phpBB/includes/functions_profile_fields.php

   1 <?php
   2 /**
   3 *
   4 * @package phpBB3
   5 * @version $Id$
   6 * @copyright (c) 2005 phpBB Group
   7 * @license http://opensource.org/licenses/gpl-license.php GNU Public License
   8 *
   9 */
  10
  11 /**
  12 * @ignore
  13 */
  14 if (!defined('IN_PHPBB'))
  15 {
  16         exit;
  17 }
  18
  19 /**
  20 * Custom Profile Fields
  21 * @package phpBB3
  22 */
  23 class custom_profile
  24 {
  25         var $profile_types = array(FIELD_INT => 'int', FIELD_STRING => 'string', FIELD_TEXT => 'text', FIELD_BOOL => 'bool', FIELD_DROPDOWN => 'dropdown', FIELD_DATE => 'date');
  26         var $profile_cache = array();
  27         var $options_lang = array();
  28
  29         /**
  30         * Assign editable fields to template, mode can be profile (for profile change) or register (for registration)
  31         * Called by ucp_profile and ucp_register
  32         * @access public
  33         */
  34         function generate_profile_fields($mode, $lang_id)
  35         {
  36                 global $db, $template, $auth;
  37
  38                 $sql_where = '';
  39                 switch ($mode)
  40                 {
  41                         case 'register':
  42                                 // If the field is required we show it on the registration page
  43                                 $sql_where .= ' AND f.field_show_on_reg = 1';
  44                         break;
  45
  46                         case 'profile':
  47                                 // Show hidden fields to moderators/admins
  48                                 if (!$auth->acl_gets('a_', 'm_') && !$auth->acl_getf_global('m_'))
  49                                 {
  50                                         $sql_where .= ' AND f.field_show_profile = 1';
  51                                 }
  52                         break;
  53
  54                         default:
  55                                 trigger_error('Wrong profile mode specified', E_USER_ERROR);
  56                         break;
  57                 }
  58
  59                 $sql = 'SELECT l.*, f.*
  60                         FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . " f
  61                         WHERE f.field_active = 1
  62                                 $sql_where
  63                                 AND l.lang_id = $lang_id
  64                                 AND l.field_id = f.field_id
  65                         ORDER BY f.field_order";
  66                 $result = $db->sql_query($sql);
  67
  68                 while ($row = $db->sql_fetchrow($result))
  69                 {
  70                         // Return templated field
  71                         $tpl_snippet = $this->process_field_row('change', $row);
  72
  73                         // Some types are multivalue, we can't give them a field_id as we would not know which to pick
  74                         $type = (int) $row['field_type'];
  75
  76                         $template->assign_block_vars('profile_fields', array(
  77                                 'LANG_NAME'             => $row['lang_name'],
  78                                 'LANG_EXPLAIN'  => $row['lang_explain'],
  79                                 'FIELD'                 => $tpl_snippet,
  80                                 'FIELD_ID'              => ($type == FIELD_DATE || ($type == FIELD_BOOL && $row['field_length'] == '1')) ? '' : 'pf_' . $row['field_ident'],
  81                                 'S_REQUIRED'    => ($row['field_required']) ? true : false)
  82                         );
  83                 }
  84                 $db->sql_freeresult($result);
  85         }
  86
  87         /**
  88         * Validate entered profile field data
  89         * @access public
  90         */
  91         function validate_profile_field($field_type, &$field_value, $field_data)
  92         {
  93                 switch ($field_type)
  94                 {
  95                         case FIELD_DATE:
  96                                 $field_validate = explode('-', $field_value);
  97
  98                                 $day = (isset($field_validate[0])) ? (int) $field_validate[0] : 0;
  99                                 $month = (isset($field_validate[1])) ? (int) $field_validate[1] : 0;
 100                                 $year = (isset($field_validate[2])) ? (int) $field_validate[2] : 0;
 101
 102                                 if ((!$day || !$month || !$year) && !$field_data['field_required'])
 103                                 {
 104                                         return false;
 105                                 }
 106
 107                                 if ((!$day || !$month || !$year) && $field_data['field_required'])
 108                                 {
 109                                         return 'FIELD_REQUIRED';
 110                                 }
 111
 112                                 if ($day < 0 || $day > 31 || $month < 0 || $month > 12 || ($year < 1901 && $year > 0) || $year > gmdate('Y', time()) + 50)
 113                                 {
 114                                         return 'FIELD_INVALID_DATE';
 115                                 }
 116
 117                                 if (checkdate($month, $day, $year) === false)
 118                                 {
 119                                         return 'FIELD_INVALID_DATE';
 120                                 }
 121                         break;
 122
 123                         case FIELD_BOOL:
 124                                 $field_value = (bool) $field_value;
 125
 126                                 if (!$field_value && $field_data['field_required'])
 127                                 {
 128                                         return 'FIELD_REQUIRED';
 129                                 }
 130                         break;
 131
 132                         case FIELD_INT:
 133                                 if (trim($field_value) === '' && !$field_data['field_required'])
 134                                 {
 135                                         return false;
 136                                 }
 137
 138                                 $field_value = (int) $field_value;
 139
 140                                 if ($field_value < $field_data['field_minlen'])
 141                                 {
 142                                         return 'FIELD_TOO_SMALL';
 143                                 }
 144                                 else if ($field_value > $field_data['field_maxlen'])
 145                                 {
 146                                         return 'FIELD_TOO_LARGE';
 147                                 }
 148                         break;
 149
 150                         case FIELD_DROPDOWN:
 151                                 $field_value = (int) $field_value;
 152
 153                                 if ($field_value == $field_data['field_novalue'] && $field_data['field_required'])
 154                                 {
 155                                         return 'FIELD_REQUIRED';
 156                                 }
 157                         break;
 158
 159                         case FIELD_STRING:
 160                         case FIELD_TEXT:
 161                                 if (empty($field_value) && !$field_data['field_required'])
 162                                 {
 163                                         return false;
 164                                 }
 165                                 else if (empty($field_value) && $field_data['field_required'])
 166                                 {
 167                                         return 'FIELD_REQUIRED';
 168                                 }
 169
 170                                 if ($field_data['field_minlen'] && utf8_strlen($field_value) < $field_data['field_minlen'])
 171                                 {
 172                                         return 'FIELD_TOO_SHORT';
 173                                 }
 174                                 else if ($field_data['field_maxlen'] && utf8_strlen($field_value) > $field_data['field_maxlen'])
 175                                 {
 176                                         return 'FIELD_TOO_LONG';
 177                                 }
 178
 179                                 if (!empty($field_data['field_validation']) && $field_data['field_validation'] != '.*')
 180                                 {
 181                                         $field_validate = ($field_type == FIELD_STRING) ? $field_value : bbcode_nl2br($field_value);
 182                                         if (!preg_match('#^' . str_replace('\\\\', '\\', $field_data['field_validation']) . '$#i', $field_validate))
 183                                         {
 184                                                 return 'FIELD_INVALID_CHARS';
 185                                         }
 186                                 }
 187                         break;
 188                 }
 189
 190                 return false;
 191         }
 192
 193         /**
 194         * Build profile cache, used for display
 195         * @access private
 196         */
 197         function build_cache()
 198         {
 199                 global $db, $user, $auth;
 200
 201                 $this->profile_cache = array();
 202
 203                 // Display hidden/no_view fields for admin/moderator
 204                 $sql = 'SELECT l.*, f.*
 205                         FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . ' f
 206                         WHERE l.lang_id = ' . $user->get_iso_lang_id() . '
 207                                 AND f.field_active = 1 ' .
 208                                 ((!$auth->acl_gets('a_', 'm_') && !$auth->acl_getf_global('m_')) ? '    AND f.field_hide = 0 ' : '') . '
 209                                 AND f.field_no_view = 0
 210                                 AND l.field_id = f.field_id
 211                         ORDER BY f.field_order';
 212                 $result = $db->sql_query($sql);
 213
 214                 while ($row = $db->sql_fetchrow($result))
 215                 {
 216                         $this->profile_cache[$row['field_ident']] = $row;
 217                 }
 218                 $db->sql_freeresult($result);
 219         }
 220
 221         /**
 222         * Get language entries for options and store them here for later use
 223         */
 224         function get_option_lang($field_id, $lang_id, $field_type, $preview)
 225         {
 226                 global $db;
 227
 228                 if ($preview)
 229                 {
 230                         $lang_options = (!is_array($this->vars['lang_options'])) ? explode("\n", $this->vars['lang_options']) : $this->vars['lang_options'];
 231
 232                         foreach ($lang_options as $num => $var)
 233                         {
 234                                 $this->options_lang[$field_id][$lang_id][($num + 1)] = $var;
 235                         }
 236                 }
 237                 else
 238                 {
 239                         $sql = 'SELECT option_id, lang_value
 240                                 FROM ' . PROFILE_FIELDS_LANG_TABLE . "
 241                                         WHERE field_id = $field_id
 242                                         AND lang_id = $lang_id
 243                                         AND field_type = $field_type
 244                                 ORDER BY option_id";
 245                         $result = $db->sql_query($sql);
 246
 247                         while ($row = $db->sql_fetchrow($result))
 248                         {
 249                                 $this->options_lang[$field_id][$lang_id][($row['option_id'] + 1)] = $row['lang_value'];
 250                         }
 251                         $db->sql_freeresult($result);
 252                 }
 253         }
 254
 255         /**
 256         * Submit profile field for validation
 257         * @access public
 258         */
 259         function submit_cp_field($mode, $lang_id, &$cp_data, &$cp_error)
 260         {
 261                 global $auth, $db, $user;
 262
 263                 $sql_where = '';
 264                 switch ($mode)
 265                 {
 266                         case 'register':
 267                                 // If the field is required we show it on the registration page
 268                                 $sql_where .= ' AND f.field_show_on_reg = 1';
 269                         break;
 270
 271                         case 'profile':
 272                                 // Show hidden fields to moderators/admins
 273                                 if (!$auth->acl_gets('a_', 'm_') && !$auth->acl_getf_global('m_'))
 274                                 {
 275                                         $sql_where .= ' AND f.field_show_profile = 1';
 276                                 }
 277                         break;
 278
 279                         default:
 280                                 trigger_error('Wrong profile mode specified', E_USER_ERROR);
 281                         break;
 282                 }
 283
 284                 $sql = 'SELECT l.*, f.*
 285                         FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . " f
 286                         WHERE l.lang_id = $lang_id
 287                                 AND f.field_active = 1
 288                                 $sql_where
 289                                 AND l.field_id = f.field_id
 290                         ORDER BY f.field_order";
 291                 $result = $db->sql_query($sql);
 292
 293                 while ($row = $db->sql_fetchrow($result))
 294                 {
 295                         $cp_data['pf_' . $row['field_ident']] = $this->get_profile_field($row);
 296                         $check_value = $cp_data['pf_' . $row['field_ident']];
 297
 298                         if (($cp_result = $this->validate_profile_field($row['field_type'], $check_value, $row)) !== false)
 299                         {
 300                                 // If not and only showing common error messages, use this one
 301                                 $error = '';
 302                                 switch ($cp_result)
 303                                 {
 304                                         case 'FIELD_INVALID_DATE':
 305                                         case 'FIELD_REQUIRED':
 306                                                 $error = sprintf($user->lang[$cp_result], $row['lang_name']);
 307                                         break;
 308
 309                                         case 'FIELD_TOO_SHORT':
 310                                         case 'FIELD_TOO_SMALL':
 311                                                 $error = sprintf($user->lang[$cp_result], $row['lang_name'], $row['field_minlen']);
 312                                         break;
 313
 314                                         case 'FIELD_TOO_LONG':
 315                                         case 'FIELD_TOO_LARGE':
 316                                                 $error = sprintf($user->lang[$cp_result], $row['lang_name'], $row['field_maxlen']);
 317                                         break;
 318
 319                                         case 'FIELD_INVALID_CHARS':
 320                                                 switch ($row['field_validation'])
 321                                                 {
 322                                                         case '[0-9]+':
 323                                                                 $error = sprintf($user->lang[$cp_result . '_NUMBERS_ONLY'], $row['lang_name']);
 324                                                         break;
 325
 326                                                         case '[\w]+':
 327                                                                 $error = sprintf($user->lang[$cp_result . '_ALPHA_ONLY'], $row['lang_name']);
 328                                                         break;
 329
 330                                                         case '[\w_\+\. \-\[\]]+':
 331                                                                 $error = sprintf($user->lang[$cp_result . '_SPACERS_ONLY'], $row['lang_name']);
 332                                                         break;
 333                                                 }
 334                                         break;
 335                                 }
 336
 337                                 if ($error != '')
 338                                 {
 339                                         $cp_error[] = $error;
 340                                 }
 341                         }
 342                 }
 343                 $db->sql_freeresult($result);
 344         }
 345
 346         /**
 347         * Update profile field data directly
 348         */
 349         function update_profile_field_data($user_id, &$cp_data)
 350         {
 351                 global $db;
 352
 353                 if (!sizeof($cp_data))
 354                 {
 355                         return;
 356                 }
 357
 358                 switch ($db->sql_layer)
 359                 {
 360                         case 'oracle':
 361                         case 'firebird':
 362                         case 'postgres':
 363                                 $right_delim = $left_delim = '"';
 364                         break;
 365
 366                         case 'sqlite':
 367                         case 'mssql':
 368                         case 'mssql_odbc':
 369                                 $right_delim = ']';
 370                                 $left_delim = '[';
 371                         break;
 372
 373                         case 'mysql':
 374                         case 'mysql4':
 375                         case 'mysqli':
 376                                 $right_delim = $left_delim = '`';
 377                         break;
 378                 }
 379
 380                 // use new array for the UPDATE; changes in the key do not affect the original array
 381                 $cp_data_sql = array();
 382                 foreach ($cp_data as $key => $value)
 383                 {
 384                         // Firebird is case sensitive with delimiter
 385                         $cp_data_sql[$left_delim . (($db->sql_layer == 'firebird' || $db->sql_layer == 'oracle') ? strtoupper($key) : $key) . $right_delim] = $value;
 386                 }
 387
 388                 $sql = 'UPDATE ' . PROFILE_FIELDS_DATA_TABLE . '
 389                         SET ' . $db->sql_build_array('UPDATE', $cp_data_sql) . "
 390                         WHERE user_id = $user_id";
 391                 $db->sql_query($sql);
 392
 393                 if (!$db->sql_affectedrows())
 394                 {
 395                         $cp_data_sql['user_id'] = (int) $user_id;
 396
 397                         $db->sql_return_on_error(true);
 398
 399                         $sql = 'INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . ' ' . $db->sql_build_array('INSERT', $cp_data_sql);
 400                         $db->sql_query($sql);
 401
 402                         $db->sql_return_on_error(false);
 403                 }
 404         }
 405
 406         /**
 407         * Assign fields to template, used for viewprofile, viewtopic and memberlist (if load setting is enabled)
 408         * 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
 409         * @access public
 410         */
 411         function generate_profile_fields_template($mode, $user_id = 0, $profile_row = false)
 412         {
 413                 global $db;
 414
 415                 if ($mode == 'grab')
 416                 {
 417                         if (!is_array($user_id))
 418                         {
 419                                 $user_id = array($user_id);
 420                         }
 421
 422                         if (!sizeof($this->profile_cache))
 423                         {
 424                                 $this->build_cache();
 425                         }
 426
 427                         if (!sizeof($user_id))
 428                         {
 429                                 return array();
 430                         }
 431
 432                         $sql = 'SELECT *
 433                                 FROM ' . PROFILE_FIELDS_DATA_TABLE . '
 434                                 WHERE ' . $db->sql_in_set('user_id', array_map('intval', $user_id));
 435                         $result = $db->sql_query($sql);
 436
 437                         $field_data = array();
 438                         while ($row = $db->sql_fetchrow($result))
 439                         {
 440                                 $field_data[$row['user_id']] = $row;
 441                         }
 442                         $db->sql_freeresult($result);
 443
 444                         $user_fields = array();
 445
 446                         // Go through the fields in correct order
 447                         foreach (array_keys($this->profile_cache) as $used_ident)
 448                         {
 449                                 foreach ($field_data as $user_id => $row)
 450                                 {
 451                                         $user_fields[$user_id][$used_ident]['value'] = $row['pf_' . $used_ident];
 452                                         $user_fields[$user_id][$used_ident]['data'] = $this->profile_cache[$used_ident];
 453                                 }
 454                         }
 455
 456                         return $user_fields;
 457                 }
 458                 else if ($mode == 'show')
 459                 {
 460                         // $profile_row == $user_fields[$row['user_id']];
 461                         $tpl_fields = array();
 462                         $tpl_fields['row'] = $tpl_fields['blockrow'] = array();
 463
 464                         foreach ($profile_row as $ident => $ident_ary)
 465                         {
 466                                 $value = $this->get_profile_value($ident_ary);
 467
 468                                 if ($value === NULL)
 469                                 {
 470                                         continue;
 471                                 }
 472
 473                                 $tpl_fields['row'] += array(
 474                                         'PROFILE_' . strtoupper($ident) . '_VALUE'      => $value,
 475                                         'PROFILE_' . strtoupper($ident) . '_TYPE'       => $ident_ary['data']['field_type'],
 476                                         'PROFILE_' . strtoupper($ident) . '_NAME'       => $ident_ary['data']['lang_name'],
 477                                         'PROFILE_' . strtoupper($ident) . '_EXPLAIN'=> $ident_ary['data']['lang_explain'],
 478
 479                                         'S_PROFILE_' . strtoupper($ident)                       => true
 480                                 );
 481
 482                                 $tpl_fields['blockrow'][] = array(
 483                                         'PROFILE_FIELD_VALUE'   => $value,
 484                                         'PROFILE_FIELD_TYPE'    => $ident_ary['data']['field_type'],
 485                                         'PROFILE_FIELD_NAME'    => $ident_ary['data']['lang_name'],
 486                                         'PROFILE_FIELD_EXPLAIN' => $ident_ary['data']['lang_explain'],
 487
 488                                         'S_PROFILE_' . strtoupper($ident)               => true
 489                                 );
 490                         }
 491
 492                         return $tpl_fields;
 493                 }
 494                 else
 495                 {
 496                         trigger_error('Wrong mode for custom profile', E_USER_ERROR);
 497                 }
 498         }
 499
 500         /**
 501         * Get Profile Value for display
 502         */
 503         function get_profile_value($ident_ary)
 504         {
 505                 $value = $ident_ary['value'];
 506                 $field_type = $ident_ary['data']['field_type'];
 507
 508                 switch ($this->profile_types[$field_type])
 509                 {
 510                         case 'int':
 511                                 if ($value === '')
 512                                 {
 513                                         return NULL;
 514                                 }
 515                                 return (int) $value;
 516                         break;
 517
 518                         case 'string':
 519                         case 'text':
 520                                 if (!$value)
 521                                 {
 522                                         return NULL;
 523                                 }
 524
 525                                 $value = make_clickable($value);
 526                                 $value = censor_text($value);
 527                                 $value = bbcode_nl2br($value);
 528                                 return $value;
 529                         break;
 530
 531                         // case 'datetime':
 532                         case 'date':
 533                                 $date = explode('-', $value);
 534                                 $day = (isset($date[0])) ? (int) $date[0] : 0;
 535                                 $month = (isset($date[1])) ? (int) $date[1] : 0;
 536                                 $year = (isset($date[2])) ? (int) $date[2] : 0;
 537
 538                                 if (!$day && !$month && !$year)
 539                                 {
 540                                         return NULL;
 541                                 }
 542                                 else if ($day && $month && $year)
 543                                 {
 544                                         global $user;
 545                                         // d/m/y 00:00 GMT isn't necessarily on the same d/m/y in the user's timezone, so add the timezone seconds
 546                                         return $user->format_date(gmmktime(0, 0, 0, $month, $day, $year) + $user->timezone + $user->dst, $user->lang['DATE_FORMAT'], true);
 547                                 }
 548
 549                                 return $value;
 550                         break;
 551
 552                         case 'dropdown':
 553                                 $field_id = $ident_ary['data']['field_id'];
 554                                 $lang_id = $ident_ary['data']['lang_id'];
 555                                 if (!isset($this->options_lang[$field_id][$lang_id]))
 556                                 {
 557                                         $this->get_option_lang($field_id, $lang_id, FIELD_DROPDOWN, false);
 558                                 }
 559
 560                                 if ($value == $ident_ary['data']['field_novalue'])
 561                                 {
 562                                         return NULL;
 563                                 }
 564
 565                                 $value = (int) $value;
 566
 567                                 // User not having a value assigned
 568                                 if (!isset($this->options_lang[$field_id][$lang_id][$value]))
 569                                 {
 570                                         return NULL;
 571                                 }
 572
 573                                 return $this->options_lang[$field_id][$lang_id][$value];
 574                         break;
 575
 576                         case 'bool':
 577                                 $field_id = $ident_ary['data']['field_id'];
 578                                 $lang_id = $ident_ary['data']['lang_id'];
 579                                 if (!isset($this->options_lang[$field_id][$lang_id]))
 580                                 {
 581                                         $this->get_option_lang($field_id, $lang_id, FIELD_BOOL, false);
 582                                 }
 583
 584                                 if ($ident_ary['data']['field_length'] == 1)
 585                                 {
 586                                         return (isset($this->options_lang[$field_id][$lang_id][(int) $value])) ? $this->options_lang[$field_id][$lang_id][(int) $value] : NULL;
 587                                 }
 588                                 else if (!$value)
 589                                 {
 590                                         return NULL;
 591                                 }
 592                                 else
 593                                 {
 594                                         return $this->options_lang[$field_id][$lang_id][(int) ($value) + 1];
 595                                 }
 596                         break;
 597
 598                         default:
 599                                 trigger_error('Unknown profile type', E_USER_ERROR);
 600                         break;
 601                 }
 602         }
 603
 604         /**
 605         * Get field value for registration/profile
 606         * @access private
 607         */
 608         function get_var($field_validation, &$profile_row, $default_value, $preview)
 609         {
 610                 global $user;
 611
 612                 $profile_row['field_ident'] = (isset($profile_row['var_name'])) ? $profile_row['var_name'] : 'pf_' . $profile_row['field_ident'];
 613                 $user_ident = $profile_row['field_ident'];
 614                 // checkbox - only testing for isset
 615                 if ($profile_row['field_type'] == FIELD_BOOL && $profile_row['field_length'] == 2)
 616                 {
 617                         $value = (isset($_REQUEST[$profile_row['field_ident']])) ? true : ((!isset($user->profile_fields[$user_ident]) || $preview) ? $default_value : $user->profile_fields[$user_ident]);
 618                 }
 619                 else if ($profile_row['field_type'] == FIELD_INT)
 620                 {
 621                         if (isset($_REQUEST[$profile_row['field_ident']]))
 622                         {
 623                                 $value = ($_REQUEST[$profile_row['field_ident']] === '') ? NULL : request_var($profile_row['field_ident'], $default_value);
 624                         }
 625                         else
 626                         {
 627                                 if (!$preview && isset($user->profile_fields[$user_ident]) && is_null($user->profile_fields[$user_ident]))
 628                                 {
 629                                         $value = NULL;
 630                                 }
 631                                 else if (!isset($user->profile_fields[$user_ident]) || $preview)
 632                                 {
 633                                         $value = $default_value;
 634                                 }
 635                                 else
 636                                 {
 637                                         $value = $user->profile_fields[$user_ident];
 638                                 }
 639                         }
 640
 641                         return (is_null($value) || $value === '') ? '' : (int) $value;
 642                 }
 643                 else
 644                 {
 645                         $value = (isset($_REQUEST[$profile_row['field_ident']])) ? request_var($profile_row['field_ident'], $default_value, true) : ((!isset($user->profile_fields[$user_ident]) || $preview) ? $default_value : $user->profile_fields[$user_ident]);
 646
 647                         if (gettype($value) == 'string')
 648                         {
 649                                 $value = utf8_normalize_nfc($value);
 650                         }
 651                 }
 652
 653                 switch ($field_validation)
 654                 {
 655                         case 'int':
 656                                 return (int) $value;
 657                         break;
 658                 }
 659
 660                 return $value;
 661         }
 662
 663         /**
 664         * Process int-type
 665         * @access private
 666         */
 667         function generate_int($profile_row, $preview = false)
 668         {
 669                 global $template;
 670
 671                 $profile_row['field_value'] = $this->get_var('int', $profile_row, $profile_row['field_default_value'], $preview);
 672                 $template->assign_block_vars($this->profile_types[$profile_row['field_type']], array_change_key_case($profile_row, CASE_UPPER));
 673         }
 674
 675         /**
 676         * Process date-type
 677         * @access private
 678         */
 679         function generate_date($profile_row, $preview = false)
 680         {
 681                 global $user, $template;
 682
 683                 $profile_row['field_ident'] = (isset($profile_row['var_name'])) ? $profile_row['var_name'] : 'pf_' . $profile_row['field_ident'];
 684                 $user_ident = $profile_row['field_ident'];
 685
 686                 $now = getdate();
 687
 688                 if (!isset($_REQUEST[$profile_row['field_ident'] . '_day']))
 689                 {
 690                         if ($profile_row['field_default_value'] == 'now')
 691                         {
 692                                 $profile_row['field_default_value'] = sprintf('%2d-%2d-%4d', $now['mday'], $now['mon'], $now['year']);
 693                         }
 694                         list($day, $month, $year) = explode('-', ((!isset($user->profile_fields[$user_ident]) || $preview) ? $profile_row['field_default_value'] : $user->profile_fields[$user_ident]));
 695                 }
 696                 else
 697                 {
 698                         if ($preview && $profile_row['field_default_value'] == 'now')
 699                         {
 700                                 $profile_row['field_default_value'] = sprintf('%2d-%2d-%4d', $now['mday'], $now['mon'], $now['year']);
 701                                 list($day, $month, $year) = explode('-', ((!isset($user->profile_fields[$user_ident]) || $preview) ? $profile_row['field_default_value'] : $user->profile_fields[$user_ident]));
 702                         }
 703                         else
 704                         {
 705                                 $day = request_var($profile_row['field_ident'] . '_day', 0);
 706                                 $month = request_var($profile_row['field_ident'] . '_month', 0);
 707                                 $year = request_var($profile_row['field_ident'] . '_year', 0);
 708                         }
 709                 }
 710
 711                 $profile_row['s_day_options'] = '<option value="0"' . ((!$day) ? ' selected="selected"' : '') . '>--</option>';
 712                 for ($i = 1; $i < 32; $i++)
 713                 {
 714                         $profile_row['s_day_options'] .= '<option value="' . $i . '"' . (($i == $day) ? ' selected="selected"' : '') . ">$i</option>";
 715                 }
 716
 717                 $profile_row['s_month_options'] = '<option value="0"' . ((!$month) ? ' selected="selected"' : '') . '>--</option>';
 718                 for ($i = 1; $i < 13; $i++)
 719                 {
 720                         $profile_row['s_month_options'] .= '<option value="' . $i . '"' . (($i == $month) ? ' selected="selected"' : '') . ">$i</option>";
 721                 }
 722
 723                 $profile_row['s_year_options'] = '<option value="0"' . ((!$year) ? ' selected="selected"' : '') . '>--</option>';
 724                 for ($i = $now['year'] - 100; $i <= $now['year'] + 100; $i++)
 725                 {
 726                         $profile_row['s_year_options'] .= '<option value="' . $i . '"' . (($i == $year) ? ' selected="selected"' : '') . ">$i</option>";
 727                 }
 728                 unset($now);
 729
 730                 $profile_row['field_value'] = 0;
 731                 $template->assign_block_vars($this->profile_types[$profile_row['field_type']], array_change_key_case($profile_row, CASE_UPPER));
 732         }
 733
 734         /**
 735         * Process bool-type
 736         * @access private
 737         */
 738         function generate_bool($profile_row, $preview = false)
 739         {
 740                 global $template;
 741
 742                 $value = $this->get_var('int', $profile_row, $profile_row['field_default_value'], $preview);
 743
 744                 $profile_row['field_value'] = $value;
 745                 $template->assign_block_vars($this->profile_types[$profile_row['field_type']], array_change_key_case($profile_row, CASE_UPPER));
 746
 747                 if ($profile_row['field_length'] == 1)
 748                 {
 749                         if (!isset($this->options_lang[$profile_row['field_id']][$profile_row['lang_id']]) || !sizeof($this->options_lang[$profile_row['field_id']][$profile_row['lang_id']]))
 750                         {
 751                                 $this->get_option_lang($profile_row['field_id'], $profile_row['lang_id'], FIELD_BOOL, $preview);
 752                         }
 753
 754                         foreach ($this->options_lang[$profile_row['field_id']][$profile_row['lang_id']] as $option_id => $option_value)
 755                         {
 756                                 $template->assign_block_vars('bool.options', array(
 757                                         'OPTION_ID'     => $option_id,
 758                                         'CHECKED'       => ($value == $option_id) ? ' checked="checked"' : '',
 759                                         'VALUE'         => $option_value)
 760                                 );
 761                         }
 762                 }
 763         }
 764
 765         /**
 766         * Process string-type
 767         * @access private
 768         */
 769         function generate_string($profile_row, $preview = false)
 770         {
 771                 global $template;
 772
 773                 $profile_row['field_value'] = $this->get_var('string', $profile_row, $profile_row['lang_default_value'], $preview);
 774                 $template->assign_block_vars($this->profile_types[$profile_row['field_type']], array_change_key_case($profile_row, CASE_UPPER));
 775         }
 776
 777         /**
 778         * Process text-type
 779         * @access private
 780         */
 781         function generate_text($profile_row, $preview = false)
 782         {
 783                 global $template;
 784                 global $user, $phpEx, $phpbb_root_path;
 785
 786                 $field_length = explode('|', $profile_row['field_length']);
 787                 $profile_row['field_rows'] = $field_length[0];
 788                 $profile_row['field_cols'] = $field_length[1];
 789
 790                 $profile_row['field_value'] = $this->get_var('string', $profile_row, $profile_row['lang_default_value'], $preview);
 791                 $template->assign_block_vars($this->profile_types[$profile_row['field_type']], array_change_key_case($profile_row, CASE_UPPER));
 792         }
 793
 794         /**
 795         * Process dropdown-type
 796         * @access private
 797         */
 798         function generate_dropdown($profile_row, $preview = false)
 799         {
 800                 global $user, $template;
 801
 802                 $value = $this->get_var('int', $profile_row, $profile_row['field_default_value'], $preview);
 803
 804                 if (!isset($this->options_lang[$profile_row['field_id']]) || !isset($this->options_lang[$profile_row['field_id']][$profile_row['lang_id']]) || !sizeof($this->options_lang[$profile_row['field_id']][$profile_row['lang_id']]))
 805                 {
 806                         $this->get_option_lang($profile_row['field_id'], $profile_row['lang_id'], FIELD_DROPDOWN, $preview);
 807                 }
 808
 809                 $profile_row['field_value'] = $value;
 810                 $template->assign_block_vars($this->profile_types[$profile_row['field_type']], array_change_key_case($profile_row, CASE_UPPER));
 811
 812                 foreach ($this->options_lang[$profile_row['field_id']][$profile_row['lang_id']] as $option_id => $option_value)
 813                 {
 814                         $template->assign_block_vars('dropdown.options', array(
 815                                 'OPTION_ID'     => $option_id,
 816                                 'SELECTED'      => ($value == $option_id) ? ' selected="selected"' : '',
 817                                 'VALUE'         => $option_value)
 818                         );
 819                 }
 820         }
 821
 822         /**
 823         * Return Templated value/field. Possible values for $mode are:
 824         * change == user is able to set/enter profile values; preview == just show the value
 825         * @access private
 826         */
 827         function process_field_row($mode, $profile_row)
 828         {
 829                 global $template;
 830
 831                 $preview = ($mode == 'preview') ? true : false;
 832
 833                 // set template filename
 834                 $template->set_filenames(array(
 835                         'cp_body'               => 'custom_profile_fields.html')
 836                 );
 837
 838                 // empty previously filled blockvars
 839                 foreach ($this->profile_types as $field_case => $field_type)
 840                 {
 841                         $template->destroy_block_vars($field_type);
 842                 }
 843
 844                 // Assign template variables
 845                 $type_func = 'generate_' . $this->profile_types[$profile_row['field_type']];
 846                 $this->$type_func($profile_row, $preview);
 847
 848                 // Return templated data
 849                 return $template->assign_display('cp_body');
 850         }
 851
 852         /**
 853         * Build Array for user insertion into custom profile fields table
 854         */
 855         function build_insert_sql_array($cp_data)
 856         {
 857                 global $db, $user, $auth;
 858
 859                 $sql_not_in = array();
 860                 foreach ($cp_data as $key => $null)
 861                 {
 862                         $sql_not_in[] = (strncmp($key, 'pf_', 3) === 0) ? substr($key, 3) : $key;
 863                 }
 864
 865                 $sql = 'SELECT f.field_type, f.field_ident, f.field_default_value, l.lang_default_value
 866                         FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . ' f
 867                         WHERE l.lang_id = ' . $user->get_iso_lang_id() . '
 868                                 ' . ((sizeof($sql_not_in)) ? ' AND ' . $db->sql_in_set('f.field_ident', $sql_not_in, true) : '') . '
 869                                 AND l.field_id = f.field_id';
 870                 $result = $db->sql_query($sql);
 871
 872                 while ($row = $db->sql_fetchrow($result))
 873                 {
 874                         if ($row['field_default_value'] == 'now' && $row['field_type'] == FIELD_DATE)
 875                         {
 876                                 $now = getdate();
 877                                 $row['field_default_value'] = sprintf('%2d-%2d-%4d', $now['mday'], $now['mon'], $now['year']);
 878                         }
 879
 880                         $cp_data['pf_' . $row['field_ident']] = (in_array($row['field_type'], array(FIELD_TEXT, FIELD_STRING))) ? $row['lang_default_value'] : $row['field_default_value'];
 881                 }
 882                 $db->sql_freeresult($result);
 883
 884                 return $cp_data;
 885         }
 886
 887         /**
 888         * Get profile field value on submit
 889         * @access private
 890         */
 891         function get_profile_field($profile_row)
 892         {
 893                 global $phpbb_root_path, $phpEx;
 894                 global $config;
 895
 896                 $var_name = 'pf_' . $profile_row['field_ident'];
 897
 898                 switch ($profile_row['field_type'])
 899                 {
 900                         case FIELD_DATE:
 901
 902                                 if (!isset($_REQUEST[$var_name . '_day']))
 903                                 {
 904                                         if ($profile_row['field_default_value'] == 'now')
 905                                         {
 906                                                 $now = getdate();
 907                                                 $profile_row['field_default_value'] = sprintf('%2d-%2d-%4d', $now['mday'], $now['mon'], $now['year']);
 908                                         }
 909                                         list($day, $month, $year) = explode('-', $profile_row['field_default_value']);
 910                                 }
 911                                 else
 912                                 {
 913                                         $day = request_var($var_name . '_day', 0);
 914                                         $month = request_var($var_name . '_month', 0);
 915                                         $year = request_var($var_name . '_year', 0);
 916                                 }
 917
 918                                 $var = sprintf('%2d-%2d-%4d', $day, $month, $year);
 919                         break;
 920
 921                         case FIELD_BOOL:
 922                                 // Checkbox
 923                                 if ($profile_row['field_length'] == 2)
 924                                 {
 925                                         $var = (isset($_REQUEST[$var_name])) ? 1 : 0;
 926                                 }
 927                                 else
 928                                 {
 929                                         $var = request_var($var_name, (int) $profile_row['field_default_value']);
 930                                 }
 931                         break;
 932
 933                         case FIELD_STRING:
 934                         case FIELD_TEXT:
 935                                 $var = utf8_normalize_nfc(request_var($var_name, (string) $profile_row['field_default_value'], true));
 936                         break;
 937
 938                         case FIELD_INT:
 939                                 if (isset($_REQUEST[$var_name]) && $_REQUEST[$var_name] === '')
 940                                 {
 941                                         $var = NULL;
 942                                 }
 943                                 else
 944                                 {
 945                                         $var = request_var($var_name, (int) $profile_row['field_default_value']);
 946                                 }
 947                         break;
 948
 949                         case FIELD_DROPDOWN:
 950                                 $var = request_var($var_name, (int) $profile_row['field_default_value']);
 951                         break;
 952
 953                         default:
 954                                 $var = request_var($var_name, $profile_row['field_default_value']);
 955                         break;
 956                 }
 957
 958                 return $var;
 959         }
 960 }
 961
 962 /**
 963 * Custom Profile Fields ACP
 964 * @package phpBB3
 965 */
 966 class custom_profile_admin extends custom_profile
 967 {
 968         var $vars = array();
 969
 970         /**
 971         * Return possible validation options
 972         */
 973         function validate_options()
 974         {
 975                 global $user;
 976
 977                 $validate_ary = array('CHARS_ANY' => '.*', 'NUMBERS_ONLY' => '[0-9]+', 'ALPHA_ONLY' => '[\w]+', 'ALPHA_SPACERS' => '[\w_\+\. \-\[\]]+');
 978
 979                 $validate_options = '';
 980                 foreach ($validate_ary as $lang => $value)
 981                 {
 982                         $selected = ($this->vars['field_validation'] == $value) ? ' selected="selected"' : '';
 983                         $validate_options .= '<option value="' . $value . '"' . $selected . '>' . $user->lang[$lang] . '</option>';
 984                 }
 985
 986                 return $validate_options;
 987         }
 988
 989         /**
 990         * Get string options for second step in ACP
 991         */
 992         function get_string_options()
 993         {
 994                 global $user;
 995
 996                 $options = array(
 997                         0 => array('TITLE' => $user->lang['FIELD_LENGTH'],              'FIELD' => '<input type="text" name="field_length" size="5" value="' . $this->vars['field_length'] . '" />'),
 998                         1 => array('TITLE' => $user->lang['MIN_FIELD_CHARS'],   'FIELD' => '<input type="text" name="field_minlen" size="5" value="' . $this->vars['field_minlen'] . '" />'),
 999                         2 => array('TITLE' => $user->lang['MAX_FIELD_CHARS'],   'FIELD' => '<input type="text" name="field_maxlen" size="5" value="' . $this->vars['field_maxlen'] . '" />'),
1000                         3 => array('TITLE' => $user->lang['FIELD_VALIDATION'],  'FIELD' => '<select name="field_validation">' . $this->validate_options() . '</select>')
1001                 );
1002
1003                 return $options;
1004         }
1005
1006         /**
1007         * Get text options for second step in ACP
1008         */
1009         function get_text_options()
1010         {
1011                 global $user;
1012
1013                 $options = array(
1014                         0 => array('TITLE' => $user->lang['FIELD_LENGTH'],              'FIELD' => '<input name="rows" size="5" value="' . $this->vars['rows'] . '" /> ' . $user->lang['ROWS'] . '</dd><dd><input name="columns" size="5" value="' . $this->vars['columns'] . '" /> ' . $user->lang['COLUMNS'] . ' <input type="hidden" name="field_length" value="' . $this->vars['field_length'] . '" />'),
1015                         1 => array('TITLE' => $user->lang['MIN_FIELD_CHARS'],   'FIELD' => '<input type="text" name="field_minlen" size="10" value="' . $this->vars['field_minlen'] . '" />'),
1016                         2 => array('TITLE' => $user->lang['MAX_FIELD_CHARS'],   'FIELD' => '<input type="text" name="field_maxlen" size="10" value="' . $this->vars['field_maxlen'] . '" />'),
1017                         3 => array('TITLE' => $user->lang['FIELD_VALIDATION'],  'FIELD' => '<select name="field_validation">' . $this->validate_options() . '</select>')
1018                 );
1019
1020                 return $options;
1021         }
1022
1023         /**
1024         * Get int options for second step in ACP
1025         */
1026         function get_int_options()
1027         {
1028                 global $user;
1029
1030                 $options = array(
1031                         0 => array('TITLE' => $user->lang['FIELD_LENGTH'],              'FIELD' => '<input type="text" name="field_length" size="5" value="' . $this->vars['field_length'] . '" />'),
1032                         1 => array('TITLE' => $user->lang['MIN_FIELD_NUMBER'],  'FIELD' => '<input type="text" name="field_minlen" size="5" value="' . $this->vars['field_minlen'] . '" />'),
1033                         2 => array('TITLE' => $user->lang['MAX_FIELD_NUMBER'],  'FIELD' => '<input type="text" name="field_maxlen" size="5" value="' . $this->vars['field_maxlen'] . '" />'),
1034                         3 => array('TITLE' => $user->lang['DEFAULT_VALUE'],             'FIELD' => '<input type="post" name="field_default_value" value="' . $this->vars['field_default_value'] . '" />')
1035                 );
1036
1037                 return $options;
1038         }
1039
1040         /**
1041         * Get bool options for second step in ACP
1042         */
1043         function get_bool_options()
1044         {
1045                 global $user, $config, $lang_defs;
1046
1047                 $default_lang_id = $lang_defs['iso'][$config['default_lang']];
1048
1049                 $profile_row = array(
1050                         'var_name'                              => 'field_default_value',
1051                         'field_id'                              => 1,
1052                         'lang_name'                             => $this->vars['lang_name'],
1053                         'lang_explain'                  => $this->vars['lang_explain'],
1054                         'lang_id'                               => $default_lang_id,
1055                         'field_default_value'   => $this->vars['field_default_value'],
1056                         'field_ident'                   => 'field_default_value',
1057                         'field_type'                    => FIELD_BOOL,
1058                         'field_length'                  => $this->vars['field_length'],
1059                         'lang_options'                  => $this->vars['lang_options']
1060                 );
1061
1062                 $options = array(
1063                         0 => array('TITLE' => $user->lang['FIELD_TYPE'], 'EXPLAIN' => $user->lang['BOOL_TYPE_EXPLAIN'], 'FIELD' => '<label><input type="radio" class="radio" name="field_length" value="1"' . (($this->vars['field_length'] == 1) ? ' checked="checked"' : '') . ' onchange="document.getElementById(\'add_profile_field\').submit();" /> ' . $user->lang['RADIO_BUTTONS'] . '</label><label><input type="radio" class="radio" name="field_length" value="2"' . (($this->vars['field_length'] == 2) ? ' checked="checked"' : '') . ' onchange="document.getElementById(\'add_profile_field\').submit();" /> ' . $user->lang['CHECKBOX'] . '</label>'),
1064                         1 => array('TITLE' => $user->lang['DEFAULT_VALUE'], 'FIELD' => $this->process_field_row('preview', $profile_row))
1065                 );
1066
1067                 return $options;
1068         }
1069
1070         /**
1071         * Get dropdown options for second step in ACP
1072         */
1073         function get_dropdown_options()
1074         {
1075                 global $user, $config, $lang_defs;
1076
1077                 $default_lang_id = $lang_defs['iso'][$config['default_lang']];
1078
1079                 $profile_row[0] = array(
1080                         'var_name'                              => 'field_default_value',
1081                         'field_id'                              => 1,
1082                         'lang_name'                             => $this->vars['lang_name'],
1083                         'lang_explain'                  => $this->vars['lang_explain'],
1084                         'lang_id'                               => $default_lang_id,
1085                         'field_default_value'   => $this->vars['field_default_value'],
1086                         'field_ident'                   => 'field_default_value',
1087                         'field_type'                    => FIELD_DROPDOWN,
1088                         'lang_options'                  => $this->vars['lang_options']
1089                 );
1090
1091                 $profile_row[1] = $profile_row[0];
1092                 $profile_row[1]['var_name'] = 'field_novalue';
1093                 $profile_row[1]['field_ident'] = 'field_novalue';
1094                 $profile_row[1]['field_default_value']  = $this->vars['field_novalue'];
1095
1096                 $options = array(
1097                         0 => array('TITLE' => $user->lang['DEFAULT_VALUE'], 'FIELD' => $this->process_field_row('preview', $profile_row[0])),
1098                         1 => array('TITLE' => $user->lang['NO_VALUE_OPTION'], 'EXPLAIN' => $user->lang['NO_VALUE_OPTION_EXPLAIN'], 'FIELD' => $this->process_field_row('preview', $profile_row[1]))
1099                 );
1100
1101                 return $options;
1102         }
1103
1104         /**
1105         * Get date options for second step in ACP
1106         */
1107         function get_date_options()
1108         {
1109                 global $user, $config, $lang_defs;
1110
1111                 $default_lang_id = $lang_defs['iso'][$config['default_lang']];
1112
1113                 $profile_row = array(
1114                         'var_name'                              => 'field_default_value',
1115                         'lang_name'                             => $this->vars['lang_name'],
1116                         'lang_explain'                  => $this->vars['lang_explain'],
1117                         'lang_id'                               => $default_lang_id,
1118                         'field_default_value'   => $this->vars['field_default_value'],
1119                         'field_ident'                   => 'field_default_value',
1120                         'field_type'                    => FIELD_DATE,
1121                         'field_length'                  => $this->vars['field_length']
1122                 );
1123
1124                 $always_now = request_var('always_now', -1);
1125                 if ($always_now == -1)
1126                 {
1127                         $s_checked = ($this->vars['field_default_value'] == 'now') ? true : false;
1128                 }
1129                 else
1130                 {
1131                         $s_checked = ($always_now) ? true : false;
1132                 }
1133
1134                 $options = array(
1135                         0 => array('TITLE' => $user->lang['DEFAULT_VALUE'],     'FIELD' => $this->process_field_row('preview', $profile_row)),
1136                         1 => array('TITLE' => $user->lang['ALWAYS_TODAY'],      'FIELD' => '<label><input type="radio" class="radio" name="always_now" value="1"' . (($s_checked) ? ' checked="checked"' : '') . ' onchange="document.getElementById(\'add_profile_field\').submit();" /> ' . $user->lang['YES'] . '</label><label><input type="radio" class="radio" name="always_now" value="0"' . ((!$s_checked) ? ' checked="checked"' : '') . ' onchange="document.getElementById(\'add_profile_field\').submit();" /> ' . $user->lang['NO'] . '</label>'),
1137                 );
1138
1139                 return $options;
1140         }
1141 }
1142
1143 ?>