28,391
社区成员
发帖
与我相关
我的任务
分享
<%
set rs = createobject("adodb.recordset")
sql = "select * FROM Jkjs_news where ip='"& isnull=("userip") &"' and news_id="&news_id
rs.cursorLocation = 3
rs.open sql,conn,1,3
if not rs.eof and rs.bof then
else
if dateDiff("d",rs("data"),date) <>0 Then
rs("data")=date
rs("news_count") = rs("news_count").value + 1
end if
end if
rs("ip") = userip
rs("url") = url
rs("data") = date()
rs.update
if rs.state <> 0 then rs.close
set rs = nothing
%>
<%
userip = Request.ServerVariables("HTTP_X_FORWARDED_FOR") '捕获代理IP
If userip = "" Then userip = Request.ServerVariables("REMOTE_ADDR")
dim userip,redate,news_id
set rs = createobject("adodb.recordset")
sql = "select * from renew where ip='"& userip &"' and news_id="&news_id
rs.cursorLocation = 3
rs.open sql,conn,1,3
if rs.eof and rs.bof then
rs.addnew
rs("ip") = userip
rs("redate")=date
rs("news_id") = news_id
conn.execute("update Jkjs_news set news_count=news_count+1 where news_id="&news_id)
elseif dateDiff("d",rs("redate"),date) <>0 Then
rs("redate")=date
conn.execute("update Jkjs_news set news_count=news_count+1 where news_id="&news_id)
end if
rs.update
if rs.state <> 0 then rs.close
set rs = nothing
%>
<%
set rs = createobject("adodb.recordset")
sql = "select * FROM renew where (ip='"&userip&"' or dateDiff('d',redate,date()) <>0 ) and news_id="&news_id
rs.cursorLocation = 3
rs.open sql,conn,1,3
if not rs.eof and rs.bof then
else
rs.addnew
rs("news_id")=news_id
rs("ip") = userip
rs("redate") = date()
rs.update
conn.execute("update Jkjs_news set news_count=news_count+1 where news_id="&news_id)
end if
if rs.state <> 0 then rs.close
set rs = nothing
%>
<%
set rs = createobject("adodb.recordset")
sql = "select * FROM renew where ip='"&userip&"' and news_id="&news_id
rs.cursorLocation = 3
rs.open sql,conn,1,3
if not rs.eof and rs.bof then
else
rs.addnew
rs("news_id")=news_id
rs("ip") = userip
rs("redate") = date()
rs.update
conn.execute("update Jkjs_news set news_count=news_count+1 where news_id="&news_id)
end if
if rs.state <> 0 then rs.close
set rs = nothing
%>
sql = "select * FROM Jkjs_news where (ip='"&userip&"' or dateDiff('d',data,date) <>0 )and news_id="&news_id
sql = "select * FROM Jkjs_news where (ip='"&userip&"' or dateDiff('d',data,date)) <>0 and news_id="&news_id
<%
set rs = createobject("adodb.recordset")
sql = "select * FROM Jkjs_news where news_id="&news_id
rs.cursorLocation = 3
rs.open sql,conn,1,3
if not rs.eof and rs.bof then
else
if dateDiff("d",rs("data"),date) <>0 Then
rs("ip") = userip
rs("data")=date
rs("news_count") = rs("news_count").value + 1
elseif rs("ip")=userip then
else
rs("ip") = userip
rs("data")=date
rs("news_count") = rs("news_count").value + 1
end if
end if
rs.update
if rs.state <> 0 then rs.close
set rs = nothing
%>
sql = "select * FROM Jkjs_news where ip='"&userip&"' and dateDiff('d',data,date) <>0 and news_id="&news_id