[HELP]New Auto thunder Script

06/17/2012 10:33 buzz2289#1

Hello all! now i have auto thunder running on my server, and im using this script:

Quote:

update cq_eudemon set item_type = item_type + 4000, damage_type = 5 where item_type < 1075999 and magic_defence > 1071999;
update cq_eudemon set item_type = item_type - 3000 where item_type > 1077000 and magic_defence > 1071999;

And i have only 1 pet that it wont work for if it goes to damage type at all it turns into the old coded pet, is there a way i can use this script and mod it to avoid id number: 2019553759,

here is the whole Table line for it:

Quote:

2019553759 0 Buzz[PM] InfernoLion 0 7585 0 2085 10483 0 6170 1607 417 0 0 0 0 0 1073500 61 3 72 10340856 15000 0 0 0 5 0 0 0 0 2525 0 2511 127 12173 4969 0 19737720 1073501 100008462 100008462 53 0 0 0 0 0

06/18/2012 00:07 no_1#2

i'm using auto thunder also but i've modified it so it works on all pets. without bugging
depends on how you are using the ids for pets.

06/18/2012 05:53 buzz2289#3

i want it to thunder all pets EXCEPT 1073500 and 1073501

06/21/2012 13:55 buzz2289#4

is there maybe a way to set it with something like : not Like itemtype 1073500;

06/22/2012 18:27 King_Arthur#5

Quote:

Originally Posted by buzz2289

is there maybe a way to set it with something like : not Like itemtype 1073500;

Don't use LIKE for this. Use "<>" which means not equals. So... UPDATE blah blah blah WHERE blah blah AND id <> 1234 blah blah

06/24/2012 15:17 buzz2289#6

So then do i just add "<> 1073501" after 1071999

like:

Quote:

update cq_eudemon set item_type = item_type + 4000, damage_type = 5 where item_type < 1075999 and magic_defence > 1071999;
update cq_eudemon set item_type = item_type - 3000 where item_type > 1077000 and magic_defence > 1071999;

I dont want it to seam like im asking you to give it to me, just trying to learn to do this right. so i can do it myself :)

06/28/2012 19:27 magewarior2#7

Code:

update cq_eudemon set item_type = item_type + 4000, damage_type = 5 where item_type < 1075999 and magic_defence > 1073510;

update cq_eudemon set item_type = item_type + 4000, damage_type = 5 where item_type < 1073499 and magic_defence > 1071999;

update cq_eudemon set item_type = item_type - 3000 where item_type > 1077000 and magic_defence > 1073510;

update cq_eudemon set item_type = item_type - 3000 where item_type > 1073499 and magic_defence > 1071999;

try this!

07/01/2012 03:46 buzz2289#8

nope made all non original 65535 orb 58K stars and all stolen and all warehouse pets gone

and i just ran my backup still the same WTH?!?!