m_count.asp

来自「是个不错的文件代码,希望大家好好用,」· ASP 代码 · 共 98 行

ASP
98
字号
<!--#include file="inc/inc_sys.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>oBlog--更新系统数据</title>
<link rel="stylesheet" href="images/style.css" type="text/css" />
<script src="images/menu.js" type="text/javascript"></script>
</head>
<body>
<form name="form1" method="post" action="">
<div id="main_body">
	<ul class="main_top">
		<li class="main_top_left left">更新系统数据</li>
		<li class="main_top_right right"> </li>
	</ul>
	<div class="main_content_rightbg">
		<div class="main_content_leftbg">
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF" class="border">
  <tr class="tdbg">
    <td colspan="2">
<%
dim rs,sql,trs
action=request("action")
if action="DoUpdate" then
	Set rs=Server.CreateObject("Adodb.RecordSet")
	sql="select * from oblog_setup"
	rs.Open sql,Conn,1,3
	set trs=oblog.execute("select count(logID) from [oblog_log]")
	if isNull(trs(0)) then
		rs("log_count")=0
	else
		rs("log_count")=trs(0)
	end if
	set trs=oblog.execute("select count(commentID) from oblog_comment")
	if isNull(trs(0)) then
		rs("comment_count")=0
	else
		rs("comment_count")=trs(0)
	end if
	set trs=oblog.execute("select count(messageID) from oblog_message")
	if isNull(trs(0)) then
		rs("message_count")=0
	else
		rs("message_count")=trs(0)
	end if
	set trs=oblog.execute("select count(userID) from [oblog_user]")
	if isNull(trs(0)) then
		rs("user_count")=0
	else
		rs("user_count")=trs(0)
	end if
	rs.update
	rs.close
	set rs=nothing
	set trs=nothing
	oblog.reloadsetup()
	Application.Lock
	Application(oblog.cache_name&"index_update")=true
	application(oblog.cache_name&"list_update")=true
	application(oblog.cache_name&"class_update")=true
	Application.unLock
	response.Write("<script src="""&blogdir&"index.asp?re=0""></script>")
	response.Write("已经成功将系统数据进行了更新!")
	response.Write("<br /><a href=""javascript:history.back(-1)"">返回上一页</a>")
	response.Write("</td>")
	response.Write("  </tr>")
	response.Write("</table>")
	response.Write("   </form>")
	response.Write("		</div>")
	response.Write("	</div>")
	response.Write("	<ul class=""main_end"">")
	response.Write("		<li class=""main_end_left left""></li>")
	response.Write("		<li class=""main_end_right right""></li>")
	response.Write("	</ul>")
	response.Write("</div>")
	else
	%>
	<p>说明:<br>
        1、本操作将重新计算系统的日志,评论,留言数及更新缓存和首页。<br>
        2、本操作可能消耗服务器资源,请仔细确认每一步操作后执行。</p></td>
  </tr>
  <tr class="tdbg">
    <td height="25" colspan="2"><input name="Submit" type="submit" id="Submit" value="更新系统数据">
    <input name="Action" type="hidden" id="Action" value="DoUpdate"></td>
  </tr>
</table>
   </form>
		</div>
	</div>
	<ul class="main_end">
		<li class="main_end_left left"></li>
		<li class="main_end_right right"></li>
	</ul>
</div>
<%
end if
%>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?