$root = "../"; $rubrik = "gaestebuch"; $content = "content.php"; include($root."common/opendb.php"); $fehler = ""; $tabelle = "gaestebuch"; $nichtEinzutragendeFelder = array("submit","textNull"); if (isset($_POST['submit'])) { if (empty($_POST['name'])) $fehler .= "
  • Bitte einen Namen eingeben.
  • "; if (empty($_POST['text'])) $fehler .= "
  • Bitte einen Text eingeben.
  • "; if (!empty($_POST['textNull'])) { $fehler .= "
  • Das Feld muss leer bleiben.
  • "; //mail("patrick@artalacarte.de","Oysterinfo","Feld wurde ausgefüllt:\n\n".$_POST['textNull']); } if (strstr(strtolower($_POST['text']),"[url")) $fehler .= "
  • Der Eintrag enthält die unerlaubte Zeichenkette '[URL'.
  • "; if (strstr(strtolower($_POST['text'])," 751) $fehler .= "
  • Text zu lang!
  • "; if (strstr(strtolower($_POST['email']),"google.com")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['email']),"hotmail.com")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['email']),"tesy")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['email']),"sve@yandex.com")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['email']),"sveta@yandex.com")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['email']),"Kilkoi")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['email']),"sjd.com")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['email']),"vasya")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"phentermine")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"viagra")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"tramadol")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"hillary")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"helga")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"britney")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"lippa")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"valium")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"bush")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"soma")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"buy")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"xanax")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"levitra")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"sveta")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"bill")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"adipex")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"propecia")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"vilyi")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"vasya")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['name']),"name")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"%2")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"indymedia")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"teen")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"pics")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"video")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"sex")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"xanax")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"levitra")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"kama")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"sutra")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"tarot")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://30mg")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://viilu.in")) $fehler .= "
  • SSPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"thecity")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"fora.pl")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"acholia.cn")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"abstaining.cn")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"acedronoles.cn")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"buy")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"vigora")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"flanger.cn")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"acholuric.cn")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"deictic.cn")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"valtrex")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"herpes")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"acedronole.cn")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"phentermine")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"health")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"viagra")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"10top.com")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"sildenafil")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"pills")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"anniston.cn")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"search1top.com")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"news-auto")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"syrette.cn")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"meds")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"soma")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"sale")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"alanyadance")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),".cn")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"ashep")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"wikipatterns")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"zonap2p")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"simplyfired")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"islamonline")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"dontstayin")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"testriffic")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://a")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://b")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://c")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://d")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://e")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://f")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://g")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://h")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://i")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://j")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://k")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://l")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://m")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://n")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://o")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://p")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://q")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://r")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://s")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://t")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://u")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://v")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://x")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://y")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://z")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wa")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wb")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wc")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wd")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://we")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wf")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wg")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wh")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wi")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wj")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wk")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wl")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wm")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wn")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wo")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wp")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wq")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wr")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://ws")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wt")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wu")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wv")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wx")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wy")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://wz")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://1")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://2")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://3")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://4")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://5")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://6")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://7")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://8")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://9")) $fehler .= "
  • SPAM-Verdacht!
  • "; if (strstr(strtolower($_POST['homepage']),"http://0")) $fehler .= "
  • SPAM-Verdacht!
  • "; } if (isset($_POST['submit']) && empty($fehler)) { $_POST['datum'] = date("Y-m-d H:i:s"); // Formuarfeld-Namen und zugehörige Werte herausfinden $feldNamen = array(); $feldWerte = array(); for($x=0;$x
    ALTER TABLE `".$tabelle."` ADD `".$_POST['autoSpaltenTyp']."` ".$_POST['autoSpalte']." NOT NULL ;"; mysql_query("ALTER TABLE `".$tabelle."` ADD `".$_POST['autoSpalte']."` ".$_POST['autoSpaltenTyp']." NOT NULL ;",$verbindung) or die (mysql_error()); } // -------- ENDE Automatismen zur Tabellenverwaltung ------------------ include($root."common/frame.php"); ?>