Re: Gang war surrender error
<?php
include "globals.php";
print "<h3> Gang Wars</h3>
<table width=75% cellspacing=1 class='table'>";
$q=$db->query("SELECT w.*,g1.gangNAME as declarer, g1.gangRESPECT as drespect, g2.gangNAME as defender, g2.gangRESPECT as frespect FROM gangwars w LEFT JOIN gangs g1 ON w.warDECLARER=g1.gangID LEFT JOIN gangs g2 ON w.warDECLARED=g2.gangID WHERE g1.gangNAME != '' AND g2.gangNAME != ''");
if($db->num_rows($q) > 0)
{
while($r=$db->fetch_row($q))
{
print "<tr> <td width=45%>{$r['declarer']} [{$r['drespect']} respect]</a></td> <td width=10%>vs.</td> <td width=45%>{$r['defender']} [{$r['frespect']} respect]</a></td> </tr>";
}
}
else
{
print "</table>There are currently no gang wars in progress.";
}
print "</table>";
$h->endpage();
?>