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