From 6ac764fd0982930c1bc04a259c850fd380770250 Mon Sep 17 00:00:00 2001 From: Lester Caine Date: Sat, 18 Feb 2006 09:10:27 +0000 Subject: Fix reserved word field names - follow on from schema --- Pigeonholes.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'Pigeonholes.php') diff --git a/Pigeonholes.php b/Pigeonholes.php index 73d394b..636cf2d 100644 --- a/Pigeonholes.php +++ b/Pigeonholes.php @@ -1,6 +1,6 @@ - * @version $Revision: 1.46 $ + * @version $Revision: 1.47 $ * @package pigeonholes */ @@ -408,10 +408,10 @@ class Pigeonholes extends LibertyAttachable { $contentIds[] = $path['content_id']; } if( !empty( $contentIds ) ) { - $query = "SELECT `name`, `value` FROM `".BIT_DB_PREFIX."liberty_content_prefs` WHERE `content_id` IN( ".preg_replace( "/,$/", "", str_repeat( "?,", count( $contentIds ) ) )." ) "; + $query = "SELECT `name`, `pref_value` FROM `".BIT_DB_PREFIX."liberty_content_prefs` WHERE `content_id` IN( ".preg_replace( "/,$/", "", str_repeat( "?,", count( $contentIds ) ) )." ) "; $result = $this->mDb->query( $query, $contentIds ); while( $aux = $result->fetchRow() ) { - ${$aux['name']} = $aux['value']; + ${$aux['name']} = $aux['pref_value']; if( ( !empty( $group_id ) && !$gBitUser->isInGroup( $group_id ) ) || ( !empty( $permission ) && !$gBitUser->hasPermission( $permission ) ) ) { return FALSE; } -- cgit v1.3