[geeklog-hg] geeklog: Added check for Stop Forum Spam before adding new IP

[geeklog-cvs at lists.geeklog.net]

changeset 9501:a3ce473861fc
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/a3ce473861fc
user: Tom <websitemaster at cogeco.net>
date: Wed Feb 19 22:13:50 2014 -0500
description:
Added check for Stop Forum Spam before adding new IP

diffstat:

 plugins/spamx/SFSbase.class.php |  13 +++++++++----
 1 files changed, 9 insertions(+), 4 deletions(-)

diffs (24 lines):

diff -r ac77ee3fe865 -r a3ce473861fc plugins/spamx/SFSbase.class.php
--- a/plugins/spamx/SFSbase.class.php	Thu Feb 20 01:45:55 2014 +0900
+++ b/plugins/spamx/SFSbase.class.php	Wed Feb 19 22:13:50 2014 -0500
@@ -109,11 +109,16 @@
             SPAMX_log ("SFS: spammer IP detected: " . $ip);
             
             // Add IP to SFS IP list... assuming sfs runs after ip check so no dups
-            $timestamp = DB_escapeString(date('Y-m-d H:i:s'));
+            // Double Check for IP address just in case
             $db_ip = DB_escapeString($ip);
-            $sql = "INSERT INTO {$_TABLES['spamx']} (name, value, regdate) 
-                    VALUES ('IP', '$db_ip', '$timestamp')";
-            DB_query($sql);
+            $result = DB_query("SELECT value FROM {$_TABLES['spamx']}
+                    WHERE name='IP' AND value='$db_ip'", 1);
+            if (DB_numRows($result) == 0) { // Not in db so add            
+                $timestamp = DB_escapeString(date('Y-m-d H:i:s'));
+                $sql = "INSERT INTO {$_TABLES['spamx']} (name, value, regdate) 
+                        VALUES ('IP', '$db_ip', '$timestamp')";
+                DB_query($sql);
+            }
         } else if ($this->_verbose) {
             SPAMX_log ("SFS: spammer IP not detected: " . $ip);
         }