Classic Queries

[Furinex]

So... Im sorry for reviving this thread... But ive been trying to get the manastone back into the Evil Eye's loot list for a while and I realized that this SQL command is out of date. Is there still a way to do this? Im sure its the 47116 number but I cant seem to find the correct one for the updated SQL.

[chrsschb]

Originally Posted by Furinex

So... Im sorry for reviving this thread... But ive been trying to get the manastone back into the Evil Eye's loot list for a while and I realized that this SQL command is out of date. Is there still a way to do this? Im sure its the 47116 number but I cant seem to find the correct one for the updated SQL.

You can do it with GeorgeS' NPC Loot Editor pretty easy.

[So_1337]

Yes, sorry. It's not possible for me to edit the original post, unfortunately. This one will do it for you, though:

### This sets the Evil Eye in Guk to drop the Bag of Sewn Evil Eye 75% and Manastone 25% ###
UPDATE lootdrop_entries SET chance = 75 WHERE lootdrop_id = 18855 and item_id = 17354;
INSERT INTO lootdrop_entries VALUES (18855,13401,1,0,25);