Kamik

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'

Kamik

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;

Kamik

COUNTRIES_WITHOUT_POSTCODES = [
	[ "Angola", "AO" ],
	[ "Antigua and Barbuda", "AG" ],
	[ "Aruba", "AW" ],
	[ "Bahamas", "BS" ],
	[ "Belize", "BZ" ],
	[ "Benin", "BJ" ],
	[ "Botswana", "BW" ],
	[ "Burkina Faso", "BF" ],
	[ "Burundi", "BI" ],

Kamik

  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;
  }