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
113
|
<?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("../auth.php");
require_once("../class.templib.php");
$auth = new BasicAuthenticator(ADMINREALM, REALMERROR);
$auth->addUser(ADMINUSER, ADMINPASSWD);
// And now perform the authentication
$auth->authenticate();
// save the last customer used
// must set path else Netscape gets confused!
setcookie("ipplanCustomer","$cust",time() + 10000000, "/");
// basic sequence is connect, search, interpret search
// result, close connection
// explicitly cast variables as security measure against SQL injection
list($cust) = myRegister("I:cust");
$ds=new IPplanDbf() or die(my_("Could not connect to database"));
// force file download due to bad mime type
header("Content-Type: bad/type");
header("Content-Disposition: attachment; filename=ipaddr.txt");
header("Pragma: no-cache");
header("Expires: 0");
// if a specific network template exists, use that, else use generic template
$template=new IPplanIPTemplate("iptemplate", $cust);
$err=$template->is_error();
$result=&$ds->ds->Execute("SELECT ipaddr.userinf, ipaddr.location, ipaddr.telno,
ipaddr.descrip, ipaddr.hname, ipaddr.ipaddr AS ip,
ipaddr.baseindex AS baseip, ipaddr.macaddr
FROM ipaddr, base
WHERE ipaddr.baseindex=base.baseindex AND
base.customer=$cust
ORDER BY
ipaddr.ipaddr");
// main loop
while($row = $result->FetchRow()) {
echo inet_ntoa($row["ip"]).FIELDS_TERMINATED_BY.$row["userinf"].FIELDS_TERMINATED_BY.
$row["location"].FIELDS_TERMINATED_BY.$row["descrip"].FIELDS_TERMINATED_BY.
$row["hname"].FIELDS_TERMINATED_BY.$row["telno"].FIELDS_TERMINATED_BY.
$row["macaddr"];
if (!$err) {
$restmp=&$ds->ds->Execute("SELECT info, infobin
FROM ipaddradd
WHERE ipaddr=".$row["ip"]." AND baseindex=".$row["baseip"]);
if($rowadd = $restmp->FetchRow()) {
$template->Merge($template->decode($rowadd["info"]));
foreach($template->userfld as $arr) {
$tmpfield=csv_escape($arr["value"]);
echo FIELDS_TERMINATED_BY.$tmpfield;
}
}
}
echo "\n";
}
// wrap any multiline string with quotes
function csv_escape($str) {
if (PHP_VERSION >= 5) {
// this function only works with php 5 and above
$str = str_replace(array('"', ',', "\n", "\r"), array('""', ',', "\n", "\r"), $str, $count);
if($count) {
return '"' . $str . '"';
} else {
return $str;
}
}
else {
$replaced_str = str_replace(array('"', ',', "\n", "\r"),
array('""', ', ', " \n", " \r"), $str);
if(strcmp($replaced_str,$str)) {
return '"' . $replaced_str . '"';
} else {
return $str;
}
}
}
?>
|
