<?php
/**
 *
 * @category        admin
 * @package         preferences
 * @author          WebsiteBaker Project
 * @copyright       2009-2012, Website Baker Org. e.V.
 * @link			http://www.websitebaker2.org/
 * @license         http://www.gnu.org/licenses/gpl.html
 * @platform        WebsiteBaker 2.8.x
 * @requirements    PHP 5.2.2 and higher
 * @version         $Id: save.php 1782 2012-10-11 12:29:11Z Luisehahne $
 * @filesource		$HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/admin/preferences/save.php $
 * @lastmodified    $Date: 2012-10-11 14:29:11 +0200 (Thu, 11 Oct 2012) $
 *
 */


// Print admin header
require('../../config.php');
require_once(WB_PATH.'/framework/class.admin.php');
// suppress to print the header, so no new FTAN will be set
$admin = new admin('Preferences','start', false);

function save_preferences( &$admin, &$database)
{
	global $MESSAGE;
	$err_msg = array();
	$iMinPassLength = 6;
// first check form-tan
	if(!$admin->checkFTAN()){ $err_msg[] = $MESSAGE['GENERIC_SECURITY_ACCESS']; }
// Get entered values and validate all
	// remove any dangerouse chars from display_name
	$display_name     = $admin->add_slashes(strip_tags(trim($admin->get_post('display_name'))));
	$display_name     = ( $display_name == '' ? $admin->get_display_name() : $display_name );
	// check that display_name is unique in whoole system (prevents from User-faking)
	$sql  = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'users` ';
	$sql .= 'WHERE `user_id` <> '.(int)$admin->get_user_id().' AND `display_name` LIKE "'.$display_name.'"';
	if( $database->get_one($sql) > 0 ){ $err_msg[] = $MESSAGE['USERS_USERNAME_TAKEN']; }
// language must be 2 upercase letters only
	$language         = strtoupper($admin->get_post('language'));
	$language         = (preg_match('/^[A-Z]{2}$/', $language) ? $language : DEFAULT_LANGUAGE);
// timezone must be between -12 and +13  or -20 as system_default
	$timezone         = $admin->get_post('timezone');
	$timezone         = (is_numeric($timezone) ? $timezone : -20);
	$timezone         = ( ($timezone >= -12 && $timezone <= 13) ? $timezone : -20 ) * 3600;
// date_format must be a key from /interface/date_formats
	$date_format      = $admin->get_post('date_format');
	$date_format_key  = str_replace(' ', '|', $date_format);
	$user_time = true;
	include( ADMIN_PATH.'/interface/date_formats.php' );
	$date_format = (array_key_exists($date_format_key, $DATE_FORMATS) ? $date_format : 'system_default');
	$date_format = ($date_format == 'system_default' ? '' : $date_format);
	unset($DATE_FORMATS);
// time_format must be a key from /interface/time_formats
	$time_format      = $admin->get_post('time_format');
	$time_format_key  = str_replace(' ', '|', $time_format);
	$user_time = true;
	include( ADMIN_PATH.'/interface/time_formats.php' );
	$time_format = (array_key_exists($time_format_key, $TIME_FORMATS) ? $time_format : 'system_default');
	$time_format = ($time_format == 'system_default' ? '' : $time_format);
	unset($TIME_FORMATS);
// email should be validatet by core
	$email = trim( $admin->get_post('email') == null ? '' : $admin->get_post('email') );
	if( !$admin->validate_email($email) )
	{
		$email = '';
		$err_msg[] = $MESSAGE['USERS_INVALID_EMAIL'];
	}else {
		if($email != '') {
		// check that email is unique in whoole system
			$email = $admin->add_slashes($email);
			$sql  = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'users` ';
			$sql .= 'WHERE `user_id` <> '.(int)$admin->get_user_id().' AND `email` LIKE "'.$email.'"';
			if( $database->get_one($sql) > 0 ){ $err_msg[] = $MESSAGE['USERS_EMAIL_TAKEN']; }
		}
	}
// receive password vars and calculate needed action
	$sCurrentPassword = $admin->get_post('current_password');
	$sCurrentPassword = (is_null($sCurrentPassword) ? '' : $sCurrentPassword);
	$sNewPassword = $admin->get_post('new_password_1');
	$sNewPassword = (is_null($sNewPassword) ? '' : $sNewPassword);
	$sNewPasswordRetyped = $admin->get_post('new_password_2');
	$sNewPasswordRetyped= (is_null($sNewPasswordRetyped) ? '' : $sNewPasswordRetyped);
// Check existing password
	$sql  = 'SELECT `password` ';
	$sql .= 'FROM `'.TABLE_PREFIX.'users` ';
	$sql .= 'WHERE `user_id` = '.$admin->get_user_id();
	if (md5($sCurrentPassword) != $database->get_one($sql)) {
// access denied
		$err_msg[] = $MESSAGE['PREFERENCES_CURRENT_PASSWORD_INCORRECT'];
	}else {
// validate new password
		$sPwHashNew = false;
		if($sNewPassword != '') {
			if(strlen($sNewPassword) < $iMinPassLength) {
				$err_msg[] = $MESSAGE['USERS_PASSWORD_TOO_SHORT'];
			}else {
				if($sNewPassword != $sNewPasswordRetyped) {
					$err_msg[] = $MESSAGE['USERS_PASSWORD_MISMATCH'];
				}else {
					$pattern = '/[^'.$admin->password_chars.']/';
					if (preg_match($pattern, $sNewPassword)) {
						$err_msg[] = $MESSAGE['PREFERENCES_INVALID_CHARS'];
					}else {
						$sPwHashNew = md5($sNewPassword);
					}
				}
			}
		}
// if no validation errors, try to update the database, otherwise return errormessages
		if(sizeof($err_msg) == 0)
		{
			$sql  = 'UPDATE `'.TABLE_PREFIX.'users` ';
			$sql .= 'SET `display_name`=\''.$display_name.'\', ';
			if($sPwHashNew) {
				$sql .=     '`password`=\''.$sPwHashNew.'\', ';
			}
			if($email != '') {
				$sql .=     '`email`=\''.$email.'\', ';
			}
			$sql .=     '`language`=\''.$language.'\', ';
			$sql .=     '`timezone`=\''.$timezone.'\', ';
			$sql .=     '`date_format`=\''.$date_format.'\', ';
			$sql .=     '`time_format`=\''.$time_format.'\' ';
			$sql .= 'WHERE `user_id`='.(int)$admin->get_user_id();
			if( $database->query($sql) )
			{
				// update successfull, takeover values into the session
				$_SESSION['DISPLAY_NAME'] = $display_name;
				$_SESSION['LANGUAGE'] = $language;
				$_SESSION['TIMEZONE'] = $timezone;
				$_SESSION['EMAIL'] = $email;
				// Update date format
				if($date_format != '') {
					$_SESSION['DATE_FORMAT'] = $date_format;
					if(isset($_SESSION['USE_DEFAULT_DATE_FORMAT'])) { unset($_SESSION['USE_DEFAULT_DATE_FORMAT']); }
				} else {
					$_SESSION['USE_DEFAULT_DATE_FORMAT'] = true;
					if(isset($_SESSION['DATE_FORMAT'])) { unset($_SESSION['DATE_FORMAT']); }
				}
				// Update time format
				if($time_format != '') {
					$_SESSION['TIME_FORMAT'] = $time_format;
					if(isset($_SESSION['USE_DEFAULT_TIME_FORMAT'])) { unset($_SESSION['USE_DEFAULT_TIME_FORMAT']); }
				} else {
					$_SESSION['USE_DEFAULT_TIME_FORMAT'] = true;
					if(isset($_SESSION['TIME_FORMAT'])) { unset($_SESSION['TIME_FORMAT']); }
				}
			}else {
				$err_msg[] = 'invalid database UPDATE call in '.__FILE__.'::'.__FUNCTION__.'before line '.__LINE__;
			}
		}
	}
	return ( (sizeof($err_msg) > 0) ? implode('<br />', $err_msg) : '' );
}
$retval = save_preferences($admin, $database);
if( $retval == '')
{
	// print the header
	$admin->print_header();
	$admin->print_success($MESSAGE['PREFERENCES_DETAILS_SAVED']);
	$admin->print_footer();
}else {
	// print the header
	$admin->print_header();
	$admin->print_error($retval);
}