Untitled

<?php
require_once 'settings/site.php';
$pageid = "2";
$siteid = "5";
$title  = "En iyi Üyeler";
error_reporting(E_ALL);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php require_once 'template/body.php'; ?>
</head>
<body>
<?php
require_once 'template/header.php';
require_once 'template/subheader.php';

    $krediqry = mysql_query("SELECT * FROM users WHERE rank > 3 ORDER BY credits DESC LIMIT 6") or die(mysql_error());
        $onlineqry = mysql_query("SELECT OnlineTime,id FROM user_stats ORDER BY OnlineTime DESC LIMIT 6") or die(mysql_error());

?>
<div id="content">
    <div id="box" style="margin-left:5px; margin-top:20px; width:99%;">
        <div class="titel plau">En fazla Kredi olan</div>
        <div style="margin-left:50px;">
            <?php while($kredi = mysql_fetch_object($krediqry)) { ?>
            <a onmouseover="tooltip.show('<?php echo $kredi->username; ?> <br /> <?php echo $kredi->credits; ?> Kredi <br /> Motto: <?php echo htmlspecialchars($kredi->motto); ?>');" onmouseout="tooltip.hide();" id="habbo" style="float:left; margin-right:10px;"><img src="http://habbo.nl/habbo-imaging/avatarimage?figure=<?php echo $kredi->look; ?>&size=l&direction=2&head_direction=3&gesture=sml&size=l" /></a>
            <?php } ?>
        </div>
    </div>
    <div id="box" style="margin-left:5px; margin-top:20px; width:99%;">
        <div class="titel hellrot">Online zamani</div>
        <div style="margin-left:50px;">
            <?php while($online = mysql_fetch_object($onlineqry)) {
                $userrowqry = mysql_query("SELECT * FROM users WHERE id='$online->id'") or die(mysql_error());
                while($userrow = mysql_fetch_object($userrowqry)) {
                ?><a onmouseover="tooltip.show('<?php echo $userrow->username; ?> <br /> <?php echo round($online->OnlineTime / 60 / 60).' Saat'; ?> <br /> Motto: <?php echo htmlspecialchars($userrow->motto); ?>');" onmouseout="tooltip.hide();" id="habbo" style="float:left; margin-left:10px;"><img src="http://habbo.nl/habbo-imaging/avatarimage?figure=<?php echo $userrow->look; ?>&size=l&direction=2&head_direction=3&gesture=sml&size=l" /></a>
            <?php } } ?>
        </div>
    </div>
    <?php require_once 'template/footer.php'; ?>
</div>