{

global $db;

$sql = 'SELECT *

FROM ' . $table . '

WHERE parent_id = ' . (int) $parent_id .

((!empty($where)) ? ' AND ' . implode(' AND ', $where) : '') . '

ORDER BY left_id ASC';

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

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

{

// First we update the left_id for this module

if ($row['left_id'] != $new_id)

{

$db->sql_query('UPDATE ' . $table . ' SET ' . $db->sql_build_array('UPDATE', array('left_id' => $new_id)) . " WHERE $pkey = {$row[$pkey]}");

}

$new_id++;

// Then we go through any children and update their left/right id's

recalc_nested_sets($new_id, $pkey, $table, $row[$pkey], $where);

// Then we come back and update the right_id for this module

if ($row['right_id'] != $new_id)

{

$db->sql_query('UPDATE ' . $table . ' SET ' . $db->sql_build_array('UPDATE', array('right_id' => $new_id)) . " WHERE $pkey = {$row[$pkey]}");

}

$new_id++;

}

$db->sql_freeresult($result);

{

global $db, $user, $auth;

// This query is identical to the jumpbox one

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

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

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

$right = 0;

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

$padding = '';

$forum_list = ($return_array) ? array() : '';

// Sometimes it could happen that forums will be displayed here not be displayed within the index page

// This is the result of forums not displayed at index, having list permissions and a parent of a forum with no permissions.

// If this happens, the padding could be "broken"

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

{

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

{

$padding .= '&nbsp; &nbsp;';

$padding_store[$row['parent_id']] = $padding;

}

else if ($row['left_id'] > $right + 1)

{

$padding = (isset($padding_store[$row['parent_id']])) ? $padding_store[$row['parent_id']] : '';

}

$right = $row['right_id'];

$disabled = false;

if (!$ignore_acl && $auth->acl_gets(array('f_list', 'a_forum', 'a_forumadd', 'a_forumdel'), $row['forum_id']))

{

if ($only_acl_post && !$auth->acl_get('f_post', $row['forum_id']) || (!$auth->acl_get('m_approve', $row['forum_id']) && !$auth->acl_get('f_noapprove', $row['forum_id'])))

{

$disabled = true;

}

}

else if (!$ignore_acl)

{

continue;

}

if (

((is_array($ignore_id) && in_array($row['forum_id'], $ignore_id)) || $row['forum_id'] == $ignore_id)

||

// Non-postable forum with no subforums, don't display

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

||

($row['forum_type'] != FORUM_POST && $ignore_nonpost)

)

{

$disabled = true;

}

if ($return_array)

{

// Include some more information...

$selected = (is_array($select_id)) ? ((in_array($row['forum_id'], $select_id)) ? true : false) : (($row['forum_id'] == $select_id) ? true : false);

$forum_list[$row['forum_id']] = array_merge(array('padding' => $padding, 'selected' => ($selected && !$disabled), 'disabled' => $disabled), $row);

}

else

{

$selected = (is_array($select_id)) ? ((in_array($row['forum_id'], $select_id)) ? ' selected="selected"' : '') : (($row['forum_id'] == $select_id) ? ' selected="selected"' : '');

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

}

}

$db->sql_freeresult($result);

unset($padding_store);

return $forum_list;

{

global $user;

$size_types_text = array($user->lang['BYTES'], $user->lang['KIB'], $user->lang['MIB']);

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

$s_size_options = '';

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

{

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

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

}

return $s_size_options;

{

global $db, $user, $config;

$exclude_sql = ($exclude_ids !== false && sizeof($exclude_ids)) ? 'WHERE ' . $db->sql_in_set('group_id', array_map('intval', $exclude_ids), true) : '';

$sql_and = (!$config['coppa_enable']) ? (($exclude_sql) ? ' AND ' : ' WHERE ') . "group_name <> 'REGISTERED_COPPA'" : '';

$sql_founder = ($manage_founder !== false) ? (($exclude_sql || $sql_and) ? ' AND ' : ' WHERE ') . 'group_founder_manage = ' . (int) $manage_founder : '';

$sql = 'SELECT group_id, group_name, group_type

FROM ' . GROUPS_TABLE . "

ORDER BY group_type DESC, group_name ASC";

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

$s_group_options = '';

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

{

$selected = ($row['group_id'] == $group_id) ? ' selected="selected"' : '';

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

}

$db->sql_freeresult($result);

return $s_group_options;

{

global $db, $auth;

static $forum_rows;

if (!isset($forum_rows))

{

// This query is identical to the jumpbox one

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

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

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

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

$forum_rows = array();

$right = $padding = 0;

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

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

{

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

{

$padding++;

$padding_store[$row['parent_id']] = $padding;

}

else if ($row['left_id'] > $right + 1)

{

// Ok, if the $padding_store for this parent is empty there is something wrong. For now we will skip over it.

// @todo digging deep to find out "how" this can happen.

$padding = (isset($padding_store[$row['parent_id']])) ? $padding_store[$row['parent_id']] : $padding;

}

$right = $row['right_id'];

$row['padding'] = $padding;

$forum_rows[] = $row;

}

$db->sql_freeresult($result);

unset($padding_store);

}

$rowset = array();

foreach ($forum_rows as $row)

{

if ($postable_only && $row['forum_type'] != FORUM_POST)

{

continue;

}

if ($acl_list == '' || ($acl_list != '' && $auth->acl_gets($acl_list, $row['forum_id'])))

{

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

}

}

return $rowset;

{

global $db;

switch ($type)

{

case 'parents':

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

break;

case 'children':

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

break;

default:

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

break;

}

$rows = array();

$sql = 'SELECT f2.*

FROM ' . FORUMS_TABLE . ' f1

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

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

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

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

{

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

{

continue;

}

$rows[] = $row;

}

$db->sql_freeresult($result);

return $rows;

{

global $db;

// Only one forum id specified

if (!is_array($dest_forum_ids))

{

$dest_forum_ids = array($dest_forum_ids);

}

// Make sure forum ids are integers

$src_forum_id = (int) $src_forum_id;

$dest_forum_ids = array_map('intval', $dest_forum_ids);

// No source forum or no destination forums specified

if (empty($src_forum_id) || empty($dest_forum_ids))

{

return false;

}

// Check if source forum exists

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $src_forum_id;

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

$src_forum_name = $db->sql_fetchfield('forum_name');

$db->sql_freeresult($result);

// Source forum doesn't exist

if (empty($src_forum_name))

{

return false;

}

// Check if destination forums exists

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $dest_forum_ids);

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

$dest_forum_ids = $dest_forum_names = array();

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

{

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

$dest_forum_names[] = $row['forum_name'];

}

$db->sql_freeresult($result);

// No destination forum exists

if (empty($dest_forum_ids))

{

return false;

}

// From the mysql documentation:

// Prior to MySQL 4.0.14, the target table of the INSERT statement cannot appear

// in the FROM clause of the SELECT part of the query. This limitation is lifted in 4.0.14.

// Due to this we stay on the safe side if we do the insertion "the manual way"

// Rowsets we're going to insert

$users_sql_ary = $groups_sql_ary = array();

// Query acl users table for source forum data

$sql = 'SELECT user_id, auth_option_id, auth_role_id, auth_setting

FROM ' . ACL_USERS_TABLE . '

WHERE forum_id = ' . $src_forum_id;

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

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

{

$row = array(

'user_id' => (int) $row['user_id'],

'auth_option_id' => (int) $row['auth_option_id'],

'auth_role_id' => (int) $row['auth_role_id'],

'auth_setting' => (int) $row['auth_setting'],

);

foreach ($dest_forum_ids as $dest_forum_id)

{

$users_sql_ary[] = $row + array('forum_id' => $dest_forum_id);

}

}

$db->sql_freeresult($result);

// Query acl groups table for source forum data

$sql = 'SELECT group_id, auth_option_id, auth_role_id, auth_setting

FROM ' . ACL_GROUPS_TABLE . '

WHERE forum_id = ' . $src_forum_id;

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

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

{

$row = array(

'group_id' => (int) $row['group_id'],

'auth_option_id' => (int) $row['auth_option_id'],

'auth_role_id' => (int) $row['auth_role_id'],

'auth_setting' => (int) $row['auth_setting'],

);

foreach ($dest_forum_ids as $dest_forum_id)

{

$groups_sql_ary[] = $row + array('forum_id' => $dest_forum_id);

}

}

$db->sql_freeresult($result);

$db->sql_transaction('begin');

// Clear current permissions of destination forums

if ($clear_dest_perms)

{

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $dest_forum_ids);

$db->sql_query($sql);

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $dest_forum_ids);

$db->sql_query($sql);

}

$db->sql_multi_insert(ACL_USERS_TABLE, $users_sql_ary);

$db->sql_multi_insert(ACL_GROUPS_TABLE, $groups_sql_ary);

if ($add_log)

{

add_log('admin', 'LOG_FORUM_COPIED_PERMISSIONS', $src_forum_name, implode(', ', $dest_forum_names));

}

$db->sql_transaction('commit');

return true;

{

$matches = array($dir => array());

// Remove initial / if present

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

// Add closing / if not present

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

// Remove initial / if present

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

// Add closing / if not present

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

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

{

return $matches;

}

$dh = @opendir($rootdir . $dir);

if (!$dh)

{

return $matches;

}

while (($fname = readdir($dh)) !== false)

{

if (is_file("$rootdir$dir$fname"))

{

if (filesize("$rootdir$dir$fname") && preg_match('#\.' . $type . '$#i', $fname))

{

$matches[$dir][] = $fname;

}

}

else if ($fname[0] != '.' && is_dir("$rootdir$dir$fname"))

{

$matches += filelist($rootdir, "$dir$fname", $type);

}

}

closedir($dh);

return $matches;

{

global $db;

if (empty($topic_ids))

{

return;

}

$forum_ids = array($forum_id);

if (!is_array($topic_ids))

{

$topic_ids = array($topic_ids);

}

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set('topic_moved_id', $topic_ids) . '

AND forum_id = ' . $forum_id;

$db->sql_query($sql);

if ($auto_sync)

{

$sql = 'SELECT DISTINCT forum_id

FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set('topic_id', $topic_ids);

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

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

{

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

}

$db->sql_freeresult($result);

}

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

foreach ($table_ary as $table)

{

$sql = "UPDATE $table

WHERE " . $db->sql_in_set('topic_id', $topic_ids);

$db->sql_query($sql);

}

unset($table_ary);

if ($auto_sync)

{

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

unset($forum_ids);

}

{

global $db;

if (!is_array($post_ids))

{

$post_ids = array($post_ids);

}

$forum_ids = array();

$topic_ids = array($topic_id);

$sql = 'SELECT DISTINCT topic_id, forum_id

FROM ' . POSTS_TABLE . '

WHERE ' . $db->sql_in_set('post_id', $post_ids);

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

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

{

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

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

}

$db->sql_freeresult($result);

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

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

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

$db->sql_freeresult($result);

if (!$forum_row)

{

trigger_error('NO_TOPIC');

}

$sql = 'UPDATE ' . POSTS_TABLE . '

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

WHERE " . $db->sql_in_set('post_id', $post_ids);

$db->sql_query($sql);

$sql = 'UPDATE ' . ATTACHMENTS_TABLE . "

WHERE " . $db->sql_in_set('post_msg_id', $post_ids);

$db->sql_query($sql);

if ($auto_sync)

{

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

sync('topic_reported', 'topic_id', $topic_ids);

sync('topic_attachment', 'topic_id', $topic_ids);

sync('topic', 'topic_id', $topic_ids, true);

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

}

// Update posted information

update_posted_info($topic_ids);

{

global $db, $config;

$approved_topics = 0;

$forum_ids = $topic_ids = array();

if ($where_type === 'range')

{

$where_clause = $where_ids;

}

else

{

$where_ids = (is_array($where_ids)) ? array_unique($where_ids) : array($where_ids);

if (!sizeof($where_ids))

{

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

}

$where_clause = $db->sql_in_set($where_type, $where_ids);

}

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

$return = array(

'posts' => ($call_delete_posts) ? delete_posts($where_type, $where_ids, false, true, $post_count_sync, false) : 0,

);

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

FROM ' . TOPICS_TABLE . '

WHERE ' . $where_clause;

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

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

{

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

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

if ($row['topic_approved'] && !$row['topic_moved_id'])

{

$approved_topics++;

}

}

$db->sql_freeresult($result);

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

if (!sizeof($topic_ids))

{

return $return;

}

$db->sql_transaction('begin');

$table_ary = array(BOOKMARKS_TABLE, TOPICS_TRACK_TABLE, TOPICS_POSTED_TABLE, POLL_VOTES_TABLE, POLL_OPTIONS_TABLE, TOPICS_WATCH_TABLE, TOPICS_TABLE);

foreach ($table_ary as $table)

{

$sql = "DELETE FROM $table

WHERE " . $db->sql_in_set('topic_id', $topic_ids);

$db->sql_query($sql);

}

unset($table_ary);

$moved_topic_ids = array();

// update the other forums

$sql = 'SELECT topic_id, forum_id

FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set('topic_moved_id', $topic_ids);

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

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

{

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

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

}

$db->sql_freeresult($result);

if (sizeof($moved_topic_ids))

{

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set('topic_id', $moved_topic_ids);

$db->sql_query($sql);

}

$db->sql_transaction('commit');

if ($auto_sync)

{

sync('forum', 'forum_id', array_unique($forum_ids), true, true);

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

}

if ($approved_topics)

{

set_config_count('num_topics', $approved_topics * (-1), true);

}

return $return;

{

global $db, $config, $phpbb_root_path, $phpEx, $auth, $user;

if ($where_type === 'range')

{

$where_clause = $where_ids;

}

else

{

if (is_array($where_ids))

{

$where_ids = array_unique($where_ids);

}

else

{

$where_ids = array($where_ids);

}

if (!sizeof($where_ids))

{

return false;

}

$where_ids = array_map('intval', $where_ids);

$where_clause = $db->sql_in_set($where_type, $where_ids);

}

$approved_posts = 0;

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

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

FROM ' . POSTS_TABLE . '

WHERE ' . $where_clause;

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

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

{

$post_ids[] = (int) $row['post_id'];

$poster_ids[] = (int) $row['poster_id'];

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

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

if ($row['post_postcount'] && $post_count_sync && $row['post_approved'])

{

$post_counts[$row['poster_id']] = (!empty($post_counts[$row['poster_id']])) ? $post_counts[$row['poster_id']] + 1 : 1;

}

if ($row['post_approved'])

{

$approved_posts++;

}

}

$db->sql_freeresult($result);

if (!sizeof($post_ids))

{

return false;

}

$db->sql_transaction('begin');

$table_ary = array(POSTS_TABLE, REPORTS_TABLE);

foreach ($table_ary as $table)

{

$sql = "DELETE FROM $table

WHERE " . $db->sql_in_set('post_id', $post_ids);

$db->sql_query($sql);

}

unset($table_ary);

// Adjust users post counts

if (sizeof($post_counts) && $post_count_sync)

{

foreach ($post_counts as $poster_id => $substract)

{

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = ' . $poster_id . '

AND user_posts < ' . $substract;

$db->sql_query($sql);

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_posts = user_posts - ' . $substract . '

WHERE user_id = ' . $poster_id . '

AND user_posts >= ' . $substract;

$db->sql_query($sql);

}

}

// Remove topics now having no posts?

if (sizeof($topic_ids))

{

$sql = 'SELECT topic_id

FROM ' . POSTS_TABLE . '

WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '

GROUP BY topic_id';

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

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

{

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

}

$db->sql_freeresult($result);

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

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

}

// Remove the message from the search index

$search_type = $config['search_type'];

if (!class_exists($search_type))

{

trigger_error('NO_SUCH_SEARCH_MODULE');

}

$error = false;

$search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

if ($error)

{

trigger_error($error);

}

$search->index_remove($post_ids, $poster_ids, $forum_ids);

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

$db->sql_transaction('commit');

// Resync topics_posted table

if ($posted_sync)

{

update_posted_info($topic_ids);

}

if ($auto_sync)

{

sync('topic_reported', 'topic_id', $topic_ids);

sync('topic', 'topic_id', $topic_ids, true);

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

}

if ($approved_posts)

{

set_config_count('num_posts', $approved_posts * (-1), true);

}

// We actually remove topics now to not be inconsistent (the delete_topics function calls this function too)

if (sizeof($remove_topics) && $call_delete_topics)

{

delete_topics('topic_id', $remove_topics, $auto_sync, $post_count_sync, false);

}

return sizeof($post_ids);

{

global $db, $config;

// 0 is as bad as an empty array

if (empty($ids))

{

return false;

}

if (is_array($ids))

{

$ids = array_unique($ids);

$ids = array_map('intval', $ids);

}

else

{

$ids = array((int) $ids);

}

$sql_where = '';

switch ($mode)

{

case 'post':

case 'message':

$sql_id = 'post_msg_id';

$sql_where = ' AND in_message = ' . ($mode == 'message' ? 1 : 0);

break;

case 'topic':

$sql_id = 'topic_id';

break;

case 'user':

$sql_id = 'poster_id';

break;

case 'attach':

default:

$sql_id = 'attach_id';

$mode = 'attach';

break;

}

$post_ids = $message_ids = $topic_ids = $physical = array();

// Collect post and topic ids for later use if we need to touch remaining entries (if resync is enabled)

$sql = 'SELECT post_msg_id, topic_id, in_message, physical_filename, thumbnail, filesize, is_orphan

FROM ' . ATTACHMENTS_TABLE . '

WHERE ' . $db->sql_in_set($sql_id, $ids);

$sql .= $sql_where;

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

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

{

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

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

{

if (!$row['in_message'])

{

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

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

}

else

{

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

}

}

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

}

$db->sql_freeresult($result);

// Delete attachments

$sql = 'DELETE FROM ' . ATTACHMENTS_TABLE . '

WHERE ' . $db->sql_in_set($sql_id, $ids);

$sql .= $sql_where;

$db->sql_query($sql);

$num_deleted = $db->sql_affectedrows();

if (!$num_deleted)

{

return 0;

}

// Delete attachments from filesystem

$space_removed = $files_removed = 0;

foreach ($physical as $file_ary)

{

if (phpbb_unlink($file_ary['filename'], 'file', true) && !$file_ary['is_orphan'])

{