Global stats

Discussion in 'General' started by esezako, Feb 19, 2009.

  1. esezako

    esezako New Member

    Hi, i need see a statics of the sites of mi ispconfig all at the same time.
    i don't know if with webalizer is posible, but with awstats i find awstatstotals, but i donĀ“t know how do it work.
    Can somebody help me?
     
  2. matrixn

    matrixn New Member

    i`m interested too for instaling this plugin.. but i can`t find any help over the web... i hope someone can help us :)
     
  3. falko

    falko Super Moderator

    Isn't there a README or INSTALL file in the sources?
     
  4. matrixn

    matrixn New Member

    the tool is made from 2 files (awstats.php[wrapper] and awstatstotals.php). Only help is shown in awstats.php which is :

    PHP:
    <?php

    /**
     * AWStats PHP Wrapper Script
     *
     * In your AWStats.conf set the following: 
     * WrapperScript="awstats.php"
     *
     * @author      Jeroen de Jong <jeroen@telartis.nl>
     * @copyright   2004-2007 Telartis BV
     * @version     1.1
     *
     * @link        http://www.telartis.nl/xcms/awstats
     * 
     *.....GNU GPL.. 
     */

    /**
     * The location of the AWStats script.
     */
    $AWStatsFile '/usr/local/awstats/cgi-bin/awstats.pl';

    /* ... */
    ?>

    and the awstatstotals.php has some settings to do.. I have set it up and when i run awstatstotals.php from browser says something like "Config variable not set!" ... :confused:
     
  5. falko

    falko Super Moderator

    What's in awstatstotals.php?
     
  6. matrixn

    matrixn New Member

    this is awstatstotals.php is a web php file as far as i identify not a "system" php program or something else like the awstats.php

    PHP:
    <?php

    /**
     * AWStats Totals is a simple php script to view the totals
     * (Unique visitors, Number of visits, Pages, Hits, Bandwidth)
     * for multiple sites per month with sort options.
     *
     * @author      Jeroen de Jong <jeroen@telartis.nl>
     * @copyright   2004-2008 Telartis BV
     * @version     1.16
     *
     * @link        http://www.telartis.nl/xcms/awstats
     *
     * Changelog:
     * 1.0  initial version
     * 1.1  use awstats language files to set your language
     * 1.2  register_globals setting can be off
     * 1.3  display yearly totals and last entry (Marco Gruber)
     * 1.4  use english messages when no language files found
     * 1.5  error_reporting setting can be E_ALL
     * 1.6  fixed incorrect unique visitors in year view (ConteZero)
     * 1.7  changed number and byte format
     * 1.8  added not viewed traffic, changed layout, improved reading of AWStats database
     * 1.9  define all variables (Michael Dorn)
     * 1.10 added browser language detection (based on work by Andreas Diem)
     * 1.11 fixed notice errors when no data file present (Marco Gruber)
     * 1.12 recursive reading of awstats data directory
     * 1.13 fixed trailing slashes problem with directories
     * 1.14 fixed errors when some dirs or files were not found (Reported by Sam Evans)
     * 1.15 added security checks for input parameters (Elliot Kendall)
     * 1.16 fixed month parameter 'all' to show stats in awstats
     *
     * This program is free software; you can redistribute it and/or
     * modify it under the terms of the GNU General Public License
     * as published by the Free Software Foundation; either version 2
     * of the License, or (at your option) any later version.
     *
     * This program is distributed in the hope that it will be useful,
     * but WITHOUT ANY WARRANTY; without even the implied warranty of
     * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
     * GNU General Public License for more details.
     *
     * You should have received a copy of the GNU General Public License
     * along with this program; if not, write to the Free Software
     * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
     */


    /*******************************************************
     * SETUP SECTION
     *******************************************************/

    /**
     * Set this value to the directory where AWStats
     * saves its database and working files into.
     */
    $DirData '/var/lib/awstats';

    /**
     * The URL of the AWStats script.
     */
    $AWStatsURL '/cgi-bin/awstats.pl';

    /**
     * Set your language.
     * Possible value:
     *  Albanian=al, Bosnian=ba, Bulgarian=bg, Catalan=ca,
     *  Chinese (Taiwan)=tw, Chinese (Simpliefied)=cn, Czech=cz, Danish=dk,
     *  Dutch=nl, English=en, Estonian=et, Euskara=eu, Finnish=fi,
     *  French=fr, Galician=gl, German=de, Greek=gr, Hebrew=he, Hungarian=hu,
     *  Icelandic=is, Indonesian=id, Italian=it, Japanese=jp, Korean=kr,
     *  Latvian=lv, Norwegian (Nynorsk)=nn, Norwegian (Bokmal)=nb, Polish=pl,
     *  Portuguese=pt, Portuguese (Brazilian)=br, Romanian=ro, Russian=ru,
     *  Serbian=sr, Slovak=sk, Spanish=es, Swedish=se, Turkish=tr, Ukrainian=ua,
     *  Welsh=wlk.
     *  First available language accepted by browser=auto
     */
    $Lang 'auto';

    /**
     * Set the location of language files.
     */
    $DirLang '/usr/share/awstats/lang';

    /**
     * How to display not viewed traffic
     * Possible value: ignore, columns, sum
     */
    $NotViewed 'sum';

    /**
     * How to sort.
     * Possible value:
     * config, unique, visits, pages, hits, bandwidth,
     * not_viewed_pages, not_viewed_hits, not_viewed_bandwidth
     */
    $sort_default 'bandwidth';

    /**
     * Set number format.
     */
    $dec_point '.';
    $thousands_sep ' ';

    /**
     * Config names to filter. Shows all if empty array.
     */
    $FilterConfigs = array();

    /*
    To read website configs from database, do something like:
    $sql = 'SELECT config FROM users WHERE (user=...)';
    $rs = mysql_query($sql);
    if ($rs) while ($row = mysql_fetch_array($rs))
        $FilterConfigs[] = $row['config'];
    */

    /*******************************************************
     * PROGRAM SECTION
     *******************************************************/

    if (isset($_GET['sort'])) $sort preg_replace('/[^_a-z]/'''$_GET['sort']); else $sort $sort_default;
    if (isset(
    $_GET['year'])) $year = (int)$_GET['year']; else $year date('Y');
    if (isset(
    $_GET['month'])) $month = (int)$_GET['month']; else $month date('n');
    if (!
    $month$month 'all';

    function 
    get_config($file) {
        
    $r '';
        if (
    preg_match('/awstats\d{6}\.(.+)\.txt/'$file$match)) $r $match[1];
        return 
    $r;
    }

    function 
    read_history($file) {
        
    $config get_config($file);

        
    $s '';
        
    $f fopen($file'r');
        while (!
    feof($f)) {
           
    $line fgets($f4096);
           
    $s .= $line;
           if (
    trim($line) == 'END_TIME') break;
        }
        
    fclose($f);

        
    $visits_total 0$unique_total 0$pages_total 0$hits_total 0$bandwidth_total 0;
        
    $not_viewed_pages_total 0$not_viewed_hits_total 0$not_viewed_bandwidth_total 0;

        if (
    preg_match('/TotalVisits (\d+)/'$s$match)) $visits_total = (int)$match[1];
        if (
    preg_match('/TotalUnique (\d+)/'$s$match)) $unique_total = (int)$match[1];

        if (
    preg_match('/\nBEGIN_TIME \d+\n(.*)\nEND_TIME\n/s'$s$match)) {
            foreach (
    explode("\n"$match[1]) as $row) {
                list(
    $hour$pages$hits$bandwidth,
                     
    $not_viewed_pages$not_viewed_hits$not_viewed_bandwidth) = explode(' '$row);
                
    $pages_total += $pages$hits_total += $hits$bandwidth_total += $bandwidth;
                
    $not_viewed_pages_total += $not_viewed_pages;
                
    $not_viewed_hits_total += $not_viewed_hits;
                
    $not_viewed_bandwidth_total += $not_viewed_bandwidth;
            }
        }

        return array(
    'config'=>$config'visits'=>$visits_total'unique'=>$unique_total,
                     
    'pages'=>$pages_total'hits'=>$hits_total'bandwidth'=>$bandwidth_total,
                     
    'not_viewed_pages'=>$not_viewed_pages_total,
                     
    'not_viewed_hits'=>$not_viewed_hits_total,
                     
    'not_viewed_bandwidth'=>$not_viewed_bandwidth_total);
    }

    function 
    parse_dir($dir) {
        
    // add trailing slash if not exists
        
    if (substr($dir, -1) != '/'$dir .= '/';
        
    $files = array();
        if (
    $dh = @opendir($dir)) {
            while ((
    $file readdir($dh)) !== false) {
                if (!
    preg_match('/^\./s'$file)) {
                    if (
    is_dir($dir.$file)) {
                        
    $newdir $dir.$file.'/';
                        
    chdir($newdir);
                        
    $files array_merge($filesparse_dir($newdir));
                    } else {
                        
    $files[] = $dir.$file;
                    }
                }
            }
            
    chdir('..');
        }
        return 
    $files;
    }

    if (!
    is_dir($DirData)) die("Could not open directory $DirData");

    $dirfiles parse_dir($DirData);

    $files = array();
    $config = array();
    if (
    $month == 'all'$pat '\d{2}'; else $pat substr('0'.$month, -2);
    $pat '/awstats'.$pat.$year.'\.(.+)\.txt$/';
    foreach (
    $dirfiles as $file) if (preg_match($pat$file$match)) {
        
    $config $match[1];
        if (!
    $FilterConfigs || in_array($config$FilterConfigs)) {
            
    $configs[] = $config;
            
    $files[] = $file;
        }
    }

    $visits_total 0$unique_total 0$pages_total 0$hits_total 0$bandwidth_total 0;
    $not_viewed_pages_total 0$not_viewed_hits_total 0$not_viewed_bandwidth_total 0;

    $rows = array();
    if (
    $files) {
        
    array_multisort($configs$files);
        
    $row_prev = array();
        for (
    $i 0$cnt count($files); $i <= $cnt$i++) {
            
    $row = array();
            if (
    $i $cnt) {
                
    $row read_history($files[$i]);

                if (
    $NotViewed == 'sum') {
                    
    $row['pages'] += $row['not_viewed_pages'];
                    
    $row['hits'] += $row['not_viewed_hits'];
                    
    $row['bandwidth'] += $row['not_viewed_bandwidth'];
                }

                
    $visits_total += $row['visits'];
                
    $unique_total += $row['unique'];
                
    $pages_total += $row['pages'];
                
    $hits_total += $row['hits'];
                
    $bandwidth_total += $row['bandwidth'];
               
                if (
    $NotViewed == 'columns') {
                    
    $not_viewed_pages_total += $row['not_viewed_pages'];
                    
    $not_viewed_hits_total += $row['not_viewed_hits'];
                    
    $not_viewed_bandwidth_total += $row['not_viewed_bandwidth'];
                }
            }
            if ( isset(
    $row['config']) && isset($row_prev['config']) &&
                 (
    $row['config'] == $row_prev['config']) ) {

                
    $row['visits'] += $row_prev['visits'];
                
    $row['unique'] += $row_prev['unique'];
                
    $row['pages'] += $row_prev['pages']; 
                
    $row['hits']  += $row_prev['hits'];
                
    $row['bandwidth'] += $row_prev['bandwidth'];

                if (
    $NotViewed == 'columns') {
                    
    $row['not_viewed_pages'] += $row_prev['not_viewed_pages'];
                    
    $row['not_viewed_hits'] += $row_prev['not_viewed_hits'];
                    
    $row['not_viewed_bandwidth'] += $row_prev['not_viewed_bandwidth'];
                }

            } elseif (
    $i 0$rows[] = $row_prev;
            
    $row_prev $row;
        }
    }

    function 
    multisort(&$array$key) {
       
    $cmp create_function('$a, $b',
           
    'if ($a["'.$key.'"] == $b["'.$key.'"]) return 0;'.
           
    'return ($a["'.$key.'"] > $b["'.$key.'"]) ? -1 : 1;');
       
    usort($array$cmp);
    }

    if (
    $sort == 'config'sort($rows); else multisort($rows$sort);

    function 
    detect_language($DirLang) {
        
    $Lang '';
        foreach (
    explode(','$_SERVER['HTTP_ACCEPT_LANGUAGE']) as $Lang) {
            
    $Lang strtolower(trim(substr($Lang02)));
            if (
    is_dir("$DirLang/awstats-$Lang.txt")) break; else $Lang '';
        }
        if (!
    $Lang$Lang 'en';
        return 
    $Lang;
    }

    function 
    read_language_data($file) {
        
    $r = array();
        if (
    file_exists($file)) $lines file($file);
        if (
    $lines) foreach ($lines as $line)
            if (
    preg_match('/^message(\d+)=(.*)$/'$line$match))
                
    $r[$match[1]] = $match[2];
        return 
    $r;
    }

    // remove trailing slash if exists
    if (substr($DirLang, -1) == '/'$DirLang substr($DirLang0strlen($DirLang) - 1);

    if (
    $Lang == 'auto'$Lang detect_language($DirLang);

    $message read_language_data("$DirLang/awstats-$Lang.txt");

    if (!
    $message) {
        
    $message[7]   = 'Statistics for';
        
    $message[10]  = 'Number of visits';
        
    $message[11]  = 'Unique visitors';
        
    $message[56]  = 'Pages';
        
    $message[57]  = 'Hits';
        
    $message[60]  = 'Jan';
        
    $message[61]  = 'Feb';
        
    $message[62]  = 'Mar';
        
    $message[63]  = 'Apr';
        
    $message[64]  = 'May';
        
    $message[65]  = 'Jun';
        
    $message[66]  = 'Jul';
        
    $message[67]  = 'Aug';
        
    $message[68]  = 'Sep';
        
    $message[69]  = 'Oct';
        
    $message[70]  = 'Nov';
        
    $message[71]  = 'Dec';
        
    $message[75]  = 'Bandwidth';
        
    $message[102] = 'Total';
        
    $message[115] = 'OK';
        
    $message[133] = 'Reported period';
        
    $message[160] = 'Viewed traffic';
        
    $message[161] = 'Not viewed traffic';
    }

    function 
    byte_format($number$decimals 2) {
        global 
    $dec_point$thousands_sep;
        
    // kilo, mega, giga, tera, peta, exa, zetta, yotta
        
    $prefix_arr = array('','k','M','G','T','P','E','Z','Y');
        
    $i 0;
        if (
    $number == 0$result 0; else {
            
    $value round($number$decimals);
            while (
    $value 1024) { $value /= 1024$i++; }
            
    $result number_format($value$decimals$dec_point$thousands_sep);
        }
        
    $result .= ' '.$prefix_arr[$i].'B'; if (!$i$result .= 'ytes';
        return 
    $result;
    }

    function 
    num_format($number$decimals 0) {
        global 
    $dec_point$thousands_sep;
        return 
    number_format($number$decimals$dec_point$thousands_sep);
    }


    /*******************************************************
     * HTML SECTION
     *******************************************************/

    ?>
    <!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN>
    <html>
    <head>
    <title>AWStats Totals</title>
    <style type="text/css">
    body { font: 11px verdana,arial,helvetica,sans-serif; background-color: white }
    td   { font: 11px verdana,arial,helvetica,sans-serif; text-align: center; color: black }
    .l { text-align: left }
    .b { background-color: #CCCCDD; padding: 2px; margin: 0 }
    .d { background-color: white }
    .f { font: 14px verdana,arial,helvetica }
    .border { border: #ECECEC 1px solid }
    a  { text-decoration: none }
    a:hover { text-decoration: underline }
    a.h  { color: black }
    </style>
    </head>
    <body>

    <form action="<?php echo $_SERVER['SCRIPT_NAME']; ?>">
    <table class="b" border="0" cellpadding="2" cellspacing="0" width="100%">
    <tr><td class="l">
    <table class="d" border="0" cellpadding="8" cellspacing="0" width="100%">
    <tr>
    <th><?php echo $message[133]; ?>:</th>
    <td class="l">
    <?php
    echo '<select class="f" name="month">'."\n";
    for (
    $i 1$i <= 12$i++) { 
        echo 
    '<option value="'.$i.'"'; if ($month == $i) echo ' selected'; echo '>'.$message[$i 59]."\n";
    }
    echo 
    '<option value="all"'; if ($month == 'all') echo ' selected'; echo '>-'."\n";
    echo 
    '</select>'."\n";

    echo 
    '<select class="f" name="year">'."\n";
    for (
    $curyear date('Y'), $i $curyear 4$i <= $curyear$i++) {
        echo 
    '<option value="'.$i.'"'; if ($year == $i) echo ' selected'; echo '>'.$i."\n";
    }
    echo 
    '</select>'."\n";
    ?>
    <input type="submit" class="f" value="<?php echo $message[115]; ?>">
    </td></tr>
    </table>
    </td></tr>
    </table>
    </form>

    <table align="center">
    <?php
    if ($NotViewed == 'columns') {
    ?>
    <tr>
    <td>&nbsp;
    <td class="border" colspan="5"><?php echo $message[160]; ?>
    <td class="border" colspan="3"><?php echo $message[161]; ?>
    <tr>
    <?php
    }
    $url $_SERVER['SCRIPT_NAME']."?month=$month&year=$year&sort=";
    ?>
    <td bgcolor="#ECECEC" class="l" nowrap>&nbsp;<a href="<?php echo $url?>config" class="h"><?php echo $message[7]; ?></a>
    <td width="80" bgcolor="#FFB055"><a href="<?php echo $url?>unique" class="h"><?php echo $message[11]; ?></a>
    <td width="80" bgcolor="#F8E880"><a href="<?php echo $url?>visits" class="h"><?php echo $message[10]; ?></a>
    <td width="80" bgcolor="#4477DD"><a href="<?php echo $url?>pages" class="h"><?php echo $message[56]; ?></a>
    <td width="80" bgcolor="#66F0FF"><a href="<?php echo $url?>hits" class="h"><?php echo $message[57]; ?></a>
    <td width="80" bgcolor="#2EA495"><a href="<?php echo $url?>bandwidth" class="h"><?php echo $message[75]; ?></a>
    <?php
    if ($NotViewed == 'columns') {
    ?>
    <td width="80" bgcolor="#4477DD"><a href="<?php echo $url?>not_viewed_pages" class="h"><?php echo $message[56]; ?></a>
    <td width="80" bgcolor="#66F0FF"><a href="<?php echo $url?>not_viewed_hits" class="h"><?php echo $message[57]; ?></a>
    <td width="80" bgcolor="#2EA495"><a href="<?php echo $url?>not_viewed_bandwidth" class="h"><?php echo $message[75]; ?></a>
    <?php
    }
    foreach (
    $rows as $row) {
        echo 
    '<tr><td class="l"><a href="'.$AWStatsURL."?month=$month&year=$year&config=".
             
    $row['config'].'">'.$row['config'].'</a><td>'.num_format($row['unique']).
             
    '<td>'.num_format($row['visits']).'<td>'.num_format($row['pages']).
             
    '<td>'.num_format($row['hits']).'<td>'.byte_format($row['bandwidth']);
        if (
    $NotViewed == 'columns') echo '<td>'.num_format($row['not_viewed_pages']).
             
    '<td>'.num_format($row['not_viewed_hits']).
             
    '<td>'.byte_format($row['not_viewed_bandwidth']);
        echo 
    "\n";
    }
    echo 
    '<tr><td class="l" bgcolor="#ECECEC">&nbsp;Total<td bgcolor="#ECECEC">'.num_format($unique_total).
         
    '<td bgcolor="#ECECEC">'.num_format($visits_total).'<td bgcolor="#ECECEC">'.num_format($pages_total).
         
    '<td bgcolor="#ECECEC">'.num_format($hits_total).'<td bgcolor="#ECECEC">'.byte_format($bandwidth_total);
    if (
    $NotViewed == 'columns') echo '<td bgcolor="#ECECEC">'.num_format($not_viewed_pages_total).
         
    '<td bgcolor="#ECECEC">'.num_format($not_viewed_hits_total).
         
    '<td bgcolor="#ECECEC">'.byte_format($not_viewed_bandwidth_total);
    echo 
    "\n";
    ?>
    </table>

    <br><br><center><b>AWStats Totals 1.16</b> - <a
    href="http://www.telartis.nl/xcms/awstats">&copy; 2004-2008 Telartis BV</a></center><br><br>

    </body>
    </html>
     
  7. falko

    falko Super Moderator

    As far as I can see, the script assumes that the stats for all web sites are stored in the same directory, so I don't think this will work with ISPConfig.
     
  8. matrixn

    matrixn New Member

    is there a way to make it to read the config for every web user added in ispconfig :confused:

    if i known how awstats for ispconfig works... i might get it done... i have some basic skills in php :). Is there a way to read the awstats configs for every web from ispconfig mysql database?
     
  9. matrixn

    matrixn New Member

    i assume that u are talking about this line


    PHP:
    $DirData '/var/lib/awstats'
    Did u known where the database of awstats is saved.. i didn`t manage to find it. There is a database for every web added in ispconfig am i right??so.. i think that is the problem mentioned by you in the upper post?


    P.S. I know that my english is very bad... :(
     
  10. falko

    falko Super Moderator

    Unfortunately not - I've never used awstats with ISPConfig.
     

Share This Page