David Alexander davidalexander

davidalexander / readme.md

Created January 4, 2021 12:21

Skywire / m2-module-linked-products

m2-module-linked-products

Link products to each other with user configurable types.

Install via composer

composer require skywire/linkedproducts

davidalexander / speedcurveAlert.php

Created July 25, 2018 10:11

A script to get the commit message and use it as the note to trigger a speedcurve deploy (magento 1)

	<?php

	class Skywire_Speedcurve_Alert extends Mage_Shell_Abstract
	{
	const GIT_COMMIT_API = 'https://api.github.com/repos/%s/%s/git/commits/%s';

	const SPEEDCURVE_API = 'https://api.speedcurve.com/v1/deploys';

	protected $hash;

davidalexander / magento_trigger_500.php

Last active August 29, 2015 14:10

trigger magento 500 error

	<?php
	// Trigger 500 response
	// allows styling of "There has been an error processing your request" page
	// note setIsDeveloperModes should be false to prevent xxception being thrown
	throw new Exception('you shall not pass');

davidalexander / admin_reset.sql

Created September 9, 2014 16:58

Magento Admin gives 404 due to admin website not having id of 0

	SET FOREIGN_KEY_CHECKS=0;
	UPDATE `core_store` SET store_id = 0 WHERE code='admin';
	UPDATE `core_store_group` SET group_id = 0 WHERE name='Default';
	UPDATE `core_website` SET website_id = 0 WHERE code='admin';
	UPDATE `customer_group` SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN';
	SET FOREIGN_KEY_CHECKS=1;

davidalexander / gist:f938f8b4d14b82581cfb

Last active August 29, 2015 14:04

resend order emails from Magento admin for local testing

	<?php
	// app/code/core/Mage/Sales/Model/Order.php
	// comment the following lines arround ln.1272

	// if ($this->getEmailSent()) {
	// return $this;
	// }

davidalexander / largest_tables.sql

Created July 16, 2014 12:42

get largest 10 tables in all SQL databases

	-- http://www.mysqlperformanceblog.com/2008/02/04/finding-out-largest-tables-on-mysql-server/
	SELECT
	CONCAT(table_schema, '.', table_name),
	CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows,
	CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G') DATA,
	CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G') idx,
	CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
	ROUND(index_length / data_length, 2) idxfrac
	FROM
	information_schema.TABLES

davidalexander / magento_logrotate

Last active September 17, 2016 08:46

magento logrotate

	# /etc/logrotate.d/magento

	"/path/to/site/var/log/*.log"
	"/path/to/another-site/var/log/*.log" {
	compress
	copytruncate
	daily
	missingok
	notifempty
	olddir archive

davidalexander / gist:11351615

Created April 27, 2014 18:00

magento - get all quoted translation strings

	# https://twitter.com/mrsopacua/status/447892121283223552 (@mrsopacua)
	find app/design/frontend -type f -exec perl -ne 'while($_ =~ /(?<=\W)__$\s([\x27\x22])(.+?)\1\s$/g) { print "$2\n"; }' {} +

davidalexander / gist:7772193

Created December 3, 2013 16:21

Magento: Efficiently get a single product attribute from product id

	<?php
	$attribute_value = Mage::getResourceSingleton('catalog/product')->getAttributeRawValue($productId, 'attribute_code', Mage::app()->getStore());
	echo $attribute_value;

davidalexander / My xdebug php config values

Created November 14, 2013 22:00

	xdebug.remote_autostart=true
	xdebug.remote_enable=1
	xdebug.collect_vars=on
	xdebug.collect_params=4
	xdebug.show_local_vars=on
	xdebug.var_display_max_depth=5
	xdebug.show_exception_trace=on