WB 2.08.x

<?php

/**

 *

 * @category        frontend

 * @package         account

 * @license         http://www.gnu.org/licenses/gpl.html

 * @platform        WebsiteBaker 2.8.x

 * @filesource		$HeadURL$

 *

 */

if(!defined('WB_URL')) {

	header('Location: ../index.php');

	exit(0);

}

// Get the values entered

$current_password = $wb->get_post('current_password');

$email = $wb->get_post('email');

// Create a javascript back link

$js_back = "javascript: history.go(-1);";

// Get existing password

$database = new database();

$query = "SELECT user_id FROM ".TABLE_PREFIX."users WHERE user_id = '".$wb->get_user_id()."' AND password = '".md5($current_password)."'";

$results = $database->query($query);

// Validate values

if($results->numRows() == 0) {

	$wb->print_error($MESSAGE['PREFERENCES']['CURRENT_PASSWORD_INCORRECT'], $js_back, false);

}

// Validate values

if(!$wb->validate_email($email)) {

	$wb->print_error($MESSAGE['USERS']['INVALID_EMAIL'], $js_back, false);

}

$email = $wb->add_slashes($email);

// Update the database

$database = new database();

$query = "UPDATE ".TABLE_PREFIX."users SET email = '$email' WHERE user_id = '".$wb->get_user_id()."' AND password = '".md5($current_password)."'";

$database->query($query);

if($database->is_error()) {

	$wb->print_error($database->get_error,'index.php', false);

} else {

	$wb->print_success($MESSAGE['PREFERENCES']['EMAIL_UPDATED'], WB_URL.'/account/preferences.php');

	$_SESSION['EMAIL'] = $email;

}