David Yin's Blog

Now there five main browsers in the market.

Apple Safari, Google Chrome, Microsoft IE 8, Mozilla Firefox, Opera.

If we just think about Windows platform.
Firefox has best web application compatibility. For web standards, Google Chrome and Opera are better support standards. Everyone knows that Firefox has a lot of Addons. So for extensibility, Firefox wins.
There are also some very important for users.
Performance, Opera 10 and Google Chrome are loading faster than others.
Platform Support, Firefox and Opera support Windows, Mac and Linux systems.

I do have IE on my Windows. I have Opera and Firefox too.
Among these three, I use Firefox most often, because of addons I need only working on Firefox. Sometimes I use Opera. Opera Unite is very cool.

What happen in next year.

Today, I upgraded my WHMCS 3.8 to WHMCS 4.0.2.

Now WHMCS has more features.
Including enhanced billing system, clients manager, tickets issue, and more improvement on modules.

The upgrade is fast and easy. No hassle.

I would like to introduce Hosting plans which I managed. We provide support in Chinese. Hosting in USA.
Best deal for small sites to medium sites. Great price.

It is released on 2009-05-27.

There are some bug fix. I just upgraded my OpenX installation afternoon. It is very simple to upgrade from v2.8.0 to 2.8.1.

# Bug Fixes

* Zone probabilities are distributed amongst campaigns, independent of the number of banners. OX-3095
* Fixed delivery of exclusive campaigns when banners have delivery limitations. OX-5450
* Inventory lists now react to last visited parent. OX-4788
* Displaying entity IDs in the UI is now optional. OX-5341
* Fixed function declarations for various _adRenderX functions. OX-5355
* For more information, please see https://developer.openx.org/jira/browse/OX/fixforversion/10843

# OpenX Market Integration

* Market campaign management tools, which allow you to set floors for multiple campaigns at the same time.
* Ad quality tools, which allow you to review ads that have run on your sites and block advertiser campaigns.
* Ability to re-associate your OpenX.org account to OpenX Market even if you had to switch instances of your OpenX Ad Server (i.e., due to a reinstall or server change).
* For more information, please see http://www.openx.org/market.

# Major security fix. Removed vulnerability that allowed anyone to log in as an admin user. See https://developer.openx.org/jira/browse/OX-5460

Alexa is a good tool to value the sites in the world.
It has toolbar for IE only before. Now Alexa has an addon for Firefox.
Alexa Sparky v1.3.1 for Firefox.

I installed it on my office desktop 5 minutes ago. When I restart the firefox, it redir me to a page with some poll. It ask me following questions.
Gender, Age, Household income, Ethnicity, Education, Children in Household or not, office or home, and post code.

It the status bar of Firefox. There are some new information of the site you are watching. The information includes, Traffic trend, Traffic rank, Reach meter.

When I read this blog's site information provided by Alexa, I think it is a very helpful tool for blogger to optimize the content. And know more about the readers of the blog.

I have a VPS powered by Centos 5.2.

There are some very important forum on it. I would like to backup it every day.
Now because HyperVM/LxAdmin - Backup Home, can not backup MySQL or not easy to get it. I have to write the shell script to do the backup job.

To use the FTP I need lftp tool.

The whole picture looks like below.
1) Dump all MySQL databases and compress them, save them in /home/usera/backup/mysql/
2) FTP them to Backup server of Dreamhost at /vps-backup/mysql/
3) Remove the backup files 4 days old.

You have to use your own account name and password.
usera is my sample user name. You can also use any other FTP server to save your offsite backups.
You make a file under /home/usera/mysql.backup.sh
Put the content below in it, save and make it executive.

To upgrade phpBB properly without problem, I make a detailed upgrading plan. I would like to share it with you.

1. Disable forum board.
It is important to make the board clean. And keep resource usage low.

2. Backup
The most important part is backup.

2.1. Database backup
2.1.1. phpBB own tools
Admin Control Panel > Maintenance > Backup
Complete backup with gzip, including all tables, save and download.
(if your board has a lot of posts, the index table is very big. I prefer to clean the index first. Just like me, index table is about 200MB)

2.1.2. phpMyAdmin tool
Login your own phpMyAdmin web tool for MySQL database. Select your database and click Export all tables. My exported file is about 50MB.

2.2. Backup all phpBB 3.0.4 files.
SSH your host.

tar czvf forum.tar.gz ~/your.forum/

3. Download "Automatic Update Package".
For upgrade, I like this package. It can merge your previous changes or mod on you old phpBB when doing upgrading.
cd ~/source/
wget the package.
tar xjf phpBB-3.0.4_to_3.0.5.tar.bz2
cp -r ./install/ ~/your.forum/

4. Upgrade
http://your.forum/install/
start upgrade following the upgrading wizard.
After it. Rename the install folder or delete it.
Enable the board.

Done.

It is very often to include another file as a part of your script.

require_once("/path"/to/file.php");

When do this kind of including, should be very careful on following parts.
1) The path to the script is wrong.

2) The path to the script is correct, but the script is in a forbidden directory.

3) The include file has a blank line or space before or after the code in the PHP script.
It is very easy to omit the space after the code.

4) The include file can be viewd by non-PHP methods.

5) You're in include overload.

6) You are using unchecked variables as include filenames.
It may make your site unsafe in some situation.

The tips of including file are learned from "Wicked Cool PHP"

I have not upgrade to 4.25 when MovableType 4.25 released. Because I failed to upgrade my Unofficial MT site at that time.

But I did a wonderful upgrade from MT 4.25 to 4.26. And this blog is based on MovableType 4.24 before upgrade. Now the upgrade it so smoothly. I have the screen shot of upgrade.

Wow, I saw MovableType 4.26 is released today too.

WordPress has a new upgrade from 2.7.1 to 2.8. MovableType upgrade from 4.25 to 4.26.

For MT, it is an optional release for performance improvement.

* Release Type: Performance Release. This update fixes bugs and improves existing features. No new features are included. * Mandatory? No. This is an optional upgrade recommended for Movable Type Enterprise users. * Performance Implications: Better search performance for large datasets and improved reliability and performance around TheSchwartz. * Plugins Affected: None. Current plugins should continue to work as expected. * Templates Affected: None. * System Requirements: This release has no new or additional system requirements. * Licensing considerations: None. Movable Type 4.26 is a free update for users of any version of MT 4.x. * Upgrade Fatigue: No further mandatory updates are planned for 2009. Optional releases may become available.

Download it here.

It takes time to test MovableType 4.26 and upgrade this blog to it.

It is so happy to know that WordPress 2.8 released tonight.

The most important change is to make WordPress faster. I like it.
Find more information about the release here..

You can download it here for free.

I will find time to upgrade my installation of WordPress.

I have a typo when I posted about phpBB 3 new release.

It is 3.0.5, not 3.1.5.

First of all, I need Memcache to be installed in the server.

I don't want say too much about installation of Memcache. The topic is MAKE MEMCACHE WORK ON PHPBB3.

First get acm_memcache.php from code center of phpbb.

Put this file under /root/includes/acm/
There is acm_file.php already.

Then modify config.php
Replace $acm_type = 'file'
by
$acm_type = 'memcache'

That's all.

Of course, if you do not use the default memcache installation, you need to config acm_memcache.php to let it know your IP and port.