Skip to content

Instantly share code, notes, and snippets.

View steverobbins's full-sized avatar

Steve Robbins steverobbins

117 followers · 113 following
View GitHub Profile
@steverobbins
steverobbins / magento-get-all-attribute-option-values.php
Last active August 29, 2015 14:12
<?php
$code = 'color';
$opts = Mage::getSingleton('eav/config')
->getAttribute('catalog_product', $code)
->getSource()
->getAllOptions(false);
foreach($opts as $opt) {
@steverobbins
steverobbins / magento-fetch-media.php
Last active May 10, 2017 10:09
Download product media images to your local Magento store without rsync/ftp.
<?php
$range = array_merge(range('a', 'z'), range('A', 'Z'), range(0, 9), array('_'));
foreach ($range as $a) foreach ($range as $b) mkdir("$a/$b", 0777, true);
$db = new PDO('mysql:127.0.0.1;dbname=magento', 'root', 'root');
//$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$result = $db->query('select distinct value from catalog_product_entity_media_gallery');
@steverobbins
steverobbins / xdebug-php.ini
Created December 11, 2014 23:50
[xdebug]
xdebug.default_enable=1
xdebug.remote_enable=1
xdebug.remote_handler=dbgp
xdebug.remote_host=localhost
xdebug.remote_port=9000
xdebug.remote_autostart=1
xdebug.profiler_enable_trigger=1
zend_extension="/Applications/MAMP/bin/php/php5.5.3/lib/php/extensions/no-debug-non-zts-20121212/xdebug.so"
@steverobbins
steverobbins / Paypal.php
Last active April 22, 2024 12:18
PayPal API Requests
<?php
class Paypal
{
/**
* API Version
*/
const VERSION = 51.0;
/**
@steverobbins
steverobbins / magento-backup-db.sh
Last active July 9, 2018 03:30
#!/bin/bash
################################################################################
# FUNCTIONS
################################################################################
# 1. Check required system tools
_check_installed_tools() {
local missed=""
@steverobbins
steverobbins / magento-log-events.php
Last active August 29, 2015 14:08
<?php
final class Mage
{
// ...
public static function dispatchEvent($name, array $data = array())
{
$e = new Exception();
Mage::log(
$name . ': ' . implode(', ', array_keys($data)) . "\n"
@steverobbins
steverobbins / magento-fix-db-trigger-definer-windows.ps1
Created October 29, 2014 18:30
Get-Content dump.sql | Foreach-Object { $_ -replace 'DEFINER(.*)`magento-dbuser`@`localhost`','DEFINER$1`different-user`@`different-host`' } | Set-Content new.sql
@steverobbins
steverobbins / magento-make-admin.php
Created October 27, 2014 18:36
<?php
include 'app/Mage.php';
Mage::app('admin', 'store');
$password = substr(md5('Password' . time()), 0, 16);
$user = Mage::getModel("admin/user")
->setData(array(
'username' => 'steve',
@steverobbins
steverobbins / table-sizes.sql
Created October 23, 2014 17:58
SET @DATABASE = 'prod';
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
WHERE `information_schema`.TABLES.table_schema = @DATABASE
@steverobbins
steverobbins / magento-backup.sh
Last active September 27, 2017 16:31
#!/bin/bash
################################################################################
# FUNCTIONS
################################################################################
# 1. Check required system tools
_check_installed_tools() {
local missed=""