[pLog-svn] r4642 - plog/branches/lifetype-1.1.5/class/summary/dao
BalearWeb
balearweb at balearweb.com
Thu Feb 1 06:30:43 EST 2007
It works ok, and I think it quite accurate.
Oscar Renalias wrote:
> You can give it a try and let us know. I am planning to release 1.1.5
> either today or tomorrow (there's no need to hold it back any longer)
> so having this fix in would be interesting.
>
> On 1 Feb 2007, at 12:05, BalearWeb wrote:
>
>
>> Jordi, from blocat.com, is using this:
>>
>> $query = "SELECT SUM(((a.num_reads + a.num_comments/5) /
>> (TO_DAYS(NOW()) - TO_DAYS(a.date) + 1)) )/COUNT(a.id) as rank,
>> b.id AS blog_id, b.blog
>> FROM {$prefix}articles AS a
>> INNER JOIN {$prefix}blogs AS b
>> ON b.id = a.blog_id AND b.status =
>> ".BLOG_STATUS_ACTIVE."
>> WHERE a.date >= ".$this->_startTime." AND a.date
>> <= ".$this->_now."
>> AND a.in_summary_page = '1'
>> AND b.show_in_summary = '1'
>> GROUP BY b.id
>> ORDER BY rank DESC";
>>
>> I still haven't tried. I will give it a try this afternoon.
>>
>> oscar at devel.lifetype.net wrote:
>>
>>> Author: oscar
>>> Date: 2007-02-01 04:34:44 -0500 (Thu, 01 Feb 2007)
>>> New Revision: 4642
>>>
>>> Modified:
>>> plog/branches/lifetype-1.1.5/class/summary/dao/
>>> summarystats.class.php
>>> Log:
>>> reverted the mostActiveBlogs() changes until we find another
>>> solution, since they did not seem to work very well
>>>
>>>
>>> Modified: plog/branches/lifetype-1.1.5/class/summary/dao/
>>> summarystats.class.php
>>> ===================================================================
>>> --- plog/branches/lifetype-1.1.5/class/summary/dao/
>>> summarystats.class.php 2007-02-01 00:12:11 UTC (rev 4641)
>>> +++ plog/branches/lifetype-1.1.5/class/summary/dao/
>>> summarystats.class.php 2007-02-01 09:34:44 UTC (rev 4642)
>>> @@ -179,13 +179,16 @@
>>> include_once( PLOG_CLASS_PATH."class/dao/blogs.class.php" );
>>>
>>> $prefix = $this->getPrefix();
>>> - $query = "SELECT id, num_posts, last_update_date FROM
>>> {$prefix}blogs
>>> - WHERE show_in_summary = '1'
>>> - AND last_update_date >= ".$this->_startTime." AND
>>> last_update_date <= ".$this->_now."
>>> - AND status = ".BLOG_STATUS_ACTIVE." AND
>>> - last_update_date > create_date
>>> - ORDER BY last_update_date DESC, num_posts DESC";
>>> -
>>> + $query = "SELECT COUNT(a.id) as t, SUM((num_reads /
>>> (TO_DAYS(NOW()) - TO_DAYS(a.date) + 1)) ) as rank, b.id AS blog_id
>>> + FROM {$prefix}articles AS a
>>> + INNER JOIN {$prefix}blogs AS b
>>> + ON b.id = a.blog_id AND b.status =
>>> ".BLOG_STATUS_ACTIVE."
>>> + WHERE a.date >= ".$this->_startTime." AND
>>> a.date <= ".$this->_now."
>>> + AND in_summary_page = '1'
>>> + AND b.show_in_summary = '1'
>>> + GROUP BY a.id
>>> + ORDER BY rank DESC";
>>> +
>>> if( $maxBlogs > 0 )
>>> $query .= " LIMIT 0,".$maxBlogs;
>>> else
>>> @@ -200,7 +203,7 @@
>>> $blogs = Array();
>>> $blogsDao = new Blogs();
>>> while( $row = $result->FetchRow()) {
>>> - $blog = $blogsDao->getBlogInfo( $row["id"] );
>>> + $blog = $blogsDao->getBlogInfo( $row["blog_id"] );
>>> $blogs[$blog->getId()] = $blog;
>>> }
>>>
>>>
More information about the pLog-svn
mailing list