Subversion-Projekte lars-tiefland.webhosting

Revision

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

Revision 39 Revision 60
Zeile 1... Zeile 1...
1 
<?
 1 
<?
2 
	// $URL: file:///svn/repos/webhosting/trunk/functions.php $ last modified in Revision $Rev: 39 $ by $Author: lars $ at $Date: 2007-06-02 23:24:38 +0200 (Sa, 02 Jun 2007) $
 2 
	// $URL: file:///svn/repos/webhosting/trunk/functions.php $ last modified in Revision $Rev: 60 $ by $Author: lars $ at $Date: 2007-06-14 15:23:14 +0200 (Do, 14 Jun 2007) $
3 
	mysql_connect("127.0.0.1","ltiefland","voyager");
 3 
	mysql_connect("127.0.0.1","ltiefland","voyager");
4 
	mysql_select_db("webhosting");
 4 
	mysql_select_db("webhosting");
Zeile 5... Zeile 5...
5 
 
 5 
 
Zeile 109... Zeile 109...
109 
				return false;
 109 
				return false;
110 
			}
 110 
			}
111 
		}
 111 
		}
112 
	}
 112 
	}
Zeile 113... Zeile 113...
113
113
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 
	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)
115 
	{
 115 
	{
116 
		$sql="";
 116 
		$sql="";
117 
		mysql_query("SET AUTOCOMMIT=0");
 117 
		mysql_query("SET AUTOCOMMIT=0");
118 
		mysql_query("START TRANSACTION");
 118 
		mysql_query("START TRANSACTION");
- 
 
 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
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)";
 140 
		)";
120 
		if(mysql_query($sql))
 141 
		if(mysql_query($sql))
121 
		{
 142 
		{
122 
			$k_id=sprintf("%011d",mysql_insert_id());
 143 
			$k_id=sprintf("%011d",mysql_insert_id());
123 
			$i=0;
 144 
			$i=0;
- 
 
 145 
			$sql="INSERT INTO software
- 
 
 146 
			(
- 
 
 147 
				k_id,
- 
 
 148 
				os,
- 
 
 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'
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')";
 168 
			)";
125 
			$res=mysql_query($sql);
 169 
			$res=mysql_query($sql);
126 
			if ($res)
 170 
			if ($res)
127 
			{
 171 
			{
128 
				$sql="INSERT INTO emails (k_id, email, target) VALUES ";
 172 
				$sql="INSERT INTO emails (k_id, email, target) VALUES ";
Zeile 312... Zeile 356...
312 
		PDF_show($pdf, "Anzahl Datenbanken: ");
 356 
		PDF_show($pdf, "Anzahl Datenbanken: ");
313 
		PDF_set_text_pos($pdf, 200, $y);
 357 
		PDF_set_text_pos($pdf, 200, $y);
314 
		PDF_show($pdf, $row["db_anz"]);
 358 
		PDF_show($pdf, $row["db_anz"]);
315 
		$y-=10;
 359 
		$y-=10;
316 
		PDF_set_text_pos($pdf, 70, $y);
 360 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 361 
		PDF_show($pdf, "Betriebssystem:");
- 
 
 362 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 363 
		switch($row_w["os"])
- 
 
 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);
317 
		PDF_show($pdf, "Webmail Interface:");
 378 
		PDF_show($pdf, "Webmail Interface:");
318 
		PDF_set_text_pos($pdf, 200, $y);
 379 
		PDF_set_text_pos($pdf, 200, $y);
319 
		switch($row_w["webmail"])
 380 
		switch($row_w["webmail"])
320 
		{
 381 
		{
321 
			case 1:
 382 
			case 1:
Zeile 512... Zeile 573...
512 
		PDF_show($pdf, "Anzahl Datenbanken: ");
 573 
		PDF_show($pdf, "Anzahl Datenbanken: ");
513 
		PDF_set_text_pos($pdf, 200, $y);
 574 
		PDF_set_text_pos($pdf, 200, $y);
514 
		PDF_show($pdf, $row["db_anz"]);
 575 
		PDF_show($pdf, $row["db_anz"]);
515 
		$y-=10;
 576 
		$y-=10;
516 
		PDF_set_text_pos($pdf, 70, $y);
 577 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 578 
		PDF_show($pdf, "Betriebssystem:");
- 
 
 579 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 580 
		switch($row_w["os"])
- 
 
 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);
517 
		PDF_show($pdf, "Webmail Interface:");
 595 
		PDF_show($pdf, "Webmail Interface:");
518 
		PDF_set_text_pos($pdf, 200, $y);
 596 
		PDF_set_text_pos($pdf, 200, $y);
519 
		switch($row_w["webmail"])
 597 
		switch($row_w["webmail"])
520 
		{
 598 
		{
521 
			case 1:
 599 
			case 1: