blob: 7b09b0bc4df7205d907957a0f00ce6ba257ec834 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
|
<?php
/********************************************
SQLgrey Web Interface
Filename: opt_in_out.php
Purpose: Renders the optin/out pages
Version: 1.1.6
*********************************************/
require "includes/functions.inc.php";
require "includes/opt_in_out.inc.php";
(isset($_GET["direction"])) ? $direction = $_GET["direction"] : $direction = "out";
(isset($_GET["what"])) ? $what = $_GET["what"] : $what = "domain";
(isset($_GET["action"])) ? $action = $_GET["action"] : $action = "";
// Add some explanation.
if ($direction == "out") {
$helptag = $helptag_dir;
} else {
$helptag = $helptag_dir.$helptag_what;
}
// Perform demanded action.
switch ($action) {
case "del":
$entry = $_GET["field"];
if ($entry == '') {
$report = '<br />Nothing was entered.';
} else {
do_query("DELETE FROM ".$table." WHERE ".$field."='".addslashes($entry)."'");
$report = '<br />'.$entry.' deleted.';
}
break;
case "add":
$entry = $_POST[$field];
if ($entry == '') {
$report = '<br />Nothing was entered.';
} else {
do_query("INSERT INTO ".$table."(".$field.") VALUES('".addslashes(strtolower($entry))."')");
$report = '<br />'.$entry.' added.';
}
break;
case "":
$report = "";
break;
}
?>
<!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><?php echo $title; ?></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('grey','', $direction, $what); ?>
</div>
<table width="100%" summary="main">
<tr>
<td>
<p><span class="h1"><?php echo $title; ?></span> <span class="h2"><?php echo $helptag; ?></span></p>
<table border="0" summary="data"><tr><td> </td></tr><?php
$query = "SELECT ".$field." FROM ".$table." ORDER BY ".$field;
$result = do_query($query);
while($line = fetch_row($result)) {
echo ('
<tr>
<td>'.$line[$field].'</td>
<td><a href="opt_in_out.php?direction='.$direction.'&what='.$what.'&field='.$line[$field].'&action=del">delete</a></td>
</tr>');
}
echo "\n";
?>
</table>
<br /><br />
<form action="opt_in_out.php?direction=<?php echo $direction.'&what='.$what; ?>&action=add" method="post">
<input type="text" name="<?php echo $field; ?>" size="40" />
<input class="btn" type="submit" value="Add" />
</form>
<?php if (! $report == '' ) echo '<span class="alert">'.$report.'</span>'; ?>
</td>
</tr>
</table>
<br />
<div id="footer" style="width: 800px">
<?php require "includes/copyright.inc.php" ?>
</div>
</div>
</body>
</html>
|
