File manager - Edit - /home/opticamezl/www/newok/administrator/components/com_admin/sql/updates/mysql/4.0.3-2021-09-04.sql
Back
-- -- Delete the com_search package extension including its update site if no other -- com_search extension exists -- DELETE FROM `#__update_sites_extensions` WHERE `update_site_id` IN (SELECT `update_site_id` FROM `#__update_sites` WHERE `location` = 'https://raw.githubusercontent.com/joomla-extensions/search/main/manifest.xml') AND `extension_id` IN (SELECT `extension_id` FROM `#__extensions` WHERE `element` = 'pkg_search' AND `type` = 'package') AND (SELECT COUNT(a.`extension_id`) FROM `#__extensions` a WHERE (a.`type` = 'component' AND a.`element` = 'com_search') OR (a.`type` = 'module' AND a.`element` = 'mod_search' AND a.`client_id` = 0) OR (a.`type` = 'plugin' AND a.`element` IN ('categories', 'contacts', 'content', 'newsfeeds', 'tags') AND a.`folder` = 'search') ) = 0; DELETE FROM `#__update_sites` WHERE `location` = 'https://raw.githubusercontent.com/joomla-extensions/search/main/manifest.xml' AND (SELECT COUNT(a.`extension_id`) FROM `#__extensions` a WHERE (a.`type` = 'component' AND a.`element` = 'com_search') OR (a.`type` = 'module' AND a.`element` = 'mod_search' AND a.`client_id` = 0) OR (a.`type` = 'plugin' AND a.`element` IN ('categories', 'contacts', 'content', 'newsfeeds', 'tags') AND a.`folder` = 'search') ) = 0; DELETE FROM `#__extensions` WHERE `type` = 'package' AND `element` = 'pkg_search' AND (SELECT b.`count` FROM (SELECT COUNT(a.`extension_id`) AS `count` FROM `#__extensions` a WHERE (a.`type` = 'component' AND a.`element` = 'com_search') OR (a.`type` = 'module' AND a.`element` = 'mod_search' AND a.`client_id` = 0) OR (a.`type` = 'plugin' AND a.`element` IN ('categories', 'contacts', 'content', 'newsfeeds', 'tags') AND a.`folder` = 'search') ) b ) = 0;
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings