Mass subscribe already registered users to their threads ?
 

Hi.
How can i mass subscribe Already registered users to the threads which they have started or where they have posted?
Is there any SLQ Query for that ?

I think you would need to write a script to query the thread table and get the threadid and postuserid (that is the userid of the thread starter) and then go through a loop and add each entry to the subscribethread table.

Well. Miss Lynne :)

I dont want to subscribe them to older threads which they have started or where they have posted.
Just i want it for new threads that they will start or post in.
In VB by default it is possible to do it for new users who will register.
But not available for the ones who has already registered.
Regards.

Ah, I see. I thought you wanted to subscribe them to all their threads. You can set this in the admincp > maintenance > execute sql query > pick the option you want from the dropdown (Do not subscribe, subscribe with no notification, etc)