*/

/**

* @package acp

*/

class acp_profile

if (confirm_box(true))

{

WHERE field_id = $field_id";

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

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

{

case 'sqlite':

$sql = "SELECT sql

AND name = '" . PROFILE_FIELDS_DATA_TABLE . "'

ORDER BY type DESC, name;";

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

$order++;

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

{

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

$db->sql_query($sql);

}

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

}

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

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

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

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

}

WHERE field_id = $field_id";

$db->sql_query($sql);

WHERE field_id = $field_id";

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

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

}

$sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

WHERE field_id = $field_id";

$db->sql_query($sql);

WHERE field_id = $field_id";

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

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

}

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

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

AND f.field_id = $field_id

AND l.field_id = f.field_id";

{

// Some admin changed the default language?

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

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

AND f.field_id = $field_id

AND l.field_id = f.field_id";

// Get language entries

$sql = 'SELECT *

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

AND field_id = $field_id

ORDER BY option_id ASC";

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'

{

// Get language entries

$sql = 'SELECT *

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

AND field_id = $field_id

ORDER BY option_id ASC";

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

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

AND field_id = $field_id

ORDER BY lang_id ASC";

// Check for already existing field ident

if ($action != 'edit')

{

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

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

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

switch ($step)

{

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

// Build common create options

$template->assign_vars(array(

break;

// Define remaining language variables

$template->assign_var('S_STEP_THREE', true);

$options = $this->build_language_options($cp, $field_type, $action);

$default_lang_id = (!empty($this->edit_lang_id)) ? $this->edit_lang_id : $this->lang_defs['iso'][$config['default_lang']];

FROM ' . LANG_TABLE . '

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

ORDER BY lang_english_name';

foreach ($empty_lang as $lang_id => $NULL)

{

WHERE field_id = $field_id

AND lang_id = " . (int) $lang_id;

$db->sql_query($sql);

if ($action != 'create')

{

WHERE field_id = $field_id

AND lang_id = " . (int) $default_lang_id;

$db->sql_query($sql);

{

if ($action != 'create')

{

WHERE field_id = $field_id

AND lang_id = " . (int) $lang_id;

$db->sql_query($sql);

foreach ($empty_lang as $lang_id => $NULL)

{

WHERE field_id = $field_id

AND lang_id = " . (int) $lang_id;

$db->sql_query($sql);

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

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

'field_id' => $field_id,

'option_id' => $option_id)

);

return;

}

FROM $table

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

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

{

if (sizeof($sql_ary))

{

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

$db->sql_query($sql);

}

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

{

$sql = "SELECT sql

AND name = '" . PROFILE_FIELDS_DATA_TABLE . "'

ORDER BY type DESC, name;";

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