Workable APN for China Unicom 3G on iPad Mini

Currently I use this:

APN: BJTWXD.OTHER.BJAPN
Username: 123
Password: 123

‘Coz this’s the recommended settings by the service provider China Unicom BJ.

BTW, the package I’ve bought is 3GB in 6 months cost 300 RMB officially(actually less than 150 via Taobao). It’s said this package is for Beijing only.

However, after two month I have to say this APN is NOT always workable. I don’t know the reason. and I haven’t call the sp. Instead, I asked google and got another APN:

APN: 3gnet
Username:(blank)
Password: (blank)

Guess what? It’s working, sometimes.

So all in all, I use the two APNs mentioned above. And when one doesn’t work, I’ll use the other. If you don’t care about the difference like I do, you can use my method.

Access Twitter and Facebook in China

If you plan to use twitter for iphone(iTunes) in a place where twitter dot com has been blocked, like me, then i recommend you to take a look at twip.

Quote

twip is a twitter API Proxy in php,like birdnest.

twip is licensed under Mozilla Public License 1.1

If you are a user and want to have your own API proxy, please read ForUser Guide.

If you are a client developer and want to support twip in your client, please read ForDeveloper Guide

In my testing until now it works like a charm!!
And it’s great to breathe the free air.

And yep, i’ve also tried hard to find an facebook proxy. Those online proxies out there either are blocked already, or on the way to be.

Same to those free VPN solutions(Paid one is a good solution to the gfw blocking, if you’re willing to pay).

Tor(and the bridge part) is a little bit slow to me. And i tried also to setup my own with the help of phpproxy, and unfortunately failed(fk gfw, and the creator fxd!).

So for now I still use GAppProxy in my computers, though ssl problem happens time to time. In the iPhone due to the ssl issue, those fb and twitter apps that require ssl cert to authenticate has no luck for sure.

Hope it helps.

Use iPhone to Update Tao Weibo

It’s been a LONG time since my last post, really. Over three months. Long indeed. Why soooooo long? The answer is Tao Weibo, a micro-blogging service powered by StatusNet aiming to accumulate the record of TaoTao‘s growing up experience, either painful or pleasant, happy or sad. ‘Coz we believe in the end they all are  significant parts of memory.

One of the reasons I choose StatusNet is because it has an iPhone app called StatusNet Mobile(iTunes), by which the taken photos in the phone could be easily uploaded. Normally I will resize picture to a lower resolution by the free SimpleResize app, ‘coz that will cut down the traffic cost and fast the upload speed when the phone is in cellular network. If you wanna add some effects to the original photo, I may launch the free photo editing tool iRetouch Lite to make it.

And I just found the short message would be much more nice and cute with some emoji added, since I happened to update the phone to the whited00r firmware v3.3 that seamlessly supports emoji keyboard. And StatusNet Mobile does support emoji, too.

However, only when your prime browser support emoji then can you see them well. Chrome user please install this extension, Firefox user please follow this guide. IE user? sorry.

iPhone 4 Unlocked by Dev-Teams’ Ultrasn0w 1.0-1!

The most well-known online iphone hacking group the iphone dev-team just announced that the iPhone 4 has been unlocked by the updated ultrasn0w 1.0-1(via the official blog here).

iPhone 4 Unlocked by Ultrasn0w from Dev-Team

Quotes:

Version 1.0-1 of ultrasn0w works for:

  • iPhone4 baseband 01.59
  • 3G/3GS basebands 04.26.08, 05.11.07, 05.12.01 and 05.13.04

(If ultrasn0w doesn’t show when you search Cydia, add the repo:  repo666.ultrasn0w.com)

Cheers!

Jailbreak is legal now.So?

Sure it’s a good news, for all of the iphone jailbreakers, esp. people of the States.

But does it mean Apple will modify their warranty policy accordingly and promise to provide post-sale service to our devices?

If not, what can we get from this?

Let’s wait and see.

Update(Jul.27,2010): Consumers still shouldn’t jailbreak their iPhones says Apple 

But what happens if jailbreaking goes mainstream as a result of the new exemption?
What if a company like Adobe or Google were to publicly embrace jailbreaking in order to distribute apps Apple doesn’t want on the iPhone?

First Unofficial iPhone 4 Entering ZGC of Beijing,China

‘Someone fly to Japan to get the iPhone 4 after a in-line waiting. And currently it costs 8~9k RMB(1178~1325 USD) and has been pre-ordered.’, said the ZGC reseller,’the device is still un-jailbroken, no phone call and sms sending and receiving’.

Via XinhuaNet.

With that price, I’d rather choose to get an Mac Pro, personally.

How-to: Migrate data from WordPress 2.9 to WordPress 3.0(subsite)

This is exactly how I get my original data of cuimengsuo.com back online to cuiziqi.com/cui/en.
My method requires you have an idea of database, a little bit MySQL programming skills, and a DIY-holic spirit.

First allow me to introduce my situation, you know, the context.
1.I’ve been added a new sub site http://cuiziqi.com/cui/en (Thanks to the new WP 3.0, the steps are pretty easy, check out the official guide here. Naming it en ‘coz the posts are in English).
2.and I’ve had a database online where all my previous data of cuimengsuo.com are stored there.
3.Besides, I’ve uploaded all my uploads(/wp-contents/uploads) to my current hosting server(since I already knew that all subsites of WP 3.0 share the same uploads folder, I then uploaded them to that folder as well).

One more thing, a simple look at the database you’ll know that WP will save the all of your new sites’ data in the tables with the prefix wp_2_, like wp_2_posts, wp_2_terms, etc. Besides, further side by side table compare will tell you that which table/data are created by your installed plug-ins, other than WP itself(I assume here your new site are a fresh install until now, like I did).

Now time to figure out what exactly you wanna transfer.
In my case, all I care about is my posts, pages, tags, categories and comments. No links, since I didn’t have many. No user either, since I’m the only author.

Warning: I suggest you do a database backup before start. Log on to your phpMyadmin panel, open two tabs which shows your the old and the new database.

OK,now showtime.

first, the posts and the pages, accordingly the table wp_posts.

1. Modify the old wp_posts table.
>>rename it to wp_2_posts.
>>remove the field post_category, ‘coz there’s no such a field in the new wp_2_posts table accordingly.
>>update the domain name string in the post_content. In my case, from http://cuimengsuo.com to http://cuiziqi.com/cui/en.
update wp_posts set post_content=replace(post_content,’http://cuimengsuo.com’,’http://cuiziqi.com/cui/en’) WHERE instr(`post_content`,’http://cuimengsuo.com’)>0
>>export the data to a zipped sql file and save it to your local hard disk.

2.Modify the new wp_2_posts
>>clear the table
>>uncheck the field ID‘s AUTO_INCREMENT property.

3.Transfer the data.
>>goto the new database and import the data.

4.Enable the new table wp_2_posts.ID‘s AUTO_INCREMENT.

5.Done.
Visit your blog and you should see your posts back.  Great, eh? Not finished yet, let’s move on.

Now comments, obviously the table is wp_comments(I just leave wp_commentmeta out and seems until now everything works fine. but if you think it wrong, please correct me via comments). Most of the steps are similar to what we’ve done in posts actually. Here they are.

1.Update the old wp_comments table.
>>rename wp_comments into wp_2_comments

>>Url replacement in two fields: `comment_author_url and comment_content.
update wp_2_comments
set `comment_author_url`=replace(`comment_author_url`,’http://cuimengsuo.com’,’http://cuiziqi.com/cui/en’),comment_content=replace(`comment_content`,’http://cuimengsuo.com’,’http://cuiziqi.com/cui/en’)

2.Prepare the new wp_2_comments table.
>>do the clear, like we do in the posts;
>>uncheck comment_ID‘s AUTO_INCREMENT.

3.Export the data from old table and then import it into the new one.
4.Restore the new table’s AUTO_INCREMENT.

Last, the tags and categories. They all are in the following tables: wp_2_terms,wp_2_term_relationships and wp_2_term_taxonomy.
Basically the steps are the same: clear data for the new table, disable AUTO_INCREMENT if necessary, do the export and import, finally enable AUTO_INCREMENT accordingly.

All done and enjoy.

Cui – On My Way is back!

After couple of hours data migration work, I finally got this:

almost all valued contents of the blocked blog http://cuimengsuo.com has been transferred to this new address http://cuiziqi.com/cui/en.

That is to say, Cui – On My Way is back. And reloaded in the new URI as promised before(not by sub-domain,but sub-virtual directory).

And I’ll keep it updated as usual. For friends like you, your visit and comments are warmly welcomed as usual as well.