tpearl5
12-30-2013, 01:21 PM
This query will set all users threads as not visible. In otherwords, not a hard delete:
UPDATE `thread` SET `visible` = "2" WHERE `postusername` = "USERNAME" AND `visible` = "1"
To reverse it and make the threads visible again just swap the 1 & 2 for 'visible'. This will probably work for vb3 as well, but has not been tested.
UPDATE `thread` SET `visible` = "2" WHERE `postusername` = "USERNAME" AND `visible` = "1"
To reverse it and make the threads visible again just swap the 1 & 2 for 'visible'. This will probably work for vb3 as well, but has not been tested.