feedbackfun.php
2.69 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
88
89
90
91
92
93
94
95
96
97
98
99
100
<?php
//提交反饋
function AddMemberFeedback($add){
global $empire,$dbtbpre;
//驗證碼
$keyvname='checkspacefbkey';
ecmsCheckShowKey($keyvname,$add['key'],1);
//用戶
$userid=intval($add['userid']);
$ur=$empire->fetch1("select ".egetmf('userid')." from ".eReturnMemberTable()." where ".egetmf('userid')."='$userid' limit 1");
if(empty($ur['userid']))
{
printerror("NotUsername","",1);
}
//發表者
$uid=(int)getcvar('mluserid');
if($uid)
{
$uname=RepPostVar(getcvar('mlusername'));
}
else
{
$uid=0;
$uname='';
}
$uname=RepPostStr($uname);
$name=RepPostStr($add['name']);
$company=RepPostStr($add['company']);
$phone=RepPostStr($add['phone']);
$fax=RepPostStr($add['fax']);
$email=RepPostStr($add['email']);
$address=RepPostStr($add['address']);
$zip=RepPostStr($add['zip']);
$title=RepPostStr($add['title']);
$ftext=RepPostStr($add['ftext']);
if(!trim($name)||!trim($title)||!trim($ftext))
{
printerror("EmptyMemberFeedback","history.go(-1)",1);
}
$addtime=date("Y-m-d H:i:s");
$ip=egetip();
$eipport=egetipport();
$sql=$empire->query("insert into {$dbtbpre}enewsmemberfeedback(name,company,phone,fax,email,address,zip,title,ftext,userid,ip,uid,uname,addtime,eipport) values('$name','$company','$phone','$fax','$email','$address','$zip','$title','$ftext',$userid,'$ip',$uid,'$uname','$addtime','$eipport');");
ecmsEmptyShowKey($keyvname);//清空驗證碼
if($sql)
{
printerror("AddMemberFeedbackSuccess",$_SERVER['HTTP_REFERER'],1);
}
else
{
printerror("DbError","history.go(-1)",1);
}
}
//刪除反饋
function DelMemberFeedback($add){
global $empire,$dbtbpre;
$user_r=islogin();//是否登陸
$fid=intval($add['fid']);
if(!$fid)
{
printerror("NotDelMemberFeedbackid","history.go(-1)",1);
}
$sql=$empire->query("delete from {$dbtbpre}enewsmemberfeedback where fid='$fid' and userid='$user_r[userid]'");
if($sql)
{
printerror("DelMemberFeedbackSuccess",$_SERVER['HTTP_REFERER'],1);
}
else
{
printerror("DbError","history.go(-1)",1);
}
}
//批量刪除反饋
function DelMemberFeedback_All($add){
global $empire,$dbtbpre;
$user_r=islogin();//是否登陸
$fid=$add['fid'];
$count=count($fid);
if(empty($count))
{
printerror("NotDelMemberFeedbackid","history.go(-1)",1);
}
for($i=0;$i<$count;$i++)
{
$addsql.="fid='".intval($fid[$i])."' or ";
}
$addsql=substr($addsql,0,strlen($addsql)-4);
$sql=$empire->query("delete from {$dbtbpre}enewsmemberfeedback where (".$addsql.") and userid='$user_r[userid]'");
if($sql)
{
printerror("DelMemberFeedbackSuccess",$_SERVER['HTTP_REFERER'],1);
}
else
{
printerror("DbError","history.go(-1)",1);
}
}
?>