Thread: Dynamic DNS
View Single Post
  #3  
Old 18th September 2008, 20:21
omry omry is offline
Junior Member
 
Join Date: Sep 2008
Posts: 23
Thanks: 3
Thanked 3 Times in 3 Posts
Default

Quote:
Originally Posted by falko View Post
Is this an ISPConfig or MyDNSConfig question?
mathematically speaking, the answer is yes.
in other words, both.

This is what I ended up doing:
PHP Code:
$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 === falseerror(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?
Reply With Quote