\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"
$text
Error:$errornr
Warnung:$msg
\n"; echo"

\n"; exit; } function echoError($text) { echo"
"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"
Warnung:$text
\n"; echo"

\n"; } function connect() { global $MYSQL_HOST, $MYSQL_USER, $MYSQL_PASS, $MYSQL_BASE; $temp = mysql_connect($MYSQL_HOST,$MYSQL_USER,$MYSQL_PASS); if(!$temp) { $this->error("Keine Verbindung zur Datenbank!\n"); return false; } $this->link = $temp; $temp = @mysql_select_db($MYSQL_BASE,$temp); if( !$temp ) { $this->error("Keine datenbank gefunden! - >".$MYSQL_BASE."\n"); return false; } return $this->link; } function query($sql) { if(!$this->link) { $this->error("Keine Abfrage bekommen!\n"); } if($this->resid) { @mysql_free_result($this->resid); } $result = mysql_query($sql,$this->link); if(!$result) { $this->error("Sql Syntax ist falsch! -> ".$sql."\n"); } $this->resid = $result; return $result; } function addUser($nl_name, $nl_email) { global $nl_main_table, $nl_archive_table, $adminInform, $userInform, $webmasterMail, $webmasterUrl; $this->query("SELECT name FROM ".$nl_main_table." WHERE email = '$nl_email'"); list($name) = $this->data(); if($name) { return $name; } else { $this->query("INSERT INTO ".$nl_main_table." (email, name, date) VALUES ('$nl_email', '$nl_name', NOW())"); if($adminInform == true) { mail($webmasterMail,"Neuer Newsletter Interessent!","Ein neu angemeldeter Benutzer wurde im Newsletter registriert:\n\nBenutzer: $nl_name\nEmail: $nl_email\n\n$webmasterUrl","From: $webmasterMail"); } if($userInform == true) { mail($nl_email,"Herzlich Willkommen!","Sie haben sich auf $webmasterUrl mit folgenden Daten beim Newsletter eingetragen:\n\nBenutzer: $nl_name\nEmail: $nl_email\n\nVielen Dank für das Interesse!\n\n$webmasterUrl","From: $webmasterMail"); } } } function removeUser($nl_name, $nl_email) { global $nl_main_table, $nl_archive_table, $adminInform, $userInform, $webmasterMail, $webmasterUrl; $this->query("SELECT name, email FROM ".$nl_main_table." WHERE name = '$nl_name' AND email = '$nl_email'"); list($name, $email) = $this->data(); if($name != "" && $email != "") { $this->query("DELETE FROM ".$nl_main_table." WHERE name = '$nl_name' AND email = '$nl_email'"); if($adminInform == true) { mail($webmasterMail,"Ein Newsletter Interessent weniger!","Ein Benutzer hat sich vom Newsletter abgemeldet:\n\nBenutzer: $nl_name\nEmail:$nl_email\n\n$webmasterUrl","From: $webmasterMail"); } if($userInform == true) { mail($nl_email,"Auf Wiedersehen!","Sie haben sich auf $webmasterUrl erfolgreich, mit folgenden Daten, vom Newsletter abgemeldet:\n\nBenutzer: $nl_name\nEmail: $nl_email\n\nVielen Dank und auf ein Wiedersehen!\n\n$webmasterUrl","From: $webmasterMail"); } } else { return $nl_email; } } function verteiler($subject, $mailtext) { global $nl_main_table, $signature, $webmasterMail, $anrede, $bccCount; ini_set('max_execution_time',500); $this->query("SELECT email FROM ".$nl_main_table.""); $mailtext = stripslashes(trim($mailtext."\n\n----\n".$signature)); //$anrede.",\n\n". vor Mailtext $subject = stripslashes(trim($subject)); if($bccCount > mysql_affected_rows()) { $bccCount = mysql_affected_rows(); } $phronk = $bccCount; $i=1; while((list($email) = $this->data())) { $mailUser .= "$email, "; if($i==$bccCount) { $count += 1; $header = "From: $webmasterMail\nBcc: $mailUser"; $header = substr($header,0,-2); mail($webmasterMail,$subject,$mailtext,$header); unset($mailUser); $bccCount+=$phronk; } $i++; } if($mailUser != NULL) { $count += 1; $mailUser = substr($mailUser,0,-2); $header = "From: $webmasterMail\nBcc: $mailUser"; mail($webmasterMail,$subject,$mailtext,$header); } return $count; } function numRows($sql) { $number = mysql_num_rows($this->query($sql)); return $number; } function data() { if(!$this->link) { $this->error("Keine Abfrage bekommen!\n"); } if(!$this->resid) { $this->error("Sql Syntax Fehler!\n"); } $result = @mysql_fetch_array($this->resid, MYSQL_BOTH); return $result; } function firstPage($page, $anzahlEnt, $bool) { if($bool == false) { $ausgabe = "archive"; } else { $ausgabe = "main"; } if($page <= $anzahlEnt) { return "«"; }else{ return "«"; } } function lastPage($page, $show, $bool) { if($bool == false) { $ausgabe = "archive"; } else { $ausgabe = "main"; } if ($page != $show ) { return "»"; } else { return "»"; } } function nlSeiten($position, $durchlauf, $show, $page, $bool) { if($bool == false) { $ausgabe = "archive"; } else { $ausgabe = "main"; } for ($i = $position; $i <= $durchlauf; $i++) { if($i>=0) { if($i==0) { $position = 0; } if($i==$show) { $durchlauf = $show; } $urlA = $i+1; if($i == $page) { $urlA = "$urlA"; } if($page == $i) { $c = "randfarbe1"; }else{ $c = "randfarbe"; } $entrySeiten .= "$urlA "; } } return $entrySeiten; } function position($count_entries, $bis, $von) { if ($count_entries < $bis) { $t1 = $von; return $t1; } else { $t1= $von; return $t1; } } function nl_mysql_db() { $this->connect(); } } $nl_mysql_db = new nl_mysql_db; class nl_functions { function gettemplate($template,$endung="html") { $data = str_replace("\"","\\\"",implode("",file($template.".".$endung))); if(!$data) { nl_mysql_db::echoError("Template Datei fehlt!"); } return $data; } function cut($post) { preg_match_all("/(.*)/isU",$post,$ma); for ($i = 0; $i < count($ma[0]); $i++) { $cut[$i] = $ma[0][$i]; } return $cut; } function template($datei) { $noob = nl_functions::gettemplate($datei); $cut = nl_functions::cut($noob); $cut = str_replace("","",$cut); $cut = str_replace("","",$cut); return $cut; } function validEmail($nl_email) { $validEmail = '^[a-z0-9_\.-]+@[a-z0-9_-]+\.[a-z0-9_\.-]+$'; if (!(eregi($validEmail,$nl_email)) || !isset($nl_email)) { return false; } return true; } function validName($nl_name) { global $maxNameLen; if(strlen($nl_name) > $maxNameLen || $nl_name=="") { return false; } return true; } function menu() { global $menuhoverColor, $menubgColor; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
 
\n"; echo "
\n"; } function getUsers() { global $knl_version; echo "\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
\n"; echo " \"Knusperleicht$knl_version © 2004
\n"; echo "\n"; } } $nl_fc = new nl_functions; ?>