+------------------------------------------+
| PostfixAdmin Aliases Plugin for RoudCube |
+------------------------------------------+



AUTHOR

Gianluca Giacometti ([email protected])



VERSION

0.7.2



RELEASE DATE

11-03-2012



INSTALL

Requirements :
- jQuery UI.

To install this plugin, copy all files into /plugin/aliases folder and
add it to the plugin array in config/main.inc.php :

// List of active plugins (in plugins/ directory)
$rcmail_config['plugins'] = array('aliases');



CONFIGURATION

Copy 'config.inc.php.dist' to 'config.inc.php'.
Edit the plugin configuration file 'config.inc.php' and choose the
appropriate options:

$rcmail_config['alias_driver'] = 'sql';
    so far only sql is available

$rcmail_config['alias_sql_dsn'] = value;
    example value: 'pgsql://username:password@host/database'
    example value: 'mysql://username:password@host/database'

$rcmail_config['alias_sql_aliases'] = query;
    query used to select all mailbox aliases
    default mailbox alias to itself is excluded and managed by forward plugin
    the query depends upon your postfixadmin database structure
    placeholders %goto and %address must be kept unchanged
    default query: 'SELECT * FROM alias WHERE goto = %goto AND address != %goto ORDER BY address'
    example query: 'SELECT * FROM aliases WHERE forwardto = %goto AND address != %goto ORDER BY address'

$rcmail_config['alias_sql_allaliases'] = query;
    query used to select all domain aliases but user's
    need to avoid alias duplicates in the domain
    the query depends upon your postfixadmin database structure
    placeholders %domain, %goto and %address must be kept unchanged
    default query: 'SELECT * FROM alias WHERE domain = %domain AND goto != %goto ORDER BY address'
    example query: 'SELECT * FROM aliases WHERE domain = %domain AND forwardto != %goto ORDER BY address'

$rcmail_config['alias_sql_read'] = query;
    query used to select an alias
    the query depends upon your postfixadmin database structure
    placeholders $goto and %address must be kept unchanged
    default query: 'SELECT * FROM alias WHERE goto = %goto AND address = %address'
    example query: 'SELECT * FROM aliases WHERE forwardto = %goto AND address = %address'

$rcmail_config['alias_sql_update'] = query;
    query used to update an alias
    the query depends upon your postfixadmin database structure
    placeholders %newalias, %goto and %address must be kept unchanged
    default query: 'UPDATE alias SET address = %newalias, modified = %modified WHERE goto = %goto AND address = %address'
    example query: 'UPDATE aliases SET address = %newalias WHERE forwardto = %goto AND address = %address'

$rcmail_config['alias_sql_delete'] = query;
    query used to delete an alias
    the query depends upon your postfixadmin database structure
    placeholders %goto and %address must be kept unchanged
    default query: 'DELETE FROM alias WHERE address = %address AND goto = %goto'
    example query: 'DELETE FROM aliases WHERE address = %address AND forwardto = %goto'

$rcmail_config['alias_sql_create'] = query;
    query used to create a new an alias
    the query depends upon your postfixadmin database structure
    placeholders %goto, %address, %domain, %created, %modified and %active must be kept unchanged
    default query: 'INSERT INTO alias (address, goto, domain, created, modified, active) VALUES (%address, %goto, %domain, %created, %modified, %active)'
    example query: 'INSERT INTO aliases (address, forwardto, domain, created, updated, active) VALUES (%address, %goto, %domain, %created, %modified, %active)'



LICENCE

Licensed under GNU GPL2 licence.



NOTE

The code is based on SieveRules plugin (sieverules) by Philip Weir.
Thank you Philip.