+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: Ep1 Guides (https://lckb.dev/forum/forumdisplay.php?fid=178)
+----- Thread: [FIX] Merchant Geres Item Fix (/showthread.php?tid=173)
Pages:
1
2
- METH - 09-16-2011
Issue : Couldnt buy following items from Geres and other NPCS
FIX:
Fix all items + Add Stone of the Wise , Superior Remedy, Advanced True Sight and Advanced Stone cure
UPDATE `newproject_data`.`t_shopitem` SET `a_national` = 4;
INSERT INTO `newproject_data`.`t_shopitem` (`a_keeper_idx`, `a_item_idx`, `a_national`) VALUES (226, 3763, 4);
INSERT INTO `newproject_data`.`t_shopitem` (`a_keeper_idx`, `a_item_idx`, `a_national`) VALUES (226, 2899, 4);
INSERT INTO `newproject_data`.`t_shopitem` (`a_keeper_idx`, `a_item_idx`, `a_national`) VALUES (226, 3579, 4);
INSERT INTO `newproject_data`.`t_shopitem` (`a_keeper_idx`, `a_item_idx`, `a_national`) VALUES (226, 3582, 4);
- DeadlyHitrate - 10-30-2011
where do i place this?
- Koko - 10-30-2011
Put each line one by one in the sql tab of newproject_data table
- DeadlyHitrate - 10-30-2011
can u make a screen where pls ?
- METH - 10-31-2011
Find the button that says QUERY and copy and paste it
- MonarC - 10-31-2011
Why i cant buy item-cash at geres in my own ep1 ? how can i fix it ?
- balkia1 - 11-03-2011
Can someone make a tutorial so every1 can see how to add the fix? because i dont know it and it dont work -.-
- METH - 11-03-2011
Its an SQL query and it does work if u restart your server
- Warmonger - 11-04-2011
Can someone make a tutorial so every1 can see how to add the fix? because i dont know it and it dont work -.-
Because this fix is garbage, there is no need to update the entire table to make the NPC sell a few missing items. Use mine below instead.
DELETE FROM t_shopitem WHERE a_keeper_idx = 20;
# Pick Axe
INSERT INTO t_shopitem VALUES (20, 194, 0);
INSERT INTO t_shopitem VALUES (20, 254, 0);
INSERT INTO t_shopitem VALUES (20, 255, 0);
# Energy Collector
INSERT INTO t_shopitem VALUES (20, 265, 0);
INSERT INTO t_shopitem VALUES (20, 264, 0);
INSERT INTO t_shopitem VALUES (20, 196, 0);
INSERT INTO t_shopitem VALUES (20, 261, 0);
INSERT INTO t_shopitem VALUES (20, 262, 0);
INSERT INTO t_shopitem VALUES (20, 263, 0);
# Knife
INSERT INTO t_shopitem VALUES (20, 260, 0);
INSERT INTO t_shopitem VALUES (20, 259, 0);
INSERT INTO t_shopitem VALUES (20, 258, 0);
INSERT INTO t_shopitem VALUES (20, 257, 0);
INSERT INTO t_shopitem VALUES (20, 256, 0);
INSERT INTO t_shopitem VALUES (20, 195, 0);
# Combination Box
INSERT INTO t_shopitem VALUES (20, 395, 0);
# Power Box
INSERT INTO t_shopitem VALUES (20, 497, 0);
# Healing Potion Manuals
INSERT INTO t_shopitem VALUES (20, 488, 0);
INSERT INTO t_shopitem VALUES (20, 489, 0);
# Bloodseal And Purification Gem
INSERT INTO t_shopitem VALUES (20, 284, 0);
INSERT INTO t_shopitem VALUES (20, 285, 0);
# Potions
INSERT INTO t_shopitem VALUES (20, 43, 0);
INSERT INTO t_shopitem VALUES (20, 44, 0);
INSERT INTO t_shopitem VALUES (20, 45, 0);
INSERT INTO t_shopitem VALUES (20, 484, 0);
# Remedy
INSERT INTO t_shopitem VALUES (20, 457, 0);
# Haste
INSERT INTO t_shopitem VALUES (20, 391, 0);
# Moonstone Boxs
INSERT INTO t_shopitem VALUES (20, 2552, 0);
INSERT INTO t_shopitem VALUES (20, 2553, 0);
INSERT INTO t_shopitem VALUES (20, 2554, 0);
INSERT INTO t_shopitem VALUES (20, 2555, 0);
- balkia1 - 11-04-2011
At where must i put it in?