Banned Users List (with reason/date)

[supreemball]

here it is, the Banned Users List hack, originally done by my host wired @ www.xirgo.com but he gave me rights to release it here..

basically this hack lists all banned users along with a reason for each user being banned, as well as the date they should be unbanned. this is VERY convenient for my mods over at my forum, as there was always talk of wondering who was banned and why, and with this hack this talk shall cease to exist. this is also great just to get your bannings organized and see how many users are banned in the first place.

a live demo of this hack is viewable on my forum: www.somethingleet.com/forum/showbanned.php ..

also when a mod bans someone from the mod cp, the reason and date is asked. the date doesn't have to be in a date format, it can be just 'forever' or something.

this hack has only been completely tested on vb2.2.2.. as of tomorrow it will be tested on vb2.2.4 when i upgrade my forum.

let me know what you guys think :)

[sleepbirdcyp]

Great!!!

[SaintDog]

Nice hack, great job!

Will this seperate onto multiple pages or will it continue all on one page (if yes to one page, could you make it to where after 10-20 members, it would split to multiple pages?).

SaintDog

[Lesane]

Nice hack, well done.

[Floris]

Way cool :) fnx :)

[Dalius]

Good job!

[ExcErr]

may be some screenshots?

[Dalius]

I got a feature Request, it's probably easy

can you add the Ban Thingy from the Mod CP to the Admin CP?

[supreemball]

Originally posted by SaintDog
Nice hack, great job!

Will this seperate onto multiple pages or will it continue all on one page (if yes to one page, could you make it to where after 10-20 members, it would split to multiple pages?).

SaintDog

as of now there unfortunately isn't any page seperation.. not sure if wired (who released it) will add this or not..

excerr: view www.somethingleet.com/forum/showbanned.php for the demo.

dalius: all you would do in the admin cp (a bit different from the mod cp) is change the user status to Banned in the User editor, and then go down to the bottom to the added Custom Profile fields and fill in the "Banned for" and "Banned until" fields, and then click submit. :)

[Dalius]

Ah, thanks supreem

[dawl]

I get an empty page even though I have 2 members in the "Banned" group...any ideas ?

[69-FLy-gUy]

same here...

[Bald Bouncer]

Originally posted by dawl
I get an empty page even though I have 2 members in the "Banned" group...any ideas ?

open up showbanned.php and find


$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 AND usergroup.usergroupid = 15


change 15 to your banned usergroup ;)

[Robert9]

basically.. add two fields to user profile for the reason of banning, and the length of the ban.

create a new user group called "Banned" (exact name/case required) and set permissions as you wish
(most likely you would set them all to 'No')

edit your config.php and add

-----------V
wherever i want??

//set fieldid's of banreason field and banuser field
$banreasonfieldid=10;
$banuntilfieldid=11;

-----------^

to the bottom of it, replacing '10' and '11' with the fieldid's of the reason and until field respectively.




Red= i don't understand, can somebody post an example code, because i don't know, how to make 2 new fields!
Green= Question by me
thx in adnace

DoDgE

[69-FLy-gUy]

in your admin CP... go to add under User Profile Fields..

then once the two profiles are created... look at the ID's of each one.. then edit it as requested for the config.php file.....

[69-FLy-gUy]

i tried editing the showbanned. but it still isn't working. very weird.

[dawl]

same here

[69-FLy-gUy]

dawl.. if you get it workin, let me know=)

[dawl]

sure will - i'm chalking it up to being sick, i'm obviously missing something simple...the fever has the brain garbled LOL I'll keep tinkering and let you know.

[fonzerelli_79]

i get this dtatbase error

Database error in vBulletin 2.2.0:

Invalid SQL:
SELECT
userfield.field10, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, userfield.field11
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1 AND usergroup.usergroupid = 10

mysql error: Unknown column 'userfield.field10' in 'field list'

[Robert9]

it worked nice, THX!

[Bald Bouncer]

Originally posted by 69-FLy-gUy
i tried editing the showbanned. but it still isn't working. very weird.

have you done what I said?? get the usergroup number and place it at that part in showbanned.php??

worked for me! ;)

[dawl]

sure did, i'm clueless here, i've looked over showbanned.php a dozen times and can find nothing wrong, the usergroup is set to what it should be, I verified I had the right group # about 10 times LOL I still get a blank page...strange, very strange.

[Bald Bouncer]

LMK were your forum is and I'll take a look if you want

[Barret]

Originally posted by 69-FLy-gUy
in your admin CP... go to add under User Profile Fields..

then once the two profiles are created... look at the ID's of each one.. then edit it as requested for the config.php file.....

Looks like neat hack but I can`t get the ids. :(

[irn-bru]

I get a blank page on showbanned.php.
I have made the changes to the showbanned.php
usergroupid to reflect the banned user group, number 10.

I also checked the profile fields on the db and they
match up with what I put in the config.php , so np there.

But blank page?

[irn-bru]

ah ha heres a tip :)

Viewable on Show Group=YES

In the install txt its written "(most likely you would set them all to 'No'"

This might be the problem, if anyone is still haveing them try this :)

Kewl hack...

edit: any help in getting banned users off the forum leaders
page . thanx

[69-FLy-gUy]

put it is yes? i will try it

EDIT-> Yup it works.... i tested it..

You have to put showable on groups as yes

[Whome]

Thank you...very useful :)

[Barret]

How do you get the id of the new usergroups?

[cerebro]

Put the mouse over the EDIT link in the User CP / User Profile Field

and you will see
......action=edit&profilefieldid=5
There you have the ID...5 in this case!

That is the way i use...good luck

[cerebro]

in the Template showbanned

in the line

<table align="center"><tr><td>
$groupbits
<table cellpadding=0 cellspacing=0 border=0 bgcolor="{tablebordercolor}" align="center" width=100%><tr><td>
</td></tr></table>

You forget the " " to the width=100%
and in the other template to!

Correct that, and add a better install.txt

Thanks!

[Capt PPRuNe]

Why does it have to show up on 'Show Groups'? Is there a way to prevent that from happening? I understand why it has to be set to 'Yes' in the control panel.

Also, where do I edit either the templates or sripts so that when a moderator is in their own forum the option to ban shows up in the 'Admin Options' drop down menu?

Is there a way for a moderator to unban someone after they have banned someone? :paranoid:

[Jawelin]

Great hack!

Just a question (or extension? ) : How could I avoid banned users be able to modify - accessing the userCP - their own email or password or some other data ? Above all, email... ;)
Some banned user changed email to a non-existing one just to re-subscribe with the old one. Neither he would create another account !!!

Thanks

[Jawelin]

^BUMP^

[datatec]

Hey sounds really brilliant - does it work on 2.2.4 ?!?!?!?

Thanks in advance

[kidney]

If anyone need to add by who the person was banned by let me know I will release it if it's needed by someone else.
Example: http://forum.dishwacker.com/showbanned.php

[Marshalus]

I think that is needed.

[Jawelin]

Originally posted by kidney
If anyone need to add by who the person was banned by let me know I will release it if it's needed by someone else.
Example: http://forum.dishwacker.com/showbanned.php
Here I'm !!! :)
Besides, I asked also for a general feature: how to avoid a banned user could access to his post (editing and deleting them) and his UserCP to change email or something else... ??

Thanks.
I'll wait for your upgraded version

[kidney]

here it is.....
https://vborg.vbsupport.ru/showthread.php?s=&threadid=36819

[Slynderdale]

ok, if you still want the banned list without having the users show in thw show groups remove usergroup.showgroup = 1 so it looks like this. remember to change 9 to your banned usergroup


// 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 = 9
");

[Webdude?]

Originally posted by fonzerelli_79
i get this dtatbase error

Database error in vBulletin 2.2.0:

Invalid SQL:
SELECT
userfield.field10, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, userfield.field11
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1 AND usergroup.usergroupid = 10

mysql error: Unknown column 'userfield.field10' in 'field list'

Anyone have an answer to this? I get the same thing.

[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?

[Slynderdale]

Originally posted by Webdude?


Anyone have an answer to this? I get the same thing.

When you made the new profile fields did you put them in numerical order from the last profile field, so if the original ones were 1 2 3 4 and you added a new one and names it 10 youll get the error so give it the value after the last one so if the original ones were 1 2 3 4 names the new ones 5 6 and change it in the config file, i had the same problem and this fixed it

[Slynderdale]

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


// 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

// 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

[Slynderdale]

If you wanna show who banned them, in the showbanned.php first install the hack then after you installed it follow the text in the next post, the screen shot is below

[Slynderdale]

Heres the instructions

[inetd]

What for it is necessary to create new group Banned if is Banned by Moderators?

[inetd]

When Administrator or Super Moderator ban users, in showbanned.php don't show By Who.
Help me please!
And: add unban to mod CP - good suggestion. Please make this :)

[Slynderdale]

Originally posted by inetd
When Administrator or Super Moderator ban users, in showbanned.php don't show By Who.
Help me please!
And: add unban to mod CP - good suggestion. Please make this :)
ill make unban too, but if you use the admin cp, yoiu muest put in your name and when manualy in the account, if you use the mod cp, it adds your account to why you ban them manually, and i have it so if a mod banns some one it sets there user title to banned by moderator, it doesnt matter what the usergroup has

[GOD-Dblade]

bleh i feel like a n00b well...this is what i got
Database error in vBulletin Mod Control Panel 2.2.5:

Invalid SQL: UPDATE user SET usergroupid=8 WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Sunday 12th of May 2002 09:07:20 PM
Script: http://www.gods-network.com/forums/forums/mod/user.php
Referer: http://www.gods-network.com/forums/mod/user.php?action=ban&userid=2476

in my config file i have
//set fieldid's of banreason field and banuser field
$banreasonfieldid=8;
$banuntilfieldid=9;

and i also changed in showbanned.php to try to fix it this
$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 AND usergroup.usergroupid = 15

to

$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 AND usergroup.usergroupid = 8

[GOD-Dblade]

i guess no suport for this hack?

[Slynderdale]

message me on aim ill help

[Dalius]

Can I make it so the banned users only show up on the Banned list, not the Forum Leaders list (showgroups.php)

[Slynderdale]

Originally posted by Dalius
Can I make it so the banned users only show up on the Banned list, not the Forum Leaders list (showgroups.php)

i explained how in previouse posts

[Matt87]

I got it to work... nevermind...lol

[vBHackz]

I dont understand, I make 1 user group for the banned user, and another one to show why he/she has been banned?

[vBHackz]

Im very lost, and super confused, someone help lol :(

[vBHackz]

...............................

[inetd]

Originally posted by vBHackz
I dont understand, I make 1 user group for the banned user, and another one to show why he/she has been banned? Make Banned group. Or rename Banned by Moderators to Banned.

[Slynderdale]

the only thing banned by moderators is, it sets the user title to banned by moderators thats all, you dont need to make a new grouple for it, just banned, thats all

[remedy]

I've followed everything in this thread to the letter, double checked everything.. banned some users and added reasons, etc. but the showbanned.php always shows up blank.

im using vB 2.2.6 ... if you can help please email me at remedy777@yahoo.com .. thanks!

[remedy]

I need some help.. can someone help?

[TreizeAtreides]

Im having a major problem with my forum. It has something to do with this hack I don't want to double post so detials can be found here: https://vborg.vbsupport.ru/showthread.php?s=&threadid=41346

[CRego3D]

Works Great :D

http://www.yaxay.com/yack/showbanned.php

Now, my question, is there a way to have this hack record and show the DATE the user was banned ? :)

[dotagious]

I have this working on 2.2.9 but banned users still appear on showgroups.php even after trying the fix mentioned in this thread. Any ideas?

[Andrew111888]

Umm... I banned a user, and set his usergroup to Banned, and when I go to showbanned, he isn't listed.

www.teenadvicecenter.com/forum/upload/showbanned.php

[Andrew111888]

Anyone?

[Andrew111888]

...........at all.....

[Andrew111888]

Rawr! Is this hack compatible with 2.2.9?

[irn-bru]

lo supreemball nice one works well got installed at my site.

Update your url btw.
http://www.somethingleet.com/forum/showbanned.php

A bit of topic...

*The Big Man* Violation of Forum Guideline #5 Forever.

That Beer Luver mod no like *The Big Man* but Bradley thought the "you are a idiot pop up hell" was great.

thanks for the hack.

[wooolF[RM]]

/me clicks install

[Xelation]

any reason why my images are all directing to...

showbanned.php/images

on the showbanned page?

[Dark Shogun]

Two questions.

1. Does this work with vb 2.3.0?
2. Is there a way to use this with the miserable banning hack?

Dark Shogun

[Alien]

...confirmed working on 2.3.0... Very nice job. :)

Anyone know how to get the actual date of the ban in the showbanned.php file? :D

[SinisterX]

looks good, wish i could get the day the person was banned tho.

[Gutspiller]

I get this error when I try and view showbanned.php

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin: Invalid SQL:
SELECT
userfield.field21, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, userfield.field22
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1 AND usergroup.usergroupid = 15

mysql error: Unknown column 'usergroup.showgroup' in 'where clause'
mysql error number: 1054
Date: Friday 04th of July 2003 06:47:56 PM
Script: /forumz/showbanned.php
Referer:

Any ideas?

[Shiekron]

Warning: mysql_pconnect(): Access denied for user: 'dorksnet@cp4.myhostdns.org' (Using password: YES) in /home/dorksnet/public_html/talk/admin/db_mysql.php on line 38

Anyone have an idea?

[Darkwaltz4]

shiekron, that means your config file is messed up, and the password to your database does not match.

also, i installed this hack just yesterday without reading this thread whatsoever, and i edited it greatly, creating my own 'banned by' and even (although i didnt know this was requested) a 'banned when'. i also ordered it alphabetically.
i also incorporated 2 drop down menus for the 'reason' and 'time' fields because my mods were not filling out the fields, so now they only have to select what they want it to be when they ban someone.

so, if youd like to see what im talking about,
http://forums.ffgon.com/showbanned.php

and like i said i made all the edits myself, i didnt even use the mod posted above for who banned, i havent even seen the inside of the attachment. if youd like to know what to do im me on something. note: since this hack is new on my board and weve had previous banned members, it still shows them up. i however defaulted them to have a 0 timestamp, and Unknown reasons and banners. for an actual person banned under the new edits, look at the user 'Inuyasha'

[lifesourcerec]

Will this be available for vB3?

[influence]

vb3 version of this coming out anytime soon?

[sully02]

vb3 version of this coming out anytime soon?
I would also love a vB3 version of this.

[fridayweb]

Putting in my vote for vb3 version as well. I had used this hack previously, but now with the upgrade, I just have one page with a banned showgroup all in a list. Looks pretty ugly. :p

[integra99]

vb3 for sure.

[Slynderdale]

Working on a vB 3 version of this.