Visit Counter (Page 2 of 3)

Unfortunately the plugin isn't suited for highly loaded projects because file editing takes time and lock process in windows based platform doesn't work. If you have an opportunity to connect to MySQL we can rewrite it for MySQL.

Thanks filou83 but I just want a simple counter of hits and this website is not free...

Thanks you so much, I test it and I make a feedback tomorrow...

Hello,

The script is good. No reboot with MySQL. Perfect !

Thanks you.

1) How many report are there in your database?
SELECT COUNT(*) FROM cn_visit_counter;

2) The amount of reports for 1 news SELECT COUNT(*) FROM cn_visit_counter WHERE id = 1361700169;

Change in the line's script

    $q = mysql_query("SELECT * FROM cn_visit_counter WHERE id = $ID ORDER BY accesstime ASC", $cn_connection);
    while ($a = mysql_fetch_assoc($q)) $news[] = $a;

to the following

    $q = mysql_query("SELECT * FROM cn_visit_counter WHERE id = $ID", $cn_connection);
    while ($a = mysql_fetch_assoc($q)) $news[ $a['accesstime'] ] = $a;
    ksort($news);

If the database is rather big and you can avoid keeping files of more that 3 days long you can add the lines after ksort($news)
    $the_old_time = 60*60*24*3; // 3 day
    mysql_query("DELETE FROM cn_visit_counter WHERE id = $ID AND accesstime < UNIX_TIMESTAMP(NOW()) - $the_old_time", $cn_connection);

Hi Support Team,

Since 1 week, here the result on the server :

120  618 ligns and 5,6 Mio

With the modification, it seems to be good :

$q = mysql_query("SELECT * FROM cn_visit_counter WHERE id = $ID", $cn_connection);
while ($a = mysql_fetch_assoc($q)) $news[ $a['accesstime'] ] = $a;
ksort($news);

I've deleted this :

$output = str_replace("{unique-views}", count($unique), $output);
$output = str_replace("{your-views}", $your_views, $output);
$output = str_replace("{online}", count($online), $output);
$output = str_replace("{first-view}", date($config_timestamp_active, $first_view), $output);

And finally I don't use this :

$the_old_time = 60*60*24*3; // 3 day
mysql_query("DELETE FROM cn_visit_counter WHERE id = $ID AND accesstime < UNIX_TIMESTAMP(NOW()) - $the_old_time", $cn_connection);

Regards,

Hi, I'd like to hicierais a tutorial for this plugin can be worth in version 2.0.

Thank you,
A greeting.

translate google spanish - English.
(Original):
Hola, me gustaría que me hicierais un tutorial para que este plugin pueda valen en la versión 2.0.

Gracias,
Un saludo.

Could You give a link to a fully working file visit-counter.php ?
I have the plugin does not work. MySQL database is created, the table is created.
CuteNews 2.0 last

Thank you very much.
a pop up window with the full news in the upper right corner

Hi Netta,

For MySQL, the post is the #35

Hi,

You must create table on your MySQL database like this :

/*
  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
*/

Here is how the table looks at me
An hour trying to make it work...