Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- dokuwiki [15/11/2017 - 10:17] – thommie
+++ dokuwiki [17/01/2018 - 11:57] – admin
@@ Zeile 1: / Zeile 1: @@
-====== External authentication from OC through Authpdo ======
+====== 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]]
@@ Zeile 13: / Zeile 19: @@
 </code>
-==== OC10: SQL Statement to select the data of a single user ====
+===== OC 9: Statement to select all groups of a single user =====
 <code>
-SELECT oc_accounts.user_id as 'user',
+SELECT oc_group_user.gid FROM oc_group_user WHERE oc_group_user.uid = 'thommie'
-oc_accounts.display_name as 'name',
-oc_accounts.email as 'mail',
-substr(oc_authtoken.password, 3) as 'hash' FROM oc_accounts LEFT JOIN oc_authtoken ON oc_accounts.user_id=oc_authtoken.uid
-WHERE oc_accounts.user_id LIKE 'xxxx'
 </code>
-\\
+===== OC 9: Statement to select all available groups =====
-OC10: in PDO
-SELECT "oc_accounts.user_id" as "user",\\
+<code>
-"oc_accounts.display_name" as "name",\\
+SELECT gid FROM `oc_groups` WHERE 1
-"oc_accounts.email" as "mail",\\
+</code>
-"substr(oc_authtoken.password, 3)" as "hash"\\
-FROM "oc_accounts" LEFT JOIN "oc_authtoken" ON "oc_accounts.user_id=oc_authtoken.uid"\\
+===== 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]]