[Sommaire] [Imprimer]

   1  <?php
   2  /*****************************************************
   3  * This file is part of Agora, web based content management system.
   4  *
   5  * Agora is free software; you can redistribute it and/or modify
   6  * it under the terms of the GNU General Public License as published by
   7  * the Free Software Foundation; version 2 of the License.
   8  *
   9  * Agora is distributed in the hope that it will be useful,
  10  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  * GNU General Public License for more details (file "COPYING").
  13  *
  14  * Copyright © Arnaud Martin, Antoine Pitrou et Philippe Rivière.
  15  * List of authors detailed in "copyright_fr.html" file.
  16  * E-mail : agora@sig.premier-ministre.gouv.fr
  17  * Web site : http://www.agora.gouv.fr
  18  *****************************************************/
  19  require_once  'include/settings.php';
  20  
  21  if (isset($_GET['pst_id']) && $db->getOne(
  22                                    "SELECT COUNT(*) FROM " . CM_TABLE_PREFIX . "_posts WHERE pst_id = " . $_GET['pst_id']. " AND pst_date_sent = 0") == 1)
  23      {
  24      $lst_id = $db->getOne("SELECT lst_id FROM " . CM_TABLE_PREFIX . "_posts WHERE pst_id = " . $_GET['pst_id']);
  25      $subscribers = $db->query("SELECT sub_id FROM " . CM_TABLE_PREFIX . "_lists_subscribers WHERE lst_id = " . $lst_id);
  26  
  27      while ($sub = $subscribers->fetchRow()) {
  28          $db->query(
  29              "INSERT INTO " . CM_TABLE_PREFIX . "_posts_queued (pst_id, sub_id, psq_date) VALUES (" . $_GET['pst_id']. ", " . $sub['sub_id']. ", " . time(). ")");
  30      }
  31      $db->query(
  32          "UPDATE " . CM_TABLE_PREFIX . "_posts SET pst_date_sent = " . time(). " WHERE pst_id = " . $_GET['pst_id']);
  33  }
  34  
  35  header ('Location: posts.php?lst_id=' . $lst_id);
  36  exit;
  37  ?>