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

[inetd]

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

[inetd]

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

[The Realist]

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

[The Realist]

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

Any ideas.

[Chris M]

Same here...



Satan

[Erwin]

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.

[Chris M]

I did...

It still doesnt show...

Satan