
02-03-2004, 10:58 AM
|
|
|
Join Date: Jan 2004
Location: Colorado
Posts: 319
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by EvilLS1
Just change the queries in timeslips.php so that it only selects from your specified usergroup like this:
Find:
Code:
// Get total number of users
$userscount=$DB_site->query_first("SELECT COUNT(*) AS users
FROM user,userfield
$cond
AND user.userid = userfield.userid");
Replace it with:
Code:
// Get total number of users
$userscount=$DB_site->query_first("SELECT COUNT(*) AS users
FROM user,userfield
$cond
AND user.userid = userfield.userid AND user.usergroupid = X");
Change the X to the usergroupid in this bit of code: user.usergroupid = X
Then find:
Code:
// Get users
$users=$DB_site->query("SELECT *
FROM user,userfield
WHERE user.userid = userfield.userid
$condition
ORDER BY $orderby $direction
LIMIT $pos,$perpage");
Replace it with:
Code:
// Get users
$users=$DB_site->query("SELECT *
FROM user,userfield
WHERE user.userid = userfield.userid
AND user.usergroupid = X
$condition
ORDER BY $orderby $direction
LIMIT $pos,$perpage");
Again, change the X in the code above to the usergroupid.
Is this in your forum directory? Try adding $bburl/ before timeslips.php. If that doesn't work just add the full url. If you can go to the page manually its gotta be just a typo in the URL or timeslips.php isn't in that directory.
|
EvilLS1 great support for a great hack. Thanks for the quick replies and help. I'll give them a shot.
|