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: