zachbrowne

#!/bin/sh

#######################################################
# Another great script by:                            #
#    _                , _                             #
#   / )  _,   _  |)  /|/_) ,_   _                 _   #
#    /  / |  /   |/\  |  \/  | / \_|  |  |_/|/|  |/   #
#   /__/\/|_/\__/|  |/|(_/   |/\_/  \/ \/   | |_/|_/  #
#    (|                                               #
#                                                     #

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

colinmollenhour

This repo has been moved into a proper github project:

CM_Cache_Backend_File

schmengler

<?php
/**
 * Integration test for OnePageCheckout
 *
 * @author Fabian Schmengler <[email protected]>
 * @copyright SGH informationstechnologie UGmbH 2012
 * @package SGH\Common
 * @subpackage Test
 *
 */

abtris

<?php
namespace Pokus;

class Exception extends \Exception
{
}

function tttt($string)
{
	try {

ticean

SET @entityid = '3';

SELECT ea.attribute_id, ea.attribute_code, eav.value AS 'value', 'varchar' AS 'type'
FROM catalog_category_entity e
JOIN catalog_category_entity_varchar eav
  ON e.entity_id = eav.entity_id
JOIN eav_attribute ea
  ON eav.attribute_id = ea.attribute_id
WHERE e.entity_id = @entityid
UNION