"Receive Email from Administrators": Which members have set this to "no"?

[licensinglinks]

Is there a way of getting a list of usernames who have set it to "no"?

Similarly I would like to know who has selected "Don't receive Email Notification of new Private Messages"

Thanks.

--------------- Added [DATE]1357252509[/DATE] at [TIME]1357252509[/TIME] ---------------

anyone any thoughts?

[licensinglinks]

anyone got any ideas?

[snakes1100]

You would have to create a custom script or use a query directly thru mysql or phpmyadmin.

[licensinglinks]

Yes I know that. Does anyone know what query I would need to run in phpmyadmin?

[Brandon Sheley]

I'd check the user table and see what field that is, then something like
select * from user where admin_emails = no

[Simon Lloyd]

You'd need to know which option in the user table is for recieve admin emails and then get the matches like this

PHP Code:

SELECT * 
FROM `user`
WHERE substr(`options`, 5, 1) = '1' 


So this one says show all the people who have the option set for 1 at position 5 in the string of options, so maybe in phpmyadmin the options column looks like 432516780 as you can see in this example position 5 shows 1 so it would be a match.

I dont know what the criteria is for creating the options list or how they arrive at the figures, if i did i could help further

--------------- Added [DATE]1357315487[/DATE] at [TIME]1357315487[/TIME] ---------------

Originally Posted by Brandon Sheley

I'd check the user table and see what field that is, then something like
select * from user where admin_emails = no

Unfortunately that column doesn't exist

[kh99]

It would be:

SELECT username FROM user WHERE options & 16 = 0

[Simon Lloyd]

Hi Kevin could you possibly explain the & 16 =0 obviously it works but i don't know why?

[kh99]

It's kind of like what you said, only for your method to work the value would have to be a string, with the number represented in binary. The & operator is kind of like treating an integer field as if it were a binary string, and checking only one character out of it. '&' means 'bitwise and', and 16 is 10000 in binary, so it's checking the 5th bit from the right. When you '&' the values, you'll get either 16 or 0, depending on whether or not that bit is set, so then you just have check for whether or not the result is 0.

I hope that makes some sense. Maybe this is better: http://en.wikipedia.org/wiki/Mask_%28computing%29

[Simon Lloyd]

It makes perfect sense, i had the right idea but just not the skill to execute it properly! - thanks for the explanation and it's something i'll add to my toolchest for future