include("inc/db.inc.php"); // Hier wird der Navigationseintrag festgelegt $division = "Witze"; // Uebergaben if ($status != "senden") { $witz_id = $HTTP_GET_VARS['witz_id']; $kategorie = $HTTP_GET_VARS['kategorie']; $start = $HTTP_GET_VARS['start']; $limit = $HTTP_GET_VARS['limit']; } else { $witz_id = $HTTP_POST_VARS['witz_id']; $kategorie = $HTTP_POST_VARS['kategorie']; $absendername = $HTTP_POST_VARS['absendername']; $absenderemail = $HTTP_POST_VARS['absenderemail']; $empfaengername = $HTTP_POST_VARS['empfname']; $empfaengeremail = $HTTP_POST_VARS['empfemail']; $status = $HTTP_POST_VARS['status']; $witz = $HTTP_POST_VARS['witz']; $start = $HTTP_POST_VARS['start']; $limit = $HTTP_POST_VARS['limit']; } // WitzKategorien auslesen $query_kategorie = "SELECT kategorie_id, kategorie_wert from kategorie"; $result_kategorie = mysql_query($query_kategorie); // Anzahl der Witze auslesen $resultID = mysql_query("SELECT COUNT(witz_id) FROM witz where witz_online != 0"); $witz_total = mysql_result($resultID,0); // Anzahl der Bilder auslesen $resultID = mysql_query("SELECT COUNT(bild_id) FROM bild where bild_online != 0"); $bild_total = mysql_result($resultID,0); // Anzahl der Newsletterabonnenten auslesen $newsletterID = mysql_query("SELECT COUNT(nl_id) FROM nl where status = 1"); $newsletter_total = mysql_result($newsletterID,0); // Witze auslesen $query_witze = "SELECT witz_id, witz_text, witz_kategorie from witz where witz_id = '$witz_id'"; $result_witze = mysql_query($query_witze); //mysql_close(); if ($status == "senden") { if (($absendername != "") && ($absenderemail != "") && ($empfaengername != "") && ($empfaengeremail != "")) { // E-Mail--------------------- //Wird vom Formular ausgefuellt //Absender-Email $email_from_mail = $absenderemail; //Absender-Name $email_from_name = $absendername; //Absender-Email $email_to_mail = $empfaengeremail; //Absender-Name $email_to_name = $empfaengername; //Betreff in der Mail $email_betreff = "Lustiger Witz..."; //CC $witz = str_replace('\"','"',$witz); $email_to_cc=""; $header = "From:$email_from_name<$email_from_mail>\n"; $header .= "Cc: $email_to_cc\n"; $nachricht = "Hallo, ich habe auf http://www.spass-team.de folgenden Witz gefunden:\n"; $nachricht .= "-------------------------------\n\n"; $nachricht .= str_replace("\n","",$witz)."\n\n"; $nachricht .= "-------------------------------\n"; $nachricht .= "mehr Witze auf http://www.spass-team.de"; mail($email_to_mail,$email_betreff,$nachricht,$header); header("Location: http://www.spass-team.de/witze_senden_danke.php?kategorie=".$kategorie."&start=".$start."&limit=".$limit.""); } else { $fehler = "true"; } } echo ""; ?>