From 63a10fdce860801d8e3276a0a229b678c2d01050 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 10 Aug 2005 20:48:40 +0000 Subject: - Bug 23810: removed redundant variable from SQL query. --- modules/profile.module | 2 +- modules/profile/profile.module | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'modules') diff --git a/modules/profile.module b/modules/profile.module index 939e47f7e..64db5ffcb 100644 --- a/modules/profile.module +++ b/modules/profile.module @@ -60,7 +60,7 @@ function profile_block($op = 'list', $delta = 0, $edit = array()) { if ($use_fields = variable_get('profile_block_author_fields', array())) { // Compile a list of fields to show $fields = array(); - $result = db_query('SELECT name, title, type, visibility FROM {profile_fields} WHERE visibility = %d ORDER BY weight', PROFILE_PUBLIC, PROFILE_PUBLIC_LISTING); + $result = db_query('SELECT name, title, type, visibility FROM {profile_fields} WHERE visibility = %d ORDER BY weight', PROFILE_PUBLIC); while ($record = db_fetch_object($result)) { // Endure that field is displayed only if it is among the defined block fields and, if it is private, the user has appropriate permissions. if (in_array($record->name, $use_fields)) { diff --git a/modules/profile/profile.module b/modules/profile/profile.module index 939e47f7e..64db5ffcb 100644 --- a/modules/profile/profile.module +++ b/modules/profile/profile.module @@ -60,7 +60,7 @@ function profile_block($op = 'list', $delta = 0, $edit = array()) { if ($use_fields = variable_get('profile_block_author_fields', array())) { // Compile a list of fields to show $fields = array(); - $result = db_query('SELECT name, title, type, visibility FROM {profile_fields} WHERE visibility = %d ORDER BY weight', PROFILE_PUBLIC, PROFILE_PUBLIC_LISTING); + $result = db_query('SELECT name, title, type, visibility FROM {profile_fields} WHERE visibility = %d ORDER BY weight', PROFILE_PUBLIC); while ($record = db_fetch_object($result)) { // Endure that field is displayed only if it is among the defined block fields and, if it is private, the user has appropriate permissions. if (in_array($record->name, $use_fields)) { -- cgit v1.2.3