Query to set default Start of the Week

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Pasqualis
    Senior Member
    • Apr 2004
    • 199
    • 3.6.x

    Query to set default Start of the Week

    Simple question: which query can I use to set the start of the week day for all my users to Monday ?
  • Chroder
    Senior Member
    • Dec 2002
    • 1449

    #2
    Code:
    UPDATE user SET startofweek=2
    That should do the trick (make sure to prefix the `user` table with your table prefix, if you specified one in config.php).

    Comment

    • Pasqualis
      Senior Member
      • Apr 2004
      • 199
      • 3.6.x

      #3
      Thanks Chroder!
      Next time I won't ask such simple questions again

      Comment

      • Pasqualis
        Senior Member
        • Apr 2004
        • 199
        • 3.6.x

        #4
        I'm very sorry.... but I do have another question like this....

        How do I set all users to use the standard editor ? (I couldn't find such table in my user table)

        Thanks in advance,

        Pasqualis

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #5
          To set the defaults for new users:

          Admin CP -> vBulletin Options -> User Registration Options -> Default Registration Options

          To reset options for existing users:

          Admin CP -> Import & Maintenance -> Execute SQL Query -> Automatic Query

          Then choose the appropriate query from the drop-down box and click on 'Continue'.

          To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

          // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
          // The users specified here will be allowed to run queries from the control panel.
          // See the above entries for more information on the format.
          // Please note that the ability to run queries is quite powerful. You may wish
          // to remove all user IDs from this list for security reasons.
          $canrunqueries = 'x';

          ...with x being your userid number (not username).
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment

          • RobinPriestley
            New Member
            • Mar 2006
            • 5
            • 3.5.x

            #6
            Cheers for the MySQL tip that worked a treat for the existing users, but I don't seem to have the option in

            Admin CP -> vBulletin Options -> User Registration Options -> Default Registration Options

            to set the date for the start of week at all for new users. Plenty of stuff about avatars etc.

            Is there another way of doing it? A default sql table or setting somewhere?

            Cheers for any help

            Comment

            • Colin F
              Senior Member
              • May 2004
              • 17689

              #7
              You're right.
              I don't think there's an option to set this to a default, it would require code modification.
              Best Regards
              Colin Frei

              Please don't contact me per PM.

              Comment

              • Marco van Herwaarden
                Senior Member
                • Nov 2004
                • 6999
                • 3.8.x

                #8
                Released: Default Start of the Week for new Registrations
                Want to take your board beyond the standard vBulletin features?
                Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

                Comment

                • RobinPriestley
                  New Member
                  • Mar 2006
                  • 5
                  • 3.5.x

                  #9
                  Wonderful you star!

                  Comment

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