Adding Total Views To Stats

[qtwre]

Hey Guys,  I wanna add Total Views to the statsblock how do I do it?

Addtional: Page Views Today:

Stats
Total Views: xxxxxx
Page Views Today: xxx
Total Posts: 10269
Total Topics: 685
Online Today: 57
Online Ever: 183

p.s It's really hard to find this topic especially when I type stats in the searchbox.

And what is the meaning of $txt[95], $txt[64], etc?  where do I call the numbers?  I've looked around the .php files but don't really understand them.

[IchBin]

The $txt variables are the language strings in SMF. They are stored in the language files. I don't recall seeing SMF have anything for Total View or Page Views. Where are you seeing this information?

[Ianedres]

Ich, I think he is referring to the number listed in the 'General Statistics' in the 'Stats' page...

I've been wondering this for a while and once tried to quickly get the number listed.

This works, but isn't pretty:

Code Select Expand

global $txt, $scripturl, $db_prefix, $modSettings, $user_info, $context;

$result = db_query("
SELECT
SUM(hits) AS hits
FROM {$db_prefix}log_activity", __FILE__, __LINE__);
$row = mysql_fetch_assoc($result);
mysql_free_result($result);

$context['num_hits'] = $row['hits'];

echo $context['num_hits'];

Place in a php block...   code is derived from stats.php but I removed some of the other calculations it performed...

[qtwre]

The $txt variables are the language strings in SMF. They are stored in the language files.

Thanks!

I don't recall seeing SMF have anything for Total View or Page Views. Where are you seeing this information?

I wanted to add the information to the block.  I can find the information at index?action=stats

Ich, I think he is referring to the number listed in the 'General Statistics' in the 'Stats' page...

I've been wondering this for a while and once tried to quickly get the number listed.

This works, but isn't pretty:

Code Select Expand

global $txt, $scripturl, $db_prefix, $modSettings, $user_info, $context;

$result = db_query("
SELECT
SUM(hits) AS hits
FROM {$db_prefix}log_activity", __FILE__, __LINE__);
$row = mysql_fetch_assoc($result);
mysql_free_result($result);

$context['num_hits'] = $row['hits'];

echo $context['num_hits'];

Place in a php block...   code is derived from stats.php but I removed some of the other calculations it performed...

Thanks!  I wanted to add into the original stats itself, but I'll give it a try with ur code

[qtwre]

I've tried your code and it works great!  However do anyone know how to implement it into the orginal stats block?

I hope this is the file that I should edit: BoardIndex.template.php

Code Select Expand

// Show some statistics next to the link tree if SP1 info is off.
echo '
<table width="100%" cellpadding="3" cellspacing="0">
<tr>
<td valign="bottom">', theme_linktree(), '</td>
<td align="right">';
if (!$settings['show_sp1_info'])
echo '
', $txt[19], ': ', $context['common_stats']['total_members'], ' &nbsp;•&nbsp; ', $txt[95], ': ', $context['common_stats']['total_posts'], ' &nbsp;•&nbsp; ', $txt[64], ': ', $context['common_stats']['total_topics'], '
', ($settings['show_latest_member'] ? '<br />' . $txt[201] . ' <b>' . $context['common_stats']['latest_member']['link'] . '</b>' . $txt[581] : '');
echo '
</td>
</tr>
</table>';

[qtwre]

Anybody has a better knowledge to help pls? :smiley6600:

[JPDeni]

If you want to alter the statsbox, the file to edit is Themes/default/TPortalBlocks.template.php since that's where the statsbox is defined.

The query for the total number of hits is (as was posted before):

Code Select Expand


$result = db_query("
          SELECT SUM(hits) AS hits
          FROM {$db_prefix}log_activity", __FILE__, __LINE__);
          $row = mysql_fetch_assoc($result);
          mysql_free_result($result);

          $context['totalhits'] = $row['hits'];


The code for getting the number of hits for today is:

Code Select Expand


$today = date("Y-m-d");
$result = db_query("
          SELECT hits
          FROM {$db_prefix}log_activity
          WHERE date LIKE '$today'", __FILE__, __LINE__);
          $row = mysql_fetch_assoc($result);
          mysql_free_result($result);

          $context['todayhits'] = $row['hits'];


The stats are in $context['totalhits'] and $context['todayhits'].