EQEmulator Forums - Query to Make All Spells No-Drop

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - Query to Make All Spells No-Drop (https://www.eqemulator.org/forums/showthread.php?t=37154)

zerjz3

08-07-2013 02:27 PM

Query to Make All Spells No-Drop

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

08-07-2013 03:00 PM

Here you go.

Code:

UPDATE items SET nodrop = 0 WHERE `name` like "Spell:%";

zerjz3

08-07-2013 03:01 PM

Thanks so much Kingly.

rencro

08-07-2013 03:08 PM

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

Drajor

08-08-2013 03:20 AM

WHERE itemtype = 20;

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

Mariomario

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.

rabbired1

03-02-2014 02:06 AM

is good .... make....

All times are GMT -4. The time now is 09:01 PM.