delubyos

open your playerCap.php and replace with this <?php $host = 'localhost'; $username = 'root'; // Mysql Username $password = 'root'; // Mysql Pass $db = 'ragnarok_database'; // Database name $link = mysql_connect($host, $username, $password) or die(mysql_error()); @mysql_select_db($db,$link); // Characters. $sql = "SELECT COUNT(`char`.char_id) AS total FROM {$server->charMapDatabase}.`char` "; if (Flux::config('HideTempBannedStats')) { $sql .= "LEFT JOIN {$server->loginDatabase}.login ON login.account_id = `char`.account_id "; $sql .= "WHERE login.unban_time <= UNIX_TIMESTAMP()"; } if (Flux::config('HidePermBannedStats')) { if (Flux::config('HideTempBannedStats')) { $sql .= " AND login.state != 5"; } else { $sql .= "LEFT JOIN {$server->loginDatabase}.login ON login.account_id = `char`.account_id "; $sql .= "WHERE login.state != 5"; } } $result = mysql_query($sql,$link); mysql_close($link); $arr = mysql_fetch_array($result); $player_cap = $arr['total']; ?> <p id="playerCap"><?php echo $player_cap; ?></p>