PageRenderTime 41ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/includes/user.php

https://bitbucket.org/ogsteam/ogspy
PHP | 2897 lines | 2315 code | 321 blank | 261 comment | 473 complexity | afb8463db4a9648a237b82554e970d08 MD5 | raw file
Possible License(s): GPL-3.0, BSD-3-Clause 
    

  1. <?php
    2. 

  2. /**
    3. 

  3.  * user.php Fonctions concernant les utilisateurs
    4. 

  4.  * @author Kyser
    5. 

  5.  * @package OGSpy
    6. 

  6.  * @subpackage user
    7. 

  7.  * @copyright Copyright &copy; 2007, http://ogsteam.fr/
    8. 

  8.  * @modified $Date: 2012-11-05 13:04:30 +0100 (Mon, 05 Nov 2012) $
    9. 

  9.  * @author Kyser
    10. 

  10.  * @link $HeadURL: http://svn.ogsteam.fr/trunk/ogspy/includes/user.php $
    11. 

  11.  * @version 3.04b ( $Rev: 7752 $ ) 
    12. 

  12.  * $Id: user.php 7752 2012-11-05 12:04:30Z darknoon $
    13. 

  13.  */
    14. 

  14. 

  15. if (!defined('IN_SPYOGAME')) {
    16. 

  16.     die("Hacking attempt");
    17. 

  17. }
    18. 

  18. 

  19. /**
    20. 

  20.  * Verification des droits utilisateurs sur une action avec redirection le cas echeant
    21. 

  21.  * @param string $action Action verifie
    22. 

  22.  * @param int $user_id identificateur optionnel de l'utilisateur teste
    23. 

  23.  */
    24. 

  24. function user_check_auth($action, $user_id = null)
    25. 

  25. {
    26. 

  26.     global $user_data;
    27. 

  27. 

  28.     switch ($action) {
    29. 

  29.         case "user_create":
    30. 

  30.         case "usergroup_manage":
    31. 

  31.             if ($user_data["user_admin"] != 1 && $user_data["user_coadmin"] != 1 && $user_data["management_user"] !=
    32. 

  32.                 1)
    33. 

  33.                 redirection("index.php?action=message&id_message=forbidden&info");
    34. 

  34. 

  35.             break;
    36. 

  36. 

  37.         case "user_update":
    38. 

  38.             if ($user_data["user_admin"] != 1 && $user_data["user_coadmin"] != 1 && $user_data["management_user"] !=
    39. 

  39.                 1)
    40. 

  40.                 redirection("index.php?action=message&id_message=forbidden&info");
    41. 

  41. 

  42.             $info_user = user_get($user_id);
    43. 

  43.             if ($info_user === false)
    44. 

  44.                 redirection("index.php?action=message&id_message=deleteuser_failed&info");
    45. 

  45. 

  46.             if (($user_data["user_admin"] != 1 && $user_data["user_coadmin"] != 1 && $user_data["management_user"] !=
    47. 

  47.                 1) || ($info_user[0]["user_admin"] == 1) || (($user_data["user_coadmin"] == 1) &&
    48. 

  48.                 ($info_user[0]["user_coadmin"] == 1)) || (($user_data["user_coadmin"] != 1 && $user_data["management_user"] ==
    49. 

  49.                 1) && ($info_user[0]["user_coadmin"] == 1 || $info_user[0]["management_user"] ==
    50. 

  50.                 1))) {
    51. 

  51.                 redirection("index.php?action=message&id_message=forbidden&info");
    52. 

  52.             }
    53. 

  53. 

  54.             break;
    55. 

  55. 

  56. 

  57.         default:
    58. 

  58.             redirection("index.php?action=message&id_message=errorfatal&info");
    59. 

  59.     }
    60. 

  60. }
    61. 

  61. /**
    62. 

  62.  * Login d'un utilisateur
    63. 

  63.  * @global string $pub_login
    64. 

  64.  * @global string $pub_password
    65. 

  65.  * @global string $pub_goto
    66. 

  66.  * @todo Query : "select user_id, user_active from " . TABLE_USER .
    67. 

  67.             " where user_name = '" .  $db->sql_escape_string($pub_login) .
    68. 

  68.             "' and user_password = '" . md5(sha1($pub_password)) . "'";
    69. 

  69.  * @todo Query : "select user_lastvisit from " . TABLE_USER . " where user_id = " . $user_id;
    70. 

  70.  * @todo Query : "update " . TABLE_USER . " set user_lastvisit = " . time() ." where user_id = " . $user_id;
    71. 

  71.  * @todo Query : "update " . TABLE_STATISTIC ." set statistic_value = statistic_value + 1" " where statistic_name = 'connection_server'";
    72. 

  72.  * @todo Query : "insert ignore into " . TABLE_STATISTIC ." values ('connection_server', '1')";
    73. 

  73.  */
    74. 

  74. function user_login()
    75. 

  75. {
    76. 

  76.     global $db;
    77. 

  77.     global $pub_login, $pub_password, $pub_goto, $url_append;
    78. 

  78. 

  79.     if (!check_var($pub_login, "Pseudo_Groupname") || !check_var($pub_password,
    80. 

  80.         "Password") || !check_var($pub_goto, "Special", "#^[\w=&%+]+$#")) {
    81. 

  81.         redirection("index.php?action=message&id_message=errordata&info");
    82. 

  82.     }
    83. 

  83. 

  84.     if (!isset($pub_login) || !isset($pub_password)) {
    85. 

  85.         redirection("index.php?action=message&id_message=errorfatal&info");
    86. 

  86.     } else {
    87. 

  87.         $request = "SELECT user_id, user_active FROM " . TABLE_USER .
    88. 

  88.             " WHERE user_name = '" .  $db->sql_escape_string($pub_login) .
    89. 

  89.             "' AND user_password = '" . md5(sha1($pub_password)) . "'";
    90. 

  90.         $result = $db->sql_query($request);
    91. 

  91.         if (list($user_id, $user_active) = $db->sql_fetch_row($result)) {
    92. 

  92.             if ($user_active == 1) {
    93. 

  93.                 $request = "select user_lastvisit from " . TABLE_USER . " where user_id = " . $user_id;
    94. 

  94.                 $result = $db->sql_query($request);
    95. 

  95.                 list($lastvisit) = $db->sql_fetch_row($result);
    96. 

  96. 

  97.                 $request = "update " . TABLE_USER . " set user_lastvisit = " . time() .
    98. 

  98.                     " where user_id = " . $user_id;
    99. 

  99.                 $db->sql_query($request);
    100. 

  100.                 
    101. 

  101.                 $request = "update " . TABLE_STATISTIC .
    102. 

  102.                     " set statistic_value = statistic_value + 1";
    103. 

  103.                 $request .= " where statistic_name = 'connection_server'";
    104. 

  104.                 $db->sql_query($request);
    105. 

  105.                 if ($db->sql_affectedrows() == 0) {
    106. 

  106.                     $request = "insert ignore into " . TABLE_STATISTIC .
    107. 

  107.                         " values ('connection_server', '1')";
    108. 

  108.                     $db->sql_query($request);
    109. 

  109.                 }
    110. 

  110. 

  111.                 session_set_user_id($user_id, $lastvisit);
    112. 

  112.                 log_('login');
    113. 

  113.                 if(!isset($url_append)){
    114. 

  114.                 	$url_append="";
    115. 

  115.                 }
    116. 

  116.                 redirection("index.php?action=" . $pub_goto . "" . $url_append);
    117. 

  117.             } else {
    118. 

  118.                 redirection("index.php?action=message&id_message=account_lock&info");
    119. 

  119.             }
    120. 

  120.         } else {
    121. 

  121.             redirection("index.php?action=message&id_message=login_wrong&info");
    122. 

  122.         }
    123. 

  123.     }
    124. 

  124. }
    125. 

  125. /**
    126. 

  126. * Login d'un utilisateur avec redirection
    127. 

  127. * @global string $pub_login
    128. 

  128. * @global string $pub_password
    129. 

  129. * @global string $pub_goto
    130. 

  130. */
    131. 

  131. function user_login_redirection()
    132. 

  132. {
    133. 

  133. 	global $pub_goto, $url_append;
    134. 

  134. 	
    135. 

  135. 	if($pub_goto=='galaxy'){
    136. 

  136. 		global $pub_galaxy, $pub_system;
    137. 

  137. 		$url_append="&galaxy=" . $pub_galaxy . "&system=" . $pub_system;		
    138. 

  138. 		user_login();
    139. 

  139. 	} else {
    140. 

  140. 		user_login();
    141. 

  141. 	}
    142. 

  142. }
    143. 

  143. 

  144. /**
    145. 

  145.  * Deconnection utilisateur
    146. 

  146.  */
    147. 

  147. function user_logout()
    148. 

  148. {
    149. 

  149.     log_("logout");
    150. 

  150.     session_close();
    151. 

  151.     redirection("index.php");
    152. 

  152. }
    153. 

  153. /**
    154. 

  154.  * Verification de la validite des inputs utilisateurs
    155. 

  155.  * @param string $type Type de variable verifie (pseudo,groupname,password,galaxy,system)
    156. 

  156.  * @param string $string La chaine teste
    157. 

  157.  * @return false|string 
    158. 

  158.  */
    159. 

  159. function string_check($type, $string)
    160. 

  160. {
    161. 

  161.     if ($type == "pseudo" || $type == "groupname") {
    162. 

  162.         $length_min = 3;
    163. 

  163.         $length_max = 15;
    164. 

  164.     } elseif ($type = "password") {
    165. 

  165.         $length_min = 6;
    166. 

  166.         $length_max = 15;
    167. 

  167.     } elseif ($type = "galaxy") {
    168. 

  168.         $length_min = 1;
    169. 

  169.         $length_max = 999;
    170. 

  170.     } elseif ($type = "system" || $type = "systems") {
    171. 

  171.         $length_min = 1;
    172. 

  172.         $length_max = 999;
    173. 

  173.     }
    174. 

  174. 

  175.     $string = trim($string);
    176. 

  176.     if (strlen($string) < $length_min || strlen($string) > $length_max) {
    177. 

  177.         return false;
    178. 

  178.     }
    179. 

  179. 

  180.     return $string;
    181. 

  181. }
    182. 

  182. 

  183. /**
    184. 

  184.  * Modification des droits ogspy d'un utilisateur par l'admin
    185. 

  185.  */
    186. 

  186. function admin_user_set()
    187. 

  187. {
    188. 

  188.     global $user_data;
    189. 

  189.     global $pub_user_id, $pub_active, $pub_user_coadmin, $pub_management_user, $pub_management_ranking;
    190. 

  190. 

  191.     if (!check_var($pub_user_id, "Num") || !check_var($pub_active, "Num") || !
    192. 

  192.         check_var($pub_user_coadmin, "Num") || !check_var($pub_management_user, "Num") ||
    193. 

  193.         !check_var($pub_management_ranking, "Num")) {
    194. 

  194.         redirection("index.php?action=message&id_message=errordata&info");
    195. 

  195.     }
    196. 

  196. 

  197.     if (!isset($pub_user_id) || !isset($pub_active)) {
    198. 

  198.         redirection("index.php?action=message&id_message=admin_modifyuser_failed&info");
    199. 

  199.     }
    200. 

  200. 

  201.     //Vérification des droits
    202. 

  202.     user_check_auth("user_update", $pub_user_id);
    203. 

  203. 

  204.     if ($user_data["user_admin"] == 1) {
    205. 

  205.         if (!isset($pub_user_coadmin) || !isset($pub_management_user) || !isset($pub_management_ranking)) {
    206. 

  206.             redirection("index.php?action=message&id_message=admin_modifyuser_failed&info");
    207. 

  207.         }
    208. 

  208.     } elseif ($user_data["user_coadmin"] == 1) {
    209. 

  209.         $pub_user_coadmin = null;
    210. 

  210.         if (!isset($pub_management_user) || !isset($pub_management_ranking)) {
    211. 

  211.             redirection("index.php?action=message&id_message=admin_modifyuser_failed&info");
    212. 

  212.         }
    213. 

  213.     } else {
    214. 

  214.         $pub_user_coadmin = $pub_management_user = null;
    215. 

  215.     }
    216. 

  216.     if (user_get($pub_user_id) === false) {
    217. 

  217.         redirection("index.php?action=message&id_message=admin_modifyuser_failed&info");
    218. 

  218.     }
    219. 

  219.     user_set_grant($pub_user_id, null, $pub_active, $pub_user_coadmin, $pub_management_user,
    220. 

  220.         $pub_management_ranking);
    221. 

  221.     redirection("index.php?action=administration&subaction=member");
    222. 

  222. }
    223. 

  223. 

  224. /**
    225. 

  225.  * Generation d'un mot de passe par l'admin pour un utilisateur
    226. 

  226.  */
    227. 

  227. function admin_regeneratepwd()
    228. 

  228. {
    229. 

  229.     global $pub_user_id; // $pub_new_pass;
    230. 

  230.     $pass_id = "pub_pass_" . $pub_user_id;
    231. 

  231.     global $$pass_id;
    232. 

  232.     $new_pass = $$pass_id;
    233. 

  233. 

  234.     if (!check_var($pub_user_id, "Num")) {
    235. 

  235.         redirection("index.php?action=message&id_message=errordata&info");
    236. 

  236.     }
    237. 

  237. 

  238.     if (!isset($pub_user_id)) {
    239. 

  239.         redirection("index.php?action=message&id_message=errorfatal&info");
    240. 

  240.     }
    241. 

  241. 

  242.     user_check_auth("user_update", $pub_user_id);
    243. 

  243. 

  244.     if (user_get($pub_user_id) === false) {
    245. 

  245.         redirection("index.php?action=message&id_message=regeneratepwd_failed&info");
    246. 

  246.     }
    247. 

  247.     if ($new_pass != "") {
    248. 

  248.         $password = $new_pass;
    249. 

  249.     } else {
    250. 

  250.         $password = password_generator();
    251. 

  251.     }
    252. 

  252.     user_set_general($pub_user_id, null, $password);
    253. 

  253. 

  254.     $info = $pub_user_id . ":" . $password;
    255. 

  255.     log_("regeneratepwd", $pub_user_id);
    256. 

  256.     redirection("index.php?action=message&id_message=regeneratepwd_success&info=" .
    257. 

  257.         $info);
    258. 

  258. }
    259. 

  259. 

  260. /**
    261. 

  261.  * Modification du profil par un utilisateur
    262. 

  262.  * @todo Query : x11
    263. 

  263.  */
    264. 

  264. function member_user_set()
    265. 

  265. {
    266. 

  266.     global $db, $user_data, $user_technology;
    267. 

  267.     global $pub_pseudo, $pub_old_password, $pub_new_password, $pub_new_password2, $pub_galaxy,
    268. 

  268.         $pub_system, $pub_skin, $pub_disable_ip_check, $pub_off_commandant, $pub_off_amiral, $pub_off_ingenieur,
    269. 

  269.         $pub_off_geologue, $pub_off_technocrate, $pub_pseudo_ingame, $pub_pseudo_email;
    270. 

  270. 

  271.     if (!check_var($pub_pseudo, "Text") || !check_var($pub_old_password, "Text") ||
    272. 

  272.         !check_var($pub_new_password, "Text") || !check_var($pub_new_password2,
    273. 

  273.         "CharNum") || !check_var($pub_pseudo_email, "Email")
    274. 

  274. 		|| !check_var($pub_galaxy, "Num") || !check_var($pub_system, "Num") ||
    275. 

  275.         !check_var($pub_skin, "URL") || !check_var($pub_disable_ip_check, "Num") || !
    276. 

  276.         check_var($pub_pseudo_ingame, "Pseudo_ingame")) {
    277. 

  277.         redirection("index.php?action=message&id_message=errordata&info");
    278. 

  278.     }
    279. 

  279. 

  280.     $user_id = $user_data["user_id"];
    281. 

  281.     $user_info = user_get($user_id);
    282. 

  282. 	$user_empire = user_get_empire();
    283. 

  283. 	$user_technology = $user_empire["technology"];
    284. 

  284. 

  285.     $password_validated = null;
    286. 

  286.     if (!isset($pub_pseudo) || !isset($pub_old_password) || !isset($pub_new_password) ||
    287. 

  287.         !isset($pub_new_password2) || !isset($pub_pseudo_email) || !isset($pub_galaxy) || !isset($pub_system) || !
    288. 

  288.         isset($pub_skin)) {
    289. 

  289.         redirection("index.php?action=message&id_message=member_modifyuser_failed&info");
    290. 

  290.     }
    291. 

  291. 

  292.     if ($pub_old_password != "" || $pub_new_password != "" || $pub_new_password2 !=
    293. 

  293.         "") {
    294. 

  294.         if ($pub_old_password == "" || $pub_new_password == "" || $pub_new_password != $pub_new_password2) {
    295. 

  295.             redirection("index.php?action=message&id_message=member_modifyuser_failed_passwordcheck&info");
    296. 

  296.         }
    297. 

  297.         if (md5(sha1($pub_old_password)) != $user_info[0]["user_password"]) {
    298. 

  298.             redirection("index.php?action=message&id_message=member_modifyuser_failed_passwordcheck&info");
    299. 

  299.         }
    300. 

  300.         if (!check_var($pub_new_password, "Password")) {
    301. 

  301.             redirection("index.php?action=message&id_message=member_modifyuser_failed_password&info");
    302. 

  302.         }
    303. 

  303.     }
    304. 

  304. 

  305.     if (!check_var($pub_pseudo, "Pseudo_Groupname")) {
    306. 

  306.         redirection("index.php?action=message&id_message=member_modifyuser_failed_pseudo&info");
    307. 

  307.     }
    308. 

  308. 

  309.     //pseudo ingame
    310. 

  310.     if ($user_data["user_stat_name"] !== $pub_pseudo_ingame) {
    311. 

  311.         user_set_stat_name($pub_pseudo_ingame);
    312. 

  312.     }
    313. 

  313. 

  314. 	//compte Commandant
    315. 

  315.     if ($user_data['off_commandant'] == "0" && $pub_off_commandant == 1) {
    316. 

  316.         $db->sql_query("UPDATE " . TABLE_USER .
    317. 

  317.             " SET `off_commandant` = '1' WHERE `user_id` = " . $user_id);
    318. 

  318.     }
    319. 

  319.     if ($user_data['off_commandant'] == 1 && (is_null($pub_off_commandant) || $pub_off_commandant !=
    320. 

  320.         1)) {
    321. 

  321.         $db->sql_query("UPDATE " . TABLE_USER .
    322. 

  322.             " SET `off_commandant` = '0' WHERE `user_id` = " . $user_id);
    323. 

  323.     }
    324. 

  324. 

  325.     //compte amiral
    326. 

  326.     if ($user_data['off_amiral'] == "0" && $pub_off_amiral == 1) {
    327. 

  327.         $db->sql_query("UPDATE " . TABLE_USER .
    328. 

  328.             " SET `off_amiral` = '1' WHERE `user_id` = " . $user_id);
    329. 

  329.     }
    330. 

  330.     if ($user_data['off_amiral'] == 1 && (is_null($pub_off_amiral) || $pub_off_amiral !=
    331. 

  331.         1)) {
    332. 

  332.         $db->sql_query("UPDATE " . TABLE_USER .
    333. 

  333.             " SET `off_amiral` = '0' WHERE `user_id` = " . $user_id);
    334. 

  334.     }
    335. 

  335. 

  336.     //compte ingenieur
    337. 

  337.     if ($user_data['off_ingenieur'] == "0" && $pub_off_ingenieur == 1) {
    338. 

  338.         $db->sql_query("UPDATE " . TABLE_USER .
    339. 

  339.             " SET `off_ingenieur` = '1' WHERE `user_id` = " . $user_id);
    340. 

  340.     }
    341. 

  341.     if ($user_data['off_ingenieur'] == 1 && (is_null($pub_off_ingenieur) || $pub_off_ingenieur !=
    342. 

  342.         1)) {
    343. 

  343.         $db->sql_query("UPDATE " . TABLE_USER .
    344. 

  344.             " SET `off_ingenieur` = '0' WHERE `user_id` = " . $user_id);
    345. 

  345.     }
    346. 

  346. 

  347.     //compte geologue
    348. 

  348.     if ($user_data['off_geologue'] == "0" && $pub_off_geologue == 1) {
    349. 

  349.         $db->sql_query("UPDATE " . TABLE_USER .
    350. 

  350.             " SET `off_geologue` = '1' WHERE `user_id` = " . $user_id);
    351. 

  351.     }
    352. 

  352.     if ($user_data['off_geologue'] == 1 && (is_null($pub_off_geologue) || $pub_off_geologue !=
    353. 

  353.         1)) {
    354. 

  354.         $db->sql_query("UPDATE " . TABLE_USER .
    355. 

  355.             " SET `off_geologue` = '0' WHERE `user_id` = " . $user_id);
    356. 

  356.     }
    357. 

  357. 

  358.     //compte technocrate
    359. 

  359.     if ($user_data['off_technocrate'] == "0" && $pub_off_technocrate == 1) {
    360. 

  360.         $db->sql_query("UPDATE " . TABLE_USER .
    361. 

  361.             " SET `off_technocrate` = '1' WHERE `user_id` = " . $user_id);
    362. 

  362.         $tech = $user_technology['Esp'] + 2;
    363. 

  363.         $db->sql_query("UPDATE " . TABLE_USER_TECHNOLOGY . " SET `Esp` = " . $tech .
    364. 

  364.             " WHERE `user_id` = " . $user_id);
    365. 

  365.     }
    366. 

  366.     if ($user_data['off_technocrate'] == 1 && (is_null($pub_off_technocrate) || $pub_off_technocrate !=
    367. 

  367.         1)) {
    368. 

  368.         $db->sql_query("UPDATE " . TABLE_USER .
    369. 

  369.             " SET `off_technocrate` = '0' WHERE `user_id` = " . $user_id);
    370. 

  370.         $tech = $user_technology['Esp'] - 2;
    371. 

  371.         $db->sql_query("UPDATE " . TABLE_USER_TECHNOLOGY . " SET `Esp` = " . $tech .
    372. 

  372.             " WHERE `user_id` = " . $user_id);
    373. 

  373.     }
    374. 

  374. 

  375.     //Contrôle que le pseudo ne soit pas déjà utilisé
    376. 

  376.     $request = "select * from " . TABLE_USER . " where user_name = '" .
    377. 

  377.          $db->sql_escape_string($pub_pseudo) . "' and user_id <> " . $user_id;
    378. 

  378.     $result = $db->sql_query($request);
    379. 

  379.     if ($db->sql_numrows($result) != 0) {
    380. 

  380.         redirection("index.php?action=message&id_message=member_modifyuser_failed_pseudolocked&info");
    381. 

  381.     }
    382. 

  382. 

  383.     if (is_null($pub_disable_ip_check) || $pub_disable_ip_check != 1)
    384. 

  384.         $pub_disable_ip_check = 0;
    385. 

  385. 

  386.     user_set_general($user_id, $pub_pseudo, $pub_new_password, $pub_pseudo_email, null, $pub_galaxy, $pub_system,
    387. 

  387.         $pub_skin, $pub_disable_ip_check);
    388. 

  388.     redirection("index.php?action=profile");
    389. 

  389. }
    390. 

  390. 

  391. /**
    392. 

  392.  * Entree en BDD de donnees utilisateur
    393. 

  393.  * @todo Query x1
    394. 

  394.  */
    395. 

  395. function user_set_general($user_id, $user_name = null, $user_password = null, $user_email = null, $user_lastvisit = null,
    396. 

  396.     $user_galaxy = null, $user_system = null, $user_skin = null, $disable_ip_check = null)
    397. 

  397. {
    398. 

  398.     global $db, $user_data, $server_config;
    399. 

  399. 

  400.     if (!isset($user_id)) {
    401. 

  401.         redirection("index.php?action=message&id_message=errorfatal&info");
    402. 

  402.     }
    403. 

  403. 

  404.     if (!empty($user_galaxy)) {
    405. 

  405.         $user_galaxy = intval($user_galaxy);
    406. 

  406.         if ($user_galaxy < 1 || $user_galaxy > intval($server_config['num_of_galaxies']))
    407. 

  407.             $user_galaxy = 1;
    408. 

  408.     }
    409. 

  409.     if (!empty($user_system)) {
    410. 

  410.         $user_system = intval($user_system);
    411. 

  411.         if ($user_system < 1 || $user_system > intval($server_config['num_of_systems']))
    412. 

  412.             $user_system = 1;
    413. 

  413.     }
    414. 

  414. 

  415.     $update = "";
    416. 

  416. 

  417.     //Pseudo et mot de passe
    418. 

  418.     if (!empty($user_name))
    419. 

  419.         $update .= "user_name = '" .  $db->sql_escape_string($user_name) . "'";
    420. 

  420.     if (!empty($user_password))
    421. 

  421.         $update .= ((strlen($update) > 0) ? ", " : "") . "user_password = '" . md5(sha1
    422. 

  422.             ($user_password)) . "'";
    423. 

  423. 

  424.     //Galaxy et système solaire du membre
    425. 

  425.     if (!empty($user_galaxy))
    426. 

  426.         $update .= ((strlen($update) > 0) ? ", " : "") . "user_galaxy = '" . $user_galaxy .
    427. 

  427.             "'";
    428. 

  428.     if (!empty($user_system))
    429. 

  429.         $update .= ((strlen($update) > 0) ? ", " : "") . "user_system = '" . $user_system .
    430. 

  430.             "'";
    431. 

  431. 

  432.     //Dernière visite
    433. 

  433.     if (!empty($user_lastvisit))
    434. 

  434.         $update .= ((strlen($update) > 0) ? ", " : "") . "user_lastvisit = '" . $user_lastvisit .
    435. 

  435.             "'";
    436. 

  436.    
    437. 

  437.    //Email
    438. 

  438.     if (!empty($user_email))
    439. 

  439.         $update .= ((strlen($update) > 0) ? ", " : "") . "user_email = '" . $user_email .
    440. 

  440.             "'";			
    441. 

  441. 			
    442. 

  442.     //Skin
    443. 

  443.     if (!is_null($user_skin)) {
    444. 

  444.         if (strlen($user_skin) > 0 && substr($user_skin, strlen($user_skin) - 1) != "/")
    445. 

  445.             $user_skin .= "/";
    446. 

  446.         $update .= ((strlen($update) > 0) ? ", " : "") . "user_skin = '" .
    447. 

  447.              $db->sql_escape_string($user_skin) . "'";
    448. 

  448.     }
    449. 

  449. 

  450.     //Désactivation de la vérification de l'adresse ip
    451. 

  451.     if (!is_null($disable_ip_check))
    452. 

  452.         $update .= ((strlen($update) > 0) ? ", " : "") . "disable_ip_check = '" . $disable_ip_check .
    453. 

  453.             "'";
    454. 

  454. 

  455. 

  456.     $request = "update " . TABLE_USER . " set " . $update . " where user_id = " . $user_id;
    457. 

  457.     $db->sql_query($request);
    458. 

  458. 

  459.     if ($user_id == $user_data['user_id']) {
    460. 

  460.         log_("modify_account");
    461. 

  461.     } else {
    462. 

  462.         log_("modify_account_admin", $user_id);
    463. 

  463.     }
    464. 

  464. }
    465. 

  465. 

  466. /**
    467. 

  467.  * Enregistrement des droits et status utilisateurs
    468. 

  468.  * @todo Query : x2
    469. 

  469.  */
    470. 

  470. function user_set_grant($user_id, $user_admin = null, $user_active = null, $user_coadmin = null,
    471. 

  471.     $management_user = null, $management_ranking = null)
    472. 

  472. {
    473. 

  473.     global $db, $user_data;
    474. 

  474. 

  475.     if (!isset($user_id)) {
    476. 

  476.         redirection("index.php?action=message&id_message=errorfatal&info");
    477. 

  477.     }
    478. 

  478. 

  479.     //Vérification des droits
    480. 

  480.     user_check_auth("user_update", $user_id);
    481. 

  481. 

  482.     $update = "";
    483. 

  483. 

  484.     //Activation membre
    485. 

  485.     if (!is_null($user_active)) {
    486. 

  486.         $update .= ((strlen($update) > 0) ? ", " : "") . "user_active = '" . intval($user_active) .
    487. 

  487.             "'";
    488. 

  488.         if (intval($user_active) == 0) {
    489. 

  489.             $request = "delete from " . TABLE_SESSIONS . " where session_user_id = " . $user_id;
    490. 

  490.             $db->sql_query($request);
    491. 

  491.         }
    492. 

  492.     }
    493. 

  493. 

  494.     //Co-administration
    495. 

  495.     if (!is_null($user_coadmin)) {
    496. 

  496.         $update .= ((strlen($update) > 0) ? ", " : "") . "user_coadmin = '" . intval($user_coadmin) .
    497. 

  497.             "'";
    498. 

  498.     }
    499. 

  499. 

  500.     //Gestion des membres
    501. 

  501.     if (!is_null($management_user)) {
    502. 

  502.         $update .= ((strlen($update) > 0) ? ", " : "") . "management_user = '" . intval($management_user) .
    503. 

  503.             "'";
    504. 

  504.     }
    505. 

  505. 

  506.     //Gestion des classements
    507. 

  507.     if (!is_null($management_ranking)) {
    508. 

  508.         $update .= ((strlen($update) > 0) ? ", " : "") . "management_ranking = '" .
    509. 

  509.             intval($management_ranking) . "'";
    510. 

  510.     }
    511. 

  511. 

  512. 

  513.     $request = "update " . TABLE_USER . " set " . $update . " where user_id = " . $user_id;
    514. 

  514.     $db->sql_query($request);
    515. 

  515. 

  516.     if ($user_id == $user_data['user_id']) {
    517. 

  517.         log_("modify_account");
    518. 

  518.     } else {
    519. 

  519.         log_("modify_account_admin", $user_id);
    520. 

  520.     }
    521. 

  521. }
    522. 

  522. /**
    523. 

  523.  * Enregistrement des statistiques utilisateurs
    524. 

  524.  * @todo Query : x1
    525. 

  525.  */
    526. 

  526. function user_set_stat($planet_added_web = null, $planet_added_ogs = null, $search = null,
    527. 

  527.     $spy_added_web = null, $spy_added_ogs = null, $rank_added_web = null, $rank_added_ogs = null,
    528. 

  528.     $planet_exported = null, $spy_exported = null, $rank_exported = null)
    529. 

  529. {
    530. 

  530.     global $db, $user_data;
    531. 

  531. 

  532.     $update = "";
    533. 

  533. 

  534.     //Statistiques envoi systèmes solaires et rapports d'espionnage
    535. 

  535.     if (!is_null($planet_added_web))
    536. 

  536.         $update .= ((strlen($update) > 0) ? ", " : "") .
    537. 

  537.             "planet_added_web = planet_added_web + " . $planet_added_web;
    538. 

  538.     if (!is_null($planet_added_ogs))
    539. 

  539.         $update .= ((strlen($update) > 0) ? ", " : "") .
    540. 

  540.             "planet_added_ogs = planet_added_ogs + " . $planet_added_ogs;
    541. 

  541.     if (!is_null($search))
    542. 

  542.         $update .= ((strlen($update) > 0) ? ", " : "") . "search = search + " . $search;
    543. 

  543.     if (!is_null($spy_added_web))
    544. 

  544.         $update .= ((strlen($update) > 0) ? ", " : "") .
    545. 

  545.             "spy_added_web = spy_added_web + " . $spy_added_web;
    546. 

  546.     if (!is_null($spy_added_ogs))
    547. 

  547.         $update .= ((strlen($update) > 0) ? ", " : "") .
    548. 

  548.             "spy_added_ogs = spy_added_ogs + " . $spy_added_ogs;
    549. 

  549.     if (!is_null($rank_added_web))
    550. 

  550.         $update .= ((strlen($update) > 0) ? ", " : "") .
    551. 

  551.             "rank_added_web = rank_added_web + " . $rank_added_web;
    552. 

  552.     if (!is_null($rank_added_ogs))
    553. 

  553.         $update .= ((strlen($update) > 0) ? ", " : "") .
    554. 

  554.             "rank_added_ogs = rank_added_ogs + " . $rank_added_ogs;
    555. 

  555.     if (!is_null($planet_exported))
    556. 

  556.         $update .= ((strlen($update) > 0) ? ", " : "") .
    557. 

  557.             "planet_exported = planet_exported + " . $planet_exported;
    558. 

  558.     if (!is_null($spy_exported))
    559. 

  559.         $update .= ((strlen($update) > 0) ? ", " : "") .
    560. 

  560.             "spy_exported = spy_exported + " . $spy_exported;
    561. 

  561.     if (!is_null($rank_exported))
    562. 

  562.         $update .= ((strlen($update) > 0) ? ", " : "") .
    563. 

  563.             "rank_exported = rank_exported + " . $rank_exported;
    564. 

  564. 

  565.     $request = "update " . TABLE_USER . " set " . $update . " where user_id = " . $user_data["user_id"];
    566. 

  566.     $db->sql_query($request);
    567. 

  567. }
    568. 

  568. 

  569. /**
    570. 

  570.  * Recuperation d'une ligne d'information utilisateur
    571. 

  571.  * @param int $user_id Identificateur optionnel d'1 utilisateur specifique 
    572. 

  572.  * @return Array Liste des utilisateurs ou de l'utilisateur specifique
    573. 

  573.  * @comment Pourrait peut etre avantageusement remplace par select * from TABLE_USER
    574. 

  574.  * @comment pour les eventuels champs supplementaires
    575. 

  575.  * @todo Query : x1
    576. 

  576.  */
    577. 

  577. function user_get($user_id = false)
    578. 

  578. {
    579. 

  579.     global $db;
    580. 

  580. 

  581.     $request = "select user_id, user_name, user_password, user_email, user_active, user_regdate, user_lastvisit," .
    582. 

  582.         " user_galaxy, user_system, user_admin, user_coadmin, management_user, management_ranking, disable_ip_check," .
    583. 

  583.         " off_commandant, off_amiral, off_ingenieur, off_geologue, off_technocrate" .
    584. 

  584.         " from " . TABLE_USER;
    585. 

  585. 

  586.     if ($user_id !== false) {
    587. 

  587.         $request .= " where user_id = " . $user_id;
    588. 

  588.     }
    589. 

  589.     $request .= " order by user_name";
    590. 

  590.     $result = $db->sql_query($request);
    591. 

  591. 

  592.     $info_users = array();
    593. 

  593.     while ($row = $db->sql_fetch_assoc($result)) {
    594. 

  594. 

  595.         $info_users[] = $row;
    596. 

  596.     }
    597. 

  597. 

  598.     if (sizeof($info_users) == 0) {
    599. 

  599.         return false;
    600. 

  600.     }
    601. 

  601. 

  602.     return $info_users;
    603. 

  603. }
    604. 

  604. /**
    605. 

  605.  * Recuperation des droits d'un utilisateur
    606. 

  606.  * @param int $user_id Identificateur de l'utilisateur demande
    607. 

  607.  * @todo Query : x1
    608. 

  608.  * @return Array Tableau des droits
    609. 

  609.  */
    610. 

  610. function user_get_auth($user_id)
    611. 

  611. {
    612. 

  612.     global $db;
    613. 

  613. 

  614.     $user_info = user_get($user_id);
    615. 

  615.     $user_info = $user_info[0];
    616. 

  616.     if ($user_info["user_admin"] == 1 || $user_info["user_coadmin"] == 1) {
    617. 

  617.         $user_auth = array("server_set_system" => 1, "server_set_spy" => 1,
    618. 

  618.             "server_set_rc" => 1, "server_set_ranking" => 1, "server_show_positionhided" =>
    619. 

  619.             1, "ogs_connection" => 1, "ogs_set_system" => 1, "ogs_get_system" => 1,
    620. 

  620.             "ogs_set_spy" => 1, "ogs_get_spy" => 1, "ogs_set_ranking" => 1,
    621. 

  621.             "ogs_get_ranking" => 1);
    622. 

  622. 

  623.         return $user_auth;
    624. 

  624.     }
    625. 

  625. 

  626.     $request = "select server_set_system, server_set_spy, server_set_rc, server_set_ranking, server_show_positionhided,";
    627. 

  627.     $request .= " ogs_connection, ogs_set_system, ogs_get_system, ogs_set_spy, ogs_get_spy, ogs_set_ranking, ogs_get_ranking";
    628. 

  628.     $request .= " from " . TABLE_GROUP . " g, " . TABLE_USER_GROUP . " u";
    629. 

  629.     $request .= " where g.group_id = u.group_id";
    630. 

  630.     $request .= " and user_id = " . $user_id;
    631. 

  631.     $result = $db->sql_query($request);
    632. 

  632. 

  633.     if ($db->sql_numrows($result) > 0) {
    634. 

  634.         $user_auth = array("server_set_system" => 0, "server_set_spy" => 0,
    635. 

  635.             "server_set_rc" => 0, "server_set_ranking" => 0, "server_show_positionhided" =>
    636. 

  636.             0, "ogs_connection" => 0, "ogs_set_system" => 0, "ogs_get_system" => 0,
    637. 

  637.             "ogs_set_spy" => 0, "ogs_get_spy" => 0, "ogs_set_ranking" => 0,
    638. 

  638.             "ogs_get_ranking" => 0);
    639. 

  639. 

  640.         while ($row = $db->sql_fetch_assoc($result)) {
    641. 

  641.             if ($row["server_set_system"] == 1)
    642. 

  642.                 $user_auth["server_set_system"] = 1;
    643. 

  643.             if ($row["server_set_spy"] == 1)
    644. 

  644.                 $user_auth["server_set_spy"] = 1;
    645. 

  645.             if ($row["server_set_rc"] == 1)
    646. 

  646.                 $user_auth["server_set_rc"] = 1;
    647. 

  647.             if ($row["server_set_ranking"] == 1)
    648. 

  648.                 $user_auth["server_set_ranking"] = 1;
    649. 

  649.             if ($row["server_show_positionhided"] == 1)
    650. 

  650.                 $user_auth["server_show_positionhided"] = 1;
    651. 

  651.             if ($row["ogs_connection"] == 1)
    652. 

  652.                 $user_auth["ogs_connection"] = 1;
    653. 

  653.             if ($row["ogs_set_system"] == 1)
    654. 

  654.                 $user_auth["ogs_set_system"] = 1;
    655. 

  655.             if ($row["ogs_get_system"] == 1)
    656. 

  656.                 $user_auth["ogs_get_system"] = 1;
    657. 

  657.             if ($row["ogs_set_spy"] == 1)
    658. 

  658.                 $user_auth["ogs_set_spy"] = 1;
    659. 

  659.             if ($row["ogs_get_spy"] == 1)
    660. 

  660.                 $user_auth["ogs_get_spy"] = 1;
    661. 

  661.             if ($row["ogs_set_ranking"] == 1)
    662. 

  662.                 $user_auth["ogs_set_ranking"] = 1;
    663. 

  663.             if ($row["ogs_get_ranking"] == 1)
    664. 

  664.                 $user_auth["ogs_get_ranking"] = 1;
    665. 

  665.         }
    666. 

  666.     } else {
    667. 

  667.         $user_auth = array("server_set_system" => 0, "server_set_spy" => 0,
    668. 

  668.             "server_set_ranking" => 0, "server_show_positionhided" => 0, "ogs_connection" =>
    669. 

  669.             0, "ogs_set_system" => 0, "ogs_get_system" => 0, "ogs_set_spy" => 0,
    670. 

  670.             "ogs_get_spy" => 0, "ogs_set_ranking" => 0, "ogs_get_ranking" => 0);
    671. 

  671.     }
    672. 

  672. 

  673.     return $user_auth;
    674. 

  674. }
    675. 

  675. 

  676. /**
    677. 

  677.  * Creation d'un utilisateur a partir des donnees du formulaire admin
    678. 

  678.  * @comment redirection si erreur de type de donnee
    679. 

  679.  * @todo Query : x3
    680. 

  680.  */
    681. 

  681. function user_create()
    682. 

  682. {
    683. 

  683.     global $db, $user_data;
    684. 

  684.     global $pub_pseudo, $pub_user_id, $pub_active, $pub_user_coadmin, $pub_management_user,
    685. 

  685.         $pub_management_ranking, $pub_group_id, $pub_pass;
    686. 

  686. 

  687.     if (!check_var($pub_pseudo, "Pseudo_Groupname")) {
    688. 

  688.         redirection("index.php?action=message&id_message=errordata&info=1");
    689. 

  689.     }
    690. 

  690. 

  691.     if (!isset($pub_pseudo)) {
    692. 

  692.         redirection("index.php?action=message&id_message=createuser_failed_general&info");
    693. 

  693.     }
    694. 

  694. 

  695.     //Vérification des droits
    696. 

  696.     user_check_auth("user_create");
    697. 

  697. 

  698.     if (!check_var($pub_pseudo, "Pseudo_Groupname")) {
    699. 

  699.         redirection("index.php?action=message&id_message=createuser_failed_pseudo&info=" .
    700. 

  700.             $pub_pseudo);
    701. 

  701.     }
    702. 

  702. 

  703.     if (!check_var($pub_pass, "Password")) {
    704. 

  704.         redirection("index.php?action=message&id_message=createuser_failed_password&info=" .
    705. 

  705.             $pub_pseudo);
    706. 

  706.     }
    707. 

  707. 

  708.     if ($pub_pass != "") {
    709. 

  709.         $password = $pub_pass;
    710. 

  710.     } else {
    711. 

  711.         $password = password_generator();
    712. 

  712.     }
    713. 

  713.     //$request = "select user_id from ".TABLE_USER." where user_name = '". $db->sql_escape_string($pub_pseudo)."'";
    714. 

  714.     $request = "select user_id from " . TABLE_USER . " where user_name = '" . $pub_pseudo .
    715. 

  715.         "'";
    716. 

  716.     $result = $db->sql_query($request);
    717. 

  717.     if ($db->sql_numrows($result) == 0) {
    718. 

  718.         $request = "insert into " . TABLE_USER .
    719. 

  719.             " (user_name, user_password, user_regdate, user_active)" . " values ('" . $pub_pseudo .
    720. 

  720.             "', '" . md5(sha1($password)) . "', " . time() . ", '1')";
    721. 

  721.         $db->sql_query($request);
    722. 

  722.         $user_id = $db->sql_insertid();
    723. 

  723. 

  724.         $request = "insert into " . TABLE_USER_GROUP . " (group_id, user_id) values (" .
    725. 

  725.             $pub_group_id . ", " . $user_id . ")";
    726. 

  726.         $db->sql_query($request);
    727. 

  727. 

  728.         $info = $user_id . ":" . $password;
    729. 

  729.         log_("create_account", $user_id);
    730. 

  730.         user_set_grant($user_id, null, $pub_active, $pub_user_coadmin, $pub_management_user,
    731. 

  731.             $pub_management_ranking);
    732. 

  732.         redirection("index.php?action=message&id_message=createuser_success&info=" . $info);
    733. 

  733.     } else {
    734. 

  734.         redirection("index.php?action=message&id_message=createuser_failed_pseudolocked&info=" .
    735. 

  735.             $pub_pseudo);
    736. 

  736.     }
    737. 

  737. }
    738. 

  738. /**
    739. 

  739.  * Suppression d'un utilisateur ($pub_user_id)
    740. 

  740.  * @todo Query : x12
    741. 

  741.  */
    742. 

  742. function user_delete()
    743. 

  743. {
    744. 

  744.     global $db, $user_data;
    745. 

  745.     global $pub_user_id;
    746. 

  746. 

  747.     if (!check_var($pub_user_id, "Num")) {
    748. 

  748.         redirection("index.php?action=message&id_message=errordata&info");
    749. 

  749.     }
    750. 

  750. 

  751.     if (!isset($pub_user_id)) {
    752. 

  752.         redirection("index.php?action=message&id_message=createuser_failed_general&info");
    753. 

  753.     }
    754. 

  754. 

  755.     user_check_auth("user_update", $pub_user_id);
    756. 

  756. 

  757.     log_("delete_account", $pub_user_id);
    758. 

  758.     $request = "delete from " . TABLE_USER . " where user_id = " . $pub_user_id;
    759. 

  759.     $db->sql_query($request);
    760. 

  760. 

  761.     $request = "delete from " . TABLE_USER_GROUP . " where user_id = " . $pub_user_id;
    762. 

  762.     $db->sql_query($request);
    763. 

  763. 

  764.     $request = "delete from " . TABLE_USER_BUILDING . " where user_id = " . $pub_user_id;
    765. 

  765.     $db->sql_query($request);
    766. 

  766. 

  767.     $request = "delete from " . TABLE_USER_FAVORITE . " where user_id = " . $pub_user_id;
    768. 

  768.     $db->sql_query($request);
    769. 

  769. 

  770.     $request = "delete from " . TABLE_USER_DEFENCE . " where user_id = " . $pub_user_id;
    771. 

  771.     $db->sql_query($request);
    772. 

  772. 

  773.     $request = "delete from " . TABLE_USER_SPY . " where user_id = " . $pub_user_id;
    774. 

  774.     $db->sql_query($request);
    775. 

  775. 

  776.     $request = "delete from " . TABLE_USER_TECHNOLOGY . " where user_id = " . $pub_user_id;
    777. 

  777.     $db->sql_query($request);
    778. 

  778. 

  779.     $request = "update " . TABLE_RANK_PLAYER_POINTS ." set sender_id = 0 where sender_id = " . $pub_user_id;
    780. 

  780.     $db->sql_query($request);
    781. 

  781. 

  782.     $request = "update " . TABLE_RANK_PLAYER_ECO ." set sender_id = 0 where sender_id = " . $pub_user_id;
    783. 

  783.     $db->sql_query($request);
    784. 

  784. 

  785. 	$request = "update " . TABLE_RANK_PLAYER_TECHNOLOGY ." set sender_id = 0 where sender_id = " . $pub_user_id;
    786. 

  786.     $db->sql_query($request);
    787. 

  787. 	
    788. 

  788. 	$request = "update " . TABLE_RANK_PLAYER_MILITARY ." set sender_id = 0 where sender_id = " . $pub_user_id;
    789. 

  789.     $db->sql_query($request);
    790. 

  790. 

  791. 	$request = "update " . TABLE_RANK_PLAYER_MILITARY_BUILT ." set sender_id = 0 where sender_id = " . $pub_user_id;
    792. 

  792.     $db->sql_query($request);
    793. 

  793. 

  794. 	$request = "update " . TABLE_RANK_PLAYER_MILITARY_LOOSE ." set sender_id = 0 where sender_id = " . $pub_user_id;
    795. 

  795.     $db->sql_query($request);
    796. 

  796. 

  797. 	$request = "update " . TABLE_RANK_PLAYER_MILITARY_DESTRUCT ." set sender_id = 0 where sender_id = " . $pub_user_id;
    798. 

  798.     $db->sql_query($request);
    799. 

  799. 

  800. 	$request = "update " . TABLE_RANK_PLAYER_HONOR ." set sender_id = 0 where sender_id = " . $pub_user_id;
    801. 

  801.     $db->sql_query($request);
    802. 

  802. 

  803. 	$request = "update " . TABLE_RANK_ALLY_POINTS ." set sender_id = 0 where sender_id = " . $pub_user_id;
    804. 

  804.     $db->sql_query($request);
    805. 

  805. 

  806. 	$request = "update " . TABLE_RANK_ALLY_ECO ." set sender_id = 0 where sender_id = " . $pub_user_id;
    807. 

  807.     $db->sql_query($request);
    808. 

  808. 

  809. 	$request = "update " . TABLE_RANK_ALLY_TECHNOLOGY ." set sender_id = 0 where sender_id = " . $pub_user_id;
    810. 

  810.     $db->sql_query($request);
    811. 

  811. 

  812. 	$request = "update " . TABLE_RANK_ALLY_MILITARY ." set sender_id = 0 where sender_id = " . $pub_user_id;
    813. 

  813.     $db->sql_query($request);
    814. 

  814. 

  815. 	$request = "update " . TABLE_RANK_ALLY_MILITARY_BUILT ." set sender_id = 0 where sender_id = " . $pub_user_id;
    816. 

  816.     $db->sql_query($request);
    817. 

  817. 

  818. 	$request = "update " . TABLE_RANK_ALLY_MILITARY_LOOSE ." set sender_id = 0 where sender_id = " . $pub_user_id;
    819. 

  819.     $db->sql_query($request);
    820. 

  820. 

  821. 	$request = "update " . TABLE_RANK_ALLY_MILITARY_DESTRUCT ." set sender_id = 0 where sender_id = " . $pub_user_id;
    822. 

  822.     $db->sql_query($request);
    823. 

  823. 

  824. 	$request = "update " . TABLE_RANK_ALLY_HONOR ." set sender_id = 0 where sender_id = " . $pub_user_id;
    825. 

  825.     $db->sql_query($request);
    826. 

  826. 

  827.     $request = "update " . TABLE_UNIVERSE ." set last_update_user_id = 0 where last_update_user_id = " . $pub_user_id;
    828. 

  828.     $db->sql_query($request);
    829. 

  829. 

  830.     session_close($pub_user_id);
    831. 

  831. 

  832.     redirection("index.php?action=administration&subaction=member");
    833. 

  833. }
    834. 

  834. /**
    835. 

  835.  * Recuperation des statistiques
    836. 

  836.  * @todo Query : x1
    837. 

  837.  */
    838. 

  838. function user_statistic()
    839. 

  839. {
    840. 

  840.     global $db;
    841. 

  841. 

  842.     $request = "select user_id, user_name, planet_added_web, planet_added_ogs, search, spy_added_web, spy_added_ogs, rank_added_web, rank_added_ogs, planet_exported, spy_exported, rank_exported, xtense_type, xtense_version, user_active, user_admin";
    843. 

  843.     $request .= " from " . TABLE_USER .
    844. 

  844.         " order by (planet_added_web + planet_added_ogs) desc";
    845. 

  845.     $result = $db->sql_query($request);
    846. 

  846. 

  847.     $user_statistic = array();
    848. 

  848.     while ($row = $db->sql_fetch_assoc($result)) {
    849. 

  849.         $here = "";
    850. 

  850.         $request = "select session_ogs from " . TABLE_SESSIONS .
    851. 

  851.             " where session_user_id = " . $row["user_id"];
    852. 

  852.         $result_2 = $db->sql_query($request);
    853. 

  853.         if ($db->sql_numrows($result_2) > 0) {
    854. 

  854.             $here = "(*)";
    855. 

  855.             list($session_ogs) = $db->sql_fetch_row($result_2);
    856. 

  856.             if ($session_ogs == 1)
    857. 

  857.                 $here = "(**)";
    858. 

  858.         }
    859. 

  859.         $user_statistic[] = array_merge($row, array("here" => $here));
    860. 

  860.     }
    861. 

  861. 

  862.     return $user_statistic;
    863. 

  863. }
    864. 

  864. /**
    865. 

  865.  * Recuperation du nombres de comptes actifs
    866. 

  866.  * @todo Query : x1
    867. 

  867.  */
    868. 

  868. function user_get_nb_active_users()
    869. 

  869. {
    870. 

  870.     global $db;
    871. 

  871. 

  872.     $request = "SELECT user_id, user_active";
    873. 

  873.     $request .= " FROM ".TABLE_USER;
    874. 

  874.     $request .= " WHERE user_active='1'";
    875. 

  875.     $result = $db->sql_query($request);
    876. 

  876.     $number = $db->sql_numrows();
    877. 

  877.     
    878. 

  878.     return($number);
    879. 

  879. }
    880. 

  880. /**
    881. 

  881.  * Enregistrement des donnees Empires d'un utilisateur
    882. 

  882.  */
    883. 

  883. function user_set_empire()
    884. 

  884. {
    885. 

  885.     global $pub_typedata, $pub_data, $pub_planet_id, $pub_planet_name, $pub_fields,
    886. 

  886.         $pub_coordinates, $pub_temperature_min, $pub_temperature_max, $pub_satellite;
    887. 

  887. 

  888.     if (!isset($pub_typedata) || !isset($pub_data)) {
    889. 

  889.         redirection("index.php?action=message&id_message=errorfatal&info");
    890. 

  890.     }
    891. 

  891. 

  892.     switch ($pub_typedata) {
    893. 

  893.         case "B":
    894. 

  894.             if (!isset($pub_planet_name) || !isset($pub_fields) || !isset($pub_coordinates) ||
    895. 

  895.                 !isset($pub_temperature_min) || !isset($pub_temperature_max) || !isset($pub_satellite)) {
    896. 

  896.                 redirection("index.php?action=message&id_message=errorfatal&info");
    897. 

  897.             }
    898. 

  898.             user_set_building($pub_data, $pub_planet_id, $pub_planet_name, $pub_fields, $pub_coordinates,
    899. 

  899.                 $pub_temperature_min, $pub_temperature_max, $pub_satellite);
    900. 

  900.             break;
    901. 

  901. 

  902.         case "T":
    903. 

  903.             user_set_technology($pub_data);
    904. 

  904.             break;
    905. 

  905. 

  906.         case "D":
    907. 

  907.             if (!isset($pub_planet_name) || !isset($pub_fields) || !isset($pub_coordinates) ||
    908. 

  908.                 !isset($pub_temperature_min) || !isset($pub_temperature_max) || !isset($pub_satellite)) {
    909. 

  909.                 redirection("index.php?action=message&id_message=errorfatal&info");
    910. 

  910.             }
    911. 

  911.             user_set_defence($pub_data, $pub_planet_id, $pub_planet_name, $pub_fields, $pub_coordinates,
    912. 

  912.                 $pub_temperature_min, $pub_temperature_max, $pub_satellite);
    913. 

  913.             break;
    914. 

  914. 

  915.         case "E":
    916. 

  916.             user_set_all_empire($pub_data);
    917. 

  917.             break;
    918. 

  918. 

  919. 

  920.         default:
    921. 

  921.             redirection("index.php?action=message&id_message=errorfatal&info");
    922. 

  922.             break;
    923. 

  923.     }
    924. 

  924. 

  925.     redirection("index.php?action=home&subaction=empire");
    926. 

  926. }
    927. 

  927. /**
    928. 

  928.  * Enregistrement de toutes les donnees empires
    929. 

  929.  * @param array $data All data related to the empire
    930. 

  930.  * @todo Query : x5
    931. 

  931.  */
    932. 

  932. function user_set_all_empire($data)
    933. 

  933. {
    934. 

  934.     global $db, $user_data;
    935. 

  935.     global $pub_view;
    936. 

  936.     require_once ("parameters/lang_empire.php");
    937. 

  937. 

  938.     $data = str_replace("-", "0", $data);
    939. 

  939.     $data = str_replace(".", "", $data);
    940. 

  940.     $data = stripcslashes($data);
    941. 

  941.     $lines = explode(chr(10), $data);
    942. 

  942.     $OK = false;
    943. 

  943.     $etape = "";
    944. 

  944.     $planetes_total_row = false;
    945. 

  945.     foreach ($lines as $line) {
    946. 

  946.         $arr = array();
    947. 

  947.         $line = trim($line);
    948. 

  948. 

  949.         if ($line == "Vue d'ensemble de votre empire") {
    950. 

  950.             $OK = true;
    951. 

  951.             continue;
    952. 

  952.         }
    953. 

  953. 

  954.         if ($OK) {
    955. 

  955.             if (preg_match("#^Coordonnées\s+\[(.*)\]$#", $line, $arr)) {
    956. 

  956.                 $coordonnees = preg_split("/\]\s+\[/", $arr[1]);
    957. 

  957.                 $planetes_total_row = sizeof($coordonnees) + 1;
    958. 

  958.                 if ($planetes_total_row > 10)
    959. 

  959.                     return false;
    960. 

  960. 

  961.                 $link_building = array($lang_building["M"] => "M", $lang_building["C"] => "C", $lang_building["D"] =>
    962. 

  962.                     "D", $lang_building["CES"] => "CES", $lang_building["CEF"] => "CEF", $lang_building["UdR"] =>
    963. 

  963.                     "UdR", $lang_building["UdN"] => "UdN", $lang_building["CSp"] => "CSp", $lang_building["HM"] =>
    964. 

  964.                     "HM", $lang_building["HC"] => "HC", $lang_building["HD"] => "HD", $lang_building["Lab"] =>
    965. 

  965.                     "Lab", $lang_building["Ter"] => "Ter", $lang_building["Silo"] => "Silo", $lang_building["BaLu"] =>
    966. 

  966.                     "BaLu", $lang_building["Pha"] => "Pha", $lang_building["PoSa"] => "PoSa");
    967. 

  967. 

  968.                 $buildings = array("M" => array_fill(0, $planetes_total_row, 0), "C" =>
    969. 

  969.                     array_fill(0, $planetes_total_row, 0), "D" => array_fill(0, $planetes_total_row,
    970. 

  970.                     0), "CES" => array_fill(0, $planetes_total_row, 0), "CEF" => array_fill(0, $planetes_total_row,
    971. 

  971.                     0), "UdR" => array_fill(0, $planetes_total_row, 0), "UdN" => array_fill(0, $planetes_total_row,
    972. 

  972.                     0), "CSp" => array_fill(0, $planetes_total_row, 0), "HM" => array_fill(0, $planetes_total_row,
    973. 

  973.                     0), "HC" => array_fill(0, $planetes_total_row, 0), "HD" => array_fill(0, $planetes_total_row,
    974. 

  974.                     0), "Lab" => array_fill(0, $planetes_total_row, 0), "Ter" => array_fill(0, $planetes_total_row,
    975. 

  975.                     0), "Silo" => array_fill(0, $planetes_total_row, 0), "BaLu" => array_fill(0, $planetes_total_row,
    976. 

  976.                     0), "Pha" => array_fill(0, $planetes_total_row, 0), "PoSa" => array_fill(0, $planetes_total_row,
    977. 

  977.                     0));
    978. 

  978. 

  979.                 $link_defence = array($lang_defence["LM"] => "LM", $lang_defence["LLE"] => "LLE",
    980. 

  980.                     $lang_defence["LLO"] => "LLO", $lang_defence["CG"] => "CG", $lang_defence["AI"] =>
    981. 

  981.                     "AI", $lang_defence["LP"] => "LP", $lang_defence["PB"] => "PB", $lang_defence["GB"] =>
    982. 

  982.                     "GB", $lang_defence["MIC"] => "MIC", $lang_defence["MIP"] => "MIP");
    983. 

  983. 

  984.                 $defences = array("LM" => array_fill(0, $planetes_total_row, 0), "LLE" =>
    985. 

  985.                     array_fill(0, $planetes_total_row, 0), "LLO" => array_fill(0, $planetes_total_row,
    986. 

  986.                     0), "CG" => array_fill(0, $planetes_total_row, 0), "AI" => array_fill(0, $planetes_total_row,
    987. 

  987.                     0), "LP" => array_fill(0, $planetes_total_row, 0), "PB" => array_fill(0, $planetes_total_row,
    988. 

  988.                     0), "GB" => array_fill(0, $planetes_total_row, 0), "MIC" => array_fill(0, $planetes_total_row,
    989. 

  989.                     0), "MIP" => array_fill(0, $planetes_total_row, 0));
    990. 

  990. 

  991.                 $link_technology = array($lang_technology["Esp"] => "Esp", $lang_technology["Ordi"] =>
    992. 

  992.                     "Ordi", $lang_technology["Armes"] => "Armes", $lang_technology["Bouclier"] =>
    993. 

  993.                     "Bouclier", $lang_technology["Protection"] => "Protection", $lang_technology["NRJ"] =>
    994. 

  994.                     "NRJ", $lang_technology["Hyp"] => "Hyp", $lang_technology["RC"] => "RC", $lang_technology["RI"] =>
    995. 

  995.                     "RI", $lang_technology["PH"] => "PH", $lang_technology["Laser"] => "Laser", $lang_technology["Ions"] =>
    996. 

  996.                     "Ions", $lang_technology["Plasma"] => "Plasma", $lang_technology["RRI"] => "RRI",
    997. 

  997.                     $lang_technology["Graviton"] => "Graviton", $lang_technology["Astrophysique"] =>
    998. 

  998.                     "Astrophysique");
    999. 

  999. 

  1000.                 $technologies = array("Esp" => 0, "Ordi" => 0, "Armes" => 0, "Bouclier" => 0,
    1001. 

  1001.                     "Protection" => 0, "NRJ" => 0, "Hyp" => 0, "RC" => 0, "RI" => 0, "PH" => 0,
    1002. 

  1002.                     "Laser" => 0, "Ions" => 0, "Plasma" => 0, "RRI" => 0, "Graviton" => 0,
    1003. 

  1003.                     "Astrophysique" => 0);
    1004. 

  1004. 

  1005.                 $satellites = array_fill(0, $planetes_total_row, 0);
    1006. 

  1006.                 $cases = array_fill(0, $planetes_total_row, 0);
    1007. 

  1007. 

  1008.                 // creation du masque ici
    1009. 

  1009.                 $masq = "#^((?:\s?\S+)+)\s+";
    1010. 

  1010.                 for ($i = 0; $i < ($planetes_total_row - 1); $i++) {
    1011. 

  1011.                     $masq .= "(\d+)(?:|\s\d+|\s\(\d+\))\s+";
    1012. 

  1012.                 }
    1013. 

  1013.                 $masq .= "(\d+)(?:\s\d+|\s\(\d+\))*$#";
    1014. 

  1014. 

  1015.                 continue;
    1016. 

  1016.             }
    1017. 

  1017. 

  1018.             if ($OK && $planetes_total_row !== false) {
    1019. 

  1019. 

  1020.                 if (preg_match("#^Cases\s+\d+\/((?:\d+\s+(?:\d+)\/(?:\d+)\s*){1," . $planetes_total_row .
    1021. 

  1021.                     "})$#", $line, $arr)) {
    1022. 

  1022.                     $cases = preg_split("/\s+\d+\//", $arr[1]);
    1023. 

  1023.                     if (sizeof($cases) != $planetes_total_row)
    1024. 

  1024.                         return false;
    1025. 

  1025.                     continue;
    1026. 

  1026.                 }
    1027. 

  1027. 

  1028.                 if (preg_match("#^(" . $lang_empire["Batiment"] . "|" . $lang_empire["Recherche"] .
    1029. 

  1029.                     "|" . $lang_empire["Vaisseaux"] . "|" . $lang_empire["Défense"] . ")$#", $line)) {
    1030. 

  1030.                     $etape = $line;
    1031. 

  1031.                     continue;
    1032. 

  1032.                 }
    1033. 

  1033. 

  1034.                 if ($etape != "" && preg_match($masq, $line, $arr)) {
    1035. 

  1035. 

  1036.                     $building = $arr[1];
    1037. 

  1037.                     $levels = array_slice($arr, 2);
    1038. 

  1038. 

  1039.                     switch ($etape) {
    1040. 

  1040.                         case "Bâtiments":
    1041. 

  1041.                             if (isset($link_building[$building])) {
    1042. 

  1042.                                 if (sizeof($levels) != $planetes_total_row)
    1043. 

  1043.                                     return false;
    1044. 

  1044.                                 $buildings[$link_building[$building]] = $levels;
    1045. 

  1045.                             }
    1046. 

  1046.                             break;
    1047. 

  1047.                         case "Recherche":
    1048. 

  1048.                             if (isset($link_technology[$building])) {
    1049. 

  1049.                                 if (sizeof($levels) != $planetes_total_row)
    1050. 

  1050.                                     return false;
    1051. 

  1051.                                 $technologies[$link_technology[$building]] = max($levels);
    1052. 

  1052.                             }
    1053. 

  1053.                             break;
    1054. 

  1054.                         case "Vaisseaux":
    1055. 

  1055.                             if ($building == "Satellite solaire") {
    1056. 

  1056.                                 if (sizeof($levels) != $planetes_total_row)
    1057. 

  1057.                                     return false;
    1058. 

  1058.                                 $satellites = $levels;
    1059. 

  1059.                             }
    1060. 

  1060.                             break;
    1061. 

  1061.                         case "Défense":
    1062. 

  1062.                             if (isset($link_defence[$building])) {
    1063. 

  1063.                                 if (sizeof($levels) != $planetes_total_row)
    1064. 

  1064.                                     return false;
    1065. 

  1065.                                 $defences[$link_defence[$building]] = $levels;
    1066. 

  1066.                             }
    1067. 

  1067.                             break;
    1068. 

  1068.                         default:
    1069. 

  1069.                             redirection("index.php?action=message&id_message=set_empire_failed_data&info");
    1070. 

  1070.                     }
    1071. 

  1071.                     continue;
    1072. 

  1072.                 }
    1073. 

  1073. 

  1074.             }
    1075. 

  1075.         }
    1076. 

  1076.     }
    1077. 

  1077.     if ($OK && $planetes_total_row !== false) {
    1078. 

  1078.         $j = 19;
    1079. 

  1079.         for ($i = 0; $i < $planetes_total_row; $i++) {
    1080. 

  1080.             if ($pub_view == "moons") {
    1081. 

  1081.                 $request = "select planet_id from " . TABLE_USER_BUILDING .
    1082. 

  1082.                     " where coordinates = '" . $coordonnees[$i] . "' and planet_id > 9";
    1083. 

  1083.                 $result = $db->sql_query($request);
    1084. 

  1084.                 if ($db->sql_numrows($result) > 0) {
    1085. 

  1085.                     list($planete_id) = $db->sql_fetch_row($result);
    1086. 

  1086.                 } else {
    1087. 

  1087.                     $request = "select planet_id from " . TABLE_USER_BUILDING . " where user_id = " .
    1088. 

  1088.                         $user_data["user_id"] . " and coordinates = '" . $coordonnees[$i] . "'";
    1089. 

  1089.                     $result = $db->sql_query($request);
    1090. 

  1090.                     list($planete_id) = $db->sql_fetch_row($result);
    1091. 

  1091.                     if (!$planete_id) {
    1092. 

  1092.                         $planete_id = $j;
    1093. 

  1093.                         $j++;
    1094. 

  1094.                     } else
    1095. 

  1095.                         $planete_id += 9;
    1096. 

  1096.                 }
    1097. 

  1097.             } else
    1098. 

  1098.                 $planete_id = $i + 1;
    1099. 

  1099. 

  1100.             if ($pub_view == "planets")
    1101. 

  1101.                 $case = $cases[$i] - 5 * $buildings["Ter"][$i];
    1102. 

  1102.             else
    1103. 

  1103.                 $case = 1;
    1104. 

  1104. 

  1105.             $request = "update " . TABLE_USER_BUILDING . " set coordinates = '" . $coordonnees[$i] .
    1106. 

  1106.                 "', `fields` = " . $case . " , Sat = " . $satellites[$i];
    1107. 

  1107.             $request .= ", M = " . $buildings["M"][$i] . ", C = " . $buildings["C"][$i] .
    1108. 

  1108.                 ", D = " . $buildings["D"][$i];
    1109. 

  1109.             $request .= ", CES = " . $buildings["CES"][$i] . ", CEF = " . $buildings["CEF"][$i] .
    1110. 

  1110.                 ", UdR = " . $buildings["UdR"][$i];
    1111. 

  1111.             $request .= ", UdN = " . $buildings["UdN"][$i] . ", CSp = " . $buildings["CSp"][$i] .
    1112. 

  1112.                 ", HM = " . $buildings["HM"][$i];
    1113. 

  1113.             $request .= ", HC = " . $buildings["HC"][$i] . ", HD = " . $buildings["HD"][$i] .
    1114. 

  1114.                 ", Lab = " . $buildings["Lab"][$i];
    1115. 

  1115.             $request .= ", Ter = " . $buildings["Ter"][$i] . ", Silo = " . $buildings["Silo"][$i] .
    1116. 

  1116.                 ", BaLu = " . $buildings["BaLu"][$i];
    1117. 

  1117.             $request .= ", Pha = " . $buildings["Pha"][$i] . ", PoSa = " . $buildings["PoSa"][$i] . ($pub_view ==
    1118. 

  1118.                 'lunes' ? ', planet_name = \'Lune\'' : '');
    1119. 

  1119.             $request .= " where user_id = " . $user_data["user_id"] . " and planet_id = " .
    1120. 

  1120.                 $planete_id;
    1121. 

  1121.             $db->sql_query($request);
    1122. 

  1122.             if ($db->sql_affectedrows() == 0) {
    1123. 

  1123.                 $request = "insert ignore into " . TABLE_USER_BUILDING .
    1124. 

  1124.                     " (user_id, planet_id, planet_name, coordinates, `fields`, temperature_min, temperature_max, Sat, M, C, D, CES, CEF, UdR, UdN, CSp, HM, HC, HD, Lab, Ter, Silo, BaLu, Pha, PoSa)";
    1125. 

  1125.                 $request .= " values (" . $user_data["user_id"] . ", " . $planete_id . ", '" . ($pub_view ==
    1126. 

  1126.                     'moons' ? 'Lune' : 'planete ' . $planete_id) . "', '" . $coordonnees[$i] . "', " .
    1127. 

  1127.                     $case . ", 0, " . $satellites[$i];
    1128. 

  1128.                 $request .= ", " . $buildings["M"][$i] . ", " . $buildings["C"][$i] . ", " . $buildings["D"][$i];
    1129. 

  1129.                 $request .= ", " . $buildings["CES"][$i] . ", " . $buildings["CEF"][$i] . ", " .
    1130. 

  1130.                     $buildings["UdR"][$i];
    1131. 

  1131.                 $request .= ", " . $buildings["UdN"][$i] . ", " . $buildings["CSp"][$i] . ", " .
    1132. 

  1132.                     $buildings["HM"][$i];
    1133. 

  1133.                 $request .= ", " . $buildings["HC"][$i] . ", " . $buildings["HD"][$i] . ", " . $buildings["Lab"][$i];
    1134. 

  1134.                 $request .= ", " . $buildings["Ter"][$i] . ", " . $buildings["Silo"][$i] . ", " .
    1135. 

  1135.                     $buildings["BaLu"][$i];
    1136. 

  1136.                 $request .= ", " . $buildings["Pha"][$i] . ", " . $buildings["PoSa"][$i] . ")";
    1137. 

  1137.                 $db->sql_query($request);
    1138. 

  1138.             }
    1139. 

  1139. 

  1140.             $request = "delete from " . TABLE_USER_DEFENCE . " where user_id = " . $user_data["user_id"] .
    1141. 

  1141.                 " and planet_id= " . $planete_id;
    1142. 

  1142.             $db->sql_query($request);
    1143. 

  1143. 

  1144.             $request = "insert into " . TABLE_USER_DEFENCE .
    1145. 

  1145.                 " (user_id, planet_id, LM, LLE, LLO, CG, AI, LP, PB, GB, MIC, MIP)";
    1146. 

  1146.             $request .= " values (" . $user_data["user_id"] . ", " . $planete_id . ", " . $defences["LM"][$i] .
    1147. 

  1147.                 ", " . $defences["LLE"][$i] . "," . $defences["LLO"][$i] . ", " . $defences["CG"][$i] .
    1148. 

  1148.                 ", " . $defences["AI"][$i] . ", " . $defences["LP"][$i] . ", " . $defences["PB"][$i] .
    1149. 

  1149.                 ", " . $defences["GB"][$i] . ", " . $defences["MIC"][$i] . ", " . $defences["MIP"][$i] .
    1150. 

  1150.                 ")";
    1151. 

  1151.             $db->sql_query($request);
    1152. 

  1152.         }
    1153. 

  1153.         if ($pub_view == "planets") {
    1154. 

  1154.             $request = "delete from " . TABLE_USER_TECHNOLOGY . " where user_id = " . $user_data["user_id"];
    1155. 

  1155.             $db->sql_query($request);
    1156. 

  1156. 

  1157.             $request = "insert into " . TABLE_USER_TECHNOLOGY .
    1158. 

  1158.                 " (user_id, esp, Ordi, Armes, Bouclier, Protection, NRJ, Hyp, RC, RI, PH, Laser, Ions, Plasma, RRI, Graviton, Astrophysique)";
    1159. 

  1159.             $request .= " values (" . $user_data["user_id"] . ", " . $technologies["Esp"] .
    1160. 

  1160.                 ", " . $technologies["Ordi"] . "," . $technologies["Armes"] . ", " . $technologies["Bouclier"] .
    1161. 

  1161.                 ", " . $technologies["Protection"] . ", " . $technologies["NRJ"] . ", " . $technologies["Hyp"] .
    1162. 

  1162.                 ", " . $technologies["RC"] . ", " . $technologies["RI"] . ", " . $technologies["PH"] .
    1163. 

  1163.                 ", " . $technologies["Laser"] . ", " . $technologies["Ions"] . ", " . $technologies["Plasma"] .
    1164. 

  1164.                 ", " . $technologies["RRI"] . ", " . $technologies["Graviton"] . ", " . $technologies["Astrophysique"] .
    1165. 

  1165.                 ");";
    1166. 

  1166.             $db->sql_query($request);
    1167. 

  1167.         }
    1168. 

  1168. 

  1169. 

  1170.         if ($pub_view == "planets")
    1171. 

  1171.             redirection("index.php?action=home&subaction=empire&view=" . $pub_view .
    1172. 

  1172.                 "&alert_empire=true");
    1173. 

  1173.         else
    1174. 

  1174.             redirection("index.php?action=home&subaction=empire&view=" . $pub_view);
    1175. 

  1175.     } else
    1176. 

  1176.         redirection("index.php?action=message&id_message=set_empire_failed_data&info");
    1177. 

  1177. }
    1178. 

  1178. 

  1179. 

  1180. /**
    1181. 

  1181.  * remise en ordre des lunes en fonctions des positions des planetes
    1182. 

  1182.  * @todo Query : x6
    1183. 

  1183.  */
    1184. 

  1184. function user_set_all_empire_resync_moon()
    1185. 

  1185. {
    1186. 

  1186.     global $db, $user_data;
    1187. 

  1187. 

  1188. 

  1189.     // lews planetes
    1190. 

  1190.     $request = "select planet_id, coordinates";
    1191. 

  1191.     $request .= " from " . TABLE_USER_BUILDING;
    1192. 

  1192.     $request .= " where user_id = " . $user_data["user_id"];
    1193. 

  1193.     $request .= " and planet_id <= 199";
    1194. 

  1194.     $request .= " order by planet_id";
    1195. 

  1195.     $result = $db->sql_query($request);
    1196. 

  1196. 

  1197.     while (list($planet_id, $coordinates) = $db->sql_fetch_row($result)) {
    1198. 

  1198.         $planet_position[$coordinates] = $planet_id;
    1199. 

  1199.     }
    1200. 

  1200. 

  1201.     // les lunes
    1202. 

  1202.     $request = "select planet_id, coordinates";
    1203. 

  1203.     $request .= " from " . TABLE_USER_BUILDING;
    1204. 

  1204.     $request .= " where user_id = " . $user_data["user_id"];
    1205. 

  1205.     $request .= " and planet_id > 199";
    1206. 

  1206.     $request .= " order by planet_id";
    1207. 

  1207.     $result = $db->sql_query($request);
    1208. 

  1208. 

  1209.     while (list($planet_id, $coordinates) = $db->sql_fetch_row($result)) {
    1210. 

  1210.         $moon_position[$coordinates] = $planet_id;
    1211. 

  1211.     }
    1212. 

  1212. 

  1213.     // on ressort les complexes planete / lune ayant la meme cle
    1214. 

  1214.     $complexe = array_intersect_key($planet_position, $moon_position);
    1215. 

  1215. 

  1216.     /// on passe les id se modifiant a 300
    1217. 

  1217.     foreach ($complexe as $cle_com => $valeur_com) {
    1218. 

  1218.         $nouvelle_valeur = $planet_position[$cle_com] + 200;
    1219. 

  1219.         $request = "UPDATE " . TABLE_USER_DEFENCE . " SET planet_id  = " . $nouvelle_valeur .
    1220. 

  1220.             " WHERE  planet_id = " . $moon_position[$cle_com] . " and user_id = " . $user_data["user_id"] .
    1221. 

  1221.             "";
    1222. 

  1222.         $db->sql_query($request);
    1223. 

  1223.         $request = "UPDATE " . TABLE_USER_BUILDING . " SET planet_id  = " . $nouvelle_valeur .
    1224. 

  1224.             " WHERE  planet_id = " . $moon_position[$cle_com] . " and user_id = " . $user_data["user_id"] .
    1225. 

  1225.             "";
    1226. 

  1226.         $db->sql_query($request);
    1227. 

  1227.     }
    1228. 

  1228. 

  1229.     /// on remet le tout a 200 pour lunes
    1230. 

  1230.     $request = "UPDATE " . TABLE_USER_BUILDING .
    1231. 

  1231.         " SET planet_id  = planet_id -100 WHERE  planet_id > 299 and user_id = " . $user_data["user_id"] .
    1232. 

  1232.         "";
    1233. 

  1233.     $db->sql_query($request);
    1234. 

  1234.     $request = "UPDATE " . TABLE_USER_DEFENCE .
    1235. 

  1235.         " SET planet_id  = planet_id -100 WHERE  planet_id > 299 and user_id = " . $user_data["user_id"] .
    1236. 

  1236.         "";
    1237. 

  1237.     $db->sql_query($request);
    1238. 

  1238. 

  1239. }
    1240. 

  1240. /**
    1241. 

  1241.  * remise en ordre des planetes sans espaces vides ...
    1242. 

  1242.  * ( les id doivent se suivre 101,102,103 etc etc)
    1243. 

  1243.  * @todo Query : x3
    1244. 

  1244.  */
    1245. 

  1245. function user_set_all_empire_resync_planet()
    1246. 

  1246. {
    1247. 

  1247.     global $db, $user_data;
    1248. 

  1248. 

  1249.     $nb_planete = find_nb_planete_user();
    1250. 

  1250. 

  1251.     $request = "select planet_id, coordinates";
    1252. 

  1252.     $request .= " from " . TABLE_USER_BUILDING;
    1253. 

  1253.     $request .= " where user_id = " . $user_data["user_id"];
    1254. 

  1254.     $request .= " and planet_id <= 199";
    1255. 

  1255.     $request .= " order by planet_id";
    1256. 

  1256.     $result = $db->sql_query($request);
    1257. 

  1257. 

  1258.     while (list($planet_id, $coordinates) = $db->sql_fetch_row($result)) {
    1259. 

  1259.         $planet_position[$coordinates] = $planet_id;
    1260. 

  1260.     }
    1261. 

  1261. 

  1262. 

  1263.     $i = 101;
    1264. 

  1264.     foreach ($planet_position as $cle => $valeur) {
    1265. 

  1265. 

  1266.         // planete
    1267. 

  1267.         $request = "update " . TABLE_USER_BUILDING . " set planet_id = " . $i .
    1268. 

  1268.             " where planet_id = " . $valeur ." and user_id = " . $user_data["user_id"];
    1269. 

  1269.         $db->sql_query($request);
    1270. 

  1270.         $request = "update " . TABLE_USER_DEFENCE . " set planet_id = " . $i .
    1271. 

  1271.             " where planet_id = " . $valeur . " and user_id = " . $user_data["user_id"];
    1272. 

  1272.         $db->sql_query($request);
    1273. 

  1273. 

  1274.         $i++;
    1275. 

  1275. 

  1276.     }
    1277. 

  1277.     
    1278. 

  1278.     /// on lance le resync moon que si lune
    1279. 

  1279.     $request = "select planet_id ";
    1280. 

  1280.     $request .= " from " . TABLE_USER_BUILDING;
    1281. 

  1281.     $request .= " where user_id = " . $user_data["user_id"];
    1282. 

  1282.     $request .= " and planet_id > 199";
    1283. 

  1283.     $request .= " order by planet_id";
    1284. 

  1284.     $result = $db->sql_query($request);
    1285. 

  1285.  
    1286. 

  1286.      if ($db->sql_numrows($result) != 0) {
    1287. 

  1287.        
    1288. 

  1288.     // on remet en ordre moon
    1289. 

  1289.     user_set_all_empire_resync_moon();
    1290. 

  1290.     // todo : passer le result en paramettre ...
    1291. 

  1291.        
    1292. 

  1292.        
    1293. 

  1293.     }
    1294. 

  1294. 

  1295. }
    1296. 

  1296. /**
    1297. 

  1297.  * Build the array with Empire data
    1298. 

  1298.  *
    1299. 

  1299.  * @todo Query : x3
    1300. 

  1300.  */
    1301. 

  1301. function user_set_building($data, $planet_id, $planet_name, $fields, $coordinates,
    1302. 

  1302.     $temperature_min, $temperature_max, $satellite)
    1303. 

  1303. {
    1304. 

  1304.     global $db, $user_data;
    1305. 

  1305.     global $pub_view, $server_config;
    1306. 

  1306.     require_once ("parameters/lang_empire.php");
    1307. 

  1307. 

  1308.     $planet_name = trim($planet_name) != "" ? trim($planet_name) : "Inconnu";
    1309. 

  1309.     if (!check_var($planet_name, "Galaxy"))
    1310. 

  1310.         $planet_name = "";
    1311. 

  1311. 

  1312.     $fields = intval($fields);
    1313. 

  1313.     $temperature_min = intval($temperature_min);
    1314. 

  1314.     $temperature_max = intval($temperature_max);
    1315. 

  1315.     $satellite = intval($satellite);
    1316. 

  1316.     $coordinates_ok = "";
    1317. 

  1317.     if (sizeof(explode(":", $coordinates)) == 3 || sizeof(explode(".", $coordinates)) ==
    1318. 

  1318.         3) {
    1319. 

  1319.         if (sizeof(explode(":", $coordinates)) == 3)
    1320. 

  1320.             @list($galaxy, $system, $row) = explode(":", $coordinates);
    1321. 

  1321.         if (sizeof(explode(".", $coordinates)) == 3)
    1322. 

  1322.             @list($galaxy, $system, $row) = explode(".", $coordinates);
    1323. 

  1323.         if (intval($galaxy) >= 1 && intval($galaxy) <= intval($server_config['num_of_galaxies']) &&
    1324. 

  1324.             intval($system) >= 1 && intval($system) <= intval($server_config['num_of_systems']) &&
    1325. 

  1325.             intval($row) >= 1 && intval($row) <= 15) {
    1326. 

  1326.             $coordinates_ok = $coordinates;
    1327. 

  1327.         }
    1328. 

  1328.     }
    1329. 

  1329. 

  1330.     if (!isset($planet_id)) {
    1331. 

  1331.         redirection("index.php?action=message&id_message=set_empire_failed_data&info");
    1332. 

  1332.     }
    1333. 

  1333.     $planet_id = intval($planet_id);
    1334. 

  1334.     if (($view == "planets" && ($planet_id < 1 || $planet_id > 9)) || ($view ==
    1335. 

  1335.         "lunes" && ($planet_id < 10 || $planet_id > 18))) {
    1336. 

  1336.         redirection("index.php?action=message&id_message=set_empire_failed_data&info");
    1337. 

  1337.     }
    1338. 

  1338. 

  1339.     $link_building = array($lang_building["M"] => "M", $lang_building["C"] => "C", $lang_building["D"] =>
    1340. 

  1340.         "D", $lang_building["CES"] => "CES", $lang_building["CEF"] => "CEF", $lang_building["DdR"] =>
    1341. 

  1341.         "DdR", $lang_building["UdR"] => "UdR", $lang_building["UdN"] => "UdN", $lang_building["CSp"] =>
    1342. 

  1342.         "CSp", $lang_building["HM"] => "HM", $lang_building["HC"] => "HC", $lang_building["HD"] =>
    1343. 

  1343.         "HD", $lang_building["Lab"] => "Lab", $lang_building["Ter"] => "Ter", $lang_building["Silo"] =>
    1344. 

  1344.         "Silo", $lang_building["BaLu"] => "BaLu", $lang_building["Pha"] => "Pha", $lang_building["PoSa"] =>
    1345. 

  1345.         "PoSa");
    1346. 

  1346. 

  1347.     $buildings = array("M" => 0, "C" => 0, "D" => 0, "CES" => 0, "CEF" => 0, "DdR" =>
    1348. 

  1348.         0, "UdR" => 0, "UdN" => 0, "CSp" => 0, "HM" => 0, "HC" => 0, "HD" => 0, "Lab" =>
    1349. 

  1349.         0, "Ter" => 0, "Silo" => 0, "BaLu" => 0, "Pha" => 0, "PoSa" => 0);
    1350. 

  1350. 

  1351.     $lines = explode(chr(10), $data);
    1352. 

  1352. 

  1353.     $OK = false;
    1354. 

  1354.     foreach ($lines as $line) {
    1355. 

  1355.         $arr = array();
    1356. 

  1356.         $line = trim($line);
    1357. 

  1357.         if (ereg("^(.*) \(Niveau ([[:digit:]]{1,3}).*\)$", $line, $arr)) {
    1358. 

  1358.             list($string, $building, $level) = $arr;
    1359. 

  1359. 

  1360.             $building = trim($building);
    1361. 

  1361.             $level = trim(str_replace("Niveau", "", $level));
    1362. 

  1362. 

  1363.             if (isset($link_building[$building])) {
    1364. 

  1364.                 $OK = true;
    1365. 

  1365.                 $buildings[$link_building[$building]] = $level;
    1366. 

  1366.                 $res = $db->sql_query('SELECT planet_name FROM ' . TABLE_USER_BUILDING .
    1367. 

  1367.                     ' WHERE planet_id = ' . $planet_id);
    1368. 

  1368.                 if ($link_building[$building] == 'Ter' && $db->sql_numrows($res) == 0)
    1369. 

  1369.                     $fields -= $level * 5;
    1370. 

  1370.                 if ($link_building[$building] == 'Balu' && $db->sql_numrows($res) == 0)
    1371. 

  1371.                     $fields -= $level * 4;
    1372. 

  1372.             }
    1373. 

  1373.         }
    1374. 

  1374.     }
    1375. 

  1375. 

  1376.     if ($OK) {
    1377. 

  1377.         $request = "delete from " . TABLE_USER_BUILDING . " where user_id = " . $user_data["user_id"] .
    1378. 

  1378.             " and planet_id= " . $planet_id;
    1379. 

  1379.         $db->sql_query($request);
    1380. 

  1380. 

  1381.         $request = "insert into " . TABLE_USER_BUILDING .
    1382. 

  1382.             " (user_id, planet_id, planet_name, coordinates, `fields`, temperature_min, temperature_max, Sat, M, C, D, CES, CEF, UdR, UdN, CSP, HM, HC, HD, Lab, Ter, Silo, BaLu, Pha, PoSa)";
    1383. 

  1383.         $request .= " values (" . $user_data["user_id"] . ", " . $planet_id . ", '" .
    1384. 

  1384.              $db->sql_escape_string($planet_name) . "', '" . $coordinates_ok . "', " . $fields .
    1385. 

  1385.             ", " . $temperature_min . ", " . $satellite . ", " . $buildings["M"] . ", " . $buildings["C"] .
    1386. 

  1386.             "," . $buildings["D"] . ", " . $buildings["CES"] . ", " . $buildings["CEF"] .
    1387. 

  1387.             ", " . $buildings["UdR"] . ", " . $buildings["UdN"] . ", " . $buildings["CSp"] .
    1388. 

  1388.             ", " . $buildings["HM"] . ", " . $buildings["HC"] . ", " . $buildings["HD"] .
    1389. 

  1389.             ", " . $buildings["Lab"] . ", " . $buildings["Ter"] . ", " . $buildings["Silo"] .
    1390. 

  1390.             ", " . $buildings["BaLu"] . ", " . $buildings["Pha"] . ", " . $buildings["PoSa"] .
    1391. 

  1391.             ")";
    1392. 

  1392.         $db->sql_query($request);
    1393. 

  1393.     } elseif ($planet_id > 9) {
    1394. 

  1394.         $request = "insert into " . TABLE_USER_BUILDING .
    1395. 

  1395.             " (user_id, planet_id, planet_name, coordinates, `fields`, temperature_min, temperature_max, Sat, M, C, D, CES, CEF, UdR, UdN, CSP, HM, HC, HD, Lab, Ter, Silo, BaLu, Pha, PoSa)";
    1396. 

  1396.         $request .= " values (" . $user_data["user_id"] . ", " . $planet_id . ", '" .
    1397. 

  1397.              $db->sql_escape_string($planet_name) . "', '" . $coordinates_ok . "', " . $fields .
    1398. 

  1398.             ", " . $temperature_max . ", " . $satellite . ", " . $buildings["M"] . ", " . $buildings["C"] .
    1399. 

  1399.             "," . $buildings["D"] . ", " . $buildings["CES"] . ", " . $buildings["CEF"] .
    1400. 

  1400.             ", " . $buildings["UdR"] . ", " . $buildings["UdN"] . ", " . $buildings["CSp"] .
    1401. 

  1401.             ", " . $buildings["HM"] . ", " . $buildings["HC"] . ", " . $buildings["HD"] .
    1402. 

  1402.             ", " . $buildings["Lab"] . ", " . $buildings["Ter"] . ", " . $buildings["Silo"] .
    1403. 

  1403.             ", " . $buildings["BaLu"] . ", " . $buildings["Pha"] . ", " . $buildings["PoSa"] .
    1404. 

  1404.             ")";
    1405. 

  1405.         $db->sql_query($request);
    1406. 

  1406.     } else {
    1407. 

  1407.         $request = "update " . TABLE_USER_BUILDING . " set planet_name = '" .
    1408. 

  1408.              $db->sql_escape_string($planet_name) . "', coordinates = '" . $coordinates_ok .
    1409. 

  1409.             "', `fields` = " . $fields . ", temperature_min = " . $temperature_min .
    1410. 

  1410.             ", temperature_max = " . $temperature_max . ", Sat = " . $satellite .
    1411. 

  1411.             " where user_id = " . $user_data["user_id"] . " and planet_id = " . $planet_id;
    1412. 

  1412.         $db->sql_query($request);
    1413. 

  1413.     }
    1414. 

  1414. 

  1415.     redirection("index.php?action=home&subaction=empire&view=" . $pub_view);
    1416. 

  1416. }
    1417. 

  1417. /**
    1418. 

  1418.  * Build the array with technology data
    1419. 

  1419.  *
    1420. 

  1420.  * @todo Query : x2
    1421. 

  1421.  */
    1422. 

  1422. function user_set_technology($data)
    1423. 

  1423. {
    1424. 

  1424.     global $db, $user_data;
    1425. 

  1425.     require_once ("parameters/lang_empire.php");
    1426. 

  1426. 

  1427.     $link_technology = array($lang_technology["Esp"] => "Esp", $lang_technology["Ordi"] =>
    1428. 

  1428.         "Ordi", $lang_technology["Armes"] => "Armes", $lang_technology["Bouclier"] =>
    1429. 

  1429.         "Bouclier", $lang_technology["Protection"] => "Protection", $lang_technology["NRJ"] =>
    1430. 

  1430.         "NRJ", $lang_technology["Hyp"] => "Hyp", $lang_technology["RC"] => "RC", $lang_technology["RI"] =>
    1431. 

  1431.         "RI", $lang_technology["PH"] => "PH", $lang_technology["Laser"] => "Laser", $lang_technology["Ions"] =>
    1432. 

  1432.         "Ions", $lang_technology["Plasma"] => "Plasma", $lang_technology["RRI"] => "RRI",
    1433. 

  1433.         $lang_technology["Graviton"] => "Graviton", $lang_technology["Astrophysique"] =>
    1434. 

  1434.         "Astrophysique");
    1435. 

  1435. 

  1436.     $technologies = array("Esp" => 0, "Ordi" => 0, "Armes" => 0, "Bouclier" => 0,
    1437. 

  1437.         "Protection" => 0, "NRJ" => 0, "Hyp" => 0, "RC" => 0, "RI" => 0, "PH" => 0,
    1438. 

  1438.         "Laser" => 0, "Ions" => 0, "Plasma" => 0, "RRI" => 0, "Graviton" => 0,
    1439. 

  1439.         "Astrophysique" => 0);
    1440. 

  1440. 

  1441.     $lines = explode(chr(10), $data);
    1442. 

  1442. 

  1443.     $OK = false;
    1444. 

  1444.     foreach ($lines as $line) {
    1445. 

  1445.         $arr = array();
    1446. 

  1446.         $line = trim($line);
    1447. 

  1447.         if (ereg("^(.*) \(Niveau ([[:digit:]]{1,3}).*\)$", $line, $arr)) {
    1448. 

  1448.             list($string, $technology, $level) = $arr;
    1449. 

  1449. 

  1450.             $technology = trim($technology);
    1451. 

  1451.             $level = trim(str_replace("Niveau", "", $level));
    1452. 

  1452. 

  1453.             if (isset($link_technology[$technology])) {
    1454. 

  1454.                 $OK = true;
    1455. 

  1455.                 $technologies[$link_technology[$technology]] = $level;
    1456. 

  1456.             }
    1457. 

  1457.         }
    1458. 

  1458.     }
    1459. 

  1459. 

  1460.     if (!$OK) {
    1461. 

  1461.         redirection("index.php?action=message&id_message=set_empire_failed_data&info");
    1462. 

  1462.     }
    1463. 

  1463. 

  1464.     $request = "delete from " . TABLE_USER_TECHNOLOGY . " where user_id = " . $user_data["user_id"];
    1465. 

  1465.     $db->sql_query($request);
    1466. 

  1466. 

  1467.     $request = "insert into " . TABLE_USER_TECHNOLOGY .
    1468. 

  1468.         " (user_id, esp, Ordi, Armes, Bouclier, Protection, NRJ, Hyp, RC, RI, PH, Laser, Ions, Plasma, RRI, Graviton, Astrophysique)";
    1469. 

  1469.     $request .= " values (" . $user_data["user_id"] . ", " . $technologies["Esp"] .
    1470. 

  1470.         ", " . $technologies["Ordi"] . "," . $technologies["Armes"] . ", " . $technologies["Bouclier"] .
    1471. 

  1471.         ", " . $technologies["Protection"] . ", " . $technologies["NRJ"] . ", " . $technologies["Hyp"] .
    1472. 

  1472.         ", " . $technologies["RC"] . ", " . $technologies["RI"] . ", " . $technologies["PH"] .
    1473. 

  1473.         ", " . $technologies["Laser"] . ", " . $technologies["Ions"] . ", " . $technologies["Plasma"] .
    1474. 

  1474.         ", " . $technologies["RRI"] . ", " . $technologies["Graviton"] . ", " . $technologies["Astrophysique"] .
    1475. 

  1475.         ");";
    1476. 

  1476.     $db->sql_query($request);
    1477. 

  1477. 

  1478.     redirection("index.php?action=home&subaction=empire");
    1479. 

  1479. }
    1480. 

  1480. /**
    1481. 

  1481.  * Enregistrement des defenses de l'utilisateurs
    1482. 

  1482.  * @todo Query : x3
    1483. 

  1483.  */
    1484. 

  1484. function user_set_defence($data, $planet_id, $planet_name, $fields, $coordinates,
    1485. 

  1485.     $temperature_min, $temperature_max, $satellite)
    1486. 

  1486. {
    1487. 

  1487.     global $db, $user_data;
    1488. 

  1488.     global $pub_view, $server_config;
    1489. 

  1489.     require_once ("parameters/lang_empire.php");
    1490. 

  1490. 

  1491.     $planet_name = trim($planet_name) != "" ? trim($planet_name) : "Inconnu";
    1492. 

  1492.     if (!check_var($planet_name, "Galaxy"))
    1493. 

  1493.         $planet_name = "";
    1494. 

  1494.     $fields = intval($fields);
    1495. 

  1495.     $temperature_min = intval($temperature_min);
    1496. 

  1496.     $temperature_max = intval($temperature_max);
    1497. 

  1497.     $satellite = intval($satellite);
    1498. 

  1498.     $coordinates_ok = "";
    1499. 

  1499.     if (sizeof(explode(":", $coordinates)) == 3 || sizeof(explode(".", $coordinates)) ==
    1500. 

  1500.         3) {
    1501. 

  1501.         if (sizeof(explode(":", $coordinates)) == 3)
    1502. 

  1502.             @list($galaxy, $system, $row) = explode(":", $coordinates);
    1503. 

  1503.         if (sizeof(explode(".", $coordinates)) == 3)
    1504. 

  1504.             @list($galaxy, $system, $row) = explode(".", $coordinates);
    1505. 

  1505.         if (intval($galaxy) >= 1 && intval($galaxy) <= intval($server_config['num_of_galaxies']) &&
    1506. 

  1506.             intval($system) >= 1 && intval($system) <= intval($server_config['num_of_systems']) &&
    1507. 

  1507.             intval($row) >= 1 && intval($row) <= 15) {
    1508. 

  1508.             $coordinates_ok = $coordinates;
    1509. 

  1509.         }
    1510. 

  1510.     }
    1511. 

  1511. 

  1512.     if (!isset($planet_id)) {
    1513. 

  1513.         redirection("index.php?action=message&id_message=set_empire_failed_data&info");
    1514. 

  1514.     }
    1515. 

  1515.     $planet_id = intval($planet_id);
    1516. 

  1516.     if (($pub_view == "planets" && ($planet_id < 1 || $planet_id > 9)) || ($pub_view ==
    1517. 

  1517.         "lunes" && ($planet_id < 10 || $planet_id > 18))) {
    1518. 

  1518.         redirection("index.php?action=message&id_message=set_empire_failed_data&info");
    1519. 

  1519.     }
    1520. 

  1520. 

  1521.     $link_defence = array($lang_defence["LM"] => "LM", $lang_defence["LLE"] => "LLE",
    1522. 

  1522.         $lang_defence["LLO"] => "LLO", $lang_defence["CG"] => "CG", $lang_defence["AI"] =>
    1523. 

  1523.         "AI", $lang_defence["LP"] => "LP", $lang_defence["PB"] => "PB", $lang_defence["GB"] =>
    1524. 

  1524.         "GB", $lang_defence["MIC"] => "MIC", $lang_defence["MIP"] => "MIP");
    1525. 

  1525. 

  1526.     $defences = array("LM" => 0, "LLE" => 0, "LLO" => 0, "CG" => 0, "AI" => 0, "LP" =>
    1527. 

  1527.         0, "PB" => 0, "GB" => 0, "MIC" => 0, "MIP" => 0);
    1528. 

  1528. 

  1529.     $lines = explode(chr(10), str_replace('.', '', $data));
    1530. 

  1530. 

  1531.     $OK = false;
    1532. 

  1532.     foreach ($lines as $line) {
    1533. 

  1533.         $arr = array();
    1534. 

  1534.         $line = trim($line);
    1535. 

  1535. 

  1536.         if (ereg("^(.*) \(([[:space:][:digit:]]{1,9}|[[:digit:]]{1,9}) disponible", $line,
    1537. 

  1537.             $arr)) {
    1538. 

  1538.             list($string, $defence, $level) = $arr;
    1539. 

  1539. 

  1540.             $defence = trim($defence);
    1541. 

  1541.             $level = trim(str_replace("disponible(s)", "", $level));
    1542. 

  1542. 

  1543.             if (isset($link_defence[$defence])) {
    1544. 

  1544.                 $OK = true;
    1545. 

  1545.                 $defences[$link_defence[$defence]] = $level;
    1546. 

  1546.             }
    1547. 

  1547.         }
    1548. 

  1548.     }
    1549. 

  1549. 

  1550.     if ($OK) {
    1551. 

  1551.         $request = "delete from " . TABLE_USER_DEFENCE . " where user_id = " . $user_data["user_id"] .
    1552. 

  1552.             " and planet_id= " . $planet_id;
    1553. 

  1553.         $db->sql_query($request);
    1554. 

  1554. 

  1555.         $request = "insert into " . TABLE_USER_DEFENCE .
    1556. 

  1556.             " (user_id, planet_id, LM, LLE, LLO, CG, AI, LP, PB, GB, MIC, MIP)";
    1557. 

  1557.         $request .= " values (" . $user_data["user_id"] . ", " . $planet_id . ", " . $defences["LM"] .
    1558. 

  1558.             ", " . $defences["LLE"] . "," . $defences["LLO"] . ", " . $defences["CG"] . ", " .
    1559. 

  1559.             $defences["AI"] . ", " . $defences["LP"] . ", " . $defences["PB"] . ", " . $defences["GB"] .
    1560. 

  1560.             ", " . $defences["MIC"] . ", " . $defences["MIP"] . ")";
    1561. 

  1561.         $db->sql_query($request);
    1562. 

  1562.     } else {
    1563. 

  1563.         $request = "update " . TABLE_USER_BUILDING . " set planet_name = '" .
    1564. 

  1564.              $db->sql_escape_string($planet_name) . "', coordinates = '" . $coordinates_ok .
    1565. 

  1565.             "', `fields` = " . $fields . ", temperature_min = " . $temperature_min .
    1566. 

  1566.             ", temperature_max = " . $temperature_max . ", Sat = " . $satellite .
    1567. 

  1567.             " where user_id = " . $user_data["user_id"] . " and planet_id = " . $planet_id;
    1568. 

  1568.         $db->sql_query($request);
    1569. 

  1569.     }
    1570. 

  1570. 

  1571.     redirection("index.php?action=home&subaction=empire&view=" . $pub_view);
    1572. 

  1572. }
    1573. 

  1573. 

  1574. /**
    1575. 

  1575.  * Récupération des données empire de l'utilisateur loggé
    1576. 

  1576.  * @comment On pourrait mettre un paramètre $user_id optionnel
    1577. 

  1577.  */
    1578. 

  1578. function user_get_empire()
    1579. 

  1579. {
    1580. 

  1580.     global $db, $user_data;
    1581. 

  1581. 

  1582.     $planet = array(false, "user_id" => "", "planet_name" => "", "coordinates" => "",
    1583. 

  1583.         "fields" => "", "fields_used" => "", "boosters" => booster_encode(),
    1584. 

  1584.         "temperature_min" => "", "temperature_max" =>"",
    1585. 

  1585.         "Sat" => 0, "Sat_percentage" => 100, "M" => 0, "M_percentage" => 100, "C" => 0,
    1586. 

  1586.         "C_Percentage" => 100, "D" => 0, "D_percentage" =>100, "CES" => 0, "CES_percentage" => 100,
    1587. 

  1587.         "CEF" => 0, "CEF_percentage" => 100, "UdR" => 0, "UdN" => 0, "CSp" => 0,
    1588. 

  1588.         "HM" => 0, "HC" => 0, "HD" => 0, "CM" => 0,"CC" => 0,"CD" => 0, "Lab" => 0,
    1589. 

  1589.         "Ter" => 0, "Silo" => 0, "BaLu" => 0, "Pha" => 0, "PoSa" => 0, "DdR" => 0,
    1590. 

  1590.         "C_percentage" => 100);
    1591. 

  1591. 

  1592.     $defence = array("LM" => 0, "LLE" => 0, "LLO" => 0, "CG" => 0, "AI" => 0, "LP" =>
    1593. 

  1593.         0, "PB" => 0, "GB" => 0, "MIC" => 0, "MIP" => 0);
    1594. 

  1594. 

  1595.     // pour affichage on selectionne 9 planetes minis
    1596. 

  1596.     if (find_nb_planete_user() < 9) {
    1597. 

  1597.         $nb_planete = 9;
    1598. 

  1598.     } else {
    1599. 

  1599.         $nb_planete = find_nb_planete_user();
    1600. 

  1600.     }
    1601. 

  1601. 

  1602.     // on met les planete a 0
    1603. 

  1603.     for ($i = 101; $i <= ($nb_planete + 100); $i++) {
    1604. 

  1604.         $user_building[$i] = $planet;
    1605. 

  1605.     }
    1606. 

  1606. 

  1607.     // on met les lunes a 0
    1608. 

  1608.     for ($i = 201; $i <= ($nb_planete + 200); $i++) {
    1609. 

  1609.         $user_building[$i] = $planet;
    1610. 

  1610.     }
    1611. 

  1611. 

  1612.     $request = "SELECT planet_id, planet_name, coordinates, fields, boosters, temperature_min, temperature_max, Sat, Sat_percentage, M, M_percentage, C, C_Percentage, D, D_percentage, CES, CES_percentage, CEF, CEF_percentage, UdR, UdN, CSp, HM, HC, HD, CM, CC, CD, Lab, Ter, Silo, BaLu, Pha, PoSa, DdR";
    1613. 

  1613.     $request .= " FROM " . TABLE_USER_BUILDING;
    1614. 

  1614.     $request .= " WHERE user_id = " . $user_data["user_id"];
    1615. 

  1615.     $request .= " ORDER BY planet_id";
    1616. 

  1616.     $result = $db->sql_query($request);
    1617. 

  1617. 

  1618. 

  1619.     //	$user_building = array_fill(101,$nb_planete , $planet);
    1620. 

  1620.     while ($row = $db->sql_fetch_assoc($result)) {
    1621. 

  1621.         $arr = $row;
    1622. 

  1622.         unset($arr["planet_id"]);
    1623. 

  1623.         unset($arr["planet_name"]);
    1624. 

  1624.         unset($arr["coordinates"]);
    1625. 

  1625.         unset($arr["fields"]);
    1626. 

  1626.         unset($arr["boosters"]);
    1627. 

  1627.         unset($arr["temperature_min"]);
    1628. 

  1628.         unset($arr["temperature_max"]);
    1629. 

  1629.         unset($arr["Sat"]);
    1630. 

  1630.         unset($arr["Sat_percentage"]);
    1631. 

  1631.         unset($arr["M_percentage"]);
    1632. 

  1632.         unset($arr["C_Percentage"]);
    1633. 

  1633.         unset($arr["D_percentage"]);
    1634. 

  1634.         unset($arr["CES_percentage"]);
    1635. 

  1635.         unset($arr["CEF_percentage"]);
    1636. 

  1636.         $fields_used = array_sum(array_values($arr));
    1637. 

  1637. 

  1638. 

  1639.         $row["fields_used"] = $fields_used;
    1640. 

  1640.         $row["boosters"] = booster_verify_str($row["boosters"]);    //Correction et mise à jour booster from date
    1641. 

  1641.         $row["C_percentage"] = $row["C_Percentage"];
    1642. 

  1642.         $user_building[$row["planet_id"]] = $row;
    1643. 

  1643.         $user_building[$row["planet_id"]][0] = true;
    1644. 

  1644.     }
    1645. 

  1645. 

  1646. 

  1647.     $request = "SELECT Esp, Ordi, Armes, Bouclier, Protection, NRJ, Hyp, RC, RI, PH, Laser, Ions, Plasma, RRI, Graviton, Astrophysique";
    1648. 

  1648.     $request .= " FROM " . TABLE_USER_TECHNOLOGY;
    1649. 

  1649.     $request .= " WHERE user_id = " . $user_data["user_id"];
    1650. 

  1650.     $result = $db->sql_query($request);
    1651. 

  1651. 

  1652.     $user_technology = $db->sql_fetch_assoc($result);
    1653. 

  1653. 

  1654.     $request = "SELECT planet_id, LM, LLE, LLO, CG, AI, LP, PB, GB, MIC, MIP";
    1655. 

  1655.     $request .= " FROM " . TABLE_USER_DEFENCE;
    1656. 

  1656.     $request .= " WHERE user_id = " . $user_data["user_id"];
    1657. 

  1657.     $request .= " ORDER BY planet_id";
    1658. 

  1658.     $result = $db->sql_query($request);
    1659. 

  1659. 

  1660. 

  1661.     // on met les def planete a 0
    1662. 

  1662.     for ($i = 101; $i <= ($nb_planete + 100); $i++) {
    1663. 

  1663.         $user_defence[$i] = $defence;
    1664. 

  1664.     }
    1665. 

  1665. 

  1666.     // on met les def lunes a 0
    1667. 

  1667.     for ($i = 201; $i <= ($nb_planete + 200); $i++) {
    1668. 

  1668.         $user_defence[$i] = $defence;
    1669. 

  1669.     }
    1670. 

  1670. 

  1671.     //$user_defence = array_fill(1, $nb_planete_lune, $defence);
    1672. 

  1672.     while ($row = $db->sql_fetch_assoc($result)) {
    1673. 

  1673.         $planet_id = $row["planet_id"];
    1674. 

  1674.         unset($row["planet_id"]);
    1675. 

  1675.         $user_defence[$planet_id] = $row;
    1676. 

  1676.     }
    1677. 

  1677. 

  1678.     return array("building" => $user_building, "technology" => $user_technology,
    1679. 

  1679.         "defence" => $user_defence, );
    1680. 

  1680. }
    1681. 

  1681. /**
    1682. 

  1682.  * Récuperation du nombre de  planete de l utilisateur
    1683. 

  1683.  * TODO => cette fonction sera a mettre en adequation avec astro 
    1684. 

  1684.  * ( attention ancien uni techno a 1 planete mais utilisateur 9 possible  !!!!!)
    1685. 

  1685.  */
    1686. 

  1686. function find_nb_planete_user()
    1687. 

  1687. {
    1688. 

  1688.     global $db, $user_data;
    1689. 

  1689. 

  1690. 

  1691.     $request = "SELECT planet_id ";
    1692. 

  1692.     $request .= " FROM " . TABLE_USER_BUILDING;
    1693. 

  1693.     $request .= " WHERE user_id = " . $user_data["user_id"];
    1694. 

  1694.     $request .= " AND planet_id < 199 ";
    1695. 

  1695.     $request .= " ORDER BY planet_id";
    1696. 

  1696. 

  1697.     $result = $db->sql_query($request);
    1698. 

  1698. 

  1699.     //mini 9 pour eviter bug affichage
    1700. 

  1700.     if ($db->sql_numrows($result) <= 9)
    1701. 

  1701.         return 9;
    1702. 

  1702. 

  1703.     return $db->sql_numrows($result);
    1704. 

  1704. 

  1705. }
    1706. 

  1706. function find_nb_moon_user()
    1707. 

  1707. {
    1708. 

  1708.     global $db, $user_data;
    1709. 

  1709. 

  1710. 

  1711.     $request = "select planet_id ";
    1712. 

  1712.     $request .= " from " . TABLE_USER_BUILDING;
    1713. 

  1713.     $request .= " where user_id = " . $user_data["user_id"];
    1714. 

  1714.     $request .= " and planet_id > 199 ";
    1715. 

  1715.     $request .= " order by planet_id";
    1716. 

  1716. 

  1717.     $result = $db->sql_query($request);
    1718. 

  1718. 

  1719.     //mini 9 pour eviter bug affichage
    1720. 

  1720.     if ($db->sql_numrows($result) <= 9)
    1721. 

  1721.         return 9;
    1722. 

  1722. 

  1723.     return $db->sql_numrows($result);
    1724. 

  1724. 

  1725. }
    1726. 

  1726. 

  1727. /**
    1728. 

  1728.  * Suppression des données de batiments de l'utilisateur loggé
    1729. 

  1729.  */
    1730. 

  1730. function user_del_building()
    1731. 

  1731. {
    1732. 

  1732.     global $db, $user_data;
    1733. 

  1733.     global $pub_planet_id, $pub_view;
    1734. 

  1734. 

  1735.     if (!check_var($pub_planet_id, "Num")) {
    1736. 

  1736.         redirection("index.php?action=message&id_message=errordata&info");
    1737. 

  1737.     }
    1738. 

  1738.     if (!isset($pub_planet_id)) {
    1739. 

  1739.         redirection("index.php?action=message&id_message=errorfatal&info");
    1740. 

  1740.     }
    1741. 

  1741. 

  1742.     $request = "delete from " . TABLE_USER_BUILDING . " where user_id = " . $user_data["user_id"] .
    1743. 

  1743.         " and planet_id = " . intval($pub_planet_id);
    1744. 

  1744.     $db->sql_query($request);
    1745. 

  1745. 

  1746.     $request = "delete from " . TABLE_USER_DEFENCE . " where user_id = " . $user_data["user_id"] .
    1747. 

  1747.         " and planet_id = " . intval($pub_planet_id);
    1748. 

  1748.     $db->sql_query($request);
    1749. 

  1749. 

  1750.     // si on supprime une planete; la lune doit suivre
    1751. 

  1751.     if (intval($pub_planet_id) < 199) {
    1752. 

  1752.         $moon_id = (intval($pub_planet_id) + 100);
    1753. 

  1753.         $request = "delete from " . TABLE_USER_BUILDING . " where user_id = " . $user_data["user_id"] .
    1754. 

  1754.             " and planet_id = " . intval($moon_id);
    1755. 

  1755.         $db->sql_query($request);
    1756. 

  1756. 

  1757.         $request = "delete from " . TABLE_USER_DEFENCE . " where user_id = " . $user_data["user_id"] .
    1758. 

  1758.             " and planet_id = " . intval($moon_id);
    1759. 

  1759.         $db->sql_query($request);
    1760. 

  1760.     }
    1761. 

  1761. 

  1762.     $request = "select * from " . TABLE_USER_BUILDING . " where planet_id <= 199";
    1763. 

  1763.     $result = $db->sql_query($request);
    1764. 

  1764.     if ($db->sql_numrows($result) == 0) {
    1765. 

  1765.         $request = "delete from " . TABLE_USER_TECHNOLOGY . " where user_id = " . $user_data["user_id"];
    1766. 

  1766.         $db->sql_query($request);
    1767. 

  1767.     }
    1768. 

  1768. 

  1769.     // remise en ordre des planetes :
    1770. 

  1770.     user_set_all_empire_resync_planet();
    1771. 

  1771. 

  1772.     redirection("index.php?action=home&subaction=empire&view=" . $pub_view);
    1773. 

  1773. }
    1774. 

  1774. /**
    1775. 

  1775.  * Déplacement des données de planète de la page empire
    1776. 

  1776.  */
    1777. 

  1777. function user_move_empire()
    1778. 

  1778. {
    1779. 

  1779.     global $db, $user_data;
    1780. 

  1780.     global $pub_planet_id, $pub_left, $pub_right;
    1781. 

  1781. 

  1782.     $nb_planete = find_nb_planete_user();
    1783. 

  1783. 

  1784.     if (!check_var($pub_planet_id, "Num")) {
    1785. 

  1785.         redirection("index.php?action=message&id_message=errordata&info");
    1786. 

  1786.     }
    1787. 

  1787.     if (!isset($pub_planet_id) || (!isset($pub_left) && !isset($pub_right))) {
    1788. 

  1788.         redirection("index.php?action=message&id_message=errorfatal&info");
    1789. 

  1789.     }
    1790. 

  1790. 

  1791.     $pub_planet_id = intval($pub_planet_id);
    1792. 

  1792.     if ($pub_planet_id < 101 || $pub_planet_id > (100 + $nb_planete)) {
    1793. 

  1793.         redirection("index.php?action=message&id_message=errorfatal&info");
    1794. 

  1794.     }
    1795. 

  1795.     if (isset($pub_left)) {
    1796. 

  1796.         if ($pub_planet_id == 101)
    1797. 

  1797.             redirection("index.php?action=home&subaction=empire");
    1798. 

  1798.         $new_position = $pub_planet_id - 1;
    1799. 

  1799.     } elseif (isset($pub_right)) {
    1800. 

  1800.         if ($pub_planet_id == (100 + $nb_planete))
    1801. 

  1801.             redirection("index.php?action=home&subaction=empire");
    1802. 

  1802.         $new_position = $pub_planet_id + 1;
    1803. 

  1803.     }
    1804. 

  1804. 

  1805.     $request = "update " . TABLE_USER_BUILDING . " set planet_id = -" . $new_position .
    1806. 

  1806.         " where user_id = " . $user_data["user_id"] . " and planet_id = " . $pub_planet_id;
    1807. 

  1807.     $db->sql_query($request);
    1808. 

  1808. 

  1809.     $request = "update " . TABLE_USER_BUILDING . " set planet_id = " . $pub_planet_id .
    1810. 

  1810.         " where user_id = " . $user_data["user_id"] . " and planet_id = " . $new_position;
    1811. 

  1811.     $db->sql_query($request);
    1812. 

  1812. 

  1813.     $request = "update " . TABLE_USER_BUILDING . " set planet_id = " . $new_position .
    1814. 

  1814.         " where user_id = " . $user_data["user_id"] . " and planet_id = -" . $new_position;
    1815. 

  1815.     $db->sql_query($request);
    1816. 

  1816. 

  1817. 

  1818.     $request = "update " . TABLE_USER_DEFENCE . " set planet_id = -" . $new_position .
    1819. 

  1819.         " where user_id = " . $user_data["user_id"] . " and planet_id = " . $pub_planet_id;
    1820. 

  1820.     $db->sql_query($request);
    1821. 

  1821. 

  1822.     $request = "update " . TABLE_USER_DEFENCE . " set planet_id = " . $pub_planet_id .
    1823. 

  1823.         " where user_id = " . $user_data["user_id"] . " and planet_id = " . $new_position;
    1824. 

  1824.     $db->sql_query($request);
    1825. 

  1825. 

  1826.     $request = "update " . TABLE_USER_DEFENCE . " set planet_id = " . $new_position .
    1827. 

  1827.         " where user_id = " . $user_data["user_id"] . " and planet_id = -" . $new_position;
    1828. 

  1828.     $db->sql_query($request);
    1829. 

  1829. 

  1830. 

  1831.     // remise en ordre des planetes :
    1832. 

  1832.     user_set_all_empire_resync_planet();
    1833. 

  1833. 

  1834.     redirection("index.php?action=home&subaction=empire");
    1835. 

  1835. }
    1836. 

  1836. 

  1837. /**
    1838. 

  1838.  * Ajout d'un système favori
    1839. 

  1839.  */
    1840. 

  1840. function user_add_favorite()
    1841. 

  1841. {
    1842. 

  1842.     global $db, $user_data, $server_config;
    1843. 

  1843.     global $pub_galaxy, $pub_system;
    1844. 

  1844. 

  1845.     if (!isset($pub_galaxy) || !isset($pub_system)) {
    1846. 

  1846.         redirection("index.php");
    1847. 

  1847.     }
    1848. 

  1848.     if (intval($pub_galaxy) < 1 || intval($pub_galaxy) > intval($server_config['num_of_galaxies']) ||
    1849. 

  1849.         intval($pub_system) < 1 || intval($pub_system) > intval($server_config['num_of_systems'])) {
    1850. 

  1850.         redirection("index.php?action=galaxy");
    1851. 

  1851.     }
    1852. 

  1852. 

  1853.     $request = "select * from " . TABLE_USER_FAVORITE . " where user_id = " . $user_data["user_id"];
    1854. 

  1854.     $result = $db->sql_query($request);
    1855. 

  1855.     $nb_favorites = $db->sql_numrows($result);
    1856. 

  1856. 

  1857.     if ($nb_favorites < $server_config["max_favorites"]) {
    1858. 

  1858.         $request = "insert ignore into " . TABLE_USER_FAVORITE .
    1859. 

  1859.             " (user_id, galaxy, system) values (" . $user_data["user_id"] . ", '" . $pub_galaxy .
    1860. 

  1860.             "', " . $pub_system . ")";
    1861. 

  1861.         $db->sql_query($request);
    1862. 

  1862.         redirection("index.php?action=galaxy&galaxy=" . $pub_galaxy . "&system=" . $pub_system);
    1863. 

  1863.     } else {
    1864. 

  1864.         redirection("index.php?action=message&id_message=max_favorites&info");
    1865. 

  1865.     }
    1866. 

  1866. }
    1867. 

  1867. 

  1868. /**
    1869. 

  1869.  * Suppression d'un système favori
    1870. 

  1870.  */
    1871. 

  1871. function user_del_favorite()
    1872. 

  1872. {
    1873. 

  1873.     global $db, $user_data;
    1874. 

  1874.     global $pub_galaxy, $pub_system, $server_config;
    1875. 

  1875. 

  1876.     if (!isset($pub_galaxy) || !isset($pub_system)) {
    1877. 

  1877.         redirection("index.php");
    1878. 

  1878.     }
    1879. 

  1879.     if (intval($pub_galaxy) < 1 || intval($pub_galaxy) > intval($server_config['num_of_galaxies']) ||
    1880. 

  1880.         intval($pub_system) < 1 || intval($pub_system) > intval($server_config['num_of_systems'])) {
    1881. 

  1881.         redirection("index.php?action=galaxy");
    1882. 

  1882.     }
    1883. 

  1883.     $request = "delete from " . TABLE_USER_FAVORITE . " where user_id = " . $user_data["user_id"] .
    1884. 

  1884.         " and galaxy = '" . $pub_galaxy . "' and system = " . $pub_system;
    1885. 

  1885.     $db->sql_query($request);
    1886. 

  1886. 

  1887.     redirection("index.php?action=galaxy&galaxy=" . $pub_galaxy . "&system=" . $pub_system .
    1888. 

  1888.         "");
    1889. 

  1889. }
    1890. 

  1890. 

  1891. /**
    1892. 

  1892.  * Récupération des rapports favoris
    1893. 

  1893.  */
    1894. 

  1894. function user_getfavorites_spy()
    1895. 

  1895. {
    1896. 

  1896.     global $db, $user_data;
    1897. 

  1897.     global $sort, $sort2;
    1898. 

  1898. 

  1899.     if (!isset($sort) || !isset($sort2) || !is_numeric($sort) || !is_numeric($sort2)) {
    1900. 

  1900.         $orderby = "dateRE desc";
    1901. 

  1901.     } else {
    1902. 

  1902.         switch ($sort2) {
    1903. 

  1903.             case 0:
    1904. 

  1904.                 $order .= " desc";
    1905. 

  1905.                 break;
    1906. 

  1906.             case 1:
    1907. 

  1907.                 $order .= " asc";
    1908. 

  1908.                 break;
    1909. 

  1909.             default:
    1910. 

  1910.                 $order .= " asc";
    1911. 

  1911.         }
    1912. 

  1912. 

  1913.         switch ($sort) {
    1914. 

  1914.             case 1:
    1915. 

  1915.                 $orderby = "coordinates" . $order . "";
    1916. 

  1916.                 break;
    1917. 

  1917.             case 2:
    1918. 

  1918.                 $orderby = "ally " . $order;
    1919. 

  1919.                 break;
    1920. 

  1920.             case 3:
    1921. 

  1921.                 $orderby = "player " . $order;
    1922. 

  1922.                 break;
    1923. 

  1923.             case 4:
    1924. 

  1924.                 $orderby = "moon " . $order;
    1925. 

  1925.                 break;
    1926. 

  1926.             case 5:
    1927. 

  1927.                 $orderby = "dateRE " . $order;
    1928. 

  1928.                 break;
    1929. 

  1929.             default:
    1930. 

  1930.                 $orderby = "dateRE " . $order;
    1931. 

  1931.         }
    1932. 

  1932.     }
    1933. 

  1933. 

  1934.     $favorite = array();
    1935. 

  1935. 

  1936.     $request = "select " . TABLE_PARSEDSPY .
    1937. 

  1937.         ".id_spy, coordinates, dateRE, sender_id, " . TABLE_UNIVERSE . ".moon, " .
    1938. 

  1938.         TABLE_UNIVERSE . ".ally, " . TABLE_UNIVERSE . ".player, " . TABLE_UNIVERSE .
    1939. 

  1939.         ".status";
    1940. 

  1940.     $request .= " from " . TABLE_PARSEDSPY . ", " . TABLE_USER_SPY . ", " .
    1941. 

  1941.         TABLE_UNIVERSE;
    1942. 

  1942.     $request .= " where user_id = " . $user_data["user_id"] . " and CONCAT(" .
    1943. 

  1943.         TABLE_UNIVERSE . ".galaxy,':'," . TABLE_UNIVERSE . ".system,':'," .
    1944. 

  1944.         TABLE_UNIVERSE . ".row)=coordinates and " . TABLE_USER_SPY . ".spy_id=" .
    1945. 

  1945.         TABLE_PARSEDSPY . ".id_spy";
    1946. 

  1946.     $request .= " order by " . $orderby;
    1947. 

  1947.     $result = $db->sql_query($request);
    1948. 

  1948. 

  1949.     while (list($spy_id, $coordinates, $datadate, $sender_id, $moon, $ally, $player,
    1950. 

  1950.         $status) = $db->sql_fetch_row($result)) {
    1951. 

  1951.         $request = "select user_name from " . TABLE_USER;
    1952. 

  1952.         $request .= " where user_id=" . $sender_id;
    1953. 

  1953.         $result_2 = $db->sql_query($request);
    1954. 

  1954.         list($user_name) = $db->sql_fetch_row($result_2);
    1955. 

  1955.         $favorite[$spy_id] = array("spy_id" => $spy_id, "spy_galaxy" => substr($coordinates,
    1956. 

  1956.             0, strpos($coordinates, ':')), "spy_system" => substr($coordinates, strpos($coordinates,
    1957. 

  1957.             ':') + 1, strrpos($coordinates, ':') - strpos($coordinates, ':') - 1), "spy_row" =>
    1958. 

  1958.             substr($coordinates, strrpos($coordinates, ':') + 1), "player" => $player,
    1959. 

  1959.             "ally" => $ally, "moon" => $moon, "status" => $status, "datadate" => $datadate,
    1960. 

  1960.             "poster" => $user_name);
    1961. 

  1961.     }
    1962. 

  1962. 

  1963.     return $favorite;
    1964. 

  1964. }
    1965. 

  1965. 

  1966. /**
    1967. 

  1967.  * Ajout d'un rapport favori
    1968. 

  1968.  */
    1969. 

  1969. function user_add_favorite_spy()
    1970. 

  1970. {
    1971. 

  1971.     global $db, $user_data, $server_config;
    1972. 

  1972.     global $pub_spy_id, $pub_galaxy, $pub_system, $pub_row;
    1973. 

  1973. 

  1974.     if (!check_var($pub_spy_id, "Num")) {
    1975. 

  1975.         redirection("index.php?action=message&id_message=errordata&info");
    1976. 

  1976.     }
    1977. 

  1977. 

  1978.     if (!isset($pub_spy_id)) {
    1979. 

  1979.         redirection("index.php?action=message&id_message=errorfatal&info");
    1980. 

  1980.     }
    1981. 

  1981. 

  1982.     $request = "select * from " . TABLE_USER_SPY . " where user_id = " . $user_data["user_id"];
    1983. 

  1983.     $result = $db->sql_query($request);
    1984. 

  1984.     $nb_favorites = $db->sql_numrows($result);
    1985. 

  1985. 

  1986.     if ($nb_favorites < $server_config["max_favorites_spy"]) {
    1987. 

  1987.         $request = "insert ignore into " . TABLE_USER_SPY .
    1988. 

  1988.             " (user_id, spy_id) values (" . $user_data["user_id"] . ", " . $pub_spy_id . ")";
    1989. 

  1989.         $db->sql_query($request);
    1990. 

  1990.         redirection("index.php?action=show_reportspy&galaxy=" . $pub_galaxy . "&system=" .
    1991. 

  1991.             $pub_system . "&row=" . $pub_row);
    1992. 

  1992.     } else {
    1993. 

  1993.         redirection("index.php?action=message&id_message=max_favorites&info=_spy");
    1994. 

  1994.     }
    1995. 

  1995. }
    1996. 

  1996. 

  1997. /**
    1998. 

  1998.  * Suppression d'un rapport favori
    1999. 

  1999.  */
    2000. 

  2000. function user_del_favorite_spy()
    2001. 

  2001. {
    2002. 

  2002.     global $db, $user_data;
    2003. 

  2003.     global $pub_spy_id, $pub_galaxy, $pub_system, $pub_row, $pub_info;
    2004. 

  2004. 

  2005.     if (!check_var($pub_spy_id, "Num")) {
    2006. 

  2006.         redirection("index.php?action=message&id_message=errordata&info");
    2007. 

  2007.     }
    2008. 

  2008. 

  2009.     if (!isset($pub_spy_id)) {
    2010. 

  2010.         redirection("index.php?action=message&id_message=errorfatal&info");
    2011. 

  2011.     }
    2012. 

  2012. 

  2013.     $request = "delete from " . TABLE_USER_SPY . " where user_id = " . $user_data["user_id"] .
    2014. 

  2014.         " and spy_id = '" . $pub_spy_id . "'";
    2015. 

  2015.     $db->sql_query($request);
    2016. 

  2016. 

  2017.     if (!isset($pub_info))
    2018. 

  2018.         $pub_info = 1;
    2019. 

  2019. 

  2020.     switch ($pub_info) {
    2021. 

  2021.         case 2:
    2022. 

  2022.             redirection("index.php?action=show_reportspy&galaxy=" . $pub_galaxy . "&system=" .
    2023. 

  2023.                 $pub_system . "&row=" . $pub_row);
    2024. 

  2024.         case 1:
    2025. 

  2025.             redirection("index.php?action=home&subaction=spy");
    2026. 

  2026.         default:
    2027. 

  2027.             return true;
    2028. 

  2028.     }
    2029. 

  2029. }
    2030. 

  2030. 

  2031. /**
    2032. 

  2032.  * Création d'un groupe
    2033. 

  2033.  */
    2034. 

  2034. function usergroup_create()
    2035. 

  2035. {
    2036. 

  2036.     global $db, $user_data;
    2037. 

  2037.     global $pub_groupname;
    2038. 

  2038. 

  2039.     if (!isset($pub_groupname)) {
    2040. 

  2040.         redirection("index.php?action=message&id_message=createusergroup_failed_general&info");
    2041. 

  2041.     }
    2042. 

  2042. 

  2043.     //Vérification des droits
    2044. 

  2044.     user_check_auth("usergroup_manage");
    2045. 

  2045. 

  2046.     if (!check_var($pub_groupname, "Pseudo_Groupname")) {
    2047. 

  2047.         redirection("index.php?action=message&id_message=createusergroup_failed_groupname&info");
    2048. 

  2048.     }
    2049. 

  2049. 

  2050.     $request = "select group_id from " . TABLE_GROUP . " where group_name = '" .
    2051. 

  2051.          $db->sql_escape_string($pub_groupname) . "'";
    2052. 

  2052.     $result = $db->sql_query($request);
    2053. 

  2053. 

  2054.     if ($db->sql_numrows($result) == 0) {
    2055. 

  2055.         $request = "insert into " . TABLE_GROUP . " (group_name)" . " values ('" .
    2056. 

  2056.              $db->sql_escape_string($pub_groupname) . "')";
    2057. 

  2057.         $db->sql_query($request);
    2058. 

  2058.         $group_id = $db->sql_insertid();
    2059. 

  2059. 

  2060.         log_("create_usergroup", $pub_groupname);
    2061. 

  2061.         redirection("index.php?action=administration&subaction=group&group_id=" . $group_id);
    2062. 

  2062.     } else {
    2063. 

  2063.         redirection("index.php?action=message&id_message=createusergroup_failed_groupnamelocked&info=" .
    2064. 

  2064.             $pub_groupname);
    2065. 

  2065.     }
    2066. 

  2066. }
    2067. 

  2067. 

  2068. /**
    2069. 

  2069.  * Suppression d'un groupe utilisateur
    2070. 

  2070.  */
    2071. 

  2071. function usergroup_delete()
    2072. 

  2072. {
    2073. 

  2073.     global $db, $user_data;
    2074. 

  2074.     global $pub_group_id;
    2075. 

  2075. 

  2076.     if (!check_var($pub_group_id, "Num")) {
    2077. 

  2077.         redirection("index.php?action=message&id_message=errordata&info");
    2078. 

  2078.     }
    2079. 

  2079. 

  2080.     if (!isset($pub_group_id)) {
    2081. 

  2081.         redirection("index.php?action=message&id_message=createusergroup_failed_general&info");
    2082. 

  2082.     }
    2083. 

  2083. 

  2084.     //Vérification des droits
    2085. 

  2085.     user_check_auth("usergroup_manage");
    2086. 

  2086. 

  2087.     if ($pub_group_id == 1) {
    2088. 

  2088.         redirection("index.php?action=administration&subaction=group&group_id=1");
    2089. 

  2089.     }
    2090. 

  2090. 

  2091.     log_("delete_usergroup", $pub_group_id);
    2092. 

  2092. 

  2093.     $request = "delete from " . TABLE_USER_GROUP . " where group_id = " . intval($pub_group_id);
    2094. 

  2094.     $db->sql_query($request);
    2095. 

  2095. 

  2096.     $request = "delete from " . TABLE_GROUP . " where group_id = " . intval($pub_group_id);
    2097. 

  2097.     $db->sql_query($request);
    2098. 

  2098. 

  2099.     redirection("index.php?action=administration&subaction=group");
    2100. 

  2100. }
    2101. 

  2101. 

  2102. /**
    2103. 

  2103.  * Récupération des droits d'un groupe d'utilisateurs
    2104. 

  2104.  */
    2105. 

  2105. function usergroup_get($group_id = false)
    2106. 

  2106. {
    2107. 

  2107.     global $db, $user_data;
    2108. 

  2108. 

  2109.     //Vérification des droits
    2110. 

  2110.     user_check_auth("usergroup_manage");
    2111. 

  2111. 

  2112.     $request = "select group_id, group_name, ";
    2113. 

  2113.     $request .= " server_set_system, server_set_spy, server_set_rc, server_set_ranking, server_show_positionhided,";
    2114. 

  2114.     $request .= " ogs_connection, ogs_set_system, ogs_get_system, ogs_set_spy, ogs_get_spy, ogs_set_ranking, ogs_get_ranking";
    2115. 

  2115.     $request .= " from " . TABLE_GROUP;
    2116. 

  2116. 

  2117.     if ($group_id !== false) {
    2118. 

  2118.         if (intval($group_id) == 0)
    2119. 

  2119.             return false;
    2120. 

  2120.         $request .= " where group_id = " . $group_id;
    2121. 

  2121.     }
    2122. 

  2122.     $request .= " order by group_name";
    2123. 

  2123.     $result = $db->sql_query($request);
    2124. 

  2124. 

  2125.     if (!$group_id) {
    2126. 

  2126.         $info_usergroup = array();
    2127. 

  2127.         while ($row = $db->sql_fetch_assoc()) {
    2128. 

  2128.             $info_usergroup[] = $row;
    2129. 

  2129.         }
    2130. 

  2130.     } else {
    2131. 

  2131.         while ($row = $db->sql_fetch_assoc()) {
    2132. 

  2132.             $info_usergroup = $row;
    2133. 

  2133.         }
    2134. 

  2134.     }
    2135. 

  2135. 

  2136.     if (sizeof($info_usergroup) == 0) {
    2137. 

  2137.         return false;
    2138. 

  2138.     }
    2139. 

  2139. 

  2140.     return $info_usergroup;
    2141. 

  2141. }
    2142. 

  2142. /**
    2143. 

  2143.  * Enregistrement des droits d'un groupe utilisateurs
    2144. 

  2144.  */
    2145. 

  2145. function usergroup_setauth()
    2146. 

  2146. {
    2147. 

  2147.     global $db, $user_data;
    2148. 

  2148.     global $pub_group_id, $pub_group_name, $pub_server_set_system, $pub_server_set_spy,
    2149. 

  2149.         $pub_server_set_rc, $pub_server_set_ranking, $pub_server_show_positionhided, $pub_ogs_connection,
    2150. 

  2150.         $pub_ogs_set_system, $pub_ogs_get_system, $pub_ogs_set_spy, $pub_ogs_get_spy, $pub_ogs_set_ranking,
    2151. 

  2151.         $pub_ogs_get_ranking;
    2152. 

  2152. 

  2153.     if (!check_var($pub_group_id, "Num") || !check_var($pub_group_name,
    2154. 

  2154.         "Pseudo_Groupname") || !check_var($pub_server_set_system, "Num") || !check_var($pub_server_set_spy,
    2155. 

  2155.         "Num") || !check_var($pub_server_set_rc, "Num") || !check_var($pub_server_set_ranking,
    2156. 

  2156.         "Num") || !check_var($pub_server_show_positionhided, "Num") || !check_var($pub_ogs_connection,
    2157. 

  2157.         "Num") || !check_var($pub_ogs_set_system, "Num") || !check_var($pub_ogs_get_system,
    2158. 

  2158.         "Num") || !check_var($pub_ogs_set_spy, "Num") || !check_var($pub_ogs_get_spy,
    2159. 

  2159.         "Num") || !check_var($pub_ogs_set_ranking, "Num") || !check_var($pub_ogs_get_ranking,
    2160. 

  2160.         "Num")) {
    2161. 

  2161.         redirection("index.php?action=message&id_message=errordata&info");
    2162. 

  2162.     }
    2163. 

  2163. 

  2164.     if (!isset($pub_group_id) || !isset($pub_group_name)) {
    2165. 

  2165.         redirection("index.php?action=message&id_message=errorfatal&info");
    2166. 

  2166.     }
    2167. 

  2167. 

  2168.     if (is_null($pub_server_set_system))
    2169. 

  2169.         $pub_server_set_system = 0;
    2170. 

  2170.     if (is_null($pub_server_set_spy))
    2171. 

  2171.         $pub_server_set_spy = 0;
    2172. 

  2172.     if (is_null($pub_server_set_rc))
    2173. 

  2173.         $pub_server_set_rc = 0;
    2174. 

  2174.     if (is_null($pub_server_set_ranking))
    2175. 

  2175.         $pub_server_set_ranking = 0;
    2176. 

  2176.     if (is_null($pub_server_show_positionhided))
    2177. 

  2177.         $pub_server_show_positionhided = 0;
    2178. 

  2178.     if (is_null($pub_ogs_connection))
    2179. 

  2179.         $pub_ogs_connection = 0;
    2180. 

  2180.     if (is_null($pub_ogs_set_system))
    2181. 

  2181.         $pub_ogs_set_system = 0;
    2182. 

  2182.     if (is_null($pub_ogs_get_system))
    2183. 

  2183.         $pub_ogs_get_system = 0;
    2184. 

  2184.     if (is_null($pub_ogs_set_spy))
    2185. 

  2185.         $pub_ogs_set_spy = 0;
    2186. 

  2186.     if (is_null($pub_ogs_get_spy))
    2187. 

  2187.         $pub_ogs_get_spy = 0;
    2188. 

  2188.     if (is_null($pub_ogs_set_ranking))
    2189. 

  2189.         $pub_ogs_set_ranking = 0;
    2190. 

  2190.     if (is_null($pub_ogs_get_ranking))
    2191. 

  2191.         $pub_ogs_get_ranking = 0;
    2192. 

  2192. 

  2193.     //Vérification des droits
    2194. 

  2194.     user_check_auth("usergroup_manage");
    2195. 

  2195. 

  2196.     log_("modify_usergroup", $pub_group_id);
    2197. 

  2197. 

  2198.     $request = "update " . TABLE_GROUP;
    2199. 

  2199.     $request .= " set group_name = '" .  $db->sql_escape_string($pub_group_name) .
    2200. 

  2200.         "',";
    2201. 

  2201.     $request .= " server_set_system = '" . intval($pub_server_set_system) .
    2202. 

  2202.         "', server_set_spy = '" . intval($pub_server_set_spy) . "', server_set_rc = '" .
    2203. 

  2203.         intval($pub_server_set_rc) . "', server_set_ranking = '" . intval($pub_server_set_ranking) .
    2204. 

  2204.         "', server_show_positionhided = '" . intval($pub_server_show_positionhided) .
    2205. 

  2205.         "',";
    2206. 

  2206.     $request .= " ogs_connection = '" . intval($pub_ogs_connection) .
    2207. 

  2207.         "', ogs_set_system = '" . intval($pub_ogs_set_system) . "', ogs_get_system = '" .
    2208. 

  2208.         intval($pub_ogs_get_system) . "', ogs_set_spy = '" . intval($pub_ogs_set_spy) .
    2209. 

  2209.         "', ogs_get_spy = '" . intval($pub_ogs_get_spy) . "', ogs_set_ranking = '" .
    2210. 

  2210.         intval($pub_ogs_set_ranking) . "', ogs_get_ranking = '" . intval($pub_ogs_get_ranking) .
    2211. 

  2211.         "'";
    2212. 

  2212.     $request .= " where group_id = " . intval($pub_group_id);
    2213. 

  2213.     $db->sql_query($request);
    2214. 

  2214. 

  2215.     redirection("index.php?action=administration&subaction=group&group_id=" . $pub_group_id);
    2216. 

  2216. }
    2217. 

  2217. 

  2218. /**
    2219. 

  2219.  * Récupération des utilisateurs appartenant à un groupe
    2220. 

  2220.  * @param int $group_id Identificateur du groupe demandé
    2221. 

  2221.  * @return Array Liste des utilisateurs
    2222. 

  2222.  */
    2223. 

  2223. function usergroup_member($group_id)
    2224. 

  2224. {
    2225. 

  2225.     global $db, $user_data;
    2226. 

  2226. 

  2227.     if (!isset($group_id) || !is_numeric($group_id)) {
    2228. 

  2228.         redirection("index.php?action=message&id_message=errorfatal&info");
    2229. 

  2229.     }
    2230. 

  2230. 

  2231.     $usergroup_member = array();
    2232. 

  2232. 

  2233.     $request = "select u.user_id, u.user_name from " . TABLE_USER . " as  u, " .
    2234. 

  2234.         TABLE_USER_GROUP . " as g";
    2235. 

  2235.     $request .= " where u.user_id = g.user_id";
    2236. 

  2236.     $request .= " and g.group_id = " . intval($group_id);
    2237. 

  2237.     $request .= " order by user_name";
    2238. 

  2238.     $result = $db->sql_query($request);
    2239. 

  2239.     while ($row = $db->sql_fetch_assoc()) {
    2240. 

  2240.         $usergroup_member[] = $row;
    2241. 

  2241.     }
    2242. 

  2242. 

  2243.     return $usergroup_member;
    2244. 

  2244. }
    2245. 

  2245. 

  2246. /**
    2247. 

  2247.  * Ajout d'un utilisateur à un groupe
    2248. 

  2248.  */
    2249. 

  2249. function usergroup_newmember()
    2250. 

  2250. {
    2251. 

  2251.     global $db, $user_data;
    2252. 

  2252.     global $pub_user_id, $pub_group_id, $pub_add_all;
    2253. 

  2253. 

  2254.     if ($pub_add_all == "Ajouter tout les membres") {
    2255. 

  2255.         $request = "SELECT user_id FROM " . TABLE_USER;
    2256. 

  2256.         $result = $db->sql_query($request);
    2257. 

  2257. 

  2258.         while ($res = $db->sql_fetch_assoc($result)) {
    2259. 

  2259.             user_check_auth("usergroup_manage");
    2260. 

  2260.             $request = "INSERT IGNORE INTO " . TABLE_USER_GROUP .
    2261. 

  2261.                 " (group_id, user_id) values (" . intval($pub_group_id) . ", " . intval($res["user_id"]) .
    2262. 

  2262.                 ")";
    2263. 

  2263.             $db->sql_query($request);
    2264. 

  2264.         }
    2265. 

  2265.         redirection("index.php?action=administration&subaction=group");
    2266. 

  2266.     } else {
    2267. 

  2267.         if (!check_var($pub_user_id, "Num") || !check_var($pub_group_id, "Num")) {
    2268. 

  2268.             redirection("index.php?action=message&id_message=errordata&info");
    2269. 

  2269.         }
    2270. 

  2270. 

  2271.         if (!isset($pub_user_id) || !isset($pub_group_id)) {
    2272. 

  2272.             redirection("index.php?action=message&id_message=errorfatal&info");
    2273. 

  2273.         }
    2274. 

  2274. 

  2275.         //Vérification des droits
    2276. 

  2276.         user_check_auth("usergroup_manage");
    2277. 

  2277. 

  2278.         $request = "select group_id from " . TABLE_GROUP . " where group_id = " . intval($pub_group_id);
    2279. 

  2279.         $result = $db->sql_query($request);
    2280. 

  2280.         if ($db->sql_numrows($result) == 0) {
    2281. 

  2281.             redirection("index.php?action=administration&subaction=group");
    2282. 

  2282.         }
    2283. 

  2283. 

  2284.         $request = "select user_id from " . TABLE_USER . " where user_id = " . intval($pub_user_id);
    2285. 

  2285.         $result = $db->sql_query($request);
    2286. 

  2286.         if ($db->sql_numrows($result) == 0) {
    2287. 

  2287.             redirection("index.php?action=administration&subaction=group");
    2288. 

  2288.         }
    2289. 

  2289. 

  2290.         $request = "insert ignore into " . TABLE_USER_GROUP .
    2291. 

  2291.             " (group_id, user_id) values (" . intval($pub_group_id) . ", " . intval($pub_user_id) .
    2292. 

  2292.             ")";
    2293. 

  2293.         $result = $db->sql_query($request);
    2294. 

  2294. 

  2295.         if ($db->sql_affectedrows() > 0) {
    2296. 

  2296.             log_("add_usergroup", array($pub_group_id, $pub_user_id));
    2297. 

  2297.         }
    2298. 

  2298. 

  2299.         redirection("index.php?action=administration&subaction=group&group_id=" . $pub_group_id);
    2300. 

  2300.     }
    2301. 

  2301. }
    2302. 

  2302. 

  2303. /**
    2304. 

  2304.  * Supression d'un utilisateur d'un groupe
    2305. 

  2305.  * @global int $pub_user_id Identificateur utilisateur
    2306. 

  2306.  * @global int $pub_group_id Identificateur du Groupe
    2307. 

  2307.  */
    2308. 

  2308. function usergroup_delmember()
    2309. 

  2309. {
    2310. 

  2310.     global $db, $user_data;
    2311. 

  2311.     global $pub_user_id, $pub_group_id;
    2312. 

  2312. 

  2313.     if (!isset($pub_user_id) || !isset($pub_group_id)) {
    2314. 

  2314.         redirection("index.php?action=message&id_message=errorfatal&info");
    2315. 

  2315.     }
    2316. 

  2316.     if (!check_var($pub_user_id, "Num") || !check_var($pub_group_id, "Num")) {
    2317. 

  2317.         redirection("index.php?action=message&id_message=errordata&info");
    2318. 

  2318.     }
    2319. 

  2319. 

  2320.     //Vérification des droits
    2321. 

  2321.     user_check_auth("usergroup_manage");
    2322. 

  2322. 

  2323.     $request = "delete from " . TABLE_USER_GROUP . " where group_id = " . intval($pub_group_id) .
    2324. 

  2324.         " and user_id = " . intval($pub_user_id);
    2325. 

  2325.     $result = $db->sql_query($request);
    2326. 

  2326. 

  2327.     if ($db->sql_affectedrows() > 0) {
    2328. 

  2328.         log_("del_usergroup", array($pub_group_id, $pub_user_id));
    2329. 

  2329.     }
    2330. 

  2330. 

  2331.     redirection("index.php?action=administration&subaction=group&group_id=" . $pub_group_id);
    2332. 

  2332. }
    2333. 

  2333. 

  2334. /**
    2335. 

  2335.  * A quoi sert donc cette fonction ? :p
    2336. 

  2336.  * Reponse elle sert a mettre a jour le pseudo ingame afin d afficher les stats users dans son espace perso
    2337. 

  2337.  */
    2338. 

  2338. function user_set_stat_name($user_stat_name)
    2339. 

  2339. {
    2340. 

  2340.     global $db, $user_data;
    2341. 

  2341. 

  2342.     $request = "update " . TABLE_USER . " set user_stat_name = '" . $user_stat_name .
    2343. 

  2343.         "' where user_id = " . $user_data['user_id'];
    2344. 

  2344.     $db->sql_query($request);
    2345. 

  2345. }
    2346. 

  2346. 

  2347. //Suppression d'un rapport d'espionnage
    2348. 

  2348. function user_del_spy()
    2349. 

  2349. {
    2350. 

  2350.     global $db, $user_data;
    2351. 

  2351.     global $pub_spy_id, $pub_galaxy, $pub_system, $pub_row, $pub_info;
    2352. 

  2352. 

  2353.     if (!check_var($pub_spy_id, "Num")) {
    2354. 

  2354.         redirection("index.php?action=message&id_message=errordata&info");
    2355. 

  2355.     }
    2356. 

  2356. 

  2357.     if (!isset($pub_spy_id)) {
    2358. 

  2358.         redirection("index.php?action=message&id_message=errorfatal&info");
    2359. 

  2359.     }
    2360. 

  2360. 

  2361.     if ($user_data["user_admin"] == 1 || $user_data["user_coadmin"] == 1) {
    2362. 

  2362.         $request = "delete from " . TABLE_PARSEDSPY . " where id_spy = '" . $pub_spy_id .
    2363. 

  2363.             "'";
    2364. 

  2364.         $db->sql_query($request);
    2365. 

  2365.     }
    2366. 

  2366. 

  2367.     if (!isset($pub_info))
    2368. 

  2368.         $pub_info = 1;
    2369. 

  2369. 

  2370.     switch ($pub_info) {
    2371. 

  2371.         case 2:
    2372. 

  2372.             redirection("index.php?action=show_reportspy&galaxy=" . $pub_galaxy . "&system=" .
    2373. 

  2373.                 $pub_system . "&row=" . $pub_row);
    2374. 

  2374.         case 1:
    2375. 

  2375.             redirection("index.php?action=home&subaction=spy");
    2376. 

  2376.         default:
    2377. 

  2377.             return true;
    2378. 

  2378.     }
    2379. 

  2379. }
    2380. 

  2380. 

  2381. /**
    2382. 

  2382.  * Parsing des RC
    2383. 

  2383.  * @param string $rawRC RC à parser
    2384. 

  2384.  * @return int $return identifiant du RC
    2385. 

  2385.  */
    2386. 

  2386. function parseRC($rawRC)
    2387. 

  2387. {
    2388. 

  2388.     // Suppression des '\', et gestion des retours charriots/sauts de ligne
    2389. 

  2389.     $rawRC = str_replace('\\', '', ereg_replace("\n|\r|\r\n", " \n", $rawRC));
    2390. 

  2390.     // Suppression des '.' dans les nombres
    2391. 

  2391.     while (preg_match('/\d+\.\d+/', $rawRC))
    2392. 

  2392.         $rawRC = preg_replace('/(\d+)\.(\d+)/', "$1$2", $rawRC);
    2393. 

  2393.     $return = array('dateRC' => '', 'nb_rounds' => 0, 'attaquants' => array(),
    2394. 

  2394.         'defenseur' => array(), 'victoire' => 'A', 'pertes_A' => 0, 'pertes_D' => 0,
    2395. 

  2395.         'gain_M' => -1, 'gain_C' => -1, 'gain_D' => -1, 'debris_M' => -1, 'debris_C' =>
    2396. 

  2396.         -1, 'lune' => 0, 'coordinates' => '1:1:1');
    2397. 

  2397. 

  2398.     // Extraction du timestamp pour la date du RC
    2399. 

  2399.     preg_match('/affrontées le (\d*)-(\d*) (\d*):(\d*):(\d*) \.:/', $rawRC, $reg);
    2400. 

  2400.     $jourRC = trim($reg[2]);
    2401. 

  2401.     $moisRC = trim($reg[1]);
    2402. 

  2402.     $heureRC = trim($reg[3]);
    2403. 

  2403.     $minutesRC = trim($reg[4]);
    2404. 

  2404.     $secondesRC = trim($reg[5]);
    2405. 

  2405.     $return['dateRC'] = mktime($heureRC, $minutesRC, $secondesRC, $moisRC, $jourRC,
    2406. 

  2406.         date('Y'));
    2407. 

  2407. 

  2408.     // Extraction du nom, des coordonnées et des techs de l'attaquant et du défenseur
    2409. 

  2409.     $opponents = array();
    2410. 

  2410.     preg_match_all('/Attaquant (.*) \(\[(.*)\]\)(\s*)Armes: (\d*)% Bouclier: (\d*)% Coque: (\d*)%/',
    2411. 

  2411.         $rawRC, $reg);
    2412. 

  2412.     for ($idx = 0; $idx < sizeof($reg[0]); $idx++) {
    2413. 

  2413.         $return['attaquants'][] = array('pseudo' => $reg[1][$idx], 'coordinates' => $reg[2][$idx],
    2414. 

  2414.             'armes' => $reg[4][$idx], 'bouclier' => $reg[5][$idx], 'protection' => $reg[6][$idx]);
    2415. 

  2415.         $opponents[] = $reg[1][$idx];
    2416. 

  2416.     }
    2417. 

  2417.     preg_match_all('/D.fenseur (.*) \(\[(.*)\]\)(\s*)Armes: (\d*)% Bouclier: (\d*)% Coque: (\d*)%/',
    2418. 

  2418.         $rawRC, $reg);
    2419. 

  2419.     for ($idx = 0; $idx < sizeof($reg[0]); $idx++) {
    2420. 

  2420.         if ($idx == 0)
    2421. 

  2421.             $return['coordinates'] = $reg[2][$idx];
    2422. 

  2422.         $return['defenseurs'][] = array('pseudo' => $reg[1][$idx], 'coordinates' => $reg[2][$idx],
    2423. 

  2423.             'armes' => $reg[4][$idx], 'bouclier' => $reg[5][$idx], 'protection' => $reg[6][$idx]);
    2424. 

  2424.         $opponents[] = $reg[1][$idx];
    2425. 

  2425.     }
    2426. 

  2426. 

  2427.     // Comptage du nombre de roungs
    2428. 

  2428.     $return['nb_rounds'] = substr_count($rawRC, 'attaquante tire') + 1;
    2429. 

  2429. 

  2430.     // Extraction des pertes
    2431. 

  2431.     preg_match('/L\'attaquant a perdu au total (\d*) unit.s/', $rawRC, $reg);
    2432. 

  2432.     $return['pertes_A'] = trim($reg[1]);
    2433. 

  2433.     preg_match('/Le d.fenseur a perdu au total (\d*) unit.s/', $rawRC, $reg);
    2434. 

  2434.     $return['pertes_D'] = trim($reg[1]);
    2435. 

  2435. 

  2436.     // Extraction du champ de débris et du pourcentage de lune
    2437. 

  2437.     preg_match('/Un champ de d.bris contenant (\d*) unit.s de m.tal et (\d*) unit.s de cristal(.*)/',
    2438. 

  2438.         $rawRC, $reg);
    2439. 

  2439.     $return['debris_M'] = trim($reg[1]);
    2440. 

  2440.     $return['debris_C'] = trim($reg[2]);
    2441. 

  2441.     if (preg_match('/une lune est de (\d*)( ?)%/', $rawRC, $reg))
    2442. 

  2442.         $return['lune'] = trim($reg[1]);
    2443. 

  2443. 

  2444.     // Extraction du résultat du RC
    2445. 

  2445.     // A = victoire de l'attaquant
    2446. 

  2446.     // D = victoire du défenseur
    2447. 

  2447.     // N = match nul
    2448. 

  2448.     if (preg_match('/L\'attaquant a gagn. la bataille/', $rawRC)) {
    2449. 

  2449.         $return['victoire'] = 'A';
    2450. 

  2450.         // Extraction des ressources gagnées
    2451. 

  2451.         preg_match('/(\d*) unit.s de m.tal, (\d*) unit.s de cristal et (\d*) unit.s de deut.rium/',
    2452. 

  2452.             $rawRC, $reg);
    2453. 

  2453.         $return['gain_M'] = trim($reg[1]);
    2454. 

  2454.         $return['gain_C'] = trim($reg[2]);
    2455. 

  2455.         $return['gain_D'] = trim($reg[3]);
    2456. 

  2456.     } elseif (preg_match('/Le d.fenseur a gagn. la bataille/', $rawRC))
    2457. 

  2457.         $return['victoire'] = 'D';
    2458. 

  2458.     else
    2459. 

  2459.         $return['victoire'] = 'N';
    2460. 

  2460. 

  2461.     $tmp = parseRCround($rawRC, $return['nb_rounds'], $opponents, $return['victoire']);
    2462. 

  2462. 

  2463.     $idx = 1;
    2464. 

  2464.     foreach ($tmp as $array) {
    2465. 

  2465.         $return['round' . $idx] = $array;
    2466. 

  2466.         $idx++;
    2467. 

  2467.     }
    2468. 

  2468. 

  2469.     return $return;
    2470. 

  2470. }
    2471. 

  2471. 

  2472. /**
    2473. 

  2473.  * Parsing de chaque round des RC
    2474. 

  2474.  * @param string $rawRC RC à analyser
    2475. 

  2475.  * @param int $nb_rounds Nombre de round du RC à analyser
    2476. 

  2476.  * @param array $opponents Tableau contenant le nom de chaque joueur du RC
    2477. 

  2477.  * @return array $row_RC Tableau contenant pour chaque round du RC, les flottes/défenses de chaque joueur
    2478. 

  2478.  */
    2479. 

  2479. function parseRCround($rawRC, $nb_rounds, $opponents, $victoire)
    2480. 

  2480. {
    2481. 

  2481.     $rawRC = preg_replace("/ \n/", '|', $rawRC);
    2482. 

  2482.     $row_RC = array();
    2483. 

  2483.     $row_RC_opponent = array('P.transp.' => -1, 'G.transp.' => -1, 'Ch.léger' => -1,
    2484. 

  2484.         'Ch.lourd' => -1, 'Croiseur' => -1, 'V.bataille' => -1, 'V.colonisation' => -1,
    2485. 

  2485.         'Recycleur' => -1, 'Sonde' => -1, 'Bombardier' => -1, 'Destr.' => -1, 'Rip' => -
    2486. 

  2486.         1, 'Sat.sol.' => -1, 'Traqueur' => -1, 'Missile' => -1, 'L.léger.' => -1,
    2487. 

  2487.         'L.lourd' => -1, 'Can.Gauss' => -1, 'Art.ions' => -1, 'Lanc.plasma' => -1,
    2488. 

  2488.         'P.bouclier' => -1, 'G.bouclier' => -1, );
    2489. 

  2489. 

  2490.     $decoupe = explode('points de dégâts||', $rawRC);
    2491. 

  2491.     for ($idx_round = 0; $idx_round < $nb_rounds; $idx_round++) {
    2492. 

  2492.         $row_RC[$idx_round] = array();
    2493. 

  2493.         for ($idx_opp = 0; $idx_opp < sizeof($opponents); $idx_opp++) {
    2494. 

  2494.             $row_RC[$idx_round][$opponents[$idx_opp]] = $row_RC_opponent;
    2495. 

  2495.             $pattern = '/' . $opponents[$idx_opp] . ' \(\[.*?\]\)\|(Armes: \d*% Bouclier: \d*% Coque: \d*%\|)?Type[ \t](.*?)\|Nombre[ \t](.*?)\|/';
    2496. 

  2496.             preg_match($pattern, $decoupe[$idx_round], $reg);
    2497. 

  2497.             if (isset($reg[2])) {
    2498. 

  2498.                 $flotte = split("[ \t]", chop($reg[2]));
    2499. 

  2499.                 $nombre = split("[ \t]", chop($reg[3]));
    2500. 

  2500.                 foreach ($flotte as $key => $val)
    2501. 

  2501.                     $row_RC[$idx_round][$opponents[$idx_opp]][$val] = $nombre[$key];
    2502. 

  2502.             }
    2503. 

  2503.         }
    2504. 

  2504.         if ($idx_round < $nb_rounds) {
    2505. 

  2505.             preg_match('/La flotte attaquante tire (\d*) fois avec une puissance totale de (-?\d*) sur le d.fenseur. Les boucliers du d.fenseur absorbent (\d*) points de d.g.ts/',
    2506. 

  2506.                 $decoupe[$idx_round], $reg);
    2507. 

  2507.             if (isset($reg[1])) {
    2508. 

  2508.                 $row_RC[$idx_round]['attaque_tir'] = $reg[1];
    2509. 

  2509.                 $row_RC[$idx_round]['attaque_puissance'] = $reg[2];
    2510. 

  2510.                 $row_RC[$idx_round]['defense_bouclier'] = $reg[3];
    2511. 

  2511.             } else {
    2512. 

  2512.                 $row_RC[$idx_round]['attaque_tir'] = 0;
    2513. 

  2513.                 $row_RC[$idx_round]['attaque_puissance'] = 0;
    2514. 

  2514.                 $row_RC[$idx_round]['defense_bouclier'] = 0;
    2515. 

  2515.             }
    2516. 

  2516.             preg_match("/La flotte d.fensive tire au total (\d*) fois avec une puissance totale de (-?\d*) sur l'attaquant. Les boucliers de l'attaquant absorbent (\d*)/",
    2517. 

  2517.                 $decoupe[$idx_round], $reg);
    2518. 

  2518.             if (isset($reg[1])) {
    2519. 

  2519.                 $row_RC[$idx_round]['attaque_bouclier'] = $reg[3];
    2520. 

  2520.                 $row_RC[$idx_round]['defense_tir'] = $reg[1];
    2521. 

  2521.                 $row_RC[$idx_round]['defense_puissance'] = $reg[2];
    2522. 

  2522.             } else {
    2523. 

  2523.                 $row_RC[$idx_round]['attaque_bouclier'] = 0;
    2524. 

  2524.                 $row_RC[$idx_round]['defense_tir'] = 0;
    2525. 

  2525.                 $row_RC[$idx_round]['defense_puissance'] = 0;
    2526. 

  2526.             }
    2527. 

  2527.         }
    2528. 

  2528.     }
    2529. 

  2529. 

  2530.     return ($row_RC);
    2531. 

  2531. }
    2532. 

  2532. 

  2533. /**
    2534. 

  2534.  * Reconstruction des RC
    2535. 

  2535.  * @global $db
    2536. 

  2536.  * @param int $id_RC RC à reconstituer
    2537. 

  2537.  * @return string $template_RC reconstitué
    2538. 

  2538.  */
    2539. 

  2539. function UNparseRC($id_RC)
    2540. 

  2540. {
    2541. 

  2541.     global $db;
    2542. 

  2542. 

  2543.     $key_ships = array('PT' => 'P.transp.', 'GT' => 'G.transp.', 'CLE' => 'Ch.léger',
    2544. 

  2544.         'CLO' => 'Ch.lourd', 'CR' => 'Croiseur', 'VB' => 'V.bataille', 'VC' =>
    2545. 

  2545.         'V.colonisation', 'REC' => 'Recycleur', 'SE' => 'Sonde', 'BMD' => 'Bombardier',
    2546. 

  2546.         'DST' => 'Destr.', 'EDLM' => 'Rip', 'SAT' => 'Sat.sol.', 'TRA' => 'Traqueur');
    2547. 

  2547.     $key_defs = array('LM' => 'Missile', 'LLE' => 'L.léger.', 'LLO' => 'L.lourd',
    2548. 

  2548.         'CG' => 'Can.Gauss', 'AI' => 'Art.ions', 'LP' => 'Lanc.plasma', 'PB' =>
    2549. 

  2549.         'P.bouclier', 'GB' => 'G.bouclier');
    2550. 

  2550.     $base_ships = array('PT' => array(4000, 10, 5), 'GT' => array(12000, 25, 5),
    2551. 

  2551.         'CLE' => array(4000, 10, 50), 'CLO' => array(10000, 25, 150), 'CR' => array(27000,
    2552. 

  2552.         50, 400), 'VB' => array(60000, 200, 1000), 'VC' => array(30000, 100, 50), 'REC' =>
    2553. 

  2553.         array(16000, 10, 1), 'SE' => array(1000, 0, 0), 'BMD' => array(75000, 500, 1000),
    2554. 

  2554.         'DST' => array(110000, 500, 2000), 'EDLM' => array(9000000, 50000, 200000),
    2555. 

  2555.         'SAT' => array(2000, 1, 1), 'TRA' => array(70000, 400, 700));
    2556. 

  2556.     $base_defs = array('LM' => array(2000, 20, 80), 'LLE' => array(2000, 25, 100),
    2557. 

  2557.         'LLO' => array(8000, 100, 250), 'CG' => array(35000, 200, 1100), 'AI' => array(8000,
    2558. 

  2558.         500, 150), 'LP' => array(100000, 300, 3000), 'PB' => array(20000, 2000, 1), 'GB' =>
    2559. 

  2559.         array(100000, 10000, 1));
    2560. 

  2560. 

  2561.     // Récupération des constantes du RC
    2562. 

  2562.     $query = 'SELECT dateRC, coordinates, nb_rounds, victoire, pertes_A, pertes_D, gain_M, gain_C, 
    2563. 

  2563.     gain_D, debris_M, debris_C, lune FROM ' . TABLE_PARSEDRC . ' WHERE id_rc = ' .
    2564. 

  2564.         $id_RC;
    2565. 

  2565.     $result = $db->sql_query($query);
    2566. 

  2566.     list($dateRC, $coordinates, $nb_rounds, $victoire, $pertes_A, $pertes_D, $gain_M,
    2567. 

  2567.         $gain_C, $gain_D, $debris_M, $debris_C, $lune) = $db->sql_fetch_row($result);
    2568. 

  2568.     $dateRC = date('d.m.Y H:i:s', $dateRC);
    2569. 

  2569.     $template = 'Les flottes suivantes s\'affrontent (' . $dateRC . "):\n\n";
    2570. 

  2570. 

  2571.     // Récupération de chaque round du RC
    2572. 

  2572.     for ($idx = 1; $idx <= $nb_rounds; $idx++) {
    2573. 

  2573.         $query = 'SELECT id_rcround, attaque_tir, attaque_puissance, attaque_bouclier, defense_tir, 
    2574. 

  2574.       defense_puissance, defense_bouclier FROM ' . TABLE_PARSEDRCROUND .
    2575. 

  2575.             ' WHERE id_rc = ' . $id_RC . '
    2576. 

  2576.      AND numround = ' . $idx;
    2577. 

  2577.         $result_round = $db->sql_query($query);
    2578. 

  2578.         list($id_rcround, $attaque_tir, $attaque_puissance, $attaque_bouclier, $defense_tir,
    2579. 

  2579.             $defense_puissance, $defense_bouclier) = $db->sql_fetch_row($result_round);
    2580. 

  2580. 		// On formate les résultats
    2581. 

  2581. 		$nf_gain_M = number_format($gain_M,0,',','.');
    2582. 

  2582. 		$nf_gain_C = number_format($gain_C,0,',','.');
    2583. 

  2583. 		$nf_gain_D = number_format($gain_D,0,',','.');
    2584. 

  2584. 		$nf_pertes_A = number_format($pertes_A,0,',','.');
    2585. 

  2585. 		$nf_pertes_D = number_format($pertes_D,0,',','.');
    2586. 

  2586. 		$nf_debris_M = number_format($debris_M,0,',','.');
    2587. 

  2587. 		$nf_debris_C = number_format($debris_C,0,',','.');
    2588. 

  2588. 		$nf_attaque_tir = number_format($attaque_tir,0,',','.');
    2589. 

  2589. 		$nf_attaque_puissance = number_format($attaque_puissance,0,',','.');
    2590. 

  2590. 		$nf_attaque_bouclier = number_format($attaque_bouclier,0,',','.');
    2591. 

  2591. 		$nf_defense_tir = number_format($defense_tir,0,',','.');
    2592. 

  2592. 		$nf_defense_puissance = number_format($defense_puissance,0,',','.');
    2593. 

  2593. 		$nf_defense_bouclier = number_format($defense_bouclier,0,',','.');
    2594. 

  2594. 	
    2595. 

  2595.         // Récupération de chaque attaquant du RC
    2596. 

  2596.         $query = 'SELECT player, coordinates, Armes, Bouclier, Protection, PT, GT, CLE, CLO, CR, VB, VC, REC, 
    2597. 

  2597.       SE, BMD, DST, EDLM, TRA FROM ' . TABLE_ROUND_ATTACK .
    2598. 

  2598.             ' WHERE id_rcround = ' . $id_rcround;
    2599. 

  2599.         $result_attack = $db->sql_query($query);
    2600. 

  2600.         while (list($player, $coordinates, $Armes, $Bouclier, $Protection, $PT, $GT, $CLE,
    2601. 

  2601.             $CLO, $CR, $VB, $VC, $REC, $SE, $BMD, $DST, $EDLM, $TRA) = $db->sql_fetch_row($result_attack)) {
    2602. 

  2602.             $key = '';
    2603. 

  2603.             $ship = 0;
    2604. 

  2604.             $vivant_att = false;
    2605. 

  2605.             $template .= 'Attaquant ' . $player;
    2606. 

  2606.             $ship_type = 'Type';
    2607. 

  2607.             $ship_nombre = 'Nombre';
    2608. 

  2608.             $ship_armes = 'Armes';
    2609. 

  2609.             $ship_bouclier = 'Bouclier';
    2610. 

  2610.             $ship_protection = 'Coque';
    2611. 

  2611.             foreach ($key_ships as $key => $ship) {
    2612. 

  2612.                 if (isset($$key) && $$key > 0) {
    2613. 

  2613.                     $vivant_att = true;
    2614. 

  2614.                     $ship_type .= "\t" . $ship;
    2615. 

  2615.                     $ship_nombre .= "\t" . number_format($$key,0,',','.');;
    2616. 

  2616.                     $ship_protection .= "\t" . number_format(round(($base_ships[$key][0] * (($Protection / 10) * 0.1 + 1)) / 10),0,',','.');
    2617. 

  2617.                     $ship_bouclier .= "\t" . number_format(round($base_ships[$key][1] * (($Bouclier / 10) * 0.1 + 1)),0,',','.');
    2618. 

  2618.                     $ship_armes .= "\t" . number_format(round($base_ships[$key][2] * (($Armes / 10) * 0.1 + 1)),0,',','.');
    2619. 

  2619.                 }
    2620. 

  2620.             }
    2621. 

  2621.             if ($vivant_att == true) {
    2622. 

  2622. 				$template .= ' [' . $coordinates . ']';
    2623. 

  2623. 				if($idx==1)
    2624. 

  2624. 					$template .= ' Armes: ' . $Armes . '% Bouclier: ' . $Bouclier . '% Coques: ' . $Protection . '%';
    2625. 

  2625. 				$template .="\n";
    2626. 

  2626. 				$template .= $ship_type . "\n" . $ship_nombre . "\n" . $ship_armes . "\n" . $ship_bouclier . "\n" . $ship_protection . "\n\n";
    2627. 

  2627. 			}
    2628. 

  2628.             else
    2629. 

  2629.                 $template .= ' détruit.' . "\n\n";
    2630. 

  2630.         } // Fin récupération de chaque attaquant du RC
    2631. 

  2631. 

  2632.         // Récupération de chaque défenseur du RC
    2633. 

  2633.         $query = 'SELECT player, coordinates, Armes, Bouclier, Protection, PT, GT, CLE, CLO, CR, VB, VC, REC, 
    2634. 

  2634.       SE, BMD, SAT, DST, EDLM, TRA, LM, LLE, LLO, CG, AI, LP, PB, GB FROM ' .
    2635. 

  2635.             TABLE_ROUND_DEFENSE . ' WHERE 
    2636. 

  2636.       id_rcround = ' . $id_rcround;
    2637. 

  2637.         $result_defense = $db->sql_query($query);
    2638. 

  2638.         while (list($player, $coordinates, $Armes, $Bouclier, $Protection, $PT, $GT, $CLE,
    2639. 

  2639.             $CLO, $CR, $VB, $VC, $REC, $SE, $BMD, $SAT, $DST, $EDLM, $TRA, $LM, $LLE, $LLO, $CG, $AI,
    2640. 

  2640.             $LP, $PB, $GB) = $db->sql_fetch_row($result_defense)) {
    2641. 

  2641.             $key = '';
    2642. 

  2642.             $ship = 0;
    2643. 

  2643.             $vivant_def = false;
    2644. 

  2644.             $template .= 'Défenseur ' . $player;
    2645. 

  2645.             $ship_type = 'Type';
    2646. 

  2646.             $ship_nombre = 'Nombre';
    2647. 

  2647.             $ship_armes = 'Armes';
    2648. 

  2648.             $ship_bouclier = 'Bouclier';
    2649. 

  2649.             $ship_protection = 'Coque';
    2650. 

  2650.             foreach ($key_ships as $key => $ship) {
    2651. 

  2651.                 if (isset($$key) && $$key > 0) {
    2652. 

  2652.                     $vivant_def = true;
    2653. 

  2653.                     $ship_type .= "\t" . $ship;
    2654. 

  2654.                     $ship_nombre .= "\t" . number_format($$key,0,',','.');
    2655. 

  2655.                     $ship_protection .= "\t" . number_format(round(($base_ships[$key][0] * (($Protection / 10) * 0.1 + 1)) / 10),0,',','.');
    2656. 

  2656.                     $ship_bouclier .= "\t" . number_format(round($base_ships[$key][1] * (($Bouclier / 10) * 0.1 + 1)),0,',','.');
    2657. 

  2657.                     $ship_armes .= "\t" . number_format(round($base_ships[$key][2] * (($Armes / 10) * 0.1 + 1)),0,',','.');
    2658. 

  2658.                 }
    2659. 

  2659.             }
    2660. 

  2660.             foreach ($key_defs as $key => $def) {
    2661. 

  2661.                 if (isset($$key) && $$key > 0) {
    2662. 

  2662.                     $vivant_def = true;
    2663. 

  2663.                     $ship_type .= "\t" . $def;
    2664. 

  2664.                     $ship_nombre .= "\t" . number_format($$key,0,',','.');
    2665. 

  2665.                     $ship_protection .= "\t" . number_format(round(($base_defs[$key][0] * (($Protection / 10) * 0.1 + 1)) / 10),0,',','.');
    2666. 

  2666.                     $ship_bouclier .= "\t" . number_format(round($base_defs[$key][1] * (($Bouclier / 10) * 0.1 + 1)),0,',','.');
    2667. 

  2667.                     $ship_armes .= "\t" . number_format(round($base_defs[$key][2] * (($Armes / 10) * 0.1 + 1)),0,',','.');
    2668. 

  2668.                 }
    2669. 

  2669.             }
    2670. 

  2670.             if ($vivant_def == true) {
    2671. 

  2671.                 $template .= ' [' . $coordinates . ']';
    2672. 

  2672. 				if($idx==1)
    2673. 

  2673. 					$template .= ' Armes: ' . $Armes . '% Bouclier: ' . $Bouclier . '% Coques: ' . $Protection . '%';
    2674. 

  2674. 				$template .="\n";
    2675. 

  2675. 				$template .= $ship_type . "\n" . $ship_nombre . "\n" . $ship_armes . "\n" . $ship_bouclier . "\n" . $ship_protection . "\n\n";
    2676. 

  2676. 			}
    2677. 

  2677.             else
    2678. 

  2678.                 $template .= ' détruit.' . "\n\n";
    2679. 

  2679.         } // Fin récupération de chaque défenseur du RC
    2680. 

  2680. 

  2681.         // Résultat du round
    2682. 

  2682.         if ($attaque_tir != 0 || $defense_tir != 0) {
    2683. 

  2683.             $template .= 'La flotte attaquante tire ' . $nf_attaque_tir .
    2684. 

  2684.                 ' fois avec une force totale de ' . $nf_attaque_puissance .
    2685. 

  2685.                 ' sur le défenseur. Les boucliers du défenseur absorbent ' . $nf_defense_bouclier .
    2686. 

  2686.                 ' points de dommage.' . "\n\n";
    2687. 

  2687.             $template .= 'La flotte de défense tire ' . $nf_defense_tir .
    2688. 

  2688.                 ' fois sur l\'attaquant avec une force de ' . $nf_defense_puissance . '. Les boucliers de l\'attaquant absorbent ' .
    2689. 

  2689.                 $nf_attaque_bouclier . ' points de dommage.' . "\n\n";
    2690. 

  2690.         }
    2691. 

  2691.     } // Fin récupération de chaque round du RC
    2692. 

  2692. 

  2693.     // Qui a remporté le combat ?
    2694. 

  2694. 	    switch ($victoire) {
    2695. 

  2695.         case 'N':
    2696. 

  2696.             $template .= 'La bataille se termine par un match nul, les deux flottes rentrent vers leurs planètes respectives.' .
    2697. 

  2697.                 "\n\n";
    2698. 

  2698.             break;
    2699. 

  2699.         case 'A':
    2700. 

  2700.             $template .= 'L\'attaquant a gagné la bataille ! Il emporte ' .
    2701. 

  2701.                 $nf_gain_M . ' unités de métal, ' . $nf_gain_C . ' unités de cristal et ' . $nf_gain_D .
    2702. 

  2702.                 ' unités de deutérium.' . "\n\n";
    2703. 

  2703.             break;
    2704. 

  2704.         case 'D':
    2705. 

  2705.             $template .= 'Le défenseur a gagné la bataille !' . "\n\n";
    2706. 

  2706.             break;
    2707. 

  2707.     }
    2708. 

  2708. 

  2709.     // Pertes et champs de débris
    2710. 

  2710.     $template .= 'L\'attaquant a perdu au total ' . $nf_pertes_A . ' unités.' . "\n";
    2711. 

  2711.     $template .= 'Le défenseur a perdu au total ' . $nf_pertes_D . ' unités.' . "\n";
    2712. 

  2712.     $template .= 'Un champ de débris contenant ' . $nf_debris_M .
    2713. 

  2713.         ' de métal et ' . $nf_debris_C . ' de cristal se forme dans l\'orbite de la planète.' .
    2714. 

  2714.         "\n";
    2715. 

  2715. 	
    2716. 

  2716. 	$lunePourcent = floor(($debris_M + $debris_C) / 100000);
    2717. 

  2717. 	$lunePourcent = ($lunePourcent<0 ? 0 : ($lunePourcent>20 ? 20 : $lunePourcent));
    2718. 

  2718. 	if ($lunePourcent>0)
    2719. 

  2719. 		$template .= 'La probabilité de création d\'une lune est de ' . $lunePourcent . ' %';
    2720. 

  2720. 		
    2721. 

  2721. 	if($lune==1)
    2722. 

  2722. 		$template .= "\nLes quantités énormes de métal et de cristal s'attirent, formant ainsi une lune dans l'orbite de cette planète.";
    2723. 

  2723. 

  2724.     return ($template);
    2725. 

  2725. }
    2726. 

  2726. 

  2727. /**
    2728. 

  2728.  * Enregistrement des RC
    2729. 

  2729.  * @global $db
    2730. 

  2730.  * @param string $rawRC RC brut à analyser
    2731. 

  2731.  */
    2732. 

  2732. function insert_RC($rawRC)
    2733. 

  2733. {
    2734. 

  2734.     global $db;
    2735. 

  2735.     $parsedRC = parseRC($rawRC);
    2736. 

  2736.     $query = 'INSERT IGNORE INTO ' . TABLE_PARSEDRC .
    2737. 

  2737.         '(dateRC, nb_rounds, victoire, pertes_A, pertes_D, 
    2738. 

  2738.     gain_M, gain_C, gain_D, debris_M, debris_C, lune, coordinates) VALUES (' . $parsedRC['dateRC'] .
    2739. 

  2739.         ',' . $parsedRC['nb_rounds'] . ',"' . $parsedRC['victoire'] . '",' . $parsedRC['pertes_A'] .
    2740. 

  2740.         ',' . $parsedRC['pertes_D'] . ',' . $parsedRC['gain_M'] . ',' . $parsedRC['gain_C'] .
    2741. 

  2741.         ',' . $parsedRC['gain_D'] . ',' . $parsedRC['debris_M'] . ',' . $parsedRC['debris_C'] .
    2742. 

  2742.         ',' . $parsedRC['lune'] . ',"' . $parsedRC['coordinates'] . '")';
    2743. 

  2743.     if (!$db->sql_query($query)) {
    2744. 

  2744.         $error = $db->sql_error();
    2745. 

  2745.     }
    2746. 

  2746.     $id_RC = $db->sql_insertid();
    2747. 

  2747.     for ($idx_round = 1; $idx_round <= $parsedRC['nb_rounds']; $idx_round++) {
    2748. 

  2748.         $round = 'round' . $idx_round;
    2749. 

  2749.         log_('mod', ' enregistre le round ' . $idx_round);
    2750. 

  2750.         $query = 'INSERT IGNORE INTO ' . TABLE_PARSEDRCROUND .
    2751. 

  2751.             '(id_rc, numround, attaque_tir, attaque_puissance, 
    2752. 

  2752.       attaque_bouclier, defense_tir, defense_puissance, defense_bouclier) VALUES(' .
    2753. 

  2753.             $id_RC . ', ' . $idx_round . ', "' . $parsedRC[$round]['attaque_tir'] . '", "' .
    2754. 

  2754.             $parsedRC[$round]['attaque_puissance'] . '", "' . $parsedRC[$round]['attaque_bouclier'] .
    2755. 

  2755.             '", "' . $parsedRC[$round]['defense_tir'] . '", "' . $parsedRC[$round]['defense_puissance'] .
    2756. 

  2756.             '", "' . $parsedRC[$round]['defense_bouclier'] . '")';
    2757. 

  2757.         if (!$db->sql_query($query)) {
    2758. 

  2758.             $error = $db->sql_error();
    2759. 

  2759.         }
    2760. 

  2760.         $id_parsedround = $db->sql_insertid();
    2761. 

  2761.         foreach ($parsedRC['attaquants'] as $opponent => $row) {
    2762. 

  2762.             $pseudo = $row['pseudo'];
    2763. 

  2763.             $query = 'INSERT IGNORE INTO ' . TABLE_ROUND_ATTACK .
    2764. 

  2764.                 '(id_rcround, player, coordinates, Armes, 
    2765. 

  2765.         Bouclier, Protection, PT, GT, CLE, CLO, CR, VB, VC, REC, SE, BMD, DST, EDLM, TRA) VALUES (' .
    2766. 

  2766.                 $id_parsedround . ', "' . $row['pseudo'] . '", "' . $row['coordinates'] . '", ' .
    2767. 

  2767.                 $row['armes'] . ', ' . $row['bouclier'] . ', ' . $row['protection'] . ', "' . $parsedRC[$round][$pseudo]['P.transp.'] .
    2768. 

  2768.                 '", "' . $parsedRC[$round][$pseudo]['G.transp.'] . '", "' . $parsedRC[$round][$pseudo]['Ch.léger'] .
    2769. 

  2769.                 '", "' . $parsedRC[$round][$pseudo]['Ch.lourd'] . '", "' . $parsedRC[$round][$pseudo]['Croiseur'] .
    2770. 

  2770.                 '", "' . $parsedRC[$round][$pseudo]['V.bataille'] . '", "' . $parsedRC[$round][$pseudo]['V.colonisation'] .
    2771. 

  2771.                 '", "' . $parsedRC[$round][$pseudo]['Recycleur'] . '", "' . $parsedRC[$round][$pseudo]['Sonde'] .
    2772. 

  2772.                 '", "' . $parsedRC[$round][$pseudo]['Bombardier'] . '", "' . $parsedRC[$round][$pseudo]['Destr.'] .
    2773. 

  2773.                 '", "' . $parsedRC[$round][$pseudo]['Rip'] . '", "' . $parsedRC[$round][$pseudo]['Traqueur'] .
    2774. 

  2774.                 '")';
    2775. 

  2775.             if (!$db->sql_query($query)) {
    2776. 

  2776.                 $error = $db->sql_error();
    2777. 

  2777.             }
    2778. 

  2778.         }
    2779. 

  2779.         foreach ($parsedRC['defenseurs'] as $opponent => $row) {
    2780. 

  2780.             $pseudo = $row['pseudo'];
    2781. 

  2781.             $query = 'INSERT IGNORE INTO ' . TABLE_ROUND_DEFENSE .
    2782. 

  2782.                 '(id_rcround, player, coordinates, Armes, 
    2783. 

  2783.         Bouclier, Protection, PT, GT, CLE, CLO, CR, VB, VC, REC, SE, BMD, DST, EDLM, SAT, TRA, LM, LLE, LLO, 
    2784. 

  2784.         CG, AI, LP, PB, GB) VALUES (' . $id_parsedround . ', "' . $row['pseudo'] .
    2785. 

  2785.                 '", "' . $row['coordinates'] . '", ' . $row['armes'] . ', ' . $row['bouclier'] .
    2786. 

  2786.                 ', ' . $row['protection'] . ', "' . $parsedRC[$round][$pseudo]['P.transp.'] .
    2787. 

  2787.                 '", "' . $parsedRC[$round][$pseudo]['G.transp.'] . '", "' . $parsedRC[$round][$pseudo]['Ch.léger'] .
    2788. 

  2788.                 '", "' . $parsedRC[$round][$pseudo]['Ch.lourd'] . '", "' . $parsedRC[$round][$pseudo]['Croiseur'] .
    2789. 

  2789.                 '", "' . $parsedRC[$round][$pseudo]['V.bataille'] . '", "' . $parsedRC[$round][$pseudo]['V.colonisation'] .
    2790. 

  2790.                 '", "' . $parsedRC[$round][$pseudo]['Recycleur'] . '", "' . $parsedRC[$round][$pseudo]['Sonde'] .
    2791. 

  2791.                 '", "' . $parsedRC[$round][$pseudo]['Bombardier'] . '", "' . $parsedRC[$round][$pseudo]['Destr.'] .
    2792. 

  2792.                 '", "' . $parsedRC[$round][$pseudo]['Rip'] . '", "' . $parsedRC[$round][$pseudo]['Sat.sol.'] .
    2793. 

  2793.                 '", "' . $parsedRC[$round][$pseudo]['Traqueur'] . '", "' . $parsedRC[$round][$pseudo]['Missile'] .
    2794. 

  2794.                 '", "' . $parsedRC[$round][$pseudo]['L.léger.'] . '", "' . $parsedRC[$round][$pseudo]['L.lourd'] .
    2795. 

  2795.                 '", "' . $parsedRC[$round][$pseudo]['Can.Gauss'] . '", "' . $parsedRC[$round][$pseudo]['Art.ions'] .
    2796. 

  2796.                 '", "' . $parsedRC[$round][$pseudo]['Lanc.plasma'] . '", "' . $parsedRC[$round][$pseudo]['P.bouclier'] .
    2797. 

  2797.                 '", "' . $parsedRC[$round][$pseudo]['G.bouclier'] . '")';
    2798. 

  2798.             if (!$db->sql_query($query)) {
    2799. 

  2799.                 $error = $db->sql_error();
    2800. 

  2800.             }
    2801. 

  2801.         }
    2802. 

  2802.     }
    2803. 

  2803.     redirection('index.php');
    2804. 

  2804. }
    2805. 

  2805. 

  2806. /**
    2807. 

  2807.  * Fonction de calcul du ratio
    2808. 

  2808.  * @param int $player user_id ID du joueur
    2809. 

  2809.  * @return array ratio et divers calculs intermédiaires pour l'utilisateur en question
    2810. 

  2810.  * @author Bousteur 25/11/2006
    2811. 

  2811.  */
    2812. 

  2812. function ratio_calc($player)
    2813. 

  2813. {
    2814. 

  2814.     global $db, $user_data;
    2815. 

  2815. 

  2816.     //récupération des données nécessaires
    2817. 

  2817.     $sqlrecup = "SELECT planet_added_web, planet_added_ogs, planet_exported, search, spy_added_web, spy_added_ogs, spy_exported, rank_added_web, rank_added_ogs, rank_exported FROM " .
    2818. 

  2818.         TABLE_USER . " WHERE user_id='" . $player . "'";
    2819. 

  2819.     $result = $db->sql_query($sqlrecup);
    2820. 

  2820.     list($planet_added_web, $planet_added_ogs, $planet_exported, $search, $spy_added_web,
    2821. 

  2821.         $spy_added_ogs, $spy_exported, $rank_added_web, $rank_added_ogs, $rank_exported) =
    2822. 

  2822.         $db->sql_fetch_row($result);
    2823. 

  2823.     $request = "select sum(planet_added_web + planet_added_ogs), ";
    2824. 

  2824.     $request .= "sum(spy_added_web + spy_added_ogs), ";
    2825. 

  2825.     $request .= "sum(rank_added_web + rank_added_ogs), ";
    2826. 

  2826.     $request .= "sum(search) ";
    2827. 

  2827.     $request .= "from " . TABLE_USER;
    2828. 

  2828.     $resultat = $db->sql_query($request);
    2829. 

  2829.     list($planetimporttotal, $spyimporttotal, $rankimporttotal, $searchtotal) = $db->
    2830. 

  2830.         sql_fetch_row($resultat);
    2831. 

  2831.     $query = "SELECT COUNT(user_id) as count FROM " . TABLE_USER;
    2832. 

  2832.     $result = $db->sql_query($query);
    2833. 

  2833.     if ($db->sql_numrows($result) > 0) {
    2834. 

  2834.         $row = $db->sql_fetch_assoc($result);
    2835. 

  2835.         $max = $row['count'];
    2836. 

  2836.     }
    2837. 

  2837.     //pour éviter la division par zéro
    2838. 

  2838.     if ($planetimporttotal == 0)
    2839. 

  2839.         $planetimporttotal = 1;
    2840. 

  2840.     if ($spyimporttotal == 0)
    2841. 

  2841.         $spyimporttotal = 1;
    2842. 

  2842.     if ($rankimporttotal == 0)
    2843. 

  2843.         $rankimporttotal = 1;
    2844. 

  2844.     if ($searchtotal == 0)
    2845. 

  2845.         $searchtotal = 1;
    2846. 

  2846. 

  2847.     //et on commence le calcul
    2848. 

  2848.     $ratio_planet = ($planet_added_web + $planet_added_ogs) / $planetimporttotal;
    2849. 

  2849.     $ratio_spy = ($spy_added_web + $spy_added_ogs) / $spyimporttotal;
    2850. 

  2850.     $ratio_rank = ($rank_added_web + $rank_added_ogs) / $rankimporttotal;
    2851. 

  2851.     $ratio = ($ratio_planet * 4 + $ratio_spy * 2 + $ratio_rank) / (4 + 2 + 1);
    2852. 

  2852. 

  2853.     $ratio_planet_penality = ($planet_added_web + $planet_added_ogs - $planet_exported) /
    2854. 

  2854.         $planetimporttotal;
    2855. 

  2855.     $ratio_spy_penality = (($spy_added_web + $spy_added_ogs) - $spy_exported) / $spyimporttotal;
    2856. 

  2856.     $ratio_rank_penality = (($rank_added_web + $rank_added_ogs) - $rank_exported) /
    2857. 

  2857.         $rankimporttotal;
    2858. 

  2858.     $ratio_penality = ($ratio_planet_penality * 4 + $ratio_spy_penality * 2 + $ratio_rank_penality) / (4 +
    2859. 

  2859.         2 + 1);
    2860. 

  2860. 

  2861.     $ratio_search = $search / $searchtotal;
    2862. 

  2862.     $ratio_searchpenality = ($ratio - $ratio_search);
    2863. 

  2863. 

  2864.     $result = ($ratio + $ratio_penality + $ratio_searchpenality) * 1000;
    2865. 

  2865.     $array = array($result, $ratio_searchpenality, $ratio_search, $ratio_penality, $ratio_rank_penality,
    2866. 

  2866.         $ratio_spy_penality, $ratio_planet_penality);
    2867. 

  2867. 

  2868.     //retourne le ratio et calculs intermédiaires
    2869. 

  2869.     return $array;
    2870. 

  2870. }
    2871. 

  2871. 

  2872. /**
    2873. 

  2873.  * Fonction de test d'autorisation d'effectuer une action en fonction du ratio ou de l'appartenance à un groupe qui a un ratio illimité
    2874. 

  2874.  * @return bool vrai si l'utilisateur peut faire des recherches
    2875. 

  2875.  * @author Bousteur 28/11/2006
    2876. 

  2876.  */
    2877. 

  2877. function ratio_is_ok()
    2878. 

  2878. {
    2879. 

  2879.     global $user_data, $server_config;
    2880. 

  2880.     static $result;
    2881. 

  2881. 

  2882.     if ($result != null)
    2883. 

  2883.         return $result;
    2884. 

  2884.     if (isset($server_config["block_ratio"]) && $server_config["block_ratio"] == 1) {
    2885. 

  2885.         if ($user_data["user_admin"] == 1 || $user_data["user_coadmin"] == 1 || $user_data["management_user"] ==
    2886. 

  2886.             1) {
    2887. 

  2887.             return true;
    2888. 

  2888.         } else {
    2889. 

  2889.             $result = ratio_calc($user_data['user_id']);
    2890. 

  2890.             $result = $result[0] >= $server_config["ratio_limit"];
    2891. 

  2891.             return $result;
    2892. 

  2892.         }
    2893. 

  2893.     } else {
    2894. 

  2894.         return true;
    2895. 

  2895.     }
    2896. 

  2896. }
    2897. 

  2897. ?>
    2898.