====== dokuJClient.jar ======

https://github.com/gturri/dokujclient

====== OAuth2 ======

====== External authentication from OC through AuthPDO ======

[[https://www.dokuwiki.org/plugin:authpdo#configuration|https://www.dokuwiki.org/plugin:authpdo#configuration]]

===== OC9: SQL Statement to select the data of a single user =====

<code>
SELECT oc_users.uid AS 'id',
oc_users.displayname AS 'name',
oc_users.password AS 'pass',
oc_preferences.configvalue AS 'mail' FROM oc_users INNER JOIN oc_preferences ON oc_users.uid=oc_preferences.userid
WHERE oc_users.uid = 'admin' AND oc_preferences.configkey = 'email'
</code>

===== OC 9: Statement to select all groups of a single user =====

<code>
SELECT oc_group_user.gid FROM oc_group_user WHERE oc_group_user.uid = 'thommie'
</code>

===== OC 9: Statement to select all available groups =====

<code>
SELECT gid FROM `oc_groups` WHERE 1
</code>

===== OC10: PDO Statement to select the data of a single user =====

<code>
SELECT "oc_accounts.user_id" as "user",
"oc_accounts.display_name" as "name",
"oc_accounts.email" as "mail",
"substr(oc_users.password, 3)" as "hash"
FROM "oc_users" LEFT JOIN "oc_users" ON "oc_accounts.user_id=oc_users.uid"
WHERE "oc_accounts.user_id" LIKE :user
</code>

Owncloud Code hasher: [[https://github.com/owncloud/core/blob/master/lib/private/Security/Hasher.php|https://github.com/owncloud/core/blob/master/lib/private/Security/Hasher.php]]