Some of todays action in svn-trunk: I've added two new datetime fields to the dbmail_auto_replies table called start_date and stop_date. This way activation and deactivation of auto_replies is shoot and forget. If no start_date and/or stop_date is specified in the table, default values are used in the query.
"SELECT reply_body FROM %sauto_replies " "WHERE user_idnr = %llu " "AND NOW() BETWEEN COALESCE(start_date,DATE '1900-01-01') " "AND COALESCE(stop_date, DATE '3000-01-01'", DBPFX,user_idnr); this way, rather than using default values in the table, if a user clears such a value, auto_reply behaviour should still follow the rule of least surprise. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
