PageRenderTime 27ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 0ms

/src/2.10.2/upload/adm/AccountEditorPage.php

https://github.com/SantiHarry/XG-Proyect-v2.10.x
PHP | 1010 lines | 867 code | 128 blank | 15 comment | 202 complexity | d929246a8fe711926d259cb23a53353c MD5 | raw file
  1. <?php
  2. /**
  3. * @project XG Proyect
  4. * @version 2.10.x build 0000
  5. * @copyright Copyright (C) 2008 - 2012
  6. */
  7. define('INSIDE' , TRUE);
  8. define('INSTALL' , FALSE);
  9. define('IN_ADMIN', TRUE);
  10. define('XGP_ROOT', './../');
  11. include(XGP_ROOT . 'global.php');
  12. if ($EditUsers != 1) die(message ($lang['404_page']));
  13. $parse = $lang;
  14. switch($_GET[page])
  15. {
  16. case'resources':
  17. $id = $_POST['id'];
  18. $id_dark = $_POST['id_dark'];
  19. $metal = $_POST['metal'];
  20. $cristal = $_POST['cristal'];
  21. $deut = $_POST['deut'];
  22. $dark = $_POST['dark'];
  23. if ($_POST){
  24. if(is_numeric($id) && is_numeric($metal) && is_numeric($cristal) && is_numeric($deut) && is_numeric($dark) && is_numeric($id_dark))
  25. {
  26. if ($_POST['add'])
  27. {
  28. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  29. $QryUpdatePlanet .= "`metal` = `metal` + '". $metal ."', ";
  30. $QryUpdatePlanet .= "`crystal` = `crystal` + '". $cristal ."', ";
  31. $QryUpdatePlanet .= "`deuterium` = `deuterium` + '". $deut ."' ";
  32. $QryUpdatePlanet .= "WHERE ";
  33. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  34. doquery( $QryUpdatePlanet, "planets");
  35. if ($id_dark != NULL)
  36. {
  37. $QryUpdateUser = "UPDATE {{table}} SET ";
  38. $QryUpdateUser .= "`darkmatter` = `darkmatter` + '". $dark ."' ";
  39. $QryUpdateUser .= "WHERE ";
  40. $QryUpdateUser .= "`id` = '". $id_dark ."' ";
  41. doquery( $QryUpdateUser, "users");
  42. }
  43. $Name = $lang['log_moree'];
  44. $parse['display'] = '<tr><th colspan="2"><font color=lime>'.$lang['ad_add_sucess'].'</font></th></tr>';
  45. }
  46. elseif ($_POST['delete'])
  47. {
  48. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  49. $QryUpdatePlanet .= "`metal` = `metal` - '". $metal ."', ";
  50. $QryUpdatePlanet .= "`crystal` = `crystal` - '". $cristal ."', ";
  51. $QryUpdatePlanet .= "`deuterium` = `deuterium` - '". $deut ."' ";
  52. $QryUpdatePlanet .= "WHERE ";
  53. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  54. doquery( $QryUpdatePlanet, "planets");
  55. if ($id_dark != NULL)
  56. {
  57. $QryUpdateUser = "UPDATE {{table}} SET ";
  58. $QryUpdateUser .= "`darkmatter` = `darkmatter` - '". $dark ."' ";
  59. $QryUpdateUser .= "WHERE ";
  60. $QryUpdateUser .= "`id` = '". $id_dark ."' ";
  61. doquery( $QryUpdateUser, "users");
  62. }
  63. $Name = $lang['log_nomoree'];
  64. $parse['display'] = '<tr><th colspan="2"><font color=lime>'.$lang['ad_delete_sucess'].'</font></th></tr>';
  65. }
  66. if ($_POST['add'] || $_POST['delete'])
  67. {
  68. $Log .= "\n".$lang['log_the_user'].$user['username']." ".$Name.":\n";
  69. $Log .= $lang['metal'].": ".$metal."\n";
  70. $Log .= $lang['crystal'].": ".$cristal."\n";
  71. $Log .= $lang['deuterium'].": ".$deut."\n";
  72. $Log .= $lang['log_to_planet'].$id."\n";
  73. $Log .= $lang['log_and'].$lang['darkmatter'].": ".$dark."\n";
  74. $Log .= $lang['log_to_user'].$id_dark."\n";
  75. LogFunction($Log, "ResourcesLog", $LogCanWork);
  76. }
  77. }
  78. else
  79. {
  80. $parse['display'] = '<tr><th colspan="2"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
  81. }
  82. }
  83. display (parsetemplate(gettemplate("adm/EditorTPL/ResourcesBody"), $parse), FALSE, '', TRUE, FALSE);
  84. break;
  85. case'ships':
  86. if($_POST)
  87. {
  88. $id = $_POST['id'];
  89. $light_hunter = $_POST['light_hunter'];
  90. $heavy_hunter = $_POST['heavy_hunter'];
  91. $small_ship_cargo = $_POST['small_ship_cargo'];
  92. $big_ship_cargo = $_POST['big_ship_cargo'];
  93. $crusher = $_POST['crusher'];
  94. $battle_ship = $_POST['battle_ship'];
  95. $colonizer = $_POST['colonizer'];
  96. $recycler = $_POST['recycler'];
  97. $spy_sonde = $_POST['spy_sonde'];
  98. $bomber_ship = $_POST['bomber_ship'];
  99. $solar_satelit = $_POST['solar_satelit'];
  100. $destructor = $_POST['destructor'];
  101. $dearth_star = $_POST['dearth_star'];
  102. $battleship = $_POST['battleship'];
  103. if(is_numeric($id) && is_numeric($light_hunter) && is_numeric($heavy_hunter) && is_numeric($small_ship_cargo) && is_numeric($big_ship_cargo) &&
  104. is_numeric($crusher) && is_numeric($battle_ship) && is_numeric($colonizer) && is_numeric($recycler) && is_numeric($spy_sonde) &&
  105. is_numeric($bomber_ship) && is_numeric($solar_satelit) && is_numeric($destructor) && is_numeric($dearth_star) &&
  106. is_numeric($battleship))
  107. {
  108. if ($_POST['add'])
  109. {
  110. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  111. $QryUpdatePlanet .= "`small_ship_cargo` = `small_ship_cargo` + '". $small_ship_cargo ."', ";
  112. $QryUpdatePlanet .= "`battleship` = `battleship` + '". $battleship ."', ";
  113. $QryUpdatePlanet .= "`dearth_star` = `dearth_star` + '". $dearth_star ."', ";
  114. $QryUpdatePlanet .= "`destructor` = `destructor` + '". $destructor ."', ";
  115. $QryUpdatePlanet .= "`solar_satelit` = `solar_satelit` + '". $solar_satelit ."', ";
  116. $QryUpdatePlanet .= "`bomber_ship` = `bomber_ship` + '". $bomber_ship ."', ";
  117. $QryUpdatePlanet .= "`spy_sonde` = `spy_sonde` + '". $spy_sonde ."', ";
  118. $QryUpdatePlanet .= "`recycler` = `recycler` + '". $recycler ."', ";
  119. $QryUpdatePlanet .= "`colonizer` = `colonizer` + '". $colonizer ."', ";
  120. $QryUpdatePlanet .= "`battle_ship` = `battle_ship` + '". $battle_ship ."', ";
  121. $QryUpdatePlanet .= "`crusher` = `crusher` + '". $crusher ."', ";
  122. $QryUpdatePlanet .= "`heavy_hunter` = `heavy_hunter` + '". $heavy_hunter ."', ";
  123. $QryUpdatePlanet .= "`big_ship_cargo` = `big_ship_cargo` + '". $big_ship_cargo ."', ";
  124. $QryUpdatePlanet .= "`light_hunter` = `light_hunter` + '". $light_hunter ."' ";
  125. $QryUpdatePlanet .= "WHERE ";
  126. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  127. doquery( $QryUpdatePlanet, "planets");
  128. $Name = $lang['log_moree'];
  129. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_add_sucess_ships'].'</font></th></tr>';
  130. }
  131. elseif ($_POST['delete'])
  132. {
  133. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  134. $QryUpdatePlanet .= "`small_ship_cargo` = `small_ship_cargo` - '". $small_ship_cargo ."', ";
  135. $QryUpdatePlanet .= "`battleship` = `battleship` - '". $battleship ."', ";
  136. $QryUpdatePlanet .= "`dearth_star` = `dearth_star` - '". $dearth_star ."', ";
  137. $QryUpdatePlanet .= "`destructor` = `destructor` - '". $destructor ."', ";
  138. $QryUpdatePlanet .= "`solar_satelit` = `solar_satelit` - '". $solar_satelit ."', ";
  139. $QryUpdatePlanet .= "`bomber_ship` = `bomber_ship` - '". $bomber_ship ."', ";
  140. $QryUpdatePlanet .= "`spy_sonde` = `spy_sonde` - '". $spy_sonde ."', ";
  141. $QryUpdatePlanet .= "`recycler` = `recycler` - '". $recycler ."', ";
  142. $QryUpdatePlanet .= "`colonizer` = `colonizer` - '". $colonizer ."', ";
  143. $QryUpdatePlanet .= "`battle_ship` = `battle_ship` - '". $battle_ship ."', ";
  144. $QryUpdatePlanet .= "`crusher` = `crusher` - '". $crusher ."', ";
  145. $QryUpdatePlanet .= "`heavy_hunter` = `heavy_hunter` - '". $heavy_hunter ."', ";
  146. $QryUpdatePlanet .= "`big_ship_cargo` = `big_ship_cargo` - '". $big_ship_cargo ."', ";
  147. $QryUpdatePlanet .= "`light_hunter` = `light_hunter` - '". $light_hunter ."' ";
  148. $QryUpdatePlanet .= "WHERE ";
  149. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  150. doquery( $QryUpdatePlanet, "planets");
  151. $Name = $lang['log_nomoree'];
  152. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_delete_sucess_ships'].'</font></th></tr>';
  153. }
  154. if ($_POST['add'] || $_POST['delete'])
  155. {
  156. $Log .= "\n".$lang['log_the_user'].$user['username']." ".$Name.":\n";
  157. $Log .= $lang['small_ship_cargo'].": ".$small_ship_cargo."\n";
  158. $Log .= $lang['big_ship_cargo'].": ".$big_ship_cargo."\n";
  159. $Log .= $lang['light_hunter'].": ".$light_hunter."\n";
  160. $Log .= $lang['heavy_hunter'].": ".$heavy_hunter."\n";
  161. $Log .= $lang['crusher'].": ".$crusher."\n";
  162. $Log .= $lang['battle_ship'].": ".$battle_ship."\n";
  163. $Log .= $lang['colonizer'].": ".$colonizer."\n";
  164. $Log .= $lang['recycler'].": ".$recycler."\n";
  165. $Log .= $lang['spy_sonde'].": ".$spy_sonde."\n";
  166. $Log .= $lang['bomber_ship'].": ".$bomber_ship."\n";
  167. $Log .= $lang['solar_satelit'].": ".$solar_satelit."\n";
  168. $Log .= $lang['destructor'].": ".$destructor."\n";
  169. $Log .= $lang['dearth_star'].": ".$dearth_star."\n";
  170. $Log .= $lang['battleship'].": ".$battleship."\n";
  171. $Log .= $lang['log_to_planet'].$id."\n";
  172. LogFunction($Log, "ShipsLog", $LogCanWork);
  173. }
  174. }
  175. else
  176. {
  177. $parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
  178. }
  179. }
  180. display (parsetemplate(gettemplate("adm/EditorTPL/ShipsBody"), $parse), FALSE, '', TRUE, FALSE);
  181. break;
  182. case'defenses':
  183. if ($_POST)
  184. {
  185. $id = $_POST['id'];
  186. $misil_launcher = $_POST['misil_launcher'];
  187. $small_laser = $_POST['small_laser'];
  188. $big_laser = $_POST['big_laser'];
  189. $gauss_canyon = $_POST['gauss_canyon'];
  190. $ionic_canyon = $_POST['ionic_canyon'];
  191. $buster_canyon = $_POST['buster_canyon'];
  192. $small_protection_shield = $_POST['small_protection_shield'];
  193. $big_protection_shield = $_POST['big_protection_shield'];
  194. $interceptor_misil = $_POST['interceptor_misil'];
  195. $interplanetary_misil = $_POST['interplanetary_misil'];
  196. if(is_numeric($id) && is_numeric($misil_launcher) && is_numeric($small_laser) && is_numeric($big_laser) && is_numeric($gauss_canyon) &&
  197. is_numeric($ionic_canyon) && is_numeric($buster_canyon) && is_numeric($small_protection_shield) && is_numeric($big_protection_shield) &&
  198. is_numeric($interceptor_misil) && is_numeric($interplanetary_misil))
  199. {
  200. if ($_POST['add'])
  201. {
  202. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  203. $QryUpdatePlanet .= "`misil_launcher` = `misil_launcher` + '". $misil_launcher ."', ";
  204. $QryUpdatePlanet .= "`small_laser` = `small_laser` + '". $small_laser ."', ";
  205. $QryUpdatePlanet .= "`big_laser` = `big_laser` + '". $big_laser ."', ";
  206. $QryUpdatePlanet .= "`gauss_canyon` = `gauss_canyon` + '". $gauss_canyon ."', ";
  207. $QryUpdatePlanet .= "`ionic_canyon` = `ionic_canyon` + '". $ionic_canyon ."', ";
  208. $QryUpdatePlanet .= "`buster_canyon` = `buster_canyon` + '". $buster_canyon ."', ";
  209. $QryUpdatePlanet .= "`small_protection_shield` = `small_protection_shield` + '". $small_protection_shield ."', ";
  210. $QryUpdatePlanet .= "`big_protection_shield` = `big_protection_shield` + '". $big_protection_shield ."', ";
  211. $QryUpdatePlanet .= "`interceptor_misil` = `interceptor_misil` + '". $interceptor_misil ."', ";
  212. $QryUpdatePlanet .= "`interplanetary_misil` = `interplanetary_misil` + '". $interplanetary_misil ."' ";
  213. $QryUpdatePlanet .= "WHERE ";
  214. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  215. doquery( $QryUpdatePlanet, "planets");
  216. $Name = $lang['log_moree'];
  217. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_add_defenses_succes'].'</font></th></tr>';
  218. }
  219. elseif ($_POST['delete'])
  220. {
  221. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  222. $QryUpdatePlanet .= "`misil_launcher` = `misil_launcher` - '". $misil_launcher ."', ";
  223. $QryUpdatePlanet .= "`small_laser` = `small_laser` - '". $small_laser ."', ";
  224. $QryUpdatePlanet .= "`big_laser` = `big_laser` - '". $big_laser ."', ";
  225. $QryUpdatePlanet .= "`gauss_canyon` = `gauss_canyon` - '". $gauss_canyon ."', ";
  226. $QryUpdatePlanet .= "`ionic_canyon` = `ionic_canyon` - '". $ionic_canyon ."', ";
  227. $QryUpdatePlanet .= "`buster_canyon` = `buster_canyon` - '". $buster_canyon ."', ";
  228. $QryUpdatePlanet .= "`small_protection_shield` = `small_protection_shield` - '". $small_protection_shield ."', ";
  229. $QryUpdatePlanet .= "`big_protection_shield` = `big_protection_shield` - '". $big_protection_shield ."', ";
  230. $QryUpdatePlanet .= "`interceptor_misil` = `interceptor_misil` - '". $interceptor_misil ."', ";
  231. $QryUpdatePlanet .= "`interplanetary_misil` = `interplanetary_misil` - '". $interplanetary_misil ."' ";
  232. $QryUpdatePlanet .= "WHERE ";
  233. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  234. doquery( $QryUpdatePlanet, "planets");
  235. $Name = $lang['log_nomoree'];
  236. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_delete_defenses_succes'].'</font></th></tr>';
  237. }
  238. if ($_POST['add'] || $_POST['delete'])
  239. {
  240. $Log .= "\n".$lang['log_the_user'].$user['username']." ".$Name.":\n";
  241. $Log .= $lang['misil_launcher'].": ".$misil_launcher."\n";
  242. $Log .= $lang['small_laser'].": ".$small_laser."\n";
  243. $Log .= $lang['big_laser'].": ".$big_laser."\n";
  244. $Log .= $lang['gauss_canyon'].": ".$gauss_canyon."\n";
  245. $Log .= $lang['ionic_canyon'].": ".$ionic_canyon."\n";
  246. $Log .= $lang['buster_canyon'].": ".$buster_canyon."\n";
  247. $Log .= $lang['small_protection_shield'].": ".$small_protection_shield."\n";
  248. $Log .= $lang['big_protection_shield'].": ".$big_protection_shield."\n";
  249. $Log .= $lang['interceptor_misil'].": ".$interceptor_misil."\n";
  250. $Log .= $lang['interplanetary_misil'].": ".$interplanetary_misil."\n";
  251. $Log .= $lang['log_to_planet'].$id."\n";
  252. LogFunction($Log, "DefensesLog", $LogCanWork);
  253. }
  254. }
  255. else
  256. {
  257. $parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
  258. }
  259. }
  260. display (parsetemplate(gettemplate("adm/EditorTPL/DefensesBody"), $parse), FALSE, '', TRUE, FALSE);
  261. break;
  262. case'buildings':
  263. if ($_POST)
  264. {
  265. $id = $_POST['id'];
  266. $metal_mine = $_POST['metal_mine'];
  267. $crystal_mine = $_POST['crystal_mine'];
  268. $deuterium_sintetizer = $_POST['deuterium_sintetizer'];
  269. $solar_plant = $_POST['solar_plant'];
  270. $fusion_plant = $_POST['fusion_plant'];
  271. $robot_factory = $_POST['robot_factory'];
  272. $nano_factory = $_POST['nano_factory'];
  273. $hangar = $_POST['hangar'];
  274. $metal_store = $_POST['metal_store'];
  275. $crystal_store = $_POST['crystal_store'];
  276. $deuterium_store = $_POST['deuterium_store'];
  277. $laboratory = $_POST['laboratory'];
  278. $terraformer = $_POST['terraformer'];
  279. $ally_deposit = $_POST['ally_deposit'];
  280. $silo = $_POST['silo'];
  281. $mondbasis = $_POST['mondbasis'];
  282. $phalanx = $_POST['phalanx'];
  283. $sprungtor = $_POST['sprungtor'];
  284. if(is_numeric($id) && is_numeric($metal_mine) && is_numeric($crystal_mine) && is_numeric($deuterium_sintetizer) && is_numeric($solar_plant) &&
  285. is_numeric($fusion_plant) && is_numeric($robot_factory) && is_numeric($nano_factory) && is_numeric($hangar) &&
  286. is_numeric($metal_store) && is_numeric($crystal_store) && is_numeric($deuterium_store) && is_numeric($laboratory) &&
  287. is_numeric($terraformer)&& is_numeric($ally_deposit) && is_numeric($silo) && is_numeric($mondbasis) &&
  288. is_numeric($phalanx) && is_numeric($sprungtor))
  289. {
  290. $QueryFind = doquery("SELECT `planet_type` FROM {{table}} WHERE `id` = '".$id."'", "planets", TRUE);
  291. if ($_POST['add'])
  292. {
  293. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  294. $QryUpdatePlanet .= "`metal_mine` = `metal_mine` + '". $metal_mine ."', ";
  295. $QryUpdatePlanet .= "`crystal_mine` = `crystal_mine` + '". $crystal_mine ."', ";
  296. $QryUpdatePlanet .= "`deuterium_sintetizer` = `deuterium_sintetizer` + '". $deuterium_sintetizer ."', ";
  297. $QryUpdatePlanet .= "`solar_plant` = `solar_plant` + '". $solar_plant ."', ";
  298. $QryUpdatePlanet .= "`fusion_plant` = `fusion_plant` + '". $fusion_plant ."', ";
  299. $QryUpdatePlanet .= "`robot_factory` = `robot_factory` + '". $robot_factory ."', ";
  300. $QryUpdatePlanet .= "`nano_factory` = `nano_factory` + '". $nano_factory ."', ";
  301. $QryUpdatePlanet .= "`hangar` = `hangar` + '". $hangar ."', ";
  302. $QryUpdatePlanet .= "`metal_store` = `metal_store` + '". $metal_store ."', ";
  303. $QryUpdatePlanet .= "`crystal_store` = `crystal_store` + '". $crystal_store ."', ";
  304. $QryUpdatePlanet .= "`deuterium_store` = `deuterium_store` + '". $deuterium_store ."', ";
  305. $QryUpdatePlanet .= "`laboratory` = `laboratory` + '". $laboratory ."', ";
  306. $QryUpdatePlanet .= "`terraformer` = `terraformer` + '". $terraformer ."', ";
  307. $QryUpdatePlanet .= "`ally_deposit` = `ally_deposit` + '". $ally_deposit ."', ";
  308. $QryUpdatePlanet .= "`silo` = `silo` + '". $silo ."' ";
  309. $QryUpdatePlanet .= "WHERE ";
  310. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  311. doquery( $QryUpdatePlanet, "planets");
  312. if ($mondbasis or $phalanx or $sprungtor)
  313. {
  314. if ($QueryFind['planet_type'] == '3')
  315. {
  316. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  317. $QryUpdatePlanet .= "`mondbasis` = `mondbasis` + '". $mondbasis ."', ";
  318. $QryUpdatePlanet .= "`phalanx` = `phalanx` + '". $phalanx ."', ";
  319. $QryUpdatePlanet .= "`sprungtor` = `sprungtor` + '". $sprungtor ."' ";
  320. $QryUpdatePlanet .= "WHERE ";
  321. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  322. doquery( $QryUpdatePlanet, "planets");
  323. if ($mondbasis > 0)
  324. {
  325. $Sum = $mondbasis * FIELDS_BY_MOONBASIS_LEVEL;
  326. //doquery("UPDATE {{table}} SET `field_max` = field_max + '".$Sum."', `field_current` = field_current + '".$mondbasis."'", "planets");
  327. // FIX START BY alivan
  328. //doquery("UPDATE {{table}} SET `field_max` = field_max '".$Sum."', `field_current` = field_current '".$mondbasis."' WHERE `id` = '". $id ."'", "planets");
  329. // FIX END BY alivan
  330. //fix by jstar lol
  331. doquery("UPDATE {{table}} SET `field_max` = field_max + '".$Sum."', `field_current` = field_current + '".$mondbasis."' WHERE `id` = '". $id ."'", "planets");
  332. }
  333. }
  334. else
  335. {
  336. $parse['display2'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_error_moon_only'].'</font></th></tr>';
  337. }
  338. }
  339. $Name = $lang['log_moree'];
  340. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_add_succes'].'</font></th></tr>';
  341. }
  342. elseif ($_POST['delete'])
  343. {
  344. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  345. $QryUpdatePlanet .= "`metal_mine` = `metal_mine` - '". $metal_mine ."', ";
  346. $QryUpdatePlanet .= "`crystal_mine` = `crystal_mine` - '". $crystal_mine ."', ";
  347. $QryUpdatePlanet .= "`deuterium_sintetizer` = `deuterium_sintetizer` - '". $deuterium_sintetizer ."', ";
  348. $QryUpdatePlanet .= "`solar_plant` = `solar_plant` - '". $solar_plant ."', ";
  349. $QryUpdatePlanet .= "`fusion_plant` = `fusion_plant` - '". $fusion_plant ."', ";
  350. $QryUpdatePlanet .= "`robot_factory` = `robot_factory` - '". $robot_factory ."', ";
  351. $QryUpdatePlanet .= "`nano_factory` = `nano_factory` - '". $nano_factory ."', ";
  352. $QryUpdatePlanet .= "`hangar` = `hangar` - '". $hangar ."', ";
  353. $QryUpdatePlanet .= "`metal_store` = `metal_store` - '". $metal_store ."', ";
  354. $QryUpdatePlanet .= "`crystal_store` = `crystal_store` - '". $crystal_store ."', ";
  355. $QryUpdatePlanet .= "`deuterium_store` = `deuterium_store` - '". $deuterium_store ."', ";
  356. $QryUpdatePlanet .= "`laboratory` = `laboratory` - '". $laboratory ."', ";
  357. $QryUpdatePlanet .= "`terraformer` = `terraformer` - '". $terraformer ."', ";
  358. $QryUpdatePlanet .= "`ally_deposit` = `ally_deposit` - '". $ally_deposit ."', ";
  359. $QryUpdatePlanet .= "`silo` = `silo` - '". $silo ."' ";
  360. $QryUpdatePlanet .= "WHERE ";
  361. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  362. doquery( $QryUpdatePlanet, "planets");
  363. if ($mondbasis or $phalanx or $sprungtor)
  364. {
  365. if ($QueryFind['planet_type'] == '3')
  366. {
  367. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  368. $QryUpdatePlanet .= "`mondbasis` = `mondbasis` - '". $mondbasis ."', ";
  369. $QryUpdatePlanet .= "`phalanx` = `phalanx` - '". $phalanx ."', ";
  370. $QryUpdatePlanet .= "`sprungtor` = `sprungtor` - '". $sprungtor ."' ";
  371. $QryUpdatePlanet .= "WHERE ";
  372. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  373. doquery( $QryUpdatePlanet, "planets");
  374. if ($mondbasis > 0)
  375. {
  376. $Sum = $mondbasis * FIELDS_BY_MOONBASIS_LEVEL;
  377. //doquery("UPDATE {{table}} SET `field_max` = field_max - '".$Sum."', `field_current` = field_current - '".$mondbasis."'", "planets");
  378. // FIX START BY alivan
  379. //doquery("UPDATE {{table}} SET `field_max` = field_max - '".$Sum."', `field_current` = field_current - '".$mondbasis."' WHERE `id` = '". $id ."'", "planets");
  380. // FIX END BY alivan
  381. //fix by jstar
  382. doquery("UPDATE {{table}} SET `field_max` = field_max - '".$Sum."', `field_current` = field_current - '".$mondbasis."' WHERE `id` = '". $id ."'", "planets");
  383. }
  384. }
  385. else
  386. {
  387. $parse['display2'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_error_moon_only'].'</font></th></tr>';
  388. }
  389. }
  390. $Name = $lang['log_nomoree'];
  391. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_delete_succes'].'</font></th></tr>';
  392. }
  393. if ($_POST['add'] || $_POST['delete'])
  394. {
  395. $Log .= "\n".$lang['log_the_user'].$user['username']." ".$Name.":\n";
  396. $Log .= $lang['metal_mine'].": ".$metal_mine."\n";
  397. $Log .= $lang['crystal_mine'].": ".$crystal_mine."\n";
  398. $Log .= $lang['deuterium_sintetizer'].": ".$deuterium_sintetizer."\n";
  399. $Log .= $lang['solar_plant'].": ".$solar_plant."\n";
  400. $Log .= $lang['fusion_plant'].": ".$fusion_plant."\n";
  401. $Log .= $lang['robot_factory'].": ".$robot_factory."\n";
  402. $Log .= $lang['nano_factory'].": ".$nano_factory."\n";
  403. $Log .= $lang['shipyard'].": ".$hangar."\n";
  404. $Log .= $lang['metal_store'].": ".$metal_store."\n";
  405. $Log .= $lang['crystal_store'].": ".$crystal_store."\n";
  406. $Log .= $lang['deuterium_store'].": ".$deuterium_store."\n";
  407. $Log .= $lang['laboratory'].": ".$laboratory."\n";
  408. $Log .= $lang['terraformer'].": ".$terraformer."\n";
  409. $Log .= $lang['ally_deposit'].": ".$ally_deposit."\n";
  410. $Log .= $lang['silo'].": ".$silo."\n";
  411. $Log .= $lang['moonbases'].": ".$mondbasis."\n";
  412. $Log .= $lang['phalanx'].": ".$phalanx."\n";
  413. $Log .= $lang['cuantic'].": ".$sprungtor."\n";
  414. $Log .= $lang['log_to_planet'].$id."\n";
  415. LogFunction($Log, "BuildingsLog", $LogCanWork);
  416. }
  417. }
  418. else
  419. {
  420. $parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
  421. }
  422. }
  423. display (parsetemplate(gettemplate("adm/EditorTPL/BuildingsBody"), $parse), FALSE, '', TRUE, FALSE);
  424. break;
  425. case'researchs':
  426. if ($_POST)
  427. {
  428. $id = $_POST['id'];
  429. $spy_tech = $_POST['spy_tech'];
  430. $computer_tech = $_POST['computer_tech'];
  431. $military_tech = $_POST['military_tech'];
  432. $defence_tech = $_POST['defence_tech'];
  433. $shield_tech = $_POST['shield_tech'];
  434. $energy_tech = $_POST['energy_tech'];
  435. $hyperspace_tech = $_POST['hyperspace_tech'];
  436. $combustion_tech = $_POST['combustion_tech'];
  437. $impulse_motor_tech = $_POST['impulse_motor_tech'];
  438. $hyperspace_motor_tech = $_POST['hyperspace_motor_tech'];
  439. $laser_tech = $_POST['laser_tech'];
  440. $ionic_tech = $_POST['ionic_tech'];
  441. $buster_tech = $_POST['buster_tech'];
  442. $intergalactic_tech = $_POST['intergalactic_tech'];
  443. $expedition_tech = $_POST['expedition_tech'];
  444. $graviton_tech = $_POST['graviton_tech'];
  445. if(is_numeric($id) && is_numeric($spy_tech) && is_numeric($computer_tech) && is_numeric($military_tech) && is_numeric($defence_tech) &&
  446. is_numeric($shield_tech) && is_numeric($energy_tech) && is_numeric($hyperspace_tech) && is_numeric($combustion_tech) &&
  447. is_numeric($impulse_motor_tech) && is_numeric($hyperspace_motor_tech) && is_numeric($laser_tech) && is_numeric($ionic_tech) &&
  448. is_numeric($buster_tech)&& is_numeric($intergalactic_tech) && is_numeric($expedition_tech) && is_numeric($graviton_tech))
  449. {
  450. if ($_POST['add'])
  451. {
  452. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  453. $QryUpdatePlanet .= "`spy_tech` = `spy_tech` + '". $spy_tech ."', ";
  454. $QryUpdatePlanet .= "`computer_tech` = `computer_tech` + '". $computer_tech ."', ";
  455. $QryUpdatePlanet .= "`military_tech` = `military_tech` + '". $military_tech ."', ";
  456. $QryUpdatePlanet .= "`defence_tech` = `defence_tech` + '". $defence_tech ."', ";
  457. $QryUpdatePlanet .= "`shield_tech` = `shield_tech` + '". $shield_tech ."', ";
  458. $QryUpdatePlanet .= "`energy_tech` = `energy_tech` + '". $energy_tech ."', ";
  459. $QryUpdatePlanet .= "`hyperspace_tech` = `hyperspace_tech` + '". $hyperspace_tech ."', ";
  460. $QryUpdatePlanet .= "`combustion_tech` = `combustion_tech` + '". $combustion_tech ."', ";
  461. $QryUpdatePlanet .= "`impulse_motor_tech` = `impulse_motor_tech` + '". $impulse_motor_tech ."', ";
  462. $QryUpdatePlanet .= "`hyperspace_motor_tech` = `hyperspace_motor_tech` + '". $hyperspace_motor_tech ."', ";
  463. $QryUpdatePlanet .= "`laser_tech` = `laser_tech` + '". $laser_tech ."', ";
  464. $QryUpdatePlanet .= "`ionic_tech` = `ionic_tech` + '". $ionic_tech ."', ";
  465. $QryUpdatePlanet .= "`buster_tech` = `buster_tech` + '". $buster_tech ."', ";
  466. $QryUpdatePlanet .= "`intergalactic_tech` = `intergalactic_tech` + '". $intergalactic_tech ."', ";
  467. $QryUpdatePlanet .= "`expedition_tech` = `expedition_tech` + '". $expedition_tech ."', ";
  468. $QryUpdatePlanet .= "`graviton_tech` = `graviton_tech` + '". $graviton_tech ."' ";
  469. $QryUpdatePlanet .= "WHERE ";
  470. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  471. doquery( $QryUpdatePlanet, "users");
  472. $Name = $lang['log_moree'];
  473. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_add_succes'].'</font></th></tr>';
  474. }
  475. elseif ($_POST['delete'])
  476. {
  477. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  478. $QryUpdatePlanet .= "`spy_tech` = `spy_tech` - '". $spy_tech ."', ";
  479. $QryUpdatePlanet .= "`computer_tech` = `computer_tech` - '". $computer_tech ."', ";
  480. $QryUpdatePlanet .= "`military_tech` = `military_tech` - '". $military_tech ."', ";
  481. $QryUpdatePlanet .= "`defence_tech` = `defence_tech` - '". $defence_tech ."', ";
  482. $QryUpdatePlanet .= "`shield_tech` = `shield_tech` - '". $shield_tech ."', ";
  483. $QryUpdatePlanet .= "`energy_tech` = `energy_tech` - '". $energy_tech ."', ";
  484. $QryUpdatePlanet .= "`hyperspace_tech` = `hyperspace_tech` - '". $hyperspace_tech ."', ";
  485. $QryUpdatePlanet .= "`combustion_tech` = `combustion_tech` - '". $combustion_tech ."', ";
  486. $QryUpdatePlanet .= "`impulse_motor_tech` = `impulse_motor_tech` - '". $impulse_motor_tech ."', ";
  487. $QryUpdatePlanet .= "`hyperspace_motor_tech` = `hyperspace_motor_tech` - '". $hyperspace_motor_tech ."', ";
  488. $QryUpdatePlanet .= "`laser_tech` = `laser_tech` - '". $laser_tech ."', ";
  489. $QryUpdatePlanet .= "`ionic_tech` = `ionic_tech` - '". $ionic_tech ."', ";
  490. $QryUpdatePlanet .= "`buster_tech` = `buster_tech` - '". $buster_tech ."', ";
  491. $QryUpdatePlanet .= "`intergalactic_tech` = `intergalactic_tech` - '". $intergalactic_tech ."', ";
  492. $QryUpdatePlanet .= "`expedition_tech` = `expedition_tech` - '". $expedition_tech ."', ";
  493. $QryUpdatePlanet .= "`graviton_tech` = `graviton_tech` - '". $graviton_tech ."' ";
  494. $QryUpdatePlanet .= "WHERE ";
  495. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  496. doquery( $QryUpdatePlanet, "users");
  497. $Name = $lang['log_nomoree'];
  498. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_delete_succes'].'</font></th></tr>';
  499. }
  500. if ($_POST['add'] || $_POST['delete'])
  501. {
  502. $Log .= "\n".$lang['log_the_user'].$user['username']." ".$Name.":\n";
  503. $Log .= $lang['spy_tech'].": ".$spy_tech."\n";
  504. $Log .= $lang['computer_tech'].": ".$computer_tech."\n";
  505. $Log .= $lang['military_tech'].": ".$military_tech."\n";
  506. $Log .= $lang['defence_tech'].": ".$defence_tech."\n";
  507. $Log .= $lang['shield_tech'].": ".$shield_tech."\n";
  508. $Log .= $lang['energy_tech'].": ".$energy_tech."\n";
  509. $Log .= $lang['hyperspace_tech'].": ".$hyperspace_tech."\n";
  510. $Log .= $lang['combustion_tech'].": ".$combustion_tech."\n";
  511. $Log .= $lang['impulse_motor_tech'].": ".$impulse_motor_tech."\n";
  512. $Log .= $lang['hyperspace_motor_tech'].": ".$hyperspace_motor_tech."\n";
  513. $Log .= $lang['laser_tech'].": ".$laser_tech."\n";
  514. $Log .= $lang['ionic_tech'].": ".$ionic_tech."\n";
  515. $Log .= $lang['buster_tech'].": ".$buster_tech."\n";
  516. $Log .= $lang['intergalactic_tech'].": ".$intergalactic_tech."\n";
  517. $Log .= $lang['expedition_tech'].": ".$expedition_tech."\n";
  518. $Log .= $lang['graviton_tech'].": ".$graviton_tech."\n";
  519. $Log .= $lang['log_to_user'].$id."\n";
  520. LogFunction($Log, "ResearchLog", $LogCanWork);
  521. }
  522. }
  523. else
  524. {
  525. $parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
  526. }
  527. }
  528. display (parsetemplate(gettemplate("adm/EditorTPL/ResearchBody"), $parse), FALSE, '', TRUE, FALSE);
  529. break;
  530. case 'personal':
  531. $parse['yes'] = $lang['one_is_yes'][1];
  532. $parse['no'] = $lang['one_is_yes'][0];
  533. if ($user['authlevel'] != 3) $parse['Block'] = "disabled='disabled'";
  534. if ($_POST)
  535. {
  536. if ($user['authlevel'] != 3 && $_POST['username'] != NULL && $_POST['password'] != NULL && $_POST['email_2'] != NULL &&
  537. $_POST['email'] != NULL ) die();
  538. if(!$_POST['id'])
  539. {
  540. $parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_forgiven_id'].'</font></th></tr>';
  541. }
  542. else
  543. {
  544. $Log .= "\n".$lang['log_the_user'].$user['username']." ".$lang['log_modify_personal'].":\n";
  545. $PersonalQuery = "UPDATE {{table}} SET ";
  546. if($_POST['username'] != NULL){
  547. $PersonalQuery .= "`username` = '".$_POST['username']."', ";
  548. $Log .= $lang['ad_personal_name'].": ".$_POST['username']."\n";}
  549. if($_POST['email'] != NULL){
  550. $PersonalQuery .= "`email` = '".$_POST['email']."', ";
  551. $Log .= $lang['ad_personal_email'].": ".$_POST['email']."\n";}
  552. if($_POST['email_2'] != NULL){
  553. $PersonalQuery .= "`email_2` = '".$_POST['email_2']."', ";
  554. $Log .= $lang['ad_personal_email2'].": ".$_POST['email_2']."\n";}
  555. if($_POST['password'] != NULL)
  556. $PersonalQuery .= "`password` = '".md5($_POST['password'])."', ";
  557. if($_POST['vacation'] != '')
  558. {
  559. if ($_POST['vacation'] == 'no')
  560. {
  561. $Answer = 0;
  562. $TimeAns = 0;
  563. }
  564. elseif ($_POST['vacation'] == 'yes')
  565. {
  566. $Answer = 1;
  567. $VTime = $_POST['d'] * 86400;
  568. $VTime += $_POST['h'] * 3600;
  569. $VTime += $_POST['m'] * 60;
  570. $VTime += $_POST['s'];
  571. $TimeAns = $VTime + time();
  572. }
  573. $PersonalQuery .= "`urlaubs_modus` = '".$Answer."', `urlaubs_until` = '".$TimeAns."' ";
  574. }
  575. else
  576. $PersonalQuery .= "`onlinetime` = '".time()."' ";
  577. if ($_POST['username'] or $_POST['email'] or $_POST['email_2'] or $_POST['password'] or $_POST['vacation'] != '')
  578. {
  579. $PersonalQuery .= "WHERE `id` = '".$_POST['id']."'";
  580. doquery($PersonalQuery, "users");
  581. $Log .= $lang['log_to_user'].$_POST['id']."\n";
  582. LogFunction($Log, "PersonalLog", $LogCanWork);
  583. }
  584. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_personal_succes'].'</font></th></tr>';
  585. }
  586. }
  587. display (parsetemplate(gettemplate("adm/EditorTPL/PersonalBody"), $parse), FALSE, '', TRUE, FALSE);
  588. break;
  589. case'officiers':
  590. if ($_POST)
  591. {
  592. $id = $_POST['id'];
  593. $rpg_geologue = $_POST['rpg_geologue'];
  594. $rpg_amiral = $_POST['rpg_amiral'];
  595. $rpg_ingenieur = $_POST['rpg_ingenieur'];
  596. $rpg_technocrate = $_POST['rpg_technocrate'];
  597. if(is_numeric($id) && is_numeric($rpg_geologue) && is_numeric($rpg_amiral) && is_numeric($rpg_ingenieur) && is_numeric($rpg_technocrate))
  598. {
  599. if ($_POST['add'])
  600. {
  601. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  602. $QryUpdatePlanet .= "`rpg_geologue` = `rpg_geologue` + '". $rpg_geologue ."', ";
  603. $QryUpdatePlanet .= "`rpg_amiral` = `rpg_amiral` + '". $rpg_amiral ."', ";
  604. $QryUpdatePlanet .= "`rpg_ingenieur` = `rpg_ingenieur` + '". $rpg_ingenieur ."', ";
  605. $QryUpdatePlanet .= "`rpg_technocrate` = `rpg_technocrate` + '". $rpg_technocrate ."' ";
  606. $QryUpdatePlanet .= "WHERE ";
  607. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  608. doquery( $QryUpdatePlanet, "users");
  609. $Name = $lang['log_moree'];
  610. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_offi_succes_add'].'</font></th></tr>';
  611. }
  612. elseif ($_POST['delete'])
  613. {
  614. $QryUpdatePlanet = "UPDATE {{table}} SET ";
  615. $QryUpdatePlanet .= "`rpg_geologue` = `rpg_geologue` - '". $rpg_geologue ."', ";
  616. $QryUpdatePlanet .= "`rpg_amiral` = `rpg_amiral` - '". $rpg_amiral ."', ";
  617. $QryUpdatePlanet .= "`rpg_ingenieur` = `rpg_ingenieur` - '". $rpg_ingenieur ."', ";
  618. $QryUpdatePlanet .= "`rpg_technocrate` = `rpg_technocrate` - '". $rpg_technocrate ."' ";
  619. $QryUpdatePlanet .= "WHERE ";
  620. $QryUpdatePlanet .= "`id` = '". $id ."' ";
  621. doquery( $QryUpdatePlanet, "users");
  622. $Name = $lang['log_nomoree'];
  623. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_offi_succes_delete'].'</font></th></tr>';
  624. }
  625. if ($_POST['add'] || $_POST['delete'])
  626. {
  627. $Log .= "\n".$lang['log_the_user'].$user['username']." ".$Name.":\n";
  628. $Log .= $lang['geologist'].": ".$rpg_geologue."\n";
  629. $Log .= $lang['admiral'].": ".$rpg_amiral."\n";
  630. $Log .= $lang['engineer'].": ".$rpg_ingenieur."\n";
  631. $Log .= $lang['technocrat'].": ".$rpg_technocrate."\n";
  632. $Log .= $lang['log_to_user'].$id."\n";
  633. LogFunction($Log, "OfficierLog", $LogCanWork);
  634. }
  635. }
  636. else
  637. {
  638. $parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
  639. }
  640. }
  641. display (parsetemplate(gettemplate("adm/EditorTPL/OfficiersBody"), $parse), FALSE, '', TRUE, FALSE);
  642. break;
  643. case 'planets':
  644. if ($_POST)
  645. {
  646. $id = $_POST['id'];
  647. $name = $_POST['name'];
  648. $change_id = $_POST['change_id'];
  649. $diameter = $_POST['diameter'];
  650. $fields = $_POST['fields'];
  651. $buildings = $_POST['0_buildings'];
  652. $ships = $_POST['0_ships'];
  653. $defenses = $_POST['0_defenses'];
  654. $c_hangar = $_POST['0_c_hangar'];
  655. $c_buildings = $_POST['0_c_buildings'];
  656. $change_pos = $_POST['change_position'];
  657. $galaxy = $_POST['g'];
  658. $system = $_POST['s'];
  659. $planet = $_POST['p'];
  660. $delete = $_POST['delete'];
  661. if ($id != NULL)
  662. {
  663. if (is_numeric($id))
  664. {
  665. $Log .= "\n".$lang['log_the_user'].$user['username']." ".$lang['log_modify_personal'].":\n";
  666. if ($delete != 'on')
  667. {
  668. if ($name != NULL){
  669. doquery("UPDATE {{table}} SET `name` = '".$name."' WHERE `id` = '".$id."'", "planets");
  670. $Log .= $lang['log_change_name_pla'].": ".$name."\n";}
  671. if ($buildings == 'on'){
  672. doquery("UPDATE {{table}} SET `metal_mine` = '0', `crystal_mine` = '0', `deuterium_sintetizer` = '0',
  673. `solar_plant` = '0', `fusion_plant` = '0', `robot_factory` = '0',
  674. `nano_factory` = '0', `hangar` = '0', `metal_store` = '0',
  675. `crystal_store` = '0', `deuterium_store` = '0', `laboratory` = '0',
  676. `terraformer` = '0', `ally_deposit` = '0', `silo` = '0', `mondbasis` = '0',
  677. `phalanx` = '0', `sprungtor` = '0', `last_jump_time` = '0' WHERE `id` = '".$id."'", "planets");
  678. $Log .= $lang['log_delete_all_edi']."\n";}
  679. if ($ships == 'on'){
  680. doquery("UPDATE {{table}} SET `small_ship_cargo` = '0', `big_ship_cargo` = '0', `light_hunter` = '0',
  681. `heavy_hunter` = '0', `crusher` = '0', `battle_ship` = '0',
  682. `colonizer` = '0', `recycler` = '0', `spy_sonde` = '0',
  683. `bomber_ship` = '0', `solar_satelit` = '0', `destructor` = '0',
  684. `dearth_star` = '0', `battleship` = '0' WHERE `id` = '".$id."'", "planets");
  685. $Log .= $lang['log_delete_all_ships']."\n";}
  686. if ($defenses == 'on'){
  687. doquery("UPDATE {{table}} SET `misil_launcher` = '0', `small_laser` = '0', `big_laser` = '0',
  688. `gauss_canyon` = '0', `ionic_canyon` = '0', `buster_canyon` = '0',
  689. `small_protection_shield` = '0', `big_protection_shield` = '0',
  690. `interceptor_misil` = '0', `interplanetary_misil` = '0' WHERE `id` = '".$id."'", "planets");
  691. $Log .= $lang['log_delete_all_def']."\n";}
  692. if ($c_hangar == 'on'){
  693. doquery("UPDATE {{table}} SET `b_hangar` = '0', `b_hangar_plus` = '0', `b_hangar_id` = '' WHERE `id` = '".$id."'", "planets");
  694. $Log .= $lang['log_delete_all_c_han']."\n";}
  695. if ($c_buildings == 'on'){
  696. doquery("UPDATE {{table}} SET `b_building` = '0', `b_building_id` = '' WHERE `id` = '".$id."'", "planets");
  697. $Log .= $lang['log_delete_all_c_edi']."\n";}
  698. $P = doquery("SELECT * FROM {{table}} WHERE `id` = '".$id."'", "planets", TRUE);
  699. if ($diameter != NULL && is_numeric($diameter) && $diameter > 0){
  700. doquery("UPDATE {{table}} SET `diameter` = '".$diameter."' WHERE `id` = '".$id."'", "planets");
  701. $Log .= $lang['log_change_diameter'].": ".$diameter."\n";}
  702. if ($fields != NULL && is_numeric($fields) && $fields > 0){
  703. doquery("UPDATE {{table}} SET `field_max` = '".$fields."' WHERE `id` = '".$id."'", "planets");
  704. $Log .= $lang['log_change_fields'].": ".$fields."\n";}
  705. if ($change_pos == 'on')
  706. {
  707. if (is_numeric($galaxy) && is_numeric($system) && is_numeric($planet) && $galaxy > 0 && $system > 0 && $planet > 0 &&
  708. $galaxy <= MAX_GALAXY_IN_WORLD && $system <= MAX_SYSTEM_IN_GALAXY && $planet <= MAX_PLANET_IN_SYSTEM)
  709. {
  710. $Queryyy = doquery("SELECT * FROM {{table}} WHERE `galaxy` = '".$galaxy."' AND `system` = '".$system."' AND
  711. `planet` = '".$planet."'", "galaxy", TRUE);
  712. if ($P['planet_type'] == '1')
  713. {
  714. if (!$Queryyy)
  715. {
  716. if ($Queryyy['id_luna'] != '0')
  717. {
  718. doquery ("UPDATE {{table}} SET `galaxy` = '".$galaxy."', `system` = '".$system."', `planet` = '".$planet."' WHERE
  719. `galaxy` = '".$P['galaxy']."' AND `system` = '".$P['system']."' AND `planet` = '".$P['planet']."' AND `planet_type` = '3'", "planets");
  720. }
  721. doquery ("UPDATE {{table}} SET `galaxy` = '".$galaxy."', `system` = '".$system."', `planet` = '".$planet."' WHERE
  722. `id` = '".$id."'", "planets");
  723. doquery ("UPDATE {{table}} SET `galaxy` = '".$galaxy."', `system` = '".$system."', `planet` = '".$planet."' WHERE
  724. `id_planet` = '".$id."'", "galaxy");
  725. $Name = $lang['log_planet_pos'];
  726. }
  727. else
  728. {
  729. $Error .= '<tr><th colspan="3"><font color=red>'.$lang['ad_pla_error_planets3'].'</font></th></tr>';
  730. }
  731. }
  732. elseif ($P['planet_type'] == '3')
  733. {
  734. if ($Queryyy)
  735. {
  736. if ($Queryyy['id_luna'] == '0')
  737. {
  738. doquery ("UPDATE {{table}} SET `id_luna` = '0' WHERE `galaxy` = '".$P['galaxy']."' AND `system` = '".$P['system']."' AND
  739. `planet` = '".$P['planet']."'", "galaxy");
  740. doquery ("UPDATE {{table}} SET `galaxy` = '".$galaxy."', `system` = '".$system."', `planet` = '".$planet."',
  741. `id_luna` = '".$id."' WHERE `id_planet` = '".$Queryyy['id_planet']."'", "galaxy");
  742. $QMOON2 = doquery("SELECT * FROM {{table}} WHERE `galaxy` = '".$galaxy."' AND `system` = '".$system."' AND
  743. `planet` = '".$planet."'", "planets", TRUE);
  744. doquery ("UPDATE {{table}} SET `galaxy` = '".$galaxy."', `system` = '".$system."', `planet` = '".$planet."',
  745. `id_owner` = '".$QMOON2['id_owner']."', `id_level` = '".$QMOON2['id_level']."' WHERE `id` = '".$id."' AND `planet_type` = '3'", "planets");
  746. $Name = $lang['log_moon_pos'];
  747. }
  748. else
  749. {
  750. $Error .= '<tr><th colspan="3"><font color=red>'.$lang['ad_pla_error_planets4'].'</font></th></tr>';
  751. }
  752. }
  753. else
  754. {
  755. $Error .= '<tr><th colspan="3"><font color=red>'.$lang['ad_pla_error_planets5'].'</font></th></tr>';
  756. }
  757. }
  758. $Log .= $lang['log_change_pla_pos'].$Name.": [".$galaxy.":".$system.":".$planet."]\n";
  759. }
  760. else
  761. {
  762. $Error .= '<tr><th colspan="3"><font color=red>'.$lang['ad_only_numbers'].'</font></th></tr>';
  763. }
  764. }
  765. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_pla_succes'].'</font></th></tr>';
  766. $parse['display2'] = $Error;
  767. }
  768. else
  769. {
  770. $QueryPlanetsS = doquery("SELECT planet_type FROM {{table}} WHERE id = '".$id."'", "planets", TRUE);
  771. if ($QueryPlanetsS['planet_type'] == '1')
  772. {
  773. doquery("DELETE FROM {{table}} WHERE id = '".$id."'", "planets");
  774. doquery("DELETE FROM {{table}} WHERE id_planet = '".$id."'", "galaxy");
  775. }
  776. else
  777. {
  778. doquery("DELETE FROM {{table}} WHERE id = '".$id."'", "planets");
  779. doquery("UPDATE {{table}} SET id_luna = '0', luna = '0' WHERE id_luna = '".$id."'", "galaxy");
  780. }
  781. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_pla_delete_planet_s'].'</font></th></tr>';
  782. }
  783. $Log .= $lang['log_to_planet'].$id."\n";
  784. LogFunction($Log, "PlanetsAndMoonsLog", $LogCanWork);
  785. }
  786. else
  787. {
  788. $parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['only_numbers'].'</font></th></tr>';
  789. }
  790. }
  791. else
  792. {
  793. $parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_forgiven_id'].'</font></th></tr>';
  794. }
  795. }
  796. display (parsetemplate(gettemplate("adm/EditorTPL/PlanetsMoonsBody"), $parse), FALSE, '', TRUE, FALSE);
  797. break;
  798. case 'alliances':
  799. if ($_POST)
  800. {
  801. $id = $_POST['id'];
  802. $name = $_POST['name'];
  803. $changeleader = $_POST['changeleader'];
  804. $tag = $_POST['tag'];
  805. $externo = $_POST['externo'];
  806. $interno = $_POST['interno'];
  807. $solicitud = $_POST['solicitud'];
  808. $delete = $_POST['delete'];
  809. $delete_u = $_POST['delete_u'];
  810. if ($id != NULL)
  811. {
  812. $QueryF = doquery("SELECT * FROM {{table}} WHERE `id` = '".$id."'", "alliance", TRUE);
  813. if ($QueryF)
  814. {
  815. $Log .= "\n".$lang['log_the_user'].$user['username']." ".$lang['log_modify_personal'].":\n";
  816. if ($name != NULL){
  817. doquery("UPDATE {{table}} SET `ally_name` = '".$name."' WHERE `id` = '".$id."'", "alliance");
  818. doquery("UPDATE {{table}} SET `ally_name` = '".$name."' WHERE `ally_id` = '".$id."'", "users");
  819. $Log .= $lang['log_name_of_ally'].": ".$name."\n";}
  820. if ($tag != NULL){
  821. doquery("UPDATE {{table}} SET `ally_tag` = '".$tag."' WHERE `id` = '".$id."'", "alliance");
  822. $Log .= $lang['log_tag_of_ally'].": ".$tag."\n";}
  823. $i = 0;
  824. $QueryF2 = doquery("SELECT * FROM {{table}} WHERE `id` = '".$changeleader."'", "users", TRUE);
  825. if ($QueryF2 && $changeleader != NULL && $QueryF2['ally_id'] == $id){
  826. doquery("UPDATE {{table}} SET `ally_owner` = '".$changeleader."' WHERE `id` = '".$id."'", "alliance");
  827. doquery("UPDATE {{table}} SET `ally_rank_id` = '0' WHERE `id` = '".$changeleader."'", "users");
  828. $Log .= $lang['log_idnewleader'].": ".$changeleader."\n";}
  829. elseif (!$QueryF2 && $changeleader != NULL){
  830. $Error .= '<tr><th colspan="3"><font color=red>'.$lang['ad_ally_not_exist3'].'</font></th></tr>';
  831. $i++;}
  832. if ($externo != NULL){
  833. doquery("UPDATE {{table}} SET `ally_description` = '".$externo."' WHERE `id` = '".$id."'", "alliance");
  834. $Log .= $lang['log_text_ext'].": ".$externo."\n";}
  835. if ($interno != NULL){
  836. doquery("UPDATE {{table}} SET `ally_text` = '".$interno."' WHERE `id` = '".$id."'", "alliance");
  837. $Log .= $lang['log_text_int'].": ".$interno."\n";}
  838. if ($solicitud != NULL){
  839. doquery("UPDATE {{table}} SET `ally_request` = '".$solicitud."' WHERE `id` = '".$id."'", "alliance");
  840. $Log .= $lang['log_text_sol'].": ".$solicitud."\n";}
  841. if ($delete == 'on'){
  842. doquery("DELETE FROM {{table}} WHERE `id` = '".$id."'", "alliance");
  843. doquery("UPDATE {{table}} SET `ally_id` = '0', `ally_name` = '', `ally_request` = '0', `ally_rank_id` = '0', `ally_register_time` = '0',
  844. `ally_request` = '0' WHERE `ally_id` = '".$id."'", "users");
  845. $Log .= $lang['log_ally_delete']."\n";}
  846. $QueryF3 = doquery("SELECT * FROM {{table}} WHERE `id` = '".$delete_u."'", "users", TRUE);
  847. if ($QueryF3 && $delete_u != NULL){
  848. doquery("UPDATE {{table}} SET `ally_members` = ally_members - 1 WHERE `id` = '".$id."'", "alliance");
  849. doquery("UPDATE {{table}} SET `ally_id` = '0', `ally_name` = '', `ally_request` = '0', `ally_rank_id` = '0', `ally_register_time` = '0',
  850. `ally_request` = '0' WHERE `id` = '".$delete_u."' AND `ally_id` = '".$id."'", "users");
  851. $Log .= $lang['log_id_user_expu'].": ".$delete_u."\n";}
  852. elseif (!$QueryF3 && $delete_u != NULL){
  853. $Error .= '<tr><th colspan="3"><font color=red>'.$lang['ad_ally_not_exist2'].'</font></th></tr>';
  854. $i++;}
  855. if ($i == 0)
  856. $parse['display'] = '<tr><th colspan="3"><font color=lime>'.$lang['ad_ally_succes'].'</font></th></tr>';
  857. else
  858. $parse['display'] = $Error;
  859. $Log .= $lang['log_to_ally_whosid'].$id."\n";
  860. LogFunction($Log, "AllianceLog", $LogCanWork);
  861. }
  862. else
  863. {
  864. $parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_ally_not_exist'].'</font></th></tr>';
  865. }
  866. }
  867. else
  868. {
  869. $parse['display'] = '<tr><th colspan="3"><font color=red>'.$lang['ad_forgiven_id'].'</font></th></tr>';
  870. }
  871. }
  872. display (parsetemplate(gettemplate("adm/EditorTPL/AllianceBody"), $parse), FALSE, '', TRUE, FALSE);
  873. break;
  874. default:
  875. if ($user['authlevel'] == 3)
  876. $parse['changepersonal'] =
  877. '<tr>
  878. <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>
  879. </tr>';
  880. display(parsetemplate(gettemplate('adm/EditorTPL/EditorBody'), $parse), FALSE, '', TRUE, FALSE);
  881. }
  882. ?>