Changing ignore in database?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jimnyc
    Senior Member
    • Aug 2003
    • 191
    • 2.3.0

    [Forum] Changing ignore in database?

    I very temporarily made it on my board so that members can ignore moderators. This was for 24 hours and I changed my mind. During that time, a couple of members placed a moderator on ignore. I changed the option back, but that member I guess is "grandfathered" in and is still able to keep that member on ignore.

    Is there perhaps a SQL query that can be ran, or similar, that would clear ignored members for just one member on the board? Or all if no other choice?

    Thanks!

    -Jim
    .
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    The ignore list is stored in the userlist and in the usertextfield tables.

    delete from userlist where type='ignore' and userid=XX
    update usertextfield set ignorelist='' where userid=XX

    Altering the database is done so at your own risk. It is recommended that you do a database backup before running any queries.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...