Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Eudemons Online > EO PServer Hosting > EO PServer Guides & Releases
simple +255 gears + attire/casual +255 query simple +255 gears + attire/casual +255 query
You last visited: Today at 22:34

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

simple +255 gears + attire/casual +255 query

Discussion on simple +255 gears + attire/casual +255 query within the EO PServer Guides & Releases forum part of the EO PServer Hosting category.

Reply
 
Old   #1
 
Marcus*'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2010
Posts: 614
Received Thanks: 1,242
Smile 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

credits to MoŽtalKing for the code

==============================================

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';
Marcus* is offline  
Thanks
39 Users
Old 08/25/2011, 18:48   #2
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2011
Posts: 2
Received Thanks: 0
thanks man ..it work
akmal panther is offline  
Old 08/25/2011, 23:24   #3
 
Marcus*'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2010
Posts: 614
Received Thanks: 1,242
not a problem and this is there for a resign
Marcus* is offline  
Thanks
2 Users
Old 08/27/2011, 12:53   #4
 
MoŽtalKing's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Dec 2010
Posts: 107
Received Thanks: 84
BTW i am M.KinG so i prefer to say credit to MoŽtalKing ... and thanks for credits
MoŽtalKing is offline  
Thanks
3 Users
Old 08/29/2011, 00:23   #5
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Nov 2009
Posts: 585
Received Thanks: 151
Great Relase marcus i havent seen one that works lol
pretzel666 is offline  
Old 08/29/2011, 08:26   #6
 
Marcus*'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2010
Posts: 614
Received Thanks: 1,242
Quote:
Originally Posted by MoŽtalKing View Post
BTW i am M.KinG so i prefer to say credit to MoŽtalKing ... and thanks for credits
your welcome and changed
Marcus* is offline  
Thanks
3 Users
Old 08/29/2011, 17:16   #7
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2010
Posts: 84
Received Thanks: 2
ty
carde is offline  
Old 09/04/2011, 18:54   #8
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2011
Posts: 10
Received Thanks: 0
im new about this..
i copy all of this and paste at query.. and run it.. went i wanna close it, do i have to save that or not..?
and where do i get that gear?
luqman al-hakim is offline  
Old 09/05/2011, 06:17   #9
 
Marcus*'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2010
Posts: 614
Received Thanks: 1,242
Code:
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=[COLOR="Red"]10000001[/COLOR] and position=1;
the part in red has to be changed to the players id that your doing it on and they have to be already wearing gears for it to work
Marcus* is offline  
Thanks
2 Users
Old 09/05/2011, 07:25   #10
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2011
Posts: 10
Received Thanks: 0
i put that code in query and run it.. went it finish, it look like this=

[SQL] update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=14942921 and position=1;
Affected rows: 1
Time: 0.003ms

did it work.. because went i login.. my gear still the same..
after finish the query.. should i save that or not?

thx for reply.

im still new about this.. and i need a pro to teach me..
luqman al-hakim is offline  
Old 09/05/2011, 08:09   #11
 
Marcus*'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2010
Posts: 614
Received Thanks: 1,242
the code should work if your doing it right try saving it though it should auto save but try anyway
Marcus* is offline  
Thanks
1 User
Old 09/06/2011, 11:50   #12
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2011
Posts: 10
Received Thanks: 0
thx broo.. it work..
luqman al-hakim is offline  
Old 07/24/2014, 12:29   #13
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: May 2013
Posts: 2
Received Thanks: 0
could this be used for conquer online
promethues is offline  
Old 07/24/2014, 16:43   #14
 
hio77's Avatar
 
elite*gold: 20
The Black Market: 0/0/0
Join Date: Jun 2006
Posts: 1,759
Received Thanks: 825
Quote:
Originally Posted by promethues View Post
could this be used for conquer online
Conquer Binary servers, sure.. probably with a slight bit of modification.

although considering the alternatives for starters, i dont know why you would bother trying.


(from the conquer section..)

Quote:
TQ Binaries (Download Links) - They're considered warez (pirated software) and are very illegal to use.
so obtaining them in the first place is likely to stop you dead in your tracks with that.
hio77 is offline  
Old 03/28/2020, 15:31   #15
 
sedian's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2011
Posts: 46
Received Thanks: 6
Quote:
Originally Posted by Marcus* View Post
+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

credits to MoŽtalKing for the code

==============================================

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';
Do i need just copy and paste it into the queries?
sedian is offline  
Reply

« [RELEASE] ITEMTYPE FDB CN TO EN CONVERTOR | [Release] Open source Launcher v1 »

Similar Threads Similar Threads
T>Eudemons eps/pets/gears for Conquer Online gears/cps
05/15/2011 - Conquer Online 2 Trading - 1 Replies
On Eudemons London server i have over 10k eps worth of eudemons/gears and pets, i would like to trade that for cps/gears on conquer online on any server. Pm me if your interested, thanks :D
Selling Account + Gears + Gears & More Gears @ Snowwhite!
06/29/2010 - Conquer Online 2 Trading - 1 Replies
Server: Cinderella/Snowwhite (Tro) Gears: Sup +6 SDG/SDG -5 Ears lvl 112 (102HP) Sup +6 SDG -5 130 Necky lvl 130 (130HP) Sup +6 SDG/SDG Blade lvl 130 (142HP) Sup +6 SDG/SDG -3 Trojan Armor lvl 120 (130HP) GoodLuck -1 Sup +6 SDG/SDG -5 Sword lvl 130 (225HP) Sup +6 SGG/SGG -1 Fan
Trading Tro-water acc pretty good gears for a tro with same gears or close
07/25/2009 - Conquer Online 2 - 1 Replies
Trading tro-water acc with +3 super tro armor super +3 1 soc club super +3 ring elite +2 boots elite +2 sword super no + necky super +2 coro super +2 super fan and a ref tower lol (lost elite one getting red) his tao gears are the following uni 1 soc tao robe super bracelet super ears uni tao backsword elite bag i will like a lv 110 or higher tro for this acc with alike tro gears this is a real old acc had it for a long time i know someone whats it sry if this wrong place to post
sell arch gears _trojan gears for real money
06/18/2009 - Conquer Online 2 - 2 Replies
Sell super arch coat +4 sdg L107 super 2sock +5 2sdg boot L110 super 1sdg +6 L110 Ring sup 1sdg +5 L97 ears sup +5 1sdg L97 neacky sup +4 2sdg L120 bow sup +4 1sdg tro armor 50% por Sup +4 tower 34% por M goard 1000hp+1000M iam from egypt send message to me if u wanna buy



All times are GMT +2. The time now is 22:34.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.