*/

function make_forum_select($select_id = false, $ignore_id = false, $ignore_acl = false, $ignore_nonpost = false, $ignore_emptycat = true, $only_acl_post = false, $return_array = false)

{

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

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"

{

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

{

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

}

}

return $forum_list;

}

*/

function get_forum_list($acl_list = 'f_list', $id_only = true, $postable_only = false, $no_cache = false)

{

static $forum_rows;

if (!isset($forum_rows))

}

}

return $rowset;

}

*/

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

{

if (!is_array($post_ids))

{

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

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

$db->sql_query($sql);

if ($auto_sync)

{

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

'notification.type.quote',

'notification.type.approve_post',

'notification.type.post_in_queue',

);

/**

$table_ary = array(POSTS_TABLE, REPORTS_TABLE);

foreach ($table_ary as $table)

{

$sql = "DELETE FROM $table

*/

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

{

// 0 is as bad as an empty array

if (empty($ids))

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

}

$db->sql_freeresult($result);

// Delete attachments

$sql = 'DELETE FROM ' . ATTACHMENTS_TABLE . '

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

$db->sql_query($sql);

$num_deleted = $db->sql_affectedrows();

if (!$num_deleted)

{

return 0;

}

}

if ($space_removed || $files_removed)

{

set_config_count('upload_dir_size', $space_removed * (-1), true);

/**

* Prune function

*/

{

global $db, $phpbb_dispatcher;

* @var int prune_flags The prune flags

* @var bool auto_sync Whether or not to perform auto sync

* @var string sql_and SQL text appended to where clause

* @since 3.1.3-RC1

*/

extract($phpbb_dispatcher->trigger_event('core.prune_sql', compact($vars)));

$sql = 'SELECT topic_id

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

AND poll_start = 0

$sql_and";

$topic_list = array();

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

AND poll_start > 0

AND poll_last_vote < $prune_date

$sql_and";

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

{

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

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

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

}

{

$version = $row['mysql_version'];

{

$sql = 'SHOW TABLE STATUS

FROM ' . $db_name;

$database_size = 0;

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

{

{

if ($table_prefix != '')

{

*/

function add_permission_language()

{

// add permission language files from extensions

$finder = $phpbb_extension_manager->get_finder();

->prefix('permissions_')

->suffix(".$phpEx")

->core_path('language/' . $user->lang_name . '/')

->extension_directory('/language/' . $user->lang_name)

->find();

foreach ($lang_files as $lang_file => $ext_name)

{

if ($ext_name === '/')