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.

Re: Major Fix in your Software,

What forum version do you speak about?

Re: Major Fix in your Software,

All of them,