"Fossies" - the Fresh Open Source Software Archive 
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. See also the latest
Fossies "Diffs" side-by-side code changes report for "awl.php":
1.1.7_vs_1.1.8.
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>