borriglione

<?php

require_once 'abstract.php';

class TaxrateChange extends Mage_Shell_Abstract
{
    public function run()
    {
        $this->validateInput();
        $this->changeTaxRate();

borriglione

diff --git a/Mail/Message.php b/Mail/Message.php
index 1f423e801087..0e4d79aac933 100644
--- a/Mail/Message.php
+++ b/Mail/Message.php
@@ -171,7 +171,6 @@ private function createMimeFromString($body, $messageType)
         $part = new Part($body);
         $part->setCharset($this->zendMessage->getEncoding());
         $part->setEncoding(Mime::ENCODING_QUOTEDPRINTABLE);
-        $part->setDisposition(Mime::DISPOSITION_INLINE);
         $part->setType($messageType);

borriglione

#!/bin/bash

usage()
{
cat << EOF
usage: $0 options

This script set ownership for all table, sequence and views for a given database

Credit: Based on http://stackoverflow.com/a/2686185/305019 by Alex Soto

borriglione

#!/bin/bash
echo "*** This script is anonymizing a DB-dump of the LIVE-DB in the DEMO-Environment ***"

HOST=`grep host ../app/etc/local.xml | sed 's/ *<host>\(.*\)<\/host>/\1/' | sed 's/<!\[CDATA\[//' | sed 's/\]\]>//'`
USER=`grep username ../app/etc/local.xml | sed 's/ *<username>\(.*\)<\/username>/\1/' | sed 's/<!\[CDATA\[//' | sed 's/\]\]>//'`
PASS=`grep password ../app/etc/local.xml | sed 's/ *<password>\(.*\)<\/password>/\1/' | sed 's/<!\[CDATA\[//' | sed 's/\]\]>//'`
NAME=`grep dbname ../app/etc/local.xml | sed 's/ *<dbname>\(.*\)<\/dbname>/\1/' | sed 's/<!\[CDATA\[//' | sed 's/\]\]>//'`

echo ""

borriglione

Magento 1 attribute usage statistic

The idea here is super simple - check how much is current attribute used and decide which can be removed from the shop to increase the performance and/or reduce database load. Script might be quite heavy to run at once, thus consider splitting it in two by commenting out some left joins and corresponding count selects.

borriglione

    <global>
        <helpers>
            <romogonefieldlimit>
                <class>Rom_Phyderma_Block</class>
            </romogonefieldlimit>
            <ops>
                <rewrite>
                    <payment_request>Rom_OgoneFieldLimit_Helper_Payment_Request</payment_request>
                </rewrite>
            </ops>

borriglione

Urls

• Jobmixer Legacy: http://localhost:8080/
• Jobmixer Legacy Manager: http://localhost:8080/backend_dev.php (testadmin/testadmin)
• Jobmixer Legacy API: http://localhost:8080/api_dev.php
• Jobmixer Core: http://localhost:9000/
• Jobmixer Manager: http://localhost:8081/

PHPMyAdmin starten:

borriglione

<?xml version="1.0" encoding="UTF-8"?>
<result>
    <grp id="G1">
        <fld name="YBPCNUM" type="Char">PO109009</fld>
        <fld name="YITMREF" type="Char">PV00068203</fld>
        <fld name="YSAU" type="Char">UN</fld>
        <fld name="YQTY" type="Decimal">6</fld>
        <fld name="YDAT" type="Date">20161110</fld>
        <fld name="YPRITYP" type="Integer">1</fld>
        <fld name="YFCYVEN" type="Char">TOL</fld>

borriglione

Duplicate Checks
================

http://www.albertomariarossi.it/howto-solve-url-rewrite-indexing-errors-in-magento/

1- Check for duplicate SKUs
---------------------------
SELECT
DISTINCT(`sku`) as `sku`,
COUNT(`sku`) as `skuCount`, `entity_id` FROM `catalog_product_entity`

borriglione

diff --git a/app/code/community/Netresearch/OPS/controllers/ApiController.php b/app/code/community/Netresearch/OPS/controllers/ApiController.php
index 61f5154..e14f995 100644
--- a/app/code/community/Netresearch/OPS/controllers/ApiController.php
+++ b/app/code/community/Netresearch/OPS/controllers/ApiController.php
@@ -32,6 +32,24 @@ class Netresearch_OPS_ApiController extends Netresearch_OPS_Controller_Abstract
     public function postBackAction()
     {
         $params = $this->getRequest()->getParams();
+        /**
+         * Hotfix