[Question sql&var] Upgrade number's

[Dramosith]

Hey Friends/Folks

Well i have qeustion about var/sql.

every update +100 update but.. it doenst work Keep Only 100. nothings 200 just wonder if someone can help me

query_sql("UPDATE `char` SET `pvp_exp` = 100 WHERE `char_id` = '"+getcharid(0)+"' ");

Dramosith.

[JoWei]

Try using this:

query_sql("UPDATE `char` SET `pvp_exp` = `pvp_exp`+100 WHERE `char_id` = '"+getcharid(0)+"' ");

[Dramosith]

Thanks Friend JoWei =)

it works but how about using variable(setarray)?

Edited November 5, 2012 by Dramosith

[JoWei]

I'm not quite sure what you mean by "using variable(setarray)".

Can you try to explain it more?

[Dramosith]

Aagh!, sorry sorry, my english isnt very well. but. if i want make to variable then..

setarray .PVP_EXP[0],550,200,300;
query_sql("UPDATE `char` SET `pvp_exp` = `pvp_exp`+.PVP_EXP[0] WHERE `char_id` = '"+getcharid(0)+"' ");

like that? it coud works fine? but it isnt work for me =/

Dramosith.

[JoWei]

It doesnt work because you put .PVP_EXP[0] in string.

This should work:

query_sql("UPDATE `char` SET `pvp_exp` = `pvp_exp`+"+.PVP_EXP[0]+" WHERE `char_id` = '"+getcharid(0)+"' ");

[Dramosith]

Ah Thanks so much , it works

[JoWei]

You're welcome. :3