Subversion-Projekte lars-tiefland.webhosting

Revision

Revision 60 | Revision 69 | 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: 62 $ by $Author: lars $ at $Date: 2007-06-14 16:13:25 +0200 (Do, 14 Jun 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 
 
60 lars 114 
	function speichern($name, $vname, $email, $domain, $emails, $email_type, $targets, $space, $traffic, $db_anz, $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,
126 
			space,
127 
			traffic,
128 
			db_anz
129 
		)
130 
		VALUES
131 
		(
132 
			'$name',
133 
			'$vname',
134 
			'$email',
135 
			'$domain',
136 
			$email_type,
137 
			$space,
138 
			$traffic,
139 
			$db_anz
140 
		)";
1 lars 141 
		if(mysql_query($sql))
142 
		{
62 lars 143 
			$k_id=sprintf("%03d",mysql_insert_id());
1 lars 144 
			$i=0;
60 lars 145 
			$sql="INSERT INTO software
146 
			(
147 
				k_id,
62 lars 148 
				system,
60 lars 149 
				webmail,
150 
				forum,
151 
				copper,
152 
				svn,
153 
				admin_name,
154 
				admin_pw,
155 
				repo_name
156 
			)
157 
			VALUES
158 
			(
159 
				$k_id,
160 
				$os,
161 
				$webmail,
162 
				$forum,
163 
				$copper,
164 
				$svn,
165 
				'$admin_name',
166 
				'$admin_pw',
167 
				'$repo'
168 
			)";
1 lars 169 
			$res=mysql_query($sql);
170 
			if ($res)
171 
			{
172 
				$sql="INSERT INTO emails (k_id, email, target) VALUES ";
173 
				foreach ($emails as $email)
174 
				{
175 
					$target="";
176 
					if ($email_type==0)
177 
					{
178 
						if ($i < count($targets))
179 
						{
180 
							$target=$targets[$i];
181 
						}
182 
						else
183 
						{
184 
							$target=$target[count($targets)];
185 
						}
186 
					}
187 
					$sql.="($k_id, '$email', '$target')";
188 
					$i++;
189 
					if($i<count($emails))
190 
					{
191 
						$sql.=", ";
192 
					}
193 
				}
194 
				//SVN Repository wurde gebucht
195 
				if ($svn)
196 
				{
197 
					if ($e_sql=mysql_query($sql))
198 
					{
199 
						$i=0;
200 
						$sql="INSERT INTO svn_users (k_id, u_name, u_pw) VALUES ";
201 
						foreach ($svn_users as $svn_user)
202 
						{
203 
							$svn=explode("=",$svn_user);
204 
							$user=trim($svn[0]);
205 
							$pw=trim($svn[1]);
206 
							$i++;
207 
							$sql.="($k_id, '$user', '$pw')";
208 
							if($i<count($svn_users))
209 
							{
210 
								$sql.=", ";
211 
							}
212 
						}
213 
					}
214 
					else
215 
					{
216 
						return false;
217 
					}
218 
 
219 
				}
220 
				if(mysql_query($sql))
221 
				{
222 
					return true;
223 
				}
224 
				else
225 
				{
226 
					return false;
227 
				}
228 
			}
229 
			else
230 
			{
231 
				return false;
232 
			}
233 
		}
234 
		else
235 
		{
236 
			return false;
237 
		}
238 
	}
239 
 
37 lars 240 
	function generate_pdf_lt($k_id)
241 
	{
62 lars 242 
		$k_id=sprintf("%03d",$k_id);
37 lars 243 
		$sql="SELECT * FROM kunden WHERE k_id=$k_id";
244 
		$res=mysql_query($sql);
245 
		$row=mysql_fetch_assoc($res);
246 
		$sql_e="SELECT * FROM emails WHERE k_id=$k_id";
247 
		$sql_s="SELECT * FROM svn_users WHERE k_id=$k_id";
248 
		$res_e=mysql_query($sql_e);
249 
		$res_s=mysql_query($sql_s);
250 
		$sql_w="SELECT * FROM software where k_id=$k_id";
251 
		$res_w=mysql_query($sql_w);
252 
		$row_w=mysql_fetch_assoc($res_w);
253 
		while ($row_e=mysql_fetch_assoc($res_e))
254 
		{
255 
			$email_arr[]=$row_e["email"];
256 
			$target_arr[]=$row_e["email"];
257 
		}
258 
		$email_anz=count($email_arr);
259 
		while ($row_s=mysql_fetch_assoc($res_s))
260 
		{
261 
			$svn_user_arr[]=$row_s["u_name"]." = ".$row_s["u_pw"];
262 
		}
263 
		$k_name=$row["vname"]." ".$row["nname"];
264 
		$pdf=PDF_new();
265 
		if(!$pdf) return false;
266 
		if(!PDF_begin_document($pdf, "pdf/Kunde_$k_id"."_lt.pdf","")) return false;
267 
		if(!PDF_begin_page_ext($pdf, 595, 842, "")) return false;
268 
 
269 
		$font = PDF_load_font($pdf, "Helvetica-Bold", "winansi", "");
270 
 
271 
		PDF_setfont($pdf, $font, 10);
272 
		$y=770;
273 
		PDF_set_text_pos($pdf, 70, $y);
274 
		PDF_show($pdf, "Bestellung von $k_name auf http://webhosting.lars-tiefland.de");
275 
		$y-=10;
276 
		PDF_set_text_pos($pdf, 70, $y);
277 
		PDF_show($pdf, "=======================================================");
278 
		$y-=30;
279 
		PDF_set_text_pos($pdf, 70, $y);
280 
		PDF_show($pdf, "Hallo,");
281 
		$y-=10;
282 
		PDF_set_text_pos($pdf, 70, $y);
283 
		PDF_show($pdf, "dies sind die Daten, die $k_name bei seiner Bestllung eingegeben hat.");
39 lars 284 
		$y-=60;
37 lars 285 
		PDF_set_text_pos($pdf, 70, $y);
286 
		PDF_show($pdf, "Kundennummer: ");
287 
		PDF_set_text_pos($pdf, 200, $y);
288 
		PDF_show($pdf, $k_id);
289 
		$y-=10;
290 
		PDF_set_text_pos($pdf, 70, $y);
291 
		PDF_show($pdf, "Name: ");
292 
		PDF_set_text_pos($pdf, 200, $y);
293 
		PDF_show($pdf, $row["nname"]);
294 
		$y-=10;
295 
		PDF_set_text_pos($pdf, 70, $y);
296 
		PDF_show($pdf, "Vorname: ");
297 
		PDF_set_text_pos($pdf, 200, $y);
298 
		PDF_show($pdf, $row["vname"]);
299 
		$y-=10;
300 
		PDF_set_text_pos($pdf, 70, $y);
301 
		PDF_show($pdf, "E-Mail: ");
302 
		PDF_set_text_pos($pdf, 200, $y);
303 
		PDF_show($pdf, $row["email"]);
304 
		$y-=10;
305 
		PDF_set_text_pos($pdf, 70, $y);
306 
		PDF_show($pdf, "Domain: ");
307 
		PDF_set_text_pos($pdf, 200, $y);
308 
		PDF_show($pdf, $row["domain"]);
309 
		$y-=10;
310 
		PDF_set_text_pos($pdf, 70, $y);
311 
		PDF_show($pdf, "Anzahl E-Mail Adressen: ");
312 
		PDF_set_text_pos($pdf, 200, $y);
313 
		$y-=10;
314 
		PDF_show($pdf, $email_anz);
315 
		PDF_set_text_pos($pdf, 70, $y);
316 
		PDF_show($pdf, "E-Mail Adressen: ");
317 
		foreach($email_arr as $email)
318 
		{
319 
			PDF_set_text_pos($pdf, 200, $y);
320 
			PDF_Show($pdf, $email);
321 
			$y-=10;
322 
		}
323 
		PDF_set_text_pos($pdf, 70, $y);
324 
		PDF_show($pdf, "E-Mail Typ: ");
325 
		PDF_set_text_pos($pdf, 200, $y);
326 
		PDF_show($pdf, ($row["email_type"]==0)?"Weiterleitung":"POP3/IMAP Postfach");
327 
		$y-=10;
328 
		PDF_set_text_pos($pdf, 70, $y);
329 
		PDF_show($pdf, "Ziel Adressen: ");
330 
		if ($row["email_type"]==0)
331 
		{
332 
			foreach($target_arr as $target)
333 
			{
334 
				PDF_set_text_pos($pdf, 200, $y);
335 
				PDF_Show($pdf, $target);
336 
				$y-=10;
337 
			}
338 
		}
339 
		else
340 
		{
341 
			PDF_set_text_pos($pdf, 200, $y);
342 
			PDF_Show($pdf, "Nicht nötig");
343 
			$y-=10;
344 
		}
345 
		PDF_set_text_pos($pdf, 70, $y);
346 
		PDF_show($pdf, "Webspace: ");
347 
		PDF_set_text_pos($pdf, 200, $y);
348 
		PDF_show($pdf, number_format($row["space"],0,",",".")." MB");
349 
		$y-=10;
350 
		PDF_set_text_pos($pdf, 70, $y);
351 
		PDF_show($pdf, "Traffic / Monat: ");
352 
		PDF_set_text_pos($pdf, 200, $y);
353 
		PDF_show($pdf, number_format($row["traffic"],0,",",".")." GB");
354 
		$y-=10;
355 
		PDF_set_text_pos($pdf, 70, $y);
356 
		PDF_show($pdf, "Anzahl Datenbanken: ");
357 
		PDF_set_text_pos($pdf, 200, $y);
358 
		PDF_show($pdf, $row["db_anz"]);
359 
		$y-=10;
360 
		PDF_set_text_pos($pdf, 70, $y);
60 lars 361 
		PDF_show($pdf, "Betriebssystem:");
362 
		PDF_set_text_pos($pdf, 200, $y);
62 lars 363 
		switch($row_w["system"])
60 lars 364 
		{
365 
			case 1:
366 
				$os_text="Gentoo Linux 2007.0";
367 
				break;
368 
			case 2:
369 
				$os_text="Debian 4.0 Etch";
370 
				break;
371 
			case 0:
372 
				$os_text="Keines";
373 
				break;
374 
		}
375 
		PDF_show($pdf, $os_text);
376 
		$y-=10;
377 
		PDF_set_text_pos($pdf, 70, $y);
37 lars 378 
		PDF_show($pdf, "Webmail Interface:");
379 
		PDF_set_text_pos($pdf, 200, $y);
380 
		switch($row_w["webmail"])
381 
		{
382 
			case 1:
383 
				$webmail_text="VWebmail";
384 
				break;
385 
			case 2:
386 
				$webmail_text="Squirrelmail";
387 
				break;
388 
			case 0:
389 
				$webmail_text="Keines";
390 
				break;
391 
		}
392 
		PDF_show($pdf, $webmail_text);
393 
		$y-=10;
394 
		PDF_set_text_pos($pdf, 70, $y);
395 
		PDF_show($pdf, "Forum: ");
396 
		PDF_set_text_pos($pdf, 200, $y);
397 
		switch($row_w["forum"])
398 
		{
399 
			case 1:
400 
				$f_text="phpBB";
401 
				break;
402 
			case 2:
403 
				$f_text="SMF";
404 
				break;
405 
			case 0:
406 
				$f_text="Keines";
407 
				break;
408 
		}
409 
		PDF_show($pdf, "$f_text");
410 
		$y-=10;
411 
		PDF_set_text_pos($pdf, 70, $y);
412 
		PDF_show($pdf, "coppermine Galerie: ");
413 
		PDF_set_text_pos($pdf, 200, $y);
414 
		PDF_show($pdf, ($row_w["copper"])?"Ja":"Nein");
415 
		$y-=10;
416 
		PDF_set_text_pos($pdf, 70, $y);
417 
		PDF_show($pdf, "Subversion Repository: ");
418 
		PDF_set_text_pos($pdf, 200, $y);
419 
		PDF_show($pdf, ($row_w["svn"])?"Ja":"Nein");
420 
		$y-=10;
421 
		PDF_set_text_pos($pdf, 70, $y);
422 
		PDF_show($pdf, "Admin Name: ");
423 
		PDF_set_text_pos($pdf, 200, $y);
424 
		PDF_show($pdf, $row_w["admin_name"]);
425 
		$y-=10;
426 
		PDF_set_text_pos($pdf, 70, $y);
427 
		PDF_show($pdf, "Admin Passwort: ");
428 
		PDF_set_text_pos($pdf, 200, $y);
429 
		PDF_show($pdf, $row_w["admin_pw"]);
430 
		$y-=10;
431 
		if($row_w["repo_name"])
432 
		{
433 
			PDF_set_text_pos($pdf, 70, $y);
434 
			PDF_show($pdf, "Repository Name: ");
435 
			PDF_set_text_pos($pdf, 200, $y);
436 
			PDF_show($pdf, $row_w["repo_name"]);
437 
			$y-=10;
438 
			PDF_set_text_pos($pdf, 70, $y);
439 
			PDF_show($pdf, "SVN Benutzer: ");
440 
			foreach($svn_user_arr as $svn_user)
441 
			{
442 
				PDF_set_text_pos($pdf, 200, $y);
443 
				PDF_Show($pdf, $svn_user);
444 
				$y-=10;
445 
			}
446 
		}
447 
		if(!PDF_end_page_ext($pdf,"")) return false;
448 
		if(!PDF_end_document($pdf,"")) return false;
449 
		return true;
450 
	}
1 lars 451 
	function generate_pdf($k_id)
452 
	{
62 lars 453 
		$k_id=sprintf("%03d",$k_id);
1 lars 454 
		$sql="SELECT * FROM kunden WHERE k_id=$k_id";
455 
		$res=mysql_query($sql);
456 
		$row=mysql_fetch_assoc($res);
457 
		$sql_e="SELECT * FROM emails WHERE k_id=$k_id";
458 
		$sql_s="SELECT * FROM svn_users WHERE k_id=$k_id";
459 
		$res_e=mysql_query($sql_e);
460 
		$res_s=mysql_query($sql_s);
4 lars 461 
		$sql_w="SELECT * FROM software where k_id=$k_id";
1 lars 462 
		$res_w=mysql_query($sql_w);
463 
		$row_w=mysql_fetch_assoc($res_w);
464 
		while ($row_e=mysql_fetch_assoc($res_e))
465 
		{
466 
			$email_arr[]=$row_e["email"];
467 
			$target_arr[]=$row_e["email"];
468 
		}
469 
		$email_anz=count($email_arr);
470 
		while ($row_s=mysql_fetch_assoc($res_s))
471 
		{
472 
			$svn_user_arr[]=$row_s["u_name"]." = ".$row_s["u_pw"];
473 
		}
474 
		$k_name=$row["vname"]." ".$row["nname"];
475 
		$pdf=PDF_new();
476 
		if(!$pdf) return false;
33 lars 477 
		if(!PDF_begin_document($pdf, "pdf/Kunde_$k_id.pdf","")) return false;
1 lars 478 
		if(!PDF_begin_page_ext($pdf, 595, 842, "")) return false;
479 
 
480 
		$font = PDF_load_font($pdf, "Helvetica-Bold", "winansi", "");
481 
 
482 
		PDF_setfont($pdf, $font, 10);
483 
		$y=770;
484 
		PDF_set_text_pos($pdf, 70, $y);
485 
		PDF_show($pdf, "Deine Bestellung auf http://webhosting.lars-tiefland.de");
486 
		$y-=10;
487 
		PDF_set_text_pos($pdf, 70, $y);
488 
		PDF_show($pdf, "=======================================================");
489 
		$y-=30;
490 
		PDF_set_text_pos($pdf, 70, $y);
491 
		PDF_show($pdf, "Hallo $k_name,");
492 
		$y-=10;
493 
		PDF_set_text_pos($pdf, 70, $y);
494 
		PDF_show($pdf, "dies sind die Daten, die Du bei Deiner Bestllung eingegeben hast.");
495 
		$y-=10;
496 
		PDF_set_text_pos($pdf, 70, $y);
497 
		PDF_show($pdf, "Sollten Fehler enthalten sein, oder solltest Du weitere Angaben machen wollen, ");
498 
		$y-=10;
499 
		PDF_set_text_pos($pdf, 70, $y);
500 
		PDF_show($pdf, "so schreibe bitte an order@lars-tiefland.de");
501 
		$y-=30;
502 
		PDF_set_text_pos($pdf, 70, $y);
503 
		PDF_show($pdf, "Kundennummer: ");
504 
		PDF_set_text_pos($pdf, 200, $y);
505 
		PDF_show($pdf, $k_id);
506 
		$y-=10;
507 
		PDF_set_text_pos($pdf, 70, $y);
508 
		PDF_show($pdf, "Name: ");
509 
		PDF_set_text_pos($pdf, 200, $y);
510 
		PDF_show($pdf, $row["nname"]);
511 
		$y-=10;
512 
		PDF_set_text_pos($pdf, 70, $y);
513 
		PDF_show($pdf, "Vorname: ");
514 
		PDF_set_text_pos($pdf, 200, $y);
515 
		PDF_show($pdf, $row["vname"]);
516 
		$y-=10;
517 
		PDF_set_text_pos($pdf, 70, $y);
518 
		PDF_show($pdf, "E-Mail: ");
519 
		PDF_set_text_pos($pdf, 200, $y);
520 
		PDF_show($pdf, $row["email"]);
521 
		$y-=10;
522 
		PDF_set_text_pos($pdf, 70, $y);
523 
		PDF_show($pdf, "Domain: ");
524 
		PDF_set_text_pos($pdf, 200, $y);
525 
		PDF_show($pdf, $row["domain"]);
526 
		$y-=10;
527 
		PDF_set_text_pos($pdf, 70, $y);
528 
		PDF_show($pdf, "Anzahl E-Mail Adressen: ");
529 
		PDF_set_text_pos($pdf, 200, $y);
530 
		$y-=10;
531 
		PDF_show($pdf, $email_anz);
532 
		PDF_set_text_pos($pdf, 70, $y);
533 
		PDF_show($pdf, "E-Mail Adressen: ");
534 
		foreach($email_arr as $email)
535 
		{
536 
			PDF_set_text_pos($pdf, 200, $y);
537 
			PDF_Show($pdf, $email);
538 
			$y-=10;
539 
		}
540 
		PDF_set_text_pos($pdf, 70, $y);
541 
		PDF_show($pdf, "E-Mail Typ: ");
542 
		PDF_set_text_pos($pdf, 200, $y);
543 
		PDF_show($pdf, ($row["email_type"]==0)?"Weiterleitung":"POP3/IMAP Postfach");
544 
		$y-=10;
545 
		PDF_set_text_pos($pdf, 70, $y);
546 
		PDF_show($pdf, "Ziel Adressen: ");
547 
		if ($row["email_type"]==0)
548 
		{
549 
			foreach($target_arr as $target)
550 
			{
551 
				PDF_set_text_pos($pdf, 200, $y);
552 
				PDF_Show($pdf, $target);
553 
				$y-=10;
554 
			}
555 
		}
556 
		else
557 
		{
558 
			PDF_set_text_pos($pdf, 200, $y);
559 
			PDF_Show($pdf, "Nicht nötig");
560 
			$y-=10;
561 
		}
562 
		PDF_set_text_pos($pdf, 70, $y);
563 
		PDF_show($pdf, "Webspace: ");
564 
		PDF_set_text_pos($pdf, 200, $y);
565 
		PDF_show($pdf, number_format($row["space"],0,",",".")." MB");
566 
		$y-=10;
567 
		PDF_set_text_pos($pdf, 70, $y);
568 
		PDF_show($pdf, "Traffic / Monat: ");
569 
		PDF_set_text_pos($pdf, 200, $y);
570 
		PDF_show($pdf, number_format($row["traffic"],0,",",".")." GB");
571 
		$y-=10;
572 
		PDF_set_text_pos($pdf, 70, $y);
573 
		PDF_show($pdf, "Anzahl Datenbanken: ");
574 
		PDF_set_text_pos($pdf, 200, $y);
575 
		PDF_show($pdf, $row["db_anz"]);
576 
		$y-=10;
577 
		PDF_set_text_pos($pdf, 70, $y);
60 lars 578 
		PDF_show($pdf, "Betriebssystem:");
579 
		PDF_set_text_pos($pdf, 200, $y);
62 lars 580 
		switch($row_w["system"])
60 lars 581 
		{
582 
			case 1:
583 
				$os_text="Gentoo Linux 2007.0";
584 
				break;
585 
			case 2:
586 
				$os_text="Debian 4.0 Etch";
587 
				break;
588 
			case 0:
589 
				$os_text="Keines";
590 
				break;
591 
		}
592 
		PDF_show($pdf, $os_text);
593 
		$y-=10;
594 
		PDF_set_text_pos($pdf, 70, $y);
20 lars 595 
		PDF_show($pdf, "Webmail Interface:");
19 lars 596 
		PDF_set_text_pos($pdf, 200, $y);
33 lars 597 
		switch($row_w["webmail"])
598 
		{
599 
			case 1:
600 
				$webmail_text="VWebmail";
601 
				break;
602 
			case 2:
603 
				$webmail_text="Squirrelmail";
604 
				break;
605 
			case 0:
606 
				$webmail_text="Keines";
607 
				break;
608 
		}
609 
		PDF_show($pdf, $webmail_text);
19 lars 610 
		$y-=10;
611 
		PDF_set_text_pos($pdf, 70, $y);
33 lars 612 
		PDF_show($pdf, "Forum: ");
1 lars 613 
		PDF_set_text_pos($pdf, 200, $y);
33 lars 614 
		switch($row_w["forum"])
615 
		{
616 
			case 1:
617 
				$f_text="phpBB";
618 
				break;
619 
			case 2:
620 
				$f_text="SMF";
621 
				break;
622 
			case 0:
623 
				$f_text="Keines";
624 
				break;
625 
		}
626 
		PDF_show($pdf, "$f_text");
1 lars 627 
		$y-=10;
628 
		PDF_set_text_pos($pdf, 70, $y);
629 
		PDF_show($pdf, "coppermine Galerie: ");
630 
		PDF_set_text_pos($pdf, 200, $y);
631 
		PDF_show($pdf, ($row_w["copper"])?"Ja":"Nein");
632 
		$y-=10;
633 
		PDF_set_text_pos($pdf, 70, $y);
634 
		PDF_show($pdf, "Subversion Repository: ");
635 
		PDF_set_text_pos($pdf, 200, $y);
636 
		PDF_show($pdf, ($row_w["svn"])?"Ja":"Nein");
637 
		$y-=10;
638 
		PDF_set_text_pos($pdf, 70, $y);
639 
		PDF_show($pdf, "Admin Name: ");
640 
		PDF_set_text_pos($pdf, 200, $y);
641 
		PDF_show($pdf, $row_w["admin_name"]);
642 
		$y-=10;
643 
		PDF_set_text_pos($pdf, 70, $y);
644 
		PDF_show($pdf, "Admin Passwort: ");
645 
		PDF_set_text_pos($pdf, 200, $y);
646 
		PDF_show($pdf, $row_w["admin_pw"]);
647 
		$y-=10;
33 lars 648 
		if($row_w["repo_name"])
1 lars 649 
		{
33 lars 650 
			PDF_set_text_pos($pdf, 70, $y);
651 
			PDF_show($pdf, "Repository Name: ");
1 lars 652 
			PDF_set_text_pos($pdf, 200, $y);
33 lars 653 
			PDF_show($pdf, $row_w["repo_name"]);
1 lars 654 
			$y-=10;
33 lars 655 
			PDF_set_text_pos($pdf, 70, $y);
656 
			PDF_show($pdf, "SVN Benutzer: ");
657 
			foreach($svn_user_arr as $svn_user)
658 
			{
659 
				PDF_set_text_pos($pdf, 200, $y);
660 
				PDF_Show($pdf, $svn_user);
661 
				$y-=10;
662 
			}
1 lars 663 
		}
664 
		if(!PDF_end_page_ext($pdf,"")) return false;
665 
		if(!PDF_end_document($pdf,"")) return false;
666 
		return true;
667 
	}
668 
 
669 
	function send_email($k_id)
670 
	{
671 
		$email=new mime_mail();
672 
		$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";
673 
		$res=mysql_query($sql);
674 
		$row=mysql_fetch_assoc($res);
675 
		$k_id=$row["k_id"];
33 lars 676 
		$filename="pdf/Kunde_$k_id.pdf";
1 lars 677 
		$k_name=$row["vname"]." ". $row["nname"];
678 
		$k_email=$row["email"];
679 
		$email->to="$k_name<$k_email>";
33 lars 680 
		$email->from="Bestellbestätigung<order@lars-tiefland.de>";
1 lars 681 
		if (file_exists($filename))
682 
		{
683 
			$fd = fopen($filename, "rb");
684 
			$data = fread($fd, filesize($filename));
685 
			fclose($fd);
686 
			$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";
687 
			$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";
688 
			$email->subject="Deine Bestellung ist eingegangen";
33 lars 689 
			$email->add_attachment($data, basename($filename));
1 lars 690 
			$send=$email->send();
691 
		}
692 
		else
693 
		{
694 
			$send=false;
695 
		}
696 
		return $send;
697 
	}
698 
 
699 
	function send_order($k_id)
700 
	{
701 
		$email=new mime_mail();
702 
		$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";
703 
		$res=mysql_query($sql);
704 
		$row=mysql_fetch_assoc($res);
705 
		$k_id=$row["k_id"];
37 lars 706 
		$filename="pdf/Kunde_$k_id"."_lt.pdf";
1 lars 707 
		$k_name=$row["vname"]." ". $row["nname"];
708 
		$k_email=$row["email"];
709 
		$email->to="Lars Tiefland<order@lars-tiefland.de>";
38 lars 710 
		$email->from="$k_name<$k_email>";
1 lars 711 
		if (file_exists($filename))
712 
		{
713 
			$fd = fopen($filename, "rb");
714 
			$data = fread($fd, filesize($filename));
715 
			fclose($fd);
4 lars 716 
			$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 717 
			$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";
718 
			$email->subject="Eine neue Bestellung ist eingegangen";
33 lars 719 
			$email->add_attachment($data, basename($filename));
1 lars 720 
			$send=$email->send();
721 
		}
722 
		else
723 
		{
724 
			$send=false;
725 
		}
726 
		return $send;
727 
	}
728 
?>