Announcement

Collapse
No announcement yet.

Manual SQL Queries Help

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

  • 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).

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


    • #3
      Thanks mate worked fine.

      Comment


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


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

          Comment


          • #6
            Thanks again Lats

            Comment

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