cityusers.php

<?php

/**************************************************************************************************
 * | Software Name        : Ravan Scripts Online Mafia Game
 * | Software Author      : Ravan Soft Tech
 * | Software Version     : Version 2.0.1 Build 2101
 * | Website              : http://www.ravan.info/
 * | E-mail               : support@ravan.info
 * |**************************************************************************************************

 * | The files in the package must not be distributed in whole or significant part.
 * | All code is copyrighted unless otherwise advised.
 * | Do Not Remove Powered By Ravan Scripts without permission .
 * |**************************************************************************************************
 * | Copyright (c) 2010 Ravan Scripts . All rights reserved.
 * |**************************************************************************************************/

include "globals.php";
global $db, $ir, $userid, $h, $db;
$cityname = $db->fetch_single($db->query("SELECT cityname FROM cities WHERE cityid = " . $ir['location']));
$location = $ir['location'];

$q = $db->query("SELECT * FROM users WHERE location = $location ORDER BY laston DESC ");


print"
<div class='generalinfo_txt'>
<div><img src='images/info_left.jpg' alt='' /></div>
<div class='info_mid'><h2 style='padding-top:10px;'> Players in your city - $cityname</h2></div>
<div><img src='images/info_right.jpg' alt='' /></div> </div>
<div class='generalinfo_simple'><br> <br><br>
<table width='90%' class= 'table' border='2' >
<td height='6'>
<div align='center'><strong>
<font color=white><u><font color=white></font>Order
</u></strong></u></div></td>
<td><div align='center'><strong>
<font color=white><u><font color=white><u></font>Name
</strong></u></div></td>
<td><div align='center'><strong>
<font color=white><u>ID</font></strong></u></div></td>
<td><div align='center'><strong>
<font color=white><u>Level</font></strong></u></div></td>
<td><div align='center'><strong>
<font color=white><u>Gender
<u/></strong></u></div></td>
<td><div align='center'><strong>
<font color=white><u>Last Online
<u/></strong></u></div></td>
<td><div align='center'><strong>
<font color=white><u>Money
<u/></strong></u></div></td>
<td><div align='center'><strong>
<font color=white><u>Attack
<u/></strong></u></div></td>
</tr>";

while ($r = $db->fetch_row($q)) {
    $la = time() - $r['laston'];
    $unit = "secs";
    if ($la >= 60) {
        $la = (int)($la / 60);
        $unit = "mins";
    }
    if ($la >= 60) {
        $la = (int)($la / 60);
        $unit = "hours";
        if ($la >= 24) {
            $la = (int)($la / 24);
            $unit = "days";
        }
    }
    if ($r['laston'] > 0) {
        $la = time() - $r['laston'];
        $unit = "seconds";
        if ($la >= 60) {
            $la = (int)($la / 60);
            $unit = "minutes";
        }
        if ($la >= 60) {
            $la = (int)($la / 60);
            $unit = "hours";
            if ($la >= 24) {
                $la = (int)($la / 24);
                $unit = "days";
            }
        }
        $str = "$la $unit ago";
    } else {
        $str = "--";
    }
    if ($r['last_login'] > 0) {
        $ll = time() - $r['last_login'];
        $unit2 = "seconds";
        if ($ll >= 60) {
            $ll = (int)($ll / 60);
            $unit2 = "minutes";
        }
        if ($ll >= 60) {
            $ll = (int)($ll / 60);
            $unit2 = "hours";
            if ($ll >= 24) {
                $ll = (int)($ll / 24);
                $unit2 = "days";
            }
        }
        $str2 = "$ll $unit2 ago";
    } else {
        $str2 = "--";
    }
    $money = money_formatter($r['money']);
    $cn++;


    print"

<tr>
<td><div align='center'><strong>
$cn.
</strong></div></td>
<td><div align='center'><strong>
<a href='viewuser.php?u={$r['userid']}'>{$r['username']}
</strong></div></td>
<td><div align='center'><strong>
{$r['userid']}<br/>
</strong></div></td>
<td><div align='center'><strong>
{$r['level']}<br>
</div></strong></td>
<td><div align='center'><strong>
{$r['gender']}<br />
</div></strong></td>
<td><div align='center'><strong>
$str<br />
</div></strong></td>
<td><div align='center'><strong>
$money</a><br />
</div></strong></td>
<td><div align='center'><strong>
<a href='attack.php?ID={$r['userid']}'>Attack</a><br />
</div></strong></td>
 ";
}

print "</table> </div><div><img src='images/generalinfo_btm.jpg' alt='' /></div><br></div></div></div></div></div> ";
$h->endpage();
?>