diff options
| author | Dries Buytaert <dries@buytaert.net> | 2001-08-15 17:50:15 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2001-08-15 17:50:15 +0000 |
| commit | ae9233272a532393012a19446bf3b2f1822de2a0 (patch) | |
| tree | 0b3d506bf68b5a6384d69525e5800091d0999303 | |
| parent | af1e20e4299af53c920416ece552db385e25ef3f (diff) | |
| download | brdo-ae9233272a532393012a19446bf3b2f1822de2a0.tar.gz brdo-ae9233272a532393012a19446bf3b2f1822de2a0.tar.bz2 | |
- blog.module:
+ fix small glitch with blog not being displayed immediatly after
posting
| -rw-r--r-- | modules/blog.module | 2 | ||||
| -rw-r--r-- | modules/blog/blog.module | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/modules/blog.module b/modules/blog.module index a4d1f302f..ae4b370e0 100644 --- a/modules/blog.module +++ b/modules/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 .= "<table border=\"0\" cellpadding=\"4\" cellspacing=\"4\">"; 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 .= "<table border=\"0\" cellpadding=\"4\" cellspacing=\"4\">"; |