PageRenderTime 68ms CodeModel.GetById 23ms RepoModel.GetById 0ms app.codeStats 0ms

/includes/functions.php

https://bitbucket.org/ogsteam/ogspy
PHP | 1867 lines | 1234 code | 195 blank | 438 comment | 358 complexity | 503ee5e1cc492cdea88f337978e468b6 MD5 | raw file
Possible License(s): GPL-3.0, BSD-3-Clause 
    

  1. <?php
    2. 

  2. /**
    3. 

  3.  * OGSpy Global functions
    4. 

  4.  * @package OGSpy
    5. 

  5.  * @subpackage Common
    6. 

  6.  * @author Kyser
    7. 

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

  8.  * @version 3.1.1 ($Rev: 7752 $)
    9. 

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

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

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

  12.  */
    13. 

  13. if (!defined('IN_SPYOGAME')) {
    14. 

  14.     die("Hacking attempt");
    15. 

  15. }
    16. 

  16. /**
    17. 

  17.  * URL Redirection
    18. 

  18.  * @param string $url target URL
    19. 

  19.  */
    20. 

  20. function redirection($url)
    21. 

  21. {
    22. 

  22.     if (headers_sent()) {
    23. 

  23.         die('<meta http-equiv="refresh" content="0; URL=' . $url . '">');
    24. 

  24.     } else {
    25. 

  25.         header("Location: " . $url);
    26. 

  26.         exit();
    27. 

  27.     }
    28. 

  28. }
    29. 

  29. 

  30. /**
    31. 

  31.  * Write a text or a table in a file
    32. 

  32.  * @param string $file Filename
    33. 

  33.  * @param string $mode File Opening Mode
    34. 

  34.  * @param string|Array $text String or table to write
    35. 

  35.  * @return boolean false if failed
    36. 

  36.  */
    37. 

  37. function write_file($file, $mode, $text)
    38. 

  38. {
    39. 

  39.     if ($fp = fopen($file, $mode)) {
    40. 

  40.         if (is_array($text)) {
    41. 

  41.             foreach ($text as $t) {
    42. 

  42.                 fwrite($fp, rtrim($t));
    43. 

  43.                 fwrite($fp, "\r\n");
    44. 

  44.             }
    45. 

  45.         } else {
    46. 

  46.             fwrite($fp, $text);
    47. 

  47.             fwrite($fp, "\r\n");
    48. 

  48.         }
    49. 

  49.         fclose($fp);
    50. 

  50.         return true;
    51. 

  51.     } else
    52. 

  52.         return false;
    53. 

  53. }
    54. 

  54. 

  55. /**
    56. 

  56.  * Write a text or a table in a gz compressed file
    57. 

  57.  * @param string $file Filename
    58. 

  58.  * @param string $mode File Opening Mode
    59. 

  59.  * @param string|Array $text String or table to write
    60. 

  60.  * @return boolean false if failed
    61. 

  61.  */
    62. 

  62. function write_file_gz($file, $mode, $text)
    63. 

  63. {
    64. 

  64.     if ($fp = gzopen($file . ".gz", $mode)) {
    65. 

  65.         if (is_array($text)) {
    66. 

  66.             foreach ($text as $t) {
    67. 

  67.                 gzwrite($fp, rtrim($t));
    68. 

  68.                 gzwrite($fp, "\r\n");
    69. 

  69.             }
    70. 

  70.         } else {
    71. 

  71.             gzwrite($fp, $text);
    72. 

  72.             gzwrite($fp, "\r\n");
    73. 

  73.         }
    74. 

  74.         gzclose($fp);
    75. 

  75.         return true;
    76. 

  76.     } else
    77. 

  77.         return false;
    78. 

  78. }
    79. 

  79. 

  80. /**
    81. 

  81.  * Convert an IP in Hex Format
    82. 

  82.  * @param string $ip format xxx.xxx.xxx.xxx in IPv4 and xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx in IPv6
    83. 

  83.  * @return string IP in hex : HHHHHHHH for IPv4 and HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH for IPv6
    84. 

  84.  */
    85. 

  85. function encode_ip ($ip)
    86. 

  86. {
    87. 

  87. 	$d = explode('.', $ip);
    88. 

  88. 	if (count($d) == 4) return sprintf('%02x%02x%02x%02x', $d[0], $d[1], $d[2], $d[3]);
    89. 

  89. 

  90. 	$d = explode(':', preg_replace('/(^:)|(:$)/', '', $ip));
    91. 

  91. 	$res = '';
    92. 

  92. 	foreach ($d as $x)
    93. 

  93. 	$res .= sprintf('%0'. ($x == '' ? (9 - count($d)) * 4 : 4) .'s', $x);
    94. 

  94. 	return $res;
    95. 

  95. }
    96. 

  96. 

  97. /**
    98. 

  98.  * Convert an IP in Hex format to an IPv4 or IPv6 format
    99. 

  99.  * @param string $int_ip IP encoded
    100. 

  100.  * @return string $ip format xxx.xxx.xxx.xxx in IPv4 and xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx in IPv6
    101. 

  101.  */
    102. 

  102. function decode_ip($int_ip)
    103. 

  103. { 
    104. 

  104.     if (strlen($int_ip) == 32) {
    105. 

  105.         $int_ip = substr(chunk_split($int_ip, 4, ':'), 0, 39);
    106. 

  106.         $int_ip = ':'. implode(':', array_map("hexhex", explode(':',$int_ip))) .':';
    107. 

  107.         preg_match_all("/(:0)+/", $int_ip, $zeros);
    108. 

  108.         if (count($zeros[0]) > 0) {
    109. 

  109.             $match = '';
    110. 

  110.             foreach($zeros[0] as $zero)
    111. 

  111.                 if (strlen($zero) > strlen($match))
    112. 

  112.                     $match = $zero;
    113. 

  113.             $int_ip = preg_replace('/'. $match .'/', ':', $int_ip, 1);
    114. 

  114.         }
    115. 

  115.         return preg_replace('/(^:([^:]))|(([^:]):$)/', '$2$4', $int_ip);
    116. 

  116.     }
    117. 

  117.     $hexipbang = explode('.', chunk_split($int_ip, 2, '.'));
    118. 

  118.     return hexdec($hexipbang[0]). '.' . hexdec($hexipbang[1]) . '.' . hexdec($hexipbang[2]) . '.' . hexdec($hexipbang[3]);
    119. 

  119. }
    120. 

  120. /**
    121. 

  121.  * Converts a hex value to another hew value (depnding of the current php version on the server)
    122. 

  122.  * @param string $value The initial hexvalue
    123. 

  123.  * @return string the new hew value
    124. 

  124.  */
    125. 

  125. function hexhex($value) {
    126. 

  126. 	return dechex(hexdec($value));
    127. 

  127. };
    128. 

  128. 

  129. /**
    130. 

  130.  * Generates a random password with 6 chars
    131. 

  131.  * @return string $password The generated password
    132. 

  132.  */
    133. 

  133. function password_generator()
    134. 

  134. {
    135. 

  135.     $string = "abBDEFcdefghijkmnPQRSTUVWXYpqrst23456789";
    136. 

  136.     srand((double)microtime() * 1000000);
    137. 

  137.     $password = '';
    138. 

  138.     for ($i = 0; $i < 6; $i++) {
    139. 

  139.         $password .= $string[rand() % strlen($string)];
    140. 

  140.     }
    141. 

  141.     return $password;
    142. 

  142. }
    143. 

  143. /**
    144. 

  144.  * Initialisation of the cache for all Mod settings
    145. 

  145.  * 
    146. 

  146.  * Generates a file which contains all configurations for different installed OGSpy Modules
    147. 

  147.  */
    148. 

  148. function init_mod_cache()
    149. 

  149. {
    150. 

  150.     global $cache_mod, $server_config;
    151. 

  151. 

  152.     // Load cached config
    153. 

  153.     $filename = 'cache/cache_mod.php';
    154. 

  154. 

  155.     if (file_exists($filename)) {
    156. 

  156.         include $filename;
    157. 

  157.         // regeneration si besoin
    158. 

  158.         if ((filemtime($filename) + $server_config['mod_cache']) < time()) {
    159. 

  159.             generate_mod_cache();
    160. 

  160.         }
    161. 

  161. 

  162.     } else {
    163. 

  163.         generate_mod_cache();
    164. 

  164.         if (file_exists($filename)) {
    165. 

  165.             include $filename; // on reinjecte le fichier s'il existe'
    166. 

  166.         }
    167. 

  167. 

  168.     }
    169. 

  169. 

  170. }
    171. 

  171. 

  172. /**
    173. 

  173.  * Initialisation of the cache for all Server settings
    174. 

  174.  * 
    175. 

  175.  * Generates a file which contains all configurations for the OGSpy Server
    176. 

  176.  */
    177. 

  177. function init_serverconfig()
    178. 

  178. {
    179. 

  179.     global $server_config;
    180. 

  180. 

  181.     // Load cached config
    182. 

  182.     $filename = 'cache/cache_config.php';
    183. 

  183. 

  184.     if (file_exists($filename)) {
    185. 

  185.         include $filename;
    186. 

  186.         // regeneration si besoin
    187. 

  187.         if ((filemtime($filename) + $server_config['config_cache']) < time()) {
    188. 

  188.             generate_config_cache();
    189. 

  189.         }
    190. 

  190. 

  191.     } else {
    192. 

  192.         generate_config_cache();
    193. 

  193.         if (file_exists($filename)) {
    194. 

  194.             include $filename; // on reinjecte le fichier s'il existe'
    195. 

  195.         }
    196. 

  196. 

  197.     }
    198. 

  198. 

  199. }
    200. 

  200. /**
    201. 

  201.  *  Updates in the database all configurations displayed in the display administration Page.
    202. 

  202.  * @todo Query: update  . TABLE_CONFIG .  set config_value =  . $pub_enable_portee_missil . where config_name = \'portee_missil\'
    203. 

  203.  * @todo Query: "update " . TABLE_CONFIG . " set config_value = " . $pub_galaxy_by_line_stat . " where config_name = 'galaxy_by_line_stat'"
    204. 

  204.  * @todo Query: "update " . TABLE_CONFIG . " set config_value = " . $pub_system_by_line_stat . " where config_name = 'system_by_line_stat'"
    205. 

  205.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $pub_open_user ."' where config_name = 'open_user'"
    206. 

  206.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $pub_open_admin . "' where config_name = 'open_admin'"
    207. 

  207.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_enable_stat_view ." where config_name = 'enable_stat_view'"
    208. 

  208.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_enable_members_view ." where config_name = 'enable_members_view'"
    209. 

  209.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $db->sql_escape_string($pub_nb_colonnes_ally) ."' where config_name = 'nb_colonnes_ally'"
    210. 

  210.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $db->sql_escape_string($color_ally) . "' where config_name = 'color_ally'"
    211. 

  211.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_galaxy_by_line_ally ." where config_name = 'galaxy_by_line_ally'"
    212. 

  212.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_system_by_line_ally ." where config_name = 'system_by_line_ally'"
    213. 

  213.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $pub_enable_register_view ."' where config_name = 'enable_register_view'"
    214. 

  214.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $db->sql_escape_string($pub_register_alliance) ."' where config_name = 'register_alliance'"
    215. 

  215.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $db->sql_escape_string($pub_register_forum) ."' where config_name = 'register_forum'"
    216. 

  216.  */
    217. 

  217. function set_server_view()
    218. 

  218. {
    219. 

  219.     global $db, $user_data;
    220. 

  220.     global $pub_enable_portee_missil, $pub_enable_members_view, $pub_enable_stat_view,
    221. 

  221.         $pub_galaxy_by_line_stat, $pub_system_by_line_stat, $pub_galaxy_by_line_ally, $pub_system_by_line_ally,
    222. 

  222.         $pub_nb_colonnes_ally, $pub_color_ally, $pub_enable_register_view, $pub_register_alliance,
    223. 

  223.         $pub_register_forum, $pub_open_user, $pub_open_admin;
    224. 

  224. 

  225.     if (!check_var($pub_enable_members_view, "Num") || !check_var($pub_enable_stat_view,
    226. 

  226.         "Num") || !check_var($pub_galaxy_by_line_stat, "Num") || !check_var($pub_system_by_line_stat,
    227. 

  227.         "Num") || !check_var($pub_galaxy_by_line_ally, "Num") || !check_var($pub_system_by_line_ally,
    228. 

  228.         "Num")) {
    229. 

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

  230.     }
    231. 

  231.     if ($user_data["user_admin"] != 1 && $user_data["user_coadmin"] != 1) {
    232. 

  232.         redirection("planetindex.php?action=message&id_message=forbidden&info");
    233. 

  233.     }
    234. 

  234. 

  235.     if (!isset($pub_galaxy_by_line_stat) || !isset($pub_system_by_line_stat) || !
    236. 

  236.         isset($pub_galaxy_by_line_ally) || !isset($pub_system_by_line_ally)) {
    237. 

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

  238.     }
    239. 

  239. 

  240.     if (is_null($pub_enable_portee_missil))
    241. 

  241.         $pub_enable_portee_missil = 0;
    242. 

  242.     if (is_null($pub_enable_stat_view))
    243. 

  243.         $pub_enable_stat_view = 0;
    244. 

  244.     if (is_null($pub_enable_members_view))
    245. 

  245.         $pub_enable_members_view = 0;
    246. 

  246. 

  247.     $break = false;
    248. 

  248. 

  249. 

  250.     if (!is_numeric($pub_galaxy_by_line_stat))
    251. 

  251.         $break = true;
    252. 

  252.     if (!is_numeric($pub_system_by_line_stat))
    253. 

  253.         $break = true;
    254. 

  254.     if ($pub_enable_stat_view != 0 && $pub_enable_stat_view != 1)
    255. 

  255.         $break = true;
    256. 

  256.     if ($pub_enable_members_view != 0 && $pub_enable_members_view != 1)
    257. 

  257.         $break = true;
    258. 

  258.     if (!is_numeric($pub_galaxy_by_line_ally))
    259. 

  259.         $break = true;
    260. 

  260.     if (!is_numeric($pub_system_by_line_ally))
    261. 

  261.         $break = true;
    262. 

  262.     if ($pub_nb_colonnes_ally == 0 || $pub_nb_colonnes_ally > 9 || !is_numeric($pub_nb_colonnes_ally))
    263. 

  263.         $break = true;
    264. 

  264.     if ($pub_enable_register_view != 0 && $pub_enable_register_view != 1)
    265. 

  265.         $break = true;
    266. 

  266. 

  267.     if ($break) {
    268. 

  268.         redirection("index.php?action=message&id_message=setting_server_view_failed&info");
    269. 

  269.     }
    270. 

  270. 

  271.     //
    272. 

  272.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_enable_portee_missil .
    273. 

  273.         " where config_name = 'portee_missil'";
    274. 

  274.     $db->sql_query($request);
    275. 

  275. 

  276.     //
    277. 

  277.     if ($pub_galaxy_by_line_stat < 1)
    278. 

  278.         $pub_galaxy_by_line_stat = 1;
    279. 

  279.     if ($pub_galaxy_by_line_stat > 100)
    280. 

  280.         $pub_galaxy_by_line_stat = 100;
    281. 

  281.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_galaxy_by_line_stat .
    282. 

  282.         " where config_name = 'galaxy_by_line_stat'";
    283. 

  283.     $db->sql_query($request);
    284. 

  284. 

  285.     //
    286. 

  286.     if ($pub_system_by_line_stat < 1)
    287. 

  287.         $pub_system_by_line_stat = 1;
    288. 

  288.     if ($pub_system_by_line_stat > 100)
    289. 

  289.         $pub_system_by_line_stat = 100;
    290. 

  290.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_system_by_line_stat .
    291. 

  291.         " where config_name = 'system_by_line_stat'";
    292. 

  292.     $db->sql_query($request);
    293. 

  293. 

  294.     //
    295. 

  295.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $pub_open_user .
    296. 

  296.         "' where config_name = 'open_user'";
    297. 

  297.     $db->sql_query($request);
    298. 

  298. 

  299.     //
    300. 

  300.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $pub_open_admin .
    301. 

  301.         "' where config_name = 'open_admin'";
    302. 

  302.     $db->sql_query($request);
    303. 

  303. 

  304.     //
    305. 

  305.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_enable_stat_view .
    306. 

  306.         " where config_name = 'enable_stat_view'";
    307. 

  307.     $db->sql_query($request);
    308. 

  308. 

  309.     //
    310. 

  310.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_enable_members_view .
    311. 

  311.         " where config_name = 'enable_members_view'";
    312. 

  312.     $db->sql_query($request);
    313. 

  313. 

  314.     //
    315. 

  315.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $db->
    316. 

  316.         sql_escape_string($pub_nb_colonnes_ally) .
    317. 

  317.         "' where config_name = 'nb_colonnes_ally'";
    318. 

  318.     $db->sql_query($request);
    319. 

  319. 

  320. 

  321.     $array = $pub_color_ally; //die(var_dump($pub_color_ally));
    322. 

  322.     $color_ally = implode("_", $array);
    323. 

  323.     //
    324. 

  324.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $db->
    325. 

  325.         sql_escape_string($color_ally) . "' where config_name = 'color_ally'";
    326. 

  326.     $db->sql_query($request);
    327. 

  327. 

  328.     //
    329. 

  329.     if ($pub_galaxy_by_line_ally < 1)
    330. 

  330.         $pub_galaxy_by_line_ally = 1;
    331. 

  331.     if ($pub_galaxy_by_line_ally > 100)
    332. 

  332.         $pub_galaxy_by_line_ally = 100;
    333. 

  333.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_galaxy_by_line_ally .
    334. 

  334.         " where config_name = 'galaxy_by_line_ally'";
    335. 

  335.     $db->sql_query($request);
    336. 

  336. 

  337.     //
    338. 

  338.     if ($pub_system_by_line_ally < 1)
    339. 

  339.         $pub_system_by_line_ally = 1;
    340. 

  340.     if ($pub_system_by_line_ally > 100)
    341. 

  341.         $pub_system_by_line_ally = 100;
    342. 

  342.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_system_by_line_ally .
    343. 

  343.         " where config_name = 'system_by_line_ally'";
    344. 

  344.     $db->sql_query($request);
    345. 

  345. 

  346.     //
    347. 

  347.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $pub_enable_register_view .
    348. 

  348.         "' where config_name = 'enable_register_view'";
    349. 

  349.     $db->sql_query($request);
    350. 

  350. 

  351.     //
    352. 

  352.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $db->
    353. 

  353.         sql_escape_string($pub_register_alliance) .
    354. 

  354.         "' where config_name = 'register_alliance'";
    355. 

  355.     $db->sql_query($request);
    356. 

  356. 

  357.     //
    358. 

  358.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $db->
    359. 

  359.         sql_escape_string($pub_register_forum) .
    360. 

  360.         "' where config_name = 'register_forum'";
    361. 

  361.     $db->sql_query($request);
    362. 

  362. 

  363.     // mise a jour des caches avec les modifs
    364. 

  364.     generate_config_cache();
    365. 

  365.     log_("set_server_view");
    366. 

  366.     redirection("index.php?action=administration&subaction=affichage");
    367. 

  367. }
    368. 

  368. /**
    369. 

  369.  *  Updates in the database all configurations displayed in the parameters administration Page.
    370. 

  370.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_server_active ." where config_name = 'server_active'";
    371. 

  371.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_debug_log ." where config_name = 'debug_log'";
    372. 

  372.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_block_ratio ." where config_name = 'block_ratio'";
    373. 

  373.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_log_phperror ." where config_name = 'log_phperror'";
    374. 

  374.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_max_favorites ." where config_name = 'max_favorites'";
    375. 

  375.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_max_favorites_spy ." where config_name = 'max_favorites_spy'";
    376. 

  376.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_ratio_limit ." where config_name = 'ratio_limit'";
    377. 

  377.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_max_spyreport ." where config_name = 'max_spyreport'";
    378. 

  378.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_max_battlereport ." where config_name = 'max_battlereport'";
    379. 

  379.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_session_time ." where config_name = 'session_time'";
    380. 

  380.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_max_keeplog ." where config_name = 'max_keeplog'";
    381. 

  381.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $db->sql_escape_string($pub_default_skin) . "' where config_name = 'default_skin'";
    382. 

  382.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $db->sql_escape_string($pub_reason) . "' where config_name = 'reason'";
    383. 

  383.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $db->sql_escape_string($pub_ally_protection) ."' where config_name = 'ally_protection'";
    384. 

  384.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $db->sql_escape_string($pub_url_forum) . "' where config_name = 'url_forum'";
    385. 

  385.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_max_keeprank ." where config_name = 'max_keeprank'";
    386. 

  386.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $db->sql_escape_string($pub_keeprank_criterion) ."' where config_name = 'keeprank_criterion'";
    387. 

  387.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_max_keepspyreport ." where config_name = 'max_keepspyreport'";
    388. 

  388.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $db->sql_escape_string($pub_servername) . "' where config_name = 'servername'";
    389. 

  389.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $db->sql_escape_string($pub_allied) . "' where config_name = 'allied'";
    390. 

  390.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_disable_ip_check ." where config_name = 'disable_ip_check'";
    391. 

  391.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_num_of_galaxies ." where config_name = 'num_of_galaxies'";
    392. 

  392.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_num_of_systems ." where config_name = 'num_of_systems'";
    393. 

  393.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $pub_ddr ."' where config_name = 'ddr'";
    394. 

  394.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $pub_astro_strict ."' where config_name = 'astro_strict'";
    395. 

  395.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $pub_uni_arrondi_galaxy ."' where config_name = 'uni_arrondi_galaxy'";
    396. 

  396.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = '" . $pub_uni_arrondi_system ."' where config_name = 'uni_arrondi_system'";
    397. 

  397.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_speed_uni ." where config_name = 'speed_uni'";
    398. 

  398.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_mod_cache ." where config_name = 'mod_cache'";
    399. 

  399.  * @todo Query : "update " . TABLE_CONFIG . " set config_value = " . $pub_config_cache ." where config_name = 'config_cache'";
    400. 

  400.  */
    401. 

  401. function set_serverconfig()
    402. 

  402. {
    403. 

  403.     global $db, $user_data, $server_config;
    404. 

  404.     global $pub_max_battlereport, $pub_max_favorites, $pub_max_favorites_spy, $pub_max_spyreport,
    405. 

  405.         $pub_server_active, $pub_session_time, $pub_max_keeplog, $pub_default_skin, $pub_debug_log,
    406. 

  406.         $pub_reason, $pub_ally_protection, $pub_url_forum, $pub_max_keeprank, $pub_keeprank_criterion,
    407. 

  407.         $pub_max_keepspyreport, $pub_servername, $pub_allied, $pub_disable_ip_check, $pub_num_of_galaxies,
    408. 

  408.         $pub_num_of_systems, $pub_log_phperror, $pub_block_ratio, $pub_ratio_limit, $pub_speed_uni,
    409. 

  409.         $pub_ddr, $pub_astro_strict, $pub_uni_arrondi_galaxy, $pub_uni_arrondi_system, $pub_config_cache, $pub_mod_cache;
    410. 

  410. 

  411. 

  412.     if (!isset($pub_num_of_galaxies))
    413. 

  413.         $pub_num_of_galaxies = intval($server_config['num_of_galaxies']);
    414. 

  414.     if (!isset($pub_num_of_systems))
    415. 

  415.         $pub_num_of_systems = intval($server_config['num_of_systems']);
    416. 

  416. 

  417.     if (!check_var($pub_max_battlereport, "Num") || !check_var($pub_max_favorites,
    418. 

  418.         "Num") || !check_var($pub_max_favorites_spy, "Num") || !check_var($pub_ratio_limit,
    419. 

  419.         "Special", "#^[\w\s,\.\-]+$#") || !check_var($pub_max_spyreport, "Num") || !
    420. 

  420.         check_var($pub_server_active, "Num") || !check_var($pub_session_time, "Num") ||
    421. 

  421.         !check_var($pub_max_keeplog, "Num") || !check_var($pub_default_skin, "URL") || !
    422. 

  422.         check_var($pub_debug_log, "Num") || !check_var($pub_block_ratio, "Num") || !
    423. 

  423.         check_var(stripslashes($pub_reason), "Text") || !check_var($pub_ally_protection,
    424. 

  424.         "Special", "#^[\w\s,\.\-]+$#") || !check_var($pub_url_forum, "URL") || !
    425. 

  425.         check_var($pub_max_keeprank, "Num") || !check_var($pub_keeprank_criterion,
    426. 

  426.         "Char") || !check_var($pub_max_keepspyreport, "Num") || !check_var(stripslashes
    427. 

  427.         ($pub_servername), "Text") || !check_var($pub_allied, "Special", "#^[\w\s,\.\-]+$#") ||
    428. 

  428.         !check_var($pub_disable_ip_check, "Num") || !check_var($pub_num_of_galaxies,
    429. 

  429.         "Galaxies") || !check_var($pub_num_of_systems, "Galaxies") || !check_var($pub_config_cache,
    430. 

  430.         "Num") || !check_var($pub_mod_cache, "Num")) {
    431. 

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

  432.     }
    433. 

  433.     if ($user_data["user_admin"] != 1 && $user_data["user_coadmin"] != 1) {
    434. 

  434.         redirection("planetindex.php?action=message&id_message=forbidden&info");
    435. 

  435.     }
    436. 

  436. 

  437.     if (!isset($pub_max_battlereport) || !isset($pub_max_favorites) || !isset($pub_max_favorites_spy) ||
    438. 

  438.         !isset($pub_ratio_limit) || !isset($pub_max_spyreport) || !isset($pub_session_time) ||
    439. 

  439.         !isset($pub_max_keeplog) || !isset($pub_default_skin) || !isset($pub_reason) ||
    440. 

  440.         !isset($pub_ally_protection) || !isset($pub_url_forum) || !isset($pub_max_keeprank) ||
    441. 

  441.         !isset($pub_keeprank_criterion) || !isset($pub_max_keepspyreport) || !isset($pub_servername) ||
    442. 

  442.         !isset($pub_allied) || !isset($pub_mod_cache) || !isset($pub_config_cache)) {
    443. 

  443.         redirection("index.php?action=message&id_message=setting_serverconfig_failed&info");
    444. 

  444.     }
    445. 

  445. 

  446.     if (is_null($pub_server_active))
    447. 

  447.         $pub_server_active = 0;
    448. 

  448.     if (is_null($pub_disable_ip_check))
    449. 

  449.         $pub_disable_ip_check = 0;
    450. 

  450.     if (is_null($pub_log_phperror))
    451. 

  451.         $pub_log_phperror = 0;
    452. 

  452. 

  453.     if (is_null($pub_debug_log))
    454. 

  454.         $pub_debug_log = 0;
    455. 

  455.     if (is_null($pub_block_ratio))
    456. 

  456.         $pub_block_ratio = 0;
    457. 

  457. 

  458.     $break = false;
    459. 

  459. 

  460. 

  461.     if ($pub_server_active != 0 && $pub_server_active != 1)
    462. 

  462.         $break = true;
    463. 

  463.     if ($pub_debug_log != 0 && $pub_debug_log != 1)
    464. 

  464.         $break = true;
    465. 

  465.     if ($pub_block_ratio != 0 && $pub_block_ratio != 1)
    466. 

  466.         $break = true;
    467. 

  467.     if (!is_numeric($pub_max_favorites))
    468. 

  468.         $break = true;
    469. 

  469.     if (!is_numeric($pub_max_favorites_spy))
    470. 

  470.         $break = true;
    471. 

  471.     if (!is_numeric($pub_ratio_limit))
    472. 

  472.         $break = true;
    473. 

  473.     if (!is_numeric($pub_max_spyreport))
    474. 

  474.         $break = true;
    475. 

  475.     if (!is_numeric($pub_max_battlereport))
    476. 

  476.         $break = true;
    477. 

  477.     if (!is_numeric($pub_session_time))
    478. 

  478.         $break = true;
    479. 

  479.     if (!is_numeric($pub_max_keeplog))
    480. 

  480.         $break = true;
    481. 

  481.     if ($pub_disable_ip_check != 0 && $pub_disable_ip_check != 1)
    482. 

  482.         $break = true;
    483. 

  483.     if ($pub_log_phperror != 0 && $pub_log_phperror != 1)
    484. 

  484.         $break = true;
    485. 

  485. 

  486.     if ($break) {
    487. 

  487.         redirection("index.php?action=message&id_message=setting_serverconfig_failed&info");
    488. 

  488.     }
    489. 

  489. 

  490.     if (($pub_num_of_galaxies != intval($server_config['num_of_galaxies'])) || ($pub_num_of_systems !=
    491. 

  491.         intval($server_config['num_of_systems']))) {
    492. 

  492.         resize_db($pub_num_of_galaxies, $pub_num_of_systems);
    493. 

  493.     }
    494. 

  494.     //
    495. 

  495.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_server_active .
    496. 

  496.         " where config_name = 'server_active'";
    497. 

  497.     $db->sql_query($request);
    498. 

  498. 

  499.     //
    500. 

  500.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_debug_log .
    501. 

  501.         " where config_name = 'debug_log'";
    502. 

  502.     $db->sql_query($request);
    503. 

  503. 

  504.     //
    505. 

  505.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_block_ratio .
    506. 

  506.         " where config_name = 'block_ratio'";
    507. 

  507.     $db->sql_query($request);
    508. 

  508. 

  509.     //
    510. 

  510.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_log_phperror .
    511. 

  511.         " where config_name = 'log_phperror'";
    512. 

  512.     $db->sql_query($request);
    513. 

  513.     //
    514. 

  514.     $pub_max_favorites = intval($pub_max_favorites);
    515. 

  515.     if ($pub_max_favorites < 0)
    516. 

  516.         $pub_max_favorites = 0;
    517. 

  517.     if ($pub_max_favorites > 99)
    518. 

  518.         $pub_max_favorites = 99;
    519. 

  519.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_max_favorites .
    520. 

  520.         " where config_name = 'max_favorites'";
    521. 

  521.     $db->sql_query($request);
    522. 

  522. 

  523.     //
    524. 

  524.     $pub_max_favorites_spy = intval($pub_max_favorites_spy);
    525. 

  525.     if ($pub_max_favorites_spy < 0)
    526. 

  526.         $pub_max_favorites_spy = 0;
    527. 

  527.     if ($pub_max_favorites_spy > 99)
    528. 

  528.         $pub_max_favorites_spy = 99;
    529. 

  529.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_max_favorites_spy .
    530. 

  530.         " where config_name = 'max_favorites_spy'";
    531. 

  531.     $db->sql_query($request);
    532. 

  532. 

  533.     //
    534. 

  534.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_ratio_limit .
    535. 

  535.         " where config_name = 'ratio_limit'";
    536. 

  536.     $db->sql_query($request);
    537. 

  537. 

  538.     //
    539. 

  539.     $pub_max_spyreport = intval($pub_max_spyreport);
    540. 

  540.     if ($pub_max_spyreport < 1)
    541. 

  541.         $pub_max_spyreport = 1;
    542. 

  542.     if ($pub_max_spyreport > 50)
    543. 

  543.         $pub_max_spyreport = 50;
    544. 

  544.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_max_spyreport .
    545. 

  545.         " where config_name = 'max_spyreport'";
    546. 

  546.     $db->sql_query($request);
    547. 

  547. 

  548.     //
    549. 

  549.     $pub_max_battlereport = intval($pub_max_battlereport);
    550. 

  550.     if ($pub_max_battlereport < 0)
    551. 

  551.         $pub_max_battlereport = 0;
    552. 

  552.     if ($pub_max_battlereport > 999)
    553. 

  553.         $pub_max_battlereport = 999;
    554. 

  554.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_max_battlereport .
    555. 

  555.         " where config_name = 'max_battlereport'";
    556. 

  556.     $db->sql_query($request);
    557. 

  557. 

  558.     //
    559. 

  559.     $pub_session_time = intval($pub_session_time);
    560. 

  560.     if ($pub_session_time < 5 && $pub_session_time != 0)
    561. 

  561.         $pub_session_time = 5;
    562. 

  562.     if ($pub_session_time > 180)
    563. 

  563.         $pub_session_time = 180;
    564. 

  564.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_session_time .
    565. 

  565.         " where config_name = 'session_time'";
    566. 

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

  567. 

  568.     //
    569. 

  569.     $pub_max_keeplog = intval($pub_max_keeplog);
    570. 

  570.     if ($pub_max_keeplog < 0)
    571. 

  571.         $pub_max_keeplog = 0;
    572. 

  572.     if ($pub_max_keeplog > 365)
    573. 

  573.         $pub_max_keeplog = 365;
    574. 

  574.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_max_keeplog .
    575. 

  575.         " where config_name = 'max_keeplog'";
    576. 

  576.     $db->sql_query($request);
    577. 

  577. 

  578.     //
    579. 

  579.     if (substr($pub_default_skin, strlen($pub_default_skin) - 1) != "/")
    580. 

  580.         $pub_default_skin .= "/";
    581. 

  581.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $db->
    582. 

  582.         sql_escape_string($pub_default_skin) . "' where config_name = 'default_skin'";
    583. 

  583.     $db->sql_query($request);
    584. 

  584. 

  585.     //
    586. 

  586.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $db->
    587. 

  587.         sql_escape_string($pub_reason) . "' where config_name = 'reason'";
    588. 

  588.     $db->sql_query($request);
    589. 

  589. 

  590.     //
    591. 

  591.     if (substr($pub_ally_protection, strlen($pub_ally_protection) - 1) == ",")
    592. 

  592.         $pub_ally_protection = substr($pub_ally_protection, 0, strlen($pub_ally_protection) -
    593. 

  593.             1);
    594. 

  594.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $db->
    595. 

  595.         sql_escape_string($pub_ally_protection) .
    596. 

  596.         "' where config_name = 'ally_protection'";
    597. 

  597.     $db->sql_query($request);
    598. 

  598. 

  599.     //
    600. 

  600.     if ($pub_url_forum != "" && !preg_match("#^http://#", $pub_url_forum))
    601. 

  601.         $pub_url_forum = "http://" . $pub_url_forum;
    602. 

  602.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $db->
    603. 

  603.         sql_escape_string($pub_url_forum) . "' where config_name = 'url_forum'";
    604. 

  604.     $db->sql_query($request);
    605. 

  605. 

  606.     //
    607. 

  607.     $pub_max_keeprank = intval($pub_max_keeprank);
    608. 

  608.     if ($pub_max_keeprank < 1)
    609. 

  609.         $pub_max_keeprank = 1;
    610. 

  610.     if ($pub_max_keeprank > 999)
    611. 

  611.         $pub_max_keeprank = 999;
    612. 

  612.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_max_keeprank .
    613. 

  613.         " where config_name = 'max_keeprank'";
    614. 

  614.     $db->sql_query($request);
    615. 

  615. 

  616.     //
    617. 

  617.     if ($pub_keeprank_criterion != "quantity" && $pub_keeprank_criterion != "day")
    618. 

  618.         $pub_keeprank_criterion = "quantity";
    619. 

  619.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $db->
    620. 

  620.         sql_escape_string($pub_keeprank_criterion) .
    621. 

  621.         "' where config_name = 'keeprank_criterion'";
    622. 

  622.     $db->sql_query($request);
    623. 

  623. 

  624.     //
    625. 

  625.     $pub_max_keepspyreport = intval($pub_max_keepspyreport);
    626. 

  626.     if ($pub_max_keepspyreport < 1)
    627. 

  627.         $pub_max_keepspyreport = 1;
    628. 

  628.     if ($pub_max_keepspyreport > 999)
    629. 

  629.         $pub_max_keepspyreport = 999;
    630. 

  630.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_max_keepspyreport .
    631. 

  631.         " where config_name = 'max_keepspyreport'";
    632. 

  632.     $db->sql_query($request);
    633. 

  633. 

  634.     //
    635. 

  635.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $db->
    636. 

  636.         sql_escape_string($pub_servername) . "' where config_name = 'servername'";
    637. 

  637.     $db->sql_query($request);
    638. 

  638. 

  639.     //
    640. 

  640.     if (substr($pub_allied, strlen($pub_allied) - 1) == ",")
    641. 

  641.         $pub_allied = substr($pub_allied, 0, strlen($pub_allied) - 1);
    642. 

  642.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $db->
    643. 

  643.         sql_escape_string($pub_allied) . "' where config_name = 'allied'";
    644. 

  644.     $db->sql_query($request);
    645. 

  645. 

  646.     //
    647. 

  647.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_disable_ip_check .
    648. 

  648.         " where config_name = 'disable_ip_check'";
    649. 

  649.     $db->sql_query($request);
    650. 

  650. 

  651.     //
    652. 

  652.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_num_of_galaxies .
    653. 

  653.         " where config_name = 'num_of_galaxies'";
    654. 

  654.     $db->sql_query($request);
    655. 

  655. 

  656.     //
    657. 

  657.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_num_of_systems .
    658. 

  658.         " where config_name = 'num_of_systems'";
    659. 

  659.     $db->sql_query($request);
    660. 

  660. 

  661.     //
    662. 

  662.     if (!isset($pub_ddr) || !is_numeric($pub_ddr))
    663. 

  663.         $pub_ddr = 0;
    664. 

  664.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $pub_ddr .
    665. 

  665.         "' where config_name = 'ddr'";
    666. 

  666.     $db->sql_query($request);
    667. 

  667. 

  668.     //
    669. 

  669.     if (!isset($pub_astro_strict) || !is_numeric($pub_astro_strict))
    670. 

  670.         $pub_astro_strict = 0;
    671. 

  671.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $pub_astro_strict .
    672. 

  672.         "' where config_name = 'astro_strict'";
    673. 

  673.     $db->sql_query($request);
    674. 

  674. 

  675.     //
    676. 

  676.     if (!isset($pub_uni_arrondi_galaxy) || !is_numeric($pub_uni_arrondi_galaxy))
    677. 

  677.         $pub_uni_arrondi_galaxy = 0;
    678. 

  678.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $pub_uni_arrondi_galaxy .
    679. 

  679.         "' where config_name = 'uni_arrondi_galaxy'";
    680. 

  680.     $db->sql_query($request);
    681. 

  681.     
    682. 

  682.     //
    683. 

  683.     if (!isset($pub_uni_arrondi_system) || !is_numeric($pub_uni_arrondi_system))
    684. 

  684.         $pub_uni_arrondi_system = 0;
    685. 

  685.     $request = "update " . TABLE_CONFIG . " set config_value = '" . $pub_uni_arrondi_system .
    686. 

  686.         "' where config_name = 'uni_arrondi_system'";
    687. 

  687.     $db->sql_query($request);
    688. 

  688.     
    689. 

  689.     //
    690. 

  690.     if (!is_numeric($pub_speed_uni) || $pub_speed_uni < 1)
    691. 

  691.         $pub_speed_uni = 1;
    692. 

  692.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_speed_uni .
    693. 

  693.         " where config_name = 'speed_uni'";
    694. 

  694.     $db->sql_query($request);
    695. 

  695. 

  696.     //
    697. 

  697.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_mod_cache .
    698. 

  698.         " where config_name = 'mod_cache'";
    699. 

  699.     $db->sql_query($request);
    700. 

  700. 

  701.     //
    702. 

  702.     $request = "update " . TABLE_CONFIG . " set config_value = " . $pub_config_cache .
    703. 

  703.         " where config_name = 'config_cache'";
    704. 

  704.     $db->sql_query($request);
    705. 

  705. 

  706. 

  707.     // mise a jour des caches avec les mofids
    708. 

  708.     generate_config_cache();
    709. 

  709.     log_("set_serverconfig");
    710. 

  710.     redirection("index.php?action=administration&subaction=parameter");
    711. 

  711. }
    712. 

  712. /**
    713. 

  713.  * Returns the Status of the Database used size.
    714. 

  714.  * @return Array [Server], et [Total]
    715. 

  715.  * @todo : Query : "SHOW TABLE STATUS"
    716. 

  716.  */
    717. 

  717. function db_size_info()
    718. 

  718. {
    719. 

  719.     global $db;
    720. 

  720.     global $table_prefix;
    721. 

  721. 

  722.     $dbSizeServer = 0;
    723. 

  723.     $dbSizeTotal = 0;
    724. 

  724. 

  725.     $request = "SHOW TABLE STATUS";
    726. 

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

  727.     while ($row = $db->sql_fetch_assoc($result)) {
    728. 

  728.         $dbSizeTotal += $row['Data_length'] + $row['Index_length'];
    729. 

  729.         if (preg_match("#^" . $table_prefix . ".*$#", $row['Name'])) {
    730. 

  730.             $dbSizeServer += $row['Data_length'] + $row['Index_length'];
    731. 

  731.         }
    732. 

  732.     }
    733. 

  733. 

  734.     $bytes = array('Octets', 'Ko', 'Mo', 'Go', 'To');
    735. 

  735. 

  736.     if ($dbSizeServer < 1024)
    737. 

  737.         $dbSizeServer = 1;
    738. 

  738.     for ($i = 0; $dbSizeServer > 1024; $i++)
    739. 

  739.         $dbSizeServer /= 1024;
    740. 

  740.     $dbSize_info["Server"] = round($dbSizeServer, 2) . " " . $bytes[$i];
    741. 

  741. 

  742.     if ($dbSizeTotal < 1024)
    743. 

  743.         $dbSizeTotal = 1;
    744. 

  744.     for ($i = 0; $dbSizeTotal > 1024; $i++)
    745. 

  745.         $dbSizeTotal /= 1024;
    746. 

  746.     $dbSize_info["Total"] = round($dbSizeTotal, 2) . " " . $bytes[$i];
    747. 

  747. 

  748.     return $dbSize_info;
    749. 

  749. }
    750. 

  750. /**
    751. 

  751.  * Function to Optimize all tables of the OGSpy Database
    752. 

  752.  * @param boolean $maintenance_action true if no url redirection is requested,false to redirect to another page
    753. 

  753.  * @todo : Query : "SHOW TABLES"
    754. 

  754.  */
    755. 

  755. function db_optimize($maintenance_action = false)
    756. 

  756. {
    757. 

  757.     global $db;
    758. 

  758. 

  759.     $dbSize_before = db_size_info();
    760. 

  760.     $dbSize_before = $dbSize_before["Total"];
    761. 

  761. 

  762.     $request = 'SHOW TABLES';
    763. 

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

  764.     while (list($table) = $db->sql_fetch_row($res)) {
    765. 

  765.         $request = 'OPTIMIZE TABLE ' . $table;
    766. 

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

  767.     }
    768. 

  768.     // 09-07-2012 : Commenté car cette table n'est plus utilisée
    769. 

  769.     //$request = 'TRUNCATE ' . TABLE_UNIVERSE_TEMPORARY;
    770. 

  770.     //$db->sql_query($request);
    771. 

  771. 

  772.     $dbSize_after = db_size_info();
    773. 

  773.     $dbSize_after = $dbSize_after["Total"];
    774. 

  774. 

  775.     if (!$maintenance_action) {
    776. 

  776.         redirection("index.php?action=message&id_message=db_optimize&info=" . $dbSize_before .
    777. 

  777.             "¤" . $dbSize_after);
    778. 

  778.     }
    779. 

  779. }
    780. 

  780. /**
    781. 

  781.  * Adapt the database to fit on the number of galaxies and solar systems
    782. 

  782.  * @param int $new_num_of_galaxies Galaxy total
    783. 

  783.  * @param int $new_num_of_systems Solar Systems total
    784. 

  784.  * @return null
    785. 

  785.  * @todo : Query : sql_query("DELETE FROM " . TABLE_UNIVERSE . " WHERE galaxy > $new_num_of_galaxies");
    786. 

  786.  * @todo : Query : sql_query("UPDATE " . TABLE_USER . " SET user_galaxy=1 WHERE user_galaxy > $new_num_of_galaxies");
    787. 

  787.  * @todo : Query : sql_query("DELETE FROM " . TABLE_USER_FAVORITE . " WHERE galaxy > $new_num_of_galaxies");
    788. 

  788.  * @todo : Query : sql_query("DELETE FROM " . TABLE_UNIVERSE . " WHERE system > $new_num_of_systems");
    789. 

  789.  * @todo : Query : sql_query("UPDATE " . TABLE_USER . " SET user_system=1 WHERE user_system > $new_num_of_systems");
    790. 

  790.  * @todo : Query : sql_query("DELETE FROM " . TABLE_USER_FAVORITE . " WHERE system > $new_num_of_systems");
    791. 

  791.  * @todo : Query : "ALTER TABLE `" . TABLE_UNIVERSE . "` CHANGE `galaxy` `galaxy` ENUM("; -> Voir Fonction
    792. 

  792.  * @todo : Query : "ALTER TABLE `" . TABLE_USER ." CHANGE `user_galaxy` `user_galaxy` -> Voir fonction
    793. 

  793.  * @todo : Query : $request = "ALTER TABLE `" . TABLE_USER_FAVORITE ."` CHANGE `galaxy` `galaxy` ENUM(" -> Voir fonction
    794. 

  794.  * @todo : Query : "REPLACE INTO " . TABLE_CONFIG ." (config_name, config_value) VALUES ('num_of_galaxies','$new_num_of_galaxies')";
    795. 

  795.  * @todo : Query : $requests = "REPLACE INTO " . TABLE_CONFIG ." (config_name, config_value) VALUES ('num_of_systems','$new_num_of_systems')";
    796. 

  796. */
    797. 

  797. function resize_db($new_num_of_galaxies, $new_num_of_systems)
    798. 

  798. {
    799. 

  799.     global $db, $db_host, $db_user, $db_password, $db_database, $table_prefix, $server_config;
    800. 

  800. 

  801.     // si on reduit on doit supprimez toutes les entrées qui font reference au systemes ou galaxies que l'on va enlever
    802. 

  802.     if ($new_num_of_galaxies < intval($server_config['num_of_galaxies'])) {
    803. 

  803.         $db->sql_query("DELETE FROM " . TABLE_UNIVERSE . " WHERE galaxy > $new_num_of_galaxies");
    804. 

  804.         $db->sql_query("UPDATE " . TABLE_USER . " SET user_galaxy=1 WHERE user_galaxy > $new_num_of_galaxies");
    805. 

  805.         $db->sql_query("DELETE FROM " . TABLE_USER_FAVORITE . " WHERE galaxy > $new_num_of_galaxies");
    806. 

  806.     }
    807. 

  807.     if ($new_num_of_systems < intval($server_config['num_of_systems'])) {
    808. 

  808.         $db->sql_query("DELETE FROM " . TABLE_UNIVERSE . " WHERE system > $new_num_of_systems");
    809. 

  809.         $db->sql_query("UPDATE " . TABLE_USER . " SET user_system=1 WHERE user_system > $new_num_of_systems");
    810. 

  810.         $db->sql_query("DELETE FROM " . TABLE_USER_FAVORITE . " WHERE system > $new_num_of_systems");
    811. 

  811.     }
    812. 

  812. 

  813.     $request = "ALTER TABLE `" . TABLE_UNIVERSE . "` CHANGE `galaxy` `galaxy` ENUM(";
    814. 

  814.     for ($i = 1; $i < $new_num_of_galaxies; $i++)
    815. 

  815.         $request .= "'$i' , ";
    816. 

  816.     $request .= "'$new_num_of_galaxies') NOT NULL DEFAULT '1'";
    817. 

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

  818. 

  819.     $request = "ALTER TABLE `" . TABLE_USER .
    820. 

  820.         "` CHANGE `user_galaxy` `user_galaxy` ENUM(";
    821. 

  821.     for ($i = 1; $i < $new_num_of_galaxies; $i++)
    822. 

  822.         $request .= "'$i' , ";
    823. 

  823.     $request .= "'$new_num_of_galaxies') NOT NULL DEFAULT '1'";
    824. 

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

  825. 

  826.     $request = "ALTER TABLE `" . TABLE_USER_FAVORITE .
    827. 

  827.         "` CHANGE `galaxy` `galaxy` ENUM(";
    828. 

  828.     for ($i = 1; $i < $new_num_of_galaxies; $i++)
    829. 

  829.         $request .= "'$i' , ";
    830. 

  830.     $request .= "'$new_num_of_galaxies') NOT NULL DEFAULT '1'";
    831. 

  831.     $db->sql_query($request);
    832. 

  832. 

  833.     $server_config['num_of_galaxies'] = "$new_num_of_galaxies";
    834. 

  834.     $server_config['num_of_systems'] = "$new_num_of_systems";
    835. 

  835.     $requests = "REPLACE INTO " . TABLE_CONFIG .
    836. 

  836.         " (config_name, config_value) VALUES ('num_of_galaxies','$new_num_of_galaxies')";
    837. 

  837.     $db->sql_query($request);
    838. 

  838.     $requests = "REPLACE INTO " . TABLE_CONFIG .
    839. 

  839.         " (config_name, config_value) VALUES ('num_of_systems','$new_num_of_systems')";
    840. 

  840.     $db->sql_query($request);
    841. 

  841. 

  842.     log_("set_db_size");
    843. 

  843. }
    844. 

  844. /**
    845. 

  845.  * File Log size on the Server
    846. 

  846.  * @return Array tableau [type] and [size]
    847. 

  847.  */
    848. 

  848. function log_size_info()
    849. 

  849. {
    850. 

  850.     $logSize = 0;
    851. 

  851.     $res = opendir(PATH_LOG);
    852. 

  852.     $directory = array();
    853. 

  853.     //Récupération de la liste des fichiers présents dans les répertoires répertoriés
    854. 

  854.     while ($file = readdir($res)) {
    855. 

  855.         if ($file != "." && $file != "..") {
    856. 

  856.             if (is_dir(PATH_LOG . $file)) {
    857. 

  857.                 $directory[] = PATH_LOG . $file;
    858. 

  858.             }
    859. 

  859.         }
    860. 

  860.     }
    861. 

  861.     closedir($res);
    862. 

  862. 

  863.     foreach ($directory as $v) {
    864. 

  864.         $res = opendir($v);
    865. 

  865.         $directory = array();
    866. 

  866.         //Récupération de la liste des fichiers présents dans les répertoires répertoriés
    867. 

  867.         while ($file = readdir($res)) {
    868. 

  868.             if ($file != "." && $file != "..") {
    869. 

  869.                 $logSize += @filesize($v . "/" . $file);
    870. 

  870.             }
    871. 

  871.         }
    872. 

  872.         closedir($res);
    873. 

  873.     }
    874. 

  874. 

  875.     $bytes = array('Octets', 'Ko', 'Mo', 'Go', 'To');
    876. 

  876. 

  877.     if ($logSize < 1024)
    878. 

  878.         $logSize = 1;
    879. 

  879. 

  880.     for ($i = 0; $logSize > 1024; $i++)
    881. 

  881.         $logSize /= 1024;
    882. 

  882. 

  883.     $log_size_info['size'] = round($logSize, 2);
    884. 

  884.     $log_size_info['type'] = $bytes[$i];
    885. 

  885. 

  886.     return $log_size_info;
    887. 

  887. }
    888. 

  888. /**
    889. 

  889.  * Checks the availability of a log File
    890. 

  890.  * @param int $date Requested Date 
    891. 

  891.  * @return boolean true if the log file exists
    892. 

  892.  * @internal To be improved...
    893. 

  893.  */
    894. 

  894. function log_check_exist($date)
    895. 

  895. {
    896. 

  896.     if (!isset($date))
    897. 

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

  898. 

  899.     $typelog = array("sql", "log", "txt");
    900. 

  900. 

  901.     $root = PATH_LOG;
    902. 

  902.     $path = opendir("$root");
    903. 

  903. 

  904.     //Récupération de la liste des répertoires correspondant à cette date
    905. 

  905.     while ($file = readdir($path)) {
    906. 

  906.         if ($file != "." && $file != "..") {
    907. 

  907.             if (is_dir($root . $file) && preg_match("/^" . $date . "/", $file))
    908. 

  908.                 $directories[] = $file;
    909. 

  909.         }
    910. 

  910.     }
    911. 

  911.     closedir($path);
    912. 

  912. 

  913.     if (!isset($directories)) {
    914. 

  914.         return false;
    915. 

  915.     }
    916. 

  916. 

  917.     foreach ($directories as $d) {
    918. 

  918.         $path = opendir($root . $d);
    919. 

  919. 

  920.         while ($file = readdir($path)) {
    921. 

  921.             if ($file != "." && $file != "..") {
    922. 

  922.                 $extension = substr($file, (strrpos($file, ".") + 1));
    923. 

  923.                 if (in_array($extension, $typelog)) {
    924. 

  924.                     $files[] = $d . "/" . $file;
    925. 

  925.                 }
    926. 

  926.             }
    927. 

  927.         }
    928. 

  928.         closedir($path);
    929. 

  929.     }
    930. 

  930. 

  931.     if (!isset($files)) {
    932. 

  932.         return false;
    933. 

  933.     }
    934. 

  934. 

  935.     return true;
    936. 

  936. }
    937. 

  937. /**
    938. 

  938.  * Sends a Compressed archive to the browser for a specific date
    939. 

  939.  * @global array $user_data
    940. 

  940.  */
    941. 

  941. function log_extractor()
    942. 

  942. {
    943. 

  943.     global $pub_date, $user_data;
    944. 

  944. 

  945.     if ($user_data["user_admin"] != 1 && $user_data["user_coadmin"] != 1) {
    946. 

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

  947.     }
    948. 

  948. 

  949.     if (!isset($pub_date))
    950. 

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

  951. 	
    952. 

  952. 	$typelog = array("sql", "log", "txt");
    953. 

  953. 

  954.     $root = PATH_LOG;
    955. 

  955. 	$zip_file= $root."log.zip";
    956. 

  956.     $path = opendir("$root");
    957. 

  957. 	unlink($zip_file);
    958. 

  958. 	
    959. 

  959.     //Récupération de la liste des répertoires correspondant à cette date
    960. 

  960.     while ($file = readdir($path)) {
    961. 

  961.         if ($file != "." && $file != "..") {
    962. 

  962.             if (is_dir($root . $file) && preg_match("/^" . $pub_date . "/", $file))
    963. 

  963.                 $directories[] = $file;
    964. 

  964.         }
    965. 

  965.     }
    966. 

  966.     closedir($path);
    967. 

  967. 

  968.     if (!isset($directories)) {
    969. 

  969.         redirection("index.php?action=message&id_message=log_missing&info");
    970. 

  970.     }
    971. 

  971. 

  972.     foreach ($directories as $d) {
    973. 

  973.         $path = opendir($root . $d);
    974. 

  974. 

  975.         while ($file = readdir($path)) {
    976. 

  976.             if ($file != "." && $file != "..") {
    977. 

  977.                 $extension = substr($file, (strrpos($file, ".") + 1));
    978. 

  978.                 if (in_array($extension, $typelog)) {
    979. 

  979.                     $files[] = $d . "/" . $file;
    980. 

  980.                 }
    981. 

  981.             }
    982. 

  982.         }
    983. 

  983.         closedir($path);
    984. 

  984.     }
    985. 

  985. 

  986.     if (!isset($files)) {
    987. 

  987.         redirection("index.php?action=message&id_message=log_missing&info");
    988. 

  988.     }
    989. 

  989. 

  990.     // création d'un objet 'zipfile'
    991. 

  991. 	
    992. 

  992. 	$zip = new ZipArchive;
    993. 

  993. 	$zip->open($zip_file, ZipArchive::CREATE);
    994. 

  994.     foreach ($files as $filename) {
    995. 

  995.         // ajout du fichier dans cet objet
    996. 

  996.         $zip->addFile($root.$filename);
    997. 

  997. 		log_('debug',"fichier dans archive:".$filename);
    998. 

  998. 		}
    999. 

  999. 	
    1000. 

  1000. 	// production de l'archive Zip
    1001. 

  1001.     $zip->close();
    1002. 

  1002. 

  1003.     // entêtes HTTP
    1004. 

  1004.     header('Content-Type: application/x-zip');
    1005. 

  1005.     // force le téléchargement
    1006. 

  1006.     header('Content-disposition: attachment; filename=log_' . $pub_date . '.zip');
    1007. 

  1007. 	header('Content-Transfer-Encoding: binary');
    1008. 

  1008. 

  1009.     // envoi du fichier au navigateur
    1010. 

  1010.     flush();
    1011. 

  1011. 	readfile($zip_file);
    1012. 

  1012. }
    1013. 

  1013. 

  1014. /**
    1015. 

  1015.  * Deletes a specified Log File
    1016. 

  1016.  *
    1017. 

  1017.  */
    1018. 

  1018. function log_remove()
    1019. 

  1019. {
    1020. 

  1020.     global $pub_date, $user_data, $pub_directory;
    1021. 

  1021. 

  1022.     if ($user_data["user_admin"] != 1 && $user_data["user_coadmin"] != 1)
    1023. 

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

  1024. 

  1025.     if ($pub_directory == true) {
    1026. 

  1026.         @unlink("journal/" . $pub_date . "/log_" . $pub_date . ".log");
    1027. 

  1027.         @unlink("journal/" . $pub_date . "/index.htm");
    1028. 

  1028.         if (rmdir("journal/" . $pub_date)) {
    1029. 

  1029.             redirection("index.php?action=message&id_message=log_remove&info");
    1030. 

  1030.         } else {
    1031. 

  1031.             redirection("index.php?action=message&id_message=log_missing&info");
    1032. 

  1032.         }
    1033. 

  1033.     } else {
    1034. 

  1034.         if (unlink("journal/" . $pub_date . "/log_" . $pub_date . ".log")) {
    1035. 

  1035.             redirection("index.php?action=message&id_message=log_remove&info");
    1036. 

  1036.         } else {
    1037. 

  1037.             redirection("index.php?action=message&id_message=log_missing&info");
    1038. 

  1038.         }
    1039. 

  1039.     }
    1040. 

  1040. }
    1041. 

  1041. 

  1042. /**
    1043. 

  1043.  * Log file cleaning according the the Server configuration
    1044. 

  1044.  */
    1045. 

  1045. function log_purge()
    1046. 

  1046. {
    1047. 

  1047.     global $server_config;
    1048. 

  1048. 

  1049.     $time = $server_config["max_keeplog"];
    1050. 

  1050.     $limit = time() - (60 * 60 * 24 * $time);
    1051. 

  1051.     $limit = intval(date("ymd", $limit));
    1052. 

  1052. 

  1053.     $root = PATH_LOG;
    1054. 

  1054.     $path = opendir("$root");
    1055. 

  1055.     while ($file = readdir($path)) {
    1056. 

  1056.         if ($file != "." && $file != "..") {
    1057. 

  1057.             if (is_dir($root . $file) && intval($file) < $limit && @ereg("[0-9]{6}", $file)) {
    1058. 

  1058.                 $directories[] = $file;
    1059. 

  1059.             }
    1060. 

  1060.         }
    1061. 

  1061.     }
    1062. 

  1062.     closedir($path);
    1063. 

  1063. 

  1064.     if (!isset($directories)) {
    1065. 

  1065.         return;
    1066. 

  1066.     }
    1067. 

  1067. 

  1068.     $files = array();
    1069. 

  1069.     foreach ($directories as $d) {
    1070. 

  1070.         $path = opendir($root . $d);
    1071. 

  1071. 

  1072.         while ($file = readdir($path)) {
    1073. 

  1073.             if ($file != "." && $file != "..") {
    1074. 

  1074.                 $extension = substr($file, (strrpos($file, ".") + 1));
    1075. 

  1075.                 unlink($root . $d . "/" . $file);
    1076. 

  1076.             }
    1077. 

  1077.         }
    1078. 

  1078.         closedir($path);
    1079. 

  1079.         rmdir($root . $d);
    1080. 

  1080.     }
    1081. 

  1081. }
    1082. 

  1082. /**
    1083. 

  1083.  * Formats a number.
    1084. 

  1084.  * @param int $number The value to be converted
    1085. 

  1085.  * @param int $decimal Sets the number of decimal points.
    1086. 

  1086.  * @return string The number with the new formatting
    1087. 

  1087.  */
    1088. 

  1088. function formate_number($number, $decimal = 0)
    1089. 

  1089. {
    1090. 

  1090.     return number_format($number, $decimal, ",", " ");
    1091. 

  1091. }
    1092. 

  1092. 

  1093. /**
    1094. 

  1094.  * Server Maintenance (Cleaning of Galaxy, Spy reports and Logs)
    1095. 

  1095.  */
    1096. 

  1096. function maintenance_action()
    1097. 

  1097. {
    1098. 

  1098.     global $db, $server_config;
    1099. 

  1099. 

  1100.     $time = mktime(0, 0, 0);
    1101. 

  1101.     if (isset($server_config["last_maintenance_action"]) && $time > $server_config["last_maintenance_action"]) {
    1102. 

  1102.         galaxy_purge_ranking();
    1103. 

  1103.         log_purge();
    1104. 

  1104.         galaxy_purge_spy();
    1105. 

  1105.         
    1106. 

  1106.         $request = "update " . TABLE_CONFIG . " set config_value = '" . $time . "' where config_name = 'last_maintenance_action'";
    1107. 

  1107.         $db->sql_query($request);
    1108. 

  1108.     }
    1109. 

  1109. }
    1110. 

  1110. /**
    1111. 

  1111.  * Security Function : Variable Verification according the type(Pseudo, Password, string, number,...)
    1112. 

  1112.  * @param string $value Value of the data to check
    1113. 

  1113.  * @param string $type_check Type of the value (Pseudo_Groupname, Pseudo_ingame, Password, Text, CharNum, Char, Num, Galaxies, URL, Special)
    1114. 

  1114.  * @param string $mask Can be used to specify a Regex for the check when the type is set as Special
    1115. 

  1115.  * @param boolean $auth_null Workarround linked to the authentification
    1116. 

  1116.  * @return boolean true if the value is ok or empty and false if the checking has failed.
    1117. 

  1117.  */
    1118. 

  1118. function check_var($value, $type_check, $mask = "", $auth_null = true)
    1119. 

  1119. {
    1120. 

  1120.     if ($auth_null && $value == "") {
    1121. 

  1121.         return true;
    1122. 

  1122.     }
    1123. 

  1123. 

  1124.     switch ($type_check) {
    1125. 

  1125.             //Pseudo des membres
    1126. 

  1126.         case "Pseudo_Groupname":
    1127. 

  1127.             if (!preg_match("#^[\w\s\-]{3,15}$#", $value)) {
    1128. 

  1128.                 log_("check_var", array("Pseudo_Groupname", $value));
    1129. 

  1129.                 return false;
    1130. 

  1130.             }
    1131. 

  1131.             break;
    1132. 

  1132. 

  1133.         //Pseudo ingame
    1134. 

  1134.         case "Pseudo_ingame": // caracteres autorises entre 3 et 20 ( interdit au 05/11/11 = > &"'()# `/,;+ ) 
    1135. 

  1135.             if (!preg_match("#^[\w@äàçéèêëïîöôûü\^\{\}\[\]\.\*\-_~%§]{3,20}$#", $value)) {
    1136. 

  1136.                 log_("check_var", array("Text", $value));
    1137. 

  1137.                 return false;
    1138. 

  1138.             }
    1139. 

  1139.             break;
    1140. 

  1140. 

  1141.             //Mot de passe des membres
    1142. 

  1142.         case "Password":
    1143. 

  1143.             if (!preg_match("#^[\w\s\-]{6,20}$#", $value)) {
    1144. 

  1144.                 return false;
    1145. 

  1145.             }
    1146. 

  1146.             break;
    1147. 

  1147. 

  1148.             //Chaîne de caractères avec espace
    1149. 

  1149.         case "Text":
    1150. 

  1150.             if (!preg_match("#^[\w'äàçéèêëïîöôûü\s\.\*\-]+$#", $value)) {
    1151. 

  1151.                 log_("check_var", array("Text", $value));
    1152. 

  1152.                 return false;
    1153. 

  1153.             }
    1154. 

  1154.             break;
    1155. 

  1155. 

  1156.             //Chaîne de caractères et  chiffre
    1157. 

  1157.         case "CharNum":
    1158. 

  1158.             if (!preg_match("#^[\w\.\*\-\#]+$#", $value)) {
    1159. 

  1159.                 log_("check_var", array("CharNum", $value));
    1160. 

  1160.                 return false;
    1161. 

  1161.             }
    1162. 

  1162.             break;
    1163. 

  1163. 

  1164.             //Caractères
    1165. 

  1165.         case "Char":
    1166. 

  1166.             if (!preg_match("#^[[:alpha:]_\.\*\-]+$#", $value)) {
    1167. 

  1167.                 log_("check_var", array("Char", $value));
    1168. 

  1168.                 return false;
    1169. 

  1169.             }
    1170. 

  1170.             break;
    1171. 

  1171. 

  1172.             //Chiffres
    1173. 

  1173.         case "Num":
    1174. 

  1174.             if (!preg_match("#^[[:digit:]]+$#", $value)) {
    1175. 

  1175.                 log_("check_var", array("Num", $value));
    1176. 

  1176.                 return false;
    1177. 

  1177.             }
    1178. 

  1178.             break;
    1179. 

  1179. 		            //Chiffres
    1180. 

  1180.         case "Email":
    1181. 

  1181.             if (!preg_match('#^[\w.-]+@[\w.-]+\.[a-zA-Z]{2,6}$#', $value)) {
    1182. 

  1182.                 log_("check_var", array("Email", $value));
    1183. 

  1183.                 return false;
    1184. 

  1184.             }
    1185. 

  1185.             break;	
    1186. 

  1186. 

  1187.             //Galaxies
    1188. 

  1188.         case "Galaxies":
    1189. 

  1189.             if ($value < 1 || $value > 999) {
    1190. 

  1190.                 log_("check_var", array("Galaxy or system", $value));
    1191. 

  1191.                 return false;
    1192. 

  1192.             }
    1193. 

  1193.             break;
    1194. 

  1194. 

  1195.             //Adresse internet
    1196. 

  1196.         case "URL":
    1197. 

  1197.             if (!preg_match("#^(((?:http?)://)?(?(2)(www\.)?|(www\.){1})?[-a-z0-9~_]{2,}(\.[-a-z0-9~._]{2,})?[-a-z0-9~_\/&\?=.]{2,})$#i",
    1198. 

  1198.                 $value)) {
    1199. 

  1199.                 log_("check_var", array("URL", $value));
    1200. 

  1200.                 return false;
    1201. 

  1201.             }
    1202. 

  1202.             break;
    1203. 

  1203. 

  1204.             //Planète, Joueur et alliance
    1205. 

  1205.         case "Galaxy":
    1206. 

  1206.             //		if (!preg_match("#^[\w\s\.\*\-]+$#", $value)) {
    1207. 

  1207.             //			log_("check_var", array("Galaxy", $value));
    1208. 

  1208.             //			return false;
    1209. 

  1209.             //		}
    1210. 

  1210.             break;
    1211. 

  1211. 

  1212.             //Rapport d'espionnage
    1213. 

  1213.         case "Spyreport":
    1214. 

  1214.             //		if (!preg_match("#^[\w\s\[\]\:\-'%\.\*]+$#", $value)) {
    1215. 

  1215.             //			log_("check_var", array("Spyreport", $value));
    1216. 

  1216.             //			return false;
    1217. 

  1217.             //		}
    1218. 

  1218.             break;
    1219. 

  1219. 

  1220.             //Masque paramétrable
    1221. 

  1221.         case "Special":
    1222. 

  1222.             if (!preg_match($mask, $value)) {
    1223. 

  1223.                 log_("check_var", array("Special", $value));
    1224. 

  1224.                 return false;
    1225. 

  1225.             }
    1226. 

  1226.             break;
    1227. 

  1227. 

  1228.         default:
    1229. 

  1229.             return false;
    1230. 

  1230.     }
    1231. 

  1231. 

  1232.     return true;
    1233. 

  1233. }
    1234. 

  1234. /**
    1235. 

  1235.  * Resets the User for imported datas.
    1236. 

  1236.  * @param boolean $maintenance_action If true the function does not redirect the user to the raz_ration Page
    1237. 

  1237.  */
    1238. 

  1238. function admin_raz_ratio($maintenance_action = false)
    1239. 

  1239. {
    1240. 

  1240.     global $db, $user_data;
    1241. 

  1241. 

  1242.     if ($user_data["user_admin"] != 1 && $user_data["user_coadmin"] != 1 && $user_data["management_user"] !=
    1243. 

  1243.         1) {
    1244. 

  1244.         die("Acces interdit");
    1245. 

  1245.     }
    1246. 

  1246. 

  1247.     $request = "UPDATE " . TABLE_USER . " set search='0'";
    1248. 

  1248.     $db->sql_query($request);
    1249. 

  1249. 

  1250.     if (!$maintenance_action) {
    1251. 

  1251.         redirection("index.php?action=message&id_message=raz_ratio&info");
    1252. 

  1252.     }
    1253. 

  1253. }
    1254. 

  1254. /**
    1255. 

  1255.  *  Microtime Value formatted for benchmark functions
    1256. 

  1256.  * @return int Current microtime
    1257. 

  1257.  */
    1258. 

  1258. function benchmark()
    1259. 

  1259. {
    1260. 

  1260.     $mtime = microtime();
    1261. 

  1261.     $mtime = explode(" ", $mtime);
    1262. 

  1262.     $mtime = $mtime[1] + $mtime[0];
    1263. 

  1263. 

  1264.     return $mtime;
    1265. 

  1265. }
    1266. 

  1266. /**
    1267. 

  1267.  * Security : HTTP GET Data verifications
    1268. 

  1268.  * @param string $secvalue The value to be checked
    1269. 

  1269.  * @return boolean true if the verification is ok
    1270. 

  1270.  */
    1271. 

  1271. function check_getvalue($secvalue)
    1272. 

  1272. {
    1273. 

  1273.     if (!is_array($secvalue)) {
    1274. 

  1274.         if ((preg_match("/<[^>]*script*\"?[^>]*>/i", $secvalue)) || (preg_match("/<[^>]*object*\"?[^>]*>/i",
    1275. 

  1275.             $secvalue)) || (preg_match("/<[^>]*iframe*\"?[^>]*>/i", $secvalue)) || (preg_match
    1276. 

  1276.             ("/<[^>]*applet*\"?[^>]*>/i", $secvalue)) || (preg_match("/<[^>]*meta*\"?[^>]*>/i",
    1277. 

  1277.             $secvalue)) || (preg_match("/<[^>]*style*\"?[^>]*>/i", $secvalue)) || (preg_match
    1278. 

  1278.             ("/<[^>]*form*\"?[^>]*>/i", $secvalue)) || (preg_match("/<[^>]*img*\"?[^>]*>/i",
    1279. 

  1279.             $secvalue)) || (preg_match("/\([^>]*\"?[^)]*\)/i", $secvalue)) || (preg_match("/\"/i",
    1280. 

  1280.             $secvalue))) {
    1281. 

  1281.             return false;
    1282. 

  1282.         }
    1283. 

  1283.     } else {
    1284. 

  1284.         foreach ($secvalue as $subsecvalue) {
    1285. 

  1285.             if (!check_getvalue($subsecvalue))
    1286. 

  1286.                 return false;
    1287. 

  1287.         }
    1288. 

  1288.     }
    1289. 

  1289.     return true;
    1290. 

  1290. }
    1291. 

  1291. /**
    1292. 

  1292.  * Security : HTTP POST Data verifications
    1293. 

  1293.  * @param string $secvalue The value to be checked
    1294. 

  1294.  * @return boolean true if the verification is ok
    1295. 

  1295.  */
    1296. 

  1296. function check_postvalue($secvalue)
    1297. 

  1297. {
    1298. 

  1298.     if (!is_array($secvalue)) {
    1299. 

  1299.         if ((preg_match("/<[^>]*script*\"?[^>]*>/", $secvalue)) || (preg_match("/<[^>]*style*\"?[^>]*>/",
    1300. 

  1300.             $secvalue))) {
    1301. 

  1301.             return false;
    1302. 

  1302.         }
    1303. 

  1303.     } else {
    1304. 

  1304.         foreach ($secvalue as $subsecvalue) {
    1305. 

  1305.             if (!check_postvalue($subsecvalue))
    1306. 

  1306.                 return false;
    1307. 

  1307.         }
    1308. 

  1308.     }
    1309. 

  1309.     return true;
    1310. 

  1310. }
    1311. 

  1311. 

  1312. 

  1313. //\\ fonctions utilisable pour les mods //\\
    1314. 

  1314. /**
    1315. 

  1315.  * Funtion to install a new mod in OGSpy
    1316. 

  1316.  * @param string $mod_folder : Folder name which contains the mod
    1317. 

  1317.  * @todo Query: "SELECT title FROM " . TABLE_MOD . " WHERE title='" . $value_mod[0] ."'"."'"
    1318. 

  1318.  * @todo Query: "INSERT INTO " . TABLE_MOD .
    1319. 

  1319.                 " (title, menu, action, root, link, version, active,admin_only) VALUES ('" . $value_mod[0] .
    1320. 

  1320.                 "','" . $value_mod[1] . "','" . $value_mod[2] . "','" . $value_mod[3] . "','" .
    1321. 

  1321.                 $value_mod[4] . "','" . $mod_version . "','" . $value_mod[5] . "','" . $value_mod[6] .
    1322. 

  1322.                 "')"
    1323. 

  1323.  * @return boolean true if the mod has been correctly installed
    1324. 

  1324.  * @api
    1325. 

  1325.  */
    1326. 

  1326. function install_mod($mod_folder)
    1327. 

  1327. {
    1328. 

  1328.     global $db,$server_config;
    1329. 

  1329.     $is_ok = false;
    1330. 

  1330.     $filename = 'mod/' . $mod_folder . '/version.txt';
    1331. 

  1331.     if (file_exists($filename)) {
    1332. 

  1332.         $file = file($filename);
    1333. 

  1333.     }
    1334. 

  1334. 

  1335. 

  1336.     // On récupère les données du fichier version.txt
    1337. 

  1337.     $mod_version = trim($file[1]);
    1338. 

  1338.     $mod_config = trim($file[2]);
    1339. 

  1339. 

  1340.     //Version Minimale OGSpy
    1341. 

  1341.     /** @var string $mod_required_ogspy */
    1342. 

  1342.     $mod_required_ogspy = trim($file[3]);
    1343. 

  1343.     if(isset($mod_required_ogspy)){
    1344. 

  1344.         if (version_compare($mod_required_ogspy,$server_config["version"]) > 0 ){
    1345. 

  1345.             log_("mod_erreur_txt_version",$mod_folder);
    1346. 

  1346.             redirection("index.php?action=message&id_message=errormod&info");
    1347. 

  1347.             exit();
    1348. 

  1348.         }
    1349. 

  1349.     }
    1350. 

  1350. 

  1351.     // On explode la chaine d'information
    1352. 

  1352.     $value_mod = explode(',', $mod_config);
    1353. 

  1353. 

  1354.     // On vérifie si le mod est déjà installé""
    1355. 

  1355.     $check = "SELECT title FROM " . TABLE_MOD . " WHERE title='" . $value_mod[0] ."'";
    1356. 

  1356.     $query_check = $db->sql_query($check);
    1357. 

  1357.     $result_check = $db->sql_numrows($query_check);
    1358. 

  1358. 

  1359.     if ($result_check != 0) {
    1360. 

  1360.     } else
    1361. 

  1361.         if (count($value_mod) == 7) {
    1362. 

  1362.             // On vérifie le nombre de valeur de l'explode
    1363. 

  1363.             $query = "INSERT INTO " . TABLE_MOD .
    1364. 

  1364.                 " (title, menu, action, root, link, version, active,admin_only) VALUES ('" . $value_mod[0] .
    1365. 

  1365.                 "','" . $value_mod[1] . "','" . $value_mod[2] . "','" . $value_mod[3] . "','" .
    1366. 

  1366.                 $value_mod[4] . "','" . $mod_version . "','" . $value_mod[5] . "','" . $value_mod[6] .
    1367. 

  1367.                 "')";
    1368. 

  1368.             $db->sql_query($query);
    1369. 

  1369.             $is_ok = true; /// tout c 'est bien passe'
    1370. 

  1370.         }
    1371. 

  1371.     return $is_ok;
    1372. 

  1372. }
    1373. 

  1373. /**
    1374. 

  1374.  * Function to uninstall an OGSpy Module
    1375. 

  1375.  * @param string $mod_uninstall_name : Mod name
    1376. 

  1376.  * @param string $mod_uninstall_table : Name of the Database table used by the Mod that we need to remove
    1377. 

  1377.  * @todo Query: "DELETE FROM " . TABLE_MOD . " WHERE title='" . $mod_uninstall_name ."'
    1378. 

  1378.  * @api
    1379. 

  1379.  */
    1380. 

  1380. function uninstall_mod($mod_uninstall_name, $mod_uninstall_table)
    1381. 

  1381. {
    1382. 

  1382.     global $db;
    1383. 

  1383.     $db->sql_query("DELETE FROM " . TABLE_MOD . " WHERE title='" . $mod_uninstall_name ."';");
    1384. 

  1384.     if (!empty($mod_uninstall_table)) {
    1385. 

  1385.         $db->sql_query("DROP TABLE IF EXISTS " . $mod_uninstall_table . "");
    1386. 

  1386.     }
    1387. 

  1387. }
    1388. 

  1388. /**
    1389. 

  1389.  * Fonction to update the OGSpy mod
    1390. 

  1390.  * @param string $mod_folder : Folder name which contains the mod
    1391. 

  1391.  * @param string $mod_name : Mod name
    1392. 

  1392.  * @todo Query: "UPDATE " . TABLE_MOD . " SET version='" . $mod_version ."' WHERE action='" . $mod_name . "'";
    1393. 

  1393.  * @return boolean true if the mod has been correctly updated
    1394. 

  1394.  * @api [Mod] Function to be called in the update.php file to set up the new version.
    1395. 

  1395.  */
    1396. 

  1396. function update_mod($mod_folder, $mod_name)
    1397. 

  1397. {
    1398. 

  1398.     global $db, $server_config;
    1399. 

  1399.     $is_oki = false;
    1400. 

  1400.     $filename = 'mod/' . $mod_folder . '/version.txt';
    1401. 

  1401.     if (file_exists($filename)) {
    1402. 

  1402.         $file = file($filename);
    1403. 

  1403.     } else {
    1404. 

  1404.         return $is_oki;
    1405. 

  1405.     }
    1406. 

  1406. 

  1407.     $mod_version = trim($file[1]);
    1408. 

  1408. 

  1409.     //Version Minimale OGSpy
    1410. 

  1410.     /** @var string $mod_required_ogspy */
    1411. 

  1411.     $mod_required_ogspy = trim($file[3]);
    1412. 

  1412.     if(isset($mod_required_ogspy)){
    1413. 

  1413.         if (version_compare($mod_required_ogspy,$server_config["version"]) > 0 ){
    1414. 

  1414.             log_("mod_erreur_txt_version",$mod_folder);
    1415. 

  1415.             redirection("index.php?action=message&id_message=errormod&info");
    1416. 

  1416.             exit();
    1417. 

  1417.         }
    1418. 

  1418.     }
    1419. 

  1419. 

  1420. 

  1421.     $query = "UPDATE " . TABLE_MOD . " SET version='" . $mod_version .
    1422. 

  1422.         "' WHERE action='" . $mod_name . "'";
    1423. 

  1423.     $db->sql_query($query);
    1424. 

  1424.     $is_oki = true;
    1425. 

  1425.     return $is_oki;
    1426. 

  1426. }
    1427. 

  1427. 

  1428. /**
    1429. 

  1429.  * OGSpy Hash Function
    1430. 

  1430.  * @param string The string to Hash (usually the password)
    1431. 

  1431.  * todo : remplacer les sha1(md5()) d'ogspy par la fonction'
    1432. 

  1432.  * @return string Returns the hash of the input function
    1433. 

  1433.  */
    1434. 

  1434. function crypto($str)
    1435. 

  1435. {
    1436. 

  1436.     return md5(sha1($str));
    1437. 

  1437. }
    1438. 

  1438. 

  1439. /**
    1440. 

  1440.  * OGSpy Key Generator : This key will be the unique id of the current OGSpy installation.
    1441. 

  1441.  *
    1442. 

  1442.  * The current OGSpy Key is written in a file named parameters/key.php
    1443. 

  1443.  */
    1444. 

  1444. function generate_key()
    1445. 

  1445. {
    1446. 

  1446.     //création de la clef
    1447. 

  1447.     $str = "abcdefghijklmnopqrstuvwxyzABCDEVGHIJKLMOPQRSTUVWXYZ";
    1448. 

  1448.     srand((double)microtime() * 1000000);
    1449. 

  1449.     $pass = time();
    1450. 

  1450.     for ($i = 0; $i < 20; $i++) {
    1451. 

  1451.         $pass .= $str[rand() % strlen($str)];
    1452. 

  1452.     }
    1453. 

  1453.     $key = crypto($pass);
    1454. 

  1454.     // création du path
    1455. 

  1455.     $path = $_SERVER["SCRIPT_FILENAME"];;
    1456. 

  1456. 

  1457. 

  1458.     $key_php[] = '<?php';
    1459. 

  1459.     $key_php[] = '/***************************************************************************';
    1460. 

  1460.     $key_php[] = '*	filename	: key.php';
    1461. 

  1461.     $key_php[] = '*	generated	: ' . date("d/M/Y H:i:s");
    1462. 

  1462.     $key_php[] = '***************************************************************************/';
    1463. 

  1463.     $key_php[] = '';
    1464. 

  1464.     $key_php[] = 'if (!defined("IN_SPYOGAME")) die("Hacking attempt");';
    1465. 

  1465.     $key_php[] = '';
    1466. 

  1466.     $key_php[] = '//Paramètres unique a ne pas communiquer';
    1467. 

  1467.     $key_php[] = '$serveur_key = "' . $key . '";';
    1468. 

  1468.     $key_php[] = '$serveur_date = "' . time() . '";';
    1469. 

  1469.     $key_php[] = '$serveur_path = "' . $path . '";';
    1470. 

  1470.     $key_php[] = '';
    1471. 

  1471.     $key_php[] = 'define("OGSPY_KEY", TRUE);';
    1472. 

  1472.     $key_php[] = '?>';
    1473. 

  1473.     if (!write_file("./parameters/key.php", "w", $key_php)) {
    1474. 

  1474.         die("Echec , impossible de générer le fichier 'parameters/key.php'");
    1475. 

  1475.     }
    1476. 

  1476. 

  1477. }
    1478. 

  1478. 

  1479. 

  1480. /***********************************************************************
    1481. 

  1481.  ************** Fonctions pour table Google Cloud Messaging ************
    1482. 

  1482.  ***********************************************************************/
    1483. 

  1483. 

  1484. /** Storing new GCM user
    1485. 

  1485.  * @return : user true or false
    1486. 

  1486.  */
    1487. 

  1487. function storeGCMUser($name,$gcm_regid) {	
    1488. 

  1488. 	global $db;
    1489. 

  1489. 	$user_id = "0";
    1490. 

  1490. 	$result = $db->sql_query("SELECT user_id FROM " . TABLE_USER . " WHERE user_name = '" . $name . "' OR user_stat_name = '" . $name . "'");
    1491. 

  1491. 	
    1492. 

  1492. 	$nbGcmUsers = $db->sql_numrows("SELECT * FROM " . TABLE_GCM_USERS . " WHERE gcm_regid = '" . $gcm_regid . "'");
    1493. 

  1493. 	
    1494. 

  1494. 	while (list($userid) = $db->sql_fetch_row($result))	{
    1495. 

  1495. 		$user_id = $userid;		
    1496. 

  1496. 	}
    1497. 

  1497. 	
    1498. 

  1498. 	//return "Nombre de users GCM = " . $nbGcmUsers;
    1499. 

  1499. 	
    1500. 

  1500. 	if($nbGcmUsers == 0){
    1501. 

  1501. 		// insert user into database
    1502. 

  1502. 		$result = $db->sql_query("INSERT INTO " . TABLE_GCM_USERS . "(user_id, gcm_regid, created_at) VALUES('" . $user_id ."' , '" . $gcm_regid . "', NOW())");
    1503. 

  1503. 		// check for successful store
    1504. 

  1504. 		if ($result) {
    1505. 

  1505. 			return 1;
    1506. 

  1506. 		} else {
    1507. 

  1507. 			return 0;
    1508. 

  1508. 		}
    1509. 

  1509. 	} else {
    1510. 

  1510. 		return -1;
    1511. 

  1511. 	}
    1512. 

  1512. }
    1513. 

  1513. 

  1514. /** Storing new GCM user
    1515. 

  1515. * @return : user true or false
    1516. 

  1516. */
    1517. 

  1517. function deleteGCMUser($gcm_regid) {
    1518. 

  1518. 	global $db;
    1519. 

  1519. 

  1520. 	// delete user in database
    1521. 

  1521. 	$result = $db->sql_query("DELETE FROM " . TABLE_GCM_USERS . " WHERE gcm_regid = '" . $gcm_regid . "'");
    1522. 

  1522. 	// check for successful store
    1523. 

  1523. 	if ($result) {
    1524. 

  1524. 		return true;
    1525. 

  1525. 	} else {
    1526. 

  1526. 		return false;
    1527. 

  1527. 	}
    1528. 

  1528. }
    1529. 

  1529. 

  1530. /**
    1531. 

  1531.  * Getting all GCM users
    1532. 

  1532.  */
    1533. 

  1533. function getAllGCMUsers() {
    1534. 

  1534. 	global $db;
    1535. 

  1535. 	$query = "SELECT gcm.user_id AS user_id, users.user_name AS name, users.user_stat_name AS name2, users.user_email AS email, gcm.gcm_regid AS gcm_regid, gcm.created_at AS created_at, gcm.version_android AS version_android, gcm.version_ogspy AS version_ogspy, gcm.device AS device ".
    1536. 

  1536. 			 "FROM " . TABLE_GCM_USERS . " gcm ".
    1537. 

  1537. 			 "INNER JOIN " . TABLE_USER . " users ON users.user_id = gcm.user_id";
    1538. 

  1538. 	return $db->sql_query($query);
    1539. 

  1539. }
    1540. 

  1540. 

  1541. /**
    1542. 

  1542.  * Getting all GCM users but not me
    1543. 

  1543.  */
    1544. 

  1544. function getAllGCMUsersExceptMe($id) {
    1545. 

  1545. 	global $db;
    1546. 

  1546. 	$query = "SELECT gcm_regid ".
    1547. 

  1547. 			 "FROM " . TABLE_GCM_USERS .
    1548. 

  1548. 			 " WHERE gcm_regid != '" . $id ."'";
    1549. 

  1549. 	return $db->sql_query($query);
    1550. 

  1550. }
    1551. 

  1551. 

  1552. /**
    1553. 

  1553.  * Calcule la distance entre a et b, a - b ; en tenant en compte des univers arrondis.
    1554. 

  1554.  * type = Représente le type de distance à calculer
    1555. 

  1555.  *      0 : Galaxie
    1556. 

  1556.  *      1 : Système
    1557. 

  1557.  *      2 : Planète
    1558. 

  1558.  * typeArrondi = true pour un univers arrondi selon le type donnée
    1559. 

  1559.  */
    1560. 

  1560. function calc_distance($a, $b, $type, $typeArrondi = false) {//a-b
    1561. 

  1561.     global $server_config;
    1562. 

  1562.     
    1563. 

  1563.     $max_type = 0;
    1564. 

  1564.     
    1565. 

  1565.     switch($type){
    1566. 

  1566.         case 0: //Galaxy
    1567. 

  1567.             $max_type = $server_config['num_of_galaxies']; //9
    1568. 

  1568.             break;
    1569. 

  1569.         case 1: //System
    1570. 

  1570.             $max_type = $server_config['num_of_systems']; //499
    1571. 

  1571.             break;
    1572. 

  1572.     }
    1573. 

  1573.     if($typeArrondi) {
    1574. 

  1574.         if(abs($a - $b) < $max_type/2) {
    1575. 

  1575.             return abs($a - $b);//|a-b|
    1576. 

  1576.         } else {
    1577. 

  1577.             return abs(abs($a - $b) - $max_type); //||a-b| - base|
    1578. 

  1578.         }
    1579. 

  1579.     } else {
    1580. 

  1580.         return abs($a - $b);//|a-b|
    1581. 

  1581.     }
    1582. 

  1582. }
    1583. 

  1583. /********************************************************************************/
    1584. 

  1584. /**                     Booster partie                                         **/
    1585. 

  1585. /* Description :
    1586. 

  1586.   "m:0:0_c:0:0_d:0:0_p:0_m:0" =>booster_m;booster_c;booster_d;extension_p;extension_moon
    1587. 

  1587.   booster_x    => ressource:%:date_de_fin  (ressource= m|c|d)
    1588. 

  1588.   extension_x  => type:+" (type= p|m)
    1589. 

  1589.   "m:0:0_c:0:0_d:0:0_p:0_m:0" = string de stockage par défaut
    1590. 

  1590. */
    1591. 

  1591. /*##Base de donnée  ##*/
    1592. 

  1592. /* Lit les informations des objets Ogame dans la BDD et les transformes en un tableau
    1593. 

  1593.  * @arg id_player id du joueur
    1594. 

  1594.  * @arg id_planet id de la planète à rechercher
    1595. 

  1595.  * @return tableau associatif des boosters ou NULL en cas d'échec
    1596. 

  1596.  * array('booster_m_val', 'booster_m_date', 'booster_c_val', 'booster_c_date', 'booster_c_val', 'booster_c_date', 'extention_p', 'extention_m')
    1597. 

  1597. */
    1598. 

  1598. function booster_lire_bdd($id_player, $id_planet){
    1599. 

  1599.     global $db;
    1600. 

  1600.     $result = NULL;
    1601. 

  1601. 

  1602.     $request = "SELECT boosters FROM ".TABLE_USER_BUILDING." WHERE user_id=".$id_player." AND planet_id=".$id_planet;
    1603. 

  1603.     $res = $db->sql_query($request);
    1604. 

  1604.     if($res) {
    1605. 

  1605.         $str = $db->sql_fetch_row($res);
    1606. 

  1606.         if($str){
    1607. 

  1607.             return booster_decode($str[0]);
    1608. 

  1608.         }
    1609. 

  1609.     }
    1610. 

  1610.     return $result;
    1611. 

  1611. }
    1612. 

  1612. /* Écrit la string de stockage des objets Ogame dans la BDD.
    1613. 

  1613.  * @arg id_player   id du joueur
    1614. 

  1614.  * @arg id_planet   id de la planète à rechercher
    1615. 

  1615.  * @str_booster     string de stockage des boosters (donnée par les fonctions booster_encode() ou booster_encodev())
    1616. 

  1616.  * @return FALSE en cas d'échec
    1617. 

  1617. */
    1618. 

  1618. function booster_ecrire_bdd_str($id_player, $id_planet, $str_booster){
    1619. 

  1619.     global $db;
    1620. 

  1620.     
    1621. 

  1621.     $request = "UPDATE ".TABLE_USER_BUILDING." SET boosters='".$str_booster."' WHERE user_id=".$id_player." AND planet_id=".$id_planet;
    1622. 

  1622.     return $db->sql_query($request);
    1623. 

  1623. }
    1624. 

  1624. /* Écrit les informations des objets Ogame dans la BDD sous forme d'une string de stockage.
    1625. 

  1625.  * @arg id_player   id du joueur
    1626. 

  1626.  * @arg id_planet   id de la planète à rechercher
    1627. 

  1627.  * @tab_booster     tableau infos des boosters (donnée par les fonctions booster_lire_bdd() ou booster_decode())
    1628. 

  1628.  * @return FALSE en cas d'échec
    1629. 

  1629. */
    1630. 

  1630. function booster_ecrire_bdd_tab($id_player, $id_planet, $tab_booster){
    1631. 

  1631.     return booster_ecrire_bdd_str($id_player, $id_planet, booster_encode($tab_booster));
    1632. 

  1632. }
    1633. 

  1633. /* Mets à jour les boosters de tous les users en fonction de la date de fin dans la BDD
    1634. 

  1634.  *
    1635. 

  1635. */
    1636. 

  1636. function booster_maj_bdd(){
    1637. 

  1637.     global $db;
    1638. 

  1638. 

  1639.     $request = "SELECT user_id, planet_id, boosters FROM ".TABLE_USER_BUILDING;
    1640. 

  1640.     $res = $db->sql_query($request);
    1641. 

  1641.     if($res) {
    1642. 

  1642.         $requests = array();
    1643. 

  1643.         while($row = $db->sql_fetch_assoc($res)) {            
    1644. 

  1644.             $tmp = booster_verify_str($row['boosters']);
    1645. 

  1645.             if($tmp !== $row['boosters']) {
    1646. 

  1646.                 $row['boosters'] = $tmp;
    1647. 

  1647.                 $requests[] = "UPDATE ".TABLE_USER_BUILDING." SET boosters = '".$row['boosters']."' ".
    1648. 

  1648.                              " WHERE user_id = ".$row['user_id'].
    1649. 

  1649.                              " AND planet_id = ".$row['planet_id'];
    1650. 

  1650.             }
    1651. 

  1651.         }
    1652. 

  1652.         foreach ($requests as $request) {
    1653. 

  1653.             $db->sql_query($request);
    1654. 

  1654.         }
    1655. 

  1655.     }
    1656. 

  1656. }
    1657. 

  1657. 

  1658. /*#######Contrôles et modifications poussées  #######*/
    1659. 

  1659. /* Contrôle la date de validité des boosters et reset si la date est dépassée
    1660. 

  1660.  * @param $boosters     tableau infos des boosters (donnée par les fonctions booster_lire_bdd() ou booster_decode())
    1661. 

  1661.  * @return tableau associatif des boosters mis à jour
    1662. 

  1662.  * array('booster_m_val', 'booster_m_date', 'booster_c_val', 'booster_c_date', 'booster_d_val', 'booster_d_date', 'extention_p', 'extention_m')
    1663. 

  1663. */
    1664. 

  1664. function booster_verify($boosters) {
    1665. 

  1665.     $b_control = array('booster_m_', 'booster_c_', 'booster_d_');
    1666. 

  1666.     $current_time = time();
    1667. 

  1667.     
    1668. 

  1668.     foreach($b_control as $b) {
    1669. 

  1669.         if($boosters[$b.'date'] <= $current_time) {
    1670. 

  1670.             $boosters[$b.'val'] = 0;
    1671. 

  1671.             $boosters[$b.'date'] = 0;
    1672. 

  1672.         }
    1673. 

  1673.     }
    1674. 

  1674.     return $boosters;
    1675. 

  1675. }
    1676. 

  1676. /* Contrôle la date de validité des boosters et reset si la date est dépassée
    1677. 

  1677.  * @param $str     string de stockage des boosters (donnée par les fonctions booster_encode() ou booster_encodev() ou directement from BDD)
    1678. 

  1678.  * @return tableau associatif des boosters mis à jour
    1679. 

  1679.  * array('booster_m_val', 'booster_m_date', 'booster_c_val', 'booster_c_date', 'booster_d_val', 'booster_d_date', 'extention_p', 'extention_m')
    1680. 

  1680. */
    1681. 

  1681. function booster_verify_str($str) {
    1682. 

  1682.     return booster_encode(booster_verify(booster_decode($str)));
    1683. 

  1683. }
    1684. 

  1684. /* donne des tableaux d'informations en relation avec les objets Ogame 
    1685. 

  1685.  * @type    détermine les informations renvoyées
    1686. 

  1686.  *      [Default] donne un tableau avec les uuid des objets Ogame
    1687. 

  1687.  *      'definition' donne un tableau avec le nom de l'objet (ex. 'Booster de métal en or')
    1688. 

  1688.  *      'array'      donne un tableau asso de tab uuid=>array('booster_x'|'extension_x', valeur)
    1689. 

  1689.  *      'string'     donne un tableau asso de string uuid=>'x:valeur:0'|'x:valeur'
    1690. 

  1690.  *      'full'       donne les tableaux simple : définition, uuid, string, array)
    1691. 

  1691.  *      'separateur' donne le char qui sert de séparateur entre les objets Ogame
    1692. 

  1692.  *      'default_str' donne la string de stockage par défaut : "m:0:0_c:0:0_d:0:0_p:0_m:0"
    1693. 

  1693.  * @return  le tableau correspondant au type
    1694. 

  1694. */
    1695. 

  1695. function booster_objets_tab($type='') {
    1696. 

  1696.     $objet_str = array('Booster de métal en or'    ,'Booster de métal en argent'    ,'Booster de métal en bronze',
    1697. 

  1697.                        'Booster de cristal en or'  ,'Booster de cristal en argent'  ,'Booster de cristal en bronze',
    1698. 

  1698.                        'Booster de deutérium en or','Booster de deutérium en argent','Booster de deutérium en bronze',
    1699. 

  1699.                        'Extension planétaire en or','Extension planétaire en argent','Extension planétaire en bronze',
    1700. 

  1700.                        'Extension lunaire en or'   ,'Extension lunaire en argent'   ,'Extension lunaire en bronze');                    
    1701. 

  1701.     $objet_uuid = array('05294270032e5dc968672425ab5611998c409166',//'Booster de métal +30%'
    1702. 

  1702.                         'ba85cc2b8a5d986bbfba6954e2164ef71af95d4a',//'Booster de métal +20%'
    1703. 

  1703.                         'de922af379061263a56d7204d1c395cefcfb7d75',//'Booster de métal +10%'
    1704. 

  1704.                         '118d34e685b5d1472267696d1010a393a59aed03',//'Booster de cristal +30%'
    1705. 

  1705.                         '422db99aac4ec594d483d8ef7faadc5d40d6f7d3',//'Booster de cristal +20%'
    1706. 

  1706.                         '3c9f85221807b8d593fa5276cdf7af9913c4a35d',//'Booster de cristal +10%'
    1707. 

  1707.                         '5560a1580a0330e8aadf05cb5bfe6bc3200406e2',//'Booster de deutérium +30%'
    1708. 

  1708.                         'e4b78acddfa6fd0234bcb814b676271898b0dbb3',//'Booster de deutérium +20%'
    1709. 

  1709.                         'd9fa5f359e80ff4f4c97545d07c66dbadab1d1be',//'Booster de deutérium +10%'
    1710. 

  1710.                         '04e58444d6d0beb57b3e998edc34c60f8318825a',//'Extension planétaire +15'
    1711. 

  1711.                         '0e41524dc46225dca21c9119f2fb735fd7ea5cb3',//'Extension planétaire +9'
    1712. 

  1712.                         '16768164989dffd819a373613b5e1a52e226a5b0',//'Extension planétaire +4'
    1713. 

  1713.                         '05ee9654bd11a261f1ff0e5d0e49121b5e7e4401',//'Extension lunaire +6'
    1714. 

  1714.                         'c21ff33ba8f0a7eadb6b7d1135763366f0c4b8bf',//'Extension lunaire +4'
    1715. 

  1715.                         'be67e009a5894f19bbf3b0c9d9b072d49040a2cc');//'Extension lunaire +2'
    1716. 

  1716.     $objet_uuid_str = array('m:30:0','m:20:0','m:10:0','c:30:0','c:20:0','c:10:0','d:30:0','d:20:0','d:10:0','p:15','p:9','p:4','m:6','m:4','m:2');
    1717. 

  1717.     $objet_uuid_tab = array(array('booster_m', 30),array('booster_m', 20),array('booster_m', 10),
    1718. 

  1718.                         array('booster_c', 30),array('booster_c', 20),array('booster_c', 10),
    1719. 

  1719.                         array('booster_d', 30),array('booster_d', 20),array('booster_d', 10),
    1720. 

  1720.                         array('extention_p', 15),array('extention_p', 9),array('extention_p', 4),
    1721. 

  1721.                         array('extention_m', 6),array('extention_m', 4),array('extention_m', 2));
    1722. 

  1722.     $separateur = '_';
    1723. 

  1723.     $default_str = array('m:0:0', 'c:0:0', 'd:0:0', 'p:0', 'm:0');
    1724. 

  1724.     
    1725. 

  1725.     switch($type) {
    1726. 

  1726.         case 'definition':
    1727. 

  1727.             return $objet_str;
    1728. 

  1728.         case 'array':
    1729. 

  1729.             $n = count($objet_uuid);
    1730. 

  1730.             for($i=0 ; $i<$n ; $i++) {
    1731. 

  1731.                 $result[$objet_uuid[$i]] = $objet_uuid_tab[$i]; 
    1732. 

  1732.             }
    1733. 

  1733.             return $result;
    1734. 

  1734.         case 'string':
    1735. 

  1735.             $n = count($objet_uuid);
    1736. 

  1736.             for($i=0 ; $i<$n ; $i++) {
    1737. 

  1737.                 $result[$objet_uuid[$i]] = $objet_uuid_str[$i]; 
    1738. 

  1738.             }
    1739. 

  1739.             return $result;
    1740. 

  1740.         case 'full':
    1741. 

  1741.             return array($objet_str, $objet_uuid, $objet_uuid_str, $objet_uuid_tab);
    1742. 

  1742.         case 'separateur':
    1743. 

  1743.             return $separateur;
    1744. 

  1744.         case 'default_str':
    1745. 

  1745.             return implode($separateur, $default_str);
    1746. 

  1746.         default:
    1747. 

  1747.             return $objet_uuid;
    1748. 

  1748.     }
    1749. 

  1749. }
    1750. 

  1750. /* Indique si un uuid est enregistré dans OGSpy (il existe)
    1751. 

  1751.  * @uuid    string uuid récupéré de la page Ogame
    1752. 

  1752. */
    1753. 

  1753. function booster_is_uuid($uuid) {
    1754. 

  1754.     return in_array($uuid, booster_objets_tab());
    1755. 

  1755. }
    1756. 

  1756. /* Mets à jour le tableau infos des boosters.
    1757. 

  1757.  * @boosters tableau infos des boosters (donnée par les fonctions booster_lire_bdd() ou booster_decode())
    1758. 

  1758.  * @uuid     string uuid de l'objet Ogame récupéré de la page Ogame
    1759. 

  1759.  * @date     date de fin de l'objet Ogame. [defaut=0]
    1760. 

  1760.  * return   le tableau à jour (par uuid et date)
    1761. 

  1761.  *          si $boosters==NULL OU booster_uuid($b) sans uuid -> donne tableau avec valeurs par défaut (équivalent booster_decode())
    1762. 

  1762.  *          NULL en cas d'erreur (uuid inconnu)
    1763. 

  1763. */
    1764. 

  1764. function booster_uuid($boosters, $uuid='', $date=0) {
    1765. 

  1765.     if($boosters==NULL || $uuid=='') {
    1766. 

  1766.         $boosters = booster_decode();
    1767. 

  1767.         return $boosters;
    1768. 

  1768.     } else {
    1769. 

  1769.         $objet_uuid = booster_objets_tab('array');
    1770. 

  1770.         //if(isset($objet_uuid[$uuid]) || array_key_exists($uuid, $objet_uuid)) {
    1771. 

  1771.         if(isset($objet_uuid[$uuid])) {
    1772. 

  1772.             if($objet_uuid[$uuid][0][0] == 'b') { //1er lettre de booster
    1773. 

  1773.                 $boosters[$objet_uuid[$uuid][0].'_val'] = $objet_uuid[$uuid][1];
    1774. 

  1774.                 $boosters[$objet_uuid[$uuid][0].'_date'] = $date;
    1775. 

  1775.             } elseif($objet_uuid[$uuid][0][0] == 'e') { //1er lettre de extension
    1776. 

  1776.                 $boosters[$objet_uuid[$uuid][0]] = $objet_uuid[$uuid][1];
    1777. 

  1777.             } else { return NULL;} //Ne devrait jamais arriver si les tableaux dans booster_objets_tab() sont bien construit
    1778. 

  1778.             return $boosters;
    1779. 

  1779.         }
    1780. 

  1780.     }
    1781. 

  1781.     return NULL;
    1782. 

  1782. }
    1783. 

  1783. 

  1784. /* Transforme la date Ogame de format "*s *j *h *m *s" en nombre de seconde
    1785. 

  1785.  * @str string contenant le temps
    1786. 

  1786.  * @return int nombre de seconde correspondant à $str. 0 si problème
    1787. 

  1787. */
    1788. 

  1788. function booster_lire_date($str) {
    1789. 

  1789.     static $tri = array(   's',   'j',   'h', 'm', 's');
    1790. 

  1790.     static $num = array(604800, 86400,  3600,  60,  1);
    1791. 

  1791.     static $n = 5;
    1792. 

  1792.     $result = 0;
    1793. 

  1793.     $j = $n-1;  //Lecture de droite à gauche on démarre par les secondes.
    1794. 

  1794.     
    1795. 

  1795.     $parts = sscanf($str, '%d%c %d%c %d%c %d%c %d%c');
    1796. 

  1796.     for($i=$n-1 ; $i >= 0 ; $i--) {
    1797. 

  1797.         $car = $parts[$i*2+1];  //%c
    1798. 

  1798.         $valeur = $parts[$i*2]; //%d
    1799. 

  1799.         if(!is_null($car)) {
    1800. 

  1800.             if($car == $tri[$j]){
    1801. 

  1801.                 $result += $valeur * $num[$j--];
    1802. 

  1802.             }
    1803. 

  1803.         }
    1804. 

  1804.     }
    1805. 

  1805.     return $result;
    1806. 

  1806. }
    1807. 

  1807. 

  1808. /*#######Lecture et modifications poussées  #######*/
    1809. 

  1809. /* Transforme en tableau les données des objets Ogame contenues dans une string de stockage.
    1810. 

  1810.  * Si aucun argument n'ai donné alors elle renvoie les valeurs des objets par défaut.
    1811. 

  1811.  * @param $str  string de stockage des objets Ogame
    1812. 

  1812.  * @return      tableau contenant les informations des objets
    1813. 

  1813.  * array('booster_m_val', 'booster_m_date', 'booster_c_val', 'booster_c_date', 'booster_c_val', 'booster_c_date', 'extention_p', 'extention_m')
    1814. 

  1814. */
    1815. 

  1815. function booster_decode($str=NULL, &$boosters=NULL) {
    1816. 

  1816.     if($str) {
    1817. 

  1817.         $s = booster_objets_tab('separateur');
    1818. 

  1818.         $a = preg_match("/m:(\d+):(\d+)".$s."c:(\d+):(\d+)".$s."d:(\d+):(\d+)".$s."p:(\d+)".$s."m:(\d+)/", $str, $boosters);
    1819. 

  1819.         if($a) {
    1820. 

  1820.             $i = 1;
    1821. 

  1821.         return array('booster_m_val'=>intval($boosters[$i++]), 'booster_m_date'=>intval($boosters[$i++]),
    1822. 

  1822.                      'booster_c_val'=>intval($boosters[$i++]), 'booster_c_date'=>intval($boosters[$i++]),
    1823. 

  1823.                      'booster_d_val'=>intval($boosters[$i++]), 'booster_d_date'=>intval($boosters[$i++]),
    1824. 

  1824.                      'extention_p'=>intval($boosters[$i++]), 'extention_m'=>intval($boosters[$i++]));
    1825. 

  1825.         }
    1826. 

  1826.     }    
    1827. 

  1827.     return array('booster_m_val'=>0, 'booster_m_date'=>0,
    1828. 

  1828.                  'booster_c_val'=>0, 'booster_c_date'=>0,
    1829. 

  1829.                  'booster_d_val'=>0, 'booster_d_date'=>0,
    1830. 

  1830.                  'extention_p'=>0, 'extention_m'=>0);
    1831. 

  1831. }
    1832. 

  1832. /* Transforme le tableau des informations des objets Ogame en une string de stockage.
    1833. 

  1833.  * @b tableau associatif des infos array('booster_m_val', 'booster_m_date', 'booster_c_val', 'booster_c_date', 'booster_c_val', 'booster_c_date', 'extention_p', 'extention_m')
    1834. 

  1834.  * @return objet sous format string de stockage ("m:0:0_c:0:0_d:0:0_p:0_m:0 si pas d'argument)
    1835. 

  1835. */
    1836. 

  1836. function booster_encode($b=NULL) {
    1837. 

  1837.     $str = '';
    1838. 

  1838.     if($b){
    1839. 

  1839.         $separateur= booster_objets_tab('separateur');
    1840. 

  1840.         $str .= 'm:'.$b['booster_m_val'].':'.$b['booster_m_date'].$separateur;
    1841. 

  1841.         $str .= 'c:'.$b['booster_c_val'].':'.$b['booster_c_date'].$separateur;
    1842. 

  1842.         $str .= 'd:'.$b['booster_d_val'].':'.$b['booster_d_date'].$separateur;
    1843. 

  1843.         $str .= 'p:'.$b['extention_p'].$separateur;
    1844. 

  1844.         $str .= 'm:'.$b['extention_m'];
    1845. 

  1845.     } else {
    1846. 

  1846.         $str = booster_objets_tab('default_str');//"m:0:0_c:0:0_d:0:0_p:0_m:0";
    1847. 

  1847.     }
    1848. 

  1848.     return $str;
    1849. 

  1849. }
    1850. 

  1850. /* Transforme les valeurs des objets Ogame en une string de stockage.
    1851. 

  1851.  * string de stockage par défaut = m:0:0_c:0:0_d:0:0_p:0_m:0
    1852. 

  1852.  * @return objet sous format string de stockage ("m:0:0_c:0:0_d:0:0_p:0_m:0" si pas d'argument)
    1853. 

  1853. */
    1854. 

  1854. function booster_encodev($booster_m_val=0, $booster_m_date=0, $booster_c_val=0, $booster_c_date=0,
    1855. 

  1855.                 $booster_d_val=0, $booster_d_date=0, $extention_p=0, $extention_m=0) {
    1856. 

  1856.     $separateur= booster_objets_tab('separateur');
    1857. 

  1857.     $str = '';
    1858. 

  1858.     $str .= 'm:'.$booster_m_val.':'.$booster_m_date.$separateur;
    1859. 

  1859.     $str .= 'c:'.$booster_c_val.':'.$booster_c_date.$separateur;
    1860. 

  1860.     $str .= 'd:'.$booster_d_val.':'.$booster_d_date.$separateur;
    1861. 

  1861.     $str .= 'p:'.$extention_p.$separateur;
    1862. 

  1862.     $str .= 'm:'.$extention_m;
    1863. 

  1863.     return $str;
    1864. 

  1864. }
    1865. 

  1865. /**                     Fin booster partie                                     **/
    1866. 

  1866. /********************************************************************************/
    1867. 

  1867. ?>
    1868.