My Programming Life

Git script which shows little bit advanced status. Save with Preferred file name in /usr/local/bin/XX branch="" branches="git branch --list" ESC_SEQ="\x1b[" COL_RESET=$ESC_SEQ"39;49;00m" COL_RED=$ESC_SEQ"31;01m" while read -r branch; do clean_branch_name=${branch//\*\ /} description=`git config branch.$clean_branch_name.description` if [ "${branch::1}" == "*" ]; then printf "$COL_RED$branch$COL_RESET $description \n" else printf " $branch $description\n" fi done Use the following command to add a description to your local branches. git branch --edit-description

SELECT * FROM core_config_data INTO OUTFILE '/tmp/core_config.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '`' LINES TERMINATED BY '\n';

I have experienced problems when installing two monitors in Ubuntu. Following script will help you to solve this problem. I had problems when saving below values so I created a script and put it to the startup. #!/bin/sh xrandr --output VGA-0 --mode 1920x1080 --pos 1280x0 --rotate normal --output DVI-I-1 --off --output DVI-I-0 --mode 1280x1024 --pos 0x0 --rotate normal --output HDMI-0 --off

Following statement will compare values in two databases and gives you records that not matched. SELECT stage,live,path,scope_id FROM ( SELECT (CASE WHEN (S.value = L.value) THEN '' ELSE 'N/M' END) as matched, S.scope_id, S.path, S.value AS 'stage', L.value AS 'live' FROM cin_stage.core_config_data S INNER JOIN cin_live.core_config_data L ON S.path = L.path ) RES WHERE matched = 'N/M' ORDER BY scope_id

I got this error suddenly while accessing the magento site. SQLSTATE[HY000] [1129] Host 'user.workgroup' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' Solution use below command in console mysqladmin flush-hosts or log in to  mysql with a different host if its implemented on network environment and use below statement; FLUSH HOSTS; Or Restart the mysql server

<?php /* | File: url_checker.php | Info: Take CSV as inpu and check url status. | Usage: php url_checker.php | | CSV file contain URLS | | ex: | www.site.com/url1 | www.site.com/url2 | www.site.com/url3 | www.site.com/url4 | www.site.com/url5 | www.site.com/url6 | www.site.com/url7 | */ $file = fopen("urls.csv","r"); while(! feof($file)) { $row = fgetcsv($file); $handle = curl_init($row[0]); curl_setopt($handle, CURLOPT_RETURNTRANSFER, TRUE); $response = curl_exec($handle); $httpCode = curl_getinfo($handle, CURLINFO_HTTP_CODE); if($httpCode!=200) { //Following will use teminal colors to echo "\033[01;31m{$httpCode} \033[0m {$row[0]} \n"; } else { echo $httpCode."\n"; } } echo "Finished fetching..."; fclose($file); ?>

I had a problem with generating the Google sitemap using cron job. To do that you can simply change following database value. SELECT * FROM core_config_data WHERE path = 'crontab/jobs/sitemap_generate/schedule/cron_expr' Change the value as you set time in cron jobs. EX: Generate the Sitemap for every 5 minutes value = */5 * * * * That's it. Now you have to worry about cron is working or not. Just type following in your browser and hit enter. http://youresite.com/cron.php

SET FOREIGN_KEY_CHECKS=0; TRUNCATE `sales_flat_creditmemo`; TRUNCATE `sales_flat_creditmemo_comment`; TRUNCATE `sales_flat_creditmemo_grid`; TRUNCATE `sales_flat_creditmemo_item`; TRUNCATE `sales_flat_invoice`; TRUNCATE `sales_flat_invoice_comment`; TRUNCATE `sales_flat_invoice_grid`; TRUNCATE `sales_flat_invoice_item`; TRUNCATE `sales_flat_order`; TRUNCATE `sales_flat_order_address`; TRUNCATE `sales_flat_order_grid`; TRUNCATE `sales_flat_order_item`; TRUNCATE `sales_flat_order_payment`; TRUNCATE `sales_flat_order_status_history`; TRUNCATE `sales_flat_quote`; TRUNCATE `sales_flat_quote_address`; TRUNCATE `sales_flat_quote_address_item`; TRUNCATE `sales_flat_quote_item`; TRUNCATE `sales_flat_quote_item_option`; TRUNCATE `sales_flat_quote_payment`; TRUNCATE `sales_flat_quote_shipping_rate`; TRUNCATE `sales_flat_shipment`; TRUNCATE `sales_flat_shipment_comment`; TRUNCATE `sales_flat_shipment_grid`; TRUNCATE `sales_flat_shipment_item`; TRUNCATE `sales_flat_shipment_track`; TRUNCATE `sale...

SET FOREIGN_KEY_CHECKS=0; -- reset customers TRUNCATE customer_address_entity; TRUNCATE customer_address_entity_datetime; TRUNCATE customer_address_entity_decimal; TRUNCATE customer_address_entity_int; TRUNCATE customer_address_entity_text; TRUNCATE customer_address_entity_varchar; TRUNCATE customer_entity; TRUNCATE customer_entity_datetime; TRUNCATE customer_entity_decimal; TRUNCATE customer_entity_int; TRUNCATE customer_entity_text; TRUNCATE customer_entity_varchar; TRUNCATE log_customer; TRUNCATE log_visitor; TRUNCATE log_visitor_info; ALTER TABLE customer_address_entity AUTO_INCREMENT=1; ALTER TABLE customer_address_entity_datetime AUTO_INCREMENT=1; ALTER TABLE customer_address_entity_decimal AUTO_INCREMENT=1; ALTER TABLE customer_address_entity_int AUTO_INCREMENT=1; ALTER TABLE customer_address_entity_text AUTO_INCREMENT=1; ALTER TABLE customer_address_entity_varchar AUTO_INCREMENT=1; ALTER TABLE customer_entity AUTO_INCREMENT=1; ALTER TABLE customer_entity_datetime AUTO_INCREME...

$productId =1; $loadpro=Mage::getModel('catalog/product')->load($product->getId()); $mediaApi = Mage::getModel("catalog/product_attribute_media_api"); $mediaApiItems = $mediaApi->items($product->getId()); foreach($mediaApiItems as $item) { $mediaApi->remove($loadpro->getId(), $item['file']); } $loadpro->save();

SELECT table_name,column_name,table_schema FROM INFORMATION_SCHEMA.COLUMNS WHERE column_name like '%mail%'

I have used DbVisualizer 9.0 in Ubuntu 13.04. Because of that I cannot use other software like netbeans and chrome due to slowness of their process. So I moved to different Mysql Admin tools and Tora is great tool. http://torasql.com/ here is how you can install it in Ubuntu $ sudo apt-get install tora $ sudo apt-get install libqt4-sql-mysql libqt4-sql-psql libqt4-sql-sqlite libqt4-sql-odbc libqt4-sql-tds

I just want to mention here I found some of my friends offering cheap web hosting in fiverr. Checkout their gigs. They offer following options for $5. Its Cheap I guess. Why don't you give a try Below are the links to those gigs. You can pay them via Paypal http://fiverr.com/calestomedia/provide-a-genuine-5-websites-hosting-package-for-1-year-including-cpanel-fantastico-sitebuilder-500-free-templates http://fiverr.com/llcoollasa/give-you-100mb-hosting-space

Again I Spent quiet time to set `Use Default Value` in Magento.  I wanted to set Product Status to be `Use Default  Value` under store views. I tried some methods and checked not lucky for me so i tested with the database.

You might want to update or insert Database single statement rather than checking the record is inserted or and again go to the update. But using following SQL statement you can run First run and check Insert statement and if that fails Update statement after that.

Override Magento Module MD5 to SHA1 Here I am going to override the hash function in Encryption class to sha1 instead of md5. Original file is located in below path.

Ok.I have been faced for this cross domain request using ajax last week and i got real pain when i tried to use it. I tried with jquery ajax and read lots of articles from the Internet. Reading made me to do this post. First i tell you what was my scene. I had to do a validation regarding some value. I request this via Ajax.

A SQL-DMO object exposes the attributes of a Microsoft® SQL Server™ 2000 component. Distributed Management Objects (DMO) is a set of programmable objects that come with SQL Server that make it easy to programatically administer your databases. SQL-DMO is actually the foundation of Enterprise Manager, so you can pretty much do anything programatically that you can do in the management tools. Some of these tasks include :

Here is a post how to send Email using VB.NET including your Gmail Account

How To Remove index.php How To use CSS,Javascript & etc in your site Before Start