[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  $subs = $db->query("SELECT sub_id, sub_email FROM " . CM_TABLE_PREFIX . "_subscribers WHERE sub_profile = ''");
  22  echo $subs->numRows();
  23  
  24  while ($sub = $subs->fetchRow()) {
  25      $db->query("UPDATE " . CM_TABLE_PREFIX . "_subscribers SET sub_profile = '" . md5(
  26                                                                                        $sub['sub_id']. '#' . $$sub['sub_email']. '#' . time()). "' WHERE sub_id = " . $sub['sub_id']);
  27  }
  28  ?>