[geeklog-cvs] geeklog: Fixed SQL error

[geeklog-cvs at lists.geeklog.net]

changeset 7881:2d1bc9ff9534
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/2d1bc9ff9534
user: Dirk Haun <dirk at haun-online.de>
date: Thu Apr 08 20:35:11 2010 +0200
description:
Fixed SQL error

diffstat:

 public_html/lib-common.php |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r 7c0e8b83e7e9 -r 2d1bc9ff9534 public_html/lib-common.php
--- a/public_html/lib-common.php	Wed Apr 07 10:07:20 2010 +0200
+++ b/public_html/lib-common.php	Thu Apr 08 20:35:11 2010 +0200
@@ -1958,7 +1958,7 @@
     if ($numB > 1) {
         $B = DB_fetchArray($resultB);
         // un-feature all other featured frontpage story
-        $sql = "UPDATE {$_TABLES['stories']} SET featured = 0 WHERE featured = 1 AND draft_flag = 0 AND frontpage = 1 AND date <= NOW() AND sid NOT '{$B['sid']}'";
+        $sql = "UPDATE {$_TABLES['stories']} SET featured = 0 WHERE featured = 1 AND draft_flag = 0 AND frontpage = 1 AND date <= NOW() AND sid <> '{$B['sid']}'";
         DB_query($sql);
     }