Fulltext results:
- Users.AutoresponderConditions table
- he [[users users|user]] this condition is for * datefrom - the date this condition will act from (or NULL to be any date) * dateto - the date this condition will act to (or NULL to be any date) * timefrom - the time this
- Autoresponder Commands
- the user's autoresponder settings. * **<Valid:**date spec**>** - this specifies that the autoresponder should only work during the specified dates. See below for more details The <Valid:> command supports date restrictions to indicate when the autoresponder s... in one <Valid> command, separated by commas. * Date - the date can be specified as dd/mm/yyyy or mm/d
- Status Monitor (port 5109) protocol
- gin===== Before the Status Monitor receives any updates or can issue commands it must log in using a use... C2 +OK Logged in OK (Build 2886) =====Status Updates===== Immediately that you are logged into the Status Server, VPOP3 will send status updates to you. Initially it will send a big burst of data to get you up-to-date, then it will send updates as and when they occur
- Autoresponder scripting
- * **OrigSubject** - the original subject * **Date, LongDate, ShortDate, Time, TimeNoSecs** - the current date & time in different, locale-dependent, forms * **conditionname
- Autoresponder
- ties are processed first) ===Conditions=== * **Dates** - specify dates between which the autoresponder will trigger. * **Times** - specify times between which the autoresponder will trigger. * **Date/Time** - specify dates & times between which the autoresponder will trigger. * **Days of the Week** -
- Spam Filter Rules: GetRFC822Date
- ======Spam Filter Rules: GetRFC822Date====== ^Statement |GetRFC822Date | ^Version |2.2.1+ | ^Purpose |Converts an RFC 822 format date field into the number of days elapsed since 1st January 1601 | The **GetRFC822Date** statement requires a date in RFC 822 format and
- Spam Filter Rules: DBUpdate
- ======Spam Filter Rules: DBUpdate====== ^Statement |DBUpdate | ^Version |6.16+ | ^Purpose |Updates a record in the spam filter database | The **DBUpdate** statement requires a component name, key, opera
- Running database updates within a transaction
- ======Running database updates within a transaction====== This is a trick which database experts use, b... ny database query which can alter the database (UPDATE, DELETE, INSERT, DROP, CREATE, ALTER) begin a dat... on using the ''BEGIN'' command; Then, run your update query. Then, check the results. Then, either us... undo what you have just done. After doing the update query, you can also issue SELECT queries or other
- Database query to alter LAN Forwarding rules for one server to go to another
- rver host name instead) As this database query updates the database, be sure to take care doing it as y... extra bit of safety, see the [[running database updates within a transaction]] article. At a command pr... (The password is 'vpop3pass') Then, type UPDATE rules.lanforwarding SET server='<new server>' WHE... vers respectively. Don't include the <>. eg UPDATE rules.lanforwarding SET server='192.168.1.53' WHE
- Spam Filter Rules
- ten by future installations of VPOP3 and by the update procedure of the Spam Filter subscription. The *... teval|DBDeleteVal]] * [[spamrules_statement_dbupdate|DBUpdate]] * [[spamrules_statement_dbquery|DBQuery]] * [[spamrules_statement_dbqueryone|DBQueryOne]... etmd5|GetMD5]] * [[spamrules_statement_getrfc822date|GetRFC822Date]] * [[spamrules_statement_getsect
- Spam Filter Rules: DBDeleteTime
- om the spam filter database based on their last update time | The **DBDeleteTime** statement requires a... ttp://www.postgresql.org/docs/9.1/static/datatype-datetime.html#DATATYPE-INTERVAL-INPUT]] Example DBD... rds for the 'subject' component which were last updated earlier than 3 months ago. The SQL expression is created as 'updatetime <comparator> now() - <timevalue>', so the abo
- Database query to alter LAN Forwarding rules for one server to go to another
- rver host name instead) As this database query updates the database, be sure to take care doing it as y... extra bit of safety, see the [[running database updates within a transaction]] article. At a command pr... (The password is 'vpop3pass') Then, type UPDATE messages.outgoingtargets SET target='<new server>... vers respectively. Don't include the <>. eg UPDATE messages.outgoingtargets SET target='192.168.1.53
- msgaudit Database table
- ) * id - incrementing ID of msgaudit entry * datetime - the date & time the event occurred * component - which VPOP3 component performed the event * ... ge subject * sender - the message sender * msgdate - the message date Note that this logs commands sent to VPOP3's message store, NOT commands sent by th
- Calendar.Calendars table
- his is the display name of the calendar * lastupdate - this is a timestamp containing when the calendar data was last updated. Triggers on the [[Calendar]].[[calendar_events|Events]] table will automatically update this entry when an event is added/updated/deleted from this calendar * internalname - this is an inte
- Spam Filter Rules: DBInsert
- der' component, then it will not be added. (To "update or insert" see the [[spamrules_statement_dbupdate|DBUpdate]] statement.)