[Katelynn]

Hey Guys, Just wanted to let you know I figured it out. I ended up writing this for my dailycleanup.php cron job. Hope that helps someone with a huge log file!

If I should NOT be doing this, please let me know!!

// DELETE Spam--O-Matic Log Entries Older Than 7 Days
$vbulletin->db->query_write("
        DELETE FROM " . TABLE_PREFIX . "glowhostspamomatic_log
        WHERE date < DATE_SUB(NOW(), INTERVAL 7 DAY)
");

// OPTIMIZE Spam--O-Matic TABLE After Deletion Of Log Entries Older Than 7 Days
$vbulletin->db->query_write("
        OPTIMIZE TABLE " . TABLE_PREFIX . "glowhostspamomatic_log
");