New BETA version based on SVN version 2090
Attached is a beta version of the SpamAssassin MySQL patch built against SVN version 2090.
This version includes a new config option to set the step size by which the spam score options are incremented.
This version also includes a synchronisation function to copy any inserts, updates or deletes from the Roundcube address book to the SpamAssassin whitelist.
NOTE: The synchronisation function requires your SpamAssassin prefs table includes a field in which the contact_id from the Roundcube address book can be stored, the default value for this field (used for any address not in the address book should be -1). For example:
ALTER TABLE `userpref` ADD `contact_id` INT NOT NULL DEFAULT '-1';
The sync will only work for addresses entered into your address book while the code is active, it will not add anything that is already in your address book. You have to do this yourself.
I have only just finished this code and its kinda late here so there could be a few bugs which is why I have called it beta, please report any any issues to this thread and I will try and fix them.
*FIXED a bug with data typing that sometimes stopped the correct spam score from being selected on page load, updated patch attached.
*UPDATE added the ability to configure the order of the fieldsets in the UI and also added a bit of text to tell users when whitlist/addressbook sync is enabled. New file attached sauserprefs.beta2.r2099.patch includes these changes, built against SVN 2099 and will work with 2101.
**UPDATE 20090102**
I have added a new version of the patch, sauserprefs.BETA.0_2.patch. This version works with the 0.2 stable release of RoundCube. I have also made a number of improvements to the script.
NOTE: the config variable to change the order of the fieldsets added in the last version of this patch has been remove, the order of the field sets is now controlled in the template file (skins/default/templates/sauserprefs.html)
**UPDATE 20090108**
sauserprefs.0_2stable.patch - works with the download from the RC site
sauserprefs.r2198.patch - works with the SVN version