[Sommaire] [Imprimer]

   1  <?php
   2  # Mantis - a php based bugtracking system
   3  
   4  # Copyright (C) 2000 - 2002  Kenzaburo Ito - kenito@300baud.org
   5  # Copyright (C) 2002 - 2007  Mantis Team   - mantisbt-dev@lists.sourceforge.net
   6  
   7  # Mantis is free software: you can redistribute it and/or modify
   8  # it under the terms of the GNU General Public License as published by
   9  # the Free Software Foundation, either version 2 of the License, or
  10  # (at your option) any later version.
  11  #
  12  # Mantis is distributed in the hope that it will be useful,
  13  # but WITHOUT ANY WARRANTY; without even the implied warranty of
  14  # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  15  # GNU General Public License for more details.
  16  #
  17  # You should have received a copy of the GNU General Public License
  18  # along with Mantis.  If not, see <http://www.gnu.org/licenses/>.
  19  
  20      # --------------------------------------------------------
  21      # $Id: manage_user_prune.php,v 1.11.2.1 2007-10-13 22:33:57 giallu Exp $
  22      # --------------------------------------------------------
  23  
  24      require_once ( 'core.php' );
  25  
  26      auth_reauthenticate();
  27  
  28      access_ensure_global_level( config_get( 'manage_user_threshold' ) );
  29  
  30      $t_user_table = config_get( 'mantis_user_table' );
  31  
  32      # Delete the users who have never logged in and are older than 1 week
  33      $days_old = 7;
  34      $days_old = (integer)$days_old;
  35  
  36      $date_calc = db_helper_compare_days( db_now(), "date_created", "> $days_old" );
  37  
  38      $query = "SELECT id
  39              FROM $t_user_table
  40              WHERE ( login_count = 0 ) AND ( date_created = last_visit ) AND $date_calc";
  41      $result = db_query($query);
  42  
  43      if ( !$result ) {
  44          trigger_error( ERROR_GENERIC, ERROR );
  45      }
  46      
  47      $count = db_num_rows( $result );
  48  
  49      if ( $count > 0 ) {
  50          helper_ensure_confirmed( lang_get( 'confirm_account_pruning' ),
  51                                   lang_get( 'prune_accounts_button' ) );
  52      }
  53  
  54      for ($i=0; $i < $count; $i++) {
  55          $row = db_fetch_array( $result );
  56          user_delete($row['id']);
  57      }
  58  
  59      $t_redirect_url = 'manage_user_page.php';
  60  
  61      print_header_redirect( $t_redirect_url );
  62      
  63  ?>