[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