osrecio

SELECT `quote_id`,
	COUNT(`quote_id`) AS `qty_duplicates`,
	`increment_id` AS `first_increment_id`,
	GROUP_CONCAT( `increment_id` SEPARATOR ' | ' ) AS `increment_ids`,
	`created_at`,
	`state`,
	`status`,
	`customer_firstname`,
	`customer_lastname`,
	`customer_email`,

osrecio

php -r "require 'app/Mage.php'; echo Mage::getVersion();"

osrecio

 Zend_Debug::dump($this->getLayout()->getUpdate()->getHandles());

osrecio

SELECT core_store_group.name AS group_name, core_website.name AS website_name, core_store.name AS store_name, core_store.store_id, increment_prefix, increment_last_id, entity_type_code
FROM eav_entity_store
INNER JOIN eav_entity_type ON eav_entity_type.entity_type_id = eav_entity_store.entity_type_id
INNER JOIN core_store ON core_store.store_id = eav_entity_store.store_id
INNER JOIN core_store_group ON core_store_group.group_id = core_store.group_id
INNER JOIN core_website ON core_website.website_id = core_store.website_id
WHERE eav_entity_store.store_id != 0 ORDER BY eav_entity_store.store_id;

osrecio

TRUNCATE dataflow_batch_export;
TRUNCATE dataflow_batch_import;
TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;

osrecio

#!/bin/bash
#
# ----------------------------------------------------------------------------
# magento_backup.sh                                     by @OSrecio
#
# Hace una copia de seguridad de la instalacion de magento en la maquina local.
#
# Se crean dos ficheros comprimidos:
#  - Un volcado de la base de datos MYSQL.
#  - Una copia de la carpeta que contiene la instalacion web.

osrecio

<?php
$row = 0;
$j = 1; // Linea por la que quieres empezar
$file = "name.txt"; //Nombre del fichero
if (($handle = fopen($file, "r")) !== FALSE) {
  while (($data = fgetcsv($handle, ",")) !== FALSE) {
      print_r($data);
      $j++;
      $row++;	
  }

osrecio

#!/bin/bash
LOG="/path_to_save_logs"
echo "Start backup web `date`" >> $LOG

cd /folder_to_save
FECHAF=`date +%Y.%m.%d`
mkdir $FECHAF
cd $FECHAF
FECHA=`date +%-m-%-d-%Y`

osrecio

/*
  
  Cobalt theme by Carlos Asín

  ************************************

  A cobalt theme for Chrome Developer Tools inspired by Sublime Text 2 cobalt theme. 

  Modifies the source code and other smaller tweaks.

osrecio

DELETE a.*,b.*,c.* 
FROM wp_posts a 
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) 
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision';