Posts

Showing posts with the label how-to

6 steps to create local copy of your live WordPress site

I know there are bunch of other posts on how to create local copy of your live WordPress site, however, they are too much descriptive. Here I will show you step by step approach rather than descriptive one. 1. Export your live database into an sql file. 2. Download/Copy your live WordPress site folder to your local machine. 3. Move your downloaded WordPress site files inside local server’s web root. 4. Open exported sql file using notepad or any other editor of your choice and replace “http://www.yoursite.com” with “http://localhost/wordpress” and Save that file. (CAUTION: This file could be very large so replacing might take time. Command for replacing file content on *nix based system.) 5. Import database from that sql file into your local mysql database. 6. Open wp-config.php file which you can find inside your copied WordPress folder. In that file replace DB_NAME with your local WordPress database which you imported in above step. DB_USER with database user name. D...

Step by step Cordova calabash-ios automation

Step by step guide about how to integrate calabash-ios with Cordova in an automated way without opening Apple Xcode. Note: First try steps given on https://github.com/calabash/calabash-ios . If those steps aren’t working for you then try following steps. For me only manual steps given on above link worked. Also this script doesn’t create separate target same as “calabsh-ios setup” command. I also presume that you have already setup your cordova project and nodejs . sudo gem install calabash-cucumber If you get any error then try using following command sudo ARCHFLAGS=-Wno-error=unused-command-line-argument-hard-error-in-future gem install calabash-cucumber reference Go inside your Cordova project directory npm install xcode npm install fs-extra npm install underscore Download script “cordova-calabash-ios.js” from here and paste it inside your cordova project at www level (not inside www). (Note: This is very primitive script you can modify it according to your n...

iPhone 4s wifi grayed out temporary fix

Image
I am facing issues of WiFi button grayed out and battery draining very fast after upgrading from iOS 7.0 to iOS 7.0.3. I have been searching through internet right after this issue happened with my iDevice. My three colleagues don't have problems after upgrading to iOS 7.0.3 except for one saying battery draining is fast. Many people tried putting their iPhone's into freezer and I am one of them and it got fixed temporarily for at least 5 minutes. I kept it in freezer for 20 minutes and WiFi button reappeared. Interesting information, when in freezer it contracts hardware parts and WiFi reappears and again after sometime due to heat WiFi button gets grayed out again. You can see device logs by downloading iPhone configuration utility. Also I can see kernel panic logs related to WiFi inside iPhone diagnostic which you can see (if you have any) by going in Settings -> General -> About -> Diagnostic & Usage -> Diagnostic & Usage Data. Now question is,...

Repair anything yourself using guides on iFixit

Image
Recently, I raised my Macbook Pro's RAM up to 8 GB. My machine is Macbook Pro 13" (mid 2010). I was worried about opening my Mac and replacing RAMs myself. But still determined to change RAMs. After searching on internet I came across a website named iFixit.com . They say that it is a free repair manual. I followed this guide to change RAM. It is described in very simple and easy steps. Guide even tells you which tools will be required to perform repair. If you go to their about section, it states that, "We're building the free repair manual for everything". Also they encourage you to contribute repairs. You can follow this link to contribute repair. Currently you can find repair guides for following things Mac, Game Console, Phone, iPhone, Car & Truck, Camera, PC, iPad, iPod, Appliance etc. For those who are interested to know which RAM I used and from where I bought it. The answer for former is G.Skill SQ For MAC DDR3 4 GB and for later is Fl...

Monetize your Facebook application in four easy steps

Image
You have a great Facebook application and generating a decent amount of impressions then, probably, it's time to generate money from your Facebook application. There are various methods of monetizing, like displaying ads and/or using Facebook Credits. Facebook Credits are like a virtual currency. You can use it to buy virtual goods in any games or apps of the Facebook platform that accept payments. Currently, I am monetizing my Facebook application by the method of displaying ads. Follow below four simple and easy steps to start monetizing your Facebook application: Find the Facebook ads providers list by going on https://developers.facebook.com/adproviders/ Choose and register as a publisher with one of these ads providers. (Ads providers may take time because they will review your application.) Once ads providers review your application, you can create ads slots. Grab the code from those ads slots and place them into your Facebook application at appropriate place...

Map your trek route on Google Maps without any application andconnectivity?

Image
Last year on 16th of July, we trekked from Talapewadi to Bhimashankar. It was a very great experience and you feel relieved when you go close to the nature. While trekking as usual everyone was taking photographs and I was no exception. I was taking photographs using my brand new Nokia Lumia 800 (now I no longer own it) which has functionality of attaching GPS locations to clicked photographs. And luckily I clicked photographs on important turns of trek. Trek was of almost 23 kilometers. After returning home I used those photographs to extract GPS locations using Garmin Basecamp application. You can import these geotagged photos into Garmin Basecamp application. Give some nice name to the collection. Now right click on all photos and select "view in Google Earth" and you are done. So to summarize, the things that you will need to map your hike on Google Maps are as follows: A camera with geotagging facility. Software that can extract all the GPS co-ordinates from...

How to recover your forgotten ISP password from router?

Image
Most of us would like to use Internet on multiple devices at home or office. To use Internet on multiple devices, you need to make use of a router. Certainly you can share Internet connection using computer that is connected to Internet. However there are some limitations associated with that method. You have to keep that computer ON for others to let use Internet that will consume lots of power. Coming back to our real topic. So you have a router with ISP username and password in it and you don't remember the password. You can either call ISP and ask to reset the password that will take 2-3 days (may be more depends on willingness of ISP provider :)) OR you can follow below steps to recover the password: Make sure that you are connected to the router from which you have to recover ISP password. Login to your router using a web browser. Usually most routers have default IP address http://192.168.1.1 (unless you have changed it) which you have to type it in your browser's...

How to replace multiple spaces with one space?

Image
I came up with the situation of replacing multiple spaces with single space in SQL. I got the solution from a site but it was very difficult to understand at first look. So I got into deep to find out exactly how it works? I really liked the trick and it made me write this blog post. This could be useful where regex expressions are not available. The logic is explained in the video below. For visualization purpose space is represented as ‘@’ character and ‘#’ can be any random character which never occurs in strings as a normal character. I am repeating again, Consider @ = white space # = any random character that is never used as a normal character in strings. [sql] replace( replace( replace( trim(‘string’) , ‘@@’,’@#’ ) ,’#@’,’’) ,’#’,’’)[/sql] By the way the editor utility which I am using in this video is Notepad++ which is free and open source editor and a video utility to create video which I used is CamStudio it is also free and...