Points not updating

[Jedzkie 58]

hi again! i 'm gonna ask something about my problem, i use #VOTEPOINTS in my server and converts it to "cp_credits" in my sql,

 

but my problem is it does not add 1 point in sql but i already converted it in npc, it works when 1 have a 1 point, but it dont work if i dont have points, here's my query_sql script

 

 

query_sql "UPDATE `cp_credits` SET `balance` = `balance` +1 " WHERE `account_id` = " + getcharid(3) + " AND `balance` <> 0;";

[mleo1 36]

remove this
 

+ " AND `balance` <> 0;" 

[Jedzkie 58]

i already removed, but still nothing happens.

[mleo1 36]

i already removed, but still nothing happens.

 

I thought null+1=1, wrong moves then

 

 

try

query_sql "UPDATE `cp_credits` SET `balance`=IF(`balance` IS NULL,1,`balance`+1) WHERE `account_id`="+getcharid(3);

or

query_sql "UPDATE `cp_credits` SET `balance`=COALESCE(`balance`+1,1) WHERE `account_id`="+getcharid(3);

Edited July 25, 2013 by mleo1