Pastoid

<?php $theme->display('header'); ?>
<!-- plugin.single.php -->
<?php 
$versions_array = array();
$allversions = "";
$this_plugin = $post->title; // seemingly necessary as otherwise second post->title_out is wrong??
 
	foreach( (array) $post->versions as $version) 
	{ 
		$allversions .= ( $allversions ? " and " . $version->habari_version : $version->habari_version);
 
		$versions_array[ $version->habari_version ] = array(
			'plugin_version_id' => $version->id,
			'plugin_version_version' => $version->version,
			'plugin_version_description' => $version->description,
			'plugin_version_url' => $version->url,
			'plugin_version_status' => $version->status,
			'plugin_version_habari' => $version->habari_version
			);
	}
 
krsort( $versions_array); // ensure newest release first, cheap hack for now, though.
		/* those weren't all the fields, just enough to get started */
?>
 
<div class="push-5 span-19">
<h2 class="plugin_title"><a href="<?php echo $post->permalink; ?>"><?php 
echo $post->title_out; ?></a></h2><p class="plugin_title"><?php _e( " for Habari "); ?><?php echo 
$allversions; ?></p>
</div>
</div>
<div class="container">
 
<div class="column span-4">
 
 
<div id="recent_updates"><?php _e('Recently Updated'); ?>
<ul>
<?php
foreach(Posts::get(array('where'=>'{posts}.id in (select post_id from {dir_plugin_versions})', 
'limit'=>5)) as $post) {echo "<li><a href=\"{$post->permalink}\">{$post->title}</a></li>"; }
?>
</ul>
</div><!-- /recent_updates -->
 
</div><!-- /column span-4 push-1 -->
 
<?php if ( ! empty ( $versions_array ) ) : ?>
 
<div id="version_wrapper" class="column span-17">
<div id="version_accordion" class="ui-accordion-container">
	<?php foreach( $versions_array as $key => $version ) : ?>
<div class="olderpostbox">
<div id="x-<?php echo $post->id; ?>-<? echo $version['plugin_version_version']; ?>" class="versiontitle"><?php echo 
$post->title_out; ?> <?php echo $version[ 'plugin_version_habari' ]; ?>-<?php echo $version[ 'plugin_version_version' ]; 
?></div>
 
<div class="versioncontent container span-17">
 
	<div class="version_info column span-4">
		<?php $this_title = "$this_plugin $key-{$version[ 'plugin_version_version' ]}" ; ?>
			<a href="<?php echo $version[ 'plugin_version_url' ]; ?>" title="download <?php echo $this_title; ?>"><?php 
			echo $this_title; ?></a>
 
		<h3>Info</h3>
		<ul>
		<li>Author: <a href="<?php echo $post->info->author_url; ?>" rel="nofollow"><?php echo $post->info->author; ?></a></li>
		<li>License: <a href="/ssvn/explore/other/license/apache-license-2-0" title="More details about this license"><?php echo $post->info->license; ?></a></li>
		</ul>
 
	</div><!-- /version_info -->
 
	<div class="plugin_tabs_container column span-13 last">
		<ul class="plugin_tabs">
			<li><a href="#description<?php echo $version[ 'plugin_version_id']; ?>">Description</a></li>
			<li><a href="#instructions<?php echo $version[ 'plugin_version_id']; ?>">Instructions</a></li><?php 
		if ($post->info->screenshot) : ?>
			<li><a href="#screenshot<?php echo $version[ 'plugin_version_id']; ?>">Screenshot</a></li>
		<?php endif; ?>
		</ul>
 
		<div id="description<?php echo $version[ 'plugin_version_id']; ?>">
		<h3>Description</h3>
		<?php echo $post->content_out; ?>
		</div><!-- /description -->
 
		<div id="instructions<?php echo $version[ 'plugin_version_id']; ?>">
		<h3>Instructions</h3>
		<?php echo $post->info->instructions; ?>
		</div><!-- /instructions -->
 
		<?php if ($post->info->screenshot) : ?>
		<div id="screenshot<?php echo $version[ 'plugin_version_id']; ?>" class="screenshot">
		<h3>Screenshot</h3>
		<a href="<?php 
		echo $post->info->screenshot; ?>" title="<?php echo $post->title_out ?> Screenshot" class="thickbox"><img src="<?php 
		echo $post->info->screenshot; ?>" alt="screenshot of <?php echo $post->title_out; ?>"></a>
		</div><!-- /screenshot -->
		<?php endif; ?>
 
	</div><!-- /plugin_tabs_container -->
 
</div><!-- /versioncontent -->
</div><!-- /olderpostbox -->
<?php endforeach; ?>
</div><!-- /accordion_container -->
    </div><!-- /version_wrapper -->
<?php endif; ?>
 
<div class="column span-3 last">
 
<?php if ( is_array( $post->tags ) ) { ?>
 
	<div id="tags" class="box"><?php _e('Tagged:'); ?><ul>
	<?php foreach( $post->tags as $tag ) {  ?>
		<li><a href="<?php echo URL::get( 'display_entries_by_tag', array( 'tag' => $tag ) ); ?>"><?php echo $tag; ?></a></li>
	<?php } ?>
	</ul></div><!-- /tags -->
<?php } ?>
 
</div>
 
<? /*
<h2>results should be right here</h2>
<?php 
// var_dump(DB::get_results('select id from {posts} where {posts}.id in ((select post_id from {plugin_versions} limit 5))')); 
// var_dump(DB::get_results('select id from {posts} where id in (select post_id from {plugin_versions} limit 5)'));
// var_dump(DB::get_results('select slug from {posts} where id in (select post_id from {plugin_versions}) limit 5'));
 var_dump(Posts::get(array('where'=>'{posts}.id in (select post_id from {plugin_versions})', 'limit'=>5)));
?>
<h2>end of results</h2>
 
*/ ?>
 
<!-- /plugin.single.php -->
<?php $theme->display('footer'); ?>