[Lyceum-dev] Widgets: MyBlogs and All Blogs

John Joseph Bachir jjb at ibiblio.org
Sun Jul 30 23:03:17 EDT 2006


great stuff. dave, if you post this somewhere downloadable on the web 
(maybe along with an explanator blog post) we'll feature it on the lyceum 
blog.

maybe a more important issue---  are folks still wanting a lyceum plugin 
svn repository?

we should definitely have a mailing list.

john



On Sun, 30 Jul 2006, DaveG wrote:

> Jameson Lopp wrote:
>> $wpdb is a global variable, so before you start using it you should
>> have the statement:
>>
>> global $wpdb;
>>
> That worked great, thanks! Here's the final code (with a few HTML tweaks):
>
>    echo $before_widget;
> //----------------
>    global $wpdb;
>    $wpdb->query("
>      CREATE TEMPORARY TABLE bloginfo
>        SELECT $wpdb->blogs.id, $wpdb->blogs.slug, option_value as
> blogname, status
>        FROM $wpdb->blogs
>          INNER JOIN $wpdb->options ON ($wpdb->blogs.id =
> $wpdb->options.blog)
>          INNER JOIN $wpdb->posts
>          INNER JOIN $wpdb->post2cat ON (post_id = $wpdb->posts.ID)
>          INNER JOIN $wpdb->categories ON (category_id = cat_ID AND
> $wpdb->categories.blog = $wpdb->options.blog)
>        WHERE
>          status = 'active' AND
>          option_name = 'blogname'
>        ORDER BY post_date_gmt DESC
>    ");
>    $blogs = $wpdb->get_results("SELECT DISTINCT(id), slug, blogname,
> status FROM bloginfo");
>
>    echo $before_title . $title . $after_title . "<ul>";
>    if ($blogs)
>      if(SUBDOMAINS)
>        foreach ($blogs as $b)
>          echo "<li><a
> href=\"http://$b->slug.".MAINDOMAIN."\">$b->blogname</a></li>";
>      else
>        foreach ($blogs as $b)
>          echo "<li><a href=\"./$b->slug\">$b->blogname</a></li>";
> //----------------
>    echo "</ul>" . $after_widget;
>
> _______________________________________________
> Lyceum-dev mailing list
> Lyceum-dev at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/lyceum-dev
>

-- 
John
----
aim/yim/msn/jabber.org: johnjosephbachir
713.494.2704
irc://irc.freenode.net/lyceum
http://lyceum.ibiblio.org/
http://blog.johnjosephbachir.org/



More information about the Lyceum-dev mailing list