https://proxy2.de/forum/posts/list/3.php JForum - http://www.jforum.net
I see you have it your Daily Counter working on your site. Are you using text files or do you have a fix for mysql.class.php.



The total visitors seems to work fine, but daily ....
It logs each visitor as "1" in the database and is not adding them
and then fails to return a value for $visits['visits_today']

thanx

Actually looking at the code, the problem is in counter.class.php]]> https://proxy2.de/forum/posts/preList/7674/26251.php https://proxy2.de/forum/posts/preList/7674/26251.php GMT https://proxy2.de/forum/posts/preList/7674/26257.php https://proxy2.de/forum/posts/preList/7674/26257.php GMT
The function to update counter is in counter.class.php on line 70.
$this->db->query("UPDATE ".$this->table['total']." set total=total+1"); seems to work

$this->db->query("UPDATE ".$this->table['daily']." SET visitors=visitors+'1' WHERE day = now()"); - does not

echo $visits['total']; works
echo $visits['visits_today']; does not

Cannot figure out why ?????]]> https://proxy2.de/forum/posts/preList/7674/26258.php https://proxy2.de/forum/posts/preList/7674/26258.php GMT
"UPDATE ".$this->table['daily']." SET visitors=visitors+'1' WHERE day = now()"

to see what code it is creating.]]> https://proxy2.de/forum/posts/preList/7674/26259.php https://proxy2.de/forum/posts/preList/7674/26259.php GMT
This is what it is doing...

$this->db->query("UPDATE ".$this->table['daily']." SET visitors=visitors+1 WHERE day = now()");
if ($this->db->affected_rows() == 0) {
// $this->db->query("INSERT INTO ".$this->table['daily']." SET visitors='1', day = now()");


It is running the " if ($this->db->affected_rows() == 0)" and continuously adds a new date and entry of 1. One one site with 10,000 daily visits, I don't even want to mention the database size!

If I comment it out, it stops adding new entries (tried an echo here but not displayed).

The question is, why is it always seeing the "affected rows()==0" ????

You would think that function affected rows was the problem in mysql.class.php but the total update works, i.e.,

$this->db->query("UPDATE ".$this->table['total']." set total=total+1");

if ($this->db->affected_rows() == 0) {
$this->db->query("INSERT INTO ".$this->table['total']." SET total='1', installtime = UNIX_TIMESTAMP()");

In thsi case (total), it is executing the set "total=total+1" and NOT the affected_rows() == 0)

Dont mind saying I am stumped

]]> https://proxy2.de/forum/posts/preList/7674/26260.php https://proxy2.de/forum/posts/preList/7674/26260.php GMT
[code]if ($this->db->affected_rows() == 0) {
$this->db->query("INSERT INTO ".$this->table['daily']." SET visitors='1', day = CURDATE()");[/code]]]> https://proxy2.de/forum/posts/preList/7674/26261.php https://proxy2.de/forum/posts/preList/7674/26261.php GMT
I think I am going to shoot myself if it is a new version

Will let you know - ]]> https://proxy2.de/forum/posts/preList/7674/26262.php https://proxy2.de/forum/posts/preList/7674/26262.php GMT Can't now, but will try it shortly and let you know]]> https://proxy2.de/forum/posts/preList/7674/26263.php https://proxy2.de/forum/posts/preList/7674/26263.php GMT https://proxy2.de/forum/posts/preList/7674/26264.php https://proxy2.de/forum/posts/preList/7674/26264.php GMT THANK YOU
I have changed the version on all the scripts to version 1.2!!!!

Thank you again]]> https://proxy2.de/forum/posts/preList/7674/26265.php https://proxy2.de/forum/posts/preList/7674/26265.php GMT