/src/2.10.2/upload/adm/AccountEditorPage.php
PHP | 1010 lines | 867 code | 128 blank | 15 comment | 202 complexity | d929246a8fe711926d259cb23a53353c MD5 | raw file
- <?php
-
- /**
- * @project XG Proyect
- * @version 2.10.x build 0000
- * @copyright Copyright (C) 2008 - 2012
- */
-
- define('INSIDE' , TRUE);
- define('INSTALL' , FALSE);
- define('IN_ADMIN', TRUE);
- define('XGP_ROOT', './../');
-
- include(XGP_ROOT . 'global.php');
-
- 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'];
-
-
- 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))
- {
- 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 .= "`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 .= "`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['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'];
- $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))
- {
- 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 .= "`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 .= "`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['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");
- // FIX START BY alivan
- //doquery("UPDATE {{table}} SET `field_max` = field_max '".$Sum."', `field_current` = field_current '".$mondbasis."' WHERE `id` = '". $id ."'", "planets");
- // FIX END BY alivan
- //fix by jstar lol
- doquery("UPDATE {{table}} SET `field_max` = field_max + '".$Sum."', `field_current` = field_current + '".$mondbasis."' WHERE `id` = '". $id ."'", "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");
- // FIX START BY alivan
- //doquery("UPDATE {{table}} SET `field_max` = field_max - '".$Sum."', `field_current` = field_current - '".$mondbasis."' WHERE `id` = '". $id ."'", "planets");
- // FIX END BY alivan
- //fix by jstar
- doquery("UPDATE {{table}} SET `field_max` = field_max - '".$Sum."', `field_current` = field_current - '".$mondbasis."' WHERE `id` = '". $id ."'", "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'];
- $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($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 .= "`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 .= "`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['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'];
-
- if(is_numeric($id) && is_numeric($rpg_geologue) && is_numeric($rpg_amiral) && is_numeric($rpg_ingenieur) && is_numeric($rpg_technocrate))
- {
-
- 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 .= "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 .= "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['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' 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', `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);
- }
- ?>