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

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

[Slybone]

Originally Posted by nexialys

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....48&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/forum...Dedit%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]

Originally Posted by Slybone

*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]

1. 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)
2. In modcp/banning.php FIND
   
   PHP Code:

   // check that the target usergroup is valid 
   

   ABOVE that ADD
   
   PHP Code:

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