Rateb BEN MOUSSA proxium

## Drop-all-tables-in-database
# Drop all tables from YOUR_DBSCHEMA_NAME
mysql --user=YOUR_USERNAME --password=YOUR_PASSWORD -BNe "show tables" YOUR_DBSCHEMA_NAME | tr '\n' ',' | sed -e 's/,$//' | awk '{print "SET FOREIGN_KEY_CHECKS = 0;DROP TABLE IF EXISTS " $1 ";SET FOREIGN_KEY_CHECKS = 1;"}' | mysql --user=YOUR_USERNAME --password=YOUR_PASSWORD YOUR_DBSCHEMA_NAME

## gist:7baf858c6fadd24154ad
Verifying I am +ratebbenmoussa on my passcard. https://onename.com/ratebbenmoussa

## miscellaneous.sh
# Use those commands to check for duplicate lines in <file>

# The more verbose --count flag with the GNU version:
sort <file> | uniq -c

# The more verbose --count flag with the GNU version:
sort <file> | uniq --count

# Show only print duplicate lines
sort <file> | uniq -d

## search pattern line
# search recursively showing filename and line
grep -Hrn --exclude-dir=.git 'search term' path/to/files

# with support color
grep -Hrn search . | less -r

## Remote debug using xDebug
# You should enable xDebug remotely then create the Tunnel
ssh -R <remote xDebug port>:127.0.0.1:<local xDebug configured port> username@remote_host -N -v -v

# * sudo netstat -lptu|grep -i <local xDebug configured port>
# Example output:
tcp        0      0 *:9001                  *:*                     LISTEN      11902/java

## bumpversion.sh
#!/bin/bash

# works with a file called VERSION in the current directory,
# the contents of which should be a semantic version number
# such as "1.2.3"

# this script will display the current version, automatically
# suggest a "minor" version update, and ask for input to use
# the suggestion, or a newly entered value.

## magento_dummy_simple_products_generation.php
<?php

// env config
ini_set('display_errors', 1);
umask(0);

// mage setup
require_once dirname(__FILE__).'/../app/Mage.php';
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

## Show_Product_Count_Per_Category.php
<?php

/**
 * @param $category
 * @return int
 */
public function getProductCount($category)
{
    $productTable = Mage::getSingleton('core/resource')->getTableName('catalog/category_product');

## layout_xml_via_event.php
<?php
/*
config.xml
<?xml version="1.0"?>
<config>
    <modules>
        <Loewenstark_Layout>
            <version>1.0.0.0</version>
        </Loewenstark_Layout>
    </modules>

## export_commit_files.sh
git diff-tree -r --no-commit-id --name-only --diff-filter=ACMRT <commit ID ex:b9e0245> | tar -czf file.tgz -T -
	# Drop all tables from YOUR_DBSCHEMA_NAME
	mysql --user=YOUR_USERNAME --password=YOUR_PASSWORD -BNe "show tables" YOUR_DBSCHEMA_NAME \| tr '\n' ',' \| sed -e 's/,$//' \| awk '{print "SET FOREIGN_KEY_CHECKS = 0;DROP TABLE IF EXISTS " $1 ";SET FOREIGN_KEY_CHECKS = 1;"}' \| mysql --user=YOUR_USERNAME --password=YOUR_PASSWORD YOUR_DBSCHEMA_NAME
	# Use those commands to check for duplicate lines in <file>

	# The more verbose --count flag with the GNU version:
	sort <file> \| uniq -c

	# The more verbose --count flag with the GNU version:
	sort <file> \| uniq --count

	# Show only print duplicate lines
	sort <file> \| uniq -d
	# search recursively showing filename and line
	grep -Hrn --exclude-dir=.git 'search term' path/to/files

	# with support color
	grep -Hrn search . \| less -r
	# You should enable xDebug remotely then create the Tunnel
	ssh -R <remote xDebug port>:127.0.0.1:<local xDebug configured port> username@remote_host -N -v -v

	# * sudo netstat -lptu\|grep -i <local xDebug configured port>
	# Example output:
	tcp 0 0 :9001 :* LISTEN 11902/java
	#!/bin/bash

	# works with a file called VERSION in the current directory,
	# the contents of which should be a semantic version number
	# such as "1.2.3"

	# this script will display the current version, automatically
	# suggest a "minor" version update, and ask for input to use
	# the suggestion, or a newly entered value.
	<?php

	// env config
	ini_set('display_errors', 1);
	umask(0);

	// mage setup
	require_once dirname(__FILE__).'/../app/Mage.php';
	Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
	<?php

	/**
	* @param $category
	* @return int
	*/
	public function getProductCount($category)
	{
	$productTable = Mage::getSingleton('core/resource')->getTableName('catalog/category_product');
	<?php
	/*
	config.xml
	<?xml version="1.0"?>
	<config>
	<modules>
	<Loewenstark_Layout>
	<version>1.0.0.0</version>
	</Loewenstark_Layout>
	</modules>