}
}
if ($fehler != '') {
echo '<center><b><font color="red">', $fehler, '</font></b></center>';
}
include "nav2.php";
?>
<br>
<table width="750" border="0" valign="top" align="middle">
<tr><td align="middle"><b>Aktuelle News</b></td></tr>
<?php
$var2 = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT 3");
while ($varb = mysql_fetch_array($var2)) {
$text2 = nl2br($varb["text"]);
echo '<tr><td bgcolor="#300000">', gerdatum($varb["datum"]), '</td></tr><tr><td>', $text2, '</td></tr>';
}
?>
</table>
<br>
<br>
<br>
</center>
</body>
</html>
$avatar = 'avatar/siedler.gif';
}
$explodevar = explode("-", $t["bezug"]);
$postdate = isset($postdate) ? $postdate : $t["datum"];
echo '<table class="invitetable" style="text-align:center;" width="100%"><tr><th><a href="newmail.php?to=', $blub->id, '"><img src="images/misc/kontakt.png" border="0" onmouseover="Tip(\'<b>Nachricht an Spieler</b>\')" onmouseout="UnTip()" /></a>', $ich->moderator == 1 || $ich->id == $posterid ? '<a href="knedit.php?channel=' . $channel . '&pid=' . $t["id"] . '"><img src="images/misc/bearbeiten.png" border="0" onmouseover="Tip(\'<b>Nachricht editieren</b>\')" onmouseout="UnTip()" /></a>' : ' ', '<a href="zusammenhang.php?channel=', $channel, '&pid=', $t["id"], '"><img src="images/misc/zusammenhang.png" border="0" onmouseover="Tip(\'<b>Zusammenhang darstellen</b>\')" onmouseout="UnTip()" /></a><a href="knwrite.php?channel=', $channel, '&pid=', $t["id"], '"><img src="images/misc/botschaft.png" border="0" onmouseover="Tip(\'<b>Auf diese Nachricht antworten / Auf diese Nachricht beziehen</b>\')" onmouseout="UnTip()" /></a> <a href="knwrite.php?channel=', $channel, '"><img src="images/misc/write.png" border="0" onmouseover="Tip(\'<b>neuen Beitrag ( ohne Zusammenhang ) verfassen</b>\')" onmouseout="UnTip()" /></a></th><th width="55%"><a href="userinfo.php?id=', $t["autor"], '">', $blub->nickname, '</a></th><th><span style="color:silver;">Bezug auf: ', $explodevar[1] == 0 ? '-' : $t["bezug"], '</th><th><span style="color:red;">ID ', $t["id"], '</th><th>', gerdatum($postdate), '</th></tr></table>';
echo '<table class="invitetable" width="100%"><tr><td width="80px"><center><img src="', $avatar, '" border="0" /></center></td><td>';
if ($posterid == 1) {
echo '<font color="#00C0FF">';
}
echo nl2br(pruefetext($t["text"]));
// *** MOD VIEW
if ($ich->moderator == 1) {
$editvar = mysql_query("SELECT * FROM kn_log WHERE channel='{$channel}' AND pid='" . $t["id"] . "' ORDER BY id DESC");
while ($erow = mysql_fetch_array($editvar)) {
$editusr = new Account($erow["autor"]);
echo '<br /><br /><span style="color:yellow;font-weight:bold;">Version vom ', gerdatum($erow["datum"]), '</span> editiert von ', $editusr->nickname, '<br />';
echo nl2br(pruefetext($erow["text"]));
}
}
// ** ENDE MODVIEW
if (isset($editid)) {
$eusr = new Account($editid);
echo '<br /><br />[ <span style="color:red;">editiert von ', $eusr->nickname, ' ]';
}
if ($posterid == 1) {
echo '</font>';
}
echo '</td></tr></table><br/>';
}
$zahl++;
}
if (!ctype_digit($aid)) {
$betray = true;
}
if (!isset($_SESSION["Id"])) {
$betray = true;
}
if ($betray) {
echo 'Es ist ein Fehler aufgetreten (System.Exception(1))';
} else {
//
echo '<h3>Schiffsversteigerung</h3><br />';
echo '<table class="bordered"><tr><td>Bild</td><td>Klasse</td><td>Position</td><td>Verkäufer</td><td>Zahlungsmittel</td><td>Gebot</td><td>B</td><td>Ende</td></tr>';
$sebayresult = mysql_query("SELECT * FROM sebay WHERE id='{$aid}'");
while ($ebay = mysql_fetch_array($sebayresult)) {
$schiff = new schiff($ebay["sid"]);
echo '<tr><td><img src="', $schiff->img, '" border="0" /></td><td>', $schiff->klasse, '</td><td>', $schiff->x, '|', $schiff->y, '</td><td>', id2name($schiff->besitzer), '</td><td>', $inhaltcap[array_search($ebay["rohstoff"], $inhalt)], '</td><td>', $ebay["gebot"], ' (', id2name($ebay["bieter"]), ')</td><td><a href="sebay.php?aid=', $ebay["id"], '">bieten</a></td><td>', gerdatum($ebay["ende"]), '</td></tr>';
echo '</table><br />';
echo '<table class="bordered2">';
echo '<tr><td>Schilde</td><td>', $schiff->schilde, '/', $schiff->maxschilde, '</td></tr>';
echo '<tr><td>Hülle</td><td>', $schiff->hull, '/', $schiff->maxhull, '</td></tr>';
echo '<tr><td>Gondelerhitzung</td><td>', $schiff->maxgondeln, '</td></tr>';
echo '<tr><td>Phasererhitzung</td><td>', $schiff->maxphaser, '</td></tr>';
echo '<tr><td>Phaserstärke</td><td>', $schiff->laser, '</td></tr>';
echo '<tr><td>Energie</td><td>', $schiff->energie, '/', $schiff->maxenergie, ' (+', $schiff->energieoutput, ')</td></tr>';
echo '<tr><td>Lagerraum</td><td>', $schiff->lager, '</td></tr>';
echo '<tr><td>Sensorreichweite</td><td>', 2 + $schiff->lrs, '</td></tr>';
echo '<tr><td>Warpkern</td><td>', $schiff->maxwarpkern > 0 ? 'ja (' . $schiff->maxwarpkern . ')' : 'nein', '</td></tr>';
echo '<tr><td>Tarnung</td><td>', $schiff->skilltarnung == 1 ? 'ja' : 'nein', '</td></tr>';
echo '<tr><td>Transwarp</td><td>', $schiff->skilltranswarp == 1 ? 'ja' : 'nein', '</td></tr>';
echo '<tr><td>Deuteriumsauger / Erzsauger</td><td>', $schiff->skilldeut == 0 ? 'nein' : 'ja', ' / ', $schiff->skillerz == 0 ? 'nein' : 'ja', '</td></tr>';
echo '</table><br />';
$onlinecounter = 0;
$isonlinevar = mysql_query("SELECT * FROM account");
while ($checkonline = mysql_fetch_array($isonlinevar)) {
if (isonline($checkonline["aktion"])) {
$onlinecounter++;
}
}
if ($onlinecounter == 1) {
echo 'Es ist gerade <a href="player.php">1 Spieler</a> online!<br />';
}
if ($onlinecounter > 1) {
echo 'Es sind gerade <a href="player.php">', $onlinecounter, ' Spieler</a> online!<br />';
}
echo 'Dabei seit ', $account->mitglied, ' Ticks!<br />';
echo '<br /><font color="yellow"><b>permanenter Hinweis</b></font>: Solltest du Opfer von permanenten Diebstählen werden ( sogenanntes Farming ) wende dich bitte an das <a href="forum/">Forum - Gerichtshof </a> und bringe den permanenten Diebstahl zur Anzeige!<br />';
echo '<br />';
if ($account->level <= 3) {
echo '<span style="color:yellow;font-weight:bold;">Hinweis:</span> Ich empfehle dir das <a href="wiki/index.php/Tutorial">Tutorial</a> und das <a href="wiki/">Wiki</a> durchzulesen<br /><span style="color:yellow;font-weight:bold;">Hinweis:</span> Du bist die ersten 3 Level geschützt, du kannst nich angegriffen werden, kannst keine Rohstoffe klauen, kannst nicht beklaut werden und nicht angreifen.<br />';
}
if ($account->level <= 2) {
echo '<span style="color:yellow;font-weight:bold;">Hinweis:</span> Die ersten 2 Level haben Gebäude keine Bauzeit. Sie sind also sofort verfügbar!<br />';
}
echo '<br />';
if ($tm2["status"] == 1) {
echo 'Tick läuft gerade .... Bitte warten!';
} else {
echo 'Letzer Tick: ', gerdatum($tm2["datum"]), ' (Dauer: ', $tm2["dauer"], ' Sekunden)';
}
}
//TICK
include "foot.php";
$sid = $_GET["sid"];
//BETRAY
$betray = false;
if (!($id > 0)) {
$betray = true;
}
if (ctype_digit($sid)) {
$schiff = new schiff($sid);
if ($schiff->besitzer != $_SESSION["Id"]) {
$betray = true;
}
if ($schiff->klasse != 'Horchposten') {
$betray = true;
}
} else {
$betray = true;
}
//ENDE
if ($betray) {
echo 'Es ist ein Fehler aufgetreten...';
} else {
echo '<h3>Bericht des Horchposten im Sektor ', $schiff->x, '/', $schiff->y, '</h3>';
echo '<table class="bordered2"><tr><td>Datum</td><td>Bild</td><td>Klasse</td><td>Besitzer</td><td>Sektor</td></tr>';
$result = mysql_query("SELECT * FROM horchlog WHERE ich='{$sid}' ORDER BY id DESC");
while ($row = mysql_fetch_array($result)) {
echo '<tr><td>', gerdatum($row["datum"]), '</td><td><img src="', $row["img"], '" border="0" /></td><td>', $row["klasse"], '</td><td>', id2name($row["besitzer"]), '</td><td>', $row["x"], '/', $row["y"], '</td></tr>';
}
echo '</table>';
echo '<br /><a href="schiffe.php?sid=', $sid, '">zurück</a>';
}
include "foot.php";
}
}
if ($existName == 0) {
$fehler = 'Name existiert nicht!';
}
}
include "head.php";
include "nav.php";
if ($fehler != '') {
echo '<center><b><font color="red">', $fehler, '</font></b></center>';
}
echo '<center><h3>News</h3><table class="box">';
$var2 = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT 3");
while ($varb = mysql_fetch_array($var2)) {
$text2 = nl2br($varb["text"]);
echo '<tr><td width="150" style="vertical-align:top">', gerdatum($varb["datum"]), '</td><td><font color="', $varb["farbe"], '">', $text2, '</font><hr />geschrieben von: ', id2name($varb["autor"]), '</td></tr><tr><td> </td></tr>';
}
?>
</table><br />
neustes Changelog immer <a href="changelog.php">hier...</a><br />
<h3>Login</h3>
<br />
<form action="login.php" method="post">
<div class="box" style="width:300px">
<table>
<tr><td>Name</td><td><input type="text" name="name"></td></tr>
<tr><td>Passwort</td><td><input type="password" name="passwort"></td></tr>
<tr><td><span style="font-size:small"><a href="register.php">registrieren</a></span></td><td><input type="submit" value="einloggen"></td></tr>
</table>
<input type="hidden" name="sent" value="1"></div>
</form></center>
<?php
mysql_connect("localhost", "root", "db");
mysql_select_db("game2");
session_start();
include "klassen.php";
$hash = $_GET["hash"];
$sesid = $_SESSION["Id"] == '' || $_SESSION["Id"] == 0 ? $_SESSION["nick"] : $_SESSION["Id"];
mysql_query("INSERT INTO chat (zeit,nachricht,ip,uid) VALUES ('" . date("Y-m-d H:i:s") . "','{$hash}','" . $_SERVER["REMOTE_ADDR"] . "','" . $sesid . "')") or die(mysql_error());
mysql_query("UPDATE account SET aktion='" . date("Y-m-d H:i:s") . "' WHERE id='" . $_SESSION["Id"] . "'");
//HASH abfrage
if (substr($hash, 0, 5) == "!seen") {
if (ctype_digit(substr($hash, 6, strlen($hash) - 6))) {
$usr = new Account(substr($hash, 6, strlen($hash) - 6));
$msg = 'User [Spieler:' . $usr->id . '] war zuletzt online am: ' . gerdatum($usr->aktion);
mysql_query("INSERT INTO chat (zeit,nachricht,ip,uid) VALUES ('" . date("Y-m-d H:i:s") . "','{$msg}','" . $_SERVER["REMOTE_ADDR"] . "','9')") or die(mysql_error());
} else {
$msg = 'Falscher Syntax: !seen <ID des Users>';
mysql_query("INSERT INTO chat (zeit,nachricht,ip,uid) VALUES ('" . date("Y-m-d H:i:s") . "','{$msg}','" . $_SERVER["REMOTE_ADDR"] . "','9')") or die(mysql_error());
}
}
if (substr($hash, 0, 8) == "!wpunkte") {
if (ctype_digit(substr($hash, 9, strlen($hash) - 9))) {
$usr = new Account(substr($hash, 9, strlen($hash) - 9));
$msg = 'User [Spieler:' . $usr->id . '] hat ' . $usr->wpunkte . ' Wirtschaftspunkte!';
mysql_query("INSERT INTO chat (zeit,nachricht,ip,uid) VALUES ('" . date("Y-m-d H:i:s") . "','{$msg}','" . $_SERVER["REMOTE_ADDR"] . "','9')") or die(mysql_error());
} else {
$msg = 'Falscher Syntax: !wpunkte <ID des Users>';
mysql_query("INSERT INTO chat (zeit,nachricht,ip,uid) VALUES ('" . date("Y-m-d H:i:s") . "','{$msg}','" . $_SERVER["REMOTE_ADDR"] . "','9')") or die(mysql_error());
}
}
}
if (!ctype_digit($_GET["brief"])) {
die;
}
//CHEATSCHUTZ ENDE
$id = 1;
$postid = $_GET["brief"];
$postquery = mysql_query("SELECT * FROM mail WHERE id='{$postid}'");
//id einsetzen
while ($post = mysql_fetch_array($postquery)) {
//Abfrage der accountdaten
$abs = new Account($post["absender"]);
if ($_SESSION["Id"] == $post["absender"] || $_SESSION["Id"] == $post["empfaenger"]) {
//Pruefen ob cookievariable = empfaenger!
echo '<table class="invitetable">';
echo '<tr><th>Empfangsdatum</th><td>', gerdatum($post["datum"]), '</td></tr>';
echo '<tr><th>Absender</th><td>', $abs->nickname, '</td></tr>';
echo '<tr><th>Betreff</th><td>', $post["betreff"], '</td></tr>';
echo '</table>';
echo '<br />';
echo '<table class="invitetable">';
echo '<tr><th>Nachricht:</td></tr>';
echo '<tr><td style="width:400px;">', nl2br($post["inhalt"]), '</td></tr></table>';
mysql_query("UPDATE mail SET neu=0 WHERE id='{$postid}' AND empfaenger='{$selfid}'");
echo '<br />';
$bu = new Button("newmail.php?to=" . $post["absender"] . "&subject=Re:%20" . $post["betreff"], "<span style=\"color:green;\">antworten</span>");
$bu->printme();
echo "<br /><br />";
$bu = new Button("mail.php", "zurück zum Posteingang");
$bu->printme();
} else {
function showkn($channel, $pid, $vor)
{
$ich = new Account($_SESSION["Id"]);
if ($pid == 0 || $channel == 0) {
return;
}
$dec = null;
$vorfeld = explode("-", $vor);
$editid = null;
$posterid = null;
//*** EDITPRUFUNG
$editvar = mysql_query("SELECT * FROM kn_log WHERE channel='{$channel}' AND pid='{$pid}' ORDER BY id ASC LIMIT 1");
if (mysql_num_rows($editvar) > 0) {
while ($erow = mysql_fetch_array($editvar)) {
$posterid = $erow["autor"];
}
$editid = -2;
}
$abfrage = mysql_query("SELECT * FROM kn WHERE channel=" . $channel . " and bezug='" . $knid . "-" . $pid . "' AND bezug != '{$vor}'");
if (mysql_num_rows($abfrage) > 0) {
while ($t = mysql_fetch_array($abfrage)) {
if (!(text2num($vorfeld[0]) == 1 && $vorfeld[1] == $t["id"])) {
$usr = new Account($t["autor"]);
echo '<a href="zusammenhang.php?channel=' . $channel . '&pid=', $t["id"], '"><span style="color:red;font-weight:bold;">zur (anderen) Antwort von ', $usr->nickname, ' auf:</span></a><br />';
}
}
}
$abfrage = mysql_query("SELECT * FROM kn where channel=" . $channel . " AND id=" . $pid . " ORDER BY id DESC");
while ($t = mysql_fetch_array($abfrage)) {
if ($editid == -2) {
$editid = $t["autor"];
}
if (!isset($posterid)) {
$posterid = $t["autor"];
}
$tid = $posterid;
$blub = new Account($posterid);
$avatar = $blub->bild;
if ($avatar == '') {
$avatar = 'siedler.gif';
}
$explodevar = explode("-", $t["bezug"]);
$pre = $explodevar[1];
echo '<table class="bordered" width="100%"><tr><td width="55%"><a href="userinfo.php?id=', $t["autor"], '">', $blub->nickname, '</a></td><td><span style="color:silver;">Bezug auf: ', $explodevar[1] == 0 ? '-' : $t["bezug"], '</td><td><span style="color:red;">Eintrag: ', $knid, '-', $t["id"], '</td><td>', gerdatum($t["datum"]), '</td></tr></table>';
echo '<table class="bordered2" width="100%"><tr><td width="80px"><center><img src="', $avatar, '" border="0" /></center></td><td>';
if ($t["autor"] == 1) {
echo '<font color="#00C0FF">';
}
echo nl2br(pruefetext($t["text"]));
// *** MOD VIEW
if ($ich->moderator == 1) {
$editvar = mysql_query("SELECT * FROM kn_log WHERE channel='{$channel}' AND pid='" . $t["id"] . "' ORDER BY id DESC");
while ($erow = mysql_fetch_array($editvar)) {
$editusr = new Account($erow["autor"]);
echo '<br /><br /><span style="color:yellow;font-weight:bold;">Version vom :', gerdatum($erow["datum"]), '</span> editiert von ', $editusr->nickname, '<br />';
echo nl2br(pruefetext($erow["text"]));
}
}
// ** ENDE MODVIEW
if (isset($editid)) {
$eusr = new Account($editid);
echo '<br /><br />[ <span style="color:red;">editiert von ', $eusr->nickname, ' ]';
}
if ($t["autor"] == 1) {
echo '</font>';
}
echo '</td></tr></table>';
}
echo '<br/>';
switch ($explodevar[0]) {
case "KN":
$neuchannel = 1;
break;
case "ARCHIV":
$neuchannel = 2;
break;
case "HILFE":
$neuchannel = 3;
break;
case "HANDEL":
$neuchannel = 4;
break;
case "ALLIANZ":
$neuchannel = 5;
break;
default:
$neuchannel = 0;
break;
}
showkn($neuchannel, $pre, $knid . "-" . $pid);
}
}
echo '</table>';
}
if ($modus == 2) {
echo '<table class="bordered"><tr><td><a href="logbuch.php?modus=', $modus, '&order=', $ordervar == '1D' ? '1A' : '1D', '">Betroffener</a></td><td>Wo</td><td><a href="logbuch.php?modus=', $modus, '&order=', $ordervar == '3D' ? '3A' : '3D', '">Typ</a></td><td><a href="logbuch.php?modus=', $modus, '&order=', $ordervar == '4D' ? '4A' : '4D', '">Tatzeit</a></td><td>Abhandlung</td></tr>';
$abfrage = mysql_query("SELECT * FROM logbuch WHERE klasse='Ausgang' AND betroffener != '" . $_SESSION["Id"] . "' AND initiator='{$me}' ORDER BY {$ordervar1}");
while ($log = mysql_fetch_array($abfrage)) {
$zaehler++;
if ($zaehler >= 1 + ($seite - 1) * 25 && $zaehler <= $seite * 25) {
$aktid = $log["id"];
//Anzeige
if ($log["system"] > 0) {
$sys = new System($log["system"]);
}
$usr = new Account($log["initiator"]);
echo '<tr><td>', $usr->nickname, '</td><td>', $log["x"], '/', $log["y"], ' im ', $log["system"] == 0 ? 'Weltraum' : $sys->name . '-System (' . $sys->x . '|' . $sys->y . ')', '</td><td>', $log["typ"], '</td><td>', gerdatum($log["zeit"]), '</td><td>', $log["text"], '</td></tr>';
}
}
echo '</table>';
}
//SEITENLOGIK
$einfaerben = false;
for ($o = 1; $o <= ceil($zaehler / 25); $o++) {
if ($zaehler >= 1 + ($o - 1) * 25) {
if ($seite == $o) {
$einfaerben = true;
}
echo $o == $seite ? '<a href="logbuch.php?order=' . $ordervar . '&seite=' . $o . '&modus=' . $modus . '"><span style="color:red;">' . $o . '</span></a>' : '<a href="logbuch.php?order=' . $ordervar . '&seite=' . $o . '&modus=' . $modus . '">' . $o . '</span>', $o == ceil($zaehler / 25) ? '' : ',';
}
}
include "foot.php";
echo 'selected="true"';
}
echo '>' . $list[$i]->caption . ' (' . $list[$i]->id . ')</option>';
}
echo '</select><br /><br />';
if ($pid > 0) {
echo 'Du beziehst dich auf:<br />';
$abfrage = mysql_query("SELECT * FROM kn where channel=" . $channel . " AND id=" . $pid . " ORDER BY id DESC");
while ($t = mysql_fetch_array($abfrage)) {
$tid = $t["autor"];
$blub = new Account($t["autor"]);
$avatar = $blub->bild;
if ($avatar == '') {
$avatar = 'siedler.gif';
}
echo '<table class="bordered" width="100%"><tr><td width="70%"><a href="userinfo.php?id=', $t["autor"], '">', $blub->nickname, '</a></td><td>', gerdatum($t["datum"]), '</td></tr></table>';
echo '<table class="bordered2" width="100%"><tr><td width="80px"><center><img src="', $avatar, '" border="0" /></center></td><td>';
if ($t["autor"] == 1) {
echo '<font color="#00C0FF">';
}
echo nl2br($t["text"]);
if ($t["autor"] == 1) {
echo '</font>';
}
echo '</td></tr></table><br/>';
}
}
if ($_POST["do"] == 2) {
echo '<br /><div style="width:400px;padding:4px;border:1px solid darkred;">', nl2br(pruefetext($_POST["text"])), '</div><br />';
}
?>
<?php
include "klassen.php";
$usr = new Account("1");
echo '!', gerdatum($usr->aktion);
if ($post["neu"] == 1) {
//neue post
echo '<tr><td><span style="font-weight:bold">', gerdatum($post["datum"]), '</span></td><td><span style="font-weight:bold">', $abs->nickname;
echo '</span></td><td><span style="font-weight:bold"><a class="default" href="viewmail.php?brief=', $post["id"], '">', $post["betreff"], '</a></span></td>';
echo '<td><span style="font-weight:bold">';
$bu = new Button("viewmail.php?brief=" . $post["id"], "lesen");
$bu->printme();
echo '</span></td><form action="mail.php" method="post"><input type="hidden" name="delpost" value="', $post["id"], '"><td>';
$bu = new Button("", "löschen");
$bu->printme();
echo '</td></form></tr>';
$neuPostZaehler++;
//Zaehlen der neuen Post
} else {
//keine neue Post ( nicht markiert )
echo '<tr><td>', gerdatum($post["datum"]), '</td><td>', $abs->nickname;
echo '</td><td><a class="general" href="viewmail.php?brief=', $post["id"], '">', $post["betreff"], '</a></td>';
echo '<td><span style="font-weight:bold">';
$bu = new Button("viewmail.php?brief=" . $post["id"], "lesen");
$bu->printme();
echo '</span></td><form action="mail.php" method="post"><input type="hidden" name="delpost" value="', $post["id"], '"><td>';
$bu = new Button("", "löschen");
$bu->printme();
echo '</td></form></tr>';
}
//Ende else block
}
}
echo '</table></div>';
$einfaerben = false;
for ($o = 1; $o <= ceil($zaehler / 20); $o++) {
<?php
include "head.php";
include "navlogged.php";
include "connect.php";
echo '<table class="bordered">';
$abfrage = mysql_query("SELECT * FROM iplog");
while ($liste = mysql_fetch_array($abfrage)) {
$ip = $liste["ip"];
$id = $liste["id"];
$abfrage2 = mysql_query("SELECT * FROM iplog WHERE ip='{$ip}' AND id!='{$id}'");
while ($liste2 = mysql_fetch_array($abfrage2)) {
echo '<tr><td>', id2name($liste["besitzer"]), '</td><td>', id2name($liste2["besitzer"]), '</td><td>', gerdatum($liste["datum"]), '<br />', gerdatum($liste2["datum"]), '</td><td><b>', $liste["ip"], '</b></td></tr>';
}
}
echo '</table>';
include "foot.php";
<?php
mysql_connect("localhost", "root", "db");
mysql_select_db("game2");
session_start();
include "klassen.php";
echo '<table>';
$abfrage = mysql_query("SELECT * FROM chat WHERE id > ((SELECT MAX(id) FROM chat)-15) ORDER BY id ASC LIMIT 15");
while ($row = mysql_fetch_array($abfrage)) {
$arg1 = "";
$arg2 = "";
$text = pruefetext($row["nachricht"]);
$usr = new Account($row["uid"]);
if ($usr->id == 9) {
$arg1 = "color:red;";
$arg2 = "font-weight:bold;";
}
if ($usr->id == 1) {
$arg1 = "color:#00C0FF;";
}
if ($usr->id == '' || $usr->id == 0) {
$usr->nickname = $row["uid"];
}
echo '<tr><td style="width:135px;">', gerdatum($row["zeit"]), '</td><td style="min-width:140px;"><span style="', $arg1, $arg2, '">', $usr->nickname, '</span></td><td><span style="', $arg1, $arg2, '">', $text, '</span></td></tr>';
}
echo '</table>';
//mysql_query("UPDATE account SET aktion='".date("Y-m-d H:i:s")."' WHERE id='".$_SESSION["Id"]."'") or die(mysql_error());
