Subversion-Projekte lars-tiefland.webhosting

Revision

Revision 31 | Revision 34 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 31 Revision 33
Zeile 1... Zeile 1...
1 
<?
 1 
<?
- 
 
 2 
	// $URL: file:///svn/repos/webhosting/trunk/functions.php $ last modified in Revision $Rev: 33 $ by $Author: lars $ at $Date: 2007-04-09 17:43:52 +0200 (Mo, 09 Apr 2007) $
2 
	mysql_connect("localhost","ltiefland","voyager");
 3 
	mysql_connect("localhost","ltiefland","voyager");
3 
	mysql_select_db("webhosting");
 4 
	mysql_select_db("webhosting");
Zeile 4... Zeile 5...
4 
 
 5 
 
Zeile 108... Zeile 109...
108 
				return false;
 109 
				return false;
109 
			}
 110 
			}
110 
		}
 111 
		}
111 
	}
 112 
	}
Zeile 112... Zeile 113...
112
113
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)
 114 
	function speichern($name, $vname, $email, $domain, $emails, $email_type, $targets, $space, $traffic, $db_anz, $webmail, $forum, $copper, $svn, $admin_name, $admin_pw, $repo, $svn_users)
114 
	{
 115 
	{
115 
		$sql="";
 116 
		$sql="";
116 
		mysql_query("SET AUTOCOMMIT=0");
 117 
		mysql_query("SET AUTOCOMMIT=0");
117 
		mysql_query("START TRANSACTION");
 - 
 
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 
		}
 118 
		mysql_query("START TRANSACTION");
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)";
 119 
		$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))
 120 
		if(mysql_query($sql))
135 
		{
 121 
		{
136 
			$k_id=sprintf("%011d",mysql_insert_id());
 122 
			$k_id=sprintf("%011d",mysql_insert_id());
137 
			$i=0;
 123 
			$i=0;
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')";
 124 
			$sql="INSERT INTO software (k_id, webmail, forum, copper, svn, admin_name, admin_pw, repo_name) VALUES ($k_id, $webmail, $forum, $copper, $svn, '$admin_name', '$admin_pw', '$repo')";
139 
			$res=mysql_query($sql);
 125 
			$res=mysql_query($sql);
140 
			if ($res)
 126 
			if ($res)
141 
			{
 127 
			{
142 
				$sql="INSERT INTO emails (k_id, email, target) VALUES ";
 128 
				$sql="INSERT INTO emails (k_id, email, target) VALUES ";
Zeile 231... Zeile 217...
231 
			$svn_user_arr[]=$row_s["u_name"]." = ".$row_s["u_pw"];
 217 
			$svn_user_arr[]=$row_s["u_name"]." = ".$row_s["u_pw"];
232 
		}
 218 
		}
233 
		$k_name=$row["vname"]." ".$row["nname"];
 219 
		$k_name=$row["vname"]." ".$row["nname"];
234 
		$pdf=PDF_new();
 220 
		$pdf=PDF_new();
235 
		if(!$pdf) return false;
 221 
		if(!$pdf) return false;
236 
		if(!PDF_begin_document($pdf, "Kunde_$k_id.pdf","")) return false;
 222 
		if(!PDF_begin_document($pdf, "pdf/Kunde_$k_id.pdf","")) return false;
237 
		if(!PDF_begin_page_ext($pdf, 595, 842, "")) return false;
 223 
		if(!PDF_begin_page_ext($pdf, 595, 842, "")) return false;
Zeile 238... Zeile 224...
238
224
Zeile 239... Zeile 225...
239 
		$font = PDF_load_font($pdf, "Helvetica-Bold", "winansi", "");
 225 
		$font = PDF_load_font($pdf, "Helvetica-Bold", "winansi", "");
Zeile 334... Zeile 320...
334 
		PDF_show($pdf, $row["db_anz"]);
 320 
		PDF_show($pdf, $row["db_anz"]);
335 
		$y-=10;
 321 
		$y-=10;
336 
		PDF_set_text_pos($pdf, 70, $y);
 322 
		PDF_set_text_pos($pdf, 70, $y);
337 
		PDF_show($pdf, "Webmail Interface:");
 323 
		PDF_show($pdf, "Webmail Interface:");
338 
		PDF_set_text_pos($pdf, 200, $y);
 324 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 325 
		switch($row_w["webmail"])
- 
 
 326 
		{
- 
 
 327 
			case 1:
- 
 
 328 
				$webmail_text="VWebmail";
- 
 
 329 
				break;
- 
 
 330 
			case 2:
- 
 
 331 
				$webmail_text="Squirrelmail";
- 
 
 332 
				break;
- 
 
 333 
			case 0:
- 
 
 334 
				$webmail_text="Keines";
- 
 
 335 
				break;
- 
 
 336 
		}
339 
		PDF_show($pdf, ($row_w["vwebmail"])?"V-Webmail":(($row_w["squirre"])?"Squirrelmail":"keines"));
 337 
		PDF_show($pdf, $webmail_text);
340 
		$y-=10;
 338 
		$y-=10;
341 
		PDF_set_text_pos($pdf, 70, $y);
 339 
		PDF_set_text_pos($pdf, 70, $y);
342 
		PDF_show($pdf, "phpBB Forum: ");
 340 
		PDF_show($pdf, "Forum: ");
343 
		PDF_set_text_pos($pdf, 200, $y);
 341 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 342 
		switch($row_w["forum"])
- 
 
 343 
		{
- 
 
 344 
			case 1:
- 
 
 345 
				$f_text="phpBB";
- 
 
 346 
				break;
- 
 
 347 
			case 2:
- 
 
 348 
				$f_text="SMF";
- 
 
 349 
				break;
- 
 
 350 
			case 0:
- 
 
 351 
				$f_text="Keines";
- 
 
 352 
				break;
- 
 
 353 
		}
344 
		PDF_show($pdf, ($row_w["phpbb"])?"Ja":"Nein");
 354 
		PDF_show($pdf, "$f_text");
345 
		$y-=10;
 355 
		$y-=10;
346 
		PDF_set_text_pos($pdf, 70, $y);
 356 
		PDF_set_text_pos($pdf, 70, $y);
347 
		PDF_show($pdf, "coppermine Galerie: ");
 357 
		PDF_show($pdf, "coppermine Galerie: ");
348 
		PDF_set_text_pos($pdf, 200, $y);
 358 
		PDF_set_text_pos($pdf, 200, $y);
349 
		PDF_show($pdf, ($row_w["copper"])?"Ja":"Nein");
 359 
		PDF_show($pdf, ($row_w["copper"])?"Ja":"Nein");
Zeile 361... Zeile 371...
361 
		PDF_set_text_pos($pdf, 70, $y);
 371 
		PDF_set_text_pos($pdf, 70, $y);
362 
		PDF_show($pdf, "Admin Passwort: ");
 372 
		PDF_show($pdf, "Admin Passwort: ");
363 
		PDF_set_text_pos($pdf, 200, $y);
 373 
		PDF_set_text_pos($pdf, 200, $y);
364 
		PDF_show($pdf, $row_w["admin_pw"]);
 374 
		PDF_show($pdf, $row_w["admin_pw"]);
365 
		$y-=10;
 375 
		$y-=10;
366 
		PDF_set_text_pos($pdf, 70, $y);
 - 
 
367 
		PDF_show($pdf, "Repository Name: ");
 - 
 
368 
		PDF_set_text_pos($pdf, 200, $y);
 - 
 
369 
		PDF_show($pdf, $row_w["repo_name"]);
 376 
		if($row_w["repo_name"])
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 
		{
 377 
		{
- 
 
 378 
			PDF_set_text_pos($pdf, 70, $y);
- 
 
 379 
			PDF_show($pdf, "Repository Name: ");
375 
			PDF_set_text_pos($pdf, 200, $y);
 380 
			PDF_set_text_pos($pdf, 200, $y);
376 
			PDF_Show($pdf, $svn_user);
 381 
			PDF_show($pdf, $row_w["repo_name"]);
377 
			$y-=10;
 382 
			$y-=10;
- 
 
 383 
			PDF_set_text_pos($pdf, 70, $y);
- 
 
 384 
			PDF_show($pdf, "SVN Benutzer: ");
- 
 
 385 
			foreach($svn_user_arr as $svn_user)
- 
 
 386 
			{
- 
 
 387 
				PDF_set_text_pos($pdf, 200, $y);
- 
 
 388 
				PDF_Show($pdf, $svn_user);
- 
 
 389 
				$y-=10;
- 
 
 390 
			}
378 
		}
 391 
		}
379 
		if(!PDF_end_page_ext($pdf,"")) return false;
 392 
		if(!PDF_end_page_ext($pdf,"")) return false;
380 
		if(!PDF_end_document($pdf,"")) return false;
 393 
		if(!PDF_end_document($pdf,"")) return false;
381 
		return true;
 394 
		return true;
382 
	}
 395 
	}
Zeile 386... Zeile 399...
386 
		$email=new mime_mail();
 399 
		$email=new mime_mail();
387 
		$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";
 400 
		$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";
388 
		$res=mysql_query($sql);
 401 
		$res=mysql_query($sql);
389 
		$row=mysql_fetch_assoc($res);
 402 
		$row=mysql_fetch_assoc($res);
390 
		$k_id=$row["k_id"];
 403 
		$k_id=$row["k_id"];
391 
		$filename="Kunde_$k_id.pdf";
 404 
		$filename="pdf/Kunde_$k_id.pdf";
392 
		$k_name=$row["vname"]." ". $row["nname"];
 405 
		$k_name=$row["vname"]." ". $row["nname"];
393 
		$k_email=$row["email"];
 406 
		$k_email=$row["email"];
394 
		$email->to="$k_name<$k_email>";
 407 
		$email->to="$k_name<$k_email>";
395 
		$email->from="order@lars-tiefland.de";
 408 
		$email->from="Bestellbestätigung<order@lars-tiefland.de>";
396 
		if (file_exists($filename))
 409 
		if (file_exists($filename))
397 
		{
 410 
		{
398 
			$fd = fopen($filename, "rb");
 411 
			$fd = fopen($filename, "rb");
399 
			$data = fread($fd, filesize($filename));
 412 
			$data = fread($fd, filesize($filename));
400 
			fclose($fd);
 413 
			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";
 414 
			$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";
 415 
			$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";
 416 
			$email->subject="Deine Bestellung ist eingegangen";
404 
			$email->add_attachment($data, $filename);
 417 
			$email->add_attachment($data, basename($filename));
405 
			$send=$email->send();
 418 
			$send=$email->send();
406 
		}
 419 
		}
407 
		else
 420 
		else
408 
		{
 421 
		{
409 
			$send=false;
 422 
			$send=false;
Zeile 416... Zeile 429...
416 
		$email=new mime_mail();
 429 
		$email=new mime_mail();
417 
		$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";
 430 
		$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";
418 
		$res=mysql_query($sql);
 431 
		$res=mysql_query($sql);
419 
		$row=mysql_fetch_assoc($res);
 432 
		$row=mysql_fetch_assoc($res);
420 
		$k_id=$row["k_id"];
 433 
		$k_id=$row["k_id"];
421 
		$filename="Kunde_$k_id.pdf";
 434 
		$filename="pdf/Kunde_$k_id.pdf";
422 
		$k_name=$row["vname"]." ". $row["nname"];
 435 
		$k_name=$row["vname"]." ". $row["nname"];
423 
		$k_email=$row["email"];
 436 
		$k_email=$row["email"];
424 
		$email->to="Lars Tiefland<order@lars-tiefland.de>";
 437 
		$email->to="Lars Tiefland<order@lars-tiefland.de>";
425 
		$email->from="order@lars-tiefland.de";
 438 
		$email->from="order@lars-tiefland.de";
426 
		if (file_exists($filename))
 439 
		if (file_exists($filename))
Zeile 429... Zeile 442...
429 
			$data = fread($fd, filesize($filename));
 442 
			$data = fread($fd, filesize($filename));
430 
			fclose($fd);
 443 
			fclose($fd);
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";
 444 
			$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";
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";
 445 
			$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";
 446 
			$email->subject="Eine neue Bestellung ist eingegangen";
434 
			$email->add_attachment($data, $filename);
 447 
			$email->add_attachment($data, basename($filename));
435 
			$send=$email->send();
 448 
			$send=$email->send();
436 
		}
 449 
		}
437 
		else
 450 
		else
438 
		{
 451 
		{
439 
			$send=false;
 452 
			$send=false;