Verzeichnisstruktur phpBB-3.1.0
- Veröffentlicht
- 27.10.2014
So funktioniert es
|
Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück |
Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis. |
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
acp_profile.php
0001 <?php
0002 /**
0003 *
0004 * This file is part of the phpBB Forum Software package.
0005 *
0006 * @copyright (c) phpBB Limited <https://www.phpbb.com>
0007 * @license GNU General Public License, version 2 (GPL-2.0)
0008 *
0009 * For full copyright and license information, please see
0010 * the docs/CREDITS.txt file.
0011 *
0012 */
0013
0014 /**
0015 * @ignore
0016 */
0017 if (!defined('IN_PHPBB'))
0018 {
0019 exit;
0020 }
0021
0022 class acp_profile
0023 {
0024 var $u_action;
0025
0026 var $edit_lang_id;
0027 var $lang_defs;
0028 protected $type_collection;
0029
0030 function main($id, $mode)
0031 {
0032 global $config, $db, $user, $auth, $template, $cache;
0033 global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix;
0034 global $request, $phpbb_container;
0035
0036 include($phpbb_root_path . 'includes/functions_posting.' . $phpEx);
0037 include($phpbb_root_path . 'includes/functions_user.' . $phpEx);
0038
0039 $user->add_lang(array('ucp', 'acp/profile'));
0040 $this->tpl_name = 'acp_profile';
0041 $this->page_title = 'ACP_CUSTOM_PROFILE_FIELDS';
0042
0043 $field_id = $request->variable('field_id', 0);
0044 $action = (isset($_POST['create'])) ? 'create' : request_var('action', '');
0045
0046 $error = array();
0047 $s_hidden_fields = '';
0048
0049 if (!$field_id && in_array($action, array('delete','activate', 'deactivate', 'move_up', 'move_down', 'edit')))
0050 {
0051 trigger_error($user->lang['NO_FIELD_ID'] . adm_back_link($this->u_action), E_USER_WARNING);
0052 }
0053
0054 $cp = $phpbb_container->get('profilefields.manager');
0055 $this->type_collection = $phpbb_container->get('profilefields.type_collection');
0056
0057 // Build Language array
0058 // Based on this, we decide which elements need to be edited later and which language items are missing
0059 $this->lang_defs = array();
0060
0061 $sql = 'SELECT lang_id, lang_iso
0062 FROM ' . LANG_TABLE . '
0063 ORDER BY lang_english_name';
0064 $result = $db->sql_query($sql);
0065
0066 while ($row = $db->sql_fetchrow($result))
0067 {
0068 // Make some arrays with all available languages
0069 $this->lang_defs['id'][$row['lang_id']] = $row['lang_iso'];
0070 $this->lang_defs['iso'][$row['lang_iso']] = $row['lang_id'];
0071 }
0072 $db->sql_freeresult($result);
0073
0074 $sql = 'SELECT field_id, lang_id
0075 FROM ' . PROFILE_LANG_TABLE . '
0076 ORDER BY lang_id';
0077 $result = $db->sql_query($sql);
0078
0079 while ($row = $db->sql_fetchrow($result))
0080 {
0081 // Which languages are available for each item
0082 $this->lang_defs['entry'][$row['field_id']][] = $row['lang_id'];
0083 }
0084 $db->sql_freeresult($result);
0085
0086 // Have some fields been defined?
0087 if (isset($this->lang_defs['entry']))
0088 {
0089 foreach ($this->lang_defs['entry'] as $field_ident => $field_ary)
0090 {
0091 // Fill an array with the languages that are missing for each field
0092 $this->lang_defs['diff'][$field_ident] = array_diff(array_values($this->lang_defs['iso']), $field_ary);
0093 }
0094 }
0095
0096 switch ($action)
0097 {
0098 case 'delete':
0099
0100 if (confirm_box(true))
0101 {
0102 $sql = 'SELECT field_ident
0103 FROM ' . PROFILE_FIELDS_TABLE . "
0104 WHERE field_id = $field_id";
0105 $result = $db->sql_query($sql);
0106 $field_ident = (string) $db->sql_fetchfield('field_ident');
0107 $db->sql_freeresult($result);
0108
0109 $db->sql_transaction('begin');
0110
0111 $db->sql_query('DELETE FROM ' . PROFILE_FIELDS_TABLE . " WHERE field_id = $field_id");
0112 $db->sql_query('DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . " WHERE field_id = $field_id");
0113 $db->sql_query('DELETE FROM ' . PROFILE_LANG_TABLE . " WHERE field_id = $field_id");
0114
0115 $db_tools = $phpbb_container->get('dbal.tools');
0116 $db_tools->sql_column_remove(PROFILE_FIELDS_DATA_TABLE, 'pf_' . $field_ident);
0117
0118 $order = 0;
0119
0120 $sql = 'SELECT *
0121 FROM ' . PROFILE_FIELDS_TABLE . '
0122 ORDER BY field_order';
0123 $result = $db->sql_query($sql);
0124
0125 while ($row = $db->sql_fetchrow($result))
0126 {
0127 $order++;
0128 if ($row['field_order'] != $order)
0129 {
0130 $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "
0131 SET field_order = $order
0132 WHERE field_id = {$row['field_id']}";
0133 $db->sql_query($sql);
0134 }
0135 }
0136 $db->sql_freeresult($result);
0137
0138 $db->sql_transaction('commit');
0139
0140 add_log('admin', 'LOG_PROFILE_FIELD_REMOVED', $field_ident);
0141 trigger_error($user->lang['REMOVED_PROFILE_FIELD'] . adm_back_link($this->u_action));
0142 }
0143 else
0144 {
0145 confirm_box(false, 'DELETE_PROFILE_FIELD', build_hidden_fields(array(
0146 'i' => $id,
0147 'mode' => $mode,
0148 'action' => $action,
0149 'field_id' => $field_id,
0150 )));
0151 }
0152
0153 break;
0154
0155 case 'activate':
0156
0157 $sql = 'SELECT lang_id
0158 FROM ' . LANG_TABLE . "
0159 WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'";
0160 $result = $db->sql_query($sql);
0161 $default_lang_id = (int) $db->sql_fetchfield('lang_id');
0162 $db->sql_freeresult($result);
0163
0164 if (!in_array($default_lang_id, $this->lang_defs['entry'][$field_id]))
0165 {
0166 trigger_error($user->lang['DEFAULT_LANGUAGE_NOT_FILLED'] . adm_back_link($this->u_action), E_USER_WARNING);
0167 }
0168
0169 $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "
0170 SET field_active = 1
0171 WHERE field_id = $field_id";
0172 $db->sql_query($sql);
0173
0174 $sql = 'SELECT field_ident
0175 FROM ' . PROFILE_FIELDS_TABLE . "
0176 WHERE field_id = $field_id";
0177 $result = $db->sql_query($sql);
0178 $field_ident = (string) $db->sql_fetchfield('field_ident');
0179 $db->sql_freeresult($result);
0180
0181 add_log('admin', 'LOG_PROFILE_FIELD_ACTIVATE', $field_ident);
0182
0183 if ($request->is_ajax())
0184 {
0185 $json_response = new \phpbb\json_response();
0186 $json_response->send(array(
0187 'text' => $user->lang('DEACTIVATE'),
0188 ));
0189 }
0190
0191 trigger_error($user->lang['PROFILE_FIELD_ACTIVATED'] . adm_back_link($this->u_action));
0192
0193 break;
0194
0195 case 'deactivate':
0196
0197 $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "
0198 SET field_active = 0
0199 WHERE field_id = $field_id";
0200 $db->sql_query($sql);
0201
0202 $sql = 'SELECT field_ident
0203 FROM ' . PROFILE_FIELDS_TABLE . "
0204 WHERE field_id = $field_id";
0205 $result = $db->sql_query($sql);
0206 $field_ident = (string) $db->sql_fetchfield('field_ident');
0207 $db->sql_freeresult($result);
0208
0209 if ($request->is_ajax())
0210 {
0211 $json_response = new \phpbb\json_response();
0212 $json_response->send(array(
0213 'text' => $user->lang('ACTIVATE'),
0214 ));
0215 }
0216
0217 add_log('admin', 'LOG_PROFILE_FIELD_DEACTIVATE', $field_ident);
0218
0219 trigger_error($user->lang['PROFILE_FIELD_DEACTIVATED'] . adm_back_link($this->u_action));
0220
0221 break;
0222
0223 case 'move_up':
0224 case 'move_down':
0225
0226 $sql = 'SELECT field_order
0227 FROM ' . PROFILE_FIELDS_TABLE . "
0228 WHERE field_id = $field_id";
0229 $result = $db->sql_query($sql);
0230 $field_order = $db->sql_fetchfield('field_order');
0231 $db->sql_freeresult($result);
0232
0233 if ($field_order === false || ($field_order == 0 && $action == 'move_up'))
0234 {
0235 break;
0236 }
0237 $field_order = (int) $field_order;
0238 $order_total = $field_order * 2 + (($action == 'move_up') ? -1 : 1);
0239
0240 $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "
0241 SET field_order = $order_total - field_order
0242 WHERE field_order IN ($field_order, " . (($action == 'move_up') ? $field_order - 1 : $field_order + 1) . ')';
0243 $db->sql_query($sql);
0244
0245 if ($request->is_ajax())
0246 {
0247 $json_response = new \phpbb\json_response;
0248 $json_response->send(array(
0249 'success' => (bool) $db->sql_affectedrows(),
0250 ));
0251 }
0252
0253 break;
0254
0255 case 'create':
0256 case 'edit':
0257
0258 $step = request_var('step', 1);
0259
0260 $submit = (isset($_REQUEST['next']) || isset($_REQUEST['prev'])) ? true : false;
0261 $save = (isset($_REQUEST['save'])) ? true : false;
0262
0263 // The language id of default language
0264 $this->edit_lang_id = $this->lang_defs['iso'][$config['default_lang']];
0265
0266 // We are editing... we need to grab basic things
0267 if ($action == 'edit')
0268 {
0269 $sql = 'SELECT l.*, f.*
0270 FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . ' f
0271 WHERE l.lang_id = ' . $this->edit_lang_id . "
0272 AND f.field_id = $field_id
0273 AND l.field_id = f.field_id";
0274 $result = $db->sql_query($sql);
0275 $field_row = $db->sql_fetchrow($result);
0276 $db->sql_freeresult($result);
0277
0278 if (!$field_row)
0279 {
0280 // Some admin changed the default language?
0281 $sql = 'SELECT l.*, f.*
0282 FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . ' f
0283 WHERE l.lang_id <> ' . $this->edit_lang_id . "
0284 AND f.field_id = $field_id
0285 AND l.field_id = f.field_id";
0286 $result = $db->sql_query($sql);
0287 $field_row = $db->sql_fetchrow($result);
0288 $db->sql_freeresult($result);
0289
0290 if (!$field_row)
0291 {
0292 trigger_error($user->lang['FIELD_NOT_FOUND'] . adm_back_link($this->u_action), E_USER_WARNING);
0293 }
0294
0295 $this->edit_lang_id = $field_row['lang_id'];
0296 }
0297 $field_type = $field_row['field_type'];
0298 $profile_field = $this->type_collection[$field_type];
0299
0300 // Get language entries
0301 $sql = 'SELECT *
0302 FROM ' . PROFILE_FIELDS_LANG_TABLE . '
0303 WHERE lang_id = ' . $this->edit_lang_id . "
0304 AND field_id = $field_id
0305 ORDER BY option_id ASC";
0306 $result = $db->sql_query($sql);
0307
0308 $lang_options = array();
0309 while ($row = $db->sql_fetchrow($result))
0310 {
0311 $lang_options[$row['option_id']] = $row['lang_value'];
0312 }
0313 $db->sql_freeresult($result);
0314
0315 $s_hidden_fields = '<input type="hidden" name="field_id" value="' . $field_id . '" />';
0316 }
0317 else
0318 {
0319 // We are adding a new field, define basic params
0320 $lang_options = $field_row = array();
0321
0322 $field_type = request_var('field_type', '');
0323
0324 if (!isset($this->type_collection[$field_type]))
0325 {
0326 trigger_error($user->lang['NO_FIELD_TYPE'] . adm_back_link($this->u_action), E_USER_WARNING);
0327 }
0328
0329 $profile_field = $this->type_collection[$field_type];
0330 $field_row = array_merge($profile_field->get_default_option_values(), array(
0331 'field_ident' => str_replace(' ', '_', utf8_clean_string(request_var('field_ident', '', true))),
0332 'field_required' => 0,
0333 'field_show_novalue'=> 0,
0334 'field_hide' => 0,
0335 'field_show_profile'=> 0,
0336 'field_no_view' => 0,
0337 'field_show_on_reg' => 0,
0338 'field_show_on_pm' => 0,
0339 'field_show_on_vt' => 0,
0340 'field_show_on_ml' => 0,
0341 'field_is_contact' => 0,
0342 'field_contact_desc'=> '',
0343 'field_contact_url' => '',
0344 'lang_name' => utf8_normalize_nfc(request_var('field_ident', '', true)),
0345 'lang_explain' => '',
0346 'lang_default_value'=> '')
0347 );
0348
0349 $s_hidden_fields = '<input type="hidden" name="field_type" value="' . $field_type . '" />';
0350 }
0351
0352 // $exclude contains the data we gather in each step
0353 $exclude = array(
0354 1 => array('field_ident', 'lang_name', 'lang_explain', 'field_option_none', 'field_show_on_reg', 'field_show_on_pm', 'field_show_on_vt', 'field_show_on_ml', 'field_required', 'field_show_novalue', 'field_hide', 'field_show_profile', 'field_no_view', 'field_is_contact', 'field_contact_desc', 'field_contact_url'),
0355 2 => array('field_length', 'field_maxlen', 'field_minlen', 'field_validation', 'field_novalue', 'field_default_value'),
0356 3 => array('l_lang_name', 'l_lang_explain', 'l_lang_default_value', 'l_lang_options')
0357 );
0358
0359 // Visibility Options...
0360 $visibility_ary = array(
0361 'field_required',
0362 'field_show_novalue',
0363 'field_show_on_reg',
0364 'field_show_on_pm',
0365 'field_show_on_vt',
0366 'field_show_on_ml',
0367 'field_show_profile',
0368 'field_hide',
0369 'field_is_contact',
0370 );
0371
0372 $options = $profile_field->prepare_options_form($exclude, $visibility_ary);
0373
0374 $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']);
0375 $cp->vars['lang_name'] = $request->variable('lang_name', $field_row['lang_name'], true);
0376 $cp->vars['lang_explain'] = $request->variable('lang_explain', $field_row['lang_explain'], true);
0377 $cp->vars['lang_default_value'] = $request->variable('lang_default_value', $field_row['lang_default_value'], true);
0378 $cp->vars['field_contact_desc'] = $request->variable('field_contact_desc', $field_row['field_contact_desc'], true);
0379 $cp->vars['field_contact_url'] = $request->variable('field_contact_url', $field_row['field_contact_url'], true);
0380
0381 foreach ($visibility_ary as $val)
0382 {
0383 $cp->vars[$val] = ($submit || $save) ? $request->variable($val, 0) : $field_row[$val];
0384 }
0385
0386 $cp->vars['field_no_view'] = $request->variable('field_no_view', (int) $field_row['field_no_view']);
0387
0388 // If the user has submitted a form with options (i.e. dropdown field)
0389 if ($options)
0390 {
0391 $exploded_options = (is_array($options)) ? $options : explode("\n", $options);
0392
0393 if (sizeof($exploded_options) == sizeof($lang_options) || $action == 'create')
0394 {
0395 // The number of options in the field is equal to the number of options already in the database
0396 // Or we are creating a new dropdown list.
0397 $cp->vars['lang_options'] = $exploded_options;
0398 }
0399 else if ($action == 'edit')
0400 {
0401 // Changing the number of options? (We remove and re-create the option fields)
0402 $cp->vars['lang_options'] = $exploded_options;
0403 }
0404 }
0405 else
0406 {
0407 $cp->vars['lang_options'] = $lang_options;
0408 }
0409
0410 // step 2
0411 foreach ($exclude[2] as $key)
0412 {
0413 $var = utf8_normalize_nfc(request_var($key, $field_row[$key], true));
0414
0415 $field_data = $cp->vars;
0416 $var = $profile_field->get_excluded_options($key, $action, $var, $field_data, 2);
0417 $cp->vars = $field_data;
0418
0419 $cp->vars[$key] = $var;
0420 }
0421
0422 // step 3 - all arrays
0423 if ($action == 'edit')
0424 {
0425 // Get language entries
0426 $sql = 'SELECT *
0427 FROM ' . PROFILE_FIELDS_LANG_TABLE . '
0428 WHERE lang_id <> ' . $this->edit_lang_id . "
0429 AND field_id = $field_id
0430 ORDER BY option_id ASC";
0431 $result = $db->sql_query($sql);
0432
0433 $l_lang_options = array();
0434 while ($row = $db->sql_fetchrow($result))
0435 {
0436 $l_lang_options[$row['lang_id']][$row['option_id']] = $row['lang_value'];
0437 }
0438 $db->sql_freeresult($result);
0439
0440 $sql = 'SELECT lang_id, lang_name, lang_explain, lang_default_value
0441 FROM ' . PROFILE_LANG_TABLE . '
0442 WHERE lang_id <> ' . $this->edit_lang_id . "
0443 AND field_id = $field_id
0444 ORDER BY lang_id ASC";
0445 $result = $db->sql_query($sql);
0446
0447 $l_lang_name = $l_lang_explain = $l_lang_default_value = array();
0448 while ($row = $db->sql_fetchrow($result))
0449 {
0450 $l_lang_name[$row['lang_id']] = $row['lang_name'];
0451 $l_lang_explain[$row['lang_id']] = $row['lang_explain'];
0452 $l_lang_default_value[$row['lang_id']] = $row['lang_default_value'];
0453 }
0454 $db->sql_freeresult($result);
0455 }
0456
0457 foreach ($exclude[3] as $key)
0458 {
0459 $cp->vars[$key] = utf8_normalize_nfc(request_var($key, array(0 => ''), true));
0460
0461 if (!$cp->vars[$key] && $action == 'edit')
0462 {
0463 $cp->vars[$key] = $$key;
0464 }
0465
0466 $field_data = $cp->vars;
0467 $var = $profile_field->get_excluded_options($key, $action, $var, $field_data, 3);
0468 $cp->vars = $field_data;
0469 }
0470
0471 // Check for general issues in every step
0472 if ($submit) // && $step == 1
0473 {
0474 // Check values for step 1
0475 if ($cp->vars['field_ident'] == '')
0476 {
0477 $error[] = $user->lang['EMPTY_FIELD_IDENT'];
0478 }
0479
0480 if (!preg_match('/^[a-z_]+$/', $cp->vars['field_ident']))
0481 {
0482 $error[] = $user->lang['INVALID_CHARS_FIELD_IDENT'];
0483 }
0484
0485 if (strlen($cp->vars['field_ident']) > 17)
0486 {
0487 $error[] = $user->lang['INVALID_FIELD_IDENT_LEN'];
0488 }
0489
0490 if ($cp->vars['lang_name'] == '')
0491 {
0492 $error[] = $user->lang['EMPTY_USER_FIELD_NAME'];
0493 }
0494
0495 $error = $profile_field->validate_options_on_submit($error, $cp->vars);
0496
0497 // Check for already existing field ident
0498 if ($action != 'edit')
0499 {
0500 $sql = 'SELECT field_ident
0501 FROM ' . PROFILE_FIELDS_TABLE . "
0502 WHERE field_ident = '" . $db->sql_escape($cp->vars['field_ident']) . "'";
0503 $result = $db->sql_query($sql);
0504 $row = $db->sql_fetchrow($result);
0505 $db->sql_freeresult($result);
0506
0507 if ($row)
0508 {
0509 $error[] = $user->lang['FIELD_IDENT_ALREADY_EXIST'];
0510 }
0511 }
0512 }
0513
0514 $step = (isset($_REQUEST['next'])) ? $step + 1 : ((isset($_REQUEST['prev'])) ? $step - 1 : $step);
0515
0516 if (sizeof($error))
0517 {
0518 $step--;
0519 $submit = false;
0520 }
0521
0522 // Build up the specific hidden fields
0523 foreach ($exclude as $num => $key_ary)
0524 {
0525 if ($num == $step)
0526 {
0527 continue;
0528 }
0529
0530 $_new_key_ary = array();
0531
0532 $field_data = $cp->vars;
0533 foreach ($key_ary as $key)
0534 {
0535 $var = $profile_field->prepare_hidden_fields($step, $key, $action, $field_data);
0536 if ($var !== null)
0537 {
0538 $_new_key_ary[$key] = $profile_field->prepare_hidden_fields($step, $key, $action, $field_data);
0539 }
0540 }
0541 $cp->vars = $field_data;
0542
0543 $s_hidden_fields .= build_hidden_fields($_new_key_ary);
0544 }
0545
0546 if (!sizeof($error))
0547 {
0548 if ($step == 3 && (sizeof($this->lang_defs['iso']) == 1 || $save))
0549 {
0550 $this->save_profile_field($cp, $field_type, $action);
0551 }
0552 else if ($action == 'edit' && $save)
0553 {
0554 $this->save_profile_field($cp, $field_type, $action);
0555 }
0556 }
0557
0558 $template->assign_vars(array(
0559 'S_EDIT' => true,
0560 'S_EDIT_MODE' => ($action == 'edit') ? true : false,
0561 'ERROR_MSG' => (sizeof($error)) ? implode('<br />', $error) : '',
0562
0563 'L_TITLE' => $user->lang['STEP_' . $step . '_TITLE_' . strtoupper($action)],
0564 'L_EXPLAIN' => $user->lang['STEP_' . $step . '_EXPLAIN_' . strtoupper($action)],
0565
0566 'U_ACTION' => $this->u_action . "&action=$action&step=$step",
0567 'U_BACK' => $this->u_action)
0568 );
0569
0570 // Now go through the steps
0571 switch ($step)
0572 {
0573 // Create basic options - only small differences between field types
0574 case 1:
0575 $template_vars = array(
0576 'S_STEP_ONE' => true,
0577 'S_FIELD_REQUIRED' => ($cp->vars['field_required']) ? true : false,
0578 'S_FIELD_SHOW_NOVALUE'=> ($cp->vars['field_show_novalue']) ? true : false,
0579 'S_SHOW_ON_REG' => ($cp->vars['field_show_on_reg']) ? true : false,
0580 'S_SHOW_ON_PM' => ($cp->vars['field_show_on_pm']) ? true : false,
0581 'S_SHOW_ON_VT' => ($cp->vars['field_show_on_vt']) ? true : false,
0582 'S_SHOW_ON_MEMBERLIST'=> ($cp->vars['field_show_on_ml']) ? true : false,
0583 'S_FIELD_HIDE' => ($cp->vars['field_hide']) ? true : false,
0584 'S_SHOW_PROFILE' => ($cp->vars['field_show_profile']) ? true : false,
0585 'S_FIELD_NO_VIEW' => ($cp->vars['field_no_view']) ? true : false,
0586 'S_FIELD_CONTACT' => $cp->vars['field_is_contact'],
0587 'FIELD_CONTACT_DESC'=> $cp->vars['field_contact_desc'],
0588 'FIELD_CONTACT_URL' => $cp->vars['field_contact_url'],
0589
0590 'L_LANG_SPECIFIC' => sprintf($user->lang['LANG_SPECIFIC_OPTIONS'], $config['default_lang']),
0591 'FIELD_TYPE' => $profile_field->get_name(),
0592 'FIELD_IDENT' => $cp->vars['field_ident'],
0593 'LANG_NAME' => $cp->vars['lang_name'],
0594 'LANG_EXPLAIN' => $cp->vars['lang_explain'],
0595 );
0596
0597 $field_data = $cp->vars;
0598 $profile_field->display_options($template_vars, $field_data);
0599 $cp->vars = $field_data;
0600
0601 // Build common create options
0602 $template->assign_vars($template_vars);
0603 break;
0604
0605 case 2:
0606
0607 $template->assign_vars(array(
0608 'S_STEP_TWO' => true,
0609 'L_NEXT_STEP' => (sizeof($this->lang_defs['iso']) == 1) ? $user->lang['SAVE'] : $user->lang['PROFILE_LANG_OPTIONS'])
0610 );
0611
0612 // Build options based on profile type
0613 $options = $profile_field->get_options($this->lang_defs['iso'][$config['default_lang']], $cp->vars);
0614
0615 foreach ($options as $num => $option_ary)
0616 {
0617 $template->assign_block_vars('option', $option_ary);
0618 }
0619
0620 break;
0621
0622 // Define remaining language variables
0623 case 3:
0624
0625 $template->assign_var('S_STEP_THREE', true);
0626 $options = $this->build_language_options($cp, $field_type, $action);
0627
0628 foreach ($options as $lang_id => $lang_ary)
0629 {
0630 $template->assign_block_vars('options', array(
0631 'LANGUAGE' => sprintf($user->lang[(($lang_id == $this->edit_lang_id) ? 'DEFAULT_' : '') . 'ISO_LANGUAGE'], $lang_ary['lang_iso']))
0632 );
0633
0634 foreach ($lang_ary['fields'] as $field_ident => $field_ary)
0635 {
0636 $template->assign_block_vars('options.field', array(
0637 'L_TITLE' => $field_ary['TITLE'],
0638 'L_EXPLAIN' => (isset($field_ary['EXPLAIN'])) ? $field_ary['EXPLAIN'] : '',
0639 'FIELD' => $field_ary['FIELD'])
0640 );
0641 }
0642 }
0643
0644 break;
0645 }
0646
0647 $template->assign_vars(array(
0648 'S_HIDDEN_FIELDS' => $s_hidden_fields)
0649 );
0650
0651 return;
0652
0653 break;
0654 }
0655
0656 $sql = 'SELECT *
0657 FROM ' . PROFILE_FIELDS_TABLE . '
0658 ORDER BY field_order';
0659 $result = $db->sql_query($sql);
0660
0661 $s_one_need_edit = false;
0662 while ($row = $db->sql_fetchrow($result))
0663 {
0664 $active_lang = (!$row['field_active']) ? 'ACTIVATE' : 'DEACTIVATE';
0665 $active_value = (!$row['field_active']) ? 'activate' : 'deactivate';
0666 $id = $row['field_id'];
0667
0668 $s_need_edit = (sizeof($this->lang_defs['diff'][$row['field_id']])) ? true : false;
0669
0670 if ($s_need_edit)
0671 {
0672 $s_one_need_edit = true;
0673 }
0674
0675 $profile_field = $this->type_collection[$row['field_type']];
0676 $template->assign_block_vars('fields', array(
0677 'FIELD_IDENT' => $row['field_ident'],
0678 'FIELD_TYPE' => $profile_field->get_name(),
0679
0680 'L_ACTIVATE_DEACTIVATE' => $user->lang[$active_lang],
0681 'U_ACTIVATE_DEACTIVATE' => $this->u_action . "&action=$active_value&field_id=$id",
0682 'U_EDIT' => $this->u_action . "&action=edit&field_id=$id",
0683 'U_TRANSLATE' => $this->u_action . "&action=edit&field_id=$id&step=3",
0684 'U_DELETE' => $this->u_action . "&action=delete&field_id=$id",
0685 'U_MOVE_UP' => $this->u_action . "&action=move_up&field_id=$id",
0686 'U_MOVE_DOWN' => $this->u_action . "&action=move_down&field_id=$id",
0687
0688 'S_NEED_EDIT' => $s_need_edit)
0689 );
0690 }
0691 $db->sql_freeresult($result);
0692
0693 // At least one option field needs editing?
0694 if ($s_one_need_edit)
0695 {
0696 $template->assign_var('S_NEED_EDIT', true);
0697 }
0698
0699 $s_select_type = '';
0700 foreach ($this->type_collection as $key => $profile_field)
0701 {
0702 $s_select_type .= '<option value="' . $key . '">' . $profile_field->get_name() . '</option>';
0703 }
0704
0705 $template->assign_vars(array(
0706 'U_ACTION' => $this->u_action,
0707 'S_TYPE_OPTIONS' => $s_select_type,
0708 ));
0709 }
0710
0711 /**
0712 * Build all Language specific options
0713 */
0714 function build_language_options(&$cp, $field_type, $action = 'create')
0715 {
0716 global $user, $config, $db, $phpbb_container;
0717
0718 $default_lang_id = (!empty($this->edit_lang_id)) ? $this->edit_lang_id : $this->lang_defs['iso'][$config['default_lang']];
0719
0720 $sql = 'SELECT lang_id, lang_iso
0721 FROM ' . LANG_TABLE . '
0722 WHERE lang_id <> ' . (int) $default_lang_id . '
0723 ORDER BY lang_english_name';
0724 $result = $db->sql_query($sql);
0725
0726 $languages = array();
0727 while ($row = $db->sql_fetchrow($result))
0728 {
0729 $languages[$row['lang_id']] = $row['lang_iso'];
0730 }
0731 $db->sql_freeresult($result);
0732
0733 $profile_field = $this->type_collection[$field_type];
0734 $options = $profile_field->get_language_options($cp->vars);
0735
0736 $lang_options = array();
0737
0738 foreach ($options as $field => $field_type)
0739 {
0740 $lang_options[1]['lang_iso'] = $this->lang_defs['id'][$default_lang_id];
0741 $lang_options[1]['fields'][$field] = array(
0742 'TITLE' => $user->lang['CP_' . strtoupper($field)],
0743 'FIELD' => '<dd>' . ((is_array($cp->vars[$field])) ? implode('<br />', $cp->vars[$field]) : bbcode_nl2br($cp->vars[$field])) . '</dd>'
0744 );
0745
0746 if (isset($user->lang['CP_' . strtoupper($field) . '_EXPLAIN']))
0747 {
0748 $lang_options[1]['fields'][$field]['EXPLAIN'] = $user->lang['CP_' . strtoupper($field) . '_EXPLAIN'];
0749 }
0750 }
0751
0752 foreach ($languages as $lang_id => $lang_iso)
0753 {
0754 $lang_options[$lang_id]['lang_iso'] = $lang_iso;
0755 foreach ($options as $field => $field_type)
0756 {
0757 $value = ($action == 'create') ? utf8_normalize_nfc(request_var('l_' . $field, array(0 => ''), true)) : $cp->vars['l_' . $field];
0758 if ($field == 'lang_options')
0759 {
0760 $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];
0761
0762 switch ($field_type)
0763 {
0764 case 'two_options':
0765
0766 $lang_options[$lang_id]['fields'][$field] = array(
0767 'TITLE' => $user->lang['CP_' . strtoupper($field)],
0768 'FIELD' => '
0769 <dd><input class="medium" name="l_' . $field . '[' . $lang_id . '][]" value="' . ((isset($value[$lang_id][0])) ? $value[$lang_id][0] : $var[0]) . '" /> ' . $user->lang['FIRST_OPTION'] . '</dd>
0770 <dd><input class="medium" name="l_' . $field . '[' . $lang_id . '][]" value="' . ((isset($value[$lang_id][1])) ? $value[$lang_id][1] : $var[1]) . '" /> ' . $user->lang['SECOND_OPTION'] . '</dd>'
0771 );
0772 break;
0773
0774 case 'optionfield':
0775 $value = ((isset($value[$lang_id])) ? ((is_array($value[$lang_id])) ? implode("\n", $value[$lang_id]) : $value[$lang_id]) : implode("\n", $var));
0776 $lang_options[$lang_id]['fields'][$field] = array(
0777 'TITLE' => $user->lang['CP_' . strtoupper($field)],
0778 'FIELD' => '<dd><textarea name="l_' . $field . '[' . $lang_id . ']" rows="7" cols="80">' . $value . '</textarea></dd>'
0779 );
0780 break;
0781 }
0782
0783 if (isset($user->lang['CP_' . strtoupper($field) . '_EXPLAIN']))
0784 {
0785 $lang_options[$lang_id]['fields'][$field]['EXPLAIN'] = $user->lang['CP_' . strtoupper($field) . '_EXPLAIN'];
0786 }
0787 }
0788 else
0789 {
0790 $var = ($action == 'create' || !is_array($cp->vars[$field])) ? $cp->vars[$field] : $cp->vars[$field][$lang_id];
0791
0792 $lang_options[$lang_id]['fields'][$field] = array(
0793 'TITLE' => $user->lang['CP_' . strtoupper($field)],
0794 '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>'
0795 );
0796
0797 if (isset($user->lang['CP_' . strtoupper($field) . '_EXPLAIN']))
0798 {
0799 $lang_options[$lang_id]['fields'][$field]['EXPLAIN'] = $user->lang['CP_' . strtoupper($field) . '_EXPLAIN'];
0800 }
0801 }
0802 }
0803 }
0804
0805 return $lang_options;
0806 }
0807
0808 /**
0809 * Save Profile Field
0810 */
0811 function save_profile_field(&$cp, $field_type, $action = 'create')
0812 {
0813 global $db, $config, $user, $phpbb_container;
0814
0815 $field_id = request_var('field_id', 0);
0816
0817 // Collect all information, if something is going wrong, abort the operation
0818 $profile_sql = $profile_lang = $empty_lang = $profile_lang_fields = array();
0819
0820 $default_lang_id = (!empty($this->edit_lang_id)) ? $this->edit_lang_id : $this->lang_defs['iso'][$config['default_lang']];
0821
0822 if ($action == 'create')
0823 {
0824 $sql = 'SELECT MAX(field_order) as max_field_order
0825 FROM ' . PROFILE_FIELDS_TABLE;
0826 $result = $db->sql_query($sql);
0827 $new_field_order = (int) $db->sql_fetchfield('max_field_order');
0828 $db->sql_freeresult($result);
0829
0830 $field_ident = $cp->vars['field_ident'];
0831 }
0832
0833 // Save the field
0834 $profile_fields = array(
0835 'field_length' => $cp->vars['field_length'],
0836 'field_minlen' => $cp->vars['field_minlen'],
0837 'field_maxlen' => $cp->vars['field_maxlen'],
0838 'field_novalue' => $cp->vars['field_novalue'],
0839 'field_default_value' => $cp->vars['field_default_value'],
0840 'field_validation' => $cp->vars['field_validation'],
0841 'field_required' => $cp->vars['field_required'],
0842 'field_show_novalue' => $cp->vars['field_show_novalue'],
0843 'field_show_on_reg' => $cp->vars['field_show_on_reg'],
0844 'field_show_on_pm' => $cp->vars['field_show_on_pm'],
0845 'field_show_on_vt' => $cp->vars['field_show_on_vt'],
0846 'field_show_on_ml' => $cp->vars['field_show_on_ml'],
0847 'field_hide' => $cp->vars['field_hide'],
0848 'field_show_profile' => $cp->vars['field_show_profile'],
0849 'field_no_view' => $cp->vars['field_no_view'],
0850 'field_is_contact' => $cp->vars['field_is_contact'],
0851 'field_contact_desc' => $cp->vars['field_contact_desc'],
0852 'field_contact_url' => $cp->vars['field_contact_url'],
0853 );
0854
0855 if ($action == 'create')
0856 {
0857 $profile_fields += array(
0858 'field_type' => $field_type,
0859 'field_ident' => $field_ident,
0860 'field_name' => $field_ident,
0861 'field_order' => $new_field_order + 1,
0862 'field_active' => 1
0863 );
0864
0865 $sql = 'INSERT INTO ' . PROFILE_FIELDS_TABLE . ' ' . $db->sql_build_array('INSERT', $profile_fields);
0866 $db->sql_query($sql);
0867
0868 $field_id = $db->sql_nextid();
0869 }
0870 else
0871 {
0872 $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . '
0873 SET ' . $db->sql_build_array('UPDATE', $profile_fields) . "
0874 WHERE field_id = $field_id";
0875 $db->sql_query($sql);
0876 }
0877
0878 $profile_field = $this->type_collection[$field_type];
0879
0880 if ($action == 'create')
0881 {
0882 $field_ident = 'pf_' . $field_ident;
0883
0884 $db_tools = $phpbb_container->get('dbal.tools');
0885 $db_tools->sql_column_add(PROFILE_FIELDS_DATA_TABLE, $field_ident, array($profile_field->get_database_column_type(), null));
0886 }
0887
0888 $sql_ary = array(
0889 'lang_name' => $cp->vars['lang_name'],
0890 'lang_explain' => $cp->vars['lang_explain'],
0891 'lang_default_value' => $cp->vars['lang_default_value']
0892 );
0893
0894 if ($action == 'create')
0895 {
0896 $sql_ary['field_id'] = $field_id;
0897 $sql_ary['lang_id'] = $default_lang_id;
0898
0899 $profile_sql[] = 'INSERT INTO ' . PROFILE_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
0900 }
0901 else
0902 {
0903 $this->update_insert(PROFILE_LANG_TABLE, $sql_ary, array('field_id' => $field_id, 'lang_id' => $default_lang_id));
0904 }
0905
0906 if (is_array($cp->vars['l_lang_name']) && sizeof($cp->vars['l_lang_name']))
0907 {
0908 foreach ($cp->vars['l_lang_name'] as $lang_id => $data)
0909 {
0910 if (($cp->vars['lang_name'] != '' && $cp->vars['l_lang_name'][$lang_id] == '')
0911 || ($cp->vars['lang_explain'] != '' && $cp->vars['l_lang_explain'][$lang_id] == '')
0912 || ($cp->vars['lang_default_value'] != '' && $cp->vars['l_lang_default_value'][$lang_id] == ''))
0913 {
0914 $empty_lang[$lang_id] = true;
0915 break;
0916 }
0917
0918 if (!isset($empty_lang[$lang_id]))
0919 {
0920 $profile_lang[] = array(
0921 'field_id' => $field_id,
0922 'lang_id' => $lang_id,
0923 'lang_name' => $cp->vars['l_lang_name'][$lang_id],
0924 'lang_explain' => (isset($cp->vars['l_lang_explain'][$lang_id])) ? $cp->vars['l_lang_explain'][$lang_id] : '',
0925 'lang_default_value' => (isset($cp->vars['l_lang_default_value'][$lang_id])) ? $cp->vars['l_lang_default_value'][$lang_id] : ''
0926 );
0927 }
0928 }
0929
0930 foreach ($empty_lang as $lang_id => $NULL)
0931 {
0932 $sql = 'DELETE FROM ' . PROFILE_LANG_TABLE . "
0933 WHERE field_id = $field_id
0934 AND lang_id = " . (int) $lang_id;
0935 $db->sql_query($sql);
0936 }
0937 }
0938
0939 $cp->vars = $profile_field->get_language_options_input($cp->vars);
0940
0941 if ($cp->vars['lang_options'])
0942 {
0943 if (!is_array($cp->vars['lang_options']))
0944 {
0945 $cp->vars['lang_options'] = explode("\n", $cp->vars['lang_options']);
0946 }
0947
0948 if ($action != 'create')
0949 {
0950 $sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . "
0951 WHERE field_id = $field_id
0952 AND lang_id = " . (int) $default_lang_id;
0953 $db->sql_query($sql);
0954 }
0955
0956 foreach ($cp->vars['lang_options'] as $option_id => $value)
0957 {
0958 $sql_ary = array(
0959 'field_type' => $field_type,
0960 'lang_value' => $value
0961 );
0962
0963 if ($action == 'create')
0964 {
0965 $sql_ary['field_id'] = $field_id;
0966 $sql_ary['lang_id'] = $default_lang_id;
0967 $sql_ary['option_id'] = (int) $option_id;
0968
0969 $profile_sql[] = 'INSERT INTO ' . PROFILE_FIELDS_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
0970 }
0971 else
0972 {
0973 $this->update_insert(PROFILE_FIELDS_LANG_TABLE, $sql_ary, array(
0974 'field_id' => $field_id,
0975 'lang_id' => (int) $default_lang_id,
0976 'option_id' => (int) $option_id)
0977 );
0978 }
0979 }
0980 }
0981
0982 if (is_array($cp->vars['l_lang_options']) && sizeof($cp->vars['l_lang_options']))
0983 {
0984 $empty_lang = array();
0985
0986 foreach ($cp->vars['l_lang_options'] as $lang_id => $lang_ary)
0987 {
0988 if (!is_array($lang_ary))
0989 {
0990 $lang_ary = explode("\n", $lang_ary);
0991 }
0992
0993 if (sizeof($lang_ary) != sizeof($cp->vars['lang_options']))
0994 {
0995 $empty_lang[$lang_id] = true;
0996 }
0997
0998 if (!isset($empty_lang[$lang_id]))
0999 {
1000 if ($action != 'create')
1001 {
1002 $sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . "
1003 WHERE field_id = $field_id
1004 AND lang_id = " . (int) $lang_id;
1005 $db->sql_query($sql);
1006 }
1007
1008 foreach ($lang_ary as $option_id => $value)
1009 {
1010 $profile_lang_fields[] = array(
1011 'field_id' => (int) $field_id,
1012 'lang_id' => (int) $lang_id,
1013 'option_id' => (int) $option_id,
1014 'field_type' => $field_type,
1015 'lang_value' => $value
1016 );
1017 }
1018 }
1019 }
1020
1021 foreach ($empty_lang as $lang_id => $NULL)
1022 {
1023 $sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . "
1024 WHERE field_id = $field_id
1025 AND lang_id = " . (int) $lang_id;
1026 $db->sql_query($sql);
1027 }
1028 }
1029
1030 foreach ($profile_lang as $sql)
1031 {
1032 if ($action == 'create')
1033 {
1034 $profile_sql[] = 'INSERT INTO ' . PROFILE_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $sql);
1035 }
1036 else
1037 {
1038 $lang_id = $sql['lang_id'];
1039 unset($sql['lang_id'], $sql['field_id']);
1040
1041 $this->update_insert(PROFILE_LANG_TABLE, $sql, array('lang_id' => (int) $lang_id, 'field_id' => $field_id));
1042 }
1043 }
1044
1045 if (sizeof($profile_lang_fields))
1046 {
1047 foreach ($profile_lang_fields as $sql)
1048 {
1049 if ($action == 'create')
1050 {
1051 $profile_sql[] = 'INSERT INTO ' . PROFILE_FIELDS_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $sql);
1052 }
1053 else
1054 {
1055 $lang_id = $sql['lang_id'];
1056 $option_id = $sql['option_id'];
1057 unset($sql['lang_id'], $sql['field_id'], $sql['option_id']);
1058
1059 $this->update_insert(PROFILE_FIELDS_LANG_TABLE, $sql, array(
1060 'lang_id' => $lang_id,
1061 'field_id' => $field_id,
1062 'option_id' => $option_id)
1063 );
1064 }
1065 }
1066 }
1067
1068 $db->sql_transaction('begin');
1069
1070 if ($action == 'create')
1071 {
1072 foreach ($profile_sql as $sql)
1073 {
1074 $db->sql_query($sql);
1075 }
1076 }
1077
1078 $db->sql_transaction('commit');
1079
1080 if ($action == 'edit')
1081 {
1082 add_log('admin', 'LOG_PROFILE_FIELD_EDIT', $cp->vars['field_ident'] . ':' . $cp->vars['lang_name']);
1083 trigger_error($user->lang['CHANGED_PROFILE_FIELD'] . adm_back_link($this->u_action));
1084 }
1085 else
1086 {
1087 add_log('admin', 'LOG_PROFILE_FIELD_CREATE', substr($field_ident, 3) . ':' . $cp->vars['lang_name']);
1088 trigger_error($user->lang['ADDED_PROFILE_FIELD'] . adm_back_link($this->u_action));
1089 }
1090 }
1091
1092 /**
1093 * Update, then insert if not successfull
1094 */
1095 function update_insert($table, $sql_ary, $where_fields)
1096 {
1097 global $db;
1098
1099 $where_sql = array();
1100 $check_key = '';
1101
1102 foreach ($where_fields as $key => $value)
1103 {
1104 $check_key = (!$check_key) ? $key : $check_key;
1105 $where_sql[] = $key . ' = ' . ((is_string($value)) ? "'" . $db->sql_escape($value) . "'" : (int) $value);
1106 }
1107
1108 if (!sizeof($where_sql))
1109 {
1110 return;
1111 }
1112
1113 $sql = "SELECT $check_key
1114 FROM $table
1115 WHERE " . implode(' AND ', $where_sql);
1116 $result = $db->sql_query($sql);
1117 $row = $db->sql_fetchrow($result);
1118 $db->sql_freeresult($result);
1119
1120 if (!$row)
1121 {
1122 $sql_ary = array_merge($where_fields, $sql_ary);
1123
1124 if (sizeof($sql_ary))
1125 {
1126 $db->sql_query("INSERT INTO $table " . $db->sql_build_array('INSERT', $sql_ary));
1127 }
1128 }
1129 else
1130 {
1131 if (sizeof($sql_ary))
1132 {
1133 $sql = "UPDATE $table SET " . $db->sql_build_array('UPDATE', $sql_ary) . '
1134 WHERE ' . implode(' AND ', $where_sql);
1135 $db->sql_query($sql);
1136 }
1137 }
1138 }
1139 }
1140