+ <dt><label for="lang_options">{L_ENTRIES}:</label>

+ <!-- IF S_EDIT_MODE and S_DROPDOWN -->

+ <br /><span>{L_EDIT_DROPDOWN_LANG_EXPLAIN}</span>

+ <!-- ELSE -->

+ <br /><span>{L_LANG_OPTIONS_EXPLAIN}</span>

+ <!-- ENDIF -->

+ </dt>

+ return (isset($this->sql_rowset[$query_id][$this->sql_row_pointer[$query_id]][$field])) ? $this->sql_rowset[$query_id][$this->sql_row_pointer[$query_id]][$field] : false;

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

+ $forum_ids = array($forum_id);

+ }

+ $sql = 'INSERT INTO ' . PROFILE_FIELDS_TABLE . ' ' . $db->sql_build_array('INSERT', $profile_fields);

+ $db->sql_query($sql);

+ $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . '

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

+ WHERE field_id = $field_id";

+ $db->sql_query($sql);

+ $profile_sql[] = $this->add_field_ident($field_ident, $field_type);

+ 'field_id' => $field_id,

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

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

+

+ /**

+ * Return sql statement for adding a new field ident (profile field) to the profile fields data table

+ */

+ function add_field_ident($field_ident, $field_type)

+ {

+ global $db;

+

+ 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 = trim($matches[1]);

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

+ $column_list = array();

+

+ foreach ($old_table_cols as $declaration)

+ {

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

+ if ($entities == 'PRIMARY')

+ {

+ continue;

+ }

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

+ }

+

+ return $sql;

+ }

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

+ $message .= '<br /><br />An sql error occurred while fetching this page. Please contact an administrator if this problem persists.';

+ // If we are in safe mode create the destination file prior to using the gd functions to circumvent a PHP bug

+ if (@ini_get('safe_mode') || @strtolower(ini_get('safe_mode')) == 'on')

+ {

+ @touch($destination);

+ }

+

+ // Evil Statement

+ // Folder actions have precedence, so we will remove any other ones

+ $move_into_folder = array();

+

+ if (!$folder_action)

+ {

+ $move_into_folder[PRIVMSGS_INBOX][] = $msg_id;

+ }

+

+ if (!$folder_action)

+ {

+ $move_into_folder[PRIVMSGS_INBOX][] = $msg_id;

+ }

+ $value = (int) $value;

+

+ // User not having a value assigned

+ if (!isset($this->options_lang[$field_id][$lang_id][$value]))

+ {

+ return NULL;

+ }

+

+ return $this->options_lang[$field_id][$lang_id][$value];

+ // $tok = ($tok == '[') ? ']' : '[]';

+ $tok = '[]';

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

+ 'password_confirm' => array('string', false, $config['min_pass_chars'], $config['max_pass_chars']),

+ 'EDIT_DROPDOWN_LANG_EXPLAIN' => 'Please note that you are able to change your options text and also able to add new options to the end. It is not advised to add new options between existing options - this could result in wrong options assigned to your users. This can also happen if you remove options in-between. Removing options from the end result in users having assigned this item now reverting back to the default one.',

+ 'EMPTY_FIELD_IDENT' => 'Empty field identification',

+ 'EMPTY_USER_FIELD_NAME' => 'Please enter a field name/title',

+ 'ENTRIES' => 'Entries',

+ 'EVERYTHING_OK' => 'Everything OK',

+ 'SQL_ERROR_OCCURRED' => 'An SQL error occurred while fetching this page. Please contact the %sBoard Administrator%s if this problem persists.',

+ 'MESSAGE_STORED' => 'Your message has been sent successfully',

+$username = request_var('un', '');

+ if ($user_id == ANONYMOUS && !$username)

+ if ($username)

+ {

+ $sql = 'SELECT *

+ FROM ' . USERS_TABLE . "

+ WHERE LOWER(username) = '" . strtolower($db->sql_escape($username)) . "'

+ AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';

+ }

+ else

+ {

+ $sql = 'SELECT *

+ FROM ' . USERS_TABLE . "

+ WHERE user_id = $user_id

+ AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';

+ }

+

+ $user_id = (int) $member['user_id'];

+