Total number of READS on Community

[neal007]

Is there a variable for the NUMBER OF READS for the entire forum?

I want membercount, threadcount, postcount, and readcount for the entire forum.

Thanks!

[tubedogg]

You mean the total number of views? There's no built-in variable to do that, no. You could do something in your PHP include template though...


$views = $DB_site->query_first("SELECT sum(views) AS views FROM thread");
$totalviews = $views[views];

[George L]

check www.vbulletin.org for a the total thread views hack which i also installed at http://animeboards.com/index.php?s=

[neal007]

Works great, now how do I format the number to be like 49,888 (i.e. it puts in the comma).

Thanks a bunch!!!

[neal007]

Found it at php.net (how resourceful I am ehh?)

number_format($mynumber);

[Chen]

Resourceful, lol.

[George L]

Originally posted by FireFly
Resourceful, lol.

yup

[Freddie Bingham]

I have this in my phpinclude template but I don't get more than 20,000 views a day so it's resource usage is nil.

$fviews = $DB_site->query_first("SELECT today, maxviews, totalviews, dailyviews
                          FROM views");
$dailyviews = $fviews[dailyviews] + 1;
$totalviews = $fviews[totalviews] + 1;
$maxviews = $fviews[maxviews];
$ftoday = date('Y-m-d');
if ($ftoday != $fviews[today]) { // Update date
  if ($dailyviews > $maxviews) {
    $maxviews = $dailyviews;
  }
  $DB_site->query("UPDATE LOW_PRIORITY views
                            SET today = '$ftoday',
                            dailyviews = 1,
                            totalviews = totalviews + 1,
                            maxviews = '$maxviews'");
} else { // date is ok
  $DB_site->query("UPDATE LOW_PRIORITY views
                            SET dailyviews = dailyviews + 1,
                            totalviews = totalviews + 1");
} 

CREATE TABLE views (
  dailyviews int(10) unsigned NOT NULL default '0',
  totalviews int(10) unsigned NOT NULL default '0',
  maxviews int(10) unsigned NOT NULL default '0',
  today date NOT NULL default '0000-00-00'
) TYPE=MyISAM;

[Kaizen]

Thx

I am going to have to use this.

[Chen]

Me too.

Thanks.

[neal007]

Where can I see this in action before I code it?

[Freddie Bingham]

at the bottom of my forum?

[neal007]

That does look nice!

I'm new to vBulletin, php, mysql. I'm a Win2K, VB programmer, using SQL Server.

Where do I go to create the views table? Again, using Windows 2K, if that matters.

Thanks!

[neal007]

Freddie,

Can I suggest formatting your numbers to show the comma in the thousands place:

number_format($mynumber);

[Freddie Bingham]

Well, yes, I could do that..but you know different countries use different characters for the separator so using none doesn't confuse anyone.