[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/d68e45650544
changeset: 6583:d68e45650544
user:      Dirk Haun <dirk at haun-online.de>
date:      Mon Dec 22 12:00:58 2008 +0100
description:
Fixed STORY_getItemInfo - need to check the draft flag and for a publish date in the future

diffstat:

2 files changed, 4 insertions(+)
public_html/docs/history |    3 +++
system/lib-story.php     |    1 +

diffs (31 lines):

diff -r e402d4122df2 -r d68e45650544 public_html/docs/history
--- a/public_html/docs/history	Sun Dec 21 18:39:25 2008 +0100
+++ b/public_html/docs/history	Mon Dec 22 12:00:58 2008 +0100
@@ -4,6 +4,8 @@
 ------------
 
 - Fixed wrong use of COM_isAnonUser in COM_getPermSQL (since 1.5.0) [Dirk]
+- Fixed STORY_getItemInfo - need to check the draft flag and for a publish date
+  in the future [mystral-kk, Dirk]
 - When calling COM_getYearFormOptions with a $startoffset parameter, the list
   of years was off by one (bug #0000783; patch provided by hiroron)
 - Fixed updating feeds after changing topic permissions (bug #0000779) [Dirk]
@@ -64,6 +66,7 @@
 
 Links plugin
 ------------
+- Missing parentheses my have resulted in incorrect search results [Dirk]
 - Added urlencoded versions of {link_actual_url} and {link_name} [Dirk]
 - Prevent overwriting existing links when changing the link ID [Dirk]
 
diff -r e402d4122df2 -r d68e45650544 system/lib-story.php
--- a/system/lib-story.php	Sun Dec 21 18:39:25 2008 +0100
+++ b/system/lib-story.php	Mon Dec 22 12:00:58 2008 +0100
@@ -727,6 +727,7 @@
     if (count ($fields) > 0) {
         $result = DB_query ("SELECT " . implode (',', $fields)
                     . " FROM {$_TABLES['stories']} WHERE sid = '$sid'"
+                    . ' AND (draft_flag = 0) AND (date <= NOW())';
                     . COM_getPermSql ('AND') . COM_getTopicSql ('AND'));
         $A = DB_fetchArray ($result);
     } else {