%
'On Error Resume Next
'======================================================================================
'留言板程序
'官方网站:http://www.520soso.com
'======================================================================================
sub getshow(str,url)
if str="" and url <>"" then
response.Write ""
response.End()
end if
if str<>"" and url="" then
response.Write ""
response.End()
end if
if str<>"" and url<>"" then
response.Write ""
response.End()
end if
end sub
Function funstrs(Str)
If Isnull(Str) Then
funstrs = ""
Exit Function
End If
'str = ucase(str)
Str = Replace(Str,Chr(0),"", 1, -1, 1)
Str = Replace(Str, """", """, 1, -1, 1)
Str = Replace(Str,"<","<", 1, -1, 1)
Str = Replace(Str,">",">", 1, -1, 1)
Str = Replace(Str, "script", "script", 1, -1, 0)
Str = Replace(Str, "SCRIPT", "SCRIPT", 1, -1, 0)
Str = Replace(Str, "Script", "Script", 1, -1, 0)
Str = Replace(Str, "script", "Script", 1, -1, 1)
Str = Replace(Str, "object", "object", 1, -1, 0)
Str = Replace(Str, "OBJECT", "OBJECT", 1, -1, 0)
Str = Replace(Str, "Object", "Object", 1, -1, 0)
Str = Replace(Str, "object", "Object", 1, -1, 1)
Str = Replace(Str, "applet", "applet", 1, -1, 0)
Str = Replace(Str, "APPLET", "APPLET", 1, -1, 0)
Str = Replace(Str, "Applet", "Applet", 1, -1, 0)
Str = Replace(Str, "applet", "Applet", 1, -1, 1)
Str = Replace(Str, "[", "[")
Str = Replace(Str, "]", "]")
Str = Replace(Str, """", "", 1, -1, 1)
Str = Replace(Str, "=", "=", 1, -1, 1)
Str = Replace(Str, "'", "''", 1, -1, 1)
Str = Replace(Str, "select", "select", 1, -1, 1)
Str = Replace(Str, "execute", "execute", 1, -1, 1)
Str = Replace(Str, "exec", "exec", 1, -1, 1)
Str = Replace(Str, "join", "join", 1, -1, 1)
Str = Replace(Str, "union", "union", 1, -1, 1)
Str = Replace(Str, "where", "where", 1, -1, 1)
Str = Replace(Str, "insert", "insert", 1, -1, 1)
Str = Replace(Str, "delete", "delete", 1, -1, 1)
Str = Replace(Str, "update", "update", 1, -1, 1)
Str = Replace(Str, "like", "like", 1, -1, 1)
Str = Replace(Str, "drop", "drop", 1, -1, 1)
Str = Replace(Str, "create", "create", 1, -1, 1)
Str = Replace(Str, "rename", "rename", 1, -1, 1)
Str = Replace(Str, "count", "count", 1, -1, 1)
Str = Replace(Str, "chr", "chr", 1, -1, 1)
Str = Replace(Str, "mid", "mid", 1, -1, 1)
Str = Replace(Str, "truncate", "truncate", 1, -1, 1)
Str = Replace(Str, "nchar", "nchar", 1, -1, 1)
Str = Replace(Str, "char", "char", 1, -1, 1)
Str = Replace(Str, "alter", "alter", 1, -1, 1)
Str = Replace(Str, "cast", "cast", 1, -1, 1)
Str = Replace(Str, "exists", "exists", 1, -1, 1)
Str = Replace(Str,Chr(13),"
", 1, -1, 1)
funstrs = Replace(Str,"'","''", 1, -1, 1)
End Function
Function funstr(str)
str = trim(str)
str = replace(str, "<", "<", 1, -1, 1)
str = replace(str, ">", ">", 1, -1, 1)
str = replace(str,"'","'")
funstr = str
End Function
'============
'执行一条SQL语句 rs函数
'============
function rsfunm(sqlm,i)
select case i
case "1"
set rsm=server.CreateObject("adodb.recordset")
rsm.open sqlm,conn,1,1
set rsfunm=rsm
set rsm=nothing
case "3"
set rsm=server.CreateObject("adodb.recordset")
rsm.open sqlm,conn,1,3
set rsfunm=rsm
set rsm=nothing
end select
end function
'============
'关闭数据库
'============
'==================================================
'读取文件内容
'==================================================
function openfile(url)
fileurl=server.MapPath(url)
set fso=server.CreateObject("scripting.filesystemobject") '定义FSO
set mofile=fso.opentextfile(fileurl,1) '以读的方式打开文件
mo_top=mofile.readall() '读取全部内容
mofile.close
openfile=mo_top
end function
%>