Gerenciador & Editor PHP

📝 Editando: format-highlight.html

<pre style="color: black; background-color: white;">SELECT 
 customer_id, 
 customer_name, 
 COUNT(order_id) as total 
FROM 
 customers 
 INNER JOIN orders ON customers.customer_id = orders.customer_id 
GROUP BY 
 customer_id, 
 customer_name 
HAVING 
 COUNT(order_id) &gt; 5 
ORDER BY 
 COUNT(order_id) DESC;</pre>

<pre style="color: black; background-color: white;">UPDATE 
 customers 
SET 
 totalorders = ordersummary.total 
FROM 
 (
 SELECT 
 customer_id, 
 count(order_id) As total 
 FROM 
 orders 
 GROUP BY 
 customer_id
 ) As ordersummary 
WHERE 
 customers.customer_id = ordersummary.customer_id</pre>

<pre style="color: black; background-color: white;">SELECT 
 * 
FROM 
 sometable 
UNION ALL 
SELECT 
 * 
FROM 
 someothertable;</pre>

<pre style="color: black; background-color: white;">SET 
 NAMES 'utf8';</pre>

<pre style="color: black; background-color: white;">CREATE TABLE `PREFIX_address` (
 `id_address` int(10) unsigned NOT NULL auto_increment, 
 `id_country` int(10) unsigned NOT NULL, 
 `id_state` int(10) unsigned default NULL, 
 `id_customer` int(10) unsigned NOT NULL default '0', 
 `id_manufacturer` int(10) unsigned NOT NULL default '0', 
 `id_supplier` int(10) unsigned NOT NULL default '0', 
 `id_warehouse` int(10) unsigned NOT NULL default '0', 
 `alias` varchar(32) NOT NULL, 
 `company` varchar(64) default NULL, 
 `lastname` varchar(32) NOT NULL, 
 `firstname` varchar(32) NOT NULL, 
 `address1` varchar(128) NOT NULL, 
 `address2` varchar(128) default NULL, 
 `postcode` varchar(12) default NULL, 
 `city` varchar(64) NOT NULL, 
 `other` text, 
 `phone` varchar(16) default NULL, 
 `phone_mobile` varchar(16) default NULL, 
 `vat_number` varchar(32) default NULL, 
 `dni` varchar(16) DEFAULT NULL, 
 `date_add` datetime NOT NULL, 
 `date_upd` datetime NOT NULL, 
 `active` tinyint(1) unsigned NOT NULL default '1', 
 `deleted` tinyint(1) unsigned NOT NULL default '0', 
 PRIMARY KEY (`id_address`), 
 KEY `address_customer` (`id_customer`), 
 KEY `id_country` (`id_country`), 
 KEY `id_state` (`id_state`), 
 KEY `id_manufacturer` (`id_manufacturer`), 
 KEY `id_supplier` (`id_supplier`), 
 KEY `id_warehouse` (`id_warehouse`)
) ENGINE = ENGINE_TYPE DEFAULT CHARSET = utf8</pre>

<pre style="color: black; background-color: white;">CREATE TABLE `PREFIX_carrier` (
 `id_carrier` int(10) unsigned NOT NULL AUTO_INCREMENT, 
 `id_reference` int(10) unsigned NOT NULL, 
 `id_tax_rules_group` int(10) unsigned DEFAULT '0', 
 `name` varchar(64) NOT NULL, 
 `url` varchar(255) DEFAULT NULL, 
 `active` tinyint(1) unsigned NOT NULL DEFAULT '0', 
 `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0', 
 `shipping_handling` tinyint(1) unsigned NOT NULL DEFAULT '1', 
 `range_behavior` tinyint(1) unsigned NOT NULL DEFAULT '0', 
 `is_module` tinyint(1) unsigned NOT NULL DEFAULT '0', 
 `is_free` tinyint(1) unsigned NOT NULL DEFAULT '0', 
 `shipping_external` tinyint(1) unsigned NOT NULL DEFAULT '0', 
 `need_range` tinyint(1) unsigned NOT NULL DEFAULT '0', 
 `external_module_name` varchar(64) DEFAULT NULL, 
 `shipping_method` int(2) NOT NULL DEFAULT '0', 
 `position` int(10) unsigned NOT NULL default '0', 
 `max_width` int(10) DEFAULT 0, 
 `max_height` int(10) DEFAULT 0, 
 `max_depth` int(10) DEFAULT 0, 
 `max_weight` int(10) DEFAULT 0, 
 `grade` int(10) DEFAULT 0, 
 PRIMARY KEY (`id_carrier`), 
 KEY `deleted` (`deleted`, `active`), 
 KEY `id_tax_rules_group` (`id_tax_rules_group`)
) ENGINE = ENGINE_TYPE DEFAULT CHARSET = utf8</pre>

<pre style="color: black; background-color: white;">CREATE TABLE IF NOT EXISTS `PREFIX_specific_price_rule` (
 `id_specific_price_rule` int(10) unsigned NOT NULL AUTO_INCREMENT, 
 `name` VARCHAR(255) NOT NULL, 
 `id_shop` int(11) unsigned NOT NULL DEFAULT '1', 
 `id_currency` int(10) unsigned NOT NULL, 
 `id_country` int(10) unsigned NOT NULL, 
 `id_group` int(10) unsigned NOT NULL, 
 `from_quantity` mediumint(8) unsigned NOT NULL, 
 `price` DECIMAL(20, 6), 
 `reduction` decimal(20, 6) NOT NULL, 
 `reduction_type` enum('amount', 'percentage') NOT NULL, 
 `from` datetime NOT NULL, 
 `to` datetime NOT NULL, 
 PRIMARY KEY (`id_specific_price_rule`), 
 KEY `id_product` (
 `id_shop`, `id_currency`, `id_country`, 
 `id_group`, `from_quantity`, `from`, 
 `to`
 )
) ENGINE = ENGINE_TYPE DEFAULT CHARSET = utf8</pre>

<pre style="color: black; background-color: white;">UPDATE 
 `PREFIX_configuration` 
SET 
 value = '6' 
WHERE 
 name = 'PS_SEARCH_WEIGHT_PNAME'</pre>

<pre style="color: black; background-color: white;">UPDATE 
 `PREFIX_hook_module` 
SET 
 position = 1 
WHERE 
 id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'displayPayment'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'cheque'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'displayPaymentReturn'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'cheque'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'displayHome'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'homeslider'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'actionAuthentication'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'statsdata'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'actionShopDataDuplication'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'homeslider'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'displayTop'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'blocklanguages'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'actionCustomerAccountAdd'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'statsdata'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'displayCustomerAccount'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'favoriteproducts'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'displayAdminStatsModules'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'statsvisits'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'displayAdminStatsGraphEngine'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'graphvisifire'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'displayAdminStatsGridEngine'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'gridhtml'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'displayLeftColumnProduct'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'blocksharefb'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'actionSearch'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'statssearch'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'actionCategoryAdd'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'blockcategories'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'actionCategoryUpdate'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'blockcategories'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'actionCategoryDelete'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'blockcategories'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'actionAdminMetaSave'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'blockcategories'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'displayMyAccountBlock'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'favoriteproducts'
 ) 
 OR id_hook = (
 SELECT 
 id_hook 
 FROM 
 `PREFIX_hook` 
 WHERE 
 name = 'displayFooter'
 ) 
 AND id_module = (
 SELECT 
 id_module 
 FROM 
 `PREFIX_module` 
 WHERE 
 name = 'blockreinsurance'
 )</pre>

<pre style="color: black; background-color: white;">ALTER TABLE 
 `PREFIX_employee` 
ADD 
 `bo_color` varchar(32) default NULL 
AFTER 
 `stats_date_to`</pre>

<pre style="color: black; background-color: white;">INSERT INTO `PREFIX_cms_category_lang` 
VALUES 
 (
 1, 3, 'Inicio', '', 'home', NULL, NULL, 
 NULL
 )</pre>

<pre style="color: black; background-color: white;">INSERT INTO `PREFIX_cms_category` 
VALUES 
 (1, 0, 0, 1, NOW(), NOW(), 0)</pre>

<pre style="color: black; background-color: white;">UPDATE 
 `PREFIX_cms_category` 
SET 
 `position` = 0</pre>

<pre style="color: black; background-color: white;">ALTER TABLE 
 `PREFIX_customer` 
ADD 
 `note` text 
AFTER 
 `secure_key`</pre>

<pre style="color: black; background-color: white;">ALTER TABLE 
 `PREFIX_contact` 
ADD 
 `customer_service` tinyint(1) NOT NULL DEFAULT 0 
AFTER 
 `email`</pre>

<pre style="color: black; background-color: white;">INSERT INTO `PREFIX_specific_price` (
 `id_product`, `id_shop`, `id_currency`, 
 `id_country`, `id_group`, `priority`, 
 `price`, `from_quantity`, `reduction`, 
 `reduction_type`, `from`, `to`
) (
 SELECT 
 dq.`id_product`, 
 1, 
 1, 
 0, 
 1, 
 0, 
 0.00, 
 dq.`quantity`, 
 IF(
 dq.`id_discount_type` = 2, dq.`value`, 
 dq.`value` / 100
 ), 
 IF (
 dq.`id_discount_type` = 2, 'amount', 
 'percentage'
 ), 
 '0000-00-00 00:00:00', 
 '0000-00-00 00:00:00' 
 FROM 
 `PREFIX_discount_quantity` dq 
 INNER JOIN `PREFIX_product` p ON (p.`id_product` = dq.`id_product`)
)</pre>

<pre style="color: black; background-color: white;">DROP 
 TABLE `PREFIX_discount_quantity`</pre>

<pre style="color: black; background-color: white;">INSERT INTO `PREFIX_specific_price` (
 `id_product`, `id_shop`, `id_currency`, 
 `id_country`, `id_group`, `priority`, 
 `price`, `from_quantity`, `reduction`, 
 `reduction_type`, `from`, `to`
) (
 SELECT 
 p.`id_product`, 
 1, 
 0, 
 0, 
 0, 
 0, 
 0.00, 
 1, 
 IF(
 p.`reduction_price` &gt; 0, p.`reduction_price`, 
 p.`reduction_percent` / 100
 ), 
 IF(
 p.`reduction_price` &gt; 0, 'amount', 
 'percentage'
 ), 
 IF (
 p.`reduction_from` = p.`reduction_to`, 
 '0000-00-00 00:00:00', p.`reduction_from`
 ), 
 IF (
 p.`reduction_from` = p.`reduction_to`, 
 '0000-00-00 00:00:00', p.`reduction_to`
 ) 
 FROM 
 `PREFIX_product` p 
 WHERE 
 p.`reduction_price` 
 OR p.`reduction_percent`
)</pre>

<pre style="color: black; background-color: white;">ALTER TABLE 
 `PREFIX_product` 
DROP 
 `reduction_price`, 
DROP 
 `reduction_percent`, 
DROP 
 `reduction_from`, 
DROP 
 `reduction_to`</pre>

<pre style="color: black; background-color: white;">INSERT INTO `PREFIX_configuration` (
 `name`, `value`, `date_add`, `date_upd`
) 
VALUES 
 (
 'PS_SPECIFIC_PRICE_PRIORITIES', 
 'id_shop;id_currency;id_country;id_group', 
 NOW(), NOW()
 ), 
 ('PS_TAX_DISPLAY', 0, NOW(), NOW()), 
 (
 'PS_SMARTY_FORCE_COMPILE', 1, NOW(), 
 NOW()
 ), 
 (
 'PS_DISTANCE_UNIT', 'km', NOW(), NOW()
 ), 
 (
 'PS_STORES_DISPLAY_CMS', 0, NOW(), 
 NOW()
 ), 
 (
 'PS_STORES_DISPLAY_FOOTER', 0, NOW(), 
 NOW()
 ), 
 (
 'PS_STORES_SIMPLIFIED', 0, NOW(), 
 NOW()
 ), 
 (
 'PS_STATSDATA_CUSTOMER_PAGESVIEWS', 
 1, NOW(), NOW()
 ), 
 (
 'PS_STATSDATA_PAGESVIEWS', 1, NOW(), 
 NOW()
 ), 
 (
 'PS_STATSDATA_PLUGINS', 1, NOW(), 
 NOW()
 )</pre>

<pre style="color: black; background-color: white;">CREATE TEMPORARY TABLE `PREFIX_configuration_tmp` (`value` text)</pre>

<pre style="color: black; background-color: white;">SET 
 @defaultOOS = (
 SELECT 
 value 
 FROM 
 `PREFIX_configuration` 
 WHERE 
 name = 'PS_ORDER_OUT_OF_STOCK'
 )</pre>

<pre style="color: black; background-color: white;">UPDATE 
 `PREFIX_product` p 
SET 
 `cache_default_attribute` = 0 
WHERE 
 `id_product` NOT IN (
 SELECT 
 `id_product` 
 FROM 
 `PREFIX_product_attribute`
 )</pre>

<pre style="color: black; background-color: white;">LOCK TABLES `admin_assert` WRITE</pre>

<pre style="color: black; background-color: white;">UNLOCK TABLES</pre>

<pre style="color: black; background-color: white;">DROP 
 TABLE IF EXISTS `admin_role`</pre>

<pre style="color: black; background-color: white;">SELECT 
 * 
FROM 
 -- This is another comment
 MyTable # One final comment
 
 /* This is a block comment 
 */
WHERE 
 1 = 2;</pre>

<pre style="color: black; background-color: white;">SELECT 
 -- This is a test</pre>

<pre style="color: black; background-color: white;">SELECT 
 Test 
FROM 
 Test 
WHERE 
 (MyColumn = 1)
)
AND (
 (
 (SomeOtherColumn = 2); 
WARNING: unclosed parentheses or section</pre>

<pre style="color: black; background-color: white;">SELECT 
 * 
LIMIT 
 1; 
SELECT 
 a, 
 b, 
 c, 
 d 
FROM 
 e 
LIMIT 
 1, 2; 
SELECT 
 1, 
 2, 
 3 
WHERE 
 a in (1, 2, 3, 4, 5) 
 and b = 5;</pre>

<pre style="color: black; background-color: white;">SELECT 
 count - 50 
WHERE 
 a - 50 = b 
WHERE 
 1 
 and -50 
WHERE 
 -50 = a 
WHERE 
 a = -50 
WHERE 
 1 
 /*test*/
 -50 
WHERE 
 1 
 and -50;</pre>

<pre style="color: black; background-color: white;">SELECT 
 @ 
 and b;</pre>

<pre style="color: black; background-color: white;">SELECT 
 @&quot;weird variable name&quot;;</pre>

<pre style="color: black; background-color: white;">SELECT 
 &quot;no closing quote
</pre>

[ Cancelar ]

Nome	Permissões	Ações
[ .. Voltar ]
📄 SqlFormatterTest.php	0644	[ EDITAR/VER ]
📄 clihighlight.html	0644	[ EDITAR/VER ]
📄 compress.html	0644	[ EDITAR/VER ]
📄 format-highlight.html	0644	[ EDITAR/VER ]
📄 format.html	0644	[ EDITAR/VER ]
📄 highlight.html	0644	[ EDITAR/VER ]
📄 performance.php	0644	[ EDITAR/VER ]
📄 sql.sql	0644	[ EDITAR/VER ]

📍 /home/diasdiamonds/public_html/vendor/jdorn/sql-formatter/tests

📝 Editando: format-highlight.html