Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Eudemons Online > EO PServer Hosting
You last visited: Today at 04:02

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


[QUESTION]How to change some equipments?

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Aug 2008
Posts: 158
Received Thanks: 10
[QUESTION]How to change some equipments?

Firstly this question to Soulerman ...Cause he must know to do this...
Hey,
how to change equipment bonus for an example my blade is +12 so how to change it to be 255...
and how to change Outfits bonus and eudemons attack1-eudemons attack4 and add some gems?



jamban012 is offline  
Old 11/07/2009, 11:24   #2
 
elite*gold: 50
Join Date: Oct 2008
Posts: 571
Received Thanks: 1,123
Quote:
Originally Posted by jamban012 View Post
Firstly this question to Soulerman ...Cause he must know to do this...
Hey,
how to change equipment bonus for an example my blade is +12 so how to change it to be 255...
and how to change Outfits bonus and eudemons attack1-eudemons attack4 and add some gems?
LOL that was odd :/

ok - I am sure most of poeple here know HOW heh + this was already answered somewhere...

ok anyway:

go to your cq_item
locate your item that you are planing to make +255 with (255 elements and fsoul)
for example locate all items for your character ID (this ID you can find while browsing cq_user, by finding name, write down your ID).

ok under cq_item -> search items for your char ID -> chose which item you want to upgrade (by standard equipment that you are wearing have POSITION:1,2,3,4,7,8 and suit has 12).

then edit this or those items:
and under
magic3: put 255 (this is the place where your item is getting bonus +12 etc etc)
warghostexp: put 1024
eudemon_attack1: 255
eudemon_attack2: 255
eudemon_attack3: 255
eudemon_attack4: 255
eudemon_attack1 = are simply ELEMENTS
special_effect: put 8

after this save changed (confirm)
relog your character in game
and have fun with +255 (4x255 elemental) with fsoul8 and special effect item(s)...


And please - next time try to use SEARCH button since it was for sure few times described

Regards


SoulNecturn is offline  
Thanks
3 Users
Old 11/07/2009, 11:33   #3
 
elite*gold: 0
Join Date: Aug 2008
Posts: 158
Received Thanks: 10
i could find how to add eudemons attack only in search button...lol

but i still cant find how to add at outfit for an example for PinkRomance
jamban012 is offline  
Old 11/07/2009, 11:45   #4
 
elite*gold: 50
Join Date: Oct 2008
Posts: 571
Received Thanks: 1,123
Quote:
Originally Posted by jamban012 View Post
i could find how to add eudemons attack only in search button...lol

but i still cant find how to add at outfit for an example for PinkRomance
Like I wrote...

search under POSITION (if you are wearing this certain suit) or by TYPE and ID

for example
each suit, each item (lol) has OWN TYPE (that is ID under cq_itemtype), so just search for certain type for certain user.

for example:
PinkRomance has TYPE: 190540 and 190520 (male and female)

so we are:
cq_item: search for:
type: 190540
owner_id (or player_id if its under warehouse of certain player): ID of player here

then it will show you this item, rest - just edit it like on top guide

Regards


SoulNecturn is offline  
Old 11/07/2009, 11:53   #5
 
elite*gold: 0
Join Date: Aug 2008
Posts: 158
Received Thanks: 10
ty man...
you very good person
jamban012 is offline  
Old 11/07/2009, 13:37   #6
 
elite*gold: 0
Join Date: Aug 2008
Posts: 158
Received Thanks: 10
deadpool pls closed this thread...question have been answered
jamban012 is offline  
Old 11/07/2009, 13:56   #7
 
elite*gold: 0
Join Date: May 2009
Posts: 1,175
Received Thanks: 534
Or you can just run this query lol

Upgrade cq_item set gem1=18 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set gem2=18 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set magic3=255 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set warghostexp=1024 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set eudemon_attack1=255 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set eudemon_attack2=255 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set eudemon_attack3=255 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set eudemon_attack4=255 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set special_effect=255 where id= PUTYOURCHARACTERIDHERE;

if you wanna make everything +255 with f-soul 8 and 2 super ambers in them, just delete where id=PUTYOURCHARACTERID; and run it. make sure you have ";" at end. this will amke everything like that including exp ***** and clovers and stuff...

make sure you got unlimited msg sever otherwise your equips will dissapear..
.Ash is offline  
Thanks
1 User
Old 11/07/2009, 14:32   #8
 
elite*gold: 0
Join Date: Aug 2008
Posts: 158
Received Thanks: 10
where i can get char id?
char id from cq_user?

And it says you have sql syntax error at line 1
jamban012 is offline  
Old 11/07/2009, 15:55   #9
 
elite*gold: 50
Join Date: Oct 2008
Posts: 571
Received Thanks: 1,123
Quote:
Originally Posted by SpongeBox View Post
Or you can just run this query lol

Upgrade cq_item set gem1=18 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set gem2=18 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set magic3=255 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set warghostexp=1024 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set eudemon_attack1=255 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set eudemon_attack2=255 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set eudemon_attack3=255 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set eudemon_attack4=255 where id= PUTYOURCHARACTERIDHERE;
Upgrade cq_item set special_effect=255 where id= PUTYOURCHARACTERIDHERE;

if you wanna make everything +255 with f-soul 8 and 2 super ambers in them, just delete where id=PUTYOURCHARACTERID; and run it. make sure you have ";" at end. this will amke everything like that including exp balls and clovers and stuff...

make sure you got unlimited msg sever otherwise your equips will dissapear..

hehe

Yes via query as well its possible (if want to be faster...)

but this is WRONG query VERY hehe

there is no UPGRADE .... there is UPDATE

so your query most likely should look like:


Code:
Update cq_item set gem1=18 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set gem2=18 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set magic3=255 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set warghostexp=1024 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set eudemon_attack1=255 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set eudemon_attack2=255 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set eudemon_attack3=255 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set eudemon_attack4=255 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set special_effect=255 where id= PUTYOURCHARACTERIDHERE;
then yes this might work as you described

Regards
SoulNecturn is offline  
Old 11/07/2009, 16:31   #10
 
elite*gold: 0
Join Date: Aug 2008
Posts: 158
Received Thanks: 10
man...where i can get char id?
jamban012 is offline  
Old 11/07/2009, 16:31   #11
 
elite*gold: 0
Join Date: Aug 2008
Posts: 158
Received Thanks: 10
sorry for double posting...
in cq_user
jamban012 is offline  
Old 11/07/2009, 17:21   #12
 
elite*gold: 50
Join Date: Oct 2008
Posts: 571
Received Thanks: 1,123
Quote:
Originally Posted by jamban012 View Post
sorry for double posting...
in cq_user
where you can get id from cq_user is the question????

open cq_user -> put nick that you want to locate -> move little in your search result to see table field: "ID" - number inside it its your certain player ID that you need to use to locate other stuff under other tables

I hope its pretty clear now.... easier cant be said ....heh
SoulNecturn is offline  
Old 11/07/2009, 19:27   #13
 
elite*gold: 0
Join Date: May 2009
Posts: 1,175
Received Thanks: 534
Quote:
Originally Posted by jamban012 View Post
man...where i can get char id?
Hmm, Well if you got a Eudemon with a english name, and go to cq_eudemon and find your name and your pets name and go all the way to right and see player_id, thats the character id.
.Ash is offline  
Old 11/07/2009, 19:29   #14
 
elite*gold: 0
Join Date: May 2009
Posts: 1,175
Received Thanks: 534
Quote:
Originally Posted by Soulerman View Post
hehe

Yes via query as well its possible (if want to be faster...)

but this is WRONG query VERY hehe

there is no UPGRADE .... there is UPDATE

so your query most likely should look like:


Code:
Update cq_item set gem1=18 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set gem2=18 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set magic3=255 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set warghostexp=1024 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set eudemon_attack1=255 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set eudemon_attack2=255 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set eudemon_attack3=255 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set eudemon_attack4=255 where id= PUTYOURCHARACTERIDHERE;
Update cq_item set special_effect=255 where id= PUTYOURCHARACTERIDHERE;
then yes this might work as you described

Regards

Lol yeah i was about to leave to saturday school and catch my bus, so i just typed real fast.. Thanks for the correction
.Ash is offline  
Old 11/24/2009, 14:25   #15
 
elite*gold: 0
Join Date: Oct 2009
Posts: 81
Received Thanks: 32
Quote:
Originally Posted by jamban012 View Post
man...where i can get char id?
Look in your cq_user scroll over until you see the "id" lets say that number is 14471246 <-- this id is called the "Player id" in your cq_item so open your cq_item table then click on the green filter wizard button, after that click the <Click here to add button> then select "Player id" from the drop down bar next to that ensure that it says "is equal to" in black if it don't just click the black text and a drop down will appear select "is equal to" then next click the <?> button and enter the player id remember you got it from the "id" in the user table 14471246 into the window that opens hit (Enter) then control + r and poof your filter wizard will select for you all the Items in that table with a player_id equal to 14471246 so now that you have all the items for the person you want to look at up on your screen Right Click on the box that says POSITION then hover on "sort" and then select "sort ascending" if the player is wearing all his gear when he or she logged out last time all of that gear will reflect on the top 6 lines and you can edit those items as you please


CrimsonHaze is offline  
Thanks
1 User
Reply



« [HELP]all u see this.. | [Help]How to change monster texture? »

Similar Threads
[QUESTION]how to change price to change character??
07/08/2010 - EO PServer Hosting - 8 Replies
hi all..can help me?to change price to change character...:handsdown:
[ASK] Refining Equipments in PW
02/11/2010 - Perfect World - 4 Replies
can anyone tell anything we should know about refining equipments in PW, such as the success rate boost of Item Mall stones, or success rate for each + , so we understand a bit what to expect when starting to refine equipments, mostly it's like spamming the stones and getting only a plain equipments in the end, even after spent a lot of stones which cost us a lot of money or time to stockpile the needed stones. this game's equipment refining system sucks, very annoying and frustrating. So...
Mage equipments
07/28/2009 - Dekaron - 3 Replies
Hello fellas! How you doin? So, i'm here cuz i have some mage equipments doubts.... I like been more tanker than an "attacker" if u know what i mean. I guess i'm going like this at lvl 138+ Full set +7, with whatever medials i can get, i don't know if its good to use t3 +7 gloves at 130+, help me with that. About acessories i guess i'll use 3 def necks, and use the neck that u get from exchanging oblivions. But i don't if i should where staff or wand, and what gems should i put on...
Lvl equipments to 120
08/09/2007 - CO2 Main - Discussions / Questions - 8 Replies
can i lvl my lvl 115 blade and club to lvl 120 at tc using met?
question on equipments
12/02/2005 - SRO Main - Discussions / Questions - 2 Replies
How do we level up the weapon or armor from lvl 10 to the next lvl if we have a very good armor/weapon? That go for all the equipments. Thanks for the help.



All times are GMT +1. The time now is 04:02.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.