Showing posts from June, 2013

How to recover your forgotten ISP password from router?

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 (unless you have changed it) which you have to type it in your browser's addre…

How to replace multiple spaces with one space?

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,
@ = white space
# = any random character that is never used as a normal character in strings.

replace( trim(‘string’) , ‘@@’,’@#’ )

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 open source.

How to get list of countries using firebug, jQuerify and Firefox

While working on a project I wanted a list of all possible countries for my web application. Of course I wanted to put it into database. The query was as shown below:

INSERT INTO Country VALUES(‘CountryName’,1,NOW(),1,NOW());

I found countries from Yahoo directories from this link.

Now imagine how long it would have taken If I would have copied each country name from that page to write insert queries. Instead I used firebug console. Once you open firebug console click on jQuerify (you have to install this add-on separately.)

In firebug console I typed following command

$('ul li a b').each(function(){
document.write("INSERT INTO Country VALUES('" + $(this).text() + "',1,NOW(),1,NOW());<br>");

And it generated following output

INSERT INTO Country VALUES(‘Afghanistan’,1,NOW(),1,NOW());
INSERT INTO Country VALUES(‘Albania’,1,NOW(),1,NOW());
INSERT INTO Country VALUES(‘Algeria’,1,NOW(),1,NOW());
INSERT INTO Country VALUES(‘Andorra’,1,NOW(),1,NO…

System wide equalizer for your Mac, Windows and Ubuntu

As the speed of internet is increasing, most of us prefer to hear songs/music or watch videos online (examples: Spotify, Youtube etc.) than downloading it.  However there are some people who would like to hear every beat of songs/music or while watching educational video preference would be to the vocals. When you hear music offline you can use equalizer available in music applications like Winamp, iTunes etc.

But when you hear music online you don’t have any option to alter equalizer. In this situation you need system wide sound booster or equalizer. I was also searching for the same kind of applications and I found following applications. For Mac - Boom For Windows - Audio Enhancer Bongiovi DPS Plugin For Ubuntu - PulseAudio Equalizer
If you know any other applications please do post in comments below.