include('admin/config.php');
if (isset($_GET['id']) ) { $thema_id = (int) $_GET['id']; }
$result = mysql_query("SELECT text FROM `ff_thema` WHERE id = '$thema_id'") or trigger_error(mysql_error());
while($row = mysql_fetch_array($result))
{ require_once('header.php');
echo "
" . nl2br( $row['text']) . " "; }
echo "";
$result = mysql_query("SELECT * FROM `ff_beitrag` WHERE `thema_id` = '$thema_id' AND status < 2 ORDER BY timestamp ASC") or trigger_error(mysql_error());
while($row = mysql_fetch_array($result)){
foreach($row AS $key => $value) { $row[$key] = stripslashes($value); }
//E-Mail vorbereiten
$teile = explode('@', $row['email']);
$anfang = $teile[0];
$ende = $teile[1];
//Beitrag vorbereiten
$suchmuster[0] = "/\[br\]/";
$suchmuster[1] = "/\[:/";
$suchmuster[2] = "/:\]/";
$suchmuster[3] = "#http://www\.youtube\.com/watch\?v=([A-Za-z0-9_\-&=]*)#is";
$suchmuster[4] = "#^(.)#is";
$suchmuster[5] = "#([\s>])([\w]+?://[\w\#$\(\)%&~/.\-;:=,?@\[\]+]*)#is";
$suchmuster[6] = "#([\s>])(www\.[\w\#$%&~/.\-;:=,?@\[\]+]*)#is";
$suchmuster[7] = "/\&/";
$ersetzungen[0] = " ";
$ersetzungen[1] = " ";
$ersetzungen[3] = ' ';
$ersetzungen[4] = " \\1";
$ersetzungen[5] = "\\1\\2 ";
$ersetzungen[6] = "\\1\\2 ";
$ersetzungen[7] = "&";
$row['text'] = preg_replace($suchmuster, $ersetzungen, $row['text']);
//Status vorbereiten
if ($row['status'] == 0) { $statusimage = " "; }
if ($row['status'] == 1) { $statusimage = " "; }
if ($row['status'] == 0) { $ip = ''. substr_replace(substr_replace(str_replace(".", "",$row['ip']),"",2,3),"9",3,2) .' '; }
echo "\n";
echo "
\n";
echo $statusimage . "\n";
echo $ip . "\n";
echo nl2br( $row['name']);
echo " am ";
echo date('d.m.Y H:i', strtotime($row['timestamp'])) . "
\n";
echo "
" . nl2br( $row['text']) . "
\n";
echo "
\n";
}
?>
Neue Antwort
include('footer.php'); ?>