Kamik

## nginx.conf
  location /api {
    rewrite ^/api/rest /api.php?type=rest last;
    rewrite ^/api/v2_soap /api.php?type=v2_soap last;
    rewrite ^/api/soap /api.php?type=soap last;
  }

## countries-without-postcodes.rb
COUNTRIES_WITHOUT_POSTCODES = [
	[ "Angola", "AO" ],
	[ "Antigua and Barbuda", "AG" ],
	[ "Aruba", "AW" ],
	[ "Bahamas", "BS" ],
	[ "Belize", "BZ" ],
	[ "Benin", "BJ" ],
	[ "Botswana", "BW" ],
	[ "Burkina Faso", "BF" ],
	[ "Burundi", "BI" ],

## gist:3ecae1135a0675f73c66
delimiter ;;
    drop procedure if exists build_catalog;;
    create procedure build_catalog(IN categories INT, IN products INT)
    begin
        SET @category_count = 1;
        SET @CATNAMEPREFIX = "Category ";
        SET @CATURLKEYPREFIX = "cat-";
        SET @CATURLPATHPREFIX = "catpath-";
        SET @ROOTCATEGORY = 2;
        SET @INCLUDEINMENU = 1;

## gist:39034717a664e2f70731
UPDATE `core_config_data` SET  `value` = 'AO,AG,GQ,AW,BS,BZ,BJ,BW,BF,BI,CK,CI,CD,KP,DM,DJ,ER,FJ,TF,GM,GH,GD,GN,GY,IE,YE,CM,QA,KI,KM,CG,MW,ML,MR,NR,NU,TL,SB,ST,SC,SL,ZW,SO,HK,MO,KN,LC,SR,SY,TZ,TG,TK,TO,TV,UG,VU,AE,CF' WHERE `scope` = 'default' and `scope_id`=0 and  `path` = 'general/country/optional_zip_countries'

## magento_php5.6.sh
# use this inside lib/Zend to make the version of ZF usable with php 5.6

sed -i "s/'internal_encoding'/'default_charset'/g" ./XmlRpc/Client.php ./Service/Audioscrobbler.php ./Service/Technorati.php ./Locale/Format.php ./Validate/Hostname.php ./Validate/StringLength.php

## shell_delete_unused_images
<?php
require_once 'abstract.php';

class Mage_Shell_CheckImages extends Mage_Shell_Abstract
{
    const CATALOG_PRODUCT = '/catalog/product';

    const CACHE = '/cache/';

    protected function _glob_recursive($pattern, $flags = 0)

## n98-magerun.yaml
commands:
  N98\Magento\Command\Database\DumpCommand:
    table-groups:
      - id: products
        description: Skip all product tables.
        tables: >
                catalog_category_product*
                catalog_compare_item
                catalog_product_*
                cataloginventory_stock_*

## mysql_splitdump.sh
#!/bin/bash

####
# Split MySQL dump SQL file into one file per table
# based on http://blog.tty.nl/2011/12/28/splitting-a-database-dump
####

if [ $# -lt 1 ] ; then
  echo "USAGE $0 DUMP_FILE [TABLE]"
  exit

## prestashop.conf
server {
    listen 80;
    listen [::]:80;   #Use this to enable IPv6
    server_name www.example.com;
    root /var/www/prestashop17;
    access_log /var/log/nginx/access.log;
    error_log /var/log/nginx/error.log;

    index index.php index.html;

## interfaces
### Hetzner Online AG - installimage
# Loopback device:
auto lo
iface lo inet loopback

# device: eth0
auto eth0 ##Hetzner Interface
iface eth0 inet static
    address     <Main IP>
    broadcast   <Broadcast IP>
	location /api {
	rewrite ^/api/rest /api.php?type=rest last;
	rewrite ^/api/v2_soap /api.php?type=v2_soap last;
	rewrite ^/api/soap /api.php?type=soap last;
	}
	COUNTRIES_WITHOUT_POSTCODES = [
	[ "Angola", "AO" ],
	[ "Antigua and Barbuda", "AG" ],
	[ "Aruba", "AW" ],
	[ "Bahamas", "BS" ],
	[ "Belize", "BZ" ],
	[ "Benin", "BJ" ],
	[ "Botswana", "BW" ],
	[ "Burkina Faso", "BF" ],
	[ "Burundi", "BI" ],
	delimiter ;;
	drop procedure if exists build_catalog;;
	create procedure build_catalog(IN categories INT, IN products INT)
	begin
	SET @category_count = 1;
	SET @CATNAMEPREFIX = "Category ";
	SET @CATURLKEYPREFIX = "cat-";
	SET @CATURLPATHPREFIX = "catpath-";
	SET @ROOTCATEGORY = 2;
	SET @INCLUDEINMENU = 1;
	# use this inside lib/Zend to make the version of ZF usable with php 5.6

	sed -i "s/'internal_encoding'/'default_charset'/g" ./XmlRpc/Client.php ./Service/Audioscrobbler.php ./Service/Technorati.php ./Locale/Format.php ./Validate/Hostname.php ./Validate/StringLength.php
	<?php
	require_once 'abstract.php';

	class Mage_Shell_CheckImages extends Mage_Shell_Abstract
	{
	const CATALOG_PRODUCT = '/catalog/product';

	const CACHE = '/cache/';

	protected function _glob_recursive($pattern, $flags = 0)
	commands:
	N98\Magento\Command\Database\DumpCommand:
	table-groups:
	- id: products
	description: Skip all product tables.
	tables: >
	catalog_category_product*
	catalog_compare_item
	catalog_product_*
	cataloginventory_stock_*
	#!/bin/bash

	####
	# Split MySQL dump SQL file into one file per table
	# based on http://blog.tty.nl/2011/12/28/splitting-a-database-dump
	####

	if [ $# -lt 1 ] ; then
	echo "USAGE $0 DUMP_FILE [TABLE]"
	exit
	server {
	listen 80;
	listen [::]:80; #Use this to enable IPv6
	server_name www.example.com;
	root /var/www/prestashop17;
	access_log /var/log/nginx/access.log;
	error_log /var/log/nginx/error.log;

	index index.php index.html;
	### Hetzner Online AG - installimage
	# Loopback device:
	auto lo
	iface lo inet loopback

	# device: eth0
	auto eth0 ##Hetzner Interface
	iface eth0 inet static
	address <Main IP>
	broadcast <Broadcast IP>