SQL query question -

[93Corvette]

I have had a token error with my website forever, I have already spent countless hours looking at the footer and other area and decided long ago just to use a simple work around.

If my member have their options set to this, everything works great:
Automatically detect DST setting: No
Is DST currently in effect: Yes

I know I can run a SQL query to make all of my members the same why by:
UPDATE user SET options=options - 64 WHERE options & 64
UPDATE user SET options=options + 128 WHERE NOT (options & 128)

So my question is:
1. With SQL, how do I display all users that have "Automatically detect DST" setting to "YES"?
2. With SQL, how do I display all users that have "Is DST currently in effect" to "No"?
3. How do I make it so they can't ever change these items (ie always have Auto to "No" & DST current to "Yes")?

Thanks for any help on any answers you know.....

[kh99]

For some reason my test forum has a drop-down with three choices for "Automatically Detect DST settings" and "DST always on" "DST always off". It must be a version difference but it seems like those two options you have have been combined in to one (I guess it makes no sense to select "automatic=yes" and also select on or off).

In any case, I think:

SELECT username, userid from user 
WHERE (options & 64)

should tell you who has "Automatically detect DST" set to yes, and

SELECT username, userid from user 
WHERE !(options & 128)

should tell you who has the other option set to "No"


As for making them permanent, I think if you edit the modifyoptions_timezone template to take out the options that might do it. Then the only issue will be to make sure they default to the values you want, which I'm not sure how to do. I suppose you could just replace the radio buttons with hidden fields, but there might be some other way to set the default for those.

[93Corvette]

Thank you, I will give it a try....

[93Corvette]

kh99,
That worked perfectly.... Thank-you.....