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

[Floris]

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

[vertex]

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

[Q8vbhacks]

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

[vertex]

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

[kidney]

Originally posted by Q8vbhacks
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

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.

[kidney]

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

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:

$banuser=$DB_site->query_first("SELECT username,userid,usergroupid,customtitle,posts FROM user WHERE userid=$userid");
$ismod=$DB_site->query_first("SELECT moderatorid FROM moderator WHERE userid=$userid");

and replace it by:

$banby = $bbuserinfo['username'];
$banuser=$DB_site->query_first("SELECT username,userid,usergroupid,customtitle,posts FROM user WHERE userid=$userid");
$ismod=$DB_site->query_first("SELECT moderatorid FROM moderator WHERE userid=$userid");

in the same file look for:

$DB_site->query("UPDATE userfield SET field$banreasonfieldid='$banreason', field$banuntilfieldid='$banuntil', WHERE userid=$banuser[userid]");

and replace it with

$DB_site->query("UPDATE userfield SET field$banreasonfieldid='$banreason', field$banuntilfieldid='$banuntil', field$bannedbyfieldid='$banby' WHERE userid=$banuser[userid]");

and use my showbanned.php, and replace all the template with mine, it should be working fine after all that.



xiphoid

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

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

[voogru]

i keep getting this

Database error in vBulletin 2.2.5:

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

mysql error number: 1054

Date: Saturday 20th of April 2002 08:45:42 PM
Script: http://forums.voogru.com/showbanned.php
Referer:

[voogru]

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

[voogru]

n/m got it