| 
      1
     | 
    
      <?php
 
     | 
  
  
    | 
      2
     | 
    
      /**
 
     | 
  
  
    | 
      3
     | 
    
       *
 
     | 
  
  
    | 
      4
     | 
    
       * @category        admin
 
     | 
  
  
    | 
      5
     | 
    
       * @package         preferences
 
     | 
  
  
    | 
      6
     | 
    
       * @author          WebsiteBaker Project
 
     | 
  
  
    | 
      7
     | 
    
       * @copyright       2009-2012, Website Baker Org. e.V.
 
     | 
  
  
    | 
      8
     | 
    
       * @link			http://www.websitebaker2.org/
 
     | 
  
  
    | 
      9
     | 
    
       * @license         http://www.gnu.org/licenses/gpl.html
 
     | 
  
  
    | 
      10
     | 
    
       * @platform        WebsiteBaker 2.8.x
 
     | 
  
  
    | 
      11
     | 
    
       * @requirements    PHP 5.2.2 and higher
 
     | 
  
  
    | 
      12
     | 
    
       * @version         $Id: save.php 1569 2012-01-10 08:49:08Z darkviper $
 
     | 
  
  
    | 
      13
     | 
    
       * @filesource		$HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/admin/preferences/save.php $
 
     | 
  
  
    | 
      14
     | 
    
       * @lastmodified    $Date: 2012-01-10 09:49:08 +0100 (Tue, 10 Jan 2012) $
 
     | 
  
  
    | 
      15
     | 
    
       *
 
     | 
  
  
    | 
      16
     | 
    
       */
 
     | 
  
  
    | 
      17
     | 
    
      
 
     | 
  
  
    | 
      18
     | 
    
      
 
     | 
  
  
    | 
      19
     | 
    
      // Print admin header
 
     | 
  
  
    | 
      20
     | 
    
      require('../../config.php');
     | 
  
  
    | 
      21
     | 
    
      require_once(WB_PATH.'/framework/class.admin.php');
 
     | 
  
  
    | 
      22
     | 
    
      // suppress to print the header, so no new FTAN will be set
 
     | 
  
  
    | 
      23
     | 
    
      $admin = new admin('Preferences','start', false);
     | 
  
  
    | 
      24
     | 
    
      
 
     | 
  
  
    | 
      25
     | 
    
      function save_preferences( &$admin, &$database)
 
     | 
  
  
    | 
      26
     | 
    
      {
     | 
  
  
    | 
      27
     | 
    
      	global $MESSAGE;
 
     | 
  
  
    | 
      28
     | 
    
      	$err_msg = array();
 
     | 
  
  
    | 
      29
     | 
    
      	$iMinPassLength = 6;
 
     | 
  
  
    | 
      30
     | 
    
      // first check form-tan
 
     | 
  
  
    | 
      31
     | 
    
      	if(!$admin->checkFTAN()){ $err_msg[] = $MESSAGE['GENERIC_SECURITY_ACCESS']; }
     | 
  
  
    | 
      32
     | 
    
      // Get entered values and validate all
 
     | 
  
  
    | 
      33
     | 
    
      	// remove any dangerouse chars from display_name
 
     | 
  
  
    | 
      34
     | 
    
      	$display_name     = $admin->add_slashes(strip_tags(trim($admin->get_post('display_name'))));
     | 
  
  
    | 
      35
     | 
    
      	$display_name     = ( $display_name == '' ? $admin->get_display_name() : $display_name );
 
     | 
  
  
    | 
      36
     | 
    
      	// check that display_name is unique in whoole system (prevents from User-faking)
 
     | 
  
  
    | 
      37
     | 
    
      	$sql  = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'users` ';
 
     | 
  
  
    | 
      38
     | 
    
      	$sql .= 'WHERE `user_id` <> '.(int)$admin->get_user_id().' AND `display_name` LIKE "'.$display_name.'"';
 
     | 
  
  
    | 
      39
     | 
    
      	if( $database->get_one($sql) > 0 ){ $err_msg[] = $MESSAGE['USERS_USERNAME_TAKEN']; }
     | 
  
  
    | 
      40
     | 
    
      // language must be 2 upercase letters only
 
     | 
  
  
    | 
      41
     | 
    
      	$language         = strtoupper($admin->get_post('language'));
     | 
  
  
    | 
      42
     | 
    
      	$language         = (preg_match('/^[A-Z]{2}$/', $language) ? $language : DEFAULT_LANGUAGE);
     | 
  
  
    | 
      43
     | 
    
      // timezone must be between -12 and +13  or -20 as system_default
 
     | 
  
  
    | 
      44
     | 
    
      	$timezone         = $admin->get_post('timezone');
     | 
  
  
    | 
      45
     | 
    
      	$timezone         = (is_numeric($timezone) ? $timezone : -20);
 
     | 
  
  
    | 
      46
     | 
    
      	$timezone         = ( ($timezone >= -12 && $timezone <= 13) ? $timezone : -20 ) * 3600;
 
     | 
  
  
    | 
      47
     | 
    
      // date_format must be a key from /interface/date_formats
 
     | 
  
  
    | 
      48
     | 
    
      	$date_format      = $admin->get_post('date_format');
     | 
  
  
    | 
      49
     | 
    
      	$date_format_key  = str_replace(' ', '|', $date_format);
     | 
  
  
    | 
      50
     | 
    
      	$user_time = true;
 
     | 
  
  
    | 
      51
     | 
    
      	include( ADMIN_PATH.'/interface/date_formats.php' );
 
     | 
  
  
    | 
      52
     | 
    
      	$date_format = (array_key_exists($date_format_key, $DATE_FORMATS) ? $date_format : 'system_default');
 
     | 
  
  
    | 
      53
     | 
    
      	$date_format = ($date_format == 'system_default' ? '' : $date_format);
 
     | 
  
  
    | 
      54
     | 
    
      	unset($DATE_FORMATS);
 
     | 
  
  
    | 
      55
     | 
    
      // time_format must be a key from /interface/time_formats	
 
     | 
  
  
    | 
      56
     | 
    
      	$time_format      = $admin->get_post('time_format');
     | 
  
  
    | 
      57
     | 
    
      	$time_format_key  = str_replace(' ', '|', $time_format);
     | 
  
  
    | 
      58
     | 
    
      	$user_time = true;
 
     | 
  
  
    | 
      59
     | 
    
      	include( ADMIN_PATH.'/interface/time_formats.php' );
 
     | 
  
  
    | 
      60
     | 
    
      	$time_format = (array_key_exists($time_format_key, $TIME_FORMATS) ? $time_format : 'system_default');
 
     | 
  
  
    | 
      61
     | 
    
      	$time_format = ($time_format == 'system_default' ? '' : $time_format);
 
     | 
  
  
    | 
      62
     | 
    
      	unset($TIME_FORMATS);
 
     | 
  
  
    | 
      63
     | 
    
      // email should be validatet by core
 
     | 
  
  
    | 
      64
     | 
    
      	$email = trim( $admin->get_post('email') == null ? '' : $admin->get_post('email') );
     | 
  
  
    | 
      65
     | 
    
      	if( !$admin->validate_email($email) )
 
     | 
  
  
    | 
      66
     | 
    
      	{
     | 
  
  
    | 
      67
     | 
    
      		$email = '';
 
     | 
  
  
    | 
      68
     | 
    
      		$err_msg[] = $MESSAGE['USERS_INVALID_EMAIL'];
 
     | 
  
  
    | 
      69
     | 
    
      	}else {
     | 
  
  
    | 
      70
     | 
    
      		if($email != '') {
     | 
  
  
    | 
      71
     | 
    
      		// check that email is unique in whoole system
 
     | 
  
  
    | 
      72
     | 
    
      			$email = $admin->add_slashes($email);
 
     | 
  
  
    | 
      73
     | 
    
      			$sql  = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'users` ';
 
     | 
  
  
    | 
      74
     | 
    
      			$sql .= 'WHERE `user_id` <> '.(int)$admin->get_user_id().' AND `email` LIKE "'.$email.'"';
 
     | 
  
  
    | 
      75
     | 
    
      			if( $database->get_one($sql) > 0 ){ $err_msg[] = $MESSAGE['USERS_EMAIL_TAKEN']; }
     | 
  
  
    | 
      76
     | 
    
      		}
 
     | 
  
  
    | 
      77
     | 
    
      	}
 
     | 
  
  
    | 
      78
     | 
    
      // receive password vars and calculate needed action
 
     | 
  
  
    | 
      79
     | 
    
      	$sCurrentPassword = $admin->get_post('current_password');
     | 
  
  
    | 
      80
     | 
    
      	$sCurrentPassword = (is_null($sCurrentPassword) ? '' : $sCurrentPassword);
 
     | 
  
  
    | 
      81
     | 
    
      	$sNewPassword = $admin->get_post('new_password_1');
     | 
  
  
    | 
      82
     | 
    
      	$sNewPassword = (is_null($sNewPassword) ? '' : $sNewPassword);
 
     | 
  
  
    | 
      83
     | 
    
      	$sNewPasswordRetyped = $admin->get_post('new_password_2');
     | 
  
  
    | 
      84
     | 
    
      	$sNewPasswordRetyped= (is_null($sNewPasswordRetyped) ? '' : $sNewPasswordRetyped);
 
     | 
  
  
    | 
      85
     | 
    
      // Check existing password
 
     | 
  
  
    | 
      86
     | 
    
      	$sql  = 'SELECT `password` ';
 
     | 
  
  
    | 
      87
     | 
    
      	$sql .= 'FROM `'.TABLE_PREFIX.'users` ';
 
     | 
  
  
    | 
      88
     | 
    
      	$sql .= 'WHERE `user_id` = '.$admin->get_user_id();
 
     | 
  
  
    | 
      89
     | 
    
      	if (md5($sCurrentPassword) != $database->get_one($sql)) {
     | 
  
  
    | 
      90
     | 
    
      // access denied
 
     | 
  
  
    | 
      91
     | 
    
      		$err_msg[] = $MESSAGE['PREFERENCES_CURRENT_PASSWORD_INCORRECT'];
 
     | 
  
  
    | 
      92
     | 
    
      	}else {
     | 
  
  
    | 
      93
     | 
    
      // validate new password
 
     | 
  
  
    | 
      94
     | 
    
      		$sPwHashNew = false;
 
     | 
  
  
    | 
      95
     | 
    
      		if($sNewPassword != '') {
     | 
  
  
    | 
      96
     | 
    
      			if(strlen($sNewPassword) < $iMinPassLength) {
     | 
  
  
    | 
      97
     | 
    
      				$err_msg[] = $MESSAGE['USERS_PASSWORD_TOO_SHORT'];
 
     | 
  
  
    | 
      98
     | 
    
      			}else {
     | 
  
  
    | 
      99
     | 
    
      				if($sNewPassword != $sNewPasswordRetyped) {
     | 
  
  
    | 
      100
     | 
    
      					$err_msg[] = $MESSAGE['USERS_PASSWORD_MISMATCH'];
 
     | 
  
  
    | 
      101
     | 
    
      				}else {
     | 
  
  
    | 
      102
     | 
    
      					$pattern = '/[^'.$admin->password_chars.']/';
 
     | 
  
  
    | 
      103
     | 
    
      					if (preg_match($pattern, $sNewPassword)) {
     | 
  
  
    | 
      104
     | 
    
      						$err_msg[] = $MESSAGE['PREFERENCES_INVALID_CHARS'];
 
     | 
  
  
    | 
      105
     | 
    
      					}else {
     | 
  
  
    | 
      106
     | 
    
      						$sPwHashNew = md5($sNewPassword);
 
     | 
  
  
    | 
      107
     | 
    
      					}
 
     | 
  
  
    | 
      108
     | 
    
      				}
 
     | 
  
  
    | 
      109
     | 
    
      			}
 
     | 
  
  
    | 
      110
     | 
    
      		}
 
     | 
  
  
    | 
      111
     | 
    
      // if no validation errors, try to update the database, otherwise return errormessages
 
     | 
  
  
    | 
      112
     | 
    
      		if(sizeof($err_msg) == 0)
 
     | 
  
  
    | 
      113
     | 
    
      		{
     | 
  
  
    | 
      114
     | 
    
      			$sql  = 'UPDATE `'.TABLE_PREFIX.'users` ';
 
     | 
  
  
    | 
      115
     | 
    
      			$sql .= 'SET `display_name`=\''.$display_name.'\', ';
 
     | 
  
  
    | 
      116
     | 
    
      			if($sPwHashNew) {
     | 
  
  
    | 
      117
     | 
    
      				$sql .=     '`password`=\''.$sPwHashNew.'\', ';
 
     | 
  
  
    | 
      118
     | 
    
      			}
 
     | 
  
  
    | 
      119
     | 
    
      			if($email != '') {
     | 
  
  
    | 
      120
     | 
    
      				$sql .=     '`email`=\''.$email.'\', ';
 
     | 
  
  
    | 
      121
     | 
    
      			}
 
     | 
  
  
    | 
      122
     | 
    
      			$sql .=     '`language`=\''.$language.'\', ';
 
     | 
  
  
    | 
      123
     | 
    
      			$sql .=     '`timezone`=\''.$timezone.'\', ';
 
     | 
  
  
    | 
      124
     | 
    
      			$sql .=     '`date_format`=\''.$date_format.'\', ';
 
     | 
  
  
    | 
      125
     | 
    
      			$sql .=     '`time_format`=\''.$time_format.'\' ';
 
     | 
  
  
    | 
      126
     | 
    
      			$sql .= 'WHERE `user_id`='.(int)$admin->get_user_id();
 
     | 
  
  
    | 
      127
     | 
    
      			if( $database->query($sql) )
 
     | 
  
  
    | 
      128
     | 
    
      			{
     | 
  
  
    | 
      129
     | 
    
      				// update successfull, takeover values into the session
 
     | 
  
  
    | 
      130
     | 
    
      				$_SESSION['DISPLAY_NAME'] = $display_name;
 
     | 
  
  
    | 
      131
     | 
    
      				$_SESSION['LANGUAGE'] = $language;
 
     | 
  
  
    | 
      132
     | 
    
      				$_SESSION['TIMEZONE'] = $timezone;
 
     | 
  
  
    | 
      133
     | 
    
      				$_SESSION['EMAIL'] = $email;
 
     | 
  
  
    | 
      134
     | 
    
      				// Update date format
 
     | 
  
  
    | 
      135
     | 
    
      				if($date_format != '') {
     | 
  
  
    | 
      136
     | 
    
      					$_SESSION['DATE_FORMAT'] = $date_format;
 
     | 
  
  
    | 
      137
     | 
    
      					if(isset($_SESSION['USE_DEFAULT_DATE_FORMAT'])) { unset($_SESSION['USE_DEFAULT_DATE_FORMAT']); }
     | 
  
  
    | 
      138
     | 
    
      				} else {
     | 
  
  
    | 
      139
     | 
    
      					$_SESSION['USE_DEFAULT_DATE_FORMAT'] = true;
 
     | 
  
  
    | 
      140
     | 
    
      					if(isset($_SESSION['DATE_FORMAT'])) { unset($_SESSION['DATE_FORMAT']); }
     | 
  
  
    | 
      141
     | 
    
      				}
 
     | 
  
  
    | 
      142
     | 
    
      				// Update time format
 
     | 
  
  
    | 
      143
     | 
    
      				if($time_format != '') {
     | 
  
  
    | 
      144
     | 
    
      					$_SESSION['TIME_FORMAT'] = $time_format;
 
     | 
  
  
    | 
      145
     | 
    
      					if(isset($_SESSION['USE_DEFAULT_TIME_FORMAT'])) { unset($_SESSION['USE_DEFAULT_TIME_FORMAT']); }
     | 
  
  
    | 
      146
     | 
    
      				} else {
     | 
  
  
    | 
      147
     | 
    
      					$_SESSION['USE_DEFAULT_TIME_FORMAT'] = true;
 
     | 
  
  
    | 
      148
     | 
    
      					if(isset($_SESSION['TIME_FORMAT'])) { unset($_SESSION['TIME_FORMAT']); }
     | 
  
  
    | 
      149
     | 
    
      				}
 
     | 
  
  
    | 
      150
     | 
    
      			}else {
     | 
  
  
    | 
      151
     | 
    
      				$err_msg[] = 'invalid database UPDATE call in '.__FILE__.'::'.__FUNCTION__.'before line '.__LINE__;
 
     | 
  
  
    | 
      152
     | 
    
      			}
 
     | 
  
  
    | 
      153
     | 
    
      		}
 
     | 
  
  
    | 
      154
     | 
    
      	}
 
     | 
  
  
    | 
      155
     | 
    
      	return ( (sizeof($err_msg) > 0) ? implode('<br />', $err_msg) : '' );
     | 
  
  
    | 
      156
     | 
    
      }
 
     | 
  
  
    | 
      157
     | 
    
      $retval = save_preferences($admin, $database);
 
     | 
  
  
    | 
      158
     | 
    
      if( $retval == '')
 
     | 
  
  
    | 
      159
     | 
    
      {
     | 
  
  
    | 
      160
     | 
    
      	// print the header
 
     | 
  
  
    | 
      161
     | 
    
      	$admin->print_header();
 
     | 
  
  
    | 
      162
     | 
    
      	$admin->print_success($MESSAGE['PREFERENCES_DETAILS_SAVED']);
 
     | 
  
  
    | 
      163
     | 
    
      	$admin->print_footer();
 
     | 
  
  
    | 
      164
     | 
    
      }else {
     | 
  
  
    | 
      165
     | 
    
      	// print the header
 
     | 
  
  
    | 
      166
     | 
    
      	$admin->print_header();
 
     | 
  
  
    | 
      167
     | 
    
      	$admin->print_error($retval);
 
     | 
  
  
    | 
      168
     | 
    
      }
 
     |