Subversion-Projekte lars-tiefland.webhosting

Revision

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

Revision 36 Revision 37
Zeile 1... Zeile 1...
1 
<?
 1 
<?
2 
	// $URL: file:///svn/repos/webhosting/trunk/functions.php $ last modified in Revision $Rev: 36 $ by $Author: lars $ at $Date: 2007-05-28 14:03:08 +0200 (Mo, 28 Mai 2007) $
 2 
	// $URL: file:///svn/repos/webhosting/trunk/functions.php $ last modified in Revision $Rev: 37 $ by $Author: lars $ at $Date: 2007-05-28 20:01:57 +0200 (Mo, 28 Mai 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 191... Zeile 191...
191 
		{
 191 
		{
192 
			return false;
 192 
			return false;
193 
		}
 193 
		}
194 
	}
 194 
	}
Zeile -... Zeile 195...
- 
 
 195 
 
- 
 
 196 
	function generate_pdf_lt($k_id)
- 
 
 197 
	{
- 
 
 198 
		$k_id=sprintf("%011d",$k_id);
- 
 
 199 
		$sql="SELECT * FROM kunden WHERE k_id=$k_id";
- 
 
 200 
		$res=mysql_query($sql);
- 
 
 201 
		$row=mysql_fetch_assoc($res);
- 
 
 202 
		$sql_e="SELECT * FROM emails WHERE k_id=$k_id";
- 
 
 203 
		$sql_s="SELECT * FROM svn_users WHERE k_id=$k_id";
- 
 
 204 
		$res_e=mysql_query($sql_e);
- 
 
 205 
		$res_s=mysql_query($sql_s);
- 
 
 206 
		$sql_w="SELECT * FROM software where k_id=$k_id";
- 
 
 207 
		$res_w=mysql_query($sql_w);
- 
 
 208 
		$row_w=mysql_fetch_assoc($res_w);
- 
 
 209 
		while ($row_e=mysql_fetch_assoc($res_e))
- 
 
 210 
		{
- 
 
 211 
			$email_arr[]=$row_e["email"];
- 
 
 212 
			$target_arr[]=$row_e["email"];
- 
 
 213 
		}
- 
 
 214 
		$email_anz=count($email_arr);
- 
 
 215 
		while ($row_s=mysql_fetch_assoc($res_s))
- 
 
 216 
		{
- 
 
 217 
			$svn_user_arr[]=$row_s["u_name"]." = ".$row_s["u_pw"];
- 
 
 218 
		}
- 
 
 219 
		$k_name=$row["vname"]." ".$row["nname"];
- 
 
 220 
		$pdf=PDF_new();
- 
 
 221 
		if(!$pdf) return false;
- 
 
 222 
		if(!PDF_begin_document($pdf, "pdf/Kunde_$k_id"."_lt.pdf","")) return false;
- 
 
 223 
		if(!PDF_begin_page_ext($pdf, 595, 842, "")) return false;
- 
 
 224
- 
 
 225 
		$font = PDF_load_font($pdf, "Helvetica-Bold", "winansi", "");
- 
 
 226 
 
- 
 
 227 
		PDF_setfont($pdf, $font, 10);
- 
 
 228 
		$y=770;
- 
 
 229 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 230 
		PDF_show($pdf, "Bestellung von $k_name auf http://webhosting.lars-tiefland.de");
- 
 
 231 
		$y-=10;
- 
 
 232 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 233 
		PDF_show($pdf, "=======================================================");
- 
 
 234 
		$y-=30;
- 
 
 235 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 236 
		PDF_show($pdf, "Hallo,");
- 
 
 237 
		$y-=10;
- 
 
 238 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 239 
		PDF_show($pdf, "dies sind die Daten, die $k_name bei seiner Bestllung eingegeben hat.");
- 
 
 240 
		$y-=20;
- 
 
 241 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 242 
		PDF_show($pdf, "so schreibe bitte an order@lars-tiefland.de");
- 
 
 243 
		$y-=30;
- 
 
 244 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 245 
		PDF_show($pdf, "Kundennummer: ");
- 
 
 246 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 247 
		PDF_show($pdf, $k_id);
- 
 
 248 
		$y-=10;
- 
 
 249 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 250 
		PDF_show($pdf, "Name: ");
- 
 
 251 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 252 
		PDF_show($pdf, $row["nname"]);
- 
 
 253 
		$y-=10;
- 
 
 254 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 255 
		PDF_show($pdf, "Vorname: ");
- 
 
 256 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 257 
		PDF_show($pdf, $row["vname"]);
- 
 
 258 
		$y-=10;
- 
 
 259 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 260 
		PDF_show($pdf, "E-Mail: ");
- 
 
 261 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 262 
		PDF_show($pdf, $row["email"]);
- 
 
 263 
		$y-=10;
- 
 
 264 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 265 
		PDF_show($pdf, "Domain: ");
- 
 
 266 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 267 
		PDF_show($pdf, $row["domain"]);
- 
 
 268 
		$y-=10;
- 
 
 269 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 270 
		PDF_show($pdf, "Anzahl E-Mail Adressen: ");
- 
 
 271 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 272 
		$y-=10;
- 
 
 273 
		PDF_show($pdf, $email_anz);
- 
 
 274 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 275 
		PDF_show($pdf, "E-Mail Adressen: ");
- 
 
 276 
		foreach($email_arr as $email)
- 
 
 277 
		{
- 
 
 278 
			PDF_set_text_pos($pdf, 200, $y);
- 
 
 279 
			PDF_Show($pdf, $email);
- 
 
 280 
			$y-=10;
- 
 
 281 
		}
- 
 
 282 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 283 
		PDF_show($pdf, "E-Mail Typ: ");
- 
 
 284 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 285 
		PDF_show($pdf, ($row["email_type"]==0)?"Weiterleitung":"POP3/IMAP Postfach");
- 
 
 286 
		$y-=10;
- 
 
 287 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 288 
		PDF_show($pdf, "Ziel Adressen: ");
- 
 
 289 
		if ($row["email_type"]==0)
- 
 
 290 
		{
- 
 
 291 
			foreach($target_arr as $target)
- 
 
 292 
			{
- 
 
 293 
				PDF_set_text_pos($pdf, 200, $y);
- 
 
 294 
				PDF_Show($pdf, $target);
- 
 
 295 
				$y-=10;
- 
 
 296 
			}
- 
 
 297 
		}
- 
 
 298 
		else
- 
 
 299 
		{
- 
 
 300 
			PDF_set_text_pos($pdf, 200, $y);
- 
 
 301 
			PDF_Show($pdf, "Nicht nötig");
- 
 
 302 
			$y-=10;
- 
 
 303 
		}
- 
 
 304 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 305 
		PDF_show($pdf, "Webspace: ");
- 
 
 306 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 307 
		PDF_show($pdf, number_format($row["space"],0,",",".")." MB");
- 
 
 308 
		$y-=10;
- 
 
 309 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 310 
		PDF_show($pdf, "Traffic / Monat: ");
- 
 
 311 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 312 
		PDF_show($pdf, number_format($row["traffic"],0,",",".")." GB");
- 
 
 313 
		$y-=10;
- 
 
 314 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 315 
		PDF_show($pdf, "Anzahl Datenbanken: ");
- 
 
 316 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 317 
		PDF_show($pdf, $row["db_anz"]);
- 
 
 318 
		$y-=10;
- 
 
 319 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 320 
		PDF_show($pdf, "Webmail Interface:");
- 
 
 321 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 322 
		switch($row_w["webmail"])
- 
 
 323 
		{
- 
 
 324 
			case 1:
- 
 
 325 
				$webmail_text="VWebmail";
- 
 
 326 
				break;
- 
 
 327 
			case 2:
- 
 
 328 
				$webmail_text="Squirrelmail";
- 
 
 329 
				break;
- 
 
 330 
			case 0:
- 
 
 331 
				$webmail_text="Keines";
- 
 
 332 
				break;
- 
 
 333 
		}
- 
 
 334 
		PDF_show($pdf, $webmail_text);
- 
 
 335 
		$y-=10;
- 
 
 336 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 337 
		PDF_show($pdf, "Forum: ");
- 
 
 338 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 339 
		switch($row_w["forum"])
- 
 
 340 
		{
- 
 
 341 
			case 1:
- 
 
 342 
				$f_text="phpBB";
- 
 
 343 
				break;
- 
 
 344 
			case 2:
- 
 
 345 
				$f_text="SMF";
- 
 
 346 
				break;
- 
 
 347 
			case 0:
- 
 
 348 
				$f_text="Keines";
- 
 
 349 
				break;
- 
 
 350 
		}
- 
 
 351 
		PDF_show($pdf, "$f_text");
- 
 
 352 
		$y-=10;
- 
 
 353 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 354 
		PDF_show($pdf, "coppermine Galerie: ");
- 
 
 355 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 356 
		PDF_show($pdf, ($row_w["copper"])?"Ja":"Nein");
- 
 
 357 
		$y-=10;
- 
 
 358 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 359 
		PDF_show($pdf, "Subversion Repository: ");
- 
 
 360 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 361 
		PDF_show($pdf, ($row_w["svn"])?"Ja":"Nein");
- 
 
 362 
		$y-=10;
- 
 
 363 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 364 
		PDF_show($pdf, "Admin Name: ");
- 
 
 365 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 366 
		PDF_show($pdf, $row_w["admin_name"]);
- 
 
 367 
		$y-=10;
- 
 
 368 
		PDF_set_text_pos($pdf, 70, $y);
- 
 
 369 
		PDF_show($pdf, "Admin Passwort: ");
- 
 
 370 
		PDF_set_text_pos($pdf, 200, $y);
- 
 
 371 
		PDF_show($pdf, $row_w["admin_pw"]);
- 
 
 372 
		$y-=10;
- 
 
 373 
		if($row_w["repo_name"])
- 
 
 374 
		{
- 
 
 375 
			PDF_set_text_pos($pdf, 70, $y);
- 
 
 376 
			PDF_show($pdf, "Repository Name: ");
- 
 
 377 
			PDF_set_text_pos($pdf, 200, $y);
- 
 
 378 
			PDF_show($pdf, $row_w["repo_name"]);
- 
 
 379 
			$y-=10;
- 
 
 380 
			PDF_set_text_pos($pdf, 70, $y);
- 
 
 381 
			PDF_show($pdf, "SVN Benutzer: ");
- 
 
 382 
			foreach($svn_user_arr as $svn_user)
- 
 
 383 
			{
- 
 
 384 
				PDF_set_text_pos($pdf, 200, $y);
- 
 
 385 
				PDF_Show($pdf, $svn_user);
- 
 
 386 
				$y-=10;
- 
 
 387 
			}
- 
 
 388 
		}
- 
 
 389 
		if(!PDF_end_page_ext($pdf,"")) return false;
- 
 
 390 
		if(!PDF_end_document($pdf,"")) return false;
- 
 
 391 
		return true;
195 
 
 392 
	}
196 
	function generate_pdf($k_id)
 393 
	function generate_pdf($k_id)
197 
	{
 394 
	{
198 
		$k_id=sprintf("%011d",$k_id);
 395 
		$k_id=sprintf("%011d",$k_id);
199 
		$sql="SELECT * FROM kunden WHERE k_id=$k_id";
 396 
		$sql="SELECT * FROM kunden WHERE k_id=$k_id";
Zeile 429... Zeile 626...
429 
		$email=new mime_mail();
 626 
		$email=new mime_mail();
430 
		$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";
 627 
		$sql="SELECT k_id, vname, nname, email FROM kunden WHERE k_id=$k_id";
431 
		$res=mysql_query($sql);
 628 
		$res=mysql_query($sql);
432 
		$row=mysql_fetch_assoc($res);
 629 
		$row=mysql_fetch_assoc($res);
433 
		$k_id=$row["k_id"];
 630 
		$k_id=$row["k_id"];
434 
		$filename="pdf/Kunde_$k_id.pdf";
 631 
		$filename="pdf/Kunde_$k_id"."_lt.pdf";
435 
		$k_name=$row["vname"]." ". $row["nname"];
 632 
		$k_name=$row["vname"]." ". $row["nname"];
436 
		$k_email=$row["email"];
 633 
		$k_email=$row["email"];
437 
		$email->to="Lars Tiefland<order@lars-tiefland.de>";
 634 
		$email->to="Lars Tiefland<order@lars-tiefland.de>";
438 
		$email->from="order@lars-tiefland.de";
 635 
		$email->from="order@lars-tiefland.de";
439 
		if (file_exists($filename))
 636 
		if (file_exists($filename))