phpcms2008数据导入phpcmsv9
发布:smiling 来源: PHP粉丝网 添加日期:2014-10-22 10:34:49 浏览: 评论:0
这里直导入news模型和栏目,其他的以此类推.
phpcms2008_c_news导入.sql,代码如下:
- INSERT INTO
- `phpcmsv9`.`v9_news_data`
- (
- `id`, `content`, `paginationtype`,`maxcharperpage`,`copyfrom`,`readpoint`,
- `paytype`, `voteid`, `allow_comment`
- )
- SELECT
- `contentid`, `content` ,`paginationtype`,`maxcharperpage` , '|0' as `copyfrom`, `readpoint`,
- 0 as `paytype`, 0 as `voteid`, 1 as `allow_comment`
- FROM `phpcms2008`.`phpcms2008_c_news`
phpcms2008_category导入.sql,代码如下:
- INSERT INTO `phpcmsv9`.`v9_category`
- (
- `siteid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `catdir`,
- `url`, `catid`,
- `items`, `hits`,
- `setting`,
- `listorder`, `ismenu`, `sethtml`, `letter`
- )
- SELECT
- '1' as `siteid`,'content' as `module`,`type`,`modelid`, `parentid`,`arrparentid`,`child`,`arrchildid`,`catname`,`catdir`,
- concat('http://www.phpfensi.com/index.php?m=content&c=index&a=lists&catid=',`catid`) as `url`,`catid`,
- `items`,`hits`,
- "array (
- 'workflowid' => '1',
- 'ishtml' => '0',
- 'content_ishtml' => '0',
- 'create_to_html_root' => '0',
- 'template_list' => 'default',
- 'category_template' => 'category',
- 'list_template' => 'list',
- 'show_template' => 'show',
- 'meta_title' => '',
- 'meta_keywords' => '',
- 'meta_description' => '',
- 'presentpoint' => '1',
- 'defaultchargepoint' => '0',
- 'paytype' => '0',
- 'repeatchargedays' => '1',
- 'category_ruleid' => '6',
- 'show_ruleid' => '16',
- )" as `setting`,
- `listorder`,`ismenu`, 0 as `sethtml`, `letter`
- FROM `phpcms2008`.`phpcms2008_category`
phpcms2008_content导入.sql,代码如下:
- INSERT INTO
- `phpcmsv9`.`v9_news` (
- `id`,`catid`, `typeid`, `title`, `thumb`, `keywords`, `description`, `posids`,
- `url`,
- `listorder`, `status`,
- `sysadd`,
- `username`, `inputtime`, `updatetime` ,`islink`
- )
- SELECT
- `contentid`,`catid`,`typeid`, `title`, `thumb`, `keywords`, `description`, `posids`,
- concat('http://localhost/phpcmsv9/index.php?m=content&c=index&a=show&catid=',`catid`,'&id=',`contentid`) as `url`,
- `listorder`, `status`, //phpfensi.com
- 1 as `sysadd`,
- `username`, `inputtime`, `updatetime`, `islink`
- FROM `phpcms2008`.`phpcms2008_content`
phpcms2008_search导入.sql,代码如下:
- INSERT INTO `phpcmsv9`.`v9_search` (
- `searchid`,
- `typeid`, `id`, `adddate`, `data`, `siteid`)
- SELECT
- `searchid`,
- 1 as `typeid`, `searchid` as `id`, UNIX_TIMESTAMP() as `adddate` , `data` ,1 as `siteid`
- FROM `phpcms2008`.`phpcms2008_search`
Tags: phpcms2008导入phpcmsv9
- 上一篇:phpcms常用标签
- 下一篇:PHPCMS V9内容页点击量如何调用
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)