Top 10 most #pvppoints

[foenne524]

I have a pvp system where every kill gives #pvppoint instead of cash points. This would be the basis of my pvp ladder.

Are there any scripts there that would show the top 10 players who has the most pvp points? tried to check mvp ladders but to no avail

[Poring King]

17 minutes ago, foenne524 said:

I have a pvp system where every kill gives #pvppoint instead of cash points. This would be the basis of my pvp ladder.

Are there any scripts there that would show the top 10 players who has the most pvp points? tried to check mvp ladders but to no avail

Spoiler

https://rathena.org/board/topic/84798-stolaos-pvp-ladder-v31a/

 

[foenne524]

39 minutes ago, Poring King said:

  Reveal hidden contents

https://rathena.org/board/topic/84798-stolaos-pvp-ladder-v31a/

 

Thank you for that. is it possible that this query shows most #pvppoints instead of kills and death? i know there isn't much of a difference on both it's just that im using ghost pvp ladder and it uses KDR. i'm planning to add another npc that shows most #pvppoints

 

Spoiler

query_sql("SELECT `char_reg_num`.`value`,`char`.`name`,`char`.`char_id` FROM `char` INNER JOIN `char_reg_num` ON `char_reg_num`.`char_id`=`char`.`char_id` WHERE `char_reg_num`.`key`='" + .@key$ + "' ORDER BY `char_reg_num`.`value` DESC LIMIT 10",.@value,.@name$,.@cid);
            if(!(.Options&256)){
                for(.@i = 0; .@i < getarraysize(.@cid); .@i++) {
                    if(.@i == 2){
                        if(.Options&128)
                            .@key$ = "m_dthcount";
                        else    .@key$ = "pl_dthcount";

 

Edited August 14, 2020 by foenne524