HTTP referers

[TRN]

The good news is that half of the visitors to this website are coming from bookmarks. That is a real honor. We know that traffic spikes when other sites link to a story but it is the long time visitors that make this website real for us. Thank you.

[TRN]

The good news is that half of the visitors to this website are coming from bookmarks. That is a real honor. We know that traffic spikes when other sites link to a story but it is the long time visitors that make this website real for us. Thank you.

AdvStats shows visitors from the following countries in the past hour: Australia, Belgium, Canada, Poland, Chile, Denmark, Finland, Switzerland, Israel

Not bad ! Thanks.

[robbie_n]

That error's still there :-(


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/linuxz/linuxtests-www/modules/AdvStats/track.php on line 187

[TRN]

Annoying isn't it? !

:mad:

I haven't figured out why though. It seems to only be in the phpBB2 forums. :cry:

I posted in the developers forum .. after all .. it is beta product. He seems to have not updated it since July. So, we'll see what happens. Maybe I'll yank it. Or maybe I'll be forced to figure it out myself. :shock:

[robbie_n]

lol :lol:

[TRN]

Discussion here is a start.. I guess. Not that I understand it but I found the code and now I'll just have to explore parts above and below it.

http://www.php.net/manual/en/function.mysql-num-rows.php

[TRN]

Well, here is the offending query.

$sql="select substring(tracktime,1,10) as date,
substring(tracktime,1,4) as annee, substring(tracktime,6,2) as mois, substring(tracktime,9,2) as jour from
".pnConfigGetVar('prefix')."_tracking WHERE tracktime NOT LIKE '$today%' GROUP BY date";
$query=mysql_query($sql);
$rows=mysql_num_rows($query);

This is an example from the php manual:

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

[TRN]

Well, here is the offending query.

$sql="select substring(tracktime,1,10) as date,
substring(tracktime,1,4) as annee, substring(tracktime,6,2) as mois, substring(tracktime,9,2) as jour from
".pnConfigGetVar('prefix')."_tracking WHERE tracktime NOT LIKE '$today%' GROUP BY date";
$query=mysql_query($sql);
$rows=mysql_num_rows($query);

This is an example from the php manual:

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

OK. I'm not sure if this fixes the problem or just hides it but I placed this symbol @ in front of the mysql_query and mysql_num_rows. Therefore, the code now looks like this:

$query = @ mysql_query($sql);
$rows = @ mysql_num_rows($query);