📄 admin_update.asp
字号:
<!--#include file="Inc/Level012.asp" -->
<!--#include file="Connections/connY.asp" -->
<!--#include file="Inc/TimeFormat.asp" -->
<!--#include file="Inc/UBBCode.asp" -->
<!--#include file="Inc/Md5.asp" -->
<!--#include file="Inc/SetCss.asp" -->
<html>
<head>
<title><%=Forum_Title%></title>
<meta http-equiv="Content-Type" content="text/html;">
<meta http-equiv="Expires" CONTENT="0">
<meta http-equiv="Cache-Control" CONTENT="no-cache">
<meta http-equiv="Pragma" CONTENT="no-cache">
<!--#include file="Inc/Css.asp" -->
<script language=Javascript src="Js/Menu.Js"></script>
<script language=Javascript src="Js/Button.Js"></script>
<script language=Javascript src="Js/Operate.Js"></script>
</head>
<body leftmargin="0" topmargin="0" bgcolor="<%=Forum_ColorList_BgColor%>" vlink="<%=Forum_Css_A_Link_Color%>" onLoad="MM_preloadImages('<%=Forum_Pic_Write2%>','<%=Forum_Pic_Vote2%>')">
<!--#include file="Inc/Top.asp" -->
<table width="<%=Forum_Width%>" border="0" cellspacing="1" cellpadding="0" align="center" bgcolor="<%=Forum_ColorList_BorderColor%>">
<tr>
<td height="20" bgcolor="<%=Forum_ColorList_BgColor%>">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="font">
<tr>
<td> 您所在的位置： <a href="../" onfocus="this.blur()">首页</a> >>
<a href="List.asp" onFocus="this.blur()">讨论组</a> >> <font color="<%=Forum_ColorList_NavFontColor%>">论坛管理系统</font></td>
<td width="18">
<div align="center"></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="<%=Forum_Width%>" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height=1></td>
</tr>
</table>
<table width="<%=Forum_Width%>" border="0" cellspacing="1" cellpadding="2" align="center" bgcolor="<%=Forum_ColorList_BorderColor%>" class="font">
<tr>
<td valign="top" width="102" bgcolor="<%=Forum_ColorList_BgColor%>">
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<!--#include file="Inc/Menu.asp" -->
</td>
</tr>
</table>
</td>
<td bgcolor="<%=Forum_ColorList_BgColor%>" valign="top"> <br>
<table width="80%" border="0" cellspacing="1" cellpadding="2" align="center" class="font" bgcolor="<%=Forum_ColorList_BorderColor%>">
<tr>
<td bgcolor="<%=Forum_ColorList_TitleColor%>" height="20"> 用户更新数据</td>
</tr>
<tr>
<td bgcolor="<%=Forum_ColorList_BgColor%>" valign="top"> 1.执行下列操作比较消耗服务器资源,如果数据量非常大的情况下将消耗更多的资源和时间,尽量减少使用次数.<br>
-------------------------------------------------------------------------------<br>
<%
If Request("Action")="Go" Then
Set rsU = Server.CreateObject("ADODB.Recordset")
Sql = "Select * From tUserManage"
rsU.Open Sql,ConnY,3,3
While Not rsU.Eof
Set rsA = Server.CreateObject("ADODB.Recordset")
Sql = "Select * From tArticleManage Where rRepID=0 And rPoster='"&rsU("rUserID")&"'"
rsA.Open Sql,ConnY,3,3
TotalWrite=rsA.RecordCount
rsA.Close
Sql = "Select * From tArticleManage Where rRepID<>0 And rPoster='"&rsU("rUserID")&"'"
rsA.Open Sql,ConnY,3,3
TotalReply=rsA.RecordCount
rsA.Close
Sql = "Select * From tArticleManage Where rIsQuintessence And rPoster='"&rsU("rUserID")&"'"
rsA.Open Sql,ConnY,3,3
TotalSoul=rsA.RecordCount
rsA.Close
Set rsA=Nothing
rsU("rPostNum")=TotalWrite
rsU("rReplyNum")=TotalReply
rsU("rIsQuintessence")=TotalSoul
rsU.Update
rsU.MoveNext
Wend
rsU.Close
Set rsU=Nothing
Response.Write " 更新用户数据成功"
End If
If Request("Action")="" Then
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="font">
<form name="form1" method="post" action="Admin_Update.asp?Action=Go"><tr>
<td>
<input type="submit" name="Submit" value="重新计算用户发,回,收录贴数量" class="button">
<br>
<br>
执行本操作将按照论坛发贴重新计算所有用户发表帖子数量,回帖数量,收录精华区数量.</td>
</tr></form>
</table>
<%
End If
%>
</td>
</tr>
</table>
<br>
</td>
</tr>
</table>
<!--#include file="Inc/Bottom.asp" -->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -