Log of /contributions/modules/spam/spam.mysql
Parent Directory
| 
Revision Log
| 
Revision Graph
Revision
1.10 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Sun Apr 17 20:15:18 2005 UTC
(4 years, 7 months ago)
by
jeremy
Branch:
MAIN
CVS Tags:
DRUPAL-4-5--1-0,
DRUPAL-4-6--1-0,
HEAD
Branch point for:
DRUPAL-4-6
Changes since
1.9: +2 -2 lines
Diff to
previous 1.9
- spam.module
o updated to work with Drupal 4.6
o fixed issues with publishing/unpublishing nodes and comments
o added ability to mass-delete spam nodes and comments
o issue #17031: simplified statistics page (needs lots of work)
o issue #14382: added ability to search/modify old comments
- spam.mysql
o issue #18411: mark all primary keys NOT NULL
Revision
1.9 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Tue Feb 8 05:47:51 2005 UTC
(4 years, 9 months ago)
by
jeremy
Branch:
MAIN
Changes since
1.8: +19 -18 lines
Diff to
previous 1.8
o add "auto delete spam" option to custom filters, when enabled any new
content that matches the filter and is determined to be spam will be
automatically (and silently) deleted
- spam.mysql
o added autodelete column (to update existing install, execute:)
ALTER TABLE spam_custom ADD autodelete tinyint(1) unsigned default 0;
Revision
1.8 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Mon Oct 25 03:30:40 2004 UTC
(5 years, 1 month ago)
by
jeremy
Branch:
MAIN
Changes since
1.7: +13 -0 lines
Diff to
previous 1.7
- spam.module
o rest of feature #11991: introducing custom filters
(can define custom regex filters to blacklist/whitelist words/phrases)
- spam.mysql
o adds spam_custom table
(to upgrade, run CREATE TABLE spam_custom... section of spam.mysql)
Revision
1.7 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Sun Oct 17 16:12:55 2004 UTC
(5 years, 1 month ago)
by
jeremy
Branch:
MAIN
Changes since
1.6: +1 -0 lines
Diff to
previous 1.6
- spam.module
o feature request #11662: display spam poster's IP address
To upgrade, execute the following on your database:
ALTER TABLE spam_nodes ADD hostname varchar(128) NOT NULL default '';
- spam.mysql
o add 'hostname' column to spam_nodes table (not needed for spam_comments
because hostname is already stored in core comments table)
Revision
1.5 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Tue Oct 5 20:44:27 2004 UTC
(5 years, 1 month ago)
by
jeremy
Branch:
MAIN
Branch point for:
DRUPAL-4-4
Changes since
1.4: +13 -2 lines
Diff to
previous 1.4
- spam.module
o no longer saves hostname when detecting spam comment (redundant)
o fixed typo that prevented unpublished spam comments from being editable
o cleaned up comment filtering admin page, can update multiple comments
at a time
o added node filtering, can enable/disable per node type
o updated help to reflect recent changes
- spam.mysql
o remove redundant 'hostname' column from spam_comment table, info already
in comment table
Revision
1.4 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Thu Sep 30 02:47:35 2004 UTC
(5 years, 1 month ago)
by
jeremy
Branch:
MAIN
Changes since
1.3: +2 -1 lines
Diff to
previous 1.3
- spam.module:
o performance: only recalculate probability of tokens that have changed
o added ability to notify the admin when a spam comment is detected
o update 'last' field in spam_comments when changed
o store IP in spam_comments table when user leaves comment (to be
used for future blacklisting functionality)
o default to rebuilding probability table (if never built before)
o provide two probability calculation methods (development testing)
- spam.mysql:
o made 'token' field of spam_tokens table the PRIMARY KEY
o add 'hostname' field to spam_comments, for later use in blacklisting
VS: ----------------------------------------------------------------------
Revision
1.3 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Wed Sep 29 04:50:19 2004 UTC
(5 years, 1 month ago)
by
jeremy
Branch:
MAIN
Changes since
1.2: +10 -18 lines
Diff to
previous 1.2
- spam.module
o greatly simplified logic/optimized by combining all token tables
o added ability to auto-unpublish spam comments
o general cleanup
- spam.mysql
o combined all three tokens_* tables into one spam_tokens table
Revision
1.2 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Wed Sep 29 03:19:35 2004 UTC
(5 years, 1 month ago)
by
jeremy
Branch:
MAIN
Changes since
1.1: +7 -18 lines
Diff to
previous 1.1
- spam.module:
o reworked spam statistics logic, added additional counters/timestamps
o fixed comment regarding asort()
o in _spam_rating() switched from confusing while() loop to for() loop
o removed unused gid (group id)
- spam.mysql
o new spam_statistics table - to upgrade drop the old, add the new
o removed unused gid column from all tokens_ tables
Revision
1.1 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Sun Sep 26 22:14:15 2004 UTC
(5 years, 2 months ago)
by
jeremy
Branch:
MAIN
The spam module helps administrators to automatically deal with spam comments.
This is accomplished with a simple Bayesian filter, using statistical analysis
to determine whether or not a given comment is most likely spam.
NOTE: This module is still in an early beta state. It is believed to work,
however the algorithms used are somewhat simplistic, it is not optimized for
best performance, and the administrative interfaces are still primitive. That
said, I welcome testers, bug reports, and most of all patches.
This form allows you to request diffs between any two revisions of this file.
For each of the two "sides" of the diff,
select a symbolic revision name using the selection box, or choose
'Use Text Field' and enter a numeric revision.
