dedecms顶踩功能

CREATE TABLE `dede_vote` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `aid` int(11) NOT NULL, -- 文章ID
  `uid` int(11) NOT NULL, -- 用户ID
  `type` tinyint(1) NOT NULL DEFAULT '0', -- 0表示踩，1表示顶
  `vtime` int(11) NOT NULL DEFAULT '0', -- 操作时间
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid_aid_type` (`uid`,`aid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

<button id="upvote" onclick="vote(1)">顶</button>
<button id="downvote" onclick="vote(0)">踩</button>

<?php
// 处理顶踩请求
function vote($type, $aid, $uid) {
    global $dsql;
    $vtime = time();
    $sql = "INSERT INTO dede_vote (aid, uid, type, vtime) 
             VALUES ('$aid', '$uid', '$type', '$vtime') 
             ON DUPLICATE KEY UPDATE type = '$type', vtime = '$vtime'";
    $dsql->ExecuteNoneQuery($sql);
    return true;
}
?>