I run a private forum where users are supposed to write at least their presentation in two weeks time after registration and any user with 0 (zero) posts within 3 months of registration are deactivated.
Is there any way to query the database for:
1. Users registered within the last 3 months with 0 (zero) posts ?
2. Users registered within the last two weeks to have started a topic on xf_thread.thread_id = 9 ?
Thanks in advance for your help.