OG Galleries Thumbnail Block

Ok I'll try to describe this as best I can. First, this is intended for use in Drupal 5.x, with the latest version of OG, OG Galleries, and Views. I will assume that you already have OG up and running and have configured OG Galleries using the default gallery name of "Main". Second, and this is a big one, I have not actually used this in a Block, instead I have decided to place the latest 3 images on the Group homepage node. Just edit the Group node making sure to use the PHP option and paste in this snippet:

<div id="gpphotos">
<center>Photo Album</center>
<?php
$query = "SELECT TID
FROM term_data TD inner join vocabulary V on V.vid = TD.vid inner join og_galleries gal on V.vid = gal.vid
WHERE gal.gid = '" . arg(1) . "' and TD.name = 'Main'";
$gal_term = db_result(db_query($query));
?>
<center>
<?php
print l("View All Pictures","galleries/" . arg(1) . "/" . $gal_term);
?>
</center>
<?php
$view = views_get_view('og_galleries');
print views_build_view('embed', $view,array(arg(1),$gal_term), false, 3);
?>
</div>

I make no claims that this is the best way to make this happen, but it worked for me. First, this code makes the assumption that the current node being viewed is a Group node, which in this case it always will be since it's on the Group homepage node, hence the arg(1) calls. The SQL query is being used to lookup the term id of the "Main" gallery associated with this group. I then call the views_get_view and views_build_view to get the default og_galleries view using the term id found earlier and limit the results to 3 images. I have not tried it, but this code should work in a block as well. Just create a new block and paste in the code. You may want to add some code to check if the current node is a Group node and hide/display the block accordingly.

Hope this helps,

Josh