Disabling email for older accounts

[kh99]

Originally Posted by VodkaFish

Thanks. Should I be looking at the allowemail column? Searching in the forums makes it look like it's in the options column as WHERE options & 16 instead of WHERE allowemail = 'yes'

Yeah, it's the options & 16 one. It should be something like

UPDATE user SET options = options - 16 WHERE options & 16 AND ....

where you'd add your date check code. It checks for options & 16 because it does a subtraction to unset the bit, so of course you dont' want to do it unless it's already set. I took that from the "canned" queries in the Maintenance menu, and I don't know enough SQL to know why they don't use a bitmask.