SELECT *
FROM jos_session
WHERE session_id = '5u80tah18jeum524al5npe1ts1'
DELETE
FROM jos_session
WHERE ( TIME < '1713533680' )
SELECT *
FROM jos_session
WHERE session_id = '5u80tah18jeum524al5npe1ts1'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '5u80tah18jeum524al5npe1ts1','1713534580','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM jos_downloads_repository
ORDER BY id
LIMIT 1
SELECT DISTINCT ROLE
FROM jos_assignments UNION SELECT DISTINCT ROLE
FROM jos_permissions
SELECT ROLE, subject_id, action
FROM jos_permissions
WHERE subject_type = 'remosFolder'
AND action IN('download','edit')
SELECT COUNT(*)
FROM jos_downloads_repository
UPDATE jos_downloads_repository
SET name='', alias='', version='', Use_Database='1', Main_Page_Title='Remository', tabclass='sectiontableentry2,sectiontableentry1', tabheader='sectiontableheader', headerpic='http://localhost/www.cifppiambello.it/components/com_remository/images/header.gif', ExtsOk='txt,exe,tar,gz,rar,zip,png,gif,jpg,pdf,doc,rtf,odt,odc,odp,odg,mp3,mov', ExtsDisplay='', ExtsAudio='', ExtsVideo='', Classification_Types='', Scribd='', Down_Path='/web/htdocs/www.cifppiambello.it/home/remos_downloads', Up_Path='/web/htdocs/www.cifppiambello.it/home//remos_downloads/uploads', Large_Text_Len='300', Small_Text_Len='150', Small_Image_Width='100', Small_Image_Height='100', Large_Image_Width='600', Large_Image_Height='600', Allow_Large_Images='1', Activate_AEC='0', Remository_Pathway='1', MaxSize='5000', Max_Up_Per_Day='5', Max_Down_Per_Day='5', Max_Down_Reg_Day='10', Max_Down_File_Day='5', Count_Down='0', Featured_Number='0', Max_Up_Dir_Space='50000', Favourites_Max='0', Max_Thumbnails='1', Min_Comment_length='1', Make_Auto_Thumbnail='0', Default_Version='', Main_Authors='', Author_Threshold='0', Date_Format='d M Y', Set_date_locale='', Force_Language='', Show_all_containers='0', Show_SubCategories='0', Anti_Leach='0', Allow_Up_Overwrite='0', Allow_User_Sub='0', Allow_User_Edit='0', Allow_User_Delete='0', Allow_User_Up='0', Enable_Admin_Autoapp='1', Enable_User_Autoapp='0', Allow_Comments='0', Allow_Votes='0', Enable_List_Download='0', Audio_Download='0', Video_Download='0', User_Remote_Files='0', See_Containers_no_download='1', See_Files_no_download='1', Show_RSS_feeds='0', Allow_File_Info='1', Show_Footer='1', Show_File_Folder_Counts='1', Display_PageHeading='1', Display_FolderListHeading='1', Display_FolderIcons='1', Display_FileIcons='1', Display_FileListHeading='1', Send_Sub_Mail='1', Sub_Mail_Alt_Addr='', Sub_Mail_Alt_Name='', Time_Stamp='1136491012', Profile_URI='', download_text='<script type=\"text/javascript\"><!--\r\ngoogle_ad_client = \"pub-9523985668336222\";\r\ngoogle_ad_width = 300;\r\ngoogle_ad_height = 250;\r\ngoogle_ad_format = \"300x250_as\";\r\ngoogle_ad_type = \"image\";\r\ngoogle_ad_channel =\"\";\r\n//--></script>\r\n<script type=\"text/javascript\"\r\nsrc=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\">\r\n</script>', preamble='', Default_Licence='', customizer='a:6:{s:1:\"A\";a:14:{i:0;i:1;i:1;i:0;i:2;i:1;i:3;i:1;i:4;i:1;i:5;i:1;i:6;i:0;i:7;i:0;i:8;i:0;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:0;}s:1:\"B\";a:14:{i:0;i:1;i:1;i:0;i:2;i:1;i:3;i:1;i:4;i:1;i:5;i:1;i:6;i:0;i:7;i:0;i:8;i:0;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:0;}s:1:\"C\";a:14:{i:0;i:1;i:1;i:0;i:2;i:1;i:3;i:1;i:4;i:1;i:5;i:1;i:6;i:0;i:7;i:0;i:8;i:0;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:0;}s:1:\"D\";a:14:{i:0;i:1;i:1;i:0;i:2;i:1;i:3;i:1;i:4;i:1;i:5;i:1;i:6;i:1;i:7;i:1;i:8;i:1;i:9;i:1;i:10;i:1;i:11;i:1;i:12;i:1;i:13;i:1;}s:1:\"E\";a:14:{i:0;i:1;i:1;i:0;i:2;i:0;i:3;i:0;i:4;i:0;i:5;i:0;i:6;i:1;i:7;i:1;i:8;i:1;i:9;i:1;i:10;i:0;i:11;i:1;i:12;i:1;i:13;i:0;}s:1:\"S\";a:14:{i:0;i:10;i:1;i:20;i:2;i:30;i:3;i:40;i:4;i:50;i:5;i:60;i:6;i:70;i:7;i:80;i:8;i:90;i:9;i:100;i:10;i:110;i:11;i:120;i:12;i:130;i:13;i:140;}}', custom_names='', template='default', Cron_Timer='1713534580', Real_With_ID='1', Immediate_Download='0', Use_CMS_Groups='0', SEQUENCE='0', windowtitle='', keywords=''
WHERE id=1
SELECT f.*, AVG(l.VALUE) AS vote_value, COUNT(l.VALUE) AS vote_count
FROM jos_downloads_files AS f
LEFT JOIN jos_downloads_log AS l
ON l.TYPE=3
AND l.fileid=f.id
WHERE f.id = 2
AND published=1
GROUP BY f.id
SELECT COUNT(*)
FROM `jos_permissions`
WHERE `subject_type`='remosFolder'
AND (`action`='download' OR `action`='*')
SELECT `role`, `control`, `subject_id`, `action`
FROM `jos_permissions`
WHERE `subject_type`='remosFolder'
AND (`action`='download' OR `action`='*')
SELECT fileid, COUNT(fileid) AS NUMBER
FROM jos_downloads_log
WHERE TYPE = 1
AND ipaddress = '3.129.247.196'
AND DATE > SUBDATE(NOW(), INTERVAL 24 HOUR)
GROUP BY fileid
SELECT COUNT(*)
FROM jos_downloads_containers
SELECT *
FROM jos_downloads_containers
LIMIT 0, 1000
SELECT link
FROM jos_menu
WHERE id = 32
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder, (CASE TYPE WHEN 'url' THEN 2 ELSE 1 END) typorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND TYPE LIKE 'component%'
AND published=1
ORDER BY typorder, menorder
SELECT c.*, CASE WHEN c.TYPE = '' THEN 0 ELSE 9 END AS typseq
FROM jos_downloads_classify AS c
INNER JOIN jos_downloads_file_classify AS fc
ON c.id = fc.classify_id
WHERE c.published != 0
AND c.hidden = 0
AND fc.file_id = 2
ORDER BY typseq, c.name
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 32)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 32 OR mm.menuid = 0 )
ORDER BY POSITION, ordering