diff --git a/compat/auth/joomla.sql b/compat/auth/joomla.sql index 7c192c5..18feac4 100644 --- a/compat/auth/joomla.sql +++ b/compat/auth/joomla.sql @@ -1 +1 @@ -SELECT username FROM joomla_users WHERE (email=? OR username=?) AND password=CONCAT_WS(':', MD5(CONCAT(?, SUBSTRING_INDEX(SUBSTRING_INDEX(password, ':', 2), ':', -1))), SUBSTRING_INDEX(SUBSTRING_INDEX(password, ':', 2), ':', -1)) LIMIT 1 \ No newline at end of file +SELECT username FROM joomla_users WHERE (email=? OR username=?) AND password=CONCAT_WS(':', MD5(CONCAT(?, SUBSTRING_INDEX(SUBSTRING_INDEX(password, ':', 2), ':', -1))), SUBSTRING_INDEX(SUBSTRING_INDEX(password, ':', 2), ':', -1)) LIMIT 1