Recover lost images from SD/MMC cards

A very nice and really working recovery tool is  PhotoRec. It’s a very cool commandline tool for Linux which is able to recover all images on a SD or MMC card that have been deleted accidentally. In my case my fingers where faster than my brain and so I had kicked three rally awesome images :-/. […]

Setup an static IP on Arch Linux

Setup an static IP on Arch Linux can be done by placing a config file in /etc/netctl/: $> sudo nano eth0-Valhalla As you can see, you have to install sudo first. Otherwise you have to switch to root user (su). In the file you have to place the following lines for example: Description=’Valhalla at home eth0′ […]

Wifi setup on Arch Linux

The following steps are showing how I did setup my wireless connection with an static IP on my ArchLinux driven RaspberryPi. You need to have installed sudo to uses this instructions: Update all packages: $> sudo pacman -Syu Install dialog package: $> sudo pacman -S dialog Install wpa_supplicant package $> sudo pacman -S wpa_supplicant Run wifi-menu: […]

Get stores last order increment ids

This can be done by the following database query: SELECT cs.store_id, csg.name AS group_name, cw.name AS website_name, cs.name AS store_name, increment_last_id AS last_increment_id, entity_type_code AS entity_code FROM eav_entity_store AS ees INNER JOIN eav_entity_type AS eet ON eet.entity_type_id = ees.entity_type_id INNER JOIN core_store AS cs ON cs.store_id = ees.store_id INNER JOIN core_store_group AS csg ON csg.group_id […]

Increment order increment ids for all stores

The following query increments the last increment ids for all store by 100: UPDATE eav_entity_store AS ees INNER JOIN eav_entity_type AS eet ON eet.entity_type_id = ees.entity_type_id SET ees.increment_last_id = ees.increment_last_id + 100 WHERE eet.entity_type_code=’order’; The actual values for each store can be queried as shown in Get stores last order increment ids.

Install CMS pages with your module

You can do this as shown in the following example of a Magento data setup script: <?php /* @var $installer Mage_Core_Model_Resource_Setup */ $oInstaller = $this; $oInstaller->startSetup(); $aCmsPages = [ [ ‘title’ => ‘FAQ’, ‘root_template’ => ‘two_columns_left’, ‘meta_keywords’ => ‘FAQ’, ‘meta_description’ => ‘FAQ’, ‘identifier’ => ‘faq’, ‘is_active’ => 1, ‘stores’ => 0, ‘sort_order’ => 0, ‘content_heading’ => […]

Install CMS blocks with your module

You can do this as shown in the following example: <?php /* @var $installer Mage_Core_Model_Resource_Setup */ $oInstaller = $this; $oInstaller->startSetup(); $oCmsBlocks = [ [ ‘title’ => ‘Footer bar for benefits’, ‘identifier’ => ‘footer-bar’, ‘content’ => <<<HTML <ul> <li>Shop Benefit 1</li> <li>Shop Benefit 2</li> <li>Shop Benefit 3</li> <li>Shop Benefit 4</li> <li>Customer Service (D): <a href=”tel:08008828838″ class=”tel”>0800 […]