Version: 1.00, by filburt1
Developer Last Online: May 2007
Version: Unknown
Rating:
Released: 03-07-2003
Last Update: Never
Installs: 2
No support by the author.
Author: filburt1 Description: a powerful, admin CP-integrated set of options to automatically perform actions on users and posts who appear to be flooding your forums with spam. This is a relatively complicated mod to install so read the instructions. Requires PAPI 1.0.8. Screenshot: attached for admin CP, n/a for actual usage
Read This!
The number of queries that this mod uses is dynamic but execute on every page. If you are not in the Registered usergroup or have turned off the spambot protection, it uses none. If you only monitor spam threads or replies, it uses one query; if you monitor for both, it's two queries.
The query for actually detecting spam is relatively server-intensive. However, if you make the threshold higher, the query gets much more intensive. Choose an intelligent value. Something along the lines of 100 could cripple your server because the query would have to search the entire huge post table before quitting.
So, if you have a large board, configure with intelligence!
This better work for everybody, that's all I can say *yawn* I do expect people to report bugs to the complexity of the mod so I'll be ready for them...tomorrow.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
I installed everything and everything is working fine, except for when I try to do things with the users I registered. For some reason, everytime I try to post with that user I get a database error and I got it occassionally with trying to log-in. The interesting thing is I can do everything just fine with the admin account, including posting, logging back in, etc. So I assume it must be something with the database modifications.
It's just giving me the generic "There has been an error in the Senate Sim database." It doesn't give me the report like where it's coming from or anything.
This is the one I am getting when trying to log in. It appears, it does have something to do with the hack because it denotes 6 which is the number of posts I set in the Board Options.
Quote:
<html><head><title>Senate Sim Version 3.0 Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>
<!-- Database error in vBulletin 2.3.0:
Invalid SQL: SELECT
IF(COUNT(threadid) >= 6, 6, COUNT(threadid)
FROM thread WHERE postuserid = 12
AND dateline > UNIX_TIMESTAMP() - 30
mysql error: You have an error in your SQL syntax near 'FROM thread WHERE postuserid = 12
AND dateline > UNIX_TIMESTAMP() - 30' at line 3
</table></td></tr></table></form>
<blockquote><p> </p><p><b>There seems to have been a slight problem with the Senate Sim Version 3.0 database.</b><br>
Please try again by pressing the <a href="javascript:window.location=window.location;" >refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:support@senatesim.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>
<html><head><title>Senate Sim Version 3.0 Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>
<!-- Database error in vBulletin 2.3.0:
Invalid SQL: SELECT
IF(COUNT(threadid) >= 6, 6, COUNT(threadid)
FROM thread WHERE postuserid = 12
AND dateline > UNIX_TIMESTAMP() - 30
mysql error: You have an error in your SQL syntax near 'FROM thread WHERE postuserid = 12
AND dateline > UNIX_TIMESTAMP() - 30' at line 3
</table></td></tr></table></form>
<blockquote><p> </p><p><b>There seems to have been a slight problem with the Senate Sim Version 3.0 database.</b><br>
Please try again by pressing the <a href="javascript:window.location=window.location;" >refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:support@senatesim.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>