SELECT *
FROM jos_session
WHERE session_id = 'pj80rcq9o7v649r4btleqelq46'
DELETE
FROM jos_session
WHERE ( TIME < '1722048454' )
SELECT *
FROM jos_session
WHERE session_id = 'pj80rcq9o7v649r4btleqelq46'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'pj80rcq9o7v649r4btleqelq46','1722049354','','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 *
FROM `jos_rsfirewall_configuration`
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND menuid = 0
ORDER BY menuid DESC
LIMIT 0, 1
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND menuid = 0
ORDER BY menuid DESC
LIMIT 0, 1
SELECT `extension`, `file`, `type`
FROM `jos_rokcommon_configs`
ORDER BY `priority`
SELECT `ip`
FROM jos_rsfirewall_lists
WHERE (`ip`='18.225.255.208' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'
SELECT `ip`
FROM jos_rsfirewall_lists
WHERE (`ip`='18.225.255.208' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'
SELECT `ip`, `reason`
FROM jos_rsfirewall_lists
WHERE (`ip`='18.225.255.208' OR `ip` LIKE '%*%')
AND `type`='0'
AND `published`='1'
SELECT *
FROM jos_rsfirewall_hashes
WHERE `type`='1.5.26'
SELECT *
FROM jos_rsfirewall_hashes
WHERE `type`='1.5.26'
SELECT *
FROM jos_rsfirewall_hashes
WHERE `type`='protect'
SELECT *
FROM jos_rsfirewall_hashes
WHERE `type`='protect'
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 `ip`
FROM jos_rsfirewall_lists
WHERE (`ip`='18.225.255.208' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'
SELECT `ip`
FROM jos_rsfirewall_lists
WHERE (`ip`='18.225.255.208' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 178)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT id, parent_id, VALUE, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=23
SELECT id
FROM jos_k2_categories
WHERE published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE id = '47'
SELECT *
FROM jos_k2_categories
WHERE parent=47
AND published=1
AND trash=0
AND access<=0
ORDER BY id ASC
SELECT id
FROM jos_k2_categories
WHERE parent IN (47)
AND id NOT IN (47)
AND published=1
AND trash=0
AND access<=0
SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jos_k2_items AS i RIGHT JOIN jos_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 0
AND i.trash = 0
AND c.published = 1
AND c.access <= 0
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-07-27 03:02:34' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-07-27 03:02:34' )
AND c.id IN (47)
ORDER BY i.created DESC
LIMIT 0, 20
SELECT COUNT(*)
FROM jos_k2_items AS i RIGHT JOIN jos_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 0
AND i.trash = 0
AND c.published = 1
AND c.access <= 0
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-07-27 03:02:34' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-07-27 03:02:34' )
AND c.id IN (47)
SELECT tag.*
FROM jos_k2_tags AS tag
JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 159
ORDER BY xref.id ASC
SELECT *
FROM jos_users
WHERE id = '62'
SELECT id, gender, description, image, url, `group`, plugins
FROM jos_k2_users
WHERE userID=62
SELECT COUNT(*)
FROM jos_k2_comments
WHERE itemID=159
AND published=1
SELECT g.*
FROM jos_core_acl_aro_groups AS g
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN jos_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.VALUE='62'
ORDER BY g.id
SELECT *
FROM jos_jcomments_settings
SELECT COUNT(*)
FROM jos_jcomments AS c
WHERE c.object_id = 159
AND c.object_group = 'com_k2'
AND c.published = 1
SELECT tag.*
FROM jos_k2_tags AS tag
JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 155
ORDER BY xref.id ASC
SELECT COUNT(*)
FROM jos_k2_comments
WHERE itemID=155
AND published=1
SELECT COUNT(*)
FROM jos_jcomments AS c
WHERE c.object_id = 155
AND c.object_group = 'com_k2'
AND c.published = 1
SELECT tag.*
FROM jos_k2_tags AS tag
JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 107
ORDER BY xref.id ASC
SELECT COUNT(*)
FROM jos_k2_comments
WHERE itemID=107
AND published=1
SELECT COUNT(*)
FROM jos_jcomments AS c
WHERE c.object_id = 107
AND c.object_group = 'com_k2'
AND c.published = 1
SELECT tag.*
FROM jos_k2_tags AS tag
JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 104
ORDER BY xref.id ASC
SELECT COUNT(*)
FROM jos_k2_comments
WHERE itemID=104
AND published=1
SELECT COUNT(*)
FROM jos_jcomments AS c
WHERE c.object_id = 104
AND c.object_group = 'com_k2'
AND c.published = 1
SELECT tag.*
FROM jos_k2_tags AS tag
JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 103
ORDER BY xref.id ASC
SELECT COUNT(*)
FROM jos_k2_comments
WHERE itemID=103
AND published=1
SELECT COUNT(*)
FROM jos_jcomments AS c
WHERE c.object_id = 103
AND c.object_group = 'com_k2'
AND c.published = 1
SELECT tag.*
FROM jos_k2_tags AS tag
JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 102
ORDER BY xref.id ASC
SELECT COUNT(*)
FROM jos_k2_comments
WHERE itemID=102
AND published=1
SELECT COUNT(*)
FROM jos_jcomments AS c
WHERE c.object_id = 102
AND c.object_group = 'com_k2'
AND c.published = 1
SELECT params
FROM jos_components AS c
WHERE c.OPTION='com_widgetkit'
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 = 178 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
Disaster management demands rapid response, and careful coordination of workers in the field. Mobile technology has the potential to provide important tools to first responders to help mitigate the effects of disasters. Working with a county in the state of Michigan, we have been investigating the use is iOS and Android devices in combination with ArcGIS Online to help improve disaster management efforts.