[induslady]

Hello kh99,

Thanks for the response and yes I did try your suggestion and this is what I did -

1. Took a test user - "X"
2.User X had PM box around 50% full but when I ran the update query -

UPDATE user SET options = options - 524288 WHERE (options & 524288) AND userid = X

got message that no row was affected.

3. Now user X had PM box 90% full, ran the update query and got the message that 1 row was affected.

4.User X got the "pmbox almost full" mail notification.

5.User X had PM box 100% full and user X got pm box full mail notification as well.

With the above what could be inferred? This query will clear only for the users whose inbox is 90% full and it will not affect the users who are yet to hit the 90% mark? Do I keep running this query in specific period?

What should be the actionable so that the users in my board gets both - pmboxalmostfull and pmboxfull mail notification.

Thanks in advance for the response.