Home | panticz.de

Magento: change the required / minimum password length

<?php
$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/password/validation.js.diff";

echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

Links
http://www.magentocommerce.com/boards/201210/viewthread/18197/#t62474

Magento: Delete single order

install http://www.magentocommerce.com/magento-connect/EMThemes.com/extension/4562/em_deleteorder

<?php
$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/order/Grid.php.diff";

echo "<div><pre>";
</pre></div>

$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/order/OrderController.php.diff";

echo "<div><pre>";
</pre></div>

$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/order/delete.magento.test.order.sql.txt";

echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

Links
http://inchoo.net/ecommerce/magento/delete-test-orders-in-magento/ - Delete test orders in Magento
http://www.magentocommerce.com/magento-connect/EMThemes.com/extension/4562/em_deleteorder - Seamless Delete Order Module
http://www.magentocommerce.com/boards/viewthread/207792/P15/
http://www.magentocommerce.com/boards/viewthread/1680/P345/

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 "<div><pre>";
</pre></div>

$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 "<div><pre>";
</pre></div>

$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

Get latest driver
https://www.intel.de/content/www/de/de/download/17809/685225/storcli-standalone-utility.html

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

apt install -y unzip
wget https://downloadmirror.intel.com/685225/StorCLI_007.1704.0000.0000.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

dpkg -x /tmp/versionChangeSet/univ_viva_cli_rel/storcli_All_OS/Ubuntu/storcli_*_all.deb /tmp/versionChangeSet/univ_viva_cli_rel/storcli_All_OS/Ubuntu/
/tmp/versionChangeSet/univ_viva_cli_rel/storcli_All_OS/Ubuntu/opt/MegaRAID/storcli/storcli
ln -s /tmp/versionChangeSet/univ_viva_cli_rel/storcli_All_OS/Ubuntu/opt/MegaRAID/storcli/storcli /sbin/MegaCli

cp /scripts/MegaCli/MegaCli64  /usr/sbin/
ln -s /usr/sbin/MegaCli64 /usr/sbin/MegaCli
cp /scripts/MegaCli/lib/$(uname -m)/libsysfs.so.2.0.2  /usr/lib64/

Commands
https://downloadmirror.intel.com/27433/eng/storcli_mr7.2_rel-notes.txt

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 "<div><pre>";
</pre></div>

$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 "<div><pre>";
</pre></div>

$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/

Install uShare (UPnP server)

<?php
$URL="https://raw.githubusercontent.com/panticz/installit/master/install.ushare.sh";

echo "wget $URL -O - | bash -";
echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

Web interface
http://YOUR_SERVER_IP:49152/web/ushare.html

Links
http://ushare.geexbox.org/

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 "<div><pre>";
</pre></div>

$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 "<div><pre>";
</pre></div>

$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 "<div><pre>";
</pre></div>

$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 "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

Magento: customized category banner block

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

echo "$URL";
echo "<div><pre>";
</pre></div>

$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 "<div><pre>";
</pre></div>

$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 "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

Magento: add proceed to checkout button to message

<?php
$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/cart/CartController.php.diff";

echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

Optional: fix CSS
add to ./skin/frontend/default/default/css/styles.css
.proceed-to-checkout {
padding-top:8px;
}

Install Wine

Install
https://gitlab.winehq.org/wine/wine/-/wikis/Debian-Ubuntu

sudo mkdir -pm755 /etc/apt/keyrings
sudo wget -NP /etc/apt/sources.list.d/ https://dl.winehq.org/wine-builds/ubuntu/dists/plucky/winehq-plucky.sources
sudo dpkg --add-architecture i386
wget -O - https://dl.winehq.org/wine-builds/winehq.key | sudo gpg --dearmor -o /etc/apt/keyrings/winehq-archive.key -
sudo apt update
sudo apt install --install-recommends winehq-staging

[embed_url: https://raw.githubusercontent.com/panticz/installit/master/install.wine.sh]

winetricks

sudo apt-get install -y winetricks
#sudo winetricks --self-update

# winetricks BASH completion
wget https://raw.githubusercontent.com/Winetricks/winetricks/master/src/winetricks.bash-completion -O- | sudo tee /etc/bash_completion.d/winetricks
source /etc/bash_completion.d/winetricks

Downgrade to Wine 1.2.x (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

Snap package
https://snapcraft.io/wine-platform-6-stable

Debug

wine --version

Compile wine (deprected)