NPC not showing SQL Balance (SOLVED)

[rakuzas]

Hi,

I tried to make NPC to shows balance from SQL.. But each time I talk to that NPC, it keep shows 0 Points.. But my database have 7 points.. Tried almost 1 hour and keep googling around but still no luck.. Below is my sample script :

 

prontera,150,150,5	script	Sample	861,{

mes " Hi";
    if (select("Yes:No") - 1) close;
	
query_sql ("SELECT `balance` FROM `test` WHERE 'id' = 1", .BalancePoints);

mes "Your balance is "+(.BalancePoints)+"point .. ";
close;
}

 

Below is my table :

Edited December 21, 2016 by rakuzas

[Akkarin]

Try `id` instead of 'id'. Column names use ` .

[rakuzas]

1 hour ago, Akkarin said:

Try `id` instead of 'id'. Column names use ` .

Ahhh.. One small mistake.. My bad not notice that for almost a hour tried figure what's wrong.. xD

Thank you.. Now its working..

[Emistry]

you should change

.BalancePoints

to

.@BalancePoints

 

[rakuzas]

11 minutes ago, Emistry said:

you should change

.BalancePoints

to

.@BalancePoints

 

Ok.. Thank you~