Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- dokuwiki [15/11/2017 - 10:18] – [OC10: SQL Statement to select the data of a single user] 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>
-===== OC10: in PDO =====
+===== 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>
@@ Zeile 29: / Zeile 37: @@
 "oc_accounts.display_name" as "name",
 "oc_accounts.email" as "mail",
-"substr(oc_authtoken.password, 3)" as "hash"
+"substr(oc_users.password, 3)" as "hash"
-FROM "oc_accounts" LEFT JOIN "oc_authtoken" ON "oc_accounts.user_id=oc_authtoken.uid"
+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]]