Hallo hab ne frage kann mir einer helfen bei ingame bann wenn ich ein ingame banne da kommt meine Account ID will aber das mein ingame name kommt wie geht das das php sicht so aus
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>
