<?php
header("Content-Type: content=text/html; charset=cp1251");
######
# Конфиг
######
$realm_name[1] = ''; //Название сервера
$dbip[1] = ''; //ip бд
$dblogin[1] = ''; // логин бд
$dbpass[1] = ''; // пароль бд
$cdb_name[1] = '';
$referesh_delay = 5;
$num_realms = 1;
######
$servers = file("./online.txt");
for($i=1;$i<=$num_realms;$i++){
$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()+$referesh_delay;
$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];
}
echo "Орда:".$online['horde'][$i]." Альянс:".$online['allnc'][$i]." Всего:".$online['all'][$i];
}
if($last_state[2] < time()){
@file_put_contents("./online.txt", $servers_file);
}
?>