MySQL - user.options ???
 

Hello,

I have an automatic e-mail reminder script that automatically messages my members after x days of inactivity, however I would like to create a link to a custom script in the footer of those e-mails to automatically unsubscribe from the e-mails.

My automatic e-mail script checks by MySQL to see anybody with: "WHERE options & 16" from the user database. (I believe that this is the adminemail option.)

My questions is: How do I remove the adminemail option by only using MySQL? Is there another way, ie a function, to change these?

Any help would be greatly appreciated.

Thanks,
Jean

I found my solution. Here it is for any searchers:

//On: UPDATE user SET options=options + 16 WHERE NOT(options & 16)
//Off: UPDATE user SET options=options - 16 WHERE options & 16