[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;