Need help with a query :(

[Cyricx]

So I'm trying to write a small php file that'll more or less optimize someones vb settings for highspeed or dialup.

Turning off signatures, avatars, img code and the like, or alternately turning it on.

Then I realized that showsignatures, showavatars and showimages, seemed to be stored in a "binary?" form in the options field of the user table.

I am completely stumped on what I can do to do this.

I found this query for dst

$DB_site->query("

UPDATE " . TABLE_PREFIX . "user SET

options = options - $_USEROPTIONS[dstonoff]

WHERE userid = $bbuserinfo[userid]

AND (options & $_USEROPTIONS[dstonoff])

");

So I'm sure I could run a variant of that, i.e. useroptions[showsignatures]

but if I don't know who has it selected already I'm pretty sure it could really fubar somethings

Any ideas? :ermm:

[Xenon]

actually it should work quite equal:

$DB_site->query("
UPDATE " . TABLE_PREFIX . "user SET
options = options - $_USEROPTIONS[showsignatures]
WHERE userid = $bbuserinfo[userid]
AND (options & $_USEROPTIONS[showsignatures])
");

the and options & part checks if it is set , the options - then sets it to no.

and to get the other way round it would be:

$DB_site->query("
UPDATE " . TABLE_PREFIX . "user SET
options = options + $_USEROPTIONS[showsignatures]
WHERE userid = $bbuserinfo[userid]
AND NOT (options & $_USEROPTIONS[showsignatures])
");

[Cyricx]

Thank you so very much bro, worked like a charm!!!!

[Xenon]

you're welcome