Banned Users List (with reason/date/who)
 

Here is a modification to a hack that already exist, but it adds by who the ban was made.

Here is an example of this hack
http://forum.dishwacker.com/showbanned.php

and here is the original hack
https://vborg.vbsupport.ru/showthrea...threadid=35979

Enjoy and let me if any problems occur

Can I limit this to only super/mods/admins can see this? I do not wish guests or registered members to see this.

great addon to supreem's hack, i believe i requested that = ] thanks, it would be better if only staff can see by who though.

thanks for hack but i have this problem

Database error in vBulletin: Invalid SQL:
SELECT
userfield.field6, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, userfield.field7, userfield.field8
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 'usergroup.showgroup' in 'where clause'
mysql error number: 1054

ok if i have the hack already by supreemball what is there to add thats different? is showbanned.php different?

You must create your fields before anything else and then add the mod to the config.php.

If you still have send your files i'll look into it when I have time.

Firts make sure that you create the extra and take down the ID that field and add to you config.php the following:
$bannedbyfieldid=7;

and the in the mod/user.php find:
and replace it by:
in the same file look for:
and replace it with
and use my showbanned.php, and replace all the template with mine, it should be working fine after all that.



xiphoid
That's on my todo list.....

i keep getting this

ok, it works now but now when i ban someone it will not show up in the showbanned thing

n/m got it

What for it is necessary to create new group Banned if is Banned by Moderators?
If a moderator ban someone, it can write for as up to what date? The user leaves from ban automatically whether or not?

Thanks for replies

Hm
I banned users. But this ban don't show in showbanned.php and by Who field empty in user profile.
(i'm Admin on my board)
Super Moderator try ban too, and result the same. :(
Help me please

Im getting the following. Done all as above, error is:

Invalid SQL:
SELECT
userfield.field5, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, userfield.field6, userfield.field
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.field5' in 'field list'

mysql error number: 1054

Anyone?

Running 2.2.4

Solved the above DB error, but when we ban a member its not being displayed in the showbanned page.

Any ideas.

Same here...

:(

Satan

Easily fixed - make sure that the usegroupid of the banned group in showbanned.php is the same as the usergroupid of your own forum. Otherwise it won't show.

I did...

It still doesnt show...

Satan