help sql V4P

[NakedWolf]

am using this script 

http://pastebin.com/raw.php?i=jwvq247A

by @Emistry

but after i receive the vote points from npc in-game am able to re vote again but i had set the vote timing is ones in 12 hours
and even the accumulated vote point on the webside docent becomes 0 after receiving the point in-game
 
this pic is after voting

after i redeem points in-game

its like this.

after i redeem the points in- game am able to vote again with out waiting 12 hours on the website if i dint redeem the points in -game i am not able to vote

 

hope some one can help me 

Edited May 15, 2017 by NakedWolf

[Emistry]

query_sql( "UPDATE `cp_votes` SET `credits` = 0 WHERE `account_id`='"+getcharid(3)+"'" );

 

Edited May 16, 2017 by Emistry

[NakedWolf]

@Emistry i changed it as you said after that. Am able to redeem the points again and again uisng the npc it docent becomes zero

and also on my console i get a Warning : incorrect use of "close: command!

 

this fixed my problem

 

query_sql( "UPDATE `cp_votes` SET `credits` = 0 WHERE `account_id`='"+getcharid(3)+"'" );

 thank you so much @Emistry

Edited May 16, 2017 by NakedWolf

[NakedWolf]

Some please help

Bump

[Ninja]

2 hours ago, NakedWolf said:

and also on my console i get a Warning : incorrect use of "close: command!

This shows up when you did not do any prior "mes" commands before closing it.

What I would suggest is to put something like 

mes "You have successfully retrieved your Vote points!";

before "close"

[NakedWolf]

1 hour ago, Ninja said:

This shows up when you did not do any prior "mes" commands before closing it.

What I would suggest is to put something like 

mes "You have successfully retrieved your Vote points!";

before "close"

that fixed the problem thank you @Ninja

[Ninja]

You are welcome. Cheers.