Good Quries

[-+Sezzy+-]

Hey guys i was wondering if there were any other quirys out there like the plus 255 one that i could use as a donation?
I need the legion all totems one :P

[redburn89]

use this for +255 Donation item 1set.
this query for +255 full element +255 f-soul level 9
(Please Change that playerid and playername)

 Spoiler

update cq_item set eudemon_attack1=255 where player_id=PlayerID and position=1;
update cq_item set eudemon_attack1=255 where player_id=PlayerID and position=2;
update cq_item set eudemon_attack1=255 where player_id=PlayerID and position=3;
update cq_item set eudemon_attack1=255 where player_id=PlayerID and position=4;
update cq_item set eudemon_attack1=255 where player_id=PlayerID and position=7;
update cq_item set eudemon_attack1=255 where player_id=PlayerID and position=8;
update cq_item set eudemon_attack2=255 where player_id=PlayerID and position=1;
update cq_item set eudemon_attack2=255 where player_id=PlayerID and position=2;
update cq_item set eudemon_attack2=255 where player_id=PlayerID and position=3;
update cq_item set eudemon_attack2=255 where player_id=PlayerID and position=4;
update cq_item set eudemon_attack2=255 where player_id=PlayerID and position=7;
update cq_item set eudemon_attack2=255 where player_id=PlayerID and position=8;
update cq_item set eudemon_attack3=255 where player_id=PlayerID and position=1;
update cq_item set eudemon_attack3=255 where player_id=PlayerID and position=2;
update cq_item set eudemon_attack3=255 where player_id=PlayerID and position=3;
update cq_item set eudemon_attack3=255 where player_id=PlayerID and position=4;
update cq_item set eudemon_attack3=255 where player_id=PlayerID and position=7;
update cq_item set eudemon_attack3=255 where player_id=PlayerID and position=8;
update cq_item set eudemon_attack4=255 where player_id=PlayerID and position=1;
update cq_item set eudemon_attack4=255 where player_id=PlayerID and position=2;
update cq_item set eudemon_attack4=255 where player_id=PlayerID and position=3;
update cq_item set eudemon_attack4=255 where player_id=PlayerID and position=4;
update cq_item set eudemon_attack4=255 where player_id=PlayerID and position=7;
update cq_item set eudemon_attack4=255 where player_id=PlayerID and position=8;
update cq_item set special_effect=255 where player_id=PlayerID and position=1;
update cq_item set special_effect=255 where player_id=PlayerID and position=2;
update cq_item set special_effect=255 where player_id=PlayerID and position=3;
update cq_item set special_effect=255 where player_id=PlayerID and position=4;
update cq_item set special_effect=255 where player_id=PlayerID and position=7;
update cq_item set special_effect=255 where player_id=PlayerID and position=8;
update cq_item set magic3=255 where player_id=PlayerID and position=1;
update cq_item set magic3=255 where player_id=PlayerID and position=2;
update cq_item set magic3=255 where player_id=PlayerID and position=3;
update cq_item set magic3=255 where player_id=PlayerID and position=4;
update cq_item set magic3=255 where player_id=PlayerID and position=7;
update cq_item set magic3=255 where player_id=PlayerID and position=8;
update cq_item set amount=28800 where player_id=PlayerID and position=1;
update cq_item set amount_limit=28800 where player_id=PlayerID and position=1;
update cq_item set amount=28800 where player_id=PlayerID and position=2;
update cq_item set amount_limit=28800 where player_id=PlayerID and position=2;
update cq_item set amount=28800 where player_id=PlayerID and position=3;
update cq_item set amount_limit=28800 where player_id=PlayerID and position=3;
update cq_item set amount=28800 where player_id=PlayerID and position=4;
update cq_item set amount_limit=28800 where player_id=PlayerID and position=4;
update cq_item set amount=28800 where player_id=PlayerID and position=7;
update cq_item set amount_limit=28800 where player_id=PlayerID and position=7;
update cq_item set amount=28800 where player_id=PlayerID and position=8;
update cq_item set amount_limit=28800 where player_id=PlayerID and position=8;
update cq_item set gem1=18 where player_id=PlayerID and position=1;
update cq_item set gem2=18 where player_id=PlayerID and position=1;
update cq_item set gem1=18 where player_id=PlayerID and position=2;
update cq_item set gem2=18 where player_id=PlayerID and position=2;
update cq_item set gem1=18 where player_id=PlayerID and position=3;
update cq_item set gem2=18 where player_id=PlayerID and position=3;
update cq_item set gem1=18 where player_id=PlayerID and position=4;
update cq_item set gem2=18 where player_id=PlayerID and position=4;
update cq_item set gem1=18 where player_id=PlayerID and position=7;
update cq_item set gem2=18 where player_id=PlayerID and position=7;
update cq_item set gem1=18 where player_id=PlayerID and position=8;
update cq_item set gem2=18 where player_id=PlayerID and position=8;
update cq_item set warghostexp=1536 where player_id=PlayerID and position=1;
update cq_item set warghostexp=1536 where player_id=PlayerID and position=2;
update cq_item set warghostexp=1536 where player_id=PlayerID and position=3;
update cq_item set warghostexp=1536 where player_id=PlayerID and position=4;
update cq_item set warghostexp=1536 where player_id=PlayerID and position=7;
update cq_item set warghostexp=1536 where player_id=PlayerID and position=8;
update cq_item set forgename='PlayerName' where player_id=PlayerID and position=1;
update cq_item set forgename='PlayerName' where player_id=PlayerID and position=2;
update cq_item set forgename='PlayerName' where player_id=PlayerID and position=3;
update cq_item set forgename='PlayerName' where player_id=PlayerID and position=4;
update cq_item set forgename='PlayerName' where player_id=PlayerID and position=7;
update cq_item set forgename='PlayerName' where player_id=PlayerID and position=8;

[-+Sezzy+-]

thats the only one i have LO thx anywayz