Extended virtuser_query plugin

[steffenvogel]

Hi,
I've made a patch to the virtuser_query plugin.
It implements now the 'email2user' hook too.
So you can login by entering your username or your email address.

I've also added the 'authenticate' hook to the plugin. So you do not have to select the imap server manually.

I'm new to roundcube hacking. It would be nice to find someone who will commit my patch to the trunk repo. Thank you :)

[steffenvogel]

Postfix configuration

[steffenvogel]

Roundcube configuration

[steffenvogel]

Database scheme for mySQL

[steffenvogel]

new plugin

[steffenvogel]

my patch

[Napsty]

Hi. Sorry to break the enthusiasm but I just tested your virtuser_query.php and it doesn't work. My virtuser_query in main.inc.php is the following:

$rcmail_config['virtuser_query'] = 'SELECT concat( prefix, "@", domain ) AS address FROM confixx.email, confixx.email_forward WHERE ident = email_ident AND pop3 = "%u" AND prefix <> "*";';

At the first login with your version I don't have any e-mail addresses. With the original one it works.

[alec]

Fixed and applied in r4018/svn.