Revision 69 | Revision 80 | Zur aktuellen Revision | Blame | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed
<?// $URL: file:///svn/repos/webhosting/trunk/functions.php $ last modified in Revision $Rev: 79 $ by $Author: lars $ at $Date: 2008-08-08 20:08:31 +0200 (Fr, 08 Aug 2008) $mysql_connect("127.0.0.1","ltiefland","voyager");mysql_select_db("webhosting");require('Mail.php');require("Mail/mime.php");//function borrowed from/*Top-Side.de Php Domain Checker v1.1 pro - (C) 2005 by Top-Side.deDieses Script darf frei verwendet werden, solange dieser Text bestehen bleibt.*/function get_whois_server($domain){$whoisservers=array(array("de","whois.denic.de"),array("com","rs.internic.net"),array("net","rs.internic.net"),array("org","whois.pir.org"),array("info","whois.afilias.net"),array("biz","whois.biz"),array("at","whois.nic.at"),array("ch","whois.nic.ch"),array("li","whois.nic.ch"),array("co.uk","whois.nic.uk"),array("tv","whois.www.tv"),array("cc","whois.enic.cc"),array("dk","whois.dk-hostmaster.dk"),array("it","whois.nic.it"),array("ws","whois.worldsite.ws"));$whocnt = count($whoisservers);for ($x=0;$x<$whocnt;$x++){$artld = $whoisservers[$x][0];$tldlen = intval(0 - strlen($artld));if (substr($domain, $tldlen) == $artld) $whosrv = $whoisservers[$x][1];}return $whosrv;}//function borrowed from/*Top-Side.de Php Domain Checker v1.1 pro - (C) 2005 by Top-Side.deDieses Script darf frei verwendet werden, solange dieser Text bestehen bleibt.*/function lookup($dom){$lusrv = get_whois_server($dom);if (!$lusrv) return "";$fp = fsockopen($lusrv,43);if($lusrv == "whois.denic.de"){fputs($fp, "-C ISO-8859-1 -T ace,dn $dom\r\n");}else{fputs($fp, "$dom\r\n");}$string="";while(!feof($fp)){$string.= fgets($fp,128);}fclose($fp);$reg = "/Whois Server: (.*?)\n/i";preg_match_all($reg, $string, $matches);$secondtry = $matches[1][0];if ($secondtry){$fp = fsockopen($secondtry,43);fputs($fp, "$dom\r\n");$string="";while(!feof($fp)){$string.=fgets($fp,128);}fclose($fp);}if(ereg("(No match|No entries found|NOT FOUND|Not found|not found in database|We do not have an entry in our database matching your query)",$string)){return true;}else{return $string;}}function check_domain($domain, $vname, $nname){$string=lookup($domain);if ($string===true){return true;}else{if (strpos($string, $nname)!==false AND strpos($string, $vname)!==false){return true;}else{return false;}}}function speichern($name, $vname, $email, $domain, $emails, $email_type, $targets, $traffic, $os, $webmail, $forum, $copper, $svn, $admin_name, $admin_pw, $repo, $svn_users){$sql="";mysql_query("SET AUTOCOMMIT=0");mysql_query("START TRANSACTION");$sql="INSERT INTO kunden(nname,vname,email,domain,email_type,traffic)VALUES('$name','$vname','$email','$domain',$email_type,$traffic)";if(mysql_query($sql)){$k_id=sprintf("%03d",mysql_insert_id());$i=0;$sql="INSERT INTO software(k_id,system,webmail,forum,copper,svn,admin_name,admin_pw,repo_name)VALUES($k_id,$os,$webmail,$forum,$copper,$svn,'$admin_name','$admin_pw','$repo')";$res=mysql_query($sql);if ($res){$sql="INSERT INTO emails (k_id, email, target) VALUES ";foreach ($emails as $email){$target="";if ($email_type==0){if ($i < count($targets)){$target=$targets[$i];}else{$target=$target[count($targets)];}}$sql.="($k_id, '$email', '$target')";$i++;if($i<count($emails)){$sql.=", ";}}//SVN Repository wurde gebuchtif ($svn){if ($e_sql=mysql_query($sql)){$i=0;$sql="INSERT INTO svn_users (k_id, u_name, u_pw) VALUES ";foreach ($svn_users as $svn_user){$svn=explode("=",$svn_user);$user=trim($svn[0]);$pw=trim($svn[1]);$i++;$sql.="($k_id, '$user', '$pw')";if($i<count($svn_users)){$sql.=", ";}}}else{return false;}}if(mysql_query($sql)){return true;}else{return false;}}else{return false;}}else{return false;}}function generate_pdf_lt($k_id){$k_id=sprintf("%03d",$k_id);$sql="SELECT * FROM kunden WHERE k_id=$k_id";$res=mysql_query($sql);$row=mysql_fetch_assoc($res);$sql_e="SELECT * FROM emails WHERE k_id=$k_id";$sql_s="SELECT * FROM svn_users WHERE k_id=$k_id";$res_e=mysql_query($sql_e);$res_s=mysql_query($sql_s);$sql_w="SELECT * FROM software where k_id=$k_id";$res_w=mysql_query($sql_w);$row_w=mysql_fetch_assoc($res_w);while ($row_e=mysql_fetch_assoc($res_e)){$email_arr[]=$row_e["email"];$target_arr[]=$row_e["email"];}$email_anz=count($email_arr);while ($row_s=mysql_fetch_assoc($res_s)){$svn_user_arr[]=$row_s["u_name"]." = ".$row_s["u_pw"];}$k_name=$row["vname"]." ".$row["nname"];$pdf=PDF_new();if(!$pdf) return false;if(!PDF_begin_document($pdf, "pdf/Kunde_$k_id"."_lt.pdf","")) return false;if(!PDF_begin_page_ext($pdf, 595, 842, "")) return false;$font = PDF_load_font($pdf, "Helvetica-Bold", "winansi", "");PDF_setfont($pdf, $font, 10);$y=770;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Bestellung von $k_name auf http://webhosting.lars-tiefland.de");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "=======================================================");$y-=30;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Hallo,");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "dies sind die Daten, die $k_name bei seiner Bestllung eingegeben hat.");$y-=60;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Kundennummer: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $k_id);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Name: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row["nname"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Vorname: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row["vname"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "E-Mail: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row["email"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Domain: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row["domain"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Anzahl E-Mail Adressen: ");PDF_set_text_pos($pdf, 200, $y);$y-=10;PDF_show($pdf, $email_anz);PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "E-Mail Adressen: ");foreach($email_arr as $email){PDF_set_text_pos($pdf, 200, $y);PDF_Show($pdf, $email);$y-=10;}PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "E-Mail Typ: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, ($row["email_type"]==0)?"Weiterleitung":"POP3/IMAP Postfach");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Ziel Adressen: ");if ($row["email_type"]==0){foreach($target_arr as $target){PDF_set_text_pos($pdf, 200, $y);PDF_Show($pdf, $target);$y-=10;}}else{PDF_set_text_pos($pdf, 200, $y);PDF_Show($pdf, "Nicht nötig");$y-=10;}PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Traffic / Monat: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, number_format($row["traffic"],0,",",".")." GB");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Betriebssystem:");PDF_set_text_pos($pdf, 200, $y);switch($row_w["system"]){case 1:$os_text="Gentoo Linux 2007.0";break;case 2:$os_text="Debian 4.0 Etch";break;case 0:$os_text="Keines";break;}PDF_show($pdf, $os_text);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Webmail Interface:");PDF_set_text_pos($pdf, 200, $y);switch($row_w["webmail"]){case 1:$webmail_text="VWebmail";break;case 2:$webmail_text="Squirrelmail";break;case 0:$webmail_text="Keines";break;}PDF_show($pdf, $webmail_text);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Forum: ");PDF_set_text_pos($pdf, 200, $y);switch($row_w["forum"]){case 1:$f_text="phpBB";break;case 2:$f_text="SMF";break;case 0:$f_text="Keines";break;}PDF_show($pdf, "$f_text");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "coppermine Galerie: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, ($row_w["copper"])?"Ja":"Nein");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Subversion Repository: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, ($row_w["svn"])?"Ja":"Nein");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Admin Name: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row_w["admin_name"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Admin Passwort: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row_w["admin_pw"]);$y-=10;if($row_w["repo_name"]){PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Repository Name: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row_w["repo_name"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "SVN Benutzer: ");foreach($svn_user_arr as $svn_user){PDF_set_text_pos($pdf, 200, $y);PDF_Show($pdf, $svn_user);$y-=10;}}if(!PDF_end_page_ext($pdf,"")) return false;if(!PDF_end_document($pdf,"")) return false;return true;}function generate_pdf($k_id){$k_id=sprintf("%03d",$k_id);$sql="SELECT * FROM kunden WHERE k_id=$k_id";$res=mysql_query($sql);$row=mysql_fetch_assoc($res);$sql_e="SELECT * FROM emails WHERE k_id=$k_id";$sql_s="SELECT * FROM svn_users WHERE k_id=$k_id";$res_e=mysql_query($sql_e);$res_s=mysql_query($sql_s);$sql_w="SELECT * FROM software where k_id=$k_id";$res_w=mysql_query($sql_w);$row_w=mysql_fetch_assoc($res_w);while ($row_e=mysql_fetch_assoc($res_e)){$email_arr[]=$row_e["email"];$target_arr[]=$row_e["email"];}$email_anz=count($email_arr);while ($row_s=mysql_fetch_assoc($res_s)){$svn_user_arr[]=$row_s["u_name"]." = ".$row_s["u_pw"];}$k_name=$row["vname"]." ".$row["nname"];$pdf=PDF_new();if(!$pdf) return false;if(!PDF_begin_document($pdf, "pdf/Kunde_$k_id.pdf","")) return false;if(!PDF_begin_page_ext($pdf, 595, 842, "")) return false;$font = PDF_load_font($pdf, "Helvetica-Bold", "winansi", "");PDF_setfont($pdf, $font, 10);$y=770;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Deine Bestellung auf http://webhosting.lars-tiefland.de");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "=======================================================");$y-=30;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Hallo $k_name,");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "dies sind die Daten, die Du bei Deiner Bestllung eingegeben hast.");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Sollten Fehler enthalten sein, oder solltest Du weitere Angaben machen wollen, ");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "so schreibe bitte an order@lars-tiefland.de");$y-=30;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Kundennummer: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $k_id);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Name: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row["nname"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Vorname: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row["vname"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "E-Mail: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row["email"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Domain: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row["domain"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Anzahl E-Mail Adressen: ");PDF_set_text_pos($pdf, 200, $y);$y-=10;PDF_show($pdf, $email_anz);PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "E-Mail Adressen: ");foreach($email_arr as $email){PDF_set_text_pos($pdf, 200, $y);PDF_Show($pdf, $email);$y-=10;}PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "E-Mail Typ: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, ($row["email_type"]==0)?"Weiterleitung":"POP3/IMAP Postfach");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Ziel Adressen: ");if ($row["email_type"]==0){foreach($target_arr as $target){PDF_set_text_pos($pdf, 200, $y);PDF_Show($pdf, $target);$y-=10;}}else{PDF_set_text_pos($pdf, 200, $y);PDF_Show($pdf, "Nicht nötig");$y-=10;}PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Traffic / Monat: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, number_format($row["traffic"],0,",",".")." GB");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Betriebssystem:");PDF_set_text_pos($pdf, 200, $y);switch($row_w["system"]){case 1:$os_text="Gentoo Linux 2007.0";break;case 2:$os_text="Debian 4.0 Etch";break;case 0:$os_text="Keines";break;}PDF_show($pdf, $os_text);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Webmail Interface:");PDF_set_text_pos($pdf, 200, $y);switch($row_w["webmail"]){case 1:$webmail_text="VWebmail";break;case 2:$webmail_text="Squirrelmail";break;case 0:$webmail_text="Keines";break;}PDF_show($pdf, $webmail_text);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Forum: ");PDF_set_text_pos($pdf, 200, $y);switch($row_w["forum"]){case 1:$f_text="phpBB";break;case 2:$f_text="SMF";break;case 0:$f_text="Keines";break;}PDF_show($pdf, "$f_text");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "coppermine Galerie: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, ($row_w["copper"])?"Ja":"Nein");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Subversion Repository: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, ($row_w["svn"])?"Ja":"Nein");$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Admin Name: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row_w["admin_name"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Admin Passwort: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row_w["admin_pw"]);$y-=10;if($row_w["repo_name"]){PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "Repository Name: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row_w["repo_name"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "SVN Benutzer: ");foreach($svn_user_arr as $svn_user){PDF_set_text_pos($pdf, 200, $y);PDF_Show($pdf, $svn_user);$y-=10;}}if(!PDF_end_page_ext($pdf,"")) return false;if(!PDF_end_document($pdf,"")) return false;return true;}function send_email($k_id){$mime=new Mail_mime("\n");$email=Mail::factory("mail");$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";$res=mysql_query($sql);$row=mysql_fetch_assoc($res);$k_id=$row["k_id"];$html="";$filename="pdf/Kunde_$k_id.pdf";$k_name=$row["vname"]." ". $row["nname"];$k_email=$row["email"];$to="$k_name<$k_email>";if (file_exists($filename)){$mime->addAttachment($filename, "application/pdf");$text="Hallo $k_name, \r\n\r\n vielen Dank für Deine Bestellung auf http://webhosting.lars-tiefland.de!\r\n\r\n";$text.="Im Anhang findest Du Deine eingegeben Daten als PDF Datei!\r\n\r\nLive Long And Prosper,\r\n\r\nLars Tiefland\r\r\n";$hdrs["From"]="Bestellbestätigung<order@lars-tiefland.de>";$hdrs["Subject"]="Deine Bestellung ist eingegangen";$mime->setTXTBody($text);$mime->setHTMLBody($html);$body = $mime->get();$hdrs = $mime->headers($hdrs);$send=$email->send($to, $body);}else{$send=false;}return $send;}function send_order($k_id){$email=new mime_mail();$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";$res=mysql_query($sql);$row=mysql_fetch_assoc($res);$k_id=$row["k_id"];$filename="pdf/Kunde_$k_id"."_lt.pdf";$k_name=$row["vname"]." ". $row["nname"];$k_email=$row["email"];$email->to="Lars Tiefland<order@lars-tiefland.de>";$email->from="$k_name<$k_email>";if (file_exists($filename)){$fd = fopen($filename, "rb");$data = fread($fd, filesize($filename));fclose($fd);$email->body="Hallo Lars Tiefland, \r\n\r\n $k_name hat auf http://webhosting.lars-tiefland.de eine Bestellung aufgeben!\r\n\r\n";$email->body.="Im Anhang findest Du die vom Kunden eingegeben Daten als PDF Datei!\r\n\r\nLive Long And Prosper,\r\n\r\nLars Tiefland\r\r\n";$email->subject="Eine neue Bestellung ist eingegangen";$email->add_attachment($data, basename($filename));$send=$email->send();}else{$send=false;}return $send;}?>