SQL Query to Subscribe all users to their own posts
 

Hi

I'd like a way to subscribe all my users to threads in which they have participated. This should be a simple SQL query i guess but i'm not good enough with SQL/VB to know what to enter...

if anyone can help i'd be really really grateful :) - a solution was offered at http://www.vbulletin.com/forum/showthread.php?t=225357 but i couldn't make it work - the official VB support people told me i had to come and post here rather than wait for an answer on their official support board so maybe one of you kind people can help me?

That's be tricky as you'd have to create a record for every subscription for every user.

To do it on a going-forward basis, the following query will change every user's thread subscription in their preferences to "Subscribe with no notification"...

[SQL]
UPDATE user SET autosubscribe = 0
[/SQL]

Make sure you backup your database in case you don't like what it does!