<?php


	include ("config.php") ;


$conex = @mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS) ;

// "@"mysql_connect löscht Fehlermeldung durch MySql
if(!$conex) {
	echo "Es konnte keine Verbindung aufgebaut werden." ;
	$asg = mysql_error() ;
	echo $asg ;
	die() ;
	}


// $connection nur bei mehreren Datenbanken nötig, offene Verbindung wird genutzt;
if(!mysql_select_db(MYSQL_DATABASE)) {
	echo "Datenbank ".MYSQL_DATABASE." konnte nicht ausgew&auml;hlt werden." ;
	die() ;
	}






	$read = "SELECT * FROM gamer" ;
	$get = mysql_query($read) ;


$inhalta = '<table border="10">

<tr>
<th>id</th>
<th>anmeldedatum</th>
<th>username</th>
<th>passwort</th>
<th>mailadd</th>
<th>aim</th>
<th>msn</th>
<th>icq</th>
<th>new</th>
<th>loginno</th>
<th>speicherd</th>
<th>speicherh</th>
<th>speicherm</th>
<th>wielang</th>
<th>what</th>
<th>skill</th>
<th>poweradd</th>
<th>ort</th>
<th>bewohnt</th>
<th>waffe</th>
<th>panzerung</th>
<th>liga</th>
<th>truhe1</th>
<th>truhe2</th>
<th>truhe3</th>
<th>truhe4</th>
<th>truhe5</th>
<th>truhe6</th>
<th>truhe7</th>
<th>truhe8</th>
<th>truhe9</th>
<th>truhe0</th>
<th>konstitution</th>
<th>kraft</th>
<th>intelligenz</th>
<th>kondition</th>
<th>erfahrung</th>
<th>energie</th>
<th>werkzeug</th>
<th>panzer</th>
<th>ankryltromozyn</th>
<th>contexin</th>
<th>carbonit</th>
<th>cosmoss</th>
<th>hydro</th>
<th>neutrin</th>
<th>plasma</th>
<th>vanadium</th>
<th>back</th>
<th>backs</th>
<th>markete</th>
<th>death</th>
<th>googlea</th>
<th>from</th>
<th>abschickd</th>
<th>abschickh</th>
<th>abschickm</th>
<th>ankunftd</th>
<th>ankunfth</th>
<th>ankunftm</th>
<th>rohstofa</th>
<th>mengeeea</th>
<th>mengeeeb</th>
<th>rohstofb</th>
<th>unchangable</th></tr>' ;



$i = 0 ;


while ( $var = mysql_fetch_assoc ( $get ))

	{

$varaa = $var['id'] ;
$varab = $var['anmeldedatum'] ;
$varac = $var['username'] ;
$varad = $var['passwort'] ;
$varae = $var['mailadd'] ;
$varaf = $var['aim'] ;
$varag = $var['msn'] ;
$varah = $var['icq'] ;
$varai = $var['usertext'] ;
$varaj = $var['new'] ;
$varak = $var['loginno'] ;
$varal = $var['speicherd'] ;
$varam = $var['speicherh'] ;
$varan = $var['speicherm'] ;
$varao = $var['wielang'] ;
$varap = $var['what'] ;
$varaq = $var['skill'] ;
$varar = $var['poweradd'] ;
$varas = $var['ort'] ;
$varat = $var['bewohnt'] ;
$varau = $var['waffe'] ;
$varav = $var['panzerung'] ;
$varaw = $var['liga'] ;
$varax = $var['truhe1'] ;
$varay = $var['truhe2'] ;
$varaz = $var['truhe3'] ;

$varba = $var['truhe4'] ;
$varbb = $var['truhe5'] ;
$varbc = $var['truhe6'] ;
$varbd = $var['truhe7'] ;
$varbe = $var['truhe8'] ;
$varbf = $var['truhe9'] ;
$varbg = $var['truhe0'] ;
$varbh = $var['konstitution'] ;
$varbi = $var['kraft'] ;
$varbj = $var['intelligenz'] ;
$varbk = $var['kondition'] ;
$varbl = $var['erfahrung'] ;
$varbm = $var['energie'] ;
$varbn = $var['werkzeug'] ;
$varbo = $var['panzer'] ;
$varbp = $var['ankryltromozyn'] ;
$varbq = $var['contexin'] ;
$varbr = $var['carbonit'] ;
$varbs = $var['cosmoss'] ;
$varbt = $var['hydro'] ;
$varbu = $var['neutrin'] ;
$varbv = $var['plasma'] ;
$varbw = $var['vanadium'] ;

$varef = $var['back'] ;
$vareg = $var['backs'] ;
$vareh = $var['markete'] ;
$varei = $var['death'] ;
$varej = $var['googlea'] ;
$varek = $var['from'] ;
$varel = $var['abschickd'] ;
$varem = $var['abschickh'] ;
$varen = $var['abschickm'] ;
$vareo = $var['ankunftd'] ;
$varep = $var['ankunfth'] ;
$vareq = $var['ankunftm'] ;
$varer = $var['rohstofa'] ;
$vares = $var['mengeeea'] ;
$varet = $var['mengeeeb'] ;
$vareu = $var['rohstofb'] ;
$varev = $var['unchangable'] ;

$inhaltb['$i'] = '<tr>

<td>'.$varaa.'</td>
<td>'.$varab.'</td>
<td>'.$varac.'</td>
<td>'.$varad.'</td>
<td>'.$varae.'</td>
<td>'.$varaf.'</td>
<td>'.$varag.'</td>
<td>'.$varah.'</td>
<td>'.$varaj.'</td>
<td>'.$varak.'</td>
<td>'.$varal.'</td>
<td>'.$varam.'</td>
<td>'.$varan.'</td>
<td>'.$varao.'</td>
<td>'.$varap.'</td>
<td>'.$varaq.'</td>
<td>'.$varar.'</td>
<td>'.$varas.'</td>
<td>'.$varat.'</td>
<td>'.$varau.'</td>
<td>'.$varav.'</td>
<td>'.$varaw.'</td>
<td>'.$varax.'</td>
<td>'.$varay.'</td>
<td>'.$varaz.'</td>

<td>'.$varba.'</td>
<td>'.$varbb.'</td>
<td>'.$varbc.'</td>
<td>'.$varbd.'</td>
<td>'.$varbe.'</td>
<td>'.$varbf.'</td>
<td>'.$varbg.'</td>
<td>'.$varbh.'</td>
<td>'.$varbi.'</td>
<td>'.$varbj.'</td>
<td>'.$varbk.'</td>
<td>'.$varbl.'</td>
<td>'.$varbm.'</td>
<td>'.$varbn.'</td>
<td>'.$varbo.'</td>
<td>'.$varbp.'</td>
<td>'.$varbq.'</td>
<td>'.$varbr.'</td>
<td>'.$varbs.'</td>
<td>'.$varbt.'</td>
<td>'.$varbu.'</td>
<td>'.$varbv.'</td>
<td>'.$varbw.'</td>

<td>'.$varef.'</td>
<td>'.$vareg.'</td>
<td>'.$vareh.'</td>
<td>'.$varei.'</td>
<td>'.$varej.'</td>
<td>'.$varek.'</td>
<td>'.$varel.'</td>
<td>'.$varem.'</td>
<td>'.$varen.'</td>
<td>'.$vareo.'</td>
<td>'.$varep.'</td>
<td>'.$vareq.'</td>
<td>'.$varer.'</td>
<td>'.$vares.'</td>
<td>'.$varet.'</td>
<td>'.$vareu.'</td>
<td>'.$varev.'</td>

</tr>' ;

$i++ ;

	}


$inhaltc = '</table>' ;



$inhalt = $inhalta ;



$mength = sizeof($inhaltb) ;

echo $mength ;
echo $inhaltb[0] ;

for($p=0;$p<=$mength;$p++) {

$inhalt = $inhalt.''.$inhaltb[$p] ;

	}


$inhalt = $inhalt.''.$inhaltc ;



$timestamp = time() ;
$dateum = date("d-m-Y",$timestamp) ;
$name = $dateum.'.html' ;

$data = fopen($name, "w+") ;
fwrite($data, $inhalt) ;
fclose($data) ;

?>