January.05.2004
540 Viewed
功能: 允许游客对文章评分,适用于 phpArticle 2.0.0
作者: Hyeo
最后修改: 21:29 2003-7-31
主页: http://www.21ds.net
确认你在安装时所使用的表前缀为 pa_ ,如果不是,把下面的sql中的 pa_ 替换成你所安装时所使用的表前缀.运行以下sql.
ALTER TABLE `pa_articlerate` ADD `ipaddress` VARCHAR(16) NOT NULL;
ALTER TABLE `pa_articlerate` ADD INDEX ipaddress (ipaddress);
登陆后台,修改游客所在的用户组权限,把"可以对文章评分?"设置为"是"
修改 feedback.php
查找:
if ($pauserinfo[userid]==0) {
show_nopermission();
}
删除
查找:
$checkvote = $DB->fetch_one_array("SELECT * FROM ".$db_prefix."articlerate
WHERE articleid='$articleid' AND userid='$pauserinfo[userid]'");
替换为:
$ipaddress = getip();
if ($pauserinfo[userid]!=0) {
$checkvote = $DB->fetch_one_array("SELECT * FROM ".$db_prefix."articlerate
WHERE articleid='$articleid' AND userid='$pauserinfo[userid]'");
} else {
$checkvote = $DB->fetch_one_array("SELECT * FROM ".$db_prefix."articlerate
WHERE articleid='$articleid'
AND ipaddress='".addslashes($ipaddress)."'");
}
查找:
$DB->query("INSERT INTO ".$db_prefix."articlerate (articleid,userid,vote,date,reason)
VALUES ('$articleid','$pauserinfo[userid]','$vote','".time()."','".addslashes(trim($_POST[reason]))."')");
替换为:
$DB->query("INSERT INTO ".$db_prefix."articlerate (articleid,userid,vote,date,reason,ipaddress)
VALUES ('$articleid','$pauserinfo[userid]','$vote','".time()."','".addslashes(trim($_POST[reason]))."','".addslashes($ipaddress)."')");
修改 article.php
查找:
unset($rate);
if ($pauserinfo[userid]!=0) {
替换为:
unset($rate);
if ($pauserinfo[userid]!=0 or $pauserinfo[canratearticle]) {
查找:
$checkvote = $DB->fetch_one_array("SELECT * FROM ".$db_prefix."articlerate
WHERE articleid='$articleid' AND userid='$pauserinfo[userid]'");
替换为:
$ipaddress = getip();
if ($pauserinfo[userid]!=0) {
$checkvote = $DB->fetch_one_array("SELECT * FROM ".$db_prefix."articlerate
WHERE articleid='$articleid' AND userid='$pauserinfo[userid]'");
} else {
$checkvote = $DB->fetch_one_array("SELECT * FROM ".$db_prefix."articlerate
WHERE articleid='$articleid'
AND ipaddress='".addslashes($ipaddress)."'");
}