SQL Query to Subscribe all users to their own posts

[sleepytom]

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?

[Antivirus]

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"...


UPDATE user SET autosubscribe = 0


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