[release vB2.0]couter in vB page

a. open vb2/global.php

find:

PHP Code:

// ###################### Start init ####################### 


Immediately ABOVE it put any PHP counter, i using this:

PHP Code:

// ipcounter hack by CX
// config
// create these two files count.txt and ip.txt, chmod them to 777
$count_file = "count.txt";
$ip_file = "ip.txt";
$userip = getenv('REMOTE_ADDR');  // in some fixed IP server, change this line to $userip = getenv('HTTP_X_FORWARDED_FOR');

$count_temp=file($count_file);
$ip_temp=file($ip_file);

$detail=explode("|",$count_temp[0]);
$count_t=getdate(time());
$count_day=$count_t['mday'];

if ($detail[0]==$count_day) {
    $detail[1]++;
    $detail[2]++;

    $count=count($ip_temp);
    $check=1;
    for ($i=0; $i<$count; $i++) {
        $ip_list=str_replace("\r","",str_replace("\n","",$ip_temp[$i]));
        if ($ip_list==$userip) $check=0;
    }
    if ($check==1) {
        $detail[3]++;
        $detail[4]++;
        $fp=fopen($ip_file,"a");
        flock($fp,3);
        fputs($fp,$userip."\n");
        fclose($fp);
    }
}
else {
    $detail[0]=$count_day;
    $detail[1]=1;
    $detail[3]=1;
    $detail[2]++;
    $detail[4]++;
    $fp=fopen($ip_file,"w");
    flock($fp,3);
    fputs($fp,$userip."\n");
    fclose($fp);
}

$new=implode("|",$detail);
$fp=fopen($count_file,"w");
flock($fp,3);
fputs($fp,$new);
fclose($fp);

// end ipcounter hack 


b. edit the template footer

find in last:

PHP Code:

</smallfont>
</p> 


Immediately ABOVE it put:

PHP Code:

<br><br>
page views:&nbsp;&nbsp;today = $detail[1],&nbsp;&nbsp;total = $detail[2].&nbsp;&nbsp;variant IP visitors:&nbsp;&nbsp;today = $detail[3],&nbsp;&nbsp;total = $detail[4]. 


Done!

[Robert Basil]

I just put the hack in my forums and also placed it throughout my website. Works great, thanks!

[eva2000]

just tried this hack and it was doing fine for a few minutes and then reset itself again to zero?

I get exact the same error at different times.... now 879 hits and a few minutes later it starts over at 0

[Dakota]

Its working fine for me, I just installed it. It may reset, but you never know.

Well, just installed it, too

nicely done mate. any chance of making this part of the database?

-Alex

[AJR]

I have installed bbqfan's hack and it works great!! I wanted to keep a running history
of my page views and unique IP's so I made the following hack and attached a
picture of what it looks like. There may be a better way to do this...but this is
as simple a hack as I could create!

NOTE: I could only figure out how to get this to work for daily stats. Weekly/Monthly
don't calculate correctly. If anyone knows what to add/change in the query
to get Weekly/Monthly to show correctly, please post the changes here!

Here's what you need to do:

First create a table called 'ip_views' in your vbulletin database, and add the
following fields: 'date' as INT(10), 'views' as INT(6), 'uip' as INT(6)

Note: You can run the following query in phpMyAdmin to create the table:

CREATE TABLE ip_views (
date int(10) NOT NULL,
views int(6) NOT NULL,
uip int(6) NOT NULL
)

================================================== ============

** In bbqfan's hack in global.php

Find:

PHP Code:

} else {
    $detail[0]=$count_day; 


CHANGE it to:

PHP Code:

} else {
    $DB_site->query("INSERT INTO ip_views (date,views,uip) VALUES ('$count_t',$detail[1],$detail[3])");
    $detail[0]=$count_day; 


Done with global.php!


** Open admin/stats.php

Find:

PHP Code:

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


Below it add:

PHP Code:

  echo "<option value=\"views\">Page Views</option>\n";
  echo "<option value=\"uips\">Unique IP's</option>\n"; 


Find:

PHP Code:

  } elseif ($type == "user") {
    $table = "user";
    $field = "joindate";
  } 


CHANGE it to:

PHP Code:

  } elseif ($type == "user") {
    $table = "user";
    $field = "joindate";
  } elseif ($type == "views") {
    $table = "ip_views";
    $field = "date";
    $field2 = "views";
  } elseif ($type == "uips") {
    $table = "ip_views";
    $field = "date";
    $field2 = "uip";
  } 


Find:

PHP Code:

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


CHANGE it to:

PHP Code:

  if (($type == "thread") || ($type == "post") || ($type == "user")) {
      $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");
  } elseif (($type == "views") || ($type == "uips")) {
      $stats = $DB_site->query("SELECT $field2, 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");
  } 


Done with admin/stats.php!


This works on vBulletin 2.0.1...any other 2.x versions should work, but I
can't verify. Hopefully someone will know how to make the weekly and
monthly stats add up the views/ip's correctly for the week/month!

AJ

[AJR]

Strange...the picture didn't attach in the above post. Here it is:

[Robert Basil]

This hack was working great for almost a full 24hrs and then it started resetting itself at random times back to zero (Both the visitor stats and the page view stats) So I removed it from my site.

[eva2000]

Originally posted by Sportbikeworld
This hack was working great for almost a full 24hrs and then it started resetting itself at random times back to zero (Both the visitor stats and the page view stats) So I removed it from my site.

yup join the club

[Dakota]

After afew hours I was at about 1500 page views, then I checked back the next morning and it was at like 250. Reset is occuring with me too.