Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 06 Jun 2017, 20:09
cmsouth cmsouth is offline
Join Date: Apr 2017
SQL to Subscribe Users to Channels?

I've searched thru the forum and google, but have not found sql that others have posted to update the channel subscriptions of users - is there a location that others have posted sql they have used?

We have an forum for company only users and want to subscribe them to all channels. I had a developer subscribe everyone to threads, but i've learned that you need to subscribe to channels to get new topics. I can't find any doc on the table structure to do a query by trial/ error, so even that would be helpful. Thx
Reply With Quote
Old 02 Jul 2017, 11:24
delicjous's Avatar
delicjous delicjous is offline
Join Date: Nov 2014

if you don't discover the answer by yourself I wrote you al little query which selects all users and nodes to insert it into the subsribediscussion.

It is not that easy like it sounds at first, because you have to check some things at first.

At first you have to choose which contenttypes should subscribed by all users.
If you are in phpmyadmin or your sql database you have to check the contenttypeids at the table contenttypes (depends on vB-Version). Then you could compare those ids with your nodes table and change the contenttype (s) at the following query. The publishdate selects the publishdate of all nodes installed by installed of vBulletin.
The publishdate thing only works if you have an clean fresh install which never updated --> because if vBulletn installed a new contenttype or examplenode with an update, it have a higher publishdate
Usually the css examplepage (yourdomain/special/css-examples) have an newer publishdate than the other nodes so I sort that one out by title!
So this is only a short instruction how to do it and you have to change it for your conditions!

If you want to subscribe all user to all channels than you could use the following query:
(try this select at first to see the titles you will subscribe to all users)

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Subscribe ...:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Hope it helps you to do it by your self!
Reply With Quote

Similar Threads
Thread Thread Starter Forum Replies Last Post
Forum Home Enhancements Nexia's Forum Channels, a different way to see your forums nexialys Modification Graveyard 16 14 May 2009 07:55

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 12:09.

Layout Options | Width: Wide Color: