The MySQL replace syntax is pretty simple to use. For example, let's say using wordpress and you would like to replace all post titles with 2013-2014 to 2014-2015, you can simply use the following SQL syntax: UPDATE wp_posts SET post_title = … [Continue reading]
Paypal IPN eCommerce Payment Transaction Integration Notes
1. You need either a business or premier account to use IPN. (sourceforge) 2. Enable Auto Return (in Paypal > Profile > My Seller Tools > Website Preferences > Auto Reply > On) to redirect users back to your site after making a … [Continue reading]
RSS To Feedburner To Twitter & Google Reader: Disable W3 Total Cache (W3TC) Feed Caching
The setup When a new article is written, wordpress will update the blog RSS and this feed always contains the latest contents of your blog. For this blog, that's davidtan.org/feeds. Some people uses feedburner to publish and track where their … [Continue reading]
Clear All Google Chrome Cache & Browsing History
Here's how you can clear Google Chrome's browser cache and all the history of which websites/pages that you've previously visited. Long story short, use the keyboard shortcut key CTRL+SHIFT+DEL to get the following: The instruction are really … [Continue reading]
Gadgets Review: Best Apple iPad Accessories
I have an iPad and i love it. Here I present you with a list of some of the most useful iPad accessories that I've found. … [Continue reading]
How Not To Write A SEO Proposal
I'm getting lots of spam mails and spam comments lately selling me SEO services promising that I'll rank at page 1 for my keywords, get more traffic and make more money. Although it's true that ranking on page 1 in google will get more traffic to my … [Continue reading]
Magento Encryption Key Location
You are given an encryption key after Magento is installed successfully. This key is just a text string and stored in a xml file called local.xml in your magento installation folder. … [Continue reading]
Perl MP3::Tag Module Software Error Writing of ID3v2.4 is not fully supported (prohibited now via `write_v24′) Solution
While working on a project to read and write mp3 id3 tags using Perl's MP3 Tag module, I found out that I was getting this error: Software error: Writing of ID3v2.4 is not fully supported (prohibited now via `write_v24'). For help, please send … [Continue reading]
Getting Netbeans 7.0.1 To Work With SVN 1.7 Solution
Upgraded to TortoiseSVN 1.7 and found out that Netbeans 7.0.1 doesn't recognize some of the checked-out source code using TortoiseSVN 1.6. Here's how you can get Netbeans to work with SVN 1.7. … [Continue reading]
Apple IOS 5.0.1 Direct Download Link for iPhone 4S, iPhone 4, 3GS, iPad 2, 1, iPod touch
Updated my iPhone 4 to IOS 5.0.1 through iTunes. Was using 4.3.3. previously and main reason for upgrading was to get the cool notification center on my iPhone. For those who don't use iTunes, here are the direct download links from Apple (not from … [Continue reading]