Code Forge

<?php

/**

*

* @package acp

* @version $Id$

* @copyright (c) 2005 phpBB Group

* @license http://opensource.org/licenses/gpl-license.php GNU Public License

*

*/

/**

* @ignore

*/

if (!defined('IN_PHPBB'))

{

        exit;

}

/**

* @package acp

*/

class acp_profile

{

        var $u_action;

        var $edit_lang_id;

        var $lang_defs;

        function main($id, $mode)

        {

                global $config, $db, $user, $auth, $template, $cache;

                global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix;

                include($phpbb_root_path . 'includes/functions_posting.' . $phpEx);

                include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

                include($phpbb_root_path . 'includes/functions_profile_fields.' . $phpEx);

                $user->add_lang(array('ucp', 'acp/profile'));

                $this->tpl_name = 'acp_profile';

                $this->page_title = 'ACP_CUSTOM_PROFILE_FIELDS';

                $action = (isset($_POST['create'])) ? 'create' : request_var('action', '');

                $error = array();

                $s_hidden_fields = '';

                // Define some default values for each field type

                $default_values = array(

                        FIELD_STRING        => array('field_length' => 10, 'field_minlen' => 0, 'field_maxlen' => 20, 'field_validation' => '.*', 'field_novalue' => '', 'field_default_value' => ''),

                        FIELD_TEXT                => array('field_length' => '5|80', 'field_minlen' => 0, 'field_maxlen' => 1000, 'field_validation' => '.*', 'field_novalue' => '', 'field_default_value' => ''),

                        FIELD_INT                => array('field_length' => 5, 'field_minlen' => 0, 'field_maxlen' => 100, 'field_validation' => '', 'field_novalue' => 0, 'field_default_value' => 0),

                        FIELD_DATE                => array('field_length' => 10, 'field_minlen' => 10, 'field_maxlen' => 10, 'field_validation' => '', 'field_novalue' => ' 0- 0-   0', 'field_default_value' => ' 0- 0-   0'),

                        FIELD_BOOL                => array('field_length' => 1, 'field_minlen' => 0, 'field_maxlen' => 0, 'field_validation' => '', 'field_novalue' => 0, 'field_default_value' => 0),

                        FIELD_DROPDOWN        => array('field_length' => 0, 'field_minlen' => 0, 'field_maxlen' => 5, 'field_validation' => '', 'field_novalue' => 0, 'field_default_value' => 0),

                );

                $cp = new custom_profile_admin();

                // Build Language array

                // Based on this, we decide which elements need to be edited later and which language items are missing

                $this->lang_defs = array();

                $sql = 'SELECT lang_id, lang_iso

                        FROM ' . LANG_TABLE . '

                        ORDER BY lang_english_name';

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

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

                {

                        // 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'];

                }

                $db->sql_freeresult($result);

                $sql = 'SELECT field_id, lang_id

                        FROM ' . PROFILE_LANG_TABLE . '

                        ORDER BY lang_id';

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

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

                {

                        // Which languages are available for each item

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

                }

                $db->sql_freeresult($result);

                // Have some fields been defined?

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

                {

                        foreach ($this->lang_defs['entry'] as $field_id => $field_ary)

                        {

                                // Fill an array with the languages that are missing for each field

                                $this->lang_defs['diff'][$field_id] = array_diff(array_values($this->lang_defs['iso']), $field_ary);

                        }

                }

                switch ($action)

                {

                        case 'delete':

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

                                if (!$field_id)

                                {

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

                                }

                                if (confirm_box(true))

                                {

                                        $sql = 'SELECT field_ident

                                                FROM ' . PROFILE_FIELDS_TABLE . "

                                                WHERE field_id = $field_id";

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

                                        $field_ident = (string) $db->sql_fetchfield('field_ident');

                                        $db->sql_freeresult($result);

                                        $db->sql_transaction('begin');

                                        $db->sql_query('DELETE FROM ' . PROFILE_FIELDS_TABLE . " WHERE field_id = $field_id");

                                        $db->sql_query('DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . " WHERE field_id = $field_id");

                                        $db->sql_query('DELETE FROM ' . PROFILE_LANG_TABLE . " WHERE field_id = $field_id");

                                        switch ($db->sql_layer)

                                        {

                                                case 'sqlite':

                                                        $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 = preg_split('/,(?=[\\sa-z])/im', $new_table_cols);

                                                        $column_list = array();

                                                        foreach ($old_table_cols as $declaration)

                                                        {

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

                                                                if ($entities[0] == 'PRIMARY')

                                                                {

                                                                        continue;

                                                                }

                                                                if ($entities[0] !== 'pf_' . $field_ident)

                                                                {

                                                                        $column_list[] = $entities[0];

                                                                }

                                                        }

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

                                                        $new_table_cols = preg_replace('/' . 'pf_' . $field_ident . '[^,]+,/', '', $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');

                                                break;

                                                default:

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

                                        }

                                        $order = 0;

                                        $sql = 'SELECT *

                                                FROM ' . PROFILE_FIELDS_TABLE . '

                                                ORDER BY field_order';

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

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

                                        {

                                                $order++;

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

                                                {

                                                        $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

                                                                SET field_order = $order

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

                                                        $db->sql_query($sql);

                                                }

                                        }

                                        $db->sql_freeresult($result);

                                        $db->sql_transaction('commit');

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

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

                                }

                                else

                                {

                                        confirm_box(false, 'DELETE_PROFILE_FIELD', build_hidden_fields(array(

                                                'i'                        => $id,

                                                'mode'                => $mode,

                                                'action'        => $action,

                                                'field_id'        => $field_id,

                                        )));

                                }

                        break;

                        case 'activate':

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

                                if (!$field_id)

                                {

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

                                }

                                $sql = 'SELECT lang_id

                                        FROM ' . LANG_TABLE . "

                                        WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'";

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

                                $default_lang_id = (int) $db->sql_fetchfield('lang_id');

                                $db->sql_freeresult($result);

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

                                {

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

                                }

                                $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

                                        SET field_active = 1

                                        WHERE field_id = $field_id";

                                $db->sql_query($sql);

                                $sql = 'SELECT field_ident

                                        FROM ' . PROFILE_FIELDS_TABLE . "

                                        WHERE field_id = $field_id";

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

                                $field_ident = (string) $db->sql_fetchfield('field_ident');

                                $db->sql_freeresult($result);

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

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

                        break;

                        case 'deactivate':

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

                                if (!$field_id)

                                {

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

                                }

                                $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

                                        SET field_active = 0

                                        WHERE field_id = $field_id";

                                $db->sql_query($sql);

                                $sql = 'SELECT field_ident

                                        FROM ' . PROFILE_FIELDS_TABLE . "

                                        WHERE field_id = $field_id";

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

                                $field_ident = (string) $db->sql_fetchfield('field_ident');

                                $db->sql_freeresult($result);

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

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

                        break;

                        case 'move_up':

                        case 'move_down':

                                $field_order = request_var('order', 0);

                                $order_total = $field_order * 2 + (($action == 'move_up') ? -1 : 1);

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

                                $db->sql_query($sql);

                        break;

                        case 'create':

                        case 'edit':

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

                                $step = request_var('step', 1);

                                $submit = (isset($_REQUEST['next']) || isset($_REQUEST['prev'])) ? true : false;

                                $save = (isset($_REQUEST['save'])) ? true : false;

                                // The language id of default language

                                $this->edit_lang_id = $this->lang_defs['iso'][$config['default_lang']];

                                // We are editing... we need to grab basic things

                                if ($action == 'edit')

                                {

                                        if (!$field_id)

                                        {

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

                                        }

                                        $sql = 'SELECT l.*, f.*

                                                FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . ' f

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

                                                        AND f.field_id = $field_id

                                                        AND l.field_id = f.field_id";

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

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

                                        $db->sql_freeresult($result);

                                        if (!$field_row)

                                        {

                                                // Some admin changed the default language?

                                                $sql = 'SELECT l.*, f.*

                                                        FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . ' f

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

                                                        AND f.field_id = $field_id

                                                        AND l.field_id = f.field_id";

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

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

                                                $db->sql_freeresult($result);

                                                if (!$field_row)

                                                {

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

                                                }

                                                $this->edit_lang_id = $field_row['lang_id'];

                                        }

                                        $field_type = $field_row['field_type'];

                                        // Get language entries

                                        $sql = 'SELECT *

                                                FROM ' . PROFILE_FIELDS_LANG_TABLE . '

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

                                                        AND field_id = $field_id

                                                ORDER BY option_id ASC";

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

                                        $lang_options = array();

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

                                        {

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

                                        }

                                        $db->sql_freeresult($result);

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

                                }

                                else

                                {

                                        // We are adding a new field, define basic params

                                        $lang_options = $field_row = array();

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

                                        if (!$field_type)

                                        {

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

                                        }

                                        $field_row = array_merge($default_values[$field_type], array(

                                                'field_ident'                => str_replace(' ', '_', utf8_clean_string(request_var('field_ident', '', true))),

                                                'field_required'        => 0,

                                                'field_hide'                => 0,

                                                'field_show_profile'=> 0,

                                                'field_no_view'                => 0,

                                                'field_show_on_reg'        => 0,

                                                'field_show_on_vt'        => 0,

                                                'lang_name'                        => utf8_normalize_nfc(request_var('field_ident', '', true)),

                                                'lang_explain'                => '',

                                                'lang_default_value'=> '')

                                        );

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

                                }

                                // $exclude contains the data we gather in each step

                                $exclude = array(

                                        1        => array('field_ident', 'lang_name', 'lang_explain', 'field_option_none', 'field_show_on_reg', 'field_show_on_vt', 'field_required', 'field_hide', 'field_show_profile', 'field_no_view'),

                                        2        => array('field_length', 'field_maxlen', 'field_minlen', 'field_validation', 'field_novalue', 'field_default_value'),

                                        3        => array('l_lang_name', 'l_lang_explain', 'l_lang_default_value', 'l_lang_options')

                                );

                                // Text-based fields require the lang_default_value to be excluded

                                if ($field_type == FIELD_STRING || $field_type == FIELD_TEXT)

                                {

                                        $exclude[1][] = 'lang_default_value';

                                }

                                // option-specific fields require lang_options to be excluded

                                if ($field_type == FIELD_BOOL || $field_type == FIELD_DROPDOWN)

                                {

                                        $exclude[1][] = 'lang_options';

                                }

                                $cp->vars['field_ident']                = ($action == 'create' && $step == 1) ? utf8_clean_string(request_var('field_ident', $field_row['field_ident'], true)) : request_var('field_ident', $field_row['field_ident']);

                                $cp->vars['lang_name']                        = utf8_normalize_nfc(request_var('lang_name', $field_row['lang_name'], true));

                                $cp->vars['lang_explain']                = utf8_normalize_nfc(request_var('lang_explain', $field_row['lang_explain'], true));

                                $cp->vars['lang_default_value']        = utf8_normalize_nfc(request_var('lang_default_value', $field_row['lang_default_value'], true));

                                // Visibility Options...

                                $visibility_ary = array(

                                        'field_required',

                                        'field_show_on_reg',

                                        'field_show_on_vt',

                                        'field_show_profile',

                                        'field_hide',

                                );

                                foreach ($visibility_ary as $val)

                                {

                                        $cp->vars[$val] = ($submit || $save) ? request_var($val, 0) : $field_row[$val];

                                }

                                $cp->vars['field_no_view'] = request_var('field_no_view', (int) $field_row['field_no_view']);

                                // A boolean field expects an array as the lang options

                                if ($field_type == FIELD_BOOL)

                                {

                                        $options = utf8_normalize_nfc(request_var('lang_options', array(''), true));

                                }

                                else

                                {

                                        $options = utf8_normalize_nfc(request_var('lang_options', '', true));

                                }

                                // If the user has submitted a form with options (i.e. dropdown field)

                                if ($options)

                                {

                                        $exploded_options = (is_array($options)) ? $options : explode("\n", $options);

                                        if (sizeof($exploded_options) == sizeof($lang_options) || $action == 'create')

                                        {

                                                // The number of options in the field is equal to the number of options already in the database

                                                // Or we are creating a new dropdown list.

                                                $cp->vars['lang_options'] = $exploded_options;

                                        }

                                        else if ($action == 'edit')

                                        {

                                                // Changing the number of options? (We remove and re-create the option fields)

                                                $cp->vars['lang_options'] = $exploded_options;

                                        }

                                }

                                else

                                {

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

                                }

                                // step 2

                                foreach ($exclude[2] as $key)

                                {

                                        $var = utf8_normalize_nfc(request_var($key, $field_row[$key], true));

                                        // Manipulate the intended variables a little bit if needed

                                        if ($field_type == FIELD_DROPDOWN && $key == 'field_maxlen')

                                        {

                                                // Get the number of options if this key is 'field_maxlen'

                                                $var = sizeof(explode("\n", utf8_normalize_nfc(request_var('lang_options', '', true))));

                                        }

                                        else if ($field_type == FIELD_TEXT && $key == 'field_length')

                                        {

                                                if (isset($_REQUEST['rows']))

                                                {

                                                        $cp->vars['rows'] = request_var('rows', 0);

                                                        $cp->vars['columns'] = request_var('columns', 0);

                                                        $var = $cp->vars['rows'] . '|' . $cp->vars['columns'];

                                                }

                                                else

                                                {

                                                        $row_col = explode('|', $var);

                                                        $cp->vars['rows'] = $row_col[0];

                                                        $cp->vars['columns'] = $row_col[1];

                                                }

                                        }

                                        else if ($field_type == FIELD_DATE && $key == 'field_default_value')

                                        {

                                                $always_now = request_var('always_now', -1);

                                                if ($always_now == 1 || ($always_now === -1 && $var == 'now'))

                                                {

                                                        $now = getdate();

                                                        $cp->vars['field_default_value_day'] = $now['mday'];

                                                        $cp->vars['field_default_value_month'] = $now['mon'];

                                                        $cp->vars['field_default_value_year'] = $now['year'];

                                                        $var = $_POST['field_default_value'] = 'now';

                                                }

                                                else

                                                {

                                                        if (isset($_REQUEST['field_default_value_day']))

                                                        {

                                                                $cp->vars['field_default_value_day'] = request_var('field_default_value_day', 0);

                                                                $cp->vars['field_default_value_month'] = request_var('field_default_value_month', 0);

                                                                $cp->vars['field_default_value_year'] = request_var('field_default_value_year', 0);

                                                                $var = $_POST['field_default_value'] = sprintf('%2d-%2d-%4d', $cp->vars['field_default_value_day'], $cp->vars['field_default_value_month'], $cp->vars['field_default_value_year']);

                                                        }

                                                        else

                                                        {

                                                                list($cp->vars['field_default_value_day'], $cp->vars['field_default_value_month'], $cp->vars['field_default_value_year']) = explode('-', $var);

                                                        }

                                                }

                                        }

                                        /* else if ($field_type == FIELD_BOOL && $key == 'field_default_value')

                                        {

                                                // Get the number of options if this key is 'field_maxlen'

                                                $var = request_var('field_default_value', 0);

                                        }*/

                                        else if ($field_type == FIELD_INT && $key == 'field_default_value')

                                        {

                                                // Permit an empty string

                                                if ($action == 'create' && request_var('field_default_value', '') === '')

                                                {

                                                        $var = '';

                                                }

                                        }

                                        $cp->vars[$key] = $var;

                                }

                                // step 3 - all arrays

                                if ($action == 'edit')

                                {

                                        // Get language entries

                                        $sql = 'SELECT *

                                                FROM ' . PROFILE_FIELDS_LANG_TABLE . '

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

                                                        AND field_id = $field_id

                                                ORDER BY option_id ASC";

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

                                        $l_lang_options = array();

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

                                        {

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

                                        }

                                        $db->sql_freeresult($result);

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

                                                FROM ' . PROFILE_LANG_TABLE . '

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

                                                        AND field_id = $field_id

                                                ORDER BY lang_id ASC";

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

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

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

                                        {

                                                $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'];

                                        }

                                        $db->sql_freeresult($result);

                                }

                                foreach ($exclude[3] as $key)

                                {

                                        $cp->vars[$key] = utf8_normalize_nfc(request_var($key, array(0 => ''), true));

                                        if (!$cp->vars[$key] && $action == 'edit')

                                        {

                                                $cp->vars[$key] = $$key;

                                        }

                                        else if ($key == 'l_lang_options' && $field_type == FIELD_BOOL)

                                        {

                                                $cp->vars[$key] = utf8_normalize_nfc(request_var($key, array(0 => array('')), true));

                                        }

                                        else if ($key == 'l_lang_options' && is_array($cp->vars[$key]))

                                        {

                                                foreach ($cp->vars[$key] as $lang_id => $options)

                                                {

                                                        $cp->vars[$key][$lang_id] = explode("\n", $options);

                                                }

                                        }

                                }

                                // Check for general issues in every step

                                if ($submit) //  && $step == 1

                                {

                                        // Check values for step 1

                                        if ($cp->vars['field_ident'] == '')

                                        {

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

                                        }

                                        if (!preg_match('/^[a-z_]+$/', $cp->vars['field_ident']))

                                        {

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

                                        }

                                        if (strlen($cp->vars['field_ident']) > 17)

                                        {

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

                                        }

                                        if ($cp->vars['lang_name'] == '')

                                        {

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

                                        }

                                        if ($field_type == FIELD_DROPDOWN && !sizeof($cp->vars['lang_options']))

                                        {

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

                                        }

                                        if ($field_type == FIELD_BOOL && (empty($cp->vars['lang_options'][0]) || empty($cp->vars['lang_options'][1])))

                                        {

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

                                        }

                                        // Check for already existing field ident

                                        if ($action != 'edit')

                                        {

                                                $sql = 'SELECT field_ident

                                                        FROM ' . PROFILE_FIELDS_TABLE . "

                                                        WHERE field_ident = '" . $db->sql_escape($cp->vars['field_ident']) . "'";

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

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

                                                $db->sql_freeresult($result);

                                                if ($row)

                                                {

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

                                                }

                                        }

                                }

                                $step = (isset($_REQUEST['next'])) ? $step + 1 : ((isset($_REQUEST['prev'])) ? $step - 1 : $step);

                                if (sizeof($error))

                                {

                                        $step--;

                                        $submit = false;

                                }

                                // Build up the specific hidden fields

                                foreach ($exclude as $num => $key_ary)

                                {

                                        if ($num == $step)

                                        {

                                                continue;

                                        }

                                        $_new_key_ary = array();

                                        foreach ($key_ary as $key)

                                        {

                                                if ($field_type == FIELD_TEXT && $key == 'field_length' && isset($_REQUEST['rows']))

                                                {

                                                        $cp->vars['rows'] = request_var('rows', 0);

                                                        $cp->vars['columns'] = request_var('columns', 0);

                                                        $_new_key_ary[$key] = $cp->vars['rows'] . '|' . $cp->vars['columns'];

                                                }

                                                else if ($field_type == FIELD_DATE && $key == 'field_default_value')

                                                {

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

                                                        if ($always_now)

                                                        {

                                                                $_new_key_ary[$key] = 'now';

                                                        }

                                                        else if (isset($_REQUEST['field_default_value_day']))

                                                        {

                                                                $cp->vars['field_default_value_day'] = request_var('field_default_value_day', 0);

                                                                $cp->vars['field_default_value_month'] = request_var('field_default_value_month', 0);

                                                                $cp->vars['field_default_value_year'] = request_var('field_default_value_year', 0);

                                                                $_new_key_ary[$key]  = sprintf('%2d-%2d-%4d', $cp->vars['field_default_value_day'], $cp->vars['field_default_value_month'], $cp->vars['field_default_value_year']);