<?php
$DB_Server="";
$DB_Name="";
$DB_User="";
$DB_Pass="";
$db=mysql_connect($DB_Server,$DB_User,$DB_Pass);
mysql_select_db($DB_Name,$db);

if(isset($_GET['Delete'])){
    $sql = "DELETE from IPTable WHERE `ID`=" . $_GET['Delete'];
    $result=mysql_query($sql,$db);
    if(mysql_affected_rows()==-1)
	echo("Delete Failed.");
    else
	echo("Delete Complete.");
    exit();
}

if(isset($_GET['INSTALL'])){
    $sql = "CREATE TABLE IPTable(ID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID),Name varchar(50), IPAddress varchar(15), Date datetime)";
    $result=mysql_query($sql,$db);
    if(mysql_affected_rows()==-1)
	echo("Install Failed.");
    else
	echo("Install Complete.");
    exit();
}

if(isset($_GET['FLUSH'])){
    $sql = "TRUNCATE IPTable";
    $result=mysql_query($sql,$db);
    if(mysql_affected_rows()<0)
	echo("Truncate Failed");
    else
	echo("Truncate successful");
    exit();
}

if(isset($_GET['Name'])){
    $Name=addslashes(trim($_GET['Name']));
    $IP= $_SERVER['REMOTE_ADDR'];
    $sql = "UPDATE IPTable SET IPAddress='$IP', Date=NOW() WHERE Name='$Name'";
    $result=mysql_query($sql,$db);
    if(mysql_affected_rows()<1){
	$sql = "INSERT into IPTable (Name,IPAddress,Date) values ('$Name','$IP',NOW())";
	$result=mysql_query($sql,$db);
    	if(mysql_affected_rows()>0)
	    echo("Added $Name");
	else
	    echo("Error Adding IP");
    }else
	echo("Updated $Name Address");
}else{
    $sql = "SELECT * FROM IPTable Order By Name";
    $result=mysql_query($sql,$db);
    $NumOfRow = mysql_num_rows($result);
    $current=1;
    if($NumOfRow>0){
	echo("<table border=1><tr><th>Name</th><th>IP Address</th><th>Links</th><th>Options</th><th>Date</th></tr>");
	while ($NumOfRow >= $current){
 	    $row = mysql_fetch_array($result);
	    $ID = $row["ID"];
	    $Name = $row["Name"];
	    $IP = $row["IPAddress"];
	    $Date = $row["Date"];
	    echo("<tr><td>$Name</td><td><font color=green>$IP</font></td><td><a href=\"http://$IP\">Web</a> | <a href=\"ssh://$IP\">SSH</a></td><td align=\"center\"><a href=\"" . $_SERVER['PHP_SELF'] . "?Delete=$ID\">Delete</a><td>$Date</td></tr>");
	    $current++;
	}
	echo("</table>");
    }else
	echo("No IPs Registered.");
}
?>
