From ae9233272a532393012a19446bf3b2f1822de2a0 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 15 Aug 2001 17:50:15 +0000 Subject: - blog.module: + fix small glitch with blog not being displayed immediatly after posting --- modules/blog/blog.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/blog') diff --git a/modules/blog/blog.module b/modules/blog/blog.module index a4d1f302f..ae4b370e0 100644 --- a/modules/blog/blog.module +++ b/modules/blog/blog.module @@ -71,7 +71,7 @@ function blog_page_user($name = 0, $date = 0) { $name = check_input($name ? $name : $user->name); $date = check_input($date ? $date : time()); - $result = db_query("SELECT n.nid, n.title, n.comment, COUNT(c.cid) AS comments, n.timestamp, b.body FROM blog b LEFT JOIN node n ON b.nid = n.nid LEFT JOIN users u ON n.author = u.id LEFT JOIN comments c ON n.nid = c.lid WHERE u.name = '$name' AND n.timestamp < '$date' AND n.timestamp > '". ($date - 2592000) ."' GROUP BY n.nid ORDER BY n.nid DESC LIMIT 20"); + $result = db_query("SELECT n.nid, n.title, n.comment, COUNT(c.cid) AS comments, n.timestamp, b.body FROM blog b LEFT JOIN node n ON b.nid = n.nid LEFT JOIN users u ON n.author = u.id LEFT JOIN comments c ON n.nid = c.lid WHERE u.name = '$name' AND n.timestamp <= '$date' AND n.timestamp >= '". ($date - 2592000) ."' GROUP BY n.nid ORDER BY n.nid DESC LIMIT 20"); $output .= ""; -- cgit v1.2.3