Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 24 Nov 2014, 04:41
ed762 ed762 is offline
 
Join Date: Sep 2014
How to query for the number of users that have subscribed to a forum

Hi all, just wonder if anyone has figured out how to query for the number of users that have subscribed to a particular forum. What do you query in SQL?

Thank you
Reply With Quote
  #2  
Old 24 Nov 2014, 12:28
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
I think this might work:

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

where X is the forumid.
Reply With Quote
  #3  
Old 24 Nov 2014, 13:18
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
Yes that should work.

If you want to do this on a thread level, there is this mod, [OzzModz] Users Subscribed To Thread Block
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #4  
Old 24 Nov 2014, 15:10
ed762 ed762 is offline
 
Join Date: Sep 2014
Thank you. I will give it a shot.
Reply With Quote
  #5  
Old 25 Nov 2014, 23:07
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
Let me know if it is what you were after.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
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 11:07.

Layout Options | Width: Wide Color: