Skip to content

Instantly share code, notes, and snippets.

UPDATE gp_customer_entity SET email='[email protected]' WHERE email NOT LIKE '%mhdirekt%' AND email NOT LIKE '%keyup%' AND email NOT LIKE '%grec.cz';
UPDATE gp_sales_flat_order_address SET email=NULL;
UPDATE gp_sales_flat_order SET customer_email=NULL;
UPDATE gp_core_config_data
SET value = REPLACE(value, 'www', 'dev1')
WHERE path LIKE '%base_url';
@vojtagrec
vojtagrec / README.md
Created February 17, 2014 12:06 — forked from johan/README.md

Requirements

You need the ttx binary from FontTools to dump the cmap table of the fonts into an xml font.ttx file:

> sudo apt-get install fonttools

HOWTO

> ttx -t cmap sorren.eot

Dumping "sorren.eot" to "sorren.ttx"...

@vojtagrec
vojtagrec / shipments-vat-fix.sql
Last active August 29, 2015 14:15
Recalculate shipment taxes in Magento
-- Configuration
SET @tax_percent = 21;
SET @tax_code = 'CZ DPH 21%';
SET @tax_title = 'CZ DPH 21%';
-- Functions
SET @tax_coef = ROUND(@tax_percent / (100 + @tax_percent), 4);
@vojtagrec
vojtagrec / .gitignore
Created September 17, 2015 15:38
Keyup Default Magento .gitignore
.htaccess*
/app/etc/local.xml*
/app/etc/*.backup
/api.php
/cron.php
/cron.sh
/downloader
/errors
/includes
/index.php
@vojtagrec
vojtagrec / gist:8159ba6adec8bca44ac6dca9b2945acb
Created August 12, 2016 13:10 — forked from maccath/gist:3981205
Split PDF to individual pages using FPDI and FPDF
<?php
/**
* Split PDF file
*
* <p>Split all of the pages from a larger PDF files into
* single-page PDF files.</p>
*
* @package FPDF required http://www.fpdf.org/
* @package FPDI required http://www.setasign.de/products/pdf-php-solutions/fpdi/
@vojtagrec
vojtagrec / keybase.md
Created October 5, 2017 09:45
keybase.md

Keybase proof

I hereby claim:

  • I am vojtagrec on github.
  • I am vojtagrec (https://keybase.io/vojtagrec) on keybase.
  • I have a public key ASALJ45wlw2CWv_WE0PtLj2Q6XW4R3pXj55NMyEJRKRF6go

To claim this, I am signing this object: