Add items to NPC

[paulokow]

change the NPC ID and ITEM ID, then execute on newproject_data. One Item per line. Create many lines you want.

 

[color="#0000FF"]UPDATE[/color] [color="#FF0000"]`newproject_data`.`t_shopitem`[/color] [color="#0000FF"]SET[/color] `[color="#FF0000"]a_national` = 4; [/color]

[color="#0000FF"]INSERT INTO[/color] [color="#FF0000"]`newproject_data`.`t_shopitem` (`a_keeper_idx`, `a_item_idx`, `a_national`)[/color] [color="#0000FF"]VALUES[/color] [color="#FF0000"](NPC ID, ITEM ID, 4);[/color]
[color="#0000FF"]INSERT INTO[/color] [color="#FF0000"]`newproject_data`.`t_shopitem` (`a_keeper_idx`, `a_item_idx`, `a_national`)[/color] [color="#0000FF"]VALUES[/color] [color="#FF0000"](NPC ID, ITEM ID, 4);[/color]
[color="#0000FF"]INSERT INTO[/color] [color="#FF0000"]`newproject_data`.`t_shopitem` (`a_keeper_idx`, `a_item_idx`, `a_national`)[/color] [color="#0000FF"]VALUES[/color] [color="#FF0000"](NPC ID, ITEM ID, 4);[/color]

 

After this, change shopAll.lod on Data client folder with LC Developer Studio, and change the npc items you want.

 

Credits to METH.

[Koko]

Koko when i edit the shop files and i save it I cant open again this file why ?
 

I dunno, you should be able to open it again... could you tell me what did you do exactly?

[Warmonger]

change the NPC ID and ITEM ID, then execute on newproject_data. One Item per line. Create many lines you want. 

[color="#0000FF"]UPDATE[/color] [color="#FF0000"]`newproject_data`.`t_shopitem`[/color] [color="#0000FF"]SET[/color] `[color="#FF0000"]a_national` = 4; [/color]

[color="#0000FF"]INSERT INTO[/color] [color="#FF0000"]`newproject_data`.`t_shopitem` (`a_keeper_idx`, `a_item_idx`, `a_national`)[/color] [color="#0000FF"]VALUES[/color] [color="#FF0000"](NPC ID, ITEM ID, 4);[/color]
[color="#0000FF"]INSERT INTO[/color] [color="#FF0000"]`newproject_data`.`t_shopitem` (`a_keeper_idx`, `a_item_idx`, `a_national`)[/color] [color="#0000FF"]VALUES[/color] [color="#FF0000"](NPC ID, ITEM ID, 4);[/color]
[color="#0000FF"]INSERT INTO[/color] [color="#FF0000"]`newproject_data`.`t_shopitem` (`a_keeper_idx`, `a_item_idx`, `a_national`)[/color] [color="#0000FF"]VALUES[/color] [color="#FF0000"](NPC ID, ITEM ID, 4);[/color]

 

After this, change shopAll.lod on Data client folder with LC Developer Studio, and change the npc items you want.

 

Credits to METH.

 

I wouldnt change the a_national to 4. I have no problems buying them as they are. a_national is there for a reason. Not sure yet, but im sure changing the entire table will affect something later on down the line. You should just set a_national to 0 for now and it should still be buyable.

[Darquise]

could you make a video tut pls

[damona]

I dunno, you should be able to open it again... could you tell me what did you do exactly?
 

 

i open the file and make new items it work and when i open again it dont can open it again

[MonarC]

Why when i want to add items in NPC cube, i cant but them ?

[damona]

Why when i want to add items in NPC cube, i cant but them ?
 

 

you need in database

 

i cnat open agaoin the shopall when i have edit -.- i hate it

[MonarC]

How can i have the database ?

[damona]

you must edit the t_shopitem files and you must make in the database the same items as in the client

[DeadlyHitrate]

this is what i get when i open shopall with lc developer studio why?

 

[ATTACH=CONFIG]489[/ATTACH]