>>>SELECT u.*, m.htmltitle, m.robots, m.keywords, m.description FROM #__remosef_uri AS u LEFT JOIN #__remosef_metadata AS m ON u.id = m.id WHERE u.uri = 'option=com_remository' AND CRC32('option=com_remository') = u.uri_crc ORDER BY u.refreshed DESC LIMIT 1<<>>SELECT role, access_id FROM #__assignments WHERE access_type = 'aUser' AND (access_id = '*' OR access_id = '0')<<<>>>SELECT role, control, action FROM #__permissions WHERE subject_type = '*' AND subject_id - '*'<<>>SELECT role, subject_id, action FROM #__permissions WHERE subject_type = 'remosFolder' AND action IN('download','edit')<<>>SELECT f.*, AVG(v.value) AS vote_value, COUNT(v.value) AS vote_count, 0 AS active_feature, c.name from #__downloads_files AS f INNER JOIN #__downloads_containers AS c ON f.containerid = c.id LEFT JOIN #__downloads_log AS v ON v.type=3 AND v.fileid=f.id AND v.value != 0 WHERE f.containerid IN (1) AND f.published != 0 AND NOW() >= f.publish_from AND (f.publish_to >= NOW() OR f.publish_to="0000-00-00 00:00:00") GROUP BY f.id ORDER BY f.filedate DESC LIMIT 10<<>>SELECT u.*, m.htmltitle, m.robots, m.keywords, m.description FROM #__remosef_uri AS u LEFT JOIN #__remosef_metadata AS m ON u.id = m.id WHERE u.uri = 'option=com_remository&func=fileinfo&id=1' AND CRC32('option=com_remository&func=fileinfo&id=1') = u.uri_crc ORDER BY u.refreshed DESC LIMIT 1<<< Recent Files Latest from our file repository https://aliro.org/downloads/ Fri, 29 Mar 2024 08:39:41 +0100 FeedCreator 1.7.2-ppt (info@mypapit.net) /components/com_remository/images/header.gif Recent Files https://aliro.org/downloads/ Aliro Project Site Aliro 2.0 https://aliro.org/downloads/aliro-builds/aliro-2.0-/ The Aliro Framework. Completely without all but a bare minimum of applications. Archived as .tar.gz (Aliro Builds) Sun, 28 Apr 2019 18:17:00 +0100 https://aliro.org/downloads/aliro-builds/aliro-2.0-/