Ищу скрипт.
У кого есть типо такого скрипта. Выложите пожалуйста.
Статистика
Логин сервер: Online
Гейм сервер: Online
Аккаунтов: 1296
Персонажей: 5636
Онлайн: 137
Кланов: 29
Расы на сервере
Люди: 18%
Эльфы: 48%
Темные эльфы: 9%
Орки: 12%
Гномы: 13%
7 печатей
Dusk (сумрак): 0 (0%)
Dawn (рассвет): 0 (0%)
ты че гонишь чтоли ?? Братан это есть в любой обвязке готовой , че религия не позволяет из обвязки файлы взять и под себя сделать , или на крайняк уж юзануть кнопку поиск ??
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="border-tl"> </td>
<td class="border-t h-cell t-bold">Игроки в онлайне</td>
<td class="border-tr"> </td>
</tr>
<tr>
<td class="border-l"> </td>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="n-cell">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="n-cell b-b p-2 ac">
Список онлайн
</td>
</tr>
</table>
<?
mssql_connect($mssql_server,$mssql_user,$mssql_pass);
mssql_select_db($mssql_db);
$result=mssql_query("
select a.char_name, a.Lev, a.builder, a.class, a.use_time,
a.PK, a.Duel, a.gender, b.name, a.Exp, b.pledge_id
from user_data as a
left join pledge as b on a.Pledge_id=b.pledge_id
where char_name not in (".("'".join("','",$exclude_from_top)."'").") and (login>logout) and (builder>=0)");
$online_count=mssql_num_rows($result);
$result=mssql_query("
select a.char_name, a.Lev, a.builder, a.class, a.use_time,
a.PK, a.Duel, a.gender, b.name, a.Exp, b.pledge_id
from user_data as a
left join pledge as b on a.Pledge_id=b.pledge_id
where char_name not in (".("'".join("','",$exclude_from_top)."'").") and (login>logout) and (builder>=0)");
$d_count = 0;
$de_count = 0;
$e_count = 0;
$h_count = 0;
$o_count = 0;
$online_users=array();
for ($x=0;$online_users[$x]=mssql_fetch_assoc($result);$x++)
{
$hours=round($online_users[$x]['use_time']/3600,1);
$online_users[$x]['use_time_d']=floor($hours/24)." дн. ".($hours % 24)." ч.";
if ($online_users[$x]['class'] >= 0 && $online_users[$x]['class'] <= 17) $h_count++;
if ($online_users[$x]['class'] >= 18 && $online_users[$x]['class'] <= 30) $e_count++;
if ($online_users[$x]['class'] >= 31 && $online_users[$x]['class'] <= 43) $de_count++;
if ($online_users[$x]['class'] >= 44 && $online_users[$x]['class'] <= 52) $o_count++;
if ($online_users[$x]['class'] >= 53 && $online_users[$x]['class'] <= 57) $d_count++;
}
unset($online_users[count($online_users)-1]);
mssql_connect($mssql_server,$mssql_user,$mssql_pass);
mssql_select_db($CONFIG['dbdbname']) or DIE("Table unavailable");
$result=mssql_query("
select record_time, world_user
from user_count
where auth_user<>0
order by world_user desc");
$max_user=mssql_fetch_assoc($result);
$result=mssql_query("
SELECT AVG(world_user) AS avg_user
FROM user_count
WHERE (server_id = '1') AND (DATEPART(yy, record_time) = '".date("Y")."') AND (DATEPART(mm, record_time) = '".date("m")."') AND (DATEPART(dd, record_time) = '".date("d")."')");
$avg_today=mssql_fetch_assoc($result);
?>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="n-cell p-2 ac">
<table border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="al">Всего в онлайне:</td>
<td class="t-bold al info"><?php echo "$online_count" ?></td>
</tr>
<tr>
<td class="al">Среднее число игроков за сегодня:</td>
<td class="t-bold al info"><?=$avg_today["avg_user"]?></td>
</tr>
<tr>
<td class="al">Рекорд количества игроков в онлайне: </td>
<td class="t-bold al info"><?=$max_user["world_user"]?> ( <?=$max_user["record_time"]?> )</td>
</tr>
</table>
</td>
</tr>
<?=$sep?>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="n-cell p-2 ac">
<table border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="al">Темных эльфов в онлайне: </td>
<td class="t-bold al info ar"><?=$de_count?></td>
</tr>
<tr>
<td class="al">Эльфов в онлайне:</td>
<td class="t-bold al info ar"><?=$e_count?></td>
</tr>
<tr>
<td class="al">Людей в онлайне:</td>
<td class="t-bold al info ar"><?=$h_count?></td>
</tr>
<tr>
<td class="al">Орков в онлайне:</td>
<td class="t-bold al info ar"><?=$o_count?></td>
</tr>
<tr>
<td class="al">Гномов в онлайне:</td>
<td class="t-bold al info ar"><?=$d_count?></td>
</tr>
</table>
</td>
</tr>
<?=$sep?>
</table>
<table class="sort" width="100%" border="0" cellpadding="0" cellspacing="0">
<thead>
<tr>
<td class="h-cell b-tbl">Ник</td>
<td width="50" class="h-cell b-tbl">Уров.</td>
<td width="120" class="h-cell b-tbl">Класс</td>
<td width="80" class="h-cell b-tbl">Наиграно</td>
<td width="60" class="h-cell b-tbl">PvP/PK</td>
<td width="60" class="h-cell b-tbl">Опыт</td>
<td width="100" class="h-cell b-tblr">Клан</td>
</tr>
</thead>
<tbody>
<?php for($x=0;$x<count($online_users);$x++) { ?>
<tr class="n-cell">
<td style="color:<?=!$online_users[$x]["builder"]?$online_users[$x]["gender"]?$color_female:$color_male:$color_builder?>" class="b-bl p-2 al"><?=$online_users[$x]["char_name"]?></td>
<td class="b-bl p-2 ac"><?=$online_users[$x]["Lev"]?></td>
<td class="b-bl p-2 ac"><? echo '<a href=index.php?act=show_prof_info&indx='.$online_users[$x]["class"].'>'.$class_list[$online_users[$x]["class"]].'</a>';?></td>
<td class="b-bl p-2 ar"><?=$online_users[$x]["use_time_d"]?></td>
<td class="b-bl p-2 ac"><?=$online_users[$x]["Duel"]?>/<?=$online_users[$x]["PK"]?></td>
<td class="b-bl p-2 ar"><?=round($online_users[$x]["Exp"]/1000)?> K</td>
<td class="b-blr p-2 ac">
<?
if ($online_users[$x]["name"])
echo '<a href=index.php?act=show_clan_info&indx='.$online_users[$x]["pledge_id"].'>'.$online_users[$x]["name"].'</a>';
else
echo ' ';
?>
</td>
</tr>
<? }
if (count($online_count) == 0)
echo '<tr class="n-cell"><td class="b-blr p-2 ac" colspan="7">В данный момент никто не играет</td></tr>';
?>
</tbody>
</table>
</td>
</tr>
</table>
</td>
<td class="border-r"> </td>
</tr>
<tr>
<td class="border-bl"> </td>
<td class="border-b h-cell"><img src="img/line.gif"></td>
<td class="border-br"> </td>
</tr>
</table>
а тебе что выложили???
<?
mssql_connect($mssql_server,$mssql_user,$mssql_pass);
mssql_select_db($mssql_db);
$result=mssql_query("
select a.char_name, a.Lev, a.builder, a.class, a.use_time,
a.PK, a.Duel, a.gender, b.name, a.Exp, b.pledge_id
from user_data as a
left join pledge as b on a.Pledge_id=b.pledge_id
where char_name not in (".("'".join("','",$exclude_from_top)."'").") and (login>logout) and (builder>=0)");
$online_count=mssql_num_rows($result);
$result=mssql_query("
select a.char_name, a.Lev, a.builder, a.class, a.use_time,
a.PK, a.Duel, a.gender, b.name, a.Exp, b.pledge_id
from user_data as a
left join pledge as b on a.Pledge_id=b.pledge_id
where char_name not in (".("'".join("','",$exclude_from_top)."'").") and (login>logout) and (builder>=0)");
$d_count = 0;
$de_count = 0;
$e_count = 0;
$h_count = 0;
$o_count = 0;
$online_users=array();
for ($x=0;$online_users[$x]=mssql_fetch_assoc($result);$x++)
{
$hours=round($online_users[$x]['use_time']/3600,1);
$online_users[$x]['use_time_d']=floor($hours/24)." дн. ".($hours % 24)." ч.";
if ($online_users[$x]['class'] >= 0 && $online_users[$x]['class'] <= 17) $h_count++;
if ($online_users[$x]['class'] >= 18 && $online_users[$x]['class'] <= 30) $e_count++;
if ($online_users[$x]['class'] >= 31 && $online_users[$x]['class'] <= 43) $de_count++;
if ($online_users[$x]['class'] >= 44 && $online_users[$x]['class'] <= 52) $o_count++;
if ($online_users[$x]['class'] >= 53 && $online_users[$x]['class'] <= 57) $d_count++;
}
unset($online_users[count($online_users)-1]);
mssql_connect($mssql_server,$mssql_user,$mssql_pass);
mssql_select_db($CONFIG['dbdbname']) or DIE("Table unavailable");
$result=mssql_query("
select record_time, world_user
from user_count
where auth_user<>0
order by world_user desc");
$max_user=mssql_fetch_assoc($result);
$result=mssql_query("
SELECT AVG(world_user) AS avg_user
FROM user_count
WHERE (server_id = '1') AND (DATEPART(yy, record_time) = '".date("Y")."') AND (DATEPART(mm, record_time) = '".date("m")."') AND (DATEPART(dd, record_time) = '".date("d")."')");
$avg_today=mssql_fetch_assoc($result);
?>
open eye :O



