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
107
108
109
110
111
112
|
<?php
// IPplan v4.92a
// Aug 24, 2001
//
// This program is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
//
require_once("../ipplanlib.php");
require_once("../adodb/adodb.inc.php");
require_once("../class.dbflib.php");
require_once("../layout/class.layout");
require_once("../auth.php");
$auth = new BasicAuthenticator(ADMINREALM, REALMERROR);
$auth->addUser(ADMINUSER, ADMINPASSWD);
// And now perform the authentication
$auth->authenticate();
// set language
isset($_COOKIE["ipplanLanguage"]) && myLanguage($_COOKIE['ipplanLanguage']);
//setdefault("window",array("bgcolor"=>"white"));
//setdefault("table",array("cellpadding"=>"0"));
//setdefault("text",array("size"=>"2"));
$title=my_("Display authority boundary information");
newhtml($p);
$w=myheading($p, $title);
// explicitly cast variables as security measure against SQL injection
list($grp, $ipplanParanoid) = myRegister("S:grp I:ipplanParanoid");
// basic sequence is connect, search, interpret search
// result, close connection
$ds=new IPplanDbf() or myError($w,$p, my_("Could not connect to database"));
$where="";
if ($grp) {
$where="WHERE grp=".$ds->ds->qstr($grp);
}
$result=&$ds->ds->Execute("SELECT boundsaddr, boundssize, grp
FROM bounds
$where
ORDER BY grp, boundsaddr");
insert($w,heading(3, $title));
// create a table
insert($w,$t = table(array("cols"=>"4",
"class"=>"outputtable")));
// draw heading
setdefault("cell",array("class"=>"heading"));
insert($t,$c = cell());
insert($c,text(my_("Group name")));
insert($t,$c = cell());
insert($c,text(my_("Boundary address")));
insert($t,$c = cell());
insert($c,text(my_("Boundary mask")));
insert($t,$c = cell());
insert($c,text(my_("Group action")));
$cnt=0;
$savegrp="";
while($row = $result->FetchRow()) {
setdefault("cell",array("class"=>color_flip_flop()));
insert($t,$c = cell());
if ($savegrp!=$row["grp"]) {
insert($c,text($row["grp"]));
}
insert($t,$c = cell());
insert($c,text(inet_ntoa($row["boundsaddr"])));
insert($t,$c = cell());
insert($c,text(inet_ntoa(inet_aton(ALLNETS)+1 -
$row["boundssize"])."/".inet_bits($row["boundssize"])));
insert($t,$c = cell());
insert($c,block("<small>"));
insert($c,anchor("deletebounds.php?grp=".urlencode($row["grp"]).
"&boundsaddr=".$row["boundsaddr"],
my_("Delete boundary"),
$ipplanParanoid ? array("onclick"=>"return confirm('".my_("Are you sure?")."')") : FALSE));
insert($c,block("</small>"));
$cnt++;
$savegrp=$row["grp"];
}
insert($w,block("<p><b>".sprintf(my_("Total records: %u"), $cnt)."</b>"));
$result->Close();
printhtml($p);
?>
|
