require_once 'database.class.php';
require_once 'lang/lang.inc.php';
$message = $l['Nothing_to_display_here__'];
switch ($_GET['action']) {
// user wants to unsubscribe
case 'unsubscribe':
switch ($_GET['medium']) {
// unsubscribe from the newsletter
case 'newsletter':
$id = $_GET['id'];
$hash = $_GET['hash'];
global $con;
$sql = "\n UPDATE `user_settings`, `user` \n SET `user_settings`.`newsletter_enabled` = 0 \n WHERE `user`.`id` = `user_settings`.`user` AND `user_settings`.`user` = " . $id . " AND\n `user`.`hash` LIKE BINARY '" . $hash . "';";
$query = mysqli_query($con, $sql);
// update the newsletter_enabled field to 0 (unsubscribe)
$message = $l['Successfully_unsubscribed_the_email_from_newsletter__'] . Database::id2email($id);
break;
}
break;
}
?>
<!DOCTYPE html>
<html>
<? require('html-include/head.php'); ?>
<body>
<!-- navigation -->
<nav id="head-nav" class="navbar">
<div class="navbar-inner content-width">
<a href="/">
