/forum/includes/functions_admin.php
PHP | 3419 lines | 2519 code | 538 blank | 362 comment | 421 complexity | 985b8e5d2cbe4fc972e89fdb9421c884 MD5 | raw file
Possible License(s): AGPL-1.0, LGPL-3.0, MPL-2.0-no-copyleft-exception
- <?php
- /**
- *
- * @package acp
- * @version $Id$
- * @copyright (c) 2005 phpBB Group
- * @license http://opensource.org/licenses/gpl-license.php GNU Public License
- *
- */
- /**
- * @ignore
- */
- if (!defined('IN_PHPBB'))
- {
- exit;
- }
- /**
- * Recalculate Nested Sets
- *
- * @param int $new_id first left_id (should start with 1)
- * @param string $pkey primary key-column (containing the id for the parent_id of the children)
- * @param string $table constant or fullname of the table
- * @param int $parent_id parent_id of the current set (default = 0)
- * @param array $where contains strings to compare closer on the where statement (additional)
- *
- * @author EXreaction
- */
- function recalc_nested_sets(&$new_id, $pkey, $table, $parent_id = 0, $where = array())
- {
- global $db;
- $sql = 'SELECT *
- FROM ' . $table . '
- WHERE parent_id = ' . (int) $parent_id .
- ((!empty($where)) ? ' AND ' . implode(' AND ', $where) : '') . '
- ORDER BY left_id ASC';
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- // First we update the left_id for this module
- if ($row['left_id'] != $new_id)
- {
- $db->sql_query('UPDATE ' . $table . ' SET ' . $db->sql_build_array('UPDATE', array('left_id' => $new_id)) . " WHERE $pkey = {$row[$pkey]}");
- }
- $new_id++;
- // Then we go through any children and update their left/right id's
- recalc_nested_sets($new_id, $pkey, $table, $row[$pkey], $where);
- // Then we come back and update the right_id for this module
- if ($row['right_id'] != $new_id)
- {
- $db->sql_query('UPDATE ' . $table . ' SET ' . $db->sql_build_array('UPDATE', array('right_id' => $new_id)) . " WHERE $pkey = {$row[$pkey]}");
- }
- $new_id++;
- }
- $db->sql_freeresult($result);
- }
- /**
- * Simple version of jumpbox, just lists authed forums
- */
- function make_forum_select($select_id = false, $ignore_id = false, $ignore_acl = false, $ignore_nonpost = false, $ignore_emptycat = true, $only_acl_post = false, $return_array = false)
- {
- global $db, $user, $auth;
- // This query is identical to the jumpbox one
- $sql = 'SELECT forum_id, forum_name, parent_id, forum_type, forum_flags, forum_options, left_id, right_id
- FROM ' . FORUMS_TABLE . '
- ORDER BY left_id ASC';
- $result = $db->sql_query($sql, 600);
- $right = 0;
- $padding_store = array('0' => '');
- $padding = '';
- $forum_list = ($return_array) ? array() : '';
- // Sometimes it could happen that forums will be displayed here not be displayed within the index page
- // This is the result of forums not displayed at index, having list permissions and a parent of a forum with no permissions.
- // If this happens, the padding could be "broken"
- while ($row = $db->sql_fetchrow($result))
- {
- if ($row['left_id'] < $right)
- {
- $padding .= ' ';
- $padding_store[$row['parent_id']] = $padding;
- }
- else if ($row['left_id'] > $right + 1)
- {
- $padding = (isset($padding_store[$row['parent_id']])) ? $padding_store[$row['parent_id']] : '';
- }
- $right = $row['right_id'];
- $disabled = false;
- if (!$ignore_acl && $auth->acl_gets(array('f_list', 'a_forum', 'a_forumadd', 'a_forumdel'), $row['forum_id']))
- {
- if ($only_acl_post && !$auth->acl_get('f_post', $row['forum_id']) || (!$auth->acl_get('m_approve', $row['forum_id']) && !$auth->acl_get('f_noapprove', $row['forum_id'])))
- {
- $disabled = true;
- }
- }
- else if (!$ignore_acl)
- {
- continue;
- }
- if (
- ((is_array($ignore_id) && in_array($row['forum_id'], $ignore_id)) || $row['forum_id'] == $ignore_id)
- ||
- // Non-postable forum with no subforums, don't display
- ($row['forum_type'] == FORUM_CAT && ($row['left_id'] + 1 == $row['right_id']) && $ignore_emptycat)
- ||
- ($row['forum_type'] != FORUM_POST && $ignore_nonpost)
- )
- {
- $disabled = true;
- }
- if ($return_array)
- {
- // Include some more information...
- $selected = (is_array($select_id)) ? ((in_array($row['forum_id'], $select_id)) ? true : false) : (($row['forum_id'] == $select_id) ? true : false);
- $forum_list[$row['forum_id']] = array_merge(array('padding' => $padding, 'selected' => ($selected && !$disabled), 'disabled' => $disabled), $row);
- }
- else
- {
- $selected = (is_array($select_id)) ? ((in_array($row['forum_id'], $select_id)) ? ' selected="selected"' : '') : (($row['forum_id'] == $select_id) ? ' selected="selected"' : '');
- $forum_list .= '<option value="' . $row['forum_id'] . '"' . (($disabled) ? ' disabled="disabled" class="disabled-option"' : $selected) . '>' . $padding . $row['forum_name'] . '</option>';
- }
- }
- $db->sql_freeresult($result);
- unset($padding_store);
- return $forum_list;
- }
- /**
- * Generate size select options
- */
- function size_select_options($size_compare)
- {
- global $user;
- $size_types_text = array($user->lang['BYTES'], $user->lang['KIB'], $user->lang['MIB']);
- $size_types = array('b', 'kb', 'mb');
- $s_size_options = '';
- for ($i = 0, $size = sizeof($size_types_text); $i < $size; $i++)
- {
- $selected = ($size_compare == $size_types[$i]) ? ' selected="selected"' : '';
- $s_size_options .= '<option value="' . $size_types[$i] . '"' . $selected . '>' . $size_types_text[$i] . '</option>';
- }
- return $s_size_options;
- }
- /**
- * Generate list of groups (option fields without select)
- *
- * @param int $group_id The default group id to mark as selected
- * @param array $exclude_ids The group ids to exclude from the list, false (default) if you whish to exclude no id
- * @param int $manage_founder If set to false (default) all groups are returned, if 0 only those groups returned not being managed by founders only, if 1 only those groups returned managed by founders only.
- *
- * @return string The list of options.
- */
- function group_select_options($group_id, $exclude_ids = false, $manage_founder = false)
- {
- global $db, $user, $config;
- $exclude_sql = ($exclude_ids !== false && sizeof($exclude_ids)) ? 'WHERE ' . $db->sql_in_set('group_id', array_map('intval', $exclude_ids), true) : '';
- $sql_and = (!$config['coppa_enable']) ? (($exclude_sql) ? ' AND ' : ' WHERE ') . "group_name <> 'REGISTERED_COPPA'" : '';
- $sql_founder = ($manage_founder !== false) ? (($exclude_sql || $sql_and) ? ' AND ' : ' WHERE ') . 'group_founder_manage = ' . (int) $manage_founder : '';
- $sql = 'SELECT group_id, group_name, group_type
- FROM ' . GROUPS_TABLE . "
- $exclude_sql
- $sql_and
- $sql_founder
- ORDER BY group_type DESC, group_name ASC";
- $result = $db->sql_query($sql);
- $s_group_options = '';
- while ($row = $db->sql_fetchrow($result))
- {
- $selected = ($row['group_id'] == $group_id) ? ' selected="selected"' : '';
- $s_group_options .= '<option' . (($row['group_type'] == GROUP_SPECIAL) ? ' class="sep"' : '') . ' value="' . $row['group_id'] . '"' . $selected . '>' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';
- }
- $db->sql_freeresult($result);
- return $s_group_options;
- }
- /**
- * Obtain authed forums list
- */
- function get_forum_list($acl_list = 'f_list', $id_only = true, $postable_only = false, $no_cache = false)
- {
- global $db, $auth;
- static $forum_rows;
- if (!isset($forum_rows))
- {
- // This query is identical to the jumpbox one
- $expire_time = ($no_cache) ? 0 : 600;
- $sql = 'SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id
- FROM ' . FORUMS_TABLE . '
- ORDER BY left_id ASC';
- $result = $db->sql_query($sql, $expire_time);
- $forum_rows = array();
- $right = $padding = 0;
- $padding_store = array('0' => 0);
- while ($row = $db->sql_fetchrow($result))
- {
- if ($row['left_id'] < $right)
- {
- $padding++;
- $padding_store[$row['parent_id']] = $padding;
- }
- else if ($row['left_id'] > $right + 1)
- {
- // Ok, if the $padding_store for this parent is empty there is something wrong. For now we will skip over it.
- // @todo digging deep to find out "how" this can happen.
- $padding = (isset($padding_store[$row['parent_id']])) ? $padding_store[$row['parent_id']] : $padding;
- }
- $right = $row['right_id'];
- $row['padding'] = $padding;
- $forum_rows[] = $row;
- }
- $db->sql_freeresult($result);
- unset($padding_store);
- }
- $rowset = array();
- foreach ($forum_rows as $row)
- {
- if ($postable_only && $row['forum_type'] != FORUM_POST)
- {
- continue;
- }
- if ($acl_list == '' || ($acl_list != '' && $auth->acl_gets($acl_list, $row['forum_id'])))
- {
- $rowset[] = ($id_only) ? (int) $row['forum_id'] : $row;
- }
- }
- return $rowset;
- }
- /**
- * Get forum branch
- */
- function get_forum_branch($forum_id, $type = 'all', $order = 'descending', $include_forum = true)
- {
- global $db;
- switch ($type)
- {
- case 'parents':
- $condition = 'f1.left_id BETWEEN f2.left_id AND f2.right_id';
- break;
- case 'children':
- $condition = 'f2.left_id BETWEEN f1.left_id AND f1.right_id';
- break;
- default:
- $condition = 'f2.left_id BETWEEN f1.left_id AND f1.right_id OR f1.left_id BETWEEN f2.left_id AND f2.right_id';
- break;
- }
- $rows = array();
- $sql = 'SELECT f2.*
- FROM ' . FORUMS_TABLE . ' f1
- LEFT JOIN ' . FORUMS_TABLE . " f2 ON ($condition)
- WHERE f1.forum_id = $forum_id
- ORDER BY f2.left_id " . (($order == 'descending') ? 'ASC' : 'DESC');
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- if (!$include_forum && $row['forum_id'] == $forum_id)
- {
- continue;
- }
- $rows[] = $row;
- }
- $db->sql_freeresult($result);
- return $rows;
- }
- /**
- * Copies permissions from one forum to others
- *
- * @param int $src_forum_id The source forum we want to copy permissions from
- * @param array $dest_forum_ids The destination forum(s) we want to copy to
- * @param bool $clear_dest_perms True if destination permissions should be deleted
- * @param bool $add_log True if log entry should be added
- *
- * @return bool False on error
- *
- * @author bantu
- */
- function copy_forum_permissions($src_forum_id, $dest_forum_ids, $clear_dest_perms = true, $add_log = true)
- {
- global $db;
- // Only one forum id specified
- if (!is_array($dest_forum_ids))
- {
- $dest_forum_ids = array($dest_forum_ids);
- }
- // Make sure forum ids are integers
- $src_forum_id = (int) $src_forum_id;
- $dest_forum_ids = array_map('intval', $dest_forum_ids);
- // No source forum or no destination forums specified
- if (empty($src_forum_id) || empty($dest_forum_ids))
- {
- return false;
- }
- // Check if source forum exists
- $sql = 'SELECT forum_name
- FROM ' . FORUMS_TABLE . '
- WHERE forum_id = ' . $src_forum_id;
- $result = $db->sql_query($sql);
- $src_forum_name = $db->sql_fetchfield('forum_name');
- $db->sql_freeresult($result);
- // Source forum doesn't exist
- if (empty($src_forum_name))
- {
- return false;
- }
- // Check if destination forums exists
- $sql = 'SELECT forum_id, forum_name
- FROM ' . FORUMS_TABLE . '
- WHERE ' . $db->sql_in_set('forum_id', $dest_forum_ids);
- $result = $db->sql_query($sql);
- $dest_forum_ids = $dest_forum_names = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $dest_forum_ids[] = (int) $row['forum_id'];
- $dest_forum_names[] = $row['forum_name'];
- }
- $db->sql_freeresult($result);
- // No destination forum exists
- if (empty($dest_forum_ids))
- {
- return false;
- }
- // From the mysql documentation:
- // Prior to MySQL 4.0.14, the target table of the INSERT statement cannot appear
- // in the FROM clause of the SELECT part of the query. This limitation is lifted in 4.0.14.
- // Due to this we stay on the safe side if we do the insertion "the manual way"
- // Rowsets we're going to insert
- $users_sql_ary = $groups_sql_ary = array();
- // Query acl users table for source forum data
- $sql = 'SELECT user_id, auth_option_id, auth_role_id, auth_setting
- FROM ' . ACL_USERS_TABLE . '
- WHERE forum_id = ' . $src_forum_id;
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $row = array(
- 'user_id' => (int) $row['user_id'],
- 'auth_option_id' => (int) $row['auth_option_id'],
- 'auth_role_id' => (int) $row['auth_role_id'],
- 'auth_setting' => (int) $row['auth_setting'],
- );
- foreach ($dest_forum_ids as $dest_forum_id)
- {
- $users_sql_ary[] = $row + array('forum_id' => $dest_forum_id);
- }
- }
- $db->sql_freeresult($result);
- // Query acl groups table for source forum data
- $sql = 'SELECT group_id, auth_option_id, auth_role_id, auth_setting
- FROM ' . ACL_GROUPS_TABLE . '
- WHERE forum_id = ' . $src_forum_id;
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $row = array(
- 'group_id' => (int) $row['group_id'],
- 'auth_option_id' => (int) $row['auth_option_id'],
- 'auth_role_id' => (int) $row['auth_role_id'],
- 'auth_setting' => (int) $row['auth_setting'],
- );
- foreach ($dest_forum_ids as $dest_forum_id)
- {
- $groups_sql_ary[] = $row + array('forum_id' => $dest_forum_id);
- }
- }
- $db->sql_freeresult($result);
- $db->sql_transaction('begin');
- // Clear current permissions of destination forums
- if ($clear_dest_perms)
- {
- $sql = 'DELETE FROM ' . ACL_USERS_TABLE . '
- WHERE ' . $db->sql_in_set('forum_id', $dest_forum_ids);
- $db->sql_query($sql);
- $sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '
- WHERE ' . $db->sql_in_set('forum_id', $dest_forum_ids);
- $db->sql_query($sql);
- }
- $db->sql_multi_insert(ACL_USERS_TABLE, $users_sql_ary);
- $db->sql_multi_insert(ACL_GROUPS_TABLE, $groups_sql_ary);
- if ($add_log)
- {
- add_log('admin', 'LOG_FORUM_COPIED_PERMISSIONS', $src_forum_name, implode(', ', $dest_forum_names));
- }
- $db->sql_transaction('commit');
- return true;
- }
- /**
- * Get physical file listing
- */
- function filelist($rootdir, $dir = '', $type = 'gif|jpg|jpeg|png')
- {
- $matches = array($dir => array());
- // Remove initial / if present
- $rootdir = (substr($rootdir, 0, 1) == '/') ? substr($rootdir, 1) : $rootdir;
- // Add closing / if not present
- $rootdir = ($rootdir && substr($rootdir, -1) != '/') ? $rootdir . '/' : $rootdir;
- // Remove initial / if present
- $dir = (substr($dir, 0, 1) == '/') ? substr($dir, 1) : $dir;
- // Add closing / if not present
- $dir = ($dir && substr($dir, -1) != '/') ? $dir . '/' : $dir;
- if (!is_dir($rootdir . $dir))
- {
- return $matches;
- }
- $dh = @opendir($rootdir . $dir);
- if (!$dh)
- {
- return $matches;
- }
- while (($fname = readdir($dh)) !== false)
- {
- if (is_file("$rootdir$dir$fname"))
- {
- if (filesize("$rootdir$dir$fname") && preg_match('#\.' . $type . '$#i', $fname))
- {
- $matches[$dir][] = $fname;
- }
- }
- else if ($fname[0] != '.' && is_dir("$rootdir$dir$fname"))
- {
- $matches += filelist($rootdir, "$dir$fname", $type);
- }
- }
- closedir($dh);
- return $matches;
- }
- /**
- * Move topic(s)
- */
- function move_topics($topic_ids, $forum_id, $auto_sync = true)
- {
- global $db;
- if (empty($topic_ids))
- {
- return;
- }
- $forum_ids = array($forum_id);
- if (!is_array($topic_ids))
- {
- $topic_ids = array($topic_ids);
- }
- $sql = 'DELETE FROM ' . TOPICS_TABLE . '
- WHERE ' . $db->sql_in_set('topic_moved_id', $topic_ids) . '
- AND forum_id = ' . $forum_id;
- $db->sql_query($sql);
- if ($auto_sync)
- {
- $sql = 'SELECT DISTINCT forum_id
- FROM ' . TOPICS_TABLE . '
- WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $forum_ids[] = $row['forum_id'];
- }
- $db->sql_freeresult($result);
- }
- $table_ary = array(TOPICS_TABLE, POSTS_TABLE, LOG_TABLE, DRAFTS_TABLE, TOPICS_TRACK_TABLE);
- foreach ($table_ary as $table)
- {
- $sql = "UPDATE $table
- SET forum_id = $forum_id
- WHERE " . $db->sql_in_set('topic_id', $topic_ids);
- $db->sql_query($sql);
- }
- unset($table_ary);
- if ($auto_sync)
- {
- sync('forum', 'forum_id', $forum_ids, true, true);
- unset($forum_ids);
- }
- }
- /**
- * Move post(s)
- */
- function move_posts($post_ids, $topic_id, $auto_sync = true)
- {
- global $db;
- if (!is_array($post_ids))
- {
- $post_ids = array($post_ids);
- }
- $forum_ids = array();
- $topic_ids = array($topic_id);
- $sql = 'SELECT DISTINCT topic_id, forum_id
- FROM ' . POSTS_TABLE . '
- WHERE ' . $db->sql_in_set('post_id', $post_ids);
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $forum_ids[] = (int) $row['forum_id'];
- $topic_ids[] = (int) $row['topic_id'];
- }
- $db->sql_freeresult($result);
- $sql = 'SELECT forum_id
- FROM ' . TOPICS_TABLE . '
- WHERE topic_id = ' . $topic_id;
- $result = $db->sql_query($sql);
- $forum_row = $db->sql_fetchrow($result);
- $db->sql_freeresult($result);
- if (!$forum_row)
- {
- trigger_error('NO_TOPIC');
- }
- $sql = 'UPDATE ' . POSTS_TABLE . '
- SET forum_id = ' . (int) $forum_row['forum_id'] . ", topic_id = $topic_id
- WHERE " . $db->sql_in_set('post_id', $post_ids);
- $db->sql_query($sql);
- $sql = 'UPDATE ' . ATTACHMENTS_TABLE . "
- SET topic_id = $topic_id, in_message = 0
- WHERE " . $db->sql_in_set('post_msg_id', $post_ids);
- $db->sql_query($sql);
- if ($auto_sync)
- {
- $forum_ids[] = (int) $forum_row['forum_id'];
- sync('topic_reported', 'topic_id', $topic_ids);
- sync('topic_attachment', 'topic_id', $topic_ids);
- sync('topic', 'topic_id', $topic_ids, true);
- sync('forum', 'forum_id', $forum_ids, true, true);
- }
- // Update posted information
- update_posted_info($topic_ids);
- }
- /**
- * Remove topic(s)
- */
- function delete_topics($where_type, $where_ids, $auto_sync = true, $post_count_sync = true, $call_delete_posts = true)
- {
- global $db, $config;
- $approved_topics = 0;
- $forum_ids = $topic_ids = array();
- if ($where_type === 'range')
- {
- $where_clause = $where_ids;
- }
- else
- {
- $where_ids = (is_array($where_ids)) ? array_unique($where_ids) : array($where_ids);
- if (!sizeof($where_ids))
- {
- return array('topics' => 0, 'posts' => 0);
- }
- $where_clause = $db->sql_in_set($where_type, $where_ids);
- }
- // Making sure that delete_posts does not call delete_topics again...
- $return = array(
- 'posts' => ($call_delete_posts) ? delete_posts($where_type, $where_ids, false, true, $post_count_sync, false) : 0,
- );
- $sql = 'SELECT topic_id, forum_id, topic_approved, topic_moved_id
- FROM ' . TOPICS_TABLE . '
- WHERE ' . $where_clause;
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $forum_ids[] = $row['forum_id'];
- $topic_ids[] = $row['topic_id'];
- if ($row['topic_approved'] && !$row['topic_moved_id'])
- {
- $approved_topics++;
- }
- }
- $db->sql_freeresult($result);
- $return['topics'] = sizeof($topic_ids);
- if (!sizeof($topic_ids))
- {
- return $return;
- }
- $db->sql_transaction('begin');
- $table_ary = array(BOOKMARKS_TABLE, TOPICS_TRACK_TABLE, TOPICS_POSTED_TABLE, POLL_VOTES_TABLE, POLL_OPTIONS_TABLE, TOPICS_WATCH_TABLE, TOPICS_TABLE);
- foreach ($table_ary as $table)
- {
- $sql = "DELETE FROM $table
- WHERE " . $db->sql_in_set('topic_id', $topic_ids);
- $db->sql_query($sql);
- }
- unset($table_ary);
- $moved_topic_ids = array();
- // update the other forums
- $sql = 'SELECT topic_id, forum_id
- FROM ' . TOPICS_TABLE . '
- WHERE ' . $db->sql_in_set('topic_moved_id', $topic_ids);
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $forum_ids[] = $row['forum_id'];
- $moved_topic_ids[] = $row['topic_id'];
- }
- $db->sql_freeresult($result);
- if (sizeof($moved_topic_ids))
- {
- $sql = 'DELETE FROM ' . TOPICS_TABLE . '
- WHERE ' . $db->sql_in_set('topic_id', $moved_topic_ids);
- $db->sql_query($sql);
- }
- $db->sql_transaction('commit');
- if ($auto_sync)
- {
- sync('forum', 'forum_id', array_unique($forum_ids), true, true);
- sync('topic_reported', $where_type, $where_ids);
- }
- if ($approved_topics)
- {
- set_config_count('num_topics', $approved_topics * (-1), true);
- }
- return $return;
- }
- /**
- * Remove post(s)
- */
- function delete_posts($where_type, $where_ids, $auto_sync = true, $posted_sync = true, $post_count_sync = true, $call_delete_topics = true)
- {
- global $db, $config, $phpbb_root_path, $phpEx;
- if ($where_type === 'range')
- {
- $where_clause = $where_ids;
- }
- else
- {
- if (is_array($where_ids))
- {
- $where_ids = array_unique($where_ids);
- }
- else
- {
- $where_ids = array($where_ids);
- }
- if (!sizeof($where_ids))
- {
- return false;
- }
- $where_ids = array_map('intval', $where_ids);
- /* Possible code for splitting post deletion
- if (sizeof($where_ids) >= 1001)
- {
- // Split into chunks of 1000
- $chunks = array_chunk($where_ids, 1000);
- foreach ($chunks as $_where_ids)
- {
- delete_posts($where_type, $_where_ids, $auto_sync, $posted_sync, $post_count_sync, $call_delete_topics);
- }
- return;
- }*/
- $where_clause = $db->sql_in_set($where_type, $where_ids);
- }
- $approved_posts = 0;
- $post_ids = $topic_ids = $forum_ids = $post_counts = $remove_topics = array();
- $sql = 'SELECT post_id, poster_id, post_approved, post_postcount, topic_id, forum_id
- FROM ' . POSTS_TABLE . '
- WHERE ' . $where_clause;
- //-- mod: Prime Trash Bin ---------------------------------------------------//
- $sql = substr_replace($sql, 'post_deleted_time, ', strpos($sql, 'post_id'), 0);
- //-- end: Prime Trash Bin ---------------------------------------------------//
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $post_ids[] = (int) $row['post_id'];
- $poster_ids[] = (int) $row['poster_id'];
- $topic_ids[] = (int) $row['topic_id'];
- $forum_ids[] = (int) $row['forum_id'];
- if ($row['post_postcount'] && $post_count_sync && $row['post_approved'])
- {
- //-- mod: Prime Trash Bin ---------------------------------------------------//
- // Do not reduce post counts for posts that have already been marked as deleted.
- if (!empty($row['post_deleted_time']))
- {
- continue;
- }
- //-- end: Prime Trash Bin ---------------------------------------------------//
- $post_counts[$row['poster_id']] = (!empty($post_counts[$row['poster_id']])) ? $post_counts[$row['poster_id']] + 1 : 1;
- }
- if ($row['post_approved'])
- {
- $approved_posts++;
- }
- }
- $db->sql_freeresult($result);
- if (!sizeof($post_ids))
- {
- return false;
- }
- $db->sql_transaction('begin');
- $table_ary = array(POSTS_TABLE, REPORTS_TABLE);
- //-- mod: Prime Post Revisions ----------------------------------------------//
- $table_ary[] = POST_REVISIONS_TABLE; // To delete the post's edit history
- //-- end: Prime Post Revisions ----------------------------------------------//
- foreach ($table_ary as $table)
- {
- $sql = "DELETE FROM $table
- WHERE " . $db->sql_in_set('post_id', $post_ids);
- $db->sql_query($sql);
- }
- unset($table_ary);
- // Adjust users post counts
- if (sizeof($post_counts) && $post_count_sync)
- {
- foreach ($post_counts as $poster_id => $substract)
- {
- $sql = 'UPDATE ' . USERS_TABLE . '
- SET user_posts = 0
- WHERE user_id = ' . $poster_id . '
- AND user_posts < ' . $substract;
- $db->sql_query($sql);
- $sql = 'UPDATE ' . USERS_TABLE . '
- SET user_posts = user_posts - ' . $substract . '
- WHERE user_id = ' . $poster_id . '
- AND user_posts >= ' . $substract;
- $db->sql_query($sql);
- }
- }
- // Remove topics now having no posts?
- if (sizeof($topic_ids))
- {
- $sql = 'SELECT topic_id
- FROM ' . POSTS_TABLE . '
- WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '
- GROUP BY topic_id';
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $remove_topics[] = $row['topic_id'];
- }
- $db->sql_freeresult($result);
- // Actually, those not within remove_topics should be removed. ;)
- $remove_topics = array_diff($topic_ids, $remove_topics);
- }
- // Remove the message from the search index
- $search_type = basename($config['search_type']);
- if (!file_exists($phpbb_root_path . 'includes/search/' . $search_type . '.' . $phpEx))
- {
- trigger_error('NO_SUCH_SEARCH_MODULE');
- }
- include_once("{$phpbb_root_path}includes/search/$search_type.$phpEx");
- $error = false;
- $search = new $search_type($error);
- if ($error)
- {
- trigger_error($error);
- }
- $search->index_remove($post_ids, $poster_ids, $forum_ids);
- delete_attachments('post', $post_ids, false);
- $db->sql_transaction('commit');
- // Resync topics_posted table
- if ($posted_sync)
- {
- update_posted_info($topic_ids);
- }
- if ($auto_sync)
- {
- sync('topic_reported', 'topic_id', $topic_ids);
- sync('topic', 'topic_id', $topic_ids, true);
- sync('forum', 'forum_id', $forum_ids, true, true);
- }
- if ($approved_posts)
- {
- set_config_count('num_posts', $approved_posts * (-1), true);
- }
- // We actually remove topics now to not be inconsistent (the delete_topics function calls this function too)
- if (sizeof($remove_topics) && $call_delete_topics)
- {
- delete_topics('topic_id', $remove_topics, $auto_sync, $post_count_sync, false);
- }
- return sizeof($post_ids);
- }
- /**
- * Delete Attachments
- *
- * @param string $mode can be: post|message|topic|attach|user
- * @param mixed $ids can be: post_ids, message_ids, topic_ids, attach_ids, user_ids
- * @param bool $resync set this to false if you are deleting posts or topics
- */
- function delete_attachments($mode, $ids, $resync = true)
- {
- global $db, $config;
- // 0 is as bad as an empty array
- if (empty($ids))
- {
- return false;
- }
- if (is_array($ids))
- {
- $ids = array_unique($ids);
- $ids = array_map('intval', $ids);
- }
- else
- {
- $ids = array((int) $ids);
- }
- $sql_where = '';
- switch ($mode)
- {
- case 'post':
- case 'message':
- $sql_id = 'post_msg_id';
- $sql_where = ' AND in_message = ' . ($mode == 'message' ? 1 : 0);
- break;
- case 'topic':
- $sql_id = 'topic_id';
- break;
- case 'user':
- $sql_id = 'poster_id';
- break;
- case 'attach':
- default:
- $sql_id = 'attach_id';
- $mode = 'attach';
- break;
- }
- $post_ids = $message_ids = $topic_ids = $physical = array();
- // Collect post and topic ids for later use if we need to touch remaining entries (if resync is enabled)
- $sql = 'SELECT post_msg_id, topic_id, in_message, physical_filename, thumbnail, filesize, is_orphan
- FROM ' . ATTACHMENTS_TABLE . '
- WHERE ' . $db->sql_in_set($sql_id, $ids);
- $sql .= $sql_where;
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- // We only need to store post/message/topic ids if resync is enabled and the file is not orphaned
- if ($resync && !$row['is_orphan'])
- {
- if (!$row['in_message'])
- {
- $post_ids[] = $row['post_msg_id'];
- $topic_ids[] = $row['topic_id'];
- }
- else
- {
- $message_ids[] = $row['post_msg_id'];
- }
- }
- $physical[] = array('filename' => $row['physical_filename'], 'thumbnail' => $row['thumbnail'], 'filesize' => $row['filesize'], 'is_orphan' => $row['is_orphan']);
- }
- $db->sql_freeresult($result);
- // Delete attachments
- $sql = 'DELETE FROM ' . ATTACHMENTS_TABLE . '
- WHERE ' . $db->sql_in_set($sql_id, $ids);
- $sql .= $sql_where;
- $db->sql_query($sql);
- $num_deleted = $db->sql_affectedrows();
- if (!$num_deleted)
- {
- return 0;
- }
- // Delete attachments from filesystem
- $space_removed = $files_removed = 0;
- foreach ($physical as $file_ary)
- {
- if (phpbb_unlink($file_ary['filename'], 'file', true) && !$file_ary['is_orphan'])
- {
- // Only non-orphaned files count to the file size
- $space_removed += $file_ary['filesize'];
- $files_removed++;
- }
- if ($file_ary['thumbnail'])
- {
- phpbb_unlink($file_ary['filename'], 'thumbnail', true);
- }
- }
- if ($space_removed || $files_removed)
- {
- set_config_count('upload_dir_size', $space_removed * (-1), true);
- set_config_count('num_files', $files_removed * (-1), true);
- }
- // If we do not resync, we do not need to adjust any message, post, topic or user entries
- if (!$resync)
- {
- return $num_deleted;
- }
- // No more use for the original ids
- unset($ids);
- // Now, we need to resync posts, messages, topics. We go through every one of them
- $post_ids = array_unique($post_ids);
- $message_ids = array_unique($message_ids);
- $topic_ids = array_unique($topic_ids);
- // Update post indicators for posts now no longer having attachments
- if (sizeof($post_ids))
- {
- // Just check which posts are still having an assigned attachment not orphaned by querying the attachments table
- $sql = 'SELECT post_msg_id
- FROM ' . ATTACHMENTS_TABLE . '
- WHERE ' . $db->sql_in_set('post_msg_id', $post_ids) . '
- AND in_message = 0
- AND is_orphan = 0';
- $result = $db->sql_query($sql);
- $remaining_ids = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $remaining_ids[] = $row['post_msg_id'];
- }
- $db->sql_freeresult($result);
- // Now only unset those ids remaining
- $post_ids = array_diff($post_ids, $remaining_ids);
- if (sizeof($post_ids))
- {
- $sql = 'UPDATE ' . POSTS_TABLE . '
- SET post_attachment = 0
- WHERE ' . $db->sql_in_set('post_id', $post_ids);
- $db->sql_query($sql);
- }
- }
- // Update message table if messages are affected
- if (sizeof($message_ids))
- {
- // Just check which messages are still having an assigned attachment not orphaned by querying the attachments table
- $sql = 'SELECT post_msg_id
- FROM ' . ATTACHMENTS_TABLE . '
- WHERE ' . $db->sql_in_set('post_msg_id', $message_ids) . '
- AND in_message = 1
- AND is_orphan = 0';
- $result = $db->sql_query($sql);
- $remaining_ids = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $remaining_ids[] = $row['post_msg_id'];
- }
- $db->sql_freeresult($result);
- // Now only unset those ids remaining
- $message_ids = array_diff($message_ids, $remaining_ids);
- if (sizeof($message_ids))
- {
- $sql = 'UPDATE ' . PRIVMSGS_TABLE . '
- SET message_attachment = 0
- WHERE ' . $db->sql_in_set('msg_id', $message_ids);
- $db->sql_query($sql);
- }
- }
- // Now update the topics. This is a bit trickier, because there could be posts still having attachments within the topic
- if (sizeof($topic_ids))
- {
- // Just check which topics are still having an assigned attachment not orphaned by querying the attachments table (much less entries expected)
- $sql = 'SELECT topic_id
- FROM ' . ATTACHMENTS_TABLE . '
- WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '
- AND is_orphan = 0';
- $result = $db->sql_query($sql);
- $remaining_ids = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $remaining_ids[] = $row['topic_id'];
- }
- $db->sql_freeresult($result);
- // Now only unset those ids remaining
- $topic_ids = array_diff($topic_ids, $remaining_ids);
- if (sizeof($topic_ids))
- {
- $sql = 'UPDATE ' . TOPICS_TABLE . '
- SET topic_attachment = 0
- WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
- $db->sql_query($sql);
- }
- }
- return $num_deleted;
- }
- /**
- * Deletes shadow topics pointing to a specified forum.
- *
- * @param int $forum_id The forum id
- * @param string $sql_more Additional WHERE statement, e.g. t.topic_time < (time() - 1234)
- * @param bool $auto_sync Will call sync() if this is true
- *
- * @return array Array with affected forums
- *
- * @author bantu
- */
- function delete_topic_shadows($forum_id, $sql_more = '', $auto_sync = true)
- {
- global $db;
- if (!$forum_id)
- {
- // Nothing to do.
- return;
- }
- // Set of affected forums we have to resync
- $sync_forum_ids = array();
- // Amount of topics we select and delete at once.
- $batch_size = 500;
- do
- {
- $sql = 'SELECT t2.forum_id, t2.topic_id
- FROM ' . TOPICS_TABLE . ' t2, ' . TOPICS_TABLE . ' t
- WHERE t2.topic_moved_id = t.topic_id
- AND t.forum_id = ' . (int) $forum_id . '
- ' . (($sql_more) ? 'AND ' . $sql_more : '');
- $result = $db->sql_query_limit($sql, $batch_size);
- $topic_ids = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $topic_ids[] = (int) $row['topic_id'];
- $sync_forum_ids[(int) $row['forum_id']] = (int) $row['forum_id'];
- }
- $db->sql_freeresult($result);
- if (!empty($topic_ids))
- {
- $sql = 'DELETE FROM ' . TOPICS_TABLE . '
- WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
- $db->sql_query($sql);
- }
- }
- while (sizeof($topic_ids) == $batch_size);
- if ($auto_sync)
- {
- sync('forum', 'forum_id', $sync_forum_ids, true, true);
- }
- return $sync_forum_ids;
- }
- /**
- * Update/Sync posted information for topics
- */
- function update_posted_info(&$topic_ids)
- {
- global $db, $config;
- if (empty($topic_ids) || !$config['load_db_track'])
- {
- return;
- }
- // First of all, let us remove any posted information for these topics
- $sql = 'DELETE FROM ' . TOPICS_POSTED_TABLE . '
- WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
- $db->sql_query($sql);
- // Now, let us collect the user/topic combos for rebuilding the information
- $sql = 'SELECT poster_id, topic_id
- FROM ' . POSTS_TABLE . '
- WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '
- AND poster_id <> ' . ANONYMOUS . '
- GROUP BY poster_id, topic_id';
- $result = $db->sql_query($sql);
- $posted = array();
- while ($row = $db->sql_fetchrow($result))
- {
- // Add as key to make them unique (grouping by) and circumvent empty keys on array_unique
- $posted[$row['poster_id']][] = $row['topic_id'];
- }
- $db->sql_freeresult($result);
- // Now add the information...
- $sql_ary = array();
- foreach ($posted as $user_id => $topic_row)
- {
- foreach ($topic_row as $topic_id)
- {
- $sql_ary[] = array(
- 'user_id' => (int) $user_id,
- 'topic_id' => (int) $topic_id,
- 'topic_posted' => 1,
- );
- }
- }
- unset($posted);
- $db->sql_multi_insert(TOPICS_POSTED_TABLE, $sql_ary);
- }
- /**
- * Delete attached file
- */
- function phpbb_unlink($filename, $mode = 'file', $entry_removed = false)
- {
- global $db, $phpbb_root_path, $config;
- // Because of copying topics or modifications a physical filename could be assigned more than once. If so, do not remove the file itself.
- $sql = 'SELECT COUNT(attach_id) AS num_entries
- FROM ' . ATTACHMENTS_TABLE . "
- WHERE physical_filename = '" . $db->sql_escape(utf8_basename($filename)) . "'";
- $result = $db->sql_query($sql);
- $num_entries = (int) $db->sql_fetchfield('num_entries');
- $db->sql_freeresult($result);
- // Do not remove file if at least one additional entry with the same name exist.
- if (($entry_removed && $num_entries > 0) || (!$entry_removed && $num_entries > 1))
- {
- return false;
- }
- $filename = ($mode == 'thumbnail') ? 'thumb_' . utf8_basename($filename) : utf8_basename($filename);
- return @unlink($phpbb_root_path . $config['upload_path'] . '/' . $filename);
- }
- /**
- * All-encompasing sync function
- *
- * Exaples:
- * <code>
- * sync('topic', 'topic_id', 123); // resync topic #123
- * sync('topic', 'forum_id', array(2, 3)); // resync topics from forum #2 and #3
- * sync('topic'); // resync all topics
- * sync('topic', 'range', 'topic_id BETWEEN 1 AND 60'); // resync a range of topics/forums (only available for 'topic' and 'forum' modes)
- * </code>
- *
- * Modes:
- * - forum Resync complete forum
- * - topic Resync topics
- * - topic_moved Removes topic shadows that would be in the same forum as the topic they link to
- * - topic_approved Resyncs the topic_approved flag according to the status of the first post
- * - post_reported Resyncs the post_reported flag, relying on actual reports
- * - topic_reported Resyncs the topic_reported flag, relying on post_reported flags
- * - post_attachement Same as post_reported, but with attachment flags
- * - topic_attachement Same as topic_reported, but with attachment flags
- */
- function sync($mode, $where_type = '', $where_ids = '', $resync_parents = false, $sync_extra = false)
- {
- global $db;
- if (is_array($where_ids))
- {
- $where_ids = array_unique($where_ids);
- $where_ids = array_map('intval', $where_ids);
- }
- else if ($where_type != 'range')
- {
- $where_ids = ($where_ids) ? array((int) $where_ids) : array();
- }
- if ($mode == 'forum' || $mode == 'topic' || $mode == 'topic_approved' || $mode == 'topic_reported' || $mode == 'post_reported')
- {
- if (!$where_type)
- {
- $where_sql = '';
- $where_sql_and = 'WHERE';
- }
- else if ($where_type == 'range')
- {
- // Only check a range of topics/forums. For instance: 'topic_id BETWEEN 1 AND 60'
- $where_sql = 'WHERE (' . $mode[0] . ".$where_ids)";
- $where_sql_and = $where_sql . "\n\tAND";
- }
- else
- {
- // Do not sync the "global forum"
- $where_ids = array_diff($where_ids, array(0));
- if (!sizeof($where_ids))
- {
- // Empty array with IDs. This means that we don't have any work to do. Just return.
- return;
- }
- // Limit the topics/forums we are syncing, use specific topic/forum IDs.
- // $where_type contains the field for the where clause (forum_id, topic_id)
- $where_sql = 'WHERE ' . $db->sql_in_set($mode[0] . '.' . $where_type, $where_ids);
- $where_sql_and = $where_sql . "\n\tAND";
- }
- }
- else
- {
- if (!sizeof($where_ids))
- {
- return;
- }
- // $where_type contains the field for the where clause (forum_id, topic_id)
- $where_sql = 'WHERE ' . $db->sql_in_set($mode[0] . '.' . $where_type, $where_ids);
- $where_sql_and = $where_sql . "\n\tAND";
- }
- switch ($mode)
- {
- case 'topic_moved':
- $db->sql_transaction('begin');
- switch ($db->sql_layer)
- {
- case 'mysql4':
- case 'mysqli':
- $sql = 'DELETE FROM ' . TOPICS_TABLE . '
- USING ' . TOPICS_TABLE . ' t1, ' . TOPICS_TABLE . " t2
- WHERE t1.topic_moved_id = t2.topic_id
- AND t1.forum_id = t2.forum_id";
- $db->sql_query($sql);
- break;
- default:
- $sql = 'SELECT t1.topic_id
- FROM ' .TOPICS_TABLE . ' t1, ' . TOPICS_TABLE . " t2
- WHERE t1.topic_moved_id = t2.topic_id
- AND t1.forum_id = t2.forum_id";
- $result = $db->sql_query($sql);
- $topic_id_ary = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $topic_id_ary[] = $row['topic_id'];
- }
- $db->sql_freeresult($result);
- if (!sizeof($topic_id_ary))
- {
- return;
- }
- $sql = 'DELETE FROM ' . TOPICS_TABLE . '
- WHERE ' . $db->sql_in_set('topic_id', $topic_id_ary);
- $db->sql_query($sql);
- break;
- }
- $db->sql_transaction('commit');
- break;
- case 'topic_approved':
- $db->sql_transaction('begin');
- switch ($db->sql_layer)
- {
- case 'mysql4':
- case 'mysqli':
- $sql = 'UPDATE ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . " p
- SET t.topic_approved = p.post_approved
- $where_sql_and t.topic_first_post_id = p.post_id";
- $db->sql_query($sql);
- break;
- default:
- $sql = 'SELECT t.topic_id, p.post_approved
- FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . " p
- $where_sql_and p.post_id = t.topic_first_post_id
- AND p.post_approved <> t.topic_approved";
- $result = $db->sql_query($sql);
- $topic_ids = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $topic_ids[] = $row['topic_id'];
- }
- $db->sql_freeresult($result);
- if (!sizeof($topic_ids))
- {
- return;
- }
- $sql = 'UPDATE ' . TOPICS_TABLE . '
- SET topic_approved = 1 - topic_approved
- WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
- $db->sql_query($sql);
- break;
- }
- $db->sql_transaction('commit');
- break;
- case 'post_reported':
- $post_ids = $post_reported = array();
- $db->sql_transaction('begin');
- $sql = 'SELECT p.post_id, p.post_reported
- FROM ' . POSTS_TABLE . " p
- $where_sql
- GROUP BY p.post_id, p.post_reported";
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $post_ids[$row['post_id']] = $row['post_id'];
- if ($row['post_reported'])
- {
- $post_reported[$row['post_id']] = 1;
- }
- }
- $db->sql_freeresult($result);
- $sql = 'SELECT DISTINCT(post_id)
- FROM ' . REPORTS_TABLE . '
- WHERE ' . $db->sql_in_set('post_id', $post_ids) . '
- AND report_closed = 0';
- $result = $db->sql_query($sql);
- $post_ids = array();
- while ($row = $db->sql_fetchrow($result))
- {
- if (!isset($post_reported[$row['post_id']]))
- {
- $post_ids[] = $row['post_id'];
- }
- else
- {
- unset($post_reported[$row['post_id']]);
- }
- }
- $db->sql_freeresult($result);
- // $post_reported should be empty by now, if it's not it contains
- // posts that are falsely flagged as reported
- foreach ($post_reported as $post_id => $void)
- {
- $post_ids[] = $post_id;
- }
- if (sizeof($post_ids))
- {
- $sql = 'UPDATE ' . POSTS_TABLE . '
- SET post_reported = 1 - post_reported
- WHERE ' . $db->sql_in_set('post_id', $post_ids);
- $db->sql_query($sql);
- }
- $db->sql_transaction('commit');
- break;
- case 'topic_reported':
- if ($sync_extra)
- {
- sync('post_reported', $where_type, $where_ids);
- }
- $topic_ids = $topic_reported = array();
- $db->sql_transaction('begin');
- $sql = 'SELECT DISTINCT(t.topic_id)
- FROM ' . POSTS_TABLE . " t
- $where_sql_and t.post_reported = 1";
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $topic_reported[$row['topic_id']] = 1;
- }
- $db->sql_freeresult($result);
- $sql = 'SELECT t.topic_id, t.topic_reported
- FROM ' . TOPICS_TABLE . " t
- $where_sql";
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- if ($row['topic_reported'] ^ isset($topic_reported[$row['topic_id']]))
- {
- $topic_ids[] = $row['topic_id'];
- }
- }
- $db->sql_freeresult($result);
- if (sizeof($topic_ids))
- {
- $sql = 'UPDATE ' . TOPICS_TABLE . '
- SET topic_reported = 1 - topic_reported
- WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
- $db->sql_query($sql);
- }
- $db->sql_transaction('commit');
- break;
- case 'post_attachment':
- $post_ids = $post_attachment = array();
- $db->sql_transaction('begin');
- $sql = 'SELECT p.post_id, p.post_attachment
- FROM ' . POSTS_TABLE . " p
- $where_sql
- GROUP BY p.post_id, p.post_attachment";
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $post_ids[$row['post_id']] = $row['post_id'];
- if ($row['post_attachment'])
- {
- $post_attachment[$row['post_id']] = 1;
- }
- }
- $db->sql_freeresult($result);
- $sql = 'SELECT DISTINCT(post_msg_id)
- FROM ' . ATTACHMENTS_TABLE . '
- WHERE ' . $db->sql_in_set('post_msg_id', $post_ids) . '
- AND in_message = 0';
- $result = $db->sql_query($sql);
- $post_ids = array();
- while ($row = $db->sql_fetchrow($result))
- {
- if (!isset($post_attachment[$row['post_msg_id']]))
- {
- $post_ids[] = $row['post_msg_id'];
- }
- else
- {
- unset($post_attachment[$row['post_msg_id']]);
- }
- }
- $db->sql_freeresult($result);
- // $post_attachment should be empty by now, if it's not it contains
- // posts that are falsely flagged as having attachments
- foreach ($post_attachment as $post_id => $void)
- {
- $post_ids[] = $post_id;
- }
- if (sizeof($post_ids))
- {
- $sql = 'UPDATE ' . POSTS_TABLE . '
- SET post_attachment = 1 - post_attachment
- WHERE ' . $db->sql_in_set('post_id', $post_ids);
- $db->sql_query($sql);
- }
- $db->sql_transaction('commit');
- break;
- case 'topic_attachment':
- if ($sync_extra)
- {
- sync('post_attachment', $where_type, $where_ids);
- }
- $topic_ids = $topic_attachment = array();
- $db->sql_transaction('begin');
- $sql = 'SELECT DISTINCT(t.topic_id)
- FROM ' . POSTS_TABLE . " t
- $where_sql_and t.post_attachment = 1";
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $topic_attachment[$row['topic_id']] = 1;
- }
- $db->sql_freeresult($result);
- $sql = 'SELECT t.topic_id, t.topic_attachment
- FROM ' . TOPICS_TABLE . " t
- $where_sql";
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- if ($row['topic_attachment'] ^ isset($topic_attachment[$row['topic_id']]))
- {
- $topic_ids[] = $row['topic_id'];
- }
- }
- $db->sql_freeresult($result);
- if (sizeof($topic_ids))
- {
- $sql = 'UPDATE ' . TOPICS_TABLE . '
- SET topic_attachment = 1 - topic_attachment
- WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
- $db->sql_query($sql);
- }
- $db->sql_transaction('commit');
- break;
- case 'forum':
- $db->sql_transaction('begin');
- // 1: Get the list of all forums
- $sql = 'SELECT f.*
- FROM ' . FORUMS_TABLE . " f
- $where_sql";
- $result = $db->sql_query($sql);
- $forum_data = $forum_ids = $post_ids = $last_post_id = $post_info = array();
- while ($row = $db->sql_fetchrow($result))
- {
- if ($row['forum_type'] == FORUM_LINK)
- {
- continue;
- }
- $forum_id = (int) $row['forum_id'];
- $forum_ids[$forum_id] = $forum_id;
- $forum_data[$forum_id] = $row;
- if ($sync_extra)
- {
- $forum_data[$forum_id]['posts'] = 0;
- $forum_data[$forum_id]['topics'] = 0;
- $forum_data[$forum_id]['topics_real'] = 0;
- }
- $forum_data[$forum_id]['last_post_id'] = 0;
- $forum_data[$forum_id]['last_post_subject'] = '';
- $forum_data[$forum_id]['last_post_time'] = 0;
- $forum_data[$forum_id]['last_poster_id'] = 0;
- $forum_data[$forum_id]['last_poster_name'] = '';
- $forum_data[$forum_id]['last_poster_colour'] = '';
- }
- $db->sql_freeresult($result);
- if (!sizeof($forum_ids))
- {
- break;
- }
- $forum_ids = array_values($forum_ids);
- // 2: Get topic counts for each forum (optional)
- if ($sync_extra)
- {
- $sql = 'SELECT forum_id, topic_approved, COUNT(topic_id) AS forum_topics
- FROM ' . TOPICS_TABLE . '
- WHERE ' . $db->sql_in_set('forum_id', $forum_ids) . '
- GROUP BY forum_id, topic_approved';
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $forum_id = (int) $row['forum_id'];
- $forum_data[$forum_id]['topics_real'] += $row['forum_topics'];
- if ($row['topic_approved'])
- {
- $forum_data[$forum_id]['topics'] = $row['forum_topics'];
- }
- }
- $db->sql_freeresult($result);
- }
- // 3: Get post count for each forum (optional)
- if ($sync_extra)
- {
- if (sizeof($forum_ids) == 1)
- {
- $sql = 'SELECT SUM(t.topic_replies + 1) AS forum_posts
- FROM ' . TOPICS_TABLE . ' t
- WHERE ' . $db->sql_in_set('t.forum_id', $forum_ids) . '
- AND t.topic_approved = 1
- AND t.topic_status <> ' . ITEM_MOVED;
- }
- else
- {
- $sql = 'SELECT t.forum_id, SUM(t.topic_replies + 1) AS forum_posts
- FROM ' . TOPICS_TABLE . ' t
- WHERE ' . $db->sql_in_set('t.forum_id', $forum_ids) . '
- AND t.topic_approved = 1
- AND t.topic_status <> ' . ITEM_MOVED . '
- GROUP BY t.forum_id';
- }
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $forum_id = (sizeof($forum_ids) == 1) ? (int) $forum_ids[0] : (int) $row['forum_id'];
- $forum_data[$forum_id]['posts'] = (int) $row['forum_posts'];
- }
- $db->sql_freeresult($result);
- }
- // 4: Get last_post_id for each forum
- if (sizeof($forum_ids) == 1)
- {
- $sql = 'SELECT MAX(t.topic_last_post_id) as last_post_id
- FROM ' . TOPICS_TABLE . ' t
- WHERE ' . $db->sql_in_set('t.forum_id', $forum_ids) . '
- AND t.topic_approved = 1';
- }
- else
- {
- $sql = 'SELECT t.forum_id, MAX(t.topic_last_post_id) as last_post_id
- FROM ' . TOPICS_TABLE . ' t
- WHERE ' . $db->sql_in_set('t.forum_id', $forum_ids) . '
- AND t.topic_approved = 1
- GROUP BY t.forum_id';
- }
- //-- mod: Prime Trash Bin (Topics) ------------------------------------------//
- // Here we update the last post information for the forums.
- global $phpbb_root_path, $phpEx;
- include ($phpbb_root_path . 'includes/prime_trash_bin_a.' . $phpEx);
- if (stifle_topics_enabled())
- {
- // Get the last topic that isn't deleted, except for when doing the Trash forum.
- $sql = str_replace('AND t.topic_approved', 'AND (t.topic_deleted_time = 0' . (get_trash_forum() ? ' OR t.forum_id = ' . get_trash_forum() : '') . ') AND t.topic_approved', $sql);
- }
- //-- end: Prime Trash Bin (Topics) ------------------------------------------//
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $forum_id = (sizeof($forum_ids) == 1) ? (int) $forum_ids[0] : (int) $row['forum_id'];
- $forum_data[$forum_id]['last_post_id'] = (int) $row['last_post_id'];
- $post_ids[] = $row['last_post_id'];
- }
- $db->sql_freeresult($result);
- // 5: Retrieve last_post infos
- if (sizeof($post_ids))
- {
- $sql = 'SELECT p.post_id, p.poster_id, p.post_subject, p.post_time, p.post_username, u.username, u.user_colour
- FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u
- WHERE ' . $db->sql_in_set('p.post_id', $post_ids) . '
- AND p.poster_id = u.user_id';
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $post_info[$row['post_id']] = $row;
- }
- $db->sql_freeresult($result);
- foreach ($forum_data as $forum_id => $data)
- {
- if ($data['last_post_id'])
- {
- if (isset($post_info[$data['last_post_id']]))
- {
- $forum_data[$forum_id]['last_post_subject'] = $post_info[$data['last_post_id']]['post_subject'];
- $forum_data[$forum_id]['last_post_time'] = $post_info[$data['last_post_id']]['post_time'];
- $forum_data[$forum_id]['last_poster_id'] = $post_info[$data['last_post_id']]['poster_id'];
- $forum_data[$forum_id]['last_poster_name'] = ($post_info[$data['last_post_id']]['poster_id'] != ANONYMOUS) ? $post_info[$data['last_post_id']]['username'] : $post_info[$data['last_post_id']]['post_username'];
- $forum_data[$forum_id]['last_poster_colour'] = $post_info[$data['last_post_id']]['user_colour'];
- }
- else
- {
- // For some reason we did not find the post in the db
- $forum_data[$forum_id]['last_post_id'] = 0;
- $forum_data[$forum_id]['last_post_subject'] = '';
- $forum_data[$forum_id]['last_post_time'] = 0;
- $forum_data[$forum_id]['last_poster_id'] = 0;
- $forum_data[$forum_id]['last_poster_name'] = '';
- $forum_data[$forum_id]['last_poster_colour'] = '';
- }
- }
- }
- unset($post_info);
- }
- // 6: Now do that thing
- $fieldnames = array('last_post_id', 'last_post_subject', 'last_post_time', 'last_poster_id', 'last_poster_name', 'last_poster_colour');
- if ($sync_extra)
- {
- array_push($fieldnames, 'posts', 'topics', 'topics_real');
- }
- foreach ($forum_data as $forum_id => $row)
- {
- $sql_ary = array();
- foreach ($fieldnames as $fieldname)
- {
- if ($row['forum_' . $fieldname] != $row[$fieldname])
- {
- if (preg_match('#(name|colour|subject)$#', $fieldname))
- {
- $sql_ary['forum_' . $fieldname] = (string) $row[$fieldname];
- }
- else
- {
- $sql_ary['forum_' . $fieldname] = (int) $row[$fieldname];
- }
- }
- }
- if (sizeof($sql_ary))
- {
- $sql = 'UPDATE ' . FORUMS_TABLE . '
- SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
- WHERE forum_id = ' . $forum_id;
- $db->sql_query($sql);
- }
- }
- $db->sql_transaction('commit');
- break;
- case 'topic':
- $topic_data = $post_ids = $approved_unapproved_ids = $resync_forums = $delete_topics = $delete_posts = $moved_topics = array();
- $db->sql_transaction('begin');
- $sql = 'SELECT t.topic_id, t.forum_id, t.topic_moved_id, t.topic_approved, ' . (($sync_extra) ? 't.topic_attachment, t.topic_reported, ' : '') . 't.topic_poster, t.topic_time, t.topic_replies, t.topic_replies_real, t.topic_first_post_id, t.topic_first_poster_name, t.topic_first_poster_colour, t.topic_last_post_id, t.topic_last_post_subject, t.topic_last_poster_id, t.topic_last_poster_name, t.topic_last_poster_colour, t.topic_last_post_time
- FROM ' . TOPICS_TABLE . " t
- $where_sql";
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- if ($row['topic_moved_id'])
- {
- $moved_topics[] = $row['topic_id'];
- continue;
- }
- $topic_id = (int) $row['topic_id'];
- $topic_data[$topic_id] = $row;
- $topic_data[$topic_id]['replies_real'] = -1;
- $topic_data[$topic_id]['replies'] = 0;
- $topic_data[$topic_id]['first_post_id'] = 0;
- $topic_data[$topic_id]['last_post_id'] = 0;
- unset($topic_data[$topic_id]['topic_id']);
- // This array holds all topic_ids
- $delete_topics[$topic_id] = '';
- if ($sync_extra)
- {
- $topic_data[$topic_id]['reported'] = 0;
- $topic_data[$topic_id]['attachment'] = 0;
- }
- }
- $db->sql_freeresult($result);
- //-- mod: Prime Trash Bin (Posts) -------------------------------------------//
- // Here we update the last post information for the topics.
- global $phpbb_root_path, $phpEx;
- include ($phpbb_root_path . 'includes/prime_trash_bin_a.' . $phpEx);
- if (stifle_posts_enabled())
- {
- // Get the last topic that isn't deleted, except for when doing the Trash forum.
- $where_sql2 = str_replace('WHERE ', 'WHERE (t.post_deleted_time = 0' . (get_trash_forum() ? ' OR t.forum_id = ' . get_trash_forum() : '') . ') AND ', $where_sql);
- $sql = 'SELECT t.topic_id, MIN(t.post_id) AS first_post_id, MAX(t.post_id) AS last_post_id
- FROM ' . POSTS_TABLE . " t
- $where_sql2
- GROUP BY t.topic_id";
- $result = $db->sql_query($sql);
- while ($row2 = $db->sql_fetchrow($result))
- {
- $topic_id = (int) $row2['topic_id'];
- $first_post_ids[$topic_id] = $row2['first_post_id'];
- $last_post_ids[$topic_id] = $row2['last_post_id'];
- }
- $db->sql_freeresult($result);
- }
- //-- end: Prime Trash Bin (Posts) -------------------------------------------//
- // Use "t" as table alias because of the $where_sql clause
- // NOTE: 't.post_approved' in the GROUP BY is causing a major slowdown.
- $sql = 'SELECT t.topic_id, t.post_approved, COUNT(t.post_id) AS total_posts, MIN(t.post_id) AS first_post_id, MAX(t.post_id) AS last_post_id
- FROM ' . POSTS_TABLE . " t
- $where_sql
- GROUP BY t.topic_id, t.post_approved";
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $topic_id = (int) $row['topic_id'];
- $row['first_post_id'] = (int) $row['first_post_id'];
- $row['last_post_id'] = (int) $row['last_post_id'];
- //-- mod: Prime Trash Bin (Posts) -------------------------------------------//
- // Here we update the last post information for the topics.
- if (stifle_posts_enabled())
- {
- if (!empty($first_post_ids[$topic_id]))
- {
- $row['first_post_id'] = (int) $first_post_ids[$topic_id];
- }
- if (!empty($last_post_ids[$topic_id]))
- {
- $row['last_post_id'] = (int) $last_post_ids[$topic_id];
- }
- }
- //-- end: Prime Trash Bin (Posts) -------------------------------------------//
- if (!isset($topic_data[$topic_id]))
- {
- // Hey, these posts come from a topic that does not exist
- $delete_posts[$topic_id] = '';
- }
- else
- {
- // Unset the corresponding entry in $delete_topics
- // When we'll be done, only topics with no posts will remain
- unset($delete_topics[$topic_id]);
- $topic_data[$topic_id]['replies_real'] += $row['total_posts'];
- $topic_data[$topic_id]['first_post_id'] = (!$topic_data[$topic_id]['first_post_id']) ? $row['first_post_id'] : min($topic_data[$topic_id]['first_post_id'], $row['first_post_id']);
- if ($row['post_approved'] || !$topic_data[$topic_id]['last_post_id'])
- {
- $topic_data[$topic_id]['replies'] = $row['total_posts'] - 1;
- $topic_data[$topic_id]['last_post_id'] = $row['last_post_id'];
- }
- }
- }
- $db->sql_freeresult($result);
- foreach ($topic_data as $topic_id => $row)
- {
- $post_ids[] = $row['first_post_id'];
- if ($row['first_post_id'] != $row['last_post_id'])
- {
- $post_ids[] = $row['last_post_id'];
- }
- }
- // Now we delete empty topics and orphan posts
- if (sizeof($delete_posts))
- {
- delete_posts('topic_id', array_keys($delete_posts), false);
- unset($delete_posts);
- }
- if (!sizeof($topic_data))
- {
- // If we get there, topic ids were invalid or topics did not contain any posts
- delete_topics($where_type, $where_ids, true);
- return;
- }
- if (sizeof($delete_topics))
- {
- $delete_topic_ids = array();
- foreach ($delete_topics as $topic_id => $void)
- {
- unset($topic_data[$topic_id]);
- $delete_topic_ids[] = $topic_id;
- }
- delete_topics('topic_id', $delete_topic_ids, false);
- unset($delete_topics, $delete_topic_ids);
- }
- $sql = 'SELECT p.post_id, p.topic_id, p.post_approved, p.poster_id, p.post_subject, p.post_username, p.post_time, u.username, u.user_colour
- FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u
- WHERE ' . $db->sql_in_set('p.post_id', $post_ids) . '
- AND u.user_id = p.poster_id';
- $result = $db->sql_query($sql);
- $post_ids = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $topic_id = intval($row['topic_id']);
- if ($row['post_id'] == $topic_data[$topic_id]['first_post_id'])
- {
- if ($topic_data[$topic_id]['topic_approved'] != $row['post_approved'])
- {
- $approved_unapproved_ids[] = $topic_id;
- }
- $topic_data[$topic_id]['time'] = $row['post_time'];
- $topic_data[$topic_id]['poster'] = $row['poster_id'];
- $topic_data[$topic_id]['first_poster_name'] = ($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username'];
- $topic_data[$topic_id]['first_poster_colour'] = $row['user_colour'];
- }
- if ($row['post_id'] == $topic_data[$topic_id]['last_post_id'])
- {
- $topic_data[$topic_id]['last_poster_id'] = $row['poster_id'];
- $topic_data[$topic_id]['last_post_subject'] = $row['post_subject'];
- $topic_data[$topic_id]['last_post_time'] = $row['post_time'];
- $topic_data[$topic_id]['last_poster_name'] = ($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username'];
- $topic_data[$topic_id]['last_poster_colour'] = $row['user_colour'];
- }
- }
- $db->sql_freeresult($result);
- // Make sure shadow topics do link to existing topics
- if (sizeof($moved_topics))
- {
- $delete_topics = array();
- $sql = 'SELECT t1.topic_id, t1.topic_moved_id
- FROM ' . TOPICS_TABLE . ' t1
- LEFT JOIN ' . TOPICS_TABLE . ' t2 ON (t2.topic_id = t1.topic_moved_id)
- WHERE ' . $db->sql_in_set('t1.topic_id', $moved_topics) . '
- AND t2.topic_id IS NULL';
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $delete_topics[] = $row['topic_id'];
- }
- $db->sql_freeresult($result);
- if (sizeof($delete_topics))
- {
- delete_topics('topic_id', $delete_topics, false);
- }
- unset($delete_topics);
- // Make sure shadow topics having no last post data being updated (this only rarely happens...)
- $sql = 'SELECT topic_id, topic_moved_id, topic_last_post_id, topic_first_post_id
- FROM ' . TOPICS_TABLE . '
- WHERE ' . $db->sql_in_set('topic_id', $moved_topics) . '
- AND topic_last_post_time = 0';
- $result = $db->sql_query($sql);
- $shadow_topic_data = $post_ids = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $shadow_topic_data[$row['topic_moved_id']] = $row;
- $post_ids[] = $row['topic_last_post_id'];
- $post_ids[] = $row['topic_first_post_id'];
- }
- $db->sql_freeresult($result);
- $sync_shadow_topics = array();
- if (sizeof($post_ids))
- {
- $sql = 'SELECT p.post_id, p.topic_id, p.post_approved, p.poster_id, p.post_subject, p.post_username, p.post_time, u.username, u.user_colour
- FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u
- WHERE ' . $db->sql_in_set('p.post_id', $post_ids) . '
- AND u.user_id = p.poster_id';
- $result = $db->sql_query($sql);
- $post_ids = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $topic_id = (int) $row['topic_id'];
- // Ok, there should be a shadow topic. If there isn't, then there's something wrong with the db.
- // However, there's not much we can do about it.
- if (!empty($shadow_topic_data[$topic_id]))
- {
- if ($row['post_id'] == $shadow_topic_data[$topic_id]['topic_first_post_id'])
- {
- $orig_topic_id = $shadow_topic_data[$topic_id]['topic_id'];
- if (!isset($sync_shadow_topics[$orig_topic_id]))
- {
- $sync_shadow_topics[$orig_topic_id] = array();
- }
- $sync_shadow_topics[$orig_topic_id]['topic_time'] = $row['post_time'];
- $sync_shadow_topics[$orig_topic_id]['topic_poster'] = $row['poster_id'];
- $sync_shadow_topics[$orig_topic_id]['topic_first_poster_name'] = ($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username'];
- $sync_shadow_topics[$orig_topic_id]['topic_first_poster_colour'] = $row['user_colour'];
- }
- if ($row['post_id'] == $shadow_topic_data[$topic_id]['topic_last_post_id'])
- {
- $orig_topic_id = $shadow_topic_data[$topic_id]['topic_id'];
- if (!isset($sync_shadow_topics[$orig_topic_id]))
- {
- $sync_shadow_topics[$orig_topic_id] = array();
- }
- $sync_shadow_topics[$orig_topic_id]['topic_last_poster_id'] = $row['poster_id'];
- $sync_shadow_topics[$orig_topic_id]['topic_last_post_subject'] = $row['post_subject'];
- $sync_shadow_topics[$orig_topic_id]['topic_last_post_time'] = $row['post_time'];
- $sync_shadow_topics[$orig_topic_id]['topic_last_poster_name'] = ($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username'];
- $sync_shadow_topics[$orig_topic_id]['topic_last_poster_colour'] = $row['user_colour'];
- }
- }
- }
- $db->sql_freeresult($result);
- $shadow_topic_data = array();
- // Update the information we collected
- if (sizeof($sync_shadow_topics))
- {
- foreach ($sync_shadow_topics as $sync_topic_id => $sql_ary)
- {
- $sql = 'UPDATE ' . TOPICS_TABLE . '
- SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
- WHERE topic_id = ' . $sync_topic_id;
- $db->sql_query($sql);
- }
- }
- }
- unset($sync_shadow_topics, $shadow_topic_data);
- }
- // approved becomes unapproved, and vice-versa
- if (sizeof($approved_unapproved_ids))
- {
- $sql = 'UPDATE ' . TOPICS_TABLE . '
- SET topic_approved = 1 - topic_approved
- WHERE ' . $db->sql_in_set('topic_id', $approved_unapproved_ids);
- $db->sql_query($sql);
- }
- unset($approved_unapproved_ids);
- // These are fields that will be synchronised
- $fieldnames = array('time', 'replies', 'replies_real', 'poster', 'first_post_id', 'first_poster_name', 'first_poster_colour', 'last_post_id', 'last_post_subject', 'last_post_time', 'last_poster_id', 'last_poster_name', 'last_poster_colour');
- if ($sync_extra)
- {
- // This routine assumes that post_reported values are correct
- // if they are not, use sync('post_reported') first
- $sql = 'SELECT t.topic_id, p.post_id
- FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . " p
- $where_sql_and p.topic_id = t.topic_id
- AND p.post_reported = 1
- GROUP BY t.topic_id, p.post_id";
- $result = $db->sql_query($sql);
- $fieldnames[] = 'reported';
- while ($row = $db->sql_fetchrow($result))
- {
- $topic_data[intval($row['topic_id'])]['reported'] = 1;
- }
- $db->sql_freeresult($result);
- // This routine assumes that post_attachment values are correct
- // if they are not, use sync('post_attachment') first
- $sql = 'SELECT t.topic_id, p.post_id
- FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . " p
- $where_sql_and p.topic_id = t.topic_id
- AND p.post_attachment = 1
- GROUP BY t.topic_id, p.post_id";
- $result = $db->sql_query($sql);
- $fieldnames[] = 'attachment';
- while ($row = $db->sql_fetchrow($result))
- {
- $topic_data[intval($row['topic_id'])]['attachment'] = 1;
- }
- $db->sql_freeresult($result);
- }
- foreach ($topic_data as $topic_id => $row)
- {
- $sql_ary = array();
- foreach ($fieldnames as $fieldname)
- {
- if (isset($row[$fieldname]) && isset($row['topic_' . $fieldname]) && $row['topic_' . $fieldname] != $row[$fieldname])
- {
- $sql_ary['topic_' . $fieldname] = $row[$fieldname];
- }
- }
- if (sizeof($sql_ary))
- {
- $sql = 'UPDATE ' . TOPICS_TABLE . '
- SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
- WHERE topic_id = ' . $topic_id;
- $db->sql_query($sql);
- $resync_forums[$row['forum_id']] = $row['forum_id'];
- }
- }
- unset($topic_data);
- $db->sql_transaction('commit');
- // if some topics have been resync'ed then resync parent forums
- // except when we're only syncing a range, we don't want to sync forums during
- // batch processing.
- if ($resync_parents && sizeof($resync_forums) && $where_type != 'range')
- {
- sync('forum', 'forum_id', array_values($resync_forums), true, true);
- }
- break;
- }
- return;
- }
- /**
- * Prune function
- */
- function prune($forum_id, $prune_mode, $prune_date, $prune_flags = 0, $auto_sync = true)
- {
- global $db;
- if (!is_array($forum_id))
- {
- $forum_id = array($forum_id);
- }
- if (!sizeof($forum_id))
- {
- return;
- }
- $sql_and = '';
- if (!($prune_flags & FORUM_FLAG_PRUNE_ANNOUNCE))
- {
- $sql_and .= ' AND topic_type <> ' . POST_ANNOUNCE;
- }
- if (!($prune_flags & FORUM_FLAG_PRUNE_STICKY))
- {
- $sql_and .= ' AND topic_type <> ' . POST_STICKY;
- }
- if ($prune_mode == 'posted')
- {
- $sql_and .= " AND topic_last_post_time < $prune_date";
- }
- if ($prune_mode == 'viewed')
- {
- $sql_and .= " AND topic_last_view_time < $prune_date";
- }
- $sql = 'SELECT topic_id
- FROM ' . TOPICS_TABLE . '
- WHERE ' . $db->sql_in_set('forum_id', $forum_id) . "
- AND poll_start = 0
- $sql_and";
- $result = $db->sql_query($sql);
- $topic_list = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $topic_list[] = $row['topic_id'];
- }
- $db->sql_freeresult($result);
- if ($prune_flags & FORUM_FLAG_PRUNE_POLL)
- {
- $sql = 'SELECT topic_id
- FROM ' . TOPICS_TABLE . '
- WHERE ' . $db->sql_in_set('forum_id', $forum_id) . "
- AND poll_start > 0
- AND poll_last_vote < $prune_date
- $sql_and";
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $topic_list[] = $row['topic_id'];
- }
- $db->sql_freeresult($result);
- $topic_list = array_unique($topic_list);
- }
- return delete_topics('topic_id', $topic_list, $auto_sync, false);
- }
- /**
- * Function auto_prune(), this function now relies on passed vars
- */
- function auto_prune($forum_id, $prune_mode, $prune_flags, $prune_days, $prune_freq)
- {
- global $db;
- $sql = 'SELECT forum_name
- FROM ' . FORUMS_TABLE . "
- WHERE forum_id = $forum_id";
- $result = $db->sql_query($sql, 3600);
- $row = $db->sql_fetchrow($result);
- $db->sql_freeresult($result);
- if ($row)
- {
- $prune_date = time() - ($prune_days * 86400);
- $next_prune = time() + ($prune_freq * 86400);
- prune($forum_id, $prune_mode, $prune_date, $prune_flags, true);
- $sql = 'UPDATE ' . FORUMS_TABLE . "
- SET prune_next = $next_prune
- WHERE forum_id = $forum_id";
- $db->sql_query($sql);
- add_log('admin', 'LOG_AUTO_PRUNE', $row['forum_name']);
- }
- return;
- }
- /**
- * remove_comments will strip the sql comment lines out of an uploaded sql file
- * specifically for mssql and postgres type files in the install....
- */
- function remove_comments(&$output)
- {
- $lines = explode("\n", $output);
- $output = '';
- // try to keep mem. use down
- $linecount = sizeof($lines);
- $in_comment = false;
- for ($i = 0; $i < $linecount; $i++)
- {
- if (trim($lines[$i]) == '/*')
- {
- $in_comment = true;
- }
- if (!$in_comment)
- {
- $output .= $lines[$i] . "\n";
- }
- if (trim($lines[$i]) == '*/')
- {
- $in_comment = false;
- }
- }
- unset($lines);
- return $output;
- }
- /**
- * Cache moderators, called whenever permissions are changed via admin_permissions. Changes of username
- * and group names must be carried through for the moderators table
- */
- function cache_moderators()
- {
- global $db, $cache, $auth, $phpbb_root_path, $phpEx;
- // Remove cached sql results
- $cache->destroy('sql', MODERATOR_CACHE_TABLE);
- // Clear table
- switch ($db->sql_layer)
- {
- case 'sqlite':
- case 'firebird':
- $db->sql_query('DELETE FROM ' . MODERATOR_CACHE_TABLE);
- break;
- default:
- $db->sql_query('TRUNCATE TABLE ' . MODERATOR_CACHE_TABLE);
- break;
- }
- // We add moderators who have forum moderator permissions without an explicit ACL_NEVER setting
- $hold_ary = $ug_id_ary = $sql_ary = array();
- // Grab all users having moderative options...
- $hold_ary = $auth->acl_user_raw_data(false, 'm_%', false);
- // Add users?
- if (sizeof($hold_ary))
- {
- // At least one moderative option warrants a display
- $ug_id_ary = array_keys($hold_ary);
- // Remove users who have group memberships with DENY moderator permissions
- $sql = $db->sql_build_query('SELECT', array(
- 'SELECT' => 'a.forum_id, ug.user_id, g.group_id',
- 'FROM' => array(
- ACL_OPTIONS_TABLE => 'o',
- USER_GROUP_TABLE => 'ug',
- GROUPS_TABLE => 'g',
- ACL_GROUPS_TABLE => 'a',
- ),
- 'LEFT_JOIN' => array(
- array(
- 'FROM' => array(ACL_ROLES_DATA_TABLE => 'r'),
- 'ON' => 'a.auth_role_id = r.role_id'
- )
- ),
- 'WHERE' => '(o.auth_option_id = a.auth_option_id OR o.auth_option_id = r.auth_option_id)
- AND ((a.auth_setting = ' . ACL_NEVER . ' AND r.auth_setting IS NULL)
- OR r.auth_setting = ' . ACL_NEVER . ')
- AND a.group_id = ug.group_id
- AND g.group_id = ug.group_id
- AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1)
- AND ' . $db->sql_in_set('ug.user_id', $ug_id_ary) . "
- AND ug.user_pending = 0
- AND o.auth_option " . $db->sql_like_expression('m_' . $db->any_char),
- ));
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- if (isset($hold_ary[$row['user_id']][$row['forum_id']]))
- {
- unset($hold_ary[$row['user_id']][$row['forum_id']]);
- }
- }
- $db->sql_freeresult($result);
- if (sizeof($hold_ary))
- {
- // Get usernames...
- $sql = 'SELECT user_id, username
- FROM ' . USERS_TABLE . '
- WHERE ' . $db->sql_in_set('user_id', array_keys($hold_ary));
- $result = $db->sql_query($sql);
- $usernames_ary = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $usernames_ary[$row['user_id']] = $row['username'];
- }
- foreach ($hold_ary as $user_id => $forum_id_ary)
- {
- // Do not continue if user does not exist
- if (!isset($usernames_ary[$user_id]))
- {
- continue;
- }
- foreach ($forum_id_ary as $forum_id => $auth_ary)
- {
- $sql_ary[] = array(
- 'forum_id' => (int) $forum_id,
- 'user_id' => (int) $user_id,
- 'username' => (string) $usernames_ary[$user_id],
- 'group_id' => 0,
- 'group_name' => ''
- );
- }
- }
- }
- }
- // Now to the groups...
- $hold_ary = $auth->acl_group_raw_data(false, 'm_%', false);
- if (sizeof($hold_ary))
- {
- $ug_id_ary = array_keys($hold_ary);
- // Make sure not hidden or special groups are involved...
- $sql = 'SELECT group_name, group_id, group_type
- FROM ' . GROUPS_TABLE . '
- WHERE ' . $db->sql_in_set('group_id', $ug_id_ary);
- $result = $db->sql_query($sql);
- $groupnames_ary = array();
- while ($row = $db->sql_fetchrow($result))
- {
- if ($row['group_type'] == GROUP_HIDDEN || $row['group_type'] == GROUP_SPECIAL)
- {
- unset($hold_ary[$row['group_id']]);
- }
- $groupnames_ary[$row['group_id']] = $row['group_name'];
- }
- $db->sql_freeresult($result);
- foreach ($hold_ary as $group_id => $forum_id_ary)
- {
- // If there is no group, we do not assign it...
- if (!isset($groupnames_ary[$group_id]))
- {
- continue;
- }
- foreach ($forum_id_ary as $forum_id => $auth_ary)
- {
- $flag = false;
- foreach ($auth_ary as $auth_option => $setting)
- {
- // Make sure at least one ACL_YES option is set...
- if ($setting == ACL_YES)
- {
- $flag = true;
- break;
- }
- }
- if (!$flag)
- {
- continue;
- }
- $sql_ary[] = array(
- 'forum_id' => (int) $forum_id,
- 'user_id' => 0,
- 'username' => '',
- 'group_id' => (int) $group_id,
- 'group_name' => (string) $groupnames_ary[$group_id]
- );
- }
- }
- }
- $db->sql_multi_insert(MODERATOR_CACHE_TABLE, $sql_ary);
- }
- /**
- * View log
- * If $log_count is set to false, we will skip counting all entries in the database.
- */
- function view_log($mode, &$log, &$log_count, $limit = 0, $offset = 0, $forum_id = 0, $topic_id = 0, $user_id = 0, $limit_days = 0, $sort_by = 'l.log_time DESC', $keywords = '')
- {
- global $db, $user, $auth, $phpEx, $phpbb_root_path, $phpbb_admin_path;
- $topic_id_list = $reportee_id_list = $is_auth = $is_mod = array();
- $profile_url = (defined('IN_ADMIN')) ? append_sid("{$phpbb_admin_path}index.$phpEx", 'i=users&mode=overview') : append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile');
- switch ($mode)
- {
- case 'admin':
- $log_type = LOG_ADMIN;
- $sql_forum = '';
- break;
- case 'mod':
- $log_type = LOG_MOD;
- $sql_forum = '';
- if ($topic_id)
- {
- $sql_forum = 'AND l.topic_id = ' . (int) $topic_id;
- }
- else if (is_array($forum_id))
- {
- $sql_forum = 'AND ' . $db->sql_in_set('l.forum_id', array_map('intval', $forum_id));
- }
- else if ($forum_id)
- {
- $sql_forum = 'AND l.forum_id = ' . (int) $forum_id;
- }
- break;
- case 'user':
- $log_type = LOG_USERS;
- $sql_forum = 'AND l.reportee_id = ' . (int) $user_id;
- break;
- case 'users':
- $log_type = LOG_USERS;
- $sql_forum = '';
- break;
- case 'critical':
- $log_type = LOG_CRITICAL;
- $sql_forum = '';
- break;
- default:
- return;
- }
- // Use no preg_quote for $keywords because this would lead to sole backslashes being added
- // We also use an OR connection here for spaces and the | string. Currently, regex is not supported for searching (but may come later).
- $keywords = preg_split('#[\s|]+#u', utf8_strtolower($keywords), 0, PREG_SPLIT_NO_EMPTY);
- $sql_keywords = '';
- if (!empty($keywords))
- {
- $keywords_pattern = array();
- // Build pattern and keywords...
- for ($i = 0, $num_keywords = sizeof($keywords); $i < $num_keywords; $i++)
- {
- $keywords_pattern[] = preg_quote($keywords[$i], '#');
- $keywords[$i] = $db->sql_like_expression($db->any_char . $keywords[$i] . $db->any_char);
- }
- $keywords_pattern = '#' . implode('|', $keywords_pattern) . '#ui';
- $operations = array();
- foreach ($user->lang as $key => $value)
- {
- if (substr($key, 0, 4) == 'LOG_' && preg_match($keywords_pattern, $value))
- {
- $operations[] = $key;
- }
- }
- $sql_keywords = 'AND (';
- if (!empty($operations))
- {
- $sql_keywords .= $db->sql_in_set('l.log_operation', $operations) . ' OR ';
- }
- $sql_keywords .= 'LOWER(l.log_data) ' . implode(' OR LOWER(l.log_data) ', $keywords) . ')';
- }
- $sql = "SELECT l.*, u.username, u.username_clean, u.user_colour
- FROM " . LOG_TABLE . " l, " . USERS_TABLE . " u
- WHERE l.log_type = $log_type
- AND u.user_id = l.user_id
- " . (($limit_days) ? "AND l.log_time >= $limit_days" : '') . "
- $sql_keywords
- $sql_forum
- ORDER BY $sort_by";
- $result = $db->sql_query_limit($sql, $limit, $offset);
- $i = 0;
- $log = array();
- while ($row = $db->sql_fetchrow($result))
- {
- if ($row['topic_id'])
- {
- $topic_id_list[] = $row['topic_id'];
- }
- if ($row['reportee_id'])
- {
- $reportee_id_list[] = $row['reportee_id'];
- }
- //-- mod: Prime Trash Bin ---------------------------------------------------//
- // Here we set the log entry to display the optional "Reason" parameter if it exists.
- $log_data_ary = unserialize($row['log_data']);
- if (count($log_data_ary) == 2 && !empty($log_data_ary[1]) && in_array($row['log_operation'], array('LOG_TOPIC_STIFLED', 'LOG_TOPIC_TRASHED', 'LOG_TOPIC_UNSTIFLED', 'LOG_POST_STIFLED', 'LOG_POST_TRASHED', 'LOG_POST_UNSTIFLED')) && isset($user->lang[$row['log_operation'] . '_2']))
- {
- $row['log_operation'] = $row['log_operation'] . '_2';
- }
- //-- end: Prime Trash Bin ---------------------------------------------------//
- $log[$i] = array(
- 'id' => $row['log_id'],
- 'reportee_id' => $row['reportee_id'],
- 'reportee_username' => '',
- 'reportee_username_full'=> '',
- 'user_id' => $row['user_id'],
- 'username' => $row['username'],
- 'username_full' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour'], false, $profile_url),
- 'ip' => $row['log_ip'],
- 'time' => $row['log_time'],
- 'forum_id' => $row['forum_id'],
- 'topic_id' => $row['topic_id'],
- 'viewforum' => ($row['forum_id'] && $auth->acl_get('f_read', $row['forum_id'])) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : false,
- 'action' => (isset($user->lang[$row['log_operation']])) ? $user->lang[$row['log_operation']] : '{' . ucfirst(str_replace('_', ' ', $row['log_operation'])) . '}',
- );
- if (!empty($row['log_data']))
- {
- $log_data_ary = @unserialize($row['log_data']);
- $log_data_ary = ($log_data_ary === false) ? array() : $log_data_ary;
- if (isset($user->lang[$row['log_operation']]))
- {
- // Check if there are more occurrences of % than arguments, if there are we fill out the arguments array
- // It doesn't matter if we add more arguments than placeholders
- if ((substr_count($log[$i]['action'], '%') - sizeof($log_data_ary)) > 0)
- {
- $log_data_ary = array_merge($log_data_ary, array_fill(0, substr_count($log[$i]['action'], '%') - sizeof($log_data_ary), ''));
- }
- $log[$i]['action'] = vsprintf($log[$i]['action'], $log_data_ary);
- // If within the admin panel we do not censor text out
- if (defined('IN_ADMIN'))
- {
- $log[$i]['action'] = bbcode_nl2br($log[$i]['action']);
- }
- else
- {
- $log[$i]['action'] = bbcode_nl2br(censor_text($log[$i]['action']));
- }
- }
- else if (!empty($log_data_ary))
- {
- $log[$i]['action'] .= '<br />' . implode('', $log_data_ary);
- }
- /* Apply make_clickable... has to be seen if it is for good. :/
- // Seems to be not for the moment, reconsider later...
- $log[$i]['action'] = make_clickable($log[$i]['action']);
- */
- }
- $i++;
- }
- $db->sql_freeresult($result);
- if (sizeof($topic_id_list))
- {
- $topic_id_list = array_unique($topic_id_list);
- // This query is not really needed if move_topics() updates the forum_id field,
- // although it's also used to determine if the topic still exists in the database
- $sql = 'SELECT topic_id, forum_id
- FROM ' . TOPICS_TABLE . '
- WHERE ' . $db->sql_in_set('topic_id', array_map('intval', $topic_id_list));
- $result = $db->sql_query($sql);
- $default_forum_id = 0;
- while ($row = $db->sql_fetchrow($result))
- {
- if (!$row['forum_id'])
- {
- if ($auth->acl_getf_global('f_read'))
- {
- if (!$default_forum_id)
- {
- $sql = 'SELECT forum_id
- FROM ' . FORUMS_TABLE . '
- WHERE forum_type = ' . FORUM_POST;
- $f_result = $db->sql_query_limit($sql, 1);
- $default_forum_id = (int) $db->sql_fetchfield('forum_id', false, $f_result);
- $db->sql_freeresult($f_result);
- }
- $is_auth[$row['topic_id']] = $default_forum_id;
- }
- }
- else
- {
- if ($auth->acl_get('f_read', $row['forum_id']))
- {
- $is_auth[$row['topic_id']] = $row['forum_id'];
- }
- }
- if ($auth->acl_gets('a_', 'm_', $row['forum_id']))
- {
- $is_mod[$row['topic_id']] = $row['forum_id'];
- }
- }
- $db->sql_freeresult($result);
- foreach ($log as $key => $row)
- {
- $log[$key]['viewtopic'] = (isset($is_auth[$row['topic_id']])) ? append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $is_auth[$row['topic_id']] . '&t=' . $row['topic_id']) : false;
- $log[$key]['viewlogs'] = (isset($is_mod[$row['topic_id']])) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=logs&mode=topic_logs&t=' . $row['topic_id'], true, $user->session_id) : false;
- }
- }
- if (sizeof($reportee_id_list))
- {
- $reportee_id_list = array_unique($reportee_id_list);
- $reportee_names_list = array();
- $sql = 'SELECT user_id, username, user_colour
- FROM ' . USERS_TABLE . '
- WHERE ' . $db->sql_in_set('user_id', $reportee_id_list);
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $reportee_names_list[$row['user_id']] = $row;
- }
- $db->sql_freeresult($result);
- foreach ($log as $key => $row)
- {
- if (!isset($reportee_names_list[$row['reportee_id']]))
- {
- continue;
- }
- $log[$key]['reportee_username'] = $reportee_names_list[$row['reportee_id']]['username'];
- $log[$key]['reportee_username_full'] = get_username_string('full', $row['reportee_id'], $reportee_names_list[$row['reportee_id']]['username'], $reportee_names_list[$row['reportee_id']]['user_colour'], false, $profile_url);
- }
- }
- if ($log_count !== false)
- {
- $sql = 'SELECT COUNT(l.log_id) AS total_entries
- FROM ' . LOG_TABLE . ' l, ' . USERS_TABLE . " u
- WHERE l.log_type = $log_type
- AND l.user_id = u.user_id
- AND l.log_time >= $limit_days
- $sql_keywords
- $sql_forum";
- $result = $db->sql_query($sql);
- $log_count = (int) $db->sql_fetchfield('total_entries');
- $db->sql_freeresult($result);
- }
- return;
- }
- /**
- * Update foes - remove moderators and administrators from foe lists...
- */
- function update_foes($group_id = false, $user_id = false)
- {
- global $db, $auth;
- // update foes for some user
- if (is_array($user_id) && sizeof($user_id))
- {
- $sql = 'DELETE FROM ' . ZEBRA_TABLE . '
- WHERE ' . $db->sql_in_set('zebra_id', $user_id) . '
- AND foe = 1';
- $db->sql_query($sql);
- return;
- }
- // update foes for some group
- if (is_array($group_id) && sizeof($group_id))
- {
- // Grab group settings...
- $sql = $db->sql_build_query('SELECT', array(
- 'SELECT' => 'a.group_id',
- 'FROM' => array(
- ACL_OPTIONS_TABLE => 'ao',
- ACL_GROUPS_TABLE => 'a'
- ),
- 'LEFT_JOIN' => array(
- array(
- 'FROM' => array(ACL_ROLES_DATA_TABLE => 'r'),
- 'ON' => 'a.auth_role_id = r.role_id'
- ),
- ),
- 'WHERE' => '(ao.auth_option_id = a.auth_option_id OR ao.auth_option_id = r.auth_option_id)
- AND ' . $db->sql_in_set('a.group_id', $group_id) . "
- AND ao.auth_option IN ('a_', 'm_')",
- 'GROUP_BY' => 'a.group_id'
- ));
- $result = $db->sql_query($sql);
- $groups = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $groups[] = (int) $row['group_id'];
- }
- $db->sql_freeresult($result);
- if (!sizeof($groups))
- {
- return;
- }
- switch ($db->sql_layer)
- {
- case 'mysqli':
- case 'mysql4':
- $sql = 'DELETE ' . (($db->sql_layer === 'mysqli' || version_compare($db->sql_server_info(true), '4.1', '>=')) ? 'z.*' : ZEBRA_TABLE) . '
- FROM ' . ZEBRA_TABLE . ' z, ' . USER_GROUP_TABLE . ' ug
- WHERE z.zebra_id = ug.user_id
- AND z.foe = 1
- AND ' . $db->sql_in_set('ug.group_id', $groups);
- $db->sql_query($sql);
- break;
- default:
- $sql = 'SELECT user_id
- FROM ' . USER_GROUP_TABLE . '
- WHERE ' . $db->sql_in_set('group_id', $groups);
- $result = $db->sql_query($sql);
- $users = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $users[] = (int) $row['user_id'];
- }
- $db->sql_freeresult($result);
- if (sizeof($users))
- {
- $sql = 'DELETE FROM ' . ZEBRA_TABLE . '
- WHERE ' . $db->sql_in_set('zebra_id', $users) . '
- AND foe = 1';
- $db->sql_query($sql);
- }
- break;
- }
- return;
- }
- // update foes for everyone
- $perms = array();
- foreach ($auth->acl_get_list(false, array('a_', 'm_'), false) as $forum_id => $forum_ary)
- {
- foreach ($forum_ary as $auth_option => $user_ary)
- {
- $perms = array_merge($perms, $user_ary);
- }
- }
- if (sizeof($perms))
- {
- $sql = 'DELETE FROM ' . ZEBRA_TABLE . '
- WHERE ' . $db->sql_in_set('zebra_id', array_unique($perms)) . '
- AND foe = 1';
- $db->sql_query($sql);
- }
- unset($perms);
- }
- /**
- * Lists inactive users
- */
- function view_inactive_users(&$users, &$user_count, $limit = 0, $offset = 0, $limit_days = 0, $sort_by = 'user_inactive_time DESC')
- {
- global $db, $user;
- $sql = 'SELECT COUNT(user_id) AS user_count
- FROM ' . USERS_TABLE . '
- WHERE user_type = ' . USER_INACTIVE .
- (($limit_days) ? " AND user_inactive_time >= $limit_days" : '');
- $result = $db->sql_query($sql);
- $user_count = (int) $db->sql_fetchfield('user_count');
- $db->sql_freeresult($result);
- if ($offset >= $user_count)
- {
- $offset = ($offset - $limit < 0) ? 0 : $offset - $limit;
- }
- $sql = 'SELECT *
- FROM ' . USERS_TABLE . '
- WHERE user_type = ' . USER_INACTIVE .
- (($limit_days) ? " AND user_inactive_time >= $limit_days" : '') . "
- ORDER BY $sort_by";
- $result = $db->sql_query_limit($sql, $limit, $offset);
- while ($row = $db->sql_fetchrow($result))
- {
- $row['inactive_reason'] = $user->lang['INACTIVE_REASON_UNKNOWN'];
- switch ($row['user_inactive_reason'])
- {
- case INACTIVE_REGISTER:
- $row['inactive_reason'] = $user->lang['INACTIVE_REASON_REGISTER'];
- break;
- case INACTIVE_PROFILE:
- $row['inactive_reason'] = $user->lang['INACTIVE_REASON_PROFILE'];
- break;
- case INACTIVE_MANUAL:
- $row['inactive_reason'] = $user->lang['INACTIVE_REASON_MANUAL'];
- break;
- case INACTIVE_REMIND:
- $row['inactive_reason'] = $user->lang['INACTIVE_REASON_REMIND'];
- break;
- }
- $users[] = $row;
- }
- return $offset;
- }
- /**
- * Lists warned users
- */
- function view_warned_users(&$users, &$user_count, $limit = 0, $offset = 0, $limit_days = 0, $sort_by = 'user_warnings DESC')
- {
- global $db;
- $sql = 'SELECT user_id, username, user_colour, user_warnings, user_last_warning
- FROM ' . USERS_TABLE . '
- WHERE user_warnings > 0
- ' . (($limit_days) ? "AND user_last_warning >= $limit_days" : '') . "
- ORDER BY $sort_by";
- $result = $db->sql_query_limit($sql, $limit, $offset);
- $users = $db->sql_fetchrowset($result);
- $db->sql_freeresult($result);
- $sql = 'SELECT count(user_id) AS user_count
- FROM ' . USERS_TABLE . '
- WHERE user_warnings > 0
- ' . (($limit_days) ? "AND user_last_warning >= $limit_days" : '');
- $result = $db->sql_query($sql);
- $user_count = (int) $db->sql_fetchfield('user_count');
- $db->sql_freeresult($result);
- return;
- }
- /**
- * Get database size
- * Currently only mysql and mssql are supported
- */
- function get_database_size()
- {
- global $db, $user, $table_prefix;
- $database_size = false;
- // This code is heavily influenced by a similar routine in phpMyAdmin 2.2.0
- switch ($db->sql_layer)
- {
- case 'mysql':
- case 'mysql4':
- case 'mysqli':
- $sql = 'SELECT VERSION() AS mysql_version';
- $result = $db->sql_query($sql);
- $row = $db->sql_fetchrow($result);
- $db->sql_freeresult($result);
- if ($row)
- {
- $version = $row['mysql_version'];
- if (preg_match('#(3\.23|[45]\.)#', $version))
- {
- $db_name = (preg_match('#^(?:3\.23\.(?:[6-9]|[1-9]{2}))|[45]\.#', $version)) ? "`{$db->dbname}`" : $db->dbname;
- $sql = 'SHOW TABLE STATUS
- FROM ' . $db_name;
- $result = $db->sql_query($sql, 7200);
- $database_size = 0;
- while ($row = $db->sql_fetchrow($result))
- {
- if ((isset($row['Type']) && $row['Type'] != 'MRG_MyISAM') || (isset($row['Engine']) && ($row['Engine'] == 'MyISAM' || $row['Engine'] == 'InnoDB')))
- {
- if ($table_prefix != '')
- {
- if (strpos($row['Name'], $table_prefix) !== false)
- {
- $database_size += $row['Data_length'] + $row['Index_length'];
- }
- }
- else
- {
- $database_size += $row['Data_length'] + $row['Index_length'];
- }
- }
- }
- $db->sql_freeresult($result);
- }
- }
- break;
- case 'firebird':
- global $dbname;
- // if it on the local machine, we can get lucky
- if (file_exists($dbname))
- {
- $database_size = filesize($dbname);
- }
- break;
- case 'sqlite':
- global $dbhost;
- if (file_exists($dbhost))
- {
- $database_size = filesize($dbhost);
- }
- break;
- case 'mssql':
- case 'mssql_odbc':
- case 'mssqlnative':
- $sql = 'SELECT ((SUM(size) * 8.0) * 1024.0) as dbsize
- FROM sysfiles';
- $result = $db->sql_query($sql, 7200);
- $database_size = ($row = $db->sql_fetchrow($result)) ? $row['dbsize'] : false;
- $db->sql_freeresult($result);
- break;
- case 'postgres':
- $sql = "SELECT proname
- FROM pg_proc
- WHERE proname = 'pg_database_size'";
- $result = $db->sql_query($sql);
- $row = $db->sql_fetchrow($result);
- $db->sql_freeresult($result);
- if ($row['proname'] == 'pg_database_size')
- {
- $database = $db->dbname;
- if (strpos($database, '.') !== false)
- {
- list($database, ) = explode('.', $database);
- }
- $sql = "SELECT oid
- FROM pg_database
- WHERE datname = '$database'";
- $result = $db->sql_query($sql);
- $row = $db->sql_fetchrow($result);
- $db->sql_freeresult($result);
- $oid = $row['oid'];
- $sql = 'SELECT pg_database_size(' . $oid . ') as size';
- $result = $db->sql_query($sql);
- $row = $db->sql_fetchrow($result);
- $db->sql_freeresult($result);
- $database_size = $row['size'];
- }
- break;
- case 'oracle':
- $sql = 'SELECT SUM(bytes) as dbsize
- FROM user_segments';
- $result = $db->sql_query($sql, 7200);
- $database_size = ($row = $db->sql_fetchrow($result)) ? $row['dbsize'] : false;
- $db->sql_freeresult($result);
- break;
- }
- $database_size = ($database_size !== false) ? get_formatted_filesize($database_size) : $user->lang['NOT_AVAILABLE'];
- return $database_size;
- }
- /**
- * Retrieve contents from remotely stored file
- */
- function get_remote_file($host, $directory, $filename, &$errstr, &$errno, $port = 80, $timeout = 10)
- {
- global $user;
- if ($fsock = @fsockopen($host, $port, $errno, $errstr, $timeout))
- {
- @fputs($fsock, "GET $directory/$filename HTTP/1.1\r\n");
- @fputs($fsock, "HOST: $host\r\n");
- @fputs($fsock, "Connection: close\r\n\r\n");
- $file_info = '';
- $get_info = false;
- while (!@feof($fsock))
- {
- if ($get_info)
- {
- $file_info .= @fread($fsock, 1024);
- }
- else
- {
- $line = @fgets($fsock, 1024);
- if ($line == "\r\n")
- {
- $get_info = true;
- }
- else if (stripos($line, '404 not found') !== false)
- {
- $errstr = $user->lang['FILE_NOT_FOUND'] . ': ' . $filename;
- return false;
- }
- }
- }
- @fclose($fsock);
- }
- else
- {
- if ($errstr)
- {
- $errstr = utf8_convert_message($errstr);
- return false;
- }
- else
- {
- $errstr = $user->lang['FSOCK_DISABLED'];
- return false;
- }
- }
- return $file_info;
- }
- /**
- * Tidy Warnings
- * Remove all warnings which have now expired from the database
- * The duration of a warning can be defined by the administrator
- * This only removes the warning and reduces the associated count,
- * it does not remove the user note recording the contents of the warning
- */
- function tidy_warnings()
- {
- global $db, $config;
- $expire_date = time() - ($config['warnings_expire_days'] * 86400);
- $warning_list = $user_list = array();
- $sql = 'SELECT * FROM ' . WARNINGS_TABLE . "
- WHERE warning_time < $expire_date";
- $result = $db->sql_query($sql);
- while ($row = $db->sql_fetchrow($result))
- {
- $warning_list[] = $row['warning_id'];
- $user_list[$row['user_id']] = isset($user_list[$row['user_id']]) ? ++$user_list[$row['user_id']] : 1;
- }
- $db->sql_freeresult($result);
- if (sizeof($warning_list))
- {
- $db->sql_transaction('begin');
- $sql = 'DELETE FROM ' . WARNINGS_TABLE . '
- WHERE ' . $db->sql_in_set('warning_id', $warning_list);
- $db->sql_query($sql);
- foreach ($user_list as $user_id => $value)
- {
- $sql = 'UPDATE ' . USERS_TABLE . " SET user_warnings = user_warnings - $value
- WHERE user_id = $user_id";
- $db->sql_query($sql);
- }
- $db->sql_transaction('commit');
- }
- set_config('warnings_last_gc', time(), true);
- }
- /**
- * Tidy database, doing some maintanance tasks
- */
- function tidy_database()
- {
- global $db;
- // Here we check permission consistency
- // Sometimes, it can happen permission tables having forums listed which do not exist
- $sql = 'SELECT forum_id
- FROM ' . FORUMS_TABLE;
- $result = $db->sql_query($sql);
- $forum_ids = array(0);
- while ($row = $db->sql_fetchrow($result))
- {
- $forum_ids[] = $row['forum_id'];
- }
- $db->sql_freeresult($result);
- // Delete those rows from the acl tables not having listed the forums above
- $sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '
- WHERE ' . $db->sql_in_set('forum_id', $forum_ids, true);
- $db->sql_query($sql);
- $sql = 'DELETE FROM ' . ACL_USERS_TABLE . '
- WHERE ' . $db->sql_in_set('forum_id', $forum_ids, true);
- $db->sql_query($sql);
- set_config('database_last_gc', time(), true);
- }
- /**
- * Add permission language - this will make sure custom files will be included
- */
- function add_permission_language()
- {
- global $user, $phpEx;
- // First of all, our own file. We need to include it as the first file because it presets all relevant variables.
- $user->add_lang('acp/permissions_phpbb');
- $files_to_add = array();
- // Now search in acp and mods folder for permissions_ files.
- foreach (array('acp/', 'mods/') as $path)
- {
- $dh = @opendir($user->lang_path . $user->lang_name . '/' . $path);
- if ($dh)
- {
- while (($file = readdir($dh)) !== false)
- {
- if ($file !== 'permissions_phpbb.' . $phpEx && strpos($file, 'permissions_') === 0 && substr($file, -(strlen($phpEx) + 1)) === '.' . $phpEx)
- {
- $files_to_add[] = $path . substr($file, 0, -(strlen($phpEx) + 1));
- }
- }
- closedir($dh);
- }
- }
- if (!sizeof($files_to_add))
- {
- return false;
- }
- $user->add_lang($files_to_add);
- return true;
- }
- /**
- * Obtains the latest version information
- *
- * @param bool $force_update Ignores cached data. Defaults to false.
- * @param bool $warn_fail Trigger a warning if obtaining the latest version information fails. Defaults to false.
- * @param int $ttl Cache version information for $ttl seconds. Defaults to 86400 (24 hours).
- *
- * @return string | false Version info on success, false on failure.
- */
- function obtain_latest_version_info($force_update = false, $warn_fail = false, $ttl = 86400)
- {
- global $cache;
- $info = $cache->get('versioncheck');
- if ($info === false || $force_update)
- {
- $errstr = '';
- $errno = 0;
- // www.phpBB-SEO.com SEO TOOLKIT BEGIN
- global $config;
- $url = 'www.phpbb-seo.com';
- $dir = (strpos($config['default_lang'], 'fr') !== false ? '/fr' : '/en') . '/updatecheck';
- $info = get_remote_file($url, $dir, ((defined('PHPBB_SEO_QA')) ? 'test_30x.txt' : 'premod_30x.txt'), $errstr, $errno);
- //$info = get_remote_file('version.phpbb.com', '/phpbb',
- // ((defined('PHPBB_QA')) ? '30x_qa.txt' : '30x.txt'), $errstr, $errno);
- // www.phpBB-SEO.com SEO TOOLKIT END
- if ($info === false)
- {
- $cache->destroy('versioncheck');
- if ($warn_fail)
- {
- trigger_error($errstr, E_USER_WARNING);
- }
- return false;
- }
- $cache->put('versioncheck', $info, $ttl);
- }
- return $info;
- }
- /**
- * Enables a particular flag in a bitfield column of a given table.
- *
- * @param string $table_name The table to update
- * @param string $column_name The column containing a bitfield to update
- * @param int $flag The binary flag which is OR-ed with the current column value
- * @param string $sql_more This string is attached to the sql query generated to update the table.
- *
- * @return void
- */
- function enable_bitfield_column_flag($table_name, $column_name, $flag, $sql_more = '')
- {
- global $db;
- $sql = 'UPDATE ' . $table_name . '
- SET ' . $column_name . ' = ' . $db->sql_bit_or($column_name, $flag) . '
- ' . $sql_more;
- $db->sql_query($sql);
- }
- ?>