oscar-reales-interactiv4

#funcion rapida para crear una rama de feature desde master en un proyecto. tecleando fr y la rama
function fr { git checkout master -b FR#$1;}

oscar-reales-interactiv4

iPhone|iPod|BlackBerry|Palm|Googlebot-Mobile|Mobile|mobile|mobi|Windows Mobile|Safari Mobile|Android|Opera Mini

oscar-reales-interactiv4

<?php

	define('MAGENTO', realpath(dirname(__FILE__)));
	require_once MAGENTO . '/app/Mage.php';
	Mage::app();
	$app=Mage::app();

  Mage::app()->cleanCache();
  flush();

oscar-reales-interactiv4

#atributos de catalogo creados por el usuario
SELECT attribute_code FROM eav_attribute AS eavAttr
WHERE eavAttr.entity_type_id = 4
AND eavAttr.is_user_defined = 1;

#atributos de catalogo NO creados por el usuario (magento core)
SELECT attribute_code, attribute_id FROM eav_attribute AS eavAttr
WHERE eavAttr.entity_type_id = 4
AND eavAttr.is_user_defined = 0;

oscar-reales-interactiv4

LOCK TABLES `directory_country_region` WRITE;

UPDATE `directory_country_region`
SET default_name = 'A Coruña'
WHERE region_id = 130;

UPDATE `directory_country_region`
SET default_name = 'Álava'
WHERE country_id = 'ES' AND code = 'Alava';

oscar-reales-interactiv4

<?php
/**
 * Magento
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is bundled with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * http://opensource.org/licenses/osl-3.0.php

oscar-reales-interactiv4

#PARA CUSTOMERS borrando QUOTES más antiguas de 45 días
#DELETE FROM sales_flat_quote WHERE (NOT ISNULL(customer_id) AND customer_id != 0) AND updated_at < DATE_SUB(Now(), INTERVAL 45 DAY) LIMIT 15000;
SELECT * FROM sales_flat_quote WHERE (NOT ISNULL(customer_id) AND customer_id != 0) AND updated_at < DATE_SUB(Now(), INTERVAL 45 DAY) LIMIT 15000;

#PARA NO CUSTOMERS borrando QUOTES más antiguas de 30 días.
#DELETE FROM sales_flat_quote WHERE (ISNULL(customer_id) || customer_id = 0) AND updated_at < DATE_SUB(Now(), INTERVAL 30 DAY);
SELECT * FROM sales_flat_quote WHERE (ISNULL(customer_id) || customer_id = 0) AND updated_at < DATE_SUB(Now(), INTERVAL 30 DAY) LIMIT 50000;

oscar-reales-interactiv4

#truncate customers
truncate customer_entity;
truncate customer_address_entity;
truncate log_customer;
truncate salesrule_customer;
truncate salesrule_coupon_usage;
truncate newsletter_subscriber;
truncate persistent_session;
truncate product_alert_price;
truncate product_alert_stock;

oscar-reales-interactiv4

php -f shell/log.php -- clean --days 1

oscar-reales-interactiv4

#Select all the config data with the current domain in the value
select * from core_config_data where value like "%www.old-domain.com%";

#replacing www.old-domain.com with www.new-domain.com
update core_config_data set value=REPLACE(value, 'www.old-domain.com', 'www.new-domain.com') 
where value like "%www.old-domain.com%";

#check if it worked!
select * from core_config_data where value like "%www.new-domain.com%";