Emailing web site stats once a month?

**www** · 08-27-2004, 08:47 PM

Here is an idea, not sure if it would work but I THINK it would.

1. Make the stats viewable from the outside world. (So you can see the stats at say www.domain.com/stats)

2. Make a php program to pull the output of the page that you get from www.domain.com/stats and store it in a variable.

3. Go through and convert any img tags and href links to absolute paths.

4. Email the results to your customer in HTML format.

5. Finally setup a cron job at a specified time to run your PHP script.

Boy, that sounds quite nifty to make something like that�

**james** · 08-27-2004, 10:43 PM

Yeh that would probably work.

Although there's no point making the stats publically accessible - I think you can still still grab the page using php if it's protected by .htaccess.

I think I'll end up giving this a go soon - unless someone can think of an easier way?

Cheers,

James

**Pedja** · 08-28-2004, 11:59 AM

you have access to web stats data files. They are plain text. You ave to find out what is what within file and then you may parse it and create plain text statistic report.

**james** · 08-31-2004, 01:12 AM

Ok I've had a bit of a play, writing a PHP script to do it.

It seems to work quite well. I'm going to work on it a little more, but if anyone's interested, I'm willing to post the code once it's cleaned up a bit.

James

**Frank Hagan** · 08-31-2004, 09:56 AM

I'd be interested in that, James!

**Jonathan** · 08-31-2004, 02:28 PM

Originally posted by Frank Hagan

I'd be interested in that, James!

ditto

**www** · 09-01-2004, 05:20 PM

Originally posted by james

I'm willing to post the code once it's cleaned up a bit.

That would be COOL!!!

**james** · 09-01-2004, 07:58 PM

Ok guys, I modified the script last night so that you fill in a form with the required details (cpanel username/pass, domain name, month you want stats for, etc).

This means that you can email stats for ANY cpanel domain to ANY email address.

I will most probably post this code when I get home later today/tonight.

James

**james** · 09-02-2004, 11:02 PM

For those of you waiting for my PHP script to achieve this, I've edited my initial post (above).

Please let me know how you go using the script!

James

**james** · 09-02-2004, 11:15 PM

The above script is not designed to run via a CRON job, for example, so use the following code instead if you wish to run this script for only one domain.

Edit the values of the variables at the top of the file.

PHP Code:


<?php 

$username = 'user';      // cpanel username

$password = 'pass';      // cpanel password

$domainName = 'yourdomain.com';     // domain name to get stats for (eg mydomain.com). usually without www.

$emailTo = 'you@yourdomain.com';         // email address to send stats to

$emailFrom = 'YourCompany <mail@yourcompany.com>';    // email address to send the stats from (eg MyName <me@mydomain.com)



$printOutput = 1;     // set to 0 if you do not want the script to output anything (eg for use with a cron job)



/*     Enter your base url below:

    eg. if you baseURL is [url]http://www.mydomain.com[/url], the awstats images are located at [url]http://www.mydomain.com/images/awstats[/url]

*/

$baseURL = 'http://www.yourdomain.com';





/*****************************************

You probably don't have to edit below here

*****************************************/



$hostname = "http://$username:$password@$domainName:2082";

$month = date('F');

$year = date('Y');

$emailSubject = "$month $year Web Site Statistics for $domainName";

$month = date('m')-1;

if (!(@$fp = fopen("$hostname/awstats.pl?month=$month&year=$year&output=main&config=$domainName&lang=en&framename=mainright", 'r'))) {

    if ($printOutput == 1) die("<strong>Error opening statistics file.</strong>");

    else exit();

}



//file opened successfully if we have reached here

$i = 1;

$body = "";

while (!feof($fp)) {

    $chunk = fgets($fp); // Read file line by line

    

    if ($i == 5) { // Add html code to head section

        $body .= '<base href="' . $baseURL . '">';

    }

    if (($i <= 47) || $i >= 90) {

        // Save line contents

        $body .= $chunk;

    }

    $i++;

}

fclose($fp);



// Remove all links in the HTML file received:

$body = preg_replace("/<a(.*?)a>/i", "", $body);



//email contents:

function sendHTMLMail($to, $subject, $body, $from = '') {

  $from = trim($from);

  $rp     = 'ReturnNonWorkingHere@MySite.net';

  $org    = 'YourCopmany';

  $mailer = 'YourCompany Mailer';

  $head  = '';

  $head  .= "MIME-Version: 1.0\r\n";

  $head  .= "Content-type: text/html; charset=iso-8859-1\r\n";

  $head  .= "Date: ". date('r'). " \r\n";

  $head  .= "Return-Path: $rp \r\n";

  $head  .= "From: $from \r\n";

  $head  .= "Sender: $from \r\n";

  $head  .= "Reply-To: $from \r\n";

  $head  .= "Organization: $org \r\n";

  $head  .= "X-Sender: $from \r\n";

  $head  .= "X-Priority: 3 \r\n";

  $head  .= "X-Mailer: $mailer \r\n";

  $body  = str_replace("\r\n", "\n", $body);

  $body  = str_replace("\n", "\r\n", $body);

  return mail($to, $subject, $body, $head);

}

sendHTMLMail($emailTo, $emailSubject, $body, $emailFrom);

if ($printOutput == 1) {

    echo ("<hr>Statistics successfully generated for $domainName for $month/$year.<br><br>Email sent to $emailTo.<br>A copy of the email contents is included below:<hr>");

    echo $body;

}

?>

If running via a cron job, be sure to set the printOutput variable to 0 (no).

In order for the HTML email to securely show the images produced by Awstats, it is necessary to download awstats, and upload the contents of the /wwwroot/icon folder to a publically accessible location.

For example, i uploaded mine to http://www.mydomain.com/images/awstats/. Due to the code generated by awstats, the images must be in the /images/awstats folder.

Next, copy & paste the code below, and edit the baseurl line at the top. Also, rename it to stats.php (or similar).
Cheers,

James

Emailing web site stats once a month?

Emailing web site stats once a month?

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment