Taking into consideration

... admin is NOT able to change the field type later

If the admin adds a field, he have to enter at least the default board language params. Without doing so, he

is not able to activate the field.

If the default board language is changed, a check has to be made if the profile field language entries are

still valid.

* Show at profile view (yes/no)

* Viewtopic Integration (Load Switch, Able to show fields with additional template vars populated if enabled)

* Try to build the edit screen with the existing create screen...

*/

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

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

if (!$auth->acl_get('a_user'))

{

trigger_error($user->lang['NO_ADMIN']);

$create = (isset($_POST['create'])) ? TRUE : FALSE;

$error = $notify = array();

$default_values = array(

'field_length' => array(FIELD_STRING => 10, FIELD_TEXT => '5|80', FIELD_INT => 5, FIELD_DATE => 10, FIELD_BOOL => 1, FIELD_DROPDOWN => 0),

// Build Language array

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

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

{

}

$db->sql_freeresult($result);

$sql = 'SELECT field_id, lang_id

ORDER BY lang_id';

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

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

{

}

$db->sql_freeresult($result);

{

}

if ($mode == '')

{

// Get all relevant informations about entered values within all steps

// Text-based fields require lang_default_value to be excluded

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

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

}

// step 2

foreach ($exclude[2] as $key)

{

$var = request_var($key, $default_values[$key][$field_type]);

}

}

}

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

}

// step 3 - all arrays

foreach ($exclude[3] as $key)

{

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

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

}

WHERE field_ident = '$field_ident'";

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

continue;

}

}

{

}

?>

<form name="add_profile_field" method="post" action="admin_profile.<?php echo "$phpEx$SID&amp;mode=$mode&amp;step=$step"; ?>">

<table class="bg" cellspacing="1" cellpadding="4" border="0" align="center" width="99%">

// Build common create options

?>

<tr>

<td class="row2"><b><?php echo $user->lang['FIELD_' . strtoupper($cp->profile_types[$field_type])]; ?></b></td>

</tr>

<tr>

<td class="row2"><input class="post" type="text" name="field_name" size="20" value="<?php echo $cp->vars['field_name']; ?>" /></td>

</tr>

<tr>

</tr>

<tr>

<td class="row2"><input class="post" type="text" name="lang_name" size="20" value="<?php echo $cp->vars['lang_name']; ?>" /></td>

</tr>

<tr>

<td class="row2"><textarea name="lang_explain" rows="3" cols="80"><?php echo $cp->vars['lang_explain']; ?></textarea></td>

</tr>

<?php

{

?>

<tr>

<td class="row2"><?php echo ($field_type == FIELD_STRING) ? '<input class="post" type="text" name="lang_default_value" size="20" value="' . $cp->vars['lang_default_value'] . '" />' : '<textarea name="lang_default_value" rows="5" cols="80">' . $cp->vars['lang_default_value'] . '</textarea>'; ?></td>

</tr>

<?php

}

?>

<tr>

<td class="row2"><?php echo ($field_type == FIELD_DROPDOWN) ? '<textarea name="lang_options" rows="5" cols="80">' . $cp->vars['lang_options'] . '</textarea>' : '<table border=0><tr><td><input name="lang_options[0]" size="20" value="' . $cp->vars['lang_options'][0] . '" class="post" /></td><td>[ ' . $user->lang['FIRST_OPTION'] . ' ]</td></tr><tr><td><input name="lang_options[1]" size="20" value="' . $cp->vars['lang_options'][1] . '" class="post" /></td><td>[ ' . $user->lang['SECOND_OPTION'] . ' ]</td></tr></table>'; ?></td>

</tr>

<?php

}

?>

<tr>

</tr>

<?php echo $s_hidden_fields; ?>

</table>

{

?>

<tr>

<td class="row2"><?php echo $option_ary['FIELD']; ?></td>

</tr>

<?php

}

?>

<tr>

</tr>

<?php echo $s_hidden_fields; ?>

</table>

<br /><br />

<table class="bg" cellspacing="1" cellpadding="4" border="0" align="center" width="99%">

<tr>

</tr>

<?php

if (!empty($user_error) || $update)

?> <tr>

</tr>

<?php

}

$field_data = array(

);

preview_field($field_data);

{

?>

<tr>

</tr>

<?php

foreach ($lang_ary['fields'] as $field_name => $field_ary)

{

?>

<tr>

<td class="row2"><?php echo $field_ary['FIELD']; ?></td>

</tr>

<?php

}

?>

<tr>

</tr>

<?php echo $s_hidden_fields; ?>

</table>

}

}

if ($mode == 'delete')

{

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

if (!$field_id)

if ($confirm)

{

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

$field_ident = $db->sql_fetchfield('field_ident', 0, $result);

$order = 0;

$sql = 'SELECT *

ORDER BY field_order';

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

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

{

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

{

}

}

}

{

adm_page_footer();

}

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

$db->sql_freeresult($result);

{

trigger_error('DEFAULT_LANGUAGE_NOT_FILLED');

}

}

if ($mode == 'deactivate')

trigger_error('INVALID_MODE');

}

}

if ($mode == 'move_up' || $mode == 'move_down')

{

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

SET field_order = $order_total - field_order

WHERE field_order IN ($field_order, " . (($mode == 'move_up') ? $field_order - 1 : $field_order + 1) . ')';

$db->sql_query($sql);

?>

<form name="profile_fields" method="post" action="admin_profile.<?php echo "$phpEx$SID"; ?>">

<table class="bg" cellspacing="1" cellpadding="4" border="0" align="center" width="99%">

<tr>

<th nowrap="nowrap">Name</th>

<th nowrap="nowrap">Template Variable</th>

</tr>

<?php

$sql = 'SELECT *

ORDER BY field_order';

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

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

{

$row_class = ($row_class == 'row1') ? 'row2' : 'row1';

<td class="<?php echo $row_class; ?>"><?php echo $row['field_ident']; ?></td>

<td class="<?php echo $row_class; ?>"><?php echo $user->lang['FIELD_' . strtoupper($cp->profile_types[$row['field_type']])]; ?></td>

<td class="<?php echo $row_class; ?>"><a href="admin_profile.<?php echo $phpEx . $SID; ?>&amp;mode=<?php echo $active_value; ?>&amp;field_id=<?php echo $id; ?>"><?php echo $user->lang[$active_lang]; ?></a></td>

<td class="<?php echo $row_class; ?>"><a href="admin_profile.<?php echo $phpEx . $SID; ?>&amp;mode=delete&amp;field_id=<?php echo $id; ?>"><?php echo $user->lang['DELETE']; ?></a></td>

<td class="<?php echo $row_class; ?>" align="center"><a href="admin_profile.<?php echo $phpEx . $SID; ?>&amp;mode=move_up&amp;order=<?php echo $row['field_order']; ?>"><?php echo $user->lang['MOVE_UP']; ?></a> | <a href="admin_profile.<?php echo $phpEx . $SID; ?>&amp;mode=move_down&amp;order=<?php echo $row['field_order']; ?>"><?php echo $user->lang['MOVE_DOWN']; ?></a></td>

</tr>

{

$lang_options[1]['lang_iso'] = $config['default_lang'];

$lang_options[1]['fields'][$field] = array(

'FIELD' => '<b>' . ((is_array($cp->vars[$field])) ? implode('<br />', $cp->vars[$field]) : str_replace("\n", '<br />', $cp->vars[$field])) . '</b>'

);

}

}

case 'two_options':

$lang_options[$lang_id]['fields'][$field] = array(

'FIELD' => '<table border=0><tr><td><span class="genmed">' . $user->lang['FIRST_OPTION'] . ': </span></td><td><input name="l_' . $field . '[' . $lang_id . '][]" size="20" value="' . ((isset($value[$lang_id][0])) ? $value[$lang_id][0] : $var[0]) . '" class="post" /></td></tr><tr><td><span class="genmed">' . $user->lang['SECOND_OPTION'] . ': </span></td><td><input name="l_' . $field . '[' . $lang_id . '][]" size="20" value="' . ((isset($value[$lang_id][1])) ? $value[$lang_id][1] : $var[1]) . '" class="post" /></td></tr></table>'

);

break;

case 'optionfield':

$lang_options[$lang_id]['fields'][$field] = array(

'FIELD' => '<textarea name="l_' . $field . '[' . $lang_id . ']" rows="7" cols="80">' . ((isset($value[$lang_id])) ? $value[$lang_id] : $var) . '</textarea>'

);

break;

}

}

else

{

$var = ($mode == 'new') ? $cp->vars[$field] : $cp->vars[$field][$lang_id];

$lang_options[$lang_id]['fields'][$field] = array(

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

);

}

}

}

function save_profile_field($field_type, $field_ident)

{

// Collect all informations, if something is going wrong, abort the operation

$profile_sql = $profile_lang = $empty_lang = $profile_lang_fields = array();

$result = $db->sql_query('SELECT MAX(field_order) as max_field_order FROM phpbb_profile_fields');

$new_field_order = (int) $db->sql_fetchfield('max_field_order', 0, $result);

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

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

'field_order' => $new_field_order + 1,

);

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

$field_id = $db->sql_nextid();

switch ($field_type)

{

case FIELD_STRING:

$profile_sql[] = $sql;

$sql_ary = array(

);

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

if (!isset($empty_lang[$lang_id]))

{

$profile_lang[] = array(

);

}

}

}

if (!empty($cp->vars['lang_options']))

{

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

{

$sql_ary = array(

);

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

}

foreach ($lang_ary as $option_id => $value)

{

$profile_lang_fields[] = array(

);

}

}

}

// $db->sql_transaction('commit');

trigger_error($user->lang['ADDED_PROFILE_FIELD']);

}

?> \ No newline at end of file

// TODO for M-3:

//

// * simplify the class (logical seperation between display and insert/update)

class custom_profile

var $profile_types = array(1 => 'int', 2 => 'string', 3 => 'text', 4 => 'bool', 5 => 'dropdown', 6 => 'date');

var $options_lang = array();

// Functions performing operations on register/profile/profile admin

function submit_cp_field($mode, &$cp_data, &$cp_error)

{

global $auth, $db;

$sql = 'SELECT *

WHERE field_active = 1

' . (($mode == 'register') ? ' AND field_show_on_reg = 1' : '') .

(($auth->acl_gets('a_', 'm_') && $mode == 'profile') ? '' : ' AND field_hide = 0') . '

$db->sql_freeresult($result);

}

function generate_profile_fields($mode, $lang_id, $cp_error)

{

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

WHERE l.lang_id = $lang_id

AND f.field_active = 1

" . (($mode == 'register') ? ' AND f.field_show_on_reg = 1' : '') .

$db->sql_freeresult($result);

}

// Assign fields to template, used for viewprofile, viewtopic and memberlist (if load setting is enabled)

// This is directly connected to the user -> mode == grab is to grab the user specific fields, mode == show is for assigning the row to the template

function generate_profile_fields_template($mode, $user_id = 0, $profile_row = false)

}

$sql = 'SELECT *

WHERE user_id IN (' . implode(', ', array_map('intval', $user_id)) . ')';

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

}

else

{

WHERE field_id = $field_id

AND lang_id = $lang_id

AND field_type = $field_type

global $db, $user, $auth;

$sql = 'SELECT f.field_type, f.field_ident, f.field_default_value, l.lang_default_value

WHERE l.lang_id = ' . $user->get_iso_lang_id() . '

AND f.field_active = 1

AND f.field_show_on_reg = 0

class custom_profile_admin extends custom_profile

{

var $vars = array();

{

global $user;

$validate_options = '';

foreach ($validate_ary as $lang => $value)

{

$validate_options .= '<option value="' . $value . '"' . $selected . '>' . $user->lang[$lang] . '</option>';

}

$options = array(

);

return $options;

{

global $user;

$options = array(

);

return $options;

global $user;

$options = array(

);

return $options;

function get_bool_options()

{

$profile_row = array(

);

$options = array(

);

return $options;

function get_dropdown_options()

{

$profile_row[0] = array(

);

$profile_row[1] = $profile_row[0];

$profile_row[1]['field_ident'] = 'field_no_value';

$options = array(

);

return $options;

function get_date_options()

{

$profile_row = array(

);

$options = array(

);

return $options;

'ERR_BOT_NO_IP' => 'The IP addresses you supplied were invalid or the hostname could not be resolved.',

);

?> \ No newline at end of file