diff options
| author | Max Kremmel <xing@synapse.plus.com> | 2006-09-01 12:43:43 +0000 |
|---|---|---|
| committer | Max Kremmel <xing@synapse.plus.com> | 2006-09-01 12:43:43 +0000 |
| commit | cdf0ccf9daf7517ebb7dbb5c786bb9cfa313de4f (patch) | |
| tree | 861a35de904edb06aed8ea993fea60149e795420 | |
| parent | 0632fc32b2a68be53fa31bbde32cd62bba4d8e97 (diff) | |
| download | liberty-cdf0ccf9daf7517ebb7dbb5c786bb9cfa313de4f.tar.gz liberty-cdf0ccf9daf7517ebb7dbb5c786bb9cfa313de4f.tar.bz2 liberty-cdf0ccf9daf7517ebb7dbb5c786bb9cfa313de4f.zip | |
remove hits from query
| -rwxr-xr-x | LibertyStructure.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/LibertyStructure.php b/LibertyStructure.php index 612b38f..2b68d04 100755 --- a/LibertyStructure.php +++ b/LibertyStructure.php @@ -3,7 +3,7 @@ * Management of Liberty Content * * @package liberty - * @version $Header: /cvsroot/bitweaver/_bit_liberty/LibertyStructure.php,v 1.28 2006/05/17 17:00:30 lsces Exp $ + * @version $Header: /cvsroot/bitweaver/_bit_liberty/LibertyStructure.php,v 1.29 2006/09/01 12:43:43 squareing Exp $ * @author spider <spider@steelsun.com> */ @@ -313,7 +313,7 @@ class LibertyStructure extends LibertyBase { $mid .= " AND lc.`content_type_guid`=? "; array_push( $bindVars, $pListHash['content_type_guid'] ); } - $query = "SELECT ls.`structure_id`, ls.`parent_id`, ls.`content_id`, `page_alias`, `pos`, lc.`title`, `hits`, `data`, `last_modified`, lc.`modifier_user_id`, `ip`, lc.`user_id` AS `creator_user_id`, uu.`login` AS `creator_user`, uu.`real_name` , uu.`email` + $query = "SELECT ls.`structure_id`, ls.`parent_id`, ls.`content_id`, `page_alias`, `pos`, lc.`title`, `data`, `last_modified`, lc.`modifier_user_id`, `ip`, lc.`user_id` AS `creator_user_id`, uu.`login` AS `creator_user`, uu.`real_name` , uu.`email` FROM `".BIT_DB_PREFIX."liberty_structures` ls INNER JOIN `".BIT_DB_PREFIX."liberty_content` lc ON ( ls.`content_id` = lc.`content_id` ) INNER JOIN `".BIT_DB_PREFIX."users_users` uu ON ( lc.`user_id` = uu.`user_id` ) WHERE $mid ORDER BY ".$this->mDb->convert_sortmode($pListHash['sort_mode']); |