<?php
   header("Content-Type: content=text/html; charset=cp1251");
require"./connect.php";
function uptime_t($realm){
   if($GLOBALS['realm_version'][$realm] == 'tbc'){
    $time = mysql_result(mysql_query("SELECT max(starttime) FROM `".$GLOBALS['wdb_name'][$realm]."`.`uptime` WHERE realmid = ".$realm." LIMIT 1", $GLOBALS['Connectdb'][$realm]), 0);
   }else{
    $time = mysql_result(mysql_query("SELECT max(starttime) FROM `".$GLOBALS['rdb_name'][1]."`.`uptime` WHERE realmid = ".$realm." LIMIT 1", $GLOBALS['Connectdb'][1]), 0);
   }
   $uptime = time() - $time;
    $uptime_sec = $uptime%60;
    $uptime = intval($uptime/60);
    $uptime_min = $uptime%60;
    $uptime = intval($uptime/60);
    $uptime_hours = $uptime%24;
    $uptime = intval($uptime/24);    
    $uptime_days = $uptime;
    if($uptime_days > 0){
     $return .= $uptime_days." д. ";
    }if($uptime_hours > 0){
     $return .= $uptime_hours." ч. ";
    }if($uptime_min > 0){
     $return .= $uptime_min." м. ";
    }if($uptime_sec > 0){
     $return .= $uptime_sec." c.";
    }
    return $return;
}

for($i=1;$i<=$num_got_realms;$i++){
$servers = file("./modules/onlinebar/online.txt");
$serv_num = $i-1;
$last_state = explode(",", $servers[$serv_num]);
if($last_state[2] < time()){
$online['all'][$i] = @mysql_result(@mysql_query("SELECT count(guid) FROM `".$cdb_name[$i]."`.`characters` WHERE online = 1", $Connectdb[$i]), 0);
$online['horde'][$i] = @mysql_result(@mysql_query("SELECT count(guid) FROM `".$cdb_name[$i]."`.`characters` WHERE online=1 and race in (2,5,6,8,10,9)", $Connectdb[$i]), 0);
$online['allnc'][$i] = $online['all'][$i]-$online['horde'][$i];
$realmname[$i] = $realm_name[$i];
$time = time()+10;
$servers_file .= $online['allnc'][$i].",".$online['horde'][$i].",".$time.",".$realm_name[$i]."\n";
}else{
$online['horde'][$i] = $last_state[1];
$online['allnc'][$i] = $last_state[0];
$online['all'][$i] = $online['horde'][$i]+$online['allnc'][$i];
$realmname[$i] = $last_state[3];
}
if($online['all'][$i] == 0){
$online['horde'][$i] = 0;
   $aper=50;
   $hper=50;
}else{
$aper = @floor($online['allnc'][$i] * 100 / $online['all'][$i]);
$hper = 100 - $aper;
}
if($realm_active[$i] == 1){
echo '<table border=0><tr><td align=\"center\">
<b>'.$realmname[$i].'</b> </td><td  align=\"center\"> '.uptime_t($realmid[$i]).'</td></tr></table><table border="0" cellpadding="0" cellspacing="0" align="center" width="200px" height="37px">
      <tr>
        <td>
          <img src="images/allnc.png" />
        </td>
        <td style="padding-bottom:3px;width:' . $aper . '%;background:url(images/allnc_bg.png);text-align:center">
          <font style="color:#fff;font-size:10px">' . $online['allnc'][$i] . '</font>
        </td>
        <td style="padding-bottom:3px;width:' . $hper . '%;background:url(images/horde_bg.png);text-align:center">
          <font style="color:#fff;font-size:10px">' . $online['horde'][$i] . '</font>
        </td>
        <td>
          <img src="images/horde.png" />
        </td>
      </tr>
    </table>';
}
else{
echo"Игровой мир ".$realmname[$i]." выключен<br />";
}}
if($last_state[2] < time()){
@file_put_contents("./modules/onlinebar/online.txt", $servers_file);
}
?>

<?php
$conf = array(
         'host' => 'localhost',   // хост mysql
         'user' => 'root',        // пользователь mysql
         'pass' => 'root',        // пароль mysql
         'port' => '3306',        // порт mysql
         'ench' => 'utf8',        // кодировка
         'char' => 'characters',  // база персонажей
         'shst' => 'ТУТ ТВОЙ АЙПИ',   // хост сервера мира
         'wrld' => '8085',        // порт сервера мира
         'widt' => '210'          // ширина полосы (в пикселях)