Hi,
I had a database that stores usernames and passwords of users and used a PHP script in influx 1.8 to verify these credentials. I recently upgraded to influx 2.0 and can´t reach the data anymore. The problem seems to be in these command lines:
$userdb = new DBConnection(Databases::Users);
$result = $userdb->query(“SELECT * from user_logins where username=’$username’ limit 1”, [‘epoch’ => ‘ns’]);
I think it is the SELECT * from user_logins part because the databases are now mostly accessible through the UI . Is there a new command that can be used to get this information from the database?