Announcement

Collapse
No announcement yet.

Total "admin email" users

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Total "admin email" users

    Is there any way to find out how many users are subscribed to the "admin emails"? I've had a look through the VB Admin CP but can't find a way to do it? Maybe I need an SQL query?

    Thanks in advance!

  • #2
    You can run this query:

    SELECT COUNT(*) FROM user WHERE options & 16;
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      Originally posted by Colin F View Post
      You can run this query:

      SELECT COUNT(*) FROM user WHERE options & 16;
      Thanks Colin, works great!

      What's that query doing in the WHERE section, I've not seen a query like that before?

      Comment


      • #4
        The options are saved in bits, and it's checking against those.
        Best Regards
        Colin Frei

        Please don't contact me per PM.

        Comment


        • #5
          Originally posted by Colin F View Post
          The options are saved in bits, and it's checking against those.
          Interesting I'll see if I can find some information!

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X