运行这个文件,没有测试hoho
<input type="text" name="UserID" style="border:none">
<SCRIPT LANGUAGE="JavaScript">
function validateuserid()
{
document.body.style.cursor='wait';
if (window.XMLHttpRequest)
oXMLHTTP = new XMLHttpRequest();
else if (window.ActiveXObject)
oXMLHTTP = new ActiveXObject("Msxml2.XMLHTTP");
var sURL = "http://localhost/file.asp"
oXMLHTTP.open("GET", sURL, false);
oXMLHTTP.send();
file.asp
<%
if session("cjl_username")<>"" then response.Redirect("main.asp")
//验证用户//////////////////////
if request.form("username")<>"" and request.form("password")<>"" then
username=request.form("username")
password=request.form("password")
set rs=server.createobject("adodb.recordset")
sql="select * from user where username='"&username&"' and password='"&password&"'"
rs.open sql,conn,1,1
if not rs.eof then'存在用户
////////////////////////////////
//查询积分//////////////////////
uid=rs("ID")
set rs1=server.createobject("adodb.recordset")
sql="select * from jifen where userID="&uid
rs1.open sql,conn,1,1
vdate=now-rs1("changedate") '计算未加时间
jf=rs1("jf")+rs("jfadd")*vdate*24 '最终数据
jf=CLng(jf)
'response.write(rs1("jf")&"+"&rs("jfadd")&"*"&vdate&"<br/>")
'response.write(jf)
'response.end
'rs1.close
////////////////////////////////
//更新积分//////////////////////
sql="update jifen set jf="&jf&" where userID="&uid
sql="update jifen set changedate='"&now&"' where userID="&uid
conn.execute(sql)
////////////////////////////////
<%
if session("userID")="" then response.Redirect("index.asp")
userID=session("userID")
set rs1=server.createobject("adodb.recordset")
sql="select * from jifen where userID="&userID
rs1.open sql,conn,1,1
jf=rs1("jf")
set rs=server.createobject("adodb.recordset")
sql="select * from user where ID="&userID
rs.open sql,conn,1,1
//更新数据库积分////////////////
sql="update jifen set jf="&jfing&" where userID="&userID
conn.execute(sql)
sql="update jifen set changedate='"&now&"' where userID="&userID
conn.execute(sql)
////////////////////////////////
%>
<script>
var sec
sec=0
sec+=<%=jfing%>
function tick() {
sec+=<%=willadd%>
Clock.innerHTML = sec;
window.setTimeout("tick();", 1000);//60000每分钟调整一次,1000每秒调整一次
}
window.onload = tick;