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