Subversion-Projekte lars-tiefland.webhosting

Revision

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