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

}

/**