FROM $sql_table

$sql_where";

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

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

$db->sql_freeresult($result);

}

/**

*/

function size_select_options($size_compare)

{

$size_types = array('b', 'kb', 'mb');

$s_size_options = '';

for ($i = 0, $size = sizeof($size_types_text); $i < $size; $i++)

{

$selected = ($size_compare == $size_types[$i]) ? ' selected="selected"' : '';

$s_size_options .= '<option value="' . $size_types[$i] . '"' . $selected . '>' . $size_types_text[$i] . '</option>';

}

return $s_size_options;

}

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

}

$db->sql_freeresult($result);

return $s_group_options;

}

{

// This query is identical to the jumpbox one

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

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

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

{

case 'parents':

$condition = 'f1.left_id BETWEEN f2.left_id AND f2.right_id';

case 'children':

$condition = 'f2.left_id BETWEEN f1.left_id AND f1.right_id';

default:

$condition = 'f2.left_id BETWEEN f1.left_id AND f1.right_id OR f1.left_id BETWEEN f2.left_id AND f2.right_id';

}

$rows = array();

// Remove initial / if present

$rootdir = (substr($rootdir, 0, 1) == '/') ? substr($rootdir, 1) : $rootdir;

$rootdir = ($rootdir && substr($rootdir, -1) != '/') ? $rootdir . '/' : $rootdir;

// Remove initial / if present

$dir = (substr($dir, 0, 1) == '/') ? substr($dir, 1) : $dir;

$dir = ($dir && substr($dir, -1) != '/') ? $dir . '/' : $dir;

if (!is_dir($rootdir . $dir))

}

$forum_ids = array($forum_id);

if (!is_array($topic_ids))

{

$topic_ids = array($topic_ids);

$db->sql_freeresult($result);

}

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

foreach ($table_ary as $table)

{

function delete_topics($where_type, $where_ids, $auto_sync = true)

{

global $db;

$forum_ids = $topic_ids = array();

if (is_array($where_ids))

return $return;

}

$sql_where = ' IN (' . implode(', ', $topic_ids) . ')';

$db->sql_transaction('begin');

{

$where_ids = array_unique($where_ids);

}

if (empty($where_ids))

{

return false;

}

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

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

FROM ' . POSTS_TABLE . "

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

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

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

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

}

if (!sizeof($post_ids))

{

unset($table_ary);

// Remove the message from the search index

if (!file_exists($phpbb_root_path . 'includes/search/' . $search_type . '.' . $phpEx))

{

/**

* Delete Attachments

*/

function delete_attachments($mode, $ids, $resync = true)

{

if (is_array($ids))

{

$ids = array_unique($ids);

}

if (!sizeof($ids))

{

return false;

FROM ' . ATTACHMENTS_TABLE . '

WHERE ' . $sql_id . ' IN (' . implode(', ', $ids) . ')';

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

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

{

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

WHERE post_msg_id IN (' . implode(', ', $ids) . ')

AND in_message = 0';

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

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

{

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

}

// Delete attachments

$num_deleted = $db->sql_affectedrows();

if (!$num_deleted)

{

return 0;

}

// Delete attachments from filesystem

$space_removed = $files_removed = 0;

foreach ($physical as $file_ary)

{

if ($mode == 'post' || $mode == 'topic')

{

SET post_attachment = 0

}

if ($mode == 'user' || $mode == 'attach')

$remaining = array();

$sql = 'SELECT post_msg_id

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

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

{

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

$db->sql_freeresult($result);

$unset_ids = array_diff($post_ids, $remaining);

if (sizeof($unset_ids))

{

SET post_attachment = 0

}

$remaining = array();

$sql = 'SELECT post_msg_id

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

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

{

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

$db->sql_freeresult($result);

$unset_ids = array_diff($post_ids, $remaining);

if (sizeof($unset_ids))

{

SET message_attachment = 0

}

}

}

// Update topic indicator

if ($mode == 'topic')

{

SET topic_attachment = 0

}

if ($mode == 'post' || $mode == 'user' || $mode == 'attach')

$remaining = array();

$sql = 'SELECT topic_id

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

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

$db->sql_freeresult($result);

$unset_ids = array_diff($topic_ids, $remaining);

if (sizeof($unset_ids))

{

SET topic_attachment = 0

}

}

}

*/

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

{

switch (SQL_LAYER)

{

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

. $where;

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

$topic_ids = array();

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

{

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

}

if (sizeof($topic_ids))

{

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

$db->sql_query($sql);

}

}

if ($auto_sync)

/**

* All-encompasing sync function

*

*

* Modes:

* - topic_approved Resyncs the topic_approved flag according to the status of the first post

* - post_reported Resyncs the post_reported flag, relying on actual reports

* - topic_reported Resyncs the topic_reported flag, relying on post_reported flags

*/

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

{

if (is_array($where_ids))

{

$where_ids = array_unique($where_ids);

}

else if ($where_type != 'range')

{

}

if ($mode == 'forum' || $mode == 'topic')

{

return;

}

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

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

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

AND t1.forum_id = t2.forum_id";

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

{

}

$db->sql_freeresult($result);

}

case 'topic_approved':

switch (SQL_LAYER)

SET topic_approved = 1 - topic_approved

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

$db->sql_query($sql);

}

case 'post_reported':

$post_ids = $post_reported = array();

$where_sql

GROUP BY p.post_id, p.post_reported";

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

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

{

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

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

}

}

$sql = 'SELECT DISTINCT(post_id)

FROM ' . REPORTS_TABLE . '

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

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

$db->sql_query($sql);

}

case 'topic_reported':

if ($sync_extra)

FROM ' . POSTS_TABLE . " t

$where_sql_and t.post_reported = 1";

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

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

{

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

}

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

FROM ' . TOPICS_TABLE . " t

$where_sql";

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

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

{

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

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

}

}

if (sizeof($topic_ids))

{

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

$db->sql_query($sql);

}

case 'post_attachment':

$post_ids = $post_attachment = array();

$where_sql

GROUP BY p.post_id, p.post_attachment";

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

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

{

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

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

}

}

$sql = 'SELECT DISTINCT(post_msg_id)

FROM ' . ATTACHMENTS_TABLE . '

WHERE post_msg_id IN (' . implode(', ', $post_ids) . ')

AND in_message = 0';

$post_ids = array();

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

{

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

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

}

}

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

// posts that are falsely flagged as having attachments

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

$db->sql_query($sql);

}

case 'topic_attachment':

if ($sync_extra)

FROM ' . POSTS_TABLE . " t

$where_sql_and t.post_attachment = 1";

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

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

{

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

}

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

FROM ' . TOPICS_TABLE . " t

$where_sql";

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

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

{

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

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

}

}

if (sizeof($topic_ids))

{

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

$db->sql_query($sql);

}

case 'forum':

// 1: Get the list of all forums

$sql = 'SELECT f.*

FROM ' . FORUMS_TABLE . " f

$forum_data[$forum_id]['last_poster_id'] = 0;

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

}

// 2: Get topic counts for each forum

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

WHERE forum_id IN (' . implode(', ', $forum_ids) . ')

GROUP BY forum_id, topic_approved';

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

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

{

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

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

}

}

// 3: Get post count and last_post_id for each forum

$sql = 'SELECT forum_id, COUNT(post_id) AS forum_posts, MAX(post_id) AS last_post_id

AND post_approved = 1

GROUP BY forum_id';

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

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

{

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

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

}

// 4: Retrieve last_post infos

if (sizeof($post_ids))

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

AND p.poster_id = u.user_id';

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

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

{

}

$db->sql_freeresult($result);

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

{

foreach ($fieldnames as $fieldname)

{

{

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

{

}

else

{

}

}

}

{

$sql = 'UPDATE ' . FORUMS_TABLE . '

WHERE forum_id = ' . $forum_id;

$db->sql_query($sql);

}

}

case 'topic':

$topic_data = $post_ids = $approved_unapproved_ids = $resync_forums = $delete_topics = $delete_posts = array();

delete_topics($where_type, $where_ids, true);

return;

}

if (sizeof($delete_topics))

{

$delete_topic_ids = array();

$topic_data[$topic_id]['poster'] = $row['poster_id'];

$topic_data[$topic_id]['first_poster_name'] = ($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username'];

}

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

{

$topic_data[$topic_id]['last_poster_id'] = $row['poster_id'];

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

{

foreach ($fieldnames as $fieldname)

{

if ($row['topic_' . $fieldname] != $row[$fieldname])

{

}

}

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

$db->sql_query($sql);

{

sync('forum', 'forum_id', $resync_forums, true);

}

}

}

/**

{

global $db;

$sql_and = '';

if (!($prune_flags & 4))

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

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

{

$prune_date = time() - ($prune_days * 86400);

$next_prune = time() + ($prune_freq * 86400);

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

}

return;

}

{

unset($data[key($data)]);

}

return $data;

}

),

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

));

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

*/

function view_log($mode, &$log, &$log_count, $limit = 0, $offset = 0, $forum_id = 0, $topic_id = 0, $user_id = 0, $limit_days = 0, $sort_by = 'l.log_time DESC')

{

$topic_id_list = $reportee_id_list = $is_auth = $is_mod = array();

switch ($mode)

{

$log_type = LOG_ADMIN;

$sql_forum = '';

break;

case 'mod':

$log_type = LOG_MOD;

}

$log[$i] = array(

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

'reportee_username' => '',

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

'username' => '<a href="' . $profile_url . '&amp;u=' . $row['user_id'] . '">' . $row['username'] . '</a>',

'ip' => $row['log_ip'],

'time' => $row['log_time'],

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

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

'action' => (isset($user->lang[$row['log_operation']])) ? $user->lang[$row['log_operation']] : '{' . ucfirst(str_replace('_', ' ', $row['log_operation'])) . '}',

);

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

{

if (isset($user->lang[$row['log_operation']]))

{

$topic_id_list = array_unique($topic_id_list);

// This query is not really needed if move_topics() updates the forum_id field,

$sql = 'SELECT topic_id, forum_id

FROM ' . TOPICS_TABLE . '

WHERE topic_id IN (' . implode(', ', array_map('intval', $topic_id_list)) . ')';

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

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

{

{

}

if ($auth->acl_gets('a_', 'm_', $row['forum_id']))

$is_mod[$row['topic_id']] = $row['forum_id'];

}

}

foreach ($log as $key => $row)

{

}

}

AND l.log_time >= $limit_days

$sql_forum";

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

$db->sql_freeresult($result);

return;

}

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

ORDER BY $sort_by";

$result = $db->sql_query_limit($sql, $limit, $offset);

$users = $db->sql_fetchrowset($result);

$db->sql_freeresult($result);

FROM ' . USERS_TABLE . '

WHERE user_warnings > 0

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

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

$db->sql_freeresult($result);

return;

}

{

global $db, $user, $table_prefix;

if (preg_match('#^mysql#', SQL_LAYER))

{

{

$version = $row['mysql_version'];

$sql = 'SELECT ((SUM(size) * 8.0) * 1024.0) as dbsize

FROM sysfiles';

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

$dbsize = ($row = $db->sql_fetchrow($result)) ? intval($row['dbsize']) : $user->lang['NOT_AVAILABLE'];

$db->sql_freeresult($result);

}