Force default style on all users...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tolitz
    Senior Member
    • Dec 2000
    • 1371
    • 2.3.0

    Force default style on all users...

    Greetings I tried to search for an answer to this question but after 4 search result pages, I didn't see an answer, so here's the question.

    I have just finished a new style for my forums, but it is located at a test board, and I plan to import it into my live forum.

    But most of my users are using a styleset that isn't the default, and I wanna make the new style the default style for my live forum.

    My question is, what query should I enter in phpMyAdmin to force/reset everyone's style to the default one? Thanks in advance
    OPEN TECH SUPPORT
    "Tech is our middle name!"
  • Floris
    Senior Member
    • Dec 2001
    • 37767

    #2
    UPDATE user SET styleid=x;

    I think. Let me check it out (brb)

    Comment

    • Faruk
      Senior Member
      • Aug 2001
      • 1320
      • 3.0.0 'Gold'

      #3
      Originally posted by xiphoid
      UPDATE user SET styleid=x;

      I think. Let me check it out (brb)
      Yes, that will work properly

      Comment

      • Tolitz
        Senior Member
        • Dec 2000
        • 1371
        • 2.3.0

        #4
        danke people
        OPEN TECH SUPPORT
        "Tech is our middle name!"

        Comment

        • filburt1
          Senior Member
          • Feb 2002
          • 6606

          #5
          Originally posted by 1337Devil
          Yes, that will work properly
          They may have to log out then back in though if they were ever cookied with a style.
          --filburt1, vBulletin.org/vBulletinTemplates.com moderator
          Web Design Forums.net: vB Board of the Month
          vBulletin Mail System (vBMS): webmail for your forum users

          Comment

          • WetWired
            Senior Member
            • Jul 2002
            • 305

            #6
            That won't make new users use the style, however. For that, we just take the default style and swap its info with the new style.
            http://www.zelaron.com/sigs/rotsig.gif

            Comment

            • Mntsnow
              Member
              • Oct 2001
              • 44

              #7
              Originally posted by 1337Devil
              Yes, that will work properly
              I would like to know along these lines what query would I need to run to change users that are using style id #5 to style id #16?

              Thanks for insight to this
              -Mntsnow-

              Comment

              • filburt1
                Senior Member
                • Feb 2002
                • 6606

                #8
                Originally posted by Mntsnow
                I would like to know along these lines what query would I need to run to change users that are using style id #5 to style id #16?

                Thanks for insight to this
                UPDATE user SET styleid = 16 WHERE styleid = 5;
                --filburt1, vBulletin.org/vBulletinTemplates.com moderator
                Web Design Forums.net: vB Board of the Month
                vBulletin Mail System (vBMS): webmail for your forum users

                Comment

                • Mntsnow
                  Member
                  • Oct 2001
                  • 44

                  #9
                  Originally posted by filburt1
                  UPDATE user SET styleid = 16 WHERE styleid = 5;
                  Thank you so kindly
                  -Mntsnow-

                  Comment

                  • Ted S
                    Senior Member
                    • Dec 2003
                    • 332
                    • 3.5.x

                    #10
                    Old thread but relevant...

                    What query would be used to update the user's style to accept the forum default so I don't have to worry about manual updates when I change default themes? Thanks.
                    Ted & the Giftery.me Team

                    New features released for Product Review Forums 1.3 (4.0)
                    Helpful Answers (3.8) (4.0) | Limited Guest Viewing (3.8) (4.0)

                    Comment

                    • Mntsnow
                      Member
                      • Oct 2001
                      • 44

                      #11
                      UPDATE user SET styleid = AA WHERE styleid = XX;

                      Replace the XX with the style number you want to change/migrate to style "AA" which is whatever number the "default" style is. (usually number "1")
                      -Mntsnow-

                      Comment

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