digitalFAQ.com Forum - Remove thread subscription for user via admincp (vBulletin), with SQL query

digitalFAQ.com Forum (https://www.digitalfaq.com/forum/)

- Website and Server Troubleshooting (https://www.digitalfaq.com/forum/web-tech/)

- - Remove thread subscription for user via admincp (vBulletin), with SQL query (https://www.digitalfaq.com/forum/web-tech/3226-remove-thread-subscription.html)

Remove thread subscription for user via admincp (vBulletin), with SQL query

If, as an admin, you find a need to remove individuals from thread subscriptions, it can be done by a SQL query to the database. (We suggest SQLyog Pro, not phpMyAdmin or the internal vBulletin query engine.) And as always, TAKE A BACKUP BEFORE MANUALLY EDITING A MYSQL DATABASE!

Simply enter this SQL query:

PHP Code:


		
			
DELETE FROM prefix_subscribethread WHERE userid=####

Note that "prefix_" will be specific to your forum (if one is set up), and the userid is the ID of the user.
The userid is at the top of any user profile page, as seen from the admincp.

That removes the user from all thread subscriptions. :thumb:

All times are GMT -5. The time now is 05:01 AM