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?>