первое Quote
$host ="localhost"; // IP сервера
$user ="root"; // логин mysql
$password ="root"; // пароль mysql
$wdb ="world"; // название базы world
$rdb ="realmd"; // название базы realmd
$cdb ="characters"; // название базы characters
mysql_connect($host, $user, $password) or die ("Can't connect with $host");
mysql_selectdb ("$cdb");
$online = mysql_query ("select count(*) from characters where online = 1");
$online = mysql_result ($online,0);
mysql_selectdb ("$wdb");
$max = mysql_query ("select max(`maxplayers`) from uptime");
$max = mysql_result ($max,0);
echo "Online: $online
";
echo "Max: $max";
?>
2
Кол-во игроков онлайн, орды онлайн, альянса онлайн, максимальный онлайн
Quote
mysql_selectdb ("$cdb");
$online = mysql_query ("select count(*) from characters where online = 1");
$online = mysql_result ($online,0);
$allianceonline = mysql_query ("select count(*) from characters where online = 1 and race in (1,3,4,7,11)");
$allianceonline = mysql_result ($allianceonline,0);
$hordeonline = mysql_query ("select count(*) from characters where online = 1 and race in (2,5,6,8,10)");
$hordeonline = mysql_result ($hordeonline,0);
mysql_selectdb ("$rdb");
$max = mysql_query ("select max(`maxplayers`) from uptime");
$max = mysql_result ($max,0);
echo "Игроков Онлайн: $online
";
echo "Альянса Онлайн: $allianceonline
";
echo "Орды Онлайн: $hordeonline
";
echo "Максимальный Онлайн: $max
";
?>
вот еще пару скриптов
Кол-во аккаунтов, персонажей, орды, альянса, гильди
Quote
mysql_selectdb ($rdb);
$acc = mysql_query ("select count(*) from account");
$acc = mysql_result ($acc,0);
mysql_selectdb ("$cdb");
$char = mysql_query ("select count(*) from characters");
$char = mysql_result ($char,0);
$alliance = mysql_query ("select count(*) from characters where race in (1,3,4,7,11)");
$alliance = mysql_result ($alliance,0);
$horde = mysql_query ("select count(*) from characters where race in (2,5,6,8,10)");
$horde = mysql_result ($horde,0);
$guild = mysql_query ("select count(*) from guild");
$guild = mysql_result ($guild,0);
echo "Аккаунтов: $acc
";
echo "Персонажей: $char
";
echo "Альянса: $alliance
";
echo "Орды: $horde
";
echo "Гильдий: $guild
";
?>
