+-------------------------------------------+
| PostfixAdmin Aliases Plugin for RoundCube |
+-------------------------------------------+
AUTHOR
Gianluca Giacometti (php@gianlucagiacometti.it)
Stephan Blanke (stephanblanke@users.noreply.github.com)
VERSION
1.0.0
RELEASE DATE
29-09-2014
INSTALL
Requirements :
- jQuery UI.
To install this plugin, copy all files into /plugin/aliases folder and
add it to the plugin array in config/config.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['aliases_driver'] = 'sql';
so far only sql is available
$rcmail_config['aliases_sql_dsn'] = value;
example value: 'pgsql://username:password@host/database'
example value: 'mysql://username:password@host/database'
$rcmail_config['aliases_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['aliases_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['aliases_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['aliases_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['aliases_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['aliases_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)'
$rcmail_config['aliases_sql_toggle'] = query;
query used to toggle the activation status
the query depends upon your postfixadmin database structure
placeholders %goto and %address must be kept unchanged
default query: 'UPDATE alias SET active = NOT active WHERE goto = %goto AND address = %address';
example query: 'UPDATE aliases SET active = NOT active WHERE goto = %goto AND address = %address';
LICENCE
Licensed under GNU GPL2 licence.
NOTE
The code is based on SieveRules plugin (sieverules) by Philip Weir.
Thank you Philip.
The javascript was fixed by Jakub Matas.
Thank you Jakub.