summaryrefslogtreecommitdiff
path: root/FisheyeGallery.php
diff options
context:
space:
mode:
authorChristian Fowler <spider@viovio.com>2006-10-06 20:44:38 +0000
committerChristian Fowler <spider@viovio.com>2006-10-06 20:44:38 +0000
commitf91f62911b4131e8bc76a4a4e6273dadf06c2a18 (patch)
tree0836db96fb92765585fbc729247962b0ffdf4a8b /FisheyeGallery.php
parent5a63eb6abf70329e31a8edf883dfdefcb92532dd (diff)
downloadfisheye-f91f62911b4131e8bc76a4a4e6273dadf06c2a18.tar.gz
fisheye-f91f62911b4131e8bc76a4a4e6273dadf06c2a18.tar.bz2
fisheye-f91f62911b4131e8bc76a4a4e6273dadf06c2a18.zip
fix long standing next/prev bug
Diffstat (limited to 'FisheyeGallery.php')
-rw-r--r--FisheyeGallery.php5
1 files changed, 3 insertions, 2 deletions
diff --git a/FisheyeGallery.php b/FisheyeGallery.php
index 33a953f..e3d9830 100644
--- a/FisheyeGallery.php
+++ b/FisheyeGallery.php
@@ -1,6 +1,6 @@
<?php
/**
- * @version $Header: /cvsroot/bitweaver/_bit_fisheye/FisheyeGallery.php,v 1.39 2006/10/03 20:45:11 spiderr Exp $
+ * @version $Header: /cvsroot/bitweaver/_bit_fisheye/FisheyeGallery.php,v 1.40 2006/10/06 20:44:38 spiderr Exp $
* @package fisheye
*/
@@ -116,7 +116,8 @@ class FisheyeGallery extends FisheyeBase {
$query = "SELECT fgim.*, fi.`image_id`, lf.`storage_path`
FROM `".BIT_DB_PREFIX."fisheye_gallery_image_map` fgim
INNER JOIN `".BIT_DB_PREFIX."fisheye_image` fi ON ( fi.`content_id`=fgim.`item_content_id` )
- INNER JOIN `".BIT_DB_PREFIX."liberty_files` lf ON ( lf.`file_id`=fi.`image_id` )
+ INNER JOIN `".BIT_DB_PREFIX."liberty_attachments` la ON ( la.`content_id`=fi.`content_id` )
+ INNER JOIN `".BIT_DB_PREFIX."liberty_files` lf ON ( lf.`file_id`=la.`foreign_id` )
WHERE fgim.`gallery_content_id` = ?
ORDER BY fgim.`item_position`, fi.`content_id` ";
if( $rs = $this->mDb->query($query, array( $this->mContentId ) ) ) {