Query to Make All Spells No-Drop

[zerjz3]

Hey all,
Just wondering if anyone would be able to help me write an SQL query to make all items with the word Spell: in the name to be no drop.

Thanks!

[Kingly_Krab]

Here you go.
UPDATE items SET nodrop = 0 WHERE `name` like "Spell:%";

[zerjz3]

Thanks so much Kingly.

[rencro]

Also use 'Scroll:%' and dont remember if Songs are spells or scrolls or umm songs heh
edit : songs are 'Song:%'

[Drajor]

WHERE itemtype = 20;

20 = spells/songs item type.
May be a more accurate way of doing this.

[Mariomario]

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.

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.

[rabbired1]

is good .... make....