Mehdi Chaouch mehdichaouch

Magento Snippets

Pear for 1.4, mage for 1.5. File downloaded into /downloader/.cache/community/

./pear download magento-community/Shipping_Agent
./mage download community Shipping_Agent

create different ssh key according the article Mac Set-Up Git

$ ssh-keygen -t rsa -C "[email protected]"

	<?php
	/**
	* Convert a comma separated file into an associated array.
	* The first row should contain the array keys.
	*
	* Example:
	*
	* @param string $filename Path to the CSV file
	* @param string $delimiter The separator used in the file
	* @return array

	SET @entityid = '3';

	SELECT ea.attribute_id, ea.attribute_code, eav.value AS 'value', 'varchar' AS 'type'
	FROM catalog_category_entity e
	JOIN catalog_category_entity_varchar eav
	ON e.entity_id = eav.entity_id
	JOIN eav_attribute ea
	ON eav.attribute_id = ea.attribute_id
	WHERE e.entity_id = @entityid
	UNION

	[user]
	name = Pavan Kumar Sunkara
	email = [email protected]
	username = pksunkara
	[init]
	defaultBranch = master
	[core]
	editor = nvim
	whitespace = fix,-indent-with-non-tab,trailing-space,cr-at-eol
	pager = delta

	<!DOCTYPE html>
	<head>
	<title>Stay Standalone</title>
	<meta name="apple-mobile-web-app-capable" content="yes">
	<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=no">
	<script src="stay_standalone.js" type="text/javascript"></script>
	</head>
	<body>
	<ul>
	<li><a href="http://google.com/">Remote Link (Google)</a></li>

	<?php
	#source: http://stackoverflow.com/questions/2934563/how-to-decode-unicode-escape-sequences-like-u00ed-to-proper-utf-8-encoded-char

	function replace_unicode_escape_sequence($match) {
	return mb_convert_encoding(pack('H*', $match[1]), 'UTF-8', 'UCS-2BE');
	}

	function unicode_decode($str) {
	return preg_replace_callback('/\\\\u([0-9a-f]{4})/i', 'replace_unicode_escape_sequence', $str);
	}

	// The rest of this code is currently (c) Google Inc.

	// setRowsData fills in one row of data per object defined in the objects Array.
	// For every Column, it checks if data objects define a value for it.
	// Arguments:
	// - sheet: the Sheet Object where the data will be written
	// - objects: an Array of Objects, each of which contains data for a row
	// - optHeadersRange: a Range of cells where the column headers are defined. This
	// defaults to the entire first row in sheet.
	// - optFirstDataRowIndex: index of the first row where data should be written. This

	# Credit http://stackoverflow.com/a/2514279
	for branch in `git branch -r \| grep -v HEAD`;do echo -e `git show --format="%ci %cr" $branch \| head -n 1` \\t$branch; done \| sort -r