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.
Question
Guih
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.
Edited by Guih0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.