$sql = "SELECT id, DATE_FORMAT(datum, '%d.%m.%Y') as datum, name, beschreibung, zip, screen, hits, anschau_link, (rating_summe/rating_anzahl) as rating, art, autor, benuetzt, autor_detail, autor_demo, self FROM free_webdesign WHERE id = '".mysql_real_escape_string($_GET['id'])."' ORDER BY datum DESC LIMIT 1 "; $result = mysql_query($sql) OR die("
\n".$sql."
\n".mysql_error()); if (mysql_num_rows($result) == 0) { §appbody .= "
Dieses Webdesign existiert nicht!
"; } while ($row = mysql_fetch_assoc($result)) { §appbody .= '
Infos:
'; if ($row['autor'] == '') { $autor = 'celzekr'; } else { $autor = "".nocss($row['autor']).""; } if ($row['benuetzt'] == '0') { $benuetzt = 'HTML, CSS'; } else { $benuetzt = nocss($row['benuetzt']); } §appbody .= "Autor: ".$autor."
"; §appbody .= "Datum: ".nocss($row['datum'])."
\n"; §appbody .= "Downloads: ".nocss($row['hits'])."
\n"; §appbody .= "Bewertung: ".nocss($row['rating'])."
"; §appbody .= "Benützt: ".$benuetzt."
"; if ($row['self'] == '1') { $anschauen = "http://f...content-available-to-author-only...t.de/thumbshot-pro/?scale=4&url=http://c...content-available-to-author-only...r.tk/".nocss($row['anschau_link'])."&effect=2"; } else { $anschauen = "".nocss($row['autor_demo']).""; } §appbody .= '
'.nocss($row['name']).':
'.nocss($row['beschreibung']).'
'; if ($row['self'] == '1') { §appbody .= "Anschauen  Download (.zip)

\n"; } else { §appbody .= "Anschauen  Details / Download

\n"; } §appbody .= '
Kommentare:
'; $sql555 = "SELECT id, autor, design_id, comment, date FROM design_comments WHERE design_id = '".$row['id']."' ORDER BY date DESC "; $result555 = mysql_query($sql555) OR die("
\n".$sql555."
\n".mysql_error()); while ($row555 = mysql_fetch_assoc($result555)) { §appbody .= "
Geschrieben von: ".nocss($row555['autor'])." am: ".nocss($row555['date'])."
".nocss($row555['comment'])."
\n"; } if(isset($_POST['submit']) AND $_POST['submit'] == "Kommentieren") { if(empty($_REQUEST['comment']) || empty($_REQUEST['name'])) { §appbody .= "
Bitte geben Sie Ihren Kommentar und Ihren Namen ein!
"; } elseif(isset($_POST['email']) && $_POST['email']) { §appbody .= "
You are an SPAM-Bot!
"; } else { $bodynachricht = parse_bbcode(mysql_real_escape_string($_REQUEST['comment'])); mysql_query("INSERT INTO design_comments (autor, design_id, comment, date) VALUES ('".mysql_real_escape_string($_REQUEST['name'])."','".$row['id']."','".$bodynachricht."',now())"); §appbody .= "
Sie haben den Kommentar eingetragen.
"; header("Location: http://c...content-available-to-author-only...r.tk/index.php?site=design&id=".$row['id'].""); } } §appbody .= '

Kommentar schreiben:

Ihr Name:
'; }