<?php

class OC_USER_VD_DOMAIN{
	public static function getDomains(){
		$query=OC_DB::prepare('SELECT domain,GROUP_CONCAT(fqdn) as fqdn FROM *PREFIX*users_vd_domains GROUP BY domain');
		$result=$query->execute();
		$row=$result->fetchAll();
		if($row){
			return $row;
		}else{
			return false;
		}
	}

	public static function saveDomains($dom){
		if(is_array($dom)){
			$query=OC_DB::prepare('DELETE FROM *PREFIX*users_vd_domains');
			$query->execute();
		}else{
			return false;
		}
		$query=OC_DB::prepare('INSERT INTO *PREFIX*users_vd_domains (domain,fqdn) VALUES (?,?)');
		foreach($dom as $domain => $fqdn){
			$fqdn=explode(',',$fqdn);
			foreach($fqdn as $f){
				$result=$query->execute(array($domain,$f));
			}
		}
	}
}
?>