topics (topic_id, topic_posts) (SELECT topic_id, count(post_status) as topic_posts FROM $bbdb->posts WHERE post_status = '0' GROUP BY topic_id) ON DUPLICATE KEY UPDATE topic_posts=VALUES(topic_posts) "); $fast_recount_query['fast-topic-deleted-posts']=array(" DELETE FROM $bbdb->topicmeta WHERE meta_key = 'deleted_posts '"," INSERT INTO $bbdb->topicmeta (meta_key, topic_id, meta_value) (SELECT 'deleted_posts', topic_id, count(post_status) as meta_value FROM $bbdb->posts WHERE post_status != '0' GROUP BY topic_id) "); $fast_recount_query['fast-forums']=array(" INSERT INTO $bbdb->forums (forum_id, posts) (SELECT forum_id, count(post_status) as posts FROM $bbdb->posts WHERE post_status = '0' GROUP BY forum_id) ON DUPLICATE KEY UPDATE posts=VALUES(posts) "," INSERT INTO $bbdb->forums (forum_id, topics) (SELECT forum_id, count(topic_status) as topics FROM $bbdb->topics WHERE topic_status = '0' GROUP BY forum_id) ON DUPLICATE KEY UPDATE topics=VALUES(topics) "); $fast_recount=array_reverse($fast_recount); foreach ($fast_recount as $key=>$value) {array_unshift($recount_list,array($key, __("FAST RECOUNT $value"),'fast_recount'));} $fast_recount=array_reverse($fast_recount); } function fast_recount() { global $bbdb, $fast_recount, $fast_recount_query; if (!bb_current_user_can('administrate')) {return;} bb_check_admin_referer( 'do-counts' ); foreach ($fast_recount as $key=>$value) { if (isset($_POST[$key]) && 1 == $_POST[$key] ) { unset($_POST[$key]); // or we'll get called multiple times $status=array(); echo "\t

\n"; echo "\t\t" . __("FAST RECOUNT $value..."); foreach ($fast_recount_query[$key] as $query) {$status[]=$bbdb->query($query);} echo "\t\t (".implode(':',$status).")
\n"; echo "\t\t" . __("Done fast recounting $value."); echo "\n\t

\n"; } } } ?>