From 665c9fdc2ca50f7960c16b375685485b3eb8b1cc Mon Sep 17 00:00:00 2001 From: Angie Byron Date: Thu, 26 Feb 2009 07:30:29 +0000 Subject: Roll-back of users -> user table name change in #330983: Broken pgsql is no fun. --- modules/blogapi/blogapi.install | 2 +- modules/blogapi/blogapi.module | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) (limited to 'modules/blogapi') diff --git a/modules/blogapi/blogapi.install b/modules/blogapi/blogapi.install index d0dc8eaa3..a8bb46d9b 100644 --- a/modules/blogapi/blogapi.install +++ b/modules/blogapi/blogapi.install @@ -30,7 +30,7 @@ function blogapi_schema() { 'type' => 'serial', ), 'uid' => array( - 'description' => 'The {user}.uid of the user who is associated with the file.', + 'description' => 'The {users}.uid of the user who is associated with the file.', 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, diff --git a/modules/blogapi/blogapi.module b/modules/blogapi/blogapi.module index 57c210191..763d39f10 100644 --- a/modules/blogapi/blogapi.module +++ b/modules/blogapi/blogapi.module @@ -379,13 +379,13 @@ function blogapi_blogger_get_recent_posts($appkey, $blogid, $username, $password } if ($bodies) { - $result = db_query_range("SELECT n.nid, n.title, r.body, r.format, n.comment, n.created, u.name FROM {node} n, {node_revision} r, {user} u WHERE n.uid = u.uid AND n.vid = r.vid AND n.type = :type AND n.uid = :uid ORDER BY n.created DESC", array( + $result = db_query_range("SELECT n.nid, n.title, r.body, r.format, n.comment, n.created, u.name FROM {node} n, {node_revision} r, {users} u WHERE n.uid = u.uid AND n.vid = r.vid AND n.type = :type AND n.uid = :uid ORDER BY n.created DESC", array( ':type' => $blogid, ':uid' => $user->uid ), 0, $number_of_posts); } else { - $result = db_query_range("SELECT n.nid, n.title, n.created, u.name FROM {node} n, {user} u WHERE n.uid = u.uid AND n.type = :type AND n.uid = :uid ORDER BY n.created DESC", array( + $result = db_query_range("SELECT n.nid, n.title, n.created, u.name FROM {node} n, {users} u WHERE n.uid = u.uid AND n.type = :type AND n.uid = :uid ORDER BY n.created DESC", array( ':type' => $blogid, ':uid' => $user->uid ), 0, $number_of_posts); -- cgit v1.2.3