PvP Ranking

[Haikenz]

Hi guys, I'd like some help from you guys who understand SQL and PHP.

I'm using Stolao's PvP, and would like to add it to my fluxcp.

In my theme uses the pvp dota (https://pastebin.com/3iphSgrr), then I would get to know how it is for the Stolao PvP

PvP Stolao: https://github.com/Stolao/Npc_Release/blob/master/PvP_Ladder/Pvp_Ladder.txt

FluxCP: 

$sqlpvp = "SELECT `pvpladder`.`kills`, `pvpladder`.`streaks`, `pvpladder`.`deaths`, `char`.`name`, `char`.`class`, `char`.`base_level`, `char`.`job_level`, `char`.`account_id`, `char`.`online`, `login`.`sex` FROM `pvpladder` LEFT JOIN `char` ON `char`.`char_id` = `pvpladder`.`char_id` LEFT JOIN `login` ON `login`.`account_id` = `char`.`account_id` WHERE `login`.`state` = '0' ORDER BY `pvpladder`.`kills` DESC, `pvpladder`.`streaks` DESC, `pvpladder`.`deaths` DESC, `char`.`base_exp` DESC LIMIT 0, 3";

 

Edited December 7, 2018 by Haikenz

[Vykimo]

Ok, so could you please explain your problem?

[Haikenz]

On 10/21/2018 at 7:30 PM, Vykimo said:

Ok, so could you please explain your problem?

Sorry I had not seen that I had replied.
So it's like I mentioned above, I'm looking forward to using the Stolao PVP and GVG Ranking. And I wanted to know how it is in the sql code of the fluxcp that I posted in the "Code"

So I wanted to know what the SQL queries of this Stolao script would look like in the FluxCP code I posted.

Edited December 7, 2018 by Haikenz