[pLog-svn] r7189 - plugins/branches/lifetype-1.2/moderate

jondaley at devel.lifetype.net jondaley at devel.lifetype.net
Fri May 11 12:22:46 EDT 2012


Author: jondaley
Date: 2012-05-11 12:22:46 -0400 (Fri, 11 May 2012)
New Revision: 7189

Modified:
   plugins/branches/lifetype-1.2/moderate/pluginmoderate.class.php
Log:
I was trying to be more efficient by using a 'count' query, but if I do that, I need to do more checking later, so I'll leave it as it was

Modified: plugins/branches/lifetype-1.2/moderate/pluginmoderate.class.php
===================================================================
--- plugins/branches/lifetype-1.2/moderate/pluginmoderate.class.php	2012-05-11 15:52:42 UTC (rev 7188)
+++ plugins/branches/lifetype-1.2/moderate/pluginmoderate.class.php	2012-05-11 16:22:46 UTC (rev 7189)
@@ -49,7 +49,7 @@
                 if(SessionManager::getUserInfoFromSession())
                     return true;
             }
-            
+
             $comment = $params["comment"];
             $status = COMMENT_STATUS_UNMODERATED;
             
@@ -80,7 +80,7 @@
                         // approved yet, conditionally mark it as spam (based on the user's preferences)
                         // The idea is that normal users won't keep commenting before seeing their
                         // comments published
-                    $query = "SELECT count(id) FROM ${dbPrefix}articles_comments WHERE ".
+                    $query = "SELECT id FROM ${dbPrefix}articles_comments WHERE ".
                         "blog_id = '".$this->blogInfo->getId()."' AND ".
                         "status = ".COMMENT_STATUS_UNMODERATED." AND ".
                         "client_ip = '$ip' LIMIT 2";



More information about the pLog-svn mailing list