Fluxcp no errors but not working

[Zycron]

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 

Using geromes pvp ladder from his svn

Here is php for module and theme . 

(module)pvpranking.php

(theme)pvpranking.php

Edited May 14, 2018 by Zycron

[Aries]

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 June 11, 2018 by Aries