Distribution of the skills of the Knight

• 

{source}
<?php

//Server Angaben
$DatabaseHost = "localhost";
$DatabaseUser = "d00e28dd";
$DatabasePassword = "784512";
$Database = "d00e28dd";
$TAB1 = 'Calculator_Trees';
$TAB2 = 'Skills';

$DatabasePointer = @mysqli_connect($DatabaseHost, $DatabaseUser, $DatabasePassword, $Database) or die( "<H2>Verbindungsfehler</H2>" . mysqli_connect_error());
if (mysqli_connect_errno())
{
echo "Verbindungsaufbau zu MySQL fehlgeschlagen: " . mysqli_connect_error();
}

$result1 = mysqli_query($DatabasePointer, "SELECT Timestamp, Nr, Job, Beschreibung, Beschreibung_eng FROM $TAB1 WHERE `Sichtbar` =1 and `Char` = 'Knight' Group By Nr Order By Job") or die( "<H2>Fehler beim Verbinden</H2>" . mysqli_error($DatabasePointer));
$result2 = mysqli_query($DatabasePointer, "SELECT Timestamp, Job, Beschreibung, Beschreibung_eng FROM $TAB1 WHERE `Sichtbar` =1 and `Char` = 'Knight' Group By Nr") or die( "<H2>Fehler beim Verbinden</H2>" . mysqli_error($DatabasePointer));
list($Anzahl) = mysqli_fetch_row($result2);
if ($Anzahl)
{
echo '<table border="1" cellpadding="5" cellspacing="0" class="treeliste">'."\n\t";
echo '<tbody>'."\n\t\t";
echo '<tr valign="top" class="TList_head">'."\n\t\t\t";
echo '<td width="30">'."\n\t\t\t\t";
echo '<b>Nr</b>'."\n\t\t\t";
echo '</td>'."\n\t\t\t\t";
echo '<td width="300">'."\n\t\t\t\t";
echo '<b>Job</b>'."\n\t\t\t";
echo '</td>'."\n\t\t\t\t";
echo '<td width="200">'."\n\t\t\t\t";
echo '<b>Description</b>'."\n\t\t\t";
echo '</td>'."\n\t\t\t\t";
echo '<td width="130">'."\n\t\t\t\t";
echo '<b>created by</b>'."\n\t\t\t";
echo '</td>'."\n\t\t\t\t";
echo '<td width="50">'."\n\t\t\t\t";
echo '</td>'."\n\t\t";
echo '</tr>';
$counter = 0;
while($ergebnis1 = mysqli_fetch_array($result1))
{
$counter = $counter +1;
if ($counter% 2 != 0)
{
//Ungerade Zahl
echo '<tr class="TList_ng">'."\n\t\t\t";
}
else
{
//Gerade Zahl
echo '<tr class="TList_g">'."\n\t\t\t";
}
$D = $ergebnis1['Timestamp'];
echo '<td>'.$counter.'</td>'."\n\t\t\t";
echo '<td>'.$ergebnis1['Job'].'</td>'."\n\t\t\t";
echo '<td>'.$ergebnis1['Description'].'</td>'."\n\t\t\t";
echo '<td>'.substr($D,8,2).'.'.substr($D,5,2).'.'.substr($D,0,4).' - '.substr($D,11,2).':'.substr($D,14,2).'</td>'."\n\t\t\t";
echo '<td><input type="button" name="Laden" value="Laden" onclick="SCTListShow.location = \'http://www.kal--online.com/assets/calculate/viewtrees_e.php?nr='.$ergebnis1['Nr'].'\'"></td>'."\n\t\t";
echo '</tr>';
}
echo "\n\t".'</tbody>';
echo "\n".'</table>'."\n";
}

?>
<iframe src="http://www.kal--online.com/assets/calculate/viewtrees_e.php" width="100%" height="2000" name="SCTListShow" seamless="seamless">
<p>Ihr Browser kann leider keine eingebetteten Frames anzeigen</p>
</iframe>
{/source}