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: