Просмотр файла includes/functions.php

Конкурс дизайнеров на 15000 рублей
Милый пушистый сайт !!!!
Размер файла: 27.97Kb 
  1. <?php
  2. /***************************************************************************
  3.  *                                mides.ru
  4.  *                            -------------------
  5.  ***************************************************************************/
  6. function get_db_stat($mode)
  7. {
  8. 	global $db;
  9.  
  10. 	switch( $mode )
  11. 	{
  12. 		case 'usercount':
  13. 			$sql = "SELECT COUNT(user_id) AS total
  14. 				FROM " . USERS_TABLE . "
  15. 				WHERE user_id <> " . ANONYMOUS;
  16. 			break;
  17.  
  18. 		case 'newestuser':
  19. 			$sql = "SELECT user_id, username
  20. 				FROM " . USERS_TABLE . "
  21. 				WHERE user_id <> " . ANONYMOUS . "
  22. 				ORDER BY user_id DESC
  23. 				LIMIT 1";
  24. 			break;
  25.  
  26. 		case 'postcount':
  27. 		case 'topiccount':
  28. 			$sql = "SELECT SUM(forum_topics) AS topic_total, SUM(forum_posts) AS post_total
  29. 				FROM " . FORUMS_TABLE;
  30. 			break;
  31. 		case 'attachcount':
  32. 			$sql = "SELECT count(*) AS total FROM " . ATTACHMENTS_DESC_TABLE;
  33. 			break;
  34. 	}
  35.  
  36. 	if ( !($result = $db->sql_query($sql)) )
  37. 	{
  38. 		return false;
  39. 	}
  40.  
  41. 	$row = $db->sql_fetchrow($result);
  42.  
  43. 	switch ( $mode )
  44. 	{
  45. 		case 'usercount':
  46. 			return $row['total'];
  47. 			break;
  48. 		case 'newestuser':
  49. 			return $row;
  50. 			break;
  51. 		case 'postcount':
  52. 			return $row['post_total'];
  53. 			break;
  54. 		case 'topiccount':
  55. 			return $row['topic_total'];
  56. 			break;
  57. 		case 'attachcount':
  58. 			return $row['total'];
  59. 			break;
  60. 	}
  61.  
  62. 	return false;
  63. }
  64.  
  65. function phpbb_clean_username($username)
  66. {
  67. 	$username = substr(htmlspecialchars(str_replace("\'", "'", trim($username))), 0, 25);
  68. 	$username = phpbb_rtrim($username, "\\");
  69. 	$username = str_replace("'", "\'", $username);
  70.  
  71. 	return $username;
  72. }
  73.  
  74. function phpbb_ltrim($str, $charlist = false)
  75. {
  76. 	if ($charlist === false)
  77. 	{
  78. 		return ltrim($str);
  79. 	}
  80. 	
  81. 	$php_version = explode('.', PHP_VERSION);
  82.  
  83. 	if ((int) $php_version[0] < 4 || ((int) $php_version[0] == 4 && (int) $php_version[1] < 1))
  84. 	{
  85. 		while ($str{0} == $charlist)
  86. 		{
  87. 			$str = substr($str, 1);
  88. 		}
  89. 	}
  90. 	else
  91. 	{
  92. 		$str = ltrim($str, $charlist);
  93. 	}
  94.  
  95. 	return $str;
  96. }
  97.  
  98. function phpbb_rtrim($str, $charlist = false)
  99. {
  100. 	if ($charlist === false)
  101. 	{
  102. 		return rtrim($str);
  103. 	}
  104. 	
  105. 	$php_version = explode('.', PHP_VERSION);
  106.  
  107. 	if ((int) $php_version[0] < 4 || ((int) $php_version[0] == 4 && (int) $php_version[1] < 1))
  108. 	{
  109. 		while ($str{strlen($str)-1} == $charlist)
  110. 		{
  111. 			$str = substr($str, 0, strlen($str)-1);
  112. 		}
  113. 	}
  114. 	else
  115. 	{
  116. 		$str = rtrim($str, $charlist);
  117. 	}
  118.  
  119. 	return $str;
  120. }
  121.  
  122. function dss_rand()
  123. {
  124. 	global $db, $board_config, $dss_seeded;
  125.  
  126. 	$val = $board_config['rand_seed'] . microtime();
  127. 	$val = md5($val);
  128. 	$board_config['rand_seed'] = md5($board_config['rand_seed'] . $val . 'a');
  129.    
  130. 	if($dss_seeded !== true)
  131. 	{
  132. 		$sql = "UPDATE " . CONFIG_TABLE . " SET
  133. 			config_value = '" . $board_config['rand_seed'] . "'
  134. 			WHERE config_name = 'rand_seed'";
  135. 		
  136. 		if( !$db->sql_query($sql) )
  137. 		{
  138. 			message_die(GENERAL_ERROR, "Unable to reseed PRNG", "", __LINE__, __FILE__, $sql);
  139. 		}
  140.  
  141. 		$dss_seeded = true;
  142. 	}
  143.  
  144. 	return substr($val, 4, 16);
  145. }
  146.  
  147. function get_userdata($user, $force_str = false)
  148. {
  149. 	global $db;
  150.  
  151. 	if (!is_numeric($user) || $force_str)
  152. 	{
  153. 		$user = phpbb_clean_username($user);
  154. 	}
  155. 	else
  156. 	{
  157. 		$user = intval($user);
  158. 	}
  159.  
  160. 	$sql = "SELECT *
  161. 		FROM " . USERS_TABLE . " 
  162. 		WHERE ";
  163. 	$sql .= ( ( is_integer($user) ) ? "user_id = $user" : "username = '" .  str_replace("\'", "''", $user) . "'" ) . " AND user_id <> " . ANONYMOUS;
  164. 	if ( !($result = $db->sql_query($sql)) )
  165. 	{
  166. 		message_die(GENERAL_ERROR, 'Tried obtaining data for a non-existent user', '', __LINE__, __FILE__, $sql);
  167. 	}
  168.  
  169. 	return ( $row = $db->sql_fetchrow($result) ) ? $row : false;
  170. }
  171.  
  172. function init_userprefs($userdata)
  173. {
  174. 	global $board_config;
  175. 	global $template, $lang, $phpEx, $phpbb_root_path, $db;
  176.  
  177. 	if ( $userdata['user_id'] != ANONYMOUS )
  178. 	{
  179. 		if ( !empty($userdata['user_lang']))
  180. 		{
  181. 			$default_lang = phpbb_ltrim(basename(phpbb_rtrim($userdata['user_lang'])), "'");
  182. 		}
  183.  
  184. 		if ( !empty($userdata['user_dateformat']) )
  185. 		{
  186. 			$board_config['default_dateformat'] = $userdata['user_dateformat'];
  187. 		}
  188.  
  189. 		if ( isset($userdata['user_timezone']) )
  190. 		{
  191. 			$board_config['board_timezone'] = $userdata['user_timezone'];
  192. 		}
  193. 		if ( isset($userdata['user_topics_per_page']) )
  194. 		{
  195. 			$board_config['topics_per_page'] = $userdata['user_topics_per_page'];
  196. 		}
  197. 		if ( isset($userdata['user_posts_per_page']) )
  198. 		{
  199. 			$board_config['posts_per_page'] = $userdata['user_posts_per_page'];
  200. 		}
  201. 	}
  202. 	else
  203. 	{
  204. 		$default_lang = phpbb_ltrim(basename(phpbb_rtrim($board_config['default_lang'])), "'");
  205. 	}
  206.  
  207. 	if ( !file_exists(@phpbb_realpath($phpbb_root_path . 'language/lang_' . $default_lang . '/lang_main.'.$phpEx)) )
  208. 	{
  209. 		if ( $userdata['user_id'] != ANONYMOUS )
  210. 		{
  211. 			$default_lang = phpbb_ltrim(basename(phpbb_rtrim($board_config['default_lang'])), "'");
  212. 		}
  213. 		else
  214. 		{
  215.  
  216. 			$default_lang = 'russian';
  217. 		}
  218.  
  219. 		if ( !file_exists(@phpbb_realpath($phpbb_root_path . 'language/lang_' . $default_lang . '/lang_main.'.$phpEx)) )
  220. 		{
  221. 			message_die(CRITICAL_ERROR, 'Could not locate valid language pack');
  222. 		}
  223. 	}
  224.  
  225. 	if ( $userdata['user_id'] != ANONYMOUS && $userdata['user_lang'] !== $default_lang )
  226. 	{
  227. 		$sql = 'UPDATE ' . USERS_TABLE . "
  228. 			SET user_lang = '" . $default_lang . "'
  229. 			WHERE user_lang = '" . $userdata['user_lang'] . "'";
  230.  
  231. 		if ( !($result = $db->sql_query($sql)) )
  232. 		{
  233. 			message_die(CRITICAL_ERROR, 'Could not update user language info');
  234. 		}
  235.  
  236. 		$userdata['user_lang'] = $default_lang;
  237. 	}
  238. 	elseif ( $userdata['user_id'] == ANONYMOUS && $board_config['default_lang'] !== $default_lang )
  239. 	{
  240. 		$sql = 'UPDATE ' . CONFIG_TABLE . "
  241. 			SET config_value = '" . $default_lang . "'
  242. 			WHERE config_name = 'default_lang'";
  243.  
  244. 		if ( !($result = $db->sql_query($sql)) )
  245. 		{
  246. 			message_die(CRITICAL_ERROR, 'Could not update user language info');
  247. 		}
  248. 	}
  249.  
  250. 	$board_config['default_lang'] = $default_lang;
  251.  
  252. 	include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main.' . $phpEx);
  253. 	if(file_exists($phpbb_root_path . "language/lang_".$board_config['default_lang'] . "/lang_guestbook.php"))
  254. 	{
  255. 		@include($phpbb_root_path . "language/lang_".$board_config['default_lang'] . "/lang_guestbook.php");
  256. 	}
  257. 	elseif(file_exists($phpbb_root_path . "language/lang_english/lang_guestbook.php"))
  258. 	{
  259. 		@include($phpbb_root_path . "language/lang_english/lang_guestbook.php");
  260. 	}
  261.  
  262. 	if ( defined('IN_ADMIN') )
  263. 	{
  264. 		if( !file_exists(@phpbb_realpath($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin.'.$phpEx)) )
  265. 		{
  266. 			$board_config['default_lang'] = 'russian';
  267. 		}
  268.  
  269. 		include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin.' . $phpEx);
  270. 	}
  271. 	include_attach_lang();
  272.  
  273. 	$template = new Template($phpbb_root_path . 'templates');
  274.  
  275. 	return;
  276. }
  277.  
  278. function style_text()
  279. {
  280. 	global $db, $board_config, $userdata;
  281.  
  282. 	if( $userdata['session_logged_in'] )
  283. 	{
  284. 		$sql = 'SELECT style_text
  285. 			FROM ' . USERS_TABLE . ' 
  286. 			WHERE user_id = ' . (int) $userdata['user_id'];
  287. 		if ( !($result = $db->sql_query($sql)) )
  288. 		{
  289. 			message_die(CRITICAL_ERROR, 'Could not query database for style text');
  290. 		}
  291. 		$row = $db->sql_fetchrow($result);
  292. 		return $row['style_text'];
  293. 	} else {
  294. 		$sql = 'SELECT *
  295. 			FROM ' . STYLES_CSS . ' 
  296. 			WHERE style_id = ' . (int) $board_config['default_style'];
  297. 		if( !($result = $db->sql_query($sql)) )
  298. 		{
  299. 			message_die(CRITICAL_ERROR, "Could not query style information", "", __LINE__, __FILE__, $sql);
  300. 		}
  301. 		$row = $db->sql_fetchrow($result);
  302. 		return $row['style_text'];
  303. 	}
  304. }
  305.  
  306. function encode_ip($dotquad_ip)
  307. {
  308. 	$ip_sep = explode('.', $dotquad_ip);
  309. 	return sprintf('%02x%02x%02x%02x', $ip_sep[0], $ip_sep[1], $ip_sep[2], $ip_sep[3]);
  310. }
  311.  
  312. function decode_ip($int_ip)
  313. {
  314. 	$hexipbang = explode('.', chunk_split($int_ip, 2, '.'));
  315. 	return hexdec($hexipbang[0]). '.' . hexdec($hexipbang[1]) . '.' . hexdec($hexipbang[2]) . '.' . hexdec($hexipbang[3]);
  316. }
  317.  
  318. function create_date($format, $gmepoch, $tz)
  319. {
  320. 	global $board_config, $lang;
  321. 	static $translate;
  322.  
  323. 	if ( empty($translate) && $board_config['default_lang'] = 'russian' )
  324. 	{
  325. 		@reset($lang['datetime']);
  326. 		while ( list($match, $replace) = @each($lang['datetime']) )
  327. 		{
  328. 			$translate[$match] = $replace;
  329. 		}
  330. 	}
  331.  
  332. // friendly date mod\\*******************
  333.  
  334. 	$thetime = ( !empty($translate) ) ? strtr(@gmdate($format, $gmepoch + (3600 * $tz)), $translate) : @gmdate($format, $gmepoch + (3600 * $tz));
  335. 	
  336. 	$L_Today = 'Сегодня';
  337. 	$L_Yesterday = 'Вчера';
  338. 	$time_format = " в G:i";// - hour:minute am/pm
  339. 	
  340. 	$date = getdate();
  341. 	$today = $date['mday'];
  342. 	$month = $date['mon'];
  343. 	$year = $date['year'];
  344.  
  345. 	$forum_date_today = @gmdate ("d", $gmepoch + (3600 * $tz));
  346. 	$forum_date_month = @gmdate ("m", $gmepoch + (3600 * $tz));
  347. 	$forum_date_year = @gmdate ("Y", $gmepoch + (3600 * $tz));
  348. 	
  349. 	if ($forum_date_today == $today && $forum_date_month == $month && $forum_date_year == $year)
  350. 		$thetime = $L_Today . @gmdate ($time_format, $gmepoch + (3600 * $tz));//today
  351. 	
  352. 	else
  353. 	if ($today != 1 && $forum_date_today == ($today-1) && $forum_date_month == $month && $forum_date_year == $year)
  354. 		$thetime = $L_Yesterday . @gmdate ($time_format, $gmepoch + (3600 * $tz));//yesterday
  355. 		
  356. 	else
  357. 	//if today is 1 and the month is not 1, then we have to check how many days in the previews month
  358. 	//and then set $yesterday to the last day in the previews month
  359. 	if ($today == 1 && $month != 1)
  360. 	{
  361. 	$yesterday = date ("t", mktime(0,0,0,($month-1),1,$year));//returns how many days in the previews month
  362. 	if ($forum_date_today == $yesterday && $forum_date_month == ($month-1) && $forum_date_year == $year)
  363. 		$thetime = $L_Yesterday . @gmdate ($time_format, $gmepoch + (3600 * $tz));//yesterday
  364. 	}
  365. 	else 
  366. 	//if we are in the first day in the year
  367. 	if ($today == 1 && $month == 1)
  368. 	{
  369. 	$yesterday = date ("t", mktime(0,0,0,12,1,($year -1)));
  370. 	if ($forum_date_today == $yesterday && $forum_date_month == 12 && $forum_date_year == ($year-1))
  371. 		$thetime = $L_Yesterday . @gmdate ($time_format, $gmepoch + (3600 * $tz));//yesterday
  372. 	}
  373.  
  374.    	return ($thetime);
  375. //end friendly date \\*******************************
  376. }
  377.  
  378. function generate_pagination($base_url, $num_items, $per_page, $start_item, $add_prevnext_text = TRUE)
  379. {
  380. 	global $lang;
  381.  
  382. 	$total_pages = ceil($num_items/$per_page);
  383.  
  384. 	if ( $total_pages == 1 )
  385. 	{
  386. 		return '';
  387. 	}
  388.  
  389. 	$on_page = floor($start_item / $per_page) + 1;
  390.  
  391. 	$page_string = '';
  392. 		if ( $on_page == 1 )
  393. 		{
  394. 			$page_string = 'страницы: <br/>';
  395. 		}
  396. 		if ( $on_page == $total_pages )
  397. 		{
  398. 			$page_string = 'страницы: <br/>';
  399. 		}
  400. 	if ( $total_pages > 5 )
  401. 	{
  402. 		$init_page_max = ( $total_pages > 3 ) ? 3 : $total_pages;
  403.  
  404. 		for($i = 1; $i < $init_page_max + 1; $i++)
  405. 		{
  406. 			$page_string .= ( $i == $on_page ) ? '<u>' . $i . '</u>' : '<a href="' . append_sid($base_url . "&amp;start=" . ( ( $i - 1 ) * $per_page ) ) . '">' . $i . '</a>';
  407. 			if ( $i <  $init_page_max )
  408. 			{
  409. 				$page_string .= " ";
  410. 			}
  411. 		}
  412.  
  413. 		if ( $total_pages > 3 )
  414. 		{
  415. 			if ( $on_page > 1  && $on_page < $total_pages )
  416. 			{
  417. 				$page_string .= ( $on_page > 5 ) ? '  ' : ' ';
  418.  
  419. 				$init_page_min = ( $on_page > 4 ) ? $on_page : 5;
  420. 				$init_page_max = ( $on_page < $total_pages - 4 ) ? $on_page : $total_pages - 4;
  421.  
  422. 				for($i = $init_page_min - 1; $i < $init_page_max + 2; $i++)
  423. 				{
  424. 					$page_string .= ($i == $on_page) ? '<u>' . $i . '</u>' : '<a href="' . append_sid($base_url . "&amp;start=" . ( ( $i - 1 ) * $per_page ) ) . '">' . $i . '</a>';
  425. 					if ( $i <  $init_page_max + 1 )
  426. 					{
  427. 						$page_string .= ' ';
  428. 					}
  429. 				}
  430.  
  431. 				$page_string .= ( $on_page < $total_pages - 4 ) ? '' : ' ';
  432. 			}
  433. 			else
  434. 			{
  435. 				$page_string .= '  ';
  436. 			}
  437.  
  438. 			for($i = $total_pages - 2; $i < $total_pages + 1; $i++)
  439. 			{
  440. 				$page_string .= ( $i == $on_page ) ? '<u>' . $i . '</u></b>'  : '<a href="' . append_sid($base_url . "&amp;start=" . ( ( $i - 1 ) * $per_page ) ) . '">' . $i . '</a>';
  441. 				if( $i <  $total_pages )
  442. 				{
  443. 					$page_string .= " ";
  444. 				}
  445. 			}
  446. 		}
  447. 	}
  448. 	else
  449. 	{
  450. 		for($i = 1; $i < $total_pages + 1; $i++)
  451. 		{
  452. 			$page_string .= ( $i == $on_page ) ? '<u>' . $i . '</u>' : '<a href="' . append_sid($base_url . "&amp;start=" . ( ( $i - 1 ) * $per_page ) ) . '">' . $i . '</a>';
  453. 			if ( $i <  $total_pages )
  454. 			{
  455. 				$page_string .= ' ';
  456. 			}
  457. 		}
  458. 	}
  459.  
  460. 	if ( $add_prevnext_text )
  461. 	{
  462. 		if ( $on_page > 1  && $on_page < $total_pages )
  463. 		{
  464. 			$page_string = 'страницы: ' . $page_string .'<br/>';
  465. 		}
  466.  
  467. 		if ( $on_page < $total_pages )
  468. 		{
  469. 			$page_string .= '';
  470. 		}
  471. 	}
  472.  
  473. 	$page_string = $page_string . '<br/>';
  474.  
  475. 	return $page_string;
  476. }
  477.  
  478. function phpbb_preg_quote($str, $delimiter)
  479. {
  480. 	$text = preg_quote($str);
  481. 	$text = str_replace($delimiter, '\\' . $delimiter, $text);
  482. 	
  483. 	return $text;
  484. }
  485.  
  486. function obtain_word_list(&$orig_word, &$replacement_word)
  487. {
  488. 	global $db;
  489.  
  490. 	$sql = "SELECT word, replacement
  491. 		FROM  " . WORDS_TABLE;
  492. 	if( !($result = $db->sql_query($sql)) )
  493. 	{
  494. 		message_die(GENERAL_ERROR, 'Could not get censored words from database', '', __LINE__, __FILE__, $sql);
  495. 	}
  496.  
  497. 	if ( $row = $db->sql_fetchrow($result) )
  498. 	{
  499. 		do 
  500. 		{
  501. 			
  502. 			$orig_word[] = $row['word'];
  503. 			$replacement_word[] = $row['replacement'];
  504. 		}
  505. 		while ( $row = $db->sql_fetchrow($result) );
  506. 	}
  507.  
  508. 	return true;
  509. }
  510.  
  511. function message_die($msg_code, $msg_text = '', $msg_title = '', $err_line = '', $err_file = '', $sql = '')
  512. {
  513. 	global $db, $template, $board_config, $lang, $phpEx, $phpbb_root_path, $gen_simple_header, $opera_mini, $tmp_name;
  514. 	global $userdata, $user_ip, $session_length;
  515. 	global $starttime;
  516.  
  517. 	$sql_store = $sql;
  518.  
  519. 	if ( DEBUG && ( $msg_code == GENERAL_ERROR || $msg_code == CRITICAL_ERROR ) )
  520. 	{
  521. 		$sql_error = $db->sql_error();
  522.  
  523. 		$debug_text = '';
  524.  
  525. 		if ( $sql_error['message'] != '' )
  526. 		{
  527. 			$debug_text .= '<br /><br />SQL Error : ' . $sql_error['code'] . ' ' . $sql_error['message'];
  528. 		}
  529.  
  530. 		if ( $sql_store != '' )
  531. 		{
  532. 			$debug_text .= "<br /><br />$sql_store";
  533. 		}
  534.  
  535. 		if ( $err_line != '' && $err_file != '' )
  536. 		{
  537. 			$debug_text .= '<br /><br />Line : ' . $err_line . '<br />File : ' . basename($err_file);
  538. 		}
  539. 	}
  540.  
  541. 	if( empty($userdata) && ( $msg_code == GENERAL_MESSAGE || $msg_code == GENERAL_ERROR ) )
  542. 	{
  543. 		$userdata = session_pagestart($user_ip, PAGE_INDEX);
  544. 		init_userprefs($userdata);
  545. 	}
  546.  
  547. 	if ( !defined('HEADER_INC') && $msg_code != CRITICAL_ERROR )
  548. 	{
  549. 		if ( empty($lang) )
  550. 		{
  551. 			if ( !empty($board_config['default_lang']) )
  552. 			{
  553. 				include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main.'.$phpEx);
  554. 			}
  555. 			else
  556. 			{
  557. 				include($phpbb_root_path . 'language/lang_russian/lang_main.'.$phpEx);
  558. 			}
  559. 		}
  560.  
  561. 		$page_title = 'Информация';
  562.  
  563. 		if ( !defined('IN_ADMIN') )
  564. 		{
  565. 			include($phpbb_root_path . 'includes/page_header.'.$phpEx);
  566. 		}
  567. 		else
  568. 		{
  569. 			include($phpbb_root_path . 'admin/page_header_admin.'.$phpEx);
  570. 		}
  571. 	}
  572.  
  573. 	switch($msg_code)
  574. 	{
  575. 		case GENERAL_MESSAGE:
  576. 			if ( $msg_title == '' )
  577. 			{
  578. 				$msg_title = 'Информация';
  579. 			}
  580. 			break;
  581.  
  582. 		case CRITICAL_MESSAGE:
  583. 			if ( $msg_title == '' )
  584. 			{
  585. 				$msg_title = 'Информация';
  586. 			}
  587. 			break;
  588.  
  589. 		case GENERAL_ERROR:
  590. 			if ( $msg_text == '' )
  591. 			{
  592. 				$msg_text = 'Произошла ошибка';
  593. 			}
  594.  
  595. 			if ( $msg_title == '' )
  596. 			{
  597. 				$msg_title = 'Общая ошибка';
  598. 			}
  599. 			break;
  600.  
  601. 		case CRITICAL_ERROR:
  602.  
  603. 			if ( $msg_text == '' )
  604. 			{
  605. 				$msg_text = 'Произошла критическая ошибка';
  606. 			}
  607.  
  608. 			if ( $msg_title == '' )
  609. 			{
  610. 				$msg_title = 'phpBB-CMS : <b>Критическая ошибка</b>';
  611. 			}
  612. 			break;
  613. 	}
  614.  
  615. 	if ( DEBUG && ( $msg_code == GENERAL_ERROR || $msg_code == CRITICAL_ERROR ) )
  616. 	{
  617. 		if ( $debug_text != '' )
  618. 		{
  619. 			$msg_text = $msg_text . '<br /><br /><b><u>DEBUG MODE</u></b>' . $debug_text;
  620. 		}
  621. 	}
  622.  
  623. 	if ( $msg_code != CRITICAL_ERROR )
  624. 	{
  625. 		if ( !empty($lang[$msg_text]) )
  626. 		{
  627. 			$msg_text = $lang[$msg_text];
  628. 		}
  629.  
  630. 		if ( !defined('IN_ADMIN') )
  631. 		{
  632. 			$template->set_filenames(array(
  633. 				'message_body' => 'message_body.tpl')
  634. 			);
  635. 		}
  636. 		else
  637. 		{
  638. 			$template->set_filenames(array(
  639. 				'message_body' => 'admin/admin_message_body.tpl')
  640. 			);
  641. 		}
  642.  
  643. 		$template->assign_vars(array(
  644. 			'MESSAGE_TITLE' => $msg_title,
  645. 			'MESSAGE_TEXT' => $msg_text)
  646. 		);
  647. 		$template->pparse('message_body');
  648.  
  649. 		if ( !defined('IN_ADMIN') )
  650. 		{
  651. 			include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
  652. 		}
  653. 		else
  654. 		{
  655. 			include($phpbb_root_path . 'admin/page_footer_admin.'.$phpEx);
  656. 		}
  657. 	}
  658. 	else
  659. 	{
  660. 		echo "<html>\n<body>\n" . $msg_title . "\n<br /><br />\n" . $msg_text . "</body>\n</html>";
  661. 	}
  662. 	exit;
  663. }
  664.  
  665. function phpbb_realpath($path)
  666. {
  667. 	global $phpbb_root_path, $phpEx;
  668.  
  669. 	return (!@function_exists('realpath') || !@realpath($phpbb_root_path . 'includes/functions.'.$phpEx)) ? $path : @realpath($path);
  670. }
  671.  
  672. function redirect($url)
  673. {
  674. 	global $db, $board_config;
  675.  
  676. 	if (!empty($db))
  677. 	{
  678. 		$db->sql_close();
  679. 	}
  680.  
  681. 	if (strstr(urldecode($url), "\n") || strstr(urldecode($url), "\r") || strstr(urldecode($url), ';url'))
  682. 	{
  683. 		message_die(GENERAL_ERROR, 'Tried to redirect to potentially insecure url.');
  684. 	}
  685.  
  686. 	$server_protocol = ($board_config['cookie_secure']) ? 'https://' : 'http://';
  687. 	$server_name = preg_replace('#^\/?(.*?)\/?$#', '\1', trim($board_config['server_name']));
  688. 	$server_port = ($board_config['server_port'] <> 80) ? ':' . trim($board_config['server_port']) : '';
  689. 	$script_name = preg_replace('#^\/?(.*?)\/?$#', '\1', trim($board_config['script_path']));
  690. 	$script_name = ($script_name == '') ? $script_name : '/' . $script_name;
  691. 	$url = preg_replace('#^\/?(.*?)\/?$#', '/\1', trim($url));
  692.  
  693. 	if (@preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')))
  694. 	{
  695. 		header('Refresh: 0; URL=' . $server_protocol . $server_name . $server_port . $script_name . $url);
  696. 		echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><meta http-equiv="refresh" content="0; url=' . $server_protocol . $server_name . $server_port . $script_name . $url . '"><title>Redirect</title></head><body><div align="center">If your browser does not support meta redirection please click <a href="' . $server_protocol . $server_name . $server_port . $script_name . $url . '">HERE</a> to be redirected</div></body></html>';
  697. 		exit;
  698. 	}
  699.  
  700. 	header('Location: ' . $server_protocol . $server_name . $server_port . $script_name . $url);
  701. 	exit;
  702. }
  703.  
  704. function db_query($sql)
  705. {
  706. 	global $db;
  707.  
  708. 	$sql = preg_replace_callback('#{(\w+)}#', 'const_subst', $sql); 
  709.  
  710. 	if (func_num_args() > 1)
  711. 	{
  712. 		$args = func_get_args();
  713. 		$args = array_map('addslashes', $args);
  714. 		$args[0] = $sql;
  715. 		$sql = call_user_func_array('sprintf', $args);
  716. 	}
  717.  
  718. 	if ($result = $db->sql_query($sql))
  719. 	{
  720. 		return $result;
  721. 	}
  722. 	else
  723. 	{
  724. 		message_die(GENERAL_ERROR, 'SQL query failed', '', __LINE__, __FILE__, $sql);
  725. 	}
  726. }
  727.  
  728. function const_subst($match)
  729. {
  730. 	return constant($match[1]);
  731. }
  732.  
  733. function db_transaction($command)
  734. {
  735. 	global $db;
  736.  
  737. 	$db->sql_query('SELECT 0', $command);
  738. }
  739.  
  740.  
  741. function mkrealdate($day,$month,$birth_year)
  742. {
  743. 	if ($month<1 || $month>12) return "error";
  744. 	switch ($month)
  745. 	{
  746. 		case 1: if ($day>31) return "error";break;
  747. 		case 2: if ($day>29) return "error";
  748. 			$epoch=$epoch+31;break;
  749. 		case 3: if ($day>31) return "error";
  750. 			$epoch=$epoch+59;break;
  751. 		case 4: if ($day>30) return "error" ;
  752. 			$epoch=$epoch+90;break;
  753. 		case 5: if ($day>31) return "error";
  754. 			$epoch=$epoch+120;break;
  755. 		case 6: if ($day>30) return "error";
  756. 			$epoch=$epoch+151;break;
  757. 		case 7: if ($day>31) return "error";
  758. 			$epoch=$epoch+181;break;
  759. 		case 8: if ($day>31) return "error";
  760. 			$epoch=$epoch+212;break;
  761. 		case 9: if ($day>30) return "error";
  762. 			$epoch=$epoch+243;break;
  763. 		case 10: if ($day>31) return "error";
  764. 			$epoch=$epoch+273;break;
  765. 		case 11: if ($day>30) return "error";
  766. 			$epoch=$epoch+304;break;
  767. 		case 12: if ($day>31) return "error";
  768. 			$epoch=$epoch+334;break;
  769. 	}
  770. 	$epoch=$epoch+$day;
  771. 	$epoch_Y=sqrt(($birth_year-1970)*($birth_year-1970));
  772. 	$leapyear=round((($epoch_Y+2) / 4)-.5);
  773. 	if (($epoch_Y+2)%4==0)
  774. 	{
  775. 		$leapyear--;
  776. 		if ($birth_year >1970 && $month>=3) $epoch=$epoch+1;
  777. 		if ($birth_year <1970 && $month<3) $epoch=$epoch-1;
  778. 	} else if ($month==2 && $day>28) return "error";
  779. 	if ($birth_year>1970)
  780. 		$epoch=$epoch+$epoch_Y*365-1+$leapyear;
  781. 	else
  782. 		$epoch=$epoch-$epoch_Y*365-1-$leapyear;
  783. 	return $epoch;
  784. }
  785. function add_friend($to, $friend)
  786. {
  787. global $db, $lang;
  788.  
  789.         $userdata = get_userdata($to);
  790.         if ( $userdata['username'] == $friend )
  791.         {
  792.                 message_die(GENERAL_ERROR, $lang['you_cannot_add_self']);
  793.         }
  794.  
  795.         if(!intval($friend))
  796.         {
  797.                 $sql = 'SELECT user_id FROM '.USERS_TABLE.' WHERE username = \''.str_replace("\'", "''", $friend).'\'';
  798.  
  799.                 if (!$result = $db->sql_query($sql))
  800.                 {
  801.                         message_die(GENERAL_ERROR, 'Could not get friend info', '', __LINE__, __FILE__, $sql);
  802.                 }
  803.  
  804.                 $friend_row = $db->sql_fetchrow($result);
  805.                 $friend_id = $friend_row['user_id'];
  806.         } else
  807.         {
  808.                 $friend_id = $friend;
  809.         }
  810.  
  811.         $sql_friend_id = $friend_id;
  812.  
  813.         if ( empty($friend_id) || $friend_id == ANONYMOUS )
  814.         {
  815.                 message_die(GENERAL_ERROR, $lang['select_correct_user']);
  816.         }
  817.  
  818.         //
  819.         // Is user already in friends list?
  820.         //
  821.  
  822.         $sql = 'SELECT friend_id FROM '.FRIENDS_TABLE.' WHERE friend_id = '.$sql_friend_id.' AND user_id = '.$userdata['user_id'].'';
  823.         if (!$result = $db->sql_query($sql))
  824.         {
  825.                 message_die(GENERAL_ERROR, 'Could not get friends info', '', __LINE__, __FILE__, $sql);
  826.         }
  827.  
  828.         $friend_row = $db->sql_fetchrow($result);
  829.         $friend_id = $friend_row['friend_id'];
  830.  
  831.         if ( !empty($friend_id) )
  832.         {
  833.                 message_die(GENERAL_ERROR, $lang['This_user_already_added_to_friends']);
  834.         }
  835.  
  836.         //
  837.         // Is user in foes?
  838.         //
  839.  
  840.         $sql = 'SELECT foe_id FROM '.FOES_TABLE.' WHERE foe_id = '.$sql_friend_id.' AND user_id = '.$userdata['user_id'].'';
  841.         if (!$result = $db->sql_query($sql))
  842.         {
  843.                 message_die(GENERAL_ERROR, 'Could not get foes info', '', __LINE__, __FILE__, $sql);
  844.         }
  845.  
  846.         $foes_row = $db->sql_fetchrow($result);
  847.         $friend_id = $foes_row['foe_id'];
  848.  
  849.         if ( !empty($friend_id) )
  850.         {
  851.                 message_die(GENERAL_ERROR, $lang['This_user_already_added_to_foes']);
  852.         }
  853.  
  854.         //
  855.         // All tests passes; buil a query to add friend to DB
  856.         //
  857.  
  858.         $sql = 'INSERT INTO '.FRIENDS_TABLE.' (user_id, friend_id) VALUES ('.$userdata['user_id'].', '.$sql_friend_id.')';
  859.         if (!$result = $db->sql_query($sql))
  860.         {
  861.                 message_die(GENERAL_ERROR, 'Could not add friend', '', __LINE__, __FILE__, $sql);
  862.         }
  863. }
  864.  
  865. function add_foe($to, $foe)
  866. {
  867. global $db, $lang;
  868.  
  869.         $userdata = get_userdata($to);
  870.  
  871.         if ( $userdata['username'] == $foe )
  872.         {
  873.                 message_die(GENERAL_ERROR, $lang['you_cannot_add_self']);
  874.         }
  875.  
  876.         if( !intval($foe) )
  877.         {
  878.                 $sql = 'SELECT user_id FROM '.USERS_TABLE.' WHERE username = \''.str_replace("\'", "''", $foe).'\'';
  879.                 if (!$result = $db->sql_query($sql))
  880.                 {
  881.                         message_die(GENERAL_ERROR, 'Could not get foe info', '', __LINE__, __FILE__, $sql);
  882.                 }
  883.  
  884.                 $foe_row = $db->sql_fetchrow($result);
  885.                 $foe_id = $foe_row['user_id'];
  886.         } else
  887.         {
  888.                 $foe_id = $foe;
  889.         }
  890.  
  891.         $sql_foe_id = $foe_id;
  892.  
  893.         if ( empty($foe_id) || $foe_id == ANONYMOUS )
  894.         {
  895.                 message_die(GENERAL_ERROR, $lang['select_correct_user']);
  896.         }
  897.  
  898.         //
  899.         // Is user already in foes list?
  900.         //
  901.  
  902.         $sql = 'SELECT foe_id FROM '.FOES_TABLE.' WHERE foe_id = '.$sql_foe_id.' AND user_id = '.$userdata['user_id'].'';
  903.         if (!$result = $db->sql_query($sql))
  904.         {
  905.                 message_die(GENERAL_ERROR, 'Could not get foes info', '', __LINE__, __FILE__, $sql);
  906.         }
  907.  
  908.         $foe_row = $db->sql_fetchrow($result);
  909.         $foe_id = $foe_row['foe_id'];
  910.  
  911.         if ( !empty($foe_id) )
  912.         {
  913.                 message_die(GENERAL_ERROR, $lang['This_user_already_added_to_foes']);
  914.         }
  915.  
  916.         //
  917.         // Is user in friends?
  918.         //
  919.  
  920.         $sql = 'SELECT friend_id FROM '.FRIENDS_TABLE.' WHERE friend_id = '.$sql_foe_id.' AND user_id = '.$userdata['user_id'].'';
  921.         if (!$result = $db->sql_query($sql))
  922.         {
  923.                 message_die(GENERAL_ERROR, 'Could not get friends info', '', __LINE__, __FILE__, $sql);
  924.         }
  925.  
  926.         $foes_row = $db->sql_fetchrow($result);
  927.         $foe_id = $foes_row['friend_id'];
  928.  
  929.         if ( !empty($foe_id) )
  930.         {
  931.                 message_die(GENERAL_ERROR, $lang['This_user_already_added_to_friends']);
  932.         }
  933.  
  934.         //
  935.         // All tests passes; buil a query to add friend to DB
  936.         //
  937.  
  938.         $sql = 'INSERT INTO '.FOES_TABLE.' (user_id, foe_id) VALUES ('.$userdata['user_id'].', '.$sql_foe_id.')';
  939.         if (!$result = $db->sql_query($sql))
  940.         {
  941.                 message_die(GENERAL_ERROR, 'Could not add foe', '', __LINE__, __FILE__, $sql);
  942.         }
  943.         message_die(GENERAL_MESSAGE, $lang['foe_suc_added']);
  944. }
  945.  
  946.  
  947. function get_status($id, $reverse = true, $nofriend=false, $nofoe=false)
  948. {
  949.         global $db, $userdata;
  950.  
  951.         if ( $reverse )
  952.         {
  953.                 $uid = $userdata['user_id'];
  954.                 $id = $id;
  955.         } else
  956.         {
  957.                 $uid = $id;
  958.                 $id = $userdata['user_id'];
  959.         }
  960.  
  961.         if ( !$nofriend )
  962.         {
  963.                 $sql = 'SELECT friend_id FROM '.FRIENDS_TABLE.'
  964.                 WHERE user_id = '.$id.'
  965.                 AND friend_id = '.$uid;
  966.                 if ( !($result = $db->sql_query($sql)) )
  967.                 {
  968.                         message_die(GENERAL_ERROR, 'Could not obtain friends information', '', __LINE__, __FILE__, $sql);
  969.                 }
  970.                 $friends = $db->sql_fetchrow($result);
  971.         }
  972.         if ( !$nofoe )
  973.         {
  974.                 $sql = 'SELECT foe_id FROM '.FOES_TABLE.'
  975.                 WHERE user_id = '.$id.'
  976.                 AND foe_id = '.$uid;
  977.  
  978.                 if ( !($result = $db->sql_query($sql)) )
  979.                 {
  980.                         message_die(GENERAL_ERROR, 'Could not obtain foes information', '', __LINE__, __FILE__, $sql);
  981.                 }
  982.                 $foes = $db->sql_fetchrow($result);
  983.         }
  984.         if ( !empty($foes['foe_id']) )
  985.         {
  986.                 return 2;
  987.         }
  988.         elseif ( !empty($friends['friend_id']) )
  989.         {
  990.                 return 1;
  991.         } else
  992.         {
  993.                 return 0;
  994.         }
  995.         }
  996.  
  997.  
  998. function realdate($date_syntax="Ymd",$date=0)
  999. {
  1000. 	global $lang;
  1001. 	$i=2;
  1002. 	if ($date>=0)
  1003. 	{
  1004. 	 	return create_date($date_syntax,$date*86400+1,0);
  1005. 	} else
  1006. 	{
  1007. 		$year= -(date%1461);
  1008. 		$days = $date + $year*1461;
  1009. 		while ($days<0)
  1010. 		{
  1011. 			$year--;
  1012. 			$days+=365;
  1013. 			if ($i++==3)
  1014. 			{
  1015. 				$i=0;
  1016. 				$days++;
  1017. 			}
  1018. 		}
  1019. 	}
  1020. 	$leap_year = ($i==0) ? TRUE : FALSE;
  1021. 	$months_array = ($i==0) ?
  1022. 		array (0,31,60,91,121,152,182,213,244,274,305,335,366) :
  1023. 		array (0,31,59,90,120,151,181,212,243,273,304,334,365);
  1024. 	for ($month=1;$month<12;$month++)
  1025. 	{
  1026. 		if ($days<$months_array[$month]) break;
  1027. 	}
  1028.  
  1029. 	$day=$days-$months_array[$month-1]+1;
  1030. 	return strtr ($date_syntax, array(
  1031. 		'a' => '',
  1032. 		'A' => '',
  1033. 		'\\d' => 'd',
  1034. 		'd' => ($day>9) ? $day : '0'.$day,
  1035. 		'\\D' => 'D',
  1036. 		'D' => $lang['day_short'][($date-3)%7],
  1037. 		'\\F' => 'F',
  1038. 		'F' => $lang['month_long'][$month-1],
  1039. 		'g' => '',
  1040. 		'G' => '',
  1041. 		'H' => '',
  1042. 		'h' => '',
  1043. 		'i' => '',
  1044. 		'I' => '',
  1045. 		'\\j' => 'j',
  1046. 		'j' => $day,
  1047. 		'\\l' => 'l',
  1048. 		'l' => $lang['day_long'][($date-3)%7],
  1049. 		'\\L' => 'L',
  1050. 		'L' => $leap_year,
  1051. 		'\\m' => 'm',
  1052. 		'm' => ($month>9) ? $month : '0'.$month,
  1053. 		'\\M' => 'M',
  1054. 		'M' => $lang['month_short'][$month-1],
  1055. 		'\\n' => 'n',
  1056. 		'n' => $month,
  1057. 		'O' => '',
  1058. 		's' => '',
  1059. 		'S' => '',
  1060. 		'\\t' => 't',
  1061. 		't' => $months_array[$month]-$months_array[$month-1],
  1062. 		'w' => '',
  1063. 		'\\y' => 'y',
  1064. 		'y' => ($year>29) ? $year-30 : $year+70,
  1065. 		'\\Y' => 'Y',
  1066. 		'Y' => $year+1970,
  1067. 		'\\z' => 'z',
  1068. 		'z' => $days,
  1069. 		'\\W' => '',
  1070. 		'W' => '') );
  1071. }
  1072.  
  1073. function check_medal_mod($medal_id)
  1074. {
  1075. 	global $db, $userdata;
  1076. 	
  1077. 	$sql = "SELECT *
  1078. 	FROM " . MEDAL_MOD_TABLE . "  
  1079. 	WHERE medal_id =" . $medal_id;
  1080. 	
  1081. 	if ( !($result = $db->sql_query($sql)) )
  1082. 	{
  1083. 		message_die(GENERAL_ERROR, 'Could not obtain user and medal information', '', __LINE__, __FILE__, $sql);
  1084. 	}
  1085.  
  1086. 	$medal_info = array();
  1087. 	$found = FALSE;
  1088. 	while ( $medal_info = $db->sql_fetchrow($result) )
  1089. 	{
  1090.  
  1091. 		$medal_moderator = $medal_info['user_id'];
  1092.  
  1093. 		if ( $medal_moderator == $userdata['user_id'] )
  1094. 		{
  1095. 			$found = TRUE;
  1096. 		}
  1097. 	}
  1098. 	$db->sql_freeresult($result);
  1099. 	
  1100. 	return $found;
  1101. }
  1102.  
  1103. ?>