X-Git-Url: http://git.vanrenterghem.biz/www.vanrenterghem.biz.git/blobdiff_plain/4b1ce0d83844cfd7c55e75a60ccb239882cd62e3..83ab5456767602f2a9860a7db7247f002ec96945:/phpBB2_old/includes/functions_admin.php diff --git a/phpBB2_old/includes/functions_admin.php b/phpBB2_old/includes/functions_admin.php deleted file mode 100644 index 23fe1b2..0000000 --- a/phpBB2_old/includes/functions_admin.php +++ /dev/null @@ -1,155 +0,0 @@ -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'] ) - { - $selected = ( $select_forum == $row['forum_id'] ) ? ' selected="selected"' : ''; - $forum_list .= ''; - } - } - - $forum_list = ( $forum_list == '' ) ? '' : ''; - - return $forum_list; -} - -// -// Synchronise functions for forums/topics -// -function sync($type, $id = false) -{ - 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"; - if ( !($result = $db->sql_query($sql)) ) - { - message_die(GENERAL_ERROR, 'Could not get topic count', '', __LINE__, __FILE__, $sql); - } - - $total_topics = ( $row = $db->sql_fetchrow($result) ) ? ( ( $row['total'] ) ? $row['total'] : 0 ) : 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 ( !$db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, 'Could not update forum', '', __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 = ( $row['total_posts'] ) ? "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" : "DELETE FROM " . TOPICS_TABLE . " WHERE topic_id = $id"; - if ( !$db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, 'Could not update topic', '', __LINE__, __FILE__, $sql); - } - } - break; - } - - return true; -} - -?> \ No newline at end of file