1 | <?php |
---|
2 | //======================================================================================= |
---|
3 | if (!defined('MAIL_SUPERV_PATH')) define('MAIL_SUPERV_PATH' , PHPWG_PLUGINS_PATH.basename(dirname(__FILE__)).'/'); |
---|
4 | |
---|
5 | switch (strtolower($info_ip)) |
---|
6 | { |
---|
7 | case 'ajout' : |
---|
8 | |
---|
9 | $ip_black=str_replace("*","%",$ip_black); |
---|
10 | |
---|
11 | |
---|
12 | if (!($ip_black == '')) { |
---|
13 | $query = " |
---|
14 | SELECT `ip` |
---|
15 | FROM `".MAIL_BLACK_LISTE_TABLE."` |
---|
16 | WHERE '".$ip_black."' LIKE ip |
---|
17 | ;"; |
---|
18 | //============================================================================== |
---|
19 | list($count) = mysql_fetch_row(pwg_query($query)); |
---|
20 | //============================================================================== |
---|
21 | $valeurs=array( 'NULL', |
---|
22 | "'".$ip_black."'", |
---|
23 | "'".$pays."'", |
---|
24 | "'".$region."'", |
---|
25 | "'".$ville."'", |
---|
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); |
---|
37 | $query = "DELETE FROM `".MAIL_BLACK_LISTE_TABLE."` WHERE `ip` like '%".$ip_black."%' "; |
---|
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 | } |
---|
60 | //================ Liste IP ============== |
---|
61 | $req = mysql_query('SELECT count(distinct(`IP`)) FROM '.HISTORY_TABLE.' '); |
---|
62 | $nbip = array_pop(mysql_fetch_row($req)) ; |
---|
63 | |
---|
64 | |
---|
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 |
---|
73 | WHERE "'.$_SERVER['REMOTE_ADDR'].'"not LIKE H.`IP` |
---|
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 | |
---|
82 | $query .= ' |
---|
83 | GROUP by H.`IP` |
---|
84 | ORDER by `id` DESC |
---|
85 | LIMIT '.(int)($params['per_page']*$params['start']).','.(int)$params['per_page'].' |
---|
86 | |
---|
87 | ' ; |
---|
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 | ?> |
---|