could someone look through the sql at the top and tell me if it is correct and the way the ranks are called from the sql thanks
BTW not my staff list just using this one before i change my staff list
<?php
include "globals.php";
$staff=array();
$q=$db->query("SELECT u.*,s.*,c.* FROM users u LEFT JOIN staff_users s ON u.userid=s.id LEFT JOIN gangs c ON u.gang=c.gangID ORDER BY userid ASC");
while($r=$db->fetch_row($q))
{
$staff[$r['userid']]=$r;
}
echo"<table width=100% border=1 style=text-align:center; class=table>";
print "
<h2 style='padding-top:10px;'> Staff List</h2></div>
[b]Admins[/b]
<table width=80% border=1 style=text-align:center; class=table><tr style='background:gray'><th>User</th> <th>Duties</th> <th>Level</th> <th>Money</th>
<th>Last Seen</th> <th>Status</th> </tr>";
foreach($staff as $r)
{
if($r['rank']==Admin)
{
if ($r['gangPREF'] != "")
{
$gangtag = "[url='gangs.php?action=view&ID={$r['][{$r['gangPREF']}][/url]";
} else {
$gangtag = "";
}
if($r['laston'] >= time()-15*60) { $on="<font color=green>[b]Online[/b]</font>"; } else { $on="<font color=red>[b]Offline[/b]</font>"; }
print "<tr> <td>[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$r['userid']}]</td> <td> {$r['duties']}</td> <td>{$r['level']}</td> <td>\${$r
['money']}</td> <td>".date('F j, Y, g:i:s a',$r['laston'])."</td> <td>$on</td> </tr>";
}
}
print "</table>";
print "[b]Secretaries[/b]
<table width=80% border=1 style=text-align:center; class=table><tr style='background:gray'><th>User</th> <th>Duties</th> <th>Level</th> <th>Money</th>
<th>Last Seen</th> <th>Status</th> </tr>";
foreach($staff as $r)
{
if($r['rank']==GM)
{
if ($r['gangPREF'] != "")
{
$gangtag = "[url='gangs.php?action=view&ID={$r['][{$r['gangPREF']}][/url]";
} else {
$gangtag = "";
}
if($r['laston'] >= time()-15*60) { $on="<font color=green>[b]Online[/b]</font>"; } else { $on="<font color=red>[b]Offline[/b]</font>"; }
print "<tr> <td>[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$r['userid']}]</td> <td> {$r['duties']}</td> <td>{$r['level']}</td> <td>\${$r
['money']}</td> <td>".date('F j, Y, g:i:s a',$r['laston'])."</td> <td>$on</td> </tr>";
}
}
print "</table>";
print "[b]Assistants[/b]
<table width=80% border=1 style=text-align:center; class=table><tr style='background:gray'><th>User</th> <th>Duties</th> <th>Level</th> <th>Money</th>
<th>Last Seen</th> <th>Status</th> </tr>";
foreach($staff as $r)
{
if($r['rank']==FM)
{
if ($r['gangPREF'] != "")
{
$gangtag = "[url='gangs.php?action=view&ID={$r['][{$r['gangPREF']}][/url]";
} else {
$gangtag = "";
}
if($r['laston'] >= time()-15*60) { $on="<font color=green>[b]Online[/b]</font>"; } else { $on="<font color=red>[b]Offline[/b]</font>"; }
print "<tr> <td>[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$r['userid']}]</td> <td> {$r['duties']}</td> <td>{$r['level']}</td> <td>\${$r
['money']}</td> <td>".date('F j, Y, g:i:s a',$r['laston'])."</td> <td>$on</td> </tr>";
}
}
print "</table></div><div></div>
</div></div></div></div></div>";
$h->endpage();
?>