about ladder board & query_sql

[cahadeyelo]

my ladder board keeps getting error about char_reg_num....here's my script

function	script	BREAKER	{
	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='BREAKER' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 10", .@char_id, .@name$, .@count;

	mes "[ Breaker Ladder ]";
	for( set .@x,0; .@x<=9; set .@x,.@x+1 ) {
	mes "^0000FF"+(.@x+1)+".^000000 "+.@name$[.@x]+" - ^FF0000"+.@count[.@x]+"^000000 Point(s)";
	}
	close;
}

[Technoken]

replace all global_reg_value with char_reg_num

 

it was changed since the Script Engine Upgrade update

[cahadeyelo]

my ladder board keeps getting error about char_reg_num....here's my script

function	script	BREAKER	{
	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='BREAKER' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 10", .@char_id, .@name$, .@count;

	mes "[ Breaker Ladder ]";
	for( set .@x,0; .@x<=9; set .@x,.@x+1 ) {
	mes "^0000FF"+(.@x+1)+".^000000 "+.@name$[.@x]+" - ^FF0000"+.@count[.@x]+"^000000 Point(s)";
	}
	close;
}