diff options
| author | Tristan Zur <tzur@web.web.ccwn.org> | 2014-03-27 22:27:47 +0100 |
|---|---|---|
| committer | Tristan Zur <tzur@web.web.ccwn.org> | 2014-03-27 22:27:47 +0100 |
| commit | b62676ca5d3d6f6ba3f019ea3f99722e165a98d8 (patch) | |
| tree | 86722cb80f07d4569f90088eeaea2fc2f6e2ef94 /sqlgrey/awl.php | |
Diffstat (limited to 'sqlgrey/awl.php')
| -rw-r--r-- | sqlgrey/awl.php | 251 |
1 files changed, 251 insertions, 0 deletions
diff --git a/sqlgrey/awl.php b/sqlgrey/awl.php new file mode 100644 index 0000000..ef6290c --- /dev/null +++ b/sqlgrey/awl.php @@ -0,0 +1,251 @@ +<?php + +/******************************************** +SQLgrey Web Interface +Filename: awl.php +Purpose: Renders the greylist page +Version: 1.1.6 +*********************************************/ + + require "includes/functions.inc.php"; + require "includes/awl.inc.php"; + + (isset($_GET["mode"])) ? $mode = $_GET["mode"] : $mode = "email"; + (isset($_GET["action"])) ? $action = $_GET["action"] : $action = ""; + + // For sort order. + (isset($_GET["csort"])) ? $csort = $_GET["csort"] : $csort = ""; + (isset($_GET["sort"])) ? $sort = $_GET["sort"] : $sort = ""; + if ($sort==null || $sort=="") { + if ($mode == "email") { + $sort = "sender_name"; + } else { + $sort = "sender_domain"; + } + } + $dir = "asc"; + $ndir = "desc"; + if ($sort == $csort && $_GET["order"] == "desc") { + $dir = "desc"; + $ndir = "asc"; + } + + // Perform demanded action. + $clearit = '<br /><br /><a class="navlike" href="awl.php?mode='.$mode.'">Clear this report</a>'; + switch ($action) { + case "del_selection": + // For batch deleting. + (isset($_POST["chk"])) ? $chk = $_POST["chk"] : $chk = ""; + if ($chk == "") { + $report = '<br />Nothing was selected - nothing has been deleted.'.$clearit; + } else { + foreach ($chk as $args) { + $parts = explode("@@", $args); + delete_entry($mode, $parts[0], $parts[1], $parts[2]); + } + $report = $deleted.$clearit; + } + $report2 = ""; + break; + case "del_undef": + delete_undef($mode); + $report = ""; + $report2 = $message; + break; + case "add_sender": + (isset($_POST["sender_name"])) ? $sn = $_POST["sender_name"] : $sn = ""; + add_sender($mode, $sn, $_POST["sender_domain"], $_POST["src"]); + $report = ""; + $report2 = $added; + break; + case "": + $report = ""; + $report2 = ""; + break; + } + + // Make a nice header. + if ($mode=="email") { + $query = "SELECT COUNT(*) AS count FROM from_awl"; + $title = "e-mail addresses ("; + } else { + $query = "SELECT COUNT(*) AS count FROM domain_awl"; + $title = "domains ("; + } + $result = do_query($query); + $n = fetch_row($result); + $title .= $n["count"].")"; + + /* + mysql> describe from_awl; + +---------------+---------------+------+-----+----------------+-------+ + | Field | Type | Null | Key | Default | Extra | + +---------------+---------------+------+-----+----------------+-------+ + | sender_name | varchar(64) | | PRI | | | + | sender_domain | varchar(255) | | PRI | | | + | src | varchar(39) | | PRI | | | + | first_seen | timestamp(14) | YES | | NULL | | + | last_seen | timestamp(14) | YES | MUL | 00000000000000 | | + +---------------+---------------+------+-----+----------------+-------+ + + mysql> describe domain_awl; + +---------------+---------------+------+-----+----------------+-------+ + | Field | Type | Null | Key | Default | Extra | + +---------------+---------------+------+-----+----------------+-------+ + | sender_domain | varchar(255) | | PRI | | | + | src | varchar(39) | | PRI | | | + | first_seen | timestamp(14) | YES | | NULL | | + | last_seen | timestamp(14) | YES | MUL | 00000000000000 | | + +---------------+---------------+------+-----+----------------+-------+ + */ +?> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" + "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> + +<head> + <title>Whitelisted <?php if ($mode=="email") echo "e-mail addresses"; else echo "domains"; ?></title> + <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> + <link rel="stylesheet" href="main.css" type="text/css" charset="utf-8" /> +</head> + +<body> + +<div id="page"> + + <div class="navcontainer"> + <?php shownav('white', $mode, '', ''); ?> + </div> + + <table width="100%" summary="header"> + <tr> + <td> + <h1>Whitelisted <?php echo $title; ?></h1> + </td> + <td align="right"> + <a class="navlike" href="#end" title="End of List">EoL</a> + </td> + </tr> + </table> + + <table border="0" summary="sortbar"><?php echo (' + <tr> + <td width="20"> </td>'); + if ($mode=="email") echo (' + <td width="300"> <b><a href="awl.php?mode='.$mode.'&sort=sender_name&csort='.$sort.'&order='.$ndir.'">Sender name</a></b></td>'); + echo (' + <td width="240"><b><a href="awl.php?mode='.$mode.'&sort=sender_domain&csort='.$sort.'&order='.$ndir.'">Sender domain</a></b></td> + <td width="100"><b><a href="awl.php?mode='.$mode.'&sort=src&csort='.$sort.'&order='.$ndir.'">Source</a></b></td> + <td width="120"><b><a href="awl.php?mode='.$mode.'&sort=first_seen&csort='.$sort.'&order='.$ndir.'">First seen</a></b></td> + <td width="120"><b><a href="awl.php?mode='.$mode.'&sort=last_seen&csort='.$sort.'&order='.$ndir.'">Last seen</a></b></td> + </tr>'); + ?></table> + + <form method="post" action="awl.php?mode=<?php echo $mode; ?>&action=del_selection"> + <div id="table_awl"> + <table border="0" summary="data"> + <tr><td><a name="top"></a></td></tr> + <?php + if ($mode=="email") { + if ($sort == "sender_name") { + $order = "sender_name ".$dir.", sender_domain ".$dir; + } + else if ($sort == "sender_domain") { + $order = "sender_domain ".$dir.", sender_name ".$dir; + } else { + $order = $sort." ".$dir; + } + $query = "SELECT sender_name, sender_domain, src, first_seen, last_seen FROM from_awl ORDER BY ".$order; + } else { + $order = $sort." ".$dir; + $query = "SELECT sender_domain, src, first_seen, last_seen FROM domain_awl ORDER BY ".$order; + } + $result = do_query($query); + + while($line = fetch_row($result)) { + $sd = $line["sender_domain"]; + $src = $line["src"]; + $fs = $line["first_seen"]; + $ls = $line["last_seen"]; + if ($mode == "email") { + $sn = $line["sender_name"]; + echo (' + <tr> + <td width="20"><input type="checkbox" name="chk[]" value="'.$sn.'@@'.$sd.'@@'.$src.'" /></td> + <td width="300"><span title="'.$sn.'">'.shorten_it($sn, 42).'</span></td> + '); + } else { + $sn = "noname"; + echo (' + <tr> + <td width="20"><input type="checkbox" name="chk[]" value="'.$sn.'@@'.$sd.'@@'.$src.'" /></td> + '); + } + echo (' + <td width="240"><span title="'.$sd.'">'.shorten_it($sd, 35).'</span></td> + <td width="100">'.$src.'</td> + <td width="120">'.strip_millisecs($fs).'</td> + <td width="120">'.strip_millisecs($ls).'</td> + </tr> + '); + } + ?> + <tr><td><a name="end"></a></td></tr> + </table> + </div> + + <br /> + + <table width="100%" summary="buttons"> + <tr> + <td> + <input class="btn" type="submit" value="Delete selected entries" /> + </td> + <td align="right"> + <a class="navlike" href="#top" title="Top of List">ToL</a> + </td> + </tr> + </table> + </form> + + <?php if (! $report == '' ) echo '<span class="alert">'.$report.'</span>'; ?> + + <div id="form"> + <h2>Add to whitelist</h2> + <form action="awl.php?mode=<?php echo $mode; ?>&action=add_sender" method="post"> + <table width="100%" border="0" summary="add form"> + <?php if ($mode == "email") { ?> + <tr> + <td width="120">Sender name:</td> + <td width="240"><input class="txt" type="text" name="sender_name" /></td> + <td colspan="2"> </td> + </tr> + <?php } ?> + <tr> + <td width="120">Sender domain:</td> + <td width="240"><input class="txt" type="text" name="sender_domain" /></td> + <td colspan="2"> </td> + </tr> + <tr> + <td width="120">Source (class c or d):</td> + <td width="240"><input class="txt" type="text" name="src" /></td> + <td align="left"><input class="btn" type="submit" value="Add" /></td> + <td align="right"> + <a class="navlike" href="awl.php?mode=<?php echo $mode; ?>&action=del_undef">Delete '-undef-' entries</a> + </td> + </tr> + </table> + </form> + </div> + + <?php if (! $report2 == '' ) echo '<span class="alert">'.$report2.'</span>'; ?> + + <div id="footer"> + <?php require "includes/copyright.inc.php" ?> + </div> + +</div> + +</body> + +</html> |