[Sommaire] [Imprimer]

   1  <?php
   2  /*
   3  + ----------------------------------------------------------------------------+
   4  |     e107 website system
   5  |
   6  |     ©Steve Dunstan 2001-2002
   7  |     http://e107.org
   8  |     jalist@e107.org
   9  |
  10  |     Released under the terms and conditions of the
  11  |     GNU General Public License (http://gnu.org).
  12  |
  13  |     $Source: /cvsroot/e107/e107_0.7/e107_plugins/newsletter/newsletter_menu.php,v $
  14  |     $Revision: 1.4 $
  15  |     $Date: 2006/01/15 01:47:41 $
  16  |     $Author: mcfly_e107 $
  17  +----------------------------------------------------------------------------+
  18  */
  19  
  20  if (!defined('e107_INIT')) { exit; }
  21  
  22  if(!USER || !$sql -> db_Select("newsletter", "*", "newsletter_parent='0' "))
  23  {
  24      // no newsletters defined yet //
  25      return FALSE;
  26  }
  27  
  28  $newsletterArray = $sql -> db_getList();
  29  $requery = false;
  30  
  31  foreach($_POST as $key => $value)
  32  {
  33      if(strstr($key, "nlUnsubscribe_"))
  34      {
  35          $subid = str_replace("nlUnsubscribe_", "", $key);
  36          $newsletterArray[$subid]['newsletter_subscribers'] = str_replace(chr(1).USERID, "", $newsletterArray[$subid]['newsletter_subscribers']);
  37          $sql -> db_Update("newsletter", "newsletter_subscribers='".$newsletterArray[$subid]['newsletter_subscribers']."' WHERE newsletter_id='".intval($subid)."' ");
  38          $requery = true;
  39      }
  40      else if(strstr($key, "nlSubscribe_"))
  41      {
  42          $subid = str_replace("nlSubscribe_", "", $key);
  43          $newsletterArray[$subid]['newsletter_subscribers'] .= chr(1).USERID;
  44          $sql -> db_Update("newsletter", "newsletter_subscribers='".$newsletterArray[$subid]['newsletter_subscribers']."' WHERE newsletter_id='".intval($subid)."' ");
  45          $requery = true;
  46      }
  47  }
  48  
  49  global $tp;
  50  
  51  if($requery)
  52  {
  53      if($sql -> db_Select("newsletter", "*", "newsletter_parent='0' "))
  54      {
  55          $newsletterArray = $sql -> db_getList();
  56      }
  57  }    
  58  
  59  $text = "";
  60  foreach($newsletterArray as $nl)
  61  {
  62      $text .= "<div style='text-align: center; margin-left: auto; margin-right: auto;'>
  63      <form method='post' action='".e_SELF."'>
  64      <b>".
  65      $tp -> toHTML($nl['newsletter_title'], TRUE)."</b><br />
  66      <span class='smalltext'>".
  67      $tp -> toHTML($nl['newsletter_text'], TRUE)."</span><br /><br />
  68      ";
  69  
  70      if(preg_match("#".chr(1).USERID."(".chr(1)."|$)#si", $nl['newsletter_subscribers']))
  71      {
  72          $text .= NLLAN_48."<br /><br />
  73          <input class='button' type='submit' name='nlUnsubscribe_".$nl['newsletter_id']."' value='".NLLAN_51."' onclick=\"return jsconfirm('".$tp->toJS(NLLAN_49)."') \" />
  74          ";
  75      }
  76      else
  77      {
  78          $text .= NLLAN_50." <b>".USEREMAIL."</b> ) ...<br /><br />
  79          <input class='button' type='submit' name='nlSubscribe_".$nl['newsletter_id']."' value='".NLLAN_52."' onclick=\"return jsconfirm('".$tp->toJS(NLLAN_53)."') \" />
  80          ";
  81      }
  82      $text .= "</form>
  83      </div>
  84      <br />
  85      ";
  86  }
  87  
  88  $ns -> tablerender(NLLAN_MENU_CAPTION, $text);
  89  
  90      
  91  ?>