Untitled

<html>
<header>
<style>
table{
    background-color: #222222;
    width: 600px;
    border-style: solid;
    border-width: 1px;
    border-color: #000;
    border-spacing: 0px;
    padding: 5px 5px 5px 5px;
    border-radius: 8px;
    -webkit-border-radius: 8px;
    -moz-border-radius: 8px;
}

tr, td {
    background-color: #222222;
    width: 600px;
    border-style: solid;
    border-width: 1px;
    border-color: #000;
    border-spacing: 0px;
    padding: 5px 5px 5px 5px;
    margin: 2px 2px 2px 2px;
}
</style>
</header>
</html>

<?php


$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'test';


$conn = mysql_connect ($dbhost, $dbuser, $dbpass) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ($dbname) or die('Could not select the database ' . $dbname . '!');

$query  = "SELECT rp_name_first, cash, bank, time_played FROM perp_users";

$result = mysql_query($query);

print "<center><SPAN STYLE='font-size: 16pt; font-family: arial'><b>Server Stats</span>";


while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{

$money += $row['cash'] + $row['bank'];

$formattedTime = "0 Seconds";
$timePlayed = $row['time_played'];
$totalTime += $row['time_played'];


$numMonths = floor($totalTime / (60 * 60 *24 * 31));
$numWeeks = floor($totalTime / (60 * 60 *24 * 7));
$numDays = floor($totalTime / (60 * 60 *24));
$numHours = floor($totalTime / (60 * 60));
$numMinutes = floor($totalTime / 60);
$numSeconds = floor($totalTime);

    if (numMonths != 0)
    {
    $formattedTime = $numMonths." "."Month";
        if ($numMonths > 1)
            {
            $formattedTime = $formattedTime."s";
            }
    }
    elseif ($numWeeks != 0)
        {
        $formattedTime = $numWeeks." "."Week";
            if ($numWeeks > 1)
            {
            $formattedTime = $formattedTime."s";
            }
        }
    elseif ($numDays != 0)
        {
        $formattedTime = $numDays." "."Day";
            if ($numDays > 1)
            {
            $formattedTime = $formattedTime."s";
            }
        }
    elseif ($numHours != 0)
        {
        $formattedTime = $numHours." "."Hour";
            if ($numHours > 1)
            {
            $formattedTime = $formattedTime."s";
            }
        }
    elseif ($numMinutes != 0)
        {
        $formattedTime = $numMinutes." "."Minute";
            if ($numMinutes > 1)
            {
            $formattedTime = $formattedTime."s";
            }
        }
    else
        {
        $formattedTime = $numSeconds." "."Second";
            if ($numDays > 1)
            {
            $formattedTime = $formattedTime."s";
            }
        }

}
$totalmoney = number_format($money);

echo "
<table>

    <tr>
        <td><b>Total Money</b></td>

        <td><b>Total Time</b></td>

    </tr>

    <tr>
        <td><b>$" . $totalmoney . "</b></td>

        <td><b>{$formattedTime}</b></td>

    </tr>

</table>";

$query  = "SELECT rp_name_first, rp_name_last, TIME_PLAYED, cash, bank FROM perp_users";
$result = mysql_query($query);

echo "<br><br> <SPAN STYLE='font-size: 16pt; font-family: arial'><b>Player Stats</span>
        <table>
            <tr>
                <td><b>Name</b></td>
                <td><b>Playtime</b></td>
                <td><b>Money</b></td>
            </tr>
     ";

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{


$formattedTime = "0 Seconds";
$timePlayed = $row['TIME_PLAYED'];

$numMonths = floor($timePlayed / (60 * 60 *24 * 31));
$numWeeks = floor($timePlayed / (60 * 60 *24 * 7));
$numDays = floor($timePlayed / (60 * 60 *24));
$numHours = floor($timePlayed / (60 * 60));
$numMinutes = floor($timePlayed / 60);
$numSeconds = floor($timePlayed);

    if (numMonths != 0)
    {
    $formattedTime = $numMonths." "."Month";
        if ($numMonths > 1)
            {
            $formattedTime = $formattedTime."s";
            }
    }
    elseif ($numWeeks != 0)
        {
        $formattedTime = $numWeeks." "."Week";
            if ($numWeeks > 1)
            {
            $formattedTime = $formattedTime."s";
            }
        }
    elseif ($numDays != 0)
        {
        $formattedTime = $numDays." "."Day";
            if ($numDays > 1)
            {
            $formattedTime = $formattedTime."s";
            }
        }
    elseif ($numHours != 0)
        {
        $formattedTime = $numHours." "."Hour";
            if ($numHours > 1)
            {
            $formattedTime = $formattedTime."s";
            }
        }
    elseif ($numMinutes != 0)
        {
        $formattedTime = $numMinutes." "."Minute";
            if ($numMinutes > 1)
            {
            $formattedTime = $formattedTime."s";
            }
        }
    else
        {
        $formattedTime = $numSeconds." "."Second";
            if ($numDays > 1)
            {
            $formattedTime = $formattedTime."s";
            }
        }

    $formattedMoney = $row['cash'] + $row['bank'];

echo "
        <tr>
            <td>{$row['rp_name_first']} {$row['rp_name_last']}</td>
            <td>{$formattedTime}</td>
            <td>$" . $formattedMoney . "</td>
        </tr>
    </table>
     ";
}

?>