$order = $_REQUEST['order'];
}
$sql = myquery("SELECT game_users.user_id,game_users.name,game_users.clevel,game_users_data.rego_time,game_users_data.last_visit,game_users_active.last_active,game_users_active.host,IFNULL(game_invite.user_id,0) AS invitor FROM (game_users,game_users_data,game_users_active) LEFT JOIN game_invite ON (game_invite.invite_id=game_users.user_id) WHERE DATE_FORMAT(FROM_UNIXTIME( `rego_time` ),'%Y-%m-%d')='" . $_REQUEST['data'] . "' AND game_users.user_id=game_users_data.user_id AND game_users_active.user_id=game_users.user_id ORDER BY {$order}");
echo '<table cellspacing="2" cellpadding="2" border="1">';
echo '<tr><td>№</td><td><a href="http://' . domain_name . '/admin.php?opt=main&option=show_reg&data=' . $_REQUEST['data'] . '&order=user_id">ID</a></td><td><a href="http://' . domain_name . '/admin.php?opt=main&option=show_reg&data=' . $_REQUEST['data'] . '&order=name">Имя</a></td><td><a href="http://' . domain_name . '/admin.php?opt=main&option=show_reg&data=' . $_REQUEST['data'] . '&order=clevel">Уровень</a></td><td><a href="http://' . domain_name . '/admin.php?opt=main&option=show_reg&data=' . $_REQUEST['data'] . '&order=host">IP</a></td><td><a href="http://' . domain_name . '/admin.php?opt=main&option=show_reg&data=' . $_REQUEST['data'] . '&order=rego_time">рег</a></td><td><a href="http://' . domain_name . '/admin.php?opt=main&option=show_reg&data=' . $_REQUEST['data'] . '&order=last_visit">Посл.вход</a></td><td>в игре</td><td>id ref</td><td></td></tr>';
$i = 0;
while ($row = mysql_fetch_array($sql)) {
$i++;
if ($row['last_active'] - $row['last_visit'] < 0) {
$hours = 0;
$minutes = 0;
} else {
$hours = floor(($row['last_active'] - $row['last_visit']) / 3600);
$minutes = floor(($row['last_active'] - $row['last_visit']) / 60 - $hours * 60);
}
echo '<tr><td>' . $i . '</td><td>' . $row['user_id'] . '</td><td>' . $row['name'] . '</td><td>' . $row['clevel'] . '</td><td>' . number2ip($row['host']) . '</td><td>' . date("H:i", $row['rego_time']) . '</td><td>' . date("Y-m-d H:i", $row['last_visit']) . '</td><td>' . $hours . ':' . $minutes . '</td><td>' . $row['invitor'] . '</td><td><input type="button" onClick="del_user(\'' . $row['name'] . '\')" value="Удалить игрока"></td></tr>';
}
echo '</table>';
echo '<iframe id="delid_user" name="dele_user" src="" style="width:100%;height:50px"></iframe>';
} else {
// Отображаем общую таблицу дата - количество регистраций
$sql = myquery("SELECT DATE_FORMAT( FROM_UNIXTIME( game_users_data.rego_time ) , '%Y-%m-%d' ) AS rego, count( game_users_data.user_id ) AS cnt, count( game_invite.id ) AS inv_cnt, ( SELECT count(game_stats_timemarker.id) FROM game_stats_timemarker WHERE DATE_FORMAT( FROM_UNIXTIME( game_users_data.rego_time ) , '%Y-%m-%d' )=DATE_FORMAT( FROM_UNIXTIME( game_stats_timemarker.time_stamp ) , '%Y-%m-%d' ) AND game_stats_timemarker.reason=1) as exit_cnt FROM game_users_data LEFT JOIN game_invite ON game_invite.invite_id = game_users_data.user_id GROUP BY rego ORDER BY rego DESC LIMIT 14");
echo '<table cellspacing="2" cellpadding="2" border="1">';
echo '<tr><td>№</td><td>Дата</td><td>Количество регистраций</td><td>Приглашенных</td><td>Выходы из ГН</td></tr>';
$i = 0;
while ($row = mysql_fetch_array($sql)) {
$i++;
echo '<tr><td>' . $i . '</td><td>' . $row['rego'] . '</td><td>' . $row['cnt'] . '</td><td>' . $row['inv_cnt'] . '</td><td>' . $row['exit_cnt'] . '</td></tr>';
}
echo '</table>';
}
} else {
$validation_string .= chr($rand_val);
}
}
$email = mysqlresult(myquery("SELECT email FROM game_users_data WHERE user_id='{$user_id}'"), 0, 0);
$result = myquery("INSERT INTO game_admins_ip (host, validate, user_id) VALUES (" . $host . ",'{$validation_string}'," . $user_id . ")") or die(mysql_error());
$message = "Нажмите ссылку для подтверждения регистрации нового IP адреса администратора - '" . number2ip($host) . "':\n\n";
$message .= "http://" . domain_name . "/admin.php?option=activate&user_id=" . $user_id . "&host_admin=" . $host . "&validate={$validation_string}\n\n";
$subject = 'Средиземье :: Эпоха сражений [Активация для администратора] - ' . domain_name . '';
$e_mail = new emailer();
$e_mail->email_init();
$e_mail->to = $email;
$e_mail->subject = $subject;
$e_mail->message = $message;
$e_mail->send_mail();
echo '<font size=3 color=#FFFF00><br><br><center>Твой IP адрес - <b>' . number2ip($host) . '</b> - отсутствует в базе данных IP адресов администраторов';
echo '<br><br>На твой почтовый ящик администратора было выслано письмо с активацией нового IP адреса';
if (function_exists("save_debug")) {
save_debug();
}
exit;
}
}
$adm = mysql_fetch_array($result);
if (!isset($_GET['opt'])) {
$opt = '';
} else {
$opt = $_GET['opt'];
}
switch (@$opt) {
default:
$row = mysql_fetch_array($resc);
$flagPathMore = "flag/".strtolower($row['short']).".gif";
$countryNameMore = strtolower($row['country_name']);
}
}
*/
echo '<tr bgcolor="#333333" valign="middle">
<td><font size="1" face="Verdana" color="#ffffff"><a href=http://' . domain_name . '/view/?userid=' . $act['user_id'] . ' target="_blank">' . $act['name'] . '</a></font></td>
<td><font size="1" face="Verdana" color="#ffffff">' . $act['race_name'] . '</font></td>
<td><font size="1" face="Verdana" color="#ffffff">' . $act['clevel'] . '</font></td>
<td><font size="1" face="Verdana" color="#ffffff">' . $act['map_name'] . ': x-' . $act['map_xpos'] . ' y-' . $act['map_ypos'] . '</font></td>
<td><font size="1" face="Verdana" color="#ffffff">';
if (!empty($flagPath)) {
echo '<img src=http://' . img_domain . '/' . $flagPath . ' border="0" title="' . $countryName . '" height="15"> ';
}
echo number2ip($act['host']) . ' </font></td>
<td><font size="1" face="Verdana" color="#ffffff">';
if (!empty($flagPathMore)) {
echo '<img src=http://' . img_domain . '/' . $flagPathMore . ' border="0" title="' . $countryNameMore . '" height="15"> ';
}
echo $act['host_more'] . '</font></td>
<td><font size="1" face="Verdana" color="#ff0000">' . get_delay_reason($act['delay_reason']) . '</font></td>
<td><font size="1" face="Verdana" color="#ffffff">' . $act['func_id'] . '</font></td>';
if ($adm['users'] >= 1) {
echo '
<td><font size="1" face="Verdana" color="#ffffff">' . $act['GP'] . '</font></td>
<td><font size="1" face="Verdana">' . $act['EXP'] . '</font></td>
<td><font size="1" face="Verdana" color="#ffffff">' . $act['email'] . '</font></td>
<td><font size="1" face="Verdana" color="#ffffff"><a href="admin.php?opt=main&option=users&name_v=' . $act['name'] . '"><img width="20" height="20" src="http://' . img_domain . '/nav/show.gif" border="0"></a></font></td>';
if ($act['boy'] != 0) {
echo '<td><font size="1" face="Verdana" color="#ffffff"><a href="admin.php?opt=main&option=ip&sort=' . $sort . '&del_combat=' . $act['user_id'] . '"><img width="20" height="20" src="http://' . img_domain . '/nav/action_notattack.gif" border="0"></a></font></td>';
echo '<form method="post" action="admin.php?opt=main&option=bandiap&new&add">';
echo '<table cellspacing="5" cellpadding="0" border="0">';
echo '<tr align="center"><td width="150">Нижняя граница:</td><td width="300"><input name="min_ip" type="text" size=20></td></tr>';
echo '<tr align="center"><td>Верхняя граница:</td><td><input name="max_ip" type="text" size=20></td></tr>';
echo '<tr align="center"><td>Время бана (минуты):</td><td><input name="time" type="text" value="0" size=20></td></tr>';
echo '<tr align="center"><td>Комментарий:</td><td><textarea name="reason" cols="70" class="input" rows="8"></textarea></td></tr>';
echo '</table>';
echo '<br><br><input name="" type="submit" value="Забанить">';
echo ' <input name="" type="button" value="Назад" onClick="location.href=\'admin.php?opt=main&option=bandiap\'">';
echo '</form>';
echo '<br><br><i>При времени бана "0", диапазон банится навсегда!</i>';
}
} elseif (isset($_GET['del'])) {
list($min_ip, $max_ip) = mysql_fetch_array(myquery("Select user_id, ip From game_ban Where id = " . $_GET['del'] . ";"));
$min = number2ip($min_ip);
$max = number2ip($max_ip);
$da = getdate();
$log = myquery("INSERT INTO game_log_adm (adm,dei,cur_time,day,month,year) \n\t\t\t\tVALUES (\n\t\t\t\t '" . $char['name'] . "',\n\t\t\t\t 'Удалил бан диапазона: <b>" . $min . " - " . $max . "</b>',\n\t\t\t\t '" . time() . "',\n\t\t\t\t '" . $da['mday'] . "',\n\t\t\t\t '" . $da['mon'] . "',\n\t\t\t\t '" . $da['year'] . "')") or die(mysql_error());
myquery("DELETE FROM game_ban WHERE id=" . $_GET['del'] . ";");
echo 'Бан диапазона удалён!';
echo '<meta http-equiv="refresh" content="1;url=?opt=main&option=bandiap">';
} else {
echo "<a href=admin.php?opt=main&option=bandiap&new>Забанить диапозон</a></br/>";
$check_bans = myquery("Select * From game_ban Where type=1 and (time>" . time() . " or time=-1) Order by id desc");
if (mysql_num_rows($check_bans) > 0) {
echo '<br><br><b>Список забаненых диапозонов</b><br><br>';
echo '<table border="1"><tr align="center">
<td width="50">Админ</td>
<td width="200">Диапозон</td>
<td width="120">Время окончания</td>
<td width="250">Причина</td>
<?php
$dirclass = "../class";
require '../inc/config.inc.php';
include '../inc/lib.inc.php';
include '../inc/template.inc.php';
//DbConnect();
echo '<form action="" method="post"><input type="text" name="host" size=25><input type="submit" name="runIP" value="IP->число"></form><br>';
echo '<form action="" method="post"><input type="text" name="host1" size=25><input type="submit" name="runNumber" value="число->IP"></form>';
if (isset($runIP)) {
echo 'IP = ' . $host . '<br>';
echo 'number = ' . ip2number($host) . '<br>';
echo 'IP-number = ' . number2ip(ip2number($host)) . '<br>';
}
if (isset($runNumber)) {
echo 'number = ' . $host1 . '<br>';
echo 'IP = ' . number2ip($host1) . '<br>';
echo 'number = ' . ip2number(number2ip($host1)) . '<br>';
}
<td><font size="2" color="#eeeeee">Браузер</font></td>
<td><font size="2" color="#eeeeee"><div align="center">Версия</div></font></td>
<td><font size="2" color="#eeeeee">Хост</font></td>
<td><font size="2" color="#eeeeee">Линк</font></td>
<td><font size="2" color="#eeeeee">Игрок</font></td>
</tr>';
$i = 0;
while ($report = mysql_fetch_array($result)) {
$browser = get_browser($report['agent'], true);
echo '<tr align="center">
<td>' . date("d M Y H:i", $report['time']) . '</td>
<td>' . $browser['platform'] . (isset($browser['win64']) && $browser['win64'] ? ' (x64)' : '') . '</td>
<td>' . (isset($browser['ismobiledevice']) && $browser['ismobiledevice'] ? 'mobile' : '') . '</td>
<td>' . $browser['browser'] . '</td>
<td><div align="center">' . $browser['version'] . '</div></td>
<td>' . number2ip($report['host']) . '</td>
<td>' . $report['ref'] . '</td>
<td>' . $report['name'] . '</td>
</tr>';
}
}
echo '</table>';
if (isset($_GET['type']) and $_GET['type'] == 'unique') {
$href = "?opt=main&option=stat&type=unique";
} else {
if (isset($_GET['name_v']) and $_GET['name_v'] != '') {
$href = "?opt=main&option=stat&name_v=" . $_GET['name_v'] . "";
} elseif (isset($_GET['ip_v']) and $_GET['ip_v'] != '') {
$href = "?opt=main&option=stat&ip_v=" . $_GET['ip_v'] . "";
} elseif (isset($_GET['ip_v1']) and $_GET['ip_v1'] != '' and isset($_GET['ip_v2']) and $_GET['ip_v2'] != '') {
$href = "?opt=main&option=stat&ip_v1=\$" . $_GET['ip_v1'] . "&ip_v2=\$" . $_GET['ip_v2'] . "";
if (!isset($user1)) {
echo '<div id="content" onclick="hideSuggestions();"><center>Выберите игрока<br>';
echo 'В игре ' . $online_number . ' человек</center>
<table cellpadding="0" cellspacing="1" border="0" width="60%" align="center">
<tr>
<td valign="top">
<tr bgcolor="#006699"><td width="50"><font size="1" face="Verdana" color="#000000">Ник</font></td><td width="50"><font size="1" face="Verdana" color="#000000">Хост</font></td>
<td></td><td></td>
</tr>';
while ($pl = mysql_fetch_array($result)) {
$selpl = myquery("SELECT name FROM game_users WHERE user_id='" . $pl['user_id'] . "'");
if (!mysql_num_rows($selpl)) {
$selpl = myquery("SELECT name FROM game_users_archive WHERE user_id='" . $pl['user_id'] . "'");
}
$player = mysql_fetch_array($selpl);
echo '<tr bgcolor="#333333"><td><font size="1" face="Verdana" color="#ffffff">' . $player['name'] . '</font></td><td><font size="1" face="Verdana" color="#ffffff">' . number2ip($pl['host']) . '</font></td>
<td><button onClick="location.href=\'admin.php?opt=main&option=ban&nic=' . $player['name'] . '&user1=' . $pl['user_id'] . '\'">По Нику</button></td>
<td><button onClick="location.href=\'admin.php?opt=main&option=ban&nic=' . $player['name'] . '&user1=' . $pl['user_id'] . '&host_ban=' . $pl['host'] . '\'">По IP</button></td>
</tr>';
}
if (!isset($see)) {
echo '<center><form action="" method="post">
<tr><td> </td><td> </td></tr>
<tr><td>Имя: <input name="user2" type="text" size="25" id="keyword" onkeyup="handleKeyUp(event)"><div style="display:none;" id="scroll"><div id="suggest"></div></div></td><td><input name="submit" type="submit" value="Забанить"></td></tr>
<input name="see" type="hidden" value="">
</form>';
} else {
$prov = myquery("select user_id,name from game_users where name='" . $user2 . "'");
if (!mysql_num_rows($prov)) {
$prov = myquery("select user_id,name from game_users_archive where name='" . $user2 . "'");
}
$i++;
if ($i % 2 == 0) {
$col = '#D3D3D3';
} else {
$col = '#A7A7A7';
}
$dif = $log['host_from'] - $log['host_to'];
if ($dif == 0) {
$col = '#FF0000';
} elseif ($dif >= -255 and $dif <= 255) {
$col = '#FFFF00';
} elseif (isset($att)) {
continue;
}
$t = date("H:i:s d-m-Y", $log['time']);
echo '<tr bgcolor=' . $col . '><td align=center valign=center><font color=000000>' . $t . '</td><td align=center valign=center><font color=000000>' . $log['name_from'] . '</td><td align=center valign=center><font color=000000>' . $log['user_id_from'] . '</td><td align=center valign=center><font color=000000>' . number2ip($log['host_from']) . '</td><td align=center valign=center><font color=000000>' . $log['name_to'] . '</td><td align=center valign=center><font color=000000>' . $log['user_id_to'] . '</td><td align=center valign=center><font color=000000>' . number2ip($log['host_to']) . '</td><td align=center valign=center><font color=000000>' . $log['summa'] . '</td></tr>';
}
echo '</table>';
$href = '?opt=main&option=bank&log&';
if (isset($att)) {
$href .= 'att&';
}
if (isset($_GET['usr'])) {
$href .= 'usr='******'usr'] . '&';
}
echo '<center>Страница: ';
show_page($page, $allpage, $href);
}
if (isset($_REQUEST['kredit'])) {
if (!isset($page)) {
$page = 1;
