summaryrefslogtreecommitdiff
path: root/plugins/virtuser_query
diff options
context:
space:
mode:
authorthomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c>2012-03-31 12:25:48 +0000
committerthomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c>2012-03-31 12:25:48 +0000
commite6d8f97bf2e0bbb4d95df0c4e030eb7ec6ef75a5 (patch)
tree4f6fdadb51cbe1a2bb3b2b06c9bcabb0429d1a84 /plugins/virtuser_query
parent868c169e2a64c1d19a9b6bbcd98f268808dfd173 (diff)
Move plugins repository into roundcubemail root folder; svn:externals are not defined anymore
git-svn-id: https://svn.roundcube.net/trunk@6034 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'plugins/virtuser_query')
-rw-r--r--plugins/virtuser_query/package.xml47
-rw-r--r--plugins/virtuser_query/virtuser_query.php117
2 files changed, 0 insertions, 164 deletions
diff --git a/plugins/virtuser_query/package.xml b/plugins/virtuser_query/package.xml
deleted file mode 100644
index 58f697019..000000000
--- a/plugins/virtuser_query/package.xml
+++ /dev/null
@@ -1,47 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<package xmlns="http://pear.php.net/dtd/package-2.0" xmlns:tasks="http://pear.php.net/dtd/tasks-1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" packagerversion="1.9.0" version="2.0" xsi:schemaLocation="http://pear.php.net/dtd/tasks-1.0
- http://pear.php.net/dtd/tasks-1.0.xsd
- http://pear.php.net/dtd/package-2.0
- http://pear.php.net/dtd/package-2.0.xsd">
- <name>virtuser_query</name>
- <channel>pear.roundcube.net</channel>
- <summary>SQL based User-to-Email and Email-to-User lookup</summary>
- <description>Plugin adds possibility to resolve user email/login according to lookup tables in SQL database.</description>
- <lead>
- <name>Aleksander Machniak</name>
- <user>alec</user>
- <email>alec@alec.pl</email>
- <active>yes</active>
- </lead>
- <date>2011-11-21</date>
- <version>
- <release>1.1</release>
- <api>1.1</api>
- </version>
- <stability>
- <release>stable</release>
- <api>stable</api>
- </stability>
- <license uri="http://www.gnu.org/licenses/gpl-2.0.html">GNU GPLv2</license>
- <notes>-</notes>
- <contents>
- <dir baseinstalldir="/" name="/">
- <file name="virtuser_query.php" role="php">
- <tasks:replace from="@name@" to="name" type="package-info"/>
- <tasks:replace from="@package_version@" to="version" type="package-info"/>
- </file>
- </dir>
- <!-- / -->
- </contents>
- <dependencies>
- <required>
- <php>
- <min>5.2.1</min>
- </php>
- <pearinstaller>
- <min>1.7.0</min>
- </pearinstaller>
- </required>
- </dependencies>
- <phprelease/>
-</package>
diff --git a/plugins/virtuser_query/virtuser_query.php b/plugins/virtuser_query/virtuser_query.php
deleted file mode 100644
index 21a869c57..000000000
--- a/plugins/virtuser_query/virtuser_query.php
+++ /dev/null
@@ -1,117 +0,0 @@
-<?php
-
-/**
- * DB based User-to-Email and Email-to-User lookup
- *
- * Add it to the plugins list in config/main.inc.php and set
- * SQL queries to resolve usernames, e-mail addresses and hostnames from the database
- * %u will be replaced with the current username for login.
- * %m will be replaced with the current e-mail address for login.
- *
- * Queries should select the user's e-mail address, username or the imap hostname as first column
- * The email query could optionally select identity data columns in specified order:
- * name, organization, reply-to, bcc, signature, html_signature
- *
- * $rcmail_config['virtuser_query'] = array('email' => '', 'user' => '', 'host' => '');
- *
- * @version @package_version@
- * @author Aleksander Machniak
- * @author Steffen Vogel
- */
-class virtuser_query extends rcube_plugin
-{
- private $config;
- private $app;
-
- function init()
- {
- $this->app = rcmail::get_instance();
- $this->config = $this->app->config->get('virtuser_query');
-
- if (!empty($this->config)) {
- if (is_string($this->config)) {
- $this->config = array('email' => $this->config);
- }
-
- if ($this->config['email']) {
- $this->add_hook('user2email', array($this, 'user2email'));
- }
- if ($this->config['user']) {
- $this->add_hook('email2user', array($this, 'email2user'));
- }
- if ($this->config['host']) {
- $this->add_hook('authenticate', array($this, 'user2host'));
- }
- }
- }
-
- /**
- * User > Email
- */
- function user2email($p)
- {
- $dbh = $this->app->get_dbh();
-
- $sql_result = $dbh->query(preg_replace('/%u/', $dbh->escapeSimple($p['user']), $this->config['email']));
-
- while ($sql_arr = $dbh->fetch_array($sql_result)) {
- if (strpos($sql_arr[0], '@')) {
- if ($p['extended'] && count($sql_arr) > 1) {
- $result[] = array(
- 'email' => rcube_idn_to_ascii($sql_arr[0]),
- 'name' => $sql_arr[1],
- 'organization' => $sql_arr[2],
- 'reply-to' => rcube_idn_to_ascii($sql_arr[3]),
- 'bcc' => rcube_idn_to_ascii($sql_arr[4]),
- 'signature' => $sql_arr[5],
- 'html_signature' => (int)$sql_arr[6],
- );
- }
- else {
- $result[] = $sql_arr[0];
- }
-
- if ($p['first'])
- break;
- }
- }
-
- $p['email'] = $result;
-
- return $p;
- }
-
- /**
- * EMail > User
- */
- function email2user($p)
- {
- $dbh = $this->app->get_dbh();
-
- $sql_result = $dbh->query(preg_replace('/%m/', $dbh->escapeSimple($p['email']), $this->config['user']));
-
- if ($sql_arr = $dbh->fetch_array($sql_result)) {
- $p['user'] = $sql_arr[0];
- }
-
- return $p;
- }
-
- /**
- * User > Host
- */
- function user2host($p)
- {
- $dbh = $this->app->get_dbh();
-
- $sql_result = $dbh->query(preg_replace('/%u/', $dbh->escapeSimple($p['user']), $this->config['host']));
-
- if ($sql_arr = $dbh->fetch_array($sql_result)) {
- $p['host'] = $sql_arr[0];
- }
-
- return $p;
- }
-
-}
-