Blogger Under Posting Comment box

Now, blogger(blogspot) have developed their comment box. Last time ago, if we want to post a comment there should be only a link under our posting, and we have to click the link send a comment, it's not interesting. But now we can find a comment box under our post exactly. It's original from blogger, it's not like haloscan or intensedebate. But it's truely from blogger/blogspot. You can see it under this post.

Here is the trick to create comment box under your post.

1. Login to http://draft.blogger.com
2. Go to Setting-->Comments. then change "Comment Form Placement" to be "Embedded below post" (look at the image below)



3. Then "Save Setting"
Try to see your blog and klik on your titile post. if there is a embadded commnet box below your post just stop this step here. But if there is no comments box, just follow the next steps here.

4. Go to "Layout-->Edit HTML"
5. Check the "Expand widget templates" box.
6. Find this code :

<p class='comment-footer'>
<a expr:href='data:post.addCommentUrl' expr:onclick='data:post.addCommentOnclick'>
<data:postCommentMsg/></a>
</p>
</b:if>

7. Then replace it with this code :

<p class='comment-footer'>
<b:if cond='data:post.embedCommentForm'>
<b:include data='post' name='comment-form'/>
<b:else/> <b:if cond='data:post.allowComments'>
<a expr:href='data:post.addCommentUrl' expr:onclick='data:post.addCommentOnclick'>
<data:postCommentMsg/></a>
</b:if> </b:if> </p> </b:if>

8. Save your Template.

I've deleted my last comment box (haloscan). so now I lost all of my comments before. I do it to get this comment box.

Blogger Under Posting Comment box

Now, blogger(blogspot) have developed their comment box. Last time ago, if we want to post a comment there should be only a link under our posting, and we have to click the link send a comment, it's not interesting. But now we can find a comment box under our post exactly. It's original from blogger, it's not like haloscan or intensedebate. But it's truely from blogger/blogspot. You can see it under this post.

Here is the trick to create comment box under your post.

1. Login to http://draft.blogger.com
2. Go to Setting-->Comments. then change "Comment Form Placement" to be "Embedded below post" (look at the image below)



3. Then "Save Setting"
Try to see your blog and klik on your titile post. if there is a embadded commnet box below your post just stop this step here. But if there is no comments box, just follow the next steps here.

4. Go to "Layout-->Edit HTML"
5. Check the "Expand widget templates" box.
6. Find this code :

<p class='comment-footer'>
<a expr:href='data:post.addCommentUrl' expr:onclick='data:post.addCommentOnclick'>
<data:postCommentMsg/></a>
</p>
</b:if>

7. Then replace it with this code :

<p class='comment-footer'>
<b:if cond='data:post.embedCommentForm'>
<b:include data='post' name='comment-form'/>
<b:else/> <b:if cond='data:post.allowComments'>
<a expr:href='data:post.addCommentUrl' expr:onclick='data:post.addCommentOnclick'>
<data:postCommentMsg/></a>
</b:if> </b:if> </p> </b:if>

8. Save your Template.

I've deleted my last comment box (haloscan). so now I lost all of my comments before. I do it to get this comment box.

Guiness World Record Certificate in your name - Firefox 3

On June 17th 2008, Firefox decided to set the Guiness Book of World Record for the most downloaded software in 24 hours. Mozilla foundation urged its users the world over to update their browsers by downloading the latest version namely Firefox 3. And the response was so massive on the D-Day that, there was an outage at the Mozilla data center for several hours. Once the servers were back online, the downloading continued and Firefox set the world record well within the 24 hours.

The record is 15,067,570 downloads (15 Million). Country wise, USA tops the list with a whooping 4 million + downloads. Surprisingly, sans the US, relatively small countries like Iran and France clocked more downloads than its larger counterparts like India and China.

If you are one of the people who downloaded Firefox on June 17th, then congratulations !!; You are a part of the Guiness Book of World Records. And the people at Firefox are ever too grateful to forget your valuable contribution.

So go ahead and download your own personalized Guiness Book of World Records Certificate (Ahem ... Firefox 3 Download Day Certificate that is) for helping set the record. Here is mine shown below.

OpenSUSE 11.0 released

OpenSUSE has released its latest version aka 11.0 today. This version contain cool innovations and new features. Some of them being inclusion of KDE 4.04, a brand new themed installer, latest Linux kernel (2.6.25.4) and a slew of features specific to OpenSUSE.

For a list of new features, read the release notes. And check out the screenshots of the installer to get an idea on how easy it is to install on your machine.

Wine 1.0 - The first stable release of Wine after 15 years of development

After 15 long years of active development, Wine software which makes it possible to run native Windows applications, has reached it's milestone 1.0 version. What are the features of this new stable release of Wine you ask ? Well, one of the prerequisites of the version 1.0 release, I am told, was that it should be able to run Adobe Photoshop CS2 flawlessly in Linux. And that has been achieved. Check out if and how far your favorite Windows application works in Wine by visiting the Wine Application Database.

You can download the binary packages or the source at the WineHQ website.

Show Related Article to Your Post

The advantage of showing related article to your post is it will help your readers find more information related to the topics. This is base on label or category. This is usually put to the end of the article. After your visitors finish read your article, they will find some links that related to the post base on label or category.

Here's the tutorial to create "related article to your spot":

1. Login to Blogger
2. Go to "Layout-->Edit HTML"
3. Click on "Expand Widgets Template" checkbox.
4. Then download THIS SCRIPT or HERE.
5. Open it then copy the scripts.
6. Paste the script after this code : <data:post.body/>. If you have "Read more widget" you will find two codes. Put it under the first code.
7. Save your template.

Good Luck...

Show Related Article to Your Post

The advantage of showing related article to your post is it will help your readers find more information related to the topics. This is base on label or category. This is usually put to the end of the article. After your visitors finish read your article, they will find some links that related to the post base on label or category.

Here's the tutorial to create "related article to your spot":

1. Login to Blogger
2. Go to "Layout-->Edit HTML"
3. Click on "Expand Widgets Template" checkbox.
4. Then download THIS SCRIPT or HERE.
5. Open it then copy the scripts.
6. Paste the script after this code : <data:post.body/>. If you have "Read more widget" you will find two codes. Put it under the first code.
7. Save your template.

Good Luck...

How do astronauts go to bathroom in outer space

A NASA engineer answers one of the age-old questions every kid has: What happens when you go to the bathroom in outer space? A little insight into zero-gravity toilet design.

Opera 9.50 web browser released

Opera has released yet another version of its flagship web browser by the same name. It comes with unique features, many of which are not yet available on alternate web browsers out of the box.

I have always found using Opera to be a pleasant experience. Some of the new features found in Opera are as follows :

1. Opera Link : For the very first time, all your bookmarks, speed dial and notes taken in Opera web browser will follow you around where ever you go. You can even access them from your mobile phone. The catch being you have to be using an Opera web browser. Opera provides space on their server to store your bookmarks and other settings which makes this possible.
2. Quick Find : Opera keeps track of not only the web addresses you visit but also words from pages you have visited. So if you do not remember the web address but remember a word on the web page, typing it in the address bar will let you zero in on the exact web page.
3. Better fraud protection.
4. A sharper skin.
   

Opera also claims that -

It’s faster, lighter and pushes us further out in front of other browsers, by blending the mobile and desktop worlds together in new and powerful ways.

But let the end users be the people who decide that. Why not visit Opera and download the latest version namely 9.5 and take it for a spin ? For all you know, you might get hooked to yet another fabulous web browser.

Free Web Hosting Without Ads

If we have a/some blogs, webhosting is important to support our blog running. web hosting is use for put our files such as images, sound, script, videos and many more. We can use use paid hosting or free hosting, but I suggested you to use 000webhost as your web hosting. 000webhost is a free web hosting service with full feature and no force ads. 000webhost is an amazing web hosting service. It's free web hosting that gives many features such as:

- 250 MB Disk Space
- 100 GB Data Transfer
- cPanel Control Panel
- Fantastico De Luxe 1-Click Autoinstaller
- Website Builder Software
- PHP Scripts Autoinstaller
- MySQL Databases
- Curl, GD2 library, ImageMagick, Zend
- and much more features are enabled

But to make your web hosting running well you must folow their rule.
Here is the most important rules:

1. No adult content or any kind.
2. No warez / hacking / phishing sites
3. No mass mailers / spammers (account will be automatically suspended if you will try to send mass mail), so if your software supports such feature, disable it right now.
4. We do not allow any public image or file hosting server scripts to be run.
5. Chat, proxy, or file download scripts are not allowed.
6. Paid-to-surf, auto-surm, buxto, and any other similar scripts are banned
7. We do not allow online gaming scripts such as ogame, mafia, etc..
8. Nulled software such as ip.board or vbulletin is not allowed to be hosted
9. Account cannot be used only to store files.

What are you waiting for, just SIGN UP HERE

Free Web Hosting Without Ads

If we have a/some blogs, webhosting is important to support our blog running. web hosting is use for put our files such as images, sound, script, videos and many more. We can use use paid hosting or free hosting, but I suggested you to use 000webhost as your web hosting. 000webhost is a free web hosting service with full feature and no force ads. 000webhost is an amazing web hosting service. It's free web hosting that gives many features such as:

- 250 MB Disk Space
- 100 GB Data Transfer
- cPanel Control Panel
- Fantastico De Luxe 1-Click Autoinstaller
- Website Builder Software
- PHP Scripts Autoinstaller
- MySQL Databases
- Curl, GD2 library, ImageMagick, Zend
- and much more features are enabled

But to make your web hosting running well you must folow their rule.
Here is the most important rules:

1. No adult content or any kind.
2. No warez / hacking / phishing sites
3. No mass mailers / spammers (account will be automatically suspended if you will try to send mass mail), so if your software supports such feature, disable it right now.
4. We do not allow any public image or file hosting server scripts to be run.
5. Chat, proxy, or file download scripts are not allowed.
6. Paid-to-surf, auto-surm, buxto, and any other similar scripts are banned
7. We do not allow online gaming scripts such as ogame, mafia, etc..
8. Nulled software such as ip.board or vbulletin is not allowed to be hosted
9. Account cannot be used only to store files.

What are you waiting for, just SIGN UP HERE

MySQL - Cheat Sheet

MySQL is a small, fast and highly configurable DBMS. It supports a number of different table fileformats, depending on the requirements of the user.

These are the main MySQL clients and processes (mysqld):

• mysqld - MySQL server daemon
• safe_mysqld - Server process monitor
• mysqlaccess - Tool for creating MySQL users
• mysqladmin - Utility for administering MySQL
• mysqldump - Tool for dumping the contents of a MySQL database. Useful for backing up a database from within the console.
  
• mysql - Command line interface to MySQL
• mysqlshow - List all MySQL database
• Mysql Administrator - This is a GUI tool which makes administering mysql database a painless task. Read more about it here.
  

Field Types in SQL

INTEGER - A whole number
VARCHAR(10) - Up to 10 characters.
CHAR(10) - Fixed number of characters
DATE - A date
DATETIME - Date and time
FLOAT - Floating point numbers

Field Types specific to MySQL

TEXT - Allows up to 65535 characters
DECIMAL(10,2) - Up to 10 digits before the point, 2 after.

Create a database

$ mysqladmin --user=ravi --password=xxx create database addressdb

Using the database

$ mysql --user=ravi --password=xxx
mysql> USE addressdb

Create a table

mysql> CREATE TABLE p_addr (i INTEGER PRIMARY KEY,address TEXT,email VARCHAR(30),pincode DECIMAL(10),phone DECIMAL(15),website TEXT);

Add a column called "name" to the table

mysql> ALTER TABLE p_addr ADD name VARCHAR(30);

Inserting values into table

mysql> INSERT INTO p_addr VALUES (1,"My, present, address","ravi@localhost",681024,2122536, "http://linuxhelp.blogspot.com","Ravi");

List the contents of the table

mysql> SELECT * FROM p_addr;

Delete a row from the table

mysql> DELETE FROM p_addr WHERE i=1;

Rename a column in the table from "address" to "home_address"

mysql> ALTER TABLE p_addr CHANGE address home_address INTEGER;

Note: You cannot use this method to rename a column which is a primary key.

Change an existing record in the table

mysql> UPDATE p_addr SET name="Sumitra" WHERE i=2;

Delete the table from the database

mysql> DROP TABLE p_addr;

List the databases

$ mysqlshow --user=ravi --password=xxx
+-----------+
| Databases |
+-----------+
| addressdb |
| myblog    |
| mysql     |
| test      |
+-----------+

List the tables in the database "addressdb"

$ mysqlshow --user=ravi --password=xxx addressdb

Database: addressdb
+---------+
| Tables  |
+---------+
| p_addr  |
| mytble  |
| phonebk |
+---------+

These are only a subset of the commands in mysql. But this will be enough for creating and maintaining a simple database.

Free Domain co.cc

Do you feel your blog name is too long?
If we create a blog, use blogspot or wordpress service, we have to make a name to our blog, it should be like "name.blogspot.com" or "name.wordpress.com". Do you feel it's such as a long name? If we have some money, we can buy a domain, and then our blog name would be like name.com or name.net or name.co.uk name.us etc.

But now, we can to get free domain to cut up our blog name. it's co.cc service. We can register domain to co.cc, our blogname will be like "name.co.cc". It's free, no payment needed, no setup fee and it's easy to setup. I thinnk it's very good service that offer us a free domain name. I have try it for some of my blogs, and it's interesting. So what are you waiting for.....

Free Domain co.cc

Do you feel your blog name is too long?
If we create a blog, use blogspot or wordpress service, we have to make a name to our blog, it should be like "name.blogspot.com" or "name.wordpress.com". Do you feel it's such as a long name? If we have some money, we can buy a domain, and then our blog name would be like name.com or name.net or name.co.uk name.us etc.

But now, we can to get free domain to cut up our blog name. it's co.cc service. We can register domain to co.cc, our blogname will be like "name.co.cc". It's free, no payment needed, no setup fee and it's easy to setup. I thinnk it's very good service that offer us a free domain name. I have try it for some of my blogs, and it's interesting. So what are you waiting for.....

Unbreakable Linux - Free Linux DVD set from Oracle

First it was Ubuntu and now it is Oracle's turn. That is right; here is a wonderful chance to get yourself a DVD set of Oracle's Unbreakable Linux. Essentially Unbreakable Linux is Red Hat Enterprise Linux sans the Red Hat trademarks.

Oracle claims Unbreakable Linux delivers enterprise-class support for Linux with premier backports, comprehensive management, cluster software, indemnification, testing and more, all at significantly lower cost.

Fig: Enter your email id and a password.

Fig: Enter your name and address.

To order your Free DVD of Oracle Unbreakable Linux with free shipping and all, visit this page and click the "Register Now" button. If this is your first visit to the Oracle website, you will have to create an Oracle account. Next enter your shipping address which is the address to which you would like to receive the DVD set and press "Submit". That is it. Oracle will ship you a brand new DVD set of Unbreakable Linux.