Файл: adm/AccountEditorPage.php
Строк: 1669
<?php
##############################################################################
# * #
# * XG PROYECT #
# * #
# * @copyright Copyright (C) 2008 - 2010 By lucky from xgproyect.net #
# * #
# * #
# * This program is free software: you can redistribute it and/or modify #
# * it under the terms of the GNU General Public License as published by #
# * the Free Software Foundation, either version 3 of the License, or #
# * (at your option) any later version. #
# * #
# * This program is distributed in the hope that it will be useful, #
# * but WITHOUT ANY WARRANTY; without even the implied warranty of #
# * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the #
# * GNU General Public License for more details. #
# * #
##############################################################################
define('INSIDE' , true);
define('INSTALL' , false);
define('IN_ADMIN', true);
$xgp_root = './../';
include($xgp_root . 'extension.inc.php');
include($xgp_root . 'common.' . $phpEx);
if ($EditUsers != 1) die(message ($lang['404_page']));
$parse = $lang;
switch($_GET[page])
{
case'resources':
$id = $_POST['id'];
$id_dark = $_POST['id_dark'];
$metal = $_POST['metal'];
$cristal = $_POST['cristal'];
$deut = $_POST['deut'];
$dark = $_POST['dark'];
if ($_POST){
if(is_numeric($id) && is_numeric($metal) && is_numeric($cristal) && is_numeric($deut) && is_numeric($dark) && is_numeric($id_dark))
{
if ($_POST['add'])
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`metal` = `metal` + '". $metal ."', ";
$QryUpdatePlanet .= "`crystal` = `crystal` + '". $cristal ."', ";
$QryUpdatePlanet .= "`deuterium` = `deuterium` + '". $deut ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "planets");
if ($id_dark != NULL)
{
$QryUpdateUser = "UPDATE {{table}} SET ";
$QryUpdateUser .= "`darkmatter` = `darkmatter` + '". $dark ."' ";
$QryUpdateUser .= "WHERE ";
$QryUpdateUser .= "`id` = '". $id_dark ."' ";
doquery( $QryUpdateUser, "users");
}
$Name = $lang['log_moree'];
$parse['display'] = '<tr><th colspan="2"><font color=lime>'.$lang['ad_add_sucess'].'</font></th></tr>';
}
elseif ($_POST['delete'])
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`metal` = `metal` - '". $metal ."', ";
$QryUpdatePlanet .= "`crystal` = `crystal` - '". $cristal ."', ";
$QryUpdatePlanet .= "`deuterium` = `deuterium` - '". $deut ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "planets");
if ($id_dark != NULL)
{
$QryUpdateUser = "UPDATE {{table}} SET ";
$QryUpdateUser .= "`darkmatter` = `darkmatter` - '". $dark ."' ";
$QryUpdateUser .= "WHERE ";
$QryUpdateUser .= "`id` = '". $id_dark ."' ";
doquery( $QryUpdateUser, "users");
}
$Name = $lang['log_nomoree'];
$parse['display'] = '<tr><th colspan="2"><font color=lime>'.$lang['ad_delete_sucess'].'</font></th></tr>';
}
if ($_POST['add'] || $_POST['delete'])
{
$Log .= "n".$lang['log_the_user'].$user['username']." ".$Name.":n";
$Log .= $lang['metal'].": ".$metal."n";
$Log .= $lang['crystal'].": ".$cristal."n";
$Log .= $lang['deuterium'].": ".$deut."n";
$Log .= $lang['log_to_planet'].$id."n";
$Log .= $lang['log_and'].$lang['darkmatter'].": ".$dark."n";
$Log .= $lang['log_to_user'].$id_dark."n";
LogFunction($Log, "ResourcesLog", $LogCanWork);
}
}
else
{
$parse['display'] = '<tr><th colspan="2"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
}
}
display (parsetemplate(gettemplate("adm/EditorTPL/ResourcesBody"), $parse), false, '', true, false);
break;
case'ships':
if($_POST)
{
$id = $_POST['id'];
$light_hunter = $_POST['light_hunter'];
$heavy_hunter = $_POST['heavy_hunter'];
$small_ship_cargo = $_POST['small_ship_cargo'];
$big_ship_cargo = $_POST['big_ship_cargo'];
$crusher = $_POST['crusher'];
$battle_ship = $_POST['battle_ship'];
$colonizer = $_POST['colonizer'];
$recycler = $_POST['recycler'];
$spy_sonde = $_POST['spy_sonde'];
$bomber_ship = $_POST['bomber_ship'];
$solar_satelit = $_POST['solar_satelit'];
$destructor = $_POST['destructor'];
$dearth_star = $_POST['dearth_star'];
$battleship = $_POST['battleship'];
$supernova = $_POST['supernova'];
if(is_numeric($id) && is_numeric($light_hunter) && is_numeric($heavy_hunter) && is_numeric($small_ship_cargo) && is_numeric($big_ship_cargo) &&
is_numeric($crusher) && is_numeric($battle_ship) && is_numeric($colonizer) && is_numeric($recycler) && is_numeric($spy_sonde) &&
is_numeric($bomber_ship) && is_numeric($solar_satelit) && is_numeric($destructor) && is_numeric($dearth_star) &&
is_numeric($battleship) && is_numeric($supernova))
{
if ($_POST['add'])
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`small_ship_cargo` = `small_ship_cargo` + '". $small_ship_cargo ."', ";
$QryUpdatePlanet .= "`battleship` = `battleship` + '". $battleship ."', ";
$QryUpdatePlanet .= "`dearth_star` = `dearth_star` + '". $dearth_star ."', ";
$QryUpdatePlanet .= "`destructor` = `destructor` + '". $destructor ."', ";
$QryUpdatePlanet .= "`solar_satelit` = `solar_satelit` + '". $solar_satelit ."', ";
$QryUpdatePlanet .= "`bomber_ship` = `bomber_ship` + '". $bomber_ship ."', ";
$QryUpdatePlanet .= "`spy_sonde` = `spy_sonde` + '". $spy_sonde ."', ";
$QryUpdatePlanet .= "`recycler` = `recycler` + '". $recycler ."', ";
$QryUpdatePlanet .= "`colonizer` = `colonizer` + '". $colonizer ."', ";
$QryUpdatePlanet .= "`battle_ship` = `battle_ship` + '". $battle_ship ."', ";
$QryUpdatePlanet .= "`crusher` = `crusher` + '". $crusher ."', ";
$QryUpdatePlanet .= "`heavy_hunter` = `heavy_hunter` + '". $heavy_hunter ."', ";
$QryUpdatePlanet .= "`big_ship_cargo` = `big_ship_cargo` + '". $big_ship_cargo ."', ";
$QryUpdatePlanet .= "`supernova` = `supernova` + '". $supernova ."', ";
$QryUpdatePlanet .= "`light_hunter` = `light_hunter` + '". $light_hunter ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "planets");
$Name = $lang['log_moree'];
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_add_sucess_ships'].'</font></th></tr>';
}
elseif ($_POST['delete'])
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`small_ship_cargo` = `small_ship_cargo` - '". $small_ship_cargo ."', ";
$QryUpdatePlanet .= "`battleship` = `battleship` - '". $battleship ."', ";
$QryUpdatePlanet .= "`dearth_star` = `dearth_star` - '". $dearth_star ."', ";
$QryUpdatePlanet .= "`destructor` = `destructor` - '". $destructor ."', ";
$QryUpdatePlanet .= "`solar_satelit` = `solar_satelit` - '". $solar_satelit ."', ";
$QryUpdatePlanet .= "`bomber_ship` = `bomber_ship` - '". $bomber_ship ."', ";
$QryUpdatePlanet .= "`spy_sonde` = `spy_sonde` - '". $spy_sonde ."', ";
$QryUpdatePlanet .= "`recycler` = `recycler` - '". $recycler ."', ";
$QryUpdatePlanet .= "`colonizer` = `colonizer` - '". $colonizer ."', ";
$QryUpdatePlanet .= "`battle_ship` = `battle_ship` - '". $battle_ship ."', ";
$QryUpdatePlanet .= "`crusher` = `crusher` - '". $crusher ."', ";
$QryUpdatePlanet .= "`heavy_hunter` = `heavy_hunter` - '". $heavy_hunter ."', ";
$QryUpdatePlanet .= "`big_ship_cargo` = `big_ship_cargo` - '". $big_ship_cargo ."', ";
$QryUpdatePlanet .= "`supernova` = `supernova` - '". $supernova ."', ";
$QryUpdatePlanet .= "`light_hunter` = `light_hunter` - '". $light_hunter ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "planets");
$Name = $lang['log_nomoree'];
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_delete_sucess_ships'].'</font></th></tr>';
}
if ($_POST['add'] || $_POST['delete'])
{
$Log .= "n".$lang['log_the_user'].$user['username']." ".$Name.":n";
$Log .= $lang['small_ship_cargo'].": ".$small_ship_cargo."n";
$Log .= $lang['big_ship_cargo'].": ".$big_ship_cargo."n";
$Log .= $lang['light_hunter'].": ".$light_hunter."n";
$Log .= $lang['heavy_hunter'].": ".$heavy_hunter."n";
$Log .= $lang['crusher'].": ".$crusher."n";
$Log .= $lang['battle_ship'].": ".$battle_ship."n";
$Log .= $lang['colonizer'].": ".$colonizer."n";
$Log .= $lang['recycler'].": ".$recycler."n";
$Log .= $lang['spy_sonde'].": ".$spy_sonde."n";
$Log .= $lang['bomber_ship'].": ".$bomber_ship."n";
$Log .= $lang['solar_satelit'].": ".$solar_satelit."n";
$Log .= $lang['destructor'].": ".$destructor."n";
$Log .= $lang['dearth_star'].": ".$dearth_star."n";
$Log .= $lang['battleship'].": ".$battleship."n";
$Log .= $lang['supernova'].": ".$supernova."n";
$Log .= $lang['log_to_planet'].$id."n";
LogFunction($Log, "ShipsLog", $LogCanWork);
}
}
else
{
$parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
}
}
display (parsetemplate(gettemplate("adm/EditorTPL/ShipsBody"), $parse), false, '', true, false);
break;
case'defenses':
if ($_POST)
{
$id = $_POST['id'];
$misil_launcher = $_POST['misil_launcher'];
$small_laser = $_POST['small_laser'];
$big_laser = $_POST['big_laser'];
$gauss_canyon = $_POST['gauss_canyon'];
$ionic_canyon = $_POST['ionic_canyon'];
$buster_canyon = $_POST['buster_canyon'];
$small_protection_shield = $_POST['small_protection_shield'];
$big_protection_shield = $_POST['big_protection_shield'];
$planet_protector = $_POST['planet_protector'];
$atom_protector = $_POST['atom_protector'];
$interceptor_misil = $_POST['interceptor_misil'];
$interplanetary_misil = $_POST['interplanetary_misil'];
if(is_numeric($id) && is_numeric($misil_launcher) && is_numeric($small_laser) && is_numeric($big_laser) && is_numeric($gauss_canyon) &&
is_numeric($ionic_canyon) && is_numeric($buster_canyon) && is_numeric($small_protection_shield) && is_numeric($big_protection_shield) &&
is_numeric($interceptor_misil) && is_numeric($interplanetary_misil) && is_numeric($planet_protector))
{
if ($_POST['add'])
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`misil_launcher` = `misil_launcher` + '". $misil_launcher ."', ";
$QryUpdatePlanet .= "`small_laser` = `small_laser` + '". $small_laser ."', ";
$QryUpdatePlanet .= "`big_laser` = `big_laser` + '". $big_laser ."', ";
$QryUpdatePlanet .= "`gauss_canyon` = `gauss_canyon` + '". $gauss_canyon ."', ";
$QryUpdatePlanet .= "`ionic_canyon` = `ionic_canyon` + '". $ionic_canyon ."', ";
$QryUpdatePlanet .= "`buster_canyon` = `buster_canyon` + '". $buster_canyon ."', ";
$QryUpdatePlanet .= "`small_protection_shield` = `small_protection_shield` + '". $small_protection_shield ."', ";
$QryUpdatePlanet .= "`big_protection_shield` = `big_protection_shield` + '". $big_protection_shield ."', ";
$QryUpdatePlanet .= "`planet_protector` = `planet_protector` + '". $planet_protector ."', ";
$QryUpdatePlanet .= "`atom_protector` = `atom_protector` + '". $atom_protector ."', ";
$QryUpdatePlanet .= "`interceptor_misil` = `interceptor_misil` + '". $interceptor_misil ."', ";
$QryUpdatePlanet .= "`interplanetary_misil` = `interplanetary_misil` + '". $interplanetary_misil ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "planets");
$Name = $lang['log_moree'];
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_add_defenses_succes'].'</font></th></tr>';
}
elseif ($_POST['delete'])
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`misil_launcher` = `misil_launcher` - '". $misil_launcher ."', ";
$QryUpdatePlanet .= "`small_laser` = `small_laser` - '". $small_laser ."', ";
$QryUpdatePlanet .= "`big_laser` = `big_laser` - '". $big_laser ."', ";
$QryUpdatePlanet .= "`gauss_canyon` = `gauss_canyon` - '". $gauss_canyon ."', ";
$QryUpdatePlanet .= "`ionic_canyon` = `ionic_canyon` - '". $ionic_canyon ."', ";
$QryUpdatePlanet .= "`buster_canyon` = `buster_canyon` - '". $buster_canyon ."', ";
$QryUpdatePlanet .= "`small_protection_shield` = `small_protection_shield` - '". $small_protection_shield ."', ";
$QryUpdatePlanet .= "`big_protection_shield` = `big_protection_shield` - '". $big_protection_shield ."', ";
$QryUpdatePlanet .= "`planet_protector` = `planet_protector` - '". $planet_protector ."', ";
$QryUpdatePlanet .= "`atom_protector` = `atom_protector` - '". $atom_protector ."', ";
$QryUpdatePlanet .= "`interceptor_misil` = `interceptor_misil` - '". $interceptor_misil ."', ";
$QryUpdatePlanet .= "`interplanetary_misil` = `interplanetary_misil` - '". $interplanetary_misil ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "planets");
$Name = $lang['log_nomoree'];
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_delete_defenses_succes'].'</font></th></tr>';
}
if ($_POST['add'] || $_POST['delete'])
{
$Log .= "n".$lang['log_the_user'].$user['username']." ".$Name.":n";
$Log .= $lang['misil_launcher'].": ".$misil_launcher."n";
$Log .= $lang['small_laser'].": ".$small_laser."n";
$Log .= $lang['big_laser'].": ".$big_laser."n";
$Log .= $lang['gauss_canyon'].": ".$gauss_canyon."n";
$Log .= $lang['ionic_canyon'].": ".$ionic_canyon."n";
$Log .= $lang['buster_canyon'].": ".$buster_canyon."n";
$Log .= $lang['small_protection_shield'].": ".$small_protection_shield."n";
$Log .= $lang['big_protection_shield'].": ".$big_protection_shield."n";
$Log .= $lang['planet_protector'].": ".$planet_protector."n";
$Log .= $lang['interceptor_misil'].": ".$interceptor_misil."n";
$Log .= $lang['interplanetary_misil'].": ".$interplanetary_misil."n";
$Log .= $lang['log_to_planet'].$id."n";
LogFunction($Log, "DefensesLog", $LogCanWork);
}
}
else
{
$parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
}
}
display (parsetemplate(gettemplate("adm/EditorTPL/DefensesBody"), $parse), false, '', true, false);
break;
case'buildings':
if ($_POST)
{
$id = $_POST['id'];
$metal_mine = $_POST['metal_mine'];
$crystal_mine = $_POST['crystal_mine'];
$deuterium_sintetizer = $_POST['deuterium_sintetizer'];
$solar_plant = $_POST['solar_plant'];
$fusion_plant = $_POST['fusion_plant'];
$robot_factory = $_POST['robot_factory'];
$nano_factory = $_POST['nano_factory'];
$hangar = $_POST['hangar'];
$metal_store = $_POST['metal_store'];
$crystal_store = $_POST['crystal_store'];
$deuterium_store = $_POST['deuterium_store'];
$laboratory = $_POST['laboratory'];
$terraformer = $_POST['terraformer'];
$ally_deposit = $_POST['ally_deposit'];
$silo = $_POST['silo'];
$mondbasis = $_POST['mondbasis'];
$phalanx = $_POST['phalanx'];
$sprungtor = $_POST['sprungtor'];
if(is_numeric($id) && is_numeric($metal_mine) && is_numeric($crystal_mine) && is_numeric($deuterium_sintetizer) && is_numeric($solar_plant) &&
is_numeric($fusion_plant) && is_numeric($robot_factory) && is_numeric($nano_factory) && is_numeric($hangar) &&
is_numeric($metal_store) && is_numeric($crystal_store) && is_numeric($deuterium_store) && is_numeric($laboratory) &&
is_numeric($terraformer)&& is_numeric($ally_deposit) && is_numeric($silo) && is_numeric($mondbasis) &&
is_numeric($phalanx) && is_numeric($sprungtor))
{
$QueryFind = doquery("SELECT `planet_type` FROM {{table}} WHERE `id` = '".$id."'", "planets", true);
if ($_POST['add'])
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`metal_mine` = `metal_mine` + '". $metal_mine ."', ";
$QryUpdatePlanet .= "`crystal_mine` = `crystal_mine` + '". $crystal_mine ."', ";
$QryUpdatePlanet .= "`deuterium_sintetizer` = `deuterium_sintetizer` + '". $deuterium_sintetizer ."', ";
$QryUpdatePlanet .= "`solar_plant` = `solar_plant` + '". $solar_plant ."', ";
$QryUpdatePlanet .= "`fusion_plant` = `fusion_plant` + '". $fusion_plant ."', ";
$QryUpdatePlanet .= "`robot_factory` = `robot_factory` + '". $robot_factory ."', ";
$QryUpdatePlanet .= "`nano_factory` = `nano_factory` + '". $nano_factory ."', ";
$QryUpdatePlanet .= "`hangar` = `hangar` + '". $hangar ."', ";
$QryUpdatePlanet .= "`metal_store` = `metal_store` + '". $metal_store ."', ";
$QryUpdatePlanet .= "`crystal_store` = `crystal_store` + '". $crystal_store ."', ";
$QryUpdatePlanet .= "`deuterium_store` = `deuterium_store` + '". $deuterium_store ."', ";
$QryUpdatePlanet .= "`laboratory` = `laboratory` + '". $laboratory ."', ";
$QryUpdatePlanet .= "`terraformer` = `terraformer` + '". $terraformer ."', ";
$QryUpdatePlanet .= "`ally_deposit` = `ally_deposit` + '". $ally_deposit ."', ";
$QryUpdatePlanet .= "`silo` = `silo` + '". $silo ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "planets");
if ($mondbasis or $phalanx or $sprungtor)
{
if ($QueryFind['planet_type'] == '3')
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`mondbasis` = `mondbasis` + '". $mondbasis ."', ";
$QryUpdatePlanet .= "`phalanx` = `phalanx` + '". $phalanx ."', ";
$QryUpdatePlanet .= "`sprungtor` = `sprungtor` + '". $sprungtor ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "planets");
if ($mondbasis > 0)
{
$Sum = $mondbasis * FIELDS_BY_MOONBASIS_LEVEL;
doquery("UPDATE {{table}} SET `field_max` = field_max + '".$Sum."', `field_current` = field_current + '".$mondbasis."'", "planets");
}
}
else
{
$parse['display2'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_error_moon_only'].'</font></th></tr>';
}
}
$Name = $lang['log_moree'];
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_add_succes'].'</font></th></tr>';
}
elseif ($_POST['delete'])
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`metal_mine` = `metal_mine` - '". $metal_mine ."', ";
$QryUpdatePlanet .= "`crystal_mine` = `crystal_mine` - '". $crystal_mine ."', ";
$QryUpdatePlanet .= "`deuterium_sintetizer` = `deuterium_sintetizer` - '". $deuterium_sintetizer ."', ";
$QryUpdatePlanet .= "`solar_plant` = `solar_plant` - '". $solar_plant ."', ";
$QryUpdatePlanet .= "`fusion_plant` = `fusion_plant` - '". $fusion_plant ."', ";
$QryUpdatePlanet .= "`robot_factory` = `robot_factory` - '". $robot_factory ."', ";
$QryUpdatePlanet .= "`nano_factory` = `nano_factory` - '". $nano_factory ."', ";
$QryUpdatePlanet .= "`hangar` = `hangar` - '". $hangar ."', ";
$QryUpdatePlanet .= "`metal_store` = `metal_store` - '". $metal_store ."', ";
$QryUpdatePlanet .= "`crystal_store` = `crystal_store` - '". $crystal_store ."', ";
$QryUpdatePlanet .= "`deuterium_store` = `deuterium_store` - '". $deuterium_store ."', ";
$QryUpdatePlanet .= "`laboratory` = `laboratory` - '". $laboratory ."', ";
$QryUpdatePlanet .= "`terraformer` = `terraformer` - '". $terraformer ."', ";
$QryUpdatePlanet .= "`ally_deposit` = `ally_deposit` - '". $ally_deposit ."', ";
$QryUpdatePlanet .= "`silo` = `silo` - '". $silo ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "planets");
if ($mondbasis or $phalanx or $sprungtor)
{
if ($QueryFind['planet_type'] == '3')
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`mondbasis` = `mondbasis` - '". $mondbasis ."', ";
$QryUpdatePlanet .= "`phalanx` = `phalanx` - '". $phalanx ."', ";
$QryUpdatePlanet .= "`sprungtor` = `sprungtor` - '". $sprungtor ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "planets");
if ($mondbasis > 0)
{
$Sum = $mondbasis * FIELDS_BY_MOONBASIS_LEVEL;
doquery("UPDATE {{table}} SET `field_max` = field_max - '".$Sum."', `field_current` = field_current - '".$mondbasis."'", "planets");
}
}
else
{
$parse['display2'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_error_moon_only'].'</font></th></tr>';
}
}
$Name = $lang['log_nomoree'];
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_delete_succes'].'</font></th></tr>';
}
if ($_POST['add'] || $_POST['delete'])
{
$Log .= "n".$lang['log_the_user'].$user['username']." ".$Name.":n";
$Log .= $lang['metal_mine'].": ".$metal_mine."n";
$Log .= $lang['crystal_mine'].": ".$crystal_mine."n";
$Log .= $lang['deuterium_sintetizer'].": ".$deuterium_sintetizer."n";
$Log .= $lang['solar_plant'].": ".$solar_plant."n";
$Log .= $lang['fusion_plant'].": ".$fusion_plant."n";
$Log .= $lang['robot_factory'].": ".$robot_factory."n";
$Log .= $lang['nano_factory'].": ".$nano_factory."n";
$Log .= $lang['shipyard'].": ".$hangar."n";
$Log .= $lang['metal_store'].": ".$metal_store."n";
$Log .= $lang['crystal_store'].": ".$crystal_store."n";
$Log .= $lang['deuterium_store'].": ".$deuterium_store."n";
$Log .= $lang['laboratory'].": ".$laboratory."n";
$Log .= $lang['terraformer'].": ".$terraformer."n";
$Log .= $lang['ally_deposit'].": ".$ally_deposit."n";
$Log .= $lang['silo'].": ".$silo."n";
$Log .= $lang['moonbases'].": ".$mondbasis."n";
$Log .= $lang['phalanx'].": ".$phalanx."n";
$Log .= $lang['cuantic'].": ".$sprungtor."n";
$Log .= $lang['log_to_planet'].$id."n";
LogFunction($Log, "BuildingsLog", $LogCanWork);
}
}
else
{
$parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
}
}
display (parsetemplate(gettemplate("adm/EditorTPL/BuildingsBody"), $parse), false, '', true, false);
break;
case'researchs':
if ($_POST)
{
$id = $_POST['id'];
$spy_tech = $_POST['spy_tech'];
$computer_tech = $_POST['computer_tech'];
$military_tech = $_POST['military_tech'];
$defence_tech = $_POST['defence_tech'];
$shield_tech = $_POST['shield_tech'];
$energy_tech = $_POST['energy_tech'];
$hyperspace_tech = $_POST['hyperspace_tech'];
$combustion_tech = $_POST['combustion_tech'];
$impulse_motor_tech = $_POST['impulse_motor_tech'];
$hyperspace_motor_tech = $_POST['hyperspace_motor_tech'];
$laser_tech = $_POST['laser_tech'];
$ionic_tech = $_POST['ionic_tech'];
$buster_tech = $_POST['buster_tech'];
$intergalactic_tech = $_POST['intergalactic_tech'];
$expedition_tech = $_POST['expedition_tech'];
$atom_tech = $_POST['atom_tech'];
$colonisation_tech = $_POST['colonisation_tech'];
$graviton_tech = $_POST['graviton_tech'];
if(is_numeric($id) && is_numeric($spy_tech) && is_numeric($computer_tech) && is_numeric($military_tech) && is_numeric($defence_tech) &&
is_numeric($shield_tech) && is_numeric($energy_tech) && is_numeric($hyperspace_tech) && is_numeric($combustion_tech) &&
is_numeric($impulse_motor_tech) && is_numeric($hyperspace_motor_tech) && is_numeric($laser_tech) && is_numeric($ionic_tech) &&
is_numeric($buster_tech)&& is_numeric($intergalactic_tech) && is_numeric($expedition_tech) && is_numeric($atom_tech) && is_numeric($colonisation_tech) && is_numeric($graviton_tech))
{
if ($_POST['add'])
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`spy_tech` = `spy_tech` + '". $spy_tech ."', ";
$QryUpdatePlanet .= "`computer_tech` = `computer_tech` + '". $computer_tech ."', ";
$QryUpdatePlanet .= "`military_tech` = `military_tech` + '". $military_tech ."', ";
$QryUpdatePlanet .= "`defence_tech` = `defence_tech` + '". $defence_tech ."', ";
$QryUpdatePlanet .= "`shield_tech` = `shield_tech` + '". $shield_tech ."', ";
$QryUpdatePlanet .= "`energy_tech` = `energy_tech` + '". $energy_tech ."', ";
$QryUpdatePlanet .= "`hyperspace_tech` = `hyperspace_tech` + '". $hyperspace_tech ."', ";
$QryUpdatePlanet .= "`combustion_tech` = `combustion_tech` + '". $combustion_tech ."', ";
$QryUpdatePlanet .= "`impulse_motor_tech` = `impulse_motor_tech` + '". $impulse_motor_tech ."', ";
$QryUpdatePlanet .= "`hyperspace_motor_tech` = `hyperspace_motor_tech` + '". $hyperspace_motor_tech ."', ";
$QryUpdatePlanet .= "`laser_tech` = `laser_tech` + '". $laser_tech ."', ";
$QryUpdatePlanet .= "`ionic_tech` = `ionic_tech` + '". $ionic_tech ."', ";
$QryUpdatePlanet .= "`buster_tech` = `buster_tech` + '". $buster_tech ."', ";
$QryUpdatePlanet .= "`intergalactic_tech` = `intergalactic_tech` + '". $intergalactic_tech ."', ";
$QryUpdatePlanet .= "`expedition_tech` = `expedition_tech` + '". $expedition_tech ."', ";
$QryUpdatePlanet .= "`atom_tech` = `atom_tech` + '". $atom_tech ."', ";
$QryUpdatePlanet .= "`colonisation_tech` = `colonisation_tech` + '". $colonisation_tech ."', ";
$QryUpdatePlanet .= "`graviton_tech` = `graviton_tech` + '". $graviton_tech ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "users");
$Name = $lang['log_moree'];
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_add_succes'].'</font></th></tr>';
}
elseif ($_POST['delete'])
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`spy_tech` = `spy_tech` - '". $spy_tech ."', ";
$QryUpdatePlanet .= "`computer_tech` = `computer_tech` - '". $computer_tech ."', ";
$QryUpdatePlanet .= "`military_tech` = `military_tech` - '". $military_tech ."', ";
$QryUpdatePlanet .= "`defence_tech` = `defence_tech` - '". $defence_tech ."', ";
$QryUpdatePlanet .= "`shield_tech` = `shield_tech` - '". $shield_tech ."', ";
$QryUpdatePlanet .= "`energy_tech` = `energy_tech` - '". $energy_tech ."', ";
$QryUpdatePlanet .= "`hyperspace_tech` = `hyperspace_tech` - '". $hyperspace_tech ."', ";
$QryUpdatePlanet .= "`combustion_tech` = `combustion_tech` - '". $combustion_tech ."', ";
$QryUpdatePlanet .= "`impulse_motor_tech` = `impulse_motor_tech` - '". $impulse_motor_tech ."', ";
$QryUpdatePlanet .= "`hyperspace_motor_tech` = `hyperspace_motor_tech` - '". $hyperspace_motor_tech ."', ";
$QryUpdatePlanet .= "`laser_tech` = `laser_tech` - '". $laser_tech ."', ";
$QryUpdatePlanet .= "`ionic_tech` = `ionic_tech` - '". $ionic_tech ."', ";
$QryUpdatePlanet .= "`buster_tech` = `buster_tech` - '". $buster_tech ."', ";
$QryUpdatePlanet .= "`intergalactic_tech` = `intergalactic_tech` - '". $intergalactic_tech ."', ";
$QryUpdatePlanet .= "`expedition_tech` = `expedition_tech` - '". $expedition_tech ."', ";
$QryUpdatePlanet .= "`atom_tech` = `atom_tech` - '". $atom_tech ."', ";
$QryUpdatePlanet .= "`colonisation_tech` = `colonisation_tech` - '". $colonisation_tech ."', ";
$QryUpdatePlanet .= "`graviton_tech` = `graviton_tech` - '". $graviton_tech ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "users");
$Name = $lang['log_nomoree'];
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_delete_succes'].'</font></th></tr>';
}
if ($_POST['add'] || $_POST['delete'])
{
$Log .= "n".$lang['log_the_user'].$user['username']." ".$Name.":n";
$Log .= $lang['spy_tech'].": ".$spy_tech."n";
$Log .= $lang['computer_tech'].": ".$computer_tech."n";
$Log .= $lang['military_tech'].": ".$military_tech."n";
$Log .= $lang['defence_tech'].": ".$defence_tech."n";
$Log .= $lang['shield_tech'].": ".$shield_tech."n";
$Log .= $lang['energy_tech'].": ".$energy_tech."n";
$Log .= $lang['hyperspace_tech'].": ".$hyperspace_tech."n";
$Log .= $lang['combustion_tech'].": ".$combustion_tech."n";
$Log .= $lang['impulse_motor_tech'].": ".$impulse_motor_tech."n";
$Log .= $lang['hyperspace_motor_tech'].": ".$hyperspace_motor_tech."n";
$Log .= $lang['laser_tech'].": ".$laser_tech."n";
$Log .= $lang['ionic_tech'].": ".$ionic_tech."n";
$Log .= $lang['buster_tech'].": ".$buster_tech."n";
$Log .= $lang['intergalactic_tech'].": ".$intergalactic_tech."n";
$Log .= $lang['expedition_tech'].": ".$expedition_tech."n";
$Log .= $lang['atom_tech'].": ".$atom_tech."n";
$Log .= $lang['graviton_tech'].": ".$graviton_tech."n";
$Log .= $lang['log_to_user'].$id."n";
LogFunction($Log, "ResearchLog", $LogCanWork);
}
}
else
{
$parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
}
}
display (parsetemplate(gettemplate("adm/EditorTPL/ResearchBody"), $parse), false, '', true, false);
break;
case 'personal':
$parse['yes'] = $lang['one_is_yes'][1];
$parse['no'] = $lang['one_is_yes'][0];
if ($user['authlevel'] != 3) $parse['Block'] = "disabled='disabled'";
if ($_POST)
{
if ($user['authlevel'] != 3 && $_POST['username'] != NULL && $_POST['password'] != NULL && $_POST['email_2'] != NULL &&
$_POST['email'] != NULL ) die();
if(!$_POST['id'])
{
$parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_forgiven_id'].'</font></th></tr>';
}
else
{
$Log .= "n".$lang['log_the_user'].$user['username']." ".$lang['log_modify_personal'].":n";
$PersonalQuery = "UPDATE {{table}} SET ";
if($_POST['username'] != NULL){
$PersonalQuery .= "`username` = '".$_POST['username']."', ";
$Log .= $lang['ad_personal_name'].": ".$_POST['username']."n";}
if($_POST['email'] != NULL){
$PersonalQuery .= "`email` = '".$_POST['email']."', ";
$Log .= $lang['ad_personal_email'].": ".$_POST['email']."n";}
if($_POST['email_2'] != NULL){
$PersonalQuery .= "`email_2` = '".$_POST['email_2']."', ";
$Log .= $lang['ad_personal_email2'].": ".$_POST['email_2']."n";}
if($_POST['password'] != NULL)
$PersonalQuery .= "`password` = '".md5($_POST['password'])."', ";
if($_POST['vacation'] != '')
{
if ($_POST['vacation'] == 'no')
{
$Answer = 0;
$TimeAns = 0;
}
elseif ($_POST['vacation'] == 'yes')
{
$Answer = 1;
$VTime = $_POST['d'] * 86400;
$VTime += $_POST['h'] * 3600;
$VTime += $_POST['m'] * 60;
$VTime += $_POST['s'];
$TimeAns = $VTime + time();
}
$PersonalQuery .= "`urlaubs_modus` = '".$Answer."', `urlaubs_until` = '".$TimeAns."' ";
}
else
$PersonalQuery .= "`onlinetime` = '".time()."' ";
if ($_POST['username'] or $_POST['email'] or $_POST['email_2'] or $_POST['password'] or $_POST['vacation'] != '')
{
$PersonalQuery .= "WHERE `id` = '".$_POST['id']."'";
doquery($PersonalQuery, "users");
$Log .= $lang['log_to_user'].$_POST['id']."n";
LogFunction($Log, "PersonalLog", $LogCanWork);
}
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_personal_succes'].'</font></th></tr>';
}
}
display (parsetemplate(gettemplate("adm/EditorTPL/PersonalBody"), $parse), false, '', true, false);
break;
case'officiers':
if ($_POST)
{
$id = $_POST['id'];
$rpg_geologue = $_POST['rpg_geologue'];
$rpg_amiral = $_POST['rpg_amiral'];
$rpg_ingenieur = $_POST['rpg_ingenieur'];
$rpg_technocrate = $_POST['rpg_technocrate'];
$rpg_espion = $_POST['rpg_espion'];
$rpg_constructeur = $_POST['rpg_constructeur'];
$rpg_scientifique = $_POST['rpg_scientifique'];
$rpg_commandant = $_POST['rpg_commandant'];
$rpg_stockeur = $_POST['rpg_stockeur'];
$rpg_defenseur = $_POST['rpg_defenseur'];
$rpg_destructeur = $_POST['rpg_destructeur'];
$rpg_general = $_POST['rpg_general'];
$rpg_bunker = $_POST['rpg_bunker'];
$rpg_raideur = $_POST['rpg_raideur'];
$rpg_empereur = $_POST['rpg_empereur'];
if(is_numeric($id) && is_numeric($rpg_geologue) && is_numeric($rpg_amiral) && is_numeric($rpg_ingenieur) && is_numeric($rpg_technocrate) &&
is_numeric($rpg_espion) && is_numeric($rpg_constructeur) && is_numeric($rpg_scientifique) && is_numeric($rpg_commandant) &&
is_numeric($rpg_stockeur) && is_numeric($rpg_defenseur) && is_numeric($rpg_destructeur) && is_numeric($rpg_general) &&
is_numeric($rpg_bunker)&& is_numeric($rpg_raideur) && is_numeric($rpg_empereur))
{
if ($_POST['add'])
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`rpg_geologue` = `rpg_geologue` + '". $rpg_geologue ."', ";
$QryUpdatePlanet .= "`rpg_amiral` = `rpg_amiral` + '". $rpg_amiral ."', ";
$QryUpdatePlanet .= "`rpg_ingenieur` = `rpg_ingenieur` + '". $rpg_ingenieur ."', ";
$QryUpdatePlanet .= "`rpg_technocrate` = `rpg_technocrate` + '". $rpg_technocrate ."', ";
$QryUpdatePlanet .= "`rpg_espion` = `rpg_espion` + '". $rpg_espion ."', ";
$QryUpdatePlanet .= "`rpg_constructeur` = `rpg_constructeur` + '". $rpg_constructeur ."', ";
$QryUpdatePlanet .= "`rpg_scientifique` = `rpg_scientifique` + '". $rpg_scientifique ."', ";
$QryUpdatePlanet .= "`rpg_commandant` = `rpg_commandant` + '". $rpg_commandant ."', ";
$QryUpdatePlanet .= "`rpg_stockeur` = `rpg_stockeur` + '". $rpg_stockeur ."', ";
$QryUpdatePlanet .= "`rpg_defenseur` = `rpg_defenseur` + '". $rpg_defenseur ."', ";
$QryUpdatePlanet .= "`rpg_destructeur` = `rpg_destructeur` + '". $rpg_destructeur ."', ";
$QryUpdatePlanet .= "`rpg_general` = `rpg_general` + '". $rpg_general ."', ";
$QryUpdatePlanet .= "`rpg_bunker` = `rpg_bunker` + '". $rpg_bunker ."', ";
$QryUpdatePlanet .= "`rpg_raideur` = `rpg_raideur` + '". $rpg_raideur ."', ";
$QryUpdatePlanet .= "`rpg_empereur` = `rpg_empereur` + '". $rpg_empereur ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "users");
$Name = $lang['log_moree'];
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_offi_succes_add'].'</font></th></tr>';
}
elseif ($_POST['delete'])
{
$QryUpdatePlanet = "UPDATE {{table}} SET ";
$QryUpdatePlanet .= "`rpg_geologue` = `rpg_geologue` - '". $rpg_geologue ."', ";
$QryUpdatePlanet .= "`rpg_amiral` = `rpg_amiral` - '". $rpg_amiral ."', ";
$QryUpdatePlanet .= "`rpg_ingenieur` = `rpg_ingenieur` - '". $rpg_ingenieur ."', ";
$QryUpdatePlanet .= "`rpg_technocrate` = `rpg_technocrate` - '". $rpg_technocrate ."', ";
$QryUpdatePlanet .= "`rpg_espion` = `rpg_espion` - '". $rpg_espion ."', ";
$QryUpdatePlanet .= "`rpg_constructeur` = `rpg_constructeur` - '". $rpg_constructeur ."', ";
$QryUpdatePlanet .= "`rpg_scientifique` = `rpg_scientifique` - '". $rpg_scientifique ."', ";
$QryUpdatePlanet .= "`rpg_commandant` = `rpg_commandant` - '". $rpg_commandant ."', ";
$QryUpdatePlanet .= "`rpg_stockeur` = `rpg_stockeur` - '". $rpg_stockeur ."', ";
$QryUpdatePlanet .= "`rpg_defenseur` = `rpg_defenseur` - '". $rpg_defenseur ."', ";
$QryUpdatePlanet .= "`rpg_destructeur` = `rpg_destructeur` - '". $rpg_destructeur ."', ";
$QryUpdatePlanet .= "`rpg_general` = `rpg_general` - '". $rpg_general ."', ";
$QryUpdatePlanet .= "`rpg_bunker` = `rpg_bunker` - '". $rpg_bunker ."', ";
$QryUpdatePlanet .= "`rpg_raideur` = `rpg_raideur` - '". $rpg_raideur ."', ";
$QryUpdatePlanet .= "`rpg_empereur` = `rpg_empereur` - '". $rpg_empereur ."' ";
$QryUpdatePlanet .= "WHERE ";
$QryUpdatePlanet .= "`id` = '". $id ."' ";
doquery( $QryUpdatePlanet, "users");
$Name = $lang['log_nomoree'];
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_offi_succes_delete'].'</font></th></tr>';
}
if ($_POST['add'] || $_POST['delete'])
{
$Log .= "n".$lang['log_the_user'].$user['username']." ".$Name.":n";
$Log .= $lang['geologist'].": ".$rpg_geologue."n";
$Log .= $lang['admiral'].": ".$rpg_amiral."n";
$Log .= $lang['engineer'].": ".$rpg_ingenieur."n";
$Log .= $lang['technocrat'].": ".$rpg_technocrate."n";
$Log .= $lang['spy'].": ".$rpg_espion."n";
$Log .= $lang['constructor'].": ".$rpg_constructeur."n";
$Log .= $lang['scientific'].": ".$rpg_scientifique."n";
$Log .= $lang['commander'].": ".$rpg_commandant."n";
$Log .= $lang['storer'].": ".$rpg_stockeur."n";
$Log .= $lang['defender'].": ".$rpg_defenseur."n";
$Log .= $lang['destroyer'].": ".$rpg_destructeur."n";
$Log .= $lang['general'].": ".$rpg_general."n";
$Log .= $lang['protector'].": ".$rpg_bunker."n";
$Log .= $lang['conqueror'].": ".$rpg_raideur."n";
$Log .= $lang['emperor'].": ".$rpg_empereur."n";
$Log .= $lang['log_to_user'].$id."n";
LogFunction($Log, "OfficierLog", $LogCanWork);
}
}
else
{
$parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
}
}
display (parsetemplate(gettemplate("adm/EditorTPL/OfficiersBody"), $parse), false, '', true, false);
break;
case 'planets':
if ($_POST)
{
$id = $_POST['id'];
$name = $_POST['name'];
$change_id = $_POST['change_id'];
$diameter = $_POST['diameter'];
$fields = $_POST['fields'];
$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'];
$galaxy = $_POST['g'];
$system = $_POST['s'];
$planet = $_POST['p'];
$delete = $_POST['delete'];
if ($id != NULL)
{
if (is_numeric($id))
{
$Log .= "n".$lang['log_the_user'].$user['username']." ".$lang['log_modify_personal'].":n";
if ($delete != 'on')
{
if ($name != NULL){
doquery("UPDATE {{table}} SET `name` = '".$name."' WHERE `id` = '".$id."'", "planets");
$Log .= $lang['log_change_name_pla'].": ".$name."n";}
if ($buildings == 'on'){
doquery("UPDATE {{table}} SET `metal_mine` = '0', `crystal_mine` = '0', `deuterium_sintetizer` = '0',
`solar_plant` = '0', `fusion_plant` = '0', `robot_factory` = '0',
`nano_factory` = '0', `hangar` = '0', `metal_store` = '0',
`crystal_store` = '0', `deuterium_store` = '0', `laboratory` = '0',
`terraformer` = '0', `ally_deposit` = '0', `silo` = '0', `mondbasis` = '0',
`phalanx` = '0', `sprungtor` = '0', `last_jump_time` = '0' WHERE `id` = '".$id."'", "planets");
$Log .= $lang['log_delete_all_edi']."n";}
if ($ships == 'on'){
doquery("UPDATE {{table}} SET `small_ship_cargo` = '0', `big_ship_cargo` = '0', `light_hunter` = '0',
`heavy_hunter` = '0', `crusher` = '0', `battle_ship` = '0',
`colonizer` = '0', `recycler` = '0', `spy_sonde` = '0',
`bomber_ship` = '0', `solar_satelit` = '0', `destructor` = '0',
`dearth_star` = '0', `battleship` = '0', `supernova` = '0' WHERE `id` = '".$id."'", "planets");
$Log .= $lang['log_delete_all_ships']."n";}
if ($defenses == 'on'){
doquery("UPDATE {{table}} SET `misil_launcher` = '0', `small_laser` = '0', `big_laser` = '0',
`gauss_canyon` = '0', `ionic_canyon` = '0', `buster_canyon` = '0',
`small_protection_shield` = '0', `planet_protector` = '0', `big_protection_shield` = '0',
`interceptor_misil` = '0', `interplanetary_misil` = '0' WHERE `id` = '".$id."'", "planets");
$Log .= $lang['log_delete_all_def']."n";}
if ($c_hangar == 'on'){
doquery("UPDATE {{table}} SET `b_hangar` = '0', `b_hangar_plus` = '0', `b_hangar_id` = '' WHERE `id` = '".$id."'", "planets");
$Log .= $lang['log_delete_all_c_han']."n";}
if ($c_buildings == 'on'){
doquery("UPDATE {{table}} SET `b_building` = '0', `b_building_id` = '' WHERE `id` = '".$id."'", "planets");
$Log .= $lang['log_delete_all_c_edi']."n";}
$P = doquery("SELECT * FROM {{table}} WHERE `id` = '".$id."'", "planets", true);
if ($diameter != NULL && is_numeric($diameter) && $diameter > 0){
doquery("UPDATE {{table}} SET `diameter` = '".$diameter."' WHERE `id` = '".$id."'", "planets");
$Log .= $lang['log_change_diameter'].": ".$diameter."n";}
if ($fields != NULL && is_numeric($fields) && $fields > 0){
doquery("UPDATE {{table}} SET `field_max` = '".$fields."' WHERE `id` = '".$id."'", "planets");
$Log .= $lang['log_change_fields'].": ".$fields."n";}
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 = doquery("SELECT * FROM {{table}} WHERE `galaxy` = '".$galaxy."' AND `system` = '".$system."' AND
`planet` = '".$planet."'", "galaxy", true);
if ($P['planet_type'] == '1')
{
if (!$Queryyy)
{
if ($Queryyy['id_luna'] != '0')
{
doquery ("UPDATE {{table}} SET `galaxy` = '".$galaxy."', `system` = '".$system."', `planet` = '".$planet."' WHERE
`galaxy` = '".$P['galaxy']."' AND `system` = '".$P['system']."' AND `planet` = '".$P['planet']."' AND `planet_type` = '3'", "planets");
}
doquery ("UPDATE {{table}} SET `galaxy` = '".$galaxy."', `system` = '".$system."', `planet` = '".$planet."' WHERE
`id` = '".$id."'", "planets");
doquery ("UPDATE {{table}} SET `galaxy` = '".$galaxy."', `system` = '".$system."', `planet` = '".$planet."' WHERE
`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')
{
doquery ("UPDATE {{table}} SET `id_luna` = '0' WHERE `galaxy` = '".$P['galaxy']."' AND `system` = '".$P['system']."' AND
`planet` = '".$P['planet']."'", "galaxy");
doquery ("UPDATE {{table}} SET `galaxy` = '".$galaxy."', `system` = '".$system."', `planet` = '".$planet."',
`id_luna` = '".$id."' WHERE `id_planet` = '".$Queryyy['id_planet']."'", "galaxy");
$QMOON2 = doquery("SELECT * FROM {{table}} WHERE `galaxy` = '".$galaxy."' AND `system` = '".$system."' AND
`planet` = '".$planet."'", "planets", true);
doquery ("UPDATE {{table}} SET `galaxy` = '".$galaxy."', `system` = '".$system."', `planet` = '".$planet."',
`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>';
}
}
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_pla_succes'].'</font></th></tr>';
$parse['display2'] = $Error;
}
else
{
$QueryPlanetsS = doquery("SELECT planet_type FROM {{table}} WHERE id = '".$id."'", "planets", true);
if ($QueryPlanetsS['planet_type'] == '1')
{
doquery("DELETE FROM {{table}} WHERE id = '".$id."'", "planets");
doquery("DELETE FROM {{table}} WHERE id_planet = '".$id."'", "galaxy");
}
else
{
doquery("DELETE FROM {{table}} WHERE id = '".$id."'", "planets");
doquery("UPDATE {{table}} SET id_luna = '0', luna = '0' WHERE id_luna = '".$id."'", "galaxy");
}
$parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_pla_delete_planet_s'].'</font></th></tr>';
}
$Log .= $lang['log_to_planet'].$id."n";
LogFunction($Log, "PlanetsAndMoonsLog", $LogCanWork);
}
else
{
$parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['only_numbers'].'</font></th></tr>';
}
}
else
{
$parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_forgiven_id'].'</font></th></tr>';
}
}
display (parsetemplate(gettemplate("adm/EditorTPL/PlanetsMoonsBody"), $parse), false, '', true, false);
break;
case 'alliances':
if ($_POST)
{
$id = $_POST['id'];
$name = $_POST['name'];
$changeleader = $_POST['changeleader'];
$tag = $_POST['tag'];
$externo = $_POST['externo'];
$interno = $_POST['interno'];
$solicitud = $_POST['solicitud'];
$delete = $_POST['delete'];
$delete_u = $_POST['delete_u'];
if ($id != NULL)
{
$QueryF = doquery("SELECT * FROM {{table}} WHERE `id` = '".$id."'", "alliance", true);
if ($QueryF)
{
$Log .= "n".$lang['log_the_user'].$user['username']." ".$lang['log_modify_personal'].":n";
if ($name != NULL){
doquery("UPDATE {{table}} SET `ally_name` = '".$name."' WHERE `id` = '".$id."'", "alliance");
doquery("UPDATE {{table}} SET `ally_name` = '".$name."' WHERE `ally_id` = '".$id."'", "users");
$Log .= $lang['log_name_of_ally'].": ".$name."n";}
if ($tag != NULL){
doquery("UPDATE {{table}} SET `ally_tag` = '".$tag."' WHERE `id` = '".$id."'", "alliance");
$Log .= $lang['log_tag_of_ally'].": ".$tag."n";}
$i = 0;
$QueryF2 = doquery("SELECT * FROM {{table}} WHERE `id` = '".$changeleader."'", "users", true);
if ($QueryF2 && $changeleader != NULL && $QueryF2['ally_id'] == $id){
doquery("UPDATE {{table}} SET `ally_owner` = '".$changeleader."' WHERE `id` = '".$id."'", "alliance");
doquery("UPDATE {{table}} SET `ally_rank_id` = '0' WHERE `id` = '".$changeleader."'", "users");
$Log .= $lang['log_idnewleader'].": ".$changeleader."n";}
elseif (!$QueryF2 && $changeleader != NULL){
$Error .= '<tr><th colspan="3"><font color=red>'.$lang['ad_ally_not_exist3'].'</font></th></tr>';
$i++;}
if ($externo != NULL){
doquery("UPDATE {{table}} SET `ally_description` = '".$externo."' WHERE `id` = '".$id."'", "alliance");
$Log .= $lang['log_text_ext'].": ".$externo."n";}
if ($interno != NULL){
doquery("UPDATE {{table}} SET `ally_text` = '".$interno."' WHERE `id` = '".$id."'", "alliance");
$Log .= $lang['log_text_int'].": ".$interno."n";}
if ($solicitud != NULL){
doquery("UPDATE {{table}} SET `ally_request` = '".$solicitud."' WHERE `id` = '".$id."'", "alliance");
$Log .= $lang['log_text_sol'].": ".$solicitud."n";}
if ($delete == 'on'){
doquery("DELETE FROM {{table}} WHERE `id` = '".$id."'", "alliance");
doquery("UPDATE {{table}} SET `ally_id` = '0', `ally_name` = '', `ally_request` = '0', `ally_rank_id` = '0', `ally_register_time` = '0',
`ally_request` = '0' WHERE `ally_id` = '".$id."'", "users");
$Log .= $lang['log_ally_delete']."n";}
$QueryF3 = doquery("SELECT * FROM {{table}} WHERE `id` = '".$delete_u."'", "users", true);
if ($QueryF3 && $delete_u != NULL){
doquery("UPDATE {{table}} SET `ally_members` = ally_members - 1 WHERE `id` = '".$id."'", "alliance");
doquery("UPDATE {{table}} SET `ally_id` = '0', `ally_name` = '', `ally_request` = '0', `ally_rank_id` = '0', `ally_register_time` = '0',
`ally_request` = '0' WHERE `id` = '".$delete_u."' AND `ally_id` = '".$id."'", "users");
$Log .= $lang['log_id_user_expu'].": ".$delete_u."n";}
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;
$Log .= $lang['log_to_ally_whosid'].$id."n";
LogFunction($Log, "AllianceLog", $LogCanWork);
}
else
{
$parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_ally_not_exist'].'</font></th></tr>';
}
}
else
{
$parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_forgiven_id'].'</font></th></tr>';
}
}
display (parsetemplate(gettemplate("adm/EditorTPL/AllianceBody"), $parse), false, '', true, false);
break;
default:
if ($user['authlevel'] == 3)
$parse['changepersonal'] =
'<tr>
<th><a href="AccountEditorPage.php?page=personal'.$parse['getuser'].'"><img src="../styles/images/Adm/arrowright.png" width="16" height="10"/> '.$lang['ad_editor_personal'].'</a></th>
</tr>';
display(parsetemplate(gettemplate('adm/EditorTPL/EditorBody'), $parse), false, '', true, false);
}
?>