admin_link.asp

网络上经典的图片程序

		totalnumber = CInt(Rs.recordcount) '###记录总数
		Rs.absolutepage = CurrentPage '###当前页数
		ii = 0
		Rem #######显示多少页##########
		pagestart = CurrentPage - 3
		pageend = CurrentPage + 3
		Rem ##########################
		n = CurrentPage
		If pagestart < 1 Then
			pagestart = 1
		End If
		If pageend > maxpagecount Then
			pageend = maxpagecount
		End If
		If n < maxpagecount Then
			n = maxpagecount
		End If
		j = (CurrentPage - 1) * maxperpage + 1
		Do While Not Rs.EOF And ii < Rs.pagesize
			Response.Write " <tr align=center>"
			Response.Write " <td height=25 class=TableRow1><input type=""checkbox"" name=""id"" value="""
			Response.Write Rs("linkid")
			Response.Write """></td>"
			Response.Write " <td class=TableRow1><a href="
			Response.Write Rs("Linkurl")
			Response.Write " target=_blank>"
			Response.Write Rs("Linkname")
			Response.Write "</a></td>"
			Response.Write " <td class=TableRow1>"
			If Rs("islogo") = 1 Then
				Response.Write "LOGO链接"
			Else
				Response.Write "文字链接"
			End If
			Response.Write "</td>"
			Response.Write " <td class=TableRow1> <a href=""admin_link.asp?action=edit&id="
			Response.Write Rs("Linkid")
			Response.Write """><u>编辑</u></a> | <a href=""admin_link.asp?action=lock&id="
			Response.Write Rs("linkid")
			Response.Write """><u>锁定</u></a> | <a href=""admin_link.asp?action=free&id="
			Response.Write Rs("linkid")
			Response.Write """><u>解锁</u></a> | <a href=""admin_link.asp?action=del&id="
			Response.Write Rs("linkid")
			Response.Write """ onclick=""{if(confirm('此操作将删除本友情连接\n 您确定执行此操作吗?')){this.document.myform.submit();return true;}return false;}""><u>删除</u></a></td>"
			Response.Write " <td class=TableRow1>"
			If Rs("isLock") = 0 Then
				Response.Write "正常"
			Else
				Response.Write "<font color=red>锁定</font>"
			End If
			Response.Write "</td>"
			Response.Write " <td class=TableRow1>"
			If Rs("isIndex") = 0 Then
				Response.Write "<font color=red>×</font>"
			Else
				Response.Write "<font color=blue>√</font>"
			End If
			Response.Write "</td>"
			Response.Write " </tr>"
			Rs.movenext
			j = j + 1
			ii = ii + 1
		Loop
		Rs.Close
		Set Rs = Nothing
	Else
		Response.Write ("<tr><td colspan=5 class=TableRow2>暂时还没有任何友情连接</td></tr>")
	End If
	Response.Write "<tr><td colspan=""6"" class=""TableRow1"">"
	Response.Write "<input class=""Button"" type=""button"" name=""chkall"" value=""全选"" onClick=""CheckAll(this.form)""><input class=""Button"" type=""button"" name=""chksel"" value=""反选"" onClick=""ContraSel(this.form)""> "& vbNewLine
	Response.Write "<input class=""Button"" type=""submit"" name=""Submit2"" value=""删除"" onclick=""return confirm('您确定要删除选定的友情站点吗?');"">"
	Response.Write "</td></tr></form>"
	Response.Write "<tr><td colspan=""6"" class=""TableRow2"">"
	Call showpage
	Response.Write "</td></tr>"
	Response.Write "</table>"
End Sub

Private Sub savenew()
	Dim sUploadDir,strUploadDir,SaveFileType,SaveFilesName
	Dim password,strLogo
	password = md5(Request("password"))
	strLogo = Trim(Request.Form("logo"))
	If Trim(Request("url")) <> "" And Trim(Request("readme")) <> "" And Trim(Request("name")) <> "" Then
		If Trim(Request("AutoLoad")) = "yes" Then
			sUploadDir = "../link/UploadPic/"
			strUploadDir = CreatePath(sUploadDir)
			SaveFileType = Mid(strLogo, InStrRev(strLogo, ".") + 1)
			SaveFilesName = GetRndFileName(SaveFileType)
			If SaveRemotePic(sUploadDir & strUploadDir & SaveFilesName, strLogo) = True Then
				strLogo = "link/UploadPic/" & strUploadDir & SaveFilesName
			Else
				strLogo = strLogo
			End If
		End If
		Set Rs = CreateObject("adodb.recordset")
		SQL = "select * from [NC_Link] where (Linkid is null)"
		Rs.Open SQL, Conn, 1, 3
		Rs.addnew
			Rs("Linkname").Value =  Newasp.CheckStr(Request.Form("name"))
			Rs("readme").Value = Newasp.CheckStr(Request.Form("readme"))
			Rs("logourl").Value = strLogo
			Rs("Linkurl").Value = Request.Form("url")
			Rs("password").Value = password
			Rs("islogo").Value = Request.Form("islogo")
			Rs("isLock").Value = 0
			Rs("isIndex").Value = Request.Form("isIndex")
			Rs.Update
		Rs.Close
		Set Rs = Nothing
		Succeed("添加成功，请继续其他操作。")
	Else
		ErrMsg = ErrMsg + "<br>" + "请输入完整友情链接信息。"
		Founderr = True
		Exit Sub
	End If
End Sub

Private Sub savedit()
	Dim sUploadDir,strUploadDir,SaveFileType,SaveFilesName
	Dim strLogo
	strLogo = Trim(Request.Form("logo"))
	If Trim(Request("AutoLoad")) = "yes" Then
		sUploadDir = "../link/UploadPic/"
		strUploadDir = CreatePath(sUploadDir)
		SaveFileType = Mid(strLogo, InStrRev(strLogo, ".") + 1)
		SaveFilesName = GetRndFileName(SaveFileType)
		If SaveRemotePic(sUploadDir & strUploadDir & SaveFilesName, strLogo) = True Then
			strLogo = "link/UploadPic/" & strUploadDir & SaveFilesName
		Else
			strLogo = strLogo
		End If
	End If
	Set Rs = CreateObject("adodb.recordset")
	SQL = "select * from [NC_Link] where Linkid=" & Request("id")
	Rs.Open SQL, Conn, 1, 3
		If CLng(Request("id")) > 1 Then
			Rs("Linkname").Value = Trim(Request.Form("name"))
			Rs("readme").Value = Trim(Request.Form("readme"))
			Rs("Linkurl").Value = Trim(Request.Form("url"))
		End If
		Rs("logourl").Value = strLogo
		If Trim(Request("password")) <> "" Then Rs("password").Value = Request.Form("password")
		Rs("islogo").Value = Request.Form("islogo")
		Rs("isIndex").Value = Request.Form("isIndex")
		Succeed ("更新成功，请继续其他操作。")
		Rs.Update
	Rs.Close
	Set Rs = Nothing
End Sub
Private Sub del()
	If Len(Request("id")) > 0 Then
		SQL = "DELETE FROM [NC_link] WHERE Linkid>1 And Linkid in (" & Request("id") & ")"
		Conn.Execute (SQL)
	End If
	Succeed ("删除成功，请继续其他操作。")
End Sub
Private Sub locklink()
	Dim id
	id = CLng(Request("id"))
	Conn.Execute ("UPDATE [NC_link] SET islock=1 WHERE Linkid=" & id)
	Succeed ("锁定操作成功，请继续其他操作。")
End Sub
Private Sub freelink()
	Dim id
	id = CLng(Request("id"))
	Conn.Execute ("UPDATE [NC_link] SET islock=0 WHERE Linkid=" & id)
	Succeed ("解除锁定操作成功，请继续其他操作。")
End Sub
Private Function SaveRemotePic(s_LocalFileName, s_RemoteFileUrl)
	Dim Ads
	Dim Retrieval
	Dim GetRemoteData
	Dim bError
	bError = False
	SaveRemotePic = False
	On Error Resume Next
	Set Retrieval = CreateObject("Microsoft.XMLHTTP")
	With Retrieval
		.Open "Get", s_RemoteFileUrl, False
		.Send
		If .readyState <> 4 Then Exit Function
		If .Status > 300 Then Exit Function
		GetRemoteData = .ResponseBody
	End With
	Set Retrieval = Nothing
	
	Set Ads = CreateObject("Adodb.Stream")
	With Ads
		.type = 1
		.Open
		.Write GetRemoteData
		.SaveToFile Server.MapPath(s_LocalFileName), 2
		.Cancel
		.Close
	End With
	Set Ads = Nothing
	If Err.Number = 0 And bError = False Then
		SaveRemotePic = True
	Else
		Err.Clear
	End If
End Function
Private Function GetRndFileName(ByVal sExt)
	Dim sRnd
	Randomize
	sRnd = Int(900 * Rnd) + 100
	GetRndFileName = Year(Now) & Month(Now) & Day(Now) & Hour(Now) & Minute(Now) & Second(Now) & sRnd & "." & sExt
End Function
Private Sub showpage()
	Response.Write "<table width=""96%"" border=""0"" align=""center"" cellpadding=""0"" cellspacing=""2"">"
	Response.Write " <tr><form method=""POST"" action="""
	Response.Write PageName
	Response.Write """ >"
	Response.Write " <td class=""td1"" align=""center"">共有"
	Response.Write totalnumber
	Response.Write "个 <a href="
	Response.Write PageName
	Response.Write "?page=1 title=返回第一页><font face=""Webdings"">97</font></a> "
	For i = pagestart To pageend
		If i = 0 Then
			i = 1
		End If
		strurl = "<a href=" & PageName & "?page=" & i & " title=第" & i & "页>[" & i & "]</a>"
		Response.Write strurl
		Response.Write " "
	Next
	Response.Write "<a href="
	Response.Write PageName
	Response.Write "?page="
	Response.Write maxpagecount
	Response.Write " title=尾页><font face=""Webdings"">8:</font></a> 页次:<font color=red>"
	Response.Write CurrentPage
	Response.Write "</font> / "
	Response.Write maxpagecount
	Response.Write "页 每页:"
	Response.Write maxperpage
	Response.Write " 转到:<select name='page' align=""absmiddle"" size='1' style=""font-size: 9pt"" onChange='javascript:submit()'>"
	Response.Write " "
	For i = 1 To n
		Response.Write " <option value='"
		Response.Write i
		Response.Write "' "
		If CurrentPage = CInt(i) Then
			Response.Write " selected "
		End If
		Response.Write ">第"
		Response.Write i
		Response.Write "页</option>"
		Response.Write " "
	Next
	Response.Write " </select>"
	Response.Write " </td></form>"
	Response.Write " </tr>"
	Response.Write " </table>"
End Sub
Public Function RndPassWord()
	Dim num1,rndnum
	Randomize
	Do While Len(rndnum) < 8
		num1 = CStr(Chr((57 - 48) * rnd + 48))
		rndnum = rndnum & num1
	loop
	RndPassWord = rndnum
End Function
%>