復(fù)制代碼 代碼如下:

<?php
defined('IN_PHPCMS') or exit('No permission resources.');
pc_base::load_sys_class('model', '', 0);
class keyword_ext_model extends model {
public $table_name = '';
public function __construct() {
$this->db_config = pc_base::load_config('database');
$this->db_setting = 'default';
$this->table_name = 'keyword_ext';
parent::__construct();
}
}
?>

復(fù)制代碼 代碼如下:

CREATE TABLE `t_v9_keyword_ext` (
`tagid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`tag` char(50) NOT NULL,
`style` char(5) NOT NULL,
`usetimes` smallint(5) unsigned NOT NULL DEFAULT '0',
`lastusetime` int(10) unsigned NOT NULL DEFAULT '0',
`hits` mediumint(8) unsigned NOT NULL DEFAULT '0',
`lasthittime` int(10) unsigned NOT NULL DEFAULT '0',
`listorder` tinyint(3) unsigned NOT NULL DEFAULT '0',
`modelid` smallint(6) DEFAULT '0',
PRIMARY KEY (`tagid`),
UNIQUE KEY `tag` (`tag`),
KEY `usetimes` (`usetimes`,`listorder`),
KEY `hits` (`hits`,`listorder`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

復(fù)制代碼 代碼如下:

function tags($field, $value)
{
if(!$value) return '';
if(strpos($value, ','))
{
$s = ',';
}
else
{
$s = ',';
}

$keywords = isset($s) ? array_unique(array_filter(explode($s, $value))) : array($value);
$keyword_db = pc_base::load_model('keyword_ext_model');

foreach($keywords as $tag)
{
$tag = trim($tag);
$keyword_db->delete(array("tag"=>$tag,"modelid"=>$this->modelid));
$c=$this->db->count("keywords like '%".$tag."%'");
$keyword_db->insert(array("modelid"=>$this->modelid,"tag"=>$tag,"usetimes"=>$c,"lastusetime"=>SYS_TIME),false,true);
}

return implode($s, $keywords);
}