simple +255 gears + attire/casual +255 query

+255 gears & attire/casual +255 query

Code:
-- ----------------------------
-- +255 With elements equipments
-- ----------------------------



update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=1;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=2;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=3;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=4;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=7;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=8;

update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=1;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=2;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=3;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=4;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=7;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=8;

update cq_item set type ='1020260' where type=813002;

-- ----------------------------
-- Script End
-- ----------------------------

-- --------------------------------------------
-- For Casual +255 ( with full +255 element ---
-- Script Start --
-- --------------------------------------------

update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=12;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=12;

-- ----------------------------
-- Script End
-- ----------------------------


Info

Position=12 @= Casual currently wearing by char.
player_id = change the player id u want to upgrade the items ( can be found in cq_user under ID coloum )
TO set player/maker name = change forgename to any user u want

ident = 4 @ make the item indestructable

Here is the list of Gem id's
18 = super amber
21 = super citrine
24 = super beryl
30 = super sapphire
27 = super amethyst
255 = empty sockets
0 = no sockets at all

To change F-Soul (warghostexp) here are some examples,,
1536 = +9
1024 = +8
512 = +4
256 = +2

2nd simple code credits Eurion

Code:
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.

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';v