Monday, February 25, 2008

Micro-blogging: Chinese Twitter Clone Site

Twitter is a social network micro-blogging services. The Twitter Clones (micro-blogging services) and it looks like one of the Chinese Twitters are gaining popularity quickly. Here is the most popular Twitter-clone sites in China what I known.

FanFou - FanFou is the biggest Twitter-like site in China. It seems FanFou copied almost everything of Twitter, you can use FanFou to update "what are you doing" in less than 140 characters, it supports updating and receiving notification via Gtalk, MSN, QQ, mobile phone and web, you can follow the updates of your friends, and turn on/off the notification of your friends. It already has a wordpress plugin, maxthon plug and other 3rd party add ons. It also has two Twittervision-like mashups that put Tweets on the 3D globe and a 2D map of China. Xing Wang is Founder and Chief Executive Officer of FanFou.

JiWai.de - JiWai.de is the first Chinese brother of twitter: an online service that enables user to broadcast short messages to your friends or "followers." It also lets you specify which JiWai.de users you want to follow so you can read their messages in one place. Just like twitter, Jiwai supports updating through sms and gtalk. Updating from mobile phones onto jiwai.de, however, compared with Twitter, saves considerable money for Chinese users who want to use twitter-like stuff. To meet the demand of more Chinese users, Jiwai.de also supports updating from some other IMs, including MSN, skype, and QQ. Zhuohuan Li is Founder and Chief Executive Officer of JiWai.de.

TaoTao - Tencent QQ is the most popular IM in China. While Tencent has realized the value of micro-blogging, they launched a stand-alone service called Taotao. Not like FanFou, TaoTao only support updating from QQ and Web. It have no widget support. Since Tencent has the most extensive im user base, and the characteristics of this kind of micro-blogging service also match with profile of QQ's users.

Other Micro-blogging Site in China:

zuosa - http://zuosa.com
ilaodao - http://ilaodao.cn
komoo - http://komoo.cn
byuu - http://byuu.com
wulog - http://wulog.com
fish - http://fish.sh
laigula - http://laigula.com

Thursday, February 14, 2008

WordPress Mod Rewrite Make Subdirectory 404 Error

Last night, I getting lots of 404 error while using Google to search my own blog index page, I realized there is something wrong about my blog.

My user-created-outside-of-WP folder is throwing a 404 when trying to access it. Now for some details:

Blog www.moon-blog.com : normal WP blog. Permalinks "/%year%/%monthnum%/%postname%.html" through mod_rewrite in the default .htaccess file WP created.

Subdirectory www.moon-blog.com/MySubdirectory/): normal PHP application. User defind permalinks. Located at directory "/MySubdirectory/".

The problem is that the WordPress thinks My Subdirectory is 404, and do not allow Google to index my files.

I Try add some of php code into my php application to resolve this problem:

header("Status: 200 OK");

After adding that code, my PHP application in the subdirectory do not return 404 error again.

Tuesday, February 5, 2008

WordPress 2.3.3 Urgent Security Release

Attention please! WordPress 2.3.3 has release, with an important security update. WordPress 2.3.3 is an urgent security release. If you have registration enabled a flaw was found in the XML-RPC implementation such that a specially crafted request would allow a user to edit posts of other users on that blog. Unless you want registered users to be able to edit your blog posts, you should update your WordPress installation to version 2.3.3. In addition to fixing this security flaw, 2.3.3 fixes a few minor bugs. If you are interested only in the security fix, download the fixed version of xmlrpc.php and copy it over your existing xmlrpc.php.

You can get the latest version of WordPress here. Download it today, upgrade your previous installation and continue blogging!

Saturday, January 26, 2008

The Most Popular RSS Reader In China

For the reason of language, a lot of peoples use local RSS Reader in China. Here is the most popular RSS reader in China, except Google Reader and Bloglines.

ZhuaXia: An earlier professional RSS reader. But seems stop update now.

XianGuo: Another professional RSS reader, with a lot of function better than other. I think it is the best RSS reader in China.

YouDao: A RSS reader from the Netease, Netease is the most biggest website in China, and the third biggest portal website after Sina Corp and Sohu.

QQ reader: RSS reader from Tencent QQ. Tencent QQ is the most popular free instant messaging computer program in China, and the world's third most popular IM service.

Wednesday, January 16, 2008

WordPress MU Optimization Script

WordPress MU will be automatically established more than 10 tables when a new user register, so when a large number of users register will caused a lot of problem. Then I write some performance scripts can delete the WordPress MU inactive users.

The PHP source code as follows:


  $mysql_host = "localhost";
  $mysql_user = "root";
  $mysql_pass = "";
  $mysql_db = "wordpress";
  $mysql_mylink = mysql_connect($mysql_host, $mysql_user, $mysql_pass)
  or die ("Cannot make the connection");
  mysql_select_db($mysql_db, $mysql_mylink)
  or die ("Cannot connect to the database");
  $strsql="select * from wp_blogs where blog_id>2 ";
  $rs_query = mysql_query($strsql);
  $alls=mysql_num_rows($rs_query);
  while (($RS = mysql_fetch_array($rs_query))) {
  extract($RS);
  $blogid=$RS["blog_id"];
  $query2 = "select * from wp_".$blogid."_posts ";
  $result = mysql_query($query2);
  $num= mysql_num_rows($result);
  //print $num;
  if ($num<=2) {
  print "DROP TABLE IF EXISTS wp_".$blogid."_comments;";
  print "DROP TABLE IF EXISTS wp_".$blogid."_links ;";
  print "DROP TABLE IF EXISTS wp_".$blogid."_options ;";
  print "DROP TABLE IF EXISTS wp_".$blogid."_postmeta ;";
  print "DROP TABLE IF EXISTS wp_".$blogid."_posts ;";
  print "DROP TABLE IF EXISTS wp_".$blogid."_terms ;";
  print "DROP TABLE IF EXISTS wp_".$blogid."_term_relationships ;";
  print "DROP TABLE IF EXISTS wp_".$blogid."_term_taxonomy ;";
  print "DELETE from wp_blogs where blog_id=".$blogid.";";
  }
  }
  mysql_close ();

Wednesday, January 9, 2008

Custom WordPress Database Error Page

From what i have mentioned before, we can use a program to monitor the WordPress MySQL server, when the server is down, WordPress will auto send an e-mail and write to a text log file in a recorded. Now, WordPress 2.3.2, the latest version of the popular blogging platform allows you to define a custom database error page.

It is very simple. Just follow the following steps and within a few minutes your custom database error page is ready!

First, upload a file named log.txt to the WordPress root directory, chmod it to 666.

Second, Download the file db-error.php and upload it to WordPress content directory(wp-content/db-error.php).

Finally, replace the e-mail address of the code to your own e-mail.

That's it! From now on this error file will be report the error whenever your WordPress blog has encountered some trouble connecting to the database server.

Monday, December 31, 2007

Best of Moonlight Blog 2007

As we move into 2008 I thought it might be fun to look back quickly on the year that was with a top 20 post of the most popular posts published on Moonlight Blog this year (according to page views on Google Analytics). I hope you enjoy this trip back through the year of 2007 at Moonlight Blog.
  • Wordpress Plugin: Chinese PinYin Slug - 2,467 views

  • Survival For Standalone Blogs - 1,682 views

  • China Internet Censorship Goes Crazy - 1,682 views

  • The Secret Of Internet Censorship In China - 1,461 views

  • FeedBurner Blocked By China - 1,276 views

  • FeedBurner Is Completely Blocked In China - 1,201 views

  • Google Answers Censorship In China - 1,082 views

  • About This Blog - 1,041 views

  • Baidu Hijacking Google, Yahoo, Microsoft In China - 1,019 views

  • Google Launches Chinese Blog Search - 1,014 views

  • YouTube Blocked In China - 986 views

  • WordPress MU AdSense Plugin - 944 views

  • WordPress Plugin: Post2Mail, Send Post to Email - 693 views

  • How To Visit Google BlogSpot In China - 670 views

  • WordPress Plugin: Yearly Blog Stats - 625 views

  • Wordpress Plugin: Keyword Filter - 615 views

  • WordPress Plugin: MySQL Server Crash Monitor - 552 views

  • YouTube, Have a Merry Halloween - 540 views

  • WordPress Plugin: WP-PostViews JavaScript Edition - 526 views

  • About - 520 views 

  • All in all it was a fairly busy but very satisfying year of blogging here at Moonlight Blog. Thanks to the many readers who have contributed either with guest posts, comments, emails and tip offs. I'm looking forward to yet another great year in 2008.