\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo "

\n"; } if ($public_add == "yes" && $action != "add_link") { echo "

Link eintrage

\n"; } if ($mode == "flat" && $action == "add_link") { echo "

Zur Linkliste

\n"; } if ($mode == "leveled" && $QUERY_STRING) { echo "

Zurück zur Auswahl

\n"; } if ($public_add == "yes" || $QUERY_STRING) { echo "

\n"; echo "

\n"; } ######### FLAT MODE ######### if ($mode == "flat" && !$QUERY_STRING) { $query = "SELECT $link_table.ID AS LID, Clicks, Website, URL, $link_table.Description AS LDescription, $cat_table.ID AS CID, Category, $cat_table.Description AS CDescription FROM $cat_table, $link_table WHERE $cat_table.ID = $link_table.Cat_ID ORDER BY $cat_order, $links_order"; print_table ($query, $PHP_SELF, $tbl_border, $tbl_cellpadding, $tbl_cellspacing, $tbl_width, $tbl_align, $row1_color, $row2_color, $row3_color, $Category, $CDescription, $LID, $URL, $Website, $LDescription, $Clicks, $show_clicks, $show_credit, $credit_html, $new_window, $cat_table, $link_table); } ######### LEVELED MODE ######### if ($mode == "leveled" && !$LID && !$URL) { // print categories if (!$QUERY_STRING) { $query = "SELECT * FROM $cat_table ORDER BY $cat_order"; $result = mysql_query($query) or die("

Error: No data exists.

\n\n\n\n"); echo "

\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while (list($CID, $Count, $Category, $Description) = mysql_fetch_array($result)) { if ($Count > 0) { $Category = "$Category"; } if ($Description) { $Description = "- $Description"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; } if ($show_credit == "yes") { echo " \n"; echo " \n"; echo " \n"; } echo "
Categories
Category/Description Links
$Category $Description $Count

$credit_html
\n"; echo "

\n"; } // print links for specific category if ($CID) { $query = "SELECT $link_table.ID AS LID, Clicks, Website, URL, $link_table.Description AS LDescription, $cat_table.ID AS CID, Category, $cat_table.Description AS CDescription"; $query .= " FROM $cat_table, $link_table"; $query .= " WHERE $cat_table.ID = $link_table.Cat_ID AND $cat_table.ID = $CID"; $query .= " ORDER BY $links_order"; print_table ($query, $PHP_SELF, $tbl_border, $tbl_cellpadding, $tbl_cellspacing, $tbl_width, $tbl_align, $row1_color, $row2_color, $row3_color, $Category, $CDescription, $LID, $URL, $Website, $LDescription, $Clicks, $show_clicks, $show_credit, $credit_html, $new_window, $cat_table, $link_table); } } ######### ADD LINK (PUBLIC) ######### if ($action == "add_link" && $public_add == "yes") { // process form if ($submit) { // check for errors if (!$Website) { $error = "

Webseiten Name muss eingetragen werden

\n"; } if (!$URL) { $error .= "

Webseiten URL muss eingetragen werden

\n"; } if (eregi("http://", $URL) && eregi("\.", $URL)) { // URL must contain http:// and . to be valid $validURL = 1; } if ($URL && !$validURL) { $error .= "

Webseiten URL muss eingetragen werden

\n"; } if (strlen($Description) > 120) { $error .= "

Beschreibung ist zu lang ( max.120 ) (länge: " . strlen($Description) . ")

\n"; } // add link to database if (!$error) { $Website = escape_quotes($Website); $URL = escape_quotes($URL); $Description = escape_quotes($Description); mysql_query("INSERT INTO $link_table (Cat_ID, Website, URL, Description) VALUES ('$CID','$Website','$URL','$Description')"); mysql_query("UPDATE $cat_table SET Count = Count+1 WHERE ID = $CID"); } else { $Website = strip_quotes($Website); $URL = strip_quotes($URL); $Description = strip_quotes($Description); } } // print title and message $title = "Link eintragen !"; $message = "Fülle bitte das komplette Formular aus, dann Klicke auf Link eintragen !"; if ($error) { $title = "Fehler bitte noch mal !"; $message = "Bitte alles ausfüllen !\n

$errorBitte noch mal neu eintragen !"; } if ($submit && !$error) { $title = "Link in Datenbank aufgenommen"; $message = "Danke für Ihren Eintrag!."; } print_title_message($title, $message); // print form if (!$submit) { // sets URL before user touches it $URL = "http://"; } if (!$submit || $error) { echo "\n"; } } ########### FOOTER/CLOSE DB ########### mysql_close($db); // close db connection ?>