How to reset/erase the ignore lists

[mike2902]

I would like to be able to delete a users ignore list. If that cant be done Ill settle for deleting everyones ignore list. I ran an SQL query for ignore, but I didnt click restart since Im not sure what it will do. Will this do it or is there another way to do this?

[kh99]

For userid X you would want to do these two updates:


UPDATE usertextfield set ignorelist = NULL WHERE userid=X

DELETE FROM userlist WHERE userid=X AND type='ignore'