<?php

echo "<h1>Ski Challenge 09 Mini-Archiv</h1>";

$player = isset($_POST['sc09_playername']) ? urldecode($_POST['sc09_playername']) : "Savant69";

if (count($_POST) == 0)
{
    echo "<form action='index.php' method='post'>\n
    <table>
    <tr>
    <td>Spielername:</td>
    <td><input type='text' name='sc09_playername' value='' maxlength='30' />
    </tr>
    <tr>
    <td colspan='2'><input type='submit' value='Daten abfragen' /></td>
    </tr>
    </table>
    </form>
    ";
}

function convertTime($time, $reverse = false)
{
    if ($time != "--") {
        if ($reverse == false) {
            // parse displayed time into sortable time
            $rawmins = explode(":",$time);
            $mins = str_pad(substr($rawmins[0], 0, 2), 2, '0', STR_PAD_LEFT);
            $rawsecs = explode(",",$rawmins[1]);
            $secs = str_pad(substr($rawsecs[0], 0, 2), 2, '0', STR_PAD_LEFT);
            $thou = str_pad(substr($rawsecs[1], 0, 3), 3, '0', STR_PAD_LEFT);
            $convertedTime = floatval((($mins * 60) + $secs) + ($thou / 1000));
        } else {
            // parse sortable time into displayed time
            $mins = substr(intval($time / 60), 0, 2);
            // $mins = str_pad(substr(intval($time / 60), 0, 2), 2, '0', STR_PAD_LEFT);
            $time = $time - ($mins * 60);
            $secs = str_pad(substr(intval ($time), 0, 2), 2, '0', STR_PAD_LEFT);
            $time -= $secs;
            $thoux = explode(".",$time);
            $thou = str_pad(substr($thoux[1], 0, 3), 3, '0', STR_PAD_RIGHT);

            $convertedTime = "$mins:$secs,$thou";
        }
    } else {
        $convertedTime = "--";
    }
    return $convertedTime;
}

$conn = mysql_connect("localhost","user","password") or die("DB connect error");

mysql_select_db("sc09");

$result = mysql_query("SELECT id FROM sc09_users WHERE username='" . $player . "'");

$line = mysql_fetch_assoc($result) or die("Rennläufer nicht gefunden!");


$result = mysql_query("SELECT * FROM sc09_results WHERE user_id='" . $line['id'] . "'");


while ($line = mysql_fetch_assoc($result))
{
    $results[$line['track']] = $line;
}

echo "<h2>Resultate f&uuml;r " . $player . "</h2>\n";
echo "<table width='20%'>
<tr>
<th align='left'>Strecke</th><th align='left'>Platz</th><th align='left'>Zeit</th>
</tr>";

$tracks = array(
  1 => "Gr&ouml;den",
  2 => "Bormio",
  3 => "Wengen",
  4 => "Kitzb&uuml;hel",
  5 => "Garmisch",
  6 => "Val d'Isere/WM",
);

foreach ($results AS $track => $stats)
{
    echo "<tr><td>" . $tracks[$track] . "</td><td>" . $stats['race_position'] . "</td><td>" . convertTime($stats['race_time'], true) . "</td></tr>";
}

echo "\n</table>\n";



?>