Requesting +255 simpler code

06/19/2011 14:14 stedabest321#1
Ok i used to have a +255 Query code to give player that hes wearing +255

It was alot simpler then the ones i seen out there atm such as this one

Code:
update cq_item set eudemon_attack1=255 where player_id=14942916 and position=1;

update cq_item set eudemon_attack1=255 where player_id=14942916 and position=2;

update cq_item set eudemon_attack1=255 where player_id=14942916 and position=3;

update cq_item set eudemon_attack1=255 where player_id=14942916 and position=4;

update cq_item set eudemon_attack1=255 where player_id=14942916 and position=7;

update cq_item set eudemon_attack1=255 where player_id=14942916 and position=8;

update cq_item set eudemon_attack2=255 where player_id=14942916 and position=1;

update cq_item set eudemon_attack2=255 where player_id=14942916 and position=2;

update cq_item set eudemon_attack2=255 where player_id=14942916 and position=3;

update cq_item set eudemon_attack2=255 where player_id=14942916 and position=4;

update cq_item set eudemon_attack2=255 where player_id=14942916 and position=7;

update cq_item set eudemon_attack2=255 where player_id=14942916 and position=8;

update cq_item set eudemon_attack3=255 where player_id=14942916 and position=1;

update cq_item set eudemon_attack3=255 where player_id=14942916 and position=2;

update cq_item set eudemon_attack3=255 where player_id=14942916 and position=3;

update cq_item set eudemon_attack3=255 where player_id=14942916 and position=4;

update cq_item set eudemon_attack3=255 where player_id=14942916 and position=7;

update cq_item set eudemon_attack3=255 where player_id=14942916 and position=8;

update cq_item set eudemon_attack4=255 where player_id=14942916 and position=1;

update cq_item set eudemon_attack4=255 where player_id=14942916 and position=2;

update cq_item set eudemon_attack4=255 where player_id=14942916 and position=3;

update cq_item set eudemon_attack4=255 where player_id=14942916 and position=4;

update cq_item set eudemon_attack4=255 where player_id=14942916 and position=7;

update cq_item set eudemon_attack4=255 where player_id=14942916 and position=8;

update cq_item set magic3=255 where player_id=14942916 and position=1;

update cq_item set magic3=255 where player_id=14942916 and position=2;

update cq_item set magic3=255 where player_id=14942916 and position=3;

update cq_item set magic3=255 where player_id=14942916 and position=4;

update cq_item set magic3=255 where player_id=14942916 and position=7;

update cq_item set magic3=255 where player_id=14942916 and position=8;

update cq_item set special_effect=255 where player_id=14942916 and position=1;

update cq_item set special_effect=255 where player_id=14942916 and position=2;

update cq_item set special_effect=255 where player_id=14942916 and position=3;

update cq_item set special_effect=255 where player_id=14942916 and position=4;

update cq_item set special_effect=255 where player_id=14942916 and position=7;

update cq_item set special_effect=255 where player_id=14942916 and position=8;

update cq_item set magic3=255 where player_id=14942916 and position=1;

update cq_item set magic3=255 where player_id=14942916 and position=2;

update cq_item set magic3=255 where player_id=14942916 and position=3;

update cq_item set magic3=255 where player_id=14942916 and position=4;

update cq_item set magic3=255 where player_id=14942916 and position=7;

update cq_item set magic3=255 where player_id=14942916 and position=8;

update cq_item set amount=28800 where player_id=14942916 and position=1;

update cq_item set amount_limit=28800 where player_id=14942916 and position=1;

update cq_item set amount=28800 where player_id=14942916 and position=2;

update cq_item set amount_limit=28800 where player_id=14942916 and position=2;

update cq_item set amount=28800 where player_id=14942916 and position=3;

update cq_item set amount_limit=28800 where player_id=14942916 and position=3;

update cq_item set amount=28800 where player_id=14942916 and position=4;

update cq_item set amount_limit=28800 where player_id=14942916 and position=4;

update cq_item set amount=28800 where player_id=14942916 and position=7;

update cq_item set amount_limit=28800 where player_id=14942916 and position=7;

update cq_item set amount=28800 where player_id=14942916 and position=8;

update cq_item set amount_limit=28800 where player_id=14942916 and position=8;

update cq_item set gem1=18 where player_id=14942916 and position=1;

update cq_item set gem2=18 where player_id=14942916 and position=1;

update cq_item set gem1=18 where player_id=14942916 and position=2;

update cq_item set gem2=18 where player_id=14942916 and position=2;

update cq_item set gem1=18 where player_id=14942916 and position=3;

update cq_item set gem2=18 where player_id=14942916 and position=3;

update cq_item set gem1=18 where player_id=14942916 and position=4;

update cq_item set gem2=18 where player_id=14942916 and position=4;

update cq_item set gem1=18 where player_id=14942916 and position=7;

update cq_item set gem2=18 where player_id=14942916 and position=7;

update cq_item set gem1=18 where player_id=14942916 and position=8;

update cq_item set gem2=18 where player_id=14942916 and position=8;

update cq_item set warghostexp=1536 where player_id=14942916 and position=1;

update cq_item set warghostexp=1536 where player_id=14942916 and position=2;

update cq_item set warghostexp=1536 where player_id=14942916 and position=3;

update cq_item set warghostexp=1536 where player_id=14942916 and position=4;

update cq_item set warghostexp=1536 where player_id=14942916 and position=7;

update cq_item set warghostexp=1536 where player_id=14942916 and position=8;

update cq_item set warghostexp=1536 where player_id=14942916 and position=12;

update cq_item set forgename='Darthling' where player_id=14942916 and position=1;

update cq_item set forgename='Darthling' where player_id=14942916 and position=2;

update cq_item set forgename='Darthling' where player_id=14942916 and position=3;

update cq_item set forgename='Darthling' where player_id=14942916 and position=4;

update cq_item set forgename='Darthling' where player_id=14942916 and position=7;

update cq_item set forgename='Darthling' where player_id=14942916 and position=8;
Was alot smaller and easyer to use and not in such a mess, if anyone has this query please do message me it thanks :)
06/20/2011 20:50 Eurion#2
Here's a small compact version of the query. All you need to do is edit the areas and run this. It will update anything with a POSITION of 8 or less, and then the 12.


Code:
UPDATE cq_item SET amount='28800', amount_limit='28800', gem1='18', gem2='18', magic3='255', warghostexp='1536', 'eudemon_attack1='255', 'eudemon_attack2='255', 'eudemon_attack3='255', 'eudemon_attack4='255', 'special_effect='255', forgename='Darthling' WHERE player_id='14942916' AND POSITION <= 8;

UPDATE cq_item set warghostexp='1536' WHERE player_id='14942916' AND POSITION='12';