total thread views

[BaldNut]

what is the code i would add into my stats panel to have the total thread views info please.

[Visionray]

bump

[Automated]

i would like this too! Kinda like what they have here at VB.org

[Xenon]

open index.php
find:

PHP Code:

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');
$totalthreads=number_format($countthreads['threads']); 


change to:

PHP Code:

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads, SUM(views) AS views FROM thread');
$totalthreads=number_format($countthreads['threads']);
$totalviews=number_format($countthreads['views']); 


then put $totalviews to you templates

[Darwinist]

I got errors when I used the code. I fixed it with this...

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads, SUM(views) AS views FROM thread');
$totalthreads=number_format($countthreads['threads']);
$totalviews=number_format($countthreads['views']);

..."number_format(" doesn't show up under the PHP vB Code statement.

[Mijae]

Would this add an extra query to forumhome?

[Logician]

Today at 06:36 AM v0id said this in Post #6
Would this add an extra query to forumhome?

yes.. everytime you see a line "$DB_site->query" within a code, you can safely regard, you added a query to that page.

[Darwinist]

The "$DB_site->query" was there already... the line wasn't added, only changed.

[Logician]

Today at 03:43 PM pgt91 said this in Post #8
The "$DB_site->query" was there already... the line wasn't added, only changed.

ok then reverse logic: since there is no new "$DB_site->query" line, there is no extra query added..

[Xenon]

even so it's a slow query, which will slow down loading forumhome a bit.

i'm not a fan of threadviews on forumhome because it isn't really usefull and just slows down the page....