[Summary view] [Print] [Text view]

   1  --
   2  -- Delete the com_search package extension including its update site if no other
   3  -- com_search extension exists
   4  --
   5  DELETE FROM `#__update_sites_extensions`
   6   WHERE `update_site_id` IN (SELECT `update_site_id` FROM `#__update_sites` WHERE `location` = 'https://raw.githubusercontent.com/joomla-extensions/search/main/manifest.xml')
   7     AND `extension_id` IN (SELECT `extension_id` FROM `#__extensions` WHERE `element` = 'pkg_search' AND `type` = 'package')
   8     AND (SELECT COUNT(a.`extension_id`)
   9            FROM `#__extensions` a
  10           WHERE (a.`type` = 'component' AND a.`element` = 'com_search')
  11              OR (a.`type` = 'module' AND a.`element` = 'mod_search' AND a.`client_id` = 0)
  12              OR (a.`type` = 'plugin' AND a.`element` IN ('categories', 'contacts', 'content', 'newsfeeds', 'tags') AND a.`folder` = 'search')
  13         ) = 0;
  14  
  15  DELETE FROM `#__update_sites`
  16   WHERE `location` = 'https://raw.githubusercontent.com/joomla-extensions/search/main/manifest.xml'
  17     AND (SELECT COUNT(a.`extension_id`)
  18            FROM `#__extensions` a
  19           WHERE (a.`type` = 'component' AND a.`element` = 'com_search')
  20              OR (a.`type` = 'module' AND a.`element` = 'mod_search' AND a.`client_id` = 0)
  21              OR (a.`type` = 'plugin' AND a.`element` IN ('categories', 'contacts', 'content', 'newsfeeds', 'tags') AND a.`folder` = 'search')
  22         ) = 0;
  23  
  24  DELETE FROM `#__extensions`
  25   WHERE `type` = 'package' AND `element` = 'pkg_search'
  26     AND (SELECT b.`count`
  27            FROM (SELECT COUNT(a.`extension_id`) AS `count`
  28                    FROM `#__extensions` a
  29                   WHERE (a.`type` = 'component' AND a.`element` = 'com_search')
  30                      OR (a.`type` = 'module' AND a.`element` = 'mod_search' AND a.`client_id` = 0)
  31                      OR (a.`type` = 'plugin' AND a.`element` IN ('categories', 'contacts', 'content', 'newsfeeds', 'tags') AND a.`folder` = 'search')
  32                 ) b
  33         ) = 0;