root/extensions/Mail_supervisor/include/save_info.php @ 4939

<?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) = mysql_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);
   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 = mysql_fetch_array($result,MYSQL_ASSOC))
                        {
                         array_push($liste_bl,$row);
                                }
//================ Liste IP ==============              
$req = mysql_query('SELECT count(distinct(`IP`)) FROM '.HISTORY_TABLE.'    '); 
$nbip =  array_pop(mysql_fetch_row($req)) ;


             $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  "'.$_SERVER['REMOTE_ADDR'].'"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 = mysql_fetch_array($result,MYSQL_ASSOC))
                        {
                           array_push($liste_ip, $row);
                                }
                                

?>