?php /** * Header code file for the Account Newsletters page - To change customers Newsletter options * * @package page * @copyright Copyright 2003-2006 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: header_php.php 3162 2006-03-11 01:39:16Z drbyte $ * modified for newsletter subscribe 20070120 sparrish, dmcl1, notgoddess */ if (!$_SESSION['customer_id']) { $_SESSION['navigation']->set_snapshot(); zen_redirect(zen_href_link(FILENAME_LOGIN, '', 'SSL')); } require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php')); $newsletter_query = "SELECT customers_newsletter FROM " . TABLE_CUSTOMERS . " WHERE customers_id = :customersID"; $newsletter_query = $db->bindVars($newsletter_query, ':customersID',$_SESSION['customer_id'], 'integer'); $newsletter = $db->Execute($newsletter_query); if (isset($_POST['action']) && ($_POST['action'] == 'process')) { if (isset($_POST['newsletter_general']) && is_numeric($_POST['newsletter_general'])) { $newsletter_general = zen_db_prepare_input($_POST['newsletter_general']); } else { $newsletter_general = '0'; } if ($newsletter_general != $newsletter->fields['customers_newsletter']) { $newsletter_general = (($newsletter->fields['customers_newsletter'] == '1') ? '0' : '1'); $sql = "UPDATE " . TABLE_CUSTOMERS . " SET customers_newsletter = :customersNewsletter WHERE customers_id = :customersID"; $sql = $db->bindVars($sql, ':customersID',$_SESSION['customer_id'], 'integer'); $sql = $db->bindVars($sql, ':customersNewsletter',$newsletter_general, 'integer'); $db->Execute($sql); // BEGIN newsletter_subscribe mod 1/1 if(defined('NEWSONLY_SUBSCRIPTION_ENABLED') && (NEWSONLY_SUBSCRIPTION_ENABLED=='true')) { if ($newsletter_general == '0') { $sql = "DELETE FROM " . TABLE_SUBSCRIBERS . " WHERE customers_id = :customersID"; $sql = $db->bindVars($sql, ':customersID',$_SESSION['customer_id'], 'integer'); $db->Execute($sql); } elseif ($newsletter_general == '1') { $updates = $db->Execute("SELECT customers_email_address, customers_email_format FROM " . TABLE_CUSTOMERS . " WHERE customers_id = '" . (int)$_SESSION['customer_id'] . "' "); $sql = "INSERT INTO " . TABLE_SUBSCRIBERS . " (customers_id, email_address, email_format) VALUES ('" . (int)$_SESSION['customer_id'] . "', '" . $updates->fields['customers_email_address'] . "', '" . $updates->fields['customers_email_format'] . "')"; $db->Execute($sql); } } // END newsletter_subscribe mod 1/1 } $messageStack->add_session('account', SUCCESS_NEWSLETTER_UPDATED, 'success'); zen_redirect(zen_href_link(FILENAME_ACCOUNT, '', 'SSL')); } $breadcrumb->add(NAVBAR_TITLE_1, zen_href_link(FILENAME_ACCOUNT, '', 'SSL')); $breadcrumb->add(NAVBAR_TITLE_2); ?> HEADING_TITLE : Galleristockholm.se, din Internetbutik
  Svenska  English  


 
 

HEADING_TITLE

MY_NEWSLETTERS_GENERAL_NEWSLETTER
Tillbaka