Breaker Ladder

[integral]

Hello there, could you please help me with this problem?

I'm using this script, here(thank you for the script). Though I removed the prizes(sorry, I'm not sure if modifying it is allowed). But the problem is, even if it runs perfectly well on my lan server, when I tried it on my hosted server, the npc does not store any values in phpmyadmin.

Here's the modified script that I'm using.

prontera,148,166,5	script	Breaker Ladder	864,{



query_sql "SELECT `char`.char_id,`char`.`name`,global_reg_value.`value` FROM global_reg_value LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id WHERE global_reg_value.str='brokeemp' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 10", .@char_id, .@name$, .@count;



mes "[ ^00FF00 Breaker Ladder ^000000 ]";
mes "Hello there "+strcharinfo(0)+", what do you want to do?";
menu "View Breaker Ladder",-,"Nothing",Lno;
next;

next;
for( set .@x,0; .@x<=9; set .@x,.@x+1 )
{
	mes "^0000FF"+(.@x+1)+".^000000 "+.@name$[.@x]+" - ^FF0000"+.@count[.@x]+"^000000 Point(s)";
} // .@x starts at 0, but you want to start with '1st', so use (.@x+1)
close;


Lno:
next;
mes "[ ^00FF00 Breaker Ladder ^000000 ]";
mes "Suit yourself..";
close;

}