LOL that was odd :/Quote:
Firstly this question to Soulerman :D...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?
Like I wrote...Quote:
but i still cant find how to add at outfit for an example for PinkRomance
Quote:
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..
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;
where you can get id from cq_user is the question???? :)Quote:
in cq_user
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.Quote:
Quote:
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:
then yes this might work as you described ;)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;
Regards
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 pleaseQuote: