Announcement

Collapse
No announcement yet.

Query to set default Start of the Week

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

  • 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 ?

  • #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


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

      Comment


      • #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


        • #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


          • #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


            • #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


              • #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


                • #9
                  Wonderful you star!

                  Comment

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