//---------------------------------------------------------------------------------------------
//
// changing mail
//
} else if($submit == "changemail") {
$email = $pc->POSTisSetOrSetDefault('email');
$email = $mysqli->real_escape_string($email);
$query = <<< EOD
CALL {$spUpdateEmail}('{$userId}', '{$email}', @pRowsAffected);
SELECT @pRowsAffected AS rowsAffected;
EOD;
$res = $db->performDirectMultiQuery($query);
$db->getAndStoreResults($result);
$row = $result[1]->fetch_object();
if($row->rowsAffected == 1) {
$mail = new CMail();
$to = $email;
$from = "*****@*****.**";
$subject = "Ny mailadress registrerad";
$message = <<< EOD
Välkommen,
Din nya mailadress är registrerad.
MVH
Dolphin
