truncate

Anyone have a query that could prune the IP table selectively? Specifically - keep only IPs for those in Banned Usergroup (usergroup x) AND keep ALL IPs for the last 1 year. Truncate the rest. Our table is very very large, going back 17 years, but it's not needed for the most part. What is...

hello folks, for xf1 i made a simple cronjob script that worked great... <?php class AAA_BBB_CCC { public static function truncateTable() { $db = XenForo_Application::getDb(); $db->query("TRUNCATE TABLE xf_ip"); } } can you help me convert this to xf2? i've tried a lot like this but...