Subversion-Projekte lars-tiefland.webhosting

Revision

Revision 79 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?
33 lars 2 
	// $URL: file:///svn/repos/webhosting/trunk/functions.php $ last modified in Revision $Rev: 80 $ by $Author: lars $ at $Date: 2008-08-08 20:13:01 +0200 (Fr, 08 Aug 2008) $
36 lars 3 
	mysql_connect("127.0.0.1","ltiefland","voyager");
1 lars 4 
	mysql_select_db("webhosting");
16 lars 5 
 
79 lars 6 
	require('Mail.php');
7 
	require("Mail/mime.php");
16 lars 8 
 
9 
	//function borrowed from
10 
	/*
11 
	Top-Side.de Php Domain Checker v1.1 pro - (C) 2005 by Top-Side.de
12 
 
13 
	Dieses Script darf frei verwendet werden, solange dieser Text bestehen bleibt.
14 
	*/
15 
 
16 
	function get_whois_server($domain)
17 
	{
18 
		$whoisservers=array(
19 
			array("de","whois.denic.de"),
20 
			array("com","rs.internic.net"),
21 
			array("net","rs.internic.net"),
22 
			array("org","whois.pir.org"),
23 
			array("info","whois.afilias.net"),
24 
			array("biz","whois.biz"),
25 
			array("at","whois.nic.at"),
26 
			array("ch","whois.nic.ch"),
27 
			array("li","whois.nic.ch"),
28 
			array("co.uk","whois.nic.uk"),
29 
			array("tv","whois.www.tv"),
30 
			array("cc","whois.enic.cc"),
31 
			array("dk","whois.dk-hostmaster.dk"),
32 
			array("it","whois.nic.it"),
33 
			array("ws","whois.worldsite.ws")
34 
		);
35 
		$whocnt = count($whoisservers);
36 
		for ($x=0;$x<$whocnt;$x++)
37 
		{
38 
			$artld = $whoisservers[$x][0];
39 
			$tldlen = intval(0 - strlen($artld));
40 
			if (substr($domain, $tldlen) == $artld) $whosrv = $whoisservers[$x][1];
41 
		}
42 
		return $whosrv;
43 
	}
44 
 
45 
	//function borrowed from
46 
	/*
47 
	Top-Side.de Php Domain Checker v1.1 pro - (C) 2005 by Top-Side.de
48 
 
49 
	Dieses Script darf frei verwendet werden, solange dieser Text bestehen bleibt.
50 
	*/
51 
 
52 
	function lookup($dom)
53 
	{
54 
		$lusrv = get_whois_server($dom);
55 
		if (!$lusrv) return "";
56 
		$fp = fsockopen($lusrv,43);
57 
		if($lusrv == "whois.denic.de")
58 
		{
59 
			fputs($fp, "-C ISO-8859-1 -T ace,dn $dom\r\n");
60 
		}
61 
		else
62 
		{
63 
			fputs($fp, "$dom\r\n");
64 
		}
65 
		$string="";
66 
		while(!feof($fp))
67 
		{
68 
			$string.= fgets($fp,128);
69 
		}
70 
		fclose($fp);
71 
		$reg = "/Whois Server: (.*?)\n/i";
72 
		preg_match_all($reg, $string, $matches);
73 
		$secondtry = $matches[1][0];
74 
		if ($secondtry)
75 
		{
76 
			$fp = fsockopen($secondtry,43);
77 
			fputs($fp, "$dom\r\n");
78 
			$string="";
79 
			while(!feof($fp))
80 
			{
81 
				$string.=fgets($fp,128);
82 
			}
83 
			fclose($fp);
84 
		}
17 lars 85 
		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))
86 
		{
87 
			return true;
88 
		}
89 
		else
90 
		{
91 
			return $string;
92 
		}
16 lars 93 
	}
94 
 
95 
	function check_domain($domain, $vname, $nname)
96 
	{
97 
		$string=lookup($domain);
98 
		if ($string===true)
99 
		{
100 
			return true;
101 
		}
102 
		else
103 
		{
104 
			if (strpos($string, $nname)!==false AND strpos($string, $vname)!==false)
105 
			{
106 
				return true;
107 
			}
108 
			else
109 
			{
110 
				return false;
111 
			}
112 
		}
113 
	}
114 
 
69 lars 115 
	function speichern($name, $vname, $email, $domain, $emails, $email_type, $targets, $traffic, $os, $webmail, $forum, $copper, $svn, $admin_name, $admin_pw, $repo, $svn_users)
1 lars 116 
	{
117 
		$sql="";
118 
		mysql_query("SET AUTOCOMMIT=0");
119 
		mysql_query("START TRANSACTION");
60 lars 120 
		$sql="INSERT INTO kunden
121 
		(
122 
			nname,
123 
			vname,
124 
			email,
125 
			domain,
126 
			email_type,
69 lars 127 
			traffic
60 lars 128 
		)
129 
		VALUES
130 
		(
131 
			'$name',
132 
			'$vname',
133 
			'$email',
134 
			'$domain',
135 
			$email_type,
69 lars 136 
			$traffic
60 lars 137 
		)";
1 lars 138 
		if(mysql_query($sql))
139 
		{
62 lars 140 
			$k_id=sprintf("%03d",mysql_insert_id());
1 lars 141 
			$i=0;
60 lars 142 
			$sql="INSERT INTO software
143 
			(
144 
				k_id,
62 lars 145 
				system,
60 lars 146 
				webmail,
147 
				forum,
148 
				copper,
149 
				svn,
150 
				admin_name,
151 
				admin_pw,
152 
				repo_name
153 
			)
154 
			VALUES
155 
			(
156 
				$k_id,
157 
				$os,
158 
				$webmail,
159 
				$forum,
160 
				$copper,
161 
				$svn,
162 
				'$admin_name',
163 
				'$admin_pw',
164 
				'$repo'
165 
			)";
1 lars 166 
			$res=mysql_query($sql);
167 
			if ($res)
168 
			{
169 
				$sql="INSERT INTO emails (k_id, email, target) VALUES ";
170 
				foreach ($emails as $email)
171 
				{
172 
					$target="";
173 
					if ($email_type==0)
174 
					{
175 
						if ($i < count($targets))
176 
						{
177 
							$target=$targets[$i];
178 
						}
179 
						else
180 
						{
181 
							$target=$target[count($targets)];
182 
						}
183 
					}
184 
					$sql.="($k_id, '$email', '$target')";
185 
					$i++;
186 
					if($i<count($emails))
187 
					{
188 
						$sql.=", ";
189 
					}
190 
				}
191 
				//SVN Repository wurde gebucht
192 
				if ($svn)
193 
				{
194 
					if ($e_sql=mysql_query($sql))
195 
					{
196 
						$i=0;
197 
						$sql="INSERT INTO svn_users (k_id, u_name, u_pw) VALUES ";
198 
						foreach ($svn_users as $svn_user)
199 
						{
200 
							$svn=explode("=",$svn_user);
201 
							$user=trim($svn[0]);
202 
							$pw=trim($svn[1]);
203 
							$i++;
204 
							$sql.="($k_id, '$user', '$pw')";
205 
							if($i<count($svn_users))
206 
							{
207 
								$sql.=", ";
208 
							}
209 
						}
210 
					}
211 
					else
212 
					{
213 
						return false;
214 
					}
215 
 
216 
				}
217 
				if(mysql_query($sql))
218 
				{
219 
					return true;
220 
				}
221 
				else
222 
				{
223 
					return false;
224 
				}
225 
			}
226 
			else
227 
			{
228 
				return false;
229 
			}
230 
		}
231 
		else
232 
		{
233 
			return false;
234 
		}
235 
	}
236 
 
37 lars 237 
	function generate_pdf_lt($k_id)
238 
	{
62 lars 239 
		$k_id=sprintf("%03d",$k_id);
37 lars 240 
		$sql="SELECT * FROM kunden WHERE k_id=$k_id";
241 
		$res=mysql_query($sql);
242 
		$row=mysql_fetch_assoc($res);
243 
		$sql_e="SELECT * FROM emails WHERE k_id=$k_id";
244 
		$sql_s="SELECT * FROM svn_users WHERE k_id=$k_id";
245 
		$res_e=mysql_query($sql_e);
246 
		$res_s=mysql_query($sql_s);
247 
		$sql_w="SELECT * FROM software where k_id=$k_id";
248 
		$res_w=mysql_query($sql_w);
249 
		$row_w=mysql_fetch_assoc($res_w);
250 
		while ($row_e=mysql_fetch_assoc($res_e))
251 
		{
252 
			$email_arr[]=$row_e["email"];
253 
			$target_arr[]=$row_e["email"];
254 
		}
255 
		$email_anz=count($email_arr);
256 
		while ($row_s=mysql_fetch_assoc($res_s))
257 
		{
258 
			$svn_user_arr[]=$row_s["u_name"]." = ".$row_s["u_pw"];
259 
		}
260 
		$k_name=$row["vname"]." ".$row["nname"];
261 
		$pdf=PDF_new();
262 
		if(!$pdf) return false;
263 
		if(!PDF_begin_document($pdf, "pdf/Kunde_$k_id"."_lt.pdf","")) return false;
264 
		if(!PDF_begin_page_ext($pdf, 595, 842, "")) return false;
265 
 
266 
		$font = PDF_load_font($pdf, "Helvetica-Bold", "winansi", "");
267 
 
268 
		PDF_setfont($pdf, $font, 10);
269 
		$y=770;
270 
		PDF_set_text_pos($pdf, 70, $y);
271 
		PDF_show($pdf, "Bestellung von $k_name auf http://webhosting.lars-tiefland.de");
272 
		$y-=10;
273 
		PDF_set_text_pos($pdf, 70, $y);
274 
		PDF_show($pdf, "=======================================================");
275 
		$y-=30;
276 
		PDF_set_text_pos($pdf, 70, $y);
277 
		PDF_show($pdf, "Hallo,");
278 
		$y-=10;
279 
		PDF_set_text_pos($pdf, 70, $y);
280 
		PDF_show($pdf, "dies sind die Daten, die $k_name bei seiner Bestllung eingegeben hat.");
39 lars 281 
		$y-=60;
37 lars 282 
		PDF_set_text_pos($pdf, 70, $y);
283 
		PDF_show($pdf, "Kundennummer: ");
284 
		PDF_set_text_pos($pdf, 200, $y);
285 
		PDF_show($pdf, $k_id);
286 
		$y-=10;
287 
		PDF_set_text_pos($pdf, 70, $y);
288 
		PDF_show($pdf, "Name: ");
289 
		PDF_set_text_pos($pdf, 200, $y);
290 
		PDF_show($pdf, $row["nname"]);
291 
		$y-=10;
292 
		PDF_set_text_pos($pdf, 70, $y);
293 
		PDF_show($pdf, "Vorname: ");
294 
		PDF_set_text_pos($pdf, 200, $y);
295 
		PDF_show($pdf, $row["vname"]);
296 
		$y-=10;
297 
		PDF_set_text_pos($pdf, 70, $y);
298 
		PDF_show($pdf, "E-Mail: ");
299 
		PDF_set_text_pos($pdf, 200, $y);
300 
		PDF_show($pdf, $row["email"]);
301 
		$y-=10;
302 
		PDF_set_text_pos($pdf, 70, $y);
303 
		PDF_show($pdf, "Domain: ");
304 
		PDF_set_text_pos($pdf, 200, $y);
305 
		PDF_show($pdf, $row["domain"]);
306 
		$y-=10;
307 
		PDF_set_text_pos($pdf, 70, $y);
308 
		PDF_show($pdf, "Anzahl E-Mail Adressen: ");
309 
		PDF_set_text_pos($pdf, 200, $y);
310 
		$y-=10;
311 
		PDF_show($pdf, $email_anz);
312 
		PDF_set_text_pos($pdf, 70, $y);
313 
		PDF_show($pdf, "E-Mail Adressen: ");
314 
		foreach($email_arr as $email)
315 
		{
316 
			PDF_set_text_pos($pdf, 200, $y);
317 
			PDF_Show($pdf, $email);
318 
			$y-=10;
319 
		}
320 
		PDF_set_text_pos($pdf, 70, $y);
321 
		PDF_show($pdf, "E-Mail Typ: ");
322 
		PDF_set_text_pos($pdf, 200, $y);
323 
		PDF_show($pdf, ($row["email_type"]==0)?"Weiterleitung":"POP3/IMAP Postfach");
324 
		$y-=10;
325 
		PDF_set_text_pos($pdf, 70, $y);
326 
		PDF_show($pdf, "Ziel Adressen: ");
327 
		if ($row["email_type"]==0)
328 
		{
329 
			foreach($target_arr as $target)
330 
			{
331 
				PDF_set_text_pos($pdf, 200, $y);
332 
				PDF_Show($pdf, $target);
333 
				$y-=10;
334 
			}
335 
		}
336 
		else
337 
		{
338 
			PDF_set_text_pos($pdf, 200, $y);
339 
			PDF_Show($pdf, "Nicht nötig");
340 
			$y-=10;
341 
		}
342 
		PDF_set_text_pos($pdf, 70, $y);
343 
		PDF_show($pdf, "Traffic / Monat: ");
344 
		PDF_set_text_pos($pdf, 200, $y);
345 
		PDF_show($pdf, number_format($row["traffic"],0,",",".")." GB");
346 
		$y-=10;
347 
		PDF_set_text_pos($pdf, 70, $y);
60 lars 348 
		PDF_show($pdf, "Betriebssystem:");
349 
		PDF_set_text_pos($pdf, 200, $y);
62 lars 350 
		switch($row_w["system"])
60 lars 351 
		{
352 
			case 1:
353 
				$os_text="Gentoo Linux 2007.0";
354 
				break;
355 
			case 2:
356 
				$os_text="Debian 4.0 Etch";
357 
				break;
358 
			case 0:
359 
				$os_text="Keines";
360 
				break;
361 
		}
362 
		PDF_show($pdf, $os_text);
363 
		$y-=10;
364 
		PDF_set_text_pos($pdf, 70, $y);
37 lars 365 
		PDF_show($pdf, "Webmail Interface:");
366 
		PDF_set_text_pos($pdf, 200, $y);
367 
		switch($row_w["webmail"])
368 
		{
369 
			case 1:
370 
				$webmail_text="VWebmail";
371 
				break;
372 
			case 2:
373 
				$webmail_text="Squirrelmail";
374 
				break;
375 
			case 0:
376 
				$webmail_text="Keines";
377 
				break;
378 
		}
379 
		PDF_show($pdf, $webmail_text);
380 
		$y-=10;
381 
		PDF_set_text_pos($pdf, 70, $y);
382 
		PDF_show($pdf, "Forum: ");
383 
		PDF_set_text_pos($pdf, 200, $y);
384 
		switch($row_w["forum"])
385 
		{
386 
			case 1:
387 
				$f_text="phpBB";
388 
				break;
389 
			case 2:
390 
				$f_text="SMF";
391 
				break;
392 
			case 0:
393 
				$f_text="Keines";
394 
				break;
395 
		}
396 
		PDF_show($pdf, "$f_text");
397 
		$y-=10;
398 
		PDF_set_text_pos($pdf, 70, $y);
399 
		PDF_show($pdf, "coppermine Galerie: ");
400 
		PDF_set_text_pos($pdf, 200, $y);
401 
		PDF_show($pdf, ($row_w["copper"])?"Ja":"Nein");
402 
		$y-=10;
403 
		PDF_set_text_pos($pdf, 70, $y);
404 
		PDF_show($pdf, "Subversion Repository: ");
405 
		PDF_set_text_pos($pdf, 200, $y);
406 
		PDF_show($pdf, ($row_w["svn"])?"Ja":"Nein");
407 
		$y-=10;
408 
		PDF_set_text_pos($pdf, 70, $y);
409 
		PDF_show($pdf, "Admin Name: ");
410 
		PDF_set_text_pos($pdf, 200, $y);
411 
		PDF_show($pdf, $row_w["admin_name"]);
412 
		$y-=10;
413 
		PDF_set_text_pos($pdf, 70, $y);
414 
		PDF_show($pdf, "Admin Passwort: ");
415 
		PDF_set_text_pos($pdf, 200, $y);
416 
		PDF_show($pdf, $row_w["admin_pw"]);
417 
		$y-=10;
418 
		if($row_w["repo_name"])
419 
		{
420 
			PDF_set_text_pos($pdf, 70, $y);
421 
			PDF_show($pdf, "Repository Name: ");
422 
			PDF_set_text_pos($pdf, 200, $y);
423 
			PDF_show($pdf, $row_w["repo_name"]);
424 
			$y-=10;
425 
			PDF_set_text_pos($pdf, 70, $y);
426 
			PDF_show($pdf, "SVN Benutzer: ");
427 
			foreach($svn_user_arr as $svn_user)
428 
			{
429 
				PDF_set_text_pos($pdf, 200, $y);
430 
				PDF_Show($pdf, $svn_user);
431 
				$y-=10;
432 
			}
433 
		}
434 
		if(!PDF_end_page_ext($pdf,"")) return false;
435 
		if(!PDF_end_document($pdf,"")) return false;
436 
		return true;
437 
	}
1 lars 438 
	function generate_pdf($k_id)
439 
	{
62 lars 440 
		$k_id=sprintf("%03d",$k_id);
1 lars 441 
		$sql="SELECT * FROM kunden WHERE k_id=$k_id";
442 
		$res=mysql_query($sql);
443 
		$row=mysql_fetch_assoc($res);
444 
		$sql_e="SELECT * FROM emails WHERE k_id=$k_id";
445 
		$sql_s="SELECT * FROM svn_users WHERE k_id=$k_id";
446 
		$res_e=mysql_query($sql_e);
447 
		$res_s=mysql_query($sql_s);
4 lars 448 
		$sql_w="SELECT * FROM software where k_id=$k_id";
1 lars 449 
		$res_w=mysql_query($sql_w);
450 
		$row_w=mysql_fetch_assoc($res_w);
451 
		while ($row_e=mysql_fetch_assoc($res_e))
452 
		{
453 
			$email_arr[]=$row_e["email"];
454 
			$target_arr[]=$row_e["email"];
455 
		}
456 
		$email_anz=count($email_arr);
457 
		while ($row_s=mysql_fetch_assoc($res_s))
458 
		{
459 
			$svn_user_arr[]=$row_s["u_name"]." = ".$row_s["u_pw"];
460 
		}
461 
		$k_name=$row["vname"]." ".$row["nname"];
462 
		$pdf=PDF_new();
463 
		if(!$pdf) return false;
33 lars 464 
		if(!PDF_begin_document($pdf, "pdf/Kunde_$k_id.pdf","")) return false;
1 lars 465 
		if(!PDF_begin_page_ext($pdf, 595, 842, "")) return false;
466 
 
467 
		$font = PDF_load_font($pdf, "Helvetica-Bold", "winansi", "");
468 
 
469 
		PDF_setfont($pdf, $font, 10);
470 
		$y=770;
471 
		PDF_set_text_pos($pdf, 70, $y);
472 
		PDF_show($pdf, "Deine Bestellung auf http://webhosting.lars-tiefland.de");
473 
		$y-=10;
474 
		PDF_set_text_pos($pdf, 70, $y);
475 
		PDF_show($pdf, "=======================================================");
476 
		$y-=30;
477 
		PDF_set_text_pos($pdf, 70, $y);
478 
		PDF_show($pdf, "Hallo $k_name,");
479 
		$y-=10;
480 
		PDF_set_text_pos($pdf, 70, $y);
481 
		PDF_show($pdf, "dies sind die Daten, die Du bei Deiner Bestllung eingegeben hast.");
482 
		$y-=10;
483 
		PDF_set_text_pos($pdf, 70, $y);
484 
		PDF_show($pdf, "Sollten Fehler enthalten sein, oder solltest Du weitere Angaben machen wollen, ");
485 
		$y-=10;
486 
		PDF_set_text_pos($pdf, 70, $y);
487 
		PDF_show($pdf, "so schreibe bitte an order@lars-tiefland.de");
488 
		$y-=30;
489 
		PDF_set_text_pos($pdf, 70, $y);
490 
		PDF_show($pdf, "Kundennummer: ");
491 
		PDF_set_text_pos($pdf, 200, $y);
492 
		PDF_show($pdf, $k_id);
493 
		$y-=10;
494 
		PDF_set_text_pos($pdf, 70, $y);
495 
		PDF_show($pdf, "Name: ");
496 
		PDF_set_text_pos($pdf, 200, $y);
497 
		PDF_show($pdf, $row["nname"]);
498 
		$y-=10;
499 
		PDF_set_text_pos($pdf, 70, $y);
500 
		PDF_show($pdf, "Vorname: ");
501 
		PDF_set_text_pos($pdf, 200, $y);
502 
		PDF_show($pdf, $row["vname"]);
503 
		$y-=10;
504 
		PDF_set_text_pos($pdf, 70, $y);
505 
		PDF_show($pdf, "E-Mail: ");
506 
		PDF_set_text_pos($pdf, 200, $y);
507 
		PDF_show($pdf, $row["email"]);
508 
		$y-=10;
509 
		PDF_set_text_pos($pdf, 70, $y);
510 
		PDF_show($pdf, "Domain: ");
511 
		PDF_set_text_pos($pdf, 200, $y);
512 
		PDF_show($pdf, $row["domain"]);
513 
		$y-=10;
514 
		PDF_set_text_pos($pdf, 70, $y);
515 
		PDF_show($pdf, "Anzahl E-Mail Adressen: ");
516 
		PDF_set_text_pos($pdf, 200, $y);
517 
		$y-=10;
518 
		PDF_show($pdf, $email_anz);
519 
		PDF_set_text_pos($pdf, 70, $y);
520 
		PDF_show($pdf, "E-Mail Adressen: ");
521 
		foreach($email_arr as $email)
522 
		{
523 
			PDF_set_text_pos($pdf, 200, $y);
524 
			PDF_Show($pdf, $email);
525 
			$y-=10;
526 
		}
527 
		PDF_set_text_pos($pdf, 70, $y);
528 
		PDF_show($pdf, "E-Mail Typ: ");
529 
		PDF_set_text_pos($pdf, 200, $y);
530 
		PDF_show($pdf, ($row["email_type"]==0)?"Weiterleitung":"POP3/IMAP Postfach");
531 
		$y-=10;
532 
		PDF_set_text_pos($pdf, 70, $y);
533 
		PDF_show($pdf, "Ziel Adressen: ");
534 
		if ($row["email_type"]==0)
535 
		{
536 
			foreach($target_arr as $target)
537 
			{
538 
				PDF_set_text_pos($pdf, 200, $y);
539 
				PDF_Show($pdf, $target);
540 
				$y-=10;
541 
			}
542 
		}
543 
		else
544 
		{
545 
			PDF_set_text_pos($pdf, 200, $y);
546 
			PDF_Show($pdf, "Nicht nötig");
547 
			$y-=10;
548 
		}
549 
		PDF_set_text_pos($pdf, 70, $y);
550 
		PDF_show($pdf, "Traffic / Monat: ");
551 
		PDF_set_text_pos($pdf, 200, $y);
552 
		PDF_show($pdf, number_format($row["traffic"],0,",",".")." GB");
553 
		$y-=10;
554 
		PDF_set_text_pos($pdf, 70, $y);
60 lars 555 
		PDF_show($pdf, "Betriebssystem:");
556 
		PDF_set_text_pos($pdf, 200, $y);
62 lars 557 
		switch($row_w["system"])
60 lars 558 
		{
559 
			case 1:
560 
				$os_text="Gentoo Linux 2007.0";
561 
				break;
562 
			case 2:
563 
				$os_text="Debian 4.0 Etch";
564 
				break;
565 
			case 0:
566 
				$os_text="Keines";
567 
				break;
568 
		}
569 
		PDF_show($pdf, $os_text);
570 
		$y-=10;
571 
		PDF_set_text_pos($pdf, 70, $y);
20 lars 572 
		PDF_show($pdf, "Webmail Interface:");
19 lars 573 
		PDF_set_text_pos($pdf, 200, $y);
33 lars 574 
		switch($row_w["webmail"])
575 
		{
576 
			case 1:
577 
				$webmail_text="VWebmail";
578 
				break;
579 
			case 2:
580 
				$webmail_text="Squirrelmail";
581 
				break;
582 
			case 0:
583 
				$webmail_text="Keines";
584 
				break;
585 
		}
586 
		PDF_show($pdf, $webmail_text);
19 lars 587 
		$y-=10;
588 
		PDF_set_text_pos($pdf, 70, $y);
33 lars 589 
		PDF_show($pdf, "Forum: ");
1 lars 590 
		PDF_set_text_pos($pdf, 200, $y);
33 lars 591 
		switch($row_w["forum"])
592 
		{
593 
			case 1:
594 
				$f_text="phpBB";
595 
				break;
596 
			case 2:
597 
				$f_text="SMF";
598 
				break;
599 
			case 0:
600 
				$f_text="Keines";
601 
				break;
602 
		}
603 
		PDF_show($pdf, "$f_text");
1 lars 604 
		$y-=10;
605 
		PDF_set_text_pos($pdf, 70, $y);
606 
		PDF_show($pdf, "coppermine Galerie: ");
607 
		PDF_set_text_pos($pdf, 200, $y);
608 
		PDF_show($pdf, ($row_w["copper"])?"Ja":"Nein");
609 
		$y-=10;
610 
		PDF_set_text_pos($pdf, 70, $y);
611 
		PDF_show($pdf, "Subversion Repository: ");
612 
		PDF_set_text_pos($pdf, 200, $y);
613 
		PDF_show($pdf, ($row_w["svn"])?"Ja":"Nein");
614 
		$y-=10;
615 
		PDF_set_text_pos($pdf, 70, $y);
616 
		PDF_show($pdf, "Admin Name: ");
617 
		PDF_set_text_pos($pdf, 200, $y);
618 
		PDF_show($pdf, $row_w["admin_name"]);
619 
		$y-=10;
620 
		PDF_set_text_pos($pdf, 70, $y);
621 
		PDF_show($pdf, "Admin Passwort: ");
622 
		PDF_set_text_pos($pdf, 200, $y);
623 
		PDF_show($pdf, $row_w["admin_pw"]);
624 
		$y-=10;
33 lars 625 
		if($row_w["repo_name"])
1 lars 626 
		{
33 lars 627 
			PDF_set_text_pos($pdf, 70, $y);
628 
			PDF_show($pdf, "Repository Name: ");
1 lars 629 
			PDF_set_text_pos($pdf, 200, $y);
33 lars 630 
			PDF_show($pdf, $row_w["repo_name"]);
1 lars 631 
			$y-=10;
33 lars 632 
			PDF_set_text_pos($pdf, 70, $y);
633 
			PDF_show($pdf, "SVN Benutzer: ");
634 
			foreach($svn_user_arr as $svn_user)
635 
			{
636 
				PDF_set_text_pos($pdf, 200, $y);
637 
				PDF_Show($pdf, $svn_user);
638 
				$y-=10;
639 
			}
1 lars 640 
		}
641 
		if(!PDF_end_page_ext($pdf,"")) return false;
642 
		if(!PDF_end_document($pdf,"")) return false;
643 
		return true;
644 
	}
645 
 
646 
	function send_email($k_id)
647 
	{
79 lars 648 
		$mime=new Mail_mime("\n");
649 
		$email=Mail::factory("mail");
1 lars 650 
		$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";
651 
		$res=mysql_query($sql);
652 
		$row=mysql_fetch_assoc($res);
653 
		$k_id=$row["k_id"];
79 lars 654 
		$html="";
33 lars 655 
		$filename="pdf/Kunde_$k_id.pdf";
1 lars 656 
		$k_name=$row["vname"]." ". $row["nname"];
657 
		$k_email=$row["email"];
79 lars 658 
		$to="$k_name<$k_email>";
1 lars 659 
		if (file_exists($filename))
660 
		{
79 lars 661 
			$mime->addAttachment($filename, "application/pdf");
662 
			$text="Hallo $k_name, \r\n\r\n vielen Dank für Deine Bestellung auf http://webhosting.lars-tiefland.de!\r\n\r\n";
663 
			$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";
664 
			$hdrs["From"]="Bestellbestätigung<order@lars-tiefland.de>";
665 
			$hdrs["Subject"]="Deine Bestellung ist eingegangen";
666 
 
667 
			$mime->setTXTBody($text);
668 
			$mime->setHTMLBody($html);
669 
			$body = $mime->get();
670 
			$hdrs = $mime->headers($hdrs);
80 lars 671 
			$send=$email->send($to, $hdrs, $body);
1 lars 672 
		}
673 
		else
674 
		{
675 
			$send=false;
676 
		}
677 
		return $send;
678 
	}
679 
 
680 
	function send_order($k_id)
681 
	{
80 lars 682 
		$mime=new Mail_mime("\n");
683 
		$email=Mail::factory("mail");
1 lars 684 
		$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";
685 
		$res=mysql_query($sql);
686 
		$row=mysql_fetch_assoc($res);
687 
		$k_id=$row["k_id"];
37 lars 688 
		$filename="pdf/Kunde_$k_id"."_lt.pdf";
1 lars 689 
		$k_name=$row["vname"]." ". $row["nname"];
690 
		$k_email=$row["email"];
80 lars 691 
		$html="";
692 
		$to="Lars Tiefland<order@lars-tiefland.de>";
693 
		$from="$k_name<$k_email>";
1 lars 694 
		if (file_exists($filename))
695 
		{
80 lars 696 
			$mime->addAttachment($filename, "application/pdf");
697 
			$text="Hallo Lars Tiefland, \r\n\r\n $k_name hat auf http://webhosting.lars-tiefland.de eine Bestellung aufgeben!\r\n\r\n";
698 
			$text.="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";
699 
			$hdrs["From"]=$from;
700 
			$hdrs["Subject"]="Eine neue Bestellung ist eingegangen";
701 
			$send=$email->send($to, $hdrs, $body);
1 lars 702 
		}
703 
		else
704 
		{
705 
			$send=false;
706 
		}
707 
		return $send;
708 
	}
709 
?>