- $file = '<?php $this->vars=' . $this->format_array($this->vars) . ";\n\$this->var_expires=" . $this->format_array($this->var_expires) . ' ?>';

- function format_array($array)

- $lines[] = "\n'$k' => " . $this->format_array($v);

- $lines[] = "\n'$k' => $v";

- $lines[] = "\n'$k' => " . (($v) ? 'true' : 'false');

- $lines[] = "\n'$k' => '" . str_replace("'", "\\'", str_replace('\\', '\\\\', $v)) . "'";

- return array_shift($this->sql_rowset[$query_id]);

- $l_legend_cat_images = $user->lang['SETTINGS_CAT_IMAGES'] . ' [' . $user->lang['ASSIGNED_GROUP'] . ': ' . ((sizeof($s_assigned_groups[ATTACHMENT_CATEGORY_IMAGE])) ? implode(', ', $s_assigned_groups[ATTACHMENT_CATEGORY_IMAGE]) : $user->lang['NONE']) . ']';

- 'secure_allow_empty_referer' => array('lang' => 'SECURE_EMPTY_REFERER', 'type' => 'radio:yes_no', 'explain' => true),

- WHERE extension_id IN (' . implode(', ', $extension_id_list) . ')';

- WHERE extension_id IN (' . implode(', ', $extension_id_list) . ')';

- WHERE extension_id IN (" . implode(', ', $extension_list) . ")";

- ATTACHMENT_CATEGORY_NONE => $user->lang['NONE'],

- $imglist = filelist($phpbb_root_path . $img_path);

- $imglist = array_values($imglist);

- $imglist = $imglist[0];

-

- foreach ($imglist as $key => $img)

- if (!$ext_group_row['upload_icon'])

- {

- $no_image_select = true;

- $selected = '';

- }

- else

- $selected = ($ext_group_row['upload_icon'] == $img) ? ' selected="selected"' : '';

- }

- $filename_list .= '<option value="' . htmlspecialchars($img) . '"' . $selected . '>' . htmlspecialchars($img) . '</option>';

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

- WHERE post_id IN (' . implode(', ', array_keys($upload_list)) . ')';

- ATTACHMENT_CATEGORY_NONE => $user->lang['NONE'],

- 'comment' => $message_parser->filename_data['filecomment'],

- $exe = ((defined('PHP_OS')) && (preg_match('#win#i', PHP_OS))) ? '.exe' : '';

- $unip_sql = implode(', ', array_map('intval', $_POST['unip']));

- if ($unip_sql != '')

-

- FROM ' . SITELIST_TABLE . "

- WHERE site_id IN ($unip_sql)";

- $sql = 'DELETE FROM ' . SITELIST_TABLE . "

- WHERE site_id IN ($unip_sql)";

- $bbcode_match = $bbcode_tpl = '';

- $sql = 'SELECT bbcode_match, bbcode_tpl, display_on_posting

- if ($bbcode_id > 31)

- reset($tokens[$token_type]);

- list($match, $replace) = each($tokens[$token_type]);

- $bbcode_tag = preg_replace('/.*?\[([a-z]+=?).*/i', '$1', $bbcode_match);

- 'board_timezone' => array('lang' => 'SYSTEM_TIMEZONE', 'type' => 'select', 'function' => 'tz_select', 'params' => array('{CONFIG_VALUE}'), 'explain' => false),

- 'default_style' => array('lang' => 'DEFAULT_STYLE', 'type' => 'select', 'function' => 'style_select', 'params' => array('{CONFIG_VALUE}', true), 'explain' => false),

- 'pm_edit_time' => array('lang' => 'PM_EDIT_TIME', 'type' => 'text:3:3', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

- 'auth_download_pm' => array('lang' => 'ALLOW_DOWNLOAD_PM', 'type' => 'radio:yes_no', 'explain' => false),

- 'edit_time' => array('lang' => 'EDIT_TIME', 'type' => 'text:3:3', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

- 'coppa_hide_groups' => array('lang' => 'COPPA_HIDE_GROUPS', 'type' => 'radio:yes_no', 'explain' => true),

- )

- );

- break;

-

- case 'visual':

- $display_vars = array(

- 'title' => 'ACP_VC_SETTINGS',

- 'vars' => array(

- 'legend1' => 'GENERAL_OPTIONS',

- 'enable_confirm' => array('lang' => 'VISUAL_CONFIRM_REG', 'type' => 'radio:yes_no', 'explain' => true),

- 'enable_post_confirm' => array('lang' => 'VISUAL_CONFIRM_POST', 'type' => 'radio:yes_no', 'explain' => true),

-

- 'legend2' => 'CAPTCHA_OPTIONS',

- 'policy_overlap' => array('lang' => 'CAPTCHA_OVERLAP', 'type' => 'radio:yes_no', 'explain' => false),

- 'policy_overlap_noise_pixel' => array('lang' => 'OVERLAP_NOISE_PIXEL', 'type' => 'select', 'method' => 'captcha_pixel_noise_select', 'explain' => false),

- 'policy_overlap_noise_line' => array('lang' => 'OVERLAP_NOISE_LINE', 'type' => 'radio:yes_no', 'explain' => false),

- 'policy_entropy' => array('lang' => 'CAPTCHA_ENTROPY', 'type' => 'radio:yes_no', 'explain' => false),

- 'policy_entropy_noise_pixel' => array('lang' => 'ENTROPY_NOISE_PIXEL', 'type' => 'select', 'method' => 'captcha_pixel_noise_select', 'explain' => false),

- 'policy_entropy_noise_line' => array('lang' => 'ENTROPY_NOISE_LINE', 'type' => 'radio:yes_no', 'explain' => false),

- 'policy_shape' => array('lang' => 'CAPTCHA_SHAPE', 'type' => 'radio:yes_no', 'explain' => false),

- 'policy_shape_noise_pixel' => array('lang' => 'SHAPE_NOISE_PIXEL', 'type' => 'select', 'method' => 'captcha_pixel_noise_select', 'explain' => false),

- 'policy_shape_noise_line' => array('lang' => 'SHAPE_NOISE_LINE', 'type' => 'radio:yes_no', 'explain' => false),

- 'policy_3dbitmap' => array('lang' => 'CAPTCHA_3DBITMAP', 'type' => 'radio:yes_no', 'explain' => false),

- 'policy_cells' => array('lang' => 'CAPTCHA_CELLS', 'type' => 'radio:yes_no', 'explain' => false),

- 'policy_stencil' => array('lang' => 'CAPTCHA_STENCIL', 'type' => 'radio:yes_no', 'explain' => false),

- 'policy_composite' => array('lang' => 'CAPTCHA_COMPOSITE', 'type' => 'radio:yes_no', 'explain' => false),

- 'load_db_track' => array('lang' => 'YES_POST_MARKING', 'type' => 'radio:yes_no', 'explain' => true),

- 'load_db_lastread' => array('lang' => 'YES_READ_MARKING', 'type' => 'radio:yes_no', 'explain' => true),

- 'load_online' => array('lang' => 'YES_ONLINE', 'type' => 'radio:yes_no', 'explain' => true),

- 'load_online_guests' => array('lang' => 'YES_ONLINE_GUESTS', 'type' => 'radio:yes_no', 'explain' => true),

- 'load_onlinetrack' => array('lang' => 'YES_ONLINE_TRACK', 'type' => 'radio:yes_no', 'explain' => true),

- 'load_birthdays' => array('lang' => 'YES_BIRTHDAYS', 'type' => 'radio:yes_no', 'explain' => false),

- 'load_moderators' => array('lang' => 'YES_MODERATORS', 'type' => 'radio:yes_no', 'explain' => false),

- 'load_jumpbox' => array('lang' => 'YES_JUMPBOX', 'type' => 'radio:yes_no', 'explain' => false),

- 'load_user_activity' => array('lang' => 'LOAD_USER_ACTIVITY','type' => 'radio:yes_no', 'explain' => true),

- 'load_tplcompile' => array('lang' => 'RECOMPILE_TEMPLATES', 'type' => 'radio:yes_no', 'explain' => true),

- 'allow_autologin' => array('lang' => 'ALLOW_AUTOLOGIN', 'type' => 'radio:yes_no', 'explain' => true),

- 'max_autologin_time' => array('lang' => 'AUTOLOGIN_LENGTH', 'type' => 'text:5:5', 'explain' => true),

- 'ip_check' => array('lang' => 'IP_VALID', 'type' => 'custom', 'method' => 'select_ip_check', 'explain' => true),

- 'browser_check' => array('lang' => 'BROWSER_VALID', 'type' => 'radio:yes_no', 'explain' => true),

- 'pass_complex' => array('lang' => 'PASSWORD_TYPE', 'type' => 'select', 'method' => 'select_password_chars', 'explain' => true),

- 'chg_passforce' => array('lang' => 'FORCE_PASS_CHANGE', 'type' => 'text:3:3', 'explain' => true),

- 'max_login_attempts' => array('lang' => 'MAX_LOGIN_ATTEMPTS','type' => 'text:3:3', 'explain' => true),

- 'tpl_allow_php' => array('lang' => 'TPL_ALLOW_PHP', 'type' => 'radio:yes_no', 'explain' => true),

- $cfg_array = (isset($_REQUEST['config'])) ? request_var('config', array('' => '')) : $this->new_config;

- $method = 'admin_' . $method;

- $method = 'admin_' . $method;

- * Select captcha pixel noise

- */

- function captcha_pixel_noise_select($value, $key = '')

- {

- global $user;

-

- return '<option value="0"' . (($value == 0) ? ' selected="selected"' : '') . '>' . $user->lang['NONE'] . '</option><option value="1"' . (($value == 1) ? ' selected="selected"' : '') . '>' . $user->lang['LIGHT'] . '</option><option value="2"' . (($value == 2) ? ' selected="selected"' : '') . '>' . $user->lang['MEDIUM'] . '</option><option value="3"' . (($value == 3) ? ' selected="selected"' : '') . '>' . $user->lang['HEAVY'] . '</option>';

- }

-

- /**

- $radio_ary = array(4 => 'ALL', 3 => 'CLASS_C', 2 => 'CLASS_B', 0 => 'NONE');

- WHERE user_id IN (" . implode(', ', $user_id_ary) . ')';

- $filename = time();

- $sql_data .= "BEGIN TRANSACTION\nGO\n";

- case 'sqlite':

- $sql_data .= "DROP TABLE $table_name;\n\\\n";

- $sql_data .= "DROP TABLE $table_name;\nGO\n";

- $sql = "SELECT * FROM $table_name";

- $sql = "SELECT * FROM $table_name";

- $col_types = sqlite_fetch_column_types($table_name, $db->db_connect_id);

- $sql = "SELECT * FROM $table_name";

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

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

- FROM {$table_name}";

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

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

- $seq .= "SELECT SETVAL('{$table_name}_seq',(select case when max({$ary_name[$i]})>0 then max({$ary_name[$i]})+1 else 1 end from {$table_name}));\n";

- $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES(' . implode(', ', $schema_vals) . ");\n";

- FROM {$table_name}";

- FROM INFORMATION_SCHEMA.COLUMNS

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

- $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES(' . implode(', ', $schema_vals) . ");\n";

- FROM {$table_name}";

- FROM INFORMATION_SCHEMA.COLUMNS

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

- $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES(' . implode(', ', $schema_vals) . ");\n";

- FROM {$table_name}";

- $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES(' . implode(', ', $schema_vals) . ");\n";

- FROM {$table_name}";

- $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES(' . implode(', ', $schema_vals) . ");\n";

- $sql = "SELECT relname

- ORDER BY relname;";

- preg_match('#^(\d{10})\.(sql(?:\.(?:gz|bz2))?)$#', $file, $matches);

- switch (SQL_LAYER)

- {

- case 'firebird':

- $delim = ';;';

- break;

- case 'mysql':

- case 'mysql4':

- case 'mysqli':

- case 'sqlite':

- case 'postgres':

- $delim = ';';

- break;

- case 'oracle':

- $delim = '/';

- break;

- case 'mssql':

- case 'mssql-odbc':

- $delim = 'GO';

- break;

- }

- $pieces = split_sql_file($data, $delim);

- $sql_count = count($pieces);

- for($i = 0; $i < $sql_count; $i++)

- {

- $sql = trim($pieces[$i]);

- if (!empty($sql) && $sql[0] != '#')

- $db->sql_query($sql);

- if (preg_match('#^(\d{10})\.(sql(?:\.(?:gz|bz2))?)$#', $file, $matches))

- $result = $db->sql_query("SHOW KEYS FROM $table_name");

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

- $sql_pri_keys = "SELECT ic.relname AS index_name, bc.relname AS tab_name, ta.attname AS column_name, i.indisunique AS unique_key, i.indisprimary AS primary_key

- ORDER BY index_name, tab_name, column_name ";

- $line .= ' CONSTRAINT [DF_' . $table_name . '_' . $row['COLUMN_NAME'] . '] DEFAULT ' . $row['COLUMN_DEFAULT'];

- $sql = 'SELECT DISTINCT R.RDB$FIELD_NAME AS FNAME, R.RDB$NULL_FLAG AS NFLAG, R.RDB$DEFAULT_SOURCE AS DSOURCE, F.RDB$FIELD_TYPE AS FTYPE, F.RDB$FIELD_SUB_TYPE AS STYPE, F.RDB$FIELD_LENGTH AS FLEN

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

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

- $sql = "SELECT COLUMN_NAME, DATA_TYPE, DATA_PRECISION, DATA_LENGTH, NULLABLE, DATA_DEFAULT from ALL_TAB_COLS where table_name = '{$table_name}'";

- $usernames = implode(', ', preg_replace('#^[\s]*?(.*?)[\s]*?$#e', "\"'\" . \$db->sql_escape('\\1') . \"'\"", explode("\n", $usernames)));

-

- FROM ' . USERS_TABLE . "

- WHERE username IN ($usernames)

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

- $db->sql_freeresult($result);

- }

- 'forum_desc_bitfield' => 0,

- 'forum_rules_bitfield' => 0,

- generate_text_for_storage($forum_data['forum_rules'], $forum_data['forum_rules_uid'], $forum_data['forum_rules_bitfield'], request_var('rules_parse_bbcode', false), request_var('rules_parse_urls', false), request_var('rules_parse_smilies', false));

- generate_text_for_storage($forum_data['forum_desc'], $forum_data['forum_desc_uid'], $forum_data['forum_desc_bitfield'], request_var('desc_parse_bbcode', false), request_var('desc_parse_urls', false), request_var('desc_parse_smilies', false));

- if ($forum_perm_from && $action == 'add')

- $sql = 'SELECT forum_name

- $forum_data['forum_flags'] = 0;

- $forum_data['forum_flags'] += (request_var('forum_link_track', false)) ? 1 : 0;

- $forum_data['forum_flags'] += (request_var('prune_old_polls', false)) ? 2 : 0;

- $forum_data['forum_flags'] += (request_var('prune_announce', false)) ? 4 : 0;

- $forum_data['forum_flags'] += (request_var('prune_sticky', false)) ? 8 : 0;

- $forum_data['forum_flags'] += ($forum_data['show_active']) ? 16 : 0;

- $parents_list = make_forum_select($forum_data['parent_id'], $forum_id, false, false, false);

- $forum_data['forum_rules_bitfield'] = 0;

- generate_text_for_storage($forum_data['forum_rules'], $forum_data['forum_rules_uid'], $forum_data['forum_rules_bitfield'], request_var('rules_allow_bbcode', false), request_var('rules_allow_urls', false), request_var('rules_allow_smiliess', false));

- $forum_rules_preview = generate_text_for_display($forum_data['forum_rules'], $forum_data['forum_rules_uid'], $forum_data['forum_rules_bitfield']);

- $forum_rules_data = generate_text_for_edit($forum_data['forum_rules'], $forum_data['forum_rules_uid'], $forum_data['forum_rules_bitfield']);

- $forum_data['forum_desc_bitfield'] = 0;

- generate_text_for_storage($forum_data['forum_desc'], $forum_data['forum_desc_uid'], $forum_data['forum_desc_bitfield'], request_var('desc_allow_bbcode', false), request_var('desc_allow_urls', false), request_var('desc_allow_smiliess', false));

- $forum_desc_data = generate_text_for_edit($forum_data['forum_desc'], $forum_data['forum_desc_uid'], $forum_data['forum_desc_bitfield']);

- 'L_TITLE' => $user->lang[$this->page_title],

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

- 'S_FORUM_OPTIONS' => make_forum_select(false, false, false),

- 'S_FORUM_LINK_TRACK' => ($forum_data['forum_flags'] & 1) ? true : false,

- 'FORUM_DESCRIPTION' => generate_text_for_display($row['forum_desc'], $row['forum_desc_uid'], $row['forum_desc_bitfield']),

- AND forum_id NOT IN (' . implode(', ', $moved_ids) . ')';

- AND forum_id NOT IN (' . implode(', ', $moved_ids) . ')';

- WHERE forum_id NOT IN (' . implode(', ', $moved_ids) . ')';

- WHERE forum_id IN (" . implode(', ', $moved_ids) . ')';

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

-

- $forum_ids = array($forum_id);

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

- if (!isset($forum_ids) || !is_array($forum_ids))

- {

- $forum_ids = array($forum_id);

- }

-

- $id_list = implode(', ', $ids);

- $db->sql_query("DELETE FROM $table WHERE $field IN ($id_list)");

- trigger_error($user->lang[$message] . adm_back_link($this->u_action));

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

- trigger_error($user->lang[$error] . adm_back_link($this->u_action));

- trigger_error($user->lang[$message] . adm_back_link($this->u_action));

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

- trigger_error($user->lang[$error] . adm_back_link($this->u_action));

- trigger_error($user->lang[$message] . adm_back_link($this->u_action));

- $group_desc_data = generate_text_for_edit($group_row['group_desc'], $group_row['group_desc_uid'], $group_row['group_desc_bitfield']);

- 'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&amp;form=list&amp;field=usernames'))

- 'U_DEFAULT' => "{$this->u_action}&amp;action=default&amp;g=$group_id",

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

- do

- if ($action == 'add')

- {

- unset($_images[$row[$fields . '_url']]);

- }

- if ($row[$fields . '_id'] == $icon_id)

- $after = true;

- else

- {

- if ($action == 'edit' && !$icon_id)

- {

- $data[$row[$fields . '_url']] = $row;

- }

-

- $selected = '';

- if (!empty($after))

- {

- $selected = ' selected="selected"';

- $after = false;

- }

- $after_txt = ($mode == 'smilies') ? $row['code'] : $row['icons_url'];

- $order_list = '<option value="' . ($row[$fields . '_order']) . '"' . $selected . '>' . sprintf($user->lang['AFTER_' . $lang], ' -&gt; ' . htmlspecialchars($after_txt)) . '</option>' . $order_list;

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

- $fields . '_url' => $image,

- $fields . '_width' => $image_width[$image],

- $fields . '_height' => $image_height[$image],

- 'display_on_posting'=> (isset($image_display_on_posting[$image])) ? 1 : 0,

- 'emotion' => $image_emotion[$image],

- 'code' => $image_code[$image])

-

- $result = $db->sql_query("SELECT $field_sql FROM $table");

- if ((sizeof($data[1]) != 3 && $mode == 'icons') ||

- (sizeof($data[1]) != 5 && $mode == 'smilies'))

- if (isset($data[1][3]) && isset($data[1][4]))

- $emotion = stripslashes($data[1][3]);

- $code = stripslashes($data[1][4]);

- $fields . '_url' => $img,

- $fields . '_height' => (int) $height,

- $fields . '_width' => (int) $width,

- 'emotion' => $emotion

- $fields . '_url' => $img,

- $fields . '_height' => (int) $height,

- $fields . '_width' => (int) $width,

- $fields . '_order' => (int) $order,

- 'code' => $code,

- 'emotion' => $emotion

-

-

- $db->sql_close();

- trigger_error($user->lang['NO_' . $fields . '_EXPORT'] . adm_back_link($this->u_action));

- $db->sql_query("DELETE FROM $table

- WHERE {$fields}_id = $icon_id");

- $entry = $_POST['entry'];

- foreach ($entry as $key => $value)

- {

- if (is_array($value))

- {

- foreach ($value as $key2 => $data)

- {

- $entry[$key][$key2] = htmlentities($data);

- }

- }

- else

- {

- $entry[$key] = htmlentities($value);

- }

- }

-

- $hidden_data = build_hidden_fields(array('file' => $this->language_file, 'dir' => $this->language_directory, 'method' => $method, 'entry' => $entry));

- $sql = 'SELECT * FROM ' . LANG_TABLE . "

- $sql = 'SELECT * FROM ' . LANG_TABLE . "

- $entry = (STRIP) ? stripslashes($_POST['entry']) : $_POST['entry'];

- $entry = preg_replace('#&amp;(\#[0-9]+;)#', '&\1', $entry);

- else

- {

- $entry = "\tarray(\n";

- foreach ($value as $_key => $_value)

- {

- $_value = (STRIP) ? stripslashes($_value) : $_value;

- $_value = preg_replace('#&amp;(\#[0-9]+;)#', '&\1', $_value);

- $entry .= "\t\t" . (int) $_key . "\t=> '" . str_replace("'", "\\'", $_value) . "',\n";

- }

-

- $entry .= "\t),\n";

-

- }

- if (!is_array($value))

- {

- $value = (STRIP) ? stripslashes($value) : $value;

- $value = preg_replace('#&amp;(\#[0-9]+;)#', '&\1', $value);

- $entry = "\t'" . $key . "'\t=> '" . str_replace("'", "\\'", $value) . "',\n";

- }

- else

- {

- $entry = "\n\t'" . $key . "'\t=> array(\n";

-

- foreach ($value as $_key => $_value)

- {

- $_value = (STRIP) ? stripslashes($_value) : $_value;

- $_value = preg_replace('#&amp;(\#[0-9]+;)#', '&\1', $_value);

- $entry .= "\t\t'" . $_key . "'\t=> '" . str_replace("'", "\\'", $_value) . "',\n";

- }

-

- $entry .= "\t),\n\n";

- }

-

- }

- fwrite($fp, $footer);

- $sql = 'SELECT lang_iso FROM ' . LANG_TABLE . "

- $sql = 'SELECT * FROM ' . LANG_TABLE . '

- $sql = 'SELECT * FROM ' . LANG_TABLE . '

- $sql = 'SELECT lang_iso FROM ' . LANG_TABLE . "

- $sql = 'SELECT * FROM ' . LANG_TABLE . '

- if ($use_method == 'zip')

- FROM ' . LANG_TABLE;

- $this->main_files = array("common.$phpEx", "groups.$phpEx", "mcp.$phpEx", "memberlist.$phpEx", "posting.$phpEx", "search.$phpEx", "ucp.$phpEx", "viewforum.$phpEx", "viewtopic.$phpEx", "help_bbcode.$phpEx", "help_faq.$phpEx");

-

- $tpl .= '

- <tr>

- <td class="row1" style="white-space: nowrap;">' . $key_prefix . '<b>' . $_key . '</b></td>

- <td class="row2">';

-

- if ($input_field)

- $tpl .= '<input type="text" name="entry[' . $key . '][' . $_key . ']" value="' . htmlspecialchars($_value) . '" size="50" />';

- $tpl .= '<b>' . htmlspecialchars($_value) . '</b>';

-

- $tpl .= '</td>

- </tr>';

- if ($deletemark && $marked)

- $where_sql = ' AND log_id IN (' . implode(', ', $sql_in) . ')';

- $sort_by_sql = array('u' => 'l.user_id', 't' => 'l.log_time', 'i' => 'l.log_ip', 'o' => 'l.log_operation');

- $mark = (isset($_REQUEST['mark'])) ? implode(', ', request_var('mark', array(0))) : '';

- if ($mark)

- FROM ' . USERS_TABLE . "

- WHERE user_id IN ($mark)";

- $mark_ary = explode(', ', $mark);

- foreach ($mark_ary as $user_id)

- set_config('num_users', $config['num_users'] + sizeof($mark_ary), true);

- $sql = 'DELETE FROM ' . USER_GROUP_TABLE . " WHERE user_id IN ($mark)";

- $sql = 'DELETE FROM ' . USERS_TABLE . " WHERE user_id IN ($mark)";

- FROM ' . USERS_TABLE . "

- WHERE user_id IN ($mark)";

- $post_count_ary = $auth->acl_getf('f_postcount');

- $forum_read_ary = $auth->acl_getf('f_read');

-

- $forum_ary = array();

- foreach ($post_count_ary as $forum_id => $allowed)

- {

- if ($allowed['f_postcount'] && $forum_read_ary[$forum_id]['f_read'])

- {

- $forum_ary[] = $forum_id;

- }

- }

- if (!sizeof($forum_ary))

- $db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_posts = 0');

- }

- else

- {

- $sql = 'SELECT COUNT(post_id) AS num_posts, poster_id

- FROM ' . POSTS_TABLE . '

- WHERE poster_id <> ' . ANONYMOUS . '

- AND forum_id IN (' . implode(', ', $forum_ary) . ')

- GROUP BY poster_id';

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

-

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

- {

- $db->sql_query('UPDATE ' . USERS_TABLE . " SET user_posts = {$row['num_posts']} WHERE user_id = {$row['poster_id']}");

- }

- $db->sql_freeresult($result);

- $sql = 'SELECT user_id, username, user_regdate

- list($module_name, $module_mode) = explode('::', $quick_install);

- $fileinfo = $this->get_module_infos($module_name);

- $fileinfo = $fileinfo[$module_name];

- 'module_name' => $module_name,

- 'module_name' => '',

- $module_data['module_name'] = request_var('module_name', (string) $module_row['module_name']);

- $module_data['module_name'] = $module_data['module_mode'] = $module_data['module_auth'] = '';

- if ($module_data['module_name'] && $module_data['module_mode'])

- $fileinfo = $this->get_module_infos($module_data['module_name']);

- $module_data['module_auth'] = $fileinfo[$module_data['module_name']]['modes'][$module_data['module_mode']]['auth'];

- $is_cat = (!$module_data['module_name']) ? true : false;

- if (!$module_data['module_name'])

- $module_data['module_name'] = $option;

- $s_name_options .= '<option value="' . $option . '"' . (($option == $module_data['module_name']) ? ' selected="selected"' : '') . '>' . $this->lang_name($values['title']) . ' [' . $this->module_class . '_' . $option . ']</option>';

- if ($option == $module_data['module_name'])

- $module_image = (!$row['module_name'] || $row['left_id'] + 1 != $row['right_id']) ? '<img src="images/icon_subfolder.gif" width="46" height="25" alt="' . $user->lang['CATEGORY'] . '" />' : '<img src="images/icon_folder.gif" width="46" height="25" alt="' . $user->lang['MODULE'] . '" />';

- switch (SQL_LAYER)

- {

- case 'firebird':

- $sql = 'SELECT module_id, module_enabled, "module_name", parent_id, module_langname, left_id, right_id, module_auth

- FROM ' . MODULES_TABLE . "

- WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

- ORDER BY left_id ASC";

- break;

-

- default:

- $sql = 'SELECT module_id, module_enabled, module_name, parent_id, module_langname, left_id, right_id, module_auth

- FROM ' . MODULES_TABLE . "

- WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

- ORDER BY left_id ASC";

- break;

- }

- if (!$row['module_name'] && ($row['left_id'] + 1 == $row['right_id']) && $ignore_emptycat)

- if ($row['module_name'] && $ignore_noncat)

- if (!$row = $db->sql_fetchrow($result))

- $db->sql_freeresult($result);

- if ($module_data['module_name'] && !$row['module_name'])

-

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

- AND module_id NOT IN (' . implode(', ', $moved_ids) . ')';

- AND module_id NOT IN (' . implode(', ', $moved_ids) . ')';

- AND module_id NOT IN (" . implode(', ', $moved_ids) . ')';

- AND module_id IN (" . implode(', ', $moved_ids) . ')';

- $auth_options[$row['auth_option']] = ACL_UNSET;

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

- $auth_options[$row['auth_option']] = ACL_UNSET;

- 'S_YES' => ($cat_array['S_YES'] && !$cat_array['S_NO'] && !$cat_array['S_UNSET']) ? true : false,

- 'S_NO' => ($cat_array['S_NO'] && !$cat_array['S_YES'] && !$cat_array['S_UNSET']) ? true : false,

- 'S_UNSET' => ($cat_array['S_UNSET'] && !$cat_array['S_NO'] && !$cat_array['S_YES']) ? true : false)

- 'S_UNSET' => ($allowed == ACL_UNSET) ? true : false,

- $auth_settings[$row['auth_option']] = ACL_UNSET;

- $username = request_var('username', array(''), true);

- $usernames = request_var('usernames', '', true);

- $sql_and = ($config['coppa_hide_groups']) ? " AND group_name NOT IN ('INACTIVE_COPPA', 'REGISTERED_COPPA')" : '';

- $this->remove_permissions($mode, $permission_type, $auth_admin, $user_id, $group_id, $forum_id);

- $forum_list = make_forum_select(false, false, true, false, false, true);

- $sql_forum_id = ($permission_scope == 'global') ? 'AND a.forum_id = 0' : ((sizeof($forum_id)) ? 'AND a.forum_id IN (' . implode(', ', $forum_id) . ')' : 'AND a.forum_id <> 0');

- $sql_permission_option = "AND o.auth_option LIKE '" . $db->sql_escape($permission_type) . "%'";

-

- $sql = $db->sql_build_query('SELECT_DISTINCT', array(

- 'SELECT' => 'u.username, u.user_regdate, u.user_id',

-

- 'FROM' => array(

- USERS_TABLE => 'u',

- ACL_OPTIONS_TABLE => 'o',

- ACL_USERS_TABLE => 'a'

- ),

-

- 'LEFT_JOIN' => array(

- array(

- 'FROM' => array(ACL_ROLES_DATA_TABLE => 'r'),

- 'ON' => 'a.auth_role_id = r.role_id'

- )

- ),

-

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

- $sql_permission_option

- $sql_forum_id

- AND u.user_id = a.user_id",

-

- 'ORDER_BY' => 'u.username, u.user_regdate ASC'

- ));

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

-

- $s_defined_user_options = '';

- $defined_user_ids = array();

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

- {

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

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

- }

- $db->sql_freeresult($result);

-

- $sql = $db->sql_build_query('SELECT_DISTINCT', array(

- 'SELECT' => 'g.group_type, g.group_name, g.group_id',

-

- 'FROM' => array(

- GROUPS_TABLE => 'g',

- ACL_OPTIONS_TABLE => 'o',

- ACL_GROUPS_TABLE => 'a'

- ),

-

- 'LEFT_JOIN' => array(

- array(

- 'FROM' => array(ACL_ROLES_DATA_TABLE => 'r'),

- 'ON' => 'a.auth_role_id = r.role_id'

- )

- ),

-

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

- $sql_permission_option

- $sql_forum_id

- AND g.group_id = a.group_id",

-

- 'ORDER_BY' => 'g.group_type DESC, g.group_name ASC'

- ));

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

-

- $s_defined_group_options = '';

- $defined_group_ids = array();

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

- {

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

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

- }

- $db->sql_freeresult($result);

- if ($all_users && sizeof($defined_user_ids))

- $user_id = $defined_user_ids;

- if ($all_groups && sizeof($defined_group_ids))

- $group_id = $defined_group_ids;

- 'S_DEFINED_USER_OPTIONS' => $s_defined_user_options,

- 'S_DEFINED_GROUP_OPTIONS' => $s_defined_group_options,

- 'S_ADD_GROUP_OPTIONS' => group_select_options(false, $defined_group_ids),

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

- $hold_ary = $auth_admin->get_mask('set', (sizeof($user_id)) ? $user_id : false, (sizeof($group_id)) ? $group_id : false, (sizeof($forum_id)) ? $forum_id : false, $permission_type, $permission_scope, ACL_UNSET);

- $hold_ary = $auth_admin->get_mask('view', (sizeof($user_id)) ? $user_id : false, (sizeof($group_id)) ? $group_id : false, (sizeof($forum_id)) ? $forum_id : false, $permission_type, $permission_scope, ACL_NO);

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

- // We need to add any ACL_UNSET setting from auth_settings to compare correctly

- if ($setting == ACL_UNSET)

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

- $sql .= ' IN (' . implode(', ', array_map('intval', $ug_id)) . ')';

- WHERE forum_id IN (' . implode(', ', $forum_id) . ')';

- WHERE zebra_id IN (' . implode(', ', array_unique($perms)) . ')

- 'S_SETTING_UNSET' => true,

- 'S_TOTAL_UNSET' => true)

- 'auth_setting' => ACL_UNSET,

- $total = ACL_UNSET;

- case ACL_UNSET:

- $information = $user->lang['TRACE_GROUP_UNSET'];

- $information = ($total == ACL_YES) ? $user->lang['TRACE_GROUP_YES_TOTAL_YES'] : (($total == ACL_NO) ? $user->lang['TRACE_GROUP_YES_TOTAL_NO'] : $user->lang['TRACE_GROUP_YES_TOTAL_UNSET']);

- $total = ($total == ACL_UNSET) ? ACL_YES : $total;

- case ACL_NO:

- $information = ($total == ACL_YES) ? $user->lang['TRACE_GROUP_NO_TOTAL_YES'] : (($total == ACL_NO) ? $user->lang['TRACE_GROUP_NO_TOTAL_NO'] : $user->lang['TRACE_GROUP_NO_TOTAL_UNSET']);

- $total = ACL_NO;

- 'S_SETTING_UNSET' => ($row['auth_setting'] == ACL_UNSET) ? true : false,

- 'S_SETTING_YES' => ($row['auth_setting'] == ACL_YES) ? true : false,

- 'S_TOTAL_UNSET' => ($total == ACL_UNSET) ? true : false,

- 'S_TOTAL_NO' => ($total == ACL_NO) ? true : false)

- $auth_setting = (!sizeof($hold_ary)) ? ACL_UNSET : $hold_ary[$user_id][$forum_id][$permission];

- case ACL_UNSET:

- $information = ($total == ACL_UNSET) ? $user->lang['TRACE_USER_UNSET_TOTAL_UNSET'] : $user->lang['TRACE_USER_KEPT'];

- $total = ($total == ACL_UNSET) ? ACL_NO : $total;

- $information = ($total == ACL_YES) ? $user->lang['TRACE_USER_YES_TOTAL_YES'] : (($total == ACL_NO) ? $user->lang['TRACE_USER_YES_TOTAL_NO'] : $user->lang['TRACE_USER_YES_TOTAL_UNSET']);

- $total = ($total == ACL_UNSET) ? ACL_YES : $total;

- case ACL_NO:

- $information = ($total == ACL_YES) ? $user->lang['TRACE_USER_NO_TOTAL_YES'] : (($total == ACL_NO) ? $user->lang['TRACE_USER_NO_TOTAL_NO'] : $user->lang['TRACE_USER_NO_TOTAL_UNSET']);

- $total = ACL_NO;

- 'S_SETTING_UNSET' => ($auth_setting == ACL_UNSET) ? true : false,

- 'S_SETTING_YES' => ($auth_setting == ACL_YES) ? true : false,

- 'S_TOTAL_UNSET' => false,

- 'S_TOTAL_NO' => ($total == ACL_NO) ? true : false)

- $information = ($total == ACL_YES) ? $user->lang['TRACE_USER_GLOBAL_YES_TOTAL_YES'] : $user->lang['TRACE_USER_GLOBAL_YES_TOTAL_NO'];

- $information = $user->lang['TRACE_USER_GLOBAL_NO_TOTAL_KEPT'];

- 'S_SETTING_UNSET' => false,

- 'S_SETTING_NO' => !$auth_setting,

- 'S_TOTAL_UNSET' => false,

- 'S_TOTAL_NO' => ($total == ACL_NO) ? true : false)

- 'S_SETTING_UNSET' => ($auth_setting == ACL_UNSET) ? true : false,

- 'S_SETTING_YES' => ($auth_setting == ACL_YES) ? true : false,

- 'S_TOTAL_UNSET' => false,

- 'S_TOTAL_NO' => false)

- FROM ' . LANG_TABLE;

- ORDER BY lang_id';

- $db->sql_query(preg_replace('#CREATE\s+TABLE\s+' . PROFILE_FIELDS_DATA_TABLE . '#i', 'CREATE TEMPORARY TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp', $row['sql']));

- $new_table_cols = $matches[1];

- $entities = preg_split('#\s+#', $declaration);

- if ($entities[0] !== $field_ident)

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

- $db->sql_query('ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " DROP $field_ident");

- $sql = 'SELECT * FROM ' . PROFILE_FIELDS_LANG_TABLE . '

- ORDER BY option_id ASC";

- $lang_options[$row['option_id']] = $row['value'];

- $sql = 'SELECT * FROM ' . PROFILE_FIELDS_LANG_TABLE . '

- $l_lang_options[$row['lang_id']][$row['option_id']] = $row['value'];

- $sql = 'SELECT lang_id, lang_name, lang_explain, lang_default_value FROM ' . PROFILE_LANG_TABLE . '

- $error[] = $user->lang['EMPTY_USER_FIELD_IDENT'];

- }

- WHERE lang_iso <> '" . $config['default_lang'] . "'";

- $db->sql_query('INSERT INTO ' . PROFILE_FIELDS_TABLE . ' ' . $db->sql_build_array('INSERT', $profile_fields));

- $db->sql_query('UPDATE ' . PROFILE_FIELDS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $profile_fields) . "

- WHERE field_id = $field_id");

- switch (SQL_LAYER)

- {

- case 'mysql':

- case 'mysql4':

- case 'mysqli':

-

- // We are defining the biggest common value, because of the possibility to edit the min/max values of each field.

- $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD `$field_ident` ";

- switch ($field_type)

- {

- case FIELD_STRING:

- $sql .= ' VARCHAR(255) ';

- break;

-

- case FIELD_DATE:

- $sql .= 'VARCHAR(10) ';

- break;

-

- case FIELD_TEXT:

- $sql .= "TEXT";

- // ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,

- // ADD {$field_ident}_bbcode_bitfield INT(11) UNSIGNED";

- break;

-

- case FIELD_BOOL:

- $sql .= 'TINYINT(2) ';

- break;

-

- case FIELD_DROPDOWN:

- $sql .= 'MEDIUMINT(8) ';

- break;

-

- case FIELD_INT:

- $sql .= 'BIGINT(20) ';

- break;

- }

-

- break;

-

- case 'sqlite':

-

- switch ($field_type)

- {

- case FIELD_STRING:

- $type = ' VARCHAR(255) ';

- break;

-

- case FIELD_DATE:

- $type = 'VARCHAR(10) ';

- break;

-

- case FIELD_TEXT:

- $type = "TEXT(65535)";

- // ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,

- // ADD {$field_ident}_bbcode_bitfield INT(11) UNSIGNED";

- break;

-

- case FIELD_BOOL:

- $type = 'TINYINT(2) ';

- break;

-

- case FIELD_DROPDOWN:

- $type = 'MEDIUMINT(8) ';

- break;

-

- case FIELD_INT:

- $type = 'BIGINT(20) ';

- break;

- }

-

- // We are defining the biggest common value, because of the possibility to edit the min/max values of each field.

- if (version_compare(sqlite_libversion(), '3.0') == -1)

- {

- $sql = "SELECT sql

- FROM sqlite_master

- WHERE type = 'table'

- AND name = '" . PROFILE_FIELDS_DATA_TABLE . "'

- ORDER BY type DESC, name;";

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

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

- $db->sql_freeresult($result);

-

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

- $db->sql_query(preg_replace('#CREATE\s+TABLE\s+' . PROFILE_FIELDS_DATA_TABLE . '#i', 'CREATE TEMPORARY TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp', $row['sql']));

- $db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . '_temp SELECT * FROM ' . PROFILE_FIELDS_DATA_TABLE);

- $db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE);

-

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

-

- $new_table_cols = $matches[1];

- $old_table_cols = explode(',', $new_table_cols);

- $column_list = array();

- foreach($old_table_cols as $declaration)

- {

- $entities = preg_split('#\s+#', $declaration);

- $column_list[] = $entities[0];

- }

-

- $columns = implode(',', $column_list);

-

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

-

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

- $db->sql_query('CREATE TABLE ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $new_table_cols . ');');

- $db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . PROFILE_FIELDS_DATA_TABLE . '_temp;');

- $db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp');

- }

- else

- {

- $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD $field_ident $type";

- }

-

-

- break;

-

- case 'mssql':

- case 'mssql_odbc':

-

- // We are defining the biggest common value, because of the possibility to edit the min/max values of each field.

- $sql = 'ALTER TABLE [' . PROFILE_FIELDS_DATA_TABLE . "] ADD $field_ident ";

-

- switch ($field_type)

- {

- case FIELD_STRING:

- $sql .= ' [VARCHAR] (255) ';

- break;

-

- case FIELD_DATE:

- $sql .= '[VARCHAR] (10) ';

- break;

-

- case FIELD_TEXT:

- $sql .= "[TEXT]";

- // ADD {$field_ident}_bbcode_uid [VARCHAR] (5) NOT NULL,

- // ADD {$field_ident}_bbcode_bitfield [INT] UNSIGNED";

- break;

-

- case FIELD_BOOL:

- case FIELD_DROPDOWN:

- $sql .= '[INT] ';

- break;

-

- case FIELD_INT:

- $sql .= '[FLOAT] ';

- break;

- }

-

- break;

-

- case 'postgres':

-

- // We are defining the biggest common value, because of the possibility to edit the min/max values of each field.

- $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD COLUMN $field_ident ";

-

- switch ($field_type)

- {

- case FIELD_STRING:

- $sql .= ' VARCHAR(255) ';

- break;

-

- case FIELD_DATE:

- $sql .= 'VARCHAR(10) ';

- break;

-

- case FIELD_TEXT:

- $sql .= "TEXT";

- // ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,

- // ADD {$field_ident}_bbcode_bitfield INT4 UNSIGNED";

- break;

-

- case FIELD_BOOL:

- $sql .= 'INT2 ';

- break;

-

- case FIELD_DROPDOWN:

- $sql .= 'INT4 ';

- break;

-

- case FIELD_INT:

- $sql .= 'INT8 ';

- break;

- }

-

- break;

-

- case 'firebird':

-

- // We are defining the biggest common value, because of the possibility to edit the min/max values of each field.

- $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD $field_ident ";

-

- switch ($field_type)

- {

- case FIELD_STRING:

- $sql .= ' VARCHAR(255) ';

- break;

-

- case FIELD_DATE:

- $sql .= 'VARCHAR(10) ';

- break;

-

- case FIELD_TEXT:

- $sql .= "BLOB SUB_TYPE TEXT";

- // ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,

- // ADD {$field_ident}_bbcode_bitfield INTEGER UNSIGNED";

- break;

-

- case FIELD_BOOL:

- case FIELD_DROPDOWN:

- $sql .= 'INTEGER ';

- break;

-

- case FIELD_INT:

- $sql .= 'DOUBLE PRECISION ';

- break;

- }

-

- break;

-

- case 'oracle':

-

- // We are defining the biggest common value, because of the possibility to edit the min/max values of each field.

- $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD $field_ident ";

- switch ($field_type)

- {

- case FIELD_STRING:

- $sql .= ' VARCHAR2(255) ';

- break;

-

- case FIELD_DATE:

- $sql .= 'VARCHAR2(10) ';

- break;

-

- case FIELD_TEXT:

- $sql .= "CLOB";

- // ADD {$field_ident}_bbcode_uid VARCHAR2(5) NOT NULL,

- // ADD {$field_ident}_bbcode_bitfield NUMBER(11) UNSIGNED";

- break;

-

- case FIELD_BOOL:

- $sql .= 'NUMBER(2) ';

- break;

-

- case FIELD_DROPDOWN:

- $sql .= 'NUMBER(8) ';

- break;

-

- case FIELD_INT:

- $sql .= 'NUMBER(20) ';

- break;

- }

-

- break;

- }

-

- $profile_sql[] = $sql;

- 'lang_name' => $cp->vars['lang_name'],

- 'lang_explain' => $cp->vars['lang_explain'],

- 'value' => $value

- 'field_id' => $field_id,

- 'lang_id' => (int) $default_lang_id,

- 'option_id' => (int) $option_id)

- 'value' => $value

- add_log('admin', 'LOG_PROFILE_FIELD_CREATE', $field_ident . ':' . $cp->vars['lang_name']);

- $sql_forum = (sizeof($forum_id)) ? ' AND forum_id IN (' . implode(', ', $forum_id) . ')' : '';

- WHERE forum_id IN (' . implode(', ', $forum_id) . ')';

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

-

- $where_sql = '';

-

- foreach ($users as $username)

- {

- $where_sql .= (($where_sql != '') ? ', ' : '') . "'" . $db->sql_escape($username) . "'";

- }

- $where_sql = " AND username IN ($where_sql)";

- $username = request_var('username', '', true);

- 'username' => request_var('username', '', true),

- $min_posts = ($special_rank) ? -1 : request_var('min_posts', 0);

- $img = substr($path, 1) . (($path != '') ? '/' : '') . $img;

- WHERE LOWER(reason_title) = '" . strtolower($reason_row['reason_title']) . "'";

- // Change the reports using this reason to 'other'

- $sql = 'UPDATE ' . REPORTS_TABLE . '

- SET reason_id = ' . $other_reason_id . ", report_text = CONCAT('" . $db->sql_escape($reason_row['reason_description']) . "\n\n', report_text)

- WHERE reason_id = $reason_id";

- $sql = 'SELECT post_id, poster_id

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

- $this->search->index_remove($ids, $posters);

- $sql = 'SELECT post_id, post_subject, post_text, poster_id

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

- $this->search->index('post', $row['post_id'], $row['post_text'], $row['post_subject'], $row['poster_id']);

- define('TEMPLATE_BITFIELD', 6921);

- $this->imageset_keys = 'site_logo, btn_post, btn_post_pm, btn_reply, btn_reply_pm, btn_locked, btn_profile, btn_pm, btn_delete, btn_info, btn_quote, btn_search, btn_edit, btn_report, btn_email, btn_www, btn_icq, btn_aim, btn_yim, btn_msnm, btn_jabber, btn_online, btn_offline, btn_friend, btn_foe, icon_unapproved, icon_reported, icon_attach, icon_post, icon_post_new, icon_post_latest, icon_post_newest, forum, forum_new, forum_locked, forum_link, sub_forum, sub_forum_new, folder, folder_moved, folder_posted, folder_new, folder_new_posted, folder_hot, folder_hot_posted, folder_hot_new, folder_hot_new_posted, folder_locked, folder_locked_posted, folder_locked_new, folder_locked_new_posted, folder_sticky, folder_sticky_posted, folder_sticky_new, folder_sticky_new_posted, folder_announce, folder_announce_posted, folder_announce_new, folder_announce_new_posted, folder_global, folder_global_posted, folder_global_new, folder_global_new_posted, poll_left, poll_center, poll_right, attach_progress_bar, user_icon1, user_icon2, user_icon3, user_icon4, user_icon5, user_icon6, user_icon7, user_icon8, user_icon9, user_icon10';

- $this->frontend('style', array('details', 'export', 'delete'));

- $this->frontend('template', array('cache', 'details', 'refresh', 'edit', 'export', 'delete'));

- $this->frontend('theme', array('details', 'refresh', 'edit', 'export', 'delete'));

- $this->frontend('imageset', array('details', 'edit', 'delete', 'export'));

- function frontend($mode, $options)

- $template_data = (!empty($_POST['template_data'])) ? ((STRIP) ? stripslashes($_POST['template_data']) : $_POST['template_data']) : '';

- // we want newlines no carriage returns!

- $template_data = str_replace(array("\n\r", "\r"), array("\n", "\n"), $template_data);

-

- $code = str_replace(array("\n\r", "\r"), array("\n", "\n"), file_get_contents("{$phpbb_root_path}cache/{$cache_prefix}_$source.html.$phpEx"));

- $css_data = (!empty($_POST['css_data'])) ? ((STRIP) ? stripslashes($_POST['css_data']) : $_POST['css_data']) : '';

- // we want newlines no carriage returns!

- $css_data = str_replace(array("\n\r", "\r"), array("\n", "\n"), $css_data);

-

- $imglist = filelist($phpbb_root_path . 'styles/' . $theme_info['theme_name'] . '/theme');

- $s_units = '<option value=""' . (($unit == '') ? ' selected="selected"' : '') . '>' . $user->lang['NONE'] . '</option>' . $s_units;

- foreach ($imglist as $path => $img_ary)

- $s_imglist = '<option value=""' . (($value == '') ? ' selected="selected"' : '') . '>' . $user->lang['NONE'] . '</option>' . $s_imglist;

- unset($imglist, $css_elements);

- $imglist = array(

- 'logos' => array(

- 'site_logo',

- ),

- 'buttons' => array(

- 'btn_post', 'btn_reply', 'btn_locked', 'btn_quote', 'btn_edit', 'btn_delete', 'btn_report', 'btn_post_pm', 'btn_reply_pm', 'btn_profile', 'btn_pm', 'btn_info', 'btn_search', 'btn_email', 'btn_www', 'btn_icq', 'btn_aim', 'btn_yim', 'btn_msnm', 'btn_jabber', 'btn_online', 'btn_offline',

- ),

- 'icons' => array(

- 'icon_unapproved', 'icon_reported', 'icon_attach', 'icon_post', 'icon_post_new', 'icon_post_latest', 'icon_post_newest',),

- 'forums' => array(

- 'forum', 'forum_new', 'forum_locked', 'forum_link', 'sub_forum', 'sub_forum_new',),

- 'folders' => array(

- 'folder', 'folder_posted', 'folder_new', 'folder_new_posted', 'folder_hot', 'folder_hot_posted', 'folder_hot_new', 'folder_hot_new_posted', 'folder_locked', 'folder_locked_posted', 'folder_locked_new', 'folder_locked_new_posted', 'folder_sticky', 'folder_sticky_posted', 'folder_sticky_new', 'folder_sticky_new_posted', 'folder_announce', 'folder_announce_posted', 'folder_announce_new', 'folder_announce_new_posted',),

- 'polls' => array(

- 'poll_left', 'poll_center', 'poll_right',),

- );

- foreach ($imglist as $category => $img_ary)

- foreach ($imglist as $category => $img_ary)

- 'IMAGE_REQUEST' => (!empty($imgname)) ? '../styles/' . $imageset_path . '/imageset/' . str_replace('{LANG}', $imglang, $img_info[0]) : '',

- global $db, $template, $user, $phpbb_root_path, $cache;

- $imageset_definitions = explode(', ', $this->imageset_keys);

-

- foreach ($imageset_definitions as $key)

- $imageset_cfg .= "\n" . $key . ' = ' . str_replace("styles/{$style_row['imageset_path']}/imageset/", '{PATH}', $style_row[$key]);

- $path = $style_row[$mode . '_path'];

- 'template_filename' => "$template_pathfile$file",

- $this->install_style($error, 'add', '', $style_row['style_id'], $style_row['style_name'], $style_row['style_copyright'], $style_row['style_active'], $style_row['style_default'], $style_row);

- if ($mode != 'imageset')

- switch ($mode)

- {

- case 'template':

- // We set a pre-defined bitfield here which we may use further in 3.2

- $sql_ary += array(

- 'bbcode_bitfield' => TEMPLATE_BITFIELD,

- 'template_storedb' => $store_db

- );

- break;

- case 'theme':

- $sql_ary += array(

- 'theme_storedb' => $store_db,

- 'theme_data' => ($store_db) ? (($root_path) ? $this->db_theme_data($sql_ary, false, $root_path) : '') : '',

- 'theme_mtime' => filemtime("{$phpbb_root_path}styles/$path/theme/stylesheet.css")

- );

- break;

- }

- }

- else

- {

- $cfg_data = parse_cfg_file("$root_path$mode/imageset.cfg");

- foreach ($cfg_data as $key => $value)

- {

- if (strpos($key, 'img_') === 0)

- $key = substr($key, 4);

- $sql_ary[$key] = str_replace('{PATH}', "styles/$path/imageset/", trim($value));

- }

- unset($cfg_data);

- $username = request_var('username', '', true);

- if (!$this->is_authed($ary['auth']))

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

- WHERE topic_id IN (' . implode(', ', array_keys($topic_id_ary)) . ')';

- WHERE topic_id IN (' . implode(', ', $del_topic_ary) . ')';

- WHERE topic_id IN (' . implode(', ', array_keys($topic_id_ary)) . ')';

- 'password_confirm' => array('string', true, $config['min_pass_chars'], $config['max_pass_chars']),

- if (($user_row['user_type'] == USER_FOUNDER && !$data['user_founder']) || ($user_row['user_type'] != USER_FOUNDER && $data['user_founder']))

- $sql_ary['user_type'] = ($data['user_founder']) ? USER_FOUNDER : USER_NORMAL;

- $quick_tool_ary = array('banuser' => 'BAN_USER', 'banemail' => 'BAN_EMAIL', 'banip' => 'BAN_IP', 'active' => (($user_row['user_type'] == USER_INACTIVE) ? 'ACTIVATE' : 'DEACTIVATE'), 'delsig' => 'DEL_SIG', 'delavatar' => 'DEL_AVATAR', 'moveposts' => 'MOVE_POSTS', 'delposts' => 'DEL_POSTS', 'delattach' => 'DEL_ATTACH');

-

- if ($config['email_enable'])

- $quick_tool_ary['reactivate'] = 'FORCE';

- $where_sql = ' AND log_id IN (' . implode(', ', $sql_in) . ')';

- $sort_by_sql = array('u' => 'l.user_id', 't' => 'l.log_time', 'i' => 'l.log_ip', 'o' => 'l.log_operation');

- 'lang' => array('match', false, '#^[a-z_]{2,}$#i'),

- 'S_TZ_OPTIONS' => tz_select($tz),

- 'S_SMILIES_ALLOWED' => $config['allow_sig_smilies'],)

- WHERE attach_id IN (' . implode(', ', $marked) . ')';

- 'COMMENT' => nl2br($row['comment']),

- ' . ((sizeof($id_ary)) ? 'WHERE group_id NOT IN (' . implode(', ', $id_ary) . ')' : '') . '

- if ($config['coppa_hide_groups'] && in_array($row['group_name'], array('INACTIVE_COPPA', 'REGISTERED_COPPA')))

- WHERE auth_option LIKE '%\_'

- AND is_global = 1

- ORDER BY auth_option";

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

- WHERE auth_option LIKE '%\_'

- AND is_local = 1

- ORDER BY is_global DESC, auth_option";

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

-

- /**

- * Check if user is allowed to call this user mode

- */

- function is_authed($module_auth)

- {

- global $config, $auth;

-

- $module_auth = trim($module_auth);

-

- if (!$module_auth)

- {

- return true;

- }

-

- $is_auth = false;

- eval('$is_auth = (int) (' . preg_replace(array('#acl_([a-z_]+)(,\$id)?#', '#\$id#', '#cfg_([a-z_]+)#'), array('(int) $auth->acl_get("\\1"\\2)', 'true', '(int) $config["\\1"]'), $module_auth) . ');');

-

- return $is_auth;

- }

- * @param ACL_NO|ACL_UNSET|ACL_YES $acl_fill defines the mode those permissions not set are getting filled with

- function get_mask($mode, $user_id = false, $group_id = false, $forum_id = false, $auth_option = false, $scope = false, $acl_fill = ACL_NO)

- WHERE user_id IN (' . implode(',', $ug_id) . ')';

- WHERE user_id IN (' . implode(', ', array_keys($hold_ary)) . ')

- WHERE group_id IN (' . implode(', ', array_keys($hold_ary)) . ')

- $forum_names_ary = make_forum_select(false, false, true, false, false, true);

- AND r.role_id IN (' . implode(', ', array_keys($roles)) . ')';

- WHERE forum_id IN (' . implode(', ', array_keys($hold_ary)) . ')';

- WHERE user_id IN (' . implode(', ', $auth_ary['users']) . ')

- WHERE group_id IN (' . implode(', ', $auth_ary['groups']) . ')

- $ug_id_sql = 'IN (' . implode(', ', array_map('intval', $ug_id)) . ')';

- $forum_sql = 'IN (' . implode(', ', array_map('intval', $forum_id)) . ') ';

- $id_field = $ug_type . '_id';

- WHERE forum_id $forum_sql

- AND $id_field $ug_id_sql

- WHERE forum_id $forum_sql

- AND $id_field $ug_id_sql

- AND auth_role_id IN (" . implode(', ', $role_ids) . ')';

- if ($setting == ACL_YES && (!isset($auth[$flag]) || $auth[$flag] == ACL_NO))

- if ($setting != ACL_UNSET)

- if ($setting == ACL_YES && (!isset($auth[$flag]) || $auth[$flag] == ACL_NO))

- if ($setting != ACL_UNSET)

- // If no data is there, we set the any-flag to ACL_NO...

- 'auth_setting' => ACL_NO

- $where_sql[] = (!is_array($forum_id)) ? 'forum_id = ' . (int) $forum_id : 'forum_id IN (' . implode(', ', array_map('intval', $forum_id)) . ')';

- $where_sql[] = (!is_array($ug_id)) ? $id_field . ' = ' . (int) $ug_id : $id_field . ' IN (' . implode(', ', array_map('intval', $ug_id)) . ')';

- $auth_id_ary[$row['auth_option']] = ACL_UNSET;

- AND rd.role_id IN (' . implode(', ', array_keys($cur_role_auth)) . ')';

- $where_sql[] = 'auth_option_id IN (' . implode(', ', array_map('intval', $option_id_ary)) . ')';

- 'S_YES' => ($cat_array['S_YES'] && !$cat_array['S_NO'] && !$cat_array['S_UNSET']) ? true : false,

- 'S_NO' => ($cat_array['S_NO'] && !$cat_array['S_YES'] && !$cat_array['S_UNSET']) ? true : false,

- 'S_UNSET' => ($cat_array['S_UNSET'] && !$cat_array['S_NO'] && !$cat_array['S_YES']) ? true : false,

- 'S_UNSET' => ($allowed == ACL_UNSET) ? true : false,

- 'S_UNSET' => false,

- $content_array[$forum_id][$cat]['S_UNSET'] |= ($auth_setting == ACL_UNSET) ? true : false;

- $hold_ary[0][$opt] = ACL_NO;

- 'visual' => array('title' => 'ACP_VC_SETTINGS', 'auth' => 'acl_a_board', 'cat' => array('ACP_BOARD_CONFIGURATION')),

- 'admin_roles' => array('title' => 'ACP_ADMIN_ROLES', 'auth' => 'acl_a_roles', 'cat' => array('ACP_PERMISSION_ROLES')),

- 'user_roles' => array('title' => 'ACP_USER_ROLES', 'auth' => 'acl_a_roles', 'cat' => array('ACP_PERMISSION_ROLES')),

- 'mod_roles' => array('title' => 'ACP_MOD_ROLES', 'auth' => 'acl_a_roles', 'cat' => array('ACP_PERMISSION_ROLES')),

- 'forum_roles' => array('title' => 'ACP_FORUM_ROLES', 'auth' => 'acl_a_roles', 'cat' => array('ACP_PERMISSION_ROLES')),

- $sql .= ' WHERE forum_id NOT IN (' . implode(', ', array_keys($this->acl)) . ')';

- if ($auth_ary[$opt] == ACL_YES && (!isset($bitstring[$this->acl_options[$ary_key][$option_key]]) || $bitstring[$this->acl_options[$ary_key][$option_key]] == ACL_NO))

- $bitstring[$id] = ACL_NO;

- $where_sql = ($user_id !== false) ? ' WHERE user_id ' . ((is_array($user_id)) ? ' IN (' . implode(', ', array_map('intval', $user_id)) . ')' : " = $user_id") : '';

- $sql_ug = ($ug_id !== false) ? ((!is_array($ug_id)) ? "AND a.$sql_id = $ug_id" : "AND a.$sql_id IN (" . implode(', ', $ug_id) . ')') : '';

- $sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND a.forum_id IN (' . implode(', ', $forum_id) . ')') : '';

- $sql_user = ($user_id !== false) ? ((!is_array($user_id)) ? "user_id = $user_id" : 'user_id IN (' . implode(', ', $user_id) . ')') : '';

- $sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND a.forum_id IN (' . implode(', ', $forum_id) . ')') : '';

- $sql_opts = 'AND ao.auth_option IN (' . implode(', ', preg_replace('#^\s*(.*)\s*$#e', "\"'\" . \$db->sql_escape('\\1') . \"'\"", $opts)) . ')';

- // option ... so we shouldn't need any ACL_NO checks ... he says ...

- // Now grab group settings ... ACL_NO overrides ACL_YES so act appropriatley

- if (!isset($hold_ary[$row['user_id']][$row['forum_id']][$row['auth_option']]) || (isset($hold_ary[$row['user_id']][$row['forum_id']][$row['auth_option']]) && $hold_ary[$row['user_id']][$row['forum_id']][$row['auth_option']] != ACL_NO))

- // Check for existence of ACL_YES if an option got set to NO

- if ($setting == ACL_NO)

- $sql_user = ($user_id !== false) ? ((!is_array($user_id)) ? "user_id = $user_id" : 'user_id IN (' . implode(', ', $user_id) . ')') : '';

- $sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND a.forum_id IN (' . implode(', ', $forum_id) . ')') : '';

- $sql_opts = 'AND ao.auth_option IN (' . implode(', ', preg_replace('#^\s*(.*)\s*$#e', "\"'\" . \$db->sql_escape('\\1') . \"'\"", $opts)) . ')';

- $sql_group = ($group_id !== false) ? ((!is_array($group_id)) ? "group_id = $group_id" : 'group_id IN (' . implode(', ', $group_id) . ')') : '';

- $sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND a.forum_id IN (' . implode(', ', $forum_id) . ')') : '';

- $sql_opts = 'AND ao.auth_option IN (' . implode(', ', preg_replace('#^\s*(.*)\s*$#e', "\"'\" . \$db->sql_escape('\\1') . \"'\"", $opts)) . ')';

- if (file_exists($phpbb_root_path . 'includes/auth/auth_' . $method . '.' . $phpEx))

- include_once($phpbb_root_path . 'includes/auth/auth_' . $method . '.' . $phpEx);

- $method = 'login_' . $method;

- if (function_exists($method))

- $login = $method($username, $password);

- // If login succeeded, we will log the user in... else we pass the login array through...

- if ($login['status'] == LOGIN_SUCCESS)

- $result = $user->session_create($login['user_row']['user_id'], $admin, $autologin, $viewonline);

- // Successful session creation

- if ($result === true)

- {

- return array(

- 'status' => LOGIN_SUCCESS,

- 'error_msg' => false,

- 'user_row' => $login['user_row'],

- );

- }

- 'status' => LOGIN_BREAK,

- 'error_msg' => $result,

- return $login;

-* This is for initial authentication via Apaches basic realm authentication methods,

-* user data is then obtained from the integrated user table

-*

-* You can do any kind of checking you like here ... the return data format is

-* either the resulting row of user information, an integer zero (indicating an

-* inactive user) or some error string

-*

- // the user does not exist

- 'status' => LOGIN_ERROR_USERNAME,

- 'error_msg' => 'LOGIN_ERROR_USERNAME',

- 'user_row' => array('user_id' => ANONYMOUS),

- return ($_SERVER['PHP_AUTH_USER'] === $user['username']) ? true : false;

-* You can do any kind of checking you like here ... the return data format is

-* either the resulting row of user information, an integer zero (indicating an

-* inactive user) or some error string

-*

-* This is for initial authentication via an LDAP server, user information is then

-* obtained from the integrated user table

-*

-* You can do any kind of checking you like here ... the return data format is

-* either the resulting row of user information, an integer zero (indicating an

-* inactive user) or some error string

-*

- $search = @ldap_search($ldap, $config['ldap_base_dn'], $config['ldap_uid'] . '=' . $user->data['username'], array($config['ldap_uid']));

- if (is_array($result) && sizeof($result) > 1)

- return false;

- return sprintf($user->lang['LDAP_NO_IDENTITY'], $user->data['username']);

- global $db, $config;

- $search = @ldap_search($ldap, $config['ldap_base_dn'], $config['ldap_uid'] . '=' . $username, array($config['ldap_uid']));

- $result = @ldap_get_entries($ldap, $search);

- if (is_array($result) && sizeof($result) > 1)

- if (@ldap_bind($ldap, $result[0]['dn'], $password))

-function admin_ldap(&$new)

- /**

- * @todo Using same approach as with cfg_build_template?

- */

-

- 'config' => array('ldap_server', 'ldap_base_dn', 'ldap_uid')

-/**

-* Would be nice to allow syncing of 'appropriate' data when user updates

-* their username, password, etc. ... should be up to the plugin what data

-* is updated.

-*

-* @todo implement this functionality (probably 3.2)

-*

-* @param new|update|delete $mode defining the action to take on user updates

-*/

-function usercp_ldap($mode)

-{

- global $db, $config;

-}

-

- var $bbcode_bitfield = 0;

- function bbcode($bitfield = 0)

- $bitlen = strlen(decbin($this->bbcode_bitfield));

- for ($bbcode_id = 0; $bbcode_id < $bitlen; ++$bbcode_id)

- if ($this->bbcode_bitfield & (1 << $bbcode_id))

- if (!empty($this->bbcode_cache[$bbcode_id]))

- foreach ($this->bbcode_cache[$bbcode_id] as $type => $array)

- foreach ($array as $search => $replace)

- {

- ${$type}['search'][] = str_replace('$uid', $this->bbcode_uid, $search);

- ${$type}['replace'][] = $replace;

- }

- if (sizeof($str['search']))

- {

- $message = str_replace($str['search'], $str['replace'], $message);

- $str = array('search' => array(), 'replace' => array());

- }

- if (sizeof($preg['search']))

- {

- $message = preg_replace($preg['search'], $preg['replace'], $message);

- $preg = array('search' => array(), 'replace' => array());

- }

- $sql = '';

- $bbcode_ids = $rowset = array();

- $bitlen = strlen(decbin($this->bbcode_bitfield));

- for ($bbcode_id = 0; $bbcode_id < $bitlen; ++$bbcode_id)

- if (isset($this->bbcode_cache[$bbcode_id]) || !($this->bbcode_bitfield & (1 << $bbcode_id)))

- $sql .= (($sql) ? ',' : '') . $bbcode_id;

- if ($sql)

- FROM ' . BBCODES_TABLE . "

- WHERE bbcode_id IN ($sql)";

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

- '!\[color=(#[0-9A-F]{6}|[a-z\-]+):$uid\](.*?)\[/color:$uid\]!s' => $this->bbcode_tpl('color', $bbcode_id),

- if ($this->template_bitfield & (1 << $bbcode_id))

- if ($bbcode_id != -1 && !($this->template_bitfield & (1 << $bbcode_id)))

- if ($code{0} == "\n")

- $char = hexdec(substr($seed, ($y * 4) + $x, 1));

- switch ($char % 4)

- $cells = hexdec(substr($seed, 20 + ($i * 2), 2));

- $x1 = $cells % 4;

- $y1 = $cells % 4;

- $x2 = $cells % 4;