Juruteknik Terengganu Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.


Menyelesaikan Masalah Komputer,Server Dan Gadget Anda
 
HomeJuruteknik GanuSearchLatest imagesRegisterLog in

 

 simple +255 gears + attire/casual +255 query

Go down 
AuthorMessage
touma123
[Moderator]
[Moderator]



Posts : 84
Points : 154
Terima Kasih : 7
Join date : 06/04/2012

simple +255 gears + attire/casual +255 query Empty
PostSubject: simple +255 gears + attire/casual +255 query   simple +255 gears + attire/casual +255 query Icon_minitimeTue Jun 12, 2012 3:21 pm

+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 Very Happy
Back to top Go down
 
simple +255 gears + attire/casual +255 query
Back to top 
Page 1 of 1
 Similar topics
-
» [Release]+255 gears with ambers and critines
» [HELP]NK BUAT CASUAL
» [Guide] how to add a new casual
» [Instruction] Make casual DDS
» [Instruction]Buat Casual

Permissions in this forum:You cannot reply to topics in this forum
Juruteknik Terengganu Forum :: Games :: Eudemons Online P.Server :: Tentang Server Eudemons Online :: Cara Membuat Server Eudemons Online-
Jump to: