Dramosith Posted November 5, 2012 Group: Members Topic Count: 5 Topics Per Day: 0.00 Content Count: 62 Reputation: 2 Joined: 10/17/12 Last Seen: April 3, 2014 Share Posted November 5, 2012 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. Quote Link to comment Share on other sites More sharing options...
JoWei Posted November 5, 2012 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 117 Reputation: 18 Joined: 01/06/12 Last Seen: April 1, 2021 Share Posted November 5, 2012 Try using this: query_sql("UPDATE `char` SET `pvp_exp` = `pvp_exp`+100 WHERE `char_id` = '"+getcharid(0)+"' "); Quote Link to comment Share on other sites More sharing options...
Dramosith Posted November 5, 2012 Group: Members Topic Count: 5 Topics Per Day: 0.00 Content Count: 62 Reputation: 2 Joined: 10/17/12 Last Seen: April 3, 2014 Author Share Posted November 5, 2012 (edited) Thanks Friend JoWei =) it works but how about using variable(setarray)? Edited November 5, 2012 by Dramosith Quote Link to comment Share on other sites More sharing options...
JoWei Posted November 5, 2012 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 117 Reputation: 18 Joined: 01/06/12 Last Seen: April 1, 2021 Share Posted November 5, 2012 I'm not quite sure what you mean by "using variable(setarray)". Can you try to explain it more? Quote Link to comment Share on other sites More sharing options...
Dramosith Posted November 5, 2012 Group: Members Topic Count: 5 Topics Per Day: 0.00 Content Count: 62 Reputation: 2 Joined: 10/17/12 Last Seen: April 3, 2014 Author Share Posted November 5, 2012 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. Quote Link to comment Share on other sites More sharing options...
JoWei Posted November 5, 2012 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 117 Reputation: 18 Joined: 01/06/12 Last Seen: April 1, 2021 Share Posted November 5, 2012 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)+"' "); Quote Link to comment Share on other sites More sharing options...
Dramosith Posted November 5, 2012 Group: Members Topic Count: 5 Topics Per Day: 0.00 Content Count: 62 Reputation: 2 Joined: 10/17/12 Last Seen: April 3, 2014 Author Share Posted November 5, 2012 Ah Thanks so much , it works Quote Link to comment Share on other sites More sharing options...
JoWei Posted November 5, 2012 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 117 Reputation: 18 Joined: 01/06/12 Last Seen: April 1, 2021 Share Posted November 5, 2012 You're welcome. :3 Quote Link to comment Share on other sites More sharing options...
Question
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.
Link to comment
Share on other sites
7 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.