INSERT INTO `eib_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6639367269303266666c646a62626135656d6b33366e68633133', 1, 1594766469, 0, '', 0)

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `eib_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

SELECT id, rules

  FROM `eib_viewlevels`

SELECT b.id

  FROM eib_usergroups AS a

  LEFT JOIN eib_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM eib_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

SELECT `path`

  FROM eib_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

SELECT `file`

  FROM eib_rsfirewall_hashes

  WHERE `type`='protect'

SELECT *

  FROM eib_rsfirewall_configuration

SHOW FULL COLUMNS 
  FROM `eib_rsfirewall_logs`

SELECT template

  FROM eib_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

SELECT template

  FROM eib_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

SELECT extension, file, type

  FROM eib_rokcommon_configs

  ORDER BY priority

SHOW FULL COLUMNS 
  FROM `eib_extensions`

SELECT `extension_id`

  FROM `eib_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

SELECT *

  FROM eib_extensions

  WHERE `extension_id` = '10159'

SELECT `extension_id`

  FROM `eib_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

SELECT *

  FROM eib_extensions

  WHERE `extension_id` = '10159'

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM eib_menu AS m

  LEFT JOIN eib_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

SELECT *

  FROM eib_rsfirewall_hashes

  WHERE (`type`='3.9.16' OR `type`='protect') 
  AND `flag`!='C'

SELECT *

  FROM eib_rsfirewall_snapshots

  WHERE `type`='protect'

SELECT `ip`,`reason`

  FROM eib_rsfirewall_lists

  WHERE (`ip`='3.236.121.68' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

SELECT `ip`,`reason`

  FROM eib_rsfirewall_lists

  WHERE (`ip`='3.236.121.68' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

SELECT *

  FROM eib_rsfirewall_exceptions

  WHERE `published`='1'

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `eib_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_competition','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_installer','com_jce','com_jch_optimize','com_joomailermailchimpintegration','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_redirect','com_redj','com_roksprocket','com_rsfirewall','com_rsform','com_search','com_tags','com_templates','com_users','com_widgetkit','com_wrapper')

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `eib_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

UPDATE `eib_extensions`

  SET `params` = '{\"mediaversion\":\"0bd8587e93e442448aac2d154b03be9d\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

SELECT *

  FROM eib_languages

  WHERE published=1

  ORDER BY ordering ASC