Topic: Major Fix in your Software,
Functions.php
Instead of the update function you use that uses like 2 queries and calls alot of bull crap, just use this instead,
For replies (around 204 line)
find the update_forum function and replace it with it.
//@@@@@@@@@@@@@@@@@@@@@@FIX
$db->query('UPDATE '.$db->prefix.'forums SET num_posts=num_posts+1, last_post='.$now.', last_post_id='.$pun_user['id'].', last_poster=\''.$db->escape($username).'\' WHERE id='.$cur_posting['id']) or error('Unable to update last_post/last_post_id/last_poster', __FILE__, __LINE__, $db->error());
And for the New Topic display,
find update forum function around line 313:
find update_forum function
replace it with:
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
$db->query('UPDATE '.$db->prefix.'forums SET num_topics=num_topics+1, num_posts=num_posts+1, last_post='.$now.', last_post_id='.$pun_user['id'].', last_poster=\''.$db->escape($username).'\' WHERE id='.$fid) or error('Unable to update last_post/last_post_id/last_poster', __FILE__, __LINE__, $db->error());Like if u have a site like mine that has over 40 Active users and we use this method instead, it saves me alot of server CPU Usage, more then 29% actually, Please fix if you actually have a new update, Thanks.