This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET @tables = NULL; | |
SELECT GROUP_CONCAT(table_schema, '.`', TABLE_NAME, '`') INTO @tables FROM ( | |
SELECT * | |
FROM information_schema.tables AS t | |
WHERE t.table_schema = 'DB NAME' | |
AND t.table_name REGEXP "^sequence_(.+)_[0-9]+" | |
AND SUBSTRING_INDEX(t.table_name, '_', -1) NOT IN (SELECT DISTINCT store_id FROM sales_sequence_meta) | |
) TT; | |
SET @tables = CONCAT('DROP TABLE ', @tables); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
@package magento/framework | |
@level 4 | |
@version >=103.0.6 <103.0.7 | |
diff --git a/vendor/magento/framework/App/DeploymentConfig.php b/vendor/magento/framework/App/DeploymentConfig.php | |
index 6713baa3a1d..64f32d5516b 100644 | |
--- a/vendor/magento/framework/App/DeploymentConfig.php | |
+++ b/vendor/magento/framework/App/DeploymentConfig.php | |
@@ -51,6 +51,16 @@ class DeploymentConfig | |
*/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
desc('Send the composer.lock file to our n8n endpoint to save package information in our overview'); | |
task('update-packages-overview', function () { | |
$curl = curl_init(); | |
curl_setopt_array($curl, [ | |
CURLOPT_URL => getenv('N8N_WEBHOOK_PACKAGES'), | |
CURLOPT_POST => true, | |
CURLOPT_RETURNTRANSFER => true, | |
CURLOPT_POSTFIELDS => file_get_contents('composer.lock'), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"name": "PHP packages composer.lock Magento projects", | |
"nodes": [ | |
{ | |
"parameters": { | |
"httpMethod": "POST", | |
"path": "24577e32-bda2-48d3-9721-509294f9cc89", | |
"options": {} | |
}, | |
"id": "525eb7eb-bdcb-4a47-a5a1-dc84d166c8a3", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# A number of these changes come form the following PR's; , combines changes in https://github.com/magento/magento2/pull/29360, https://github.com/magento/magento2/pull/28944 and https://github.com/magento/magento2/pull/28894, https://github.com/magento/magento2/pull/35228, https://github.com/magento/magento2/pull/36524, https://github.com/magento/magento2/pull/34323 | |
# VCL version 5.0 is not supported so it should be 4.0 even though actually used Varnish version is 6 | |
vcl 4.1; | |
import std; | |
# The minimal Varnish version is 6.0 | |
# For SSL offloading, pass the following header in your proxy server or load balancer: '/* {{ ssl_offloaded_header }} */: https' | |
backend default { | |
.host = "/* {{ host }} */"; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# ~/nginx/server.security-txt | |
# Make Magento 2.4.x's security.txt available to the world | |
rewrite ^/.well-known/security.txt$ /securitytxt/index/securitytxt last; | |
rewrite ^/security.txt$ /securitytxt/index/securitytxt last; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT COUNT(*) FROM email_template WHERE template_text LIKE '%order=%'; | |
SELECT COUNT(*) FROM email_template WHERE template_text LIKE '%invoice=%'; | |
SELECT COUNT(*) FROM email_template WHERE template_text LIKE '%sales_email_order_items%' AND template_text NOT LIKE '%area="frontend"%'; | |
SELECT COUNT(*) FROM email_template WHERE template_text LIKE '%sales_email_order_invoice_items%' AND template_text NOT LIKE '%area="frontend"%'; | |
UPDATE email_template SET template_text = REPLACE(template_text, "order=$order", "order_id=$order_id") WHERE template_text LIKE '%order=%'; | |
UPDATE email_template SET template_text = REPLACE(template_text, "invoice=$invoice", "invoice_id=$invoice_id") WHERE template_text LIKE '%invoice=%'; | |
UPDATE email_template SET template_text = REPLACE(template_text, 'handle="sales_email_order_items"', 'area="frontend" handle="sales_email_order_items"') WHERE template_text LIKE '%sales_email_order_items%' AND template_text NOT LIKE '%area="frontend"%'; | |
UPDATE email_template SET template_text = REPLACE |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Removed dependency on MSI modules | |
@package smile/elasticsuite | |
@link https://github.com/Smile-SA/elasticsuite/issues/1222 | |
diff --git src/module-elasticsuite-catalog/Model/Product/Indexer/Fulltext/Datasource/InventoryData.php src/module-elasticsuite-catalog/Model/Product/Indexer/Fulltext/Datasource/InventoryData.php | |
index ca4557d..f07e059 100644 | |
--- src/module-elasticsuite-catalog/Model/Product/Indexer/Fulltext/Datasource/InventoryData.php | |
+++ src/module-elasticsuite-catalog/Model/Product/Indexer/Fulltext/Datasource/InventoryData.php | |
@@ -14,7 +14,6 @@ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// ==UserScript== | |
// @name Fitchef to MyFitnessPal | |
// @version 0.1 | |
// @description Voeg link toe aaan Fitchef.nl om een recept aan MyFitnessPal toe te voegen | |
// @author Peter Jaap Blaakmeer | |
// @match https://fitchef.nl/weekschema/*/* | |
// @grant GM_addStyle | |
// @grant GM_xmlhttpRequest | |
// ==/UserScript== |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
// Run with the URL pointing to a require-config.js as the first argument; | |
// php identify.php http://magento2demo.firebearstudio.com/pub/static/frontend/Magento/luma/en_US/requirejs-config.js | |
$content = file_get_contents($argv[1]); | |
preg_match_all( | |
'/(?P<quote>\'|")(?P<extension>[[:alnum:]]+_[[:alnum:]]+)\/js\/.+?(?P=quote)/m', | |
$content, | |
$matches |
NewerOlder