There is one solution for changing the encoding for all database tables at once. The script is written by a web development company called Phoca and you can download the script and read step by step procedure here: How to change collation in database.

The owners of various on-line businesses, caring about customer support issues and effective business conducting, businessmen who take care about customer support improvement, work amount reduction and money/time saving are sure to appreciate PHP Help desk Software called HECK. This software will help to structure customer support tickets, based on departments and urgency criteria, reduce the support request amount due to inserted knowledge base and save time and money due to the software security and usage simplicity.
Just to set this software advantages. User can send new support tickets, annex files, get in-depth information from clients with customer fields’ help, fight spam, offer the customers to use related knowledge base article before submitting the support ticket, see and assess customer support answers, notify about customer support personnel via e-mail, use options of knowledge base display and search, using the customer interface. Knowledge base provides big amount of information, categories and sub categories, user-friendly search engine, the option to post attachments to articles, to see the amount of views, the option to display recently posted and the most popular articles, the possibilities of articles assessment and many other functions. Web site admins obtain such options as: unlimited amount of accounts, the possibility of access limitation for certain personnel, support tickets search, tickets’ transfer to designated personnel, knowledge base structuring based on categories and articles, of personnel accounts control and replies samples, support desk alignments, profiles and signatures changes, support tickets automated close and lot of others. The work with software is alleged by the presence of video lessons describing how this software works, so future customers should have no problems with its quick implementation into their activity.
Using such software the owners of on-line businesses can increase the profitability of their activities, set their business to new level corresponding modern needs.

Apart from that this helpdesk is absolutely free!
Enjoy!

After the fields are added, you need to translate them to your language.  The file with translation lies in language/YOURLANGUAGE/com_user.ini. You have to add the names of the fields to the file. Please note, that the name should be written in capitals. For example  NAME=translation to your language.

Enjoy!

The problem is connected to the prefix “www” and settings in the admin panel. If the domain in admin panel is www.yourdomain.com, then if a user enters your domain without “www” he/she is not able to buy anything as the “Buy” button doesn’t work. And vice versa.

How to solve this problem?

There are two ways: via .htaccess file and via VirtueMart.cfg.php.

The second way is easier.

Find a file  VirtueMart.cfg.php (administrator/components/com_virtuemart/virtuemart.cfg.php)

Find a code:

define( ‘URL’, “www.site.ru/” );
define( ‘SECUREURL’, “www.site.ru/” );

and choose it to:

define( ‘URL’, $mosConfig_live_site.$app );
define( ‘SECUREURL’, $mosConfig_live_site.$app );

Everything should be sorted now.

If you have a spare time, you may want to learn basic tricks for optimizing your web page. For example link building and text optimization. But from my point of view it is better to leave it for professionals.

There are dozens of people who offer help in search engine optimization, but how to understand who is really good in that?

One of the very successful companies that work on this market is a company called “First In Search”. They are based in the USA. If you check their web-site you will see that they were awarded twice for best achieved results in pay per click management and search engine optimization. They are also SEO certified company which proves that they know what they are doing.

By the way, they also have some useful SEO tips published on their website. Have a look here: search engine optimization phoenix.

However, I’ve found very easy way to do that.

First of all you have to download the plugin called Admin in English. This plugin lets you have your administration panel in English, even if the rest of your blog is translated into another language. But what if you run German blog and want to have admin panel on Russian? Then you have to do the following:
1) Find the language files for your admin panel here:  WordPress in Your Language.
2) On your site server, create a new folder in your /wp-content OR /wp-includes directory called /languages.
3) Move your language files to that directory. Remember the name of the file (language code. For example, the language code for english is en_US.
4) Unzip “Admin in English” plugin and open admin-in-english.php
5) Find the line called “return ‘en_US’;” and chang en_US to your language code.
6) Save the file and move the whole folder to /wp-content/plugins via FTP.
7) Activate “Admin in English” plugin and enjoy!

“Sooner or later every man who takes up internet business or has something to display in internet encounters the problem of web hosting selection. I was not the exception. I surfed the net looking for hosting for my company web site and tried a lot of cheap variants, which caused a lot of technical and financial problems afterwards.
Getting tired of such inconveniences, I’d lost hope of finding the hosting I need, I tried a search engine, where I entered best web hosting word combination and ran into this site (www.thetop10bestwebhosting.com). I was greatly amazed by the amount of general information about web hosting, the ways how to define best hosting provider, the features, which should be paid attention to when choosing such provider. Though, the most important thing I understood, having read the articles this site provides, was the answer to my question why cheap hosting is the worst selection for guys having a company web site.
Another thing I noticed was an easy navigation, user friendly design and most importantly the way of information presentation, which is suitable for companies running internet business of any type. I noticed a lot of useful nuances which I want to apply in my business and my company site. Being overwhelmed a little bit with such load of useful and necessary information I have forgotten for a moment the reason I came to this site – to chose the hosting I need.
Having read just host review and reviews about Ipage hosting confirming them to be the best, based on other customers opinions, I started thinking which one to chose as their technical features, technical and customers support and fees to be paid may attract anyone who cares about the business. I decided in favor of ipage as it says to be for beginners like I am. I’ve made the right choice.”

There are loads of different strategies: affiliate marketing, articles writing, advertising campaigns etc. But all of them require traffic. A lot of traffic. And traffic requires your time. A lot of your time. So basically, you have to sit in front of PC almost every day, write interesting articles in order to make your blog popular so visitors will keep visiting you.

I’ve tried all of the strategies and found the best one for making money by blogging (well, at least for me). Now, at the moment the money are not big (I earn about 70-80$ per month from two blogs), but I don’t have to sit in front of PC every day. In fact, I post one new article on my blogs once per 2-3 months.

The strategy is extremely simple and requires very small amount of effort. I sell a place for links on my blogs. For doing that I use two online agencies: Link Worth and Text-Link-Ads.com.

Link Worth is really good and I get the main proffit from them. They offer a lot of helpful settings, you can earn not only from links, but from writing articles and sometimes you can earn over 40$ for 300 words article there. Really good offers and prices. The main their requirement is your blog must have at least 19 posts.

Text Link Ads is not so good and it sells words inside your posts. If the advertiser wants to optimise his page by using keywords, he can buy he relevant keyword on your blog. The profit is not so good as with Link Worth, but I get 15$ for three words.

And the best thing is – they pay monthly. So if you sold a place on your blog, you know that you will be getting money up until the advertiser decides to remove the link.

Now, here comes the interesting bit: the price for the links depends on your blog PR (page rank). From my experience you can earn good money if your blog has PR3 and higher. But that doesn’t mean that you won’t be able to earn money if your blog has PR2 or 1.

How, to get PR2 or PR3? It is not very hard. All you ave to do is to submit each of your post to Social Bookmarking Services. I use SocialMarker.com for that. This site allows you to submit your post into 50 social bookmarking sites. It will take some time for you to register in all of them but it is worth doing. If you submit every article you have in to all of them, you will get some backlinks and Google will give you higher PR. Easy.

So let’s imagine you have one blog with two links and it brings 30$ per month. That’s fine isn’t it? But you can spend some time by creating some more blogs. Let’s imagine, that after one year you have 5 blogs with 2 links? This is 150$. Plus you can add Addsence on all of them and it will give you some more extra money. With five blogs you will be able to earn about 200$ and you won’t need to sit in front of PC every day. Only once per 203 months you can write an article and submit it.

This is my strategy for making money by blogging. Please fell free to ask any questions you have and I will do my best to help you.