Magento: Erase saved credit card data

-- get order with saved cc data
SELECT so.increment_id
FROM sales_order_entity_varchar soev
INNER JOIN sales_order_entity soe ON soev.entity_id = soe.entity_id
INNER JOIN sales_order so ON soe.parent_id = so.entity_id
WHERE soev.attribute_id = 280
AND soev.VALUE != ""

-- get saved credit card owner
select value
from sales_order_entity_varchar
where attribute_id = 282
and entity_id in (
select entity_id
from sales_order_entity_varchar
where attribute_id = 280
and value != ""
);

-- erase credit card data by order id
SET @orderId = '100000013';

UPDATE sa

install phpMyAdmin

Check for current version
www.phpmyadmin.net

<?php
$URL="https://raw.githubusercontent.com/panticz/installit/master/install.phpMyAdmin.sh";
echo "wget -q --no-check-certificate $URL -O - | bash -";
echo " 

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";
?>

# todo, import tables
mysql --host=localhost --user=${DB_USER} --password=${DB_PASS} ${DB_NAME} < /var/www/phpMyAdmin/sql/create_tables.sql

Configure
cp config.sample.inc.php config.inc.php
vi config.inc.php
$cfg['blowfish_secret'] = 'terceS';

# configure user and db
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'YOUR_DB_USER';
$cfg['Servers'][$i]['password'] = 'YOUR_DB_PASS';
$cfg['Servers'][$i]['host'] = 'YOUR_DB_HOST';

# optionaly you can restrict whitch databases should by showed in phpMyAdmin
$cfg['Servers'][$i]['only_db'] = 'YOUR_DB_NAME';

OPTIONAL
<?php
$URL="http://dl.panticz.de/scripts/install.phpMyAdmin.optional.txt";
echo "wget $URL -O - | bash -";
echo " 

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";
?>

LSI / Broadcom MegaRAID Storcli

# install storcli (MegaCli)
# https://www.broadcom.com/products/storage/raid-controllers/megaraid-sas-9361-4i#downloads

apt install -y unzip
wget https://docs.broadcom.com/docs-and-downloads/raid-controllers/raid-controllers-common-files/007.0606.0000.0000_Unified_StorCLI.zip -O /tmp/StorCLI.zip
unzip /tmp/StorCLI.zip -d /tmp/
unzip /tmp/MR_SAS_Unified_StorCLI_*.zip -d /tmp
unzip /tmp/versionChangeSet/univ_viva_cli_rel/Unified_storcli_all_os.zip -d /tmp/
dpkg -i /tmp/Unified_storcli_all_os/Ubuntu/storcli_*_all.deb
ln -s /opt/MegaRAID/storcli/storcli64 /usr/local/sbin/storcli

or

Magento: Fix bug in bug in billing / shipping address edit

<?php
$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/address/address.book.phtml.diff";
echo " 

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";
?>

<?php
$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/address/dashboard.address.phtml.diff";
echo " 

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";
?>

German translation (./app/locale/de_DE/Mage_Customer.csv)
"Default Shipping Address will use the Billing Address","Sie haben noch keine Standard Versandadresse. Die Lieferung erfolgt an die Rechnungsadresse."
"Add a new address to my address book","Neue Versandadresse hinzufügen"

Links
http://www.magentocommerce.com/boards/viewthread/7520/

Magento create category with PHP API

<?php
// Magento login information
$mage_url = 'http://YOUR_MAGENTO_SERVER/index.php/api/?wsdl';
$mage_user = 'YOUR_SOAP_USER';
$mage_api_key = 'YOUR_SOAP_PASS';

// Initialize the SOAP client
$soap = new SoapClient($mage_url);

// Login to Magento
$sessionId = $soap->login($mage_user, $mage_api_key);

// create new category
$categ = array(
15334,
array(
'name' => 'New Category 1',
'is_active' => 1,
'available_sort_by' => array('name', 'price'),
'default_sort_by' => 'name'
),
'0'
);

try {
$id = $soap->call($sessionId

Magento: Sort by newest

cp ./app/design/frontend/base/default/template/catalog/product/list.phtml ./app/design/frontend/default/default/template/catalog/product/list.phtml
<?php
$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/sortby/list.phtml.diff";
echo "$URL";
echo " 

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";

/*
$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/sortby/sortby_newest.sql.txt";
echo "$URL";
echo " 

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";
*/

$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/sortby/toolbar.phtml.diff";
echo "$URL";
echo " 

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";
?>

OPTIONAL: change sort by for a attribute
<?php
$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/sortby/Toolbar.php.diff";
echo "$URL";
echo " 

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";
?>

Images
/sites/default/files/magento/sortby/toolbar.phtml.diff
/sites/default/files/magento/sortby/up.png

Translations
echo '"Newest first","Сначала новые"' >> ./app/locale/ru_RU/Mage_Catalog.csv

List some products on top
UPDATE magento.catalog_product_entity
SET updated_at = now( ) + INTERVAL 1 year
WHERE catalog_product_entity.sku in ('YOUR_PRODUCT_SKU');

Links
http://www.magentocommerce.com/boards/v/viewthread/1176 - set the default sort order for catalog pages?
http://www.magentocommerce.com/boards/viewthread/37324/P15/#t285109

Magento: customized category banner block

<?php
$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/categorybanner/local.xml";
echo "$URL";
echo " 

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";

$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/categorybanner/banner.phtml";
echo "$URL";
echo " 

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";

$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/categorybanner/my.banner.phtml";
echo "$URL";
echo " 

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";
?>

Install Wine

<?php
$URL="https://raw.githubusercontent.com/panticz/installit/master/install.wine.sh";
echo "wget $URL -O - | bash -";
echo " 

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";
?>

Downgrade to lastest Wine 1.2 (64 bit)
sudo apt-get remove wine1.4
cd /tmp
wget http://ie.archive.ubuntu.com/ubuntu/pool/universe/w/wine1.2/wine1.2_1.2.3-0ubuntu1_amd64.deb
wget http://ie.archive.ubuntu.com/ubuntu/pool/universe/n/nss-mdns/lib32nss-mdns_0.10-3.1ubuntu1_amd64.deb
sudo dpkg -i wine1.2_1.2.3-0ubuntu1_amd64.deb lib32nss-mdns_0.10-3.1ubuntu1_amd64.deb
wine --version

OPTIONAL: fake ie6 installation
wget kegel.com/wine/winetricks -P /tmp; sh /tmp/winetricks fakeie6

Compile wine
sudo add-apt-repository ppa:ubuntu-wine/ppa
sudo apt-get build-dep wine1.3
sudo apt-get --build source wine1.3
./configure
make

LINKS
http://appdb.winehq.org/ - supported applicatinos
http://www.winehq.org/site/download-deb - Wine for Debian based distributions
http://wiki.winehq.org/AdobePhotoshop
http://wiki.winehq.org/AdobeAcrobatPro

Subscribe to