Skip to content

Instantly share code, notes, and snippets.

View oreales's full-sized avatar

Oscar Reales oreales

5 followers · 2 following
View GitHub Profile
@oreales
oreales / removeOrphanImages.php
Created September 26, 2018 16:56 — forked from acataluddi/removeOrphanImages.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>Remove Magento's orphan images web console</title>
<link href='https://fonts.googleapis.com/css?family=Open+Sans+Condensed:300,700' rel='stylesheet' type='text/css'>
<link href='https://fonts.googleapis.com/css?family=Inconsolata:400,700&subset=latin,latin-ext' rel='stylesheet'
type='text/css'>
<style type="text/css">
@oreales
oreales / magento_module_enabled.php
Created February 12, 2014 23:11 — forked from oscar-reales-interactiv4/magento_module_enabled.php
<?php
//manera que utilizan muchas extensiones, aunque no es la recomendable,
//ya que magento incluye esta funcionalidad en su core
$modules = Mage::getConfig()->getNode('modules')->children();
$modulesArray = (array)$modules;
if($modulesArray['Module_Name']->is('active')) {
echo "module is active.";
@oreales
oreales / unobstrusive-onLoad.js
Created February 12, 2014 23:11 — forked from oscar-reales-interactiv4/unobstrusive-onLoad.js
function addEvent(obj, evType, fn){
if (obj.addEventListener){
obj.addEventListener(evType, fn, false);
return true;
} else if (obj.attachEvent){
var r = obj.attachEvent("on"+evType, fn);
return r;
} else {
return false;
}
@oreales
oreales / truncate.php
Created February 12, 2014 23:09 — forked from oscar-reales-interactiv4/truncate.php
<?php
/**
* Esta funcion devuelve una cadena pasada como parametro
* truncada a un maximo de caracteres segun parametro
* @param string $string
* @param int $maxLength
* @return string
*/
public function truncateString($string, $maxLength)
@oreales
oreales / phpnative.phtml
Created February 12, 2014 23:09 — forked from oscar-reales-interactiv4/phpnative.phtml
<? for($navigation as $item) : ?>
<li><a href="<?= $item->href ?>"><?= $item->caption ?></a></li>
<? endfor; ?>
@oreales
oreales / getAttributeCollection.php
Created February 12, 2014 23:08 — forked from oscar-reales-interactiv4/getAttributeCollection.php
<?php
Mage::getSingleton('eav/config')
->getEntityType(Mage_Catalog_Model_Product::ENTITY)
->getAttributeCollection();
?>
@oreales
oreales / magento-store-replace.sql
Created February 12, 2014 23:08 — forked from oscar-reales-interactiv4/magento-store-replace.sql
#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%";
@oreales
oreales / magento-log-clean
Created February 12, 2014 23:08 — forked from oscar-reales-interactiv4/magento-log-clean
php -f shell/log.php -- clean --days 1
@oreales
oreales / magento-truncate.sql
Last active August 29, 2015 13:56 — forked from oscar-reales-interactiv4/magento-truncate.sql
SET FOREIGN_KEY_CHECKS = 0;
#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;
@oreales
oreales / quote-cleaning.sql
Created February 12, 2014 23:06 — forked from oscar-reales-interactiv4/quote-cleaning.sql
#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;