plus 255 wepaons

11/26/2010 01:24 -+Sezzy+-#1
hey guys i lost the query for the 255 weps and 255 elem can somone give me it?
11/26/2010 01:32 M.KinG#2
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
11/26/2010 01:40 -+Sezzy+-#3
love u thanks
11/26/2010 01:43 keithbell17#4
well instead of making a thread why dont you use the search function...