query('SELECT COUNT(id), SUM(num_replies) FROM '.$db->prefix.'topics WHERE moved_to IS NULL AND forum_id='.$forum_id) or error('Impossible de retrouver le total de discussions du forum', __FILE__, __LINE__, $db->error()); list($num_topics, $num_posts) = $db->fetch_row($result); $num_posts = $num_posts + $num_topics; // $num_posts is only the sum of all replies (we have to add the topic posts) $result = $db->query('SELECT last_post, last_post_id, last_poster FROM '.$db->prefix.'topics WHERE forum_id='.$forum_id.' AND moved_to IS NULL ORDER BY last_post DESC LIMIT 1') or error('Impossible de retrouver last_post/last_post_id/last_poster', __FILE__, __LINE__, $db->error()); if ($db->num_rows($result)) // There are topics in the forum { list($last_post, $last_post_id, $last_poster) = $db->fetch_row($result); $db->query('UPDATE '.$db->prefix.'forums SET num_topics='.$num_topics.', num_posts='.$num_posts.', last_post='.$last_post.', last_post_id='.$last_post_id.', last_poster=\''.$db->escape($last_poster).'\' WHERE id='.$forum_id) or error('Impossible de mettre à jour last_post/last_post_id/last_poster', __FILE__, __LINE__, $db->error()); } else // There are no topics $db->query('UPDATE '.$db->prefix.'forums SET num_topics=0, num_posts=0, last_post=NULL, last_post_id=NULL, last_poster=NULL WHERE id='.$forum_id) or error('Impossible de mettre à jour last_post/last_post_id/last_poster', __FILE__, __LINE__, $db->error()); } // // Delete a topic and all of it's posts // function delete_topic($topic_id) { global $db; // Delete the topic and any redirect topics $db->query('DELETE FROM '.$db->prefix.'topics WHERE id='.$topic_id.' OR moved_to='.$topic_id) or error('Impossible de supprimer le sujet', __FILE__, __LINE__, $db->error()); // Create a list of the post ID's in this topic $post_ids = ''; $result = $db->query('SELECT id FROM '.$db->prefix.'posts WHERE topic_id='.$topic_id) or error('Impossible de retrouver les messages', __FILE__, __LINE__, $db->error()); while ($row = $db->fetch_row($result)) $post_ids .= ($post_ids != '') ? ','.$row[0] : $row[0]; // Make sure we have a list of post ID's if ($post_ids != '') { strip_search_index($post_ids); // Delete posts in topic $db->query('DELETE FROM '.$db->prefix.'posts WHERE topic_id='.$topic_id) or error('Impossible de supprimer les messages', __FILE__, __LINE__, $db->error()); } // Delete any subscriptions for this topic $db->query('DELETE FROM '.$db->prefix.'subscriptions WHERE topic_id='.$topic_id) or error('Impossible de supprimer l\'abonnement', __FILE__, __LINE__, $db->error()); } // // Delete a single post // function delete_post($post_id, $topic_id) { global $db; $result = $db->query('SELECT id, poster, posted FROM '.$db->prefix.'posts WHERE topic_id='.$topic_id.' ORDER BY id DESC LIMIT 2') or error('Impossible de retrouver les informations du message', __FILE__, __LINE__, $db->error()); list($last_id, ,) = $db->fetch_row($result); list($second_last_id, $second_poster, $second_posted) = $db->fetch_row($result); // Delete the post $db->query('DELETE FROM '.$db->prefix.'posts WHERE id='.$post_id) or error('Impossible de supprimer le message', __FILE__, __LINE__, $db->error()); strip_search_index($post_id); // Count number of replies in the topic $result = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'posts WHERE topic_id='.$topic_id) or error('Impossible de retrouver le total de messages pour la discussion', __FILE__, __LINE__, $db->error()); $num_replies = $db->result($result, 0) - 1; // If the message we deleted is the most recent in the topic (at the end of the topic) if ($last_id == $post_id) { // If there is a $second_last_id there is more than 1 reply to the topic if (!empty($second_last_id)) $db->query('UPDATE '.$db->prefix.'topics SET last_post='.$second_posted.', last_post_id='.$second_last_id.', last_poster=\''.$db->escape($second_poster).'\', num_replies='.$num_replies.' WHERE id='.$topic_id) or error('Impossible de mettre à jour la discussion', __FILE__, __LINE__, $db->error()); else // We deleted the only reply, so now last_post/last_post_id/last_poster is posted/id/poster from the topic itself $db->query('UPDATE '.$db->prefix.'topics SET last_post=posted, last_post_id=id, last_poster=poster, num_replies='.$num_replies.' WHERE id='.$topic_id) or error('Impossible de mettre à jour la discussion', __FILE__, __LINE__, $db->error()); } else // Otherwise we just decrement the reply counter $db->query('UPDATE '.$db->prefix.'topics SET num_replies='.$num_replies.' WHERE id='.$topic_id) or error('Impossible de mettre à jour la discussion', __FILE__, __LINE__, $db->error()); } // // Replace censored words in $text // function censor_words($text) { global $db; static $search_for, $replace_with; // If not already built in a previous call, build an array of censor words and their replacement text if (!isset($search_for)) { $result = $db->query('SELECT search_for, replace_with FROM '.$db->prefix.'censoring') or error('Impossible de retrouver la liste des mots à censurer', __FILE__, __LINE__, $db->error()); $num_words = $db->num_rows($result); $search_for = array(); for ($i = 0; $i < $num_words; ++$i) { list($search_for[$i], $replace_with[$i]) = $db->fetch_row($result); $search_for[$i] = '/\b('.str_replace('\*', '\w*?', preg_quote($search_for[$i], '/')).')\b/i'; } } if (!empty($search_for)) $text = substr(preg_replace($search_for, $replace_with, ' '.$text.' '), 1, -1); return $text; } // // Determines the correct title for $user // $user must contain the elements 'username', 'title', 'posts', 'g_id' and 'g_user_title' // function get_title($user) { global $db, $pun_config, $pun_bans, $lang_common; static $ban_list, $pun_ranks; // If not already built in a previous call, build an array of lowercase banned usernames if (empty($ban_list)) { $ban_list = array(); foreach ($pun_bans as $cur_ban) $ban_list[] = strtolower($cur_ban['username']); } // If not already loaded in a previous call, load the cached ranks if ($pun_config['o_ranks'] == '1' && empty($pun_ranks)) { @include PUN_ROOT.'cache/cache_ranks.php'; if (!defined('PUN_RANKS_LOADED')) { require_once PUN_ROOT.'include/cache.php'; generate_ranks_cache(); require PUN_ROOT.'cache/cache_ranks.php'; } } // If the user has a custom title if ($user['title'] != '') $user_title = pun_htmlspecialchars($user['title']); // If the user is banned else if (in_array(strtolower($user['username']), $ban_list)) $user_title = $lang_common['Banned']; // If the user group has a default user title else if ($user['g_user_title'] != '') $user_title = pun_htmlspecialchars($user['g_user_title']); // If the user is a guest else if ($user['g_id'] == PUN_GUEST) $user_title = $lang_common['Guest']; else { // Are there any ranks? if ($pun_config['o_ranks'] == '1' && !empty($pun_ranks)) { @reset($pun_ranks); while (list(, $cur_rank) = @each($pun_ranks)) { if (intval($user['num_posts']) >= $cur_rank['min_posts']) $user_title = pun_htmlspecialchars($cur_rank['rank']); } } // If the user didn't "reach" any rank (or if ranks are disabled), we assign the default if (!isset($user_title)) $user_title = $lang_common['Member']; } return $user_title; } // // Generate a string with numbered links (for multipage scripts) // function paginate($num_pages, $cur_page, $link_to) { $pages = array(); $link_to_all = false; // If $cur_page == -1, we link to all pages (used in viewforum.php) if ($cur_page == -1) { $cur_page = 1; $link_to_all = true; } if ($num_pages <= 1) $pages = array('1'); else { if ($cur_page > 3) { $pages[] = '1'; if ($cur_page != 4) $pages[] = '…'; } // Don't ask me how the following works. It just does, OK? :-) for ($current = $cur_page - 2, $stop = $cur_page + 3; $current < $stop; ++$current) { if ($current < 1 || $current > $num_pages) continue; else if ($current != $cur_page || $link_to_all) $pages[] = ''.$current.''; else $pages[] = ''.$current.''; } if ($cur_page <= ($num_pages-3)) { if ($cur_page != ($num_pages-3)) $pages[] = '…'; $pages[] = ''.$num_pages.''; } } return implode(' ', $pages); } // // Display a message // function message($message, $no_back_link = false) { global $db, $lang_common, $pun_config, $pun_start, $tpl_main, $env; if (!defined('PUN_HEADER')) { global $pun_user; $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Info']; require PUN_ROOT.'header.php'; } ?> ', '"'), array('<', '>', '"'), $str); return $str; } // // Equivalent to strlen(), but counts &#[0-9]+ as one character (for unicode) // function pun_strlen($str) { return strlen(preg_replace('/&#([0-9]+);/', '!', $str)); } // // Convert \r\n and \r to \n // function pun_linebreaks($str) { return str_replace("\r", "\n", str_replace("\r\n", "\n", $str)); } // // A more aggressive version of trim() // function pun_trim($str) { global $lang_common; if (strpos($lang_common['lang_encoding'], '8859') !== false) { $fishy_chars = array(chr(0x81), chr(0x8D), chr(0x8F), chr(0x90), chr(0x9D), chr(0xA0)); return trim(str_replace($fishy_chars, ' ', $str)); } else return trim($str); } // // Display a message when board is in maintenance mode // function maintenance_message() { global $db, $pun_config, $lang_common, $pun_user; // Deal with newlines, tabs and multiple spaces $pattern = array("\t", ' ', ' '); $replace = array('    ', '  ', '  '); $message = str_replace($pattern, $replace, $pun_config['o_maintenance_message']); // Load the maintenance template $tpl_maint = trim(file_get_contents(PUN_ROOT.'include/template/maintenance.tpl')); // START SUBST - $tpl_maint = str_replace('', $lang_common['lang_direction'], $tpl_maint); // END SUBST - // START SUBST - $tpl_maint = str_replace('', $lang_common['lang_encoding'], $tpl_maint); // END SUBST - // START SUBST - ob_start(); ?> ', $tpl_temp, $tpl_maint); ob_end_clean(); // END SUBST - // START SUBST - $tpl_maint = str_replace('', $lang_common['Maintenance'], $tpl_maint); // END SUBST - // START SUBST - $tpl_maint = str_replace('', $message, $tpl_maint); // END SUBST - // End the transaction $db->end_transaction(); // START SUBST - while (preg_match('##', $tpl_maint, $cur_include)) { if (!file_exists(PUN_ROOT.'include/user/'.$cur_include[1])) error('Impossible de procéder à l\'inclusion utilisateur <pun_include "'.htmlspecialchars($cur_include[1]).'"> depuis le template main.tpl. Il n\'y a pas de fichier dans le répertoire /include/user/'); ob_start(); include PUN_ROOT.'include/user/'.$cur_include[1]; $tpl_temp = ob_get_contents(); $tpl_redir = str_replace($cur_include[0], $tpl_temp, $tpl_redir); ob_end_clean(); } // END SUBST - // Close the db connection (and free up any result data) $db->close(); exit($tpl_maint); } // // Display $message and redirect user to $destination_url // function redirect($destination_url, $message) { global $db, $pun_config, $lang_common, $pun_user; if ($destination_url == '') $destination_url = 'index.php'; // If the delay is 0 seconds, we might as well skip the redirect all together if ($pun_config['o_redirect_delay'] == '0') header('Location: '.str_replace('&', '&', $destination_url)); // Load the redirect template $tpl_redir = trim(file_get_contents(PUN_ROOT.'include/template/redirect.tpl')); // START SUBST - $tpl_redir = str_replace('', $lang_common['lang_direction'], $tpl_redir); // END SUBST - // START SUBST - $tpl_redir = str_replace('', $lang_common['lang_encoding'], $tpl_redir); // END SUBST - // START SUBST - ob_start(); ?> " /> ', $tpl_temp, $tpl_redir); ob_end_clean(); // END SUBST - // START SUBST - $tpl_redir = str_replace('', $lang_common['Redirecting'], $tpl_redir); // END SUBST - // START SUBST - $tpl_temp = $message.'

'.''.$lang_common['Click redirect'].''; $tpl_redir = str_replace('', $tpl_temp, $tpl_redir); // END SUBST - // START SUBST - ob_start(); // End the transaction $db->end_transaction(); // Display executed queries (if enabled) if (defined('PUN_SHOW_QUERIES')) display_saved_queries(); $tpl_temp = trim(ob_get_contents()); $tpl_redir = str_replace('', $tpl_temp, $tpl_redir); ob_end_clean(); // END SUBST - // START SUBST - while (preg_match('', $tpl_redir, $cur_include)) { ob_start(); include PUN_ROOT.$cur_include[1]; $tpl_temp = ob_get_contents(); $tpl_redir = str_replace('<'.$cur_include[0].'>', $tpl_temp, $tpl_redir); ob_end_clean(); } // END SUBST - // Close the db connection (and free up any result data) $db->close(); exit($tpl_redir); } // // Display a simple error message // function error($message, $file, $line, $db_error = false) { global $pun_config; // Set a default title if the script failed before $pun_config could be populated if (empty($pun_config)) $pun_config['o_board_title'] = 'PunBB'; // Empty output buffer and stop buffering @ob_end_clean(); // "Restart" output buffering if we are using ob_gzhandler (since the gzip header is already sent) if (!empty($pun_config['o_gzip']) && extension_loaded('zlib') && (strpos($_SERVER['HTTP_ACCEPT_ENCODING'], 'gzip') !== false || strpos($_SERVER['HTTP_ACCEPT_ENCODING'], 'deflate') !== false)) ob_start('ob_gzhandler'); ?> " />

Une erreur s'est produite

Fichier : '.$file.'
'."\n\t\t".'Ligne : '.$line.'

'."\n\t\t".'PunBB a rapporté : '.$message."\n"; if ($db_error) { echo "\t\t".'

La base de données a rapporté : '.pun_htmlspecialchars($db_error['error_msg']).(($db_error['error_no']) ? ' (Errno: '.$db_error['error_no'].')' : '')."\n"; if ($db_error['error_sql'] != '') echo "\t\t".'

Requête échouée : '.pun_htmlspecialchars($db_error['error_sql'])."\n"; } } else echo "\t\t".'Erreur : '.$message.'.'."\n"; ?>

close(); exit; } // DEBUG FUNCTIONS BELOW // // Display executed queries (if enabled) // function display_saved_queries() { global $db, $lang_common; // Get the queries so that we can print them out $saved_queries = $db->get_saved_queries(); ?>

Temps (s)	Requête
Temps total requête : s

$v) { if (!in_array($k, $no_unset) && isset($GLOBALS[$k])) unset($GLOBALS[$k]); } } // // Dump contents of variable(s) // function dump() { echo '

';

	$num_args = func_num_args();

	for ($i = 0; $i < $num_args; ++$i)
	{
		print_r(func_get_arg($i));
		echo "\n\n";
	}

	echo '

'; exit; }