Who was banned

I wanted to show the list of "banned by moderators" members on my board. With vB2.03 It's very simple.

Find in memberlist.php

PHP Code:

if ($what=="datejoined") {
    $orderby="joindate";
    $direction="DESC";
  } 


Add the following below

PHP Code:

if ($what=="banned") {
    $condition="usergroupid=[COLOR=red]your_banned_usergroupid[/COLOR]";
    $orderby="lastpost";
    $direction="DESC";
  } 


Change your_banned_usergroupid according with your data.
In my case your_banned_usergroupid=39
Then find in template "memberlist"

<td bgcolor="#DFDFDF"><smallfont><a href="memberlist.php?s=$session[sessionhash]&what=datejoined"><b>List by Date Joined</b></a></smallfont></td>

Add just right after

<td bgcolor="#DFDFDF"><smallfont><a href="memberlist.php?s=$session[sessionhash]&what=banned"><b>Banned</b></a></smallfont></td>

That' all folks!

It works here

P.S. Of course, you can use the same procedure to show any other of your usergroups in the memberlist.

[Admin]

Good idea, good job!

[GenSec]

Change in the same template "memberlist" in navbar

<normalfont><b><a href="index.php?s=$session[sessionhash]">$bbtitle</a> &gt;
	Members List</b></normalfont>

to:

<normalfont><b><a href="index.php?s=$session[sessionhash]">$bbtitle</a> &gt;
	Members List ($what)</b></normalfont>

and you will know what you see.

Originally posted by GenSec
Change your_banned_usergroupid according with your data.
In my case your_banned_usergroupid=39

i did all except this step cause i didn't understand what should i do ?!

anyway i tried to start the function and got this error msg :

Database error in vBulletin: Invalid SQL: SELECT COUNT(*) AS users
FROM user,userfield
WHERE usergroupid=your_banned_usergroupid AND
user.userid = userfield.userid
AND usergroupid NOT IN (1,3,4)

mysql error: Unknown column 'your_banned_usergroupid' in 'where clause'
mysql error number: 1054
Date: Tuesday 02nd of October 2001 01:50:40 AM
Script: memberlist.php?s=&what=banned
Referer:


help needed, any ideas ?

[DarkReaper]

In the following line:

PHP Code:

$condition="usergroupid=your_banned_usergroupid"; 


You myust change "your_banned_usergroupid" to the id of the usergroup you have named as "Banned Users" or whatever.

[JJR512]

To find the usergroupid for your Banned by Moderators usergroup, go to your Admin CP, click the link to Modify under User Groups and Permissions, find the line in the list that says Banned by Moderators, and point to any of the links. In the status bar of your browser, at the end of the url it will say usergroup=xx, where xx is a number. This is the number you need to put inside the quotes for $condition=. In other words, if your Banned by Moderators usergroupid is 39, that line would be $condition="39".

[GenSec]

Originally posted by Delu


i did all except this step cause i didn't understand what should i do ?!

help needed, any ideas ?

Go to your admin CP -> Users Groups and Permissons -> Modify

You will see the list of your usergroups. Take mouse on [edit] or[list all users] options and look at status bar of your browser. You will find the id's of your usergroups. Something like http://......edit&usergroupid=NN

Change the code to:

PHP Code:

$condition="usergroupid=[COLOR=red]NN[/COLOR]"; 


[JJR512]

Are there maybe some additional instructions that you forgot to include in your post? Because this isn't working right for me. I have the number correct, I double and tripple checked. The problem is that when I click the Banned link, I get a list of all my members. All of them. I only have one banned member. But all my members are listed when I click Banned, only they are listed in a different order, but still, it's wrong.

[JJR512]

GenSec, isn't your last post the same thing I posted 12 minutes earlier?

[GenSec]

Originally posted by JJR512
GenSec, isn't your last post the same thing I posted 12 minutes earlier?

Yes! It means that It took me more than 12 min. to type the reply
And about your problem. Nothing else need to do. Check your usergroupid's. In default 1,3,4 can't be used for banned and others