Quantcast Remove thread subscription for user via admincp (vBulletin), with SQL query - digitalFAQ Forum
Go Back    Forum > Digital Publishing / Web Sites > Website and Server Troubleshooting

LinkBack Thread Tools
06-25-2011, 04:02 AM
admin's Avatar
admin admin is offline
Site Staff | Web Development
Join Date: Jul 2003
Posts: 4,361
Thanked 606 Times in 445 Posts
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.

- Did this site help you? Then upgrade to Premium Member and show your support!
- Also: Like Us on Facebook for special DVD/Blu-ray news and deals!
Reply With Quote
Someday, 12:01 PM
admin's Avatar
Ads / Sponsors
Join Date: ∞
Posts: 42
Thanks: ∞
Thanked 42 Times in 42 Posts

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL query to change thread icons in vBulletin admin Website and Server Troubleshooting 1 05-10-2014 09:27 PM
Remove characters from URL vBulletin vBSEO ~`!@#$%^&*()+={}[]|;:'"<>,.? admin Website and Server Troubleshooting 0 03-14-2011 11:27 PM
Code edits to send HTML email via admincp in vBulletin admin Website and Server Troubleshooting 0 03-06-2011 08:14 PM
Add HTML option to vBulletin 3.x "Send Email to Users" admincp admin Website and Server Troubleshooting 0 04-28-2010 08:29 AM

Thread Tools

All times are GMT -5. The time now is 09:57 PM