/** * get accessible domains for given user * * @param integer $userID * @return array */ public static function getAccessibleDomains($userID = 0) { $data = array(); if ($userID === 0 && self::isLoggedIn()) { if (DNS::getSession()->userID !== null) { $userID = DNS::getSession()->userID; } if (self::isAdmin()) { $res = DNS::getDB()->query("SELECT * FROM dns_soa"); while ($row = DNS::getDB()->fetch_array($res)) { $data[] = $row['id']; } return $data; } } $res = DNS::getDB()->query("SELECT * FROM dns_soa_to_user WHERE userID = ?", array($userID)); while ($row = DNS::getDB()->fetch_array($res)) { $data[] = $row['soaID']; } return $data; }
/** * destroy the session */ public function destroy() { $this->sessionData = array(); $sql = "DELETE FROM dns_session WHERE sessionID = ?"; DNS::getDB()->query($sql, array($this->sessionID)); }