Back to PhocaDownloadAccess class

Method getCategoryAccessByFileId

public static
getCategoryAccessByFileId
(mixed $id)

Method getCategoryAccessByFileId - Source code

public static function getCategoryAccessByFileId($id)
{
    $output = array();
    $db = Factory::getDBO();
    $query = 'SELECT c.access, c.uploaduserid, c.deleteuserid' . ' FROM #__phocadownload_categories AS c' . ' LEFT JOIN #__phocadownload as a ON a.catid = c.id' . ' WHERE a.id = ' . (int) $id . ' ORDER BY c.id';
    $db->setQuery($query, 0, 1);
    $output = $db->loadObject();
    return $output;
}