Get Rank from Database

[flawed]

Hey Guys.

I need a plugin that gets the rank/place of the player in the database.
Example:
Mr_Mocraft: 1700 Kills => #3
Ms_Exmple: 2500 Kills => #1
He_Choppp: 1900 Kills => #2

I don't need a plugin that shows the best players. I need a plugin that shows the players his rank. When Mr_Mocraft joins he should see in a hologram (or you do that with PlaceholderAPI) his rank (=> #3)

Important:
I already have a sql "command" with this function that works perfectly in phpmyadmin.
It returns the place in the table.

select rank
from
(
    select player_name, @rank := @rank + 1 as rank
    from kitbattle_
    cross join (select @rank := 0) r
    order by Kills desc
) tmp
where player_name = 'ThePlayer'

 

[SurplexedMC]

Hello!

I am currently one of the sales representatives from Minecript
and I saw that you were looking for a Plugin!

We at Minecript have the needed individuals with the necessary skills that are needed to help you with all your needs regarding graphics, plugin development, building, web design, system administration, etc...

Although I do not have a quote for you at this time for this Plugin!, I will be able to contact the rest of our team at Minecript to get the estimated prices for it, as well as to see if there is anyone to take your request.

Best regards, Surplexed
Minecript Sales Representative

Please Contact me on Discord Surplexed#7200

- Minecript Links -
Visit our website @ https://minecript.com/
Join our community @ https://discord.minecript.com/
Follow us on Twitter @ https://twitter.com/minecriptae