• 0
Sign in to follow this  
Zycron

Fluxcp no errors but not working

Question

Posted (edited)

So Im trying to get a website up everything is fine cept the pvp ranking add-on no errors just not showing any results here are some examples 

Flux Control Panel_ Character Ranking - Google Chrome 5_14_2018 12_58_12 PM.png

Flux Control Panel_ Character Ranking - Google Chrome 5_14_2018 12_58_19 PM.png

Mine_ragnarok_main_pvpladder_ - HeidiSQL 9.1.0.4867 5_14_2018 12_58_44 PM.png

Using geromes pvp ladder from his svn

Here is php for module and theme . 

(module)pvpranking.php

(theme)pvpranking.php

Edited by Zycron

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0
Posted (edited)

Update this part of pvpranking.php on module

$col  = "ch.char_id, ch.name AS char_name, ch.class AS char_class, ch.base_level, ch.base_exp, ch.job_level, ch.job_exp, pl.kills, pl.deaths, pl.streaks,";
$col .= "ch.guild_id, guild.name AS guild_name, guild.emblem_len AS guild_emblem_len";

$sql  = "SELECT $col FROM {$server->charMapDatabase}.`char` AS ch ";
$sql .= "LEFT JOIN {$server->charMapDatabase}.guild ON guild.guild_id = ch.guild_id ";
$sql .= "LEFT JOIN {$server->loginDatabase}.login ON login.account_id = ch.account_id ";
$sql .= "LEFT JOIN {$server->charMapDatabase}.pvpladder AS pl ON pl.char_id = ch.char_id ";
$sql .= "WHERE 1=1 ";

 

Edited by Aries

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
Sign in to follow this