[Sommaire] [Imprimer]

   1  <?php
   2  /**

   3   * Header code file for the Account Newsletters page - To change customers Newsletter options

   4   *

   5   * @package page

   6   * @copyright Copyright 2003-2006 Zen Cart Development Team

   7   * @copyright Portions Copyright 2003 osCommerce

   8   * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0

   9   * @version $Id: header_php.php 3162 2006-03-11 01:39:16Z drbyte $

  10   */
  11  if (!$_SESSION['customer_id']) {
  12    $_SESSION['navigation']->set_snapshot();
  13    zen_redirect(zen_href_link(FILENAME_LOGIN, '', 'SSL'));
  14  }
  15  
  16  require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
  17  
  18  $newsletter_query = "SELECT customers_newsletter
  19                       FROM   " . TABLE_CUSTOMERS . "
  20                       WHERE  customers_id = :customersID";
  21  
  22  $newsletter_query = $db->bindVars($newsletter_query, ':customersID',$_SESSION['customer_id'], 'integer');
  23  $newsletter = $db->Execute($newsletter_query);
  24  
  25  if (isset($_POST['action']) && ($_POST['action'] == 'process')) {
  26    if (isset($_POST['newsletter_general']) && is_numeric($_POST['newsletter_general'])) {
  27      $newsletter_general = zen_db_prepare_input($_POST['newsletter_general']);
  28    } else {
  29      $newsletter_general = '0';
  30    }
  31  
  32    if ($newsletter_general != $newsletter->fields['customers_newsletter']) {
  33      $newsletter_general = (($newsletter->fields['customers_newsletter'] == '1') ? '0' : '1');
  34  
  35      $sql = "UPDATE " . TABLE_CUSTOMERS . "
  36              SET    customers_newsletter = :customersNewsletter
  37              WHERE  customers_id = :customersID";
  38  
  39      $sql = $db->bindVars($sql, ':customersID',$_SESSION['customer_id'], 'integer');
  40      $sql = $db->bindVars($sql, ':customersNewsletter',$newsletter_general, 'integer');
  41      $db->Execute($sql);
  42    }
  43  
  44    $messageStack->add_session('account', SUCCESS_NEWSLETTER_UPDATED, 'success');
  45  
  46    zen_redirect(zen_href_link(FILENAME_ACCOUNT, '', 'SSL'));
  47  }
  48  
  49  $breadcrumb->add(NAVBAR_TITLE_1, zen_href_link(FILENAME_ACCOUNT, '', 'SSL'));
  50  $breadcrumb->add(NAVBAR_TITLE_2);
  51  ?>