about summary refs log tree commit diff stats
path: root/wiki/lib/plugins/authpgsql
diff options
context:
space:
mode:
Diffstat (limited to 'wiki/lib/plugins/authpgsql')
-rw-r--r--wiki/lib/plugins/authpgsql/auth.php431
-rw-r--r--wiki/lib/plugins/authpgsql/conf/default.php33
-rw-r--r--wiki/lib/plugins/authpgsql/conf/metadata.php33
-rw-r--r--wiki/lib/plugins/authpgsql/lang/bg/settings.php13
-rw-r--r--wiki/lib/plugins/authpgsql/lang/cs/settings.php39
-rw-r--r--wiki/lib/plugins/authpgsql/lang/cy/settings.php33
-rw-r--r--wiki/lib/plugins/authpgsql/lang/da/settings.php22
-rw-r--r--wiki/lib/plugins/authpgsql/lang/de-informal/settings.php39
-rw-r--r--wiki/lib/plugins/authpgsql/lang/de/settings.php39
-rw-r--r--wiki/lib/plugins/authpgsql/lang/en/settings.php33
-rw-r--r--wiki/lib/plugins/authpgsql/lang/eo/settings.php37
-rw-r--r--wiki/lib/plugins/authpgsql/lang/es/settings.php41
-rw-r--r--wiki/lib/plugins/authpgsql/lang/fa/settings.php40
-rw-r--r--wiki/lib/plugins/authpgsql/lang/fr/settings.php38
-rw-r--r--wiki/lib/plugins/authpgsql/lang/hr/settings.php38
-rw-r--r--wiki/lib/plugins/authpgsql/lang/hu/settings.php39
-rw-r--r--wiki/lib/plugins/authpgsql/lang/it/settings.php40
-rw-r--r--wiki/lib/plugins/authpgsql/lang/ja/settings.php38
-rw-r--r--wiki/lib/plugins/authpgsql/lang/ko/settings.php39
-rw-r--r--wiki/lib/plugins/authpgsql/lang/lv/settings.php9
-rw-r--r--wiki/lib/plugins/authpgsql/lang/nl/settings.php38
-rw-r--r--wiki/lib/plugins/authpgsql/lang/no/settings.php38
-rw-r--r--wiki/lib/plugins/authpgsql/lang/pl/settings.php40
-rw-r--r--wiki/lib/plugins/authpgsql/lang/pt-br/settings.php39
-rw-r--r--wiki/lib/plugins/authpgsql/lang/pt/settings.php39
-rw-r--r--wiki/lib/plugins/authpgsql/lang/ru/settings.php42
-rw-r--r--wiki/lib/plugins/authpgsql/lang/sk/settings.php38
-rw-r--r--wiki/lib/plugins/authpgsql/lang/sl/settings.php16
-rw-r--r--wiki/lib/plugins/authpgsql/lang/sr/settings.php18
-rw-r--r--wiki/lib/plugins/authpgsql/lang/sv/settings.php29
-rw-r--r--wiki/lib/plugins/authpgsql/lang/tr/settings.php13
-rw-r--r--wiki/lib/plugins/authpgsql/lang/uk/settings.php8
-rw-r--r--wiki/lib/plugins/authpgsql/lang/zh-tw/settings.php38
-rw-r--r--wiki/lib/plugins/authpgsql/lang/zh/settings.php38
-rw-r--r--wiki/lib/plugins/authpgsql/plugin.info.txt7
35 files changed, 1515 insertions, 0 deletions
diff --git a/wiki/lib/plugins/authpgsql/auth.php b/wiki/lib/plugins/authpgsql/auth.php
new file mode 100644
index 0000000..7b677d3
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/auth.php
@@ -0,0 +1,431 @@
+<?php
+// must be run within Dokuwiki
+if(!defined('DOKU_INC')) die();
+
+/**
+ * PostgreSQL authentication backend
+ *
+ * This class inherits much functionality from the MySQL class
+ * and just reimplements the Postgres specific parts.
+ *
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ * @author     Andreas Gohr <andi@splitbrain.org>
+ * @author     Chris Smith <chris@jalakai.co.uk>
+ * @author     Matthias Grimm <matthias.grimmm@sourceforge.net>
+ * @author     Jan Schumann <js@schumann-it.com>
+ */
+class auth_plugin_authpgsql extends auth_plugin_authmysql {
+
+    /**
+     * Constructor
+     *
+     * checks if the pgsql interface is available, otherwise it will
+     * set the variable $success of the basis class to false
+     *
+     * @author Matthias Grimm <matthiasgrimm@users.sourceforge.net>
+     * @author Andreas Gohr <andi@splitbrain.org>
+     */
+    public function __construct() {
+        // we don't want the stuff the MySQL constructor does, but the grandparent might do something
+        DokuWiki_Auth_Plugin::__construct();
+
+        if(!function_exists('pg_connect')) {
+            $this->_debug("PgSQL err: PHP Postgres extension not found.", -1, __LINE__, __FILE__);
+            $this->success = false;
+            return;
+        }
+
+        $this->loadConfig();
+
+        // set capabilities based upon config strings set
+        if(empty($this->conf['user']) ||
+            empty($this->conf['password']) || empty($this->conf['database'])
+        ) {
+            $this->_debug("PgSQL err: insufficient configuration.", -1, __LINE__, __FILE__);
+            $this->success = false;
+            return;
+        }
+
+        $this->cando['addUser']   = $this->_chkcnf(
+            array(
+                 'getUserInfo',
+                 'getGroups',
+                 'addUser',
+                 'getUserID',
+                 'getGroupID',
+                 'addGroup',
+                 'addUserGroup'
+            )
+        );
+        $this->cando['delUser']   = $this->_chkcnf(
+            array(
+                 'getUserID',
+                 'delUser',
+                 'delUserRefs'
+            )
+        );
+        $this->cando['modLogin']  = $this->_chkcnf(
+            array(
+                 'getUserID',
+                 'updateUser',
+                 'UpdateTarget'
+            )
+        );
+        $this->cando['modPass']   = $this->cando['modLogin'];
+        $this->cando['modName']   = $this->cando['modLogin'];
+        $this->cando['modMail']   = $this->cando['modLogin'];
+        $this->cando['modGroups'] = $this->_chkcnf(
+            array(
+                 'getUserID',
+                 'getGroups',
+                 'getGroupID',
+                 'addGroup',
+                 'addUserGroup',
+                 'delGroup',
+                 'getGroupID',
+                 'delUserGroup'
+            )
+        );
+        /* getGroups is not yet supported
+           $this->cando['getGroups']    = $this->_chkcnf(array('getGroups',
+           'getGroupID')); */
+        $this->cando['getUsers']     = $this->_chkcnf(
+            array(
+                 'getUsers',
+                 'getUserInfo',
+                 'getGroups'
+            )
+        );
+        $this->cando['getUserCount'] = $this->_chkcnf(array('getUsers'));
+    }
+
+    /**
+     * Check if the given config strings are set
+     *
+     * @author  Matthias Grimm <matthiasgrimm@users.sourceforge.net>
+     *
+     * @param   string[] $keys
+     * @param   bool  $wop
+     * @return  bool
+     */
+    protected function _chkcnf($keys, $wop = false) {
+        foreach($keys as $key) {
+            if(empty($this->conf[$key])) return false;
+        }
+        return true;
+    }
+
+    /**
+     * Counts users which meet certain $filter criteria.
+     *
+     * @author  Matthias Grimm <matthiasgrimm@users.sourceforge.net>
+     *
+     * @param  array  $filter  filter criteria in item/pattern pairs
+     * @return int count of found users.
+     */
+    public function getUserCount($filter = array()) {
+        $rc = 0;
+
+        if($this->_openDB()) {
+            $sql = $this->_createSQLFilter($this->conf['getUsers'], $filter);
+
+            // no equivalent of SQL_CALC_FOUND_ROWS in pgsql?
+            if(($result = $this->_queryDB($sql))) {
+                $rc = count($result);
+            }
+            $this->_closeDB();
+        }
+        return $rc;
+    }
+
+    /**
+     * Bulk retrieval of user data
+     *
+     * @author  Matthias Grimm <matthiasgrimm@users.sourceforge.net>
+     *
+     * @param   int   $first     index of first user to be returned
+     * @param   int   $limit     max number of users to be returned
+     * @param   array $filter    array of field/pattern pairs
+     * @return  array userinfo (refer getUserData for internal userinfo details)
+     */
+    public function retrieveUsers($first = 0, $limit = 0, $filter = array()) {
+        $out = array();
+
+        if($this->_openDB()) {
+            $this->_lockTables("READ");
+            $sql = $this->_createSQLFilter($this->conf['getUsers'], $filter);
+            $sql .= " ".$this->conf['SortOrder'];
+            if($limit) $sql .= " LIMIT $limit";
+            if($first) $sql .= " OFFSET $first";
+            $result = $this->_queryDB($sql);
+
+            foreach($result as $user) {
+                if(($info = $this->_getUserInfo($user['user']))) {
+                    $out[$user['user']] = $info;
+                }
+            }
+
+            $this->_unlockTables();
+            $this->_closeDB();
+        }
+        return $out;
+    }
+
+    // @inherit function joinGroup($user, $group)
+    // @inherit function leaveGroup($user, $group) {
+
+    /**
+     * Adds a user to a group.
+     *
+     * If $force is set to true non existing groups would be created.
+     *
+     * The database connection must already be established. Otherwise
+     * this function does nothing and returns 'false'.
+     *
+     * @author Matthias Grimm <matthiasgrimm@users.sourceforge.net>
+     * @author Andreas Gohr   <andi@splitbrain.org>
+     *
+     * @param   string $user    user to add to a group
+     * @param   string $group   name of the group
+     * @param   bool   $force   create missing groups
+     * @return  bool   true on success, false on error
+     */
+    protected function _addUserToGroup($user, $group, $force = false) {
+        $newgroup = 0;
+
+        if(($this->dbcon) && ($user)) {
+            $gid = $this->_getGroupID($group);
+            if(!$gid) {
+                if($force) { // create missing groups
+                    $sql = str_replace('%{group}', addslashes($group), $this->conf['addGroup']);
+                    $this->_modifyDB($sql);
+                    //group should now exists try again to fetch it
+                    $gid      = $this->_getGroupID($group);
+                    $newgroup = 1; // group newly created
+                }
+            }
+            if(!$gid) return false; // group didn't exist and can't be created
+
+            $sql = $this->conf['addUserGroup'];
+            if(strpos($sql, '%{uid}') !== false) {
+                $uid = $this->_getUserID($user);
+                $sql = str_replace('%{uid}', addslashes($uid), $sql);
+            }
+            $sql = str_replace('%{user}', addslashes($user), $sql);
+            $sql = str_replace('%{gid}', addslashes($gid), $sql);
+            $sql = str_replace('%{group}', addslashes($group), $sql);
+            if($this->_modifyDB($sql) !== false) {
+                $this->_flushUserInfoCache($user);
+                return true;
+            }
+
+            if($newgroup) { // remove previously created group on error
+                $sql = str_replace('%{gid}', addslashes($gid), $this->conf['delGroup']);
+                $sql = str_replace('%{group}', addslashes($group), $sql);
+                $this->_modifyDB($sql);
+            }
+        }
+        return false;
+    }
+
+    // @inherit function _delUserFromGroup($user $group)
+    // @inherit function _getGroups($user)
+    // @inherit function _getUserID($user)
+
+    /**
+     * Adds a new User to the database.
+     *
+     * The database connection must already be established
+     * for this function to work. Otherwise it will return
+     * 'false'.
+     *
+     * @param  string $user  login of the user
+     * @param  string $pwd   encrypted password
+     * @param  string $name  full name of the user
+     * @param  string $mail  email address
+     * @param  array  $grps  array of groups the user should become member of
+     * @return bool
+     *
+     * @author  Andreas Gohr <andi@splitbrain.org>
+     * @author  Chris Smith <chris@jalakai.co.uk>
+     * @author  Matthias Grimm <matthiasgrimm@users.sourceforge.net>
+     */
+    protected function _addUser($user, $pwd, $name, $mail, $grps) {
+        if($this->dbcon && is_array($grps)) {
+            $sql = str_replace('%{user}', addslashes($user), $this->conf['addUser']);
+            $sql = str_replace('%{pass}', addslashes($pwd), $sql);
+            $sql = str_replace('%{name}', addslashes($name), $sql);
+            $sql = str_replace('%{email}', addslashes($mail), $sql);
+            if($this->_modifyDB($sql)) {
+                $uid = $this->_getUserID($user);
+            } else {
+                return false;
+            }
+
+            $group = '';
+            $gid = false;
+
+            if($uid) {
+                foreach($grps as $group) {
+                    $gid = $this->_addUserToGroup($user, $group, true);
+                    if($gid === false) break;
+                }
+
+                if($gid !== false){
+                    $this->_flushUserInfoCache($user);
+                    return true;
+                } else {
+                    /* remove the new user and all group relations if a group can't
+                     * be assigned. Newly created groups will remain in the database
+                     * and won't be removed. This might create orphaned groups but
+                     * is not a big issue so we ignore this problem here.
+                     */
+                    $this->_delUser($user);
+                    $this->_debug("PgSQL err: Adding user '$user' to group '$group' failed.", -1, __LINE__, __FILE__);
+                }
+            }
+        }
+        return false;
+    }
+
+    /**
+     * Opens a connection to a database and saves the handle for further
+     * usage in the object. The successful call to this functions is
+     * essential for most functions in this object.
+     *
+     * @author Matthias Grimm <matthiasgrimm@users.sourceforge.net>
+     *
+     * @return bool
+     */
+    protected function _openDB() {
+        if(!$this->dbcon) {
+            $dsn = $this->conf['server'] ? 'host='.$this->conf['server'] : '';
+            $dsn .= ' port='.$this->conf['port'];
+            $dsn .= ' dbname='.$this->conf['database'];
+            $dsn .= ' user='.$this->conf['user'];
+            $dsn .= ' password='.conf_decodeString($this->conf['password']);
+
+            $con = @pg_connect($dsn);
+            if($con) {
+                $this->dbcon = $con;
+                return true; // connection and database successfully opened
+            } else {
+                $this->_debug(
+                        "PgSQL err: Connection to {$this->conf['user']}@{$this->conf['server']} not possible.",
+                        -1, __LINE__, __FILE__
+                    );
+            }
+            return false; // connection failed
+        }
+        return true; // connection already open
+    }
+
+    /**
+     * Closes a database connection.
+     *
+     * @author Matthias Grimm <matthiasgrimm@users.sourceforge.net>
+     */
+    protected function _closeDB() {
+        if($this->dbcon) {
+            pg_close($this->dbcon);
+            $this->dbcon = 0;
+        }
+    }
+
+    /**
+     * Sends a SQL query to the database and transforms the result into
+     * an associative array.
+     *
+     * This function is only able to handle queries that returns a
+     * table such as SELECT.
+     *
+     * @author Matthias Grimm <matthiasgrimm@users.sourceforge.net>
+     *
+     * @param  string $query  SQL string that contains the query
+     * @return array|false the result table
+     */
+    protected function _queryDB($query) {
+        $resultarray = array();
+        if($this->dbcon) {
+            $result = @pg_query($this->dbcon, $query);
+            if($result) {
+                while(($t = pg_fetch_assoc($result)) !== false)
+                    $resultarray[] = $t;
+                pg_free_result($result);
+                return $resultarray;
+            } else{
+                $this->_debug('PgSQL err: '.pg_last_error($this->dbcon), -1, __LINE__, __FILE__);
+            }
+        }
+        return false;
+    }
+
+    /**
+     * Executes an update or insert query. This differs from the
+     * MySQL one because it does NOT return the last insertID
+     *
+     * @author Andreas Gohr <andi@splitbrain.org>
+     *
+     * @param string $query
+     * @return bool
+     */
+    protected function _modifyDB($query) {
+        if($this->dbcon) {
+            $result = @pg_query($this->dbcon, $query);
+            if($result) {
+                pg_free_result($result);
+                return true;
+            }
+            $this->_debug('PgSQL err: '.pg_last_error($this->dbcon), -1, __LINE__, __FILE__);
+        }
+        return false;
+    }
+
+    /**
+     * Start a transaction
+     *
+     * @author Matthias Grimm <matthiasgrimm@users.sourceforge.net>
+     *
+     * @param string $mode  could be 'READ' or 'WRITE'
+     * @return bool
+     */
+    protected function _lockTables($mode) {
+        if($this->dbcon) {
+            $this->_modifyDB('BEGIN');
+            return true;
+        }
+        return false;
+    }
+
+    /**
+     * Commit a transaction
+     *
+     * @author Matthias Grimm <matthiasgrimm@users.sourceforge.net>
+     *
+     * @return bool
+     */
+    protected function _unlockTables() {
+        if($this->dbcon) {
+            $this->_modifyDB('COMMIT');
+            return true;
+        }
+        return false;
+    }
+
+    /**
+     * Escape a string for insertion into the database
+     *
+     * @author Andreas Gohr <andi@splitbrain.org>
+     *
+     * @param  string  $string The string to escape
+     * @param  bool    $like   Escape wildcard chars as well?
+     * @return string
+     */
+    protected function _escape($string, $like = false) {
+        $string = pg_escape_string($string);
+        if($like) {
+            $string = addcslashes($string, '%_');
+        }
+        return $string;
+    }
+}
diff --git a/wiki/lib/plugins/authpgsql/conf/default.php b/wiki/lib/plugins/authpgsql/conf/default.php
new file mode 100644
index 0000000..7f78280
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/conf/default.php
@@ -0,0 +1,33 @@
+<?php
+
+$conf['server']           = '';
+$conf['port']             = 5432;
+$conf['user']             = '';
+$conf['password']         = '';
+$conf['database']         = '';
+$conf['debug']            = 0;
+$conf['forwardClearPass'] = 0;
+$conf['checkPass']        = '';
+$conf['getUserInfo']      = '';
+$conf['getGroups']        = '';
+$conf['getUsers']         = '';
+$conf['FilterLogin']      = '';
+$conf['FilterName']       = '';
+$conf['FilterEmail']      = '';
+$conf['FilterGroup']      = '';
+$conf['SortOrder']        = '';
+$conf['addUser']          = '';
+$conf['addGroup']         = '';
+$conf['addUserGroup']     = '';
+$conf['delGroup']         = '';
+$conf['getUserID']        = '';
+$conf['delUser']          = '';
+$conf['delUserRefs']      = '';
+$conf['updateUser']       = '';
+$conf['UpdateLogin']      = '';
+$conf['UpdatePass']       = '';
+$conf['UpdateEmail']      = '';
+$conf['UpdateName']       = '';
+$conf['UpdateTarget']     = '';
+$conf['delUserGroup']     = '';
+$conf['getGroupID']       = '';
\ No newline at end of file
diff --git a/wiki/lib/plugins/authpgsql/conf/metadata.php b/wiki/lib/plugins/authpgsql/conf/metadata.php
new file mode 100644
index 0000000..cb9c456
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/conf/metadata.php
@@ -0,0 +1,33 @@
+<?php
+
+$meta['server']           = array('string','_caution' => 'danger');
+$meta['port']             = array('numeric','_caution' => 'danger');
+$meta['user']             = array('string','_caution' => 'danger');
+$meta['password']         = array('password','_caution' => 'danger','_code'=>'base64');
+$meta['database']         = array('string','_caution' => 'danger');
+$meta['debug']            = array('onoff','_caution' => 'security');
+$meta['forwardClearPass'] = array('onoff','_caution' => 'danger');
+$meta['checkPass']        = array('','_caution' => 'danger');
+$meta['getUserInfo']      = array('','_caution' => 'danger');
+$meta['getGroups']        = array('');
+$meta['getUsers']         = array('','_caution' => 'danger');
+$meta['FilterLogin']      = array('string','_caution' => 'danger');
+$meta['FilterName']       = array('string','_caution' => 'danger');
+$meta['FilterEmail']      = array('string','_caution' => 'danger');
+$meta['FilterGroup']      = array('string','_caution' => 'danger');
+$meta['SortOrder']        = array('string','_caution' => 'danger');
+$meta['addUser']          = array('','_caution' => 'danger');
+$meta['addGroup']         = array('','_caution' => 'danger');
+$meta['addUserGroup']     = array('','_caution' => 'danger');
+$meta['delGroup']         = array('','_caution' => 'danger');
+$meta['getUserID']        = array('','_caution' => 'danger');
+$meta['delUser']          = array('','_caution' => 'danger');
+$meta['delUserRefs']      = array('','_caution' => 'danger');
+$meta['updateUser']       = array('string','_caution' => 'danger');
+$meta['UpdateLogin']      = array('string','_caution' => 'danger');
+$meta['UpdatePass']       = array('string','_caution' => 'danger');
+$meta['UpdateEmail']      = array('string','_caution' => 'danger');
+$meta['UpdateName']       = array('string','_caution' => 'danger');
+$meta['UpdateTarget']     = array('string','_caution' => 'danger');
+$meta['delUserGroup']     = array('','_caution' => 'danger');
+$meta['getGroupID']       = array('','_caution' => 'danger');
diff --git a/wiki/lib/plugins/authpgsql/lang/bg/settings.php b/wiki/lib/plugins/authpgsql/lang/bg/settings.php
new file mode 100644
index 0000000..bd6ae1c
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/bg/settings.php
@@ -0,0 +1,13 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ * 
+ * @author Kiril <neohidra@gmail.com>
+ */
+$lang['server']                = 'Вашият PostgreSQL сървър';
+$lang['port']                  = 'Порт за PostgreSQL сървъра';
+$lang['user']                  = 'PostgreSQL потребител';
+$lang['password']              = 'Парола за горния потребител';
+$lang['database']              = 'Име на базата от данни';
+$lang['debug']                 = 'Показване на допълнителна debug информация';
diff --git a/wiki/lib/plugins/authpgsql/lang/cs/settings.php b/wiki/lib/plugins/authpgsql/lang/cs/settings.php
new file mode 100644
index 0000000..af8b837
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/cs/settings.php
@@ -0,0 +1,39 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author mkucera66 <mkucera66@seznam.cz>
+ * @author Jaroslav Lichtblau <jlichtblau@seznam.cz>
+ */
+$lang['server']                = 'Váš server PostgreSQL';
+$lang['port']                  = 'Port vašeho serveru PostgreSQL';
+$lang['user']                  = 'Uživatelské jméno pro PostgreSQL';
+$lang['password']              = 'Heslo tohoto uživatele';
+$lang['database']              = 'Použtá databáze';
+$lang['debug']                 = 'Zobrazit dodatečné debugovací informace';
+$lang['forwardClearPass']      = 'Posílat uživatelské heslo jako čistý text do příkazů SQL namísto využití volby passcrypt.';
+$lang['checkPass']             = 'Příkaz SQL pro kontrolu hesel';
+$lang['getUserInfo']           = 'Příkaz SQL pro získání informací o uživateli';
+$lang['getGroups']             = 'Příkaz SQL pro získání členství uživatele ve skupinách';
+$lang['getUsers']              = 'Příkaz SQL pro seznam všech uživatelů';
+$lang['FilterLogin']           = 'Příkaz SQL pro filtrování uživatelů podle přihlašovacího jména';
+$lang['FilterName']            = 'Příkaz SQL pro filtrování uživatelů podle celého jména';
+$lang['FilterEmail']           = 'Příkaz SQL pro filtrování uživatelů podle adres e-mailů';
+$lang['FilterGroup']           = 'Příkaz SQL pro filtrování uživatelů podle členství ve skupinách';
+$lang['SortOrder']             = 'Příkaz SQL pro řazení uživatelů';
+$lang['addUser']               = 'Příkaz SQL pro řazení uživatelů';
+$lang['addGroup']              = 'Příkaz SQL pro přidání nové skupiny';
+$lang['addUserGroup']          = 'Příkaz SQL pro přidání uživatele do existující skupiny';
+$lang['delGroup']              = 'Příkaz SQL pro vymazání skupiny';
+$lang['getUserID']             = 'Příkaz SQL pro získání primárního klíče uživatele';
+$lang['delUser']               = 'Příkaz SQL pro vymazání uživatele';
+$lang['delUserRefs']           = 'Příkaz SQL pro odstranění členství uživatele se všech skupin';
+$lang['updateUser']            = 'Příkaz SQL pro aktualizaci uživatelského profilu';
+$lang['UpdateLogin']           = 'Klauzule pro aktualizaci přihlačovacího jména uživatele';
+$lang['UpdatePass']            = 'Klauzule pro aktualizaci hesla uživatele';
+$lang['UpdateEmail']           = 'Klauzule pro aktualizaci e-mailové adresy uživatele';
+$lang['UpdateName']            = 'Klauzule pro aktualizaci celého jména uživatele';
+$lang['UpdateTarget']          = 'Omezující klauzule pro identifikaci uživatele při aktualizaci';
+$lang['delUserGroup']          = 'Příkaz SQL pro zrušení členství uživatele v dané skupině';
+$lang['getGroupID']            = 'Příkaz SQL pro získání primárního klíče skupiny';
diff --git a/wiki/lib/plugins/authpgsql/lang/cy/settings.php b/wiki/lib/plugins/authpgsql/lang/cy/settings.php
new file mode 100644
index 0000000..0c32ad7
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/cy/settings.php
@@ -0,0 +1,33 @@
+<?php
+
+$lang['server']           = 'Eich gweinydd PostgreSQL';
+$lang['port']             = 'Porth eich gweinydd PostgreSQL';
+$lang['user']             = 'Defnyddair PostgreSQL';
+$lang['password']         = 'Cyfrinair y defnyddiwr uchod';
+$lang['database']         = 'Databas i\'w ddefnyddio';
+$lang['debug']            = 'angos gwybodaeth dadfygio ychwanegol';
+$lang['forwardClearPass'] = 'Pasio cyfrineiriau defnyddwyr fel \'cleartext\' i\'r datganiadau SQL isod, yn hytrach na defnyddio\'r opsiwn \'passcrypt\'';
+$lang['checkPass']        = 'Datganiad SQL i wirio cyfrineiriau';
+$lang['getUserInfo']      = 'Datganiad SQL i nôl gwybodaeth defnyddiwr';
+$lang['getGroups']        = 'Datganiad SQL i nôl aelodaeth grŵp y defnyddiwr';
+$lang['getUsers']         = 'Datganiad SQL i restru pob defnyddiwr';
+$lang['FilterLogin']      = 'Cymal SQL i hidlo defnyddwyr gan enw mewngofnodi';
+$lang['FilterName']       = 'Cymal SQL i hidlo defnyddwyr gan enw llawn';
+$lang['FilterEmail']      = 'Cymal SQL i hidlo defnyddwyr gan gyfeiriad ebost';
+$lang['FilterGroup']      = 'Cymal SQL i hidlo defnyddwyr gan aelodaeth grŵp';
+$lang['SortOrder']        = 'Cymal SQL i drefnu defnyddwyr';
+$lang['addUser']          = 'Datganiad SQL i ychwanegu defnyddiwr newydd';
+$lang['addGroup']         = 'Datganiad SQL i ychwanegu grŵp newydd';
+$lang['addUserGroup']     = 'Datganiad SQL i ychwanegu defnyddiwr newydd i grŵp sy\'n bodoli eisoes';
+$lang['delGroup']         = 'Datganiad SQL i dynnu grŵp';
+$lang['getUserID']        = 'Datganiad SQL i nôl prif allwedd y defnyddiwr';
+$lang['delUser']          = 'Datganiad SQL i ddileu defnyddiwr';
+$lang['delUserRefs']      = 'Datganiad SQL i dynnu defnyddiwr o bob grŵp';
+$lang['updateUser']       = 'Datganiad SQL i ddiweddaru proffil defnyddiwr';
+$lang['UpdateLogin']      = 'Cymal Diweddaru i ddiweddaru enw mewngofnodi defnyddiwr';
+$lang['UpdatePass']       = 'Cymal Diweddaru i ddiweddaru cyfrinair defnyddiwr';
+$lang['UpdateEmail']      = 'Cymal Diweddaru i ddiweddaru cyfeiriad ebost defnyddiwr';
+$lang['UpdateName']       = 'Cymal Diweddaru i ddiweddaru enw llawn defnyddiwr';
+$lang['UpdateTarget']     = 'Cymal Cyfyngu i adnabod y defnyddiwr wrth ddiweddaru';
+$lang['delUserGroup']     = 'Datganiad SQL i dynnu defnyddiwr oddi ar grŵp';
+$lang['getGroupID']       = 'Datganiad SQL i nôl prif allwedd grŵp penodol';
diff --git a/wiki/lib/plugins/authpgsql/lang/da/settings.php b/wiki/lib/plugins/authpgsql/lang/da/settings.php
new file mode 100644
index 0000000..bca2bfb
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/da/settings.php
@@ -0,0 +1,22 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Jens Hyllegaard <jens.hyllegaard@gmail.com>
+ * @author soer9648 <soer9648@eucl.dk>
+ */
+$lang['server']                = 'Din PostgresSQL server';
+$lang['port']                  = 'Din PostgresSQL servers port';
+$lang['password']              = 'Kodeord til ovenstående bruger';
+$lang['database']              = 'Database der skal benyttes';
+$lang['debug']                 = 'Vis yderligere debug output';
+$lang['checkPass']             = 'SQL-sætning til at kontrollere kodeord';
+$lang['getUsers']              = 'SQL-sætning til at liste alle brugere';
+$lang['addUser']               = 'SQL-sætning til at tilføje en ny bruger';
+$lang['addGroup']              = 'SQL-sætning til at tilføje en ny gruppe';
+$lang['addUserGroup']          = 'SQL-sætning til at tilføje en bruger til en eksisterende gruppe';
+$lang['delGroup']              = 'SQL-sætning til at fjerne en gruppe';
+$lang['delUser']               = 'SQL-sætning til at slette en bruger';
+$lang['delUserRefs']           = 'SQL-sætning til at fjerne en bruger fra alle grupper';
+$lang['updateUser']            = 'SQL-sætning til at opdatere en brugerprofil';
diff --git a/wiki/lib/plugins/authpgsql/lang/de-informal/settings.php b/wiki/lib/plugins/authpgsql/lang/de-informal/settings.php
new file mode 100644
index 0000000..2547e2c
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/de-informal/settings.php
@@ -0,0 +1,39 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Matthias Schulte <dokuwiki@lupo49.de>
+ * @author Volker Bödker <volker@boedker.de>
+ */
+$lang['server']                = 'PostgreSQL-Server';
+$lang['port']                  = 'Port des PostgreSQL-Servers.';
+$lang['user']                  = 'Benutzername für den Zugriff auf den PostgreSQL-Server.';
+$lang['password']              = 'Passwort des angegebenen Benutzers.';
+$lang['database']              = 'Zu verwendende Datenbank.';
+$lang['debug']                 = 'Debug-Informationen anzeigen?';
+$lang['forwardClearPass']      = 'Passwort der DokuWiki-Benutzer im Klartext an die Datenbank übergeben? (Im Normalfall wird die passcrypt-Option angewendet.)';
+$lang['checkPass']             = 'SQL-Kommando zum Überprüfen von Passwörtern.';
+$lang['getUserInfo']           = 'SQL-Kommando um Benutzerinformationen auszulesen.';
+$lang['getGroups']             = 'SQL-Kommando um Gruppen eines Benutzers auszulesen.';
+$lang['getUsers']              = 'SQL-Kommando um alle Benutzer auszulesen.';
+$lang['FilterLogin']           = 'SQL-Bedingung um Benutzer anhand ihres Anmeldenamens zu filtern.';
+$lang['FilterName']            = 'SQL-Bedingung um Benutzer anhand ihres Namens zu filtern.';
+$lang['FilterEmail']           = 'SQL-Bedingung um Benutzer anhand ihrer E-Mail-Adresse zu filtern.';
+$lang['FilterGroup']           = 'SQL-Bedingung um Benutzer anhand ihrer Gruppenzugehörigkeit zu filtern.';
+$lang['SortOrder']             = 'SQL-Bedingung um anhand der die Benutzerliste sortiert wird.';
+$lang['addUser']               = 'SQL-Kommando um einen neuen Benutzer anzulegen.';
+$lang['addGroup']              = 'SQL-Kommando um eine neue Gruppe anzulegen.';
+$lang['addUserGroup']          = 'SQL-Kommando um einen Benutzer zu einer Gruppe hinzuzufügen.';
+$lang['delGroup']              = 'SQL-Kommando um eine Gruppe zu löschen.';
+$lang['getUserID']             = 'SQL-Kommando um den Primärschlüssel des Benutzers auszulesen.';
+$lang['delUser']               = 'SQL-Kommando um einen Benutzer zu löschen.';
+$lang['delUserRefs']           = 'SQL-Kommando um einen Benutzer aus allen Gruppen zu entfernen.';
+$lang['updateUser']            = 'SQL-Kommando um das Profil eines Benutzers zu aktualisieren.';
+$lang['UpdateLogin']           = 'SQL-Bedingung um den Anmeldenamen eines Benutzers zu ändern.';
+$lang['UpdatePass']            = 'SQL-Bedingung um das Passwort eines Benutzers zu ändern.';
+$lang['UpdateEmail']           = 'SQL-Bedingung um die E-Mail-Adresse eines Benutzers zu ändern.';
+$lang['UpdateName']            = 'SQL-Bedingung um den Namen eines Benutzers zu ändern.';
+$lang['UpdateTarget']          = 'SQL-Bedingung zur eindeutigen Identifikation des Benutzers.';
+$lang['delUserGroup']          = 'SQL-Kommando um einen Benutzer aus einer angegeben Gruppe zu entfernen.';
+$lang['getGroupID']            = 'SQL-Kommando um den Primärschlüssel einer Gruppe auszulesen.';
diff --git a/wiki/lib/plugins/authpgsql/lang/de/settings.php b/wiki/lib/plugins/authpgsql/lang/de/settings.php
new file mode 100644
index 0000000..6a18811
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/de/settings.php
@@ -0,0 +1,39 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Matthias Schulte <dokuwiki@lupo49.de>
+ * @author Hella Breitkopf <hella.breitkopf@gmail.com>
+ */
+$lang['server']                = 'PostgreSQL-Server';
+$lang['port']                  = 'Port des PostgreSQL-Servers.';
+$lang['user']                  = 'Benutzername für den Zugriff auf den PostgreSQL-Server.';
+$lang['password']              = 'Passwort des angegebenen Benutzers.';
+$lang['database']              = 'Zu verwendende Datenbank.';
+$lang['debug']                 = 'Debug-Informationen anzeigen?';
+$lang['forwardClearPass']      = 'Passwort der DokuWiki-Benutzer im Klartext an die Datenbank übergeben? (Im Normalfall wird die passcrypt-Option angewendet.)';
+$lang['checkPass']             = 'SQL-Kommando zum Überprüfen von Passwörtern.';
+$lang['getUserInfo']           = 'SQL-Kommando um Benutzerinformationen auszulesen.';
+$lang['getGroups']             = 'SQL-Kommando um Gruppen eines Benutzers auszulesen.';
+$lang['getUsers']              = 'SQL-Kommando um alle Benutzer auszulesen.';
+$lang['FilterLogin']           = 'SQL-Bedingung um Benutzer anhand ihres Anmeldenamens zu filtern.';
+$lang['FilterName']            = 'SQL-Bedingung um Benutzer anhand ihres Namens zu filtern.';
+$lang['FilterEmail']           = 'SQL-Bedingung um Benutzer anhand ihrer E-Mail-Adresse zu filtern.';
+$lang['FilterGroup']           = 'SQL-Bedingung um Benutzer anhand ihrer Gruppenzugehörigkeit zu filtern.';
+$lang['SortOrder']             = 'SQL-Bedingung um anhand der die Benutzerliste sortiert wird.';
+$lang['addUser']               = 'SQL-Kommando um einen neuen Benutzer anzulegen.';
+$lang['addGroup']              = 'SQL-Kommando um eine neue Gruppe anzulegen.';
+$lang['addUserGroup']          = 'SQL-Kommando um einen Benutzer zu einer Gruppe hinzuzufügen.';
+$lang['delGroup']              = 'SQL-Kommando um eine Gruppe zu löschen.';
+$lang['getUserID']             = 'SQL-Kommando um den Primärschlüssel des Benutzers auszulesen.';
+$lang['delUser']               = 'SQL-Kommando um einen Benutzer zu löschen.';
+$lang['delUserRefs']           = 'SQL-Kommando um einen Benutzer aus allen Gruppen zu entfernen.';
+$lang['updateUser']            = 'SQL-Kommando um das Profil eines Benutzers zu aktualisieren.';
+$lang['UpdateLogin']           = 'SQL-Bedingung um den Anmeldenamen eines Benutzers zu ändern.';
+$lang['UpdatePass']            = 'SQL-Befehl um das Passwort eines Benutzers zu ändern.';
+$lang['UpdateEmail']           = 'SQL-Befehl um die E-Mail-Adresse eines Benutzers zu ändern.';
+$lang['UpdateName']            = 'SQL-Befehl um den Namen eines Benutzers zu ändern.';
+$lang['UpdateTarget']          = 'SQL-Filter zur eindeutigen Identifikation des Benutzers.';
+$lang['delUserGroup']          = 'SQL-Kommando um einen Benutzer aus einer angegeben Gruppe zu entfernen.';
+$lang['getGroupID']            = 'SQL-Kommando um den Primärschlüssel einer Gruppe auszulesen.';
diff --git a/wiki/lib/plugins/authpgsql/lang/en/settings.php b/wiki/lib/plugins/authpgsql/lang/en/settings.php
new file mode 100644
index 0000000..cfb2686
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/en/settings.php
@@ -0,0 +1,33 @@
+<?php
+
+$lang['server']           = 'Your PostgreSQL server';
+$lang['port']             = 'Your PostgreSQL server\'s port';
+$lang['user']             = 'PostgreSQL user name';
+$lang['password']         = 'Password for above user';
+$lang['database']         = 'Database to use';
+$lang['debug']            = 'Display additional debug information';
+$lang['forwardClearPass'] = 'Pass user passwords as cleartext to the SQL statements below, instead of using the passcrypt option';
+$lang['checkPass']        = 'SQL statement for checking passwords';
+$lang['getUserInfo']      = 'SQL statement for retrieving user information';
+$lang['getGroups']        = 'SQL statement for retrieving a user\'s group memberships';
+$lang['getUsers']         = 'SQL statement to list all users';
+$lang['FilterLogin']      = 'SQL clause for filtering users by login name';
+$lang['FilterName']       = 'SQL clause for filtering users by full name';
+$lang['FilterEmail']      = 'SQL clause for filtering users by email address';
+$lang['FilterGroup']      = 'SQL clause for filtering users by group membership';
+$lang['SortOrder']        = 'SQL clause to sort users';
+$lang['addUser']          = 'SQL statement to add a new user';
+$lang['addGroup']         = 'SQL statement to add a new group';
+$lang['addUserGroup']     = 'SQL statement to add a user to an existing group';
+$lang['delGroup']         = 'SQL statement to remove a group';
+$lang['getUserID']        = 'SQL statement to get the primary key of a user';
+$lang['delUser']          = 'SQL statement to delete a user';
+$lang['delUserRefs']      = 'SQL statement to remove a user from all groups';
+$lang['updateUser']       = 'SQL statement to update a user profile';
+$lang['UpdateLogin']      = 'Update clause for updating the user\'s login name';
+$lang['UpdatePass']       = 'Update clause for updating the user\'s password';
+$lang['UpdateEmail']      = 'Update clause for updating the user\'s email address';
+$lang['UpdateName']       = 'Update clause for updating the user\'s full name';
+$lang['UpdateTarget']     = 'Limit clause to identify the user when updating';
+$lang['delUserGroup']     = 'SQL statement to remove a user from a given group';
+$lang['getGroupID']       = 'SQL statement to get the primary key of a given group';
diff --git a/wiki/lib/plugins/authpgsql/lang/eo/settings.php b/wiki/lib/plugins/authpgsql/lang/eo/settings.php
new file mode 100644
index 0000000..3af6b40
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/eo/settings.php
@@ -0,0 +1,37 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ */
+$lang['server']                = 'Via PostgreSQL-servilo';
+$lang['port']                  = 'Via PostgreSQL-servila pordego';
+$lang['user']                  = 'PostgreSQL-uzantonomo';
+$lang['password']              = 'Pasvorto por tiu uzanto';
+$lang['database']              = 'Uzenda datumbazo';
+$lang['debug']                 = 'Ĉu indiki aldonajn erarinformojn';
+$lang['forwardClearPass']      = 'Ĉu transdoni pasvortojn klartekste al la SQL-frazoj sube anstataŭ uzi pasvortan kaŝon';
+$lang['checkPass']             = 'SQL-frazo por testi pasvortojn';
+$lang['getUserInfo']           = 'SQL-frazo por ricevi uzantajn informojn';
+$lang['getGroups']             = 'SQL-frazo por ricevi la grupmembrecojn de uzanto';
+$lang['getUsers']              = 'SQL-frazo por listigi ĉiujn uzantojn';
+$lang['FilterLogin']           = 'SQL-frazo por filtri uzantojn je ensaluta nomo';
+$lang['FilterName']            = 'SQL-frazo por filtri uzantojn je plena nomo';
+$lang['FilterEmail']           = 'SQL-frazo por filtri uzantojn je retpoŝtadreso';
+$lang['FilterGroup']           = 'SQL-frazo por filtri uzantojn je grupmembreco';
+$lang['SortOrder']             = 'SQL-frazo por ordigi uzantojn';
+$lang['addUser']               = 'SQL-frazo por aldoni novan uzanton';
+$lang['addGroup']              = 'SQL-frazo por aldoni novan grupon';
+$lang['addUserGroup']          = 'SQL-frazo por aldoni uzanton al ekzistanta grupo';
+$lang['delGroup']              = 'SQL-frazo por forigi grupon';
+$lang['getUserID']             = 'SQL-frazo por ricevi la ĉefan ŝlosilon de uzanto';
+$lang['delUser']               = 'SQL-frazo por forigi uzanton';
+$lang['delUserRefs']           = 'SQL-frazo por forigi uzanton el ĉiuj grupoj';
+$lang['updateUser']            = 'SQL-frazo por aktualigi uzantan profilon';
+$lang['UpdateLogin']           = 'Aktualiga frazo por uzanta ensalutnomo';
+$lang['UpdatePass']            = 'Aktualiga frazo por uzanta pasvorto';
+$lang['UpdateEmail']           = 'Aktualiga frazo por uzanta retpoŝtadreso';
+$lang['UpdateName']            = 'Aktualiga frazo por plena uzanta nomo';
+$lang['UpdateTarget']          = 'Limiga frazo por identigi la uzanton dum aktualigado';
+$lang['delUserGroup']          = 'SQL-frazo por forigi uzanton el indikita grupo';
+$lang['getGroupID']            = 'SQL-frazo por ricevi la ĉefan ŝlosilon de indikita grupo';
diff --git a/wiki/lib/plugins/authpgsql/lang/es/settings.php b/wiki/lib/plugins/authpgsql/lang/es/settings.php
new file mode 100644
index 0000000..384d798
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/es/settings.php
@@ -0,0 +1,41 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Antonio Bueno <atnbueno@gmail.com>
+ * @author Antonio Castilla <antoniocastilla@trazoide.com>
+ * @author pokesakura <pokesakura@gmail.com>
+ * @author Domingo Redal <docxml@gmail.com>
+ */
+$lang['server']                = 'Su servidor PostgreSQL';
+$lang['port']                  = 'Puerto de su servidor PostgreSQL';
+$lang['user']                  = 'Nombre de usuario PostgreSQL';
+$lang['password']              = 'Contraseña del usuario indicado';
+$lang['database']              = 'Base de datos a usar';
+$lang['debug']                 = 'Muestra la información de depuración adicional';
+$lang['forwardClearPass']      = 'Pasar las contraseñas de usuario en texto plano a las siguientes sentencias de SQL, en lugar de utilizar la opción passcrypt';
+$lang['checkPass']             = 'Sentencia SQL para el control de las contraseñas';
+$lang['getUserInfo']           = 'Sentencia SQL para recuperar información del usuario';
+$lang['getGroups']             = 'Sentencia SQL para recuperar la pertenencia a grupos de un usuario';
+$lang['getUsers']              = 'Sentencia SQL para enumerar todos los usuarios';
+$lang['FilterLogin']           = 'Sentencia SQL para filtrar a los usuarios por su login';
+$lang['FilterName']            = 'Sentencia SQL para filtrar a los usuarios por su nombre completo';
+$lang['FilterEmail']           = 'Sentencia SQL para filtrar a los usuarios por su correo electrónico';
+$lang['FilterGroup']           = 'Sentencia SQL para filtrar a los usuarios por su membresía en un grupo';
+$lang['SortOrder']             = 'Sentencia SQL para ordenar a los usuarios';
+$lang['addUser']               = 'Sentencia de SQL para agregar un nuevo usuario';
+$lang['addGroup']              = 'Sentencia de SQL para agregar un nuevo grupo';
+$lang['addUserGroup']          = 'Sentencia SQL para agregar un usuario a un grupo existente';
+$lang['delGroup']              = 'Instrucción SQL para eliminar un grupo';
+$lang['getUserID']             = 'Sentencia SQL para obtener la clave principal de un usuario';
+$lang['delUser']               = 'Sentencia SQL para eliminar un usuario';
+$lang['delUserRefs']           = 'Sentencia SQL para remover a un usuario de su memebresia en todos los grupos';
+$lang['updateUser']            = 'Sentencia SQL para actualizar los datos del usuario';
+$lang['UpdateLogin']           = 'Sentencia de actualizacion para el login del usuario';
+$lang['UpdatePass']            = 'Sentencia de actualizacion para el password del usuario';
+$lang['UpdateEmail']           = 'Sentencia de actualizacion del correo electrónico del usuario';
+$lang['UpdateName']            = 'Sentencia de actualizacion del nombre completo del usuario';
+$lang['UpdateTarget']          = 'Cláusula limite para identificar al usuario cuando se actualiza';
+$lang['delUserGroup']          = 'Sentencia SQL para eliminar un usuario de un grupo determinado';
+$lang['getGroupID']            = 'Sentencia SQL para obtener la clave principal de un grupo dado';
diff --git a/wiki/lib/plugins/authpgsql/lang/fa/settings.php b/wiki/lib/plugins/authpgsql/lang/fa/settings.php
new file mode 100644
index 0000000..9fe5032
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/fa/settings.php
@@ -0,0 +1,40 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Mohamad Mehdi Habibi <habibi.esf@gmail.com>
+ * @author Mohmmad Razavi <sepent@gmail.com>
+ * @author Masoud Sadrnezhaad <masoud@sadrnezhaad.ir>
+ */
+$lang['server']                = 'سرور PostgreSQL شما';
+$lang['port']                  = 'پورت سرور PostgreSQL شما';
+$lang['user']                  = 'نام کاربری PostgreSQL';
+$lang['password']              = 'رمزعبور کابر بالا';
+$lang['database']              = 'پایگاه داده مورد استفاده';
+$lang['debug']                 = 'نمایش اطلاعات بیشتر برای خطایابی';
+$lang['forwardClearPass']      = 'به جای استفاده از امکان رمزنگاری، پسورد کاربران به صورت متنی به دستورات SQL ارسال شود';
+$lang['checkPass']             = 'دستور SQL برای چک کردن پسورد';
+$lang['getUserInfo']           = 'دستور SQL برای دریافت اطلاعات کاربران';
+$lang['getGroups']             = 'دستور SQL برای دریافت گروه‌های یک کاربر';
+$lang['getUsers']              = 'دستور SQL برای فهرست کردن تمام کاربران';
+$lang['FilterLogin']           = 'کلاز SQL برای فیلتر کردن کاربران با نام کاربری';
+$lang['FilterName']            = 'کلاز SQL برای فیلتر کردن کاربران با نام کامل';
+$lang['FilterEmail']           = 'کلاز SQL برای فیلتر کردن کاربران با آدرس ایمیل';
+$lang['FilterGroup']           = 'کلاز SQL برای فیلتر کردن کاربران با عضویت در گروه';
+$lang['SortOrder']             = 'کلاز SQL برای مرتب کردن کاربران';
+$lang['addUser']               = 'دستور SQL برای افزودن کاربر جدید';
+$lang['addGroup']              = 'دستور SQL برای افزودن گروه جدید';
+$lang['addUserGroup']          = 'دستور SQL برای افزودن یک کاربر به یک گروه موجود';
+$lang['delGroup']              = 'دستور SQL برای پاک کردن یک گروه';
+$lang['getUserID']             = 'دستور SQL برای گرفتن کلید اصلی یک کاربر';
+$lang['delUser']               = 'دستور SQL برای حذف یک کاربر';
+$lang['delUserRefs']           = 'دستور SQL برای پاک کردن یک کاربر از تمام گروه‌ها';
+$lang['updateUser']            = 'دستور SQL برای به‌روزرسانی پروفایل کاربر';
+$lang['UpdateLogin']           = 'کلاز Update برای به روز کردن نام کاربری';
+$lang['UpdatePass']            = 'کلاز Update برای به روز کردن پسورد کاربر';
+$lang['UpdateEmail']           = 'کلاز Update برای به روز کردن ایمیل کاربر';
+$lang['UpdateName']            = 'کلاز Update برای به روز کردن نام کامل کاربر';
+$lang['UpdateTarget']          = 'کلاز Limit برای شناسایی کاربر هنگام به روز رسانی';
+$lang['delUserGroup']          = 'دستور SQL برای حذف یک کاربر از یک گروه';
+$lang['getGroupID']            = 'دستور SQL برای گرفتن کلید اصلی یک گروه';
diff --git a/wiki/lib/plugins/authpgsql/lang/fr/settings.php b/wiki/lib/plugins/authpgsql/lang/fr/settings.php
new file mode 100644
index 0000000..8cd9c6a
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/fr/settings.php
@@ -0,0 +1,38 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Bruno Veilleux <bruno.vey@gmail.com>
+ */
+$lang['server']                = 'Votre serveur PostgreSQL';
+$lang['port']                  = 'Le port de votre serveur PostgreSQL';
+$lang['user']                  = 'Nom d\'utilisateur PostgreSQL';
+$lang['password']              = 'Mot de passe pour l\'utilisateur ci-dessus';
+$lang['database']              = 'Base de données à utiliser';
+$lang['debug']                 = 'Afficher des informations de débogage supplémentaires';
+$lang['forwardClearPass']      = 'Passer les mots de passe aux requêtes SQL ci-dessous en cleartext plutôt qu\'avec l\'option passcrypt';
+$lang['checkPass']             = 'Requête SQL pour la vérification des mots de passe';
+$lang['getUserInfo']           = 'Requête SQL pour la récupération des informations d\'un utilisateur';
+$lang['getGroups']             = 'Requête SQL pour la récupération des groupes d\'un utilisateur';
+$lang['getUsers']              = 'Requête SQL pour énumérer tous les utilisateurs';
+$lang['FilterLogin']           = 'Clause SQL pour filtrer les utilisateurs par identifiant';
+$lang['FilterName']            = 'Clause SQL pour filtrer les utilisateurs par nom complet';
+$lang['FilterEmail']           = 'Clause SQL pour filtrer les utilisateurs par adresse électronique';
+$lang['FilterGroup']           = 'Clause SQL pour filtrer les utilisateurs par groupes';
+$lang['SortOrder']             = 'Clause SQL pour trier les utilisateurs';
+$lang['addUser']               = 'Requête SQL pour ajouter un nouvel utilisateur';
+$lang['addGroup']              = 'Requête SQL pour ajouter un nouveau groupe';
+$lang['addUserGroup']          = 'Requête SQL pour ajouter un utilisateur à un groupe existant';
+$lang['delGroup']              = 'Requête SQL pour retirer un groupe';
+$lang['getUserID']             = 'Requête SQL pour obtenir la clé primaire d\'un utilisateur';
+$lang['delUser']               = 'Requête SQL pour supprimer un utilisateur';
+$lang['delUserRefs']           = 'Requête SQL pour retirer un utilisateur de tous les groupes';
+$lang['updateUser']            = 'Requête SQL pour mettre à jour le profil d\'un utilisateur';
+$lang['UpdateLogin']           = 'Clause de mise à jour pour mettre à jour l\'identifiant d\'un utilisateur';
+$lang['UpdatePass']            = 'Clause de mise à jour pour mettre à jour le mot de passe d\'un utilisateur';
+$lang['UpdateEmail']           = 'Clause de mise à jour pour mettre à jour l\'adresse électronique d\'un utilisateur';
+$lang['UpdateName']            = 'Clause de mise à jour pour mettre à jour le nom complet d\'un utilisateur';
+$lang['UpdateTarget']          = 'Clause de limite pour identifier l\'utilisateur durant une mise à jour';
+$lang['delUserGroup']          = 'Requête SQL pour retirer un utilisateur d\'un groupe donné';
+$lang['getGroupID']            = 'Requête SQL pour obtenir la clé primaire d\'un groupe donné';
diff --git a/wiki/lib/plugins/authpgsql/lang/hr/settings.php b/wiki/lib/plugins/authpgsql/lang/hr/settings.php
new file mode 100644
index 0000000..2cec4e5
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/hr/settings.php
@@ -0,0 +1,38 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Davor Turkalj <turki.bsc@gmail.com>
+ */
+$lang['server']                = 'Vaš PostgreSQL server';
+$lang['port']                  = 'Port vašeg PostgreSQL servera';
+$lang['user']                  = 'PostgreSQL korisničko ime';
+$lang['password']              = 'Lozinka gore navedenoga korisnika';
+$lang['database']              = 'Baza koja se koristi';
+$lang['debug']                 = 'Prikaz dodatnih dijagnostičkih informacija';
+$lang['forwardClearPass']      = 'Proslijed lozinku kao običan tekst u SQL izrazima koji slijede, umjesto korištenja passcrypt opcije';
+$lang['checkPass']             = 'SQL izraz za provjeru lozinke';
+$lang['getUserInfo']           = 'SQL izraz za dohvat korisničkih informacija';
+$lang['getGroups']             = 'SQL izraz za dohvat korisničkog članstva u grupama';
+$lang['getUsers']              = 'SQL izraz za ispis svih korisnika';
+$lang['FilterLogin']           = 'SQL izraz za filtriranje korisnika po korisničkom imenu';
+$lang['FilterName']            = 'SQL izraz za filtriranje korisnika po punom imenu';
+$lang['FilterEmail']           = 'SQL izraz za filtriranje korisnika po email adresi';
+$lang['FilterGroup']           = 'SQL izraz za filtriranje korisnika po članstvu u grupama';
+$lang['SortOrder']             = 'SQL izraz za sortiranje korisnika';
+$lang['addUser']               = 'SQL izraz za dodavanje novog korisnika';
+$lang['addGroup']              = 'SQL izraz za dodavanje nove grupe';
+$lang['addUserGroup']          = 'SQL izraz za dodavanje korisnika u postojeću grupu';
+$lang['delGroup']              = 'SQL izraz za brisanje grupe';
+$lang['getUserID']             = 'SQL izraz za dohvaćanje primarnog ključa korisnika';
+$lang['delUser']               = 'SQL izraz za brisanje korisnika';
+$lang['delUserRefs']           = 'SQL izraz za uklanjanje korisnika iz svih grupa';
+$lang['updateUser']            = 'SQL izraz za ažuriranje korisničkog profila';
+$lang['UpdateLogin']           = 'UPDATE izraz za ažuriranje korisničkog imena';
+$lang['UpdatePass']            = 'UPDATE izraz za ažuriranje korisničke lozinke';
+$lang['UpdateEmail']           = 'UPDATE izraz za ažuriranje korisničke email adrese';
+$lang['UpdateName']            = 'UPDATE izraz za ažuriranje korisničkog punog imena';
+$lang['UpdateTarget']          = 'Limitirajući izraz za identificiranje korisnika pri ažuriranju';
+$lang['delUserGroup']          = 'SQL izraz za uklanjanje korisnika iz navedenih grupa';
+$lang['getGroupID']            = 'SQL izraz za dobivanje primarnog ključa navedene grupe';
diff --git a/wiki/lib/plugins/authpgsql/lang/hu/settings.php b/wiki/lib/plugins/authpgsql/lang/hu/settings.php
new file mode 100644
index 0000000..213fc87
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/hu/settings.php
@@ -0,0 +1,39 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ * 
+ * @author Marton Sebok <sebokmarton@gmail.com>
+ * @author Marina Vladi <deldadam@gmail.com>
+ */
+$lang['server']                = 'PostgreSQL-kiszolgáló';
+$lang['port']                  = 'PostgreSQL-kiszolgáló portja';
+$lang['user']                  = 'PostgreSQL-felhasználónév';
+$lang['password']              = 'Fenti felhasználó jelszava';
+$lang['database']              = 'Adatbázis';
+$lang['debug']                 = 'Hibakeresési üzenetek megjelenítése';
+$lang['forwardClearPass']      = 'A jelszó nyílt szövegben való átadása a következő SQL utasításokban a passcrypt opció használata helyett';
+$lang['checkPass']             = 'SQL-utasítás a jelszavak ellenőrzéséhez';
+$lang['getUserInfo']           = 'SQL-utasítás a felhasználói információk lekérdezéséhez';
+$lang['getGroups']             = 'SQL-utasítás egy felhasználó csoporttagságainak lekérdezéséhez';
+$lang['getUsers']              = 'SQL-utasítás a felhasználók listázásához';
+$lang['FilterLogin']           = 'SQL-kifejezés a felhasználók azonosító alapú szűréséhez';
+$lang['FilterName']            = 'SQL-klauzula a felhasználók név alapú szűréséhez';
+$lang['FilterEmail']           = 'SQL-klauzula a felhasználók e-mail cím alapú szűréséhez';
+$lang['FilterGroup']           = 'SQL-klauzula a felhasználók csoporttagság alapú szűréséhez';
+$lang['SortOrder']             = 'SQL-klauzula a felhasználók rendezéséhez';
+$lang['addUser']               = 'SQL-klauzula új felhasználó hozzáadásához';
+$lang['addGroup']              = 'SQL-klauzula új csoport hozzáadásához';
+$lang['addUserGroup']          = 'SQL-utasítás felhasználó meglévő csoporthoz való hozzáadásához';
+$lang['delGroup']              = 'SQL-utasítás csoport törléséhez';
+$lang['getUserID']             = 'SQL-utasítás felhasználó elsődleges kulcsának lekérdezéséhez';
+$lang['delUser']               = 'SQL-utasítás felhasználó törléséhez';
+$lang['delUserRefs']           = 'SQL-utasítás felhasználó összes csoportból való törléséhez';
+$lang['updateUser']            = 'SQL-utasítás felhasználó profiljának frissítéséhez';
+$lang['UpdateLogin']           = 'UPDATE-klauzula felhasználók azonosítójának frissítéséhez';
+$lang['UpdatePass']            = 'UPDATE-klauzula felhasználók jelszavának frissítéséhez';
+$lang['UpdateEmail']           = 'UPDATE-klauzula felhasználók e-mailcímének frissítéséhez';
+$lang['UpdateName']            = 'SQL-kifejezés a felhasználó nevének frissítéséhez';
+$lang['UpdateTarget']          = 'SQL-kifejezés a felhasználó kiválasztásához az adatok frissítésekor';
+$lang['delUserGroup']          = 'SQL-utasítás egy felhasználó eltávolításához egy adott csoportból';
+$lang['getGroupID']            = 'SQL-utasítás egy csoport elsődleges kulcsának lekérdezéséhez';
diff --git a/wiki/lib/plugins/authpgsql/lang/it/settings.php b/wiki/lib/plugins/authpgsql/lang/it/settings.php
new file mode 100644
index 0000000..365fc47
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/it/settings.php
@@ -0,0 +1,40 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Francesco <francesco.cavalli@hotmail.com>
+ * @author Torpedo <dgtorpedo@gmail.com>
+ * @author Maurizio <mcannavo@katamail.com>
+ */
+$lang['server']                = 'Il tuo server PostgreSQL ';
+$lang['port']                  = 'La porta del tuo server PostgreSQL ';
+$lang['user']                  = 'Lo username PostgreSQL';
+$lang['password']              = 'Password dell\'utente summenzionato';
+$lang['database']              = 'Database da usare';
+$lang['debug']                 = 'Visualizza informazioni addizionali di debug';
+$lang['forwardClearPass']      = 'Fornisci le password utente come testo visibile alle istruzioni SQL qui sotto, invece che usare l\'opzione passcrypt';
+$lang['checkPass']             = 'Istruzione SQL per il controllo password';
+$lang['getUserInfo']           = 'Istruzione SQL per recuperare le informazioni utente';
+$lang['getGroups']             = 'Istruzione SQL per recuperare il gruppo di appartenenza di un utente';
+$lang['getUsers']              = 'Istruzione SQL per elencare tutti gli utenti';
+$lang['FilterLogin']           = 'Condizione SQL per filtrare gli utenti in base al nome di accesso';
+$lang['FilterName']            = 'Condizione SQL per filtrare gli utenti in base al nome completo';
+$lang['FilterEmail']           = 'Condizione SQL per filtrare gli utenti in base all\'indirizzo e-mail';
+$lang['FilterGroup']           = 'Condizione SQL per filtrare gli utenti in base al gruppo di appartenenza';
+$lang['SortOrder']             = 'Condizione SQL per ordinare gli utenti';
+$lang['addUser']               = 'Istruzione SQL per aggiungere un nuovo utente';
+$lang['addGroup']              = 'Istruzione SQL per aggiungere un nuovo gruppo';
+$lang['addUserGroup']          = 'Istruzione SQL per aggiungere un utente ad un gruppo esistente';
+$lang['delGroup']              = 'Istruzione SQL per imuovere un gruppo';
+$lang['getUserID']             = 'Istruzione SQL per recuperare la primary key di un utente';
+$lang['delUser']               = 'Istruzione SQL per cancellare un utente';
+$lang['delUserRefs']           = 'Istruzione SQL per rimuovere un utente da tutti i gruppi';
+$lang['updateUser']            = 'Istruzione SQL per aggiornare il profilo utente';
+$lang['UpdateLogin']           = 'Condizione SQL per aggiornare il nome di accesso dell\'utente';
+$lang['UpdatePass']            = 'Condizione SQL per aggiornare la password utente';
+$lang['UpdateEmail']           = 'Condizione SQL per aggiornare l\'e-mail utente';
+$lang['UpdateName']            = 'Condizione SQL per aggiornare il nome completo dell\'utente';
+$lang['UpdateTarget']          = 'Condizione SQL per identificare l\'utente quando aggiornato';
+$lang['delUserGroup']          = 'Istruzione SQL per rimuovere un utente da un dato gruppo';
+$lang['getGroupID']            = 'Istruzione SQL per avere la primary key di un dato gruppo';
diff --git a/wiki/lib/plugins/authpgsql/lang/ja/settings.php b/wiki/lib/plugins/authpgsql/lang/ja/settings.php
new file mode 100644
index 0000000..001008c
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/ja/settings.php
@@ -0,0 +1,38 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Satoshi Sahara <sahara.satoshi@gmail.com>
+ */
+$lang['server']                = 'PostgreSQL のサーバー名';
+$lang['port']                  = 'PostgreSQL サーバーのポート番号';
+$lang['user']                  = 'PostgreSQL 接続用ユーザー名';
+$lang['password']              = 'PostgreSQL 接続用ユーザーのパスワード';
+$lang['database']              = '使用するデータベース名';
+$lang['debug']                 = 'デバック情報を表示する';
+$lang['forwardClearPass']      = '以下で定義する SQL ステートメントにおいて, パスワード変数 を平文とする(DokiWiki側で暗号化しない)';
+$lang['checkPass']             = 'パスワードの照合に用いる SQL ステートメント';
+$lang['getUserInfo']           = 'ユーザー情報の取得に用いる SQL ステートメント';
+$lang['getGroups']             = 'ユーザーが所属する全てのグループの取得に用いる SQL ステートメント';
+$lang['getUsers']              = 'ユーザーリストを取得する SQL ステートメント';
+$lang['FilterLogin']           = 'ユーザーリストをログイン名で絞り込む SQL 句';
+$lang['FilterName']            = 'ユーザーリストをフルネームで絞り込む SQL 句';
+$lang['FilterEmail']           = 'ユーザーリストをメールアドレスで絞り込む SQL 句';
+$lang['FilterGroup']           = 'ユーザーリストを所属グループで絞り込む SQL 句';
+$lang['SortOrder']             = 'ユーザーリストのソート方法を指定する SQL 句';
+$lang['addUser']               = '新規ユーザーを追加する SQL ステートメント';
+$lang['addGroup']              = '新規グループを追加する SQL ステートメント';
+$lang['addUserGroup']          = 'ユーザーをグループに配属する SQL ステートメント';
+$lang['delGroup']              = 'グループを削除する SQL ステートメント';
+$lang['getUserID']             = 'ユーザーIDの取得に用いる SQL ステートメン';
+$lang['delUser']               = 'ユーザーを削除する SQL ステートメント';
+$lang['delUserRefs']           = 'ユーザーのグループ所属を全て取り消す SQL ステートメント';
+$lang['updateUser']            = 'ユーザー情報を変更する SQL ステートメント';
+$lang['UpdateLogin']           = '変更後のログイン名を指定する SQL 句';
+$lang['UpdatePass']            = '変更後のパスワードを指定する SQL 句';
+$lang['UpdateEmail']           = '変更後のメールアドレスを指定する SQL 句';
+$lang['UpdateName']            = '変更後のフルネームを指定する SQL 句';
+$lang['UpdateTarget']          = '変更対象のユーザを特定するための SQL 句';
+$lang['delUserGroup']          = 'ユーザーをグループから除名する SQL ステートメント';
+$lang['getGroupID']            = 'グループIDの取得に用いる SQL ステートメント';
diff --git a/wiki/lib/plugins/authpgsql/lang/ko/settings.php b/wiki/lib/plugins/authpgsql/lang/ko/settings.php
new file mode 100644
index 0000000..fd45bfa
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/ko/settings.php
@@ -0,0 +1,39 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Myeongjin <aranet100@gmail.com>
+ * @author Garam <rowain8@gmail.com>
+ */
+$lang['server']                = 'PostgreSQL 서버';
+$lang['port']                  = 'PostgreSQL 서버의 포트';
+$lang['user']                  = 'PostgreSQL 사용자 이름';
+$lang['password']              = '위 사용자의 비밀번호';
+$lang['database']              = '사용할 데이터베이스';
+$lang['debug']                 = '추가적인 디버그 정보 보이기';
+$lang['forwardClearPass']      = 'passcrypt 옵션을 사용하는 대신 아래 SQL 문에 일반 텍스트로 사용자 비밀번호를 전달';
+$lang['checkPass']             = '비밀번호를 확인하기 위한 SQL 문';
+$lang['getUserInfo']           = '사용자 정보를 가져오기 위한 SQL 문';
+$lang['getGroups']             = '사용자의 그룹 구성원을 가져오기 위한 SQL 문';
+$lang['getUsers']              = '모든 사용자를 나타낼 SQL 문';
+$lang['FilterLogin']           = '로그인 이름별로 사용자를 필터하기 위한 SQL 조항';
+$lang['FilterName']            = '전체 이름별로 사용자를 필터하기 위한 SQL 조항';
+$lang['FilterEmail']           = '이메일 주소별로 사용자를 필터하기 위한 SQL 조항';
+$lang['FilterGroup']           = '그룹 구성원별로 사용자를 필터하기 위한 SQL 조항';
+$lang['SortOrder']             = '사용자를 정렬할 SQL 조항';
+$lang['addUser']               = '새 사용자를 추가할 SQL 문';
+$lang['addGroup']              = '새 그룹을 추가할 SQL 문';
+$lang['addUserGroup']          = '기존 그룹에 사용자를 추가할 SQL 문';
+$lang['delGroup']              = '그룹을 제거할 SQL 문';
+$lang['getUserID']             = '사용자의 기본 키를 얻을 SQL 문';
+$lang['delUser']               = '사용자를 삭제할 SQL 문';
+$lang['delUserRefs']           = '모든 그룹에서 사용자를 제거할 SQL 문';
+$lang['updateUser']            = '사용자 프로필을 업데이트할 SQL 문';
+$lang['UpdateLogin']           = '사용자의 로그인 이름을 업데이트하기 위한 Update 조항';
+$lang['UpdatePass']            = '사용자의 비밀번호를 업데이트하기 위한 Update 조항';
+$lang['UpdateEmail']           = '사용자의 이메일 주소를 업데이트하기 위한 Update 조항';
+$lang['UpdateName']            = '사용자의 전체 이름을 업데이트하기 위한 Update 조항';
+$lang['UpdateTarget']          = '업데이트할 때 사용자를 식별할 Limit 조항';
+$lang['delUserGroup']          = '주어진 그룹에서 사용자를 제거할 SQL 문';
+$lang['getGroupID']            = '주어진 그룹의 기본 키를 얻을 SQL 문';
diff --git a/wiki/lib/plugins/authpgsql/lang/lv/settings.php b/wiki/lib/plugins/authpgsql/lang/lv/settings.php
new file mode 100644
index 0000000..dd63544
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/lv/settings.php
@@ -0,0 +1,9 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Aivars Miška <allefm@gmail.com>
+ */
+$lang['password']              = 'Lietotāja parole';
+$lang['delUser']               = 'SQL pieprasījums lietotāja dzēšanai';
diff --git a/wiki/lib/plugins/authpgsql/lang/nl/settings.php b/wiki/lib/plugins/authpgsql/lang/nl/settings.php
new file mode 100644
index 0000000..7b4ec70
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/nl/settings.php
@@ -0,0 +1,38 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Remon <no@email.local>
+ */
+$lang['server']                = 'Je PostgreSQL server';
+$lang['port']                  = 'Je PostgreSQL server poort';
+$lang['user']                  = 'PostgreSQL gebruikersnaam';
+$lang['password']              = 'Wachtwoord voor bovenstaande gebruiker';
+$lang['database']              = 'Te gebruiken database';
+$lang['debug']                 = 'Tonen aanvullende debuginformatie';
+$lang['forwardClearPass']      = 'Wachtwoorden als leesbare tekst in SQL commando\'s opnemen in plaats van versleuteld';
+$lang['checkPass']             = 'SQL commando voor het verifiëren van wachtwoorden';
+$lang['getUserInfo']           = 'SQL commando voor het ophalen van gebruikersinformatie';
+$lang['getGroups']             = 'SQL commando voor het ophalen van groepslidmaatschappen van gebruikers';
+$lang['getUsers']              = 'SQL commando voor het tonen van alle gebruikers';
+$lang['FilterLogin']           = 'SQL commando voor het filteren van gebruikers op inlognaam';
+$lang['FilterName']            = 'SQL commando voor het filteren van gebruikers op volledige naam';
+$lang['FilterEmail']           = 'SQL commando voor het filteren van gebruikers op e-mailadres';
+$lang['FilterGroup']           = 'SQL commando voor het filteren van gebruikers op groepslidmaatschap';
+$lang['SortOrder']             = 'SQL commando voor het sorteren van gebruikers';
+$lang['addUser']               = 'SQL commando voor het toevoegen van een nieuwe gebruiker';
+$lang['addGroup']              = 'SQL commando voor het toevoegen van een nieuwe groep';
+$lang['addUserGroup']          = 'SQL commando voor toevoegen van een gebruiker aan een bestaande groep';
+$lang['delGroup']              = 'SQL commando voor het verwijderen van een groep';
+$lang['getUserID']             = 'SQL commando om de primaire sleutel van een gebruiker op te halen';
+$lang['delUser']               = 'SQL commando voor het verwijderen van een gebruiker';
+$lang['delUserRefs']           = 'SQL commando om een gebruiker uit alle groepen te verwijderen';
+$lang['updateUser']            = 'SQL commando om een gebruikersprofiel bij te werken';
+$lang['UpdateLogin']           = 'SQL commando om een inlognaam bij te werken';
+$lang['UpdatePass']            = 'SQL commando om een wachtwoord bij te werken';
+$lang['UpdateEmail']           = 'SQL commando om een e-mailadres bij te werken';
+$lang['UpdateName']            = 'SQL commando om een volledige naam bij te werken';
+$lang['UpdateTarget']          = 'Beperkingsclausule om de gebruiker te identificeren bij het bijwerken';
+$lang['delUserGroup']          = 'SQL commando om een gebruiker uit een bepaalde groep te verwijderen';
+$lang['getGroupID']            = 'SQL commando om de primaire sleutel van een bepaalde groep op te halen';
diff --git a/wiki/lib/plugins/authpgsql/lang/no/settings.php b/wiki/lib/plugins/authpgsql/lang/no/settings.php
new file mode 100644
index 0000000..9e84e4d
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/no/settings.php
@@ -0,0 +1,38 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Arne Hanssen <arne.hanssen@getmail.no>
+ */
+$lang['server']                = 'Din PostgreSQL-server';
+$lang['port']                  = 'Porten til din PostgreSQL-server';
+$lang['user']                  = 'PostgreSQL-brukernavn';
+$lang['password']              = 'Passord til bruker over';
+$lang['database']              = 'Database som brukes';
+$lang['debug']                 = 'Vis utvidet feilinformasjon';
+$lang['forwardClearPass']      = 'Videresendt passord i klartekst til SQL-uttrykket under, i stedet for å bruke det krypterte passordet';
+$lang['checkPass']             = 'SQL-uttrykk for å sjekke passordet';
+$lang['getUserInfo']           = 'SQL-uttrykk for å hente informasjon om en bruker';
+$lang['getGroups']             = 'SQL-uttrykk for å hente gruppene en bruker tilhører';
+$lang['getUsers']              = 'SQL-uttrykk for å liste alle brukere ';
+$lang['FilterLogin']           = 'SQL-uttrykk for å filtrere brukere etter brukernavn';
+$lang['FilterName']            = 'SQL-uttrykk for å filtrere brukere etter fult navn';
+$lang['FilterEmail']           = 'SQL-uttrykk for å filtrere brukere etter e-postadresse';
+$lang['FilterGroup']           = 'SQL-uttrykk for å filtrere brukere etter hvilken grupper de tilhører';
+$lang['SortOrder']             = 'SQL-uttrykk for å sortere brukere';
+$lang['addUser']               = 'SQL-uttrykk for å legge til en ny bruker';
+$lang['addGroup']              = 'SQL-uttrykk for å legge til en ny gruppe';
+$lang['addUserGroup']          = 'SQL-uttrykk for å legge til en bruker i en eksisterende gruppe';
+$lang['delGroup']              = 'SQL-uttrykk for å fjerne en gruppe ';
+$lang['getUserID']             = 'SQL-uttrykk for å hente primærnøkkel for en gitt bruker';
+$lang['delUser']               = 'SQL-utrykk for å slette en bruker ';
+$lang['delUserRefs']           = 'SQL-utrykk for å fjerne en bruke fra alle grupper';
+$lang['updateUser']            = 'SQL-uttrykk for å oppdatere en brukerprofil';
+$lang['UpdateLogin']           = 'Update-utrykk for å oppdatere brukernavn';
+$lang['UpdatePass']            = 'Update-utrykk for å oppdatere brukers passord';
+$lang['UpdateEmail']           = 'Update-utrykk for å oppdatere brukers e-postadresse';
+$lang['UpdateName']            = 'Update-utrykk for å oppdatere brukers fulle navn';
+$lang['UpdateTarget']          = 'Limit-uttrykk for å identifisere brukeren ved oppdatering';
+$lang['delUserGroup']          = 'SQL-uttrykk for fjerne en bruker fra gitt gruppe';
+$lang['getGroupID']            = 'SQL-uttrykk for å hente primærnøkkel for en gitt gruppe';
diff --git a/wiki/lib/plugins/authpgsql/lang/pl/settings.php b/wiki/lib/plugins/authpgsql/lang/pl/settings.php
new file mode 100644
index 0000000..e89fd91
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/pl/settings.php
@@ -0,0 +1,40 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Wojciech Lichota <wojciech@lichota.pl>
+ * @author Max <maxrb146@gmail.com>
+ * @author Mati <mackosa@wp.pl>
+ */
+$lang['server']                = 'Twój serwer PostgreSQL';
+$lang['port']                  = 'Port Twojego serwera PostgreSQL';
+$lang['user']                  = 'Nazwa użytkownika PostgreSQL';
+$lang['password']              = 'Hasła dla powyższego użytkownika';
+$lang['database']              = 'Baza danych do użycia';
+$lang['debug']                 = 'Wyświetl dodatkowe informacje debagowania';
+$lang['forwardClearPass']      = 'Przekazuj do poniższej instrukcji SQL hasła użytkowników jako czysty tekst do instrukcji SQL zamiast używać opcji passcrypt';
+$lang['checkPass']             = 'Instrukcja SQL sprawdzająca hasła';
+$lang['getUserInfo']           = 'Instrukcja SQL pobierająca dane użytkownika';
+$lang['getGroups']             = 'Instrukcja SQL pobierająca przynależność użytkownika do grup';
+$lang['getUsers']              = 'Instrukcja SQL listująca wszystkich użytkowników';
+$lang['FilterLogin']           = 'Instrukcja SQL filtrująca użytkowników po loginie';
+$lang['FilterName']            = 'Instrukcja SQL filtrująca użytkowników po imieniu i nazwisku';
+$lang['FilterEmail']           = 'Instrukcja SQL filtrująca użytkowników po emailu';
+$lang['FilterGroup']           = 'Instrukcja SQL filtrująca użytkowników po przynależności do grupy';
+$lang['SortOrder']             = 'Instrukcja SQL sortująca użytkowników';
+$lang['addUser']               = 'Instrukcja SQL dodająca nowego użytkownika';
+$lang['addGroup']              = 'Instrukcja SQL dodająca nową grupę';
+$lang['addUserGroup']          = 'Instrukcja SQL dodająca użytkownika do istniejącej grupy';
+$lang['delGroup']              = 'Instrukcja SQL usuwająca grupę';
+$lang['getUserID']             = 'Instrukcja SQL pobierająca klucz główny użytkownika';
+$lang['delUser']               = 'Instrukcja SQL usuwająca użytkownika';
+$lang['delUserRefs']           = 'Instrukcja SQL usuwająca użytkownika ze wszystkich grup';
+$lang['updateUser']            = 'Instrukcja SQL aktualizująca profil użytkownika';
+$lang['UpdateLogin']           = 'Polecenie służące do aktualizacji loginu użytkownika';
+$lang['UpdatePass']            = 'Polecenie służące do aktualizacji hasła użytkownika';
+$lang['UpdateEmail']           = 'Polecenie służące do aktualizacji e-mailu użytkownika';
+$lang['UpdateName']            = 'Polecenie służące do aktualizacji imienia i nazwiska użytkownika';
+$lang['UpdateTarget']          = 'Instrukcja limitu do identyfikacji użytkownika podczas aktualizacji';
+$lang['delUserGroup']          = 'Instrukcja SQL usuwająca użytkownika ze wskazanej grupy';
+$lang['getGroupID']            = 'Instrukcja SQL pobierająca klucz główny wskazanej grupy';
diff --git a/wiki/lib/plugins/authpgsql/lang/pt-br/settings.php b/wiki/lib/plugins/authpgsql/lang/pt-br/settings.php
new file mode 100644
index 0000000..a06ce0e
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/pt-br/settings.php
@@ -0,0 +1,39 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Victor Westmann <victor.westmann@gmail.com>
+ * @author Frederico Guimarães <frederico@teia.bio.br>
+ */
+$lang['server']                = 'Seu servidor PostgreSQL';
+$lang['port']                  = 'Sua porta do servidor PostgreSQL';
+$lang['user']                  = 'Nome de usuário PostgreSQL';
+$lang['password']              = 'Senha do usuário acima';
+$lang['database']              = 'Base de dados para usar';
+$lang['debug']                 = 'Mostrar informações adicionais de depuração';
+$lang['forwardClearPass']      = 'Transmitir senhas de usuário como texto puro para comandos SQL abaixo, ao invés de usar a opção passcrypt';
+$lang['checkPass']             = 'Comando SQL para verificar senhas';
+$lang['getUserInfo']           = 'Comando SQL para obter informações do usuário';
+$lang['getGroups']             = 'Comando SQL para obter as credenciais de um usuário de um determinado grupo';
+$lang['getUsers']              = 'Comando SQL para listar todos os usuários';
+$lang['FilterLogin']           = 'Cláusula SQL para filtrar usuários pelo nome de login';
+$lang['FilterName']            = 'Cláusula SQL para filtrar usuários pelo nome completo';
+$lang['FilterEmail']           = 'Cláusula SQL para filtrar usuários pelo endereço de email';
+$lang['FilterGroup']           = 'Cláusula SQL para filtrar usuários pelo grupo que pertencem';
+$lang['SortOrder']             = 'Comando SQL para adicionar novo grupo';
+$lang['addUser']               = 'Comando SQL para adicionar novo usuário';
+$lang['addGroup']              = 'Comando SQL para adicionar novo grupo';
+$lang['addUserGroup']          = 'Comando SQL para adicionar um usuário a um grupo existente';
+$lang['delGroup']              = 'Comando SQL para remover um grupo';
+$lang['getUserID']             = 'Comando SQL para obter chave primária de usuário';
+$lang['delUser']               = 'Comando SQL para apagar usuário';
+$lang['delUserRefs']           = 'Comando SQL para remover um usuário de todos os grupos';
+$lang['updateUser']            = 'Comando SQL para atualizar perfil de usuário';
+$lang['UpdateLogin']           = 'Atualizar cláusula para atualizar o login do usuário';
+$lang['UpdatePass']            = 'Atualizar cláusula para atualizar a senha do usuário';
+$lang['UpdateEmail']           = 'Atualizar cláusula para atualizar o endereço de email';
+$lang['UpdateName']            = 'Atualizar cláusula para atualizar o nome completo do usuário';
+$lang['UpdateTarget']          = 'Limitar cláusula para identificar quando um usuário estiver atualizando';
+$lang['delUserGroup']          = 'Comando SQL para remover um usuário de um determinado grupo';
+$lang['getGroupID']            = 'Comando SQL para obter a chave primária de um determinado grupo';
diff --git a/wiki/lib/plugins/authpgsql/lang/pt/settings.php b/wiki/lib/plugins/authpgsql/lang/pt/settings.php
new file mode 100644
index 0000000..edc4e1a
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/pt/settings.php
@@ -0,0 +1,39 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author André Neves <drakferion@gmail.com>
+ * @author Guido Salatino <guidorafael23@gmail.com>
+ */
+$lang['server']                = 'O seu servidor PostgreSQL';
+$lang['port']                  = 'A porta do seu servidor PostgreSQL';
+$lang['user']                  = 'Nome de utilizador PostgreSQL';
+$lang['password']              = 'Senha do utilizador acima';
+$lang['database']              = 'Base de dados a usar';
+$lang['debug']                 = 'Mostrar informação adicional de debug';
+$lang['forwardClearPass']      = 'Passe as senhas do usuário como texto puro para as instruções SQL abaixo, em vez de usar a opção passcrypt';
+$lang['checkPass']             = 'Instrução SQL para verificar senhas';
+$lang['getUserInfo']           = 'Instrução SQL para recuperar informações de um usuário';
+$lang['getGroups']             = 'Instrução SQL para recuperar os usuários participantes de um grupo';
+$lang['getUsers']              = 'Instrução SQL para listar todos usuários';
+$lang['FilterLogin']           = 'Cláusula SQL para filtrar utilizadores por nome de login';
+$lang['FilterName']            = 'Cláusula SQL para filtrar utilizadores por nome completo';
+$lang['FilterEmail']           = 'Cláusula SQL para filtrar utilizadores por endereço de email';
+$lang['FilterGroup']           = 'Cláusula SQL para filtrar utilizadores por pertença a grupo';
+$lang['SortOrder']             = 'Cláusula SQL para ordenar utilizadores';
+$lang['addUser']               = 'Instrução SQL para adicionar um novo usuário';
+$lang['addGroup']              = 'Instrução SQL para adicionar um novo grupo';
+$lang['addUserGroup']          = 'Instrução SQL para adicionar um usuário a um grupo existente';
+$lang['delGroup']              = 'Instrução SQL para remover um grupo';
+$lang['getUserID']             = 'Instrução SQL para obter a chave principal de um usuário';
+$lang['delUser']               = 'Instrução SQL para remover um usuário';
+$lang['delUserRefs']           = 'Instrução SQL para remover um usuário de todos os grupos';
+$lang['updateUser']            = 'Instrução SQL para atualizar um perfil de usuário';
+$lang['UpdateLogin']           = 'Cláusula de atualização para atualizar o nome de login do utilizador';
+$lang['UpdatePass']            = 'Cláusula de atualização para atualizar a senha do utilizador';
+$lang['UpdateEmail']           = 'Cláusula de atualização para atualizar o endereço de email do utilizador';
+$lang['UpdateName']            = 'Cláusula de atualização para atualizar o nome completo do utilizador';
+$lang['UpdateTarget']          = 'Cláusula limite para identificar o usuário ao atualizar';
+$lang['delUserGroup']          = 'Instrução SQL para remover um usuário de um determinado grupo';
+$lang['getGroupID']            = 'Instrução SQL para obter a chave principal de um determinado grupo';
diff --git a/wiki/lib/plugins/authpgsql/lang/ru/settings.php b/wiki/lib/plugins/authpgsql/lang/ru/settings.php
new file mode 100644
index 0000000..ceb5bd4
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/ru/settings.php
@@ -0,0 +1,42 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Ivan I. Udovichenko (sendtome@mymailbox.pp.ua)
+ * @author Aleksandr Selivanov <alexgearbox@gmail.com>
+ * @author Vitaly Filatenko <kot@hacktest.net>
+ * @author Type-kun <workwork-1@yandex.ru>
+ * @author Alex P <alexander@lanos.co.uk>
+ */
+$lang['server']                = 'Ваш PostgreSQL-сервер';
+$lang['port']                  = 'Порт вашего PostgreSQL-сервера';
+$lang['user']                  = 'Имя пользователя PostgreSQL';
+$lang['password']              = 'Пароль для указанного пользователя';
+$lang['database']              = 'Имя базы данных';
+$lang['debug']                 = 'Отображать дополнительную отладочную информацию';
+$lang['forwardClearPass']      = 'Передать чистым текстом ползовательские пароли в SQL запросы ниже, вместо использование опции passcrypt';
+$lang['checkPass']             = 'Выражение SQL, осуществляющее проверку пароля';
+$lang['getUserInfo']           = 'Выражение SQL, осуществляющее извлечение информации о пользователе';
+$lang['getGroups']             = 'Выражение SQL, осуществляющее извлечение информации о членстве пользователе в группах';
+$lang['getUsers']              = 'Выражение SQL, осуществляющее извлечение полного списка пользователей';
+$lang['FilterLogin']           = 'Выражение SQL, осуществляющее фильтрацию пользователей по логину';
+$lang['FilterName']            = 'Выражение SQL, осуществляющее фильтрацию пользователей по полному имени';
+$lang['FilterEmail']           = 'Выражение SQL, осуществляющее фильтрацию пользователей по адресу электронной почты';
+$lang['FilterGroup']           = 'Выражение SQL, осуществляющее фильтрацию пользователей согласно членству в группе';
+$lang['SortOrder']             = 'Выражение SQL, осуществляющее сортировку пользователей';
+$lang['addUser']               = 'Выражение SQL, осуществляющее добавление нового пользователя';
+$lang['addGroup']              = 'Выражение SQL, осуществляющее добавление новой группы';
+$lang['addUserGroup']          = 'Выражение SQL, осуществляющее добавление пользователя в существующую группу';
+$lang['delGroup']              = 'Выражение SQL, осуществляющее удаление группы';
+$lang['getUserID']             = 'Выражение SQL, обеспечивающее получение первичного ключа пользователя';
+$lang['delUser']               = 'Выражение SQL, осуществляющее удаление пользователя';
+$lang['delUserRefs']           = 'Выражение SQL, осуществляющее удаление пользователя из всех группы';
+$lang['updateUser']            = 'Выражение SQL, осуществляющее обновление профиля пользователя';
+$lang['UpdateLogin']           = 'Измените условие для обновления логина';
+$lang['UpdatePass']            = 'Измените условие для обновления пароля';
+$lang['UpdateEmail']           = 'Измените условие для обновления email';
+$lang['UpdateName']            = 'Условие для обновления полного имени пользователя';
+$lang['UpdateTarget']          = 'Выражение \'LIMIT\' для идентификации пользователя при обновлении';
+$lang['delUserGroup']          = 'Выражение SQL, осуществляющее удаление пользователя из указанной группы';
+$lang['getGroupID']            = 'Выражение SQL, обеспечивающее получение первичного ключа указанной группы';
diff --git a/wiki/lib/plugins/authpgsql/lang/sk/settings.php b/wiki/lib/plugins/authpgsql/lang/sk/settings.php
new file mode 100644
index 0000000..acdc2d7
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/sk/settings.php
@@ -0,0 +1,38 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Martin Michalek <michalek.dev@gmail.com>
+ */
+$lang['server']                = 'PostgreSQL server';
+$lang['port']                  = 'Port PostgreSQL servera';
+$lang['user']                  = 'Meno používateľa PostgreSQL';
+$lang['password']              = 'Heslo pre vyššie uvedeného používateľa';
+$lang['database']              = 'Použiť databázu';
+$lang['debug']                 = 'Zobraziť dodatočné ladiace informácie';
+$lang['forwardClearPass']      = 'Posielať heslo ako nezakódovaný text nižšie uvedenému SQL príkazu namiesto použitia kódovania';
+$lang['checkPass']             = 'SQL príkaz pre kontrolu hesla';
+$lang['getUserInfo']           = 'SQL príkaz pre získanie informácií o používateľovi';
+$lang['getGroups']             = 'SQL príkaz pre získanie informácií o skupinách používateľa';
+$lang['getUsers']              = 'SQL príkaz pre získanie zoznamu používateľov';
+$lang['FilterLogin']           = 'SQL podmienka pre filtrovanie používateľov podľa prihlasovacieho mena';
+$lang['FilterName']            = 'SQL podmienka pre filtrovanie používateľov podľa mena a priezviska';
+$lang['FilterEmail']           = 'SQL podmienka pre filtrovanie používateľov podľa emailovej adresy';
+$lang['FilterGroup']           = 'SQL podmienka pre filtrovanie používateľov podľa skupiny';
+$lang['SortOrder']             = 'SQL podmienka pre usporiadenia používateľov';
+$lang['addUser']               = 'SQL príkaz pre pridanie nového používateľa';
+$lang['addGroup']              = 'SQL príkaz pre pridanie novej skupiny';
+$lang['addUserGroup']          = 'SQL príkaz pre pridanie používateľa do existujúcej skupiny';
+$lang['delGroup']              = 'SQL príkaz pre zrušenie skupiny';
+$lang['getUserID']             = 'SQL príkaz pre získanie primárneho klúča používateľa';
+$lang['delUser']               = 'SQL príkaz pre zrušenie používateľa';
+$lang['delUserRefs']           = 'SQL príkaz pre vyradenie používateľa zo všetkých skupín';
+$lang['updateUser']            = 'SQL príkaz pre aktualizáciu informácií o používateľovi';
+$lang['UpdateLogin']           = 'SQL podmienka pre aktualizáciu prihlasovacieho mena používateľa';
+$lang['UpdatePass']            = 'SQL podmienka pre aktualizáciu hesla používateľa';
+$lang['UpdateEmail']           = 'SQL podmienka pre aktualizáciu emailovej adresy používateľa';
+$lang['UpdateName']            = 'SQL podmienka pre aktualizáciu mena a priezviska používateľa';
+$lang['UpdateTarget']          = 'Podmienka identifikácie používateľa pri aktualizácii';
+$lang['delUserGroup']          = 'SQL príkaz pre vyradenie používateľa z danej skupiny';
+$lang['getGroupID']            = 'SQL príkaz pre získanie primárneho kľúča skupiny';
diff --git a/wiki/lib/plugins/authpgsql/lang/sl/settings.php b/wiki/lib/plugins/authpgsql/lang/sl/settings.php
new file mode 100644
index 0000000..7110a6e
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/sl/settings.php
@@ -0,0 +1,16 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Matej Urbančič <mateju@svn.gnome.org>
+ */
+$lang['database']              = 'Podatkovna zbirka za uporabo';
+$lang['addUserGroup']          = 'Ukaz SQL za dodajanje uporabnika v obstoječo skupino';
+$lang['delGroup']              = 'Ukaz SQL za odstranitev skupine';
+$lang['getUserID']             = 'Ukaz SQL za pridobitev osnovnega ključa uporabnika';
+$lang['delUser']               = 'Ukaz SQL za izbris uporabnika';
+$lang['delUserRefs']           = 'Ukaz SQL za odstranitev uporabnika iz vseh skupin';
+$lang['updateUser']            = 'Ukaz SQL za posodobitev profila uporabnika';
+$lang['delUserGroup']          = 'Ukaz SQL za odstranitev uporabnika iz podane skupine';
+$lang['getGroupID']            = 'Ukaz SQL za pridobitev osnovnega ključa podane skupine';
diff --git a/wiki/lib/plugins/authpgsql/lang/sr/settings.php b/wiki/lib/plugins/authpgsql/lang/sr/settings.php
new file mode 100644
index 0000000..4b1cd8b
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/sr/settings.php
@@ -0,0 +1,18 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Марко М. Костић <marko.m.kostic@gmail.com>
+ */
+$lang['server']                = 'Ваш PostgreSQL сервер';
+$lang['port']                  = 'Порт вашег PostgreSQL сервера';
+$lang['user']                  = 'PostgreSQL корисничко име';
+$lang['password']              = 'Лозинка за корисника изнад';
+$lang['database']              = 'База коју треба користити';
+$lang['debug']                 = 'Прикажи додатне податке за поправљање грешака';
+$lang['forwardClearPass']      = 'Пренеси корисничке лозинке као чист текст ка SQL упитима испод уместо коришћења passcrypt опције';
+$lang['checkPass']             = 'SQL упит за проверу лозинки';
+$lang['getUserInfo']           = 'SQL упит за добављање корисничких података';
+$lang['getGroups']             = 'SQL упит за добављање групних учлањења корисника';
+$lang['getUsers']              = 'SQL упит за листање свих корисника';
diff --git a/wiki/lib/plugins/authpgsql/lang/sv/settings.php b/wiki/lib/plugins/authpgsql/lang/sv/settings.php
new file mode 100644
index 0000000..1082583
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/sv/settings.php
@@ -0,0 +1,29 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Smorkster Andersson smorkster@gmail.com
+ */
+$lang['server']                = 'Din PostgreSQL server';
+$lang['port']                  = 'Din PostgreSQL servers port';
+$lang['user']                  = 'PostgreSQL användarnamn';
+$lang['password']              = 'Lösenord för användaren ovan';
+$lang['database']              = 'Databas att använda';
+$lang['debug']                 = 'Visa ytterligare felsökningsinformation';
+$lang['forwardClearPass']      = 'Skicka lösenord för användare som klartext till SQL satserna nedan, istället för att använda krypteringsalternativet';
+$lang['checkPass']             = 'SQL sats för kontroll av lösenord';
+$lang['getUserInfo']           = 'SQL sats för att hämta användarinformation';
+$lang['getGroups']             = 'SQL sats för att hämta en användares gruppmedlemskap';
+$lang['getUsers']              = 'SQL sats för att lista alla användare';
+$lang['FilterLogin']           = 'SQL klausul för att filtrera användare efter inloggningsnamn';
+$lang['FilterName']            = 'SQL klausul för att filtrera användare efter fullt namn';
+$lang['FilterEmail']           = 'SQL klausul för att filtrera användare efter e-post adress';
+$lang['addUser']               = 'SQL sats för att lägga till en ny användare';
+$lang['addGroup']              = 'SQL sats för att lägga till en ny grupp';
+$lang['addUserGroup']          = 'SQL sats för att lägga till en användare i en existerande grupp';
+$lang['delGroup']              = 'SQL sats för att ta bort en grupp';
+$lang['delUser']               = 'SQL sats för att ta bort en användare';
+$lang['delUserRefs']           = 'SQL sats för att ta bort en användare från alla grupper';
+$lang['updateUser']            = 'SQL sats för att uppdatera en användarprofil';
+$lang['delUserGroup']          = 'SQL sats för att ta bort en användare från angiven grupp';
diff --git a/wiki/lib/plugins/authpgsql/lang/tr/settings.php b/wiki/lib/plugins/authpgsql/lang/tr/settings.php
new file mode 100644
index 0000000..f6fef9c
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/tr/settings.php
@@ -0,0 +1,13 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ * 
+ * @author İlker R. Kapaç <irifat@gmail.com>
+ */
+$lang['server']                = 'PostgreSQL sunucunuz';
+$lang['port']                  = 'PostgreSQL sunucunuzun kapısı (port)';
+$lang['user']                  = 'PostgreSQL kullanıcısının adı';
+$lang['password']              = 'Yukarıdaki kullanıcı için şifre';
+$lang['database']              = 'Kullanılacak veritabanı';
+$lang['debug']                 = 'İlave hata ayıklama bilgisini görüntüle';
diff --git a/wiki/lib/plugins/authpgsql/lang/uk/settings.php b/wiki/lib/plugins/authpgsql/lang/uk/settings.php
new file mode 100644
index 0000000..9a35341
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/uk/settings.php
@@ -0,0 +1,8 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author Nina Zolotova <nina-z@i.ua>
+ */
+$lang['database']              = 'Використовувати базу даних';
diff --git a/wiki/lib/plugins/authpgsql/lang/zh-tw/settings.php b/wiki/lib/plugins/authpgsql/lang/zh-tw/settings.php
new file mode 100644
index 0000000..b7dd9c6
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/zh-tw/settings.php
@@ -0,0 +1,38 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ * 
+ * @author syaoranhinata@gmail.com
+ */
+$lang['server']                = '您的 PostgreSQL 伺服器';
+$lang['port']                  = '您的 PostgreSQL 伺服器端口';
+$lang['user']                  = 'PostgreSQL 使用者名稱';
+$lang['password']              = '上述使用者的密碼';
+$lang['database']              = '使用的資料庫';
+$lang['debug']                 = '顯示額外除錯資訊';
+$lang['forwardClearPass']      = '以明文形式,把使用者密碼傳送给下列的 SQL 語句,而不使用 passcrypt 密碼加密選項';
+$lang['checkPass']             = '檢查密碼的 SQL 語句';
+$lang['getUserInfo']           = '獲取使用者訊息的 SQL 語句';
+$lang['getGroups']             = '獲取使用者群組成員身份的 SQL 語句';
+$lang['getUsers']              = '把所有使用者列出的 SQL 語句';
+$lang['FilterLogin']           = '根據登入名稱來篩選使用者的 SQL 子句';
+$lang['FilterName']            = '根據全名來篩選使用者的 SQL 子句';
+$lang['FilterEmail']           = '根據電郵地址來篩選使用者的 SQL 子句';
+$lang['FilterGroup']           = '根據群組成員身份來篩選使用者的 SQL 子句';
+$lang['SortOrder']             = '對使用者排序的 SQL 子句';
+$lang['addUser']               = '增加新使用者的 SQL 語句';
+$lang['addGroup']              = '增加新群組的 SQL 語句';
+$lang['addUserGroup']          = '把使用者新增至現有群組的 SQL 語句';
+$lang['delGroup']              = '把群組刪除的 SQL 語句';
+$lang['getUserID']             = '取得使用者主鍵的 SQL 語句';
+$lang['delUser']               = '把使用者刪除的 SQL 語句';
+$lang['delUserRefs']           = '把使用者從所有群組裏刪除的 SQL 語句';
+$lang['updateUser']            = '更新使用者訊息的 SQL 語句';
+$lang['UpdateLogin']           = '更新使用者登入名稱的 Update 子句';
+$lang['UpdatePass']            = '更新帳號密碼的 Update 子句';
+$lang['UpdateEmail']           = '更新使用者電郵地址的 Update 子句';
+$lang['UpdateName']            = '更新使用者全名的 Update 子句';
+$lang['UpdateTarget']          = '在更新時識別使用者的 Limit 子句';
+$lang['delUserGroup']          = '把使用者從指定群組中刪除的 SQL 語句';
+$lang['getGroupID']            = '取得指定群組主鍵的 SQL 語句';
diff --git a/wiki/lib/plugins/authpgsql/lang/zh/settings.php b/wiki/lib/plugins/authpgsql/lang/zh/settings.php
new file mode 100644
index 0000000..5140d11
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/lang/zh/settings.php
@@ -0,0 +1,38 @@
+<?php
+
+/**
+ * @license    GPL 2 (http://www.gnu.org/licenses/gpl.html)
+ *
+ * @author lainme <lainme993@gmail.com>
+ */
+$lang['server']                = '您的 PostgreSQL 服务器';
+$lang['port']                  = '您的 PostgreSQL 服务器端口';
+$lang['user']                  = 'PostgreSQL 用户名';
+$lang['password']              = '上述用户的密码';
+$lang['database']              = '使用的数据库';
+$lang['debug']                 = '显示额外调试信息';
+$lang['forwardClearPass']      = '将用户密码以明文形式传送给下面的 SQL 语句,而不使用 passcrypt 密码加密选项';
+$lang['checkPass']             = '检查密码的 SQL 语句';
+$lang['getUserInfo']           = '获取用户信息的 SQL 语句';
+$lang['getGroups']             = '获取用户的组成员身份的 SQL 语句';
+$lang['getUsers']              = '列出所有用户的 SQL 语句';
+$lang['FilterLogin']           = '根据登录名筛选用户的 SQL 子句';
+$lang['FilterName']            = '根据全名筛选用户的 SQL 子句';
+$lang['FilterEmail']           = '根据电子邮件地址筛选用户的 SQL 子句';
+$lang['FilterGroup']           = '根据组成员身份筛选用户的 SQL 子句';
+$lang['SortOrder']             = '对用户排序的 SQL 子句';
+$lang['addUser']               = '添加新用户的 SQL 语句';
+$lang['addGroup']              = '添加新组的 SQL 语句';
+$lang['addUserGroup']          = '将用户添加到现有组的 SQL 语句';
+$lang['delGroup']              = '删除组的 SQL 语句';
+$lang['getUserID']             = '获取用户主键的 SQL 语句';
+$lang['delUser']               = '删除用户的 SQL 语句';
+$lang['delUserRefs']           = '从所有组中删除一个用户的 SQL 语句';
+$lang['updateUser']            = '更新用户信息的 SQL 语句';
+$lang['UpdateLogin']           = '更新用户登录名的 Update 子句';
+$lang['UpdatePass']            = '更新用户密码的 Update 子句';
+$lang['UpdateEmail']           = '更新用户电子邮件地址的 Update 子句';
+$lang['UpdateName']            = '更新用户全名的 Update 子句';
+$lang['UpdateTarget']          = '更新时识别用户的 Limit 子句';
+$lang['delUserGroup']          = '从指定组删除用户的 SQL 语句';
+$lang['getGroupID']            = '获取指定组主键的 SQL 语句';
diff --git a/wiki/lib/plugins/authpgsql/plugin.info.txt b/wiki/lib/plugins/authpgsql/plugin.info.txt
new file mode 100644
index 0000000..033c291
--- /dev/null
+++ b/wiki/lib/plugins/authpgsql/plugin.info.txt
@@ -0,0 +1,7 @@
+base   authpgsql
+author Andreas Gohr
+email  andi@splitbrain.org
+date   2015-07-13
+name   [DEPRECATED] PostgreSQL Auth Plugin
+desc   ▶This plugin will be removed from DokuWiki in a future release! Use authpdo instead.◀ Provides user authentication against a PostgreSQL database
+url    http://www.dokuwiki.org/plugin:authpgsql