WB 2.08.x

<?php

// $Id$

/*

 Website Baker Project <http://www.websitebaker.org/>

 Copyright (C) 2004-2009, Ryan Djurovich

 Website Baker is free software; you can redistribute it and/or modify

 it under the terms of the GNU General Public License as published by

 the Free Software Foundation; either version 2 of the License, or

 (at your option) any later version.

 Website Baker is distributed in the hope that it will be useful,

 but WITHOUT ANY WARRANTY; without even the implied warranty of

 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 GNU General Public License for more details.

 You should have received a copy of the GNU General Public License

 along with Website Baker; if not, write to the Free Software

 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

*/

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;

}