Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- dokuwiki [15/11/2017 - 10:22] – thommie
+++ dokuwiki [05/03/2024 - 10:52] (aktuell) – Externe Bearbeitung 127.0.0.1
@@ 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>
-OC 9: Statement to select all groups of a single user
+===== 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 =====
@@ Zeile 25: / Zeile 31: @@
 </code>
-===== OC10: SQL Statement to select the data of a single user =====
+===== 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_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 =====
 <code>
@@ Zeile 41: / 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>