How To Completely Block Facebook On Computer

If you are following our blog regularly then you may already know that you can block any website on your computer by editing Hosts file.The major advantage of this trick is that you don’t need any addtional software to block websites but it has its own Flaw.Host file cannot block website access through Proxy or VPN network.Lately I have been trying to figure out  perfect solution that is free and can completely block facebook even via proxy or VPN.
FB Limiter is a windows application that can completely restrict access to facebook and Youtube on your computer.It is available in both free and paid versions.The Free version allows only complete blocking of youtube and facebook whereas in paid version you will have the ablity to block or unblock these sites for specific interval of time.

Features Of FB Limiter

• Block facebook and youtube access on your computer to anyone who uses it (Normal Lock)
• Limit facebook and youtube access to specific times during the week (e.g. Allow your kids to use facebook only one hour a day) (Time Lock - Pro version)
• Block facebook and youtube access to yourself for specific time duration. In cases when you are too much distracted and want to be sure you will not get a chance to use facebook or youtube. (Total Lock - Pro version)
• Control access to facebook on daily basis. (e.g. You could limit usage of facebook to just one hour daily) (Duration Lock - Pro version)

How To use Fb Limiter?

Grab your free copy of FB limiter by clicking here.Install and run the software on your computer.You will need to register for a free account to unlock the software.Once registered you will be greeted by a friendly user Interface (see screenshot below)

Now you can block these website on a single click of mouse.
Another great feature of this softwae is that it is password protected.Even if somebody know that you are blocking websites using FB limiter still they won’t be able to unblock them as the software will ask for a password before it can be used.
This software is compatible with windows xp service pack 2 and later.So test out this software and share you experience via comments.

How To Save Gmail Attachments Directly to Google Drive Source

Google is adapting quite well with latest technologies and Google Drive is another product in their already well equipped arsenal of Products.If you aren’t aware about Google Drive, its a cloud computing service launched by Google few days back to compete with Dropbox and SkyDrive.I already wrote a detailed review of Google drive and if you are not sure whether which service you should opt for then you must read detailed comparison of Dropbox, SkyDrive and Google Drive.

Since it is a product from Google we can expect it to be integrated with other services from the search engine giant.As of now you can directly open and save Google Docs files in you Google Drive account but what about email attachments? They shouldn’t be ignored Right? There is no official update regarding the time-frame in which Gmail and Google Drive will be integrated but a chrome developer has made an extension that will fulfill this purpose.

Gmail Attachments To Drive is a Google chrome extension developed by Josh Sullivan and is available for download in Chrome app store.
Here are Steps Save Gmail Attachments Directly ti Google Drive

Download and install Gmail Attachments To Drive addon for chrome.
Now open Login into your Gmail account and open any mail with document (pdf,docx etc) attachment.Now you will notice Save to Drive just below your attachment.Click on it and your file will automatically get stored in Google Drive.
However the extension only supports documents like pdf, docx, rtf etc and it cannot save videos and compressed files like .rar or .zip files directly to Google drive.For these type of documents you have to perform the task manually.

How To Change WordPress Admin Password From SQL Database Source

Rarely you will face such a situation when you will need to change your wordpress password from SQL database because if you ever forget your password you can use the Forgot Password feature using which your new password will be emailed into your inbox. However if your website gets hacked or due to any reason you lose access to both your email and wordpress than such a sitution can be handled by changing the password from SQL.

If you are a non-programmer even then you can’t go wrong with this process as it is too simple but make sure that you don’t change anything other than mentioned in the steps below.

Open Hosting Account.
Select PhpMyAdmin from your hosting. In Screenshot Below I have Shown PhpMyAdmin in Cpanel Hosting

How to reset WordPress Admin Password from SQL

Now Select your WordPress database from the dropdown menu in Left Sidebar. After you select the appropriate database the page will automatically reload and your tables will be visible.
Now look at the top navigation bar and click on the SQL tab.
In the Text area type the following code

UPDATE `wp_users` SET `user_pass` = MD5( "new_password_here" ) WHERE `wp_users`.`user_login` = "admin_username";

Here you will replace new_password_here with your new password you want to set and admin_username with new administrator username.

Code for How to reset WordPress Admin Password from SQL

Now click on the Go Button and your Username and password will get changed.

Login into your wordpress account with new username and password.This method works on self hosted wordpress.

How to create A Quick LAN Connection Between Two Computers In Windows

First go and buy the straight patch Ethernet LAN cable(make sure that ‘patch’ or ‘crossover’ is written on the cord) and connect them to both computers.

In Windows XP: Go to Network Connections Control Panel, right-click Local Area Network connection and select Properties. Now select Internet Protocol(TCP/IP) and click Properties.

In Windows Vista: Go to Network and Sharing Center, select Manage Network Connections, right-click Local Area Network connection and select Properties. Now select Internet Protocol Version 4(TCP/IPv4) and click Properties.

Now once you are inside the TCP/IP properties of your computer, click Use the following IP and enter 192.168.0.1 as IP address and 255.255.255.0 as subnet mask. Leave the other details blank and click OK.

Internet Protocol IP Properties

Now go to TCP/IP properties of the second computer and enter the same details except the IP address, which should be 192.168.0.2 and click OK.

Internet Protocol IP Properties 2

Now the networks are ready, you might need to restart both computers in some cases. If you are looking to share the Internet Connection between two computers, go to Local Area Network properties again and click on Sharing tab. Here you can select the enable internet connection sharing.

local area connection internet sharing

To share files and folders between the two computers, go to the properties of that file/folder and select Sharing tab. Click Share to being sharing it on the network.

sharing properties

Let me know if this works for you. Enjoy!

Recovery of External HDD after worm attack

Recovery of External HDD after worm attack
I have a Seagate 500 GB External Hard disk which I share between office & home. Recently, I noticed for the HDD, there are shortcut links for all the folders . I could open the folders in a new explorer window. Next day, my office computer antivirus detected attack in the HDD with Worm:Win32/Dorkbot!lnk. It deleted all the shortcuts. Now I can not find/open the folders though the files are there. I can understand the files are there during virus scanning or though disk usage.
Please help how to recover the data?

see if they are made hidden ?
Use Recuva and recover lost files.
Recovery of External HDD after worm attack.