Hi. I want the event npc to give a prize which is vote points but the problem is npc dont give me points.
here's the script
query_sql ("SELECT `points` FROM `v4p_voters_info` WHERE `accountid` = '"+getcharid(3)+"'", @vote);
set .@new, @vote +5;//
if( .@new < 0 ) // safty first..
set .@new, 0;
dispbottom "Gained Reward Points. Current Reward Points:"+.@new+"";
query_sql("UPDATE `v4p_voters_info` SET `points` = '"+.@new+"' WHERE `accountid` = '"+getcharid(3)+"'");