PHP Code:
<h2>Ban Liste</h2>
<form action="index.php?s=pranger" method="POST">
<table>
<tr>
<th class="topLine">Charakter oder Grund suchen:</th>
<td class="topLine"><input type="text" name="charsuche" value="<?PHP echo $_POST['charsuche']; ?>" size="40" maxlength="16"/></td>
<td class="topLine"><input type="submit" name="submit" value="suchen"/></td>
</tr>
</table>
</form>
<table>
<tr>
<th class="topLine">Charakter</th>
<th class="topLine">Zeitpunkt</th>
<th class="topLine">Teamler</th>
<th class="topLine">Grund</th>
<th class="topLine">Dauer</th>
</tr>
<?PHP
if(isset($_POST['submit']) AND $_POST['submit']=="suchen")
{
$sqlCmd = "SELECT ban_time,who,gm,cause,until FROM log.ingame_ban_log WHERE (who LIKE '%".mysql_real_escape_string($_POST['charsuche'])."%' OR cause='".$_POST['charsuche']."') ORDER BY who ASC";
}
else
{
$sqlCmd = "SELECT ban_time,who,gm,cause,until FROM log.ingame_ban_log ORDER BY who ASC";
}
$sqlQry = mysql_query($sqlCmd,$sqlServ);
$x=0;
while($getAccs=mysql_fetch_object($sqlQry))
{
if(($x%2)==0)
{
$zF="tdunkel";
}
else
{
$zF="thell";
}
echo"<tr>
<td class=\"$zF\">".$getAccs->who."</td>\n
<td class=\"$zF\">".$getAccs->ban_time."</td>\n
<td class=\"$zF\">".$getAccs->gm."</td>\n
<td class=\"$zF\">".$getAccs->cause."</td>\n
<td class=\"$zF\">".$getAccs->until."</td>\n
</tr>\n";
$x++;
}
?>
</table>