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="/">