Reserved Download Area on Joomla 1.6
Posted: 26 Jan 2011, 19:34
I need to create a "download area" reserved to certains users. I'd like to allow some registered users (not every registered users) to access this Area. The new Joomla 1.6 allows the creation of new "level access".
So i installed J1.6 and PhocaDownload 2.0 and i created a new "User Group" and a new "Access Level". Then i created some categories in PhocaDownload. However, i could not grant the access to the user group or to the users of the new access level i created.
So the question: does PhocaDownload allows the creation of this kind of area? and if so: what's my mistake?
I reaport also a problem in PhocaDownloads users tab that show the following output:
So i installed J1.6 and PhocaDownload 2.0 and i created a new "User Group" and a new "Access Level". Then i created some categories in PhocaDownload. However, i could not grant the access to the user group or to the users of the new access level i created.
So the question: does PhocaDownload allows the creation of this kind of area? and if so: what's my mistake?
I reaport also a problem in PhocaDownloads users tab that show the following output:
Thank you allSELECT a.*,f.id as file_id,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,fa.countfaid,fn.countfnid
FROM jos_users AS a
LEFT JOIN jos_phocadownload AS f ON f.owner_id = a.id
LEFT JOIN jos_phocadownload_categories AS cc ON cc.id = f.catid
LEFT JOIN jos_users AS ua ON ua.id=f.owner_id
LEFT JOIN jos_users AS uc ON uc.id=f.checked_out
LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM jos_phocadownload AS fa WHERE fa.approved = 1 GROUP BY fa.owner_id) AS fa ON a.id = fa.owner_id
LEFT JOIN (SELECT fn.owner_id, fn.id, count(*) AS countfnid FROM jos_phocadownload AS fn WHERE fn.approved = 0 GROUP BY fn.owner_id) AS fn ON a.id = fn.owner_id
WHERE a.id > 0 AND (fa.countfaid > 0 OR fn.countfnid > 0)
GROUP BY a.id
ORDER BY uc.name asc
