How to Select Thumbnail From Facebook Profile Picture

By: Raghu - No Comments

Finally, I found the way to customize facebook wall post thumbnail for fanpage. After uploading a profile picture in Facebook (or facebook fan page), by default random thumbnail of your picture will be displayed for all your Wall Posts. I thought, it is not possible to pick an area within the picture to be used for thumbnail, but I was wrong.

Steps to  select thumbnail from profile picture for facebook wall post.

  1. Upload the image for facebook profile picture.
  2. Click on the Image (after uploading). It will open Profile Pictures Folder.
  3. Click on Change Profile Picture Button on Top Right side.
  4. Mouse Cursor will change if you move it Thumbnail Version.
  5. Select the desired area within the picture for wall post thumbnail.
  6. Save Thumbnail Version.

This is useful when you like to display just the part of your logo (instead of some random area).

WordPress Database Cleanup – Plugins Tables

By: Raghu - No Comments

I started using wordpress at www.HappySchoolsBlog.com since October 2007 and since then I have tried several plugins. In last 3 years, I never had courage to cleanup the wordpress database. Today, I decided to delete (drop) tables in wordpress MySQL database that were unused or from deactivated plugins.

  • Total Number of Tables Before Cleanup – 54
  • Tables After Cleanup – 33

It might be possible to delete (Drop) few more tables, but I haven’t figured out which plugins were using them.

It was easy to identify few tables by looking at the table names and then click on Drop under MySql Admin page. For other tables, I searched in Google with

  • Table Name + plugin + wordpress (example – wp_alinks_settings + plugin + wordpress)

After making sure that I’m not deleting core tables, I double checked with core tables list and dropped the remaining tables.

WordPress Database Backup

I was lazy to install any plugins to backup wordpress database. Instead once per month, I used Account backup option from Dreamhost to backup the files and tables. After seeing Thesis theme getting hacked over the weekend, I decided to install WP-DB-Backup plugin. It was easy to install and create the backup. Going forward, I plan to backup the core tables after once in two days.

Very High Unsubscribe Rate with Pop-Over Form

By: Raghu - 2 Comments

Once in a few days, I erase unsubscribed users from email list. Every time, I have noticed majority of the unsubscribed leads have signed up for mailing list through Pop-Over form.

I don’t have the exact percentage or other numbers, but right before writing this post, I erased 367 unsubscribed leads. Over 340 leads have signed-up through Pop-Over form.

It will be interesting to track the exact numbers and if there is high unsubscribe rate, I may decide to remove the pop-over option and use inline sign-up form to collect email leads.

Google Adsense Pays out 68% to Publishers

By: Raghu - No Comments

Finally google is sharing the information that was kept secret so so many years – Adsense Publisher Revenue Share.

AdSense for content publishers, who make up the vast majority of our AdSense publishers, earn a 68% revenue share worldwide. This means we pay 68% of the revenue that we collect from advertisers for AdSense for content ads that appear on your sites. The remaining portion that we keep reflects Google’s costs for our continued investment in AdSense — including the development of new technologies, products and features that help maximize the earnings you generate from these ads. It also reflects the costs we incur in building products and features that enable our AdWords advertisers to serve ads on our AdSense partner sites. Since launching AdSense for content in 2003, this revenue share has never changed.

We pay our AdSense for search partners a 51% revenue share, worldwide, for the search ads that appear through their implementations. As with AdSense for content, the proportion of revenue that we keep reflects our costs, including the significant expense, research and development involved in building and enhancing our core search and AdWords technologies. The AdSense for search revenue share has remained the same since 2005, when we increased it.

Convert MS Word Table into HTML Table in 4 Steps

By: Raghu - No Comments

Converting Tables in Microsoft Word document to HTML table will create this nasty HTML Code. But, it’s very easy to convert Word Table to HTML table without any junk codes by 4 step process

Word Table to HTML Table

Do you know any other way to convert Word to HTML Tables?

Dreamhost VPS – Double RAM for Same Price

By: Raghu - No Comments

I noticed Dreamhost VPS pricing change. They have changed the pricing sturucture for VPS RAM Usage and removed Burstable RAM.

Dreamhost VPS – Before

Montly pricing was based on RAM usage.

  • 300 MB RAM would cost $30.00 per month
  • 300 MB is Guaranteed and upto 600 MB is Burstable ( Swap Space)

Dreamhost VPS – Now

With new pricing model, RAM amount is doubled for the same price.

  • 600 MB RAM will cost $30.00 per month
  • Burstable RAM is not available anymore.

For smaller sites where there is a steady traffic, this would reduce hosting expense by 50%. Adjusting the RAM for traffic increase would get the job done.  Also, this move will encourage sites in Shared Hosting to move to VPS.

How to Create Tabbed Conents in WordPress Sidebar

By: Raghu - No Comments

There are many scripts available to create Tabbed Contents in wordpress. Some of them are  DomTab, Tabifier and idTabs,

Usually, tabbed contents are used in the sidebar to display popular posts, recent comments, tags, categories or archives. I recently came across another tool to create tabbed contents in WordPress using Yahoo Developers Network Tabview.

After reviewing the API and examples, it looks promising and powerful way to to create tabbed contents. I will post an update after giving it a shot.

How to Insert Adsense in bbPress Forum

By: Raghu - 1 Comment

BBpress is light weight forum created by makers of WordPress. It’s easy to install and has the same interface as WordPress.  Displaying Adsense ad within bbpress takes about 2 minutes.

Follow the steps to display adsense ad just above and below the Page Navigation

Adsene in bbpress Forum

Sample Adsense in bbPress

Steps to Insert Adsense Code in bbPress

Instructions below is for the default theme kakumei.

  • FTP into directory where bbpress forum is installed.
  • Navigate to /example.com/bb-templates/kakumei
  • Open the File topic.php
  • Find the following line of code that contains php_topic_pages (array…… )
  • Insert the Adsense code just below that  line
  • This will display the ad above the forum topic, before posts starts
  • To insert the ad after the posts (before navigation page)
  • Insert the adsense coede below the line that contains “class=rss line…..php topic_rss_link”
  • Refresh the Topic in the fourm and you should see the ads.

There are 2 plugins that will allow to insert adsense code in bbpress. If you want to insert the code between posts then use adsense for bbpress plugin.

How to Change WordPress Theme Editing MySql Tables

By: Raghu - 3 Comments

Follow the simple steps to change the WordPress Theme ny editing MySql Tables(WordPress database). You might run into situations when you have access to only backend.

Change WordPress Theme

  • Logn into MySQL Database for your site (Example : msql.example.com)
  • Open the Database for your site ( DB_example)
  • Open the Table wp_options
  • Open Browse Tab
  • Find the option’s template and stylesheet
  • Edit the value to theme name you want to change (Example : default)
  • Save the table

If some plugin have corrupted the theme files, using above change, you can set the default theme.

How to Change Default WordPress Excerpt Length

By: Raghu - No Comments

Default wordpress excerpt length is 55 words. It’s easy to change the default excerpt length in wordpress in less than 2 minutes to desired length. I made changes to wordpress 2.9.2 code.

  1. Login into Directory where wordpress is installed
  2. Open the file Directory > wp-includes > formatting,php
  3. Search for 55 or $excerpt_length = apply_filters(‘excerpt_length’, 55);
  4. Change the value 55 to desired number of words and save the file.
  5. Refresh the page and see the results ( you may have to clear the cache)
« Older Posts
Newer Posts »