Originally Posted by falko
Is this an ISPConfig or MyDNSConfig question?
mathematically speaking, the answer is yes.
in other words, both.
This is what I ended up doing:
$sql = "SELECT * FROM sys_user WHERE USERNAME = '$user' and ( PASSWORT = '".md5($pass)."' or PASSWORT = password('$pass') )";
$app->db->show_error_messages = true;
$dbuser = $app->db->queryOneRecord($sql);
if ($dbuser === false) error(403, "authentication failed");
$groups = $dbuser['groups'];
$id = $app->db->queryOneRecord("SELECT id FROM dns_rr WHERE name = '$domain' AND type = 'A' AND sys_groupid IN ($groups)");
I verify that the dns record row sys_groupid is one of the user groups.
what do you think?