source: extensions/Mail_supervisor/include/save_info.php @ 23170

<?php
//=======================================================================================
if (!defined('MAIL_SUPERV_PATH')) define('MAIL_SUPERV_PATH' , PHPWG_PLUGINS_PATH.basename(dirname(__FILE__)).'/');
switch (strtolower($info_ip))
 {
  case  'ajout' :
 $ip_black=str_replace("*","%",$ip_black);
 if (!($ip_black == '')) {
   $query = "
            SELECT `ip`
            FROM `".MAIL_BLACK_LISTE_TABLE."`
            WHERE  '".$ip_black."' LIKE ip
        ;";
    //==============================================================================
  list($count) = pwg_db_fetch_row(pwg_query($query));
  //==============================================================================
  $valeurs=array( 'NULL',
                    "'".$ip_black."'",
                             "'".$pays."'",
                             "'".$region."'",
                             "'".$ville."'",
                             '"adresse"',
                             '"fai" ',
                             $count + 1
            );
    ajout_ligne(MAIL_BLACK_LISTE_TABLE,$superv_bl_champs, $valeurs,($count==0)) ;
 }

 break;
 //================================================================================================
  case 'raz':
    $ip_black=str_replace('*',"%",$ip_black);
        $query = "DELETE FROM `".MAIL_BLACK_LISTE_TABLE."` WHERE `ip`  like '%".$ip_black."%' ";
             pwg_query($query);

    unset ($_SESSION['pwg_'.'action_spam']);
   break;

    default:
   break;

  }
//================ Liste Black liste =================
  $query = "
     SELECT *,  COUNT(`ip`) as total ,  `ip` as blacklist, `ip` as U_DELETE
     FROM ".MAIL_BLACK_LISTE_TABLE."
     GROUP by ip
     ;";
    $liste_bl = array();
 $result = pwg_query($query);
        while ($row = pwg_db_fetch_array($result,MYSQL_ASSOC))   {
                 array_push($liste_bl,$row);
                }
//================ Liste IP ==============
$req = pwg_query('SELECT count(distinct(`IP`)) FROM '.HISTORY_TABLE.'    ');
$op=pwg_db_fetch_row($req); 
$nbip =  array_pop($op) ;

    $query = 'SELECT DISTINCT   H.`id`,
            H.`date`,
            H.`time`,
            H.`user_id`,
            H.`IP`,
            COUNT(H.`IP`) as total
            FROM '.HISTORY_TABLE.'  AS H
            WHERE  "'.$ip.'"not LIKE H.`IP`     ';//
    if (count($liste_bl)>0){
    $query .= ' AND  H.`IP` not IN ( SELECT `ip`
    FROM '.MAIL_BLACK_LISTE_TABLE.' ) ';
    }

    $query .= '
    GROUP by H.`IP`
    ORDER by `id` DESC
    LIMIT '.(int)($params['per_page']*$params['start']).','.(int)$params['per_page'].'
    '   ;

    $result = pwg_query($query);
    $liste_ip=array();
    while ($row = pwg_db_fetch_array($result,MYSQL_ASSOC))   {

              array_push($liste_ip, $row);
                }

?>