Suchen nach:
Neueintrag bestätigen und abschließen
query($sqlQuery); $numberOfRows = mysqli_num_rows($result); if ($numberOfRows > 0) { $i = 0; while ($i < $numberOfRows) { $thisId = mysqli_result($result, $i, "id"); $thisTitel = mysqli_result($result, $i, "titel"); $thisBeschreibung = mysqli_result($result, $i, "beschreibung"); $thisKeywords = mysqli_result($result, $i, "keywords"); $thisEmail = mysqli_result($result, $i, "email"); $thisKategorie = mysqli_result($result, $i, "katagorie"); $thisUser_date_time = mysqli_result($result, $i, "user_date_time"); $thisUserID = mysqli_result($result, $i, "userID"); $thisUrl = mysqli_result($result, $i, "url"); ?>
Nachfolgend sehen Sie wie Ihr Eintrag bei uns aussehen wird.



" . $thisTitel . "
" . $thisBeschreibung . "
URL: " . $thisUrl . "
"; eintInKat($thisKategorie, $txt, $rewrite_mode); echo "

" . $txt['0044'] . "







" . $txt2['0001'] . "





"; $i++; } } else { echo $txt['0046']; } } elseif ($send == 2 && $send != 1) { $sql = "DELETE FROM neu_validate WHERE id = '$e' AND userID = '$ident' "; $result = $conn->query($sql); echo $txt2['0003'] . "


"; } else { $sqlQuery1 = "SELECT * FROM neu_validate WHERE userID = '$ident' AND id = '$e'"; $result1 = $conn->query($sqlQuery1); $numberOfRows1 = mysqli_num_rows($result1); if ($numberOfRows1 > 0) { $i = 0; while ($i < $numberOfRows1) { $thisId1 = mysqli_result($result1, $i, "id"); $thisTitel1 = mysqli_result($result1, $i, "titel"); $thisBeschreibung1 = mysqli_result($result1, $i, "beschreibung"); $thisKeywords1 = mysqli_result($result1, $i, "keywords"); $thisBenutzermail1 = mysqli_result($result1, $i, "email"); $thisKategorie1 = mysqli_result($result1, $i, "katagorie"); $thisUser_date_time1 = mysqli_result($result1, $i, "user_date_time"); $thisUserID1 = mysqli_result($result1, $i, "userID"); $thisUrl1 = mysqli_result($result1, $i, "url"); $i++; } if ($demomode != 1) { $eintmenge = $conn->query("SELECT COUNT(*) from eintraege WHERE url = '" . $thisUrl1 . "'"); $eintin = mysqli_result($eintmenge, 0, 0); if ($eintin != 0) { $check2 = "1"; echo $txt['0031']; $sql = "DELETE FROM neu_validate WHERE id = '$thisId1' AND userID = '$thisUserID1' "; $result = $conn->query($sql); } $in_val = $conn->query("SELECT COUNT(*) from validate WHERE url = '" . $thisUrl1 . "'"); $eintin_val = mysqli_result($in_val, 0, 0); if ($eintin_val != 0) { $check1 = "1"; echo $txt['0033']; $sql = "DELETE FROM neu_validate WHERE id = '$thisId1' AND userID = '$thisUserID1' "; $result = $conn->query($sql); } } } if ($check1 != 1 && $check2 != 1 && $numberOfRows1 > 0) { if ($letter_an == 1) { $eintmenge = $conn->query("SELECT COUNT(*) from newsletter WHERE newsmail = '$thisBenutzermail1'") or die('query error'); $eintgesamt = 0; $eintgesamt = mysqli_result($eintmenge, 0, 0); if ($eintgesamt == 0) { $sqlQueryx = "INSERT INTO newsletter (id , newsmail , user_date_time ) VALUES ('' , '$thisBenutzermail1' , '$thisUser_date_time1' )"; $resultx = $conn->query($sqlQueryx); } } if ($auto_freischalt == "nein") { echo $txt['0047']; $sqlQuery = "INSERT INTO validate (id , titel , beschreibung , keywords , email , katagorie , user_date_time , url ) VALUES ('' , '$thisTitel1' , '$thisBeschreibung1' , '$thisKeywords1' , '$thisEmail1' , '$thisKategorie1' , '$thisUser_date_time1' , '$thisUrl1' )"; $result = $conn->query($sqlQuery); $sql = "DELETE FROM neu_validate WHERE id = '$thisId1' AND userID = '$thisUserID1' "; $result = $conn->query($sql); } else { echo $txt['0048']; $freischaltbetreff = $mail_part[0]; $freischalttexttext = $mail_part[1]; $hostname = $_SERVER['HTTP_HOST']; $path = dirname($_SERVER['PHP_SELF']); $url_newsmail = urlencode($thisBenutzermail1); $thislink = 'http://' . $hostname . ($path == '/' ? '' : $path) . '/index.php?go=newsletter&newsmail=' . $url_newsmail; $thislink = trim($thislink); $thislink = str_replace(" ", "%20", $thislink); //echo $thislink; $freischalttexttext = str_replace("{URL}", $thisUrl1, $freischalttexttext); $freischalttexttext = str_replace("{TITEL}", $thisTitel1, $freischalttexttext); $freischalttexttext = str_replace("{BESCHREIBUNG}", $thisBeschreibung1, $freischalttexttext); $freischalttexttext = str_replace("{EMAIL}", $thisBenutzermail1, $freischalttexttext); $freischalttexttext = str_replace("{NEWSLETTERLINK}", $thislink, $freischalttexttext); @mail("$thisBenutzermail1", "$freischaltbetreff", "$freischalttexttext\n\n", "From: $systemmail"); $sqlQuery = "INSERT INTO eintraege (id , titel , beschreibung , url , keywords , kategorie , benutzermail , ip_date_time , top ) VALUES ('' , '$thisTitel1' , '$thisBeschreibung1' , '$thisUrl1' , '$thisKeywords1' , '$thisKategorie1' , '$thisBenutzermail1' , '$thisIp_date_time1', '')"; $result = $conn->query($sqlQuery); $sql = "DELETE FROM neu_validate WHERE id = '$thisId1' AND userID = '$thisUserID1' "; $result = $conn->query($sql); } } } ?>

Webtipps

Handy ohne Schufa

Gratis Erotikauktionshaus

Suchmaschine

SEO München

 

Ihr Link hier?

 



eteleon - mobile and more

Preisvergleich online



Valid XHTML 1.0 Transitional Valid CSS!