[geeklog-cvs] geeklog: Fixed STORY_getItemInfo - need to check the draft flag ...

[geeklog-cvs at lists.geeklog.net]

details:   http://project.geeklog.net/cgi-bin/hgweb.cgi/rev/675d4c3b5229
changeset: 6573:675d4c3b5229
user:      Dirk Haun <dirk at haun-online.de>
date:      Sun Dec 21 09:37:59 2008 +0100
description:
Fixed STORY_getItemInfo - need to check the draft flag and for a publish date in the future

diffstat:

1 file changed, 5 insertions(+), 6 deletions(-)
system/lib-story.php |   11 +++++------

diffs (26 lines):

diff -r 67a914873db2 -r 675d4c3b5229 system/lib-story.php
--- a/system/lib-story.php	Sun Dec 21 09:27:23 2008 +0100
+++ b/system/lib-story.php	Sun Dec 21 09:37:59 2008 +0100
@@ -749,17 +749,16 @@
 
     // prepare SQL request
     if ($sid == '*') {
-        $where = '';
-        $permOp = 'WHERE';
+        $where = ' WHERE';
     } else {
-        $where = " WHERE sid = '$sid'";
-        $permOp = 'AND';
+        $where = " WHERE (sid = '$sid') AND";
     }
+    $where .= ' (draft_flag = 0) AND (date <= NOW())';
     if ($uid > 0) {
-        $permSql = COM_getPermSql($permOp, $uid)
+        $permSql = COM_getPermSql('AND', $uid)
                  . COM_getTopicSql('AND', $uid);
     } else {
-        $permSql = COM_getPermSql($permOp) . COM_getTopicSql('AND');
+        $permSql = COM_getPermSql('AND') . COM_getTopicSql('AND');
     }
     $sql = "SELECT " . implode(',', $fields)
             . " FROM {$_TABLES['stories']}" . $where . $permSql;