Microsoft Office Online: Create an effective reference system
Small things done consistently in strategic places have major impact.
Productivity Tips – Small Things in Strategic Way
4
Yearly Archives: 2006
Business of Zhending Chicken
This noon, we went to our favorite restaurant Zhengding Chicken (振鼎鸡) for lunch. It is famous for its chicken. It is a successful business, just like KFC for fried chicken.
Zhending Chicken meets the need of local market precisely, because people are very sensitive about cost and the value. They have some rules in their restaurant I feel strange.
Close The Business at Rush Hours
I remember the store at Tianlin closes at 6:00 PM. Many times we rushed to the store only to find out the store is closed. A server stands at the door and politely tell us: All chicken sold out.
It is the very few restaurant that I would keep my finger crossed on the way to there, hoping I can get permission to enter the store, for chickens.
Cold Coke or Not?
The price for cold coke and normal temperature coke are different. You have to pay 0.2 RMB more for the coke to be cold.
People clearly see the value that the coke is sold at a very low margin, that they cannot aford to pay for the refragerator to cold it.
Take out or sit in
The price for the chicken are cheaper if you take out. It is quite reasonable in Shanghai.
Estimated Price Only
When you order, say, one chicken, the server will charge you based on their estimation. The precise amount will come only after they choosed the chicken, weight it and calculated based on the weight.
Devils are in Details
Everything in Zhending Chicken pointed to the cost-saving direction. It is very cheap to have lunch in their restaurants compared to many local chicken stores. This is quite unique. I believe to do business in China, when we study MBA programs, we need to learn more from the practical local restaurants on how they control their cost and strike for operational excellency.
P.S. Long Google Search String
Today, I found someone reached my website using this long Google search string. I Fule U.
20 Years of Professional Managers in China
The latest issue of Shanghai Managers featured “20 Years of Professional Managers” in Shanghai. The topic is good since the phenomenon of “20 year professional managers” is unique in China, and it involves many people just around us. The people and their stories told in the report are just like “manager sitting in the next cubicle” (just created this phase after “girl living next door”).
Professional Manager is Still Rare in China
The growth of the country’s economy benefits greatly from the abundance of labor (which many countries are lack of), and the huge talent pool, but it is not that abundant when we talk abou experienced professional managers.
If you look at the heads of multinational companies, you will find many of them are managers from Taiwan, Hong Kong or Singapore, for example, the management team in Microsoft, in Motorola, and eBay (as far as I know). There are not so many native professional managers if you consider the big base.
How come?
20 Years!
As stated in one article in this issue of Shanghai Managers, FESCO (Foreign Enterprise Services Co.) started the history of foreign enterprises in Shanghai.
This is very true.
When I worked for Microsoft, as all my colleagues in Shanghai, I was actually an employee of FESCO and dispatched to Microsoft. It is same for me now.
FESCO was setup just to help foreign companies to overcome the human resources barrier and many difficulties old system presented to a modern company. It was the only organization to select, hire, train and dispatch employees to the multinational companies. They did much more than that, like keeping the Dangan for its employees. Now it is not the only one, but still the most important one.
FESCO was setup in the year 1984 – 22 years ago. The first round of foreign companies entered China around that year. I remember HP, as one of the first big foreign enterprises in Shanghai, just celebrated their 20 years in China last year. I believe most foreign companies have presence in China (or re-entered China market) within the last 20 years.
The report described how difficult it was to find someone who can speak a foreign language, (more importantly) is willing to give up their state-owned enterprise secured job and join a foreign company. These employees are under management of a special police station. The station has two chief to ensure safety. The FESCO provide months of training to the employees to teach them how to use Fax machine and how to dress up.
It is unbelievable in nowadays, but it is so reasonable in 1984 when China just opened up after closed for half centaury. Thanks for the editors to refresh that piece of history for us.
Now, many of the employees in 1980’s grew up and become experienced managers. But the problem is, there are not enough senior people there, and those experienced managers are not senior enough to manage multi-national businesses.
Talents from Hong Kong, Taiwan and Singapore
The last Hong Kong trip impressed me a lot. I saw how experienced managers in the International economy world are. As the generation of senior managers in China grew up to learn English (Oral English), learn those terms so new to them, and how to work in an intentional company, managers in other Chinese worlds like TW, HK and SG moved forward in faster pace. When first round of employees just became managers, people in other regions may have started to be exposed to international business that span across Asia region or global geography.
When businesses grow big enough and the management team is looking for a senior executive, when thousands of CEO positions are opened to the market, there are just not enough local executives filling into the pool. It is nature that candidates from Taiwan, Hong Kong and Singapore stand out.
They have both insight about Chinese culture and business rules, and international experiences. They are fluent in both Chinese and English. They are in their 40’s to 60’s with enough experiences. The conclusion is, they are the ideal candidates.
How about the Next 20 Years?
20 Years Anniversary of Professional Manager in Shanghai (and in China) is a great milestone. I personally feel very excited to see how big the change it is in the last 20 years. When China moves to the next decades or two, when younger professional managers like my peers in Microsoft and eBay grow more senior and become more experienced, I believe there will be enough candidates to compete in the global market as a business leader.
The market needs more people who can speak both languages – not only Chinese and English, but also the local business language and the international business language. China can be a stronger country with all these small contribution of new generation of stronger professional managers.
Productivity Tips – 5 Wrong Beliefs
I found this tip from Microsoft website very useful for me.
5 Beliefs that Limit Productivity – And How to Overcome Them
1. There’s Too Much Information Coming at Me Too Fast
2. I Have to Keep Everything
3. Organization Cramps My Freedom and Creativity
4. There’s Not Enough Time in the Day!
5. It Takes Too Much Time to Get Productive
The answers are:
1. The volume of information is not an issue. The way we process it is.
2. By removing 85% of unused documents, you feel lighter, and easier.
3. Organizing helps you to have a big block of time to do creative things.
4. Time is not the issue. Decide what to do (and more importantly what not to do) with the given time is the issue.
5. We can save much more time than the time we spend to learn to be productive.
Also, to put my commitment into the task list is a great way to keep my commitment, which is a key area to work on.
I forwarded the page to my friends I know who is also working hard to improve the productivity.
P.S. Anyone has any idea of a new tab-browser named: Sleipnir 2.3? It seems to be popular in Japan. True?
Happy Valentine’s Day
Found a Piece of Old Video
At night, chatted about my previous years, and I was amazed by how far I have gone through during the last few years. There are many moving moment when I lost my way, when I got excited, and when I fall into the lowest side of my life. It is an interesting story.
Getting back to office, I found a piece of video I recorded before – 5 years ago. I believe at that time, I was working for eCommerce team in Microsoft.
Download file (60K in size)
Also found out a picture taken on May 20, 2002. How fast the time passes! It is already 3.5 years. This was in the middle a product.
Jian Shuo Wang at Asia Community
And this:
At product RTM (Release To Manufacture date
This was taken at May 31, 2004. This was the end of another product.
Yesteday, Xiaowen (the girl on the picture) dropped an email to us for the Yuanxiao Festival. It reminded us that it was already one and half years since this picture was taken… To many friends, we make plans that we must gather once every one year. For some, we even set to meet once every several years. It sounds ridiculous when we make commitment for so long a period of time, but time always runs much faster than we can imagine.
When I thought of some other old friend, I surprised myself: “What? We haven’t seen each other for a decade already!”
Tulip Wakes Up in my Garden
When I put the 17 tulip roots into the soil of my garden, and let “Tulip Sleeps in my Garden” on Nov 9, 2005, to be honest, I never really believed that they will come out. I have never plant Tulip before, and the soil in my garden is not good – I didn’t change the soil, so it is still not different from that on the construction site. Here is what I wrote on Nov 9, 2005.
I think Nov is just the right time to plant Tulip. We went to the flower and plants market at the Long Yang Road Metro Station (just about 200 meters south of the station), and got some roots of Tulip. I carefully put them into the soil and keep my finger crossed for good luck of the Tulips.
Hopefully, next Feb, they will grow up and have followers. I hope to share the picture of the Tulips in my garden about 4 months later.
To plant something is a pleasant experience. It brings me closer to the nature, and it helps me to learn planning better. Everything is going on so quickly, and becoming quicker and quicker, thus gives us the wrong image that we can speed up a lot of things. Plants and flowers are there to remind us silently, and gracefully that there are many things that you must be patient about. If I want nice flower next spring, I have to plant it now. If I want to get good business or personal life result, I need to plant now.
Guess what happened? Today, when Wendy’s friends visited us and I showed the Tulip site, pointed to the soil and repeated the story that I don’t really believe: “Hopefully, they will come out some time this month…”, I suddenly found something different there.
What a magic: they REALLY come out of soil!
See the pictures:
Privacy of Blogging
Yesterday night, we discussed about what to blog and what not to.
I found many bloggers treat blog as a private diary and wrote something that they will never tell anybody into the blog. I don’t think it is a good approach.
Blogging is NOT a private diary. Here are some suggestions on blogging:
1. Treat blog as a TOOL. Don’t do something you won’t do because of the tool, and don’t stop doing something you have already be doing because of blog.
2. Blog has to be useful. Useful blog for someone himself/herself may not be helpful to others. It is very common and I encourage people to blog even if it is not so helpful to others if it is helpful to himself. To be helpful to others may not always be helpful to himself. It is also common. In both cases, blogging has some value. If you found it neither helpful to yourself, nor helpful to others, it means the blog doesn’t have too much value, and I recommend you to give up and stop wasting time.
3. Blogging just for blogging? It is good to try new things by starting a blog. It is good. But if you don’t feel it fits your need in some way, the solution is simple: quit blogging, although it may seems cool, hip, fashionable for others.
4. Protect other’s privacy. Privacy is defined (by some source) as the right of not to be known. People can choose whatever he/she want to write about his/her own life, but don’t involve other people’s life. The rule of thumb I use is, ask for permission if you reveals the information for other persons. To tell people what you eat for last dinner is no problem – you can share whatever about yourself, but to share what the other person ate last night seems violating this person’s privacy.
BTW, exposing too much private life without any meaningful impact also does not make too much sense. Just my 2 cents on blogging.
P.S. Technical changes
I hate to fix technical problems now, but I spent about one hour to fulfill my commitment to my friends by fixing the problems they faced. I hosted blogs for other people, including mvm, my Chinese site, claire, elfe, and wendy. Due to the server move, I only successfully moved my Chinese site and mvm to home.wangjianshuo.com and have to leave claire, elfe, and wendy on the old server. So to keep the URL unchanged, I did the following:
Under their folder at home.wangjianshuo.com, upload file as blow:
name:
.htaccess
content:
RewriteEngine On
RewriteRule (^.*) mirror.php
name: mirror.php
content:
<?php
$BLOG_MAIN_SITE = “http://wangjianshuo.com”;
$BLOG_MIRROR_SITE = “https://home.wangjianshuo.com”;
$entryfile = $_SERVER[‘REQUEST_URI’];
$file = fopen (“$BLOG_MAIN_SITE$entryfile”, “r”);
if (!$file) {
echo “
Unable to open remote file.\n”;
exit;
}
while (!feof ($file)) {
$line = fgets ($file, 1024);
echo $line;
}
fclose($file);
?>
Job is done.
Meetup: MBA or Not, that is a Question
Afternoon, attended another group discussion: Shanghai IT Club.
Arrangement
Time: 2:00 – 4:00 PM
Venue: Old Library, Shanghai Jiao Tong University
Topic: MBA 1.0 v.s. MBA 2.0
Participants:
It is a biweekly gather that many ex-microsoft collegues gathers and exchange ideas.
Below are some random note for the discussion.
Cheung Kong Graduate School of Business
MBA 1.5 year term
Flex think very highly of Cheung Kong Graduate School of Business and rated CEIBS (China European International Business School).
Link: MBA 2000 report from CKGSB
Why MBA?
Reason: Want to remove fear for unknown – want to get insight about how business runs.
Funny Answer: “The more you know, the more fear you have.”
Links: State of Fear.
Reason: Many go to MBA to seek for some changes.
Funny Answer: Uncertainty of the impact of MBA program – it is not prooved.
Yale: What is happening around is us can be very classic MBA case study. So to treasure what we can access instead of going to MBA to check other company’s MBA.
Tuition: 70,000 RMB
Duration: 2.5 year
Time: 20 Hour per week
Think very bad of the program – invested money and invest time but didn’t get that much from the program.
Fengshui V.S. Financial Knowledge
On Fengshui: It seems people in Hong Kong, Taiwan trust in Fengshui more than people in mainland.
Now I started to believe some pricinciple of Fengshui. It may be a science of usability + psychology that works very good for the land of China.
“MBA enable me to have a common language with other business leaders” – Steven
Street Smart v.s. Book Smart
How useful is Knowledge:
Daily life only requires primary school level of Chinese, and middle-school level of mathematics. Most actitivies can be handled by +-*/, not square root…
Some argues: Management is not a science. It is an art.
Some argues: Management can be a science.
Simplification can be a great way to create a science. But simplication process requires a lot of conditions to be true for the process to work.
Students are weak groups in contrast with professors and the school.
The school is only in charge of charging money, and the professor only looks for delivering the hours.
MBA and EMBA now become very profitable business in China – Fudan and SJTU have very successful business. It seems to me that CKGSB (Cheung Kong Graduate School of Business) is treating MBA and EMBA programs very seriously by investing into every student. There is no profit for CKGSB…
Disclaimer: This is just a meeting note that records the discussion and debat. I hope it does not start a controversal thread here. Take all the information as it is. No garentees of accuracy at all.
Meetup: Future Idea Foundry
I am at the Future Idea Foundry at the Starbucks of Zhong Shan Park Station of Metro Line #2.
– Sunny Sunday.
– Starting from 10:00 AM.
– Futurists gather to share ideas in Shanghai on regular bases.
– Participants are limited under 7.
Participants:
Ideas
3D Engine from Demo.com – based on Firefox engine.
# it is can be a very interesting idea to install an extension to Firefox to revert the homepage of sina.com.cn and display it in a completely new way.
On watching TV on Mobile phone – Early Adopting Geeks
People get excited about the posibility of watching TV on mobile, but people will only enjoy watching TV when the screen is big enough, the speed is fast enough and fee is cheap enough. This is called Enjoy Doing or Being Able to Do.
Mobile Internet – UA profile
The current mobile instructure only allow mobile to connect to China Mobile or China Unicom gateway, and China Mobile has removed User-Agent header from the request. The result is, no SP (Service Provider) is aware of which equipment the user is using, wheather they accept WML or WAP… It is the starting point of a closed mobile internet in China. The workaround for it is to use client software to send the information back to server in other header, or directly embed it into the URL request.
Links: Opera Mini, UCWeb, Opera Mini for Nokia 6670
I just installed Opera Mini, but it does not work now. So I need to configure a little bit later. ERROR: You do not have a working network connection. Please visit http://help.opera.com/mini/ with your desktop browser for instructios (error: 3.0.10:80)
FON
http://en.fon.com/. The funniest thing is, they have two types of people: selfish type and un-selfish time. The selfish type is called Microsoftie in their community. Oh my God!
Mobile Social Network – Dodgeball
Location based services – location based classified that allow users to post their location via SMS (check-in), and their friends/friends and friends are nearby. They were just bought by Google.
Social Filtering
Editor filtering v.s. Social Filtering.
Isaac:
1. User contribution
2. Web 2.0 aim to kill middle man
Middleman is killed, but the functions of middleman must be provided, but in a social way.
Slashdot is a great social filtering example.
Pandora – vertical industry search is more valuable
Pandora – “Can you help me discover more music that I’ll like?”
They created a engine to continously provide music and based on your own continous feedbacks, combined with other’s feedback.
For example, Google is more focused on horizontal search, while industry based vertical search, such as source code search.
Chinese Vertical
Douban.com = book review.
Book review = Douban.com
Movie = VeryCD.com
VeryCD.com = Movie
More links
The above meme was transmitted by sayonly.com
Complex system -> Preferencial selection.
Movable Type via CDMA
Nice talk with Jia and Victor at night. It is late already. I’m now on a Dazhong taxi back home, passing by the Nanpu Bridge. The whole lighting system for the city was turned off already, so it is a little bit dark now.
I brought my laptop and connected to the Internet via China Unicom CDMA. (To get it, you have to purchase the card and subscribe their service.)
I don’t want to open computer and write an entry today. The car is moving and I am typing. So I call this entry:
Movable Type via CDMA. Have good night!
Waited Long for Yuxin Sichuan Dish
3rd Floor, #333, Zhao Shang Ju Square,
North Chengdu Road 成都北路 (at the northwest corner of Weihai 威海路)
Reservation: 021-52980438
Many people in my team recommend it as the No. 1 Sichuan restaurant in Shanghai. I agree that it is a good one, although not sure if it is the best.
Really Long Queue…
When I called at 7:00 PM for reservation, the gentleman said they can give me a ticket with number, since there are many people waiting in line for seats already.
The number I got was 62. At the front of the queue, it is 20. It means, there are 42 groups of peoples are before us – that is easily 100 people waiting.
Around 7:40, we arrived only to find out the number they announce just past 40.
We waited until 8:00 PM to get a seat. At that time, the tail of the queue is 90 already. Their lobby was full of people waiting in queue, just like a railway station at the rush hours.
P.S. Canon 350D
I am pretty convienced that Canon 350D is a good choice for my bigger camera.
Image in coutesy of dpreview.com
I looked at Nikon before I bought My New Camera – Sony DSC-P8, and was Thinking about Sony F828. Now it seems Canon is a better choice. Do you have any suggestions?
Why Fudan University Only Accept Cash
Edwin spent 5 days reading this blog to prepare for his/her jouney to Shanghai for short term language program at Fudan University, but still have some questions to ask. Among them, this one is particularly interesting:
Fudan says I have to pay the tuition (4000rmb) in cash (why cash?) — my question is since i have to change such a large sum of money and walk around with it in my pocket, is it safe? Is it better to exchange money at the airport or would I get a better exchange rate within the city? Do banks take traveller’s checks or should I use cash? — I find this uncomfortable as I never carry that much cash here in my daily life so it’s weird for me…
Haha. I can understand how confusing Edwin is to bring big amount of cash in an unfamiliar environment.
It is Common
Cash is still the most widely accepted payment methods. Credit cards are widely accepted by services with better margin – restaurants, bars, shopping malls, many places still does not accept credit card. Even KFC, McDonald’s and PizzaHut does not accept credit cards in China.
Universities are among the slower mover in terms of commerical usage. I still remember the time when thousands of students carrying cash and waited in line to handin the tuition. This situation was changed in the year 1998 in Shanghai Jiao Tong University, when SJTU joined effort with ICBC (Industry and Commerical Bank of China) to issue debet cards to students.
However, it was wired at that year that when I deposited my 3000 RMB into the card, the university get the money out of my bank account without my approval. I believe this won’t happen today.
For short-term study, it is very common that they only accept cash. There is nothing strong here. So just accept it. :-)
Carrying Cash on the Street?
I don’t think anyone would say it is safe to carry large amount of cash on the street. So won’t I. But carrying cash is the only way to do that, my best suggestion is be careful. 4000 RMB is not that huge in Shanghai – many people take much more than that. It was because Cross Bank Money Transfer was not easy before some tools were put into use.
If you can choose, I suggest you to get the cash from a bank (Bakn of China) near Fudan University. You may ask where you can find the bank after you get to Fudan. To exchange at the airport is another option, but there is no discount to do that.
I have no idea about traveller’s check. It is not a common concept for people here, but I believe banks may accepted, or NOT. Check with your bank first. Citibank are here with a lot of ATM machines. You may ask their branches to get more information.
Wish you a safe trip (with the cash).
P.S. Found my picture in the Esquire magazine 2006.02 issue. It is a group photo occupying two full pages. I am not a fashion fun, and didn’t know what Esquire is. Is it a big brand in U.S? I guess so because many said Esquire is big. The Chinese version is named Shi Shang Xian Sheng (or translated as Fashionable Men).
Google’s Removed BMW.de
Max dropped an email to us: Google blacklists BMW.de this morning.
Two points I saw in this post and Cutts’ blog:
1. They (Google) have webspam team who do the removal MANNUALLY.
2. They think JavaScript redirect and presenting “too” different view for robot and to users are not good, as specified in their webmaster quality guidelines
.
Credit Cards Offer Discount at Preferred Stores
I hold credit card from the year of 1999. At that time, Credit Cards are not as popular as today. Most of the cards at that time are debut cards. But I never experienced discount offering as often as today.
When I went to the Coffee Bean and Tea Leaf at the Raffles City, I was offered again for 10% off for my China Merchant Bank (CMB) Credit Card. All sales above 50 RMB and paid via CMB card are eligible for the offer.
More banks follow to this kind of discount as their selected stores and merchants. This is good for consumers like me, and meanwhile, it is a clear sign that the competition on the financial service is heated up.
Now, the saving rate for individuals are as low as a little bit more than 2% (for one year), while the mortgage rate is as high as more than 5%. The margin for banks is high enough. The credit card transaction fee is also a very good business.
The discount may be the starting point of the new round of financial market adjustment.
Disclaimer: I don’t have financial knowledge. Just two cents on what I experienced today.
The Last Day of Vacation
Feb 4 is the last day of the 7-day long Spring Festival vacation. Tomorrow, all the business will resume. It is nice to have a pause and a lot of thoughts become clearer than before. As a book put it, the natural is full of working – and rest. The Sun, the moon, the four seasons and the tide of sea – there are almost no single object that keeps running but never pause. So to take a vacation meets the rule of the nature.
Today, I sent my car (Goudaner) for maintainance. Everything went on well, until at last, the careless driver drove the car to the washing room, but failed to brake. My poor car hit the wall and the head was crashed. How painful it will be if the car has a life. (Who told me, cars with a nick name lasts longer than those without a nick name?) I felt the pain. The FIAT service center promised to replace everything for free and lent me another white Palio Weekend until my car was fixed. OK. That is the best they can do and I can imagine. Of cause they also waived the fee for the maintaince. Well. Tomorrow, we will drive a different car. Although it is almost the same model as my Goudaner, I won’t call it with the nickname I have for my lovely car. This March 15th will be its second year birthday. Poor thing.
Beijing Winter 2006
Ice field of the Summer Palace.
© Jian Shuo Wang. Winter at the Summer Palace.
© Jian Shuo Wang. Winter at the Summer Palace.
© Jian Shuo Wang. Trees at the Summer Palace
Thanks Che Dong for bringing the USB cable to me. That helped me a lot. Otherwise, I couldn’t take pictures at the Beijing Airport today.
P.S. I am happy to have dinner with my friends in Beijing again. Che Dong, Ada, An Ti, Lu Liang, Ming Zhu… (Finally, I found we represented many High-Tech companies: Baidu, Yahoo!, eBay, Microsoft, New York Times, and Bokee…)
I Need a USB Cable
I remembered to bring my camera (SONY P8) with me during my travel but left the cable connection at home. It is a gray USB cable with a standard USB outlet on the one side and a mini USB on the other side. Without the cable, all my 128M pictures still sit in my memory stick in my camera, and I cannot transfer them to my laptop. There are many photos of Beijing that I cannot share now.
God of Fortune Arrived
According to the Chinese tradition, the 5th day of new year is the day the God of Fortune return to everyone’s home.
Last year in Shanghai, fireworks were stronger than the New Year’s Eve to Welcome to the God of Fortune. In Beijing, last night was a quite night with almost no fireworks. That is clearly the difference on culture and tradition between Beijing and Shanghai.
Added Commenter Profile Page to MovableType
If you check the site careful enough, you will see a small icon besides the name of the commenter. It is newly added feature – Commenter Profile:
The link on the icon will lead you to the profile page of the commenter, so you understand what comments he/she has posted before.
Since it is based on display name only, don’t always take it for granted that people with same display name are the same person. If you found your name are too common, choose a more unique name.
Code?
Below are the code I used. It is very massy, since I didn’t spent time to make it workable for others. It just fit the needs of this blog. I wrote it as if I were writting a blog entry. When what I try to express is completed, the code is completed. So take whatever you can take from the code, but don’t expect it to work on your MovableType directly. For those who don’t like tech stuff, sorry for posting techie again.
<?php
function dirify($s) {
$s = strtolower($s); ## lower-case.
$s = strip_tags($s); ## remove HTML tags.
$s = preg_replace('!&[^;\s]+;!','',$s); ## remove HTML entities.
$s = preg_replace('![^\w\s]!','',$s); ## remove non-word/space chars.
$s = preg_replace('!\s+!','_',$s); ## change space chars to underscores.
return $s;
}
$mt_blog_users = "https://home.wangjianshuo.com/users/";
$mt_blog_archive = "https://home.wangjianshuo.com/archives/";
$file = '<Location of mt-config.cgi file>';
$cfg = array();
if ($fp = file($file)) {
foreach ($fp as $line) {
// search through the file
if (!ereg('^\s*\#',$line)) {
// ignore lines starting with the hash symbol
if (preg_match('/^\s*([^ ]+)[ ](.*)(\r|n)?$/', $line, $regs)) {
$key = trim($regs[1]);
$value = trim($regs[2]);
$cfg[$key] = $value;
}
}
}
} else {
die("Unable to open configuration file $file");
}
$db = mysql_connect($cfg['DBHost'], $cfg['DBUser'],
$cfg['DBPassword']) or die ('I cannot connect to MySQL.');
mysql_select_db($cfg['Database']);
$query = "SELECT comment_author,
count(comment_author) as comment_count
FROM mt_comment
GROUP BY comment_author
ORDER BY comment_count";
$result = mysql_query($query);
$comment_author_previous = "";
$comment_author_next = "";
while ($row = mysql_fetch_array($result)) {
if($row['comment_author'] == $user) {
$comment_author_previous = $comment_author_previous_temp;
}
if($comment_author_previous_temp == $user) {
$comment_author_next = $row['comment_author'];
}
$comment_author_previous_temp = $row['comment_author'];
}
echo "<small><a href='$mt_blog_users$comment_author_next.htm'>« $comment_author_next</a> |";
echo " <a href='https://home.wangjianshuo.com/scripts/mt-user/mt-all-user.php'>Commenters</a> ";
echo "| <a href='$mt_blog_users$comment_author_previous.htm'>$comment_author_previous »</a></small>";
$user or $user = 'Jian Shuo Wang';
$query = "SELECT entry_id, entry_title,
comment_id, comment_url,
entry_excerpt, comment_text,
comment_entry_id,
date_format(entry_created_on, '%Y%m%d') as comment_entry_ymd,
date_format(comment_created_on, '%h%i') as comment_hourmin,
comment_created_on
FROM mt_comment, mt_entry
WHERE comment_entry_id = entry_id
AND comment_author = '$user'
ORDER BY comment_id DESC
LIMIT 300";
$comment_url = "";
$comment_count = 0;
$html = "";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$comment_entry_id = $row['comment_entry_id'];
$html = $html . "<p>" . (nl2br($row['comment_text'])) .
"<p><small>Posted by $user at <
a href='https://home.wangjianshuo.com/users/" .
$row['comment_id'] . ".htm' target=_blank>" .
$row['comment_created_on'] .
"</a> on <a target=_blank href=$mt_blog_archive" .
$row['comment_entry_ymd'] .
"_" . dirify($row['entry_title']) .
".htm#" . $row['comment_hourmin'] .
">" . $row['entry_title'] .
"</a></small><hr>";
$comment_url or $comment_url = $row['comment_url'];
$comment_count = $comment_count + 1;
}
echo "<h1>$user</h1><a href='$comment_url' target=_blank>$comment_url</a> ";
echo "Posted <b>$comment_count</b> comment(s)";
echo $html;
mysql_free_result($result);
mysql_close();
?>
Beijing is Cold. Life is Warm
I love Beijing so much. Although it is freezing outside, it is very warm inside any room. Thanks to the centralized heating system.
The food of Beijing is wonderful for me. I enjoy my life in Beijing as much as I did in Shanghai.
Beijing is my top travel destination. I have many articles in my Beijing category.