",$text); $text = str_replace ("\\", "", $text); $authorID = (mysql_result($result,$i,"authorID")); $catA = $catListA[(mysql_result($result,$i,"catA"))]; $catB = $catListB[(mysql_result($result,$i,"catB"))]; $catANo = (mysql_result($result,$i,"catA")); $catBNo = (mysql_result($result,$i,"catB")); if (!$catA) { $catA = ""; $catB = ""; $saveURL = "insert_people.php"; $icon = " "; $pSwitch = "people"; $cSwitch = "peoplecity"; } else { $saveURL = "insert_article.php"; $icon = " "; $pSwitch = "person"; $cSwitch = "city"; } $url1 = (mysql_result($result,$i,"url1")); $url2 = (mysql_result($result,$i,"url2")); $url3 = (mysql_result($result,$i,"url3")); $link1 = (mysql_result($result,$i,"link1")); $link2 = (mysql_result($result,$i,"link2")); $link3 = (mysql_result($result,$i,"link3")); $hookupAuthor = mysql_connect($server, $db_user, $db_passwd) or die ("DB-connect leider fehlgeschlagen"); if ($hookupAuthor) { $resultAuthor = mysql_db_query($db, "SELECT * FROM $TBLusers WHERE ID = '$authorID'", $hookupAuthor); if ($resultAuthor) { for ($j=0; $j   "; echo $icon; echo " $catA $catB
$headline


".date('d/m/Y', $date).", $AuthorSurname $AuthorName, $AuthorCity   "; echo "
  $synopsis

$text

"; if ($url1) { echo " "; if ($link1) { echo $link1; } else { echo $url1; } echo "
"; } if ($url2) { echo " "; if ($link2) { echo $link2; } else { echo $url2; } echo "
"; } if ($url3) { echo " "; if ($link3) { echo $link3; } else { echo $url3; } echo "
"; } echo "

comments [$noCOM]"; if ($type=="admin") { echo "
"; echo "
"; echo " edit     delete

"; } else if ($type=="user") { echo "
"; if ($authorID == $UID) { echo "
"; echo " edit     delete

"; } } else { echo "
"; } echo "

 
  "; if ($addcomment=="save") { if ($COMheadline =="") { $hl_err = $headlineError; $addcomment=1; } if ($type == "") { if (!ereg('^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+'. '@'. '[-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.'.'[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$', $COMemail)) { $em_err = $emailError; $addcomment=1; } } if ($COMtext =="") { $tx_err = $textError; $addcomment=1; } } if ($addcomment=="akjshghjasgjh") { echo "add comment
headline $hl_err


"; if ($type == "") { echo "email $em_err


"; } echo "text $tx_err



links

e.g.
linkURL: http://www.prov.com/home.html
linkText: My Homepage


LinkURL1

LinkText1


LinkURL2

LinkText2


LinkURL3

LinkText3




"; } else if ($addcomment=="save") { $date = time(); //Insert in Database $hookup = mysql_connect($server, $db_user, $db_passwd) or die ('DB-connect leider fehlgeschlagen'); if ($hookup) { mysql_select_db ($db, $hookup); if ($type == "") { $COMcity = $COMemail; } else { $COMcity = $city; } $sql = "INSERT INTO $TBLcontent (replyID, authorID, city, date, headline, text, url1, link1, url2, link2, url3, link3) VALUES ('$AID', '$UID', '$COMcity', '$date', '$COMheadline', '$COMtext', '$COMurl1', '$COMlink1', '$COMurl2', '$COMlink2', '$COMurl3', '$COMlink3')"; mysql_query ($sql, $hookup); echo "Comment saved.
"; } else { echo "Comment not saved.
"; } } else if ($EDI==1) { $hookup = mysql_connect($server, $db_user, $db_passwd) or die ("DB-connect leider fehlgeschlagen"); //Auslesen der relevanten DatensŠtze if ($hookup) { $result = mysql_db_query($db, "SELECT * FROM $TBLcontent WHERE ID = '$CID'", $hookup); if ($result) { $COMdate = (mysql_result($result,$i,"date")); $COMheadline = (mysql_result($result,$i,"headline")); $COMtext = (mysql_result($result,$i,"text")); $COMurl1 = (mysql_result($result,$i,"url1")); $COMlink1 = (mysql_result($result,$i,"link1")); $COMurl2 = (mysql_result($result,$i,"url2")); $COMlink2 = (mysql_result($result,$i,"link2")); $COMurl3 = (mysql_result($result,$i,"url3")); $COMlink3 = (mysql_result($result,$i,"link3")); } } echo "add comment
headline $hl_err


"; if ($type == "") { echo "email $em_err


"; } echo "text $tx_err



links

e.g.
linkURL: http://www.prov.com/home.html
linkText: My Homepage


LinkURL1

LinkText1


LinkURL2

LinkText2


LinkURL3

LinkText3




"; } else if ($EDI=="save") { $date = time(); //Insert in Database $hookup = mysql_connect($server, $db_user, $db_passwd) or die ('DB-connect leider fehlgeschlagen'); if ($hookup) { mysql_select_db ($db, $hookup); $sql = "DELETE FROM $TBLcontent WHERE ID = '$CID'"; mysql_query ($sql, $hookup); $sql = "INSERT INTO $TBLcontent (replyID, authorID, city, date, headline, text, url1, link1, url2, link2, url3, link3) VALUES ('$AID', '$UID', '$city', '$COMdate', '$COMheadline', '$COMtext', '$COMurl1', '$COMlink1', '$COMurl2', '$COMlink2', '$COMurl3', '$COMlink3')"; mysql_query ($sql, $hookup); echo "Comment saved.
"; } else { echo "Comment not saved.
"; } } if ($DEL) { //Insert in Database $hookup = mysql_connect($server, $db_user, $db_passwd) or die ('DB-connect leider fehlgeschlagen'); if ($hookup) { mysql_select_db ($db, $hookup); $sql = "DELETE FROM $TBLcontent WHERE ID = '$CID'"; mysql_query ($sql, $hookup); echo "Comment deleted.
"; } else { echo "Comment not deleted.
"; } } //Verbindung herstellen $hookup = mysql_connect($server, $db_user, $db_passwd) or die ("DB-connect leider fehlgeschlagen"); //Auslesen der relevanten DatensŠtze if ($hookup) { $result = mysql_db_query($db, "SELECT * FROM $TBLcontent WHERE replyID = '$AID' ORDER BY date DESC", $hookup); if ($result) { echo "comments

"; for ($i=0; $i",$COMtext); $COMurl1 = (mysql_result($result,$i,"url1")); $COMlink1 = (mysql_result($result,$i,"link1")); $COMurl2 = (mysql_result($result,$i,"url2")); $COMlink2 = (mysql_result($result,$i,"link2")); $COMurl3 = (mysql_result($result,$i,"url3")); $COMlink3 = (mysql_result($result,$i,"link3")); $hookupAuthor = mysql_connect($server, $db_user, $db_passwd) or die ("DB-connect leider fehlgeschlagen"); if ($hookupAuthor) { $resultAuthor = mysql_db_query($db, "SELECT * FROM $TBLusers WHERE ID = '$COMauthorID'", $hookupAuthor); if ($resultAuthor) { for ($j=0; $j$COMheadline - ".date('d/m/Y', $date).", "; if (!ereg('^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+'. '@'. '[-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.'. '[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$', $COMAuthorCity)) { echo "$COMAuthorSurname $COMAuthorName, $COMAuthorCity
"; } else { echo "$COMAuthorCity
"; } echo "$COMtext
"; if ($COMurl1) { echo " "; if ($COMlink1) { echo $COMlink1; } else { echo $COMurl1; } echo "
"; } if ($COMurl2) { echo " "; if ($COMlink2) { echo $COMlink2; } else { echo $COMurl2; } echo "
"; } if ($COMurl3) { echo " "; if ($COMlink3) { echo $COMlink3; } else { echo $COMurl3; } echo "
"; } echo "
"; if ($type=="admin") { echo "
"; echo " edit     delete

"; } else if ($type=="user") { if ($COMauthorID == $UID) { echo "
"; echo " edit     delete

"; } } } } } echo "
"; } } } include ("footer.php"); ?>