diff options
| author | Max Kremmel <xing@synapse.plus.com> | 2007-04-19 06:42:16 +0000 |
|---|---|---|
| committer | Max Kremmel <xing@synapse.plus.com> | 2007-04-19 06:42:16 +0000 |
| commit | d02464ad7b5d80bdde7161c87d1fd3a7c226bfc1 (patch) | |
| tree | 0fca7c1edad1d40192e8363683a23893bc9e4db5 /FisheyeGallery.php | |
| parent | 770e711610dacc5216c60e5fe2b392ccd460458e (diff) | |
| download | fisheye-d02464ad7b5d80bdde7161c87d1fd3a7c226bfc1.tar.gz fisheye-d02464ad7b5d80bdde7161c87d1fd3a7c226bfc1.tar.bz2 fisheye-d02464ad7b5d80bdde7161c87d1fd3a7c226bfc1.zip | |
liberty_attachemnt join fix to work with new schema
Diffstat (limited to 'FisheyeGallery.php')
| -rw-r--r-- | FisheyeGallery.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/FisheyeGallery.php b/FisheyeGallery.php index a07e3de..01781a1 100644 --- a/FisheyeGallery.php +++ b/FisheyeGallery.php @@ -1,6 +1,6 @@ <?php /** - * @version $Header: /cvsroot/bitweaver/_bit_fisheye/FisheyeGallery.php,v 1.53 2007/03/20 07:52:01 squareing Exp $ + * @version $Header: /cvsroot/bitweaver/_bit_fisheye/FisheyeGallery.php,v 1.54 2007/04/19 06:42:16 squareing Exp $ * @package fisheye */ @@ -139,7 +139,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_attachments` la ON ( la.`content_id`=fi.`content_id` ) + INNER JOIN `".BIT_DB_PREFIX."liberty_attachments_map` lam ON ( lam.`content_id`=fi.`content_id` ) + INNER JOIN `".BIT_DB_PREFIX."liberty_attachments` la ON ( la.`attachment_id`=lam.`attachment_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` "; |