diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-03-10 00:27:24 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-03-10 00:27:24 +0000 |
| commit | cb97372773a384860d64642b0770c4730186ad1a (patch) | |
| tree | 6128f4e4c350b8c700b63b24d0dada64226ceabe /phpBB/includes/functions_admin.php | |
| parent | 8cb119817dc6364d263ee14e834cfa622ea19eeb (diff) | |
| download | forums-cb97372773a384860d64642b0770c4730186ad1a.tar forums-cb97372773a384860d64642b0770c4730186ad1a.tar.gz forums-cb97372773a384860d64642b0770c4730186ad1a.tar.bz2 forums-cb97372773a384860d64642b0770c4730186ad1a.tar.xz forums-cb97372773a384860d64642b0770c4730186ad1a.zip | |
These are formed from breaking up functions ... modified functions is not yet in CVS and these do nothing right now
git-svn-id: file:///svn/phpbb/trunk@2286 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/functions_admin.php')
| -rw-r--r-- | phpBB/includes/functions_admin.php | 166 |
1 files changed, 166 insertions, 0 deletions
diff --git a/phpBB/includes/functions_admin.php b/phpBB/includes/functions_admin.php new file mode 100644 index 0000000000..99b82df504 --- /dev/null +++ b/phpBB/includes/functions_admin.php @@ -0,0 +1,166 @@ +<?php +/*************************************************************************** + * functions_admin.php + * ------------------- + * begin : Saturday, Feb 13, 2001 + * copyright : (C) 2001 The phpBB Group + * email : support@phpbb.com + * + * $Id$ + * + * + ***************************************************************************/ + +/*************************************************************************** + * + * This program is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or + * (at your option) any later version. + * + * + ***************************************************************************/ + + +// +// Simple version of jumpbox, just lists authed forums +// +function make_forum_select($box_name, $ignore_forum = false) +{ + global $db, $userdata; + + $is_auth_ary = auth(AUTH_READ, AUTH_LIST_ALL, $userdata); + + $sql = "SELECT forum_id, forum_name + FROM " . FORUMS_TABLE . " + ORDER BY cat_id, forum_order"; + if ( !($result = $db->sql_query($sql)) ) + { + message_die(GENERAL_ERROR, 'Couldn not obtain forums information', '', __LINE__, __FILE__, $sql); + } + + $forum_list = ''; + while( $row = $db->sql_fetchrow($result) ) + { + if ( $is_auth_ary[$row['forum_id']]['auth_read'] && $ignore_forum != $row['forum_id'] ) + { + $forum_list .= '<option value="' . $row['forum_id'] . '">' . $row['forum_name'] . '</option>'; + } + } + + $forum_list = ( $forum_list == '' ) ? '<option value="-1">-- ! No Forums ! --</option>' : '<select name="' . $box_name . '">' . $forum_list . '</select>'; + + return $forum_list; +} + +// +// Synchronise functions for forums/topics +// +function sync($type, $id) +{ + global $db; + + switch($type) + { + case 'all forums': + $sql = "SELECT forum_id + FROM " . FORUMS_TABLE; + if ( !$result = $db->sql_query($sql) ) + { + message_die(GENERAL_ERROR, 'Could not get forum IDs', '', __LINE__, __FILE__, $sql); + } + + while( $row = $db->sql_fetchrow($result) ) + { + sync("forum", $row['forum_id']); + } + break; + + case 'all topics': + $sql = "SELECT topic_id + FROM " . TOPICS_TABLE; + if ( !$result = $db->sql_query($sql) ) + { + message_die(GENERAL_ERROR, 'Could not get topic ID', '', __LINE__, __FILE__, $sql); + } + + while( $row = $db->sql_fetchrow($result) ) + { + sync("topic", $row['topic_id']); + } + break; + + case 'forum': + $sql = "SELECT MAX(post_id) AS last_post, COUNT(post_id) AS total + FROM " . POSTS_TABLE . " + WHERE forum_id = $id"; + if ( !$result = $db->sql_query($sql) ) + { + message_die(GENERAL_ERROR, 'Could not get post ID', '', __LINE__, __FILE__, $sql); + } + + if ( $row = $db->sql_fetchrow($result) ) + { + $last_post = ( $row['last_post'] ) ? $row['last_post'] : 0; + $total_posts = ($row['total']) ? $row['total'] : 0; + } + else + { + $last_post = 0; + $total_posts = 0; + } + + $sql = "SELECT COUNT(topic_id) AS total + FROM " . TOPICS_TABLE . " + WHERE forum_id = $id + AND topic_status <> " . TOPIC_MOVED; + if ( !$result = $db->sql_query($sql) ) + { + message_die(GENERAL_ERROR, 'Could not get topic count', '', __LINE__, __FILE__, $sql); + } + + if ( $row = $db->sql_fetchrow($result) ) + { + $total_topics = ($row['total']) ? $row['total'] : 0; + } + else + { + $total_topics = 0; + } + + $sql = "UPDATE " . FORUMS_TABLE . " + SET forum_last_post_id = $last_post, forum_posts = $total_posts, forum_topics = $total_topics + WHERE forum_id = $id"; + if ( !$result = $db->sql_query($sql) ) + { + message_die(GENERAL_ERROR, "Could not update forum $id", '', __LINE__, __FILE__, $sql); + } + break; + + case 'topic': + $sql = "SELECT MAX(post_id) AS last_post, MIN(post_id) AS first_post, COUNT(post_id) AS total_posts + FROM " . POSTS_TABLE . " + WHERE topic_id = $id"; + if ( !$result = $db->sql_query($sql) ) + { + message_die(GENERAL_ERROR, "Could not get post ID", '', __LINE__, __FILE__, $sql); + } + + if ( $row = $db->sql_fetchrow($result) ) + { + $sql = "UPDATE " . TOPICS_TABLE . " + SET topic_replies = " . ( $row['total_posts'] - 1 ) . ", topic_first_post_id = " . $row['first_post'] . ", topic_last_post_id = " . $row['last_post'] . " + WHERE topic_id = $id"; + if ( !($result = $db->sql_query($sql)) ) + { + message_die(GENERAL_ERROR, "Could not update topic $id", '', __LINE__, __FILE__, $sql); + } + } + + break; + } + + return true; +} + +?>
\ No newline at end of file |