Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 12 Nov 2011, 08:01
Kış Kış is offline
 
Join Date: Aug 2008
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 ?
Reply With Quote
  #2  
Old 12 Nov 2011, 18:12
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 12 Nov 2011, 20:54
Kış Kış is offline
 
Join Date: Aug 2008
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.
Reply With Quote
  #4  
Old 13 Nov 2011, 01:44
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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)
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 07:03.

Layout Options | Width: Wide Color: