my_nodes.php at OrangeMesh

<?php  
/* Name: my_nodes.php
 * Purpose: show all nodes associated with an email address
 * Written By: Mac Mollison, Ashton Mickey
 * Last Modified: November 7, 2008
 *
 * (c) 2008 Orange Networking.
 *  
 * This file is part of OrangeMesh.
 *
 * OrangeMesh is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version. This license is similar to the GNU
 * General Public license, but also requires that if you extend this code and
 * use it on a publicly accessible server, you must make available the 
 * complete source source code, including your extensions.
 *
 * OrangeMesh 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 Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with OrangeMesh.  If not, see <http://www.gnu.org/licenses/>.
 */

//Start session
session_start();

//Set how long a node can be down before it's name turns red (in seconds)
$OK_DOWNTIME = 1800;

//Get the current time
$currentTime = getdate();
$currentTime = $currentTime['0'];

//Setup database connection
require "../lib/connectDB.php";
setTable("node");

//Create menu and style, sanitize form input 
include "../lib/style.php";
include "../lib/menu.php";
include "../lib/toolbox.php";
sanitizeAll();

//Check if we have an email selected, if not ask them for one.
if (!isset($_POST['email'])) {
    ?>
    Please enter your email address.
    <form method="POST" action='my_nodes.php' name="select">
            <input name="email"><br>
            <input name="select" value="View Nodes" type="submit">
    </form>
    <?php 
    die();
}

//Include javascript to close the tip box
?>
<head>
<script>
	function close(){
		document.getElementById("tip").style.display="none";
	}
</script>
</head>
<?php 

//Display the title of the page and tip box
$result = mysql_query("SELECT * FROM network WHERE id=".$_SESSION['netid'], $conn);
$resArray = mysql_fetch_assoc($result);
if($resArray['display_name']=="") {$display_name = $resArray['net_name'];}
else {$display_name = $resArray['display_name'];}
$email = $_POST["email"];    //just used for the following message
echo <<<TITLE
<h2>Node Status List for $email on $display_name</h2>
<div class="note" id="tip">
<div class=error>Nodes in red need attention.</div>
<b>Names of gateway nodes appear in bold.
<a href="javascript:close()">hide</a></div>
TITLE;

//Get nodes that match email address from database
$query = "SELECT * FROM node WHERE owner_email='" . $_POST["email"]. "' AND netid='" . $_SESSION["netid"] . "'";
$result = mysql_query($query, $conn);
if(mysql_num_rows($result)==0) die("<div class=error>There are no nodes associated with this email address.</div>");


//Table columns, in format Display Name => DB field name.
//You can choose whatever order you like... and these are not all the options... any DB field is game.
$node_fields = array("Node Name" => "name","Description" => "description","Uptime" => "uptime",
  "Quality" => "gw-qual","Hops" => "hops","Down kb" => "kbdown","Up kb" => "kbup","Users" =>"users","Max Users" => "usershi",
  "Last Checkin" => "time","MAC" => "mac","Activation Status" => "approval_status");

//Set up the table (HTML output) - the Javascript causes it to be sortable by clicking the top of a column.
echo "<script src='../lib/sorttable.js'></script>";

echo "<table class='sortable' border='1'>";

//Output the top row of the table (display names)
echo "<tr class=\"fields\">";
foreach($node_fields as $key => $value) {
    echo "<td>" . $key . "</td>";
}
echo "</tr>";

//Output the rest of the table
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    if ($row["approval_status"] == "A" ||     //show only activated, pending or deactivated nodes
        $row["approval_status"] == "P" || 
        $row["approval_status"] == "D") {        
        
        if($currentTime - strtotime($row['time']) >= $OK_DOWNTIME) {
    	    echo "<tr class=\"down\">";
        }
        else {
    	    echo "<tr>";
        }
        foreach($node_fields as $key => $value) {
            echo "<td>";
            if ($value=="name" && $row["gateway_bit"]==1) {
                echo "<b>" . $row[$value] . "</b>";                      
            }
            elseif ($value=="gw-qual") {    //Convert rank from x {x | 0 < x < 255} to %
                echo floor(100 * ($row[$value] / 255)) . "%";
            }
            elseif ($value=="approval_status") {    //Translate approval flags into English
                switch ($row[$value]) {
                    case "A": echo "Activated"; break;
                    case "P": echo "Pending Approval"; break;
                    case "D": echo "Deactivated"; break;
                }
            }
            else {
                echo $row[$value];
            }
            echo "</td>";
        }
        echo "</tr>";
    }
}
echo "</table>";

//Set up NiftyCorners
?>
<br>
<body onload=Nifty("div.note");> <!-- Not valid HTML, but NiftyCorners needs this here to work for some reason... -->
</body>