Skip to content

Instantly share code, notes, and snippets.

View davidalexander's full-sized avatar

David Alexander davidalexander

30 followers · 61 following
View GitHub Profile
@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.

Installation

Install via composer

composer require skywire/linkedproducts

@davidalexander
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
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
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
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
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
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
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
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
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