Untitled

<?php

// Require MySQL Connector
require("connector.php");

// MySQL Queries
$onlinetime = mysql_query("SELECT * FROM `lb-players` ORDER BY onlinetime DESC");

// Permissions Group
function permissionsgroup($username) {

    $uname = mysql_real_escape_string($username);
    $query = mysql_query("SELECT * FROM permissions_inheritance WHERE child='$uname'");
        if (mysql_num_rows($query) != 1) { return "ERROR"; } else {
    $result = mysql_fetch_array($query);
    $group = $result['parent'];

    if ($group == 'admins') { $color="FF0000"; }
    elseif ($group == 'moderators') { $color="55FFFF"; }
    elseif ($group == 'members') { $color="0000FF"; }
    elseif ($group == 'guests') { $color="777777"; }
    else ($color="000000");

    return '<font color="#' . $color . '">' . ucfirst($group) . '</font>';
    }
}

// iConomy Balance
function iconomybalance($username) {

    $uname = mysql_real_escape_string($username);
    $query = mysql_query("SELECT * FROM iconomy WHERE username='$uname'");
        if (mysql_num_rows($query) != 1) { return "ERROR"; } else {
    $result = mysql_fetch_array($query);
    return $result['balance'];
    }
}

echo '
<html>
    <head>
        <title>Beaverville Seniority</title>
        <style type="text/css">
        html { font-family: Sans-Serif }
        </style>
    </head>
    <body>
        <table cellpadding="5" cellspacing="1" border="1" align="center">
            <tr><td><b>Username</b></td><td><b>Online Time</b></td><td><b>Group</b></td><td><b>Money</b></td></tr>';

// Populate Table
    while($row = mysql_fetch_array($onlinetime))
    {
        if (iconomybalance($row['playername']) != 'ERROR') {
            echo "
                <tr><td>" . $row['playername'] . "</td>
                <td>" . $row['onlinetime'] . "</td>
                <td>" . permissionsgroup($row['playername']) . "</td>
                <td>" . iconomybalance($row['playername']) . "</td></tr>";
        } else { }
    }

echo '
        </table>
    </body>
</html>';
?>