Fixed bug #5055: SQL problem with reviewstate in EM (thanks to Franz-Xaver Koch)
authorOliver Hader <oliver.hader@typo3.org>
Sun, 25 Feb 2007 10:08:52 +0000 (10:08 +0000)
committerOliver Hader <oliver.hader@typo3.org>
Sun, 25 Feb 2007 10:08:52 +0000 (10:08 +0000)
git-svn-id: https://svn.typo3.org/TYPO3v4/Core/trunk@2151 709f56b5-9817-0410-a4d7-c38de5d9e867

ChangeLog
typo3/mod/tools/em/class.em_xmlhandler.php

index b127329..ae2a3aa 100755 (executable)
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,7 @@
+2007-02-25  Oliver Hader  <oh@inpublica.de>
+
+       * Fixed bug #5055: SQL problem with reviewstate in EM (thanks to Franz-Xaver Koch)
+
 2007-02-24  Ernesto Baschny  <ernst@cron-it.de>
 
        * Fix for bug fix #2677: Highlighting of current page in workspaces was not de-highlighting previous one
index 73393f0..798569e 100644 (file)
@@ -70,10 +70,10 @@ class SC_mod_tools_em_xmlhandler {
                        $where.= ' AND ownerusername='.$GLOBALS['TYPO3_DB']->fullQuoteStr($owner, 'cache_extensions');
                }
                if (strlen($owner) || $this->useUnchecked || $allExt)   {
-                                       // do never show extensions marked as insecure
-                       $where.= ' AND NOT reviewstate < 0';
-               } else {
                                // show extensions without review or that have passed review
+                       $where.= ' AND reviewstate >= 0';
+               } else {
+                               // only display extensions that have passed review
                        $where.= ' AND reviewstate > 0';
                }
                if (!$this->useObsolete && !$allExt)    {