Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
dokuwiki [15/11/2017 - 10:22] – thommie | dokuwiki [17/08/2024 - 07:06] (aktuell) – Externe Bearbeitung 127.0.0.1 | ||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
- | ====== External authentication from OC through | + | ====== dokuJClient.jar ====== |
+ | |||
+ | https:// | ||
+ | |||
+ | ====== OAuth2 ====== | ||
+ | |||
+ | ====== External authentication from OC through | ||
[[https:// | [[https:// | ||
Zeile 13: | Zeile 19: | ||
</ | </ | ||
- | OC 9: Statement to select all groups of a single user | + | ===== OC 9: Statement to select all groups of a single user ===== |
< | < | ||
- | |||
SELECT oc_group_user.gid FROM oc_group_user WHERE oc_group_user.uid = ' | SELECT oc_group_user.gid FROM oc_group_user WHERE oc_group_user.uid = ' | ||
</ | </ | ||
+ | |||
===== OC 9: Statement to select all available groups ===== | ===== OC 9: Statement to select all available groups ===== | ||
Zeile 25: | Zeile 31: | ||
</ | </ | ||
- | ===== OC10: SQL Statement to select the data of a single user ===== | + | ===== OC10: PDO Statement to select the data of a single user ===== |
- | + | ||
- | < | + | |
- | SELECT oc_accounts.user_id as ' | + | |
- | oc_accounts.display_name as ' | + | |
- | oc_accounts.email as ' | + | |
- | substr(oc_authtoken.password, | + | |
- | WHERE oc_accounts.user_id LIKE ' | + | |
- | </ | + | |
- | + | ||
- | ===== OC10: in PDO ===== | + | |
< | < | ||
Zeile 41: | Zeile 37: | ||
" | " | ||
" | " | ||
- | " | + | " |
- | FROM "oc_accounts" LEFT JOIN "oc_authtoken" ON " | + | FROM "oc_users" LEFT JOIN "oc_users" ON " |
WHERE " | WHERE " | ||
</ | </ |