Index: site_user_list.module =================================================================== RCS file: /cvs/drupal-contrib/contributions/modules/site_user_list/Attic/site_user_list.module,v retrieving revision 1.1.2.6.2.1 diff -u -r1.1.2.6.2.1 site_user_list.module --- site_user_list.module 29 Mar 2007 18:06:39 -0000 1.1.2.6.2.1 +++ site_user_list.module 10 Apr 2007 17:02:16 -0000 @@ -264,13 +264,13 @@ $type = variable_get('site_user_list_query_type', 'view'); $name = variable_get('site_user_list_select_from', 'site_user_list_view'); if ($type == 'view') { - db_query("CREATE OR REPLACE VIEW {$name} AS " . $internal_sql); + db_query("CREATE OR REPLACE VIEW \{$name} AS " . $internal_sql); } elseif ($type == 'table') { - if (db_table_exists("{$name}")) { - db_query("DROP TABLE {$name}"); + if (db_table_exists("\{$name}")) { + db_query("DROP TABLE \{$name}"); } - db_query("CREATE TABLE {$name} AS " . $internal_sql); + db_query("CREATE TABLE \{$name} AS " . $internal_sql); } } @@ -394,7 +394,7 @@ // build the query $select_from = variable_get('site_user_list_select_from', 'site_user_list_view'); $sql = 'SELECT DISTINCT cd.uid as uid_key, ' . implode(', ', $select_columns) . ' ' - . "FROM {$select_from} as cd " + . "FROM \{$select_from} as cd " . implode(' ', $sql_options['joins']) . ' ' . 'WHERE cd.uid not in (' . implode(", ", $users_to_exclude) . ')' . (count($sql_options['where']) ? " and " . implode(" and ", $sql_options['where'])