Quote:
Originally posted by streamzone
have a question on this i have installed it but the thing is, the page shows up but it doesnt list any person i have added too the banned group on the showbanned page any ideas what i might be?
|
ok try this, find where you added this
PHP Code:
// get banned users**********************************************************
$users = $DB_site->query("
SELECT
$banreasonfieldselect, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, $banuntilfieldselect
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1 usergroup.usergroupid = [EDIT ME]
");
remove usergroup.showgroup = 1 so it looks like this
PHP Code:
// get banned users**********************************************************
$users = $DB_site->query("
SELECT
$banreasonfieldselect, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, $banuntilfieldselect
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.usergroupid = [EDIT ME]
");
now the banned usergrop can be hidden from the forum leader section and still show up in the banned usergroup, see where it says [EDIT ME] change that to the banned usergroup number