Additional Stats

[MarkB]

I love how we can see a daily/weekly/etc breakdown of how many members/posts/threads we see per period, but would it be possible to have the option to see how many *thread views* we get as well? I think it'd be cool to see which days see heavier traffic through threads themselves.

Or maybe it's just me. Still be cool tho

[Admin]

Ok, here goes...

In stats.php, add this:

  echo "<option value=\"views\">Thread Views</option>\n";

right after this code:

  echo "<option value=\"thread\">Threads</option>\n";

Now replace this:

  if ($type == "thread") {
    $table = "thread";
    $field = "dateline";
  } elseif ($type == "post") {
    $table = "post";
    $field = "dateline";
  } elseif ($type == "user") {
    $table = "user";
    $field = "joindate";
  }

with this:

  if ($type == "thread") {
    $table = "thread";
    $field = "dateline";
    $countsql = "COUNT(*)";
  } elseif ($type == "views") {
    $table = "thread";
    $field = "dateline";
    $countsql = "SUM(views)";
  } elseif ($type == "post") {
    $table = "post";
    $field = "dateline";
    $countsql = "COUNT(*)";
  } elseif ($type == "user") {
    $table = "user";
    $field = "joindate";
    $countsql = "COUNT(*)";
  }

And last, replace this:

  $stats = $DB_site->query("SELECT COUNT(*), DATE_FORMAT(FROM_UNIXTIME($field),'$sqlformat') AS timeframe, MAX($field) FROM $table WHERE $field > '$from' AND $field < '$to' GROUP BY timeframe ORDER BY $field $sort");

with this:

  $stats = $DB_site->query("SELECT $countsql , DATE_FORMAT(FROM_UNIXTIME($field),'$sqlformat') AS timeframe, MAX($field) FROM $table WHERE $field > '$from' AND $field < '$to' GROUP BY timeframe ORDER BY $field $sort");

Not tested, but should work.

[MarkB]

Works great! Thanks (yet again!) Mr Fly

[squawell]

it's great!!

if we want to add post views or someone forum views what

should i do?

[Admin]

There is no such thing as post / forum views.