XF 1.5 Notice or email based on warnings


I am looking to create a notice or send out a user e-mail to those users that have x amount of posts, been a member for x number of days, and have 0 warnings in their history. The first two are included variables in the notices and user e-mails, but the last is not. Anyone help me with a method I might use to make such a selection of my users? If nothing else perhaps an SQL query?
You will need a custom add-on to add such a criteria to the system. I'll also note that using warning points is not an indicator of never having received a warning.
Top Bottom