+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Off-Topic (The Outer World) (https://lckb.dev/forum/forumdisplay.php?fid=198)
+---- Forum: General Discussion (https://lckb.dev/forum/forumdisplay.php?fid=147)
+---- Thread: Add items to NPC (/showthread.php?tid=338)
- paulokow - 11-06-2011
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 - 11-06-2011
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 - 11-06-2011
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 - 11-07-2011
could you make a video tut pls
- damona - 11-07-2011
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 - 11-07-2011
Why when i want to add items in NPC cube, i cant but them ?
- damona - 11-08-2011
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 - 11-08-2011
How can i have the database ?
- damona - 11-08-2011
you must edit the t_shopitem files
and you must make in the database the same items as in the client- DeadlyHitrate - 11-15-2011
this is what i get when i open shopall with lc developer studio why?
[ATTACH=CONFIG]489[/ATTACH]