Subversion-Projekte lars-tiefland.webhosting

Revision

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

Revision Autor Zeilennr. Zeile
1 lars 1 
<?
2 
	mysql_connect("localhost","ltiefland","voyager");
3 
	mysql_select_db("webhosting");
16 lars 4 
 
5 
	require('mime_mail.php');
6 
 
7 
	//function borrowed from
8 
	/*
9 
	Top-Side.de Php Domain Checker v1.1 pro - (C) 2005 by Top-Side.de
10 
 
11 
	Dieses Script darf frei verwendet werden, solange dieser Text bestehen bleibt.
12 
	*/
13 
 
14 
	function get_whois_server($domain)
15 
	{
16 
		$whoisservers=array(
17 
			array("de","whois.denic.de"),
18 
			array("com","rs.internic.net"),
19 
			array("net","rs.internic.net"),
20 
			array("org","whois.pir.org"),
21 
			array("info","whois.afilias.net"),
22 
			array("biz","whois.biz"),
23 
			array("at","whois.nic.at"),
24 
			array("ch","whois.nic.ch"),
25 
			array("li","whois.nic.ch"),
26 
			array("co.uk","whois.nic.uk"),
27 
			array("tv","whois.www.tv"),
28 
			array("cc","whois.enic.cc"),
29 
			array("dk","whois.dk-hostmaster.dk"),
30 
			array("it","whois.nic.it"),
31 
			array("ws","whois.worldsite.ws")
32 
		);
33 
		$whocnt = count($whoisservers);
34 
		for ($x=0;$x<$whocnt;$x++)
35 
		{
36 
			$artld = $whoisservers[$x][0];
37 
			$tldlen = intval(0 - strlen($artld));
38 
			if (substr($domain, $tldlen) == $artld) $whosrv = $whoisservers[$x][1];
39 
		}
40 
		return $whosrv;
41 
	}
42 
 
43 
	//function borrowed from
44 
	/*
45 
	Top-Side.de Php Domain Checker v1.1 pro - (C) 2005 by Top-Side.de
46 
 
47 
	Dieses Script darf frei verwendet werden, solange dieser Text bestehen bleibt.
48 
	*/
49 
 
50 
	function lookup($dom)
51 
	{
52 
		$lusrv = get_whois_server($dom);
53 
		if (!$lusrv) return "";
54 
		$fp = fsockopen($lusrv,43);
55 
		if($lusrv == "whois.denic.de")
56 
		{
57 
			fputs($fp, "-C ISO-8859-1 -T ace,dn $dom\r\n");
58 
		}
59 
		else
60 
		{
61 
			fputs($fp, "$dom\r\n");
62 
		}
63 
		$string="";
64 
		while(!feof($fp))
65 
		{
66 
			$string.= fgets($fp,128);
67 
		}
68 
		fclose($fp);
69 
		$reg = "/Whois Server: (.*?)\n/i";
70 
		preg_match_all($reg, $string, $matches);
71 
		$secondtry = $matches[1][0];
72 
		if ($secondtry)
73 
		{
74 
			$fp = fsockopen($secondtry,43);
75 
			fputs($fp, "$dom\r\n");
76 
			$string="";
77 
			while(!feof($fp))
78 
			{
79 
				$string.=fgets($fp,128);
80 
			}
81 
			fclose($fp);
82 
		}
17 lars 83 
		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))
84 
		{
85 
			return true;
86 
		}
87 
		else
88 
		{
89 
			return $string;
90 
		}
16 lars 91 
	}
92 
 
93 
	function check_domain($domain, $vname, $nname)
94 
	{
95 
		$string=lookup($domain);
96 
		if ($string===true)
97 
		{
98 
			return true;
99 
		}
100 
		else
101 
		{
102 
			if (strpos($string, $nname)!==false AND strpos($string, $vname)!==false)
103 
			{
104 
				return true;
105 
			}
106 
			else
107 
			{
108 
				return false;
109 
			}
110 
		}
111 
	}
112 
 
19 lars 113 
	function speichern($name, $vname, $email, $domain, $emails, $email_type, $targets, $space, $traffic, $db_anz, $webmail, $phpbb, $copper, $svn, $admin_name, $admin_pw, $repo, $svn_users)
1 lars 114 
	{
115 
		$sql="";
116 
		mysql_query("SET AUTOCOMMIT=0");
117 
		mysql_query("START TRANSACTION");
19 lars 118 
		switch ($webmail)
119 
		{
120 
			case 1:
121 
				$vwebmail=1;
122 
				$squirre=0;
123 
				break;
124 
			case 2:
125 
				$vwebmail=0;
126 
				$squirre=1;
127 
				break;
128 
			case 0:
129 
				$vwebmail=0;
130 
				$squirre=0;
131 
				break;
132 
		}
1 lars 133 
		$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)";
134 
		if(mysql_query($sql))
135 
		{
136 
			$k_id=sprintf("%011d",mysql_insert_id());
137 
			$i=0;
19 lars 138 
			$sql="INSERT INTO software (k_id, vwebmail, squirre, phpbb, copper, svn, admin_name, admin_pw, repo_name) VALUES ($k_id, $vwebmail, $squirre, $phpbb, $copper, $svn, '$admin_name', '$admin_pw', '$repo')";
1 lars 139 
			$res=mysql_query($sql);
140 
			if ($res)
141 
			{
142 
				$sql="INSERT INTO emails (k_id, email, target) VALUES ";
143 
				foreach ($emails as $email)
144 
				{
145 
					$target="";
146 
					if ($email_type==0)
147 
					{
148 
						if ($i < count($targets))
149 
						{
150 
							$target=$targets[$i];
151 
						}
152 
						else
153 
						{
154 
							$target=$target[count($targets)];
155 
						}
156 
					}
157 
					$sql.="($k_id, '$email', '$target')";
158 
					$i++;
159 
					if($i<count($emails))
160 
					{
161 
						$sql.=", ";
162 
					}
163 
				}
164 
				//SVN Repository wurde gebucht
165 
				if ($svn)
166 
				{
167 
					if ($e_sql=mysql_query($sql))
168 
					{
169 
						$i=0;
170 
						$sql="INSERT INTO svn_users (k_id, u_name, u_pw) VALUES ";
171 
						foreach ($svn_users as $svn_user)
172 
						{
173 
							$svn=explode("=",$svn_user);
174 
							$user=trim($svn[0]);
175 
							$pw=trim($svn[1]);
176 
							$i++;
177 
							$sql.="($k_id, '$user', '$pw')";
178 
							if($i<count($svn_users))
179 
							{
180 
								$sql.=", ";
181 
							}
182 
						}
183 
					}
184 
					else
185 
					{
186 
						return false;
187 
					}
188 
 
189 
				}
190 
				if(mysql_query($sql))
191 
				{
192 
					return true;
193 
				}
194 
				else
195 
				{
196 
					return false;
197 
				}
198 
			}
199 
			else
200 
			{
201 
				return false;
202 
			}
203 
		}
204 
		else
205 
		{
206 
			return false;
207 
		}
208 
	}
209 
 
210 
	function generate_pdf($k_id)
211 
	{
212 
		$k_id=sprintf("%011d",$k_id);
213 
		$sql="SELECT * FROM kunden WHERE k_id=$k_id";
214 
		$res=mysql_query($sql);
215 
		$row=mysql_fetch_assoc($res);
216 
		$sql_e="SELECT * FROM emails WHERE k_id=$k_id";
217 
		$sql_s="SELECT * FROM svn_users WHERE k_id=$k_id";
218 
		$res_e=mysql_query($sql_e);
219 
		$res_s=mysql_query($sql_s);
4 lars 220 
		$sql_w="SELECT * FROM software where k_id=$k_id";
1 lars 221 
		$res_w=mysql_query($sql_w);
222 
		$row_w=mysql_fetch_assoc($res_w);
223 
		while ($row_e=mysql_fetch_assoc($res_e))
224 
		{
225 
			$email_arr[]=$row_e["email"];
226 
			$target_arr[]=$row_e["email"];
227 
		}
228 
		$email_anz=count($email_arr);
229 
		while ($row_s=mysql_fetch_assoc($res_s))
230 
		{
231 
			$svn_user_arr[]=$row_s["u_name"]." = ".$row_s["u_pw"];
232 
		}
233 
		$k_name=$row["vname"]." ".$row["nname"];
234 
		$pdf=PDF_new();
235 
		if(!$pdf) return false;
236 
		if(!PDF_begin_document($pdf, "Kunde_$k_id.pdf","")) return false;
237 
		if(!PDF_begin_page_ext($pdf, 595, 842, "")) return false;
238 
 
239 
		$font = PDF_load_font($pdf, "Helvetica-Bold", "winansi", "");
240 
 
241 
		PDF_setfont($pdf, $font, 10);
242 
		$y=770;
243 
		PDF_set_text_pos($pdf, 70, $y);
244 
		PDF_show($pdf, "Deine Bestellung auf http://webhosting.lars-tiefland.de");
245 
		$y-=10;
246 
		PDF_set_text_pos($pdf, 70, $y);
247 
		PDF_show($pdf, "=======================================================");
248 
		$y-=30;
249 
		PDF_set_text_pos($pdf, 70, $y);
250 
		PDF_show($pdf, "Hallo $k_name,");
251 
		$y-=10;
252 
		PDF_set_text_pos($pdf, 70, $y);
253 
		PDF_show($pdf, "dies sind die Daten, die Du bei Deiner Bestllung eingegeben hast.");
254 
		$y-=10;
255 
		PDF_set_text_pos($pdf, 70, $y);
256 
		PDF_show($pdf, "Sollten Fehler enthalten sein, oder solltest Du weitere Angaben machen wollen, ");
257 
		$y-=10;
258 
		PDF_set_text_pos($pdf, 70, $y);
259 
		PDF_show($pdf, "so schreibe bitte an order@lars-tiefland.de");
260 
		$y-=30;
261 
		PDF_set_text_pos($pdf, 70, $y);
262 
		PDF_show($pdf, "Kundennummer: ");
263 
		PDF_set_text_pos($pdf, 200, $y);
264 
		PDF_show($pdf, $k_id);
265 
		$y-=10;
266 
		PDF_set_text_pos($pdf, 70, $y);
267 
		PDF_show($pdf, "Name: ");
268 
		PDF_set_text_pos($pdf, 200, $y);
269 
		PDF_show($pdf, $row["nname"]);
270 
		$y-=10;
271 
		PDF_set_text_pos($pdf, 70, $y);
272 
		PDF_show($pdf, "Vorname: ");
273 
		PDF_set_text_pos($pdf, 200, $y);
274 
		PDF_show($pdf, $row["vname"]);
275 
		$y-=10;
276 
		PDF_set_text_pos($pdf, 70, $y);
277 
		PDF_show($pdf, "E-Mail: ");
278 
		PDF_set_text_pos($pdf, 200, $y);
279 
		PDF_show($pdf, $row["email"]);
280 
		$y-=10;
281 
		PDF_set_text_pos($pdf, 70, $y);
282 
		PDF_show($pdf, "Domain: ");
283 
		PDF_set_text_pos($pdf, 200, $y);
284 
		PDF_show($pdf, $row["domain"]);
285 
		$y-=10;
286 
		PDF_set_text_pos($pdf, 70, $y);
287 
		PDF_show($pdf, "Anzahl E-Mail Adressen: ");
288 
		PDF_set_text_pos($pdf, 200, $y);
289 
		$y-=10;
290 
		PDF_show($pdf, $email_anz);
291 
		PDF_set_text_pos($pdf, 70, $y);
292 
		PDF_show($pdf, "E-Mail Adressen: ");
293 
		foreach($email_arr as $email)
294 
		{
295 
			PDF_set_text_pos($pdf, 200, $y);
296 
			PDF_Show($pdf, $email);
297 
			$y-=10;
298 
		}
299 
		PDF_set_text_pos($pdf, 70, $y);
300 
		PDF_show($pdf, "E-Mail Typ: ");
301 
		PDF_set_text_pos($pdf, 200, $y);
302 
		PDF_show($pdf, ($row["email_type"]==0)?"Weiterleitung":"POP3/IMAP Postfach");
303 
		$y-=10;
304 
		PDF_set_text_pos($pdf, 70, $y);
305 
		PDF_show($pdf, "Ziel Adressen: ");
306 
		if ($row["email_type"]==0)
307 
		{
308 
			foreach($target_arr as $target)
309 
			{
310 
				PDF_set_text_pos($pdf, 200, $y);
311 
				PDF_Show($pdf, $target);
312 
				$y-=10;
313 
			}
314 
		}
315 
		else
316 
		{
317 
			PDF_set_text_pos($pdf, 200, $y);
318 
			PDF_Show($pdf, "Nicht nötig");
319 
			$y-=10;
320 
		}
321 
		PDF_set_text_pos($pdf, 70, $y);
322 
		PDF_show($pdf, "Webspace: ");
323 
		PDF_set_text_pos($pdf, 200, $y);
324 
		PDF_show($pdf, number_format($row["space"],0,",",".")." MB");
325 
		$y-=10;
326 
		PDF_set_text_pos($pdf, 70, $y);
327 
		PDF_show($pdf, "Traffic / Monat: ");
328 
		PDF_set_text_pos($pdf, 200, $y);
329 
		PDF_show($pdf, number_format($row["traffic"],0,",",".")." GB");
330 
		$y-=10;
331 
		PDF_set_text_pos($pdf, 70, $y);
332 
		PDF_show($pdf, "Anzahl Datenbanken: ");
333 
		PDF_set_text_pos($pdf, 200, $y);
334 
		PDF_show($pdf, $row["db_anz"]);
335 
		$y-=10;
336 
		PDF_set_text_pos($pdf, 70, $y);
19 lars 337 
		PDF_show($pdf, "Webmail Interface");
338 
		PDF_set_text_pos($pdf, 200, $y);
339 
		PDF_show($pdf, ($row_w["vwebmail"])?"V-Webmail":(($row_w["squirre"])?"Squirrelmail":"keines"));
340 
		$y-=10;
341 
		PDF_set_text_pos($pdf, 70, $y);
1 lars 342 
		PDF_show($pdf, "phpBB Forum: ");
343 
		PDF_set_text_pos($pdf, 200, $y);
344 
		PDF_show($pdf, ($row_w["phpbb"])?"Ja":"Nein");
345 
		$y-=10;
346 
		PDF_set_text_pos($pdf, 70, $y);
347 
		PDF_show($pdf, "coppermine Galerie: ");
348 
		PDF_set_text_pos($pdf, 200, $y);
349 
		PDF_show($pdf, ($row_w["copper"])?"Ja":"Nein");
350 
		$y-=10;
351 
		PDF_set_text_pos($pdf, 70, $y);
352 
		PDF_show($pdf, "Subversion Repository: ");
353 
		PDF_set_text_pos($pdf, 200, $y);
354 
		PDF_show($pdf, ($row_w["svn"])?"Ja":"Nein");
355 
		$y-=10;
356 
		PDF_set_text_pos($pdf, 70, $y);
357 
		PDF_show($pdf, "Admin Name: ");
358 
		PDF_set_text_pos($pdf, 200, $y);
359 
		PDF_show($pdf, $row_w["admin_name"]);
360 
		$y-=10;
361 
		PDF_set_text_pos($pdf, 70, $y);
362 
		PDF_show($pdf, "Admin Passwort: ");
363 
		PDF_set_text_pos($pdf, 200, $y);
364 
		PDF_show($pdf, $row_w["admin_pw"]);
365 
		$y-=10;
366 
		PDF_set_text_pos($pdf, 70, $y);
367 
		PDF_show($pdf, "Repository Name: ");
368 
		PDF_set_text_pos($pdf, 200, $y);
4 lars 369 
		PDF_show($pdf, $row_w["repo_name"]);
1 lars 370 
		$y-=10;
371 
		PDF_set_text_pos($pdf, 70, $y);
372 
		PDF_show($pdf, "SVN Benutzer: ");
373 
		foreach($svn_user_arr as $svn_user)
374 
		{
375 
			PDF_set_text_pos($pdf, 200, $y);
376 
			PDF_Show($pdf, $svn_user);
377 
			$y-=10;
378 
		}
379 
		if(!PDF_end_page_ext($pdf,"")) return false;
380 
		if(!PDF_end_document($pdf,"")) return false;
381 
		return true;
382 
	}
383 
 
384 
	function send_email($k_id)
385 
	{
386 
		$email=new mime_mail();
387 
		$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";
388 
		$res=mysql_query($sql);
389 
		$row=mysql_fetch_assoc($res);
390 
		$k_id=$row["k_id"];
391 
		$filename="Kunde_$k_id.pdf";
392 
		$k_name=$row["vname"]." ". $row["nname"];
393 
		$k_email=$row["email"];
394 
		$email->to="$k_name<$k_email>";
395 
		$email->from="order@lars-tiefland.de";
396 
		if (file_exists($filename))
397 
		{
398 
			$fd = fopen($filename, "rb");
399 
			$data = fread($fd, filesize($filename));
400 
			fclose($fd);
401 
			$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";
402 
			$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";
403 
			$email->subject="Deine Bestellung ist eingegangen";
404 
			$email->add_attachment($data, $filename);
405 
			$send=$email->send();
406 
		}
407 
		else
408 
		{
409 
			$send=false;
410 
		}
411 
		return $send;
412 
	}
413 
 
414 
	function send_order($k_id)
415 
	{
416 
		$email=new mime_mail();
417 
		$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";
418 
		$res=mysql_query($sql);
419 
		$row=mysql_fetch_assoc($res);
420 
		$k_id=$row["k_id"];
421 
		$filename="Kunde_$k_id.pdf";
422 
		$k_name=$row["vname"]." ". $row["nname"];
423 
		$k_email=$row["email"];
424 
		$email->to="Lars Tiefland<order@lars-tiefland.de>";
425 
		$email->from="order@lars-tiefland.de";
426 
		if (file_exists($filename))
427 
		{
428 
			$fd = fopen($filename, "rb");
429 
			$data = fread($fd, filesize($filename));
430 
			fclose($fd);
4 lars 431 
			$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 432 
			$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";
433 
			$email->subject="Eine neue Bestellung ist eingegangen";
434 
			$email->add_attachment($data, $filename);
435 
			$send=$email->send();
436 
		}
437 
		else
438 
		{
439 
			$send=false;
440 
		}
441 
		return $send;
442 
	}
443 
?>