Skip to content

Instantly share code, notes, and snippets.

Avatar

Max Chadwick mpchadwick

View GitHub Profile
View gist:5b2d782a598c694561ecdc3ec61da4a0
package main
import (
"fmt"
"github.com/jaswdr/faker"
"reflect"
)
func main() {
f := faker.New()
@mpchadwick
mpchadwick / gist:9a8fefacb7dd74c1ca3a7b5525e015db
Created Mar 5, 2020
How Magento 2 Image Cache Hash if Formed
View gist:9a8fefacb7dd74c1ca3a7b5525e015db
Here:
https://github.com/magento/magento2/blob/1eef9bd028d6fd509927ede2b4ba12f0e516567a/app/code/Magento/Catalog/Model/View/Asset/Image.php#L269
https://github.com/magento/magento2/blob/1eef9bd028d6fd509927ede2b4ba12f0e516567a/app/code/Magento/Catalog/Model/View/Asset/Image.php#L256-L262
View gist:a9ac3ce2dbc7a230ea143f83fefd2225
Generating the strace:
sudo -u apache strace -s 10000 -xx -f -e sendto,recvfrom php load-category.php
Useful Links:
- https://www.rapidtables.com/convert/number/hex-to-ascii.html
- https://dev.mysql.com/doc/internals/en/protocoltext-resultset.html
@mpchadwick
mpchadwick / gist:d732c289120ef9955e77e5801dd2fc1d
Created Jan 28, 2020
preexisting-custom-layout-updates.sql
View gist:d732c289120ef9955e77e5801dd2fc1d
# Categories
SELECT
ea.entity_type_id,
ea.attribute_id,
eet.entity_type_code,
ccet.value
FROM eav_attribute ea
LEFT JOIN eav_entity_type eet
ON eet.entity_type_id = ea.entity_type_id
LEFT JOIN catalog_category_entity_text ccet
View gist:f6fe808a80d1764241bf86f43b372bb9
diff --git a/lib/Varien/Db/Adapter/Pdo/Mysql.php b/lib/Varien/Db/Adapter/Pdo/Mysql.php
index f17f16f2d..d8c0373ec 100644
--- a/lib/Varien/Db/Adapter/Pdo/Mysql.php
+++ b/lib/Varien/Db/Adapter/Pdo/Mysql.php
@@ -2947,7 +2947,7 @@ public function prepareSqlCondition($fieldName, $condition)
if (isset($condition['to'])) {
$query .= empty($query) ? '' : ' AND ';
$to = $this->_prepareSqlDateCondition($condition, 'to');
- $query = $this->_prepareQuotedSqlCondition($query . $conditionKeyMap['to'], $to, $fieldName);
+ $query = $query . $this->_prepareQuotedSqlCondition($conditionKeyMap['to'], $to, $fieldName);
View gist:e73e9582ce88922af61e28eae76e4510
function contentLoaded(win, fn) {
var done = false, top = true,
doc = win.document,
root = doc.documentElement,
modern = doc.addEventListener,
add = modern ? 'addEventListener' : 'attachEvent',
rem = modern ? 'removeEventListener' : 'detachEvent',
View gist:ea7fb4ceecb230881a70094ab6082a76
<Proxy "fcgi://127.0.0.1:9000">
ProxySet responsefieldsize=16384
</Proxy>
<FilesMatch \.php$>
SetHandler proxy:fcgi://127.0.0.1:9000
</FilesMatch>
@mpchadwick
mpchadwick / MDVA-6616_EE_2.1.9_COMPOSER_v1.patch
Created Sep 15, 2018
MDVA-6616_EE_2.1.9_COMPOSER_v1.patch
View MDVA-6616_EE_2.1.9_COMPOSER_v1.patch
commit 548997b5e068416d7d566de76c69c424f98d9c8c
Author: Roman Tkachenko <rotkachenko@magento.com>
Date: Tue Jan 9 17:32:20 2018 +0000
MDVA-6616: New customer account does not display until reindexed manually.
- Workaround - reindex row on save.
diff --git a/vendor/magento/module-customer/Model/Address.php b/vendor/magento/module-customer/Model/Address.php
index f012edb6700..75bdb7601a3 100644
@mpchadwick
mpchadwick / PATCH_MDVA-4538_EE_2.1.4_v2.composer.patch
Created Sep 11, 2018
PATCH_MDVA-4538_EE_2.1.4_v2.composer.patch
View PATCH_MDVA-4538_EE_2.1.4_v2.composer.patch
diff --git a/vendor/magento/module-customer/Model/Indexer/Source.php b/vendor/magento/module-customer/Model/Indexer/Source.php
new file mode 100644
index 0000000..2310953
--- /dev/null
+++ b/vendor/magento/module-customer/Model/Indexer/Source.php
@@ -0,0 +1,154 @@
+<?php
+/**
+ * Copyright © 2016 Magento. All rights reserved.
+ * See COPYING.txt for license details.
@mpchadwick
mpchadwick / magento-admin-users-and-roles.sql
Created May 8, 2017
magento-admin-users-and-roles.sql
View magento-admin-users-and-roles.sql
SELECT
firstname,
lastname,
email,
username,
au2.role_name
FROM admin_user
INNER JOIN admin_role au1
ON admin_user.user_id = au1.user_id
INNER JOIN admin_role au2
You can’t perform that action at this time.