Spieler Liste Ohne Wordpress einbindung

<?php



/*



    Template Name: Spieler_Liste



*/



?>
<?php get_header() ?>
<div id="container">
<div id="slider-container" style="display:<?php echo stripslashes(get_option('tme_slider')); ?>;">
<div id="slider" style="display:<?php echo stripslashes(get_option('tme_slider')); ?>;">
<?php $my_query = new WP_Query('showposts=5&category_name=featured'); while ($my_query->have_posts()) : $my_query->the_post(); ?>
<a href="<?php the_permalink() ?>" title="<?php the_title(); ?>">
<img class="nivoSlider" src="<?php echo get_post_meta($post->ID, 'nivoimage', true); ?>" alt="" title="<?php the_title(); ?>" />
</a>
<?php endwhile; ?>
</div>
<br clear="all" />
</div>
<div id="fullwide">
<?php the_post() ?>
<div id="posttop_full"></div>
<div id="post_full-<?php the_ID(); ?>" class="post_full">
<h1 class="post-title-fulwide"></h1>
<div class="post-content2">
<?php the_content() ?>
<!--Hier kommt meine Liste rein-->

<div id="h1">
<?php
if (get_option('tme_dbu')) {
echo "<h1>".(get_option('tme_dbu'))."</h1>";
} else {
echo "<h1>Dicecraft Player Liste</h1>";
}
?>
</div>


<?php
if (get_option('tme_PORT')) {
$port = stripslashes(get_option('tme_PORT'));;
} else {
$port = 25565; }

if (get_option('tme_IP')) {
$ip = stripslashes(get_option('tme_IP'));;
} else {
$ip = "217.198.131.160";  }
$txt = ("<span style='color: #99876C'>Spieler: ");
$server = ("<span style='color: #99876C'>Server Status: </span>");
    print $iptxt;
    $fp = @fsockopen($ip, $port, $errno, $errmsg, 10);
    if (!$fp) {
    $status = ($server ."<span style='color: #FF7D2D'>OFFLINE</span>");
                $parts[0] = "Keine Informationen";
                $parts[1] = 0;
                $parts[2] = 0;
    } else {
        $status = ($server ."<span style='color: #858720'>ONLINE</span>");
        fwrite($fp, "\xFE");
        $answer = fread($fp, 256);
            if ($answer[0] != "\xFF") {
                $parts[0] = "Keine Informationen";
                $parts[1] = 0;
                $parts[2] = 0;
                fclose($fp);
            } else {
                $text = substr($answer, 3);
        $text = mb_convert_encoding($text, 'auto', 'UCS-2');
        $parts = explode("\xA7", $text);
        $spieler = ($txt . "<span style='color:black'> (" . $parts[1] . "/" . $parts[2] . ")</span>");
        $MOTD = ("<span style='color: #99876C'>" . $parts[0] ."</span>");
        Global $status, $spieler, $MOTD;
}
}
?>
<div id="status">
<div id="status_text">
<a><?php echo $spieler; ?></a></br>
<a style="color:#99876C">MOTD: <?php echo $MOTD; ?></a></br>
</div>

<div id="status_online_offline">
<a><?php echo $status; ?></a>
</div>
</div>


<table class="tabelle" cellpadding="15" border="0">
<tr>
<th>Spieler</th>
<th></th>
<th>Zuletzt Online am</th>
<th>Beigetreten am</th>
<th>Spielzeit</th>
<th>Bl&ouml;cke Zerst&ouml;rt</th>
<th>Bl&ouml;cke Gesetzt</th>
</tr>
<?php
//Hier muss der name der datenbank rein
$dbname="ni24674_1_DB";
//datenbank ip oder domain
$dbhost="217.198.131.160";
//datebank benutzer
$dbuser="ni24674_1_DB";
//datenbank password
$dbpass="lol123";
//Tabellen Name
$db_tabele = "stats";
//Spieler Feld
$db_field_player = "player";
//Wie Oft der Spieler schon Online War
$db_field_joins = "joins";
//Wan Der Spieler Zuletzt Online War (timestamp)
$db_field_lastjoin = "lastjoin";
//Spielzeit
$db_field_playtime = "playtime";
//Wan Der Spieler zuerst online war(timestamp)
$db_field_firstjoin = "firstjoin";
$db_field_chatchar = "chatchar";
$db_field_chats = "chats";
//Wie viele Blöcke er schon Platziert hat
$db_field_placed = "placed";
//Wie viele Blöcke er schon Zerstört hat
$db_field_broke = "broke";
//Datums format
$datums_format = 'd.m.Y';
//Zeit Format
$zeit_format = 'H:i';


function intervall($sek) {
    $i = sprintf('%d T%s, %d H%s,'.
            ' %d Min%s %d Sek%s',
            $sek / 86400,
            floor($sek / 86400) != 1 ? '':'',
            $sek / 3600 % 24,
            floor($sek / 3600 % 24) != 1 ? '':'',
            $sek / 60 % 60,
            floor($sek / 60 % 60) != 1 ? '':'',
            $sek % 60,
            floor($sek % 60) != 1 ? '':''
         );
    return $i;
}



mysql_connect( $dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
$res = mysql_query('select * from '.$db_tabele);
while($dsatz = mysql_fetch_assoc($res))
{
$spieler = $dsatz[$db_field_player];
echo '<tr>';
//Spieler Name
echo '<td>'.$spieler.'</td>';
//Spieler Skin

$skin = 'https://minotar.net/avatar/'.$spieler.'/30';
echo '<td><img src="'.$skin.'"></td>';
//Last Join
$timestamp_last = $dsatz[$db_field_lastjoin];
$datum = date($datums_format,$timestamp_last);
echo '<td>'.$datum.'</td>';
//First Join
$timestamp_last = $dsatz[$db_field_firstjoin];
$datum = date($datums_format,$timestamp_last);
echo '<td>'.$datum.'</td>';
//Spielzeit
echo '<td>'.intervall($dsatz[$db_field_playtime]).'</td>';
//Zerstört
echo '<td>'.$dsatz[$db_field_broke].'</td>';
//Gesetzt
echo '<td>'.$dsatz[$db_field_placed].'</td>';
echo '</tr>';
}
?>

</table>

<!--Ende-->
</div>
</div>
<div id="post-bottom_full"></div><!-- .post -->
</div><!-- #content -->
</div><!--END SIDEBAR-->
<div style="clear: both"></div>
</div><!--END CONTAINER-->
<?php get_footer() ?>