Mod Tools - acc_hide_mail
I did a commit WAY back where I gave an option in permissions to block viewing mails per rank. I personally use it to block staffs from seeing emails and so on, just for the extra bit of security, when they don't need to see them. I didn't know how to do it inside of Modtools, so I just sort of let it go, but now I honestly really need it.
Now I've come to terms that I have no idea what I'm doing that wouldn't make the code even slower, but here's what I can explain:
SELECT permissions.acc_hide_mail AS perm, mail FROM users LEFT JOIN permissions ON users.rank = permissions.id WHERE users.id = '1' LIMIT 1
If the perm = '1', hide mail. That's it really. I just don't know how to include a If condition properly without messing up something else and I know you wouldn't trust me to merge it lol.