phpcms v9编辑器ckeditor数据恢复功能
为phpcms v9的ckeditor编辑器开发的数据恢复功能.下面直接上步骤说明吧.
1.\statics\js\ckeditor\config.js文件最后增加以下代码:
//化蝶自在飞 add 2011-11-12 自动保存数据 var timer = counttimer = '30';//每?秒保存一次 var delays = 10;//延迟多少秒执行,因为firefox下无法显示,建议设置为10000 var editorid = 'content'; var fromid = 'myform'; $(function(){ var str = '恢复数据'+timer+'秒后自动保存'; setTimeout('$(".cke_footer").append(\''+str+'\')',delays*1000); setInterval('tuzwu_posts()',timer*1000); setInterval('tuzwu_timer()',1000); }); function tuzwu_posts(){ //post提交数据 var editor = CKEDITOR.instances[editorid]; data = editor.getData(); $('#'+editorid).val(data); $.post("api.php?op=editor_data", $("#"+fromid).serializeArray(),function(data){ $('#'+editorid).val(); }); } function tuzwu_timer(){ //每秒执行1次,倒数计时 if(timer
2.建数据表用于保存数据:CREATE TABLE `v9_editor_data` ( `id` mediumint(8) NOT NULL auto_increment, `data` mediumtext character set gbk NOT NULL COMMENT '数据', `time` int(10) NOT NULL, `userid` mediumint(8) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
注意:表前缀和数据库编码,推荐自己手工用phpmyadmin建表;
3.\phpcms\model\editor_data_model.class.php新建该文件,用以下代码填充文件:<?php defined('IN_PHPCMS') or exit('No permission resources.'); pc_base::load_sys_class('model', '', 0); class editor_data_model extends model { public function __construct() { $this->db_config = pc_base::load_config('database'); $this->db_setting = 'default'; $this->table_name = 'editor_data'; parent::__construct(); } } ?>
4.\api\editor_data.php新建改文件,用以下代码填充该文件:<?php defined('IN_PHPCMS') or exit('No permission resources.'); header('Content-type: text/html; charset=utf-8'); $db = pc_base::load_model('editor_data_model'); $_userid = param::get_cookie('userid'); if(!$_POST['info']['content']) exit('0'); $postinfo = array2string($_POST['info']); $postdata = CHARSET != 'utf-8' ? iconv('utf-8', CHARSET, $postinfo ):$postinfo; $posts = array( 'data'=>$postdata, 'userid'=>$_userid, 'time'=>SYS_TIME ); $r = $db->get_one( array('userid'=>$_userid,'data'=>$postdata),'id' );//如果没有改变就不用备份 if($r) exit('0'); $db->insert($posts); exit('1'); ?>
5.\phpcms\modules\content\databak.php新建该文件,代码如下:<?php defined('IN_PHPCMS') or exit('No permission resources.'); //模型缓存路径 define('CACHE_MODEL_PATH',CACHE_PATH.'caches_model'.DIRECTORY_SEPARATOR.'caches_data'.DIRECTORY_SEPARATOR); pc_base::load_app_func('util','content'); pc_base::load_app_class('admin','admin',0); class databak extends admin { private $db; function __construct() { $this->db = pc_base::load_model('editor_data_model'); $this->_userid = param::get_cookie('userid')?param::get_cookie('userid'):param::get_cookie('admin_userid'); $this->_username = param::get_cookie('_username'); $this->_groupid = param::get_cookie('_groupid'); } public function init() { if(!$this->_userid) exit('用户ID校验失败'); $page = $_GET['page']?$_GET['page']:1; $infos = $this->db->listinfo( array('userid'=>$this->_userid),'time DESC',$page,20,'',10 ); $pages = $this->db->pages; $target = $_GET['target']; include $this->admin_tpl('databak'); } } ?>
6.\phpcms\modules\content\templates\databak.tpl.php新建改文件,代码如下:<?php header('Content-Type:text/html;charset=utf-8'); defined('IN_ADMIN') or exit('No permission resources.'); $show_dialog = 1; ?> class="addbg"<?php } ?>><?php echo L('website_manage');?> <?php if(isset($show_dialog)) { ?><?php } ?><?php if(isset($show_validator)) { ?><?php } ?><?php if(!isset($show_header)) { ?>备份生成时间 标题 <?php if(is_array($infos)){ foreach($infos as $info){ $data = string2array(CHARSET != 'utf-8' ? iconv( CHARSET,'utf-8', $info['data'] ):$info['data']); $info['title'] = $data['title'] ? $data['title'] : '暂无标题'; $jsondata = json_encode($data); ?><?php } } ?> <?php echo $pages?>by 化蝶自在飞 <?php echo date("Y-m-d h:i:s",$info['time']);?> <?php echo $info['title']?>
完毕.2011-11-12 for http://www.xiaojudeng.com,转载请注明出处,谢谢.