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;
}