1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
<?php
/***************************************************
SQLgrey Web Interface
Filename: awl.inc.php
Purpose: Functions for awl.php (whitelists)
Version: 1.1.6
****************************************************/
function add_sender($mode, $sendername, $senderdomain, $src) {
global $added;
if ($mode == "email") {
if ($sendername == '' || $senderdomain == '' || $src == '') {
$added = "<br />WARNING: Insufficient data - nothing was added !";
} else {
$query = "INSERT INTO from_awl(sender_name, sender_domain, src, first_seen, last_seen)
VALUES('".addslashes($sendername)."', '".addslashes($senderdomain)."', '".addslashes($src)."', now(), now())";
$added = "<br />E-mail address ".$sendername."@".$senderdomain." (".$src.") added.";
do_query($query);
}
} else {
if ($senderdomain == '' || $src == '') {
$added = "<br />WARNING: Insufficient data - nothing was added!";
} else {
$query = "INSERT INTO domain_awl(sender_domain, src, first_seen, last_seen)
VALUES('".addslashes($senderdomain)."', '".addslashes($src)."', now(), now())";
$added = "<br />Domain ".$senderdomain." (".$src.") added.";
do_query($query);
}
}
}
function delete_undef($mode) {
global $message;
if ($mode == "email") {
$query_cnt = "SELECT COUNT(*) AS count FROM from_awl WHERE sender_name='-undef-' AND sender_domain='-undef-'";
$query = "DELETE FROM from_awl WHERE sender_name='-undef-' AND sender_domain='-undef-'";
} else {
$query_cnt = "SELECT COUNT(*) AS count FROM domain_awl WHERE sender_domain='-undef-'";
$query = "DELETE FROM domain_awl WHERE sender_domain='-undef-'";
}
$result = do_query($query_cnt);
$n = fetch_row($result);
if ($n["count"] > 0) {
do_query($query);
$message = '<br />-undef- entries ('.$n["count"].') deleted.';
} else {
$message = "<br />No -undef- entries found - nothing was deleted.";
}
}
function delete_entry($mode, $sendername, $senderdomain, $src) {
global $deleted;
if ($mode == "email") {
$query = "DELETE FROM from_awl WHERE sender_name='".addslashes($sendername)."' AND sender_domain='".addslashes($senderdomain)."' AND src='".addslashes($src)."'";
$deleted .= "<br />".$sendername."@".$senderdomain." (".$src.") deleted.";
} else {
$query = "DELETE FROM domain_awl WHERE sender_domain='".addslashes($senderdomain)."' AND src='".addslashes($src)."'";
$deleted .= "<br />".$senderdomain." (".$src.") deleted.";
}
do_query($query);
}
?>
|
