[QUESTION]How to change some equipments?

[jamban012]

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?

[SoulNecturn]

Originally Posted by jamban012

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

[jamban012]

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

[SoulNecturn]

Originally Posted by jamban012

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

[jamban012]

ty man...
you very good person

[jamban012]

deadpool pls closed this thread...question have been answered

[.Ash]

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

[jamban012]

where i can get char id?
char id from cq_user?

And it says you have sql syntax error at line 1

[SoulNecturn]

Originally Posted by SpongeBox

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:

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

[jamban012]

man...where i can get char id?

[jamban012]

sorry for double posting...
in cq_user

[SoulNecturn]

Originally Posted by jamban012

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

[.Ash]

Originally Posted by jamban012

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]

Originally Posted by Soulerman

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:

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

[CrimsonHaze]

Originally Posted by jamban012

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