Skip to content

Instantly share code, notes, and snippets.

View oreales's full-sized avatar

Oscar Reales oreales

8 followers · 2 following
View GitHub Profile
@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 / 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 / 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 / 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 / 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 / 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 / create-magento-admin-user.sql
Created March 17, 2014 21:09
creante magento admin user
INSERT INTO admin_user
SELECT
NULL user_id,
"oreales" firstname,
"" lastname,
"[email protected]" email,
"oreales" username,
MD5("xxxxxx") password,
NOW( ) created,
NULL modified,
@oreales
oreales / labels-and-metas.sql
Last active November 22, 2019 19:54
magento-seo-sqls
#SQLs que dan una respuesta rápida a si un site esta utilizando algunas de las posibilidades SEO que da Magento o no:
#total de imagenes de producto en tu tienda
SELECT count(*) FROM catalog_product_entity_media_gallery_value;
#imagenes que NO tienen texto alternativo (y debieran)
SELECT count(*) FROM catalog_product_entity_media_gallery_value WHERE label IS NULL;
#imagenes que SI tienen texto alternativo (si son pocas...ese margen de mejora tienes)
SELECT count(*) FROM catalog_product_entity_media_gallery_value WHERE label IS NOT NULL;
@oreales
oreales / .htaccess
Last active August 29, 2015 14:01
.htaccess rewrite a www y https
############################################
## rewrites to https y www
#First rewrite any request to the wrong domain to use the correct one (here www.)
RewriteCond %{HTTP_HOST} !^www\.
RewriteRule ^(.*)$ http://www.%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
#Now, rewrite to HTTPS:
RewriteCond %{HTTPS} off
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
@oreales
oreales / largest-tables.sql
Created July 11, 2014 22:21
Largest MySQL tables in a database
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
ORDER BY data_length + index_length DESC
LIMIT 10;