• 0
Haikenz

PvP Ranking

Question

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 by Haikenz

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
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 by Haikenz

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now