function ShowModVersionPage()
{
global $LNG, $USER;
$MVC = array();
$Files = scandir(ROOT_PATH . 'includes/functions/mvc/');
foreach ($Files as $File) {
if (substr($File, 0, 4) == 'mvc_') {
require ROOT_PATH . 'includes/functions/mvc/' . $File;
}
}
foreach ($MVC as &$Mod) {
$Mod['description'] = $Mod['description'][$USER['lang']];
$Update = @simplexml_load_file($Mod['update']);
$Update = $Update->{$Mod}['tag'];
if (version_compare($Mod['version'], $Update->version, '<')) {
$Mod['update'] = colorRed($LNG['mvc_update_yes']);
$Mod['udetails'] = array('version' => $Update->version, 'date' => $Update->date, 'download' => $Update->download, 'announcement' => $Update->announcement);
} else {
$Mod['update'] = colorGreen($LNG['mvc_update_no']);
$Mod['udetails'] = false;
}
}
$template = new template();
$template->assign_vars(array('MVC' => $MVC, 'mvc_title' => $LNG['mvc_title'], 'mvc_author' => $LNG['mvc_author'], 'mvc_version' => $LNG['mvc_version'], 'mvc_link' => $LNG['mvc_link'], 'mvc_update_version' => $LNG['mvc_update_version'], 'mvc_update_date' => $LNG['mvc_update_date'], 'mvc_announcement' => $LNG['mvc_announcement'], 'mvc_download' => $LNG['mvc_download'], 'mvc_desc' => $LNG['mvc_desc']));
$template->show('adm/ModVersionPage.tpl');
}
function colorNumber($n, $s = '')
{
if ($n > 0) {
if ($s != '') {
$s = colorGreen($s);
} else {
$s = colorGreen($n);
}
} elseif ($n < 0) {
if ($s != '') {
$s = colorRed($s);
} else {
$s = colorRed($n);
}
} else {
if ($s != '') {
$s = $s;
} else {
$s = $n;
}
}
return $s;
}
function dumpNode($tree, $level = 0)
{
foreach ($tree as $key => $node) {
$k = '';
if (is_string($key)) {
$k = $key . ' -> ';
}
if (is_object($node)) {
echo str_repeat(" ", $level) . $k . colorGreen(get_class($node)) . "\n";
} else {
if (!is_array($node)) {
echo str_repeat(" ", $level) . $k . print_r($node, true) . "\n";
} else {
if (strlen($k) > 0) {
echo str_repeat(" ", $level) . $k . ":\n";
}
}
}
if ($node instanceof Traversable || is_array($node)) {
dumpNode($node, $level + 1);
}
}
}
function colorNumber($n, $s = '')
{
if ($n > 0) {
return empty($s) ? colorGreen($n) : colorGreen($s);
} elseif ($n < 0) {
return empty($s) ? colorRed($n) : colorRed($s);
} else {
return empty($s) ? $n : $s;
}
}
header("Location: login.php");
}
if ($user['authlevel'] != "3" && $user['authlevel'] != "1") {
header("Location: ../login.php");
}
$dpath = !$user["dpath"] ? DEFAULT_SKINPATH : $user["dpath"];
includeLang('overview');
$parse = $lang;
$parse['dpath'] = $dpath;
$parse['mf'] = $mf;
//
// Obtenemos la ultima version, pidiendo un pequeño archivo.
//
$parse['version'] = @file_get_contents('http://ugamela.sourceforge.net/lastversion.php?v=' . VERSION);
if ($parse['version'] != VERSION) {
$parse['VERSION'] = colorRed(VERSION);
} else {
$parse['VERSION'] = colorGreen(VERSION);
}
//
// Lista de usuarios conectados.
//
$query = doquery("SELECT * FROM {{table}} WHERE onlinetime>='" . (time() - 15 * 60) . "'", 'users');
$i = 0;
while ($u = mysql_fetch_array($query)) {
$parse['online_list'] .= "<tr><td class=b>" . '<a href="../messages.php?mode=write&id=' . $u['id'] . '"><img src="' . $dpath . 'img/m.gif" alt="Escribir mensaje" title="Escribir mensaje" border="0"></a> ' . "<a href=\"\">{$u['username']}</a> " . "<a style=\"color:#7f7f7f;\" href=\"http://network-tools.com/default.asp?prog=trace&host={$u['user_lastip']}\">[{$u['user_lastip']}]</a></td>" . "<td class=b>{$u['ally_name']}</td>" . "<td class=m>" . pretty_number($u['points_points'] / 1000) . "</td>" . "<td class=b>" . pretty_time(time() - $u['onlinetime']) . "</td></tr>";
$i++;
}
$parse['online_list'] .= "<tr><th class=b colspan=4>Hay {$i} usuario(s) en linea.</th></tr>";
display(parsetemplate(gettemplate('admin/overview_body'), $parse), "Overview", true);
// Created by Perberos. All rights reversed (C) 2006
echo grayScale($d, $imageHash);
}
if ($filterId == 3) {
echo brightnessH($d, $imageHash);
}
if ($filterId == 4) {
echo brightnessL($d, $imageHash);
}
if ($filterId == 5) {
echo brightnessM($d, $imageHash);
}
if ($filterId == 6) {
echo colorBlue($d, $imageHash);
}
if ($filterId == 7) {
echo colorGreen($d, $imageHash);
}
if ($filterId == 8) {
echo colorPink($d, $imageHash);
}
if ($filterId == 9) {
echo colorRed($d, $imageHash);
}
if ($filterId == 10) {
echo colorYellow($d, $imageHash);
}
if ($filterId == 11) {
echo contrastH($d, $imageHash);
}
if ($filterId == 12) {
echo contrastL($d, $imageHash);
function ShowSearchAdmin($user)
{
global $lang, $db, $displays;
if ($user['authlevel'] < 2) {
die($displays->message($lang['not_enough_permissions']));
}
$displays->assignContent('adm/search');
$id = intval($_GET['search']);
if (isset($_GET['mode'])) {
global $reslist, $resource;
$displays->newblock($_GET['mode']);
switch ($_GET['mode']) {
case 'resources':
$SelResources = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $id . "';", 'planets', true);
$SelColos = $db->query("SELECT * FROM {{table}} WHERE `id_owner` = '" . $SelResources['id_owner'] . "' ORDER BY `galaxy`, `system`, `planet` ASC;", 'planets');
while ($u = mysql_fetch_array($SelColos)) {
$displays->newblock("lista_colos_resources");
$i++;
foreach ($u as $key => $value) {
$displays->assign($key, $value);
}
}
$mode = $_POST['edit'];
$lang['id'] = $id;
$lang['name'] = $SelResources['name'];
$lang['metal'] = pretty_number($SelResources['metal']);
$lang['crystal'] = pretty_number($SelResources['crystal']);
$lang['deuterium'] = pretty_number($SelResources['deuterium']);
$lang['galaxy'] = $SelResources['galaxy'];
$lang['system'] = $SelResources['system'];
$lang['planet'] = $SelResources['planet'];
if ($mode == 'addit') {
$accion = $_POST['accion'];
$metal = $_POST['metal'];
$cristal = $_POST['cristal'];
$deut = $_POST['deut'];
if (is_numeric($accion . $metal) && is_numeric($accion . $cristal) && is_numeric($accion . $deut)) {
$QryUpdateResources = "UPDATE {{table}} SET ";
$QryUpdateResources .= "`metal` = `metal` " . $accion . " '" . $metal . "', ";
$QryUpdateResources .= "`crystal` = `crystal` " . $accion . " '" . $cristal . "', ";
$QryUpdateResources .= "`deuterium` = `deuterium` " . $accion . " '" . $deut . "' ";
$QryUpdateResources .= "WHERE ";
$QryUpdateResources .= "`id` = '" . $id . "' ";
$db->query($QryUpdateResources, "planets");
$displays->message($lang['ad_sucess'], "admin.php?page=search&mode=resources&search=" . $id . "", 1);
} else {
$displays->message($lang['ad_numeric'], "admin.php?page=search&mode=resources&search=" . $id . "", 1);
}
}
break;
case 'buildings':
$SelBuilds = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $id . "';", 'planets', true);
$SelColos = $db->query("SELECT * FROM {{table}} WHERE `id_owner` = '" . $SelBuilds['id_owner'] . "' ORDER BY `galaxy`, `system`, `planet` ASC;", 'planets');
while ($u = mysql_fetch_array($SelColos)) {
$displays->newblock("lista_colos_buildings");
$i++;
foreach ($u as $key => $value) {
$displays->assign($key, $value);
}
}
$mode = $_POST['edit'];
$lang['id'] = $id;
$lang['name'] = $SelBuilds['name'];
$lang['galaxy'] = $SelBuilds['galaxy'];
$lang['system'] = $SelBuilds['system'];
$lang['planet'] = $SelBuilds['planet'];
foreach ($reslist['build'] as $key) {
$displays->newblock("buildings_list");
$name = $resource[$key];
$displays->assign("count", pretty_number($SelBuilds[$name]));
$displays->assign("name", $name);
$displays->assign("name_lang", $lang['tech'][$key]);
}
if ($mode == 'addit') {
extract($_POST);
if (is_numeric($accion . "1")) {
$QryUpdateBuilds = "UPDATE {{table}} SET ";
foreach ($reslist['build'] as $key) {
$name = $resource[$key];
$input = ${$name};
if (is_numeric($accion . $input) && $input != 0) {
if ($count_query == 0) {
$QryUpdateBuilds .= "" . $name . " = " . $name . " " . $accion . " '" . $input . "' ";
} else {
$QryUpdateBuilds .= ", " . $name . " = " . $name . " " . $accion . " '" . $input . "' ";
}
++$count_query;
}
}
$QryUpdateBuilds .= "WHERE ";
$QryUpdateBuilds .= "`id` = '" . $id . "' ";
$count_query != 0 ? $db->query($QryUpdateBuilds, "planets") : "";
$displays->message($lang['ad_sucess'], "admin.php?page=search&mode=defenses&search=" . $id . "", 2);
} else {
$displays->message($lang['ad_numeric'], "admin.php?page=search&mode=defenses&search=" . $id . "", 1);
}
}
break;
case 'ships':
$SelShips = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $id . "';", 'planets', true);
$SelColos = $db->query("SELECT * FROM {{table}} WHERE `id_owner` = '" . $SelShips['id_owner'] . "' ORDER BY `galaxy`, `system`, `planet` ASC;", 'planets');
while ($u = mysql_fetch_array($SelColos)) {
$displays->newblock("lista_colos_ships");
$i++;
foreach ($u as $key => $value) {
$displays->assign($key, $value);
}
}
$mode = $_POST['edit'];
$lang['id'] = $id;
$lang['name'] = $SelShips['name'];
$lang['galaxy'] = $SelShips['galaxy'];
$lang['system'] = $SelShips['system'];
$lang['planet'] = $SelShips['planet'];
foreach ($reslist['fleet'] as $key) {
$displays->newblock("ships_list");
$name = $resource[$key];
$displays->assign("count", pretty_number($SelShips[$name]));
$displays->assign("name", $name);
$displays->assign("name_lang", $lang['tech'][$key]);
}
if ($mode == 'addit') {
extract($_POST);
if (is_numeric($accion . "1")) {
$QryUpdateShips = "UPDATE {{table}} SET ";
foreach ($reslist['fleet'] as $key) {
$name = $resource[$key];
$input = ${$name};
if (is_numeric($accion . $input) && $input != 0) {
if ($count_query == 0) {
$QryUpdateShips .= "" . $name . " = " . $name . " " . $accion . " '" . $input . "' ";
} else {
$QryUpdateShips .= ", " . $name . " = " . $name . " " . $accion . " '" . $input . "' ";
}
++$count_query;
}
}
$QryUpdateShips .= "WHERE ";
$QryUpdateShips .= "`id` = '" . $id . "' ";
$count_query != 0 ? $db->query($QryUpdateShips, "planets") : "";
$displays->message($lang['ad_sucess'], "admin.php?page=search&mode=ships&search=" . $id . "", 2);
} else {
$displays->message($lang['ad_numeric'], "admin.php?page=search&mode=ships&search=" . $id . "", 1);
}
}
break;
case 'defenses':
$SelDefenses = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $id . "';", 'planets', true);
$SelColos = $db->query("SELECT * FROM {{table}} WHERE `id_owner` = '" . $SelDefenses['id_owner'] . "' ORDER BY `galaxy`, `system`, `planet` ASC;", 'planets');
while ($u = mysql_fetch_array($SelColos)) {
$displays->newblock("lista_colos_defenses");
$i++;
foreach ($u as $key => $value) {
$displays->assign($key, $value);
}
}
$mode = $_POST['edit'];
$lang['id'] = $id;
$lang['name'] = $SelDefenses['name'];
$lang['galaxy'] = $SelDefenses['galaxy'];
$lang['system'] = $SelDefenses['system'];
$lang['planet'] = $SelDefenses['planet'];
foreach ($reslist['defense'] as $key) {
$displays->newblock("defense_list");
$name = $resource[$key];
$displays->assign("count", pretty_number($SelDefenses[$name]));
$displays->assign("name", $name);
$displays->assign("name_lang", $lang['tech'][$key]);
}
if ($mode == 'addit') {
extract($_POST);
if (is_numeric($accion . "1")) {
$QryUpdateDefenses = "UPDATE {{table}} SET ";
foreach ($reslist['defense'] as $key) {
$name = $resource[$key];
$input = ${$name};
if (is_numeric($accion . $input) && $input != 0) {
if ($count_query == 0) {
$QryUpdateDefenses .= "" . $name . " = " . $name . " " . $accion . " '" . $input . "' ";
} else {
$QryUpdateDefenses .= ", " . $name . " = " . $name . " " . $accion . " '" . $input . "' ";
}
++$count_query;
}
}
$QryUpdateDefenses .= "WHERE ";
$QryUpdateDefenses .= "`id` = '" . $id . "' ";
$count_query != 0 ? $db->query($QryUpdateDefenses, "planets") : "";
$displays->message($lang['ad_sucess'], "admin.php?page=search&mode=defenses&search=" . $id . "", 2);
} else {
$displays->message($lang['ad_numeric'], "admin.php?page=search&mode=defenses&search=" . $id . "", 1);
}
}
break;
case 'researchs':
$SelResearch = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $id . "';", 'users', true);
$mode = $_POST['edit'];
$lang['id'] = $id;
$lang['name'] = $SelResearch['name'];
foreach ($reslist['tech'] as $key) {
$displays->newblock("research_list");
$name = $resource[$key];
$displays->assign("count", pretty_number($SelResearch[$name]));
$displays->assign("name", $name);
$displays->assign("name_lang", $lang['tech'][$key]);
}
if ($mode == 'addit') {
extract($_POST);
if (is_numeric($accion . "1")) {
$QryUpdateResearch = "UPDATE {{table}} SET ";
foreach ($reslist['build'] as $key) {
$name = $resource[$key];
$input = ${$name};
if (is_numeric($accion . $input) && $input != 0) {
if ($count_query == 0) {
$QryUpdateResearch .= "" . $name . " = " . $name . " " . $accion . " '" . $input . "' ";
} else {
$QryUpdateResearch .= ", " . $name . " = " . $name . " " . $accion . " '" . $input . "' ";
}
++$count_query;
}
}
$QryUpdateResearch .= "WHERE ";
$QryUpdateResearch .= "`id` = '" . $id . "' ";
$count_query != 0 ? $db->query($QryUpdateResearch, "planets") : "";
$displays->message($lang['ad_sucess'], "admin.php?page=search&mode=defenses&search=" . $id . "", 2);
} else {
$displays->message($lang['ad_numeric'], "admin.php?page=search&mode=defenses&search=" . $id . "", 1);
}
}
break;
case 'oficers':
$SelOficer = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $id . "';", 'users', true);
$mode = $_POST['edit'];
$lang['id'] = $id;
$lang['name'] = $SelOficer['name'];
foreach ($reslist['officier'] as $key) {
$displays->newblock("oficers_list");
$name = $resource[$key];
$displays->assign("count", pretty_number($SelOficer[$name]));
$displays->assign("name", $name);
$displays->assign("name_lang", $lang['tech'][$key]);
}
if ($mode == 'addit') {
extract($_POST);
if (is_numeric($accion . "1")) {
$QryUpdateOficer = "UPDATE {{table}} SET ";
foreach ($reslist['officier'] as $key) {
$name = $resource[$key];
$input = ${$name};
if (is_numeric($accion . $input) && $input != 0) {
if ($count_query == 0) {
$QryUpdateOficer .= "" . $name . " = " . $name . " " . $accion . " '" . $input . "' ";
} else {
$QryUpdateOficer .= ", " . $name . " = " . $name . " " . $accion . " '" . $input . "' ";
}
++$count_query;
}
}
$QryUpdateOficer .= "WHERE ";
$QryUpdateOficer .= "`id` = '" . $id . "' ";
$count_query != 0 ? $db->query($QryUpdateOficer, "planets") : "";
$displays->message($lang['ad_sucess'], "admin.php?page=search&mode=oficers&search=" . $id . "", 2);
} else {
$displays->message($lang['ad_numeric'], "admin.php?page=search&mode=oficers&search=" . $id . "", 1);
}
}
break;
case 'planets':
$SelPlanet = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $id . "';", 'planets', true);
$SelColos = $db->query("SELECT * FROM {{table}} WHERE `id_owner` = '" . $SelPlanet['id_owner'] . "' ORDER BY `galaxy`, `system`, `planet` ASC;", 'planets');
while ($u = mysql_fetch_array($SelColos)) {
$displays->newblock("lista_colos_planets");
$i++;
foreach ($u as $key => $value) {
$displays->assign($key, $value);
}
}
$mode = $_POST['edit'];
$lang['id'] = $id;
$lang['name'] = $SelPlanet['name'];
$lang['diameter'] = pretty_number($SelPlanet['diameter']);
$lang['field_max'] = pretty_number($SelPlanet['field_max']);
$lang['galaxy'] = $SelPlanet['galaxy'];
$lang['system'] = $SelPlanet['system'];
$lang['planet'] = $SelPlanet['planet'];
$lang['temp_min'] = $SelPlanet['temp_min'];
$lang['temp_max'] = $SelPlanet['temp_max'];
if ($SelPlanet['b_building_id'] == 0) {
$lang['b_building_id'] = colorRed($lang['ad_empty']);
} else {
$lang['b_building_id'] = $SelPlanet['b_building_id'];
}
if ($SelPlanet['b_hangar_id'] == "") {
$lang['b_hangar_id'] = colorRed($lang['ad_empty']);
} else {
$lang['b_hangar_id'] = $SelPlanet['b_hangar_id'];
}
$mode = $_POST['edit'];
if ($mode == 'addit') {
$name = $_POST['name'];
$change_id = $_POST['change_id'];
$diameter = $_POST['diameter'];
$fields = $_POST['fields'];
$galaxy = $_POST['g'];
$system = $_POST['s'];
$planet = $_POST['p'];
$t_min = $_POST['temp_min'];
$t_max = $_POST['temp_max'];
$buildings = $_POST['0_buildings'];
$ships = $_POST['0_ships'];
$defenses = $_POST['0_defenses'];
$c_hangar = $_POST['0_c_hangar'];
$c_buildings = $_POST['0_c_buildings'];
$change_pos = $_POST['change_position'];
$delete = $_POST['delete'];
$accion = $_POST['accion'];
if ($delete != 'on') {
if ($name != NULL) {
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`name` = '" . $name . "' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '" . $id . "' ";
$db->query($QryUpdatePlanet, "planets");
}
if ($buildings == 'on') {
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`metal_mine` = '0', ";
$QryUpdatePlanet .= "`crystal_mine` = '0', ";
$QryUpdatePlanet .= "`deuterium_sintetizer` = '0', ";
$QryUpdatePlanet .= "`solar_plant` = '0', ";
$QryUpdatePlanet .= "`fusion_plant` = '0', ";
$QryUpdatePlanet .= "`robot_factory` = '0', ";
$QryUpdatePlanet .= "`nano_factory` = '0', ";
$QryUpdatePlanet .= "`hangar` = '0', ";
$QryUpdatePlanet .= "`metal_store` = '0', ";
$QryUpdatePlanet .= "`crystal_store` = '0', ";
$QryUpdatePlanet .= "`deuterium_store` = '0', ";
$QryUpdatePlanet .= "`laboratory` = '0', ";
$QryUpdatePlanet .= "`terraformer` = '0', ";
$QryUpdatePlanet .= "`ally_deposit` = '0', ";
$QryUpdatePlanet .= "`silo` = '0', ";
$QryUpdatePlanet .= "`mondbasis` = '0', ";
$QryUpdatePlanet .= "`phalanx` = '0', ";
$QryUpdatePlanet .= "`sprungtor` = '0', ";
$QryUpdatePlanet .= "`last_jump_time` = '0', ";
$QryUpdatePlanet .= "`field_current` = '0' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '" . $id . "' ";
$db->query($QryUpdatePlanet, "planets");
}
if ($ships == 'on') {
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`small_ship_cargo` = '0', ";
$QryUpdatePlanet .= "`big_ship_cargo` = '0', ";
$QryUpdatePlanet .= "`light_hunter` = '0', ";
$QryUpdatePlanet .= "`heavy_hunter` = '0', ";
$QryUpdatePlanet .= "`crusher` = '0', ";
$QryUpdatePlanet .= "`battle_ship` = '0', ";
$QryUpdatePlanet .= "`colonizer` = '0', ";
$QryUpdatePlanet .= "`recycler` = '0', ";
$QryUpdatePlanet .= "`spy_sonde` = '0', ";
$QryUpdatePlanet .= "`bomber_ship` = '0', ";
$QryUpdatePlanet .= "`solar_satelit` = '0', ";
$QryUpdatePlanet .= "`destructor` = '0', ";
$QryUpdatePlanet .= "`dearth_star` = '0', ";
$QryUpdatePlanet .= "`battleship` = '0', ";
$QryUpdatePlanet .= "`supernova` = '0' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '" . $id . "' ";
$db->query($QryUpdatePlanet, "planets");
}
if ($defenses == 'on') {
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`misil_launcher` = '0', ";
$QryUpdatePlanet .= "`small_laser` = '0', ";
$QryUpdatePlanet .= "`big_laser` = '0', ";
$QryUpdatePlanet .= "`gauss_canyon` = '0', ";
$QryUpdatePlanet .= "`ionic_canyon` = '0', ";
$QryUpdatePlanet .= "`buster_canyon` = '0', ";
$QryUpdatePlanet .= "`small_protection_shield` = '0', ";
$QryUpdatePlanet .= "`planet_protector` = '0', ";
$QryUpdatePlanet .= "`big_protection_shield` = '0', ";
$QryUpdatePlanet .= "`interceptor_misil` = '0', ";
$QryUpdatePlanet .= "`interceptor_misil` = '0' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '" . $id . "' ";
$db->query($QryUpdatePlanet, "planets");
}
if ($c_hangar == 'on') {
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`b_hangar` = '0', ";
$QryUpdatePlanet .= "`b_hangar_plus` = '0', ";
$QryUpdatePlanet .= "`b_hangar_id` = '' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '" . $id . "' ";
$db->query($QryUpdatePlanet, "planets");
}
if ($c_buildings == 'on') {
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`b_building` = '0', ";
$QryUpdatePlanet .= "`b_building_id` = '' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '" . $id . "' ";
$db->query($QryUpdatePlanet, "planets");
}
if ($diameter != NULL && is_numeric($diameter) && $diameter > 0) {
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`diameter` = '" . $diameter . "' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '" . $id . "' ";
$db->query($QryUpdatePlanet, "planets");
}
if ($fields != NULL && is_numeric($fields) && $fields > 0) {
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`field_max` = '" . $fields . "' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '" . $id . "' ";
$db->query($QryUpdatePlanet, "planets");
}
if ($t_min != NULL && is_numeric($t_min)) {
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`temp_min` = '" . $t_min . "' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '" . $id . "' ";
$db->query($QryUpdatePlanet, "planets");
}
if ($t_max != NULL && is_numeric($t_max)) {
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`temp_max` = '" . $t_max . "' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '" . $id . "' ";
$db->query($QryUpdatePlanet, "planets");
}
$P = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $id . "'", "planets", true);
if ($change_pos == 'on') {
if (is_numeric($galaxy) && is_numeric($system) && is_numeric($planet) && $galaxy > 0 && $system > 0 && $planet > 0 && $galaxy <= MAX_GALAXY_IN_WORLD && $system <= MAX_SYSTEM_IN_GALAXY && $planet <= MAX_PLANET_IN_SYSTEM) {
$Queryyy = $db->query("SELECT * FROM {{table}} WHERE `galaxy` = '" . $galaxy . "' AND `system` = '" . $system . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t`planet` = '" . $planet . "'", "galaxy", true);
$PP = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $P['id_owner'] . "'", "users", true);
if ($P['planet_type'] == '1') {
if (!$Queryyy) {
if ($Queryyy['id_luna'] != '0') {
$db->query("UPDATE {{table}} SET `galaxy` = '" . $galaxy . "', `system` = '" . $system . "', `planet` = '" . $planet . "' WHERE\r\n\t\t\t\t\t\t\t\t\t\t`galaxy` = '" . $P['galaxy'] . "' AND `system` = '" . $P['system'] . "' AND `planet` = '" . $P['planet'] . "' AND `planet_type` = '3'", "planets");
}
if ($PP['galaxy'] == $galaxy && $PP['system'] == $system && $PP['planet'] == $planet) {
$db->query("UPDATE {{table}} SET `galaxy` = '" . $galaxy . "', `system` = '" . $system . "', `planet` = '" . $planet . "' WHERE\r\n\t\t\t\t\t\t\t\t\t\t`id` = '" . $P['id_owner'] . "'", "users");
}
$db->query("UPDATE {{table}} SET `galaxy` = '" . $galaxy . "', `system` = '" . $system . "', `planet` = '" . $planet . "' WHERE\r\n\t\t\t\t\t\t\t\t\t\t`id` = '" . $id . "'", "planets");
$db->query("UPDATE {{table}} SET `galaxy` = '" . $galaxy . "', `system` = '" . $system . "', `planet` = '" . $planet . "' WHERE\r\n\t\t\t\t\t\t\t\t\t\t`id_planet` = '" . $id . "'", "galaxy");
$Name = $lang['log_planet_pos'];
} else {
$Error .= '<tr><th colspan="3"><font color=red>' . $lang['ad_pla_error_planets3'] . '</font></th></tr>';
}
} elseif ($P['planet_type'] == '3') {
if ($Queryyy) {
if ($Queryyy['id_luna'] == '0') {
$db->query("UPDATE {{table}} SET `id_luna` = '0' WHERE `galaxy` = '" . $P['galaxy'] . "' AND `system` = '" . $P['system'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t`planet` = '" . $P['planet'] . "'", "galaxy");
$db->query("UPDATE {{table}} SET `galaxy` = '" . $galaxy . "', `system` = '" . $system . "', `planet` = '" . $planet . "',\r\n\t\t\t\t\t\t\t\t\t\t`id_luna` = '" . $id . "' WHERE `id_planet` = '" . $Queryyy['id_planet'] . "'", "galaxy");
$QMOON2 = doquery("SELECT * FROM {{table}} WHERE `galaxy` = '" . $galaxy . "' AND `system` = '" . $system . "' AND\r\n\t\t\t\t\t\t\t\t\t\t`planet` = '" . $planet . "'", "planets", true);
$db->query("UPDATE {{table}} SET `galaxy` = '" . $galaxy . "', `system` = '" . $system . "', `planet` = '" . $planet . "',\r\n\t\t\t\t\t\t\t\t\t\t`id_owner` = '" . $QMOON2['id_owner'] . "', `id_level` = '" . $QMOON2['id_level'] . "' WHERE `id` = '" . $id . "' AND `planet_type` = '3'", "planets");
$Name = $lang['log_moon_pos'];
} else {
$Error .= '<tr><th colspan="3"><font color=red>' . $lang['ad_pla_error_planets4'] . '</font></th></tr>';
}
} else {
$Error .= '<tr><th colspan="3"><font color=red>' . $lang['ad_pla_error_planets5'] . '</font></th></tr>';
}
}
$Log .= $lang['log_change_pla_pos'] . $Name . ": [" . $galaxy . ":" . $system . ":" . $planet . "]\n";
} else {
$Error .= '<tr><th colspan="3"><font color=red>' . $lang['ad_only_numbers'] . '</font></th></tr>';
}
}
} else {
$QueryPlanetsS = $db->query("SELECT planet_type FROM {{table}} WHERE id = '" . $id . "'", "planets", true);
if ($QueryPlanetsS['planet_type'] == '1') {
$db->query("DELETE FROM {{table}} WHERE id = '" . $id . "'", "planets");
$db->query("DELETE FROM {{table}} WHERE id_planet = '" . $id . "'", "galaxy");
} else {
$db->query("DELETE FROM {{table}} WHERE id = '" . $id . "'", "planets");
$db->query("UPDATE {{table}} SET id_luna = '0', luna = '0' WHERE id_luna = '" . $id . "'", "galaxy");
}
// MENSAJE PLANETA BORRADO $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_pla_delete_planet_s'].'</font></th></tr>';
}
$displays->message($lang['ad_sucess'], "admin.php?page=editor&mode=planets&search=" . $id . "", 1);
}
break;
case 'users':
$SelUser = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $id . "';", 'users', true);
$SelColos = $db->query("SELECT * FROM {{table}} WHERE `id_owner` = '" . $SelUser['id'] . "' ORDER BY `galaxy`, `system`, `planet` ASC;", 'planets');
while ($u = mysql_fetch_array($SelColos)) {
$displays->newblock("lista_colos_users");
$i++;
$u['activity'] = pretty_time(time() - $u['last_update']);
if ($u['planet_type'] == 1) {
$u['type'] = "Planeta";
} else {
$u['type'] = "Luna";
}
foreach ($u as $key => $value) {
$displays->assign($key, $value);
}
}
$mode = $_POST['edit'];
$lang['id'] = $id;
$lang['username'] = $SelUser['username'];
$lang['password'] = $SelUser['password'];
$lang['email'] = $SelUser['email'];
$lang['email2'] = $SelUser['email_2'];
$lang['ip_at_reg'] = $SelUser['ip_at_reg'];
$lang['register'] = date("G:i:s | d M y", $SelUser['register_time']);
$lang['lastlogin'] = date("G:i:s | d M y", $SelUser['user_lastlogin']);
$lang['user_lastip'] = $SelUser['user_lastip'];
$lang['dpath'] = $SelUser['dpath'];
$lang['authlevel_s'] = $lang['user_level'][$SelUser['authlevel']];
$lang["levels_" . $SelUser['authlevel']] = "selected='selected'";
if ($SelUser['activate_status'] == 1) {
$lang['activate'] = colorRed($lang['ad_activatenone']);
} else {
$lang['activate'] = colorGreen($lang['ad_activateok']);
}
if ($SelUser['design'] == 0) {
$lang['design'] = colorRed($lang['ad_activatenone']);
} else {
$lang['design'] = colorGreen($lang['ad_activateok']);
}
if ($SelUser['noipcheck'] == 0) {
$lang['noipcheck'] = colorRed($lang['ad_activatenone']);
} else {
$lang['noipcheck'] = colorGreen($lang['ad_activateok']);
}
if ($SelUser['urlaubs_modus'] == 0) {
$lang['vacations'] = colorRed($lang['ad_activatenone']);
} else {
$lang['vacations'] = colorGreen($lang['ad_activateok']);
}
if ($SelUser['urlaubs_until'] == 0) {
$lang['duration'] = colorRed($lang['ad_activatenone']);
} else {
$lang['duration'] = date("d/m/Y G:i:s", $SelUser['urlaubs_until']);
}
if ($mode == 'addit') {
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
$email2 = $_POST['email2'];
$activate = $_POST['activate'];
$dpath = $_POST['dpath'];
$design = $_POST['design'];
$noipcheck = $_POST['noipcheck'];
$authlevel = $_POST['authlevel'];
$vacations = $_POST['vacations'];
$d = $_POST['d'];
$h = $_POST['h'];
$QueryUsers = "UPDATE {{table}} SET ";
if ($username != NULL) {
$QueryUsers .= "`username` = '" . $username . "', ";
}
if ($password != NULL) {
$QueryUsers .= "`password` = '" . md5($password) . "', ";
}
if ($email != NULL) {
$QueryUsers .= "`email` = '" . $email . "', ";
}
if ($email_2 != NULL) {
$QueryUsers .= "`email_2` = '" . $email2 . "', ";
}
if ($activate != '') {
if ($activate == 'yes') {
$QueryUsers .= "`activate_status` = '1', ";
} elseif ($activate == 'no') {
$QueryUsers .= "`activate_status` = '0', ";
}
}
if ($dpath != NULL) {
$QueryUsers .= "`dpath` = '" . $dpath . "', ";
}
if ($design != '') {
if ($design == 'no') {
$QueryUsers .= "`design` = '0', ";
} elseif ($design == 'yes') {
$QueryUsers .= "`design` = '1', ";
}
}
if ($noipcheck != '') {
if ($noipcheck == 'no') {
$QueryUsers .= "`noipcheck` = '0', ";
} elseif ($noipcheck == 'yes') {
$QueryUsers .= "`noipcheck` = '1', ";
}
}
if ($authlevel != NULL) {
$QueryUsers .= "`authlevel` = '" . $authlevel . "', ";
}
if ($vacations != '') {
if ($vacations == 'no') {
$Vacation = 0;
$TimeAns = 0;
} elseif ($vacations == 'yes') {
$Vacation = 1;
$VTime = $d * 86400 + $h * 3600;
$TimeAns = $VTime + time();
}
$QueryUsers .= "`urlaubs_modus` = '" . $Vacation . "', ";
$QueryUsers .= "`urlaubs_until` = '" . $TimeAns . "' ";
} else {
$QueryUsers .= "`onlinetime` = '" . time() . "' ";
}
$QueryUsers .= "WHERE ";
$QueryUsers .= "`id` = '" . $id . "' ";
$db->query($QueryUsers, "users");
$displays->message($lang['ad_sucess'], "admin.php?page=search&mode=users&search=" . $id . "", 1);
}
break;
case 'alliances':
//$id = $_GET['search'];
$SelAlly = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $id . "';", 'alliance', true);
$SelOwner = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $SelAlly['ally_owner'] . "';", 'users', true);
$mode = $_POST['edit'];
$lang['ally_name'] = $SelAlly['ally_name'];
$lang['ally_tag'] = $SelAlly['ally_tag'];
$lang['ally_owner'] = $SelOwner['username'];
$lang['owner_range'] = $SelAlly['ally_owner_range'];
$lang['ally_web'] = $SelAlly['ally_web'];
$lang['ally_image'] = $SelAlly['ally_image'];
$lang['ally_description'] = $SelAlly['ally_description'];
$lang['ally_text'] = $SelAlly['ally_text'];
$lang['ally_request'] = $SelAlly['ally_request'];
$SelMembers = $db->query("SELECT * FROM {{table}} WHERE `ally_id` = '" . $id . "';", 'users');
if ($mode == 'addit') {
$name = $_POST['name'];
$tag = $_POST['tag'];
$changeleader = $_POST['changeleader'];
$range = $_POST['range'];
$web = $_POST['web'];
$image = $_POST['image'];
$externo = $_POST['externo'];
$interno = $_POST['interno'];
$solicitud = $_POST['solicitud'];
$delete = $_POST['delete'];
$delete_u = $_POST['delete_u'];
if ($SelAlly) {
if ($range != NULL) {
$db->query("UPDATE {{table}} SET `ally_owner_range` = '" . $range . "' WHERE `id` = '" . $id . "'", "alliance");
}
if ($web != NULL) {
$db->query("UPDATE {{table}} SET `ally_web` = '" . $web . "' WHERE `id` = '" . $id . "'", "alliance");
}
if ($image != NULL) {
$db->query("UPDATE {{table}} SET `ally_image` = '" . $image . "' WHERE `id` = '" . $id . "'", "alliance");
}
if ($name != NULL) {
$db->query("UPDATE {{table}} SET `ally_name` = '" . $name . "' WHERE `id` = '" . $id . "'", "alliance");
$db->query("UPDATE {{table}} SET `ally_name` = '" . $name . "' WHERE `ally_id` = '" . $id . "'", "users");
}
if ($tag != NULL) {
$db->query("UPDATE {{table}} SET `ally_tag` = '" . $tag . "' WHERE `id` = '" . $id . "'", "alliance");
}
$i = 0;
$QueryF2 = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $changeleader . "'", "users", true);
if ($QueryF2 && $changeleader != NULL && $QueryF2['ally_id'] == $id) {
$db->query("UPDATE {{table}} SET `ally_owner` = '" . $changeleader . "' WHERE `id` = '" . $id . "'", "alliance");
$db->query("UPDATE {{table}} SET `ally_rank_id` = '0' WHERE `id` = '" . $changeleader . "'", "users");
} elseif (!$QueryF2 && $changeleader != NULL) {
$Error .= '<tr><th colspan="3"><font color=red>' . $lang['ad_ally_not_exist3'] . '</font></th></tr>';
$i++;
}
if ($externo != NULL) {
$db->query("UPDATE {{table}} SET `ally_description` = '" . $externo . "' WHERE `id` = '" . $id . "'", "alliance");
}
if ($interno != NULL) {
$db->query("UPDATE {{table}} SET `ally_text` = '" . $interno . "' WHERE `id` = '" . $id . "'", "alliance");
}
if ($solicitud != NULL) {
$db->query("UPDATE {{table}} SET `ally_request` = '" . $solicitud . "' WHERE `id` = '" . $id . "'", "alliance");
}
if ($delete == 'on') {
$db->query("DELETE FROM {{table}} WHERE `id` = '" . $id . "'", "alliance");
$db->query("UPDATE {{table}} SET `ally_id` = '0', `ally_name` = '', `ally_request` = '0', `ally_rank_id` = '0', `ally_register_time` = '0',\r\n\t\t\t\t\t\t\t`ally_request` = '0' WHERE `ally_id` = '" . $id . "'", "users");
}
$QueryF3 = $db->query("SELECT * FROM {{table}} WHERE `id` = '" . $delete_u . "'", "users", true);
if ($QueryF3 && $delete_u != NULL) {
$db->query("UPDATE {{table}} SET `ally_members` = ally_members - 1 WHERE `id` = '" . $id . "'", "alliance");
$db->query("UPDATE {{table}} SET `ally_id` = '0', `ally_name` = '', `ally_request` = '0', `ally_rank_id` = '0', `ally_register_time` = '0',\r\n\t\t\t\t\t\t\t`ally_request` = '0' WHERE `id` = '" . $delete_u . "' AND `ally_id` = '" . $id . "'", "users");
} elseif (!$QueryF3 && $delete_u != NULL) {
$Error .= '<tr><th colspan="3"><font color=red>' . $lang['ad_ally_not_exist2'] . '</font></th></tr>';
$i++;
}
if ($i == 0) {
$parse['display'] = '<tr><th colspan="3"><font color=lime>' . $lang['ad_ally_succes'] . '</font></th></tr>';
} else {
$parse['display'] = $Error;
}
} else {
$displays->message($lang['ad_ally_not_exist'], "admin.php?page=search&mode=alliances&search=" . $id . "", 1);
}
$displays->message($lang['ad_sucess'], "admin.php?page=search&mode=alliances&search=" . $id . "", 1);
}
while ($ba = mysql_fetch_array($SelMembers)) {
$displays->newblock("members");
$displays->assign("username", $ba['username']);
$displays->assign("id", $ba['id']);
}
break;
case 'iplog':
$SelLog = $db->query("SELECT * FROM {{table}} WHERE (`userid` = '" . mysql_escape_string($id) . "') OR (`username` = '" . mysql_escape_string($id) . "') OR (`user_ip` = '" . mysql_escape_string($search) . "') ORDER BY `Id`;", 'iplog');
$i = 0;
while ($u = mysql_fetch_array($SelLog)) {
$displays->newblock("lista_ip");
$i++;
$lang['id'] = $u['id'];
$lang['userid'] = $u['userid'];
$lang['username'] = $u['username'];
$lang['user_ip'] = $u['user_ip'];
$lang['date'] = date("G:i:s | d M y", $u['date']);
foreach ($lang as $key => $value) {
$displays->assign($key, $value);
}
}
break;
}
} else {
$displays->newblock("default");
}
$displays->display();
}
