FROM ' . EXTENSION_GROUPS_TABLE . '

WHERE cat_id > 0

ORDER BY cat_id';

$s_assigned_groups = array();

{

$s_assigned_groups[$row['cat_id']][] = $row['group_name'];

}

$l_legend_cat_images = phpbb::$user->lang['SETTINGS_CAT_IMAGES'] . ' [' . phpbb::$user->lang['ASSIGNED_GROUP'] . ': ' . ((!empty($s_assigned_groups[ATTACHMENT_CATEGORY_IMAGE])) ? implode(', ', $s_assigned_groups[ATTACHMENT_CATEGORY_IMAGE]) : phpbb::$user->lang['NO_EXT_GROUP']) . ']';

$sql = 'SELECT *

FROM ' . SITELIST_TABLE;

$defined_ips = '';

$ips = array();

{

$value = ($row['site_ip']) ? $row['site_ip'] : $row['site_hostname'];

if ($value)

$ips[$row['site_id']] = $value;

}

}

$template->assign_vars(array(

'S_SECURE_DOWNLOADS' => $this->new_config['secure_downloads'],

$sql = 'SELECT *

FROM ' . EXTENSIONS_TABLE . '

ORDER BY extension_id';

{

if ($row['group_id'] != $extensions[$row['extension_id']]['group_id'])

{

$sql = 'UPDATE ' . EXTENSIONS_TABLE . '

SET group_id = ' . (int) $extensions[$row['extension_id']]['group_id'] . '

WHERE extension_id = ' . $row['extension_id'];

add_log('admin', 'LOG_ATTACH_EXT_UPDATE', $row['extension']);

}

}

// Delete Extension?

$extension_id_list = request_var('extension_id_list', array(0));

{

$sql = 'SELECT extension

FROM ' . EXTENSIONS_TABLE . '

$extension_list = '';

{

$extension_list .= ($extension_list == '') ? $row['extension'] : ', ' . $row['extension'];

}

$sql = 'DELETE

FROM ' . EXTENSIONS_TABLE . '

add_log('admin', 'LOG_ATTACH_EXT_DEL', $extension_list);

}

{

$sql = 'SELECT extension_id

FROM ' . EXTENSIONS_TABLE . "

{

$error[] = sprintf(phpbb::$user->lang['EXTENSION_EXIST'], $add_extension);

}

if (!sizeof($error))

{

'extension' => $add_extension

);

add_log('admin', 'LOG_ATTACH_EXT_ADD', $add_extension);

}

}

$sql = 'SELECT *

FROM ' . EXTENSIONS_TABLE . '

ORDER BY group_id, extension';

{

$old_group_id = $row['group_id'];

do

'GROUP_OPTIONS' => $this->group_select('group_select[]', $row['group_id']))

);

}

}

break;

$sql = 'SELECT *

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

if (!$ext_row)

{

{

$sql = 'SELECT group_name

FROM ' . EXTENSION_GROUPS_TABLE;

$clean_group_name = utf8_clean_string($new_group_name);

{

if (utf8_clean_string($row['group_name']) === $clean_group_name)

{

break;

}

}

}

if (!sizeof($error))

// @TODO: rewrite with the new param db functions

$sql = ($action == 'add') ? 'INSERT INTO ' . EXTENSION_GROUPS_TABLE . ' ' : 'UPDATE ' . EXTENSION_GROUPS_TABLE . ' SET ';

$sql .= ($action == 'edit') ? " WHERE group_id = $group_id" : '';

if ($action == 'add')

{

}

add_log('admin', 'LOG_ATTACH_EXTGROUP_' . strtoupper($action), $group_name);

$sql = 'UPDATE ' . EXTENSIONS_TABLE . "

SET group_id = 0

WHERE group_id = $group_id";

}

if (sizeof($extension_list))

{

$sql = 'UPDATE ' . EXTENSIONS_TABLE . "

SET group_id = $group_id

}

phpbb::$acm->destroy('extensions');

$sql = 'SELECT group_name

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

$sql = 'DELETE

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

// Set corresponding Extensions to a pending Group

$sql = 'UPDATE ' . EXTENSIONS_TABLE . "

SET group_id = 0

WHERE group_id = $group_id";

add_log('admin', 'LOG_ATTACH_EXTGROUP_DEL', $group_name);

$sql = 'SELECT *

FROM ' . EXTENSION_GROUPS_TABLE . "

WHERE group_id = $group_id";

$forum_ids = (!$ext_group_row['allowed_forums']) ? array() : unserialize(trim($ext_group_row['allowed_forums']));

WHERE group_id = $group_id

OR group_id = 0

ORDER BY extension";

if ($ext_group_row['max_filesize'] == 0)

{

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

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

$right = $cat_right = $padding_inc = 0;

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

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

{

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

{

$s_forum_id_options .= $holding;

}

unset($padding_store);

$template->assign_vars(array(

$sql = 'SELECT *

FROM ' . EXTENSION_GROUPS_TABLE . '

ORDER BY allow_group DESC, allow_in_pm DESC, group_name';

$old_allow_group = $old_allow_pm = 1;

{

$s_add_spacer = ($old_allow_group != $row['allow_group'] || $old_allow_pm != $row['allow_in_pm']) ? true : false;

$old_allow_group = $row['allow_group'];

$old_allow_pm = $row['allow_in_pm'];

}

break;

{

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

AND is_orphan = 1';

$delete_files = array();

{

phpbb_unlink($row['physical_filename'], 'file');

$delete_files[$row['attach_id']] = $row['real_filename'];

}

}

if (sizeof($delete_files))

{

$sql = 'DELETE FROM ' . ATTACHMENTS_TABLE . '

add_log('admin', 'LOG_ATTACH_ORPHAN_DEL', implode(', ', $delete_files));

$notify[] = sprintf(phpbb::$user->lang['LOG_ATTACH_ORPHAN_DEL'], implode(', ', $delete_files));

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE;

$forum_names = array();

{

$forum_names[$row['forum_id']] = $row['forum_name'];

}

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

FROM ' . POSTS_TABLE . '

$post_info = array();

{

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

}

// Select those attachments we want to change...

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

AND is_orphan = 1';

$files_added = $space_taken = 0;

{

$post_row = $post_info[$upload_list[$row['attach_id']]];

);

$sql = 'UPDATE ' . ATTACHMENTS_TABLE . '

WHERE attach_id = ' . $row['attach_id'];

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_attachment = 1

WHERE post_id = ' . $post_row['post_id'];

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_attachment = 1

WHERE topic_id = ' . $post_row['topic_id'];

$space_taken += $row['filesize'];

$files_added++;

add_log('admin', 'LOG_ATTACH_FILEUPLOAD', $post_row['post_id'], $row['real_filename']);

}

if ($files_added)

{

WHERE is_orphan = 1

AND filetime < ' . (time() - 3*60*60) . '

ORDER BY filetime DESC';

{

$template->assign_block_vars('orphan', array(

'FILESIZE' => get_formatted_filesize($row['filesize']),

'U_FILE' => append_sid('download/file', 'mode=view&amp;id=' . $row['attach_id']))

);

}

break;

}

$sql = 'SELECT cat_id

FROM ' . EXTENSION_GROUPS_TABLE . '

WHERE group_id = ' . (int) $group_id;

}

else

{

$sql = 'SELECT group_id, group_name

FROM ' . EXTENSION_GROUPS_TABLE . '

ORDER BY group_name';

$group_name = array();

{

$group_name[] = $row;

}

$row['group_id'] = 0;

$row['group_name'] = phpbb::$user->lang['NOT_ASSIGNED'];

$sql = 'SELECT site_ip, site_hostname

FROM ' . SITELIST_TABLE . "

WHERE ip_exclude = $ip_exclude";

{

$iplist_tmp = array();

$hostlist_tmp = array();

}

// break;

}

$iplist = array_unique(array_diff($iplist, $iplist_tmp));

$hostlist = array_unique(array_diff($hostlist, $hostlist_tmp));

unset($iplist_tmp);

unset($hostlist_tmp);

}

if (sizeof($iplist))

{

{

$sql = 'INSERT INTO ' . SITELIST_TABLE . " (site_ip, ip_exclude)

VALUES ($ip_entry, $ip_exclude)";

}

}

{

$sql = 'INSERT INTO ' . SITELIST_TABLE . " (site_hostname, ip_exclude)

VALUES ($host_entry, $ip_exclude)";

}

}

// Grab details of ips for logging information later

$sql = 'SELECT site_ip, site_hostname

FROM ' . SITELIST_TABLE . '

{

$l_unip_list .= (($l_unip_list != '') ? ', ' : '') . (($row['site_ip']) ? $row['site_ip'] : $row['site_hostname']);

}

$sql = 'DELETE FROM ' . SITELIST_TABLE . '

add_log('admin', 'LOG_DOWNLOAD_REMOVE_IP', $l_unip_list);

}

AND ban_email <> ''";

break;

}

$banned_options = '';

$ban_length = $ban_reasons = $ban_give_reasons = array();

{

$banned_options .= '<option' . (($row['ban_exclude']) ? ' class="sep"' : '') . ' value="' . $row['ban_id'] . '">' . $row[$field] . '</option>';

$ban_reasons[$row['ban_id']] = $row['ban_reason'];

$ban_give_reasons[$row['ban_id']] = $row['ban_give_reason'];

}

if (sizeof($ban_length))

{

$sql = 'SELECT bbcode_match, bbcode_tpl, display_on_posting, bbcode_helpline

FROM ' . BBCODES_TABLE . '

WHERE bbcode_id = ' . $bbcode_id;

if (!$row)

{

$sql = 'SELECT bbcode_id, bbcode_tag

FROM ' . BBCODES_TABLE . '

WHERE bbcode_id = ' . $bbcode_id;

if (!$row)

{

{

$sql = 'SELECT 1 as test

FROM ' . BBCODES_TABLE . "

// Grab the end, interrogate the last closing tag

if ($info['test'] === '1' || in_array(strtolower($data['bbcode_tag']), $hard_coded) || (preg_match('#\[/([^[]*)]$#', $bbcode_match, $regs) && in_array(strtolower($regs[1]), $hard_coded)))

{

$sql = 'SELECT MAX(bbcode_id) as max_bbcode_id

FROM ' . BBCODES_TABLE;

if ($row)

{

$sql_ary['bbcode_id'] = (int) $bbcode_id;

phpbb::$acm->destroy_sql(BBCODES_TABLE);

$lang = 'BBCODE_ADDED';

else

{

$sql = 'UPDATE ' . BBCODES_TABLE . '

WHERE bbcode_id = ' . $bbcode_id;

phpbb::$acm->destroy_sql(BBCODES_TABLE);

$lang = 'BBCODE_EDITED';

$sql = 'SELECT bbcode_tag

FROM ' . BBCODES_TABLE . "

WHERE bbcode_id = $bbcode_id";

if ($row)

{

if (confirm_box(true))

{

phpbb::$acm->destroy_sql(BBCODES_TABLE);

add_log('admin', 'LOG_BBCODE_DELETE', $row['bbcode_tag']);

}

$sql = 'SELECT *

FROM ' . BBCODES_TABLE . '

ORDER BY bbcode_tag';

{

$template->assign_block_vars('bbcodes', array(

'BBCODE_TAG' => $row['bbcode_tag'],

'U_DELETE' => $this->u_action . '&amp;action=delete&amp;bbcode=' . $row['bbcode_id'])

);

}

}

/*

$sql = 'UPDATE ' . BOTS_TABLE . "

SET bot_active = 1

WHERE bot_id $sql_id";

}

phpbb::$acm->destroy('bots');

$sql = 'UPDATE ' . BOTS_TABLE . "

SET bot_active = 0

WHERE bot_id $sql_id";

}

phpbb::$acm->destroy('bots');

$sql = 'SELECT bot_name, user_id

FROM ' . BOTS_TABLE . "

WHERE bot_id $sql_id";

$user_id_ary = $bot_name_ary = array();

{

$user_id_ary[] = (int) $row['user_id'];

$bot_name_ary[] = $row['bot_name'];

}

$sql = 'DELETE FROM ' . BOTS_TABLE . "

WHERE bot_id $sql_id";

if (sizeof($user_id_ary))

{

foreach ($_tables as $table)

{

$sql = "DELETE FROM $table

}

}

phpbb::$acm->destroy('bots');

FROM ' . BOTS_TABLE . ' b, ' . USERS_TABLE . " u

WHERE b.bot_id = $bot_id

AND u.user_id = b.user_id";

if (!$bot_row)

{

FROM ' . GROUPS_TABLE . "

WHERE group_name_clean = 'bots'

AND group_type = " . GROUP_SPECIAL;

if (!$group_row)

{

'user_allow_massemail' => 0,

));

'user_id' => (int) $user_id,

'bot_name' => (string) $bot_row['bot_name'],

'bot_active' => (int) $bot_row['bot_active'],

'bot_agent' => (string) $bot_row['bot_agent'],

'bot_ip' => (string) $bot_row['bot_ip'])

);

$log = 'ADDED';

}

$sql = 'SELECT user_id, bot_name

FROM ' . BOTS_TABLE . "

WHERE bot_id = $bot_id";

if (!$row)

{

$sql_ary['username_clean'] = (string) utf8_clean_string($bot_row['bot_name']);

}

'bot_name' => (string) $bot_row['bot_name'],

'bot_active' => (int) $bot_row['bot_active'],

'bot_agent' => (string) $bot_row['bot_agent'],

'bot_ip' => (string) $bot_row['bot_ip'])

) . " WHERE bot_id = $bot_id";

// Updated username?

if ($bot_row['bot_name'] !== $row['bot_name'])

FROM ' . BOTS_TABLE . ' b, ' . USERS_TABLE . " u

WHERE b.bot_id = $bot_id

AND u.user_id = b.user_id";

if (!$bot_row)

{

FROM ' . BOTS_TABLE . ' b, ' . USERS_TABLE . ' u

WHERE u.user_id = b.user_id

ORDER BY u.user_lastvisit DESC, b.bot_name ASC';

{

$active_lang = (!$row['bot_active']) ? 'BOT_ACTIVATE' : 'BOT_DEACTIVATE';

$active_value = (!$row['bot_active']) ? 'activate' : 'deactivate';

'U_DELETE' => $this->u_action . "&amp;id={$row['bot_id']}&amp;action=delete")

);

}

}

/**

// Admins might want to use names otherwise forbidden, thus we only check for duplicates.

$sql = 'SELECT username

FROM ' . USERS_TABLE . "

return ($row) ? false : true;

}

$time = time();

$filename = 'backup_' . $time . '_' . unique_id();

{

case 'mysql':

$extractor = new mysql_extractor($download, $store, $format, $filename, $time);

else

{

// We might wanna empty out all that junk :D

{

case 'sqlite':

case 'firebird':

break;

}

{

case 'mysql':

case 'sqlite':

case 'db2':

while (($sql = $fgetd($fp, ";\n", $read, $seek, $eof)) !== false)

{

}

break;

$delim = $query[9] . "\n";

continue;

}

}

break;

$sql = "SELECT domain_name

FROM information_schema.domains

WHERE domain_name = '$domain';";

{

}

}

else

{

}

if (substr($query, 0, 4) == 'COPY')

{

trigger_error(phpbb::$user->lang['RESTORE_FAILURE'] . adm_back_link($this->u_action), E_USER_WARNING);

}

}

}

}

break;

case 'oracle':

while (($sql = $fgetd($fp, "/\n", $read, $seek, $eof)) !== false)

{

}

break;

case 'mssql':

while (($sql = $fgetd($fp, "GO\n", $read, $seek, $eof)) !== false)

{

}

break;

}

function write_table($table_name)

{

$sql = 'SHOW CREATE TABLE ' . $table_name;

$sql_data = '# Table: ' . $table_name . "\n";

$sql_data .= "DROP TABLE IF EXISTS $table_name;\n";

$this->flush($sql_data . $row['Create Table'] . ";\n\n");

}

function write_data($table_name)

{

{

$this->write_data_mysqli($table_name);

}

{

$sql = "SELECT *

FROM $table_name";

if ($result != false)

{

$fields_cnt = mysqli_num_fields($result);

{

$sql = "SELECT *

FROM $table_name";

if ($result != false)

{

$sql = "SELECT sql

FROM sqlite_master

WHERE type = 'table'

ORDER BY type DESC, name;";

// Create Table

$sql_data .= $row['sql'] . ";\n";

$ar = array();

{

$ar[] = $row;

}

foreach ($ar as $value)

{

continue;

}

$fields = array();

{

$fields[] = $row['name'];

}

$sql_data .= 'CREATE ' . ($value['unique'] ? 'UNIQUE ' : '') . 'INDEX ' . $value['name'] . ' on ' . $table_name . ' (' . implode(', ', $fields) . ");\n";

}

if ($proper)

{

}

else

{

FROM sqlite_master

WHERE type = 'table'

AND name = '" . $table_name . "'";

$table_data = preg_replace('#CREATE\s+TABLE\s+"?' . $table_name . '"?#i', '', $table_data);

$table_data = trim($table_data);

$sql = "SELECT *

FROM $table_name";

$rows = sqlite_fetch_all($result, SQLITE_ASSOC);

$sql_insert = 'INSERT INTO ' . $table_name . ' (' . implode(', ', array_keys($col_types)) . ') VALUES (';

foreach ($rows as $row)

FROM INFORMATION_SCHEMA.domains a, INFORMATION_SCHEMA.column_domain_usage b

WHERE a.domain_name = b.domain_name

AND b.table_name = '{$table_name}'";

{

if (empty($domains_created[$row['domain_name']]))

{

FROM pg_class

WHERE relkind = 'S'

AND relname = '{$table_name}_seq'";

// We don't even care about storing the results. We already know the answer if we get rows back.

{

$sql_data .= "DROP SEQUENCE {$table_name}_seq;\n";

$sql_data .= "CREATE SEQUENCE {$table_name}_seq;\n";

}

$field_query = "SELECT a.attnum, a.attname as field, t.typname as type, a.attlen as length, a.atttypmod as lengthvar, a.attnotnull as notnull

FROM pg_class c, pg_attribute a, pg_type t

AND a.attnum > 0

AND a.attrelid = c.oid

AND a.atttypid = t.oid

ORDER BY a.attnum";

$sql_data .= "CREATE TABLE $table_name(\n";

$lines = array();

{

// Get the data from the table

$sql_get_default = "SELECT pg_get_expr(d.adbin, d.adrelid) as rowdefault

FROM pg_attrdef d, pg_class c

AND (c.oid = d.adrelid)

AND d.adnum = " . $row['attnum'];

if (!$def_res)

{

}

else

{

}

if ($row['type'] == 'bpchar')

{

$lines[] = $line;

}

// Get the listing of primary keys.

AND (ic.oid = i.indexrelid)

AND (ia.attrelid = i.indexrelid)

AND (ta.attrelid = bc.oid)

AND (ta.attrelid = i.indrelid)

AND (ta.attnum = i.indkey[ia.attnum-1])

ORDER BY index_name, tab_name, column_name";

$index_create = $index_rows = $primary_key = array();

// We do this in two steps. It makes placing the comma easier

{

if ($row['primary_key'] == 't')

{

$index_rows[$row['index_name']]['column_names'][] = $row['column_name'];

}

}

if (!empty($index_rows))

{

$sql_checks = "SELECT conname as index_name, consrc

FROM pg_constraint, pg_class bc

WHERE conrelid = bc.oid

AND NOT EXISTS (

SELECT *

FROM pg_constraint as c, pg_inherits as i

AND c.consrc = pg_constraint.consrc

AND c.conrelid = i.inhparent

)";

// Add the constraints to the sql file.

{

if (!is_null($row['consrc']))

{

$lines[] = ' CONSTRAINT ' . $row['index_name'] . ' CHECK ' . $row['consrc'];

}

}

$sql_data .= implode(", \n", $lines);

$sql_data .= "\n);\n";

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

$i_num_fields = pg_num_fields($result);

$seq = '';

WHERE (c.relname = '{$table_name}')

AND (c.oid = d.adrelid)

AND d.adnum = " . strval($i + 1);

{

// Determine if we must reset the sequences

if (strpos($row['rowdefault'], "nextval('") === 0)

}

$this->flush("COPY $table_name (" . implode(', ', $ary_name) . ') FROM stdin;' . "\n");

{

$schema_vals = array();

// into a valid sql statement to recreate that field in the data.

$this->flush(implode("\t", $schema_vals) . "\n");

}

$this->flush("\\.\n");

// Write out the sequence statements

$sql = "SELECT COLUMN_NAME, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') as IS_IDENTITY

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = '$table_name'";

{

$line = "\t[{$row['COLUMN_NAME']}] [{$row['DATA_TYPE']}]";

$rows[] = $line;

}

$sql_data .= implode(",\n", $rows);

$sql_data .= "\n) ON [PRIMARY]";

$sql = "SELECT CONSTRAINT_NAME, COLUMN_NAME

FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE

WHERE TABLE_NAME = '$table_name'";

{

if (!sizeof($rows))

{

$sql_data .= implode(",\n", $rows);

$sql_data .= "\n\t) ON [PRIMARY] \nGO\n";

}

$index = array();

$sql = "EXEC sp_statistics '$table_name'";

{

if ($row['TYPE'] == 3)

{

$index[$row['INDEX_NAME']][] = '[' . $row['COLUMN_NAME'] . ']';

}

}

foreach ($index as $index_name => $column_name)

{

function write_data($table_name)

{

{

$this->write_data_mssql($table_name);

}

{

$this->write_data_odbc($table_name);

}

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

$retrieved_data = mssql_num_rows($result);

$sql = "SELECT 1 as has_identity

FROM INFORMATION_SCHEMA.COLUMNS

WHERE COLUMNPROPERTY(object_id('$table_name'), COLUMN_NAME, 'IsIdentity') = 1";

if (!empty($row2['has_identity']))

{

$sql_data .= "\nSET IDENTITY_INSERT $table_name ON\nGO\n";

$ident_set = true;

}

}

{

$schema_vals = $schema_fields = array();

$this->flush($sql_data);

$sql_data = '';

}

if ($retrieved_data && $ident_set)

{

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

$retrieved_data = odbc_num_rows($result);

$sql = "SELECT 1 as has_identity

FROM INFORMATION_SCHEMA.COLUMNS

WHERE COLUMNPROPERTY(object_id('$table_name'), COLUMN_NAME, 'IsIdentity') = 1";

if (!empty($row2['has_identity']))

{

$sql_data .= "\nSET IDENTITY_INSERT $table_name ON\nGO\n";

$ident_set = true;

}

}

$i_num_fields = odbc_num_fields($result);

$ary_name[$i] = odbc_field_name($result, $i + 1);

}

{

$schema_vals = $schema_fields = array();

$sql_data = '';

}

if ($retrieved_data && $ident_set)

{

$sql = "SELECT colname, typename, length, default, identity, nulls

FROM syscat.columns

WHERE tabname = '$table_name'";

{

$line = "\t{$row['colname']} {$row['typename']}";

$rows[] = $line;

}

// switch to db2_columns()?

$sql = "SELECT colname

FROM SYSCAT.KEYCOLUSE

WHERE tabname = '$table_name'";

$prim_cols = array();

{

$prim_cols[] = $row['colname'];

}

if (sizeof($prim_cols))

{

$rows[] = "\tPRIMARY KEY (" . implode($prim_cols) . ')';

FROM SYSCAT.INDEXES

WHERE TABNAME = '$table_name'

AND UNIQUERULE <> 'P'";

$index = array();

{

$inds = explode('+', $row['colnames']);

unset($inds[0]);

$sql_data .= 'CREATE INDEX ' . $row['indname'] . ' ON ' . $table_name . ' (' . implode(', ', $inds) . ") PCTFREE 10 MINPCTUSED 10 ALLOW REVERSE SCANS PAGE SPLIT SYMMETRIC COLLECT SAMPLED DETAILED STATISTICS;\n";

}

$this->flush($sql_data);

}

function write_data($table_name)

{

$ary_type = $ary_name = array();

$i = 0;

{

$ary_type[$i] = $row['type_name'];

$ary_name[$i++] = strtolower($row['column_name']);

}

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

$sql_data = '';

$i_num_fields = $i;

{

$schema_vals = $schema_fields = array();

$this->flush($sql_data);

}

}

}

$sql = "SELECT COLUMN_NAME, DATA_TYPE, DATA_PRECISION, DATA_LENGTH, NULLABLE, DATA_DEFAULT

FROM ALL_TAB_COLS

WHERE table_name = '{$table_name}'";

$rows = array();

{

$line = ' "' . $row['column_name'] . '" ' . $row['data_type'];

}

$rows[] = $line;

}

$sql = "SELECT A.CONSTRAINT_NAME, A.COLUMN_NAME

FROM USER_CONS_COLUMNS A, USER_CONSTRAINTS B

WHERE A.CONSTRAINT_NAME = B.CONSTRAINT_NAME

AND B.CONSTRAINT_TYPE = 'P'

AND A.TABLE_NAME = '{$table_name}'";

{

$rows[] = " CONSTRAINT {$row['constraint_name']} PRIMARY KEY ({$row['column_name']})";

}

$sql = "SELECT A.CONSTRAINT_NAME, A.COLUMN_NAME

FROM USER_CONS_COLUMNS A, USER_CONSTRAINTS B

WHERE A.CONSTRAINT_NAME = B.CONSTRAINT_NAME

AND B.CONSTRAINT_TYPE = 'U'

AND A.TABLE_NAME = '{$table_name}'";

{

$rows[] = " CONSTRAINT {$row['constraint_name']} UNIQUE ({$row['column_name']})";

}

$sql_data .= implode(",\n", $rows);

$sql_data .= "\n)\n\\";

WHERE A.REFERENCED_TYPE = 'SEQUENCE'

AND A.NAME = B.TRIGGER_NAME

AND B.TABLE_NAME = '{$table_name}'";

{

$sql_data .= "\nCREATE SEQUENCE {$row['referenced_name']}\\\n";

}

$sql = "SELECT DESCRIPTION, WHEN_CLAUSE, TRIGGER_BODY

FROM USER_TRIGGERS

WHERE TABLE_NAME = '{$table_name}'";

{

$sql_data .= "\nCREATE OR REPLACE TRIGGER {$row['description']}WHEN ({$row['when_clause']})\n{$row['trigger_body']}\\";

}

$sql = "SELECT A.INDEX_NAME, B.COLUMN_NAME

FROM USER_INDEXES A, USER_IND_COLUMNS B

WHERE A.UNIQUENESS = 'NONUNIQUE'

AND A.INDEX_NAME = B.INDEX_NAME

AND B.TABLE_NAME = '{$table_name}'";

$index = array();

{

$index[$row['index_name']][] = $row['column_name'];

}

{

$sql_data .= "\nCREATE INDEX $index_name ON $table_name(" . implode(', ', $column_names) . ")\n\\";

}

$this->flush($sql_data);

}

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

$i_num_fields = ocinumcols($result);

$sql_data = '';

{

$schema_vals = $schema_fields = array();

$this->flush($sql_data);

}

}

function write_start($prefix)

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

$i_num_fields = ibase_num_fields($result);

$ary_name[$i] = $info['name'];

}

{

$schema_vals = $schema_fields = array();

$this->flush($sql_data);

}

}

function write_table($table_name)

WHERE F.RDB$SYSTEM_FLAG = 0

AND R.RDB$RELATION_NAME = \''. $table_name . '\'

ORDER BY R.RDB$FIELD_POSITION';

$rows = array();

{

$line = "\t" . '"' . $row['fname'] . '" ' . $data_types[$row['ftype']];

}

$rows[] = $line;

}

$sql_data .= implode(",\n", $rows);

$sql_data .= "\n);\n";

AND (IDX.RDB$INDEX_NAME = RC.RDB$INDEX_NAME)

AND (RC.RDB$RELATION_NAME = \''. $table_name . '\')

ORDER BY I.RDB$FIELD_POSITION';

{

$keys[] = $row['name'];

}

$sql_data .= "\nALTER TABLE $table_name ADD PRIMARY KEY (" . implode(', ', $keys) . ');';

}

$sql = 'SELECT I.RDB$INDEX_NAME as INAME, I.RDB$UNIQUE_FLAG as UFLAG, S.RDB$FIELD_NAME as FNAME

FROM RDB$INDICES I JOIN RDB$INDEX_SEGMENTS S ON S.RDB$INDEX_NAME=I.RDB$INDEX_NAME

AND I.RDB$RELATION_NAME = \''. $table_name . '\'

AND I.RDB$INDEX_NAME NOT STARTING WITH \'RDB$\'

ORDER BY S.RDB$FIELD_POSITION';

$index = array();

{

$index[$row['iname']]['unique'] = !empty($row['uflag']);

$index[$row['iname']]['values'][] = $row['fname'];

}

$sql_data .= "\n";

$sql = 'SELECT D1.RDB$DEPENDENT_NAME as DNAME, D1.RDB$FIELD_NAME as FNAME, D1.RDB$DEPENDENT_TYPE, R1.RDB$RELATION_NAME

FROM RDB$DEPENDENCIES D1

AND (D2.RDB$DEPENDENT_NAME = F2.RDB$FIELD_SOURCE)

AND (D2.RDB$DEPENDED_ON_NAME = \'' . $table_name . '\')

ORDER BY 1, 2';

{

$sql = 'SELECT T1.RDB$DEPENDED_ON_NAME as GEN, T1.RDB$FIELD_NAME, T1.RDB$DEPENDED_ON_TYPE

FROM RDB$DEPENDENCIES T1

AND (D.RDB$DEPENDENT_NAME = F.RDB$FIELD_SOURCE)

AND (F.RDB$RELATION_NAME = \'' . $row['dname'] . '\')

ORDER BY 1,2';

$gen_name = $row2['gen'];

$sql_data .= "\nDROP GENERATOR " . $gen_name . ";";

$this->flush($sql_data);

}

}

trigger_error(phpbb::$user->lang['NO_USERNAME_SPECIFIED'] . adm_back_link($this->u_action), E_USER_WARNING);

}

phpbb::$acm->destroy('disallowed_usernames');

$sql = 'DELETE FROM ' . DISALLOW_TABLE . '

WHERE disallow_id = ' . $disallowed_id;

phpbb::$acm->destroy('disallowed_usernames');

// Grab the current list of disallowed usernames...

$sql = 'SELECT *

FROM ' . DISALLOW_TABLE;

$disallow_select = '';

{

$disallow_select .= '<option value="' . $row['disallow_id'] . '">' . str_replace('%', '*', $row['disallow_username']) . '</option>';

}

$template->assign_vars(array(

'U_ACTION' => $this->u_action,

// If giving usernames the admin is able to email inactive users too...

$sql = 'SELECT username, user_email, user_jabber, user_notify_type, user_lang

FROM ' . USERS_TABLE . '

AND user_allow_massemail = 1

ORDER BY user_lang, user_notify_type'; // , SUBSTRING(user_email FROM INSTR(user_email, '@'))

}

ORDER BY user_lang, user_notify_type';

}

}

if (!$row)

{

trigger_error(phpbb::$user->lang['NO_USER'] . adm_back_link($this->u_action), E_USER_WARNING);

}

$i++;

}

}

// Send the messages

include_once(PHPBB_ROOT_PATH . 'includes/functions_messenger.' . PHP_EXT);

$sql = 'SELECT group_id

FROM ' . GROUPS_TABLE . "

WHERE group_name_clean IN ('bots', 'guests')";

$exclude = array();

{

$exclude[] = $row['group_id'];

}

$select_list = '<option value="0"' . ((!$group_id) ? ' selected="selected"' : '') . '>' . phpbb::$user->lang['ALL_USERS'] . '</option>';

$select_list .= group_select_options($group_id, $exclude);

{

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . '

WHERE forum_id = ' . (int) $forum_data['forum_id'];

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '

WHERE forum_id = ' . (int) $forum_data['forum_id'];

}

// From the mysql documentation:

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

FROM ' . ACL_USERS_TABLE . '

WHERE forum_id = ' . $forum_perm_from;

$users_sql_ary = array();

{

$users_sql_ary[] = array(

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

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

);

}

// Copy permisisons from/to the acl groups table (only forum_id gets changed)

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

FROM ' . ACL_GROUPS_TABLE . '

WHERE forum_id = ' . $forum_perm_from;

$groups_sql_ary = array();

{

$groups_sql_ary[] = array(

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

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

);

}

// Now insert the data

cache_moderators();

}

$sql = 'SELECT *

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

if (!$row)

{

$sql = 'SELECT forum_name, forum_topics_real

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

if (!$row)

{

$sql = 'SELECT MIN(topic_id) as min_topic_id, MAX(topic_id) as max_topic_id

FROM ' . TOPICS_TABLE . '

WHERE forum_id = ' . $forum_id;

// Typecast to int if there is no data available

$row2['min_topic_id'] = (int) $row2['min_topic_id'];

FROM ' . TOPICS_TABLE . '

WHERE forum_id = ' . $forum_id . '

AND topic_id BETWEEN ' . $start . ' AND ' . $end;

$start += $batch_size;

$sql = 'SELECT forum_name, forum_type

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

if (!$row)

{

FROM ' . FORUMS_TABLE . '

WHERE forum_type = ' . FORUM_POST . "

AND forum_id <> $forum_id";

{

$template->assign_vars(array(

'S_MOVE_FORUM_OPTIONS' => make_forum_select($forum_data['parent_id'], $forum_id, false, true, false))

);

}

// Subforum move options

if ($action == 'edit' && $forum_data['forum_type'] == FORUM_CAT)

FROM ' . FORUMS_TABLE . '

WHERE forum_type = ' . FORUM_POST . "

AND forum_id <> $forum_id";

{

$template->assign_vars(array(

'S_MOVE_FORUM_OPTIONS' => make_forum_select($forum_data['parent_id'], $subforums_id)) // , false, true, false???

);

}

$template->assign_vars(array(

'S_HAS_SUBFORUMS' => ($forum_data['right_id'] - $forum_data['left_id'] > 1) ? true : false,

FROM ' . FORUMS_TABLE . '

WHERE forum_type = ' . FORUM_POST . "

AND forum_id <> $forum_id";

{

$template->assign_vars(array(

'S_MOVE_FORUM_OPTIONS' => make_forum_select($forum_data['parent_id'], $subforums_id, false, true)) // , false, true, false???

);

}

$parent_id = ($this->parent_id == $forum_id) ? 0 : $this->parent_id;

FROM ' . FORUMS_TABLE . "

WHERE parent_id = $this->parent_id

ORDER BY left_id";

{

do

{

'U_SYNC' => $url . '&amp;action=sync')

);

}

}

else if ($this->parent_id)

{

'U_SYNC' => $url . '&amp;action=sync')

);

}

$template->assign_vars(array(

'ERROR_MSG' => (sizeof($errors)) ? implode('<br />', $errors) : '',

$sql = 'SELECT *

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

if (!$row)

{

$sql = 'SELECT left_id, right_id, forum_type

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $forum_data_sql['parent_id'];

if (!$row)

{

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET left_id = left_id + 2, right_id = right_id + 2

WHERE left_id > ' . $row['right_id'];

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET right_id = right_id + 2

WHERE ' . $row['left_id'] . ' BETWEEN left_id AND right_id';

$forum_data_sql['left_id'] = $row['right_id'];

$forum_data_sql['right_id'] = $row['right_id'] + 1;

{

$sql = 'SELECT MAX(right_id) AS right_id

FROM ' . FORUMS_TABLE;

$forum_data_sql['left_id'] = $row['right_id'] + 1;

$forum_data_sql['right_id'] = $row['right_id'] + 2;

}

add_log('admin', 'LOG_FORUM_ADD', $forum_data['forum_name']);

}

if (sizeof($forum_ids))

{

$sql = 'DELETE FROM ' . FORUMS_TABLE . '

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . '

// Delete forum ids from extension groups table

$sql = 'SELECT group_id, allowed_forums

FROM ' . EXTENSION_GROUPS_TABLE;

{

if (!$_row['allowed_forums'])

{

$sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . "

SET allowed_forums = '" . ((sizeof($allowed_forums)) ? serialize($allowed_forums) : '') . "'

WHERE group_id = {$_row['group_id']}";

}

phpbb::$acm->destroy('extensions');

}

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $subforums_to_id;

if (!$_row)

{

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE . "

WHERE parent_id = {$row['forum_id']}";

{

$this->move_forum($_row['forum_id'], $subforums_to_id);

}

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET parent_id = $subforums_to_id

WHERE parent_id = {$row['forum_id']}";

}

// Adjust the left/right id

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET right_id = left_id + 1

WHERE forum_id = ' . $row['forum_id'];

}

}

else if ($row['forum_type'] == FORUM_CAT && $forum_data_sql['forum_type'] == FORUM_POST)

// the forum name has changed, clear the parents list of all forums (for safety)

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET forum_parents = ''";

}

// Setting the forum id to the forum id is not really received well by some dbs. ;)

unset($forum_data_sql['forum_id']);

$sql = 'UPDATE ' . FORUMS_TABLE . '

WHERE forum_id = ' . $forum_id;

// Add it back

$forum_data['forum_id'] = $forum_id;

SET right_id = right_id - $diff, forum_parents = ''

WHERE left_id < " . $from_data['right_id'] . "

AND right_id > " . $from_data['right_id'];

// Resync righthand side of tree

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET left_id = left_id - $diff, right_id = right_id - $diff, forum_parents = ''

WHERE left_id > " . $from_data['right_id'];

if ($to_id > 0)

{

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET right_id = right_id + $diff, forum_parents = ''

WHERE " . $to_data['right_id'] . ' BETWEEN left_id AND right_id

// Resync the righthand side of the tree

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET left_id = left_id + $diff, right_id = right_id + $diff, forum_parents = ''

WHERE left_id > " . $to_data['right_id'] . '

// Resync moved branch

$to_data['right_id'] += $diff;

{

$sql = 'SELECT MAX(right_id) AS right_id

FROM ' . FORUMS_TABLE . '

$diff = '+ ' . ($row['right_id'] - $from_data['left_id'] + 1);

}

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET left_id = left_id $diff, right_id = right_id $diff, forum_parents = ''

return $errors;

}

$sql = "UPDATE $table

SET forum_id = $to_id

WHERE forum_id = $from_id";

}

unset($table_ary);

{

$sql = "DELETE FROM $table

WHERE forum_id = $from_id";

}

if ($sync)

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $posts_to_id;

if (!$row)

{

$diff = sizeof($forum_ids) * 2;

$sql = 'DELETE FROM ' . FORUMS_TABLE . '

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . '

}

else if ($action_subforums == 'move')

{

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $subforums_to_id;

if (!$row)

{

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE . "

WHERE parent_id = $forum_id";

{

$this->move_forum($row['forum_id'], $subforums_to_id);

}

// Grab new forum data for correct tree updating later

$forum_data = $this->get_forum_info($forum_id);

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET parent_id = $subforums_to_id

WHERE parent_id = $forum_id";

$diff = 2;

$sql = 'DELETE FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . "

WHERE forum_id = $forum_id";

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . "

WHERE forum_id = $forum_id";

}

}

$diff = 2;

$sql = 'DELETE FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . "

WHERE forum_id = $forum_id";

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . "

WHERE forum_id = $forum_id";

}

// Resync tree

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET right_id = right_id - $diff

WHERE left_id < {$forum_data['right_id']} AND right_id > {$forum_data['right_id']}";

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET left_id = left_id - $diff, right_id = right_id - $diff

WHERE left_id > {$forum_data['right_id']}";

// Delete forum ids from extension groups table

$sql = 'SELECT group_id, allowed_forums

FROM ' . EXTENSION_GROUPS_TABLE;

{

if (!$row['allowed_forums'])

{

$sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . "

SET allowed_forums = '" . ((sizeof($allowed_forums)) ? serialize($allowed_forums) : '') . "'

WHERE group_id = {$row['group_id']}";

}

phpbb::$acm->destroy('extensions');

{

include_once(PHPBB_ROOT_PATH . 'includes/functions_posting.' . PHP_EXT);

// Select then delete all attachments

$sql = 'SELECT a.topic_id

WHERE p.forum_id = $forum_id

AND a.in_message = 0

AND a.topic_id = p.topic_id";

$topic_ids = array();

{

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

}

delete_attachments('topic', $topic_ids, false);

WHERE forum_id = ' . $forum_id . '

AND post_postcount = 1

AND post_approved = 1';

$post_counts = array();

{

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

}

{

case 'mysql':

$sql_where .= "\nAND $table.$field = " . POSTS_TABLE . ".$field";

}

break;

$sql = "SELECT $field

FROM " . POSTS_TABLE . '

WHERE forum_id = ' . $forum_id;

$ids = array();

{

$ids[] = $row[$field];

}

if (sizeof($ids))

{

foreach ($tables as $table)

{

}

}

}

foreach ($table_ary as $table)

{

}

// Set forum ids to 0

foreach ($table_ary as $table)

{

}

// Adjust users post counts

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;

}

}

// Make sure the overall post/topic count is correct...

$sql = 'SELECT COUNT(post_id) AS stat

FROM ' . POSTS_TABLE . '

WHERE post_approved = 1';

set_config('num_posts', (int) $row['stat'], true);

$sql = 'SELECT COUNT(topic_id) AS stat

FROM ' . TOPICS_TABLE . '

WHERE topic_approved = 1';

set_config('num_topics', (int) $row['stat'], true);

$sql = 'SELECT COUNT(attach_id) as stat

FROM ' . ATTACHMENTS_TABLE;

set_config('num_files', (int) $row['stat'], true);

$sql = 'SELECT SUM(filesize) as stat

FROM ' . ATTACHMENTS_TABLE;

set_config('upload_dir_size', (float) $row['stat'], true);

FROM ' . FORUMS_TABLE . "

WHERE parent_id = {$forum_row['parent_id']}

AND " . (($action == 'move_up') ? "right_id < {$forum_row['right_id']} ORDER BY right_id DESC" : "left_id > {$forum_row['left_id']} ORDER BY left_id ASC");

$target = array();

{

$target = $row;

}

if (!sizeof($target))

{

WHERE

left_id BETWEEN {$left_id} AND {$right_id}

AND right_id BETWEEN {$left_id} AND {$right_id}";

return $target['forum_name'];

}

$sql = 'SELECT *

FROM ' . GROUPS_TABLE . "

WHERE group_id = $group_id";

if (!$group_row)

{

FROM ' . USER_GROUP_TABLE . "

WHERE group_id = $group_id

ORDER BY user_id";

$mark_ary = array();

{

do

{

$mark_ary[] = $row['user_id'];

}

group_user_attributes('default', $group_id, $mark_ary, false, $group_name, $group_row);

{

$start = 0;

}

}

while ($start);

}

$sql = 'SELECT group_founder_manage

FROM ' . GROUPS_TABLE . '

WHERE group_id = ' . $group_perm_from;

// Check the group if non-founder

if ($check_row && (phpbb::$user->is_founder || $check_row['group_founder_manage'] == 0))

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

FROM ' . ACL_GROUPS_TABLE . '

WHERE group_id = ' . $group_perm_from;

$groups_sql_ary = array();

{

$groups_sql_ary[] = array(

'group_id' => (int) $group_id,

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

);

}

// Now insert the data

phpbb::$acl->acl_clear_prefetch();

}

FROM ' . RANKS_TABLE . '

WHERE rank_special = 1

ORDER BY rank_title';

$rank_options = '<option value="0"' . ((!$group_rank) ? ' selected="selected"' : '') . '>' . phpbb::$user->lang['USER_DEFAULT'] . '</option>';

{

$selected = ($group_rank && $row['rank_id'] == $group_rank) ? ' selected="selected"' : '';

$rank_options .= '<option value="' . $row['rank_id'] . '"' . $selected . '>' . $row['rank_title'] . '</option>';

}

$type_free = ($group_type == GROUP_FREE) ? ' checked="checked"' : '';

$type_open = ($group_type == GROUP_OPEN) ? ' checked="checked"' : '';

AND u.user_id = ug.user_id

AND ug.group_leader = 1

ORDER BY ug.group_leader DESC, ug.user_pending ASC, u.username_clean";

{

$template->assign_block_vars('leader', array(

'U_USER_EDIT' => append_sid(PHPBB_ADMIN_PATH . 'index.' . PHP_EXT, "i=users&amp;action=edit&amp;u={$row['user_id']}"),

'USER_ID' => $row['user_id'])

);

}

// Total number of group members (non-leaders)

$sql = 'SELECT COUNT(user_id) AS total_members

FROM ' . USER_GROUP_TABLE . "

WHERE group_id = $group_id

AND group_leader = 0";

$s_action_options = '';

$options = array('default' => 'DEFAULT', 'approve' => 'APPROVE', 'demote' => 'DEMOTE', 'promote' => 'PROMOTE', 'deleteusers' => 'DELETE');

AND u.user_id = ug.user_id

AND ug.group_leader = 0

ORDER BY ug.group_leader DESC, ug.user_pending ASC, u.username_clean";

$pending = false;

{

if ($row['user_pending'] && !$pending)

{

'USER_ID' => $row['user_id'])

);

}

return;

break;

$sql = 'SELECT g.group_id, g.group_name, g.group_type

FROM ' . GROUPS_TABLE . ' g

ORDER BY g.group_type ASC, g.group_name';

$lookup = $cached_group_data = array();

{

$type = ($row['group_type'] == GROUP_SPECIAL) ? 'special' : 'normal';

$cached_group_data[$type][$row['group_id']] = $row;

$cached_group_data[$type][$row['group_id']]['total_members'] = 0;

}

// How many people are in which group?

$sql = 'SELECT COUNT(ug.user_id) AS total_members, ug.group_id

FROM ' . USER_GROUP_TABLE . ' ug

GROUP BY ug.group_id';

{

$type = $lookup[$row['group_id']];

$cached_group_data[$type][$row['group_id']]['total_members'] = $row['total_members'];

}

// The order is... normal, then special

ksort($cached_group_data);

$sql = 'SELECT *

FROM ' . SMILIES_TABLE . '

ORDER BY smiley_order';

{

if (empty($smilies[$row['smiley_url']]))

{

$smilies[$row['smiley_url']] = $row;

}

}

if (sizeof($smilies))

{

$sql = "SELECT *

FROM $table

ORDER BY {$fields}_order " . (($icon_id || $action == 'add') ? 'DESC' : 'ASC');

$data = array();

$after = false;

$add_order_lists = array('', '');

$display_count = 0;

{

if ($action == 'add')

{

}

}

}

$order_list = '<option value="1"' . ((!isset($after)) ? ' selected="selected"' : '') . '>' . phpbb::$user->lang['FIRST'] . '</option>';

$add_order_list = '<option value="1">' . phpbb::$user->lang['FIRST'] . '</option>';

$sql = "UPDATE $table

SET {$fields}_order = {$fields}_order + 1

WHERE {$fields}_order >= {$image_order[$image]}";

// If we adjust the order, we need to adjust all other orders too - they became inaccurate...

foreach ($image_order as $_image => $_order)

if ($action == 'modify' && !empty($image_id[$image]))

{

$sql = "UPDATE $table

WHERE {$fields}_id = " . $image_id[$image];

$icons_updated++;

}

else if ($action !== 'modify')

{

$icons_updated++;

}

// The user has already selected a smilies_pak file

if ($current == 'delete')

{

{

}

else

{

}

switch ($mode)

case 'icons':

// Reset all icon_ids

break;

}

}

$sql = "SELECT $field_sql

FROM $table";

{

++$order;

$cur_img[$row[$field_sql]] = 1;

}

}

foreach ($pak_ary as $pak_entry)

));

}

}

else

{

'emotion' => $emotion,

));

}

}

}

}

$sql = "SELECT *

FROM $table

ORDER BY {$fields}_order";

$pak = '';

{

$pak .= "'" . addslashes($row[$fields . '_url']) . "', ";

$pak .= "'" . addslashes($row[$fields . '_width']) . "', ";

$pak .= "\n";

}

if ($pak != '')

{

{

$sql = "DELETE FROM $table

WHERE {$fields}_id = $icon_id";

switch ($mode)

{

case 'icons':

// Reset appropriate icon_ids

SET icon_id = 0

WHERE icon_id = $icon_id");

SET icon_id = 0

WHERE icon_id = $icon_id");

break;

$sql = "SELECT {$fields}_order as current_order

FROM $table

WHERE {$fields}_id = $icon_id";

if ($current_order == 0 && $action == 'move_up')

{

SET {$fields}_order = $current_order

WHERE {$fields}_order = $switch_order_id

AND {$fields}_id <> $icon_id";

// Only update the other entry too if the previous entry got updated

{

$sql = "UPDATE $table

SET {$fields}_order = $switch_order_id

WHERE {$fields}_order = $current_order

AND {$fields}_id = $icon_id";

}

phpbb::$acm->destroy('icons');

$sql = "SELECT {$fields}_id AS order_id, {$fields}_order AS fields_order

FROM $table

ORDER BY display_on_posting DESC, {$fields}_order";

{

$order = 0;

do

++$order;

if ($row['fields_order'] != $order)

{

SET {$fields}_order = $order

WHERE {$fields}_id = " . $row['order_id']);

}

}

}

$template->assign_vars(array(

'L_TITLE' => phpbb::$user->lang['ACP_' . $lang],

$sql = "SELECT *

FROM $table

ORDER BY {$fields}_order ASC";

{

$alt_text = ($mode == 'smilies') ? $row['code'] : '';

$spacer = true;

}

}

}

}

$sql = 'SELECT user_id, username

FROM ' . USERS_TABLE . '

$user_affected = array();

{

$user_affected[$row['user_id']] = $row['username'];

}

if ($action == 'activate')

{

// Get those 'being activated'...

$sql = 'SELECT user_id, username, user_email, user_lang

FROM ' . USERS_TABLE . '

AND user_type = ' . phpbb::USER_INACTIVE;

$inactive_users = array();

{

$inactive_users[] = $row;

}

}

user_active_flip('activate', $mark);

$sql = 'SELECT user_id, username, user_email, user_lang, user_jabber, user_notify_type, user_regdate, user_actkey

FROM ' . USERS_TABLE . '

{

// Send the messages

include_once(PHPBB_ROOT_PATH . 'includes/functions_messenger.' . PHP_EXT);

$usernames[] = $row['username'];

}

$messenger->save_queue();

add_log('admin', 'LOG_INACTIVE_REMIND', implode(', ', $usernames));

unset($usernames);

}

break;

}

);

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_notify_type = ' . NOTIFY_IM;

}

set_config('jab_enable', $jab_enable);

$sql = 'SELECT *

FROM ' . LANG_TABLE . "

WHERE lang_id = $lang_id";

$sql_ary = array(

'lang_english_name' => request_var('lang_english_name', $row['lang_english_name']),

'lang_author' => utf8_normalize_nfc(request_var('lang_author', $row['lang_author'], true)),

);

WHERE lang_id = ' . $lang_id);

add_log('admin', 'LOG_LANGUAGE_PACK_UPDATED', $sql_ary['lang_english_name']);

$sql = 'SELECT *

FROM ' . LANG_TABLE . "

WHERE lang_id = $lang_id";

if (!$row)

{

$sql = 'SELECT lang_iso

FROM ' . LANG_TABLE . "

WHERE lang_id = $lang_id";

$file = request_var('file', '');

$dir = request_var('dir', '');

$sql = 'SELECT *

FROM ' . LANG_TABLE . '

WHERE lang_id = ' . $lang_id;

$lang_iso = $lang_entries['lang_iso'];

$missing_vars = $missing_files = array();

$sql = 'SELECT *

FROM ' . LANG_TABLE . '

WHERE lang_id = ' . $lang_id;

if ($row['lang_iso'] == phpbb::$config['default_lang'])

{

trigger_error(phpbb::$user->lang['NO_REMOVE_DEFAULT_LANG'] . adm_back_link($this->u_action), E_USER_WARNING);

}

$sql = 'UPDATE ' . USERS_TABLE . "

// We also need to remove the translated entries for custom profile fields - we want clean tables, don't we?

$sql = 'DELETE FROM ' . PROFILE_LANG_TABLE . ' WHERE lang_id = ' . $lang_id;

$sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . ' WHERE lang_id = ' . $lang_id;

phpbb::$acm->destroy_sql(STYLES_IMAGESET_DATA_TABLE);

$sql = 'SELECT lang_iso

FROM ' . LANG_TABLE . "

if ($row)

{

'lang_author' => $lang_pack['author']

);

$valid_localized = array(

'icon_back_top', 'icon_contact_aim', 'icon_contact_email', 'icon_contact_icq', 'icon_contact_jabber', 'icon_contact_msnm', 'icon_contact_pm', 'icon_contact_yahoo', 'icon_contact_www', 'icon_post_delete', 'icon_post_edit', 'icon_post_info', 'icon_post_quote', 'icon_post_report', 'icon_user_online', 'icon_user_offline', 'icon_user_profile', 'icon_user_search', 'icon_user_warn', 'button_pm_forward', 'button_pm_new', 'button_pm_reply', 'button_topic_locked', 'button_topic_new', 'button_topic_reply',

$sql = 'SELECT *

FROM ' . STYLES_IMAGESET_TABLE;

{

if (@file_exists(PHPBB_ROOT_PATH . "styles/{$imageset_row['imageset_path']}/imageset/{$lang_pack['iso']}/imageset.cfg"))

{

}

}

}

if (sizeof($sql_ary))

{

phpbb::$acm->destroy_sql(STYLES_IMAGESET_DATA_TABLE);

}

// Now let's copy the default language entries for custom profile fields for this new language - makes admin's life easier.

$sql = 'SELECT lang_id

FROM ' . LANG_TABLE . "

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

$sql = 'SELECT field_id, lang_name, lang_explain, lang_default_value

FROM ' . PROFILE_LANG_TABLE . '

WHERE lang_id = ' . $default_lang_id;

{

$row['lang_id'] = $lang_id;

}

$sql = 'SELECT field_id, option_id, field_type, lang_value

FROM ' . PROFILE_FIELDS_LANG_TABLE . '

WHERE lang_id = ' . $default_lang_id;

{

$row['lang_id'] = $lang_id;

}

add_log('admin', 'LOG_LANGUAGE_PACK_INSTALLED', $lang_pack['name']);

$sql = 'SELECT *

FROM ' . LANG_TABLE . '

WHERE lang_id = ' . $lang_id;

$use_method = request_var('use_method', '');

$methods = array('.tar');

$sql = 'SELECT user_lang, COUNT(user_lang) AS lang_count

FROM ' . USERS_TABLE . '

GROUP BY user_lang';

$lang_count = array();

{

$lang_count[$row['user_lang']] = $row['lang_count'];

}

$sql = 'SELECT *

FROM ' . LANG_TABLE . '

ORDER BY lang_english_name';

$installed = array();

{

$installed[] = $row['lang_iso'];

$tagstyle = ($row['lang_iso'] == phpbb::$config['default_lang']) ? '*' : '';

'USED_BY' => (isset($lang_count[$row['lang_iso']])) ? $lang_count[$row['lang_iso']] : 0,

));

}

$new_ary = $iso = array();

$dp = @opendir(PHPBB_ROOT_PATH . 'language');

{

$sql_in[] = $mark;

}

unset($sql_in);

}

$sql = 'DELETE FROM ' . LOG_TABLE . "

WHERE log_type = {$this->log_type}

$where_sql";

add_log('admin', 'LOG_CLEAR_' . strtoupper($mode));

}

$sql = 'SELECT *

FROM ' . ACL_ROLES_TABLE . '

WHERE role_id = ' . $role_id;

if (!$role_row)

{

$sql = 'SELECT *

FROM ' . ACL_ROLES_TABLE . '

WHERE role_id = ' . $role_id;

if (!$role_row)

{

// if we add/edit a role we check the name to be unique among the settings...

$sql = 'SELECT role_id

FROM ' . ACL_ROLES_TABLE . "

// Make sure we only print out the error if we add the role or change it's name

if ($row && ($mode == 'add' || ($mode == 'edit' && $role_row['role_name'] != $role_name)))

if ($action == 'edit')

{

$sql = 'UPDATE ' . ACL_ROLES_TABLE . '

WHERE role_id = ' . $role_id;

}

else

{

// Get maximum role order for inserting a new role...

$sql = 'SELECT MAX(role_order) as max_order

FROM ' . ACL_ROLES_TABLE . "

$sql_ary['role_order'] = $max_order + 1;

}

// Now add the auth settings

WHERE o.auth_option_id = p.auth_option_id

AND p.role_id = ' . $options_from . '

ORDER BY p.auth_option_id';

$auth_options = array();

{

$auth_options[$row['auth_option']] = $row['auth_setting'];

}

}

else

{

$sql = 'SELECT auth_option_id, auth_option

FROM ' . ACL_OPTIONS_TABLE . "

AND auth_option <> '{$permission_type}'

ORDER BY auth_option_id";

$auth_options = array();

{

$auth_options[$row['auth_option']] = phpbb::ACL_NO;

}

}

// no break;

$sql = 'SELECT *

FROM ' . ACL_ROLES_TABLE . '

WHERE role_id = ' . $role_id;

$sql = 'SELECT p.auth_option_id, p.auth_setting, o.auth_option

FROM ' . ACL_ROLES_DATA_TABLE . ' p, ' . ACL_OPTIONS_TABLE . ' o

WHERE o.auth_option_id = p.auth_option_id

AND p.role_id = ' . $role_id . '

ORDER BY p.auth_option_id';

$auth_options = array();

{

$auth_options[$row['auth_option']] = $row['auth_setting'];

}

}

if (!$role_row)

// We need to fill the auth options array with ACL_NO options ;)

$sql = 'SELECT auth_option_id, auth_option

FROM ' . ACL_OPTIONS_TABLE . "

AND auth_option <> '{$permission_type}'

ORDER BY auth_option_id";

{

if (!isset($auth_options[$row['auth_option']]))

{

$auth_options[$row['auth_option']] = phpbb::ACL_NO;

}

}

// Unset global permission option

unset($auth_options[$permission_type]);

$sql = 'UPDATE ' . ACL_ROLES_TABLE . '

SET role_order = ' . $order_total . " - role_order

AND role_order IN ($order, " . (($action == 'move_up') ? $order - 1 : $order + 1) . ')';

break;

}

// By default, check that role_order is valid and fix it if necessary

$sql = 'SELECT role_id, role_order

FROM ' . ACL_ROLES_TABLE . "

ORDER BY role_order ASC";

{

$order = 0;

do

$order++;

if ($row['role_order'] != $order)

{

}

}

}

// Display assigned items?

$display_item = request_var('display_item', 0);

// Select existing roles

$sql = 'SELECT *

FROM ' . ACL_ROLES_TABLE . "

ORDER BY role_order ASC";

$s_role_options = '';

{

$role_name = (!empty(phpbb::$user->lang[$row['role_name']])) ? phpbb::$user->lang[$row['role_name']] : $row['role_name'];

);

}

}

$template->assign_vars(array(

'S_ROLE_OPTIONS' => $s_role_options)

// Get complete auth array

$sql = 'SELECT auth_option, auth_option_id

FROM ' . ACL_OPTIONS_TABLE . "

$auth_settings = array();

{

$auth_settings[$row['auth_option']] = phpbb::ACL_NO;

}

// Get the role auth settings we need to re-set...

$sql = 'SELECT o.auth_option, r.auth_setting

FROM ' . ACL_ROLES_DATA_TABLE . ' r, ' . ACL_OPTIONS_TABLE . ' o

WHERE o.auth_option_id = r.auth_option_id

AND r.role_id = ' . $role_id;

{

$auth_settings[$row['auth_option']] = $row['auth_setting'];

}

// Get role assignments

$hold_ary = $auth_admin->get_role_mask($role_id);

// Remove role from users and groups just to be sure (happens through acl_set)

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . '

WHERE auth_role_id = ' . $role_id;

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '

WHERE auth_role_id = ' . $role_id;

// Remove role data and role

$sql = 'DELETE FROM ' . ACL_ROLES_DATA_TABLE . '

WHERE role_id = ' . $role_id;

$sql = 'DELETE FROM ' . ACL_ROLES_TABLE . '

WHERE role_id = ' . $role_id;

$auth_admin->acl_clear_prefetch();

}

FROM ' . GROUPS_TABLE . '

WHERE group_type = ' . GROUP_SPECIAL . "

$sql_and";

{

$group_id[] = $row['group_id'];

}

}

// Map usernames to ids and vice versa

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE . '

ORDER BY left_id';

$forum_id = array();

{

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

}

}

else if ($subforum_id)

{

{

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

$forum_names = array();

{

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

}

$template->assign_vars(array(

'S_FORUM_NAMES' => (sizeof($forum_names)) ? true : false,

{

$sql = "SELECT $sql_id

FROM $table

$ids = array();

{

$ids[] = (int) $row[$sql_id];

}

}

if (!sizeof($ids))

FROM ' . ACL_OPTIONS_TABLE . ' o, ' . ACL_ROLES_DATA_TABLE . ' r

WHERE o.auth_option_id = r.auth_option_id

AND r.role_id = ' . $role_id;

$test_auth_settings = array();

{

$test_auth_settings[$row['auth_option']] = $row['auth_setting'];

}

// We need to add any ACL_NO setting from auth_settings to compare correctly

foreach ($auth_settings as $option => $setting)

// Logging ... first grab user or groupnames ...

$sql = ($ug_type == 'group') ? 'SELECT group_name as name, group_type FROM ' . GROUPS_TABLE . ' WHERE ' : 'SELECT username as name FROM ' . USERS_TABLE . ' WHERE ';

$l_ug_list = '';

{

$l_ug_list .= (($l_ug_list != '') ? ', ' : '') . ((isset($row['group_type']) && $row['group_type'] == GROUP_SPECIAL) ? '<span class="sep">' . phpbb::$user->lang['G_' . $row['name']] . '</span>' : $row['name']);

}

$mode = str_replace('setting_', '', $mode);

// Grab the forum details if non-zero forum_id

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . '

$l_forum_list = '';

{

$l_forum_list .= (($l_forum_list != '') ? ', ' : '') . $row['forum_name'];

}

add_log('admin', 'LOG_ACL_' . strtoupper($action) . '_' . strtoupper($mode) . '_' . strtoupper($permission_type), $l_forum_list, $l_ug_list);

}

$sql = 'SELECT user_id, username, user_permissions, user_type

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

else

{

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

}

$back = request_var('back', 0);

WHERE ug.user_id = ' . $user_id . '

AND ug.user_pending = 0

ORDER BY g.group_type DESC, g.group_id DESC';

$groups = array();

{

$groups[$row['group_id']] = array(

'auth_setting' => phpbb::ACL_NO,

'group_name' => ($row['group_type'] == GROUP_SPECIAL) ? phpbb::$user->lang['G_' . $row['group_name']] : $row['group_name']

);

}

$total = phpbb::ACL_NO;

$add_key = (($forum_id) ? '_LOCAL' : '');

*/

function retrieve_defined_user_groups($permission_scope, $forum_id, $permission_type)

{

// Permission options are only able to be a permission set... therefore we will pre-fetch the possible options and also the possible roles

$option_ids = $role_ids = array();

$sql = 'SELECT auth_option_id

FROM ' . ACL_OPTIONS_TABLE . '

{

$option_ids[] = (int) $row['auth_option_id'];

}

if (sizeof($option_ids))

{

$sql = 'SELECT DISTINCT role_id

FROM ' . ACL_ROLES_DATA_TABLE . '

{

$role_ids[] = (int) $row['role_id'];

}

}

if (sizeof($option_ids) && sizeof($role_ids))

{

}

else

{

}

// Not ideal, due to the filesort, non-use of indexes, etc.

$sql_forum_id

$sql_where

ORDER BY u.username_clean, u.user_regdate ASC";

$s_defined_user_options = '';

$defined_user_ids = array();

{

$s_defined_user_options .= '<option value="' . $row['user_id'] . '">' . $row['username'] . '</option>';

$defined_user_ids[] = $row['user_id'];

}

$sql = 'SELECT DISTINCT g.group_type, g.group_name, g.group_id

FROM ' . GROUPS_TABLE . ' g, ' . ACL_GROUPS_TABLE . " a

$sql_forum_id

$sql_where

ORDER BY g.group_type DESC, g.group_name ASC";

$s_defined_group_options = '';

$defined_group_ids = array();

{

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

$defined_group_ids[] = $row['group_id'];

}

return array(

'group_ids' => $defined_group_ids,

$sql = 'SELECT lang_id, lang_iso

FROM ' . LANG_TABLE . '

ORDER BY lang_english_name';

{

// Make some arrays with all available languages

$this->lang_defs['id'][$row['lang_id']] = $row['lang_iso'];

$this->lang_defs['iso'][$row['lang_iso']] = $row['lang_id'];

}

$sql = 'SELECT field_id, lang_id

FROM ' . PROFILE_LANG_TABLE . '

ORDER BY lang_id';

{

// Which languages are available for each item

$this->lang_defs['entry'][$row['field_id']][] = $row['lang_id'];

}

// Have some fields been defined?

if (isset($this->lang_defs['entry']))

$sql = 'SELECT field_ident

FROM ' . PROFILE_FIELDS_TABLE . "

WHERE field_id = $field_id";

{

$sql = "SELECT sql

FROM sqlite_master

WHERE type = 'table'

AND name = '" . PROFILE_FIELDS_DATA_TABLE . "'

ORDER BY type DESC, name;";

// Create a temp table and populate it, destroy the existing one

preg_match('#\((.*)\)#s', $row['sql'], $matches);

$new_table_cols = preg_replace('/' . 'pf_' . $field_ident . '[^,]+,/', '', $new_table_cols);

// create a new table and fill it up. destroy the temp one

}

else

{

}

$order = 0;

$sql = 'SELECT *

FROM ' . PROFILE_FIELDS_TABLE . '

ORDER BY field_order';

{

$order++;

if ($row['field_order'] != $order)

$sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

SET field_order = $order

WHERE field_id = {$row['field_id']}";

}

}

add_log('admin', 'LOG_PROFILE_FIELD_REMOVED', $field_ident);

trigger_error(phpbb::$user->lang['REMOVED_PROFILE_FIELD'] . adm_back_link($this->u_action));

$sql = 'SELECT lang_id

FROM ' . LANG_TABLE . "

if (!in_array($default_lang_id, $this->lang_defs['entry'][$field_id]))

{

$sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

SET field_active = 1

WHERE field_id = $field_id";

$sql = 'SELECT field_ident

FROM ' . PROFILE_FIELDS_TABLE . "

WHERE field_id = $field_id";

add_log('admin', 'LOG_PROFILE_FIELD_ACTIVATE', $field_ident);

trigger_error(phpbb::$user->lang['PROFILE_FIELD_ACTIVATED'] . adm_back_link($this->u_action));

$sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

SET field_active = 0

WHERE field_id = $field_id";

$sql = 'SELECT field_ident

FROM ' . PROFILE_FIELDS_TABLE . "

WHERE field_id = $field_id";

add_log('admin', 'LOG_PROFILE_FIELD_DEACTIVATE', $field_ident);

trigger_error(phpbb::$user->lang['PROFILE_FIELD_DEACTIVATED'] . adm_back_link($this->u_action));

$sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

SET field_order = $order_total - field_order

WHERE field_order IN ($field_order, " . (($action == 'move_up') ? $field_order - 1 : $field_order + 1) . ')';

break;

WHERE l.lang_id = ' . $this->edit_lang_id . "

AND f.field_id = $field_id

AND l.field_id = f.field_id";

if (!$field_row)

{

WHERE l.lang_id <> ' . $this->edit_lang_id . "

AND f.field_id = $field_id

AND l.field_id = f.field_id";

if (!$field_row)

{

WHERE lang_id = ' . $this->edit_lang_id . "

AND field_id = $field_id

ORDER BY option_id ASC";

$lang_options = array();

{

$lang_options[$row['option_id']] = $row['lang_value'];

}

$s_hidden_fields = '<input type="hidden" name="field_id" value="' . $field_id . '" />';

}

WHERE lang_id <> ' . $this->edit_lang_id . "

AND field_id = $field_id

ORDER BY option_id ASC";

$l_lang_options = array();

{

$l_lang_options[$row['lang_id']][$row['option_id']] = $row['lang_value'];

}

$sql = 'SELECT lang_id, lang_name, lang_explain, lang_default_value

WHERE lang_id <> ' . $this->edit_lang_id . "

AND field_id = $field_id

ORDER BY lang_id ASC";

$l_lang_name = $l_lang_explain = $l_lang_default_value = array();

{

$l_lang_name[$row['lang_id']] = $row['lang_name'];

$l_lang_explain[$row['lang_id']] = $row['lang_explain'];

$l_lang_default_value[$row['lang_id']] = $row['lang_default_value'];

}

}

foreach ($exclude[3] as $key)

{

$sql = 'SELECT field_ident

FROM ' . PROFILE_FIELDS_TABLE . "

if ($row)

{

$sql = 'SELECT *

FROM ' . PROFILE_FIELDS_TABLE . '

ORDER BY field_order';

$s_one_need_edit = false;

{

$active_lang = (!$row['field_active']) ? 'ACTIVATE' : 'DEACTIVATE';

$active_value = (!$row['field_active']) ? 'activate' : 'deactivate';

'S_NEED_EDIT' => $s_need_edit)

);

}

// At least one option field needs editing?

if ($s_one_need_edit)

FROM ' . LANG_TABLE . '

WHERE lang_id <> ' . (int) $default_lang_id . '

ORDER BY lang_english_name';

$languages = array();

{

$languages[$row['lang_id']] = $row['lang_iso'];

}

$options = array();

$options['lang_name'] = 'string';

{

$sql = 'SELECT MAX(field_order) as max_field_order

FROM ' . PROFILE_FIELDS_TABLE;

$field_ident = $cp->vars['field_ident'];

}

'field_active' => 1

);

}

else

{

$sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . '

WHERE field_id = $field_id";

}

if ($action == 'create')

$sql_ary['field_id'] = $field_id;

$sql_ary['lang_id'] = $default_lang_id;

}

else

{

$sql = 'DELETE FROM ' . PROFILE_LANG_TABLE . "

WHERE field_id = $field_id

AND lang_id = " . (int) $lang_id;

}

}

$sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . "

WHERE field_id = $field_id

AND lang_id = " . (int) $default_lang_id;

}

foreach ($cp->vars['lang_options'] as $option_id => $value)

$sql_ary['lang_id'] = $default_lang_id;

$sql_ary['option_id'] = (int) $option_id;

}

else

{

$sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . "

WHERE field_id = $field_id

AND lang_id = " . (int) $lang_id;

}

foreach ($lang_ary as $option_id => $value)

$sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . "

WHERE field_id = $field_id

AND lang_id = " . (int) $lang_id;

}

}

{

if ($action == 'create')

{

}

else

{

{

if ($action == 'create')

{

}

else

{

}

if ($action == 'create')

{

foreach ($profile_sql as $sql)

{

}

}

if ($action == 'edit')

{

foreach ($where_fields as $key => $value)

{

$check_key = (!$check_key) ? $key : $check_key;

}

if (!sizeof($where_sql))

$sql = "SELECT $check_key

FROM $table

WHERE " . implode(' AND ', $where_sql);

if (!$row)

{

if (sizeof($sql_ary))

{

}

}

else

{

if (sizeof($sql_ary))

{

WHERE ' . implode(' AND ', $where_sql);

}

}

}

*/

function add_field_ident($field_ident, $field_type)

{

{

case 'mysql':

WHERE type = 'table'

AND name = '" . PROFILE_FIELDS_DATA_TABLE . "'

ORDER BY type DESC, name;";

// Create a temp table and populate it, destroy the existing one

preg_match('#\((.*)\)#s', $row['sql'], $matches);

$new_table_cols = $field_ident . ' ' . $type . ',' . $new_table_cols;

// create a new table and fill it up. destroy the temp one

}

else

{

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE . '

ORDER BY left_id';

$forum_id = array();

{

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

}

}

if ($submit)

'S_PRUNED' => true)

);

// Get a list of forum's or the data for the forum that we are pruning.

$sql = 'SELECT forum_id, forum_name

WHERE forum_type = ' . FORUM_POST . "

$sql_forum

ORDER BY left_id ASC";

{

$prune_ids = array();

$p_result['topics'] = 0;

$log_data .= (($log_data != '') ? ', ' : '') . $row['forum_name'];

}

// Sync all pruned forums at once

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

add_log('admin', 'LOG_PRUNE', $log_data);

}

return;

}

{

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE . '

if (!$row)

{

trigger_error(phpbb::$user->lang['NO_FORUM'] . adm_back_link($this->u_action), E_USER_WARNING);

}

$forum_list .= (($forum_list != '') ? ', ' : '') . '<b>' . $row['forum_name'] . '</b>';

$s_hidden_fields .= '<input type="hidden" name="f[]" value="' . $row['forum_id'] . '" />';

}

$l_selected_forums = (sizeof($forum_id) == 1) ? 'SELECTED_FORUM' : 'SELECTED_FORUMS';

if ($users)

{

$users = explode("\n", $users);

}

else

{

$sort_by_types = array('username', 'user_email', 'user_posts', 'user_regdate', 'user_lastvisit');

$where_sql = '';

$where_sql .= (sizeof($joined)) ? " AND user_regdate " . $key_match[$joined_select] . ' ' . gmmktime(0, 0, 0, (int) $joined[1], (int) $joined[2], (int) $joined[0]) : '';

$where_sql .= ($count !== '') ? " AND user_posts " . $key_match[$count_select] . ' ' . (int) $count . ' ' : '';

// Get bot ids

$sql = 'SELECT user_id

FROM ' . BOTS_TABLE;

$bot_ids = array();

{

$bot_ids[] = $row['user_id'];

}

// Do not prune founder members

$sql = 'SELECT user_id, username

WHERE user_id <> ' . ANONYMOUS . '

AND user_type <> ' . phpbb::USER_FOUNDER . "

$where_sql";

$where_sql = '';

$user_ids = $usernames = array();

{

// Do not prune bots and the user currently pruning.

if ($row['user_id'] != phpbb::$user->data['user_id'] && !in_array($row['user_id'], $bot_ids))

$usernames[$row['user_id']] = $row['username'];

}

}

}

}

if ($rank_id)

{

$message = phpbb::$user->lang['RANK_UPDATED'];

add_log('admin', 'LOG_RANK_UPDATED', $rank_title);

}

else

{

$message = phpbb::$user->lang['RANK_ADDED'];

add_log('admin', 'LOG_RANK_ADDED', $rank_title);

}

phpbb::$acm->destroy('ranks');

$sql = 'SELECT rank_title

FROM ' . RANKS_TABLE . '

WHERE rank_id = ' . $rank_id;

$sql = 'DELETE FROM ' . RANKS_TABLE . "

WHERE rank_id = $rank_id";

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_rank = 0

WHERE user_rank = $rank_id";

phpbb::$acm->destroy('ranks');

$sql = 'SELECT *

FROM ' . RANKS_TABLE . '

ORDER BY rank_min ASC, rank_special ASC';

{

$existing_imgs[] = $row['rank_image'];

$ranks = $row;

}

}

$imglist = filelist(PHPBB_ROOT_PATH . phpbb::$config['ranks_path'], '');

$edit_img = $filename_list = '';

$sql = 'SELECT *

FROM ' . RANKS_TABLE . '

ORDER BY rank_special DESC, rank_min ASC, rank_title ASC';

{

$template->assign_block_vars('ranks', array(

'S_RANK_IMAGE' => ($row['rank_image']) ? true : false,

'U_DELETE' => $this->u_action . '&amp;action=delete&amp;id=' . $row['rank_id'])

);

}

}

}

$sql = 'SELECT reason_title

FROM ' . REPORTS_REASONS_TABLE . "

WHERE reason_id = $reason_id";

if (strtolower($row['reason_title']) == 'other' || strtolower($reason_row['reason_title']) == 'other')

{

{

$sql = 'SELECT reason_id

FROM ' . REPORTS_REASONS_TABLE . "

if ($row || ($action == 'add' && strtolower($reason_row['reason_title']) == 'other'))

{

// Get new order...

$sql = 'SELECT MAX(reason_order) as max_reason_order

FROM ' . REPORTS_REASONS_TABLE;

$sql_ary = array(

'reason_title' => (string) $reason_row['reason_title'],

'reason_order' => $max_order + 1

);

$log = 'ADDED';

}

'reason_description' => (string) $reason_row['reason_description'],

);

WHERE reason_id = ' . $reason_id);

$log = 'UPDATED';

$sql = 'SELECT *

FROM ' . REPORTS_REASONS_TABLE . '

WHERE reason_id = ' . $reason_id;

if (!$reason_row)

{

$sql = 'SELECT *

FROM ' . REPORTS_REASONS_TABLE . '

WHERE reason_id = ' . $reason_id;

if (!$reason_row)

{

$sql = 'SELECT reason_id, report_text

FROM ' . REPORTS_REASONS_TABLE . "

WHERE LOWER(reason_title) = 'other'";

$other_reason_id = (int) $row['reason_id'];

$report_text = $row['report_text'];

$report_text .= $reason_row['reason_description'] . "\n\n";

$sql = 'UPDATE ' . REPORTS_TABLE . '

WHERE reason_id = $reason_id";

add_log('admin', 'LOG_REASON_REMOVED', $reason_row['reason_title']);

trigger_error(phpbb::$user->lang['REASON_REMOVED'] . adm_back_link($this->u_action));

$sql = 'UPDATE ' . REPORTS_REASONS_TABLE . '

SET reason_order = ' . $order_total . ' - reason_order

WHERE reason_order IN (' . $order . ', ' . (($action == 'move_up') ? $order - 1 : $order + 1) . ')';

break;

}

$sql = 'SELECT reason_id, reason_order

FROM ' . REPORTS_REASONS_TABLE . '

ORDER BY reason_order';

{

$order = 0;

do

$sql = 'UPDATE ' . REPORTS_REASONS_TABLE . "

SET reason_order = $order

WHERE reason_id = {$row['reason_id']}";

}

}

}

$template->assign_vars(array(

'U_ACTION' => $this->u_action,

$sql = 'SELECT reason_id, COUNT(reason_id) AS reason_count

FROM ' . REPORTS_TABLE . '

GROUP BY reason_id';

$reason_count = array();

{

$reason_count[$row['reason_id']] = $row['reason_count'];

}

$sql = 'SELECT *

FROM ' . REPORTS_REASONS_TABLE . '

ORDER BY reason_order ASC';

{

$translated = false;

$other_reason = ($row['reason_title'] == 'other') ? true : false;

'U_MOVE_DOWN' => $this->u_action . '&amp;action=move_down&amp;order=' . $row['reason_order'])

);

}

}

}

FROM ' . POSTS_TABLE . '

WHERE post_id >= ' . (int) ($post_counter + 1) . '

AND post_id <= ' . (int) ($post_counter + $this->batch_size);

$ids = $posters = $forum_ids = array();

{

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

$posters[] = $row['poster_id'];

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

}

$row_count += sizeof($ids);

if (sizeof($ids))

{

$sql = 'SELECT forum_id, enable_indexing

FROM ' . FORUMS_TABLE;

{

$forums[$row['forum_id']] = (bool) $row['enable_indexing'];

}

$starttime = explode(' ', microtime());

$starttime = $starttime[1] + $starttime[0];

FROM ' . POSTS_TABLE . '

WHERE post_id >= ' . (int) ($post_counter + 1) . '

AND post_id <= ' . (int) ($post_counter + $this->batch_size);

{

// Indexing enabled for this forum or global announcement?

// Global announcements get indexed by default.

}

$row_count++;

}

$post_counter += $this->batch_size;

}

{

$sql = 'SELECT MAX(post_id) as max_post_id

FROM '. POSTS_TABLE;

return $max_post_id;

}

$sql = 'UPDATE ' . STYLES_TABLE . '

SET style_active = ' . (($action == 'activate') ? 1 : 0) . '

WHERE style_id = ' . $style_id;

// Set style to default for any member using deactivated style

if ($action == 'deactivate')

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_style = ' . phpbb::$config['default_style'] . "

WHERE user_style = $style_id";

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET forum_style = 0

WHERE forum_style = ' . $style_id;

}

break;

}

$sql = 'SELECT *

FROM ' . STYLES_TEMPLATE_TABLE . "

WHERE template_id = $style_id";

if (!$template_row)

{

$sql = 'SELECT *

FROM ' . STYLES_THEME_TABLE . "

WHERE theme_id = $style_id";

if (!$theme_row)

{

'theme_data' => self::db_theme_data($theme_row)

);

WHERE theme_id = $style_id";

phpbb::$acm->destroy_sql(STYLES_THEME_TABLE);

$sql = 'SELECT *

FROM ' . STYLES_IMAGESET_TABLE . "

WHERE imageset_id = $style_id";

if (!$imageset_row)

{

$cfg_data_imageset = parse_cfg_file(PHPBB_ROOT_PATH . "styles/{$imageset_row['imageset_path']}/imageset/imageset.cfg");

$sql = 'DELETE FROM ' . STYLES_IMAGESET_DATA_TABLE . '

WHERE imageset_id = ' . $style_id;

foreach ($cfg_data_imageset as $image_name => $value)

{

$sql = 'SELECT lang_dir

FROM ' . LANG_TABLE;

{

if (@file_exists(PHPBB_ROOT_PATH . "styles/{$imageset_row['imageset_path']}/imageset/{$row['lang_dir']}/imageset.cfg"))

{

}

}

}

phpbb::$acm->destroy_sql(STYLES_IMAGESET_DATA_TABLE);

$sql = 'SELECT user_style, COUNT(user_style) AS style_count

FROM ' . USERS_TABLE . '

GROUP BY user_style';

{

$style_count[$row['user_style']] = $row['style_count'];

}

break;

$sql = "SELECT *

FROM $sql_from";

$installed = array();

$basis_options = '<option class="sep" value="">' . phpbb::$user->lang['OPTIONAL_BASIS'] . '</option>';

{

$installed[] = $row[$mode . '_name'];

$basis_options .= '<option value="' . $row[$mode . '_id'] . '">' . $row[$mode . '_name'] . '</option>';

)

);

}

// Grab uninstalled items

$new_ary = $cfg = array();

$sql = 'SELECT template_path, template_name

FROM ' . STYLES_TEMPLATE_TABLE . "

WHERE template_id = $template_id";

if (!$template_info)

{

$sql = 'SELECT *

FROM ' . STYLES_TEMPLATE_TABLE . "

WHERE template_id = $template_id";

if (!$template_row)

{

$sql = 'SELECT theme_storedb, theme_path, theme_name, theme_data

FROM ' . STYLES_THEME_TABLE . "

WHERE theme_id = $theme_id";

{

trigger_error(phpbb::$user->lang['NO_THEME'] . adm_back_link($this->u_action), E_USER_WARNING);

}

$theme_info['theme_id'] = $theme_id;

self::generate_stylesheets($theme_info);

'theme_data' => self::db_theme_data($theme_info, $theme_data),

);

$sql = 'UPDATE ' . STYLES_THEME_TABLE . '

WHERE theme_id = ' . $theme_id;

phpbb::$acm->destroy_sql(STYLES_THEME_TABLE);

$sql = 'SELECT imageset_path, imageset_name

FROM ' . STYLES_IMAGESET_TABLE . "

WHERE imageset_id = $imageset_id";

$imageset_path = $imageset_row['imageset_path'];

$imageset_name = $imageset_row['imageset_name'];

if (strpos($imgname, '-') !== false)

{

list($imgname, $imgnamelang) = explode('-', $imgname);

}

$sql = 'SELECT image_filename, image_width, image_height, image_lang, image_id

FROM ' . STYLES_IMAGESET_DATA_TABLE . "

WHERE imageset_id = $imageset_id

$image_filename = $imageset_data_row['image_filename'];

$image_width = $imageset_data_row['image_width'];

if ($imageset_data_row)

{

$sql = 'UPDATE ' . STYLES_IMAGESET_DATA_TABLE . '

WHERE image_id = $image_id";

}

// does not exist

else if (!$imageset_data_row)

{

$sql_ary['image_name'] = $imgname;

$sql_ary['imageset_id'] = (int) $imageset_id;

}

phpbb::$acm->destroy_sql(STYLES_IMAGESET_DATA_TABLE);

$sql = "SELECT $sql_select

FROM $sql_from

WHERE {$mode}_id = $style_id";

if (!$style_row)

{

WHERE {$mode}_id <> $style_id

$sql_where

ORDER BY {$mode}_name ASC";

$s_options = '';

{

do

{

$s_options .= '<option value="' . $row[$mode . '_id'] . '">' . $row[$mode . '_name'] . '</option>';

}

}

else

{

trigger_error(phpbb::$user->lang['ONLY_' . $l_prefix] . adm_back_link($this->u_action), E_USER_WARNING);

}

if ($update)

{

$sql = "DELETE FROM $sql_from

WHERE {$mode}_id = $style_id";

if ($mode == 'style')

{

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_style = $new_id

WHERE user_style = $style_id";

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET forum_style = $new_id

WHERE forum_style = $style_id";

if ($style_id == phpbb::$config['default_style'])

{

{

$sql = 'DELETE FROM ' . STYLES_IMAGESET_DATA_TABLE . "

WHERE imageset_id = $style_id";

}

$sql = 'UPDATE ' . STYLES_TABLE . "

SET {$mode}_id = $new_id

WHERE {$mode}_id = $style_id";

}

phpbb::$acm->destroy_sql(STYLES_TABLE);

$sql = "SELECT $sql_select

FROM $sql_from

WHERE $sql_where";

if (!$style_row)

{

FROM ' . STYLES_IMAGESET_DATA_TABLE . "

WHERE imageset_id = $style_id

AND image_lang = ''";

{

$imageset_main[$row['image_name']] = $row['image_filename'] . ($row['image_height'] ? '*' . $row['image_height']: '') . ($row['image_width'] ? '*' . $row['image_width']: '');

}

foreach ($this->imageset_keys as $topic => $key_array)

{

FROM ' . STYLES_IMAGESET_DATA_TABLE . "

WHERE imageset_id = $style_id

AND image_lang <> ''";

{

$imageset_lang[$row['image_lang']][$row['image_name']] = $row['image_filename'] . ($row['image_height'] ? '*' . $row['image_height']: '') . ($row['image_width'] ? '*' . $row['image_width']: '');

}

foreach ($imageset_lang as $lang => $imageset_localized)

{

$sql = "SELECT {$mode}_id, {$mode}_name

FROM " . (($mode == 'style') ? STYLES_TABLE : $sql_from) . "

WHERE {$mode}_id = $style_id";

if (!$style_row)

{

$sql = "SELECT *

FROM $sql_from

WHERE {$mode}_id = $style_id";

if (!$style_row)

{

$sql = "SELECT {$mode}_id

FROM $sql_from

WHERE {$mode}_id <> $style_id

if ($mode == 'style' && (!$template_id || !$theme_id || !$imageset_id))

{

if (sizeof($sql_ary))

{

$sql = "UPDATE $sql_from

WHERE {$mode}_id = $style_id";

// Making this the default style?

if ($mode == 'style' && $style_default)

$sql = "SELECT {$element}_id, {$element}_name

FROM $table

ORDER BY {$element}_id ASC";

${$element . '_options'} = '';

{

$selected = ($row[$element . '_id'] == $style_row[$element . '_id']) ? ' selected="selected"' : '';

${$element . '_options'} .= '<option value="' . $row[$element . '_id'] . '"' . $selected . '>' . $row[$element . '_name'] . '</option>';

}

}

}

$sql = "SELECT $sql_select

FROM $sql_from

WHERE {$mode}_id = $basis";

if (!$row)

{

$sql = "SELECT {$element}_id, {$element}_name

FROM $table

ORDER BY {$element}_id ASC";

${$element . '_options'} = '';

{

$selected = ($row[$element . '_id'] == $style_row[$element . '_id']) ? ' selected="selected"' : '';

${$element . '_options'} .= '<option value="' . $row[$element . '_id'] . '"' . $selected . '>' . $row[$element . '_name'] . '</option>';

}

}

}

// get all the lang_dirs

$sql = 'SELECT lang_dir

FROM ' . LANG_TABLE;

{

$lang_dirs[] = $row['lang_dir'];

}

// get all imagesets this theme is associated with

$sql = 'SELECT si.imageset_id, si.imageset_path, st.template_path

WHERE s.theme_id = ' . (int) $theme['theme_id'] . '

AND s.imageset_id = si.imageset_id

AND s.template_id = st.template_id';

{

foreach ($lang_dirs as $lang_dir)

{

FROM ' . STYLES_IMAGESET_DATA_TABLE . '

WHERE imageset_id = ' . $theme['imageset_id'] . "

AND image_filename <> ''

$img_array = array();

{

$img_array[$row['image_name']] = $row;

}

$specific_theme_data = str_replace(array_keys($replace), array_values($replace), $theme['theme_data']);

file_put_contents(PHPBB_ROOT_PATH . '/store/' . $theme['theme_id'] . '_' . $theme['imageset_id'] . '_' . $lang_dir . '.css', $specific_theme_data, LOCK_EX);

}

}

}

/**

$sql = "SELECT {$element}_id, {$element}_name

FROM $sql_from

{

$name = $row[$element . '_name'];

$id = $row[$element . '_id'];

unset($cfg);

}

}

/**

// Check if the name already exist

$sql = 'SELECT style_id

FROM ' . STYLES_TABLE . "

if ($row)

{

return false;

}

$sql_ary = array(

'style_name' => $name,

);

$sql = 'INSERT INTO ' . STYLES_TABLE . '

if ($default)

{

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_style = $id

WHERE user_style = " . phpbb::$config['default_style'];

set_config('default_style', $id);

}

add_log('admin', 'LOG_STYLE_ADD', $name);

}

// Check if the name already exist

$sql = "SELECT {$mode}_id

FROM $sql_from

if ($row)

break;

}

$sql = "INSERT INTO $sql_from

if ($mode == 'imageset')

{

'imageset_id' => (int) $id,

'image_lang' => '',

);

}

}

}

$sql = 'SELECT lang_dir

FROM ' . LANG_TABLE;

{

if (@file_exists("$root_path$mode/{$row['lang_dir']}/imageset.cfg"))

{

'imageset_id' => (int) $id,

'image_lang' => $row['lang_dir'],

);

}

}

}

unset($cfg_data_imageset_data);

}

}

}

$log = ($store_db) ? 'LOG_' . $l_type . '_ADD_DB' : 'LOG_' . $l_type . '_ADD_FS';

add_log('admin', $log, $name);

$sql = 'SELECT config_value

FROM ' . CONFIG_TABLE . "

WHERE config_name = 'version_update_from'";

$current_version = (!empty($version_update_from)) ? $version_update_from : phpbb::$config['version'];

{

$sql = 'SELECT user_id

FROM ' . USERS_TABLE . "

if (!$user_id)

{

LEFT JOIN ' . SESSIONS_TABLE . ' s ON (s.session_user_id = u.user_id)

WHERE u.user_id = ' . $user_id . '

ORDER BY s.session_time DESC';

if (!$user_row)

{

AND module_enabled = 1

AND module_class = 'acp'

ORDER BY left_id, module_mode";

$dropdown_modes = array();

{

if (!$this->p_master->module_auth($row['module_auth']))

{

$dropdown_modes[$row['module_mode']] = true;

}

foreach ($dropdown_modes as $module_mode => $null)

{

$sql = 'SELECT DISTINCT poster_ip

FROM ' . POSTS_TABLE . "

WHERE poster_id = $user_id";

{

$ban[] = $row['poster_ip'];

}

$reason = 'USER_ADMIN_BAN_IP_REASON';

$log = 'LOG_USER_BAN_IP';

user_active_flip('deactivate', $user_id, INACTIVE_REMIND);

$sql = 'UPDATE ' . USERS_TABLE . "

WHERE user_id = $user_id";

}

else

{

$sql = 'SELECT user_actkey

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

$messenger = new messenger(false);

'user_sig_bbcode_bitfield' => ''

);

WHERE user_id = $user_id";

add_log('admin', 'LOG_USER_DEL_SIG', $user_row['username']);

add_log('user', $user_id, 'LOG_USER_DEL_SIG_USER');

);

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = $user_id";

// Delete old avatar if present

if ($user_row['user_avatar'] && $user_row['user_avatar_type'] != AVATAR_GALLERY)

$sql = 'SELECT forum_name, forum_type

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $new_forum_id";

if (!$forum_info)

{

WHERE poster_id = $user_id

AND forum_id <> $new_forum_id

GROUP BY topic_id";

{

$topic_id_ary[$row['topic_id']] = $row['total_posts'];

}

if (sizeof($topic_id_ary))

{

$sql = 'SELECT topic_id, forum_id, topic_title, topic_replies, topic_replies_real, topic_attachment

FROM ' . TOPICS_TABLE . '

{

if (max($row['topic_replies'], $row['topic_replies_real']) + 1 == $topic_id_ary[$row['topic_id']])

{

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

}

}

// Entire topic comprises posts by this user, move these topics

foreach ($move_post_ary as $topic_id => $post_ary)

{

// Create new topic

'topic_poster' => $user_id,

'topic_time' => time(),

'forum_id' => $new_forum_id,

'topic_time_limit' => 0,

'topic_attachment' => $post_ary['attach'])

);

// Move posts

$sql = 'UPDATE ' . POSTS_TABLE . "

SET forum_id = $new_forum_id, topic_id = $new_topic_id

WHERE topic_id = $topic_id

AND poster_id = $user_id";

if ($post_ary['attach'])

{

SET topic_id = $new_topic_id

WHERE topic_id = $topic_id

AND poster_id = $user_id";

}

$new_topic_id_ary[] = $new_topic_id;

FROM ' . USERS_TABLE . '

WHERE user_type = ' . phpbb::USER_FOUNDER . '

AND user_id <> ' . $user_id;

if ($row)

{

if (sizeof($sql_ary))

{

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

if ($update_username)

$sql = 'SELECT MAX(session_time) AS session_time, MIN(session_viewonline) AS session_viewonline

FROM ' . SESSIONS_TABLE . "

WHERE session_user_id = $user_id";

$user_row['session_time'] = (isset($row['session_time'])) ? $row['session_time'] : 0;

$user_row['session_viewonline'] = (isset($row['session_viewonline'])) ? $row['session_viewonline'] : 0;

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $user_id . '

AND post_approved = 0';

$template->assign_vars(array(

'L_NAME_CHARS_EXPLAIN' => sprintf(phpbb::$user->lang[phpbb::$config['allow_name_chars'] . '_EXPLAIN'], phpbb::$config['min_name_chars'], phpbb::$config['max_name_chars']),

{

$sql_in[] = $mark;

}

unset($sql_in);

}

$sql = 'DELETE FROM ' . LOG_TABLE . '

WHERE log_type = ' . LOG_USERS . "

$where_sql";

add_log('admin', 'LOG_CLEAR_USER', $user_row['username']);

}

$sql = 'SELECT lang_id

FROM ' . LANG_TABLE . "

$user_row['iso_lang_id'] = $row['lang_id'];

);

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = $user_id";

// Update Custom Fields

if (sizeof($cp_data))

{

{

case 'oracle':

case 'firebird':

}

$sql = 'UPDATE ' . PROFILE_FIELDS_DATA_TABLE . '

WHERE user_id = $user_id";

{

$cp_data['user_id'] = (int) $user_id;

}

}

);

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = $user_id";

trigger_error(phpbb::$user->lang['USER_PREFS_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_rank = $rank_id

WHERE user_id = $user_id";

trigger_error(phpbb::$user->lang['USER_RANK_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

FROM ' . RANKS_TABLE . '

WHERE rank_special = 1

ORDER BY rank_title';

$s_rank_options = '<option value="0"' . ((!$user_row['user_rank']) ? ' selected="selected"' : '') . '>' . phpbb::$user->lang['NO_SPECIAL_RANK'] . '</option>';

{

$selected = ($user_row['user_rank'] && $row['rank_id'] == $user_row['user_rank']) ? ' selected="selected"' : '';

$s_rank_options .= '<option value="' . $row['rank_id'] . '"' . $selected . '>' . $row['rank_title'] . '</option>';

}

$template->assign_vars(array(

'S_RANK' => true,

);

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

trigger_error(phpbb::$user->lang['USER_SIG_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

FROM ' . ATTACHMENTS_TABLE . '

WHERE poster_id = ' . $user_id . '

AND is_orphan = 0

$marked = array();

{

$marked[] = $row['attach_id'];

}

}

if ($deletemark && sizeof($marked))

{

$sql = 'SELECT real_filename

FROM ' . ATTACHMENTS_TABLE . '

$log_attachments = array();

{

$log_attachments[] = $row['real_filename'];

}

delete_attachments('attach', $marked);

FROM ' . ATTACHMENTS_TABLE . "

WHERE poster_id = $user_id

AND is_orphan = 0";

$sql = 'SELECT a.*, t.topic_title, p.message_subject as message_title

FROM ' . ATTACHMENTS_TABLE . ' a

WHERE a.poster_id = ' . $user_id . "

AND a.is_orphan = 0

ORDER BY $order_by";

{

if ($row['in_message'])

{

'U_VIEW_TOPIC' => $view_topic)

);

}

$template->assign_vars(array(

'S_ATTACHMENTS' => true,

$sql = 'SELECT group_founder_manage

FROM ' . GROUPS_TABLE . '

WHERE group_id = ' . $group_id;

if (!phpbb::$user->is_founder && $founder_manage)

{

WHERE ug.user_id = $user_id

AND g.group_id = ug.group_id

ORDER BY g.group_type DESC, ug.user_pending ASC, g.group_name";

$i = 0;

$group_data = $id_ary = array();

{

$type = ($row['group_type'] == GROUP_SPECIAL) ? 'special' : (($row['user_pending']) ? 'pending' : 'normal');

$i++;

}

// Select box for other groups

$sql = 'SELECT group_id, group_name, group_type, group_founder_manage

FROM ' . GROUPS_TABLE . '

ORDER BY group_type DESC, group_name ASC';

$s_group_options = '';

{

if (!phpbb::$config['coppa_enable'] && $row['group_name'] == 'REGISTERED_COPPA')

{

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

}

$current_type = '';

foreach ($group_data as $group_type => $data_ary)

// Select auth options

$sql = 'SELECT auth_option, is_local, is_global

FROM ' . ACL_OPTIONS_TABLE . '

AND is_global = 1

ORDER BY auth_option';

$hold_ary = array();

{

$hold_ary = $auth_admin->get_mask('view', $user_id, false, false, $row['auth_option'], 'global', phpbb::ACL_NEVER);

$auth_admin->display_mask('view', $row['auth_option'], $hold_ary, 'user', false, false);

}

unset($hold_ary);

}

{

$sql = 'SELECT auth_option, is_local, is_global

FROM ' . ACL_OPTIONS_TABLE . "

AND is_local = 1

ORDER BY is_global DESC, auth_option";

{

$hold_ary = $auth_admin->get_mask('view', $user_id, false, $forum_id, $row['auth_option'], 'local', phpbb::ACL_NEVER);

$auth_admin->display_mask('view', $row['auth_option'], $hold_ary, 'user', true, false);

}

}

$s_forum_options = '<option value="0"' . ((!$forum_id) ? ' selected="selected"' : '') . '>' . phpbb::$user->lang['VIEW_GLOBAL_PERMS'] . '</option>';

$sql = 'SELECT *

FROM ' . WORDS_TABLE . "

WHERE word_id = $word_id";

$s_hidden_fields .= '<input type="hidden" name="id" value="' . $word_id . '" />';

if ($word_id)

{

}

else

{

}

phpbb::$acm->destroy('word_censors');

$sql = 'SELECT word

FROM ' . WORDS_TABLE . "

WHERE word_id = $word_id";

$sql = 'DELETE FROM ' . WORDS_TABLE . "

WHERE word_id = $word_id";

phpbb::$acm->destroy('word_censors');

$sql = 'SELECT *

FROM ' . WORDS_TABLE . '

ORDER BY word';

{

$template->assign_block_vars('words', array(

'WORD' => $row['word'],

'U_DELETE' => $this->u_action . '&amp;action=delete&amp;id=' . $row['word_id'])

);

}

}

}

$sql = 'SELECT auth_option_id, auth_option, is_global, is_local

FROM ' . ACL_OPTIONS_TABLE . '

ORDER BY auth_option_id';

$global = $local = 0;

$this->acl_options = array();

{

if ($row['is_global'])

{

$this->acl_options['id'][$row['auth_option']] = (int) $row['auth_option_id'];

$this->acl_options['option'][(int) $row['auth_option_id']] = $row['auth_option'];

}

phpbb::$acm->put('acl_options', $this->acl_options);

}

{

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE;

{

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

}

}

if ($view_user_mask)

$sql = 'SELECT user_id, user_permissions, user_type

FROM ' . USERS_TABLE . '

{

if (phpbb::$user->data['user_id'] != $userdata['user_id'])

{

}

}

}

unset($userdata);

unset($auth2);

FROM ' . ACL_USERS_TABLE . '

WHERE auth_role_id = ' . $role_id . '

ORDER BY forum_id';

{

$hold_ary[$row['forum_id']]['users'][] = $row['user_id'];

}

// Now grab groups...

$sql = 'SELECT group_id, forum_id

FROM ' . ACL_GROUPS_TABLE . '

WHERE auth_role_id = ' . $role_id . '

ORDER BY forum_id';

{

$hold_ary[$row['forum_id']]['groups'][] = $row['group_id'];

}

return $hold_ary;

}

{

$sql = 'SELECT user_id as ug_id, username as ug_name

FROM ' . USERS_TABLE . '

ORDER BY username_clean ASC';

}

else

{

$sql = 'SELECT group_id as ug_id, group_name as ug_name, group_type

FROM ' . GROUPS_TABLE . '

ORDER BY group_type DESC, group_name ASC';

}

$ug_names_ary = array();

{

$ug_names_ary[$row['ug_id']] = ($user_mode == 'user') ? $row['ug_name'] : (($row['group_type'] == GROUP_SPECIAL) ? phpbb::$user->lang['G_' . $row['ug_name']] : $row['ug_name']);

}

// Get used forums

$forum_ids = array();

// Get available roles

$sql = 'SELECT *

FROM ' . ACL_ROLES_TABLE . "

ORDER BY role_order ASC";

$roles = array();

{

$roles[$row['role_id']] = $row;

}

$cur_roles = $this->acl_role_data($user_mode, $permission_type, array_keys($hold_ary));

$sql = 'SELECT r.role_id, o.auth_option, r.auth_setting

FROM ' . ACL_ROLES_DATA_TABLE . ' r, ' . ACL_OPTIONS_TABLE . ' o

WHERE o.auth_option_id = r.auth_option_id

{

$flag = substr($row['auth_option'], 0, strpos($row['auth_option'], '_') + 1);

if ($flag == $row['auth_option'])

$s_role_js_array[$row['role_id']] .= 'role_options[' . $row['role_id'] . '][\'' . addslashes($row['auth_option']) . '\'] = ' . $row['auth_setting'] . '; ';

}

$s_role_js_array = implode('', $s_role_js_array);

}

$sql = 'SELECT group_id, group_name, group_type

FROM ' . GROUPS_TABLE . '

ORDER BY group_type DESC, group_name ASC';

$groups = array();

{

$groups[$row['group_id']] = $row;

}

$memberships = group_memberships(false, array_keys($hold_ary), false);

// Get forum names

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE . '

ORDER BY left_id';

// If the role is used globally, then reflect that

$forum_names = (isset($hold_ary[0])) ? array(0 => '') : array();

{

$forum_names[$row['forum_id']] = $row['forum_name'];

}

foreach ($forum_names as $forum_id => $forum_name)

{

{

$sql = 'SELECT user_id, username

FROM ' . USERS_TABLE . '

ORDER BY username_clean ASC';

{

$template->assign_block_vars('role_mask.users', array(

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

'U_PROFILE' => append_sid('memberlist', "mode=viewprofile&amp;u={$row['user_id']}"))

);

}

}

if (isset($auth_ary['groups']) && sizeof($auth_ary['groups']))

{

$sql = 'SELECT group_id, group_name, group_type

FROM ' . GROUPS_TABLE . '

ORDER BY group_type ASC, group_name';

{

$template->assign_block_vars('role_mask.groups', array(

'GROUP_ID' => $row['group_id'],

'U_PROFILE' => append_sid('memberlist', "mode=group&amp;g={$row['group_id']}"))

);

}

}

}

}

$sql = 'SELECT auth_option, is_global, is_local

FROM ' . ACL_OPTIONS_TABLE . '

ORDER BY auth_option_id';

{

if ($row['is_global'])

{

$cur_options['local'][] = $row['auth_option'];

}

}

// Here we need to insert new options ... this requires discovering whether

// an options is global, local or both and whether we need to add an permission

}

}

phpbb::$acm->destroy('acl_options');

$this->acl_clear_prefetch();

$ug_id = array($ug_id);

}

// Instead of updating, inserting, removing we just remove all current settings and re-set everything...

$table = ($ug_type == 'user') ? ACL_USERS_TABLE : ACL_GROUPS_TABLE;

$sql = "DELETE FROM $table

WHERE $forum_sql

AND $ug_id_sql

// Remove those having a role assigned... the correct type of course...

$sql = 'SELECT role_id

FROM ' . ACL_ROLES_TABLE . "

$role_ids = array();

{

$role_ids[] = $row['role_id'];

}

if (sizeof($role_ids))

{

WHERE $forum_sql

AND $ug_id_sql

AND auth_option_id = 0

}

// Ok, include the any-flag if one or more auth options are set to yes...

}

}

if ($clear_prefetch)

{

// Remove current auth options...

$sql = 'DELETE FROM ' . ACL_ROLES_DATA_TABLE . '

WHERE role_id = ' . $role_id;

// Now insert the new values

$this->acl_clear_prefetch();

}

if ($forum_id !== false)

{

}

if ($ug_id !== false)

{

}

// There seem to be auth options involved, therefore we need to go through the list and make sure we capture roles correctly

// Get permission type

$sql = 'SELECT auth_option, auth_option_id

FROM ' . ACL_OPTIONS_TABLE . "

$auth_id_ary = array();

{

$option_id_ary[] = $row['auth_option_id'];

$auth_id_ary[$row['auth_option']] = phpbb::ACL_NO;

}

// First of all, lets grab the items having roles with the specified auth options assigned

$sql = "SELECT auth_role_id, $id_field, forum_id

AND r.role_type = '{$permission_type}'

AND " . implode(' AND ', $where_sql) . '

ORDER BY auth_role_id';

$cur_role_auth = array();

{

$cur_role_auth[$row['auth_role_id']][$row['forum_id']][] = $row[$id_field];

}

// Get role data for resetting data

if (sizeof($cur_role_auth))

$sql = 'SELECT ao.auth_option, rd.role_id, rd.auth_setting

FROM ' . ACL_OPTIONS_TABLE . ' ao, ' . ACL_ROLES_DATA_TABLE . ' rd

WHERE ao.auth_option_id = rd.auth_option_id

$auth_settings = array();

{

// We need to fill all auth_options, else setting it will fail...

if (!isset($auth_settings[$row['role_id']]))

}

$auth_settings[$row['role_id']][$row['auth_option']] = $row['auth_setting'];

}

// Set the options

foreach ($cur_role_auth as $role_id => $auth_row)

// Now, normally remove permissions...

if ($permission_type !== false)

{

}

$sql = "DELETE FROM $table

WHERE " . implode(' AND ', $where_sql);

$this->acl_clear_prefetch();

}

}

$sql = 'UPDATE ' . USERS_TABLE . "

user_perm_from = $from_user_id

WHERE user_id = " . $to_user_id;

return true;

}