Hello guys!
I need help with a code for the PvP Ladder, i believe the problem is in the query_sql command.
mes "^0000FF[Rank de Vitórias no PvP]^000000";
query_sql "SELECT `char_reg_num_db`.`value`,`char`.`name` FROM `char` INNER JOIN `char_reg_num_db` ON `char_reg_num_db`.`char_id`=`char`.`char_id` WHERE `char_reg_num_db`.`key`='pvpkillcount' ORDER BY `char_reg_num_db`.`value` DESC LIMIT 25",.@value,.@name$;
for (.@i=0; .@i<getarraysize(.@value); .@i++){
mes "^0000FFClassificação: #"+(.@i+1)+"^000000: ^808000"+ .@name$[.@i] +"^000000 - ^CC6633"+ .@value[.@i] +"^000000 Morte(s)";
}
deletearray .@name$[0],10;
deletearray .@value$[0],10;
The rank is not showing, and there's no error on map console.
Is there anything wrong there?
Thanks.