You can download and run a full working version of CNStats, free of charge, using a trial registration key. The trial key differs from the commercial one only in a limited usage period. At the end of the trial period you can purchase a key and continue using CNStats without data loss.

CNStats PRO 3.2
CNStats STD 3.2

»
»
»

	Presentation
	Our Awards
	Screenshots

home

contacts

demo

Counter appearance modification

Requirements: CNStats 2.7 and later; GD 1.0 and later.

During CNStats installation you are offered two types of a code for allocation at the site ("Configuration - Counter type" section):

Mandatory statistics code - the one that counts the visitors;
Optional counter code - it creates a picture displaying the attendance data - graphical counter.

The counter appearance can be changed. Different variants of CNStats graphical counter are described in this article.

By default CNStats counter look as follows:

There are three figures: the uppermost denotes total pageviews, the middle one - pageviews for the current day, the lowermost - hosts for the current day. Further various means of counter appearance modification and ways of displaying other useful information will be considered.

At the end of the article you will be able to examine all the abovementioned counter types and to download them for usage.

Source data

CNStats is able to provide the following information for counter display:

Hits for the current day, for the previous day and total hits quantity;
Hosts for the current day, for the previous day and total hosts quantity;
Visitors for the current day, for the previous day and total visitors quantity;
Currently on-line.

Since CNStats can count robots, it's also possible to display these data:

Robots for the current day, for the previous day and total quantity;
Robots/users percentage.

Besides, you can make various graphical counters displaying attendance dynamics.

CNStats counters display

By default, the counter displaying script is located in CNStats root directory under the name cnts.php (abbr. Counter-Show). It is advisable to name your counter files likewise, for instance, cnts-big.php, cnts-ttf.php etc.

Let's begin with a certain standard template, which is mandatory for each CNStats counter code:

<?
error_reporting(E_ALL & ~E_NOTICE);

// Inserting the configuration file.
include "config.php";

// Creating images from the preset template.
$im=ImageCreateFromPng("button.png");

// Connecting to MySql server.
$CONN=@mysql_connect($STATS_CONF["sqlhost"],
                     $STATS_CONF["sqluser"],
                     $STATS_CONF["sqlpassword"]);
if (mysql_errno()==0) {

    // Selecting database
    @mysql_select_db($STATS_CONF["dbname"]);

    if (mysql_errno()==0) {
        // .. performing all necessary actions 
        // for image creation...       
        }
    }

// Sending HTTP header Content-Type
Header("Content-type: image/png");

// Generating images
ImagePng($im);

// Clearing the memory
ImageDestroy($im);
?>

Further this code will be inserted without comments.

Counter 1 - the standard one

<?
error_reporting(E_ALL & ~E_NOTICE);
include "config.php";

$im=ImageCreateFromPng("button.png");
$CONN=@mysql_connect($STATS_CONF["sqlhost"],
                     $STATS_CONF["sqluser"],
                     $STATS_CONF["sqlpassword"]);
if (mysql_errno()==0) {
    @mysql_select_db($STATS_CONF["dbname"]);

if (mysql_errno()==0) {

// Selecting data 
        // t_hits - total hits 
        // hits - hits for the current day
        // hosts - hosts for the current day
        $r=@mysql_query("SELECT t_hits,hits,hosts FROM cns_counter");

// Transferring the only selected record into associative array
        $res=@mysql_fetch_array($r,MYSQL_ASSOC);

// Releasing memory
        @mysql_free_result($r);

// Selecting the required colours
        $black=ImageColorAllocate($im,0,0,0);
        $color=ImageColorAllocate($im,$COUNTER["inkR"],
                                      $COUNTER["inkG"],
                                      $COUNTER["inkB"]);

// Displaying the numbers
        ImageString($im,2,86-6*strlen($res["t_hits"]),1,$res["t_hits"],$color);
        ImageString($im,1,85-5*strlen($res["hits"]),13,$res["hits"],$color);
        ImageString($im,1,85-5*strlen($res["hosts"]),20,$res["hosts"],$color);
        }
    }

Header("Content-type: image/png");
ImagePng($im);
ImageDestroy($im);
?>

The most significant part of the code is SQL query, which fetches the displayed data from the table:

SELECT t_hits,hits,hosts FROM cns_counter

The following features can also be fetched from CNStats tables without overloading the server:

SELECT hits, hosts, users,
       t_hits, t_hosts, t_users,
       u_hits, u_hosts,
       u_t_hits, u_t_hosts
FROM cns_counter;

Herein:

hits - hits for the current day
hosts - hosts for the current day
users - users for the current day
t_hits - total hits
t_hosts - total hosts
t_users - total users
u_hits - users hits for the current day (robots excluded)
u_hosts - users hosts for the current day (robots excluded)
u_t_hits - total users hits (robots excluded)
u_t_hosts - total users hosts (robots excluded)
u_hits-hits - robots hits for the current day
u_hosts-hosts - robots hosts for the current day
u_t_hits-t_hits - total robots hits
u_t_hosts-t_hosts - total robots hosts

Note! Robots are considered only with "PHP-Include" and "Combined" counters.

Below is the query received by "currently on-line" users (conventionally):

SELECT count(DISTINCT hid) as online
   FROM cns_log
   WHERE date>NOW() - INTERVAL 3 MINUTE;

Counter 2 - total hits, hits for the current day, users for the current day and currently on-line

As it can be seen from the counter display, another basic image has been used here to put in "Currently on-line" data (marked by red colour)

<?
error_reporting(E_ALL & ~E_NOTICE);
include "config.php";

$im=ImageCreateFromPng("button-tt.png");
$CONN=@mysql_connect($STATS_CONF["sqlhost"],
                     $STATS_CONF["sqluser"],
                     $STATS_CONF["sqlpassword"]);
if (mysql_errno()==0) {
    @mysql_select_db($STATS_CONF["dbname"]);

if (mysql_errno()==0) {

// Selecting data 
        // t_hits - total hits 
        // hits - hits for the current day
        // users - users for the current day
        $r=@mysql_query("SELECT t_hits,hits,users FROM cns_counter");

// Transferring the only selected record into associative array
        $res=@mysql_fetch_array($r,MYSQL_ASSOC);

// Releasing memory
        @mysql_free_result($r);

// Selecting the required colours
        $black=ImageColorAllocate($im,0,0,0);
        $red=ImageColorAllocate($im,255,0,0);

// Displaying the numbers
        ImageString($im,2,3,1,$res["t_hits"],$black);
        ImageString($im,1,3,13,$res["hits"],$black);
        ImageString($im,1,3,20,$res["users"],$black);

// Selecting "Currently on-line"
        $r=@mysql_query("SELECT count(DISTINCT hid) as online
                         FROM cns_log
                         WHERE date>NOW() - INTERVAL 3 MINUTE;");

$text=@mysql_result($r,0,0);
        @mysql_free_result($r);
        // Displaying " Currently on-line"
        ImageString($im,1,80-5*strlen($text),4,$text,$red);
        }
    }

Header("Content-type: image/png");
ImagePng($im);
ImageDestroy($im);
?>

Counter 3 - True-Type fonts usage for counter generation

Unfortunately, TrueType fonts are not supported at some servers, therefore this counter is not included into the distribution kit.

There are hits, hosts and users for the current day displayed at this counter (for a change).

<?
error_reporting(E_ALL & ~E_NOTICE);
include "config.php";

// The function allows to define string length in pixels
function width($text) {
    $box=imagettfbbox(7, 0, FONT_TAHOMA, $text);
    return($box[2]-$box[1]);
    }

// The font used for counter display
// It can be taken from C:\Windows\Fonts
define('FONT_TAHOMA', 'tahoma.ttf');

// Note: the image should be True-Color (24 bits)
$im=ImageCreateFromPng("button-tt.png");
$CONN=@mysql_connect($STATS_CONF["sqlhost"],
                     $STATS_CONF["sqluser"],
                     $STATS_CONF["sqlpassword"]);

if (mysql_errno()==0) {
    @mysql_select_db($STATS_CONF["dbname"]);

if (mysql_errno()==0) {

// Selecting data 
        // hits - hits for the current day
        // hosts - hosts for the current day
        // users - users for the current day

$r=@mysql_query("SELECT hits,hosts,users FROM cns_counter");

// Transferring the only selected record into associative array
        $res=@mysql_fetch_array($r,MYSQL_ASSOC);

// Releasing memory
        @mysql_free_result($r);

// Displaying the text
        $text = $res["hits"];
        Imagettftext($im,7, 0, 4, 10, 0x03314A, FONT_TAHOMA, $text);

$text = $res["hosts"];
        Imagettftext($im,7, 0, 4, 19, 0x03314A, FONT_TAHOMA, $text);

$text = $res["users"];
        Imagettftext($im,7, 0, 4, 28, 0x03814A, FONT_TAHOMA, $text);

$r=mysql_query("SELECT count(DISTINCT hid) as online
                        FROM cns_log
                        WHERE date>NOW() - INTERVAL 10 MINUTE;");
        $text = mysql_result($r,0,0);
        Imagettftext($im,7, 0, 80-width($text), 12, 0xC0314A, FONT_TAHOMA, $text);
        }
    }

ImagePng($im);
ImageDestroy($im);
?>

Counter 4 - total hits, hits for the current day, users for the current day, robots percentage

The counter appearance will be changed slightly: shadows will be added; figures will be made more readable by means of indents.

<?
error_reporting(E_ALL & ~E_NOTICE);
include "config.php";

// The function allows to define string length in pixels
function width($text) {
    $box=imagettfbbox(7, 0, FONT_TAHOMA, $text);
    return($box[2]-$box[1]);
    }

// The font used for counter display
// It can be taken from C:\Windows\Fonts
define('FONT_TAHOMA', 'tahoma.ttf');

// Note: the image should be True-Color (24 bits)
$im=ImageCreateFromPng("button-tt.png");

$CONN=@mysql_connect($STATS_CONF["sqlhost"],
                     $STATS_CONF["sqluser"],
                     $STATS_CONF["sqlpassword"]);

if (mysql_errno()==0) {
    @mysql_select_db($STATS_CONF["dbname"]);

if (mysql_errno()==0) {

// Selecting data
        // t_hits - total hits
        // hits - hits for the current day
        // users - users for the current day
        // u_hits - users hits
        $r=@mysql_query("SELECT t_hits,hits,users, u_hits FROM cns_counter");

// Transferring the only selected record into associative array
        $res=@mysql_fetch_array($r,MYSQL_ASSOC);

// Releasing memory
        @mysql_free_result($r);

// Displaying the text
        $text = number_format($res["t_hits"],0,","," ");
        Imagettftext($im,7, 0, 5, 11, 0xCCCCCC, FONT_TAHOMA, $text);
        Imagettftext($im,7, 0, 4, 10, 0x03314A, FONT_TAHOMA, $text);

$text = number_format($res["hits"],0,","," ");
        Imagettftext($im,7, 0, 5, 20, 0xCCCCCC, FONT_TAHOMA, $text);
        Imagettftext($im,7, 0, 4, 19, 0x04476C, FONT_TAHOMA, $text);

$text = number_format($res["users"],0,","," ");
        Imagettftext($im,7, 0, 5, 29, 0xcccccc, FONT_TAHOMA, $text);
        Imagettftext($im,7, 0, 4, 28, 0x04876C, FONT_TAHOMA, $text);

// Calculating robots percentage
        if ($res["hits"]!=0)
            $text = intval((1-$res["u_hits"]/$res["hits"])*100)."%";
        else
            $text="0";

// Displaying the text
        Imagettftext($im,7, 0, 80-width($text), 12, 0xCCCCCC, FONT_TAHOMA, $text);
        Imagettftext($im,7, 0, 79-width($text), 11, 0x03804A, FONT_TAHOMA, $text);
        }
    }

ImagePng($im);
ImageDestroy($im);
?>

Counter 5 - all included

The counter presents itself amount of all the previous.

<?
error_reporting(E_ALL & ~E_NOTICE);
include "config.php";

// The function allows to define string length in pixels
function width($text) {
    $box=imagettfbbox(7, 0, FONT_TAHOMA, $text);
    return($box[2]-$box[1]);
    }

// The font used for counter display
// It can be taken from C:\Windows\Fonts
define('FONT_TAHOMA', 'tahoma.ttf');

// Note: the image should be True-Color (24 bits)
$im=ImageCreateFromPng("button-big.png");

$CONN=@mysql_connect($STATS_CONF["sqlhost"],
                     $STATS_CONF["sqluser"],
                     $STATS_CONF["sqlpassword"]);

if (mysql_errno()==0) {
    @mysql_select_db($STATS_CONF["dbname"]);

if (mysql_errno()==0) {

$r=@mysql_query("SELECT t_hits,t_hosts,t_users,hits,hosts,users,u_hits FROM cns_counter");
        $res=@mysql_fetch_array($r,MYSQL_ASSOC);
        @mysql_free_result($r);

$text = number_format($res["t_hits"],0,","," ");
        Imagettftext($im,7, 0, 86-width($text), 11, 0xCCCCCC, FONT_TAHOMA, $text);
        Imagettftext($im,7, 0, 85-width($text), 10, 0x03314A, FONT_TAHOMA, $text);

$text = number_format($res["hits"],0,","," ");
        Imagettftext($im,7, 0, 86-width($text), 20, 0xCCCCCC, FONT_TAHOMA, $text);
        Imagettftext($im,7, 0, 85-width($text), 19, 0x0331FF, FONT_TAHOMA, $text);

$text = number_format($res["t_hosts"],0,","," ");
        Imagettftext($im,7, 0, 86-width($text), 31, 0xCCCCCC, FONT_TAHOMA, $text);
        Imagettftext($im,7, 0, 85-width($text), 30, 0x03314A, FONT_TAHOMA, $text);

$text = number_format($res["hosts"],0,","," ");
        Imagettftext($im,7, 0, 86-width($text), 40, 0xCCCCCC, FONT_TAHOMA, $text);
        Imagettftext($im,7, 0, 85-width($text), 39, 0x0331FF, FONT_TAHOMA, $text);

$text = number_format($res["t_users"],0,","," ");
        Imagettftext($im,7, 0, 86-width($text), 51, 0xCCCCCC, FONT_TAHOMA, $text);
        Imagettftext($im,7, 0, 85-width($text), 50, 0x03314A, FONT_TAHOMA, $text);

$text = number_format($res["users"],0,","," ");
        Imagettftext($im,7, 0, 86-width($text), 60, 0xCCCCCC, FONT_TAHOMA, $text);
        Imagettftext($im,7, 0, 85-width($text), 59, 0x0331FF, FONT_TAHOMA, $text);

$r=mysql_query("SELECT count(DISTINCT hid) as online
                        FROM cns_log
                        WHERE date>NOW() - INTERVAL 3 MINUTE;");
        $text = mysql_result($r,0,0);
        Imagettftext($im,7, 0, 86-width($text), 70, 0xCCCCCC, FONT_TAHOMA, $text);
        Imagettftext($im,7, 0, 85-width($text), 69, 0xC0314A, FONT_TAHOMA, $text);

$text = sprintf("%.2f%%",(1-$res["u_hits"]/$res["hits"])*100);
        Imagettftext($im,7, 0, 86-width($text), 82, 0xCCCCCC, FONT_TAHOMA, $text);
        Imagettftext($im,7, 0, 85-width($text), 81, 0x03804A, FONT_TAHOMA, $text);
        }
    }
ImagePng($im);
ImageDestroy($im);
?>

Download

Example	Reference	System requirements
	Download	GD, PNG support
	Download	GD, PNG support
	Download	GD 2.0+, PNG support, TrueType support
	Download	GD 2.0+, PNG support, TrueType support
	Download	GD 2.0+, PNG support, TrueType support

In case you have any difficulties or would like to suggest something, please, e-mail us. We are ready to answer all your questions.