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