Reason for banning

[Slybone]

When Banning a user I want to have a area where the admin/smod/mod can enter a reason for banning that user. then when you go to View Banned Users it displays the reason after Ban Period and Before Ban Will be Lifted on.

If anyone could help me out on this It would be greatly apreaciated

Thanks
-Slybone

[nexialys]

<a href="https://vborg.vbsupport.ru/showthread.php?t=59540" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=59540</a>

[Slybone]

https://vborg.vbsupport.ru/showthread.php?t=59540
Yes, I had seen that however what I am looking for is different... I want it to actually display the reason on the "View Banned Users"

[Andreas]

https://vborg.vbsupport.ru/showpost.php?p=537948&postcount=3
Let me know if it does work :)

[Slybone]

Hmmm, Lets see here...
After applying this Mod after banning a user I get a SQL error...


Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT user.userid, user.username, user.usergroupid AS busergroupid,
userban.usergroupid AS ousergroupid,
IF(userban.displaygroupid = 0, userban.usergroupid, userban.displaygroupid) AS odisplaygroupid,
bandate, liftdate, userban.banreason
adminuser.userid AS adminid, adminuser.username AS adminname
FROM user AS user
LEFT JOIN userban AS userban ON(userban.userid = user.userid)
LEFT JOIN user AS adminuser ON(adminuser.userid = userban.adminid)
WHERE user.usergroupid IN(8)
ORDER BY userban.liftdate ASC, user.username

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '.userid AS adminid, adminuser.username AS adminname
FROM use

mysql error number: 1064

Date: Saturday 31st of July 2004 10:15:00 PM
Script: http://www.neotek-networks.com/forums/modcp/banning.php
Referer: http://www.neotek-networks.com/forums/admincp/index.php?loc=user.php%3Fdo%3Dedit%26u%3D26
Username: Slybone
IP Address: 68.105.64.197

[Andreas]

There is a , missing after banreason.

[Slybone]

I see, works perfectly thanks

*EDIT* Is there anyway I can make it mandatory to enter a reason when banning a user?

[Andreas]

*EDIT* Is there anyway I can make it mandatory to enter a reason when banning a user?
Yes, this is possible.

[Slybone]

how would that be done?

[Andreas]

Add the following phrase to phrasegroup Control Panel Stop Messages:
varname=no_reason_given
text=You must enter a reason why you are going to ban this user
(Or any other text you would like to have as an error message if no reason is given)
In modcp/banning.php FIND

// check that the target usergroup is valid

ABOVE that ADD

if (!$banreason) {
print_stop_message('no_reason_given');
}

[Slybone]

Thank you KirbyDE, You have been a great help.

-Bone

[djjeffa]

will either of them hacks show the user why they were banned and for how long?

[djjeffa]

will either of them hacks show the user why they were banned and for how long?
bump if not is there a hack that dose that?

[Andreas]

No. This is only visible in Mod/Admin CP