diff options
| author | Christian Fowler <spider@viovio.com> | 2007-05-05 05:15:29 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2007-05-05 05:15:29 +0000 |
| commit | 477f4c1e4ba2a00731657a011f085c40cf6ef186 (patch) | |
| tree | 81fedbbed77236420bf7eb531950c8fe61853e68 /FisheyeGallery.php | |
| parent | 9b8740c7c8f065894419a6a27489785ac4a1ac3a (diff) | |
| download | fisheye-477f4c1e4ba2a00731657a011f085c40cf6ef186.tar.gz fisheye-477f4c1e4ba2a00731657a011f085c40cf6ef186.tar.bz2 fisheye-477f4c1e4ba2a00731657a011f085c40cf6ef186.zip | |
removeORDER BY RANDOM for isAdvancedPostgresEnabled in getThumbnailImage
Diffstat (limited to 'FisheyeGallery.php')
| -rw-r--r-- | FisheyeGallery.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/FisheyeGallery.php b/FisheyeGallery.php index 01781a1..723a325 100644 --- a/FisheyeGallery.php +++ b/FisheyeGallery.php @@ -1,6 +1,6 @@ <?php /** - * @version $Header: /cvsroot/bitweaver/_bit_fisheye/FisheyeGallery.php,v 1.54 2007/04/19 06:42:16 squareing Exp $ + * @version $Header: /cvsroot/bitweaver/_bit_fisheye/FisheyeGallery.php,v 1.55 2007/05/05 05:15:29 spiderr Exp $ * @package fisheye */ @@ -368,7 +368,7 @@ class FisheyeGallery extends FisheyeBase { FROM connectby('`".BIT_DB_PREFIX."fisheye_gallery_image_map`', '`item_content_id`', '`gallery_content_id`', ?, 0, '/') AS t(`cb_item_content_id` int, `cb_parent_content_id` int, `level` int, `branch` text) INNER JOIN liberty_content lc ON(content_id=cb_item_content_id) LEFT OUTER JOIN `".BIT_DB_PREFIX."gatekeeper_security_map` cgm ON (cgm.`content_id`=lc.`content_id`), `".BIT_DB_PREFIX."fisheye_gallery` fg - WHERE lc.`content_type_guid`='fisheyeimage' $whereSql AND `cb_parent_content_id`=fg.`content_id` ORDER BY RANDOM()"; + WHERE lc.`content_type_guid`='fisheyeimage' $whereSql AND `cb_parent_content_id`=fg.`content_id`"; // ORDER BY RANDOM() is DOG slow (seq scans) if( $pThumbnailContentId = $this->mDb->getOne( $query, $bindVars ) ) { $pThumbnailContentType = 'fisheyeimage'; } |