"Fossies" - the Fresh Open Source Software Archive

Member "sqlgreywebinterface-1.1.8/includes/awl.inc.php" (10 Aug 2015, 2450 Bytes) of package /linux/privat/old/sqlgreywebinterface-1.1.8.tgz:

As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PHP source code syntax highlighting (style: standard) with prefixed line numbers and code folding option. Alternatively you can here view or download the uninterpreted source code file. See also the latest Fossies "Diffs" side-by-side code changes report for "awl.inc.php": 1.1.7_vs_1.1.8.

    1 <?php
    2 
    3 /***************************************************
    4 SQLgrey Web Interface
    5 Filename:   awl.inc.php
    6 Purpose:    Functions for awl.php (whitelists)
    7 Version:    1.1.8
    8 ****************************************************/
    9 
   10 function 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 
   33 function 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 
   52 function 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 ?>