[FIX] Merchant Geres Item Fix

[METH]

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]

where do i place this?

[Koko]

Put each line one by one in the sql tab of newproject_data table

[DeadlyHitrate]

can u make a screen where pls ?

[METH]

Find the button that says QUERY and copy and paste it

[MonarC]

Why i cant buy item-cash at geres in my own ep1 ? how can i fix it ?

[balkia1]

Can someone make a tutorial so every1 can see how to add the fix? because i dont know it and it dont work -.-

[METH]

Its an SQL query and it does work if u restart your server

[Warmonger]

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]

At where must i put it in?