[Release VB2] Total Thread Views

This hack was done by Kier, just wanted to post it in its own thread

What It Does

Counts all the views for each thread and adds them together. Basically a sum of the pageviews for all of your threads.

How To Implement This

Copy and paste this code into index.php in the regular forum directory.

PHP Code:

// Total Thread Views

$boardviews = $DB_site->query_first("
    SELECT SUM(views) AS threadviews FROM thread");
$totalviews = number_format($boardviews[threadviews]); 


Then just print $totalviews anywhere you want.

Example: http://www.systemlogic.net/boards on the top left next to the number of posts/threads stats.

easy dude

Just insert

$totalviews since 1-5-01 into where you want it on your forum home template

[JJR512]

Well, it's very simple. Where ever you stick the $totalviews, just put the text by that. For example, if you put it in your forumhome template, so it's below your total threads and total posts, as I did, like this:

<b>$totalviews</b> total thread views

You could just change it to this:

<b>$totalviews</b> total thread views since May 7, 2001

(Or use whatever date it was when you converted from UBB to vB.)

Where do you paste the code at, in the index.php? Anywhere special.

Can someone give an example of placement.

Thanks
Dan

in the forum home template

Put it under launch buddy list or wherever

[JJR512]

Originally posted by JJR512
Well, it's very simple. Where ever you stick the $totalviews, just put the text by that. For example, if you put it in your forumhome template, so it's below your total threads and total posts, as I did, like this:

<b>$totalviews</b> total thread views

You could just change it to this:

<b>$totalviews</b> total thread views since May 7, 2001

(Or use whatever date it was when you converted from UBB to vB.)

Thanks very much,

What about the index.php file I need to edit. Where should I put the code it's says in the above post. It say cut and paste this code into the index.php file.

just find a place... like under total posts in index.php

I can't find total posts in the index.php file. Can someone cut out a small part of this file were they have this code placed in the index.php file?

// Total Thread Views

$boardviews = $DB_site->query_first("
SELECT SUM(views) AS threadviews FROM thread");
$totalviews = number_format($boardviews[threadviews]);

[JJR512]

In index.php, look for this:

// get newest member

Place the code for this hack above this line.

This is how mine looks:

PHP Code:

// get total posts
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
$totalposts=$countposts['posts'];
if ($totalposts=='') {
  $totalposts=0;
}
$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');
$totalthreads=$countthreads['threads'];
if ($totalthreads=='') {
  $totalthreads=0;
}

// Total Thread Views
$boardviews = $DB_site->query_first("
    SELECT SUM(views) AS threadviews FROM thread");
$totalviews = number_format($boardviews[threadviews]);

// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid']; 


Worked like a charm. I was getting messed up because I didn't realize at first there are two index files.