Add items to NPC

[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.