Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[FrankWiccan]

it seem that when you do a player serch the bots name (set as npc) show up
is there a way without a mod to make them invisible unless they are needed to attack?
IE they dont show up in serches
thanks

F.w

[Cronus]

You will need to edit the search page to not include npc's.
This should be fairly easy to do.

[Danny696]

Find the query, and add WHERE user_level != 0

[strats]

What about hiding the bots from the user list and and hall of fame?
Same kind of thing?

[Cronus]

Yes, basically the same exact code.
If you are having troubles let us know and we can be more descriptive.

[strats]

I will post up my userlist, could you tell me under what line I could place that code please.
Then after that I may be able to do my hall of fame myself.

Code: [Select]

<?php
include "globals.php";
$_GET['st'] = abs((int) $_GET['st']);
$st=($_GET['st']) ? $_GET['st'] : 0;
$by=($_GET['by']) ? $_GET['by'] : 'userid';
$ord=($_GET['ord']) ? $_GET['ord'] : 'ASC';
print "<h3>Userlist</h3>";
$cnt=mysql_query("SELECT userid FROM users",$c);
$membs=mysql_num_rows($cnt);
$pages=(int) ($membs/100)+1;
if($membs % 100 == 0)
{
$pages--;
}
print "Pages: ";
for($i=1;$i <= $pages;$i++)
{
$stl=($i-1)*100;
print "<a href='userlist.php?st=$stl&by=$by&ord=$ord'>$i</a>&nbsp;";
}
print "<br />
Order By: <a href='userlist.php?st=$st&by=userid&ord=$ord'>User ID</a>&nbsp;| <a href='userlist.php?st=$st&by=username&ord=$ord'>Username</a>&nbsp;| <a href='userlist.php?st=$st&by=level&ord=$ord'>Level</a>&nbsp;| <a href='userlist.php?st=$st&by=money&ord=$ord'>Money</a><br />
<a href='userlist.php?st=$st&by=$by&ord=asc'>Ascending</a>&nbsp;| <a href='userlist.php?st=$st&by=$by&ord=desc'>Descending</a><br /><br />";
$q=$db->query("SELECT u.*,g.* FROM users u LEFT JOIN gangs g ON u.gang=g.gangID ORDER BY $by $ord LIMIT $st,100");
$no1=$st+1;
$no2=$st+100;
print "Showing users $no1 to $no2 by order of $by $ord.
<table width=75% cellspacing=1 class='table'><tr style='background:gray'><th>ID</th><th>Name</th><th>Money</th><th>Level</th><th>Gender</th><th>Online</th><th>Status</th></tr>";
while($r=$db->fetch_row($q))
{
$d="";
if($r['donatordays']) { $r['username'] = "<font color=black>{$r['username']}</font>";$d="<img src='donator.gif' alt='Donator: {$r['donatordays']} Days Left' title='Donator: {$r['donatordays']} Days Left' />"; }
print "<tr><td>{$r['userid']}</td><td><a href='viewuser.php?u={$r['userid']}'>{$r['gangPREF']} {$r['username']} $d</a></td><td>\${$r['money']}</td><td>{$r['level']}</td><td>{$r['gender']}</td><td>";
if($r['laston'] >= time()-15*60)
{
print "<font color=green><b>Online</b></font>";
}
else
{
print "<font color=red><b>Offline</b></font>";
}
print "</td><td>";
if ($r['owner'] == 1)
{
print "<font color=blue>Owner</font>";
}
elseif ($r['user_level'] == 2)
{
print "<font color=blue>Admin</font>";
}
elseif ($r['user_level'] == 3)
{
print "<font color=red>Secretary</font>";
}
elseif ($r['user_level'] == 4)
{
print "<font color=yellow>Assistant</font>";
}
elseif ($r['user_level'] == 5)
{
print "<font color=purple>Modorator</font>";
}
elseif ($r['user_level'] == 6)
{
print "<font color=cyan>Helper</font>";
}
else
{
print "<font color=black>Member</font>";
}
print "</td></tr>";
}
print "</table>";

$h->endpage();
?>

[Danny696]

$cnt=mysql_query("SELECT userid FROM users",$c); change to $cnt=mysql_query("SELECT userid FROM users WHERE user_level != 0",$c);
$q=$db->query("SELECT u.*,g.* FROM users u LEFT JOIN gangs g ON u.gang=g.gangID ORDER BY $by $ord LIMIT $st,100"); change to (not sure about this)
$q=$db->query("SELECT u.*,g.* FROM users WHERE user_level>0 u LEFT JOIN gangs g ON u.gang=g.gangID ORDER BY $by $ord LIMIT $st,100");

[strats]

Your way gives this error :

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'u LEFT JOIN gangs g ON u.gang=g.gangID ORDER BY userid ASC LIMIT 0,100' at line 1
Query was SELECT u.*,g.* FROM users WHERE user_level>0 u LEFT JOIN gangs g ON u.gang=g.gangID ORDER BY userid ASC LIMIT 0,100

[Danny696]

ahh rite ermm try $q=$db->query("SELECT u.*,g.* FROM users u WHERE u.user_level>0 LEFT JOIN gangs g ON u.gang=g.gangID ORDER BY $by $ord LIMIT $st,100");

[Maketextgames.com]

Get at me later and i'll walk you and red through this if you havent got it done yet

[strats]

Nope Danny that did not work, Immortal?

[Danny696]

$q=$db->query("SELECT u.*,g.* FROM users u ON u.user_level>0 LEFT JOIN gangs g ON u.gang=g.gangID ORDER BY $by $ord LIMIT $st,100"); fixed i think

[ReignFire]

not sure if you got it working but i did this


$q=$db->query("SELECT u.*,g.* FROM users u LEFT JOIN gangs g ON g.gangID=u.gang WHERE u.user_level !=0 $myf ORDER BY level DESC,userid ASC LIMIT 20");