diff options
| author | Max Kremmel <xing@synapse.plus.com> | 2005-10-28 19:08:19 +0000 |
|---|---|---|
| committer | Max Kremmel <xing@synapse.plus.com> | 2005-10-28 19:08:19 +0000 |
| commit | 0aed853141d57b048551b8920f7c438d27aaddfe (patch) | |
| tree | 21a105695ef3d56754b7f20b260b46a9262d0e86 /Pigeonholes.php | |
| parent | be1d39c0d1e10009cd62a7ee690fc66d4e61c64d (diff) | |
| download | pigeonholes-0aed853141d57b048551b8920f7c438d27aaddfe.tar.gz pigeonholes-0aed853141d57b048551b8920f7c438d27aaddfe.tar.bz2 pigeonholes-0aed853141d57b048551b8920f7c438d27aaddfe.zip | |
used wrong JOIN: RIGHT JOIN --> LEFT JOIN
Diffstat (limited to 'Pigeonholes.php')
| -rw-r--r-- | Pigeonholes.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/Pigeonholes.php b/Pigeonholes.php index b621436..8aa1fb8 100644 --- a/Pigeonholes.php +++ b/Pigeonholes.php @@ -1,6 +1,6 @@ <?php /** - * @version $Header: /cvsroot/bitweaver/_bit_pigeonholes/Pigeonholes.php,v 1.8 2005/10/26 17:48:53 squareing Exp $ + * @version $Header: /cvsroot/bitweaver/_bit_pigeonholes/Pigeonholes.php,v 1.9 2005/10/28 19:08:19 squareing Exp $ * * +----------------------------------------------------------------------+ * | Copyright ( c ) 2004, bitweaver.org @@ -17,7 +17,7 @@ * Pigeonholes class * * @author xing <xing@synapse.plus.com> - * @version $Revision: 1.8 $ + * @version $Revision: 1.9 $ * @package pigeonholes */ @@ -143,7 +143,7 @@ class Pigeonholes extends LibertyAttachable { RIGHT JOIN `".BIT_DB_PREFIX."bit_pigeonholes` bp ON ( bp.`content_id` = bpm.`parent_id` ) INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON ( tc.`content_id` = bpm.`content_id` ) INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc2 ON ( bp.`content_id` = tc2.`content_id` ) - RIGHT JOIN `".BIT_DB_PREFIX."tiki_content_types` tct ON ( tc.`content_type_guid` = tct.`content_type_guid` ) + LEFT JOIN `".BIT_DB_PREFIX."tiki_content_types` tct ON ( tc.`content_type_guid` = tct.`content_type_guid` ) LEFT JOIN `".BIT_DB_PREFIX."users_users` uu ON ( uu.`user_id` = tc.`user_id` ) $where $order"; $result = $this->mDb->query( $query, $bindVars, !empty( $pListHash['max_records'] ) ? $pListHash['max_records'] : NULL ); |