[QUESTION]How to change some equipments?

[jamban012]

problem fix for long time..btw ty and i appreaciated for all post that can help me

[PraDevil[ELITE]]

Originally Posted by jamban012

man...where i can get char id?

1.go to cq_user
2.find your name
3.scroll until you see column name "id"
4.copy it then go to cq_item
5.press key Ctrl+F then paste your ID there
6.you will see your item at line where your id is highlight
7.edit whatever you like..
8.recomended use what soulerman said
9.end____________________________...

[funhacker]

select id from cq_user where name = 'INSERTNAMEHERE';

[.Ash]

is it that hard to find character id...? Lol

 Spoiler

SARCASM

[CyberServer]

well for some people maybe yes hehehe
but keep on guys make new implement here thanks

[CyberServer]

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

Anyone know i try run this query but didnt change anything lol maybe i wrong at anywhere maybe some people can guides me though

[jamban012]

you put account id or char id?

[funhacker]

Originally Posted by CyberServer

Anyone know i try run this query but didnt change anything lol maybe i wrong at anywhere maybe some people can guides me though

as long as you used the correct character ID it should of worked. But also be sure to relog or it wont take full affect until then.


Character ID = select id from cq_user where name = "insertname";

Name is case sensitive.

[CyberServer]

Update cq_item set gem1=18 where name = "insertname";
Update cq_item set gem2=18 where name = "insertname";
Update cq_item set magic3=255 where name = "insertname";
Update cq_item set warghostexp=1024 where name = "insertname";
Update cq_item set eudemon_attack1=255 where name = "insertname";
Update cq_item set eudemon_attack2=255 where name = "insertname";
Update cq_item set eudemon_attack3=255 where name = "insertname";
Update cq_item set eudemon_attack4=255 where name = "insertname";
Update cq_item set special_effect=255 where name = "insertname";

so is this correct dude..?or how?
if i am wrong fix at where i wrong....

thanks for the help anyways...

[CyberServer]

Originally Posted by jamban012

you put account id or char id?

whats the different between this?maybe someone can tell me coz yes i know i am new so need to gain s much knowledge here...

[jamban012]

id=character id..that you can update the equipments elemnts
account id= that can get at cq_user then you can refer for player account for vip lvl and more

[CyberServer]

Originally Posted by jamban012

id=character id..that you can update the equipments elemnts
account id= that can get at cq_user then you can refer for player account for vip lvl and more

so which one i need to put in the query?
so where to look charcter id?whats files in sql..?

[jamban012]

cq_user...nanti ade tab ke brape tah 10-20 kot...

[funhacker]

run this code:

select id from cq_user where name = "[b]insertname[/b]";

This will return a number for you which will be the character ID

now run soulerman's code by replacing all the parts with character id with the number you got.

[GosZ]

at cq_user ..and u find id lolz..it really simple..my nme is ahmad farhan..malaysian person..and malay people...