[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.

[webhost]

Here is how I have mind setup in the forumhome template.

Registered Members: <b>$numbermembers</b><br>
Total Threads: <b>$totalthreads</b> | Total Posts: <b>$totalposts</b> | Total Views: <b>$totalviews</b><br>

[webhost]

This is what my index.php looks like.

$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]);

Webhost

I thought u were just suppose to add

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

How come you got some extra code above this?

btw - pardon my lack on php knowledge - but are there permissions set for php files?

[webhost]

yes code above above ties in with something else.

Email me your index.php and forumhome template for me to look at to joeymoses1@home.com

Here you go Webhost or anyone else who is willing 2 help me out - I copied and pasted the forum home template source in a txt file

Thanks

This is how i edited the index.php file -

I went to my ftp proggy (Cute FTP) first I made a backup of the index file by downloading it on my harddisk - then I right clicked and edited the index file from my uploaded version - it opened into notepad - then added the code - and uploaded the amended version..

I take it php files do not have chmod permissions, do they?

[webhost]

Try inserting the bold item below

// Total Thread Views
$boardviews = $DB_site->query_first("
SELECT SUM(views) AS threadviews FROM thread");
$totalviews = number_format($boardviews[threadviews]);
}<--- I think you need that
// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid'];

[mjames]

Love this simple hack. Got it installed on my boards. Good job!

webhost mate - tried that = still no joy

I guess this hack doesnt wanna work on my board! ( sob sob)

Anybody got any other ideas?

[webhost]

try uploading this index.php file, first backup your file on your hardrive then delete the index.php file on your server and upload this one.

[Zip Removed -- don't post full source code!]

[webhost]

lukman give a url to your board