function sperre_posting($po_id)
{
$query = "SELECT po_gesperrt FROM posting WHERE po_id = " . intval($po_id);
$result = mysql_query($query);
$fo = mysql_fetch_array($result);
if (ist_posting_gesperrt($po_id)) {
// Posting entsperren
$query = "UPDATE posting SET po_gesperrt = 'N' WHERE po_id = " . intval($po_id);
$result = mysql_query($query);
} else {
// Posting sperren
$query = "UPDATE posting SET po_gesperrt = 'Y' WHERE po_id = " . intval($po_id);
$result = mysql_query($query);
}
}
function show_posting()
{
global $id, $http_host, $conn, $po_id, $thread, $seite;
global $f1, $f2, $f3, $f4, $farbe_tabelle_zeile1, $farbe_tabellenrahmen;
global $t, $o_js, $forum_admin;
$sql = "select po_th_id, date_format(from_unixtime(po_ts), '%d.%m.%Y, %H:%i:%s') as po_date, po_tiefe,\n po_titel, po_text, po_u_id, po_gesperrt, ifnull(u_nick, 'Nobody') as u_nick,\n\t\tu_email, u_id, u_level,u_punkte_gesamt,u_punkte_gruppe,u_chathomepage\n from posting\n left join user on po_u_id = u_id\n where po_id = " . intval($po_id);
$query = mysql_query($sql, $conn);
if ($query) {
$row = mysql_fetch_object($query);
}
$th_id = $row->po_th_id;
$po_u_id = $row->po_u_id;
$po_date = $row->po_date;
$po_tiefe = $row->po_tiefe;
$po_titel = $row->po_titel;
$po_gesperrt = $row->po_gesperrt;
if ($po_gesperrt == 'Y' and !$forum_admin) {
echo 'Posting gesperrt';
return;
}
$po_text = ersetzte_smilies(chat_parse(nl2br($row->po_text)));
if ($row->u_nick != "Nobody" && $row->u_level != "Z") {
$autor = user($po_u_id, $row, $o_js, FALSE, " ", "", "", TRUE, TRUE);
} else {
$autor = $row->u_nick;
}
@mysql_free_result($query);
$sql = "select po_threadorder from posting where po_id=" . intval($thread);
$query = mysql_query($sql, $conn);
$po_threadorder = mysql_result($query, 0, "po_threadorder");
@mysql_free_result($query);
//vorheriges und naechstes posting bestimmen
if ($po_threadorder == "0") {
//keine Antwort
$last = 0;
$next = 0;
} else {
if ($po_id == $thread) {
//root des Threads wird angezeigt
$last = 0;
$postingorder = explode(",", $po_threadorder);
$next = $postingorder[0];
} else {
//muddu guggen...
$postingorder = explode(",", $po_threadorder);
$k = 0;
while (list($k, $v) = each($postingorder)) {
if ($v == $po_id) {
break;
}
}
if ($k > 0) {
$last = $postingorder[$k - 1];
} else {
$last = $thread;
}
if ($k + 1 < count($postingorder)) {
$next = $postingorder[$k + 1];
} else {
$next = 0;
}
}
}
if (!$forum_admin) {
if (ist_posting_gesperrt($next)) {
$next = 0;
}
if (ist_posting_gesperrt($last)) {
$last = 0;
}
}
show_pfad_posting($th_id, $po_titel);
navigation_posting($last, $next, $po_u_id, $th_id, $row->u_nick, TRUE);
echo "<table width=\"760\" cellspacing=\"0\" cellpadding=\"1\" border=\"0\" bgcolor=\"{$farbe_tabellenrahmen}\"><tr><td>\n";
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"5\" border=\"0\">\n";
echo "<tr bgcolor=\"{$farbe_tabelle_zeile1}\"><td><b>{$po_titel}</b>";
if ($po_gesperrt == 'Y') {
echo " <b><font color=\"red\">(Posting gesperrt)</font></b>";
}
echo "</td></tr>";
echo "<tr bgcolor=\"{$farbe_tabelle_zeile1}\"><td>" . $f1 . $t['datum'] . $po_date . " " . $t['autor'] . $autor . $f2 . "</td></tr>";
echo "</table></td></tr>";
echo "<tr><td>\n";
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"5\" border=\"0\">\n";
echo "<tr bgcolor=\"{$farbe_tabelle_zeile1}\"><td>{$f1}" . $po_text . "{$f2}</td></tr>";
if ($po_threadorder == "0") {
echo "</table></td></tr></table>";
} else {
echo "</table></td></tr><tr><td>";
echo "<table width=\"760\" cellspacing=\"0\" cellpadding=\"5\" border=\"0\" bgcolor=\"{$farbe_tabelle_zeile1}\">\n";
echo "<tr><td align=\"center\">";
reset($postingorder);
zeige_baum($postingorder, $po_threadorder, $thread, $po_id, TRUE);
echo "</td></tr></table></td></tr></table>";
}
navigation_posting($last, $next, $po_u_id, $th_id, $row->u_nick, TRUE);
show_pfad_posting($th_id, $po_titel);
}
