"Fossies" - the Fresh Open Source Software Archive 
Member "sqlgreywebinterface-1.1.8/sqlgreywebinterface-1.1.8/awl.php" (10 Aug 2015, 8442 Bytes) of package /linux/privat/old/sqlgreywebinterface-1.1.8.tgz:
The requested HTML page contains a <FORM> tag that is unusable on "Fossies" in "automatic" (rendered) mode so that page is shown as HTML 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. For more information about "awl.php" see the
Fossies "Dox" file reference documentation.
1 <?php
2
3 /********************************************
4 SQLgrey Web Interface
5 Filename: awl.php
6 Purpose: Renders the greylist page
7 Version: 1.1.8
8 *********************************************/
9
10 require "includes/functions.inc.php";
11 require "includes/awl.inc.php";
12
13 isset($_GET["mode"]) ? $mode = $_GET["mode"] : $mode = "email";
14 isset($_GET["action"]) ? $action = $_GET["action"] : $action = "";
15
16 // For sort order.
17 isset($_GET["csort"]) ? $csort = $_GET["csort"] : $csort = "";
18 isset($_GET["sort"]) ? $sort = $_GET["sort"] : $sort = "";
19 if ($sort==null || $sort=="") {
20 if ($mode == "email") {
21 $sort = "sender_name";
22 } else {
23 $sort = "sender_domain";
24 }
25 }
26 $dir = "asc";
27 $ndir = "desc";
28 if ($sort == $csort && $_GET["order"] == "desc") {
29 $dir = "desc";
30 $ndir = "asc";
31 }
32
33 // Perform demanded action.
34 $clearit = '<br /><br /><a class="navlike" href="awl.php?mode='.$mode.'">Clear this report</a>';
35 switch ($action) {
36 case "del_selection":
37 // For batch deleting.
38 isset($_POST["chk"]) ? $chk = $_POST["chk"] : $chk = "";
39 if ($chk == "") {
40 $report = '<br />Nothing was selected - nothing has been deleted.'.$clearit;
41 } else {
42 foreach ($chk as $args) {
43 $parts = explode("@@", $args);
44 delete_entry($mode, $parts[0], $parts[1], $parts[2]);
45 }
46 $report = $deleted.$clearit;
47 }
48 $report2 = "";
49 break;
50 case "del_undef":
51 delete_undef($mode);
52 $report = "";
53 $report2 = $message;
54 break;
55 case "add_sender":
56 isset($_POST["sender_name"]) ? $sn = $_POST["sender_name"] : $sn = "";
57 add_sender($mode, $sn, $_POST["sender_domain"], $_POST["src"]);
58 $report = "";
59 $report2 = $added;
60 break;
61 case "":
62 $report = "";
63 $report2 = "";
64 break;
65 }
66
67 // Make a nice header.
68 if ($mode=="email") {
69 $query = "SELECT COUNT(*) AS count FROM from_awl";
70 $title = "e-mail addresses (";
71 } else {
72 $query = "SELECT COUNT(*) AS count FROM domain_awl";
73 $title = "domains (";
74 }
75 $result = do_query($query);
76 $n = fetch_row($result);
77 $title .= $n["count"].")";
78
79 /*
80 mysql> describe from_awl;
81 +---------------+---------------+------+-----+----------------+-------+
82 | Field | Type | Null | Key | Default | Extra |
83 +---------------+---------------+------+-----+----------------+-------+
84 | sender_name | varchar(64) | | PRI | | |
85 | sender_domain | varchar(255) | | PRI | | |
86 | src | varchar(39) | | PRI | | |
87 | first_seen | timestamp(14) | YES | | NULL | |
88 | last_seen | timestamp(14) | YES | MUL | 00000000000000 | |
89 +---------------+---------------+------+-----+----------------+-------+
90
91 mysql> describe domain_awl;
92 +---------------+---------------+------+-----+----------------+-------+
93 | Field | Type | Null | Key | Default | Extra |
94 +---------------+---------------+------+-----+----------------+-------+
95 | sender_domain | varchar(255) | | PRI | | |
96 | src | varchar(39) | | PRI | | |
97 | first_seen | timestamp(14) | YES | | NULL | |
98 | last_seen | timestamp(14) | YES | MUL | 00000000000000 | |
99 +---------------+---------------+------+-----+----------------+-------+
100 */
101 ?>
102 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
103 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
104 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
105
106 <head>
107 <title>Whitelisted <?php if ($mode=="email") echo "e-mail addresses"; else echo "domains"; ?></title>
108 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
109 <link rel="stylesheet" href="main.css" type="text/css" charset="utf-8" />
110 </head>
111
112 <body>
113
114 <div id="page">
115
116 <div class="navcontainer">
117 <?php shownav('white', $mode, '', ''); ?>
118 </div>
119
120 <table width="100%" summary="header">
121 <tr>
122 <td>
123 <h1>Whitelisted <?php echo $title; ?></h1>
124 </td>
125 <td align="right">
126 <a class="navlike" href="#end" title="End of List">EoL</a>
127 </td>
128 </tr>
129 </table>
130
131 <table border="0" summary="sortbar"><?php echo ('
132 <tr>
133 <td width="20"> </td>');
134 if ($mode=="email") echo ('
135 <td width="300"> <b><a href="awl.php?mode='.$mode.'&sort=sender_name&csort='.$sort.'&order='.$ndir.'">Sender name</a></b></td>');
136 echo ('
137 <td width="240"><b><a href="awl.php?mode='.$mode.'&sort=sender_domain&csort='.$sort.'&order='.$ndir.'">Sender domain</a></b></td>
138 <td width="100"><b><a href="awl.php?mode='.$mode.'&sort=src&csort='.$sort.'&order='.$ndir.'">Source</a></b></td>
139 <td width="120"><b><a href="awl.php?mode='.$mode.'&sort=first_seen&csort='.$sort.'&order='.$ndir.'">First seen</a></b></td>
140 <td width="120"><b><a href="awl.php?mode='.$mode.'&sort=last_seen&csort='.$sort.'&order='.$ndir.'">Last seen</a></b></td>
141 </tr>');
142 ?></table>
143
144 <form method="post" action="awl.php?mode=<?php echo $mode; ?>&action=del_selection">
145 <div id="table_awl">
146 <table border="0" summary="data">
147 <tr><td><a name="top"></a></td></tr>
148 <?php
149 if ($mode=="email") {
150 if ($sort == "sender_name") {
151 $order = "sender_name ".$dir.", sender_domain ".$dir;
152 }
153 else if ($sort == "sender_domain") {
154 $order = "sender_domain ".$dir.", sender_name ".$dir;
155 } else {
156 $order = $sort." ".$dir;
157 }
158 $query = "SELECT sender_name, sender_domain, src, first_seen, last_seen FROM from_awl ORDER BY ".$order;
159 } else {
160 $order = $sort." ".$dir;
161 $query = "SELECT sender_domain, src, first_seen, last_seen FROM domain_awl ORDER BY ".$order;
162 }
163 $result = do_query($query);
164
165 while($line = fetch_row($result)) {
166 $sd = $line["sender_domain"];
167 $src = $line["src"];
168 $fs = $line["first_seen"];
169 $ls = $line["last_seen"];
170 if ($mode == "email") {
171 $sn = $line["sender_name"];
172 echo ('
173 <tr>
174 <td width="20"><input type="checkbox" name="chk[]" value="'.$sn.'@@'.$sd.'@@'.$src.'" /></td>
175 <td width="300"><span title="'.$sn.'">'.shorten_it($sn, 42).'</span></td>
176 ');
177 } else {
178 $sn = "noname";
179 echo ('
180 <tr>
181 <td width="20"><input type="checkbox" name="chk[]" value="'.$sn.'@@'.$sd.'@@'.$src.'" /></td>
182 ');
183 }
184 echo ('
185 <td width="240"><span title="'.$sd.'">'.shorten_it($sd, 35).'</span></td>
186 <td width="100">'.$src.'</td>
187 <td width="120">'.strip_millisecs($fs).'</td>
188 <td width="120">'.strip_millisecs($ls).'</td>
189 </tr>
190 ');
191 }
192 ?>
193 <tr><td><a name="end"></a></td></tr>
194 </table>
195 </div>
196
197 <br />
198
199 <table width="100%" summary="buttons">
200 <tr>
201 <td>
202 <input class="btn" type="submit" value="Delete selected entries" />
203 </td>
204 <td align="right">
205 <a class="navlike" href="#top" title="Top of List">ToL</a>
206 </td>
207 </tr>
208 </table>
209 </form>
210
211 <?php if (! $report == '' ) echo '<span class="alert">'.$report.'</span>'; ?>
212
213 <div id="form">
214 <h2>Add to whitelist</h2>
215 <form action="awl.php?mode=<?php echo $mode; ?>&action=add_sender" method="post">
216 <table width="100%" border="0" summary="add form">
217 <?php if ($mode == "email") { ?>
218 <tr>
219 <td width="120">Sender name:</td>
220 <td width="240"><input class="txt" type="text" name="sender_name" /></td>
221 <td colspan="2"> </td>
222 </tr>
223 <?php } ?>
224 <tr>
225 <td width="120">Sender domain:</td>
226 <td width="240"><input class="txt" type="text" name="sender_domain" /></td>
227 <td colspan="2"> </td>
228 </tr>
229 <tr>
230 <td width="120">Source (class c or d):</td>
231 <td width="240"><input class="txt" type="text" name="src" /></td>
232 <td align="left"><input class="btn" type="submit" value="Add" /></td>
233 <td align="right">
234 <a class="navlike" href="awl.php?mode=<?php echo $mode; ?>&action=del_undef">Delete '-undef-' entries</a>
235 </td>
236 </tr>
237 </table>
238 </form>
239 </div>
240
241 <?php if (! $report2 == '' ) echo '<span class="alert">'.$report2.'</span>'; ?>
242
243 <div id="footer">
244 <?php include "includes/copyright.inc.php" ?>
245 </div>
246
247 </div>
248
249 </body>
250
251 </html>