Query to Make All Spells No-Drop

Mariomario · #6 08-08-2013, 08:08 PM

Code:

SELECT items.id,items.name FROM items,spells_new WHERE items.scrolleffect = spells_new.id;

This should show you all spells that are connected with each other. In order to scribe a spell it needs a 'scrolleffect' id which is the same id as the spell in the spells_new table. This selects a common ground between both tables.

Code:

UPDATE items,spells_new SET items.nodrop = 0 WHERE items.scrolleffect = spells_new.id;

This should switch all those items you found with the first query to being no drop. It should alter every spell/song/tome obtainable.