Add CMS page links to top navigation in magento

I had a site running on magento 1.6.2 CE.

To add a menu item, first of all you need to find out where it is added into template file.

Following file is rendering categories as a menu on top navigation

By Vikas
Tags: magento
Securing you ASP scripts for SQL injection

Recently I got a client email that his site is affected by malware and Trojan virus. Google safe browsing tool and other firewall security gateway was blocking some of the site URLs.

Site was written in classic asp. When I look into the file contents, no files were modified. Normally if hackers get the ftp details then they modify files and add some iframe code that will load other virus affected sites. But this wasn't case here. So there may be a case of SQL injection. When I looked into database tables, I found some of the fields with having some html code. That html code was loading other sites which are virus infected. Our site is not allowing anyone to add/edit records, however records were modified. This was done by SQL injection using query string parameter.

By Vikas
Tags: asp, SQL injections
Cloning SVN repository to GIT on Windows

Since couple of weeks working on implementing Git Repository for our codebase of our all projects. Before this we were using SVN as versioning control but as Git getting more popularity we decided to move Git. Week ago wrote post regarding creating Git server and move some of code to Git which was not in any version control. Now it was time to move all our SVN repositories to GIT and of course do not want to lost all my code revision, comments etc. GIT support cloning from SVN which make job much easier for us. There are three easy steps to cloning SVN to GIT.

By Pritesh
Tags: GIT, SVN
Calculate HMAC-SHA256 digest using user defined function in ColdFusion

Recently I am working on OpenID 2.0 protocol, in which I require HMAC-SHA256 (Hash Message Authentication Code - Secure Hash Algorithm using 256 bit key length) digest to generate Encrypted MAC key. For that, I use following UDF HMAC_SHA256(): I wrote this function by taking reference from OpenID Consumer library.

By Mahavir Dhruv
Tags: OpenID, HMAC-SHA
Decode HTML code with jQuery

In one of the project, we are storing all form fields in json string format (i.e. {"name":"myname", "email":"", "address":"myaddressdetail"}) in the database table. To avoid the JSON parsing error due to any special characters while retrieving data from database and deserialize the json string, I convert all special characters in the fields value with their HTML-escaped equivalents (by using coldfusion HTMLEditFormat() function). Till this it's works fine but I found the issue with the HTML-escaped equivalents code when I am going to retrieve data with AJAX and placed value to appropriate input field. At here I want to convert the HTML-escaped equivalents code to appropriate special character (i.e. & needs to be converted into & sign).

By Nirav
Tags: html, javascript, jQuery
ColdFusion Schedule Task Issue with Daily Every task

Schedule task in ColdFusion is something I love most and I guess all ColdFusion developers are too. It is really easy to schedule any page to run for given specific date - time or periodically, even you can easily add it through code by CFSCHEDULE tag. For who are new to admin interface of schedule task it will look like below. In frequency there are three option 1. One-Time 2. Recurring 3. Daily Every, I think option caption itself mention what it will do. One common thing in all three options is you need to provide start time to tell schedule task runner when to start execution.

By Pritesh
Tags: ColdFusion, schedule task
Scroll issue with iPad browser for framed window

Recently one of our client report scrolling issue when they try to view their website on iPad (or any mobile device). Page they are looking has iframe with scroll so basically two scrolls on browser but when user trying to scroll within iframe anyhow iOS browser doesn't able to recognize it and always scroll main window. I have gone through iPad guide provided Apple which mention that we can scroll within iframe by two fingers and use single finger to main window. I tried but doesn't work for me (may be it support new iPad only) and ask client to do so but it doesn't work for him as well.

By Pritesh
Tags: iPad, ColdFusion, iFrame
Tag SES URL throw 404 error if tag has special characters other than '-'

Recently working on MuraCMS (opensource Content Management System build on CFML) for our company website. While working on blog section where we used to have tag for each post. For one of post we have tagged which include space and dot, when we click on through tag link SES url it throws 404 error. This only happen if you are using URL rewriting to remove index.cfm from URL. After little bit of debugging I found that it was due to rewrite URL, default rewrite URL script provided by MURA doesn't support redirection of URL having special character other than '-'. This is will work fine for search by page, category etc as MURA itself change it value with SEO friendly but in case of tag it doesn't.

By Pritesh
Tags: Mura CMS, ColdFusion, Regular Expression
Configure GIT server on windows server 2008

We are using SVN since long time as version control system for our local development and quite happy with it as well until I come across GIT. GIT get lots of popularity in last couple of years but never get chance to look into this Although we were hosted some of our open source project/code on and pretty easy to use and impressed with forking ability. After getting use to with GIT it was time to implementation, we do not want to move our code to or other same kind of website rather create Git server on our local environment only and on windows server.

Tags: GIT, WIndow, VersionControl
ColdFusion Schedule Task Error: The Cron service is not available.

Recently I face strang error in five years of career in ColdFusion. 
Message: "The Cron service is not available." 
Detail: "This exception is usually caused by service startup failure. Check your server configuration."

By Pritesh
Tags: ColdFusion, schedule task, neo-cron