function Admin_Bots() { global $session; global $db_prefix; global $GlobalUser; $result = ""; // Обработка POST-запроса. if (method() === "POST") { if (AddBot($_POST['name'])) { $result = "<font color=lime>Бот успешно добавлен.</font>"; } else { $result = "<font color=red>Игрок с таким именем уже существует.</font>"; } } // Обработка GET-запроса. if (method() === "GET") { StopBot(intval($_GET['id'])); $result = "<font color=lime>Бот остановлен.</font>"; } ?> <?php echo AdminPanel(); ?> <center><?php echo $result; ?> </center> <h2>Список ботов:</h2> <?php $query = "SELECT * FROM " . $db_prefix . "queue WHERE type = 'AI' GROUP BY owner_id"; $result = dbquery($query); $rowss = $rows = dbrows($result); if ($rows == 0) { echo "Ботов не обнаружено<br>"; } else { echo "<table>\n"; echo "<tr><td class=c>ID</td><td class=c>Имя</td><td class=c>Главная планета</td><td class=c>Действие</td></tr>\n"; } while ($rows--) { $queue = dbarray($result); $user = LoadUser($queue['owner_id']); $planet = GetPlanet($user['hplanetid']); echo "<tr>"; echo "<td>" . $user['player_id'] . "</td>"; echo "<td>" . AdminUserName($user) . "</td>"; echo "<td>" . AdminPlanetName($planet) . " " . AdminPlanetCoord($planet) . "</td>"; echo "<td><a href=\"index.php?page=admin&session={$session}&mode=Bots&action=stop&id=" . $user['player_id'] . "\">Остановить</a></td>"; echo "</tr>\n"; } if ($rowss) { echo "</table>"; } ?> <h2>Добавить бота:</h2> <form action="index.php?page=admin&session=<?php echo $session; ?> &mode=Bots" method="POST"> <table> <tr><td>Имя <input type=text size=10 name="name" /> <input type=submit value="Отправить" /></td></tr> </table> </form> <?php }
function Admin_Planets() { global $loca_lang, $Languages; global $session; global $db_prefix; global $GlobalUser; $SearchResult = ""; $buildmap = array(1, 2, 3, 4, 12, 14, 15, 21, 22, 23, 24, 31, 33, 34, 41, 42, 43, 44); $fleetmap = array(202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215); $defmap = array(401, 402, 403, 404, 405, 406, 407, 408, 502, 503); // Обработка POST-запроса. if (method() === "POST" && $GlobalUser['admin'] >= 2) { $cp = intval($_GET['cp']); $action = $_GET['action']; $now = time(); //print_r ( $_POST); if ($action === "update") { $param = array('b1', 'b2', 'b3', 'b4', 'b12', 'b14', 'b15', 'b21', 'b22', 'b23', 'b24', 'b31', 'b33', 'b34', 'b41', 'b42', 'b43', 'b44', 'd401', 'd402', 'd403', 'd404', 'd405', 'd406', 'd407', 'd408', 'd502', 'd503', 'f202', 'f203', 'f204', 'f205', 'f206', 'f207', 'f208', 'f209', 'f210', 'f211', 'f212', 'f213', 'f214', 'f215', 'm', 'k', 'd', 'g', 's', 'p', 'diameter', 'type', 'temp', 'mprod', 'kprod', 'dprod', 'sprod', 'fprod', 'ssprod'); $moon_param = array('g', 's', 'p'); $query = "UPDATE " . $db_prefix . "planets SET lastpeek={$now}, "; foreach ($param as $i => $p) { if (strpos($p, "prod")) { $query .= ", {$p}='" . $_POST[$p] . "'"; } else { if ($i == 0) { $query .= "{$p}=" . intval($_POST[$p]); } else { $query .= ", {$p}=" . intval($_POST[$p]); } } } $query .= " WHERE planet_id={$cp};"; if (key_exists("delete_planet", $_POST)) { $planet = GetPlanet($cp); $user = LoadUser($planet['owner_id']); if ($user['hplanetid'] != $cp) { DestroyPlanet($cp); $_GET['cp'] = $user['hplanetid']; // перенаправить на главную планету. } } else { // Обновить данные планеты $moon_id = PlanetHasMoon($cp); // Переместить луну за планетой. if ($moon_id) { $mquery = "UPDATE " . $db_prefix . "planets SET lastpeek={$now}, "; foreach ($moon_param as $i => $p) { if ($i == 0) { $mquery .= "{$p}=" . intval($_POST[$p]); } else { $mquery .= ", {$p}=" . intval($_POST[$p]); } } $mquery .= " WHERE planet_id={$moon_id};"; dbquery($mquery); } dbquery($query); RecalcFields($cp); } } else { if ($action === "search") { $searchtype = $_POST['type']; if ($_POST['searchtext'] === "") { $SearchResult .= "Укажите строку для поиска<br>\n"; $searchtype = "none"; } if ($searchtype === "playername") { $query = "SELECT player_id FROM " . $db_prefix . "users WHERE oname LIKE '" . $_POST['searchtext'] . "%'"; $query = "SELECT * FROM " . $db_prefix . "planets WHERE owner_id = ANY ({$query});"; } else { if ($searchtype === "planetname") { $query = "SELECT * FROM " . $db_prefix . "planets WHERE name LIKE '" . $_POST['searchtext'] . "%';"; } else { if ($searchtype === "allytag") { $query = "SELECT ally_id FROM " . $db_prefix . "ally WHERE tag LIKE '" . $_POST['searchtext'] . "%'"; $query = "SELECT player_id FROM " . $db_prefix . "users WHERE ally_id <> 0 AND ally_id = ANY ({$query})"; $query = "SELECT * FROM " . $db_prefix . "planets WHERE owner_id = ANY ({$query});"; } } } if ($query) { $result = dbquery($query); } $SearchResult .= "<table>\n"; $rows = dbrows($result); if ($rows > 0) { while ($rows--) { $planet = dbarray($result); $user = LoadUser($planet['owner_id']); $SearchResult .= "<tr><th>" . date("Y-m-d H:i:s", $planet['date']) . "</th><th>" . AdminPlanetCoord($planet) . "</th>"; $SearchResult .= "<th><a href=\"index.php?page=admin&session={$session}&mode=Planets&cp=" . $planet['planet_id'] . "\">" . $planet['name'] . "</a></th>"; $SearchResult .= "<th><a href=\"index.php?page=admin&session={$session}&mode=Users&player_id=" . $user['player_id'] . "\">" . $user['oname'] . "</a></th></tr>\n"; } } else { $SearchResult .= "Ничего не найдено<br>\n"; } $SearchResult .= "</table>\n"; } } } // Обработка GET-запроса. if (method() === "GET" && $GlobalUser['admin'] >= 2) { if (key_exists('cp', $_GET)) { $cp = intval($_GET['cp']); } else { $cp = 0; } if (key_exists('action', $_GET) && $cp) { $action = $_GET['action']; } else { $action = ""; } $now = time(); if ($action === "create_moon") { $planet = GetPlanet($cp); if ($planet['type'] > 0 && $planet['type'] < 10000) { if (PlanetHasMoon($cp) == 0) { CreatePlanet($planet['g'], $planet['s'], $planet['p'], $planet['owner_id'], 0, 1, 20); } } } else { if ($action === "create_debris") { $planet = GetPlanet($cp); if ($planet['type'] > 0 && $planet['type'] < 10000) { if (HasDebris($planet['g'], $planet['s'], $planet['p']) == 0) { CreateDebris($planet['g'], $planet['s'], $planet['p'], $planet['owner_id']); } } } else { if ($action === "cooldown_gates") { $planet = GetPlanet($cp); if ($planet['type'] == 0) { $query = "UPDATE " . $db_prefix . "planets SET gate_until=0 WHERE planet_id=" . $planet['planet_id']; dbquery($query); } } else { if ($action === "warmup_gates") { $planet = GetPlanet($cp); if ($planet['type'] == 0) { $query = "UPDATE " . $db_prefix . "planets SET gate_until=" . ($now + 59 * 60 + 59) . " WHERE planet_id=" . $planet['planet_id']; dbquery($query); } } else { if ($action === "recalc_fields") { RecalcFields($cp); } else { if ($action === "random_diam") { $planet = GetPlanet($cp); if (GetPlanetType($planet) == 1) { $p = $planet['p']; if ($p <= 3) { $diam = mt_rand(50, 120) * 72; } else { if ($p >= 4 && $p <= 6) { $diam = mt_rand(50, 150) * 120; } else { if ($p >= 7 && $p <= 9) { $diam = mt_rand(50, 120) * 120; } else { if ($p >= 10 && $p <= 12) { $diam = mt_rand(50, 120) * 96; } else { if ($p >= 13 && $p <= 15) { $diam = mt_rand(50, 150) * 96; } } } } } $query = "UPDATE " . $db_prefix . "planets SET diameter={$diam} WHERE planet_id=" . $planet['planet_id']; dbquery($query); } } } } } } } } if (key_exists("cp", $_GET)) { // Информация о планете. $planet = GetPlanet(intval($_GET['cp'])); $user = LoadUser($planet['owner_id']); $moon_id = PlanetHasMoon($planet['planet_id']); $debris_id = HasDebris($planet['g'], $planet['s'], $planet['p']); $now = time(); // Парсер шпионских докладов. ?> <script> function php_str_replace(search, replace, subject) { // http://kevin.vanzonneveld.net var s = subject; var ra = r instanceof Array, sa = s instanceof Array; var f = [].concat(search); var r = [].concat(replace); var i = (s = [].concat(s)).length; var j = 0; while (j = 0, i--) { if (s[i]) { while (s[i] = (s[i]+'').split(f[j]).join(ra ? r[j] || '' : r[0]), ++j in f){}; } } return sa ? s : s[0]; } function spio () { global $GlobalUni; // // Перечислить все технологии для всех языков, а также ресурсы // var TechNames = { <?php foreach ($Languages as $lang => $langname) { loca_add("common", $lang); loca_add("technames", $lang); } $old_lang = $loca_lang; foreach ($Languages as $lang => $langname) { $loca_lang = $lang; foreach ($buildmap as $i => $gid) { echo "\"" . loca("NAME_{$gid}") . "\": {$gid}, "; } foreach ($fleetmap as $i => $gid) { echo "\"" . loca("NAME_{$gid}") . "\": {$gid}, "; } foreach ($defmap as $i => $gid) { echo "\"" . loca("NAME_{$gid}") . "\": {$gid}, "; } } ?> }; var ResNames = { <?php foreach ($Languages as $lang => $langname) { $loca_lang = $lang; echo "\"" . loca("METAL") . "\": 'm', "; echo "\"" . loca("CRYSTAL") . "\": 'k', "; echo "\"" . loca("DEUTERIUM") . "\": 'd', "; } $loca_lang = $old_lang; ?> }; var text = document.getElementById ("spiotext" ).value; text = php_str_replace (".", "", text); text = php_str_replace (":", "", text); for ( var name in TechNames ) { var id = TechNames[name]; pos = text.indexOf ( name ); if ( pos > 0 ) { obj = text.substr ( pos ); found = obj.match ("("+name+"[\\s]+)([0-9]{1,})"); document.getElementById ( "obj" + id ) . value = parseInt(found[2]); } } for ( var name in ResNames ) { var id = ResNames[name]; pos = text.indexOf ( name ); if ( pos > 0 ) { obj = text.substr ( pos ); found = obj.match ("("+name+"[\\s]+)([0-9]{1,})"); document.getElementById ( "obj" + id ) . value = parseInt(found[2]); } } } function reset () { var ids = [ <?php foreach ($buildmap as $i => $gid) { echo "{$gid}, "; } foreach ($fleetmap as $i => $gid) { echo "{$gid}, "; } foreach ($defmap as $i => $gid) { echo "{$gid}, "; } ?> ]; for ( var i in ids ) { document.getElementById ( "obj" + ids[i] ) . value = 0; } } </script> <?php AdminPanel(); echo "<table>\n"; echo "<form action=\"index.php?page=admin&session={$session}&mode=Planets&action=update&cp=" . $planet['planet_id'] . "\" method=\"POST\" >\n"; echo "<tr><td class=c colspan=2>Планета \"" . $planet['name'] . "\" (<a href=\"index.php?page=admin&session={$session}&mode=Users&player_id=" . $user['player_id'] . "\">" . $user['oname'] . "</a>)</td>\n"; echo " <td class=c >Постройки</td> <td class=c >Флот</td> <td class=c >Оборона</td> </tr>\n"; echo "<tr><th><img src=\"" . GetPlanetImage(UserSkin(), $planet) . "\"> <br>Тип: " . $planet['type']; $pp = PlanetPrice($planet); echo "<br>Стоимость : " . nicenum($pp['points'] / 1000); echo "<br>Постройки : " . nicenum(($pp['points'] - ($pp['fleet_pts'] + $pp['defense_pts'])) / 1000); echo "<br>Флот : " . nicenum($pp['fleet_pts'] / 1000); echo "<br>Оборона : " . nicenum($pp['defense_pts'] / 1000); if ($planet['type'] == 10000) { echo "<br>М: " . nicenum($planet['m']) . "<br>К: " . nicenum($planet['k']) . "<br>"; } echo "</th><th>"; if ($planet['type'] > 0 && $planet['type'] < 10000) { if ($moon_id) { $moon = GetPlanet($moon_id); echo "<a href=\"index.php?page=admin&session={$session}&mode=Planets&cp=" . $moon['planet_id'] . "\"><img src=\"" . GetPlanetSmallImage(UserSkin(), $moon) . "\"><br>\n"; echo $moon['name'] . "</a>"; } else { echo "<a href=\"index.php?page=admin&session={$session}&mode=Planets&action=create_moon&cp=" . $planet['planet_id'] . "\" >Создать луну</a>\n"; } echo "<br/><br/>\n"; if ($debris_id) { $debris = GetPlanet($debris_id); echo "<a href=\"index.php?page=admin&session={$session}&mode=Planets&cp=" . $debris['planet_id'] . "\"><img src=\"" . UserSkin() . "planeten/debris.jpg\"><br>\n"; echo $debris['name'] . "</a>"; echo "<br>М: " . nicenum($debris['m']) . "<br>К: " . nicenum($debris['k']) . "<br>"; } else { echo "<a href=\"index.php?page=admin&session={$session}&mode=Planets&action=create_debris&cp=" . $planet['planet_id'] . "\" >Создать поле обломков</a>\n"; } } else { $parent = LoadPlanet($planet['g'], $planet['s'], $planet['p'], 1); echo "<a href=\"index.php?page=admin&session={$session}&mode=Planets&cp=" . $parent['planet_id'] . "\"><img src=\"" . GetPlanetSmallImage(UserSkin(), $parent) . "\"><br>\n"; echo $parent['name'] . "</a>"; } ?> <br><br><textarea rows=10 cols=10 id="spiotext"></textarea> <a href="#" onclick="javascript:spio();">Разобрать данные доклада</a> <br> <a href="#" onclick="javascript:reset();">Сбросить</a> <?php echo "</th>"; echo "<th valign=top><table>\n"; foreach ($buildmap as $i => $gid) { echo "<tr><th>" . loca("NAME_{$gid}"); if ($gid == 43 && $planet['type'] == 0) { // управление воротами. if ($now >= $planet["gate_until"]) { // ворота готовы echo " <a href=\"index.php?page=admin&session={$session}&mode=Planets&action=warmup_gates&cp=" . $planet['planet_id'] . "\" >нагреть</a>"; } else { // ворота НЕ готовы $delta = $planet["gate_until"] - $now; echo " " . date('i\\m s\\s', $delta) . " <a href=\"index.php?page=admin&session={$session}&mode=Planets&action=cooldown_gates&cp=" . $planet['planet_id'] . "\">остудить</a>"; } } echo "</th><th><nobr><input id=\"obj{$gid}\" type=\"text\" size=3 name=\"b{$gid}\" value=\"" . $planet["b{$gid}"] . "\" />"; // управление шахтами и выработкой энергии. if ($gid == 1 && $planet['type'] != 0) { echo "<select name='mprod'>\n"; for ($prc = 0; $prc <= 1; $prc += 0.1) { echo "<option value='{$prc}' "; if ($planet["mprod"] == $prc . "") { echo " selected"; } echo ">" . $prc * 100 . "</option>\n"; } echo "</select>\n"; } if ($gid == 2 && $planet['type'] != 0) { echo "<select name='kprod'>\n"; for ($prc = 0; $prc <= 1; $prc += 0.1) { echo "<option value='{$prc}' "; if ($planet["kprod"] == $prc . "") { echo " selected"; } echo ">" . $prc * 100 . "</option>\n"; } echo "</select>\n"; } if ($gid == 3 && $planet['type'] != 0) { echo "<select name='dprod'>\n"; for ($prc = 0; $prc <= 1; $prc += 0.1) { echo "<option value='{$prc}' "; if ($planet["dprod"] == $prc . "") { echo " selected"; } echo ">" . $prc * 100 . "</option>\n"; } echo "</select>\n"; } if ($gid == 4 && $planet['type'] != 0) { echo "<select name='sprod'>\n"; for ($prc = 0; $prc <= 1; $prc += 0.1) { echo "<option value='{$prc}' "; if ($planet["sprod"] == $prc . "") { echo " selected"; } echo ">" . $prc * 100 . "</option>\n"; } echo "</select>\n"; } if ($gid == 12 && $planet['type'] != 0) { echo "<select name='fprod'>\n"; for ($prc = 0; $prc <= 1; $prc += 0.1) { echo "<option value='{$prc}' "; if ($planet["fprod"] == $prc . "") { echo " selected"; } echo ">" . $prc * 100 . "</option>\n"; } echo "</select>\n"; } echo "</nobr></th></tr>\n"; } echo "</table></th>\n"; echo "<th valign=top><table>\n"; foreach ($fleetmap as $i => $gid) { echo "<tr><th>" . loca("NAME_{$gid}") . "</th><th><nobr><input id=\"obj{$gid}\" type=\"text\" size=6 name=\"f{$gid}\" value=\"" . $planet["f{$gid}"] . "\" />"; if ($gid == 212 && $planet['type'] != 0) { echo "<select name='ssprod'>\n"; for ($prc = 0; $prc <= 1; $prc += 0.1) { echo "<option value='{$prc}' "; if ($planet["ssprod"] == $prc . "") { echo " selected"; } echo ">" . $prc * 100 . "</option>\n"; } echo "</select>\n"; } echo "</nobr></th></tr>\n"; } echo "</table></th>\n"; echo "<th valign=top><table>\n"; foreach ($defmap as $i => $gid) { echo "<tr><th>" . loca("NAME_{$gid}") . "</th><th><input id=\"obj{$gid}\" type=\"text\" size=6 name=\"d{$gid}\" value=\"" . $planet["d{$gid}"] . "\" /></th></tr>\n"; } echo "</table></th>\n"; echo "</tr>\n"; echo "<tr><th>Дата создания</th><th>" . date("Y-m-d H:i:s", $planet['date']) . "</th> <td colspan=10 class=c>Очередь построек</td></tr>"; echo "<tr><th>Дата удаления</th><th>" . date("Y-m-d H:i:s", $planet['remove']) . "</th> <th colspan=3 rowspan=12 valign=top style='text-align: left;'> "; $query = "SELECT * FROM " . $db_prefix . "buildqueue WHERE planet_id = " . $planet['planet_id'] . " ORDER BY list_id ASC"; $result = dbquery($query); $anz = dbrows($result); echo "<table>"; $bxx = 1; $duration = 0; while ($row = dbarray($result)) { echo "<tr><td> <table><tr><th><div id='bxx" . $bxx . "' title='" . ($row['end'] - $row['start'] - ($now - ($row['start'] + $duration))) . "' star='" . $duration . "'></th>"; echo "<tr><th>" . date("d.m.Y H:i:s", $row['end'] + $duration) . "</th></tr></table></td>"; echo "<td><img width='32px' src='" . UserSkin() . "gebaeude/" . $row['tech_id'] . ".gif'></td>"; echo "<td><b>" . loca("NAME_" . $row['tech_id']) . "</b><br>уровень " . $row['level'] . "</td></tr>"; $bxx++; $duration += $row['end'] - $row['start']; } echo "</table>"; echo "<script language=javascript>anz={$anz};t();</script>\n"; ?> <?php echo "</th> </tr>"; echo "<tr><th>Последняя активность</th><th>" . date("Y-m-d H:i:s", $planet['lastakt']) . "</th> \n"; echo "<input type=\"hidden\" name=\"type\" value=\"" . $planet['type'] . "\" >\n"; echo "</th> </tr>\n"; echo "<tr><th>Последнее обновление</th><th>" . date("Y-m-d H:i:s", $planet['lastpeek']) . "</th></tr>\n"; echo "<tr><th>Диаметр <br><a href=\"index.php?page=admin&session={$session}&mode=Planets&action=random_diam&cp=" . $planet['planet_id'] . "\" >новый диаметр</a> </th><th><input size=5 type=\"text\" name=\"diameter\" value=\"" . $planet['diameter'] . "\" /> км (" . $planet['fields'] . " из " . $planet['maxfields'] . " полей) "; echo "<a href=\"index.php?page=admin&session={$session}&mode=Planets&action=recalc_fields&cp=" . $planet['planet_id'] . "\" >пересчитать поля</a> "; echo "</th></tr>\n"; echo "<tr><th>Температура</th><th>от <input size=5 type=\"text\" name=\"temp\" value=\"" . $planet['temp'] . "\" />°C до " . ($planet['temp'] + 40) . "°C</th></tr>\n"; echo "<tr><th>Координаты</th><th>[<input type=\"text\" name=\"g\" value=\"" . $planet['g'] . "\" size=1 />:<input type=\"text\" name=\"s\" value=\"" . $planet['s'] . "\" size=2 />:<input type=\"text\" name=\"p\" value=\"" . $planet['p'] . "\" size=1 />]</th></tr>\n"; echo "<tr><td class=c colspan=2>Ресурсы</td></tr>\n"; echo "<tr><th>Металл</th><th><input id=\"objm\" type=\"text\" name=\"m\" value=\"" . ceil($planet['m']) . "\" /></th></tr>\n"; echo "<tr><th>Кристалл</th><th><input id=\"objk\" type=\"text\" name=\"k\" value=\"" . ceil($planet['k']) . "\" /></th></tr>\n"; echo "<tr><th>Дейтерий</th><th><input id=\"objd\" type=\"text\" name=\"d\" value=\"" . ceil($planet['d']) . "\" /></th></tr>\n"; echo "<tr><th>Энергия</th><th>" . $planet['e'] . " / " . $planet['emax'] . "</th></tr>\n"; echo "<tr><th>Коэффициент производства</th><th>" . $planet['factor'] . "</th></tr>\n"; echo "<tr><th colspan=8><input type=\"submit\" value=\"Сохранить\" /> <input type=\"submit\" name=\"delete_planet\" value=\"Удалить\" /> </th></tr>\n"; echo "</form>\n"; echo "</table>\n"; } else { $query = "SELECT * FROM " . $db_prefix . "planets ORDER BY date DESC LIMIT 25"; $result = dbquery($query); AdminPanel(); echo " </th> \n"; echo " </tr> \n"; echo "</table> \n"; echo "Новые планеты:<br>\n"; echo "<table>\n"; echo "<tr><td class=c>Дата создания</td><td class=c>Координаты</td><td class=c>Планета</td><td class=c>Игрок</td></tr>\n"; $rows = dbrows($result); while ($rows--) { $planet = dbarray($result); $user = LoadUser($planet['owner_id']); echo "<tr><th>" . date("Y-m-d H:i:s", $planet['date']) . "</th><th>" . AdminPlanetCoord($planet) . "</th>"; echo "<th><a href=\"index.php?page=admin&session={$session}&mode=Planets&cp=" . $planet['planet_id'] . "\">" . $planet['name'] . "</a></th>"; echo "<th>" . AdminUserName($user) . "</th></tr>\n"; } echo "</table>\n"; ?> </th> </tr> </table> Искать:<br> <form action="index.php?page=admin&session=<?php echo $session; ?> &mode=Planets&action=search" method="post"> <table> <tr> <th> <select name="type"> <option value="playername">Имя игрока</option> <option value="planetname" >Имя планеты</option> <option value="allytag" >Аббревиатура альянса</option> </select> <input type="text" name="searchtext" value=""/> <input type="submit" value="Искать" /> </th> </tr> </table> </form> <?php if ($SearchResult !== "") { ?> </th> </tr> </table> Результаты поиска:<br> <?php echo $SearchResult; } } }
function Admin_Bans() { global $session; global $db_prefix; global $GlobalUser; // Обработка POST-запроса. if (method() === "POST" && $GlobalUser['admin'] >= 1) { if ($_GET['action'] === 'search') { // Результаты поиска switch (intval($_POST['searchby'])) { case 0: // Забаненных с РО $query = "SELECT * FROM " . $db_prefix . "users WHERE banned = 1 AND vacation = 1"; break; case 1: // Забаненных без РО $query = "SELECT * FROM " . $db_prefix . "users WHERE banned = 1 AND vacation = 0"; break; case 2: // Блокировка атак $query = "SELECT * FROM " . $db_prefix . "users WHERE noattack = 1"; break; case 3: // Зарегистрированных недавно (дней) $when = time() - intval($_POST['text']) * 24 * 60 * 60; $query = "SELECT * FROM " . $db_prefix . "users WHERE regdate >= {$when}"; break; case 4: // Имя пользователя (примерное) $query = "SELECT * FROM " . $db_prefix . "users WHERE oname LIKE '" . $_POST['text'] . "%' "; break; case 5: // Тег альянса $query = "SELECT ally_id FROM " . $db_prefix . "ally WHERE tag LIKE '%" . $_POST['text'] . "%' "; $query = "SELECT * FROM " . $db_prefix . "users WHERE ally_id = ANY ({$query}) "; break; case 6: // Одинаковый адрес email $query = "SELECT * FROM " . $db_prefix . "users WHERE email = LIKE '%" . $_POST['text'] . "%' OR pemail = LIKE '%" . $_POST['text'] . "%' "; break; case 7: // Одинаковый IP $query = "SELECT * FROM " . $db_prefix . "users AS t1 INNER JOIN ( \r\nSELECT ip_addr,COUNT(*) FROM " . $db_prefix . "users GROUP BY ip_addr HAVING COUNT(*)>1) as t2 \r\nON t1.ip_addr = t2.ip_addr ORDER BY t1.ip_addr ASC, t1.name ASC"; break; default: $query = ''; } $result = dbquery($query); $rows0 = $rows = dbrows($result); echo AdminPanel(); ?> <script> function SetClearCheckbox (status) { var theForm = document.getElementById('banform'); for (i=0,n=theForm.elements.length;i<n;i++) { if (theForm.elements[i].className.indexOf('ids') !=-1) { theForm.elements[i].checked = status; } } } </script> <!-- Результаты поиска --> <table> <form id="banform" action="index.php?page=admin&session=<?php echo $session; ?> &mode=Bans&action=ban" method="POST" > <tr> <td class=c> <input type="checkbox" onclick="SetClearCheckbox(this.checked);"> ID</td> <td class=c>Имя</td> <td class=c>Главная планета</td> <td class=c>Постоянный адрес</td> <td class=c>Временный адрес</td> <td class=c>IP адрес</td> <td class=c>Дата регистрации</td> </td> <?php if ($rows == 0) { echo "<tr><td colspan=7>Ничего не найдено. <a href=\"index.php?page=admin&session={$session}&mode=Bans\">Назад</a></td></tr>"; } while ($rows--) { $user = dbarray($result); $hp = GetPlanet($user['hplanetid']); ?> <tr> <th><input type="checkbox" name="id[<?php echo $user['player_id']; ?> ]" class="ids"/><?php echo $user['player_id']; ?> </th> <th><a><?php echo AdminUserName($user); ?> </a></th> <th><?php echo AdminPlanetCoord($hp); ?> <?php echo AdminPlanetName($hp); ?> </th> <th><a><?php echo $user['pemail']; ?> </a></th> <th><a><?php echo $user['email']; ?> </a></th> <th><?php echo $user['ip_addr']; ?> </th> <th><?php echo date("m-d-Y H:i:s", $user['regdate']); ?> </th> </tr> <?php } // while if ($rows0 > 0) { ?> <tr><td class=c colspan=7>Действия</td></tr> <tr> <td colspan=6> <input type="radio" name="banmode" value="0"> <font color=firebrick><b>Бан без РО</b></font> <input type="radio" name="banmode" value="1" checked > <font color=red><b>Бан с РО</b></font> <input type="radio" name="banmode" value="2"> <font color=yellow><b>Блок атак</b></font> <input type="radio" name="banmode" value="3"> <font color=lime><b>Разбанить</b></font> <input type="radio" name="banmode" value="4"> <font color=lime><b>Разрешить атаки</b></font> </td> <td><input name="days" type="text" size="5"> дней <input name="hours" type="text" size="3"> часов</td> </tr> <tr><th colspan=6> Причина: <textarea cols=40 rows=4 name="reason"><?php echo "[url=mailto:" . $GlobalUser['pemail'] . "]контакт[/url]"; ?> </textarea></th><th><input type="submit" value="Отправить"></th></tr> </form> </table> <?php } die; } if ($_GET['action'] === 'ban') { // Забанить / разбанить $now = time(); $reason = str_replace('\\"', """, bb($_POST['reason'])); $reason = str_replace('\'', "’", $reason); $reason = str_replace('\\`', "‘", $reason); $seconds = intval($_POST['days']) * 24 * 60 * 60 + intval($_POST['hours']) * 60 * 60; foreach ($_POST['id'] as $player_id => $checked) { $user = LoadUser($player_id); switch (intval($_POST['banmode'])) { case 0: // Добавить пользователя на столб позора $entry = array(null, $GlobalUser['oname'], $user['oname'], $GlobalUser['player_id'], $user['player_id'], $now, $now + $seconds, $reason); AddDBRow($entry, "pranger"); BanUser($player_id, $seconds, 0); break; case 1: // Добавить пользователя на столб позора $entry = array(null, $GlobalUser['oname'], $user['oname'], $GlobalUser['player_id'], $user['player_id'], $now, $now + $seconds, $reason); AddDBRow($entry, "pranger"); BanUser($player_id, $seconds, 1); break; case 2: // Добавить пользователя на столб позора $entry = array(null, $GlobalUser['oname'], $user['oname'], $GlobalUser['player_id'], $user['player_id'], $now, $now + $seconds, $reason); AddDBRow($entry, "pranger"); BanUserAttacks($player_id, $seconds); break; case 3: UnbanUser($player_id); break; case 4: UnbanUserAttacks($player_id); break; } } // for } } ?> <!-- Форма поиска --> <?php echo AdminPanel(); ?> <table> <form action="index.php?page=admin&session=<?php echo $session; ?> &mode=Bans&action=search" method="POST" > <tr><td class="c" colspan=2>Найти пользователей</td></tr> <tr> <td> <select name="searchby"> <option value="0">Забаненных с РО</option> <option value="1">Забаненных без РО</option> <option value="2">Блокировка атак</option> <option value="3">Зарегистрированных недавно (дней)</option> <option value="4">Имя пользователя (примерное)</option> <option value="5">Тег альянса</option> <option value="6">Одинаковый адрес email</option> <option value="7">Одинаковый IP</option> </select> </td> <td> <input type="text" name="text" size=20></td> </tr> <tr><td class="c" colspan=2> <input type="submit" value="Отправить" /></td></tr> </form> </table> <?php }
function Admin_Fleetlogs() { global $session; global $db_prefix; global $GlobalUser; $now = time(); // Обработка POST-запросов. $player_id = 0; if (method() === "POST" && $GlobalUser['admin'] >= 2) { if (key_exists("order_2min", $_POST)) { // -2 минуты до оконачания задания $id = intval($_POST['order_2min']); $queue = LoadQueue($id); $fleet_obj = LoadFleet($queue['sub_id']); if ($fleet_obj['union_id']) { UpdateUnionTime($fleet_obj['union_id'], $now + 2 * 60, 0, true); } else { $query = "UPDATE " . $db_prefix . "queue SET end=" . ($now + 2 * 60) . " WHERE task_id={$id}"; dbquery($query); } } if (key_exists("order_end", $_POST)) { // Завершить задание $id = intval($_POST['order_end']); $queue = LoadQueue($id); $fleet_obj = LoadFleet($queue['sub_id']); if ($fleet_obj['union_id']) { UpdateUnionTime($fleet_obj['union_id'], $now, 0, true); } else { $query = "UPDATE " . $db_prefix . "queue SET end={$now} WHERE task_id={$id}"; dbquery($query); } } if (key_exists("order_return", $_POST)) { // Развернуть флот $queue = LoadQueue(intval($_POST['order_return'])); RecallFleet($queue['sub_id']); } } $query = "SELECT * FROM " . $db_prefix . "queue WHERE type='Fleet' ORDER BY end ASC"; $result = dbquery($query); $anz = $rows = dbrows($result); $bxx = 1; AdminPanel(); echo "<table>\n"; echo "<tr><td class=c>N</td> <td class=c>Таймер</td> <td class=c>Задание</td> <td class=c>Отправлен</td> <td class=c>Прибывает</td><td class=c>Время полёта</td> <td class=c>Старт</td> <td class=c>Цель</td> <td class=c>Флот</td> <td class=c>Груз</td> <td class=c>Топливо</td> <td class=c>САБ</td> <td class=c colspan=3>Приказ</td> </tr>\n"; while ($rows--) { $queue = dbarray($result); $fleet_obj = LoadFleet($queue['sub_id']); $fleet_price = FleetPrice($fleet_obj); $points = $fleet_price['points']; $fpoints = $fleet_price['fpoints']; $style = ""; if ($points >= 100000000) { if ($fleet_obj['mission'] <= 2) { $style = " style=\"background-color: FireBrick;\" "; } else { $style = " style=\"background-color: DarkGreen;\" "; } } ?> <tr <?php echo $style; ?> > <th <?php echo $style; ?> > <?php echo $bxx; ?> </th> <th <?php echo $style; ?> > <?php echo "<table><tr {$style} ><th {$style} ><div id='bxx" . $bxx . "' title='" . ($queue['end'] - $now) . "' star='" . $queue['start'] . "'> </th>"; echo "<tr><th {$style} >" . date("d.m.Y H:i:s", $queue['end']) . "</th></tr></table>"; ?> </th> <th <?php echo $style; ?> > <?php echo FleetlogsMissionText($fleet_obj['mission']); ?> </th> <th <?php echo $style; ?> ><?php echo date("d.m.Y", $queue['start']); ?> <br> <?php echo date("H:i:s", $queue['start']); ?> </th> <th <?php echo $style; ?> ><?php echo date("d.m.Y", $queue['end']); ?> <br> <?php echo date("H:i:s", $queue['end']); ?> </th> <th <?php echo $style; ?> > <?php echo "<nobr>" . BuildDurationFormat($fleet_obj['flight_time']) . "</nobr><br>"; echo "<nobr>" . $fleet_obj['flight_time'] . " сек.</nobr>"; ?> </th> <th <?php echo $style; ?> > <?php $planet = GetPlanet($fleet_obj['start_planet']); $user = LoadUser($planet['owner_id']); echo AdminPlanetName($planet) . " " . AdminPlanetCoord($planet) . " <br>"; echo AdminUserName($user); ?> </th> <th <?php echo $style; ?> > <?php $planet = GetPlanet($fleet_obj['target_planet']); $user = LoadUser($planet['owner_id']); echo AdminPlanetName($planet) . " " . AdminPlanetCoord($planet) . " <br>"; echo AdminUserName($user); ?> </th> <th <?php echo $style; ?> > <?php $fleetmap = array(202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215); foreach ($fleetmap as $i => $gid) { $amount = $fleet_obj["ship" . $gid]; if ($amount > 0) { echo loca("NAME_{$gid}") . ":" . nicenum($amount) . " "; } } ?> </th> <th <?php echo $style; ?> > <?php $total = $fleet_obj['m'] + $fleet_obj['k'] + $fleet_obj['d']; if ($total > 0) { echo "М: " . nicenum($fleet_obj['m']) . "<br>"; echo "К: " . nicenum($fleet_obj['k']) . "<br>"; echo "Д: " . nicenum($fleet_obj['d']); } else { echo "-"; } ?> </th> <th <?php echo $style; ?> > <?php echo nicenum($fleet_obj['fuel']); ?> </th> <th <?php echo $style; ?> > <?php if ($fleet_obj['union_id']) { echo $fleet_obj['union_id']; } else { echo "-"; } ?> </th> <th <?php echo $style; ?> > <form action="index.php?page=admin&session=<?php echo $session; ?> &mode=Fleetlogs" method="POST"> <input type="hidden" name="order_2min" value="<?php echo $queue['task_id']; ?> " /> <input type="submit" value="2m" /> </form> </th> <th <?php echo $style; ?> > <form action="index.php?page=admin&session=<?php echo $session; ?> &mode=Fleetlogs" method="POST"> <input type="hidden" name="order_end" value="<?php echo $queue['task_id']; ?> " /> <input type="submit" value="F" /> </form> </th><th <?php echo $style; ?> > <form action="index.php?page=admin&session=<?php echo $session; ?> &mode=Fleetlogs" method="POST"> <input type="hidden" name="order_return" value="<?php echo $queue['task_id']; ?> " /> <input type="submit" value="R" /> </form> </th> </tr> <?php $bxx++; } echo "<script language=javascript>anz={$anz};t();</script>\n"; echo "</table>\n"; }