mpchadwick

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

mpchadwick

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

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

<Proxy "fcgi://127.0.0.1:9000">
  ProxySet responsefieldsize=16384
</Proxy>

<FilesMatch \.php$>
  SetHandler proxy:fcgi://127.0.0.1:9000
</FilesMatch>

mpchadwick

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',

mpchadwick

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

mpchadwick

# 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

mpchadwick

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

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

mpchadwick

package main

import (
	"fmt"
	"github.com/jaswdr/faker"
	"reflect"
)

func main() {
	f := faker.New()