Revision 4 | Zur aktuellen Revision | Blame | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed
<?require('mime_mail.php');mysql_connect("localhost","ltiefland","voyager");mysql_select_db("webhosting");function speichern($name, $vname, $email, $domain, $emails, $email_type, $targets, $space, $traffic, $db_anz, $phpbb, $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, space, traffic, db_anz) VALUES ('$name', '$vname', '$email', '$domain', $email_type, $space, $traffic, $db_anz)";if(mysql_query($sql)){$k_id=sprintf("%011d",mysql_insert_id());$i=0;$sql="INSERT INTO sofware (k_id, phpbb, copper, svn, admin_name, admin_pw, repo_name) VALUES ($phpbb, $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($k_id){$k_id=sprintf("%011d",$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 sofware 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, "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, "Webspace: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, number_format($row["space"],0,",",".")." MB");$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, "Anzahl Datenbanken: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, $row["db_anz"]);$y-=10;PDF_set_text_pos($pdf, 70, $y);PDF_show($pdf, "phpBB Forum: ");PDF_set_text_pos($pdf, 200, $y);PDF_show($pdf, ($row_w["phpbb"])?"Ja":"Nein");$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;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"]);$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){$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="Kunde_$k_id.pdf";$k_name=$row["vname"]." ". $row["nname"];$k_email=$row["email"];$email->to="$k_name<$k_email>";$email->from="order@lars-tiefland.de";if (file_exists($filename)){$fd = fopen($filename, "rb");$data = fread($fd, filesize($filename));fclose($fd);$email->body="Hallo $k_name, \r\n\r\n vielen Dank für Deine Bestellung auf http://webhosting.lars-tiefland.de!\r\n\r\n";$email->body.="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";$email->subject="Deine Bestellung ist eingegangen";$email->add_attachment($data, $filename);$send=$email->send();}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="Kunde_$k_id.pdf";$k_name=$row["vname"]." ". $row["nname"];$k_email=$row["email"];$email->to="Lars Tiefland<order@lars-tiefland.de>";$email->from="order@lars-tiefland.de";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 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, $filename);$send=$email->send();}else{$send=false;}return $send;}?>