***************************************************************************/

// Simple version of jumpbox, just lists authed forums

{

global $db, $user, $auth;

$right = $cat_right = 0;

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

foreach ($rowset as $row)

{

{

continue;

}

$holding = '';

}

{

$cat_right = max($cat_right, $row['right_id']);

}

else

{

$holding = '';

}

}

{

// This query is identical to the jumpbox one

$expire_time = ($no_cache) ? 0 : 120;

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

$result = $db->sql_query($sql, $expire_time);

$rowset = array();

foreach ($forum_rows as $row)

{

{

continue;

}

global $db;

$forum_ids = array($forum_id);

if ($auto_sync)

{

$sql = 'SELECT DISTINCT forum_id

FROM ' . TOPICS_TABLE . '

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

{

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

}

sync('forum', 'forum_id', $forum_ids, TRUE);

}

}

function move_posts($post_ids, $topic_id, $auto_sync = TRUE)

{

global $db;

if (!is_array($post_ids))

{

$post_ids = array($post_ids);

FROM ' . POSTS_TABLE . '

WHERE post_id IN (' . implode(', ', $post_ids) . ')';

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

{

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

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

}

}

$result = $db->sql_query($sql);

{

}

$sql = 'UPDATE ' . POSTS_TABLE . '

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

{

$where_ids = array_unique($where_ids);

}

if (!count($where_ids))

{

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

'posts' => delete_posts($where_type, $where_ids, FALSE)

);

$sql = 'SELECT topic_id, forum_id

FROM ' . TOPICS_TABLE . "

WHERE $where_type " . ((!is_array($where_ids)) ? "= $where_ids" : 'IN (' . implode(', ', $where_ids) . ')');

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

{

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

return $return;

}

$db->sql_transaction('begin');

$db->sql_transaction('commit');

if ($auto_sync)

sync('topic_reported', $where_type, $where_ids);

}

return $return;

}

return false;

}

$db->sql_transaction('begin');

$db->sql_transaction('commit');

delete_attachment($post_ids);

sync('forum', 'forum_id', $forum_ids, TRUE);

}

return count($post_ids);

}

//

// Usage:

// sync('topic', 'topic_id', 123); <= resynch topic #123

// sync('topic', 'forum_id', array(2, 3)); <= resynch topics from forum #2 and #3

// sync('topic'); <= resynch all topics

function sync($mode, $where_type = '', $where_ids = '', $resync_parents = FALSE, $sync_extra = FALSE)

{

if (is_array($where_ids))

{

else

{

$where_sql = 'WHERE ' . $mode{0} . ".$where_type IN (" . implode(', ', $where_ids) . ')';

}

}

else

{

$where_sql = "WHERE t.$where_type IN (" . implode(', ', $where_ids) . ')';

}

switch ($mode)

$result = $db->sql_query($sql);

$topic_ids = $approved_unapproved_ids = array();

while ($row = $db->sql_fetchrow($result))

{

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

SET topic_approved = 1 - topic_approved

WHERE topic_id IN (' . implode(', ', $approved_unapproved_ids) . ')';

$db->sql_query($sql);

case 'post_attachment':

$post_ids = array();

{

default:

$sql = 'SELECT t.post_id, t.post_attachment, COUNT(a.attachment_id) AS attachments

FROM ' . POSTS_TABLE . ' t

LEFT JOIN ' . ATTACHMENTS_TABLE . " a ON t.post_id = a.post_id

$where_sql

GROUP BY t.post_id";

}

if (!count($post_ids))

{

SET post_attachment = 1 - post_attachment

WHERE post_id IN (' . implode(', ', $post_ids) . ')';

$db->sql_query($sql);

case 'topic_attachment':

{

default:

$sql = 'SELECT t.topic_id, t.topic_attachment, COUNT(a.attachment_id) AS attachments

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

LEFT JOIN ' . ATTACHMENTS_TABLE . " a ON p.post_id = a.post_id

$where_sql_and t.topic_id = p.topic_id

AND ((t.topic_attachment = 1 AND attachments = 0)

GROUP BY t.topic_id";

}

if (count($topic_ids))

{

SET topic_attachment = 1 - topic_attachment

WHERE topic_id IN (' . implode(', ', $topic_ids) . ')';

$db->sql_query($sql);

case 'reported':

$topic_data = $topic_ids = $post_ids = array();

if ($sync_extra)

{

{

}

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_reported = 1 - post_reported

WHERE post_id IN (' . implode(', ', $post_ids) . ')';

$db->sql_query($sql);

unset($post_ids);

}

}

$result = $db->sql_query($sql);

{

{

}

{

}

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_reported = 1 - topic_reported

WHERE topic_id IN (' . implode(', ', $topic_ids) . ')';

$db->sql_query($sql);

}

return;

case 'forum':

if ($resync_parents)

{

$sql = 'SELECT f2.forum_id

FROM ' . FORUMS_TABLE . ' f, ' . FORUMS_TABLE . " f2

$where_sql_and f.left_id BETWEEN f2.left_id AND f2.right_id";

$result = $db->sql_query($sql);

{

sync('forum', 'forum_id', $forum_ids, FALSE);

}

return;

}

$sql = 'SELECT f.*, f2.forum_id AS id

FROM ' . FORUMS_TABLE . ' f, ' . FORUMS_TABLE . " f2

$where_sql_and f2.left_id BETWEEN f.left_id AND f.right_id";

$forum_data = $forum_ids = $post_ids = $subforum_list = $post_count = $last_post_id = $post_info = $topic_count = $topic_count_real = array();

while ($row = $db->sql_fetchrow($result))

{

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

if (!isset($subforum_list[$row['forum_id']]))

{

{

$topic_count_real[$row['forum_id']] += $row['forum_topics'];

}

if ($row['topic_approved'])

{

$topic_count[$row['forum_id']] = $row['forum_topics'];

$forum_data[$forum_id]['topics'] += $topic_count[$subforum_id];

$forum_data[$forum_id]['topics_real'] += $topic_count_real[$subforum_id];

}

if (isset($post_count[$subforum_id]))

{

$forum_data[$forum_id]['posts'] += $post_count[$subforum_id];

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

}

}

if (count($post_ids))

{

$sql = 'SELECT p.post_id, p.poster_id, u.username, p.post_time

{

if (preg_match('#name$#', $fieldname))

{

}

else

{

}

}

SET ' . $db->sql_build_array('UPDATE', $sql) . '

WHERE forum_id = ' . $forum_id;

$db->sql_query($sql);

}

}

case 'topic':

$topic_data = $topic_ids = $post_ids = $approved_unapproved_ids = $resync_forums = array();

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

$where_sql_and p.topic_id = t.topic_id

GROUP BY p.topic_id, p.post_approved";

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

{

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

if (!count($topic_ids))

{

// If we get there, topic ids were invalid or topics did not contain any posts

delete_topics($where_type, $where_ids);

return;

}

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

WHERE p.post_id IN (' . implode(', ', $post_ids) . ')

AND u.user_id = p.poster_id';

$post_ids = array();

while ($row = $db->sql_fetchrow($result))

{

if ($row['post_id'] == $topic_data[$row['topic_id']]['first_post_id'])

{

// This routine assumes that post_reported values are correct

// if they are not, use sync('reported') instead

$sql = 'SELECT t.topic_id, p.post_id

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

$where_sql_and p.topic_id = t.topic_id

AND p.post_reported = 1

GROUP t.topic_id";

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

{

$topic_data[$row['topic_id']]['reported'] = 1;

}

// This routine assumes that post_attachment values are correct

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

$sql = 'SELECT t.topic_id, p.post_id

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

$where_sql_and p.topic_id = t.topic_id

AND p.post_attachment = 1

GROUP t.topic_id";

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

{

$topic_data[$row['topic_id']]['attachment'] = 1;

}

}

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

// NOTE: should shadow topics be updated as well?

$sql = 'UPDATE ' . TOPICS_TABLE . '

$db->sql_query($sql);

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

GROUP BY f.forum_id';

$result = $db->sql_query($sql);

{

sync('forum', 'forum_id', $forum_ids, FALSE);

}

}

}

}

}

$db->sql_freeresult($result);

}

// Function auto_prune(), this function now relies on passed vars

$in_comment = false;

for($i = 0; $i < $linecount; $i++)

{

{

$in_comment = true;

}

$output .= $lines[$i] . "\n";

}

{

$in_comment = false;

}

if ($i != $token_count - 1 || strlen($tokens[$i] > 0))

{

// This is the total number of single quotes in the token.

// Counts single quotes that are preceded by an odd number of backslashes,

// which means they're escaped quotes.

$unescaped_quotes = $total_quotes - $escaped_quotes;

for ($j = $i + 1; (!$complete_stmt && ($j < $token_count)); $j++)

{

// This is the total number of single quotes in the token.

// Counts single quotes that are preceded by an odd number of backslashes,

// which means they're escaped quotes.

$unescaped_quotes = $total_quotes - $escaped_quotes;

return $output;

}

function cache_moderators()

{

global $db;