molotovbliss

Magento Snippets

Set all categories to is_anchor 1

Find attribute_id

SELECT * FROM eav_attribute where attribute_code = 'is_anchor'

Update all of them with anchor_id from above (usually is ID 51)

UPDATE `catalog_category_entity_int` set value = 1 where attribute_id = 51

molotovbliss

<?php
/**
 * This script outputs an array of file hashes recursively for the current directory.
 * Useful for generating hashlist for security scanning programs
 * 
 */
function recursive_md5($dir, $types = null, $recursive = true, $baseDir = '')
{
	$to_ignore = array(
		'.',

molotovbliss

<?xml version="1.0"?>
<config>
    <frontend>
        <events>
            <!-- disble logs -->
            <controller_action_predispatch>
                <observers><log><type>disabled</type></log></observers>
            </controller_action_predispatch>
            <controller_action_postdispatch>
                <observers><log><type>disabled</type></log></observers>

molotovbliss

<?php

$database_host      = "localhost";
$database_user      = "username";
$database_password  = "password";
$magento_database   = "databasename";
$table_prefix       = "prefixhere_";
$dryrun				= true; // change to false when you want to commit changes

$db = mysql_connect($database_host, $database_user, $database_password);

molotovbliss

<?php
// shell/listAllCron.php
require_once 'abstract.php';

class Mage_Shell_CronLister extends Mage_Shell_Abstract
{
    public function run()
    {
        $cronJobs = Mage::app()->getConfig()->getNode('crontab/jobs');

molotovbliss

find . -name "*.phtml" -print | xargs grep --color=auto -iRnH "Mage::getModel("
find . -name "*.phtml" -print | xargs grep --color=auto -iRnH "Mage::getResourceModel("
find . -name "*.phtml" -print | xargs grep --color=auto -iRnH "Mage::getSingleton("
find . -name "*.phtml" -print | xargs grep --color=auto -iRnH "SELECT.*FROM.*;[\"\']"  
find . -name "*.php" -print | xargs grep --color=auto -iRnH "htmlEscape("
find ./app/code/local -name "*.php" -print | xargs grep --color=auto -iRnH "htmlEscape("
find ./app/code/local -name "*/Block/*.phtml" -print | xargs grep --color=auto -iRnH "SELECT.*FROM.*;[\"\']" 
find ./app/code/local -name "*.php" -print | xargs grep --color=auto -iRnH "\$_[GET|REQUEST|SERVER|POST]"
find ./app/code/local -name "*.php" -print | xargs grep --color=auto -iRnH "public _construct"
find . -name "*.php" -print | xargs grep --color=auto -iRnH "public _construct"

molotovbliss

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `catalog_product_bundle_option`;
TRUNCATE TABLE `catalog_product_bundle_option_value`;
TRUNCATE TABLE `catalog_product_bundle_price_index`;
TRUNCATE TABLE `catalog_product_bundle_selection`;
TRUNCATE TABLE `catalog_product_bundle_selection_price`;
TRUNCATE TABLE `catalog_product_bundle_stock_index`;
TRUNCATE TABLE `catalog_product_entity_datetime`;
TRUNCATE TABLE `catalog_product_entity_decimal`;
TRUNCATE TABLE `catalog_product_entity_gallery`;

molotovbliss

#!/bin/env bash
#
# Example use: Add the following line to your crontab to run the script on a daily basis.
# 
# 1 6 * * * ~/bin/compare_and_email.sh <full_path_to_webroot> "Email Subject Line" "user@example.com user2@example.com"
#

date=`date +%Y%m%d`
gitdir="$1"
subject="$2"

molotovbliss

#!/usr/bin/env bash
# script:  watchdo
# author:  Mike Smullin <mike@smullindesign.com>
# modified: Jared Blalock <mb@molotovbliss.com>
# possible use for monitoring .less changes to compile to .css
# license: GPLv3
# description:
#   watches the given path for changes
#   and executes a given command when changes occur
# usage:

molotovbliss

composer config repositories.alger/phpworld-talk2 vcs git@github.com:davidalger/phpworld-talk2.git
composer require alger/module-skeleton:dev-master
bin/magento setup:upgrade -q && bin/magento cache:flush -q

# OR

git clone git@github.com:davidalger/phpworld-talk2.git app/code/Alger/Skeleton
bin/magento module:enable Alger_Skeleton
bin/magento setup:upgrade -q && bin/magento cache:flush -q