AuthDrupal.pm has no reference to what Drupal version is to be used #25
Description
I cannot find any documentation on what Drupal version the interfaces are supposed to work with.
For Drupal 11.0.9 the druapl_tim sub in AuthDrupal.pm has to be adapted as it does not match the Drupal DB structure anymore, please see below.
Additionally, Drupal is apparently hashing the password differently now than before, thus sub Authenticate in AuthDrupal.pm is not able to authenticate anymore.
Please make required Drupal version explicit in documentation.
sub drupal_tim
{
(#) Periodic drupal maintenance
AE::log info => '- - - Periodic Drupal maintenance';
FunctionCall('DbDoSQL',
'INSERT INTO ovms_owners SELECT uid,name,mail,pass,status,0,utc_timestamp() FROM users_field_data '
. 'WHERE (users_field_data.uid NOT IN (SELECT owner FROM ovms_owners) AND users_field_data.uid != 0)');
# original query:
# 'INSERT INTO ovms_owners SELECT uid,name,mail,pass,status,0,utc_timestamp() FROM users '
# . 'WHERE users.uid NOT IN (SELECT owner FROM ovms_owners)');
FunctionCall('DbDoSQL',
'UPDATE ovms_owners LEFT JOIN users_field_data ON users_field_data.uid=ovms_owners.owner '
. 'SET ovms_owners.pass=users_field_data.pass, ovms_owners.status=users_field_data.status, ovms_owners.name=users_field_data.name, ovms_owners.mail=users_field_data.mail,'
. ' ovms_owners.deleted=0, ovms_owners.changed=UTC_TIMESTAMP() '
. 'WHERE users_field_data.pass<>ovms_owners.pass OR users_field_data.status<>ovms_owners.status OR users_field_data.name<>ovms_owners.name OR users_field_data.mail <> ovms_owners.mail');
# original query:
# 'UPDATE ovms_owners LEFT JOIN users ON users.uid=ovms_owners.owner '
# . 'SET ovms_owners.pass=users.pass, ovms_owners.status=users.status, ovms_owners.name=users.name, ovms_owners.mail=users.mail, '
# . ' ovms_owners.deleted=0, ovms_owners.changed=UTC_TIMESTAMP() '
# . 'WHERE users.pass<>ovms_owners.pass OR users.status<>ovms_owners.status OR users.name<>ovms_owners.name OR users.mail<>ovms_owners.mail');
FunctionCall('DbDoSQL',
'UPDATE ovms_owners SET deleted=1,changed=UTC_TIMESTAMP() WHERE deleted=0 AND owner NOT IN (SELECT uid FROM users_field_data)');
# original query:
# 'UPDATE ovms_owners SET deleted=1,changed=UTC_TIMESTAMP() WHERE deleted=0 AND owner NOT IN (SELECT uid FROM users)');
}