Forum Home Enhancements - Total Thread Hits Per Forum

This hack counts the total thread hits for each forum then displays it where every you put the variable. This hack adds one querie per forum unless the forum has no posts in it then it doesn't add on for that forum. It also currently does not count sub forums. I plan to work on that soon.

Demo: http://www.extremechatforums.com/forum/ look under any forum after the description where it says [New Thread]

[Mutt]

see if this works. I stole it from a different hack that FireFly cleaned up and it seemed like it would work here too.


everything is new, so delete the old code


right above this

PHP Code:

// Start makeforumbit 


add this

PHP Code:

$getforumviews = $DB_site->query('
    SELECT sum(views) AS hits, forumid
    FROM thread
    GROUP BY forumid
');
$forumviews = array();
while ($getforumview = $DB_site->fetch_array($getforumviews)) {
    $forumviews[$getforumview['forumid']] = $getforumview['hits'];
} 


then right above this

PHP Code:

        eval("\$forumbits .= \"".gettemplate("forumhome_forumbit_level$depth$tempext")."\";"); 


add this

PHP Code:

    global $forumviews;
    $forumhits = $forumviews[$forum['forumid']];
    if (intval($forumhits) < 1) {
        $forumhits = 0;
    } 


now add the var $forumhits where you want the number of total views per forum to appear. this should only add 1 querry regardless of the number of forums.


once my server is back up, I'll be installing this.

[Katman]

You don't mention what files this hack needs to be placed in? Do I update the code in the index.php or fourmdisplay.php or both? Because "// Start makeforumbit" is listed in both of them in vB 2.2.8.

[Brad]

Its in index.php.

[shanx25]

I am thinking about the same problem.

The best way of doing this imho is to have a "totalviews" column in the FORUM table. I keep updating this totalviews section on an hourly basis with a GROUPBY SQL similar to the one you use. It takes 0.0008 seconds on my server.

Now that this info is already in FORUM table, we can get this column along with the same SQL that gets all the other stuff.

In other words, there is *NO ADDITIONAL* query required.

Here is what I did:

1. Altered the "Forum" table to ADD an additional column:

"totalviews" (int(10))

2. Then, set up a cronjob to execute this code hourly (you can change timing to whatever you want of course) -- cron_update_forum_totalviews.php.txt. This code takes the total of all threads and puts them into the forum.

3. /includes/functions_forumlist.php

Find every occurence of replycount, and add the "totalviews" in a similar fashion. The attached /includes__functions_forumlist.php.txt file should tell you what I have added. Just search for the word replycount inside this file.

4. index.php

Find this code:

PHP Code:

if (is_array($forumcache)) 


This is the section where there are some references to "Replycount". I added stuff for "totalviews" so that my code looks like this:

PHP Code:

// get total threads & posts from the forumcache  
$totalthreads = 0;  
$totalposts = 0;  
$totalviews = 0;  
if (is_array($forumcache))  
{  
    foreach ($forumcache AS $forum)  
    {
          $totalthreads += $forum['threadcount'];
          $totalposts += $forum['replycount']; 
         $totalviews += $forum['totalviews'];  
    }  
}  
$totalthreads = vb_number_format($totalthreads);  
$totalposts = vb_number_format($totalposts);  
$totalviews = vb_number_format($totalviews); 


Of course, all changes are included in the attached index.php.txt

Hope this helps someone in the future include VIEWS on forumhome (forum's home page). Let me know how it works out. I have it in a BBS that's under a password protected website, so cannot show example, but works like a charm. No extra queries!

-S

[vdi]

Is it possible, to get this hack for vBulletin® Version 3.6.4 ?