story_feedback_main.php
2.65 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
<?php
require_once(dirname(__FILE__). "/config.php");
//权限检查
CheckPurview('sys_Feedback');
require_once(DEDEINC. "/datalistcp.class.php");
require_once(DEDEINC. "/typelink.class.php");
setcookie("ENV_GOBACK_URL", $dedeNowurl, time()+3600,"/");
function IsCheck($st){ return $st==1? "[已审核]" : "<font color='red'>[未审核]</font>";}
if(!empty($job))
{
$ids = preg_replace("#[^0-9,]#", '', $fid);
if(empty($ids))
{
ShowMsg("你没选中任何选项！", $_COOKIE['ENV_GOBACK_URL'], 0, 500);
exit;
}
}
else
{
$job = '';
}
//删除评论
if( $job == 'del' )
{
$query = "DELETE From `#@__bookfeedback` WHERE id in($ids) ";
$dsql->ExecuteNoneQuery($query);
ShowMsg("成功删除指定的评论!",$_COOKIE['ENV_GOBACK_URL'],0,500);
exit();
}
//删除相同IP的所有评论
else if( $job == 'delall' )
{
$dsql->SetQuery("SELECT ip FROM `#@__bookfeedback` WHERE id in ($ids) ");
$dsql->Execute();
$ips = '';
while($row = $dsql->GetArray())
{
$ips .= ($ips=='' ? " ip = '{$row['ip']}' " : " OR ip = '{$row['ip']}' ");
}
if($ips!='')
{
$query = "DELETE FROM `#@__bookfeedback` WHERE $ips ";
$dsql->ExecuteNoneQuery($query);
}
ShowMsg("成功删除指定相同IP的所有评论!", $_COOKIE['ENV_GOBACK_URL'], 0, 500);
exit();
}
//审核评论
else if($job=='check')
{
$query = "UPDATE `#@__bookfeedback` SET ischeck=1 WHERE id in($ids) ";
$dsql->ExecuteNoneQuery($query);
ShowMsg("成功审核指定评论!", $_COOKIE['ENV_GOBACK_URL'], 0, 500);
exit();
}
//浏览评论
else
{
$bgcolor = '';
$typeid = isset($typeid) && is_numeric($typeid) ? $typeid : 0;
$aid = isset($aid) && is_numeric($aid) ? $aid : 0;
$keyword = !isset($keyword) ? '' : $keyword;
$ip = !isset($ip) ? '' : $ip;
$tl = new TypeLink($typeid);
$openarray = $tl->GetOptionArray($typeid,$admin_catalogs,0);
$addsql = ($typeid != 0 ? " And typeid in (".GetSonIds($typeid).")" : '');
$addsql .= ($aid != 0 ? " And aid=$aid " : '');
$addsql .= ($ip != '' ? " And ip like '$ip' " : '');
$querystring = "SELECT * FROM `#@__bookfeedback` WHERE msg like '%$keyword%' $addsql ORDER BY dtime DESC";
$dlist = new DataListCP();
$dlist->pageSize = 15;
$dlist->SetParameter('aid', $aid);
$dlist->SetParameter('ip', $ip);
$dlist->SetParameter('typeid', $typeid);
$dlist->SetParameter('keyword', $keyword);
$dlist->SetTemplate(DEDEADMIN. '/templets/story_feedback_main.htm');
$dlist->SetSource($querystring);
$dlist->Display();
}