Ban User

[giotmuadong]

I banned 1 spammers but I forgot to list the reason. Is there a way that I can edit the reason without lift ban then ban them again?

[WhaLberg]

By a mysql query, you can do this. Here is the query:

UPDATE prefix_userban SET reason='reasonhere' WHERE username='username'

[giotmuadong]

can you tell me where should i paste that, i'm new to this one. Thanks ^_^

[WhaLberg]

Paste that to: AdminCP -> Maintenance -> Execute SQL Query

Warning: To execute sql queries on vBulletin, you have to set this line in config.php:

PHP Code:

$config['SpecialUsers']['canrunqueries'] = ''; 


[giotmuadong]

under this right?

****** USERS WITH ADMIN LOG VIEWING PERMISSIONS ******

if it's right, how come i don't get it to work?

[Dismounted]

No, it's Users With Query Running Permissions.

[giotmuadong]

and put like this right?

[Dismounted]

Replace the username and reasonhere with the banned user's username and reason respectively.

[giotmuadong]

i have this error after i click "continue"

[Dismounted]

Single quotes in your reason must be escaped (by adding a single \).