robertbao

    robertbao

    @www

    Email
    email

    License
    本站内容均为原创,转载请注明作者信息和原文链接。
    license

    Counter

    中国加油!

    05月 24th, 2008 robertbao Posted in Record 832 views 18 Comments »

    drupal向wp的移植过程

    05月 24th, 2008 robertbao Posted in Program 1,135 views 11 Comments »

    1、wp的表结构比drupal简单多了,要移植的主要就是四张表,

    分类表wp_categories:

    insert into
    wp_categories (cat_id, cat_name, category_nicename, category_description, category_parent)
    select term_data.tid, name, name, description, parent
    from term_data, term_hierarchy
    where term_data.tid=term_hierarchy.tid;

    update wp_categories
    set category_count = (select count(post_id)
    from wp_post2cat
    where wp_categories.cat_id = wp_post2cat.category_id);

    文章表wp_posts:

    insert into
    wp_posts (id, post_date, post_content, post_title, post_excerpt, post_name, post_modified)
    select distinct n.nid, from_unixtime(created), body, n.title, teaser,
    replace(replace(replace(replace(lower(n.title),’ ‘, ‘_’),’.', ‘_’),’,', ‘_’),’+', ‘_’), from_unixtime(changed)
    from node n, node_revisions r
    where n.vid = r.vid;

    update wp_posts set post_name = replace(post_name, '_', '-');

    文章分类关系表wp_post2cat:

    insert into
    wp_post2cat (post_id,category_id)
    select nid,tid
    from term_node ;

    评论表wp_comments:

    insert into
    wp_comments(comment_post_id, comment_date, comment_content, comment_parent, comment_author, comment_author_email, comment_author_url)
    select nid, from_unixtime(timestamp), comment, thread, name, mail, homepage
    from comments ;

    update wp_posts
    set comment_count = (select count(comment_post_id) from wp_comments where wp_posts.id = wp_comments.comment_post_id);

    2、移植过程中一些问题的修正,

    分类表中文章数:

    update wp_categories set category_count =84 where cat_id=1;
    update wp_categories set category_count =205 where cat_id=5;
    update wp_categories set category_count =142 where cat_id=6;
    update wp_categories set category_count =274 where cat_id=11;

    参数表:

    update wp_options set option_value='http://www.robertbao.com' where option_id=40 or option_id=1;

    3、三个post转为page,并将post调整从1149开始继续计数,

    alter table wp_posts auto_increment = 1149;

    delete from wp_post_counter_time where post_id>='9527';
    delete from wp_post_counter where post_id>=’9527′;
    delete from wp_postmeta where post_id>=’9527′;

    delete from wp_posts where id='1';
    delete from wp_posts where id=’2′;
    delete from wp_posts where id=’3′;

    update wp_posts set id='1',guid ='http://www.robertbao.com/?page_id=1' where id='1151';
    update wp_posts set id=’2′,guid =’http://www.robertbao.com/?page_id=2′ where id=’1150′;
    update wp_posts set id=’3′,guid =’http://www.robertbao.com/?page_id=3′ where id=’1149′;

    drupal升级记录

    05月 24th, 2008 robertbao Posted in Record 824 views 1 Comment »

    1、drupal:
    备份数据库,备份ftp文件

    2、theme:
    保存themes/b9527
    注意:engines中phptemplate升级

    themes/b9527/node.tpl.php中删除原来添加的flexiblock:

    <?php $blocks = theme(’flexiblock_blocks’, 1); ?>
    <?php foreach ( $blocks as $block ) { ?>
    <?php echo $block['content'] ?>
    <?php } ?>

    themes/b9527/node.tpl.php第二行删除:

    <?php if ($picture) {
    print $picture;
    }?>

    3、module:
    tinymce×
    trackback×
    poormanscron
    spam
    glossary×
    flexiblock×
    nodewords×
    sitemenu×
    interwiki×
    comment_info

    4、index.php最后加入bbclone统计代码

    5、注释掉blog.module中blog_link函数的主要内容,不显示单篇blog下的链接

    6、comment模块中
    function _comment_per_page() {}
    评论数从300改为900

    7、用自己的favicon.ico替换/misc/favicon.ico

    8、设置中文件系统路径files改为i

    上来看看

    05月 22nd, 2008 robertbao Posted in Record 839 views 发表评论 »

    真是时光似箭,转眼都一年没上来写点啥了…

    Word 2007 中的书法字帖

    05月 20th, 2007 robertbao Posted in Pastime 830 views 20 Comments »

    shufa.jpg

    看到上面的书法字体了吗,很帅吧,可别以为是我写的,我现在都不知道笔咋握了~~~

    上面的字其实都是用 Word 2007 中的”书法字帖”功能写出来的,这项功能可以灵活地创建字帖文档,自定义字帖中的字体颜色、网格样式、文字方向等,然后将它们打印出来,就像小时候练字的字帖一样了。

    具体创建过程很简单:

    1、在”新建文档”对话框中选择”书法字帖”;

    2、在”书法”选项卡中点击”增减字符”,在”书法字体”包含的11种类型列表中,选择要使用的字体类型;

    3、单击”关闭”按钮,选择的字符就会添加到文档中,同时打开”书法”工具栏,可以进行各种颜色、样式方面的调整。

    同时还可以选择”网格样式”,包括了常见的米字格、田字格等(怎么没有回宫格,hehe),这样打印出来,就可以像字帖一样进行书法练习了。

    style.jpg

    PS:只是现在每种字体的字库数量还比较少,数量最多的汉仪赵楷繁,也不过才2010个字,甚至比不上老徐的6000多字,这样就会有很多常用字找不到,期待 Word 以后的完善吧…