PageRenderTime 52ms CodeModel.GetById 15ms 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

Large files files are truncated, but you can click here to view the full file

    

  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 verificatio…
    1295.

Large files files are truncated, but you can click here to view the full file