Untitled

<?php
include("config.php");
echo "
<html><head><title>$ServerName ModReq</title></head>
<body>
<table class=\"tablehead\" align=\"center\"><tr><td class=\"tdhead\"><h1>$ServerName ModReq</h1>
</td></tr>
</table>
<div align=\"center\">
";
$Connect = mysql_connect("$Host","$DatabaseLoginUsername","$DatabaseLoginPassword") or die("<p class=pbad>Sorry but we where unable to connect to MySQL. Please try again later.</p>");
$Result = @mysql_select_db("$DatabaseName",$Connect)or die("<p class=pbad>Sorry - unable to select the database. Please try again later.</p>") ;
$SQL = "select * from requests where status=\"open\"";
$Result = @mysql_query($SQL);
echo "<h2>Open Mod Requests</h2>
<table class=\"tablemodreq\">
<tr>
<td class=\"tdmodreq\" width=\"3%\"><h3>ID</h3></td>
<td class=\"tdmodreq\" width=\"7%\"><h3>Submitter</h3></td>
<td class=\"tdmodreq\" width=\"10%\"><h3>Date</h3></td>
<td class=\"tdmodreq\" width=\"10%\"><h3>Location</h3></td>
<td class=\"tdmodreq\" width=\"10%\"><h3>Staff</h3></td>
<td class=\"tdmodreq\" width=\"30%\"><h3>Message</h3></td>
<td class=\"tdmodreq\" width=\"30%\"><h3>Comment</h3></td>
</tr>
</table>
";
while ($row = mysql_fetch_array($Result))
{
$ID = $row["id"];
$Submitter = $row["submitter"];
$Message = $row["message"];
$Date = $row["date"];
$Comment = $row["comment"];
$Location = $row["location"];
$Staff = $row["staff"];
echo "
<table class=\"tablemodreq\">
<tr>
<td class=\"tdmodreq\" width=\"3%\"><p>$ID</p></td>
<td class=\"tdmodreq\" width=\"7%\"><p>$Submitter</p></td>
<td class=\"tdmodreq\" width=\"10%\"><p>$Date</p></td>
<td class=\"tdmodreq\" width=\"10%\"><p>$Location</p></td>
<td class=\"tdmodreq\" width=\"10%\"><p>$Staff</p></td>
<td class=\"tdmodreq\" width=\"30%\"><p>$Message</p></td>
<td class=\"tdmodreq\" width=\"30%\"><p>$Comment</p></td>
</tr>
</table>
";
}

$Connect2 = mysql_connect("$Host","$DatabaseLoginUsername","$DatabaseLoginPassword") or die("<p class=pbad>Sorry but we where unable to connect to MySQL. Please try again later.</p>");
$Result2 = @mysql_select_db("$DatabaseName",$Connect2)or die("<p class=pbad>Sorry - unable to select the database. Please try again later.</p>") ;
$SQL2 = "select * from requests where status=\"claimed\"";
$Result2 = @mysql_query($SQL2);
echo "<h2>Claimed Mod Requests</h2>
<table class=\"tablemodreq\">
<tr>
<td class=\"tdmodreq\" width=\"3%\"><h3>ID</h3></td>
<td class=\"tdmodreq\" width=\"7%\"><h3>Submitter</h3></td>
<td class=\"tdmodreq\" width=\"10%\"><h3>Date</h3></td>
<td class=\"tdmodreq\" width=\"10%\"><h3>Location</h3></td>
<td class=\"tdmodreq\" width=\"10%\"><h3>Staff</h3></td>
<td class=\"tdmodreq\" width=\"30%\"><h3>Message</h3></td>
<td class=\"tdmodreq\" width=\"30%\"><h3>Comment</h3></td>
</tr>
</table>
";
while ($row2 = mysql_fetch_array($Result2))
{
$ID2 = $row2["id"];
$Submitter2 = $row2["submitter"];
$Message2 = $row2["message"];
$Date2 = $row2["date"];
$Comment2 = $row2["comment"];
$Location2 = $row2["location"];
$Staff2 = $row2["staff"];
echo "
<table class=\"tablemodreq\">
<tr>
<td class=\"tdmodreq\" width=\"3%\"><p>$ID2</p></td>
<td class=\"tdmodreq\" width=\"7%\"><p>$Submitter2</p></td>
<td class=\"tdmodreq\" width=\"10%\"><p>$Date2</p></td>
<td class=\"tdmodreq\" width=\"10%\"><p>$Location2</p></td>
<td class=\"tdmodreq\" width=\"10%\"><p>$Staff2</p></td>
<td class=\"tdmodreq\" width=\"30%\"><p>$Message2</p></td>
<td class=\"tdmodreq\" width=\"30%\"><p>$Comment2</p></td>
</tr>
</table>
";
}
$Connect3 = mysql_connect("$Host","$DatabaseLoginUsername","$DatabaseLoginPassword") or die("<p class=pbad>Sorry but we where unable to connect to MySQL. Please try again later.</p>");
$Result3 = @mysql_select_db("$DatabaseName",$Connect3)or die("<p class=pbad>Sorry - unable to select the database. Please try again later.</p>") ;
$SQL3 = "select * from requests where status=\"closed\"";
$Result3 = @mysql_query($SQL3);
echo "<h2>Closed Mod Requests</h2>
<table class=\"tablemodreq\">
<tr>
<td class=\"tdmodreq\" width=\"3%\"><h3>ID</h3></td>
<td class=\"tdmodreq\" width=\"7%\"><h3>Submitter</h3></td>
<td class=\"tdmodreq\" width=\"10%\"><h3>Date</h3></td>
<td class=\"tdmodreq\" width=\"10%\"><h3>Location</h3></td>
<td class=\"tdmodreq\" width=\"10%\"><h3>Staff</h3></td>
<td class=\"tdmodreq\" width=\"30%\"><h3>Message</h3></td>
<td class=\"tdmodreq\" width=\"30%\"><h3>Comment</h3></td>
</tr>
</table>
";
while ($row3 = mysql_fetch_array($Result3))
{
$ID3 = $row3["id"];
$Submitter3 = $row3["submitter"];
$Message3 = $row3["message"];
$Date3 = $row3["date"];
$Status3 = $row3["status"];
$Comment3 = $row3["comment"];
$Location3 = $row3["location"];
$Staff3 = $row3["staff"];
echo "
<table class=\"tablemodreq\">
<tr>
<td class=\"tdmodreq\" width=\"3%\"><p>$ID3</p></td>
<td class=\"tdmodreq\" width=\"7%\"><p>$Submitter3</p></td>
<td class=\"tdmodreq\" width=\"10%\"><p>$Date3</p></td>
<td class=\"tdmodreq\" width=\"10%\"><p>$Location3</p></td>
<td class=\"tdmodreq\" width=\"10%\"><p>$Staff3</p></td>
<td class=\"tdmodreq\" width=\"30%\"><p>$Message3</p></td>
<td class=\"tdmodreq\" width=\"30%\"><p>$Comment3</p></td>
</tr>
</table>
";
}
?>
</div>
</body>
</html>