I'm using the members template with phpr 4.2 and a mysql database.
I have 3 tables I'm working with: members (view of users), emailreceived, and ignorelist.
If a member adds another member to their ignore list, I want the members_list page to not show records of members on their ignore list when they are logged in. Additionally, I would like the emailreceived_list page to automatically delete records where the senderid is on the ignore list for that member.
The ignorelist table has the following fields: id (primary key), mid (member id), and ignoreid (member id to be igored for member), and notes (for member to add any info about the ignored member).
How can I do this? I'm guessing something in the sql query or an event or both. Help greatly appreciated.
Thanks,
JET