[Release] CharCreate Panel Website

<?php
{
// CONFIG
$odbc_host = 'Dein_PC/SQLExpress';
$odbc_user = 'sa';
$odbc_pass = 'DeinSAPasswort';
// CONFIG END

echo '<h1>Hier seht ihr wann alle Charactere erstellt wurden sind</h1>';
$odbc_link = odbc_connect ( "Driver={SQL Server};Server=".$odbc_host.";Database=Character_C N;" , $odbc_user , $odbc_pass );

$sql[1] = 'SELECT sID, dCreateDate FROM tCharacter WHERE bDeleted = 0 ORDER BY dCreateDate DESC';
$rs[1] = odbc_exec ( $odbc_link , $sql[1] );
if ( !$rs[1] )
{
exit ( 'Error in SQL' );
}

$i = 1;

echo '<table width="100%">';
echo ' <tr>';
echo ' <td>';
echo ' Nr.';
echo ' </td>';
echo ' <td>';
echo ' Name';
echo ' </td>';
echo ' <td>';
echo ' Datum';
echo ' </td>';
echo ' </tr>';
while ( odbc_fetch_row ( $rs[1] ) )
{
$sID = odbc_result ( $rs[1] , 'sID' );
$dCreateDate = odbc_result ( $rs[1] , 'dCreateDate' );
$sID = str_replace ( 'ä' , 'ä' , str_replace ( 'Ä' , '&Auml;' , str_replace ( 'ö' , 'ö' , str_replace ( 'Ö' , '&Ouml;' , str_replace ( 'ü' , 'ü' , str_replace ( 'Ü' , '&Uuml;' , str_replace ( 'ß' , '&szlig;' , $sID ) ) ) ) ) ) );

$date_time = new DateTime($dCreateDate);

echo '<tr>';
echo '<td>'.$i.'</td>';
echo '<td>'.$sID.'</td>';
echo '<td>Character erstellt am '. $date_time->format('d.m.Y') .' um '.$date_time->format('H:i').'Uhr.</td>';
echo '</tr>';

$i++;
}

odbc_close ( $odbc_link );

echo '</table>';
}
?>