define('CRON_ID', time() . ' ' . unique_id());

$sql = 'UPDATE ' . CONFIG_TABLE . "

phpbb::$db->sql_query($sql);

// another cron process altered the table between script start and UPDATE query so exit

{

exit;

}

$sql = 'SELECT forum_id, prune_next, enable_prune, prune_days, prune_viewed, forum_flags, prune_freq

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

if (!$row)

{

{

$sql = 'UPDATE ' . CONFIG_TABLE . "

SET config_value = '0'

}

?> \ No newline at end of file

static function insert_topic($data)

{

// one transaction, we can now garuntee that atomicity of insertions

$user_id = (int) $data['user_id'];

$forum_id = (int) $data['forum_id'];

$sql = 'SELECT username

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

$sql = 'SELECT forum_topics, forum_unapproved_topics, forum_posts, forum_unapproved_posts

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . (int) $forum_id;

// throw our topic to the dogs

$topic_data = array(

'forum_id' => $forum_id

);

// I suppose it is time to make us a post, no?

$post_data = array(

'forum_id' => $forum_id

);

// time to fill in the blanks

// let's go update the forum table

$forum_data = array(

$forum_data['forum_unapproved_topics'] = ++$row['forum_unapproved_topics'];

}

foreach ($shadow_forums as $shadow_forum_id)

{

}

// we are consistant, victory is ours

}

// inserts a shadow topic into the database

static function insert_shadow_topic($data)

{

// one transaction, we can now garuntee that atomicity of insertions

$user_id = (int) $data['user_id'];

$forum_id = (int) $data['forum_id'];

$sql = 'SELECT username

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

$sql = 'SELECT forum_topics, forum_shadow_topics

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . (int) $forum_id;

// throw our topic to the dogs

$topic_data = array(

'topic_shadow_id' => $shadow_topic_id

);

// let's go update the forum table

$forum_data = array(

$forum_data['forum_unapproved_topics'] = ++$row['forum_unapproved_topics'];

}

// we are consistant, victory is ours

}

static function insert_post($data)

{

// one transaction, we can now garuntee that atomicity of insertions

$user_id = (int) $data['user_id'];

$topic_id = (int) $data['topic_id'];

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

}

$post_title = $data['title'];

$sql = 'SELECT username

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

// hand holding complete, lets write some posts

$sql = 'SELECT forum_topics, forum_unapproved_topics, forum_posts, forum_unapproved_posts

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . (int) $forum_id;

$post_status = (int) $data['post_status'];

$approved = ($post_status === self::NORMAL);

'post_status' => $post_status,

'forum_id' => $forum_id,

);

// what is the new post_id?

// iceberg ahead! we must only update the topic information if the post is approved ;)

if ($approved)

'topic_last_post_title' => $post_title,

'topic_last_post_time' => $time,

);

}

// let's go update the forum table

$forum_data['forum_unapproved_posts'] = ++$row['forum_unapproved_posts'];

}

// we are consistant, victory is ours

}

static function delete_topic($data)

static function delete_topics($data)

{

// lets get this party started

$topic_ids = array_map('intval', $data['topic_ids']);

// TODO: investigate how aggregate functions can speed this up/reduce the number of results returned/misc. other benefits

$sql = 'SELECT topic_posts, topic_shadow_posts, topic_deleted_posts, topic_unapproved_posts, topic_shadow_id, forum_id, topic_status

FROM ' . TOPICS_TABLE . '

// the following in an array, key'd by forum id that refers to topic rows

$forum_lookup = array();

{

$forum_id = (int) $topic_row['forum_id'];

$forum_lookup[$forum_id]['forum_deleted_topics'] += ($topic_status & self::DELETED);

$forum_lookup[$forum_id]['forum_unapproved_topics'] += ($topic_status & self::UNAPPROVED);

}

// goodnight, topics

// goodnight, posts

$forum_ids = array_keys($forum_lookup);

// what kind of topic is this? lets find out how much we must tamper with the forum table...

$sql = 'SELECT forum_posts, forum_shadow_posts, forum_deleted_posts, forum_unapproved_posts, forum_id

FROM ' . FORUMS_TABLE . '

$forum_rows = array();

{

$forum_id = (int) $forum_row['forum_id'];

$forum_rows[$forum_id] = $forum_row;

}

$shadow_topic_ids = array();

foreach ($forum_rows as $forum_id => $forum_row)

FROM ' . POSTS_TABLE . '

WHERE post_status = ' . self::NORMAL . '

AND forum_id = ' . $forum_id;

// anything left?

if ($row)

$sql = 'SELECT post_username, poster_id, post_subject, post_time

FROM '. POSTS_TABLE . '

WHERE post_id = ' . (int) $row['max_post_id'];

$forum_array['forum_last_user_id'] = (int) $last_post['poster_id'];

$forum_array['forum_last_poster_name'] = $last_post['post_username'];

$forum_array['forum_last_post_time'] = 0;

}

}

// let's not get too hasty, we can kill off the shadows later,

// instead we compose a list of all shadows and then efficiently kill them off :)

$sql = 'SELECT topic_id

FROM ' . TOPICS_TABLE . '

{

$shadow_topic_ids[] = $row['topic_id'];

}

// recursion, the other white meat.

if (sizeof($shadow_topic_ids))

}

// goodnight, moon

}

static function delete_post($data)

static function delete_posts($data)

{

// lets get this party started

$post_ids = array_map('intval', $data['post_ids']);

$sql = 'SELECT topic_id, post_status, post_id, post_shadow_id, forum_id

FROM ' . POSTS_TABLE . '

// the following arrays are designed to allow for much faster updates

$topic_lookup = array();

$forum_lookup = array();

{

$topic_id = (int) $post_row['topic_id'];

$forum_id = (int) $post_row['forum_id'];

$forum_lookup[$topic_id]['forum_deleted_posts'] += ($post_status & self::DELETED);

$forum_lookup[$topic_id]['forum_unapproved_posts'] += ($post_status & self::UNAPPROVED);

}

$topic_ids = array_keys($forum_lookup);

// goodnight, posts

// mangle the forums table

$sql = 'SELECT forum_posts, forum_shadow_posts, forum_deleted_posts, forum_unapproved_posts, forum_id

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $forum_id;

$forum_rows = array();

{

$forum_id = (int) $forum_row['forum_id'];

$forum_rows[$forum_id] = $forum_row;

}

$shadow_topic_ids = array();

foreach ($forum_rows as $forum_id => $forum_row)

FROM ' . POSTS_TABLE . '

WHERE post_status = ' . self::NORMAL . '

AND forum_id = ' . $forum_id;

// anything left?

if ($row)

$sql = 'SELECT post_username, poster_id, post_subject, post_time

FROM '. POSTS_TABLE . '

WHERE post_id = ' . (int) $row['max_post_id'];

$forum_array['forum_last_user_id'] = (int) $last_post['poster_id'];

$forum_array['forum_last_poster_name'] = $last_post['post_username'];

$forum_array['forum_last_post_time'] = 0;

}

}

// mangle the topics table now :)

$sql = 'SELECT topic_posts, topic_shadow_posts, topic_deleted_posts, topic_unapproved_posts, topic_id

FROM ' . TOPICS_TABLE . '

WHERE forum_id = ' . $forum_id;

$topic_rows = array();

{

$topic_id = (int) $topic_row['topic_id'];

$topic_rows[$topic_id] = $topic_row;

}

$empty_topic_ids = array();

FROM ' . POSTS_TABLE . '

WHERE post_status = ' . self::NORMAL . '

AND topic_id = ' . $topic_id;

// anything left?

if ($row)

$sql = 'SELECT post_username, poster_id, post_subject, post_time

FROM '. POSTS_TABLE . '

WHERE post_id = ' . (int) $row['max_post_id'];

$topic_array['topic_last_user_id'] = (int) $last_post['poster_id'];

$topic_array['topic_last_poster_name'] = $last_post['post_username'];

$empty_topic_ids[] = $topic_id;

}

}

$shadow_post_ids = array();

// instead we compose a list of all shadows and then efficiently kill them off :)

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

{

$shadow_post_ids[] = $row['post_id'];

}

// recursion, the other white meat.

if (sizeof($shadow_topic_ids))

}

// goodnight, moon

}

static function move_topic($data)

static function move_topics($data)

{

// lets get this party started

// all of each are indexed by topic id

$to_forum_ids = $shadow_topic_ids = array();

// let us first determine how many items we are removing from the pool

$sql = 'SELECT topic_posts, topic_shadow_posts, topic_deleted_posts, topic_unapproved_posts, forum_id, topic_status, topic_type, topic_shadow_id, topic_id

FROM ' . TOPICS_TABLE . '

$forum_lookup = array();

{

$topic_id = $topic_row['topic_id'];

$from_forum_id = (int) $topic_row['forum_id'];

$forum_lookup[$to_forum_id][$column] += $topic_row['topic_posts'];

}

}

// determine the totals

$sql = 'SELECT forum_posts, forum_shadow_posts, forum_deleted_posts, forum_unapproved_posts, forum_id, forum_topics, forum_deleted_topics, forum_unapproved_topics

FROM ' . FORUMS_TABLE . '

{

$forum_id = (int) $row['forum_id'];

foreach ($update_list as $forum_id => $topic_ids)

{

// update the topic itself

// update the posts now

}

// start building the needed arrays for updating the forum data

FROM ' . POSTS_TABLE . '

WHERE post_status = ' . self::NORMAL . '

AND forum_id = ' . $forum_id;

// anything left?

if ($row)

$sql = 'SELECT post_username, poster_id, post_subject, post_time

FROM '. POSTS_TABLE . '

WHERE post_id = ' . (int) $row['max_post_id'];

$forum_data['forum_last_user_id'] = (int) $last_post['poster_id'];

$forum_data['forum_last_poster_name'] = $last_post['post_username'];

}

// update the old forum

}

// hooray for code reuse!

self::insert_shadow_topic($data);

}

}

}

function add_bots($bots)

{

$sql = 'SELECT group_id FROM ' . GROUPS_TABLE . " WHERE group_name = 'BOTS'";

if (!$group_id)

{

add_default_groups();

$sql = 'SELECT group_id FROM ' . GROUPS_TABLE . " WHERE group_name = 'BOTS'";

}

if ($user_id)

{

'bot_active' => 1,

'bot_name' => $bot_name,

'user_id' => $user_id,

'bot_agent' => $bot_ary[0],

'bot_ip' => $bot_ary[1])

);

}

}

}

//

$sql = "SELECT COUNT(*) as total, MAX(post_id) as max_post_id

FROM ". POSTS_TABLE;

{

die("Couldn't get maximum post ID :: " . $sql . " :: " . $error['message']);

}

$totalposts = $max_post_id['total'];

$max_post_id = $max_post_id['max_post_id'];

WHERE post_id

BETWEEN $batchstart

AND $batchend";

{

die("Couldn't get post_text :: " . $sql . " :: " . $error['message']);

}

$post_rows = sizeof($rowset);

{

// $sql = "LOCK TABLES ".POST_TEXT_TABLE." WRITE";

print "\n<p>\n<a href='{$_SERVER['PHP_SELF']}?batchstart=$batchstart'>Restart from posting $batchstart</a><br>\n";

// For every post in the batch:

$search->index('post', $rowset[$post_nr]['post_id'], $rowset[$post_nr]['post_text'], $rowset[$post_nr]['post_subject'], $rowset[$post_nr]['poster_id']);

}

// $sql = "UNLOCK TABLES";

}

}

$sql = 'SELECT attach_id, in_message, post_msg_id, extension, is_orphan, poster_id, filetime

FROM ' . ATTACHMENTS_TABLE . "

WHERE attach_id = $download_id";

phpbb::$db->sql_freeresult($result);

if (!$attachment)

FROM ' . POSTS_TABLE . ' p, ' . FORUMS_TABLE . ' f

WHERE p.post_id = ' . $attachment['post_msg_id'] . '

AND p.forum_id = f.forum_id';

// Global announcement?

$f_download = (!$row) ? phpbb::$acl->acl_getf_global('f_download') : phpbb::$acl->acl_get('f_download', $row['forum_id']);

$sql = 'SELECT user_id, author_id

FROM ' . PRIVMSGS_TO_TABLE . '

WHERE msg_id = ' . $attachment['post_msg_id'];

$allowed = false;

{

if (phpbb::$user->data['user_id'] == $user_row['user_id'] || phpbb::$user->data['user_id'] == $user_row['author_id'])

{

break;

}

}

if (!$allowed)

{

$sql = 'SELECT attach_id, is_orphan, in_message, post_msg_id, extension, physical_filename, real_filename, mimetype, filetime

FROM ' . ATTACHMENTS_TABLE . "

WHERE attach_id = $download_id";

phpbb::$db->sql_freeresult($result);

if (!$attachment)

$sql = 'UPDATE ' . ATTACHMENTS_TABLE . '

SET download_count = download_count + 1

WHERE attach_id = ' . $attachment['attach_id'];

}

if ($display_cat == ATTACHMENT_CATEGORY_IMAGE && $mode === 'view' && (strpos($attachment['mimetype'], 'image') === 0) && ((strpos(strtolower(phpbb::$user->system['browser']), 'msie') !== false) && (strpos(strtolower(phpbb::$user->system['browser']), 'msie 8.0') === false)))

}

// Close the db connection before sending the file

if (!set_modified_headers($attachment['filetime'], phpbb::$user->system['browser']))

{

{

$sql = 'SELECT site_ip, site_hostname, ip_exclude

FROM ' . SITELIST_TABLE;

{

$site_ip = trim($row['site_ip']);

$site_hostname = trim($row['site_hostname']);

}

}

}

}

return $allowed;

$this->sql_rowset[$query_id] = array();

$this->sql_row_pointer[$query_id] = 0;

{

$this->sql_rowset[$query_id][] = $row;

}

apc_store('sql_' . md5($query), $this->sql_rowset[$query_id], $ttl);

$this->sql_rowset[$query_id] = array();

$this->sql_row_pointer[$query_id] = 0;

{

$this->sql_rowset[$query_id][] = $row;

}

eaccelerator_put('sql_' . md5($query), $this->sql_rowset[$query_id], $ttl);

$this->sql_rowset[$query_id] = array();

$this->sql_row_pointer[$query_id] = 0;

{

$this->sql_rowset[$query_id][] = $row;

}

memcache_set($this->memcache, 'sql_' . md5($query), $this->sql_rowset[$query_id], 0, $ttl);

$this->sql_rowset[$query_id] = array();

$this->sql_row_pointer[$query_id] = 0;

{

$this->sql_rowset[$query_id][] = $row;

}

xcache_set('sql_' . md5($query), $this->sql_rowset[$query_id], $ttl);

$sql = 'SELECT user_id, username, user_password, user_passchg, user_email, user_type

FROM ' . USERS_TABLE . "

if ($row)

{

$sql = 'SELECT *

FROM ' . USERS_TABLE . "

if ($row)

{

$sql = 'SELECT *

FROM ' . USERS_TABLE . "

if ($row)

{

// first retrieve default group id

$sql = 'SELECT group_id

FROM ' . GROUPS_TABLE . "

AND group_type = " . GROUP_SPECIAL;

if (!$row)

{

$sql ='SELECT user_id, username, user_password, user_passchg, user_email, user_type

FROM ' . USERS_TABLE . "

if ($row)

{

// retrieve default group id

$sql = 'SELECT group_id

FROM ' . GROUPS_TABLE . "

AND group_type = " . GROUP_SPECIAL;

if (!$row)

{

{

$sql = 'SELECT *

FROM ' . BBCODES_TABLE . '

{

// To circumvent replacing newlines with <br /> for the generated html,

// we use carriage returns here. They are later changed back to newlines

$rowset[$row['bbcode_id']] = $row;

}

}

foreach ($bbcode_ids as $bbcode_id)

LEFT JOIN ' . SESSIONS_TABLE . ' s ON (c.session_id = s.session_id)

WHERE s.session_id IS NULL' .

((empty($type)) ? '' : ' AND c.confirm_type = ' . (int) $type);

{

$sql_in = array();

do

{

$sql_in[] = (string) $row['session_id'];

}

if (sizeof($sql_in))

{

$sql = 'DELETE FROM ' . CONFIRM_TABLE . '

}

}

}

function uninstall()

// compute $seed % 0x7fffffff

$this->seed -= 0x7fffffff * floor($this->seed / 0x7fffffff);

'confirm_id' => (string) $this->confirm_id,

'session_id' => (string) phpbb::$user->session_id,

'confirm_type' => (int) $this->type,

'code' => (string) $this->code,

'seed' => (int) $this->seed)

);

}

/**

{

$sql = 'SELECT code, seed

FROM ' . CONFIRM_TABLE . "

AND confirm_type = " . $this->type;

if ($row)

{

$this->code = $row['code'];

protected function delete_code()

{

$sql = 'DELETE FROM ' . CONFIRM_TABLE . "

AND confirm_type = " . $this->type;

}

function get_attempt_count()

{

$sql = 'SELECT COUNT(session_id) AS attempts

FROM ' . CONFIRM_TABLE . "

AND confirm_type = " . $this->type;

return $attempts;

}

function reset()

{

$sql = 'DELETE FROM ' . CONFIRM_TABLE . "

AND confirm_type = " . (int) $this->type;

// we leave the class usable by generating a new question

$this->generate_code();

if ($type === 'UPDATE')

{

$where = ($where) ? ' WHERE ' . $where : '';

}

else

{

{

$this->changed = false;

}

/**

return;

}

// Reset to minimum possible left and right id

$sql = "SELECT MIN(left_id) as min_left_id, MIN(right_id) as min_right_id

FROM $sql_table

$sql_where";

$substract = (int) (min($row['min_left_id'], $row['min_right_id']) - 1);

$sql = "UPDATE $sql_table

SET left_id = left_id - $substract, right_id = right_id - $substract

$sql_where";

}

$sql = "SELECT $sql_id, parent_id, left_id, right_id

FROM $sql_table

$sql_where

ORDER BY left_id ASC, parent_id ASC, $sql_id ASC";

{

if ($item_data['parent_id'])

{

FROM $sql_table

$sql_where " . (($sql_where) ? 'AND' : 'WHERE') . "

$sql_id = {$item_data['parent_id']}";

{

$sql = "UPDATE $sql_table SET parent_id = 0 WHERE $sql_id = " . $item_data[$sql_id];

}

$sql = "UPDATE $sql_table

SET left_id = left_id + 2, right_id = right_id + 2

$sql_where " . (($sql_where) ? 'AND' : 'WHERE') . "

left_id > {$row['right_id']}";

$sql = "UPDATE $sql_table

SET right_id = right_id + 2

$sql_where " . (($sql_where) ? 'AND' : 'WHERE') . "

{$row['left_id']} BETWEEN left_id AND right_id";

$item_data['left_id'] = $row['right_id'];

$item_data['right_id'] = $row['right_id'] + 1;

$sql = "SELECT MAX(right_id) AS right_id

FROM $sql_table

$sql_where";

$item_data['left_id'] = $row['right_id'] + 1;

$item_data['right_id'] = $row['right_id'] + 2;

$sql = "UPDATE $sql_table

SET left_id = {$item_data['left_id']}, right_id = {$item_data['right_id']}

WHERE $sql_id = " . $item_data[$sql_id];

}

}

*/

$sql = 'SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

$right = 0;

$padding_store = array('0' => '');

// 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"

{

if ($row['left_id'] < $right)

{

$forum_list .= '<option value="' . $row['forum_id'] . '"' . (($disabled) ? ' disabled="disabled" class="disabled-option"' : $selected) . '>' . $padding . $row['forum_name'] . '</option>';

}

}

unset($padding_store);

return $forum_list;

*/

function group_select_options($group_id, $exclude_ids = false, $manage_founder = false)

{

$sql_and = (!phpbb::$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_and

$sql_founder

ORDER BY group_type DESC, group_name ASC";

$s_group_options = '';

{

$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) ? phpbb::$user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

}

return $s_group_options;

}

$sql = 'SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

$forum_rows = array();

$right = $padding = 0;

$padding_store = array('0' => 0);

{

if ($row['left_id'] < $right)

{

$forum_rows[] = $row;

}

unset($padding_store);

}

LEFT JOIN ' . FORUMS_TABLE . " f2 ON ($condition)

WHERE f1.forum_id = $forum_id

ORDER BY f2.left_id " . (($order == 'descending') ? 'ASC' : 'DESC');

{

if (!$include_forum && $row['forum_id'] == $forum_id)

{

$rows[] = $row;

}

return $rows;

}

}

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

AND forum_id = ' . $forum_id;

if ($auto_sync)

{

$sql = 'SELECT DISTINCT forum_id

FROM ' . TOPICS_TABLE . '

{

$forum_ids[] = $row['forum_id'];

}

}

$table_ary = array(TOPICS_TABLE, POSTS_TABLE, LOG_TABLE, DRAFTS_TABLE, TOPICS_TRACK_TABLE);

{

$sql = "UPDATE $table

SET forum_id = $forum_id

}

unset($table_ary);

$sql = 'SELECT DISTINCT topic_id, forum_id

FROM ' . POSTS_TABLE . '

{

$forum_ids[] = $row['forum_id'];

$topic_ids[] = $row['topic_id'];

}

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

if (!$forum_row)

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET forum_id = ' . $forum_row['forum_id'] . ", topic_id = $topic_id

$sql = 'UPDATE ' . ATTACHMENTS_TABLE . "

SET topic_id = $topic_id, in_message = 0

if ($auto_sync)

{

return array('topics' => 0, 'posts' => 0);

}

}

// Making sure that delete_posts does not call delete_topics again...

$sql = 'SELECT topic_id, forum_id, topic_approved, topic_moved_id

FROM ' . TOPICS_TABLE . '

WHERE ' . $where_clause;

{

$forum_ids[] = $row['forum_id'];

$topic_ids[] = $row['topic_id'];

$approved_topics++;

}

}

$return['topics'] = sizeof($topic_ids);

return $return;

}

$table_ary = array(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

}

unset($table_ary);

// update the other forums

$sql = 'SELECT topic_id, forum_id

FROM ' . TOPICS_TABLE . '

{

$forum_ids[] = $row['forum_id'];

$moved_topic_ids[] = $row['topic_id'];

}

if (sizeof($moved_topic_ids))

{

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

}

if ($auto_sync)

{

return false;

}

}

$approved_posts = 0;

$sql = 'SELECT post_id, poster_id, post_approved, post_postcount, topic_id, forum_id

FROM ' . POSTS_TABLE . '

WHERE ' . $where_clause;

{

$post_ids[] = $row['post_id'];

$poster_ids[] = $row['poster_id'];

$approved_posts++;

}

}

if (!sizeof($post_ids))

{

return false;

}

$table_ary = array(POSTS_TABLE, REPORTS_TABLE);

foreach ($table_ary as $table)

{

$sql = "DELETE FROM $table

}

unset($table_ary);

SET user_posts = 0

WHERE user_id = ' . $poster_id . '

AND user_posts < ' . $substract;

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_posts = user_posts - ' . $substract . '

WHERE user_id = ' . $poster_id . '

AND user_posts >= ' . $substract;

}

}

{

$sql = 'SELECT topic_id

FROM ' . POSTS_TABLE . '

GROUP BY topic_id';

{

$remove_topics[] = $row['topic_id'];

}

// Actually, those not within remove_topics should be removed. ;)

$remove_topics = array_diff($topic_ids, $remove_topics);

delete_attachments('post', $post_ids, false);

// Resync topics_posted table

if ($posted_sync)

// 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 . '

{

// We only need to store post/message/topic ids if resync is enabled and the file is not orphaned

if ($resync && !$row['is_orphan'])

$physical[] = array('filename' => $row['physical_filename'], 'thumbnail' => $row['thumbnail'], 'filesize' => $row['filesize'], 'is_orphan' => $row['is_orphan']);

}

// Delete attachments

$sql = 'DELETE FROM ' . ATTACHMENTS_TABLE . '

if (!$num_deleted)

{

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_attachment = 0

}

// Update message table if messages are affected

{

$sql = 'UPDATE ' . PRIVMSGS_TABLE . '

SET message_attachment = 0

}

// Now update the topics. This is a bit trickier, because there could be posts still having attachments within the topic

// 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 . '

AND is_orphan = 0';

$remaining_ids = array();

{

$remaining_ids[] = $row['topic_id'];

}

// Now only unset those ids remaining

$topic_ids = array_diff($topic_ids, $remaining_ids);

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_attachment = 0

}

}

*/

function delete_topic_shadows($max_age, $forum_id = '', $auto_sync = true)

{

{

$sql = 'DELETE FROM ' . TOPICS_TABLE . ' t

USING ' . TOPICS_TABLE . ' t2

WHERE t.topic_moved_id = t2.topic_id

AND t.topic_time < ' . (time() - $max_age)

. $where;

}

else

{

WHERE t.topic_moved_id = t2.topic_id

AND t.topic_time < ' . (time() - $max_age)

. $where;

$topic_ids = array();

{

$topic_ids[] = $row['topic_id'];

}

if (sizeof($topic_ids))

{

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

}

}

// First of all, let us remove any posted information for these topics

$sql = 'DELETE FROM ' . TOPICS_POSTED_TABLE . '

// Now, let us collect the user/topic combos for rebuilding the information

$sql = 'SELECT poster_id, topic_id

FROM ' . POSTS_TABLE . '

AND poster_id <> ' . ANONYMOUS . '

GROUP BY poster_id, topic_id';

$posted = array();

{

// Add as key to make them unique (grouping by) and circumvent empty keys on array_unique

$posted[$row['poster_id']][] = $row['topic_id'];

}

// Now add the information...

$sql_ary = array();

}

unset($posted);

}

/**

// 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 . "

// 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))

// 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_and = $where_sql . "\n\tAND";

}

}

}

// $where_type contains the field for the where clause (forum_id, topic_id)

$where_sql_and = $where_sql . "\n\tAND";

}

switch ($mode)

{

case 'topic_moved':

{

$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";

}

else

{

FROM ' .TOPICS_TABLE . ' t1, ' . TOPICS_TABLE . " t2

WHERE t1.topic_moved_id = t2.topic_id

AND t1.forum_id = t2.forum_id";

$topic_id_ary = array();

{

$topic_id_ary[] = $row['topic_id'];

}

if (!sizeof($topic_id_ary))

{

}

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

}

break;

case 'topic_approved':

{

$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";

}

else

{

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";

$topic_ids = array();

{

$topic_ids[] = $row['topic_id'];

}

if (!sizeof($topic_ids))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_approved = 1 - topic_approved

}

break;

FROM ' . POSTS_TABLE . " p

$where_sql

GROUP BY p.post_id, p.post_reported";

{

$post_ids[$row['post_id']] = $row['post_id'];

if ($row['post_reported'])

$post_reported[$row['post_id']] = 1;

}

}

$sql = 'SELECT DISTINCT(post_id)

FROM ' . REPORTS_TABLE . '

AND report_closed = 0';

$post_ids = array();

{

if (!isset($post_reported[$row['post_id']]))

{

unset($post_reported[$row['post_id']]);

}

}

// $post_reported should be empty by now, if it's not it contains

// posts that are falsely flagged as reported

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_reported = 1 - post_reported

}

break;

$sql = 'SELECT DISTINCT(t.topic_id)

FROM ' . POSTS_TABLE . " t

$where_sql_and t.post_reported = 1";

{

$topic_reported[$row['topic_id']] = 1;

}

$sql = 'SELECT t.topic_id, t.topic_reported

FROM ' . TOPICS_TABLE . " t

$where_sql";

{

if ($row['topic_reported'] ^ isset($topic_reported[$row['topic_id']]))

{

$topic_ids[] = $row['topic_id'];

}

}

if (sizeof($topic_ids))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_reported = 1 - topic_reported

}

break;

FROM ' . POSTS_TABLE . " p

$where_sql

GROUP BY p.post_id, p.post_attachment";

{

$post_ids[$row['post_id']] = $row['post_id'];

if ($row['post_attachment'])

$post_attachment[$row['post_id']] = 1;

}

}

$sql = 'SELECT DISTINCT(post_msg_id)

FROM ' . ATTACHMENTS_TABLE . '

AND in_message = 0';

$post_ids = array();

{

if (!isset($post_attachment[$row['post_msg_id']]))

{

unset($post_attachment[$row['post_msg_id']]);

}

}

// $post_attachment should be empty by now, if it's not it contains

// posts that are falsely flagged as having attachments

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_attachment = 1 - post_attachment

}

break;

$sql = 'SELECT DISTINCT(t.topic_id)

FROM ' . POSTS_TABLE . " t

$where_sql_and t.post_attachment = 1";

{

$topic_attachment[$row['topic_id']] = 1;

}

$sql = 'SELECT t.topic_id, t.topic_attachment

FROM ' . TOPICS_TABLE . " t

$where_sql";

{

if ($row['topic_attachment'] ^ isset($topic_attachment[$row['topic_id']]))

{

$topic_ids[] = $row['topic_id'];

}

}

if (sizeof($topic_ids))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_attachment = 1 - topic_attachment

}

break;

$sql = 'SELECT f.*

FROM ' . FORUMS_TABLE . " f

$where_sql";

$forum_data = $forum_ids = $post_ids = $last_post_id = $post_info = array();

{

if ($row['forum_type'] == FORUM_LINK)

{

$forum_data[$forum_id]['last_poster_name'] = '';

$forum_data[$forum_id]['last_poster_colour'] = '';

}

if (!sizeof($forum_ids))

{

{

$sql = 'SELECT forum_id, topic_approved, COUNT(topic_id) AS forum_topics

FROM ' . TOPICS_TABLE . '

GROUP BY forum_id, topic_approved';

{

$forum_id = (int) $row['forum_id'];

$forum_data[$forum_id]['topics_real'] += $row['forum_topics'];

$forum_data[$forum_id]['topics'] = $row['forum_topics'];

}

}

}

// 3: Get post count for each forum (optional)

{

$sql = 'SELECT SUM(t.topic_replies + 1) AS forum_posts

FROM ' . TOPICS_TABLE . ' t

AND t.topic_approved = 1

AND t.topic_status <> ' . ITEM_MOVED;

}

{

$sql = 'SELECT t.forum_id, SUM(t.topic_replies + 1) AS forum_posts

FROM ' . TOPICS_TABLE . ' t

AND t.topic_approved = 1

AND t.topic_status <> ' . ITEM_MOVED . '

GROUP BY t.forum_id';

}

{

$forum_id = (sizeof($forum_ids) == 1) ? (int) $forum_ids[0] : (int) $row['forum_id'];

$forum_data[$forum_id]['posts'] = (int) $row['forum_posts'];

}

}

// 4: Get last_post_id for each forum

{

$sql = 'SELECT MAX(t.topic_last_post_id) as last_post_id

FROM ' . TOPICS_TABLE . ' t

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

AND t.topic_approved = 1

GROUP BY t.forum_id';

}

{

$forum_id = (sizeof($forum_ids) == 1) ? (int) $forum_ids[0] : (int) $row['forum_id'];

$post_ids[] = $row['last_post_id'];

}

// 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

AND p.poster_id = u.user_id';

{

$post_info[$row['post_id']] = $row;

}

foreach ($forum_data as $forum_id => $data)

{

if (sizeof($sql_ary))

{

$sql = 'UPDATE ' . FORUMS_TABLE . '

WHERE forum_id = ' . $forum_id;

}

}

break;

$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";

{

if ($row['topic_moved_id'])

{

$topic_data[$topic_id]['attachment'] = 0;

}

}

// Use "t" as table alias because of the $where_sql clause

// NOTE: 't.post_approved' in the GROUP BY is causing a major slowdown.

FROM ' . POSTS_TABLE . " t

$where_sql

GROUP BY t.topic_id, t.post_approved";

{

$topic_id = (int) $row['topic_id'];

}

}

}

foreach ($topic_data as $topic_id => $row)

{

$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

AND u.user_id = p.poster_id';

$post_ids = array();

{

$topic_id = intval($row['topic_id']);

$topic_data[$topic_id]['last_poster_colour'] = $row['user_colour'];

}

}

// Make sure shadow topics do link to existing topics

if (sizeof($moved_topics))

$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)

AND t2.topic_id IS NULL';

{

$delete_topics[] = $row['topic_id'];

}

if (sizeof($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 . '

AND topic_last_post_time = 0';

$shadow_topic_data = $post_ids = array();

{

$shadow_topic_data[$row['topic_moved_id']] = $row;

$post_ids[] = $row['topic_last_post_id'];

$post_ids[] = $row['topic_first_post_id'];

}

$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

AND u.user_id = p.poster_id';

$post_ids = array();

{

$topic_id = (int) $row['topic_id'];

}

}

}

$shadow_topic_data = array();

foreach ($sync_shadow_topics as $sync_topic_id => $sql_ary)

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

WHERE topic_id = ' . $sync_topic_id;

}

}

}

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_approved = 1 - topic_approved

}

unset($approved_unapproved_ids);

$where_sql_and p.topic_id = t.topic_id

AND p.post_reported = 1

GROUP BY t.topic_id, p.post_id";

$fieldnames[] = 'reported';

{

$topic_data[intval($row['topic_id'])]['reported'] = 1;

}

// This routine assumes that post_attachment values are correct

// if they are not, use sync('post_attachment') first

$where_sql_and p.topic_id = t.topic_id

AND p.post_attachment = 1

GROUP BY t.topic_id, p.post_id";

$fieldnames[] = 'attachment';

{

$topic_data[intval($row['topic_id'])]['attachment'] = 1;

}

}

foreach ($topic_data as $topic_id => $row)

if (sizeof($sql_ary))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

$resync_forums[$row['forum_id']] = $row['forum_id'];

}

$sql = 'SELECT topic_id

FROM ' . TOPICS_TABLE . '

AND poll_start = 0

$sql_and";

$topic_list = array();

{

$topic_list[] = $row['topic_id'];

}

if ($prune_flags & FORUM_FLAG_PRUNE_POLL)

{

$sql = 'SELECT topic_id

FROM ' . TOPICS_TABLE . '

AND poll_start > 0

AND poll_last_vote < $prune_date

$sql_and";

{

$topic_list[] = $row['topic_id'];

}

$topic_list = array_unique($topic_list);

}

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

if ($row)

{

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET prune_next = $next_prune

WHERE forum_id = $forum_id";

add_log('admin', 'LOG_AUTO_PRUNE', $row['forum_name']);

}

phpbb::$acm->destroy_sql(MODERATOR_CACHE_TABLE);

// Clear table

{

}

else

{

}

// We add moderators who have forum moderator permissions without an explicit ACL_NEVER setting

$ug_id_ary = array_keys($hold_ary);

// Remove users who have group memberships with DENY moderator permissions

'SELECT' => 'a.forum_id, ug.user_id',

'FROM' => array(

AND ((a.auth_setting = ' . phpbb::ACL_NEVER . ' AND r.auth_setting IS NULL)

OR r.auth_setting = ' . phpbb::ACL_NEVER . ')

AND a.group_id = ug.group_id

AND ug.user_pending = 0

));

{

if (isset($hold_ary[$row['user_id']][$row['forum_id']]))

{

unset($hold_ary[$row['user_id']][$row['forum_id']]);

}

}

if (sizeof($hold_ary))

{

// Get usernames...

$sql = 'SELECT user_id, username

FROM ' . USERS_TABLE . '

$usernames_ary = array();

{

$usernames_ary[$row['user_id']] = $row['username'];

}

// Make sure not hidden or special groups are involved...

$sql = 'SELECT group_name, group_id, group_type

FROM ' . GROUPS_TABLE . '

$groupnames_ary = array();

{

if ($row['group_type'] == GROUP_HIDDEN || $row['group_type'] == GROUP_SPECIAL)

{

$groupnames_ary[$row['group_id']] = $row['group_name'];

}

foreach ($hold_ary as $group_id => $forum_id_ary)

{

}

}

}

/**

if (is_array($user_id) && sizeof($user_id))

{

$sql = 'DELETE FROM ' . ZEBRA_TABLE . '

AND foe = 1';

return;

}

if (is_array($group_id) && sizeof($group_id))

{

// Grab group settings...

'SELECT' => 'a.group_id',

'FROM' => array(

),

'WHERE' => '(ao.auth_option_id = a.auth_option_id OR ao.auth_option_id = r.auth_option_id)

AND ao.auth_option IN ('a_', 'm_')",

'GROUP_BY' => 'a.group_id'

));

$groups = array();

{

$groups[] = (int) $row['group_id'];

}

if (!sizeof($groups))

{

return;

}

{

$sql = 'DELETE FROM' . ZEBRA_TABLE . ' z

USING ' . USER_GROUP_TABLE . ' ug

WHERE z.zebra_id = ug.user_id

AND z.foe = 1

}

else

{

$sql = 'SELECT user_id

FROM ' . USER_GROUP_TABLE . '

$users = array();

{

$users[] = (int) $row['user_id'];

}

if (sizeof($users))

{

$sql = 'DELETE FROM ' . ZEBRA_TABLE . '

AND foe = 1';

}

}

if (sizeof($perms))

{

$sql = 'DELETE FROM ' . ZEBRA_TABLE . '

AND foe = 1';

}

unset($perms);

}

WHERE user_warnings > 0

' . (($limit_days) ? "AND user_last_warning >= $limit_days" : '') . "

ORDER BY $sort_by";

$sql = 'SELECT count(user_id) AS user_count

FROM ' . USERS_TABLE . '

WHERE user_warnings > 0

' . (($limit_days) ? "AND user_last_warning >= $limit_days" : '');

return;

}

$sql = 'SELECT * FROM ' . WARNINGS_TABLE . "

WHERE warning_time < $expire_date";

{

$warning_list[] = $row['warning_id'];

$user_list[$row['user_id']] = isset($user_list[$row['user_id']]) ? ++$user_list[$row['user_id']] : 1;

}

if (sizeof($warning_list))

{

$sql = 'DELETE FROM ' . WARNINGS_TABLE . '

foreach ($user_list as $user_id => $value)

{

$sql = 'UPDATE ' . USERS_TABLE . " SET user_warnings = user_warnings - $value

WHERE user_id = $user_id";

}

}

set_config('warnings_last_gc', time(), true);

// Sometimes, it can happen permission tables having forums listed which do not exist

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE;

$forum_ids = array(0);

{

$forum_ids[] = $row['forum_id'];

}

// Delete those rows from the acl tables not having listed the forums above

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . '

set_config('database_last_gc', time(), true);

}

{

$sql_array['LEFT_JOIN'][] = array(

'FROM' => array(FORUMS_ACCESS_TABLE => 'fa'),

);

$sql_array['SELECT'] .= ', fa.user_id';

WHERE left_id < ' . $forum_data['left_id'] . '

AND right_id > ' . $forum_data['right_id'] . '

ORDER BY left_id ASC';

{

$forum_parents[$row['forum_id']] = array($row['forum_name'], (int) $row['forum_type']);

}

$forum_data['forum_parents'] = serialize($forum_parents);

$sql = 'UPDATE ' . FORUMS_TABLE . "

WHERE parent_id = " . $forum_data['parent_id'];

}

else

{

FROM ' . BBCODES_TABLE . '

WHERE display_on_posting = 1

ORDER BY bbcode_tag';

$i = 0;

{

$template->assign_block_vars('custom_tags', array(

'BBCODE_NAME' => "'[{$row['bbcode_tag']}]', '[/" . str_replace('=', '', $row['bbcode_tag']) . "]'",

$i++;

}

}

/**

$sql = 'SELECT *

FROM ' . REPORTS_REASONS_TABLE . '

ORDER BY reason_order ASC';

{

// If the reason is defined within the language file, we will use the localized version, else just use the database entry...

if (isset(phpbb::$user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])]) && isset(phpbb::$user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])]))

'S_SELECTED' => ($row['reason_id'] == $reason_id) ? true : false)

);

}

}

/**

}

$forum_ary = array_unique($forum_ary);

// Obtain active forum

$sql = 'SELECT forum_id, COUNT(post_id) AS num_posts

$forum_sql

GROUP BY forum_id

ORDER BY num_posts DESC";

if (!empty($active_f_row))

{

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $active_f_row['forum_id'];

}

// Obtain active topic

$forum_sql

GROUP BY topic_id

ORDER BY num_posts DESC";

if (!empty($active_t_row))

{

$sql = 'SELECT topic_title

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $active_t_row['topic_id'];

}

$userdata['active_t_row'] = $active_t_row;

FROM $table_sql

WHERE $where_sql = $match_id

AND user_id = $user_id";

}

if (!is_null($notify_status) && $notify_status !== '')

$sql = 'DELETE FROM ' . $table_sql . "

WHERE $where_sql = $match_id

AND user_id = $user_id";

}

$redirect_url = phpbb::$url->append_sid("view$mode", "$u_url=$match_id&amp;start=$start");

SET notify_status = 0

WHERE $where_sql = $match_id

AND user_id = $user_id";

}

}

}

$sql = 'INSERT INTO ' . $table_sql . " (user_id, $where_sql, notify_status)

VALUES ($user_id, $match_id, 0)";

$message = phpbb::$user->lang['ARE_WATCHING_' . strtoupper($mode)] . '<br /><br />' . sprintf(phpbb::$user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');

}

else

$sql = 'SELECT forum_style

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

phpbb::$user->setup('posting', (int) $row['forum_style']);

}

$sql = 'SELECT smiley_id

FROM ' . SMILIES_TABLE . '

WHERE display_on_posting = 0';

{

$display_link = true;

}

}

$last_url = '';

FROM ' . SMILIES_TABLE .

(($mode == 'inline') ? ' WHERE display_on_posting = 1 ' : '') . '

ORDER BY smiley_order';

$smilies = array();

{

if (empty($smilies[$row['smiley_url']]))

{

$smilies[$row['smiley_url']] = $row;

}

}

if (sizeof($smilies))

{

{

$sql = 'SELECT MAX(p.post_id) as last_post_id

FROM ' . POSTS_TABLE . " p $topic_join

$topic_condition

AND p.post_approved = 1";

}

{

$sql = 'SELECT p.' . $type . '_id, MAX(p.post_id) as last_post_id

FROM ' . POSTS_TABLE . " p $topic_join

$topic_condition

AND p.post_approved = 1

GROUP BY p.{$type}_id";

}

$last_post_ids = array();

{

if (sizeof($ids) == 1)

{

$last_post_ids[] = $row['last_post_id'];

}

if ($type == 'forum')

{

$sql = 'SELECT p.' . $type . '_id, p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.user_id, u.username, u.user_colour

FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

WHERE p.poster_id = u.user_id

{

$update_sql[$row["{$type}_id"]][] = $type . '_last_post_id = ' . (int) $row['post_id'];

$update_sql[$row["{$type}_id"]][] = $type . '_last_post_time = ' . (int) $row['post_time'];

$update_sql[$row["{$type}_id"]][] = $type . '_last_poster_id = ' . (int) $row['poster_id'];

}

}

unset($empty_forums, $ids, $last_post_ids);

$sql = "UPDATE $table

SET " . implode(', ', $update_sql_ary) . "

WHERE {$type}_id = $update_id";

}

return;

WHERE d.user_id = ' . phpbb::$user->data['user_id'] . "

$sql_and

ORDER BY d.save_time DESC";

{

if ($row['topic_id'])

{

}

$draft_rows[] = $row;

}

if (!sizeof($draft_rows))

{

{

$sql = 'SELECT topic_id, forum_id, topic_title

FROM ' . TOPICS_TABLE . '

{

$topic_rows[$row['topic_id']] = $row;

}

}

unset($topic_ids);

' . (($mode == 'post_review') ? " AND p.post_id > $cur_post_id" : '') . '

ORDER BY p.post_time ';

$sql .= ($mode == 'post_review') ? 'ASC' : 'DESC';

$post_list = array();

{

$post_list[] = $row['post_id'];

}

if (!sizeof($post_list))

{

return false;

}

'SELECT' => 'u.username, u.user_id, u.user_colour, p.*',

'FROM' => array(

POSTS_TABLE => 'p',

),

AND u.user_id = p.poster_id'

));

$bbcode_bitfield = '';

$rowset = array();

$has_attachments = false;

{

$rowset[$row['post_id']] = $row;

$bbcode_bitfield = $bbcode_bitfield | base64_decode($row['bbcode_bitfield']);

$has_attachments = true;

}

}

// Instantiate BBCode class

if (!isset($bbcode) && $bbcode_bitfield !== '')

// Get attachments...

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

AND in_message = 0

ORDER BY filetime DESC, post_msg_id ASC';

{

$attachments[$row['post_msg_id']][] = $row;

}

}

for ($i = 0, $end = sizeof($post_list); $i < $end; ++$i)

FROM ' . BANLIST_TABLE . '

WHERE ban_userid <> 0

AND ban_exclude <> 1';

$sql_ignore_users = ANONYMOUS . ', ' . phpbb::$user->data['user_id'];

{

$sql_ignore_users .= ', ' . (int) $row['ban_userid'];

}

$notify_rows = array();

AND w.notify_status = 0

AND u.user_type IN (" . phpbb::USER_NORMAL . ', ' . phpbb::USER_FOUNDER . ')

AND u.user_id = w.user_id';

{

$notify_rows[$row['user_id']] = array(

'user_id' => $row['user_id'],

'allowed' => false

);

}

// forum notification is sent to those not already receiving topic notifications

if ($topic_notification)

AND fw.notify_status = 0

AND u.user_type IN (" . phpbb::USER_NORMAL . ', ' . phpbb::USER_FOUNDER . ')

AND u.user_id = fw.user_id';

{

$notify_rows[$row['user_id']] = array(

'user_id' => $row['user_id'],

'allowed' => false

);

}

}

if (!sizeof($notify_rows))

}

// Handle the DB updates

if (!empty($update_notification['topic']))

{

$sql = 'UPDATE ' . TOPICS_WATCH_TABLE . "

SET notify_status = 1

WHERE topic_id = $topic_id

}

if (!empty($update_notification['forum']))

$sql = 'UPDATE ' . FORUMS_WATCH_TABLE . "

SET notify_status = 1

WHERE forum_id = $forum_id

}

// Now delete the user_ids not authorised to receive notifications on this topic/forum

{

$sql = 'DELETE FROM ' . TOPICS_WATCH_TABLE . "

WHERE topic_id = $topic_id

}

if (!empty($delete_ids['forum']))

{

$sql = 'DELETE FROM ' . FORUMS_WATCH_TABLE . "

WHERE forum_id = $forum_id

}

}

//

include_once(PHPBB_ROOT_PATH . 'includes/functions_admin.' . PHP_EXT);

// we must make sure to update forums that contain the shadow'd topic

if ($post_mode == 'delete_topic')

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . '

{

if (!isset($shadow_forum_ids[(int) $row['forum_id']]))

{

$shadow_forum_ids[(int) $row['forum_id']]++;

}

}

}

if (!delete_posts('post_id', array($post_id), false, false))

trigger_error('ALREADY_DELETED');

}

// Collect the necessary information for updating the tables

$sql_data[FORUMS_TABLE] = '';

{

// counting is fun! we only have to do sizeof($forum_ids) number of queries,

// even if the topic is moved back to where its shadow lives (we count how many times it is in a forum)

update_post_information('forum', $updated_forum);

}

WHERE p.topic_id = $topic_id

AND p.poster_id = u.user_id

ORDER BY p.post_time ASC";

if ($data['topic_type'] != POST_GLOBAL)

{

$sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';

}

// Decrementing topic_replies here is fine because this case only happens if there is more than one post within the topic - basically removing one "reply"

$sql_data[TOPICS_TABLE] .= ', topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');

FROM ' . POSTS_TABLE . "

WHERE topic_id = $topic_id " .

((!phpbb::$acl->acl_get('m_approve', $forum_id)) ? 'AND post_approved = 1' : '');

$next_post_id = (int) $row['last_post_id'];

}

((!phpbb::$acl->acl_get('m_approve', $forum_id)) ? 'AND post_approved = 1' : '') . '

AND post_time > ' . $data['post_time'] . '

ORDER BY post_time ASC';

if ($data['topic_type'] != POST_GLOBAL)

{

// $sql_data[USERS_TABLE] = ($data['post_postcount']) ? 'user_posts = user_posts - 1' : '';

$where_sql = array(

FORUMS_TABLE => "forum_id = $forum_id",

{

if ($update_sql)

{

}

}

FROM ' . POSTS_TABLE . '

WHERE topic_id = ' . $topic_id . '

AND poster_id = ' . $data['poster_id'];

// The user is not having any more posts within this topic

if (!$poster_id)

$sql = 'DELETE FROM ' . TOPICS_POSTED_TABLE . '

WHERE topic_id = ' . $topic_id . '

AND user_id = ' . $data['poster_id'];

}

}

if ($data['post_reported'] && ($post_mode != 'delete_topic'))

{

FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . ' p

WHERE t.topic_id = p.topic_id

AND p.post_id = ' . $data['post_id'];

$data['topic_approved'] = $topic_row['topic_approved'];

$data['post_approved'] = $topic_row['post_approved'];

}

// Start the transaction here

// Collect Information

switch ($post_mode)

$sql = 'SELECT topic_type, topic_replies, topic_replies_real, topic_approved

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $data['topic_id'];

}

// If this is the only post remaining we do not need to decrement topic_replies.

if ($post_mode == 'post')

{

$sql = 'INSERT INTO ' . TOPICS_TABLE . ' ' .

$sql_data[POSTS_TABLE]['sql'] = array_merge($sql_data[POSTS_TABLE]['sql'], array(

'topic_id' => $data['topic_id'])

);

}

if ($post_mode == 'post')

{

$sql = 'SELECT topic_type, topic_replies, topic_replies_real, topic_approved, topic_last_post_id

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $data['topic_id'];

}

// globalise/unglobalise?

{

if (!empty($sql_data[FORUMS_TABLE]['stat']) && implode('', $sql_data[FORUMS_TABLE]['stat']))

{

}

$make_global = true;

$sql = 'UPDATE ' . POSTS_TABLE . '

SET forum_id = 0

WHERE topic_id = ' . $data['topic_id'];

}

// unglobalise

else if ($topic_row['topic_type'] == POST_GLOBAL && $topic_type != POST_GLOBAL)

$sql = 'UPDATE ' . POSTS_TABLE . '

SET forum_id = ' . $data['forum_id'] . '

WHERE topic_id = ' . $data['topic_id'];

}

}

if (isset($sql_data[TOPICS_TABLE]['sql']))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

WHERE topic_id = ' . $data['topic_id'];

}

// Update the posts table

if (isset($sql_data[POSTS_TABLE]['sql']))

{

$sql = 'UPDATE ' . POSTS_TABLE . '

WHERE post_id = ' . $data['post_id'];

}

// Update Poll Tables

FROM ' . POLL_OPTIONS_TABLE . '

WHERE topic_id = ' . $data['topic_id'] . '

ORDER BY poll_option_id';

$cur_poll_options = array();

{

$cur_poll_options[] = $row;

}

}

$sql_insert_ary = array();

else if ($poll['poll_options'][$i] != $cur_poll_options[$i])

{

$sql = 'UPDATE ' . POLL_OPTIONS_TABLE . "

WHERE poll_option_id = " . $cur_poll_options[$i]['poll_option_id'] . '

AND topic_id = ' . $data['topic_id'];

}

}

}

if (sizeof($poll['poll_options']) < sizeof($cur_poll_options))

{

$sql = 'DELETE FROM ' . POLL_OPTIONS_TABLE . '

WHERE poll_option_id > ' . sizeof($poll['poll_options']) . '

AND topic_id = ' . $data['topic_id'];

}

// If edited, we would need to reset votes (since options can be re-ordered above, you can't be sure if the change is for changing the text or adding an option

if ($mode == 'edit' && sizeof($poll['poll_options']) != sizeof($cur_poll_options))

{

}

}

{

$sql = 'SELECT attach_id, filesize, physical_filename

FROM ' . ATTACHMENTS_TABLE . '

AND is_orphan = 1

AND poster_id = ' . phpbb::$user->data['user_id'];

$orphan_rows = array();

{

$orphan_rows[$row['attach_id']] = $row;

}

}

foreach ($data['attachment_data'] as $pos => $attach_row)

{

// update entry in db if attachment already stored in db and filespace

$sql = 'UPDATE ' . ATTACHMENTS_TABLE . "

WHERE attach_id = " . (int) $attach_row['attach_id'] . '

AND is_orphan = 0';

}

else

{

'attach_comment' => $attach_row['attach_comment'],

);

WHERE attach_id = ' . $attach_row['attach_id'] . '

AND is_orphan = 1

AND poster_id = ' . phpbb::$user->data['user_id'];

}

}

if (($post_mode == 'post' || $post_mode == 'reply') && $post_approved)

{

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . $data['post_id'];

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . $current_time;

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) phpbb::$user->data['user_id'];

}

else if ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || ($post_mode == 'edit_first_post' && !$data['topic_replies']))

{

$sql = 'SELECT forum_last_post_id, forum_last_post_subject

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . (int) $data['forum_id'];

// this post is the latest post in the forum, better update

if ($row['forum_last_post_id'] == $data['post_id'])

// the post's subject changed

if ($row['forum_last_post_subject'] !== $subject)

{

}

// Update the user name if poster is anonymous... just in case an admin changed it

if ($data['poster_id'] == ANONYMOUS)

{

}

}

else if ($data['post_approved'] !== $post_approved)

FROM ' . TOPICS_TABLE . '

WHERE forum_id = ' . (int) $data['forum_id'] . '

AND topic_approved = 1';

// any posts left in this forum?

if (!empty($row['last_post_id']))

FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

WHERE p.poster_id = u.user_id

AND p.post_id = ' . (int) $row['last_post_id'];

// salvation, a post is found! jam it into the forums table

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . (int) $row['post_id'];

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . (int) $row['post_time'];

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) $row['poster_id'];

}

else

{

$sql = 'SELECT forum_last_post_id

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . (int) $data['forum_id'];

// we made a topic global, go get new data

if ($topic_row['topic_type'] != POST_GLOBAL && $topic_type == POST_GLOBAL && $forum_row['forum_last_post_id'] == $topic_row['topic_last_post_id'])

FROM ' . TOPICS_TABLE . '

WHERE forum_id = ' . (int) $data['forum_id'] . '

AND topic_approved = 1';

// any posts left in this forum?

if (!empty($row['last_post_id']))

FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

WHERE p.poster_id = u.user_id

AND p.post_id = ' . (int) $row['last_post_id'];

// salvation, a post is found! jam it into the forums table

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . (int) $row['post_id'];

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . (int) $row['post_time'];

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) $row['poster_id'];

}

else

{

FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

WHERE p.poster_id = u.user_id

AND p.post_id = ' . (int) $topic_row['topic_last_post_id'];

// salvation, a post is found! jam it into the forums table

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . (int) $row['post_id'];

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . (int) $row['post_time'];

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) $row['poster_id'];

}

}

{

$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_post_id = ' . (int) $data['post_id'];

$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_poster_id = ' . (int) phpbb::$user->data['user_id'];

$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_post_time = ' . (int) $current_time;

}

else if ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || ($post_mode == 'edit_first_post' && !$data['topic_replies']))

{

// only the subject can be changed from edit

// Maybe not only the subject, but also changing anonymous usernames. ;)

if ($data['poster_id'] == ANONYMOUS)

{

}

}

}

FROM ' . POSTS_TABLE . '

WHERE topic_id = ' . (int) $data['topic_id'] . '

AND post_approved = 1';

// any posts left in this forum?

if (!empty($row['last_post_id']))

FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

WHERE p.poster_id = u.user_id

AND p.post_id = ' . (int) $row['last_post_id'];

// salvation, a post is found! jam it into the topics table

$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_post_id = ' . (int) $row['post_id'];

$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_post_time = ' . (int) $row['post_time'];

$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_poster_id = ' . (int) $row['poster_id'];

}

}

if (isset($update_ary['stat']) && implode('', $update_ary['stat']))

{

$sql = "UPDATE $table SET " . implode(', ', $update_ary['stat']) . ' WHERE ' . $where_sql[$table];

}

}

{

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

WHERE topic_moved_id = ' . $data['topic_id'];

}

// Committing the transaction before updating search index

// Delete draft if post was loaded...

$draft_id = request_var('draft_loaded', 0);

$sql = 'DELETE FROM ' . DRAFTS_TABLE . "

WHERE draft_id = $draft_id

AND user_id = " . phpbb::$user->data['user_id'];

}

// Index message contents

{

$sql = 'INSERT INTO ' . TOPICS_WATCH_TABLE . ' (user_id, topic_id)

VALUES (' . phpbb::$user->data['user_id'] . ', ' . $data['topic_id'] . ')';

}

else if ($data['notify_set'] && !$data['notify'])

{

$sql = 'DELETE FROM ' . TOPICS_WATCH_TABLE . '

WHERE user_id = ' . phpbb::$user->data['user_id'] . '

AND topic_id = ' . $data['topic_id'];

}

}

FROM ' . FORUMS_TRACK_TABLE . '

WHERE user_id = ' . phpbb::$user->data['user_id'] . '

AND forum_id = ' . $data['forum_id'];

}

else if (phpbb::$config['load_anon_lastread'] || phpbb::$user->is_registered)

{

$sql = 'SELECT forum_last_post_time

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $data['forum_id'];

update_forum_tracking_info($data['forum_id'], $forum_last_post_time, $f_mark_time, false);

}

WHERE user_id = $user_id

AND folder_id <> " . PRIVMSGS_NO_BOX . '

GROUP BY folder_id';

$num_messages = $num_unread = array();

{

$num_messages[(int) $row['folder_id']] = $row['num_messages'];

$num_unread[(int) $row['folder_id']] = $row['num_unread'];

}

// Make sure the default boxes are defined

$available_folder = array(PRIVMSGS_INBOX, PRIVMSGS_OUTBOX, PRIVMSGS_SENTBOX);

$sql = 'SELECT folder_id, folder_name, pm_count

FROM ' . PRIVMSGS_FOLDER_TABLE . "

WHERE user_id = $user_id";

{

$folder[$row['folder_id']] = array(

'folder_name' => $row['folder_name'],

'unread_messages' => ((isset($num_unread[$row['folder_id']])) ? $num_unread[$row['folder_id']] : 0)

);

}

$folder[PRIVMSGS_OUTBOX] = array(

'folder_name' => phpbb::$user->lang['PM_OUTBOX'],

AND t.user_id = ' . phpbb::$user->data['user_id'] . '

AND t.folder_id = ' . PRIVMSGS_SENTBOX . '

ORDER BY p.message_time ASC';

$delete_ids = array();

{

$delete_ids[] = $row['msg_id'];

}

delete_pm(phpbb::$user->data['user_id'], $delete_ids, PRIVMSGS_SENTBOX);

}

}

$sql = 'SELECT user_id, user_type, user_permissions

FROM ' . USERS_TABLE . '

WHERE user_id = ' . (int) $message_row['author_id'];

$auth2 = new auth();

$auth2->acl($userdata);

WHERE pm_unread = 1

AND folder_id <> ' . PRIVMSGS_OUTBOX . '

AND user_id = ' . phpbb::$user->data['user_id'];

// Update new pm count

$sql = 'SELECT COUNT(msg_id) as num_messages

WHERE pm_new = 1

AND folder_id IN (' . PRIVMSGS_NO_BOX . ', ' . PRIVMSGS_HOLD_BOX . ')

AND user_id = ' . phpbb::$user->data['user_id'];

'user_unread_privmsg' => (int) phpbb::$user->data['user_unread_privmsg'],

'user_new_privmsg' => (int) phpbb::$user->data['user_new_privmsg'],

)) . ' WHERE user_id = ' . phpbb::$user->data['user_id']);

WHERE pm_new = 1

AND folder_id NOT IN (' . PRIVMSGS_NO_BOX . ', ' . PRIVMSGS_HOLD_BOX . ')

AND user_id = ' . phpbb::$user->data['user_id'];

}

}

SET folder_id = ' . PRIVMSGS_NO_BOX . '

WHERE folder_id = ' . PRIVMSGS_HOLD_BOX . "

AND user_id = $user_id";

}

// Get those messages not yet placed into any box

// Just place into the appropriate arrays if no rules need to be checked

if (!$user_message_rules)

{

{

$action_ary[$row['msg_id']][] = array('action' => false);

}

}

else

{

$sql = 'SELECT *

FROM ' . PRIVMSGS_RULES_TABLE . "

WHERE user_id = $user_id";

if (sizeof($user_rules))

{

$sql = 'SELECT zebra_id, friend, foe

FROM ' . ZEBRA_TABLE . "

WHERE user_id = $user_id";

{

$zebra[$row['zebra_id']] = $row;

}

}

// Now build a bare-bone check_row array

{

$check_rows[] = array_merge($row, array(

'to' => explode(':', $row['to_address']),

$user_ids[] = $row['user_id'];

}

// Retrieve user memberships

if (sizeof($user_ids))

{

$sql = 'SELECT *

FROM ' . USER_GROUP_TABLE . '

AND user_pending = 0';

{

$memberships[$row['user_id']][] = $row['group_id'];

}

}

// Now place into the appropriate folder

{

$sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

SET pm_unread = 0

AND user_id = $user_id

AND folder_id = " . PRIVMSGS_NO_BOX;

}

// mark messages as important

SET pm_marked = 1 - pm_marked

WHERE folder_id = ' . PRIVMSGS_NO_BOX . "

AND user_id = $user_id

}

// Move into folder

$sql = 'SELECT folder_id, pm_count

FROM ' . PRIVMSGS_FOLDER_TABLE . '

AND user_id = $user_id";

{

$folder[(int) $row['folder_id']] = (int) $row['pm_count'];

}

unset($sql_folder);

FROM ' . PRIVMSGS_TO_TABLE . "

WHERE user_id = $user_id

AND folder_id = " . PRIVMSGS_INBOX;

}

}

WHERE user_id = $user_id

AND folder_id = $dest_folder

ORDER BY msg_id ASC";

$delete_ids = array();

{

$delete_ids[] = $row['msg_id'];

}

$num_removed += sizeof($delete_ids);

delete_pm($user_id, $delete_ids, $dest_folder);

SET folder_id = ' . PRIVMSGS_HOLD_BOX . '

WHERE folder_id = ' . PRIVMSGS_NO_BOX . "

AND user_id = $user_id

}

else

{

WHERE folder_id = " . PRIVMSGS_NO_BOX . "

AND user_id = $user_id

AND pm_new = 1

if ($dest_folder != PRIVMSGS_INBOX)

{

$sql = 'UPDATE ' . PRIVMSGS_FOLDER_TABLE . '

WHERE folder_id = $dest_folder

AND user_id = $user_id";

}

}

}

$sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

SET folder_id = ' . PRIVMSGS_SENTBOX . '

WHERE folder_id = ' . PRIVMSGS_OUTBOX . '

}

// Update new/unread count

FROM ' . PRIVMSGS_TO_TABLE . "

WHERE user_id = $user_id

AND folder_id = " . PRIVMSGS_HOLD_BOX;

return array('not_moved' => $num_not_moved, 'removed' => $num_removed);

}

FROM ' . PRIVMSGS_FOLDER_TABLE . "

WHERE folder_id = $dest_folder

AND user_id = $user_id";

if (!$row)

{

FROM ' . PRIVMSGS_TO_TABLE . '

WHERE folder_id = ' . PRIVMSGS_INBOX . "

AND user_id = $user_id";

if ($message_limit && $num_messages + sizeof($move_msg_ids) > $message_limit)

{

SET folder_id = $dest_folder

WHERE folder_id = $cur_folder_id

AND user_id = $user_id

// Update pm counts

if ($num_moved)

SET pm_count = pm_count - $num_moved

WHERE folder_id = $cur_folder_id

AND user_id = $user_id";

}

if ($dest_folder != PRIVMSGS_INBOX)

SET pm_count = pm_count + $num_moved

WHERE folder_id = $dest_folder

AND user_id = $user_id";

}

}

}

WHERE msg_id = $msg_id

AND user_id = $user_id

AND folder_id = $folder_id";

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_unread_privmsg = user_unread_privmsg - 1

WHERE user_id = $user_id";

if (phpbb::$user->data['user_id'] == $user_id)

{

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_unread_privmsg = 0

WHERE user_id = $user_id";

phpbb::$user->data['user_unread_privmsg'] = 0;

}

SET pm_marked = 1 - pm_marked

WHERE folder_id = $cur_folder_id

AND user_id = $user_id

break;

// Get PM Information for later deleting

$sql = 'SELECT msg_id, pm_unread, pm_new

FROM ' . PRIVMSGS_TO_TABLE . '

AND folder_id = $folder_id

AND user_id = $user_id";

$delete_rows = array();

$num_unread = $num_new = $num_deleted = 0;

{

$num_unread += (int) $row['pm_unread'];

$num_new += (int) $row['pm_new'];

$delete_rows[$row['msg_id']] = 1;

}

unset($msg_ids);

if (!sizeof($delete_rows))

return false;

}

// if no one has read the message yet (meaning it is in users outbox)

// then mark the message as deleted...

// Remove PM from Outbox

$sql = 'DELETE FROM ' . PRIVMSGS_TO_TABLE . "

WHERE user_id = $user_id AND folder_id = " . PRIVMSGS_OUTBOX . '

// Update PM Information for safety

$sql = 'UPDATE ' . PRIVMSGS_TABLE . " SET message_text = ''

// Set delete flag for those intended to receive the PM

// We do not remove the message actually, to retain some basic information (sent time for example)

$sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

SET pm_deleted = 1

}

else

{

$sql = 'DELETE FROM ' . PRIVMSGS_TO_TABLE . "

WHERE user_id = $user_id

AND folder_id = $folder_id

}

// if folder id is user defined folder then decrease pm_count

$sql = 'UPDATE ' . PRIVMSGS_FOLDER_TABLE . "

SET pm_count = pm_count - $num_deleted

WHERE folder_id = $folder_id";

}

// Update unread and new status field

$set_sql .= 'user_new_privmsg = user_new_privmsg - ' . $num_new;

}

phpbb::$user->data['user_new_privmsg'] -= $num_new;

phpbb::$user->data['user_unread_privmsg'] -= $num_unread;

// Now we have to check which messages we can delete completely

$sql = 'SELECT msg_id

FROM ' . PRIVMSGS_TO_TABLE . '

{

unset($delete_rows[$row['msg_id']]);

}

$delete_ids = array_keys($delete_rows);

delete_attachments('message', $delete_ids, false);

$sql = 'DELETE FROM ' . PRIVMSGS_TABLE . '

}

return true;

}

{

$sql = 'SELECT user_id, username, user_colour

FROM ' . USERS_TABLE . '

AND user_type IN (' . phpbb::USER_NORMAL . ', ' . phpbb::USER_FOUNDER . ')';

{

if ($check_type == 'to' || $author_id == phpbb::$user->data['user_id'] || $row['user_id'] == phpbb::$user->data['user_id'])

{

}

}

}

}

if (sizeof($g))

{

$sql = 'SELECT group_name, group_type

FROM ' . GROUPS_TABLE . '

{

if ($check_type == 'to' || $author_id == phpbb::$user->data['user_id'] || $row['user_id'] == phpbb::$user->data['user_id'])

{

$address[] = ($row['group_type'] == GROUP_SPECIAL) ? phpbb::$user->lang['G_' . $row['group_name']] : $row['group_name'];

}

}

}

else

{

$sql = 'SELECT g.group_id, g.group_name, g.group_colour, g.group_type, ug.user_id

FROM ' . GROUPS_TABLE . ' g, ' . USER_GROUP_TABLE . ' ug

AND g.group_id = ug.group_id

AND ug.user_pending = 0';

{

if (!isset($address['group'][$row['group_id']]))

{

$address['user'][$row['user_id']]['in_group'] = $row['group_id'];

}

}

}

}

$sql = 'SELECT u.user_type, ug.group_id, ug.user_id

FROM ' . USERS_TABLE . ' u, ' . USER_GROUP_TABLE . ' ug

AND ug.user_pending = 0

AND u.user_id = ug.user_id

AND u.user_type IN (' . phpbb::USER_NORMAL . ', ' . phpbb::USER_FOUNDER . ')' .

$sql_allow_pm;

{

$field = ($data['address_list']['g'][$row['group_id']] == 'to') ? 'to' : 'bcc';

$recipients[$row['user_id']] = $field;

}

}

if (!sizeof($recipients))

}

}

$sql = '';

if ($mode == 'post' || $mode == 'reply' || $mode == 'quote' || $mode == 'quotepost' || $mode == 'forward')

{

}

else if ($mode == 'edit')

{

$sql = 'UPDATE ' . PRIVMSGS_TABLE . '

WHERE msg_id = ' . $data['msg_id'];

}

}

{

if ($sql)

{

}

unset($sql);

);

}

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_new_privmsg = user_new_privmsg + 1, user_unread_privmsg = user_unread_privmsg + 1, user_last_privmsg = ' . time() . '

// Put PM into outbox

if ($put_in_outbox)

{

'msg_id' => (int) $data['msg_id'],

'user_id' => (int) $data['from_user_id'],

'author_id' => (int) $data['from_user_id'],

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_lastpost_time = $current_time

WHERE user_id = " . $data['from_user_id'];

}

// Submit Attachments

{

$sql = 'SELECT attach_id, filesize, physical_filename

FROM ' . ATTACHMENTS_TABLE . '

AND in_message = 1

AND is_orphan = 1

AND poster_id = ' . phpbb::$user->data['user_id'];

$orphan_rows = array();

{

$orphan_rows[$row['attach_id']] = $row;

}

}

foreach ($data['attachment_data'] as $pos => $attach_row)

{

// update entry in db if attachment already stored in db and filespace

$sql = 'UPDATE ' . ATTACHMENTS_TABLE . "

WHERE attach_id = " . (int) $attach_row['attach_id'] . '

AND is_orphan = 0';

}

else

{

'attach_comment' => $attach_row['attach_comment'],

);

WHERE attach_id = ' . $attach_row['attach_id'] . '

AND is_orphan = 1

AND poster_id = ' . phpbb::$user->data['user_id'];

}

}

$sql = 'DELETE FROM ' . DRAFTS_TABLE . "

WHERE draft_id = $draft_id

AND user_id = " . $data['from_user_id'];

}

// Send Notifications

if ($mode != 'edit')

// Get banned User ID's

$sql = 'SELECT ban_userid

FROM ' . BANLIST_TABLE . '

AND ban_exclude = 0';

{

unset($recipients[$row['ban_userid']]);

}

if (!sizeof($recipients))

{

$sql = 'SELECT user_id, username, user_email, user_lang, user_notify_pm, user_notify_type, user_jabber

FROM ' . USERS_TABLE . '

$msg_list_ary = array();

{

if ($row['user_notify_pm'] == 1 && trim($row['user_email']))

{

);

}

}

if (!sizeof($msg_list_ary))

{

}

$sql .= ' ORDER BY p.message_time DESC';

if (!$row)

{

return false;

}

$bbcode_bitfield = $bbcode_bitfield | base64_decode($row['bbcode_bitfield']);

}

}

$title = $row['message_subject'];

WHERE ug.user_id = ' . phpbb::$user->data['user_id'] . '

AND ug.user_pending = 0

AND ug.group_id = g.group_id';

phpbb::$user->data['message_limit'] = (!$message_limit) ? phpbb::$config['pm_max_msgs'] : $message_limit;

}

AND l.lang_id = $lang_id

AND l.field_id = f.field_id

ORDER BY f.field_order";

{

// Return templated field

$tpl_snippet = $this->process_field_row('change', $row);

'S_REQUIRED' => ($row['field_required']) ? true : false)

);

}

}

/**

AND f.field_no_view = 0

AND l.field_id = f.field_id

ORDER BY f.field_order';

{

$this->profile_cache[$row['field_ident']] = $row;

}

}

/**

AND lang_id = $lang_id

AND field_type = $field_type

ORDER BY option_id";

// @todo: ref optimize

{

$this->options_lang[$field_id][$lang_id][($row['option_id'] + 1)] = $row['lang_value'];

}

}

}

$sql_where

AND l.field_id = f.field_id

ORDER BY f.field_order";

{

$cp_data['pf_' . $row['field_ident']] = $this->get_profile_field($row);

$check_value = $cp_data['pf_' . $row['field_ident']];

}

}

}

}

/**

$sql = 'SELECT *

FROM ' . PROFILE_FIELDS_DATA_TABLE . '

$field_data = array();

{

$field_data[$row['user_id']] = $row;

}

$user_fields = array();

$sql = 'SELECT f.field_type, f.field_ident, f.field_default_value, l.lang_default_value

FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . ' f

WHERE l.lang_id = ' . phpbb::$user->get_iso_lang_id() . '

AND l.field_id = f.field_id';

{

if ($row['field_default_value'] == 'now' && $row['field_type'] == FIELD_DATE)

{

$cp_data['pf_' . $row['field_ident']] = (in_array($row['field_type'], array(FIELD_TEXT, FIELD_STRING))) ? $row['lang_default_value'] : $row['field_default_value'];

}

return $cp_data;

}

$sql = 'SELECT *

FROM ' . BBCODES_TABLE;

{

$rowset[] = $row;

}

}

foreach ($rowset as $row)

// For now setting the ttl to 10 minutes

$sql = 'SELECT *

FROM ' . SMILIES_TABLE . '

{

if (empty($row['code']))

{

$match[] = '(?<=^|[\n .])' . preg_quote($row['code'], '#') . '(?![^<>]*>)';

$replace[] = '<!-- s' . $row['code'] . ' --><img src="{SMILIES_PATH}/' . $row['smiley_url'] . '" alt="' . $row['code'] . '" title="' . $row['emotion'] . '" /><!-- s' . $row['code'] . ' -->';

}

}

if (sizeof($match))

'poster_id' => phpbb::$user->data['user_id'],

);

$new_entry = array(

'is_orphan' => 1,

'real_filename' => $filedata['real_filename'],

'attach_comment'=> $this->filename_data['filecomment'],

WHERE attach_id = ' . (int) $this->attachment_data[$index]['attach_id'] . '

AND is_orphan = 1

AND poster_id = ' . phpbb::$user->data['user_id'];

if ($row)

{

phpbb_unlink($row['physical_filename'], 'thumbnail');

}

}

}

else

'poster_id' => phpbb::$user->data['user_id'],

);

$new_entry = array(

'is_orphan' => 1,

'real_filename' => $filedata['real_filename'],

'attach_comment'=> $this->filename_data['filecomment'],

// Get the attachment data, based on the poster id...

$sql = 'SELECT attach_id, is_orphan, real_filename, attach_comment

FROM ' . ATTACHMENTS_TABLE . '

AND poster_id = ' . $check_user_id;

{

$pos = $not_orphan[(int) $row['attach_id']];

$this->attachment_data[$pos] = $row;

unset($not_orphan[(int) $row['attach_id']]);

}

}

if (sizeof($not_orphan))

{

$sql = 'SELECT attach_id, is_orphan, real_filename, attach_comment

FROM ' . ATTACHMENTS_TABLE . '

AND poster_id = ' . phpbb::$user->data['user_id'] . '

AND is_orphan = 1';

{

$pos = $orphan[(int) $row['attach_id']];

$this->attachment_data[$pos] = $row;

unset($orphan[(int) $row['attach_id']]);

}

}

if (sizeof($orphan))

*/

public function init()

{

$engine = '';

if (isset($info['Engine']))

$sql = 'SHOW VARIABLES

LIKE \'ft\_%\'';

$mysql_info = array();

{

$mysql_info[$row['Variable_name']] = $row['Value'];

}

set_config('fulltext_mysql_max_word_len', $mysql_info['ft_max_word_len']);

set_config('fulltext_mysql_min_word_len', $mysql_info['ft_min_word_len']);

}

else

{

}

$sql_select = (!$result_count) ? 'SQL_CALC_FOUND_ROWS ' : '';

$sql_where_options = $sql_sort_join;

$sql_where_options .= ($topic_id) ? ' AND p.topic_id = ' . $topic_id : '';

$sql_where_options .= ($join_topic) ? ' AND t.topic_id = p.topic_id' : '';

$sql_where_options .= $m_approve_fid_sql;

$sql_where_options .= (sizeof($author_ary)) ? ' AND p.poster_id ' . $sql_author : '';

$sql_where_options .= ($sort_days) ? ' AND p.post_time >= ' . (time() - ($sort_days * 86400)) : '';

$sql = "SELECT $sql_select

FROM $sql_from$sql_sort_table" . POSTS_TABLE . " p

$sql_where_options

ORDER BY $sql_sort";

{

$id_ary[] = $row[$field];

}

$id_ary = array_unique($id_ary);

if (!$result_count)

{

$sql = 'SELECT FOUND_ROWS() as result_count';

if (!$result_count)

{

$id_ary = array();

// Create some display specific sql strings

$sql_topic_id = ($topic_id) ? ' AND p.topic_id = ' . (int) $topic_id : '';

$sql_time = ($sort_days) ? ' AND p.post_time >= ' . (time() - ($sort_days * 86400)) : '';

$sql_firstpost = ($firstpost_only) ? ' AND p.post_id = t.topic_first_post_id' : '';

}

else

{

}

// If the cache was completely empty count the results

}

// Only read one block of posts from the db and then cache it

{

$id_ary[] = $row[$field];

}

// retrieve the total result count if needed

if (!$result_count)

{

$sql = 'SELECT FOUND_ROWS() as result_count';

if (!$result_count)

{

if (sizeof($alter))

{

}

return false;

}

if (sizeof($alter))

{

}

return false;

}

private function get_stats()

{

{

$this->stats = array();

return;

$sql = 'SHOW INDEX

FROM ' . POSTS_TABLE;

{

// deal with older MySQL versions which didn't use Index_type

$index_type = (isset($row['Index_type'])) ? $row['Index_type'] : $row['Comment'];

}

}

}

$sql = 'SELECT COUNT(post_id) as total_posts

FROM ' . POSTS_TABLE;

}

/**

/* Optimize/vacuum analyze the tables where appropriate

// this should be done for each version in future along with

// the version number update

{

case 'mysql':

$sql = 'OPTIMIZE TABLE ' . $table_prefix . 'auth_access, ' . $table_prefix . 'banlist, ' . $table_prefix . 'categories, ' . $table_prefix . 'config, ' . $table_prefix . 'disallow, ' . $table_prefix . 'forum_prune, ' . $table_prefix . 'forums, ' . $table_prefix . 'groups, ' . $table_prefix . 'posts, ' . $table_prefix . 'posts_text, ' . $table_prefix . 'privmsgs, ' . $table_prefix . 'privmsgs_text, ' . $table_prefix . 'ranks, ' . $table_prefix . 'search_results, ' . $table_prefix . 'search_wordlist, ' . $table_prefix . 'search_wordmatch, ' . $table_prefix . 'sessions_keys' . $table_prefix . 'smilies, ' . $table_prefix . 'themes, ' . $table_prefix . 'themes_name, ' . $table_prefix . 'topics, ' . $table_prefix . 'topics_watch, ' . $table_prefix . 'user_group, ' . $table_prefix . 'users, ' . $table_prefix . 'vote_desc, ' . $table_prefix . 'vote_results, ' . $table_prefix . 'vote_voters, ' . $table_prefix . 'words';

if (!$user_id)

{

// If we can't insert this user then continue to the next one to avoid inconsistant data

continue;

}

$sql = 'SELECT *

FROM ' . STYLES_THEME_TABLE . "

WHERE theme_name = 'prosilver'";

if ($theme)

{

'theme_data' => $theme['theme_data']

);

WHERE theme_id = ' . $theme['theme_id'];

phpbb::$acm->destroy_sql(STYLES_THEME_TABLE);

}

}

phpbb::$acm->purge();

}

$sql = 'SELECT template_name, template_path

FROM ' . STYLES_TEMPLATE_TABLE . "

WHERE LOWER(template_name) NOT IN ('subsilver2', 'prosilver')";

$templates = array();

{

$templates[] = $row;

}

if (sizeof($templates))

{

$sql = 'SELECT topic_id, forum_id

FROM ' . POSTS_TABLE . "

WHERE post_id = $post_id";

$topic_id = (int) $row['topic_id'];

$forum_id = (int) ($row['forum_id']) ? $row['forum_id'] : $forum_id;

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . "

WHERE topic_id = $topic_id";

$forum_id = (int) $row['forum_id'];

}

)

),

);

if ($read_tracking && phpbb::$config['load_db_lastread'])

);

}

{

if (!$row['forum_id'])

{

$topics[$row['topic_id']] = $row;

}

}

foreach ($cache_topic_ids as $id)

)

),

AND u.user_id = p.poster_id

AND t.topic_id = p.topic_id',

);

);

}

unset($sql_array);

{

if (!$row['forum_id'])

{

$rowset[$row['post_id']] = $row;

}

return $rowset;

}

$sql = "SELECT f.* $read_tracking_select

FROM " . FORUMS_TABLE . " f$read_tracking_join

{

if ($acl_list && !phpbb::$acl->acl_gets($acl_list, $row['forum_id']))

{

$rowset[$row['forum_id']] = $row;

}

return $rowset;

}

$sql = 'SELECT COUNT(post_id) AS total

FROM ' . POSTS_TABLE . "

AND post_approved = 0';

if ($min_time)

$sql = 'SELECT COUNT(topic_id) AS total

FROM ' . TOPICS_TABLE . "

AND topic_approved = 0';

if ($min_time)

}

else

{

}

if ($mode == 'reports')

$sql = 'SELECT COUNT(log_id) AS total

FROM ' . LOG_TABLE . "

AND log_time >= ' . $min_time . '

AND log_type = ' . LOG_MOD;

break;

if (($sort_days && $mode != 'viewlogs') || in_array($mode, array('reports', 'unapproved_topics', 'unapproved_posts')) || $where_sql != 'WHERE')

{

}

else

{

}

$sql = "SELECT $sql_id, forum_id FROM $table

$ids = array();

$forum_id = false;

{

if ($acl_list && $row['forum_id'] && !phpbb::$acl->acl_gets($acl_list, $row['forum_id']))

{

$ids[] = $row[$sql_id];

}

}

if (!sizeof($ids))

{

$sql = 'SELECT group_id

FROM ' . GROUPS_TABLE . "

WHERE group_name = 'ADMINISTRATORS'";

// Get group memberships for the admin id ary...

$admin_memberships = group_memberships($admin_group_id, $admin_id_ary);

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE;

$forums = array();

{

$forums[$row['forum_id']] = $row['forum_name'];

}

'SELECT' => 'u.user_id, u.group_id as default_group, u.username, u.username_clean, u.user_colour, u.user_rank, u.user_posts, u.user_allow_pm, g.group_id, g.group_name, g.group_colour, g.group_type, ug.user_id as ug_user_id',

'FROM' => array(

)

),

AND u.group_id = g.group_id',

'ORDER_BY' => 'g.group_name ASC, u.username_clean ASC'

));

{

$which_row = (in_array($row['user_id'], $admin_id_ary)) ? 'admin' : 'mod';

'U_VIEW_PROFILE' => get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']),

));

}

$template->assign_vars(array(

'PM_IMG' => phpbb::$user->img('icon_contact_pm', phpbb::$user->lang['SEND_PRIVATE_MESSAGE']))

FROM " . USERS_TABLE . "

WHERE user_id = $user_id

AND user_type IN (" . phpbb::USER_NORMAL . ', ' . phpbb::USER_FOUNDER . ')';

if (!$row)

{

// Get user...

$sql = 'SELECT *

FROM ' . USERS_TABLE . '

if (!$member)

{

AND g.group_id = ug.group_id" . ((!phpbb::$acl->acl_gets('a_group', 'a_groupadd', 'a_groupdel')) ? ' AND g.group_type <> ' . GROUP_HIDDEN : '') . '

AND ug.user_pending = 0

ORDER BY g.group_type, g.group_name';

$group_options = '';

{

$group_options .= '<option value="' . $row['group_id'] . '"' . (($row['group_id'] == $member['group_id']) ? ' selected="selected"' : '') . '>' . (($row['group_type'] == GROUP_SPECIAL) ? phpbb::$user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

}

// What colour is the zebra

$sql = 'SELECT friend, foe

WHERE zebra_id = ' . $user_id . '

AND user_id = ' . phpbb::$user->data['user_id'];

$foe = ($row['foe']) ? true : false;

$friend = ($row['friend']) ? true : false;

if (phpbb::$config['load_onlinetrack'])

{

$sql = 'SELECT MAX(session_time) AS session_time, MIN(session_viewonline) AS session_viewonline

FROM ' . SESSIONS_TABLE . "

WHERE session_user_id = $user_id";

$member['session_time'] = (isset($row['session_time'])) ? $row['session_time'] : 0;

$member['session_viewonline'] = (isset($row['session_viewonline'])) ? $row['session_viewonline'] : 0;

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $user_id . '

AND post_approved = 0';

}

else

{

FROM ' . USERS_TABLE . "

WHERE user_id = $user_id

AND user_type IN (" . phpbb::USER_NORMAL . ', ' . phpbb::USER_FOUNDER . ')';

if (!$row)

{

$sql = 'SELECT forum_id, topic_title

FROM ' . TOPICS_TABLE . "

WHERE topic_id = $topic_id";

if (!$row)

{

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_emailtime = ' . time() . '

WHERE user_id = ' . phpbb::$user->data['user_id'];

include_once(PHPBB_ROOT_PATH . 'includes/functions_messenger.' . PHP_EXT);

$messenger = new messenger(false);

$s_find_active_time .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';

}

$sql_where .= (is_numeric($count)) ? ' AND u.user_posts ' . $find_key_match[$count_select] . ' ' . (int) $count . ' ' : '';

$sql_where .= (sizeof($joined) > 1) ? " AND u.user_regdate " . $find_key_match[$joined_select] . ' ' . gmmktime(0, 0, 0, intval($joined[1]), intval($joined[2]), intval($joined[0])) : '';

$sql_where .= (phpbb::$acl->acl_get('u_viewonline') && sizeof($active) > 1) ? " AND u.user_lastvisit " . $find_key_match[$active_select] . ' ' . gmmktime(0, 0, 0, $active[1], intval($active[2]), intval($active[0])) : '';

}

else

{

}

if ($ips === false)

FROM ' . POSTS_TABLE . '

WHERE poster_ip ' . ((strpos($ips, '%') !== false) ? 'LIKE' : 'IN') . " ($ips)

AND forum_id IN (0, " . implode(', ', $ip_forums) . ')';

{

$ip_sql = array();

do

{

$ip_sql[] = $row['poster_id'];

}

}

else

{

}

unset($ip_forums);

}

}

}

{

for ($i = 97; $i < 123; $i++)

{

}

}

else if ($first_char)

{

}

// Are we looking at a usergroup? If so, fetch additional info

FROM ' . GROUPS_TABLE . ' g

LEFT JOIN ' . USER_GROUP_TABLE . ' ug ON (ug.user_pending = 0 AND ug.user_id = ' . phpbb::$user->data['user_id'] . " AND ug.group_id = $group_id)

WHERE g.group_id = $group_id";

if (!$group_row)

{

FROM ' . USERS_TABLE . " u$sql_from

WHERE u.user_type IN (" . phpbb::USER_NORMAL . ', ' . phpbb::USER_FOUNDER . ")

$sql_where";

}

else

{

$sql .= ' ORDER BY g.group_name ASC';

}

{

$group_ids[] = $row['group_id'];

$s_group_select .= '<option value="' . $row['group_id'] . '"' . (($group_selected == $row['group_id']) ? ' selected="selected"' : '') . '>' . (($row['group_type'] == GROUP_SPECIAL) ? phpbb::$user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

}

if ($group_selected !== 0 && !in_array($group_selected, $group_ids))

{

WHERE u.user_type IN (" . phpbb::USER_NORMAL . ', ' . phpbb::USER_FOUNDER . ")

$sql_where

ORDER BY $order_by";

$user_list = array();

{

$user_list[] = (int) $row['user_id'];

}

$leaders_set = false;

// So, did we get any users?

if (sizeof($user_list))

$sql = 'SELECT session_user_id, MAX(session_time) AS session_time

FROM ' . SESSIONS_TABLE . '

WHERE session_time >= ' . (time() - phpbb::$config['session_length']) . '

GROUP BY session_user_id';

$session_times = array();

{

$session_times[$row['session_user_id']] = $row['session_time'];

}

// Do the SQL thang

if ($mode == 'group')

$sql_select

FROM " . USERS_TABLE . " u

$sql_from

$sql_where_data";

}

else

{

$sql = 'SELECT *

FROM ' . USERS_TABLE . '

}

$id_cache = array();

{

$row['session_time'] = (!empty($session_times[$row['user_id']])) ? $session_times[$row['user_id']] : 0;

$row['last_visit'] = (!empty($row['session_time'])) ? $row['session_time'] : $row['user_lastvisit'];

$id_cache[$row['user_id']] = $row;

}

// Load custom profile fields

if (phpbb::$config['load_cpf_memberlist'])

FROM ' . EXTENSION_GROUPS_TABLE . '

WHERE cat_id > 0

ORDER BY cat_id';

$s_assigned_groups = array();

{

$s_assigned_groups[$row['cat_id']][] = $row['group_name'];

}

$l_legend_cat_images = phpbb::$user->lang['SETTINGS_CAT_IMAGES'] . ' [' . phpbb::$user->lang['ASSIGNED_GROUP'] . ': ' . ((!empty($s_assigned_groups[ATTACHMENT_CATEGORY_IMAGE])) ? implode(', ', $s_assigned_groups[ATTACHMENT_CATEGORY_IMAGE]) : phpbb::$user->lang['NO_EXT_GROUP']) . ']';

$sql = 'SELECT *

FROM ' . SITELIST_TABLE;

$defined_ips = '';

$ips = array();

{

$value = ($row['site_ip']) ? $row['site_ip'] : $row['site_hostname'];

if ($value)

$ips[$row['site_id']] = $value;

}

}

$template->assign_vars(array(

'S_SECURE_DOWNLOADS' => $this->new_config['secure_downloads'],

$sql = 'SELECT *

FROM ' . EXTENSIONS_TABLE . '

ORDER BY extension_id';

{

if ($row['group_id'] != $extensions[$row['extension_id']]['group_id'])

{

$sql = 'UPDATE ' . EXTENSIONS_TABLE . '

SET group_id = ' . (int) $extensions[$row['extension_id']]['group_id'] . '

WHERE extension_id = ' . $row['extension_id'];

add_log('admin', 'LOG_ATTACH_EXT_UPDATE', $row['extension']);

}

}

// Delete Extension?

$extension_id_list = request_var('extension_id_list', array(0));

{

$sql = 'SELECT extension

FROM ' . EXTENSIONS_TABLE . '

$extension_list = '';

{

$extension_list .= ($extension_list == '') ? $row['extension'] : ', ' . $row['extension'];

}

$sql = 'DELETE

FROM ' . EXTENSIONS_TABLE . '

add_log('admin', 'LOG_ATTACH_EXT_DEL', $extension_list);

}

{

$sql = 'SELECT extension_id

FROM ' . EXTENSIONS_TABLE . "

{

$error[] = sprintf(phpbb::$user->lang['EXTENSION_EXIST'], $add_extension);

}

if (!sizeof($error))

{

'extension' => $add_extension

);

add_log('admin', 'LOG_ATTACH_EXT_ADD', $add_extension);

}

}

$sql = 'SELECT *

FROM ' . EXTENSIONS_TABLE . '

ORDER BY group_id, extension';

{

$old_group_id = $row['group_id'];

do

'GROUP_OPTIONS' => $this->group_select('group_select[]', $row['group_id']))

);

}

}

break;

$sql = 'SELECT *

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

if (!$ext_row)

{

{

$sql = 'SELECT group_name

FROM ' . EXTENSION_GROUPS_TABLE;

$clean_group_name = utf8_clean_string($new_group_name);

{

if (utf8_clean_string($row['group_name']) === $clean_group_name)

{

break;

}

}

}

if (!sizeof($error))

// @TODO: rewrite with the new param db functions

$sql = ($action == 'add') ? 'INSERT INTO ' . EXTENSION_GROUPS_TABLE . ' ' : 'UPDATE ' . EXTENSION_GROUPS_TABLE . ' SET ';

$sql .= ($action == 'edit') ? " WHERE group_id = $group_id" : '';

if ($action == 'add')

{

}

add_log('admin', 'LOG_ATTACH_EXTGROUP_' . strtoupper($action), $group_name);

$sql = 'UPDATE ' . EXTENSIONS_TABLE . "

SET group_id = 0

WHERE group_id = $group_id";

}

if (sizeof($extension_list))

{

$sql = 'UPDATE ' . EXTENSIONS_TABLE . "

SET group_id = $group_id

}

phpbb::$acm->destroy('extensions');

$sql = 'SELECT group_name

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

$sql = 'DELETE

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

// Set corresponding Extensions to a pending Group

$sql = 'UPDATE ' . EXTENSIONS_TABLE . "

SET group_id = 0

WHERE group_id = $group_id";

add_log('admin', 'LOG_ATTACH_EXTGROUP_DEL', $group_name);

$sql = 'SELECT *

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

$forum_ids = (!$ext_group_row['allowed_forums']) ? array() : unserialize(trim($ext_group_row['allowed_forums']));

WHERE group_id = $group_id

OR group_id = 0

ORDER BY extension";

if ($ext_group_row['max_filesize'] == 0)

{

$sql = 'SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

$right = $cat_right = $padding_inc = 0;

$padding = $forum_list = $holding = '';

$padding_store = array('0' => '');

{

if ($row['forum_type'] == FORUM_CAT && ($row['left_id'] + 1 == $row['right_id']))

{

$s_forum_id_options .= $holding;

}

unset($padding_store);

$template->assign_vars(array(

$sql = 'SELECT *

FROM ' . EXTENSION_GROUPS_TABLE . '

ORDER BY allow_group DESC, allow_in_pm DESC, group_name';

$old_allow_group = $old_allow_pm = 1;

{

$s_add_spacer = ($old_allow_group != $row['allow_group'] || $old_allow_pm != $row['allow_in_pm']) ? true : false;

$old_allow_group = $row['allow_group'];

$old_allow_pm = $row['allow_in_pm'];

}

break;

{

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

AND is_orphan = 1';

$delete_files = array();

{

phpbb_unlink($row['physical_filename'], 'file');

$delete_files[$row['attach_id']] = $row['real_filename'];

}

}

if (sizeof($delete_files))

{

$sql = 'DELETE FROM ' . ATTACHMENTS_TABLE . '

add_log('admin', 'LOG_ATTACH_ORPHAN_DEL', implode(', ', $delete_files));

$notify[] = sprintf(phpbb::$user->lang['LOG_ATTACH_ORPHAN_DEL'], implode(', ', $delete_files));

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE;

$forum_names = array();

{

$forum_names[$row['forum_id']] = $row['forum_name'];

}

$sql = 'SELECT forum_id, topic_id, post_id, poster_id

FROM ' . POSTS_TABLE . '

$post_info = array();

{

$post_info[$row['post_id']] = $row;

}

// Select those attachments we want to change...

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

AND is_orphan = 1';

$files_added = $space_taken = 0;

{

$post_row = $post_info[$upload_list[$row['attach_id']]];

);

$sql = 'UPDATE ' . ATTACHMENTS_TABLE . '

WHERE attach_id = ' . $row['attach_id'];

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_attachment = 1

WHERE post_id = ' . $post_row['post_id'];

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_attachment = 1

WHERE topic_id = ' . $post_row['topic_id'];

$space_taken += $row['filesize'];

$files_added++;

add_log('admin', 'LOG_ATTACH_FILEUPLOAD', $post_row['post_id'], $row['real_filename']);

}

if ($files_added)

{

WHERE is_orphan = 1

AND filetime < ' . (time() - 3*60*60) . '

ORDER BY filetime DESC';

{

$template->assign_block_vars('orphan', array(

'FILESIZE' => get_formatted_filesize($row['filesize']),

'U_FILE' => append_sid('download/file', 'mode=view&amp;id=' . $row['attach_id']))

);

}

break;

}

$sql = 'SELECT cat_id

FROM ' . EXTENSION_GROUPS_TABLE . '

WHERE group_id = ' . (int) $group_id;

}

else

{

$sql = 'SELECT group_id, group_name

FROM ' . EXTENSION_GROUPS_TABLE . '

ORDER BY group_name';

$group_name = array();

{

$group_name[] = $row;

}

$row['group_id'] = 0;

$row['group_name'] = phpbb::$user->lang['NOT_ASSIGNED'];

$sql = 'SELECT site_ip, site_hostname

FROM ' . SITELIST_TABLE . "

WHERE ip_exclude = $ip_exclude";

{

$iplist_tmp = array();

$hostlist_tmp = array();

}

// break;

}

$iplist = array_unique(array_diff($iplist, $iplist_tmp));

$hostlist = array_unique(array_diff($hostlist, $hostlist_tmp));

unset($iplist_tmp);

unset($hostlist_tmp);

}

if (sizeof($iplist))

{

{

$sql = 'INSERT INTO ' . SITELIST_TABLE . " (site_ip, ip_exclude)

VALUES ($ip_entry, $ip_exclude)";

}

}

{

$sql = 'INSERT INTO ' . SITELIST_TABLE . " (site_hostname, ip_exclude)

VALUES ($host_entry, $ip_exclude)";

}

}

// Grab details of ips for logging information later

$sql = 'SELECT site_ip, site_hostname

FROM ' . SITELIST_TABLE . '

{

$l_unip_list .= (($l_unip_list != '') ? ', ' : '') . (($row['site_ip']) ? $row['site_ip'] : $row['site_hostname']);

}

$sql = 'DELETE FROM ' . SITELIST_TABLE . '

add_log('admin', 'LOG_DOWNLOAD_REMOVE_IP', $l_unip_list);

}

AND ban_email <> ''";

break;

}

$banned_options = '';

$ban_length = $ban_reasons = $ban_give_reasons = array();

{

$banned_options .= '<option' . (($row['ban_exclude']) ? ' class="sep"' : '') . ' value="' . $row['ban_id'] . '">' . $row[$field] . '</option>';

$ban_reasons[$row['ban_id']] = $row['ban_reason'];

$ban_give_reasons[$row['ban_id']] = $row['ban_give_reason'];

}

if (sizeof($ban_length))

{

$sql = 'SELECT bbcode_match, bbcode_tpl, display_on_posting, bbcode_helpline

FROM ' . BBCODES_TABLE . '

WHERE bbcode_id = ' . $bbcode_id;

if (!$row)

{

$sql = 'SELECT bbcode_id, bbcode_tag

FROM ' . BBCODES_TABLE . '

WHERE bbcode_id = ' . $bbcode_id;

if (!$row)

{

{

$sql = 'SELECT 1 as test

FROM ' . BBCODES_TABLE . "

// Grab the end, interrogate the last closing tag

if ($info['test'] === '1' || in_array(strtolower($data['bbcode_tag']), $hard_coded) || (preg_match('#\[/([^[]*)]$#', $bbcode_match, $regs) && in_array(strtolower($regs[1]), $hard_coded)))

{

$sql = 'SELECT MAX(bbcode_id) as max_bbcode_id

FROM ' . BBCODES_TABLE;

if ($row)

{

$sql_ary['bbcode_id'] = (int) $bbcode_id;

phpbb::$acm->destroy_sql(BBCODES_TABLE);

$lang = 'BBCODE_ADDED';

else

{

$sql = 'UPDATE ' . BBCODES_TABLE . '

WHERE bbcode_id = ' . $bbcode_id;

phpbb::$acm->destroy_sql(BBCODES_TABLE);

$lang = 'BBCODE_EDITED';

$sql = 'SELECT bbcode_tag

FROM ' . BBCODES_TABLE . "

WHERE bbcode_id = $bbcode_id";

if ($row)

{

if (confirm_box(true))

{

phpbb::$acm->destroy_sql(BBCODES_TABLE);

add_log('admin', 'LOG_BBCODE_DELETE', $row['bbcode_tag']);

}

$sql = 'SELECT *

FROM ' . BBCODES_TABLE . '

ORDER BY bbcode_tag';

{

$template->assign_block_vars('bbcodes', array(

'BBCODE_TAG' => $row['bbcode_tag'],

'U_DELETE' => $this->u_action . '&amp;action=delete&amp;bbcode=' . $row['bbcode_id'])

);

}

}