diff options
| author | Christian Fowler <spider@viovio.com> | 2007-09-04 16:30:06 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2007-09-04 16:30:06 +0000 |
| commit | fd73cbac8726c63fb6a237165e8655d89020200e (patch) | |
| tree | 0f4579bc0c6b4efdb176c574dbe3285da77b57cc | |
| parent | 4eb4e9312cbb5a5d54a10d4e489f53ed8486a5b3 (diff) | |
| download | users-fd73cbac8726c63fb6a237165e8655d89020200e.tar.gz users-fd73cbac8726c63fb6a237165e8655d89020200e.tar.bz2 users-fd73cbac8726c63fb6a237165e8655d89020200e.zip | |
LEFT JOIN on liberty_content_hits
| -rw-r--r-- | BitUser.php | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/BitUser.php b/BitUser.php index 2dbc27a..4baa032 100644 --- a/BitUser.php +++ b/BitUser.php @@ -1,6 +1,6 @@ <?php /** - * $Header: /cvsroot/bitweaver/_bit_users/BitUser.php,v 1.152 2007/08/02 14:36:15 spiderr Exp $ + * $Header: /cvsroot/bitweaver/_bit_users/BitUser.php,v 1.153 2007/09/04 16:30:06 spiderr Exp $ * * Lib for user administration, groups and permissions * This lib uses pear so the constructor requieres @@ -12,7 +12,7 @@ * All Rights Reserved. See copyright.txt for details and a complete list of authors. * Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See license.txt for details * - * $Id: BitUser.php,v 1.152 2007/08/02 14:36:15 spiderr Exp $ + * $Id: BitUser.php,v 1.153 2007/09/04 16:30:06 spiderr Exp $ * @package users */ @@ -40,7 +40,7 @@ define("ACCOUNT_DISABLED", -6); * Class that holds all information for a given user * * @author spider <spider@steelsun.com> - * @version $Revision: 1.152 $ + * @version $Revision: 1.153 $ * @package users * @subpackage BitUser */ @@ -1619,11 +1619,12 @@ class BitUser extends LibertyAttachable { $bindvars = array(); } $query = "SELECT uu.*, tf_ava.`storage_path` AS `avatar_storage_path` - FROM `".BIT_DB_PREFIX."users_users` uu - INNER JOIN `".BIT_DB_PREFIX."liberty_content` lc ON (uu.`content_id`=lc.`content_id`) - LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_attachments` ta_ava ON ( uu.`avatar_attachment_id`=ta_ava.`attachment_id` ) - LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_files` tf_ava ON ( tf_ava.`file_id`=ta_ava.`foreign_id` ) - $mid order by $sort_mode"; + FROM `".BIT_DB_PREFIX."users_users` uu + INNER JOIN `".BIT_DB_PREFIX."liberty_content` lc ON (uu.`content_id`=lc.`content_id`) + LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_content_hits` lch ON ( lc.`content_id` = lch.`content_id` ) + LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_attachments` ta_ava ON ( uu.`avatar_attachment_id`=ta_ava.`attachment_id` ) + LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_files` tf_ava ON ( tf_ava.`file_id`=ta_ava.`foreign_id` ) + $mid ORDER BY $sort_mode"; $query_cant = "select count(*) from `".BIT_DB_PREFIX."users_users` uu $mid"; $result = $this->mDb->query($query, $bindvars, $pParamHash['max_records'], $pParamHash['offset']); |