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

[Jordi Salvadó]

Hello,

I think this SQL could be most "cool blogs" because i'm using reads
and comments,
but the most active blogs would be the people have been writed more
posts recently.



2007/2/1, Oscar Renalias <oscar at renalias.net>:
> 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;
> >>              }
> >>
> >>
> >
> > _______________________________________________
> > pLog-svn mailing list
> > pLog-svn at devel.lifetype.net
> > http://limedaley.com/mailman/listinfo/plog-svn
> >
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://limedaley.com/mailman/listinfo/plog-svn
>