REGISTER or LOGIN to have the annoying ads removed.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not show banned members on memberlist?
#1
Hello there!

Is it possible to not have the banned members on the memberlist?
Anyone?
Reply
#2
Not without a modification.
Reply
#3
I thought so...but with which mod I can do this?
Reply
#4
There isn't one. But IMHO you should be able to remove banned members from the member list as standard MyBB.
Reply
#5
Should be made in PHP...i've tried some things, but with no result.
Maybe some of my friends can change this...
Reply
#6
You can alter the actual sql query in the file. Add a "NOT in usergroup='7'" should do it.
Reply
#7
So this query:

$query = $db->query("
SELECT u.*, f.*
FROM ".TABLE_PREFIX."users u
LEFT JOIN ".TABLE_PREFIX."userfields f ON (f.ufid=u.uid)
WHERE {$search_query}
ORDER BY {$sort_field} {$sort_order}
LIMIT {$start}, {$per_page}
");
Reply
#8
Try this

$query = $db->query("
SELECT u.*, f.*
FROM ".TABLE_PREFIX."users u
LEFT JOIN ".TABLE_PREFIX."userfields f ON (f.ufid=u.uid)
WHERE {$search_query} AND usergroup != '7'
ORDER BY {$sort_field} {$sort_order}
LIMIT {$start}, {$per_page}
");
Reply
#9
works almost!
The're not on the list anymore...but now i've got a lot of empty pages...
see the attachment please.


Attached Files Thumbnail(s)
   
Reply
#10
Oh that's a join...try this:

$query = $db->query("
SELECT u.*, f.*
FROM ".TABLE_PREFIX."users u
LEFT JOIN ".TABLE_PREFIX."userfields f ON (f.ufid=u.uid)
WHERE {$search_query} AND u.usergroup != '7'
ORDER BY {$sort_field} {$sort_order}
LIMIT {$start}, {$per_page}
");
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  Members for a GTA Forum iRocker 7 3,724 Aug 11, 2015, 09:51 AM
Last Post: Windy
  Any ways to gather members to a forum? Zalix 5 2,170 Oct 14, 2012, 02:47 PM
Last Post: [email protected]
  Banned from HF for 2 months hostpro 6 1,630 Aug 30, 2012, 06:03 PM
Last Post: labrocca
  Do spam members help you get real members? iRun 8 3,005 Apr 28, 2012, 04:38 PM
Last Post: effecloky
  Any members that likes Pokemon? Nab 11 3,233 Apr 08, 2012, 06:13 PM
Last Post: Nab

Forum Jump:


Users browsing this thread: 1 Guest(s)