以前设想过用存储过程来对从百度导入的原博文进行分类, 这种语义情景分析功能, 显然以我的能力无法使用, 所以就采取了简单的 SQL 语句加上手动修改来进行.

部分SQL 语句如下:
–insert inexistent relationships
INSERT INTO wp_term_relationships (object_id,term_taxonomy_id)
SELECT id,1 from wp_posts where id NOT IN (SELECT object_id FROM `wp_term_relationships`);

–display posts of inexistent category
CREATE TEMPORARY TABLE tmp_table (
id INTEGER NOT NULL
) TYPE = HEAP;
INSERT INTO tmp_table
SELECT object_id FROM `wp_term_relationships` where object_id in (SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id NOT IN
(SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy = ‘category’)
and
(object_id NOT IN
(
SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN
(SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy = ‘category’)
) ));
SELECT * FROM `wp_term_relationships` where object_id in
(SELECT * FROM tmp_table);
SELECT * FROM `wp_posts` where id in
(SELECT * FROM tmp_table);

–change inexistent category
UPDATE `wp_term_relationships`
SET term_taxonomy_id=1
WHERE object_id IN (SELECT * FROM tmp_table);

IT log ‘s category
1 default
2 think
6 live
87 wisdom
88 library

access wordpress by post’s id, such as: http://zuolo.info/?p=5

–change category by specify id
UPDATE `wp_term_relationships`
SET term_taxonomy_id=2
WHERE object_id=5 and term_taxonomy_id=1;

–recount category number
SET @taxonomy=1;
UPDATE wp_term_taxonomy
SET count=(SELECT count(*) from wp_term_relationships where term_taxonomy_id=@taxonomy)
WHERE term_taxonomy_id=@taxonomy;

手动修改主要是针对以前存放在百度Hi空间的相册图片, 百度这种不然其他网站引用其相册图片的做法实在太恶心了, 而且没有方便的导出功能.

我先把图片下载到D盘, 然后上传到 flickr 中, 再通过 [/flickr] 引用.

而且我上面 sql 操作只是简单的把未分类的项目都归到默认类别中, 所以我还一边翻页查看博客类型, 一边通过 phpMyAdmin 来执行 sql 修改类别.

真是件很麻烦的事情, 这么晚了才更新到 http://zuolo.info/page/50 , 累了, 先睡觉了, 明天还有工作.

上传图片到 Flickr 时发现其一个很阴险的事情. 不升级的话, 在 photostream 中只能看到最近的200张图片, 看来我以后又不得不每年掏出25$. 之前注册用户时这一条并没看到提醒, 现在属于上了贼船了, 呵呵, 不过等掏钱后, 我一定要拼命拍照, 使其物有所值.