[4132] | 1 | <?php |
---|
| 2 | //======================================================================================= |
---|
| 3 | if (!defined('MAIL_SUPERV_PATH')) define('MAIL_SUPERV_PATH' , PHPWG_PLUGINS_PATH.basename(dirname(__FILE__)).'/'); |
---|
[4220] | 4 | switch (strtolower($info_ip)) |
---|
[4132] | 5 | { |
---|
[10419] | 6 | case 'ajout' : |
---|
[4229] | 7 | $ip_black=str_replace("*","%",$ip_black); |
---|
[4132] | 8 | if (!($ip_black == '')) { |
---|
| 9 | $query = " |
---|
[10419] | 10 | SELECT `ip` |
---|
| 11 | FROM `".MAIL_BLACK_LISTE_TABLE."` |
---|
| 12 | WHERE '".$ip_black."' LIKE ip |
---|
| 13 | ;"; |
---|
| 14 | //============================================================================== |
---|
[9702] | 15 | list($count) = mysql_fetch_row(pwg_query($query)); |
---|
[10419] | 16 | //============================================================================== |
---|
[9702] | 17 | $valeurs=array( 'NULL', |
---|
[10419] | 18 | "'".$ip_black."'", |
---|
| 19 | "'".$pays."'", |
---|
| 20 | "'".$region."'", |
---|
| 21 | "'".$ville."'", |
---|
| 22 | '"adresse"', |
---|
| 23 | '"fai" ', |
---|
| 24 | $count + 1 |
---|
| 25 | ); |
---|
| 26 | ajout_ligne(MAIL_BLACK_LISTE_TABLE,$superv_bl_champs, $valeurs,($count==0)) ; |
---|
[4132] | 27 | } |
---|
[10419] | 28 | |
---|
[4132] | 29 | break; |
---|
| 30 | //================================================================================================ |
---|
| 31 | case 'raz': |
---|
[9702] | 32 | $ip_black=str_replace('*',"%",$ip_black); |
---|
[10419] | 33 | $query = "DELETE FROM `".MAIL_BLACK_LISTE_TABLE."` WHERE `ip` like '%".$ip_black."%' "; |
---|
| 34 | pwg_query($query); |
---|
| 35 | |
---|
[9702] | 36 | unset ($_SESSION['pwg_'.'action_spam']); |
---|
[4132] | 37 | break; |
---|
[10419] | 38 | |
---|
| 39 | default: |
---|
[4132] | 40 | break; |
---|
[10419] | 41 | |
---|
| 42 | } |
---|
[4132] | 43 | //================ Liste Black liste ================= |
---|
| 44 | $query = " |
---|
[10419] | 45 | SELECT *, COUNT(`ip`) as total , `ip` as blacklist, `ip` as U_DELETE |
---|
[9702] | 46 | FROM ".MAIL_BLACK_LISTE_TABLE." |
---|
[10419] | 47 | GROUP by ip |
---|
[9702] | 48 | ;"; |
---|
[10419] | 49 | $liste_bl = array(); |
---|
[9702] | 50 | $result = pwg_query($query); |
---|
[10419] | 51 | while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) { |
---|
| 52 | array_push($liste_bl,$row); |
---|
| 53 | } |
---|
| 54 | //================ Liste IP ============== |
---|
| 55 | $req = mysql_query('SELECT count(distinct(`IP`)) FROM '.HISTORY_TABLE.' '); |
---|
[13572] | 56 | $op=mysql_fetch_row($req); |
---|
| 57 | $nbip = array_pop($op) ; |
---|
[4938] | 58 | |
---|
[10419] | 59 | $query = 'SELECT DISTINCT H.`id`, |
---|
[9702] | 60 | H.`date`, |
---|
| 61 | H.`time`, |
---|
| 62 | H.`user_id`, |
---|
[10419] | 63 | H.`IP`, |
---|
| 64 | COUNT(H.`IP`) as total |
---|
| 65 | FROM '.HISTORY_TABLE.' AS H |
---|
| 66 | WHERE "'.$ip.'"not LIKE H.`IP` ';// |
---|
| 67 | if (count($liste_bl)>0){ |
---|
| 68 | $query .= ' AND H.`IP` not IN ( SELECT `ip` |
---|
[4132] | 69 | FROM '.MAIL_BLACK_LISTE_TABLE.' ) '; |
---|
[10419] | 70 | } |
---|
[9702] | 71 | |
---|
[10419] | 72 | $query .= ' |
---|
| 73 | GROUP by H.`IP` |
---|
| 74 | ORDER by `id` DESC |
---|
| 75 | LIMIT '.(int)($params['per_page']*$params['start']).','.(int)$params['per_page'].' |
---|
| 76 | ' ; |
---|
[9702] | 77 | |
---|
[10419] | 78 | $result = pwg_query($query); |
---|
| 79 | $liste_ip=array(); |
---|
| 80 | while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) { |
---|
[4132] | 81 | |
---|
[10419] | 82 | array_push($liste_ip, $row); |
---|
| 83 | } |
---|
| 84 | |
---|
[4132] | 85 | ?> |
---|