[pLog-svn] r4572 - plog/branches/lifetype-1.1.5/class/summary/dao

Oscar Renalias oscar at renalias.net
Sun Jan 28 18:01:04 EST 2007


I need to take a look, I guess we're not filtering based on the  
status of the blog...

On 28 Jan 2007, at 21:08, BalearWeb wrote:

> I think there is something wrong with this patch.
> I tested it (having applied all the previous patches too),
> and in the list of most active blogs I just get the 10 most
> new blogs, including those which have not yet been confirmed,
> that is with status=3
>
> oscar at devel.lifetype.net wrote:
>> Author: oscar
>> Date: 2007-01-24 21:12:48 +0000 (Wed, 24 Jan 2007)
>> New Revision: 4572
>>
>> Modified:
>>    plog/branches/lifetype-1.1.5/class/summary/dao/ 
>> summarystats.class.php
>> Log:
>> This is a simplified version of the getMostActiveBlogs() method,  
>> as apparently it hasn't been generating data properiy. It's not as  
>> complex as before but I wasn't able to come up with something as  
>> complex as before... don't know, perhaps it isn't even needed as  
>> long as the last_update_date field is updated accordingly (this  
>> new version is useless without that field...)
>>
>> 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-01-24 21:10:38 UTC (rev 4571)
>> +++ plog/branches/lifetype-1.1.5/class/summary/dao/ 
>> summarystats.class.php	2007-01-24 21:12:48 UTC (rev 4572)
>> @@ -179,7 +179,7 @@
>>  			include_once( PLOG_CLASS_PATH."class/dao/blogs.class.php" );
>>  		
>>  			$prefix = $this->getPrefix();
>> -            $query = "SELECT num_posts, last_update_date FROM  
>> {$prefix}blogs
>> +            $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."
>>  					  ORDER BY last_update_date DESC, num_posts DESC";
>> @@ -198,7 +198,7 @@
>>              $blogs = Array();
>>  			$blogsDao = new Blogs();
>>              while( $row = $result->FetchRow()) {
>> -                $blog = $blogsDao->getBlogInfo( $row["blog_id"] );
>> +                $blog = $blogsDao->getBlogInfo( $row["id"] );
>>                  $blogs[$blog->getId()] = $blog;
>>              }
>>
>
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://limedaley.com/mailman/listinfo/plog-svn
>



More information about the pLog-svn mailing list