Most popular picts ordered by click per day...

[Loïc]

Hi!

In order to not handicap new picts I would like to order most popular picts following the number of click per day instead of the total number of click... Is that mod already existing? Or anybody can help me?

Thanx,

[Loïc]

up...

[Nibbler]

Not posted afaik, you'd need to add in per day hit tracking to do this.

[Loïc]

Here's what I tried, without succes:

I found:

Code Select Expand

                $query = "SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES'AND hits > 0 $META_ALBUM_SET $keyword ORDER BY hits DESC, filename  $limit";
and replace by:

Code Select Expand

$now = time();

                $query = "SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES'AND hits > 0 $META_ALBUM_SET $keyword ORDER BY hits/($now-ctime) DESC, filename  $limit";

But all I got is the pict ordered by date...

Then I tried

Code Select Expand

ORDER BY (hits/($now-ctime))
and

Code Select Expand

ORDER BY (hits*1/($now-ctime*1))
and

Code Select Expand

ORDER BY (hits*1/($now*1-ctime*1))
and finally

Code Select Expand

ORDER BY (hits*1/(".$now."-ctime*1))

with always the same result. I wonder if

Code Select Expand

$now = time(); is correct.

Any idea???

[Loïc]

OK, if someone cares about that, I found why it didn't work. The result was in click per second, and of course < to 0,01, so understood as 0,00. The solution is to multiply the result by 86400 to have the number of click per day...