Agrandar Reducir Reiniciar

    Inicio arrow Archivos

Menú principal

Inicio
Eventos
Artículos
Gastronomía
Identificar setas
Clave dicotómica
Glosario
Socios
Histórico Eventos
Calendario Setero
Archivos

Setas de la galería

Formulario de acceso






¿Recuperar clave?

¿Quién está en línea?

Contador

Visitas ayer: 33
Visitas hoy: 43
Total Visitas: 11619
Bots Hoy: 24

Secciones

Agrupación Micológica A Zarrota :: Archivo Repository feed-icon-32x32.gif RSS

Contenedores Directorios/Archivos

folder_icons/folder_yellow.gif Sample

 (0/0)
Replace or modify this demonstration container as required
A Zarrota by A.E.S.
48 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT jaclplus FROM aza_core_acl_aro_groups WHERE group_id='29'
3
SELECT folder, element, published, params
 FROM aza_mambots
 WHERE published >= 1
 AND access IN ( 0 )
 AND folder = 'system'
 ORDER BY ordering
4
SELECT template
 FROM aza_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 75 )
 ORDER BY menuid DESC
LIMIT 0, 1
5
DELETE FROM aza_session
 WHERE (
 ( time < '1685309781' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1685309781' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT jaclplus FROM aza_core_acl_aro_groups WHERE group_id='29'
7
SELECT COUNT(*)
 FROM aza_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
8
UPDATE aza_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
9
SELECT COUNT(*)
 FROM aza_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
10
UPDATE aza_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
11
SELECT COUNT(*)
 FROM aza_stats_agents
 WHERE agent = 'com'
 AND type = 2
12
UPDATE aza_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'com'
 AND type = 2
13
SELECT *
 FROM aza_menu
 WHERE id = 75
14
SELECT * FROM aza_downloads_repository WHERE id=0
15
SELECT * FROM aza_downloads_containers ORDER BY sequence, name
16
SELECT count(f.id) FROM aza_downloads_files AS f  WHERE f.published=1
17
SELECT id FROM aza_menu WHERE link = 'index.php?option=com_remository'
18
SELECT a.*
 FROM aza_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
19
SELECT value FROM aza_jstats_configuration WHERE description = 'onlinetime'
20
SELECT exclude,type from aza_jstats_ipaddresses where ip='3.239.8.7' and useragent='ccbot/2.0 (https://commoncrawl.org/faq/)'
21
SELECT LENGTH( browser_string ) AS strlen, browser_string, browser_fullname FROM aza_jstats_browsers ORDER BY strlen DESC
22
SELECT LENGTH(bot_string) AS strlen, bot_string,bot_fullname FROM aza_jstats_bots ORDER BY strlen DESC
23
SELECT LENGTH(sys_string) AS strlen,sys_string,sys_fullname FROM aza_jstats_systems ORDER BY strlen DESC
24
insert into aza_jstats_ipaddresses (ip,nslookup,useragent,tld,system,browser,type) values ('3.239.8.7','ec2-3-239-8-7.compute-1.amazonaws.com','ccbot/2.0 (https://commoncrawl.org/faq/)','com','','Unknown robot (identified by crawl)',2)
25
SELECT id from aza_jstats_ipaddresses where ip='3.239.8.7' and useragent='ccbot/2.0 (https://commoncrawl.org/faq/)'
26
SELECT id from aza_jstats_visits WHERE month=MONTH(DATE_ADD(NOW(), INTERVAL 0 HOUR)) AND year=YEAR(DATE_ADD(NOW(), INTERVAL 0 HOUR)) AND ip_id='8565' and time >= DATE_ADD(DATE_ADD(NOW(), INTERVAL 0 HOUR), INTERVAL -10 MINUTE)
27
INSERT INTO aza_jstats_visits (ip_id,hour,day,month,year,time) values (8565,HOUR(DATE_ADD(NOW(), INTERVAL 0 HOUR)),DAYOFMONTH(DATE_ADD(NOW(), INTERVAL 0 HOUR)),MONTH(DATE_ADD(NOW(), INTERVAL 0 HOUR)),YEAR(DATE_ADD(NOW(), INTERVAL 0 HOUR)),DATE_ADD(NOW(), INTERVAL 0 HOUR))
28
SELECT page_id, page_title FROM aza_jstats_pages WHERE page='/index.php?option=com_remository&Itemid=75'
29
INSERT INTO aza_jstats_page_request (page_id,hour,day,month,year,ip_id) values (500,HOUR(DATE_ADD(NOW(), INTERVAL 0 HOUR)),DAYOFMONTH(DATE_ADD(NOW(), INTERVAL 0 HOUR)),MONTH(DATE_ADD(NOW(), INTERVAL 0 HOUR)),YEAR(DATE_ADD(NOW(), INTERVAL 0 HOUR)),19484)
30
SELECT id, title, module, position, content, showtitle, params
 FROM aza_modules AS m
 INNER JOIN aza_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.access IN ( 0 )
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = '75' )
 ORDER BY ordering
31
SELECT id, name, link, parent, type, menutype, access
 FROM aza_menu
 WHERE published = 1
 AND access IN ( 0 )
 ORDER BY menutype, parent, ordering
32
SELECT m.*
 FROM aza_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
33
SELECT m.*
 FROM aza_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
34
SELECT COUNT( id )
 FROM aza_menu 
 WHERE type = 'content_item_link'
 AND published = 1
35
SELECT id
 FROM aza_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=36'
36
SELECT guest, usertype
 FROM aza_session
37
SELECT SQL_BIG_RESULT count(*) FROM aza_jstats_visits LEFT JOIN aza_jstats_ipaddresses ON (aza_jstats_visits.ip_id=aza_jstats_ipaddresses.id) WHERE aza_jstats_ipaddresses.type=1 AND aza_jstats_visits.day=27 AND aza_jstats_visits.month=05 AND aza_jstats_visits.year=2023 GROUP by aza_jstats_visits.day
38
SELECT SQL_BIG_RESULT count(*) FROM aza_jstats_visits LEFT JOIN aza_jstats_ipaddresses ON (aza_jstats_visits.ip_id=aza_jstats_ipaddresses.id) WHERE aza_jstats_ipaddresses.type=1 AND aza_jstats_visits.day=28 AND aza_jstats_visits.month=5 AND aza_jstats_visits.year=2023 GROUP by aza_jstats_visits.day
39
SELECT SQL_BIG_RESULT count(*) FROM aza_jstats_visits LEFT JOIN aza_jstats_ipaddresses ON (aza_jstats_visits.ip_id=aza_jstats_ipaddresses.id) WHERE aza_jstats_ipaddresses.type=1
40
SELECT SQL_BIG_RESULT count(*) FROM aza_jstats_ipaddresses, aza_jstats_visits WHERE (aza_jstats_visits.ip_id = aza_jstats_ipaddresses.id) AND (aza_jstats_ipaddresses.browser !='') AND (aza_jstats_ipaddresses.type =2) AND (aza_jstats_visits.day LIKE '28') AND (aza_jstats_visits.month LIKE '5') AND (aza_jstats_visits.year LIKE '2023')
41
SELECT a.id AS id, a.title AS title, COUNT(b.id) as cnt
 FROM aza_sections as a
 LEFT JOIN aza_content as b ON a.id = b.sectionid
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2023-05-28 23:51' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2023-05-28 23:51' )
 WHERE a.scope = 'content'
 AND a.published = 1
 GROUP BY a.id
 HAVING COUNT( b.id ) > 0
 ORDER BY a.ordering
LIMIT 0, 5
42
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 5
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
43
SELECT id 
 FROM aza_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
44
SELECT id 
 FROM aza_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
45
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 4
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
46
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 6
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
47
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 1
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
48
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 2
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id