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.