<?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);
   				}
				

?>