Computer And Internet, Miscellaneous, Tips & Trick

Well, I just have done optimize SEO for one of my website using 4images gallery system it’s on http://www.innovativedesktop.com basically I play with meta title, keywords, and description. And now I’m using URL rewrite. URL look cool and more search engine friendly I believe after a week or month it will indexed in lot of search engine 😀

Here is the way for you’re to using URL rewrite on 4images to make it more search engine friendly REMEMBER this will eat CPU resources. (before you doing this I recommended to backup your files first). Any alternative you can learn about URL rewrite yourself to make it works as you want (google is the best teacher).

1. You need to make .htaccess file and put this code on it

RewriteEngine On
RewriteRule ^lightbox\.html$ lightbox.php?%{QUERY_STRING}
RewriteRule ^lightbox\.([0-9]+)\.html$ lightbox.php?page=$1&%{QUERY_STRING}
RewriteRule ^search\.html$ search.php?%{QUERY_STRING}
RewriteRule ^search\.([0-9]+)\.html$ search.php?page=$1&%{QUERY_STRING}
RewriteRule ^postcard([a-zA-Z0-9]+)\.html$ postcards.php?postcard_id=$1&%{QUERY_STRING}
RewriteRule ^postcard\.img([0-9]+)\.html$ postcards.php?image_id=$1&%{QUERY_STRING}
RewriteRule ^k_(.*)_([0-9]+).html categories.php?cat_id=$2&%{QUERY_STRING}
RewriteRule ^r_(.*)_([0-9]+).html details.php?image_id=$2&%{QUERY_STRING}
RewriteRule ^r([0-9]+).search.html details.php?image_id=$1&%{QUERY_STRING}

2. Open /include/sessions.php before the last line add this code

//Mod_bmollet
/**
* Get the category url
* @param int $cat_id The id of the category
* @param string $cat_url The current status of the URL
*/
function get_category_url($cat_id,$cat_url = ”)
{
global $site_db;
$sql = “SELECT cat_name,cat_parent_id FROM “.CATEGORIES_TABLE.” WHERE cat_id = ‘”.$cat_id.”‘”;
$result = $site_db->query($sql);
$row = $site_db->fetch_array($result);
$row[‘cat_name’] = strtr($row[‘cat_name’], “ABCDEFGHIJKLMNOPQRSTUVWXYZ”,”eeeaeauoiaabcdefghijklmnopqrstuvwxyz”);
$cat_url = ‘_’.str_replace(‘+’,’_’,urlencode($row[‘cat_name’])).’_’.$cat_id.$cat_url;
// if you want full path of category in url, put next line in comment
return $cat_url;
if( $row[‘cat_parent_id’] != 0)
{
return get_category_url($row[‘cat_parent_id’],$cat_url);
}
else
{
return $cat_url;
}
}
//Mod_bmollet
/**
* Get the image url
* @param int $image_id The id of the image
*/
function get_image_url($image_id)
{
global $site_db;
$sql = “SELECT cat_id,image_name FROM “.IMAGES_TABLE.” WHERE image_id = ‘”.$image_id.”‘”;
$result = $site_db->query($sql);
$row = $site_db->fetch_array($result);
$row[‘image_name’] = strtr($row[‘image_name’], “ABCDEFGHIJKLMNOPQRSTUVWXYZ”,”eeeaeauoiaabcdefghijklmnopqrstuvwxyz”);
// if you want comlpete path to image in url, remove comment from following line
//return get_category_url($row[‘cat_id’]).’-‘.str_replace(‘+’,’-‘,urlencode($row[‘image_name’])).’-‘.$image_id;
return ‘_’.str_replace(‘+’,’_’,urlencode($row[‘image_name’])).’_’.$image_id;
}
Read More »

    Digg Del.icio.us StumbleUpon Reddit Twitter RSS
Miscellaneous, Tips & Trick

GOOD SEO = Unstoppable Traffic = Money

This one I forgot for almost a month to optimize my site traffic performance. Meta Title, Keywords, and Description should be optimized to get maximum indexed by search engine. Play it with simple code modification, If you have dynamic site this can be done in easy by just change some parameters to optimize all that meta.

Example: Said you have a gaming site, By default all headers only optimized by fixed meta title, keyword, and description. I recommended you to change that fixed meta with dynamic meta.

How? Simple! give it at least game title on your page title it should optimized SEO if you familiar with php or html this can be done very easy. Play also with keywords and description make it more optimized by keyword search.

The last thing for SEO today is almost lot of search engine love to indexed “.html” more than indexed “.php?id=” If you’re running php site this can be fixed by mod rewrite. Sorry I can’t tell you totally 100% how you can change that “.php?id=” to become “.html” I just prefer you to search it on google on how you can make it, This way is recommended for you if you like to optimize your SEO.

This might not become a big attention for some webmaster but if you know how it works why you’re not try it. I’ll guarantee you will get more traffic after you optimized this meta.

    Digg Del.icio.us StumbleUpon Reddit Twitter RSS
Miscellaneous, Tips & Trick

Necessary or not necessary the answer is it NECESSARY!! Sitemap will not hurt you back? Why you’re not learn to optimize your SEO through sitemap. Learn from case, why visitor not come to your website? because your website is not visible!, Visible in here mean your website is hard to found visitor who’s looking any information they needed. Through sitemap your website will got indexed and every time people search using specific keyword your website will showing in result.. that was I mean VISIBLE!

Take a look on my case on site www.ahuuy.com
seo.JPG

Look how my website can showing on position 3 using keywords “flash online games” (more data can be found through google webmaster tools about keyword and website position on each unique keyword) it’s have lot of factor in result from your website title your domain name, your meta keyword, and last from your meta description.

I will not write about it right now.. but I will writing about sitemap now. Did you know first time my website not indexed already by TOP 5 search engine my traffic has never blow up. Until I submit my sitemap to TOP 5 search engine until today I satisfied with traffic result. XML sitemap is the standard for google,yahoo,live/MSN,ask and maybe other search engine.

If you want to blow up your traffic you can build your own sitemap. There is lot of free sitemap generator you can found… for reference I personally recommended you to look on this list http://code.google.com/sm_thirdparty.html for wordpress you can use this nice plugins http://www.arnebrachhold.de/redir/sitemap-home/ once you create it submit to google webmaster tool, yahoo site explorer, live webmaster tool, and ping some search engine to started crawler your website. Wait 1-2 month and see how your traffic can blow up. You can use google analytic to analyze your traffic.

Good luck 😀

    Digg Del.icio.us StumbleUpon Reddit Twitter RSS
Computer And Internet, Personal, Tips & Trick

Good day! I wishing everyone happy in this Christmas and Holiday season 😀

merry-christmas

In this short articles I want to write my personal experiment review for WP super cache. Here is the story, In the past 6-9 months ago I’m using wp super cache just because my hosting recommended it. I run some websites on budget host and most host technician complaint about resources. Nothing special until I notice my revenue is not so great even my traffic great enough.

Two weeks ago I bought a new server just because my websites not fit anymore on budget host. I do setting and everything run properly until I notice something annoying. My traffic is greater but my revenue is to low. Why this is happen? I do some research and analyze the problem, Re-Setting server configuration to the maximum resources but there is no difference.

At the first time I was thinking: Maybe (just maybe) my traffic not coming from premium country so it may not so great in conversion and affect my revenue. But it was wrong! not completely wrong actually! I do deep analyze and found my UV and Impressions not counting correctly. After long investigation I found the problem is on cache. I believe many of you already know what is wp super cache, but for you don’t know what is it: wp super cache generate HTML files and serving those HTML to all visitors: real human traffic including search engine bot traffic.

Read More »

    Digg Del.icio.us StumbleUpon Reddit Twitter RSS
Computer And Internet, Personal, Tips & Trick

If you are using wordpress or other cms and have a lot of data in you sql, your site usually will unavailable with common message database error. What actually error on your database? Nothing, this is all about query limitation on your hosting. Your blog will grown in time, say in the last months you got 10,000 readers and in the next month you got 1,000,000 readers. When people access your site it’s continuously reading data again from your database, when it to much some hosting will stop it to executed. This is not good for SEO because your potential readers will gone (robots also can’t indexing full your site). Usually bad hosting will ask you to upgrade into vps or dedicated server. Everyone know it, there is no free lunch, you will have to pay more and more, if you got good revenue maybe it’s fine but how if not?

In this short articles I will give some tips and trick to fix common wordpress database problem. When you’re planning to get a lot of visitors to your site you better looking for a ways to optimize your sql query. There is one options for this, using DB cache so when people coming to your site request the articles server don’t need to re-query database again. You just need to sacrifice some memory and space which may be better in result if you’re not planning to go for vps or dedicated at the moment.

[to_plus]

How to do this? Search on google is good idea, I found many articles for database caching last night, this is the best one. For wordpress users there is a simple solution. Just get and install DB-CACHE-RELOADED plugin, setting it as you need, example you want cache stays for 24 hours or maybe just 10 minutes.

In this sample I set 180 minutes (3 hours). Cache will stay for 3 hours and then when it expired all cache files will deleted from cache folder and generated new cache. The result after using this plugin is better than not using it. When I tested it I have never seen wordpress database error again (of course because when someone read articles again server doesn’t need to re-read again from the sql). If you like this plugin you can spare some money for Ivan for his great works 😀

The effect?? I’m not sure but in the past when I’m using similar plugin like this I have error on feed, when this happen disable the plugin clear all the cache files and reactivate plugin again. But if not then you don’t need to do anything just keep monitors your site availability and traffic. Before I close this articles I want to tell you, you can also combine this plugin with auto cron job to repair and optimize your mysql, just search on my blog you will find the articles. This combination will giving a better result.

That’s share for today, I need back to work on project he he, Have a great day everyone 🙂

    Digg Del.icio.us StumbleUpon Reddit Twitter RSS