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