[Maia-users] Need help with a mass cache delete

[Shue, Daniel G.]

Hi folks... I'm a newbie to Maia (still wet behind the ears) and we are
still in the testing phase of SA and Maia which I must say is AWESOME!
We have "User Auto Creation" turned off and had a few users login
manually to test with.  That leaves the .@ (default user) with 50,000
spam messages needing confirmation when I got in Monday morning.  I
would like to just do a deletion of all these emails rather than confirm
or non-confirm these suspected spam.  I saw the "delete_mail_references"
function in "maia_db.php" and thought I could just write my own PHP
script to do it using that function and a select from MySQL, but I'm
just chicken I guess.  I spent a week getting this up and running and I
don't want to hose the DB.  Is there any guru out there that has a MySQL
script that will delete ALL the DB references for anything to
recipient_id = "1".

TIA

Daniel


This email and any files transmitted with it are confidential and intended for use only by the individual or entity named above.  If you are not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, copying of this communication, or unauthorized use is strictly prohibited.  Please notify us immediately by reply email and then delete this message from your system.   Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Randolph County Government.  This email and any file attachments have been scanned for potential viruses; however, the recipient should check this email for the presence of viruses and/or malicious code.  Randolph County accepts no liability for any damage transmitted via this email.