Announcement

Collapse
No announcement yet.

Updating User Options en masse ????????

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

  • Updating User Options en masse ????????

    what happened to the Updating User Options en masse for "Instant notificatoin by email"

    this was very handy and helped with traffic, thanks!

  • #2
    anyone? This use to be an option in the sticky but isnt anymore?!?!

    Comment


    • #3
      Thread subscription/email notification defaults:
      Do not subscribe: UPDATE user SET autosubscribe=-1;
      Subscribe without notification: UPDATE user SET autosubscribe=0;
      Instant email: UPDATE user SET autosubscribe=1;
      Instant ICQ: UPDATE user SET autosubscribe=4 WHERE icq <> ''; (note: This requires a valid ICQ number in the user's profile to work; also the user must have ICQ Email Express enabled in ICQ.)
      Daily email: UPDATE user SET autosubscribe=2;
      Weekly email: UPDATE user SET autosubscribe=3;

      Comment


      • #4
        Originally posted by tubedogg
        Thread subscription/email notification defaults:
        Do not subscribe: UPDATE user SET autosubscribe=-1;
        Subscribe without notification: UPDATE user SET autosubscribe=0;
        Instant email: UPDATE user SET autosubscribe=1;
        Instant ICQ: UPDATE user SET autosubscribe=4 WHERE icq <> ''; (note: This requires a valid ICQ number in the user's profile to work; also the user must have ICQ Email Express enabled in ICQ.)
        Daily email: UPDATE user SET autosubscribe=2;
        Weekly email: UPDATE user SET autosubscribe=3;
        this is the error i get

        An error occured while attempting to execute your query. The following information was returned.
        error number: 1054
        error desc: Unknown column 'autosubscribe' in 'field list'

        when running this command

        UPDATE user SET autosubscribe=1;


        why was this command removed from the sticky?

        Comment


        • #5
          It was never in the sticky to begin with so it would have been pretty hard to remove it...

          What version are you running? autosubscribe was added in beta 7 as far as I can tell.

          Comment


          • #6
            Originally posted by tubedogg
            It was never in the sticky to begin with so it would have been pretty hard to remove it...

            What version are you running? autosubscribe was added in beta 7 as far as I can tell.
            it was in the sticky, i used it before.. im using beta 6

            Comment


            • #7
              That's why...upgrade to beta 7 and it will work.

              Comment

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