PageRenderTime 66ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 1ms

/includes/user.php

https://bitbucket.org/capi/ogspy
PHP | 2815 lines | 2250 code | 310 blank | 255 comment | 462 complexity | 717bcadf4e5f013a917a6ef8c6a57013 MD5 | raw file
    

  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-08-29 00:22:35 +0200 (Wed, 29 Aug 2012) $
    9. 

  9.  * @author Kyser
    10. 

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

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

  12.  * $Id: user.php 7700 2012-08-28 22:22:35Z 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, $user_auth;
    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_login, $pub_password, $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 $user_data;
    230. 

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

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

  232.     global $$pass_id;
    233. 

  233.     $new_pass = $$pass_id;
    234. 

  234. 

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

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

  237.     }
    238. 

  238. 

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

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

  241.     }
    242. 

  242. 

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

  244. 

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

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

  247.     }
    248. 

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

  249.         $password = $new_pass;
    250. 

  250.     } else {
    251. 

  251.         $password = password_generator();
    252. 

  252.     }
    253. 

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

  254. 

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

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

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

  258.         $info);
    259. 

  259. }
    260. 

  260. 

  261. /**
    262. 

  262.  * Modification du profil par un utilisateur
    263. 

  263.  * @todo Query : x11
    264. 

  264.  */
    265. 

  265. function member_user_set()
    266. 

  266. {
    267. 

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

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

  269.         $pub_system, $pub_skin, $pub_disable_ip_check, $pub_off_amiral, $pub_off_ingenieur,
    270. 

  270.         $pub_off_geologue, $pub_off_technocrate, $pub_pseudo_ingame;
    271. 

  271. 

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

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

  274.         "CharNum") || !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_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. 

  315.     //compte amiral
    316. 

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

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

  318.             " SET `off_amiral` = '1' WHERE `user_id` = " . $user_id);
    319. 

  319.     }
    320. 

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

  321.         1)) {
    322. 

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

  323.             " SET `off_amiral` = '0' WHERE `user_id` = " . $user_id);
    324. 

  324.     }
    325. 

  325. 

  326.     //compte ingenieur
    327. 

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

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

  329.             " SET `off_ingenieur` = '1' WHERE `user_id` = " . $user_id);
    330. 

  330.     }
    331. 

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

  332.         1)) {
    333. 

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

  334.             " SET `off_ingenieur` = '0' WHERE `user_id` = " . $user_id);
    335. 

  335.     }
    336. 

  336. 

  337.     //compte geologue
    338. 

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

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

  340.             " SET `off_geologue` = '1' WHERE `user_id` = " . $user_id);
    341. 

  341.     }
    342. 

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

  343.         1)) {
    344. 

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

  345.             " SET `off_geologue` = '0' WHERE `user_id` = " . $user_id);
    346. 

  346.     }
    347. 

  347. 

  348.     //compte technocrate
    349. 

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

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

  351.             " SET `off_technocrate` = '1' WHERE `user_id` = " . $user_id);
    352. 

  352.         $tech = $user_technology['Esp'] + 2;
    353. 

  353.         $db->sql_query("UPDATE " . TABLE_USER_TECHNOLOGY . " SET `Esp` = " . $tech .
    354. 

  354.             " WHERE `user_id` = " . $user_id);
    355. 

  355.     }
    356. 

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

  357.         1)) {
    358. 

  358.         $db->sql_query("UPDATE " . TABLE_USER .
    359. 

  359.             " SET `off_technocrate` = '0' WHERE `user_id` = " . $user_id);
    360. 

  360.         $tech = $user_technology['Esp'] - 2;
    361. 

  361.         $db->sql_query("UPDATE " . TABLE_USER_TECHNOLOGY . " SET `Esp` = " . $tech .
    362. 

  362.             " WHERE `user_id` = " . $user_id);
    363. 

  363.     }
    364. 

  364. 

  365.     //Contrôle que le pseudo ne soit pas déjŕ utilisé
    366. 

  366.     $request = "select * from " . TABLE_USER . " where user_name = '" .
    367. 

  367.          $db->sql_escape_string($pub_pseudo) . "' and user_id <> " . $user_id;
    368. 

  368.     $result = $db->sql_query($request);
    369. 

  369.     if ($db->sql_numrows($result) != 0) {
    370. 

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

  371.     }
    372. 

  372. 

  373.     if (is_null($pub_disable_ip_check) || $pub_disable_ip_check != 1)
    374. 

  374.         $pub_disable_ip_check = 0;
    375. 

  375. 

  376.     user_set_general($user_id, $pub_pseudo, $pub_new_password, null, $pub_galaxy, $pub_system,
    377. 

  377.         $pub_skin, $pub_disable_ip_check);
    378. 

  378.     redirection("index.php?action=profile");
    379. 

  379. }
    380. 

  380. 

  381. /**
    382. 

  382.  * Entree en BDD de donnees utilisateur
    383. 

  383.  * @todo Query x1
    384. 

  384.  */
    385. 

  385. function user_set_general($user_id, $user_name = null, $user_password = null, $user_lastvisit = null,
    386. 

  386.     $user_galaxy = null, $user_system = null, $user_skin = null, $disable_ip_check = null)
    387. 

  387. {
    388. 

  388.     global $db, $user_data, $server_config;
    389. 

  389. 

  390.     if (!isset($user_id)) {
    391. 

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

  392.     }
    393. 

  393. 

  394.     if (!empty($user_galaxy)) {
    395. 

  395.         $user_galaxy = intval($user_galaxy);
    396. 

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

  397.             $user_galaxy = 1;
    398. 

  398.     }
    399. 

  399.     if (!empty($user_system)) {
    400. 

  400.         $user_system = intval($user_system);
    401. 

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

  402.             $user_system = 1;
    403. 

  403.     }
    404. 

  404. 

  405.     $update = "";
    406. 

  406. 

  407.     //Pseudo et mot de passe
    408. 

  408.     if (!empty($user_name))
    409. 

  409.         $update .= "user_name = '" .  $db->sql_escape_string($user_name) . "'";
    410. 

  410.     if (!empty($user_password))
    411. 

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

  412.             ($user_password)) . "'";
    413. 

  413. 

  414.     //Galaxy et systčme solaire du membre
    415. 

  415.     if (!empty($user_galaxy))
    416. 

  416.         $update .= ((strlen($update) > 0) ? ", " : "") . "user_galaxy = '" . $user_galaxy .
    417. 

  417.             "'";
    418. 

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

  419.         $update .= ((strlen($update) > 0) ? ", " : "") . "user_system = '" . $user_system .
    420. 

  420.             "'";
    421. 

  421. 

  422.     //Derničre visite
    423. 

  423.     if (!empty($user_lastvisit))
    424. 

  424.         $update .= ((strlen($update) > 0) ? ", " : "") . "user_lastvisit = '" . $user_lastvisit .
    425. 

  425.             "'";
    426. 

  426. 

  427.     //Skin
    428. 

  428.     if (!is_null($user_skin)) {
    429. 

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

  430.             $user_skin .= "/";
    431. 

  431.         $update .= ((strlen($update) > 0) ? ", " : "") . "user_skin = '" .
    432. 

  432.              $db->sql_escape_string($user_skin) . "'";
    433. 

  433.     }
    434. 

  434. 

  435.     //Désactivation de la vérification de l'adresse ip
    436. 

  436.     if (!is_null($disable_ip_check))
    437. 

  437.         $update .= ((strlen($update) > 0) ? ", " : "") . "disable_ip_check = '" . $disable_ip_check .
    438. 

  438.             "'";
    439. 

  439. 

  440. 

  441.     $request = "update " . TABLE_USER . " set " . $update . " where user_id = " . $user_id;
    442. 

  442.     $db->sql_query($request);
    443. 

  443. 

  444.     if ($user_id == $user_data['user_id']) {
    445. 

  445.         log_("modify_account");
    446. 

  446.     } else {
    447. 

  447.         log_("modify_account_admin", $user_id);
    448. 

  448.     }
    449. 

  449. }
    450. 

  450. 

  451. /**
    452. 

  452.  * Enregistrement des droits et status utilisateurs
    453. 

  453.  * @todo Query : x2
    454. 

  454.  */
    455. 

  455. function user_set_grant($user_id, $user_admin = null, $user_active = null, $user_coadmin = null,
    456. 

  456.     $management_user = null, $management_ranking = null)
    457. 

  457. {
    458. 

  458.     global $db, $user_data;
    459. 

  459. 

  460.     if (!isset($user_id)) {
    461. 

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

  462.     }
    463. 

  463. 

  464.     //Vérification des droits
    465. 

  465.     user_check_auth("user_update", $user_id);
    466. 

  466. 

  467.     $update = "";
    468. 

  468. 

  469.     //Activation membre
    470. 

  470.     if (!is_null($user_active)) {
    471. 

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

  472.             "'";
    473. 

  473.         if (intval($user_active) == 0) {
    474. 

  474.             $request = "delete from " . TABLE_SESSIONS . " where session_user_id = " . $user_id;
    475. 

  475.             $db->sql_query($request);
    476. 

  476.         }
    477. 

  477.     }
    478. 

  478. 

  479.     //Co-administration
    480. 

  480.     if (!is_null($user_coadmin)) {
    481. 

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

  482.             "'";
    483. 

  483.     }
    484. 

  484. 

  485.     //Gestion des membres
    486. 

  486.     if (!is_null($management_user)) {
    487. 

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

  488.             "'";
    489. 

  489.     }
    490. 

  490. 

  491.     //Gestion des classements
    492. 

  492.     if (!is_null($management_ranking)) {
    493. 

  493.         $update .= ((strlen($update) > 0) ? ", " : "") . "management_ranking = '" .
    494. 

  494.             intval($management_ranking) . "'";
    495. 

  495.     }
    496. 

  496. 

  497. 

  498.     $request = "update " . TABLE_USER . " set " . $update . " where user_id = " . $user_id;
    499. 

  499.     $db->sql_query($request);
    500. 

  500. 

  501.     if ($user_id == $user_data['user_id']) {
    502. 

  502.         log_("modify_account");
    503. 

  503.     } else {
    504. 

  504.         log_("modify_account_admin", $user_id);
    505. 

  505.     }
    506. 

  506. }
    507. 

  507. /**
    508. 

  508.  * Enregistrement des statistiques utilisateurs
    509. 

  509.  * @todo Query : x1
    510. 

  510.  */
    511. 

  511. function user_set_stat($planet_added_web = null, $planet_added_ogs = null, $search = null,
    512. 

  512.     $spy_added_web = null, $spy_added_ogs = null, $rank_added_web = null, $rank_added_ogs = null,
    513. 

  513.     $planet_exported = null, $spy_exported = null, $rank_exported = null)
    514. 

  514. {
    515. 

  515.     global $db, $user_data;
    516. 

  516. 

  517.     $update = "";
    518. 

  518. 

  519.     //Statistiques envoi systčmes solaires et rapports d'espionnage
    520. 

  520.     if (!is_null($planet_added_web))
    521. 

  521.         $update .= ((strlen($update) > 0) ? ", " : "") .
    522. 

  522.             "planet_added_web = planet_added_web + " . $planet_added_web;
    523. 

  523.     if (!is_null($planet_added_ogs))
    524. 

  524.         $update .= ((strlen($update) > 0) ? ", " : "") .
    525. 

  525.             "planet_added_ogs = planet_added_ogs + " . $planet_added_ogs;
    526. 

  526.     if (!is_null($search))
    527. 

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

  528.     if (!is_null($spy_added_web))
    529. 

  529.         $update .= ((strlen($update) > 0) ? ", " : "") .
    530. 

  530.             "spy_added_web = spy_added_web + " . $spy_added_web;
    531. 

  531.     if (!is_null($spy_added_ogs))
    532. 

  532.         $update .= ((strlen($update) > 0) ? ", " : "") .
    533. 

  533.             "spy_added_ogs = spy_added_ogs + " . $spy_added_ogs;
    534. 

  534.     if (!is_null($rank_added_web))
    535. 

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

  536.             "rank_added_web = rank_added_web + " . $rank_added_web;
    537. 

  537.     if (!is_null($rank_added_ogs))
    538. 

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

  539.             "rank_added_ogs = rank_added_ogs + " . $rank_added_ogs;
    540. 

  540.     if (!is_null($planet_exported))
    541. 

  541.         $update .= ((strlen($update) > 0) ? ", " : "") .
    542. 

  542.             "planet_exported = planet_exported + " . $planet_exported;
    543. 

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

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

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

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

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

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

  549. 

  550.     $request = "update " . TABLE_USER . " set " . $update . " where user_id = " . $user_data["user_id"];
    551. 

  551.     $db->sql_query($request);
    552. 

  552. }
    553. 

  553. 

  554. /**
    555. 

  555.  * Recuperation d'une ligne d'information utilisateur
    556. 

  556.  * @param int $user_id Identificateur optionnel d'1 utilisateur specifique 
    557. 

  557.  * @return Array Liste des utilisateurs ou de l'utilisateur specifique
    558. 

  558.  * @comment Pourrait peut etre avantageusement remplace par select * from TABLE_USER
    559. 

  559.  * @comment pour les eventuels champs supplementaires
    560. 

  560.  * @todo Query : x1
    561. 

  561.  */
    562. 

  562. function user_get($user_id = false)
    563. 

  563. {
    564. 

  564.     global $db;
    565. 

  565. 

  566.     $request = "select user_id, user_name, user_password, user_active, user_regdate, user_lastvisit," .
    567. 

  567.         " user_galaxy, user_system, user_admin, user_coadmin, management_user, management_ranking, disable_ip_check" .
    568. 

  568.         " from " . TABLE_USER;
    569. 

  569. 

  570.     if ($user_id !== false) {
    571. 

  571.         $request .= " where user_id = " . $user_id;
    572. 

  572.     }
    573. 

  573.     $request .= " order by user_name";
    574. 

  574.     $result = $db->sql_query($request);
    575. 

  575. 

  576.     $info_users = array();
    577. 

  577.     while ($row = $db->sql_fetch_assoc($result)) {
    578. 

  578. 

  579.         $info_users[] = $row;
    580. 

  580.     }
    581. 

  581. 

  582.     if (sizeof($info_users) == 0) {
    583. 

  583.         return false;
    584. 

  584.     }
    585. 

  585. 

  586.     return $info_users;
    587. 

  587. }
    588. 

  588. /**
    589. 

  589.  * Recuperation des droits d'un utilisateur
    590. 

  590.  * @param int $user_id Identificateur de l'utilisateur demande
    591. 

  591.  * @todo Query : x1
    592. 

  592.  * @return Array Tableau des droits
    593. 

  593.  */
    594. 

  594. function user_get_auth($user_id)
    595. 

  595. {
    596. 

  596.     global $db;
    597. 

  597. 

  598.     $user_info = user_get($user_id);
    599. 

  599.     $user_info = $user_info[0];
    600. 

  600.     if ($user_info["user_admin"] == 1 || $user_info["user_coadmin"] == 1) {
    601. 

  601.         $user_auth = array("server_set_system" => 1, "server_set_spy" => 1,
    602. 

  602.             "server_set_rc" => 1, "server_set_ranking" => 1, "server_show_positionhided" =>
    603. 

  603.             1, "ogs_connection" => 1, "ogs_set_system" => 1, "ogs_get_system" => 1,
    604. 

  604.             "ogs_set_spy" => 1, "ogs_get_spy" => 1, "ogs_set_ranking" => 1,
    605. 

  605.             "ogs_get_ranking" => 1);
    606. 

  606. 

  607.         return $user_auth;
    608. 

  608.     }
    609. 

  609. 

  610.     $request = "select server_set_system, server_set_spy, server_set_rc, server_set_ranking, server_show_positionhided,";
    611. 

  611.     $request .= " ogs_connection, ogs_set_system, ogs_get_system, ogs_set_spy, ogs_get_spy, ogs_set_ranking, ogs_get_ranking";
    612. 

  612.     $request .= " from " . TABLE_GROUP . " g, " . TABLE_USER_GROUP . " u";
    613. 

  613.     $request .= " where g.group_id = u.group_id";
    614. 

  614.     $request .= " and user_id = " . $user_id;
    615. 

  615.     $result = $db->sql_query($request);
    616. 

  616. 

  617.     if ($db->sql_numrows($result) > 0) {
    618. 

  618.         $user_auth = array("server_set_system" => 0, "server_set_spy" => 0,
    619. 

  619.             "server_set_rc" => 0, "server_set_ranking" => 0, "server_show_positionhided" =>
    620. 

  620.             0, "ogs_connection" => 0, "ogs_set_system" => 0, "ogs_get_system" => 0,
    621. 

  621.             "ogs_set_spy" => 0, "ogs_get_spy" => 0, "ogs_set_ranking" => 0,
    622. 

  622.             "ogs_get_ranking" => 0);
    623. 

  623. 

  624.         while ($row = $db->sql_fetch_assoc($result)) {
    625. 

  625.             if ($row["server_set_system"] == 1)
    626. 

  626.                 $user_auth["server_set_system"] = 1;
    627. 

  627.             if ($row["server_set_spy"] == 1)
    628. 

  628.                 $user_auth["server_set_spy"] = 1;
    629. 

  629.             if ($row["server_set_rc"] == 1)
    630. 

  630.                 $user_auth["server_set_rc"] = 1;
    631. 

  631.             if ($row["server_set_ranking"] == 1)
    632. 

  632.                 $user_auth["server_set_ranking"] = 1;
    633. 

  633.             if ($row["server_show_positionhided"] == 1)
    634. 

  634.                 $user_auth["server_show_positionhided"] = 1;
    635. 

  635.             if ($row["ogs_connection"] == 1)
    636. 

  636.                 $user_auth["ogs_connection"] = 1;
    637. 

  637.             if ($row["ogs_set_system"] == 1)
    638. 

  638.                 $user_auth["ogs_set_system"] = 1;
    639. 

  639.             if ($row["ogs_get_system"] == 1)
    640. 

  640.                 $user_auth["ogs_get_system"] = 1;
    641. 

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

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

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

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

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

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

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

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

  649.         }
    650. 

  650.     } else {
    651. 

  651.         $user_auth = array("server_set_system" => 0, "server_set_spy" => 0,
    652. 

  652.             "server_set_ranking" => 0, "server_show_positionhided" => 0, "ogs_connection" =>
    653. 

  653.             0, "ogs_set_system" => 0, "ogs_get_system" => 0, "ogs_set_spy" => 0,
    654. 

  654.             "ogs_get_spy" => 0, "ogs_set_ranking" => 0, "ogs_get_ranking" => 0);
    655. 

  655.     }
    656. 

  656. 

  657.     return $user_auth;
    658. 

  658. }
    659. 

  659. 

  660. /**
    661. 

  661.  * Creation d'un utilisateur a partir des donnees du formulaire admin
    662. 

  662.  * @comment redirection si erreur de type de donnee
    663. 

  663.  * @todo Query : x3
    664. 

  664.  */
    665. 

  665. function user_create()
    666. 

  666. {
    667. 

  667.     global $db, $user_data;
    668. 

  668.     global $pub_pseudo, $pub_user_id, $pub_active, $pub_user_coadmin, $pub_management_user,
    669. 

  669.         $pub_management_ranking, $pub_group_id, $pub_pass;
    670. 

  670. 

  671.     if (!check_var($pub_pseudo, "Pseudo_Groupname")) {
    672. 

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

  673.     }
    674. 

  674. 

  675.     if (!isset($pub_pseudo)) {
    676. 

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

  677.     }
    678. 

  678. 

  679.     //Vérification des droits
    680. 

  680.     user_check_auth("user_create");
    681. 

  681. 

  682.     if (!check_var($pub_pseudo, "Pseudo_Groupname")) {
    683. 

  683.         redirection("index.php?action=message&id_message=createuser_failed_pseudo&info=" .
    684. 

  684.             $pub_pseudo);
    685. 

  685.     }
    686. 

  686. 

  687.     if (!check_var($pub_pass, "Password")) {
    688. 

  688.         redirection("index.php?action=message&id_message=createuser_failed_password&info=" .
    689. 

  689.             $pub_pseudo);
    690. 

  690.     }
    691. 

  691. 

  692.     if ($pub_pass != "") {
    693. 

  693.         $password = $pub_pass;
    694. 

  694.     } else {
    695. 

  695.         $password = password_generator();
    696. 

  696.     }
    697. 

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

  698.     $request = "select user_id from " . TABLE_USER . " where user_name = '" . $pub_pseudo .
    699. 

  699.         "'";
    700. 

  700.     $result = $db->sql_query($request);
    701. 

  701.     if ($db->sql_numrows($result) == 0) {
    702. 

  702.         //$request = "insert into ".TABLE_USER." (user_name, user_password, user_regdate, user_active)".
    703. 

  703.         //" values ('". $db->sql_escape_string($pub_pseudo)."', '".md5(sha1($password))."', ".time().", '1')";
    704. 

  704.         $request = "insert into " . TABLE_USER .
    705. 

  705.             " (user_name, user_password, user_regdate, user_active)" . " values ('" . $pub_pseudo .
    706. 

  706.             "', '" . md5(sha1($password)) . "', " . time() . ", '1')";
    707. 

  707.         $db->sql_query($request);
    708. 

  708.         $user_id = $db->sql_insertid();
    709. 

  709. 

  710.         $request = "insert into " . TABLE_USER_GROUP . " (group_id, user_id) values (" .
    711. 

  711.             $pub_group_id . ", " . $user_id . ")";
    712. 

  712.         $db->sql_query($request);
    713. 

  713. 

  714.         $info = $user_id . ":" . $password;
    715. 

  715.         log_("create_account", $user_id);
    716. 

  716.         user_set_grant($user_id, null, $pub_active, $pub_user_coadmin, $pub_management_user,
    717. 

  717.             $pub_management_ranking);
    718. 

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

  719.     } else {
    720. 

  720.         redirection("index.php?action=message&id_message=createuser_failed_pseudolocked&info=" .
    721. 

  721.             $pub_pseudo);
    722. 

  722.     }
    723. 

  723. }
    724. 

  724. /**
    725. 

  725.  * Suppression d'un utilisateur ($pub_user_id)
    726. 

  726.  * @todo Query : x12
    727. 

  727.  */
    728. 

  728. function user_delete()
    729. 

  729. {
    730. 

  730.     global $db, $user_data;
    731. 

  731.     global $pub_user_id;
    732. 

  732. 

  733.     if (!check_var($pub_user_id, "Num")) {
    734. 

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

  735.     }
    736. 

  736. 

  737.     if (!isset($pub_user_id)) {
    738. 

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

  739.     }
    740. 

  740. 

  741.     user_check_auth("user_update", $pub_user_id);
    742. 

  742. 

  743.     log_("delete_account", $pub_user_id);
    744. 

  744.     $request = "delete from " . TABLE_USER . " where user_id = " . $pub_user_id;
    745. 

  745.     $db->sql_query($request);
    746. 

  746. 

  747.     $request = "delete from " . TABLE_USER_GROUP . " where user_id = " . $pub_user_id;
    748. 

  748.     $db->sql_query($request);
    749. 

  749. 

  750.     $request = "delete from " . TABLE_USER_BUILDING . " where user_id = " . $pub_user_id;
    751. 

  751.     $db->sql_query($request);
    752. 

  752. 

  753.     $request = "delete from " . TABLE_USER_FAVORITE . " where user_id = " . $pub_user_id;
    754. 

  754.     $db->sql_query($request);
    755. 

  755. 

  756.     $request = "delete from " . TABLE_USER_DEFENCE . " where user_id = " . $pub_user_id;
    757. 

  757.     $db->sql_query($request);
    758. 

  758. 

  759.     $request = "delete from " . TABLE_USER_SPY . " where user_id = " . $pub_user_id;
    760. 

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

  761. 

  762.     $request = "delete from " . TABLE_USER_TECHNOLOGY . " where user_id = " . $pub_user_id;
    763. 

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

  764. 

  765.     $request = "update " . TABLE_RANK_PLAYER_FLEET .
    766. 

  766.         " set sender_id = 0 where sender_id = " . $pub_user_id;
    767. 

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

  768. 

  769.     $request = "update " . TABLE_RANK_PLAYER_POINTS .
    770. 

  770.         " set sender_id = 0 where sender_id = " . $pub_user_id;
    771. 

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

  772. 

  773.     $request = "update " . TABLE_RANK_PLAYER_RESEARCH .
    774. 

  774.         " set sender_id = 0 where sender_id = " . $pub_user_id;
    775. 

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

  776. 

  777.     $request = "update " . TABLE_UNIVERSE .
    778. 

  778.         " set last_update_user_id = 0 where last_update_user_id = " . $pub_user_id;
    779. 

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

  780. 

  781.     session_close($pub_user_id);
    782. 

  782. 

  783.     redirection("index.php?action=administration&subaction=member");
    784. 

  784. }
    785. 

  785. /**
    786. 

  786.  * Recuperation des statistiques
    787. 

  787.  * @todo Query : x1
    788. 

  788.  */
    789. 

  789. function user_statistic()
    790. 

  790. {
    791. 

  791.     global $db;
    792. 

  792. 

  793.     $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";
    794. 

  794.     $request .= " from " . TABLE_USER .
    795. 

  795.         " order by (planet_added_web + planet_added_ogs) desc";
    796. 

  796.     $result = $db->sql_query($request);
    797. 

  797. 

  798.     $user_statistic = array();
    799. 

  799.     while ($row = $db->sql_fetch_assoc($result)) {
    800. 

  800.         $here = "";
    801. 

  801.         $request = "select session_ogs from " . TABLE_SESSIONS .
    802. 

  802.             " where session_user_id = " . $row["user_id"];
    803. 

  803.         $result_2 = $db->sql_query($request);
    804. 

  804.         if ($db->sql_numrows($result_2) > 0) {
    805. 

  805.             $here = "(*)";
    806. 

  806.             list($session_ogs) = $db->sql_fetch_row($result_2);
    807. 

  807.             if ($session_ogs == 1)
    808. 

  808.                 $here = "(**)";
    809. 

  809.         }
    810. 

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

  811.     }
    812. 

  812. 

  813.     return $user_statistic;
    814. 

  814. }
    815. 

  815. /**
    816. 

  816.  * Enregistrement des donnees Empires d'un utilisateur
    817. 

  817.  */
    818. 

  818. function user_set_empire()
    819. 

  819. {
    820. 

  820.     global $pub_typedata, $pub_data, $pub_planet_id, $pub_planet_name, $pub_fields,
    821. 

  821.         $pub_coordinates, $pub_temperature_min, $pub_temperature_max, $pub_satellite;
    822. 

  822. 

  823.     if (!isset($pub_typedata) || !isset($pub_data)) {
    824. 

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

  825.     }
    826. 

  826. 

  827.     switch ($pub_typedata) {
    828. 

  828.         case "B":
    829. 

  829.             if (!isset($pub_planet_name) || !isset($pub_fields) || !isset($pub_coordinates) ||
    830. 

  830.                 !isset($pub_temperature_min) || !isset($pub_temperature_max) || !isset($pub_satellite)) {
    831. 

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

  832.             }
    833. 

  833.             user_set_building($pub_data, $pub_planet_id, $pub_planet_name, $pub_fields, $pub_coordinates,
    834. 

  834.                 $pub_temperature_min, $pub_temperature_max, $pub_satellite);
    835. 

  835.             break;
    836. 

  836. 

  837.         case "T":
    838. 

  838.             user_set_technology($pub_data);
    839. 

  839.             break;
    840. 

  840. 

  841.         case "D":
    842. 

  842.             if (!isset($pub_planet_name) || !isset($pub_fields) || !isset($pub_coordinates) ||
    843. 

  843.                 !isset($pub_temperature_min) || !isset($pub_temperature_max) || !isset($pub_satellite)) {
    844. 

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

  845.             }
    846. 

  846.             user_set_defence($pub_data, $pub_planet_id, $pub_planet_name, $pub_fields, $pub_coordinates,
    847. 

  847.                 $pub_temperature_min, $pub_temperature_max, $pub_satellite);
    848. 

  848.             break;
    849. 

  849. 

  850.         case "E":
    851. 

  851.             user_set_all_empire($pub_data);
    852. 

  852.             break;
    853. 

  853. 

  854. 

  855.         default:
    856. 

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

  857.             break;
    858. 

  858.     }
    859. 

  859. 

  860.     redirection("index.php?action=home&subaction=empire");
    861. 

  861. }
    862. 

  862. /**
    863. 

  863.  * Enregistrement de toutes les données empires
    864. 

  864.  */
    865. 

  865. function user_set_all_empire($data)
    866. 

  866. {
    867. 

  867.     global $db, $user_data;
    868. 

  868.     global $pub_view;
    869. 

  869.     require_once ("parameters/lang_empire.php");
    870. 

  870. 

  871.     $data = str_replace("-", "0", $data);
    872. 

  872.     $data = str_replace(".", "", $data);
    873. 

  873.     $data = stripcslashes($data);
    874. 

  874.     $lines = explode(chr(10), $data);
    875. 

  875.     $OK = false;
    876. 

  876.     $etape = "";
    877. 

  877.     $planetes_total_row = false;
    878. 

  878.     foreach ($lines as $line) {
    879. 

  879.         $arr = array();
    880. 

  880.         $line = trim($line);
    881. 

  881. 

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

  883.             $OK = true;
    884. 

  884.             continue;
    885. 

  885.         }
    886. 

  886. 

  887.         if ($OK) {
    888. 

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

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

  890.                 $planetes_total_row = sizeof($coordonnees) + 1;
    891. 

  891.                 if ($planetes_total_row > 10)
    892. 

  892.                     return false;
    893. 

  893. 

  894.                 $link_building = array($lang_building["M"] => "M", $lang_building["C"] => "C", $lang_building["D"] =>
    895. 

  895.                     "D", $lang_building["CES"] => "CES", $lang_building["CEF"] => "CEF", $lang_building["UdR"] =>
    896. 

  896.                     "UdR", $lang_building["UdN"] => "UdN", $lang_building["CSp"] => "CSp", $lang_building["HM"] =>
    897. 

  897.                     "HM", $lang_building["HC"] => "HC", $lang_building["HD"] => "HD", $lang_building["Lab"] =>
    898. 

  898.                     "Lab", $lang_building["Ter"] => "Ter", $lang_building["Silo"] => "Silo", $lang_building["BaLu"] =>
    899. 

  899.                     "BaLu", $lang_building["Pha"] => "Pha", $lang_building["PoSa"] => "PoSa");
    900. 

  900. 

  901.                 $buildings = array("M" => array_fill(0, $planetes_total_row, 0), "C" =>
    902. 

  902.                     array_fill(0, $planetes_total_row, 0), "D" => array_fill(0, $planetes_total_row,
    903. 

  903.                     0), "CES" => array_fill(0, $planetes_total_row, 0), "CEF" => array_fill(0, $planetes_total_row,
    904. 

  904.                     0), "UdR" => array_fill(0, $planetes_total_row, 0), "UdN" => array_fill(0, $planetes_total_row,
    905. 

  905.                     0), "CSp" => array_fill(0, $planetes_total_row, 0), "HM" => array_fill(0, $planetes_total_row,
    906. 

  906.                     0), "HC" => array_fill(0, $planetes_total_row, 0), "HD" => array_fill(0, $planetes_total_row,
    907. 

  907.                     0), "Lab" => array_fill(0, $planetes_total_row, 0), "Ter" => array_fill(0, $planetes_total_row,
    908. 

  908.                     0), "Silo" => array_fill(0, $planetes_total_row, 0), "BaLu" => array_fill(0, $planetes_total_row,
    909. 

  909.                     0), "Pha" => array_fill(0, $planetes_total_row, 0), "PoSa" => array_fill(0, $planetes_total_row,
    910. 

  910.                     0));
    911. 

  911. 

  912.                 $link_defence = array($lang_defence["LM"] => "LM", $lang_defence["LLE"] => "LLE",
    913. 

  913.                     $lang_defence["LLO"] => "LLO", $lang_defence["CG"] => "CG", $lang_defence["AI"] =>
    914. 

  914.                     "AI", $lang_defence["LP"] => "LP", $lang_defence["PB"] => "PB", $lang_defence["GB"] =>
    915. 

  915.                     "GB", $lang_defence["MIC"] => "MIC", $lang_defence["MIP"] => "MIP");
    916. 

  916. 

  917.                 $defences = array("LM" => array_fill(0, $planetes_total_row, 0), "LLE" =>
    918. 

  918.                     array_fill(0, $planetes_total_row, 0), "LLO" => array_fill(0, $planetes_total_row,
    919. 

  919.                     0), "CG" => array_fill(0, $planetes_total_row, 0), "AI" => array_fill(0, $planetes_total_row,
    920. 

  920.                     0), "LP" => array_fill(0, $planetes_total_row, 0), "PB" => array_fill(0, $planetes_total_row,
    921. 

  921.                     0), "GB" => array_fill(0, $planetes_total_row, 0), "MIC" => array_fill(0, $planetes_total_row,
    922. 

  922.                     0), "MIP" => array_fill(0, $planetes_total_row, 0));
    923. 

  923. 

  924.                 $link_technology = array($lang_technology["Esp"] => "Esp", $lang_technology["Ordi"] =>
    925. 

  925.                     "Ordi", $lang_technology["Armes"] => "Armes", $lang_technology["Bouclier"] =>
    926. 

  926.                     "Bouclier", $lang_technology["Protection"] => "Protection", $lang_technology["NRJ"] =>
    927. 

  927.                     "NRJ", $lang_technology["Hyp"] => "Hyp", $lang_technology["RC"] => "RC", $lang_technology["RI"] =>
    928. 

  928.                     "RI", $lang_technology["PH"] => "PH", $lang_technology["Laser"] => "Laser", $lang_technology["Ions"] =>
    929. 

  929.                     "Ions", $lang_technology["Plasma"] => "Plasma", $lang_technology["RRI"] => "RRI",
    930. 

  930.                     $lang_technology["Graviton"] => "Graviton", $lang_technology["Astrophysique"] =>
    931. 

  931.                     "Astrophysique");
    932. 

  932. 

  933.                 $technologies = array("Esp" => 0, "Ordi" => 0, "Armes" => 0, "Bouclier" => 0,
    934. 

  934.                     "Protection" => 0, "NRJ" => 0, "Hyp" => 0, "RC" => 0, "RI" => 0, "PH" => 0,
    935. 

  935.                     "Laser" => 0, "Ions" => 0, "Plasma" => 0, "RRI" => 0, "Graviton" => 0,
    936. 

  936.                     "Astrophysique" => 0);
    937. 

  937. 

  938.                 $satellites = array_fill(0, $planetes_total_row, 0);
    939. 

  939.                 $cases = array_fill(0, $planetes_total_row, 0);
    940. 

  940. 

  941.                 // creation du masque ici
    942. 

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

  943.                 for ($i = 0; $i < ($planetes_total_row - 1); $i++) {
    944. 

  944.                     $masq .= "(\d+)(?:|\s\d+|\s\(\d+\))\s+";
    945. 

  945.                 }
    946. 

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

  947. 

  948.                 continue;
    949. 

  949.             }
    950. 

  950. 

  951.             if ($OK && $planetes_total_row !== false) {
    952. 

  952. 

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

  954.                     "})$#", $line, $arr)) {
    955. 

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

  956.                     if (sizeof($cases) != $planetes_total_row)
    957. 

  957.                         return false;
    958. 

  958.                     continue;
    959. 

  959.                 }
    960. 

  960. 

  961.                 if (preg_match("#^(" . $lang_empire["Batiment"] . "|" . $lang_empire["Recherche"] .
    962. 

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

  963.                     $etape = $line;
    964. 

  964.                     continue;
    965. 

  965.                 }
    966. 

  966. 

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

  968. 

  969.                     $building = $arr[1];
    970. 

  970.                     $levels = array_slice($arr, 2);
    971. 

  971. 

  972.                     switch ($etape) {
    973. 

  973.                         case "Bâtiments":
    974. 

  974.                             if (isset($link_building[$building])) {
    975. 

  975.                                 if (sizeof($levels) != $planetes_total_row)
    976. 

  976.                                     return false;
    977. 

  977.                                 $buildings[$link_building[$building]] = $levels;
    978. 

  978.                             }
    979. 

  979.                             break;
    980. 

  980.                         case "Recherche":
    981. 

  981.                             if (isset($link_technology[$building])) {
    982. 

  982.                                 if (sizeof($levels) != $planetes_total_row)
    983. 

  983.                                     return false;
    984. 

  984.                                 $technologies[$link_technology[$building]] = max($levels);
    985. 

  985.                             }
    986. 

  986.                             break;
    987. 

  987.                         case "Vaisseaux":
    988. 

  988.                             if ($building == "Satellite solaire") {
    989. 

  989.                                 if (sizeof($levels) != $planetes_total_row)
    990. 

  990.                                     return false;
    991. 

  991.                                 $satellites = $levels;
    992. 

  992.                             }
    993. 

  993.                             break;
    994. 

  994.                         case "Défense":
    995. 

  995.                             if (isset($link_defence[$building])) {
    996. 

  996.                                 if (sizeof($levels) != $planetes_total_row)
    997. 

  997.                                     return false;
    998. 

  998.                                 $defences[$link_defence[$building]] = $levels;
    999. 

  999.                             }
    1000. 

  1000.                             break;
    1001. 

  1001.                         default:
    1002. 

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

  1003.                     }
    1004. 

  1004.                     continue;
    1005. 

  1005.                 }
    1006. 

  1006. 

  1007.             }
    1008. 

  1008.         }
    1009. 

  1009.     }
    1010. 

  1010.     if ($OK && $planetes_total_row !== false) {
    1011. 

  1011.         $j = 19;
    1012. 

  1012.         for ($i = 0; $i < $planetes_total_row; $i++) {
    1013. 

  1013.             if ($pub_view == "moons") {
    1014. 

  1014.                 $request = "select planet_id from " . TABLE_USER_BUILDING .
    1015. 

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

  1016.                 $result = $db->sql_query($request);
    1017. 

  1017.                 if ($db->sql_numrows($result) > 0) {
    1018. 

  1018.                     list($planete_id) = $db->sql_fetch_row($result);
    1019. 

  1019.                 } else {
    1020. 

  1020.                     $request = "select planet_id from " . TABLE_USER_BUILDING . " where user_id = " .
    1021. 

  1021.                         $user_data["user_id"] . " and coordinates = '" . $coordonnees[$i] . "'";
    1022. 

  1022.                     $result = $db->sql_query($request);
    1023. 

  1023.                     list($planete_id) = $db->sql_fetch_row($result);
    1024. 

  1024.                     if (!$planete_id) {
    1025. 

  1025.                         $planete_id = $j;
    1026. 

  1026.                         $j++;
    1027. 

  1027.                     } else
    1028. 

  1028.                         $planete_id += 9;
    1029. 

  1029.                 }
    1030. 

  1030.             } else
    1031. 

  1031.                 $planete_id = $i + 1;
    1032. 

  1032. 

  1033.             if ($pub_view == "planets")
    1034. 

  1034.                 $case = $cases[$i] - 5 * $buildings["Ter"][$i];
    1035. 

  1035.             else
    1036. 

  1036.                 $case = 1;
    1037. 

  1037. 

  1038.             $request = "update " . TABLE_USER_BUILDING . " set coordinates = '" . $coordonnees[$i] .
    1039. 

  1039.                 "', `fields` = " . $case . " , Sat = " . $satellites[$i];
    1040. 

  1040.             $request .= ", M = " . $buildings["M"][$i] . ", C = " . $buildings["C"][$i] .
    1041. 

  1041.                 ", D = " . $buildings["D"][$i];
    1042. 

  1042.             $request .= ", CES = " . $buildings["CES"][$i] . ", CEF = " . $buildings["CEF"][$i] .
    1043. 

  1043.                 ", UdR = " . $buildings["UdR"][$i];
    1044. 

  1044.             $request .= ", UdN = " . $buildings["UdN"][$i] . ", CSp = " . $buildings["CSp"][$i] .
    1045. 

  1045.                 ", HM = " . $buildings["HM"][$i];
    1046. 

  1046.             $request .= ", HC = " . $buildings["HC"][$i] . ", HD = " . $buildings["HD"][$i] .
    1047. 

  1047.                 ", Lab = " . $buildings["Lab"][$i];
    1048. 

  1048.             $request .= ", Ter = " . $buildings["Ter"][$i] . ", Silo = " . $buildings["Silo"][$i] .
    1049. 

  1049.                 ", BaLu = " . $buildings["BaLu"][$i];
    1050. 

  1050.             $request .= ", Pha = " . $buildings["Pha"][$i] . ", PoSa = " . $buildings["PoSa"][$i] . ($pub_view ==
    1051. 

  1051.                 'lunes' ? ', planet_name = \'Lune\'' : '');
    1052. 

  1052.             $request .= " where user_id = " . $user_data["user_id"] . " and planet_id = " .
    1053. 

  1053.                 $planete_id;
    1054. 

  1054.             $db->sql_query($request);
    1055. 

  1055.             if ($db->sql_affectedrows() == 0) {
    1056. 

  1056.                 $request = "insert ignore into " . TABLE_USER_BUILDING .
    1057. 

  1057.                     " (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)";
    1058. 

  1058.                 $request .= " values (" . $user_data["user_id"] . ", " . $planete_id . ", '" . ($pub_view ==
    1059. 

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

  1060.                     $case . ", 0, " . $satellites[$i];
    1061. 

  1061.                 $request .= ", " . $buildings["M"][$i] . ", " . $buildings["C"][$i] . ", " . $buildings["D"][$i];
    1062. 

  1062.                 $request .= ", " . $buildings["CES"][$i] . ", " . $buildings["CEF"][$i] . ", " .
    1063. 

  1063.                     $buildings["UdR"][$i];
    1064. 

  1064.                 $request .= ", " . $buildings["UdN"][$i] . ", " . $buildings["CSp"][$i] . ", " .
    1065. 

  1065.                     $buildings["HM"][$i];
    1066. 

  1066.                 $request .= ", " . $buildings["HC"][$i] . ", " . $buildings["HD"][$i] . ", " . $buildings["Lab"][$i];
    1067. 

  1067.                 $request .= ", " . $buildings["Ter"][$i] . ", " . $buildings["Silo"][$i] . ", " .
    1068. 

  1068.                     $buildings["BaLu"][$i];
    1069. 

  1069.                 $request .= ", " . $buildings["Pha"][$i] . ", " . $buildings["PoSa"][$i] . ")";
    1070. 

  1070.                 $db->sql_query($request);
    1071. 

  1071.             }
    1072. 

  1072. 

  1073.             $request = "delete from " . TABLE_USER_DEFENCE . " where user_id = " . $user_data["user_id"] .
    1074. 

  1074.                 " and planet_id= " . $planete_id;
    1075. 

  1075.             $db->sql_query($request);
    1076. 

  1076. 

  1077.             $request = "insert into " . TABLE_USER_DEFENCE .
    1078. 

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

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

  1080.                 ", " . $defences["LLE"][$i] . "," . $defences["LLO"][$i] . ", " . $defences["CG"][$i] .
    1081. 

  1081.                 ", " . $defences["AI"][$i] . ", " . $defences["LP"][$i] . ", " . $defences["PB"][$i] .
    1082. 

  1082.                 ", " . $defences["GB"][$i] . ", " . $defences["MIC"][$i] . ", " . $defences["MIP"][$i] .
    1083. 

  1083.                 ")";
    1084. 

  1084.             $db->sql_query($request);
    1085. 

  1085.         }
    1086. 

  1086.         if ($pub_view == "planets") {
    1087. 

  1087.             $request = "delete from " . TABLE_USER_TECHNOLOGY . " where user_id = " . $user_data["user_id"];
    1088. 

  1088.             $db->sql_query($request);
    1089. 

  1089. 

  1090.             $request = "insert into " . TABLE_USER_TECHNOLOGY .
    1091. 

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

  1092.             $request .= " values (" . $user_data["user_id"] . ", " . $technologies["Esp"] .
    1093. 

  1093.                 ", " . $technologies["Ordi"] . "," . $technologies["Armes"] . ", " . $technologies["Bouclier"] .
    1094. 

  1094.                 ", " . $technologies["Protection"] . ", " . $technologies["NRJ"] . ", " . $technologies["Hyp"] .
    1095. 

  1095.                 ", " . $technologies["RC"] . ", " . $technologies["RI"] . ", " . $technologies["PH"] .
    1096. 

  1096.                 ", " . $technologies["Laser"] . ", " . $technologies["Ions"] . ", " . $technologies["Plasma"] .
    1097. 

  1097.                 ", " . $technologies["RRI"] . ", " . $technologies["Graviton"] . ", " . $technologies["Astrophysique"] .
    1098. 

  1098.                 ");";
    1099. 

  1099.             $db->sql_query($request);
    1100. 

  1100.         }
    1101. 

  1101. 

  1102. 

  1103.         if ($pub_view == "planets")
    1104. 

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

  1105.                 "&alert_empire=true");
    1106. 

  1106.         else
    1107. 

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

  1108.     } else
    1109. 

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

  1110. }
    1111. 

  1111. 

  1112. 

  1113. /**
    1114. 

  1114.  * remise en ordre des lunes en fonctions des positions des planetes
    1115. 

  1115.  */
    1116. 

  1116. function user_set_all_empire_resync_moon()
    1117. 

  1117. {
    1118. 

  1118.     global $db, $user_data;
    1119. 

  1119. 

  1120. 

  1121.     // lews planetes
    1122. 

  1122.     $request = "select planet_id, coordinates";
    1123. 

  1123.     $request .= " from " . TABLE_USER_BUILDING;
    1124. 

  1124.     $request .= " where user_id = " . $user_data["user_id"];
    1125. 

  1125.     $request .= " and planet_id <= 199";
    1126. 

  1126.     $request .= " order by planet_id";
    1127. 

  1127.     $result = $db->sql_query($request);
    1128. 

  1128. 

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

  1130.         $planet_position[$coordinates] = $planet_id;
    1131. 

  1131.     }
    1132. 

  1132. 

  1133.     // les lunes
    1134. 

  1134.     $request = "select planet_id, coordinates";
    1135. 

  1135.     $request .= " from " . TABLE_USER_BUILDING;
    1136. 

  1136.     $request .= " where user_id = " . $user_data["user_id"];
    1137. 

  1137.     $request .= " and planet_id > 199";
    1138. 

  1138.     $request .= " order by planet_id";
    1139. 

  1139.     $result = $db->sql_query($request);
    1140. 

  1140. 

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

  1142.         $moon_position[$coordinates] = $planet_id;
    1143. 

  1143.     }
    1144. 

  1144. 

  1145.     // on ressort les complexes planete / lune ayant la meme cle
    1146. 

  1146.     $complexe = array_intersect_key($planet_position, $moon_position);
    1147. 

  1147. 

  1148.     /// on passe les id se modifiant a 300
    1149. 

  1149.     foreach ($complexe as $cle_com => $valeur_com) {
    1150. 

  1150.         $nouvelle_valeur = $planet_position[$cle_com] + 200;
    1151. 

  1151.         $request = "UPDATE " . TABLE_USER_DEFENCE . " SET planet_id  = " . $nouvelle_valeur .
    1152. 

  1152.             " WHERE  planet_id = " . $moon_position[$cle_com] . " and user_id = " . $user_data["user_id"] .
    1153. 

  1153.             "";
    1154. 

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

  1155.         $request = "UPDATE " . TABLE_USER_BUILDING . " SET planet_id  = " . $nouvelle_valeur .
    1156. 

  1156.             " WHERE  planet_id = " . $moon_position[$cle_com] . " and user_id = " . $user_data["user_id"] .
    1157. 

  1157.             "";
    1158. 

  1158.         $db->sql_query($request);
    1159. 

  1159.     }
    1160. 

  1160. 

  1161.     /// on remet le tout a 200 pour lunes
    1162. 

  1162.     $request = "UPDATE " . TABLE_USER_BUILDING .
    1163. 

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

  1164.         "";
    1165. 

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

  1166.     $request = "UPDATE " . TABLE_USER_DEFENCE .
    1167. 

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

  1168.         "";
    1169. 

  1169.     $db->sql_query($request);
    1170. 

  1170. 

  1171. }
    1172. 

  1172. /**
    1173. 

  1173.  * remise en ordre des planetes sans espaces vides ...
    1174. 

  1174.  * ( les id doivent se suivre 101,102,103 etc etc)
    1175. 

  1175.  */
    1176. 

  1176. function user_set_all_empire_resync_planet()
    1177. 

  1177. {
    1178. 

  1178.     global $db, $user_data;
    1179. 

  1179. 

  1180.     $nb_planete = find_nb_planete_user();
    1181. 

  1181. 

  1182.     $request = "select planet_id, coordinates";
    1183. 

  1183.     $request .= " from " . TABLE_USER_BUILDING;
    1184. 

  1184.     $request .= " where user_id = " . $user_data["user_id"];
    1185. 

  1185.     $request .= " and planet_id <= 199";
    1186. 

  1186.     $request .= " order by planet_id";
    1187. 

  1187.     $result = $db->sql_query($request);
    1188. 

  1188. 

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

  1190.         $planet_position[$coordinates] = $planet_id;
    1191. 

  1191.     }
    1192. 

  1192. 

  1193. 

  1194.     $i = 101;
    1195. 

  1195.     foreach ($planet_position as $cle => $valeur) {
    1196. 

  1196. 

  1197.         // planete
    1198. 

  1198.         $request = "update " . TABLE_USER_BUILDING . " set planet_id = " . $i .
    1199. 

  1199.             " where planet_id = " . $valeur;
    1200. 

  1200.         $db->sql_query($request);
    1201. 

  1201.         $request = "update " . TABLE_USER_DEFENCE . " set planet_id = " . $i .
    1202. 

  1202.             " where planet_id = " . $valeur;
    1203. 

  1203.         $db->sql_query($request);
    1204. 

  1204. 

  1205.         $i++;
    1206. 

  1206. 

  1207.     }
    1208. 

  1208.     
    1209. 

  1209.     /// on lance le resync moon que si lune
    1210. 

  1210.     $request = "select planet_id ";
    1211. 

  1211.     $request .= " from " . TABLE_USER_BUILDING;
    1212. 

  1212.     $request .= " where user_id = " . $user_data["user_id"];
    1213. 

  1213.     $request .= " and planet_id > 199";
    1214. 

  1214.     $request .= " order by planet_id";
    1215. 

  1215.     $result = $db->sql_query($request);
    1216. 

  1216.  
    1217. 

  1217.      if ($db->sql_numrows($result) != 0) {
    1218. 

  1218.        
    1219. 

  1219.     // on remet en ordre moon
    1220. 

  1220.     user_set_all_empire_resync_moon();
    1221. 

  1221.     // todo : passer le result en paramettre ...
    1222. 

  1222.        
    1223. 

  1223.        
    1224. 

  1224.     }
    1225. 

  1225. 

  1226. }
    1227. 

  1227. 

  1228. function user_set_building($data, $planet_id, $planet_name, $fields, $coordinates,
    1229. 

  1229.     $temperature_min, $temperature_max, $satellite)
    1230. 

  1230. {
    1231. 

  1231.     global $db, $user_data;
    1232. 

  1232.     global $pub_view, $server_config;
    1233. 

  1233.     require_once ("parameters/lang_empire.php");
    1234. 

  1234. 

  1235.     $planet_name = trim($planet_name) != "" ? trim($planet_name) : "Inconnu";
    1236. 

  1236.     if (!check_var($planet_name, "Galaxy"))
    1237. 

  1237.         $planet_name = "";
    1238. 

  1238. 

  1239.     $fields = intval($fields);
    1240. 

  1240.     $temperature_min = intval($temperature_min);
    1241. 

  1241.     $temperature_max = intval($temperature_max);
    1242. 

  1242.     $satellite = intval($satellite);
    1243. 

  1243.     $coordinates_ok = "";
    1244. 

  1244.     if (sizeof(explode(":", $coordinates)) == 3 || sizeof(explode(".", $coordinates)) ==
    1245. 

  1245.         3) {
    1246. 

  1246.         if (sizeof(explode(":", $coordinates)) == 3)
    1247. 

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

  1248.         if (sizeof(explode(".", $coordinates)) == 3)
    1249. 

  1249.             @list($galaxy, $system, $row) = explode(".", $coordinates);
    1250. 

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

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

  1252.             intval($row) >= 1 && intval($row) <= 15) {
    1253. 

  1253.             $coordinates_ok = $coordinates;
    1254. 

  1254.         }
    1255. 

  1255.     }
    1256. 

  1256. 

  1257.     if (!isset($planet_id)) {
    1258. 

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

  1259.     }
    1260. 

  1260.     $planet_id = intval($planet_id);
    1261. 

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

  1262.         "lunes" && ($planet_id < 10 || $planet_id > 18))) {
    1263. 

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

  1264.     }
    1265. 

  1265. 

  1266.     $link_building = array($lang_building["M"] => "M", $lang_building["C"] => "C", $lang_building["D"] =>
    1267. 

  1267.         "D", $lang_building["CES"] => "CES", $lang_building["CEF"] => "CEF", $lang_building["DdR"] =>
    1268. 

  1268.         "DdR", $lang_building["UdR"] => "UdR", $lang_building["UdN"] => "UdN", $lang_building["CSp"] =>
    1269. 

  1269.         "CSp", $lang_building["HM"] => "HM", $lang_building["HC"] => "HC", $lang_building["HD"] =>
    1270. 

  1270.         "HD", $lang_building["Lab"] => "Lab", $lang_building["Ter"] => "Ter", $lang_building["Silo"] =>
    1271. 

  1271.         "Silo", $lang_building["BaLu"] => "BaLu", $lang_building["Pha"] => "Pha", $lang_building["PoSa"] =>
    1272. 

  1272.         "PoSa");
    1273. 

  1273. 

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

  1275.         0, "UdR" => 0, "UdN" => 0, "CSp" => 0, "HM" => 0, "HC" => 0, "HD" => 0, "Lab" =>
    1276. 

  1276.         0, "Ter" => 0, "Silo" => 0, "BaLu" => 0, "Pha" => 0, "PoSa" => 0);
    1277. 

  1277. 

  1278.     $lines = explode(chr(10), $data);
    1279. 

  1279. 

  1280.     $OK = false;
    1281. 

  1281.     foreach ($lines as $line) {
    1282. 

  1282.         $arr = array();
    1283. 

  1283.         $line = trim($line);
    1284. 

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

  1285.             list($string, $building, $level) = $arr;
    1286. 

  1286. 

  1287.             $building = trim($building);
    1288. 

  1288.             $level = trim(str_replace("Niveau", "", $level));
    1289. 

  1289. 

  1290.             if (isset($link_building[$building])) {
    1291. 

  1291.                 $OK = true;
    1292. 

  1292.                 $buildings[$link_building[$building]] = $level;
    1293. 

  1293.                 $res = $db->sql_query('SELECT planet_name FROM ' . TABLE_USER_BUILDING .
    1294. 

  1294.                     ' WHERE planet_id = ' . $planet_id);
    1295. 

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

  1296.                     $fields -= $level * 5;
    1297. 

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

  1298.                     $fields -= $level * 4;
    1299. 

  1299.             }
    1300. 

  1300.         }
    1301. 

  1301.     }
    1302. 

  1302. 

  1303.     if ($OK) {
    1304. 

  1304.         $request = "delete from " . TABLE_USER_BUILDING . " where user_id = " . $user_data["user_id"] .
    1305. 

  1305.             " and planet_id= " . $planet_id;
    1306. 

  1306.         $db->sql_query($request);
    1307. 

  1307. 

  1308.         $request = "insert into " . TABLE_USER_BUILDING .
    1309. 

  1309.             " (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)";
    1310. 

  1310.         $request .= " values (" . $user_data["user_id"] . ", " . $planet_id . ", '" .
    1311. 

  1311.              $db->sql_escape_string($planet_name) . "', '" . $coordinates_ok . "', " . $fields .
    1312. 

  1312.             ", " . $temperature_min . ", " . $satellite . ", " . $buildings["M"] . ", " . $buildings["C"] .
    1313. 

  1313.             "," . $buildings["D"] . ", " . $buildings["CES"] . ", " . $buildings["CEF"] .
    1314. 

  1314.             ", " . $buildings["UdR"] . ", " . $buildings["UdN"] . ", " . $buildings["CSp"] .
    1315. 

  1315.             ", " . $buildings["HM"] . ", " . $buildings["HC"] . ", " . $buildings["HD"] .
    1316. 

  1316.             ", " . $buildings["Lab"] . ", " . $buildings["Ter"] . ", " . $buildings["Silo"] .
    1317. 

  1317.             ", " . $buildings["BaLu"] . ", " . $buildings["Pha"] . ", " . $buildings["PoSa"] .
    1318. 

  1318.             ")";
    1319. 

  1319.         $db->sql_query($request);
    1320. 

  1320.     } elseif ($planet_id > 9) {
    1321. 

  1321.         $request = "insert into " . TABLE_USER_BUILDING .
    1322. 

  1322.             " (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)";
    1323. 

  1323.         $request .= " values (" . $user_data["user_id"] . ", " . $planet_id . ", '" .
    1324. 

  1324.              $db->sql_escape_string($planet_name) . "', '" . $coordinates_ok . "', " . $fields .
    1325. 

  1325.             ", " . $temperature_max . ", " . $satellite . ", " . $buildings["M"] . ", " . $buildings["C"] .
    1326. 

  1326.             "," . $buildings["D"] . ", " . $buildings["CES"] . ", " . $buildings["CEF"] .
    1327. 

  1327.             ", " . $buildings["UdR"] . ", " . $buildings["UdN"] . ", " . $buildings["CSp"] .
    1328. 

  1328.             ", " . $buildings["HM"] . ", " . $buildings["HC"] . ", " . $buildings["HD"] .
    1329. 

  1329.             ", " . $buildings["Lab"] . ", " . $buildings["Ter"] . ", " . $buildings["Silo"] .
    1330. 

  1330.             ", " . $buildings["BaLu"] . ", " . $buildings["Pha"] . ", " . $buildings["PoSa"] .
    1331. 

  1331.             ")";
    1332. 

  1332.         $db->sql_query($request);
    1333. 

  1333.     } else {
    1334. 

  1334.         $request = "update " . TABLE_USER_BUILDING . " set planet_name = '" .
    1335. 

  1335.              $db->sql_escape_string($planet_name) . "', coordinates = '" . $coordinates_ok .
    1336. 

  1336.             "', `fields` = " . $fields . ", temperature_min = " . $temperature_min .
    1337. 

  1337.             ", temperature_max = " . $temperature_max . ", Sat = " . $satellite .
    1338. 

  1338.             " where user_id = " . $user_data["user_id"] . " and planet_id = " . $planet_id;
    1339. 

  1339.         $db->sql_query($request);
    1340. 

  1340.     }
    1341. 

  1341. 

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

  1343. }
    1344. 

  1344. 

  1345. function user_set_technology($data)
    1346. 

  1346. {
    1347. 

  1347.     global $db, $user_data;
    1348. 

  1348.     require_once ("parameters/lang_empire.php");
    1349. 

  1349. 

  1350.     $link_technology = array($lang_technology["Esp"] => "Esp", $lang_technology["Ordi"] =>
    1351. 

  1351.         "Ordi", $lang_technology["Armes"] => "Armes", $lang_technology["Bouclier"] =>
    1352. 

  1352.         "Bouclier", $lang_technology["Protection"] => "Protection", $lang_technology["NRJ"] =>
    1353. 

  1353.         "NRJ", $lang_technology["Hyp"] => "Hyp", $lang_technology["RC"] => "RC", $lang_technology["RI"] =>
    1354. 

  1354.         "RI", $lang_technology["PH"] => "PH", $lang_technology["Laser"] => "Laser", $lang_technology["Ions"] =>
    1355. 

  1355.         "Ions", $lang_technology["Plasma"] => "Plasma", $lang_technology["RRI"] => "RRI",
    1356. 

  1356.         $lang_technology["Graviton"] => "Graviton", $lang_technology["Astrophysique"] =>
    1357. 

  1357.         "Astrophysique");
    1358. 

  1358. 

  1359.     $technologies = array("Esp" => 0, "Ordi" => 0, "Armes" => 0, "Bouclier" => 0,
    1360. 

  1360.         "Protection" => 0, "NRJ" => 0, "Hyp" => 0, "RC" => 0, "RI" => 0, "PH" => 0,
    1361. 

  1361.         "Laser" => 0, "Ions" => 0, "Plasma" => 0, "RRI" => 0, "Graviton" => 0,
    1362. 

  1362.         "Astrophysique" => 0);
    1363. 

  1363. 

  1364.     $lines = explode(chr(10), $data);
    1365. 

  1365. 

  1366.     $OK = false;
    1367. 

  1367.     foreach ($lines as $line) {
    1368. 

  1368.         $arr = array();
    1369. 

  1369.         $line = trim($line);
    1370. 

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

  1371.             list($string, $technology, $level) = $arr;
    1372. 

  1372. 

  1373.             $technology = trim($technology);
    1374. 

  1374.             $level = trim(str_replace("Niveau", "", $level));
    1375. 

  1375. 

  1376.             if (isset($link_technology[$technology])) {
    1377. 

  1377.                 $OK = true;
    1378. 

  1378.                 $technologies[$link_technology[$technology]] = $level;
    1379. 

  1379.             }
    1380. 

  1380.         }
    1381. 

  1381.     }
    1382. 

  1382. 

  1383.     if (!$OK) {
    1384. 

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

  1385.     }
    1386. 

  1386. 

  1387.     $request = "delete from " . TABLE_USER_TECHNOLOGY . " where user_id = " . $user_data["user_id"];
    1388. 

  1388.     $db->sql_query($request);
    1389. 

  1389. 

  1390.     $request = "insert into " . TABLE_USER_TECHNOLOGY .
    1391. 

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

  1392.     $request .= " values (" . $user_data["user_id"] . ", " . $technologies["Esp"] .
    1393. 

  1393.         ", " . $technologies["Ordi"] . "," . $technologies["Armes"] . ", " . $technologies["Bouclier"] .
    1394. 

  1394.         ", " . $technologies["Protection"] . ", " . $technologies["NRJ"] . ", " . $technologies["Hyp"] .
    1395. 

  1395.         ", " . $technologies["RC"] . ", " . $technologies["RI"] . ", " . $technologies["PH"] .
    1396. 

  1396.         ", " . $technologies["Laser"] . ", " . $technologies["Ions"] . ", " . $technologies["Plasma"] .
    1397. 

  1397.         ", " . $technologies["RRI"] . ", " . $technologies["Graviton"] . ", " . $technologies["Astrophysique"] .
    1398. 

  1398.         ");";
    1399. 

  1399.     $db->sql_query($request);
    1400. 

  1400. 

  1401.     redirection("index.php?action=home&subaction=empire");
    1402. 

  1402. }
    1403. 

  1403. /**
    1404. 

  1404.  * Enregistrement des défenses de l'utilisateurs
    1405. 

  1405.  */
    1406. 

  1406. function user_set_defence($data, $planet_id, $planet_name, $fields, $coordinates,
    1407. 

  1407.     $temperature_min, $temperature_max, $satellite)
    1408. 

  1408. {
    1409. 

  1409.     global $db, $user_data;
    1410. 

  1410.     global $pub_view, $server_config;
    1411. 

  1411.     require_once ("parameters/lang_empire.php");
    1412. 

  1412. 

  1413.     $planet_name = trim($planet_name) != "" ? trim($planet_name) : "Inconnu";
    1414. 

  1414.     if (!check_var($planet_name, "Galaxy"))
    1415. 

  1415.         $planet_name = "";
    1416. 

  1416.     $fields = intval($fields);
    1417. 

  1417.     $temperature_min = intval($temperature_min);
    1418. 

  1418.     $temperature_max = intval($temperature_max);
    1419. 

  1419.     $satellite = intval($satellite);
    1420. 

  1420.     $coordinates_ok = "";
    1421. 

  1421.     if (sizeof(explode(":", $coordinates)) == 3 || sizeof(explode(".", $coordinates)) ==
    1422. 

  1422.         3) {
    1423. 

  1423.         if (sizeof(explode(":", $coordinates)) == 3)
    1424. 

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

  1425.         if (sizeof(explode(".", $coordinates)) == 3)
    1426. 

  1426.             @list($galaxy, $system, $row) = explode(".", $coordinates);
    1427. 

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

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

  1429.             intval($row) >= 1 && intval($row) <= 15) {
    1430. 

  1430.             $coordinates_ok = $coordinates;
    1431. 

  1431.         }
    1432. 

  1432.     }
    1433. 

  1433. 

  1434.     if (!isset($planet_id)) {
    1435. 

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

  1436.     }
    1437. 

  1437.     $planet_id = intval($planet_id);
    1438. 

  1438.     if (($pub_view == "planets" && ($planet_id < 1 || $planet_id > 9)) || ($pub_view ==
    1439. 

  1439.         "lunes" && ($planet_id < 10 || $planet_id > 18))) {
    1440. 

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

  1441.     }
    1442. 

  1442. 

  1443.     $link_defence = array($lang_defence["LM"] => "LM", $lang_defence["LLE"] => "LLE",
    1444. 

  1444.         $lang_defence["LLO"] => "LLO", $lang_defence["CG"] => "CG", $lang_defence["AI"] =>
    1445. 

  1445.         "AI", $lang_defence["LP"] => "LP", $lang_defence["PB"] => "PB", $lang_defence["GB"] =>
    1446. 

  1446.         "GB", $lang_defence["MIC"] => "MIC", $lang_defence["MIP"] => "MIP");
    1447. 

  1447. 

  1448.     $defences = array("LM" => 0, "LLE" => 0, "LLO" => 0, "CG" => 0, "AI" => 0, "LP" =>
    1449. 

  1449.         0, "PB" => 0, "GB" => 0, "MIC" => 0, "MIP" => 0);
    1450. 

  1450. 

  1451.     $lines = explode(chr(10), str_replace('.', '', $data));
    1452. 

  1452. 

  1453.     $OK = false;
    1454. 

  1454.     foreach ($lines as $line) {
    1455. 

  1455.         $arr = array();
    1456. 

  1456.         $line = trim($line);
    1457. 

  1457. 

  1458.         if (ereg("^(.*) \(([[:space:][:digit:]]{1,9}|[[:digit:]]{1,9}) disponible", $line,
    1459. 

  1459.             $arr)) {
    1460. 

  1460.             list($string, $defence, $level) = $arr;
    1461. 

  1461. 

  1462.             $defence = trim($defence);
    1463. 

  1463.             $level = trim(str_replace("disponible(s)", "", $level));
    1464. 

  1464. 

  1465.             if (isset($link_defence[$defence])) {
    1466. 

  1466.                 $OK = true;
    1467. 

  1467.                 $defences[$link_defence[$defence]] = $level;
    1468. 

  1468.             }
    1469. 

  1469.         }
    1470. 

  1470.     }
    1471. 

  1471. 

  1472.     if ($OK) {
    1473. 

  1473.         $request = "delete from " . TABLE_USER_DEFENCE . " where user_id = " . $user_data["user_id"] .
    1474. 

  1474.             " and planet_id= " . $planet_id;
    1475. 

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

  1476. 

  1477.         $request = "insert into " . TABLE_USER_DEFENCE .
    1478. 

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

  1479.         $request .= " values (" . $user_data["user_id"] . ", " . $planet_id . ", " . $defences["LM"] .
    1480. 

  1480.             ", " . $defences["LLE"] . "," . $defences["LLO"] . ", " . $defences["CG"] . ", " .
    1481. 

  1481.             $defences["AI"] . ", " . $defences["LP"] . ", " . $defences["PB"] . ", " . $defences["GB"] .
    1482. 

  1482.             ", " . $defences["MIC"] . ", " . $defences["MIP"] . ")";
    1483. 

  1483.         $db->sql_query($request);
    1484. 

  1484.     } else {
    1485. 

  1485.         $request = "update " . TABLE_USER_BUILDING . " set planet_name = '" .
    1486. 

  1486.              $db->sql_escape_string($planet_name) . "', coordinates = '" . $coordinates_ok .
    1487. 

  1487.             "', `fields` = " . $fields . ", temperature_min = " . $temperature_min .
    1488. 

  1488.             ", temperature_max = " . $temperature_max . ", Sat = " . $satellite .
    1489. 

  1489.             " where user_id = " . $user_data["user_id"] . " and planet_id = " . $planet_id;
    1490. 

  1490.         $db->sql_query($request);
    1491. 

  1491.     }
    1492. 

  1492. 

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

  1494. }
    1495. 

  1495. 

  1496. /**
    1497. 

  1497.  * Récupération des données empire de l'utilisateur loggé
    1498. 

  1498.  * @comment On pourrait mettre un paramčte $user_id optionnel
    1499. 

  1499.  */
    1500. 

  1500. function user_get_empire()
    1501. 

  1501. {
    1502. 

  1502.     global $db, $user_data;
    1503. 

  1503. 

  1504. 

  1505.     $planet = array(false, "user_id" => "", "planet_name" => "", "coordinates" => "",
    1506. 

  1506.         "fields" => "", "fields_used" => "", "temperature_min" => "", "temperature_max" =>
    1507. 

  1507.         "", "Sat" => "", "M" => 0, "C" => 0, "D" => 0, "CES" => 0, "CEF" => 0, "UdR" =>
    1508. 

  1508.         0, "UdN" => 0, "CSp" => 0, "HM" => 0, "HC" => 0, "HD" => 0, "CM" => 0,"CC" => 0,"CD" => 0,
    1509. 

  1509.         "Lab" => 0, "Ter" => 0, "Silo" => 0, "BaLu" => 0, "Pha" => 0, "PoSa" => 0, "DdR" => 0);
    1510. 

  1510. 

  1511.     $defence = array("LM" => 0, "LLE" => 0, "LLO" => 0, "CG" => 0, "AI" => 0, "LP" =>
    1512. 

  1512.         0, "PB" => 0, "GB" => 0, "MIC" => 0, "MIP" => 0);
    1513. 

  1513. 

  1514. 

  1515.     // pour affichage on selectionne 9 planetes minis
    1516. 

  1516. 

  1517.     if (find_nb_planete_user() < 9) {
    1518. 

  1518.         $nb_planete = 9;
    1519. 

  1519.     } else {
    1520. 

  1520.         $nb_planete = find_nb_planete_user();
    1521. 

  1521.     }
    1522. 

  1522. 

  1523. 

  1524.     // on met les planete a 0
    1525. 

  1525.     for ($i = 101; $i <= ($nb_planete + 100); $i++) {
    1526. 

  1526.         $user_building[$i] = $planet;
    1527. 

  1527.     }
    1528. 

  1528. 

  1529.     // on met les lunes a 0
    1530. 

  1530.     for ($i = 201; $i <= ($nb_planete + 200); $i++) {
    1531. 

  1531.         $user_building[$i] = $planet;
    1532. 

  1532.     }
    1533. 

  1533. 

  1534. 

  1535.     $request = "select planet_id, planet_name, `coordinates`, `fields`, temperature_min, temperature_max, Sat, M, C, D, CES, CEF, UdR, UdN, CSp, HM, HC, HD, CM, CC, CD, Lab, Ter, Silo, BaLu, Pha, PoSa, DdR";
    1536. 

  1536.     $request .= " from " . TABLE_USER_BUILDING;
    1537. 

  1537.     $request .= " where user_id = " . $user_data["user_id"];
    1538. 

  1538.     $request .= " order by planet_id";
    1539. 

  1539.     $result = $db->sql_query($request);
    1540. 

  1540. 

  1541. 

  1542.     //	$user_building = array_fill(101,$nb_planete , $planet);
    1543. 

  1543.     while ($row = $db->sql_fetch_assoc($result)) {
    1544. 

  1544.         $arr = $row;
    1545. 

  1545.         unset($arr["planet_id"]);
    1546. 

  1546.         unset($arr["planet_name"]);
    1547. 

  1547.         unset($arr["coordinates"]);
    1548. 

  1548.         unset($arr["fields"]);
    1549. 

  1549.         unset($arr["temperature_min"]);
    1550. 

  1550.         unset($arr["temperature_max"]);
    1551. 

  1551.         unset($arr["Sat"]);
    1552. 

  1552.         $fields_used = array_sum(array_values($arr));
    1553. 

  1553. 

  1554. 

  1555.         $row["fields_used"] = $fields_used;
    1556. 

  1556.         $user_building[$row["planet_id"]] = $row;
    1557. 

  1557.         $user_building[$row["planet_id"]][0] = true;
    1558. 

  1558.     }
    1559. 

  1559. 

  1560. 

  1561.     $request = "select Esp, Ordi, Armes, Bouclier, Protection, NRJ, Hyp, RC, RI, PH, Laser, Ions, Plasma, RRI, Graviton, Astrophysique";
    1562. 

  1562.     $request .= " from " . TABLE_USER_TECHNOLOGY;
    1563. 

  1563.     $request .= " where user_id = " . $user_data["user_id"];
    1564. 

  1564.     $result = $db->sql_query($request);
    1565. 

  1565. 

  1566.     $user_technology = $db->sql_fetch_assoc($result);
    1567. 

  1567. 

  1568.     $request = "select planet_id, LM, LLE, LLO, CG, AI, LP, PB, GB, MIC, MIP";
    1569. 

  1569.     $request .= " from " . TABLE_USER_DEFENCE;
    1570. 

  1570.     $request .= " where user_id = " . $user_data["user_id"];
    1571. 

  1571.     $request .= " order by planet_id";
    1572. 

  1572.     $result = $db->sql_query($request);
    1573. 

  1573. 

  1574. 

  1575.     // on met les def planete a 0
    1576. 

  1576.     for ($i = 101; $i <= ($nb_planete + 100); $i++) {
    1577. 

  1577.         $user_defence[$i] = $defence;
    1578. 

  1578.     }
    1579. 

  1579. 

  1580.     // on met les def lunes a 0
    1581. 

  1581.     for ($i = 201; $i <= ($nb_planete + 200); $i++) {
    1582. 

  1582.         $user_defence[$i] = $defence;
    1583. 

  1583.     }
    1584. 

  1584. 

  1585.     //$user_defence = array_fill(1, $nb_planete_lune, $defence);
    1586. 

  1586.     while ($row = $db->sql_fetch_assoc($result)) {
    1587. 

  1587.         $planet_id = $row["planet_id"];
    1588. 

  1588.         unset($row["planet_id"]);
    1589. 

  1589.         $user_defence[$planet_id] = $row;
    1590. 

  1590.     }
    1591. 

  1591. 

  1592.     return array("building" => $user_building, "technology" => $user_technology,
    1593. 

  1593.         "defence" => $user_defence, );
    1594. 

  1594. }
    1595. 

  1595. /**
    1596. 

  1596.  * Récuperation du nombre de  planete de l utilisateur
    1597. 

  1597.  * TODO => cette fonction sera a mettre en adequation avec astro 
    1598. 

  1598.  * ( attention ancien uni techno a 1 planete mais utilisateur 9 possible  !!!!!)
    1599. 

  1599.  */
    1600. 

  1600. function find_nb_planete_user()
    1601. 

  1601. {
    1602. 

  1602.     global $db, $user_data;
    1603. 

  1603. 

  1604. 

  1605.     $request = "select planet_id ";
    1606. 

  1606.     $request .= " from " . TABLE_USER_BUILDING;
    1607. 

  1607.     $request .= " where user_id = " . $user_data["user_id"];
    1608. 

  1608.     $request .= " and planet_id < 199 ";
    1609. 

  1609.     $request .= " order by planet_id";
    1610. 

  1610. 

  1611.     $result = $db->sql_query($request);
    1612. 

  1612. 

  1613.     //mini 9 pour eviter bug affichage
    1614. 

  1614.     if ($db->sql_numrows($result) <= 9)
    1615. 

  1615.         return 9;
    1616. 

  1616. 

  1617.     return $db->sql_numrows($result);
    1618. 

  1618. 

  1619. }
    1620. 

  1620. function find_nb_moon_user()
    1621. 

  1621. {
    1622. 

  1622.     global $db, $user_data;
    1623. 

  1623. 

  1624. 

  1625.     $request = "select planet_id ";
    1626. 

  1626.     $request .= " from " . TABLE_USER_BUILDING;
    1627. 

  1627.     $request .= " where user_id = " . $user_data["user_id"];
    1628. 

  1628.     $request .= " and planet_id > 199 ";
    1629. 

  1629.     $request .= " order by planet_id";
    1630. 

  1630. 

  1631.     $result = $db->sql_query($request);
    1632. 

  1632. 

  1633.     //mini 9 pour eviter bug affichage
    1634. 

  1634.     if ($db->sql_numrows($result) <= 9)
    1635. 

  1635.         return 9;
    1636. 

  1636. 

  1637.     return $db->sql_numrows($result);
    1638. 

  1638. 

  1639. }
    1640. 

  1640. 

  1641. /**
    1642. 

  1642.  * Suppression des données de batiments de l'utilisateur loggé
    1643. 

  1643.  */
    1644. 

  1644. function user_del_building()
    1645. 

  1645. {
    1646. 

  1646.     global $db, $user_data;
    1647. 

  1647.     global $pub_planet_id, $pub_view;
    1648. 

  1648. 

  1649.     if (!check_var($pub_planet_id, "Num")) {
    1650. 

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

  1651.     }
    1652. 

  1652.     if (!isset($pub_planet_id)) {
    1653. 

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

  1654.     }
    1655. 

  1655. 

  1656.     $request = "delete from " . TABLE_USER_BUILDING . " where user_id = " . $user_data["user_id"] .
    1657. 

  1657.         " and planet_id = " . intval($pub_planet_id);
    1658. 

  1658.     $db->sql_query($request);
    1659. 

  1659. 

  1660.     $request = "delete from " . TABLE_USER_DEFENCE . " where user_id = " . $user_data["user_id"] .
    1661. 

  1661.         " and planet_id = " . intval($pub_planet_id);
    1662. 

  1662.     $db->sql_query($request);
    1663. 

  1663. 

  1664.     // si on supprime une planete; la lune doit suivre
    1665. 

  1665.     if (intval($pub_planet_id) < 199) {
    1666. 

  1666.         $moon_id = (intval($pub_planet_id) + 100);
    1667. 

  1667.         $request = "delete from " . TABLE_USER_BUILDING . " where user_id = " . $user_data["user_id"] .
    1668. 

  1668.             " and planet_id = " . intval($moon_id);
    1669. 

  1669.         $db->sql_query($request);
    1670. 

  1670. 

  1671.         $request = "delete from " . TABLE_USER_DEFENCE . " where user_id = " . $user_data["user_id"] .
    1672. 

  1672.             " and planet_id = " . intval($moon_id);
    1673. 

  1673.         $db->sql_query($request);
    1674. 

  1674.     }
    1675. 

  1675. 

  1676.     $request = "select * from " . TABLE_USER_BUILDING . " where planet_id <= 199";
    1677. 

  1677.     $result = $db->sql_query($request);
    1678. 

  1678.     if ($db->sql_numrows($result) == 0) {
    1679. 

  1679.         $request = "delete from " . TABLE_USER_TECHNOLOGY . " where user_id = " . $user_data["user_id"];
    1680. 

  1680.         $db->sql_query($request);
    1681. 

  1681.     }
    1682. 

  1682. 

  1683.     // remise en ordre des planetes :
    1684. 

  1684.     user_set_all_empire_resync_planet();
    1685. 

  1685. 

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

  1687. }
    1688. 

  1688. /**
    1689. 

  1689.  * Déplacement des données de plančte de la page empire
    1690. 

  1690.  */
    1691. 

  1691. function user_move_empire()
    1692. 

  1692. {
    1693. 

  1693.     global $db, $user_data;
    1694. 

  1694.     global $pub_planet_id, $pub_left, $pub_right;
    1695. 

  1695. 

  1696.     $nb_planete = find_nb_planete_user();
    1697. 

  1697. 

  1698.     if (!check_var($pub_planet_id, "Num")) {
    1699. 

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

  1700.     }
    1701. 

  1701.     if (!isset($pub_planet_id) || (!isset($pub_left) && !isset($pub_right))) {
    1702. 

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

  1703.     }
    1704. 

  1704. 

  1705.     $pub_planet_id = intval($pub_planet_id);
    1706. 

  1706.     if ($pub_planet_id < 101 || $pub_planet_id > (100 + $nb_planete)) {
    1707. 

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

  1708.     }
    1709. 

  1709.     if (isset($pub_left)) {
    1710. 

  1710.         if ($pub_planet_id == 101)
    1711. 

  1711.             redirection("index.php?action=home&subaction=empire");
    1712. 

  1712.         $new_position = $pub_planet_id - 1;
    1713. 

  1713.     } elseif (isset($pub_right)) {
    1714. 

  1714.         if ($pub_planet_id == (100 + $nb_planete))
    1715. 

  1715.             redirection("index.php?action=home&subaction=empire");
    1716. 

  1716.         $new_position = $pub_planet_id + 1;
    1717. 

  1717.     }
    1718. 

  1718. 

  1719.     $request = "update " . TABLE_USER_BUILDING . " set planet_id = -" . $new_position .
    1720. 

  1720.         " where user_id = " . $user_data["user_id"] . " and planet_id = " . $pub_planet_id;
    1721. 

  1721.     $db->sql_query($request);
    1722. 

  1722. 

  1723.     $request = "update " . TABLE_USER_BUILDING . " set planet_id = " . $pub_planet_id .
    1724. 

  1724.         " where user_id = " . $user_data["user_id"] . " and planet_id = " . $new_position;
    1725. 

  1725.     $db->sql_query($request);
    1726. 

  1726. 

  1727.     $request = "update " . TABLE_USER_BUILDING . " set planet_id = " . $new_position .
    1728. 

  1728.         " where user_id = " . $user_data["user_id"] . " and planet_id = -" . $new_position;
    1729. 

  1729.     $db->sql_query($request);
    1730. 

  1730. 

  1731. 

  1732.     $request = "update " . TABLE_USER_DEFENCE . " set planet_id = -" . $new_position .
    1733. 

  1733.         " where user_id = " . $user_data["user_id"] . " and planet_id = " . $pub_planet_id;
    1734. 

  1734.     $db->sql_query($request);
    1735. 

  1735. 

  1736.     $request = "update " . TABLE_USER_DEFENCE . " set planet_id = " . $pub_planet_id .
    1737. 

  1737.         " where user_id = " . $user_data["user_id"] . " and planet_id = " . $new_position;
    1738. 

  1738.     $db->sql_query($request);
    1739. 

  1739. 

  1740.     $request = "update " . TABLE_USER_DEFENCE . " set planet_id = " . $new_position .
    1741. 

  1741.         " where user_id = " . $user_data["user_id"] . " and planet_id = -" . $new_position;
    1742. 

  1742.     $db->sql_query($request);
    1743. 

  1743. 

  1744. 

  1745.     // remise en ordre des planetes :
    1746. 

  1746.     user_set_all_empire_resync_planet();
    1747. 

  1747. 

  1748.     redirection("index.php?action=home&subaction=empire");
    1749. 

  1749. }
    1750. 

  1750. 

  1751. /**
    1752. 

  1752.  * Ajout d'un systčme favori
    1753. 

  1753.  */
    1754. 

  1754. function user_add_favorite()
    1755. 

  1755. {
    1756. 

  1756.     global $db, $user_data, $server_config;
    1757. 

  1757.     global $pub_galaxy, $pub_system;
    1758. 

  1758. 

  1759.     if (!isset($pub_galaxy) || !isset($pub_system)) {
    1760. 

  1760.         redirection("index.php");
    1761. 

  1761.     }
    1762. 

  1762.     if (intval($pub_galaxy) < 1 || intval($pub_galaxy) > intval($server_config['num_of_galaxies']) ||
    1763. 

  1763.         intval($pub_system) < 1 || intval($pub_system) > intval($server_config['num_of_systems'])) {
    1764. 

  1764.         redirection("index.php?action=galaxy");
    1765. 

  1765.     }
    1766. 

  1766. 

  1767.     $request = "select * from " . TABLE_USER_FAVORITE . " where user_id = " . $user_data["user_id"];
    1768. 

  1768.     $result = $db->sql_query($request);
    1769. 

  1769.     $nb_favorites = $db->sql_numrows($result);
    1770. 

  1770. 

  1771.     if ($nb_favorites < $server_config["max_favorites"]) {
    1772. 

  1772.         $request = "insert ignore into " . TABLE_USER_FAVORITE .
    1773. 

  1773.             " (user_id, galaxy, system) values (" . $user_data["user_id"] . ", '" . $pub_galaxy .
    1774. 

  1774.             "', " . $pub_system . ")";
    1775. 

  1775.         $db->sql_query($request);
    1776. 

  1776.         redirection("index.php?action=galaxy&galaxy=" . $pub_galaxy . "&system=" . $pub_system);
    1777. 

  1777.     } else {
    1778. 

  1778.         redirection("index.php?action=message&id_message=max_favorites&info");
    1779. 

  1779.     }
    1780. 

  1780. }
    1781. 

  1781. 

  1782. /**
    1783. 

  1783.  * Suppression d'un systčme favori
    1784. 

  1784.  */
    1785. 

  1785. function user_del_favorite()
    1786. 

  1786. {
    1787. 

  1787.     global $db, $user_data;
    1788. 

  1788.     global $pub_galaxy, $pub_system, $server_config;
    1789. 

  1789. 

  1790.     if (!isset($pub_galaxy) || !isset($pub_system)) {
    1791. 

  1791.         redirection("index.php");
    1792. 

  1792.     }
    1793. 

  1793.     if (intval($pub_galaxy) < 1 || intval($pub_galaxy) > intval($server_config['num_of_galaxies']) ||
    1794. 

  1794.         intval($pub_system) < 1 || intval($pub_system) > intval($server_config['num_of_systems'])) {
    1795. 

  1795.         redirection("index.php?action=galaxy");
    1796. 

  1796.     }
    1797. 

  1797.     $request = "delete from " . TABLE_USER_FAVORITE . " where user_id = " . $user_data["user_id"] .
    1798. 

  1798.         " and galaxy = '" . $pub_galaxy . "' and system = " . $pub_system;
    1799. 

  1799.     $db->sql_query($request);
    1800. 

  1800. 

  1801.     redirection("index.php?action=galaxy&galaxy=" . $pub_galaxy . "&system=" . $pub_system .
    1802. 

  1802.         "");
    1803. 

  1803. }
    1804. 

  1804. 

  1805. /**
    1806. 

  1806.  * Récupération des rapports favoris
    1807. 

  1807.  */
    1808. 

  1808. function user_getfavorites_spy()
    1809. 

  1809. {
    1810. 

  1810.     global $db, $user_data;
    1811. 

  1811.     global $sort, $sort2;
    1812. 

  1812. 

  1813.     if (!isset($sort) || !isset($sort2) || !is_numeric($sort) || !is_numeric($sort2)) {
    1814. 

  1814.         $orderby = "dateRE desc";
    1815. 

  1815.     } else {
    1816. 

  1816.         switch ($sort2) {
    1817. 

  1817.             case 0:
    1818. 

  1818.                 $order .= " desc";
    1819. 

  1819.                 break;
    1820. 

  1820.             case 1:
    1821. 

  1821.                 $order .= " asc";
    1822. 

  1822.                 break;
    1823. 

  1823.             default:
    1824. 

  1824.                 $order .= " asc";
    1825. 

  1825.         }
    1826. 

  1826. 

  1827.         switch ($sort) {
    1828. 

  1828.             case 1:
    1829. 

  1829.                 $orderby = "coordinates" . $order . "";
    1830. 

  1830.                 break;
    1831. 

  1831.             case 2:
    1832. 

  1832.                 $orderby = "ally " . $order;
    1833. 

  1833.                 break;
    1834. 

  1834.             case 3:
    1835. 

  1835.                 $orderby = "player " . $order;
    1836. 

  1836.                 break;
    1837. 

  1837.             case 4:
    1838. 

  1838.                 $orderby = "moon " . $order;
    1839. 

  1839.                 break;
    1840. 

  1840.             case 5:
    1841. 

  1841.                 $orderby = "dateRE " . $order;
    1842. 

  1842.                 break;
    1843. 

  1843.             default:
    1844. 

  1844.                 $orderby = "dateRE " . $order;
    1845. 

  1845.         }
    1846. 

  1846.     }
    1847. 

  1847. 

  1848.     $favorite = array();
    1849. 

  1849. 

  1850.     $request = "select " . TABLE_PARSEDSPY .
    1851. 

  1851.         ".id_spy, coordinates, dateRE, sender_id, " . TABLE_UNIVERSE . ".moon, " .
    1852. 

  1852.         TABLE_UNIVERSE . ".ally, " . TABLE_UNIVERSE . ".player, " . TABLE_UNIVERSE .
    1853. 

  1853.         ".status";
    1854. 

  1854.     $request .= " from " . TABLE_PARSEDSPY . ", " . TABLE_USER_SPY . ", " .
    1855. 

  1855.         TABLE_UNIVERSE;
    1856. 

  1856.     $request .= " where user_id = " . $user_data["user_id"] . " and CONCAT(" .
    1857. 

  1857.         TABLE_UNIVERSE . ".galaxy,':'," . TABLE_UNIVERSE . ".system,':'," .
    1858. 

  1858.         TABLE_UNIVERSE . ".row)=coordinates and " . TABLE_USER_SPY . ".spy_id=" .
    1859. 

  1859.         TABLE_PARSEDSPY . ".id_spy";
    1860. 

  1860.     $request .= " order by " . $orderby;
    1861. 

  1861.     $result = $db->sql_query($request);
    1862. 

  1862. 

  1863.     while (list($spy_id, $coordinates, $datadate, $sender_id, $moon, $ally, $player,
    1864. 

  1864.         $status) = $db->sql_fetch_row($result)) {
    1865. 

  1865.         $request = "select user_name from " . TABLE_USER;
    1866. 

  1866.         $request .= " where user_id=" . $sender_id;
    1867. 

  1867.         $result_2 = $db->sql_query($request);
    1868. 

  1868.         list($user_name) = $db->sql_fetch_row($result_2);
    1869. 

  1869.         $favorite[$spy_id] = array("spy_id" => $spy_id, "spy_galaxy" => substr($coordinates,
    1870. 

  1870.             0, strpos($coordinates, ':')), "spy_system" => substr($coordinates, strpos($coordinates,
    1871. 

  1871.             ':') + 1, strrpos($coordinates, ':') - strpos($coordinates, ':') - 1), "spy_row" =>
    1872. 

  1872.             substr($coordinates, strrpos($coordinates, ':') + 1), "player" => $player,
    1873. 

  1873.             "ally" => $ally, "moon" => $moon, "status" => $status, "datadate" => $datadate,
    1874. 

  1874.             "poster" => $user_name);
    1875. 

  1875.     }
    1876. 

  1876. 

  1877.     return $favorite;
    1878. 

  1878. }
    1879. 

  1879. 

  1880. /**
    1881. 

  1881.  * Ajout d'un rapport favori
    1882. 

  1882.  */
    1883. 

  1883. function user_add_favorite_spy()
    1884. 

  1884. {
    1885. 

  1885.     global $db, $user_data, $server_config;
    1886. 

  1886.     global $pub_spy_id, $pub_galaxy, $pub_system, $pub_row;
    1887. 

  1887. 

  1888.     if (!check_var($pub_spy_id, "Num")) {
    1889. 

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

  1890.     }
    1891. 

  1891. 

  1892.     if (!isset($pub_spy_id)) {
    1893. 

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

  1894.     }
    1895. 

  1895. 

  1896.     $request = "select * from " . TABLE_USER_SPY . " where user_id = " . $user_data["user_id"];
    1897. 

  1897.     $result = $db->sql_query($request);
    1898. 

  1898.     $nb_favorites = $db->sql_numrows($result);
    1899. 

  1899. 

  1900.     if ($nb_favorites < $server_config["max_favorites_spy"]) {
    1901. 

  1901.         $request = "insert ignore into " . TABLE_USER_SPY .
    1902. 

  1902.             " (user_id, spy_id) values (" . $user_data["user_id"] . ", " . $pub_spy_id . ")";
    1903. 

  1903.         $db->sql_query($request);
    1904. 

  1904.         redirection("index.php?action=show_reportspy&galaxy=" . $pub_galaxy . "&system=" .
    1905. 

  1905.             $pub_system . "&row=" . $pub_row);
    1906. 

  1906.     } else {
    1907. 

  1907.         redirection("index.php?action=message&id_message=max_favorites&info=_spy");
    1908. 

  1908.     }
    1909. 

  1909. }
    1910. 

  1910. 

  1911. /**
    1912. 

  1912.  * Suppression d'un rapport favori
    1913. 

  1913.  */
    1914. 

  1914. function user_del_favorite_spy()
    1915. 

  1915. {
    1916. 

  1916.     global $db, $user_data;
    1917. 

  1917.     global $pub_spy_id, $pub_galaxy, $pub_system, $pub_row, $pub_info;
    1918. 

  1918. 

  1919.     if (!check_var($pub_spy_id, "Num")) {
    1920. 

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

  1921.     }
    1922. 

  1922. 

  1923.     if (!isset($pub_spy_id)) {
    1924. 

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

  1925.     }
    1926. 

  1926. 

  1927.     $request = "delete from " . TABLE_USER_SPY . " where user_id = " . $user_data["user_id"] .
    1928. 

  1928.         " and spy_id = '" . $pub_spy_id . "'";
    1929. 

  1929.     $db->sql_query($request);
    1930. 

  1930. 

  1931.     if (!isset($pub_info))
    1932. 

  1932.         $pub_info = 1;
    1933. 

  1933. 

  1934.     switch ($pub_info) {
    1935. 

  1935.         case 2:
    1936. 

  1936.             redirection("index.php?action=show_reportspy&galaxy=" . $pub_galaxy . "&system=" .
    1937. 

  1937.                 $pub_system . "&row=" . $pub_row);
    1938. 

  1938.         case 1:
    1939. 

  1939.             redirection("index.php?action=home&subaction=spy");
    1940. 

  1940.         default:
    1941. 

  1941.             return true;
    1942. 

  1942.     }
    1943. 

  1943. }
    1944. 

  1944. 

  1945. /**
    1946. 

  1946.  * Création d'un groupe
    1947. 

  1947.  */
    1948. 

  1948. function usergroup_create()
    1949. 

  1949. {
    1950. 

  1950.     global $db, $user_data;
    1951. 

  1951.     global $pub_groupname;
    1952. 

  1952. 

  1953.     if (!isset($pub_groupname)) {
    1954. 

  1954.         redirection("index.php?action=message&id_message=createusergroup_failed_general&info");
    1955. 

  1955.     }
    1956. 

  1956. 

  1957.     //Vérification des droits
    1958. 

  1958.     user_check_auth("usergroup_manage");
    1959. 

  1959. 

  1960.     if (!check_var($pub_groupname, "Pseudo_Groupname")) {
    1961. 

  1961.         redirection("index.php?action=message&id_message=createusergroup_failed_groupname&info");
    1962. 

  1962.     }
    1963. 

  1963. 

  1964.     $request = "select group_id from " . TABLE_GROUP . " where group_name = '" .
    1965. 

  1965.          $db->sql_escape_string($pub_groupname) . "'";
    1966. 

  1966.     $result = $db->sql_query($request);
    1967. 

  1967. 

  1968.     if ($db->sql_numrows($result) == 0) {
    1969. 

  1969.         $request = "insert into " . TABLE_GROUP . " (group_name)" . " values ('" .
    1970. 

  1970.              $db->sql_escape_string($pub_groupname) . "')";
    1971. 

  1971.         $db->sql_query($request);
    1972. 

  1972.         $group_id = $db->sql_insertid();
    1973. 

  1973. 

  1974.         log_("create_usergroup", $pub_groupname);
    1975. 

  1975.         redirection("index.php?action=administration&subaction=group&group_id=" . $group_id);
    1976. 

  1976.     } else {
    1977. 

  1977.         redirection("index.php?action=message&id_message=createusergroup_failed_groupnamelocked&info=" .
    1978. 

  1978.             $pub_groupname);
    1979. 

  1979.     }
    1980. 

  1980. }
    1981. 

  1981. 

  1982. /**
    1983. 

  1983.  * Suppression d'un groupe utilisateur
    1984. 

  1984.  */
    1985. 

  1985. function usergroup_delete()
    1986. 

  1986. {
    1987. 

  1987.     global $db, $user_data;
    1988. 

  1988.     global $pub_group_id;
    1989. 

  1989. 

  1990.     if (!check_var($pub_group_id, "Num")) {
    1991. 

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

  1992.     }
    1993. 

  1993. 

  1994.     if (!isset($pub_group_id)) {
    1995. 

  1995.         redirection("index.php?action=message&id_message=createusergroup_failed_general&info");
    1996. 

  1996.     }
    1997. 

  1997. 

  1998.     //Vérification des droits
    1999. 

  1999.     user_check_auth("usergroup_manage");
    2000. 

  2000. 

  2001.     if ($pub_group_id == 1) {
    2002. 

  2002.         redirection("index.php?action=administration&subaction=group&group_id=1");
    2003. 

  2003.     }
    2004. 

  2004. 

  2005.     log_("delete_usergroup", $pub_group_id);
    2006. 

  2006. 

  2007.     $request = "delete from " . TABLE_USER_GROUP . " where group_id = " . intval($pub_group_id);
    2008. 

  2008.     $db->sql_query($request);
    2009. 

  2009. 

  2010.     $request = "delete from " . TABLE_GROUP . " where group_id = " . intval($pub_group_id);
    2011. 

  2011.     $db->sql_query($request);
    2012. 

  2012. 

  2013.     redirection("index.php?action=administration&subaction=group");
    2014. 

  2014. }
    2015. 

  2015. 

  2016. /**
    2017. 

  2017.  * Récupération des droits d'un groupe d'utilisateurs
    2018. 

  2018.  */
    2019. 

  2019. function usergroup_get($group_id = false)
    2020. 

  2020. {
    2021. 

  2021.     global $db, $user_data;
    2022. 

  2022. 

  2023.     //Vérification des droits
    2024. 

  2024.     user_check_auth("usergroup_manage");
    2025. 

  2025. 

  2026.     $request = "select group_id, group_name, ";
    2027. 

  2027.     $request .= " server_set_system, server_set_spy, server_set_rc, server_set_ranking, server_show_positionhided,";
    2028. 

  2028.     $request .= " ogs_connection, ogs_set_system, ogs_get_system, ogs_set_spy, ogs_get_spy, ogs_set_ranking, ogs_get_ranking";
    2029. 

  2029.     $request .= " from " . TABLE_GROUP;
    2030. 

  2030. 

  2031.     if ($group_id !== false) {
    2032. 

  2032.         if (intval($group_id) == 0)
    2033. 

  2033.             return false;
    2034. 

  2034.         $request .= " where group_id = " . $group_id;
    2035. 

  2035.     }
    2036. 

  2036.     $request .= " order by group_name";
    2037. 

  2037.     $result = $db->sql_query($request);
    2038. 

  2038. 

  2039.     if (!$group_id) {
    2040. 

  2040.         $info_usergroup = array();
    2041. 

  2041.         while ($row = $db->sql_fetch_assoc()) {
    2042. 

  2042.             $info_usergroup[] = $row;
    2043. 

  2043.         }
    2044. 

  2044.     } else {
    2045. 

  2045.         while ($row = $db->sql_fetch_assoc()) {
    2046. 

  2046.             $info_usergroup = $row;
    2047. 

  2047.         }
    2048. 

  2048.     }
    2049. 

  2049. 

  2050.     if (sizeof($info_usergroup) == 0) {
    2051. 

  2051.         return false;
    2052. 

  2052.     }
    2053. 

  2053. 

  2054.     return $info_usergroup;
    2055. 

  2055. }
    2056. 

  2056. /**
    2057. 

  2057.  * Enregistrement des droits d'un groupe utilisateurs
    2058. 

  2058.  */
    2059. 

  2059. function usergroup_setauth()
    2060. 

  2060. {
    2061. 

  2061.     global $db, $user_data;
    2062. 

  2062.     global $pub_group_id, $pub_group_name, $pub_server_set_system, $pub_server_set_spy,
    2063. 

  2063.         $pub_server_set_rc, $pub_server_set_ranking, $pub_server_show_positionhided, $pub_ogs_connection,
    2064. 

  2064.         $pub_ogs_set_system, $pub_ogs_get_system, $pub_ogs_set_spy, $pub_ogs_get_spy, $pub_ogs_set_ranking,
    2065. 

  2065.         $pub_ogs_get_ranking;
    2066. 

  2066. 

  2067.     if (!check_var($pub_group_id, "Num") || !check_var($pub_group_name,
    2068. 

  2068.         "Pseudo_Groupname") || !check_var($pub_server_set_system, "Num") || !check_var($pub_server_set_spy,
    2069. 

  2069.         "Num") || !check_var($pub_server_set_rc, "Num") || !check_var($pub_server_set_ranking,
    2070. 

  2070.         "Num") || !check_var($pub_server_show_positionhided, "Num") || !check_var($pub_ogs_connection,
    2071. 

  2071.         "Num") || !check_var($pub_ogs_set_system, "Num") || !check_var($pub_ogs_get_system,
    2072. 

  2072.         "Num") || !check_var($pub_ogs_set_spy, "Num") || !check_var($pub_ogs_get_spy,
    2073. 

  2073.         "Num") || !check_var($pub_ogs_set_ranking, "Num") || !check_var($pub_ogs_get_ranking,
    2074. 

  2074.         "Num")) {
    2075. 

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

  2076.     }
    2077. 

  2077. 

  2078.     if (!isset($pub_group_id) || !isset($pub_group_name)) {
    2079. 

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

  2080.     }
    2081. 

  2081. 

  2082.     if (is_null($pub_server_set_system))
    2083. 

  2083.         $pub_server_set_system = 0;
    2084. 

  2084.     if (is_null($pub_server_set_spy))
    2085. 

  2085.         $pub_server_set_spy = 0;
    2086. 

  2086.     if (is_null($pub_server_set_rc))
    2087. 

  2087.         $pub_server_set_rc = 0;
    2088. 

  2088.     if (is_null($pub_server_set_ranking))
    2089. 

  2089.         $pub_server_set_ranking = 0;
    2090. 

  2090.     if (is_null($pub_server_show_positionhided))
    2091. 

  2091.         $pub_server_show_positionhided = 0;
    2092. 

  2092.     if (is_null($pub_ogs_connection))
    2093. 

  2093.         $pub_ogs_connection = 0;
    2094. 

  2094.     if (is_null($pub_ogs_set_system))
    2095. 

  2095.         $pub_ogs_set_system = 0;
    2096. 

  2096.     if (is_null($pub_ogs_get_system))
    2097. 

  2097.         $pub_ogs_get_system = 0;
    2098. 

  2098.     if (is_null($pub_ogs_set_spy))
    2099. 

  2099.         $pub_ogs_set_spy = 0;
    2100. 

  2100.     if (is_null($pub_ogs_get_spy))
    2101. 

  2101.         $pub_ogs_get_spy = 0;
    2102. 

  2102.     if (is_null($pub_ogs_set_ranking))
    2103. 

  2103.         $pub_ogs_set_ranking = 0;
    2104. 

  2104.     if (is_null($pub_ogs_get_ranking))
    2105. 

  2105.         $pub_ogs_get_ranking = 0;
    2106. 

  2106. 

  2107.     //Vérification des droits
    2108. 

  2108.     user_check_auth("usergroup_manage");
    2109. 

  2109. 

  2110.     log_("modify_usergroup", $pub_group_id);
    2111. 

  2111. 

  2112.     $request = "update " . TABLE_GROUP;
    2113. 

  2113.     $request .= " set group_name = '" .  $db->sql_escape_string($pub_group_name) .
    2114. 

  2114.         "',";
    2115. 

  2115.     $request .= " server_set_system = '" . intval($pub_server_set_system) .
    2116. 

  2116.         "', server_set_spy = '" . intval($pub_server_set_spy) . "', server_set_rc = '" .
    2117. 

  2117.         intval($pub_server_set_rc) . "', server_set_ranking = '" . intval($pub_server_set_ranking) .
    2118. 

  2118.         "', server_show_positionhided = '" . intval($pub_server_show_positionhided) .
    2119. 

  2119.         "',";
    2120. 

  2120.     $request .= " ogs_connection = '" . intval($pub_ogs_connection) .
    2121. 

  2121.         "', ogs_set_system = '" . intval($pub_ogs_set_system) . "', ogs_get_system = '" .
    2122. 

  2122.         intval($pub_ogs_get_system) . "', ogs_set_spy = '" . intval($pub_ogs_set_spy) .
    2123. 

  2123.         "', ogs_get_spy = '" . intval($pub_ogs_get_spy) . "', ogs_set_ranking = '" .
    2124. 

  2124.         intval($pub_ogs_set_ranking) . "', ogs_get_ranking = '" . intval($pub_ogs_get_ranking) .
    2125. 

  2125.         "'";
    2126. 

  2126.     $request .= " where group_id = " . intval($pub_group_id);
    2127. 

  2127.     $db->sql_query($request);
    2128. 

  2128. 

  2129.     redirection("index.php?action=administration&subaction=group&group_id=" . $pub_group_id);
    2130. 

  2130. }
    2131. 

  2131. 

  2132. /**
    2133. 

  2133.  * Récupération des utilisateurs appartenant ŕ un groupe
    2134. 

  2134.  * @param int $group_id Identificateur du groupe demandé
    2135. 

  2135.  * @return Array Liste des utilisateurs
    2136. 

  2136.  */
    2137. 

  2137. function usergroup_member($group_id)
    2138. 

  2138. {
    2139. 

  2139.     global $db, $user_data;
    2140. 

  2140. 

  2141.     if (!isset($group_id) || !is_numeric($group_id)) {
    2142. 

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

  2143.     }
    2144. 

  2144. 

  2145.     $usergroup_member = array();
    2146. 

  2146. 

  2147.     $request = "select u.user_id, u.user_name from " . TABLE_USER . " as  u, " .
    2148. 

  2148.         TABLE_USER_GROUP . " as g";
    2149. 

  2149.     $request .= " where u.user_id = g.user_id";
    2150. 

  2150.     $request .= " and g.group_id = " . intval($group_id);
    2151. 

  2151.     $request .= " order by user_name";
    2152. 

  2152.     $result = $db->sql_query($request);
    2153. 

  2153.     while ($row = $db->sql_fetch_assoc()) {
    2154. 

  2154.         $usergroup_member[] = $row;
    2155. 

  2155.     }
    2156. 

  2156. 

  2157.     return $usergroup_member;
    2158. 

  2158. }
    2159. 

  2159. 

  2160. /**
    2161. 

  2161.  * Ajout d'un utilisateur ŕ un groupe
    2162. 

  2162.  */
    2163. 

  2163. function usergroup_newmember()
    2164. 

  2164. {
    2165. 

  2165.     global $db, $user_data;
    2166. 

  2166.     global $pub_user_id, $pub_group_id, $pub_add_all;
    2167. 

  2167. 

  2168.     if ($pub_add_all == "Ajouter tout les membres") {
    2169. 

  2169.         $request = "SELECT user_id FROM " . TABLE_USER;
    2170. 

  2170.         $result = $db->sql_query($request);
    2171. 

  2171. 

  2172.         while ($res = $db->sql_fetch_assoc($result)) {
    2173. 

  2173.             user_check_auth("usergroup_manage");
    2174. 

  2174.             $request = "INSERT IGNORE INTO " . TABLE_USER_GROUP .
    2175. 

  2175.                 " (group_id, user_id) values (" . intval($pub_group_id) . ", " . intval($res["user_id"]) .
    2176. 

  2176.                 ")";
    2177. 

  2177.             $db->sql_query($request);
    2178. 

  2178.         }
    2179. 

  2179.         redirection("index.php?action=administration&subaction=group");
    2180. 

  2180.     } else {
    2181. 

  2181.         if (!check_var($pub_user_id, "Num") || !check_var($pub_group_id, "Num")) {
    2182. 

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

  2183.         }
    2184. 

  2184. 

  2185.         if (!isset($pub_user_id) || !isset($pub_group_id)) {
    2186. 

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

  2187.         }
    2188. 

  2188. 

  2189.         //Vérification des droits
    2190. 

  2190.         user_check_auth("usergroup_manage");
    2191. 

  2191. 

  2192.         $request = "select group_id from " . TABLE_GROUP . " where group_id = " . intval($pub_group_id);
    2193. 

  2193.         $result = $db->sql_query($request);
    2194. 

  2194.         if ($db->sql_numrows($result) == 0) {
    2195. 

  2195.             redirection("index.php?action=administration&subaction=group");
    2196. 

  2196.         }
    2197. 

  2197. 

  2198.         $request = "select user_id from " . TABLE_USER . " where user_id = " . intval($pub_user_id);
    2199. 

  2199.         $result = $db->sql_query($request);
    2200. 

  2200.         if ($db->sql_numrows($result) == 0) {
    2201. 

  2201.             redirection("index.php?action=administration&subaction=group");
    2202. 

  2202.         }
    2203. 

  2203. 

  2204.         $request = "insert ignore into " . TABLE_USER_GROUP .
    2205. 

  2205.             " (group_id, user_id) values (" . intval($pub_group_id) . ", " . intval($pub_user_id) .
    2206. 

  2206.             ")";
    2207. 

  2207.         $result = $db->sql_query($request);
    2208. 

  2208. 

  2209.         if ($db->sql_affectedrows() > 0) {
    2210. 

  2210.             log_("add_usergroup", array($pub_group_id, $pub_user_id));
    2211. 

  2211.         }
    2212. 

  2212. 

  2213.         redirection("index.php?action=administration&subaction=group&group_id=" . $pub_group_id);
    2214. 

  2214.     }
    2215. 

  2215. }
    2216. 

  2216. 

  2217. /**
    2218. 

  2218.  * Supression d'un utilisateur d'un groupe
    2219. 

  2219.  * @global int $pub_user_id Identificateur utilisateur
    2220. 

  2220.  * @global int $pub_group_id Identificateur du Groupe
    2221. 

  2221.  */
    2222. 

  2222. function usergroup_delmember()
    2223. 

  2223. {
    2224. 

  2224.     global $db, $user_data;
    2225. 

  2225.     global $pub_user_id, $pub_group_id;
    2226. 

  2226. 

  2227.     if (!isset($pub_user_id) || !isset($pub_group_id)) {
    2228. 

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

  2229.     }
    2230. 

  2230.     if (!check_var($pub_user_id, "Num") || !check_var($pub_group_id, "Num")) {
    2231. 

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

  2232.     }
    2233. 

  2233. 

  2234.     //Vérification des droits
    2235. 

  2235.     user_check_auth("usergroup_manage");
    2236. 

  2236. 

  2237.     $request = "delete from " . TABLE_USER_GROUP . " where group_id = " . intval($pub_group_id) .
    2238. 

  2238.         " and user_id = " . intval($pub_user_id);
    2239. 

  2239.     $result = $db->sql_query($request);
    2240. 

  2240. 

  2241.     if ($db->sql_affectedrows() > 0) {
    2242. 

  2242.         log_("del_usergroup", array($pub_group_id, $pub_user_id));
    2243. 

  2243.     }
    2244. 

  2244. 

  2245.     redirection("index.php?action=administration&subaction=group&group_id=" . $pub_group_id);
    2246. 

  2246. }
    2247. 

  2247. 

  2248. /**
    2249. 

  2249.  * A quoi sert donc cette fonction ? :p
    2250. 

  2250.  * Reponse elle sert a mettre a jour le pseudo ingame afin d afficher les stats users dans son espace perso
    2251. 

  2251.  */
    2252. 

  2252. function user_set_stat_name($user_stat_name)
    2253. 

  2253. {
    2254. 

  2254.     global $db, $user_data;
    2255. 

  2255. 

  2256.     $request = "update " . TABLE_USER . " set user_stat_name = '" . $user_stat_name .
    2257. 

  2257.         "' where user_id = " . $user_data['user_id'];
    2258. 

  2258.     $db->sql_query($request);
    2259. 

  2259. }
    2260. 

  2260. 

  2261. //Suppression d'un rapport d'espionnage
    2262. 

  2262. function user_del_spy()
    2263. 

  2263. {
    2264. 

  2264.     global $db, $user_data;
    2265. 

  2265.     global $pub_spy_id, $pub_galaxy, $pub_system, $pub_row, $pub_info;
    2266. 

  2266. 

  2267.     if (!check_var($pub_spy_id, "Num")) {
    2268. 

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

  2269.     }
    2270. 

  2270. 

  2271.     if (!isset($pub_spy_id)) {
    2272. 

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

  2273.     }
    2274. 

  2274. 

  2275.     if ($user_data["user_admin"] == 1 || $user_data["user_coadmin"] == 1) {
    2276. 

  2276.         $request = "delete from " . TABLE_PARSEDSPY . " where id_spy = '" . $pub_spy_id .
    2277. 

  2277.             "'";
    2278. 

  2278.         $db->sql_query($request);
    2279. 

  2279.     }
    2280. 

  2280. 

  2281.     if (!isset($pub_info))
    2282. 

  2282.         $pub_info = 1;
    2283. 

  2283. 

  2284.     switch ($pub_info) {
    2285. 

  2285.         case 2:
    2286. 

  2286.             redirection("index.php?action=show_reportspy&galaxy=" . $pub_galaxy . "&system=" .
    2287. 

  2287.                 $pub_system . "&row=" . $pub_row);
    2288. 

  2288.         case 1:
    2289. 

  2289.             redirection("index.php?action=home&subaction=spy");
    2290. 

  2290.         default:
    2291. 

  2291.             return true;
    2292. 

  2292.     }
    2293. 

  2293. }
    2294. 

  2294. 

  2295. /**
    2296. 

  2296.  * Parsing des RC
    2297. 

  2297.  * @param string $rawRC RC ŕ parser
    2298. 

  2298.  * @return int $return identifiant du RC
    2299. 

  2299.  */
    2300. 

  2300. function parseRC($rawRC)
    2301. 

  2301. {
    2302. 

  2302.     // Suppression des '\', et gestion des retours charriots/sauts de ligne
    2303. 

  2303.     $rawRC = str_replace('\\', '', ereg_replace("\n|\r|\r\n", " \n", $rawRC));
    2304. 

  2304.     // Suppression des '.' dans les nombres
    2305. 

  2305.     while (preg_match('/\d+\.\d+/', $rawRC))
    2306. 

  2306.         $rawRC = preg_replace('/(\d+)\.(\d+)/', "$1$2", $rawRC);
    2307. 

  2307.     $return = array('dateRC' => '', 'nb_rounds' => 0, 'attaquants' => array(),
    2308. 

  2308.         'defenseur' => array(), 'victoire' => 'A', 'pertes_A' => 0, 'pertes_D' => 0,
    2309. 

  2309.         'gain_M' => -1, 'gain_C' => -1, 'gain_D' => -1, 'debris_M' => -1, 'debris_C' =>
    2310. 

  2310.         -1, 'lune' => 0, 'coordinates' => '1:1:1');
    2311. 

  2311. 

  2312.     // Extraction du timestamp pour la date du RC
    2313. 

  2313.     preg_match('/affrontées le (\d*)-(\d*) (\d*):(\d*):(\d*) \.:/', $rawRC, $reg);
    2314. 

  2314.     $jourRC = trim($reg[2]);
    2315. 

  2315.     $moisRC = trim($reg[1]);
    2316. 

  2316.     $heureRC = trim($reg[3]);
    2317. 

  2317.     $minutesRC = trim($reg[4]);
    2318. 

  2318.     $secondesRC = trim($reg[5]);
    2319. 

  2319.     $return['dateRC'] = mktime($heureRC, $minutesRC, $secondesRC, $moisRC, $jourRC,
    2320. 

  2320.         date('Y'));
    2321. 

  2321. 

  2322.     // Extraction du nom, des coordonnées et des techs de l'attaquant et du défenseur
    2323. 

  2323.     $opponents = array();
    2324. 

  2324.     preg_match_all('/Attaquant (.*) \(\[(.*)\]\)(\s*)Armes: (\d*)% Bouclier: (\d*)% Coque: (\d*)%/',
    2325. 

  2325.         $rawRC, $reg);
    2326. 

  2326.     for ($idx = 0; $idx < sizeof($reg[0]); $idx++) {
    2327. 

  2327.         $return['attaquants'][] = array('pseudo' => $reg[1][$idx], 'coordinates' => $reg[2][$idx],
    2328. 

  2328.             'armes' => $reg[4][$idx], 'bouclier' => $reg[5][$idx], 'protection' => $reg[6][$idx]);
    2329. 

  2329.         $opponents[] = $reg[1][$idx];
    2330. 

  2330.     }
    2331. 

  2331.     preg_match_all('/D.fenseur (.*) \(\[(.*)\]\)(\s*)Armes: (\d*)% Bouclier: (\d*)% Coque: (\d*)%/',
    2332. 

  2332.         $rawRC, $reg);
    2333. 

  2333.     for ($idx = 0; $idx < sizeof($reg[0]); $idx++) {
    2334. 

  2334.         if ($idx == 0)
    2335. 

  2335.             $return['coordinates'] = $reg[2][$idx];
    2336. 

  2336.         $return['defenseurs'][] = array('pseudo' => $reg[1][$idx], 'coordinates' => $reg[2][$idx],
    2337. 

  2337.             'armes' => $reg[4][$idx], 'bouclier' => $reg[5][$idx], 'protection' => $reg[6][$idx]);
    2338. 

  2338.         $opponents[] = $reg[1][$idx];
    2339. 

  2339.     }
    2340. 

  2340. 

  2341.     // Comptage du nombre de roungs
    2342. 

  2342.     $return['nb_rounds'] = substr_count($rawRC, 'attaquante tire') + 1;
    2343. 

  2343. 

  2344.     // Extraction des pertes
    2345. 

  2345.     preg_match('/L\'attaquant a perdu au total (\d*) unit.s/', $rawRC, $reg);
    2346. 

  2346.     $return['pertes_A'] = trim($reg[1]);
    2347. 

  2347.     preg_match('/Le d.fenseur a perdu au total (\d*) unit.s/', $rawRC, $reg);
    2348. 

  2348.     $return['pertes_D'] = trim($reg[1]);
    2349. 

  2349. 

  2350.     // Extraction du champ de débris et du pourcentage de lune
    2351. 

  2351.     preg_match('/Un champ de d.bris contenant (\d*) unit.s de m.tal et (\d*) unit.s de cristal(.*)/',
    2352. 

  2352.         $rawRC, $reg);
    2353. 

  2353.     $return['debris_M'] = trim($reg[1]);
    2354. 

  2354.     $return['debris_C'] = trim($reg[2]);
    2355. 

  2355.     if (preg_match('/une lune est de (\d*)( ?)%/', $rawRC, $reg))
    2356. 

  2356.         $return['lune'] = trim($reg[1]);
    2357. 

  2357. 

  2358.     // Extraction du résultat du RC
    2359. 

  2359.     // A = victoire de l'attaquant
    2360. 

  2360.     // D = victoire du défenseur
    2361. 

  2361.     // N = match nul
    2362. 

  2362.     if (preg_match('/L\'attaquant a gagn. la bataille/', $rawRC)) {
    2363. 

  2363.         $return['victoire'] = 'A';
    2364. 

  2364.         // Extraction des ressources gagnées
    2365. 

  2365.         preg_match('/(\d*) unit.s de m.tal, (\d*) unit.s de cristal et (\d*) unit.s de deut.rium/',
    2366. 

  2366.             $rawRC, $reg);
    2367. 

  2367.         $return['gain_M'] = trim($reg[1]);
    2368. 

  2368.         $return['gain_C'] = trim($reg[2]);
    2369. 

  2369.         $return['gain_D'] = trim($reg[3]);
    2370. 

  2370.     } elseif (preg_match('/Le d.fenseur a gagn. la bataille/', $rawRC))
    2371. 

  2371.         $return['victoire'] = 'D';
    2372. 

  2372.     else
    2373. 

  2373.         $return['victoire'] = 'N';
    2374. 

  2374. 

  2375.     $tmp = parseRCround($rawRC, $return['nb_rounds'], $opponents, $return['victoire']);
    2376. 

  2376. 

  2377.     $idx = 1;
    2378. 

  2378.     foreach ($tmp as $array) {
    2379. 

  2379.         $return['round' . $idx] = $array;
    2380. 

  2380.         $idx++;
    2381. 

  2381.     }
    2382. 

  2382. 

  2383.     return $return;
    2384. 

  2384. }
    2385. 

  2385. 

  2386. /**
    2387. 

  2387.  * Parsing de chaque round des RC
    2388. 

  2388.  * @param string $rawRC RC ŕ analyser
    2389. 

  2389.  * @param int $nb_rounds Nombre de round du RC ŕ analyser
    2390. 

  2390.  * @param array $opponents Tableau contenant le nom de chaque joueur du RC
    2391. 

  2391.  * @return array $row_RC Tableau contenant pour chaque round du RC, les flottes/défenses de chaque joueur
    2392. 

  2392.  */
    2393. 

  2393. function parseRCround($rawRC, $nb_rounds, $opponents, $victoire)
    2394. 

  2394. {
    2395. 

  2395.     $rawRC = preg_replace("/ \n/", '|', $rawRC);
    2396. 

  2396.     $row_RC = array();
    2397. 

  2397.     $row_RC_opponent = array('P.transp.' => -1, 'G.transp.' => -1, 'Ch.léger' => -1,
    2398. 

  2398.         'Ch.lourd' => -1, 'Croiseur' => -1, 'V.bataille' => -1, 'V.colonisation' => -1,
    2399. 

  2399.         'Recycleur' => -1, 'Sonde' => -1, 'Bombardier' => -1, 'Destr.' => -1, 'Rip' => -
    2400. 

  2400.         1, 'Sat.sol.' => -1, 'Traqueur' => -1, 'Missile' => -1, 'L.léger.' => -1,
    2401. 

  2401.         'L.lourd' => -1, 'Can.Gauss' => -1, 'Art.ions' => -1, 'Lanc.plasma' => -1,
    2402. 

  2402.         'P.bouclier' => -1, 'G.bouclier' => -1, );
    2403. 

  2403. 

  2404.     $decoupe = explode('points de dégâts||', $rawRC);
    2405. 

  2405.     for ($idx_round = 0; $idx_round < $nb_rounds; $idx_round++) {
    2406. 

  2406.         $row_RC[$idx_round] = array();
    2407. 

  2407.         for ($idx_opp = 0; $idx_opp < sizeof($opponents); $idx_opp++) {
    2408. 

  2408.             $row_RC[$idx_round][$opponents[$idx_opp]] = $row_RC_opponent;
    2409. 

  2409.             $pattern = '/' . $opponents[$idx_opp] . ' \(\[.*?\]\)\|(Armes: \d*% Bouclier: \d*% Coque: \d*%\|)?Type[ \t](.*?)\|Nombre[ \t](.*?)\|/';
    2410. 

  2410.             preg_match($pattern, $decoupe[$idx_round], $reg);
    2411. 

  2411.             if (isset($reg[2])) {
    2412. 

  2412.                 $flotte = split("[ \t]", chop($reg[2]));
    2413. 

  2413.                 $nombre = split("[ \t]", chop($reg[3]));
    2414. 

  2414.                 foreach ($flotte as $key => $val)
    2415. 

  2415.                     $row_RC[$idx_round][$opponents[$idx_opp]][$val] = $nombre[$key];
    2416. 

  2416.             }
    2417. 

  2417.         }
    2418. 

  2418.         if ($idx_round < $nb_rounds) {
    2419. 

  2419.             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/',
    2420. 

  2420.                 $decoupe[$idx_round], $reg);
    2421. 

  2421.             if (isset($reg[1])) {
    2422. 

  2422.                 $row_RC[$idx_round]['attaque_tir'] = $reg[1];
    2423. 

  2423.                 $row_RC[$idx_round]['attaque_puissance'] = $reg[2];
    2424. 

  2424.                 $row_RC[$idx_round]['defense_bouclier'] = $reg[3];
    2425. 

  2425.             } else {
    2426. 

  2426.                 $row_RC[$idx_round]['attaque_tir'] = 0;
    2427. 

  2427.                 $row_RC[$idx_round]['attaque_puissance'] = 0;
    2428. 

  2428.                 $row_RC[$idx_round]['defense_bouclier'] = 0;
    2429. 

  2429.             }
    2430. 

  2430.             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*)/",
    2431. 

  2431.                 $decoupe[$idx_round], $reg);
    2432. 

  2432.             if (isset($reg[1])) {
    2433. 

  2433.                 $row_RC[$idx_round]['attaque_bouclier'] = $reg[3];
    2434. 

  2434.                 $row_RC[$idx_round]['defense_tir'] = $reg[1];
    2435. 

  2435.                 $row_RC[$idx_round]['defense_puissance'] = $reg[2];
    2436. 

  2436.             } else {
    2437. 

  2437.                 $row_RC[$idx_round]['attaque_bouclier'] = 0;
    2438. 

  2438.                 $row_RC[$idx_round]['defense_tir'] = 0;
    2439. 

  2439.                 $row_RC[$idx_round]['defense_puissance'] = 0;
    2440. 

  2440.             }
    2441. 

  2441.         }
    2442. 

  2442.     }
    2443. 

  2443. 

  2444.     return ($row_RC);
    2445. 

  2445. }
    2446. 

  2446. 

  2447. /**
    2448. 

  2448.  * Reconstruction des RC
    2449. 

  2449.  * @global $db
    2450. 

  2450.  * @param int $id_RC RC ŕ reconstituer
    2451. 

  2451.  * @return string $template_RC reconstitué
    2452. 

  2452.  */
    2453. 

  2453. function UNparseRC($id_RC)
    2454. 

  2454. {
    2455. 

  2455.     global $db;
    2456. 

  2456. 

  2457.     $key_ships = array('PT' => 'P.transp.', 'GT' => 'G.transp.', 'CLE' => 'Ch.léger',
    2458. 

  2458.         'CLO' => 'Ch.lourd', 'CR' => 'Croiseur', 'VB' => 'V.bataille', 'VC' =>
    2459. 

  2459.         'V.colonisation', 'REC' => 'Recycleur', 'SE' => 'Sonde', 'BMD' => 'Bombardier',
    2460. 

  2460.         'DST' => 'Destr.', 'EDLM' => 'Rip', 'SAT' => 'Sat.sol.', 'TRA' => 'Traqueur');
    2461. 

  2461.     $key_defs = array('LM' => 'Missile', 'LLE' => 'L.léger.', 'LLO' => 'L.lourd',
    2462. 

  2462.         'CG' => 'Can.Gauss', 'AI' => 'Art.ions', 'LP' => 'Lanc.plasma', 'PB' =>
    2463. 

  2463.         'P.bouclier', 'GB' => 'G.bouclier');
    2464. 

  2464.     $base_ships = array('PT' => array(4000, 10, 5), 'GT' => array(12000, 25, 5),
    2465. 

  2465.         'CLE' => array(4000, 10, 50), 'CLO' => array(10000, 25, 150), 'CR' => array(27000,
    2466. 

  2466.         50, 400), 'VB' => array(60000, 200, 1000), 'VC' => array(30000, 100, 50), 'REC' =>
    2467. 

  2467.         array(16000, 10, 1), 'SE' => array(1000, 0, 0), 'BMD' => array(75000, 500, 1000),
    2468. 

  2468.         'DST' => array(110000, 500, 2000), 'EDLM' => array(9000000, 50000, 200000),
    2469. 

  2469.         'SAT' => array(2000, 1, 1), 'TRA' => array(70000, 400, 700));
    2470. 

  2470.     $base_defs = array('LM' => array(2000, 20, 80), 'LLE' => array(2000, 25, 100),
    2471. 

  2471.         'LLO' => array(8000, 100, 250), 'CG' => array(35000, 200, 1100), 'AI' => array(8000,
    2472. 

  2472.         500, 150), 'LP' => array(100000, 300, 3000), 'PB' => array(20000, 2000, 1), 'GB' =>
    2473. 

  2473.         array(100000, 10000, 1));
    2474. 

  2474. 

  2475.     // Récupération des constantes du RC
    2476. 

  2476.     $query = 'SELECT dateRC, coordinates, nb_rounds, victoire, pertes_A, pertes_D, gain_M, gain_C, 
    2477. 

  2477.     gain_D, debris_M, debris_C, lune FROM ' . TABLE_PARSEDRC . ' WHERE id_rc = ' .
    2478. 

  2478.         $id_RC;
    2479. 

  2479.     $result = $db->sql_query($query);
    2480. 

  2480.     list($dateRC, $coordinates, $nb_rounds, $victoire, $pertes_A, $pertes_D, $gain_M,
    2481. 

  2481.         $gain_C, $gain_D, $debris_M, $debris_C, $lune) = $db->sql_fetch_row($result);
    2482. 

  2482.     $dateRC = date('d.m.Y H:i:s', $dateRC);
    2483. 

  2483.     $template = 'Les flottes suivantes s\'affrontent (' . $dateRC . "):\n\n";
    2484. 

  2484. 

  2485.     // Récupération de chaque round du RC
    2486. 

  2486.     for ($idx = 1; $idx <= $nb_rounds; $idx++) {
    2487. 

  2487.         $query = 'SELECT id_rcround, attaque_tir, attaque_puissance, attaque_bouclier, defense_tir, 
    2488. 

  2488.       defense_puissance, defense_bouclier FROM ' . TABLE_PARSEDRCROUND .
    2489. 

  2489.             ' WHERE id_rc = ' . $id_RC . '
    2490. 

  2490.      AND numround = ' . $idx;
    2491. 

  2491.         $result_round = $db->sql_query($query);
    2492. 

  2492.         list($id_rcround, $attaque_tir, $attaque_puissance, $attaque_bouclier, $defense_tir,
    2493. 

  2493.             $defense_puissance, $defense_bouclier) = $db->sql_fetch_row($result_round);
    2494. 

  2494. 		// On formate les résultats
    2495. 

  2495. 		$nf_gain_M = number_format($gain_M,0,',','.');
    2496. 

  2496. 		$nf_gain_C = number_format($gain_C,0,',','.');
    2497. 

  2497. 		$nf_gain_D = number_format($gain_D,0,',','.');
    2498. 

  2498. 		$nf_pertes_A = number_format($pertes_A,0,',','.');
    2499. 

  2499. 		$nf_pertes_D = number_format($pertes_D,0,',','.');
    2500. 

  2500. 		$nf_debris_M = number_format($debris_M,0,',','.');
    2501. 

  2501. 		$nf_debris_C = number_format($debris_C,0,',','.');
    2502. 

  2502. 		$nf_attaque_tir = number_format($attaque_tir,0,',','.');
    2503. 

  2503. 		$nf_attaque_puissance = number_format($attaque_puissance,0,',','.');
    2504. 

  2504. 		$nf_attaque_bouclier = number_format($attaque_bouclier,0,',','.');
    2505. 

  2505. 		$nf_defense_tir = number_format($defense_tir,0,',','.');
    2506. 

  2506. 		$nf_defense_puissance = number_format($defense_puissance,0,',','.');
    2507. 

  2507. 		$nf_defense_bouclier = number_format($defense_bouclier,0,',','.');
    2508. 

  2508. 	
    2509. 

  2509.         // Récupération de chaque attaquant du RC
    2510. 

  2510.         $query = 'SELECT player, coordinates, Armes, Bouclier, Protection, PT, GT, CLE, CLO, CR, VB, VC, REC, 
    2511. 

  2511.       SE, BMD, DST, EDLM, TRA FROM ' . TABLE_ROUND_ATTACK .
    2512. 

  2512.             ' WHERE id_rcround = ' . $id_rcround;
    2513. 

  2513.         $result_attack = $db->sql_query($query);
    2514. 

  2514.         while (list($player, $coordinates, $Armes, $Bouclier, $Protection, $PT, $GT, $CLE,
    2515. 

  2515.             $CLO, $CR, $VB, $VC, $REC, $SE, $BMD, $DST, $EDLM, $TRA) = $db->sql_fetch_row($result_attack)) {
    2516. 

  2516.             $key = '';
    2517. 

  2517.             $ship = 0;
    2518. 

  2518.             $vivant_att = false;
    2519. 

  2519.             $template .= 'Attaquant ' . $player;
    2520. 

  2520.             $ship_type = 'Type';
    2521. 

  2521.             $ship_nombre = 'Nombre';
    2522. 

  2522.             $ship_armes = 'Armes';
    2523. 

  2523.             $ship_bouclier = 'Bouclier';
    2524. 

  2524.             $ship_protection = 'Coque';
    2525. 

  2525.             foreach ($key_ships as $key => $ship) {
    2526. 

  2526.                 if (isset($$key) && $$key > 0) {
    2527. 

  2527.                     $vivant_att = true;
    2528. 

  2528.                     $ship_type .= "\t" . $ship;
    2529. 

  2529.                     $ship_nombre .= "\t" . number_format($$key,0,',','.');;
    2530. 

  2530.                     $ship_protection .= "\t" . number_format(round(($base_ships[$key][0] * (($Protection / 10) * 0.1 + 1)) / 10),0,',','.');
    2531. 

  2531.                     $ship_bouclier .= "\t" . number_format(round($base_ships[$key][1] * (($Bouclier / 10) * 0.1 + 1)),0,',','.');
    2532. 

  2532.                     $ship_armes .= "\t" . number_format(round($base_ships[$key][2] * (($Armes / 10) * 0.1 + 1)),0,',','.');
    2533. 

  2533.                 }
    2534. 

  2534.             }
    2535. 

  2535.             if ($vivant_att == true) {
    2536. 

  2536. 				$template .= ' [' . $coordinates . ']';
    2537. 

  2537. 				if($idx==1)
    2538. 

  2538. 					$template .= ' Armes: ' . $Armes . '% Bouclier: ' . $Bouclier . '% Coques: ' . $Protection . '%';
    2539. 

  2539. 				$template .="\n";
    2540. 

  2540. 				$template .= $ship_type . "\n" . $ship_nombre . "\n" . $ship_armes . "\n" . $ship_bouclier . "\n" . $ship_protection . "\n\n";
    2541. 

  2541. 			}
    2542. 

  2542.             else
    2543. 

  2543.                 $template .= ' détruit.' . "\n\n";
    2544. 

  2544.         } // Fin récupération de chaque attaquant du RC
    2545. 

  2545. 

  2546.         // Récupération de chaque défenseur du RC
    2547. 

  2547.         $query = 'SELECT player, coordinates, Armes, Bouclier, Protection, PT, GT, CLE, CLO, CR, VB, VC, REC, 
    2548. 

  2548.       SE, BMD, SAT, DST, EDLM, TRA, LM, LLE, LLO, CG, AI, LP, PB, GB FROM ' .
    2549. 

  2549.             TABLE_ROUND_DEFENSE . ' WHERE 
    2550. 

  2550.       id_rcround = ' . $id_rcround;
    2551. 

  2551.         $result_defense = $db->sql_query($query);
    2552. 

  2552.         while (list($player, $coordinates, $Armes, $Bouclier, $Protection, $PT, $GT, $CLE,
    2553. 

  2553.             $CLO, $CR, $VB, $VC, $REC, $SE, $BMD, $SAT, $DST, $EDLM, $TRA, $LM, $LLE, $LLO, $CG, $AI,
    2554. 

  2554.             $LP, $PB, $GB) = $db->sql_fetch_row($result_defense)) {
    2555. 

  2555.             $key = '';
    2556. 

  2556.             $ship = 0;
    2557. 

  2557.             $vivant_def = false;
    2558. 

  2558.             $template .= 'Défenseur ' . $player;
    2559. 

  2559.             $ship_type = 'Type';
    2560. 

  2560.             $ship_nombre = 'Nombre';
    2561. 

  2561.             $ship_armes = 'Armes';
    2562. 

  2562.             $ship_bouclier = 'Bouclier';
    2563. 

  2563.             $ship_protection = 'Coque';
    2564. 

  2564.             foreach ($key_ships as $key => $ship) {
    2565. 

  2565.                 if (isset($$key) && $$key > 0) {
    2566. 

  2566.                     $vivant_def = true;
    2567. 

  2567.                     $ship_type .= "\t" . $ship;
    2568. 

  2568.                     $ship_nombre .= "\t" . number_format($$key,0,',','.');
    2569. 

  2569.                     $ship_protection .= "\t" . number_format(round(($base_ships[$key][0] * (($Protection / 10) * 0.1 + 1)) / 10),0,',','.');
    2570. 

  2570.                     $ship_bouclier .= "\t" . number_format(round($base_ships[$key][1] * (($Bouclier / 10) * 0.1 + 1)),0,',','.');
    2571. 

  2571.                     $ship_armes .= "\t" . number_format(round($base_ships[$key][2] * (($Armes / 10) * 0.1 + 1)),0,',','.');
    2572. 

  2572.                 }
    2573. 

  2573.             }
    2574. 

  2574.             foreach ($key_defs as $key => $def) {
    2575. 

  2575.                 if (isset($$key) && $$key > 0) {
    2576. 

  2576.                     $vivant_def = true;
    2577. 

  2577.                     $ship_type .= "\t" . $def;
    2578. 

  2578.                     $ship_nombre .= "\t" . number_format($$key,0,',','.');
    2579. 

  2579.                     $ship_protection .= "\t" . number_format(round(($base_defs[$key][0] * (($Protection / 10) * 0.1 + 1)) / 10),0,',','.');
    2580. 

  2580.                     $ship_bouclier .= "\t" . number_format(round($base_defs[$key][1] * (($Bouclier / 10) * 0.1 + 1)),0,',','.');
    2581. 

  2581.                     $ship_armes .= "\t" . number_format(round($base_defs[$key][2] * (($Armes / 10) * 0.1 + 1)),0,',','.');
    2582. 

  2582.                 }
    2583. 

  2583.             }
    2584. 

  2584.             if ($vivant_def == true) {
    2585. 

  2585.                 $template .= ' [' . $coordinates . ']';
    2586. 

  2586. 				if($idx==1)
    2587. 

  2587. 					$template .= ' Armes: ' . $Armes . '% Bouclier: ' . $Bouclier . '% Coques: ' . $Protection . '%';
    2588. 

  2588. 				$template .="\n";
    2589. 

  2589. 				$template .= $ship_type . "\n" . $ship_nombre . "\n" . $ship_armes . "\n" . $ship_bouclier . "\n" . $ship_protection . "\n\n";
    2590. 

  2590. 			}
    2591. 

  2591.             else
    2592. 

  2592.                 $template .= ' détruit.' . "\n\n";
    2593. 

  2593.         } // Fin récupération de chaque défenseur du RC
    2594. 

  2594. 

  2595.         // Résultat du round
    2596. 

  2596.         if ($attaque_tir != 0 || $defense_tir != 0) {
    2597. 

  2597.             $template .= 'La flotte attaquante tire ' . $nf_attaque_tir .
    2598. 

  2598.                 ' fois avec une force totale de ' . $nf_attaque_puissance .
    2599. 

  2599.                 ' sur le défenseur. Les boucliers du défenseur absorbent ' . $nf_defense_bouclier .
    2600. 

  2600.                 ' points de dommage.' . "\n\n";
    2601. 

  2601.             $template .= 'La flotte de défense tire ' . $nf_defense_tir .
    2602. 

  2602.                 ' fois sur l\'attaquant avec une force de ' . $nf_defense_puissance . '. Les boucliers de l\'attaquant absorbent ' .
    2603. 

  2603.                 $nf_attaque_bouclier . ' points de dommage.' . "\n\n";
    2604. 

  2604.         }
    2605. 

  2605.     } // Fin récupération de chaque round du RC
    2606. 

  2606. 

  2607.     // Qui a remporté le combat ?
    2608. 

  2608. 	    switch ($victoire) {
    2609. 

  2609.         case 'N':
    2610. 

  2610.             $template .= 'La bataille se termine par un match nul, les deux flottes rentrent vers leurs plančtes respectives.' .
    2611. 

  2611.                 "\n\n";
    2612. 

  2612.             break;
    2613. 

  2613.         case 'A':
    2614. 

  2614.             $template .= 'L\'attaquant a gagné la bataille ! Il emporte ' .
    2615. 

  2615.                 $nf_gain_M . ' unités de métal, ' . $nf_gain_C . ' unités de cristal et ' . $nf_gain_D .
    2616. 

  2616.                 ' unités de deutérium.' . "\n\n";
    2617. 

  2617.             break;
    2618. 

  2618.         case 'D':
    2619. 

  2619.             $template .= 'Le défenseur a gagné la bataille !' . "\n\n";
    2620. 

  2620.             break;
    2621. 

  2621.     }
    2622. 

  2622. 

  2623.     // Pertes et champs de débris
    2624. 

  2624.     $template .= 'L\'attaquant a perdu au total ' . $nf_pertes_A . ' unités.' . "\n";
    2625. 

  2625.     $template .= 'Le défenseur a perdu au total ' . $nf_pertes_D . ' unités.' . "\n";
    2626. 

  2626.     $template .= 'Un champ de débris contenant ' . $nf_debris_M .
    2627. 

  2627.         ' de métal et ' . $nf_debris_C . ' de cristal se forme dans l\'orbite de la plančte.' .
    2628. 

  2628.         "\n";
    2629. 

  2629. 	
    2630. 

  2630. 	$lunePourcent = floor(($debris_M + $debris_C) / 100000);
    2631. 

  2631. 	$lunePourcent = ($lunePourcent<0 ? 0 : ($lunePourcent>20 ? 20 : $lunePourcent));
    2632. 

  2632. 	if ($lunePourcent>0)
    2633. 

  2633. 		$template .= 'La probabilité de création d\'une lune est de ' . $lunePourcent . ' %';
    2634. 

  2634. 		
    2635. 

  2635. 	if($lune==1)
    2636. 

  2636. 		$template .= "\nLes quantités énormes de métal et de cristal s'attirent, formant ainsi une lune dans l'orbite de cette plančte.";
    2637. 

  2637. 

  2638.     return ($template);
    2639. 

  2639. }
    2640. 

  2640. 

  2641. /**
    2642. 

  2642.  * Enregistrement des RC
    2643. 

  2643.  * @global $db
    2644. 

  2644.  * @param string $rawRC RC brut ŕ analyser
    2645. 

  2645.  */
    2646. 

  2646. function insert_RC($rawRC)
    2647. 

  2647. {
    2648. 

  2648.     global $db;
    2649. 

  2649.     $parsedRC = parseRC($rawRC);
    2650. 

  2650.     $query = 'INSERT IGNORE INTO ' . TABLE_PARSEDRC .
    2651. 

  2651.         '(dateRC, nb_rounds, victoire, pertes_A, pertes_D, 
    2652. 

  2652.     gain_M, gain_C, gain_D, debris_M, debris_C, lune, coordinates) VALUES (' . $parsedRC['dateRC'] .
    2653. 

  2653.         ',' . $parsedRC['nb_rounds'] . ',"' . $parsedRC['victoire'] . '",' . $parsedRC['pertes_A'] .
    2654. 

  2654.         ',' . $parsedRC['pertes_D'] . ',' . $parsedRC['gain_M'] . ',' . $parsedRC['gain_C'] .
    2655. 

  2655.         ',' . $parsedRC['gain_D'] . ',' . $parsedRC['debris_M'] . ',' . $parsedRC['debris_C'] .
    2656. 

  2656.         ',' . $parsedRC['lune'] . ',"' . $parsedRC['coordinates'] . '")';
    2657. 

  2657.     if (!$db->sql_query($query)) {
    2658. 

  2658.         $error = $db->sql_error($result);
    2659. 

  2659.         error_sql($error['message']);
    2660. 

  2660.     }
    2661. 

  2661.     $id_RC = $db->sql_insertid();
    2662. 

  2662.     for ($idx_round = 1; $idx_round <= $parsedRC['nb_rounds']; $idx_round++) {
    2663. 

  2663.         $round = 'round' . $idx_round;
    2664. 

  2664.         log_('mod', ' enregistre le round ' . $idx_round);
    2665. 

  2665.         $query = 'INSERT IGNORE INTO ' . TABLE_PARSEDRCROUND .
    2666. 

  2666.             '(id_rc, numround, attaque_tir, attaque_puissance, 
    2667. 

  2667.       attaque_bouclier, defense_tir, defense_puissance, defense_bouclier) VALUES(' .
    2668. 

  2668.             $id_RC . ', ' . $idx_round . ', "' . $parsedRC[$round]['attaque_tir'] . '", "' .
    2669. 

  2669.             $parsedRC[$round]['attaque_puissance'] . '", "' . $parsedRC[$round]['attaque_bouclier'] .
    2670. 

  2670.             '", "' . $parsedRC[$round]['defense_tir'] . '", "' . $parsedRC[$round]['defense_puissance'] .
    2671. 

  2671.             '", "' . $parsedRC[$round]['defense_bouclier'] . '")';
    2672. 

  2672.         if (!$db->sql_query($query)) {
    2673. 

  2673.             $error = $db->sql_error($result);
    2674. 

  2674.             error_sql($error['message']);
    2675. 

  2675.         }
    2676. 

  2676.         $id_parsedround = $db->sql_insertid();
    2677. 

  2677.         foreach ($parsedRC['attaquants'] as $opponent => $row) {
    2678. 

  2678.             $pseudo = $row['pseudo'];
    2679. 

  2679.             $query = 'INSERT IGNORE INTO ' . TABLE_ROUND_ATTACK .
    2680. 

  2680.                 '(id_rcround, player, coordinates, Armes, 
    2681. 

  2681.         Bouclier, Protection, PT, GT, CLE, CLO, CR, VB, VC, REC, SE, BMD, DST, EDLM, TRA) VALUES (' .
    2682. 

  2682.                 $id_parsedround . ', "' . $row['pseudo'] . '", "' . $row['coordinates'] . '", ' .
    2683. 

  2683.                 $row['armes'] . ', ' . $row['bouclier'] . ', ' . $row['protection'] . ', "' . $parsedRC[$round][$pseudo]['P.transp.'] .
    2684. 

  2684.                 '", "' . $parsedRC[$round][$pseudo]['G.transp.'] . '", "' . $parsedRC[$round][$pseudo]['Ch.léger'] .
    2685. 

  2685.                 '", "' . $parsedRC[$round][$pseudo]['Ch.lourd'] . '", "' . $parsedRC[$round][$pseudo]['Croiseur'] .
    2686. 

  2686.                 '", "' . $parsedRC[$round][$pseudo]['V.bataille'] . '", "' . $parsedRC[$round][$pseudo]['V.colonisation'] .
    2687. 

  2687.                 '", "' . $parsedRC[$round][$pseudo]['Recycleur'] . '", "' . $parsedRC[$round][$pseudo]['Sonde'] .
    2688. 

  2688.                 '", "' . $parsedRC[$round][$pseudo]['Bombardier'] . '", "' . $parsedRC[$round][$pseudo]['Destr.'] .
    2689. 

  2689.                 '", "' . $parsedRC[$round][$pseudo]['Rip'] . '", "' . $parsedRC[$round][$pseudo]['Traqueur'] .
    2690. 

  2690.                 '")';
    2691. 

  2691.             if (!$db->sql_query($query)) {
    2692. 

  2692.                 $error = $db->sql_error($result);
    2693. 

  2693.                 error_sql($error['message']);
    2694. 

  2694.             }
    2695. 

  2695.         }
    2696. 

  2696.         foreach ($parsedRC['defenseurs'] as $opponent => $row) {
    2697. 

  2697.             $pseudo = $row['pseudo'];
    2698. 

  2698.             $query = 'INSERT IGNORE INTO ' . TABLE_ROUND_DEFENSE .
    2699. 

  2699.                 '(id_rcround, player, coordinates, Armes, 
    2700. 

  2700.         Bouclier, Protection, PT, GT, CLE, CLO, CR, VB, VC, REC, SE, BMD, DST, EDLM, SAT, TRA, LM, LLE, LLO, 
    2701. 

  2701.         CG, AI, LP, PB, GB) VALUES (' . $id_parsedround . ', "' . $row['pseudo'] .
    2702. 

  2702.                 '", "' . $row['coordinates'] . '", ' . $row['armes'] . ', ' . $row['bouclier'] .
    2703. 

  2703.                 ', ' . $row['protection'] . ', "' . $parsedRC[$round][$pseudo]['P.transp.'] .
    2704. 

  2704.                 '", "' . $parsedRC[$round][$pseudo]['G.transp.'] . '", "' . $parsedRC[$round][$pseudo]['Ch.léger'] .
    2705. 

  2705.                 '", "' . $parsedRC[$round][$pseudo]['Ch.lourd'] . '", "' . $parsedRC[$round][$pseudo]['Croiseur'] .
    2706. 

  2706.                 '", "' . $parsedRC[$round][$pseudo]['V.bataille'] . '", "' . $parsedRC[$round][$pseudo]['V.colonisation'] .
    2707. 

  2707.                 '", "' . $parsedRC[$round][$pseudo]['Recycleur'] . '", "' . $parsedRC[$round][$pseudo]['Sonde'] .
    2708. 

  2708.                 '", "' . $parsedRC[$round][$pseudo]['Bombardier'] . '", "' . $parsedRC[$round][$pseudo]['Destr.'] .
    2709. 

  2709.                 '", "' . $parsedRC[$round][$pseudo]['Rip'] . '", "' . $parsedRC[$round][$pseudo]['Sat.sol.'] .
    2710. 

  2710.                 '", "' . $parsedRC[$round][$pseudo]['Traqueur'] . '", "' . $parsedRC[$round][$pseudo]['Missile'] .
    2711. 

  2711.                 '", "' . $parsedRC[$round][$pseudo]['L.léger.'] . '", "' . $parsedRC[$round][$pseudo]['L.lourd'] .
    2712. 

  2712.                 '", "' . $parsedRC[$round][$pseudo]['Can.Gauss'] . '", "' . $parsedRC[$round][$pseudo]['Art.ions'] .
    2713. 

  2713.                 '", "' . $parsedRC[$round][$pseudo]['Lanc.plasma'] . '", "' . $parsedRC[$round][$pseudo]['P.bouclier'] .
    2714. 

  2714.                 '", "' . $parsedRC[$round][$pseudo]['G.bouclier'] . '")';
    2715. 

  2715.             if (!$db->sql_query($query)) {
    2716. 

  2716.                 $error = $db->sql_error($result);
    2717. 

  2717.                 error_sql($error['message']);
    2718. 

  2718.             }
    2719. 

  2719.         }
    2720. 

  2720.     }
    2721. 

  2721.     redirection('index.php');
    2722. 

  2722. }
    2723. 

  2723. 

  2724. /**
    2725. 

  2725.  * Fonction de calcul du ratio
    2726. 

  2726.  * @param int $player user_id ID du joueur
    2727. 

  2727.  * @return array ratio et divers calculs intermédiaires pour l'utilisateur en question
    2728. 

  2728.  * @author Bousteur 25/11/2006
    2729. 

  2729.  */
    2730. 

  2730. function ratio_calc($player)
    2731. 

  2731. {
    2732. 

  2732.     global $db, $user_data;
    2733. 

  2733. 

  2734.     //récupération des données nécessaires
    2735. 

  2735.     $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 " .
    2736. 

  2736.         TABLE_USER . " WHERE user_id='" . $player . "'";
    2737. 

  2737.     $result = $db->sql_query($sqlrecup);
    2738. 

  2738.     list($planet_added_web, $planet_added_ogs, $planet_exported, $search, $spy_added_web,
    2739. 

  2739.         $spy_added_ogs, $spy_exported, $rank_added_web, $rank_added_ogs, $rank_exported) =
    2740. 

  2740.         $db->sql_fetch_row($result);
    2741. 

  2741.     $request = "select sum(planet_added_web + planet_added_ogs), ";
    2742. 

  2742.     $request .= "sum(spy_added_web + spy_added_ogs), ";
    2743. 

  2743.     $request .= "sum(rank_added_web + rank_added_ogs), ";
    2744. 

  2744.     $request .= "sum(search) ";
    2745. 

  2745.     $request .= "from " . TABLE_USER;
    2746. 

  2746.     $resultat = $db->sql_query($request);
    2747. 

  2747.     list($planetimporttotal, $spyimporttotal, $rankimporttotal, $searchtotal) = $db->
    2748. 

  2748.         sql_fetch_row($resultat);
    2749. 

  2749.     $query = "SELECT COUNT(user_id) as count FROM " . TABLE_USER;
    2750. 

  2750.     $result = $db->sql_query($query);
    2751. 

  2751.     if ($db->sql_numrows($result) > 0) {
    2752. 

  2752.         $row = $db->sql_fetch_assoc($result);
    2753. 

  2753.         $max = $row['count'];
    2754. 

  2754.     }
    2755. 

  2755.     //pour éviter la division par zéro
    2756. 

  2756.     if ($planetimporttotal == 0)
    2757. 

  2757.         $planetimporttotal = 1;
    2758. 

  2758.     if ($spyimporttotal == 0)
    2759. 

  2759.         $spyimporttotal = 1;
    2760. 

  2760.     if ($rankimporttotal == 0)
    2761. 

  2761.         $rankimporttotal = 1;
    2762. 

  2762.     if ($searchtotal == 0)
    2763. 

  2763.         $searchtotal = 1;
    2764. 

  2764. 

  2765.     //et on commence le calcul
    2766. 

  2766.     $ratio_planet = ($planet_added_web + $planet_added_ogs) / $planetimporttotal;
    2767. 

  2767.     $ratio_spy = ($spy_added_web + $spy_added_ogs) / $spyimporttotal;
    2768. 

  2768.     $ratio_rank = ($rank_added_web + $rank_added_ogs) / $rankimporttotal;
    2769. 

  2769.     $ratio = ($ratio_planet * 4 + $ratio_spy * 2 + $ratio_rank) / (4 + 2 + 1);
    2770. 

  2770. 

  2771.     $ratio_planet_penality = ($planet_added_web + $planet_added_ogs - $planet_exported) /
    2772. 

  2772.         $planetimporttotal;
    2773. 

  2773.     $ratio_spy_penality = (($spy_added_web + $spy_added_ogs) - $spy_exported) / $spyimporttotal;
    2774. 

  2774.     $ratio_rank_penality = (($rank_added_web + $rank_added_ogs) - $rank_exported) /
    2775. 

  2775.         $rankimporttotal;
    2776. 

  2776.     $ratio_penality = ($ratio_planet_penality * 4 + $ratio_spy_penality * 2 + $ratio_rank_penality) / (4 +
    2777. 

  2777.         2 + 1);
    2778. 

  2778. 

  2779.     $ratio_search = $search / $searchtotal;
    2780. 

  2780.     $ratio_searchpenality = ($ratio - $ratio_search);
    2781. 

  2781. 

  2782.     $result = ($ratio + $ratio_penality + $ratio_searchpenality) * 1000;
    2783. 

  2783.     $array = array($result, $ratio_searchpenality, $ratio_search, $ratio_penality, $ratio_rank_penality,
    2784. 

  2784.         $ratio_spy_penality, $ratio_planet_penality);
    2785. 

  2785. 

  2786.     //retourne le ratio et calculs intermédiaires
    2787. 

  2787.     return $array;
    2788. 

  2788. }
    2789. 

  2789. 

  2790. /**
    2791. 

  2791.  * Fonction de test d'autorisation d'effectuer une action en fonction du ratio ou de l'appartenance ŕ un groupe qui a un ratio illimité
    2792. 

  2792.  * @return bool vrai si l'utilisateur peut faire des recherches
    2793. 

  2793.  * @author Bousteur 28/11/2006
    2794. 

  2794.  */
    2795. 

  2795. function ratio_is_ok()
    2796. 

  2796. {
    2797. 

  2797.     global $user_data, $server_config;
    2798. 

  2798.     static $result;
    2799. 

  2799. 

  2800.     if ($result != null)
    2801. 

  2801.         return $result;
    2802. 

  2802.     if (isset($server_config["block_ratio"]) && $server_config["block_ratio"] == 1) {
    2803. 

  2803.         if ($user_data["user_admin"] == 1 || $user_data["user_coadmin"] == 1 || $user_data["management_user"] ==
    2804. 

  2804.             1) {
    2805. 

  2805.             return true;
    2806. 

  2806.         } else {
    2807. 

  2807.             $result = ratio_calc($user_data['user_id']);
    2808. 

  2808.             $result = $result[0] >= $server_config["ratio_limit"];
    2809. 

  2809.             return $result;
    2810. 

  2810.         }
    2811. 

  2811.     } else {
    2812. 

  2812.         return true;
    2813. 

  2813.     }
    2814. 

  2814. }
    2815. 

  2815. ?>
    2816.