help with playercap.php in fluxcp

[Yonko]

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in/home5/**********/public_html/**************/themes/designno2/gthemes/playerCap.phpon line 17

Access denied for user 'root'@'localhost' (using password: YES)

why i get those? i set the theme -> designno2 by Gerome

[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>