--- etc/view.php.orig 2003-09-26 16:58:34.000000000 +0100
+++ etc/view.php 2014-06-22 15:24:14.720483023 +0100
@@ -11,10 +11,8 @@
print "\n\n\n";
/* Connect to RTG MySQL Database */
- $dbc=@mysql_connect ($host, $user, $pass) or
- $dbc=@mysql_connect ("$host:/var/lib/mysql/mysql.sock", $user, $pass) or
+ $dbc=@mysqli_connect ($host, $user, $pass, $db) or
die ("MySQL Connection Failed, Check Configuration.");
- mysql_select_db($db,$dbc);
# Global variables off by default in newer versions of PHP
if (!$PHP_SELF) {
@@ -26,17 +24,17 @@
# Determine router, interface names as necessary
if ($rid && $iid) {
$selectQuery="SELECT a.name, a.description, a.speed, b.name AS router FROM interface a, router b WHERE a.rid=b.rid AND a.rid=$rid AND a.id=$iid";
- $selectResult=mysql_query($selectQuery, $dbc);
- $selectRow=mysql_fetch_object($selectResult);
- $interfaces = mysql_num_rows($selectResult);
+ $selectResult=mysqli_query($dbc, $selectQuery);
+ $selectRow=mysqli_fetch_object($selectResult);
+ $interfaces = mysqli_num_rows($selectResult);
$name = $selectRow->name;
$description = $selectRow->description;
$speed = ($selectRow->speed)/1000000;
$router = $selectRow->router;
} else if ($rid && !$iid) {
$selectQuery="SELECT name AS router from router where rid=$rid";
- $selectResult=mysql_query($selectQuery, $dbc);
- $selectRow=mysql_fetch_object($selectResult);
+ $selectResult=mysqli_query($dbc, $selectQuery);
+ $selectRow=mysqli_fetch_object($selectResult);
$router = $selectRow->router;
}
@@ -68,12 +66,12 @@
if (!$rid) {
print "Monitored Devices: \n";
$selectQuery="SELECT rid, name FROM router";
- $selectResult=mysql_query($selectQuery, $dbc);
- if (mysql_num_rows($selectResult) <= 0)
+ $selectResult=mysqli_query($dbc, $selectQuery);
+ if (mysqli_num_rows($selectResult) <= 0)
print "
No Routers Found.
\n";
else {
print "
\n";
- while ($selectRow=mysql_fetch_object($selectResult)){
+ while ($selectRow=mysqli_fetch_object($selectResult)){
print "- rid\">";
print "$selectRow->name
\n";
}
@@ -95,19 +93,22 @@
$bt = $et - (60*60*24);
print "Day View:
\n";
- print "![](\"rtgplot.cgi?t1=ifInOctets_".$rid."&t2=ifOutOctets_".$rid."&iid=$iid&begin=$bt&end=$et&units=bits/s&factor=8&filled=yes\")
\n";
+ print "![](\"/cgi-bin/rtgplot.cgi?t1=ifInOctets_".$rid."&t2=ifOutOctets_".$rid."&iid=$iid&begin=$bt&end=$et&units=bits/s&factor=8&filled=yes";)
\n";
print "
$router: $name ($description)\n";
print "
\n";
$bt = $et - (60*60*24*7);
print "Week View:
\n";
- print "\n";
+ print "\n";
print "
$router: $name ($description)\n";
print "
\n";
$bt = $et - (60*60*24*30);
print "Month View:
\n";
- print "\n";
+ print "\n";
print "
$router: $name ($description)\n";
print "
\n";
}
@@ -116,8 +117,8 @@
if ($rid && !$iid) {
$selectQuery="SELECT id, name, description FROM interface WHERE rid=$rid";
- $selectResult=mysql_query($selectQuery, $dbc);
- $interfaces = mysql_num_rows($selectResult);
+ $selectResult=mysqli_query($dbc, $selectQuery);
+ $interfaces = mysqli_num_rows($selectResult);
if ($interfaces <= 0)
print "
No Interfaces Found for Router $router (ID: $rid).
\n";
else {
@@ -129,12 +130,15 @@
print gmdate('D, d M Y H:i:s \G\M\T', time())."\n";
print "
\n";
print "