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

'field_id' => $field_id,

)));

}

break;

case 'activate':

{

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

{

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

case 'create':

case 'edit':

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

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

{

// 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_required' => 0,

'field_hide' => 0,

'field_no_view' => 0,

'field_show_on_reg' => 0,

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

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

$exclude = array(

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

);

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

{

}

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

if ($field_type == FIELD_BOOL)

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

{

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

{

}

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

}

$db->sql_freeresult($result);

}

foreach ($exclude[3] as $key)

{

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

{

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

}

}

}

'L_TITLE' => $user->lang['STEP_' . $step . '_TITLE_' . strtoupper($action)],

'L_EXPLAIN' => $user->lang['STEP_' . $step . '_EXPLAIN_' . strtoupper($action)],

'U_ACTION' => $this->u_action . "&amp;action=$action&amp;step=$step",

'U_BACK' => $this->u_action)

);

{

// Create basic options - only small differences between field types

case 1:

// Build common create options

$template->assign_vars(array(

'S_STEP_ONE' => true,

'S_FIELD_REQUIRED' => ($cp->vars['field_required']) ? true : false,

'S_SHOW_ON_REG' => ($cp->vars['field_show_on_reg']) ? true : false,

'S_FIELD_HIDE' => ($cp->vars['field_hide']) ? true : false,

'S_FIELD_NO_VIEW' => ($cp->vars['field_no_view']) ? true : false,

'L_LANG_SPECIFIC' => sprintf($user->lang['LANG_SPECIFIC_OPTIONS'], $config['default_lang']),

'LANG_DEFAULT_VALUE' => $cp->vars['lang_default_value'])

);

}

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

{

// Initialize these array elements if we are creating a new field

'SECOND_LANG_OPTION' => ($field_type == FIELD_BOOL) ? $cp->vars['lang_options'][1] : '')

);

}

break;

case 2:

$template->assign_vars(array(

'S_STEP_TWO' => true,

'L_NEXT_STEP' => (sizeof($this->lang_defs['iso']) == 1) ? $user->lang['SAVE'] : $user->lang['PROFILE_LANG_OPTIONS'])

);

}

}

break;

}

break;

}

$sql = 'SELECT *

FROM ' . PROFILE_FIELDS_TABLE . '

ORDER BY field_order';

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

}

$db->sql_freeresult($result);

$options = array();

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

if ($cp->vars['lang_explain'])

{

$options['lang_explain'] = 'text';

}

switch ($field_type)

{

case FIELD_BOOL:

case FIELD_DROPDOWN:

$options['lang_options'] = 'optionfield';

break;

case FIELD_TEXT:

case FIELD_STRING:

if ($cp->vars['lang_default_value'])

}

break;

}

$lang_options = array();

foreach ($options as $field => $field_type)

if ($field == 'lang_options')

{

$var = (!isset($cp->vars['l_lang_options'][$lang_id]) || !is_array($cp->vars['l_lang_options'][$lang_id])) ? $cp->vars['lang_options'] : $cp->vars['l_lang_options'][$lang_id];

switch ($field_type)

{

case 'two_options':

);

break;

}

if (isset($user->lang['CP_' . strtoupper($field) . '_EXPLAIN']))

{

$lang_options[$lang_id]['fields'][$field]['EXPLAIN'] = $user->lang['CP_' . strtoupper($field) . '_EXPLAIN'];

'TITLE' => $user->lang['CP_' . strtoupper($field)],

'FIELD' => ($field_type == 'string') ? '<dd><input class="medium" type="text" name="l_' . $field . '[' . $lang_id . ']" value="' . ((isset($value[$lang_id])) ? $value[$lang_id] : $var) . '" /></dd>' : '<dd><textarea name="l_' . $field . '[' . $lang_id . ']" rows="3" cols="80">' . ((isset($value[$lang_id])) ? $value[$lang_id] : $var) . '</textarea></dd>'

);

if (isset($user->lang['CP_' . strtoupper($field) . '_EXPLAIN']))

{

$lang_options[$lang_id]['fields'][$field]['EXPLAIN'] = $user->lang['CP_' . strtoupper($field) . '_EXPLAIN'];

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

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

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

'field_no_view' => $cp->vars['field_no_view']

);

WHERE field_id = $field_id";

$db->sql_query($sql);

}

if ($action == 'create')

{

$field_ident = 'pf_' . $field_ident;

{

$sql_ary['field_id'] = $field_id;

$sql_ary['lang_id'] = $default_lang_id;

$profile_sql[] = 'INSERT INTO ' . PROFILE_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

}

else

AND lang_id = " . (int) $default_lang_id;

$db->sql_query($sql);

}

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

{

$sql_ary = array(

$lang_id = $sql['lang_id'];

$option_id = $sql['option_id'];

unset($sql['lang_id'], $sql['field_id'], $sql['option_id']);

$this->update_insert(PROFILE_FIELDS_LANG_TABLE, $sql, array(

'lang_id' => $lang_id,

'field_id' => $field_id,

$db->sql_query($sql);

}

}

$db->sql_transaction('commit');

if ($action == 'edit')

if (!$row)

{

$sql_ary = array_merge($where_fields, $sql_ary);

if (sizeof($sql_ary))

{

$db->sql_query("INSERT INTO $table " . $db->sql_build_array('INSERT', $sql_ary));

case FIELD_BOOL:

$sql .= 'TINYINT(2) ';

break;

case FIELD_DROPDOWN:

$sql .= 'MEDIUMINT(8) ';

break;

}

}