Have the Brain with Fun

Here u can find some scientifically designed games , fun to reclaim brain

Replace the Column Contents using Update/Replace Query in Database

Consider a situation, that needs to modify some string part of a column in a table with a large amount of rows.

For such situations, manually modifying the database (by taking the dump of the table and changing the queries in the dump with editor by find and replace the column content) , would be a hectic process:-(. For that there is a simple Query to update and replace the part of the column content. Following is the syntax with example:

UPDATE table_name SET column_name = REPLACE(column_name,”original_string”,”replace_string”)[/sql]

Here is what I did to change the path URLs in all the previous posts.
[sql]UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`,”mydummysite.com/wp”,”tinytip.blogspot.com/blog”)[/sql]

Difference : Developer or Programmer

Developer and Programmer , the two words generally seen in the pages for some job profiles etc.. Then what is the exact difference between the two. As far as my knowledge says,

A Programmer is who writes the instructions in the language for the target of compilation and execution of the task, mostly if the better one would test for any bugs.

A Developer also includes programmer in himself as a start step. A Developer, has following the additional tasks....as follows:


* Spec documents
* Configuration management
* Code reviews
* Testing
* Automated tests
* Documentation
* Solving tough customer problems



So in aside of this concept, it can also be concluded as small independent software vendors tends to require developers rather than Programmers.

A good explaination of this one can be found here

ScreenShots using iPhone , without any app

Just Press Home button and Sleep/PowerOff button simultaneously.
You will get a flash on the iPHone screen and screenshot will be saved on the iPhoto library of the iPhone.

To view the screenshots on the mac os x, connect the iPHone to MAC OS X and open iPhoto App ,

Applications->iPhoto.app

select the iPhone menu on the left and follow the required instructions to import, or edit etc...

Display CopyRight on your image using Gimp

Displaying the CopyRight on an image using Gimp is very easy using the plugin Eg-CopyRight

Download the Plugin and add it to folder C:\Program Files\GIMP-2.0\share\gimp\2.0\scripts

Now Restart the Gimp,
Open image on which copyrights are to be displayed.
Go to Filters->Eg->CopyRight and enter the requirements.

Combine multiple images using Pandora

Using gimp , it is possible to combine multiple images, using Pandora Plugin

Add the plugin to C:\Program Files\GIMP-2.0\share\gimp\2.0\scripts folder and Restart Gimp.

Now in File->Open as Layers ,
Select multiple images to be made into one .
Now Go to Filters->combine->Arrange as Pandora and follow the instruction it gives.

Bordering Images with GIMP simply..using plugin Eg-Borders

Border your images using the plugin

Download the plugin and add to
C:\Program Files\GIMP-2.0\share\gimp\2.0\scripts folder.

Restart the gimp, open an image and right click on the image,

Go to Filters->Eg->Border and follow the instructions.

Glossy Aqua glow buttons and backgrounds with GIMP

To get the Aqua Glow glossy buttons using GIMP, is very very simple with the addition of the Aqua Bou Plugin

Download the Aqua Bou Plugin and add it to your gimp script folder at the following path

C:\Program Files\GIMP-2.0\share\gimp\2.0\scripts

and Restart the Gimp.

Then , in the File->Create->WebPageThemes ,you will find different options to create aqua glow glossy buttons for Web Development

Reflecting layer Using Gimp

Getting the reflection layer in the Gimp, can be done by adding a script from and copying the script into C:\Program Files\GIMP\2.0\share\gimp\2.0\scripts

# Restart GIMP
# Open a Picture
# Go to Filters > Decor > Reflection
# Save your picture as PNG (to use
alpha channel) or JPEG.

"Save For Web " Option for Gimp

Save for web is the feature generally in the Adobe Photoshop have , to generate pictures for Website design and developement , in JPEG ,GIF and PNG format with low memory size and acceptable quality.

This option is not available with Gimp actually.
It can be enhanced into the Gimp by adding a Plugin to Gimp as following :

i) Download the Plugin for Save for Web
ii) Unzip the File,

iii) For vista and Mac OS X users, go to Users/gimp-2.6/plug-ins folder
For XP users,

C:\Users\username\.gimp-2.4\plug-in

Copy webexport.exe file from that(unzipped) folder to your gimp plug-ins folder
and restart the GIMP.

In File->Save for web option will be available.

Add your Mac to a Windows WorkGroup

Following are my experience for adding the mac os x (Leopard) to the work group of Windows.

i) Go to System Preference-> Network
ii) Create new location and select advanced options.
iii) Go to WINS Tab and select your work group and save your preferences.

To enable file sharing with windows PC :

i) Go to System Preferences -> Sharing.
ii) Check the File Sharing and go to options in the file sharing.
iii) Check the SMB File sharing option.
iv) Give a password if required (this will be used when the other user would like to access, login into your account for sharing files)

Also don't forget, to enable your user account for windows sharing in the Account Preferences