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

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

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?

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

ok try this, find where you added this

remove usergroup.showgroup = 1 so it looks like this
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

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

Heres the instructions

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

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

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/m...an&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

i guess no suport for this hack?

message me on aim ill help

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

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

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

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

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

Make Banned group. Or rename Banned by Moderators to Banned.

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

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!

I need some help.. can someone help?

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/showthrea...threadid=41346

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 ? :)

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?

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

http://www.teenadvicecenter.com/foru...showbanned.php

Anyone?

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

Rawr! Is this hack compatible with 2.2.9?

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.

/me clicks install

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

showbanned.php/images

on the showbanned page?

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

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

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

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?

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?

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'

Will this be available for vB3?