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

<?php


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


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



//include_once( PHPWG_ROOT_PATH.'include/common.inc.php' );
include_once (MAIL_SUPERV_PATH.'include/constants.php'); 
include_once (MAIL_SUPERV_PATH.'include/fonctions.php'); 

  $info_ip = (isset($info_ip)) ? $info_ip : '' ;
  $info_ip = (isset($_POST['info1'])) ? $_POST['info1'] : $info_ip ;
    $info_ip = (isset($_POST['info'])) ? $_POST['info'] : $info_ip ;
$info_ip .= ":";
 
 $val=explode(":",$info_ip);
 $info_ip = trim($val[0]) ;
 $ip_black = trim($val[1]) ;
 
 if (isset($_POST['ip_black']))
 $ip_black = ($ip_black == "" ) ? $_POST['ip_black'] : $ip_black ;
global $n ;


 
switch ($info_ip)
 {

  case 'ajout':
  $n +=1;
//echo " |$n] ". (( isset($_POST['info']) ) ? " POST  :".$_POST['info'] : "" ).(( isset($_POST['info1']) ) ? " POST   1 :".$_POST['info1'] : "" )."|";    
 
 if (!($ip_black == '')) {
    create_table(MAIL_BLACK_LISTE_TABLE,$superv_bl_champs,$superv_bl_type) ;
        ajust_table(MAIL_BLACK_LISTE_TABLE,$superv_bl_champs,$superv_bl_type)  ;
   $query = "
                SELECT COUNT(`id`) as total 
                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 =================
  create_table(MAIL_BLACK_LISTE_TABLE,$superv_bl_champs,$superv_bl_type) ;

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






?>