[wp-hackers] Extending query_posts?

[Scott johnson]

I'd be careful with that.  My understanding of randomization in mysql
is that the performance is awful.  I haven't done it myself but that's
hwat I understand.

Scott

On 1/29/06, Sam Angove <sam at rephrase.net> wrote:
> On 1/29/06, Mattias Winther <mattias at winthernet.se> wrote:
> >
> > 1. Are there any other approaches that might work better? I realize there are ways to do a hack that does this, but I really want to make it feel like it was integrated in the wordpress core.
> > 2. Is there a hook for looking at and modifying the query just before sending it to the SQL server?
>
> 2. There's a bunch of them. posts_where, posts_join, posts_orderby
> etc. Browse WP_Query::get_posts() in classes.php.
>
> 1. I don't know how fast it is, but you can do it with ORDER BY RAND().
>
> This seems to work:
>
> <?php
> /*
> Plugin Name: Random Posts
> */
>
> function query_random_posts($query) {
>         return query_posts($query . '&random=true');
> }
>
> class RandomPosts {
>         function orderby($orderby) {
>                 if ( get_query_var('random') == 'true' )
>                         return "RAND()";
>                 else
>                         return $orderby;
>         }
>         function register_query_var($vars) {
>                 $vars[] = 'random';
>                 return $vars;
>         }
> }
> add_filter( 'posts_orderby', array('RandomPosts', 'orderby') );
> add_filter( 'query_vars', array('RandomPosts', 'register_query_var') );
> ?>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>


--
-------------------------------------------------------
J. Scott Johnson
Ookles launches 2/28/06 - have you signed up yet?
new startup: http://ookles.com/
blog: http://fuzzyblog.com/
podcast: http://techwarstories.com/
fuzzygroup at gmail.com
aim: fuzzygroup
cell: 857 222 6459
-------------------------------------------------------