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

<?php


//=======================================================================================


if (!defined('MAIL_SUPERV_PATH')) define('MAIL_SUPERV_PATH' , PHPWG_PLUGINS_PATH.basename(dirname(__FILE__)).'/');


   


switch (strtolower($info_ip))
 {

  case  'ajout' :
 

 if (!($ip_black == '')) {
   $query = "
                SELECT `ip` 
                FROM `".MAIL_BLACK_LISTE_TABLE."` 
                    WHERE ip = '".$ip_black."'
                ;";     
//==============================================================================                
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 ==============                      
             $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 H.`IP` not LIKE "'.$_SERVER['REMOTE_ADDR'].'"
        ';//
        if (count($liste_bl)>0)
         {
        $query .= '
        AND  H.`IP` not IN (     SELECT `ip`
    FROM '.MAIL_BLACK_LISTE_TABLE.' ) ';
        }
        
        $query .= '
        
        GROUP by H.`IP` ;
        
        ;'  ;//
        $result = pwg_query($query);
        $liste_ip=array();
        while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
                        {
                           array_push($liste_ip, $row);
                                }
                                

?>