Visit Counter (Page 3 of 3)

full story.

hey,

Please donot alter the web counter code of Free internet Counter and paste as html counter as it is to avoid difficulties. This counter can also be used as a PHP counter and ASP counter. Grow Business. Many of fancy counters of different colors are given below to choose from so you have a choice and you put beautiful web counters of your taste on your website.

bobblemaker

Hello Support,

Actually, I use :

<?php

/*
  CREATE TABLE `cn_visit_counter` (
  `id` int(11) NOT NULL,
  `ip` varchar(16) NOT NULL,
  `accesstime` int(11) NOT NULL,
  KEY `id` (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8
*/

$MYSQL_HOST = '###';
$MYSQL_USER = '###';
$MYSQL_PASS = '###';
$MYSQL_DB = '###';

$cn_connection = mysql_connect($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASS);
mysql_select_db($MYSQL_DB, $cn_connection);
unset($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASS, $MYSQL_DB);

if (!defined('CN_CONNECT'))
    define("CN_CONNECT", $cn_connection);

add_hook('core/entry_make_start', '*visit_counter');

function visit_counter($template, $data, $template_name)
{
    global $_plugin_visit_access;

    $ID = intval($data['id']);
    $online_time = intval(getoption('client_online'));

    if ($online_time == 0 || !empty($_plugin_visit_access))
        return array($template);

    // Part 1: Add
    if ($data['id'] && $template_name == 'full')
    {
        $_ip = mysql_real_escape_string($_SERVER['REMOTE_ADDR'], CN_CONNECT);

        mysql_query("INSERT INTO cn_visit_counter (`id`, `ip`, `accesstime`) VALUES ($ID, '$_ip', UNIX_TIMESTAMP(NOW()))", CN_CONNECT);
        mysql_query("DELETE FROM cn_visit_counter WHERE accesstime < ".(time() - $online_time), CN_CONNECT);
    }

    // Part 2: Calc
    $views = mysql_fetch_assoc( mysql_query("SELECT COUNT(*) as `count` FROM cn_visit_counter WHERE id = $ID", CN_CONNECT) );
    $template = str_replace("{page-views}", $views['count'], $template);

    $_plugin_visit_access = TRUE;
    return array($template);
}

This plugin work fine.

I test it on my private SQL (with port) and the connection is not good. I don't understand why. I've tested too with this code but don't work :

<?php

/*
  CREATE TABLE `cn_visit_counter` (
  `id` int(11) NOT NULL,
  `ip` varchar(16) NOT NULL,
  `accesstime` int(11) NOT NULL,
  KEY `id` (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8
*/

$MYSQL_HOST = '###';
$MYSQL_USER = '###';
$MYSQL_PASS = '###';
$MYSQL_DB = '###';
$MYSQL_PORT = '###';

$cn_connection = mysql_connect($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASS, $MYSQL_PORT);
mysql_select_db($MYSQL_DB, $cn_connection);
unset($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASS, $MYSQL_DB, $MYSQL_PORT);

if (!defined('CN_CONNECT'))
    define("CN_CONNECT", $cn_connection);

add_hook('core/entry_make_start', '*visit_counter');

function visit_counter($template, $data, $template_name)
{
    global $_plugin_visit_access;

    $ID = intval($data['id']);
    $online_time = intval(getoption('client_online'));

    if ($online_time == 0 || !empty($_plugin_visit_access))
        return array($template);

    // Part 1: Add
    if ($data['id'] && $template_name == 'full')
    {
        $_ip = mysql_real_escape_string($_SERVER['REMOTE_ADDR'], CN_CONNECT);

        mysql_query("INSERT INTO cn_visit_counter (`id`, `ip`, `accesstime`) VALUES ($ID, '$_ip', UNIX_TIMESTAMP(NOW()))", CN_CONNECT);
        mysql_query("DELETE FROM cn_visit_counter WHERE accesstime < ".(time() - $online_time), CN_CONNECT);
    }

    // Part 2: Calc
    $views = mysql_fetch_assoc( mysql_query("SELECT COUNT(*) as `count` FROM cn_visit_counter WHERE id = $ID", CN_CONNECT) );
    $template = str_replace("{page-views}", $views['count'], $template);

    $_plugin_visit_access = TRUE;
    return array($template);
}

Could you help me to solve this small problem ?

Thanks you!