I have a SQL/PDO sequence which requests credentials from the OC database for authentication of users in a dokuwiki installation. The statement worked fine on OC 9 and needed some changes for OC 10 due to changes in the database structure.
Now on OC 10, I have to change the statement to get the hash value, currently I only get "NULL" with the old " substr(oc_authtoken.password, 3) as 'hash' . Can someone give me an idea where the hash value for the user is actually stored? I don't see it in oc_authtoken, oc_preferences, oc_credentials ...
The current statement for OC 10:
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'