> > Just a follow-up to my own brain-lapse:
> >
> > If you define a custom user scores query like this:
> >
> > user_scores_sql_custom_query SELECT preference, value FROM
> > spamassassin_settings WHERE username = _USERNAME_ OR username = '!GLOBAL'
> OR
> > username = CONCAT('@', _DOMAIN_) ORDER BY username ASC
> >
> > Then you can easily decide to use bayes on a per-domain basis for one or
> more
> > of your domains (and still have per-user bayes for all other domains). A
> > sample insert row into the settings table, then, would be:
> >
> > INSERT INTO spamassassin_settings (username, preference, value) VALUES
> > ('@example.com', 'bayes_sql_override_username', 'example.com');
> >
> > So everyone in the example.com domain shares all bayes information which
> is
> > placed under the username "example.com".
>
> is that in the FAQ? because it certainly sounds like a cool tip for
> Bayes/SQL users.
I don't think so. One other thing to note about this setup is:
I think I caught the idea of using !GLOBAL from someone's how-to a while back
(IIRC, the manual suggests @GLOBAL), this way the global settings can be
ordered in the query to always override any per-domain settings.
> (there should really be a section of the FAQ dedicated to that stuff.)
Would be nice.
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
