Need SQL script.

[EmuX]

Anyone able to make a script that will remove all drops with entry ID 11666 in creatureloot?

[freezer1012]

give me a sec

DELETE FROM 'creatureloot' WHERE entryid = 11666

Hope this works!

[EmuX]

Thanks! ill test it now.

[EmuX]

Dident work =(

[latruwski]

for ascent:

DELETE FROM 'creatureloot' WHERE entryid = 11666

like freezer said... what errors you get?

[EmuX]

SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax use near "creatureloot" WHERE entryid = 11666" at line 1.

[TheSpidey]

DELETE FROM creatureloot WHERE entryid=11666

Copy and paste this exact format.

[EmuX]

+rep that one worked

[latruwski]

copy paste the one freezer posted works aswell for me...
anyhow problem solved -