Manual SQL Queries Help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gatsman
    New Member
    • Nov 2008
    • 29
    • 3.6.x

    Manual SQL Queries Help

    Hi,
    I just finished my phpBB to vBulletin migration, all worked fine but there is a couple of things i need help with.
    Some options for my imported users are not correct so i wish to make some manual sql queries.

    1. Set the time +2:00 for all imported users.
    2. Set the “Save a copy of sent messages in my Sent Items folder” on, for all imported user (i have done this for the new users).
  • Lats
    Senior Member
    • Mar 2002
    • 3671

    #2
    1. UPDATE user SET timezoneoffset = "2" WHERE usergroupid = X - change X to the usergroupid of your imported users.

    2. UPDATE user SET options=options + 33554432 WHERE NOT(options & 33554432)
    Lats...

    Comment

    • gatsman
      New Member
      • Nov 2008
      • 29
      • 3.6.x

      #3
      Thanks mate worked fine.

      Comment

      • gatsman
        New Member
        • Nov 2008
        • 29
        • 3.6.x

        #4
        Automatically detect DST settings

        Hi, again
        What is the SQL manual query to set all my imported user as
        Automatically detect DST settings = Yes

        Comment

        • Lats
          Senior Member
          • Mar 2002
          • 3671

          #5
          UPDATE user SET options = options + 64 WHERE NOT(options & 64)
          Lats...

          Comment

          • gatsman
            New Member
            • Nov 2008
            • 29
            • 3.6.x

            #6
            Thanks again Lats

            Comment

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