⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 profilebottom.asp

📁 1 除掉了 时间 限制 2 除掉了 人数 限制 改为 500人 原为5人 3 发现一点小缺陷 增加人员的时候没有判断 登陆名是否重复! 自己写吧~~~:) 4 又 是一点缺陷
💻 ASP
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
Dim objcheck
Set objcheck=Server.CreateObject("SmartSales.CheckFunction")
objcheck.CheckUserFunction "profile","read"
set objcheck=nothing

dim conn
set conn=server.CreateObject("adodb.connection")
conn.Open connstring
if request("mod")="save" then
	if request("displayfile")="" then
		set rs=conn.execute("delete from userprofile where userid='"&Session("loginid")&"'")
	else
		set rs=conn.execute("insert into userprofile(userid,displayfile)values('"&session("loginid")&"',1)")
	end if
end if
set rs=conn.execute("select * from userprofile where userid='"&session("loginid")&"'")
if not rs.eof then
	strdisplayfile=1
else
	strdisplayfile=0
end if
%>
<html>
<head>
<LINK href="../global.css" rel=STYLESHEET type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>ProFileBottom</title>
</head>
<body leftmargin="10" rightmargin="0" topmargin="10" >
<form name=form2 action=profilebottom.asp?profilelistid=<%=request("profilelistid")%>>
 <%
set rsq=conn.Execute("select * from Profilelist where andid='"&request("profilelistid")&"' order by seq")
if rsq.eof then
	set rs=conn.Execute("select * from Profilelist where profilelistid="&request("profilelistid"))
	if not rs.eof then
	strsubname=rs("subname")
	strandid=rs("andid")
	if strandid<>"" and strandid<>0 then
		strAandid=getfieldvalue("ProfileList","ProfileListid",Cint(strandid),"andid")
		strAsubname=getfieldvalue("ProfileList","ProfileListid",Cint(strandid),"subname")
		strAsubname="<a href="&"Profilebottom.asp?ProfileListid="&strandid&">"&strAsubname&"</a>"&" > "
	end if
	if strAandid<>"" and strAandid<>0 then
		strBandid=getfieldvalue("ProfileList","ProfileListid",Cint(strAandid),"andid")
		strBsubname=getfieldvalue("ProfileList","ProfileListid",Cint(strAandid),"subname")
		strBsubname="<a href="&"Profilebottom.asp?ProfileListid="&strAandid&">"&strBsubname&"</a>"&" > "
	end if
	if strBandid<>"" and strBandid<>0 then
		strCandid=getfieldvalue("ProfileList","ProfileListid",Cint(strBandid),"andid")
		strCsubname=getfieldvalue("ProfileList","ProfileListid",Cint(strBandid),"subname")
		strCsubname="<a href="&"Profilebottom.asp?ProfileListid="&strBandid&">"&strCsubname&"</a>"&" > "
	end if
%>
  <table width="100%" border="0" cellpadding="0" cellspacing="0" height="100%">
    <tr> 
      <td align=left height=30 class="title" width=100%>
	    <table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td class="title" height="22">&nbsp;</td>
            <td><div align="right">
                <input type=hidden name=mod value=save>
                <input type=hidden name=profilelistid value=<%=request("profilelistid")%>>
                <input type=checkbox name=displayfile value=0 onclick="form2.submit();" <%if strdisplayfile=1 then response.Write "checked"%>>
                不弹出信息 </div></td>
          </tr>
		  <tr><td align=left height="22" colspan="2"><%=strCsubname%><%=strBsubname%><%=strAsubname%><%=strsubname%></td></tr>
		  <tr><td align=center height="1" bgcolor=#decfa8 colspan="2"></td></tr>
		  <tr><td align=center height="4" bgcolor=#FFFFFF colspan="2"></td></tr>
        </table></td>
    </tr>
    <tr> 
      <td width=100% align="left">
        <%
        if rs("FileText")<>"" then
			dim connimg
			dim rsimg
			set connimg=server.CreateObject("adodb.connection")
			connimg.Open connstring
			set rsimg=server.CreateObject("adodb.recordset")
			rsimg.Open "select * from images where imagetype='profile' and linkid="&request("profilelistid")&" order by id asc",connimg,1,1

			dim content
			dim i
			content=split(rs("FileText"),"images>")

			for i=0 to ubound(content)
			if right(content(i),2)="<l" then
				Response.Write "<font size=2 face='Verdana, Arial, Helvetica, sans-serif'>"&left(content(i),len(content(i))-2)&"</font>"
				if not rsimg.EOF then
					%>
					<img align=left src="showimg.asp?id=<%=rsimg("id")%>&producttype=images" style="margin-left:10;margin-top:10;margin-bottom:10">
					<%
					rsimg.Movenext
				end if
			elseif right(content(i),2)="<r" then
				Response.Write "<font size=2 face='Verdana, Arial, Helvetica, sans-serif'>"&left(content(i),len(content(i))-2)&"</font>"
				if not rsimg.EOF then
					%>
					<img align=right src="showimg.asp?id=<%=rsimg("id")%>&producttype=images" style="margin-left:10;margin-top:10;margin-bottom:10">
					<%
					rsimg.Movenext
				end if
			elseif right(content(i),2)="<c" then
				Response.Write "<font size=2 face='Verdana, Arial, Helvetica, sans-serif'>"&left(content(i),len(content(i))-2)&"</font>"
				if not rsimg.EOF then
					%>
					<img src="showimg.asp?id=<%=rsimg("id")%>&producttype=images" style="margin-left:10;margin-top:10;margin-bottom:10">
					<%
					rsimg.Movenext
				end if
			else
				Response.Write "<font size=2 face='Verdana, Arial, Helvetica, sans-serif'>"&content(i)&"</font>"
			end if
			next
			rsimg.Close 
			set rsimg=nothing
			connimg.Close 
			set connimg=nothing
        end if
        %><br> 

      </td>
    </tr>
	<tr><td valign="bottom" height="100%" colspan="2"></td></tr>
  </table>
  <%end if%>
<%
else
	strsubname=rsq("subname")
	strandid=request("profilelistid")
	if strandid<>"" and strandid<>0 then
		strAandid=getfieldvalue("ProfileList","ProfileListid",Cint(strandid),"andid")
		strAsubname=getfieldvalue("ProfileList","ProfileListid",Cint(strandid),"subname")
	'	strAsubname="<a href="&"Profilebottom.asp?ProfileListid="&strandid&">"&strAsubname&"</a>"
	end if
	if strAandid<>"" and strAandid<>0 then
		strBandid=getfieldvalue("ProfileList","ProfileListid",Cint(strAandid),"andid")
		strBsubname=getfieldvalue("ProfileList","ProfileListid",Cint(strAandid),"subname")
		strBsubname="<a href="&"Profilebottom.asp?ProfileListid="&strAandid&">"&strBsubname&"</a>"&" > "
	end if
	if strBandid<>"" and strBandid<>0 then
		strCandid=getfieldvalue("ProfileList","ProfileListid",Cint(strBandid),"andid")
		strCsubname=getfieldvalue("ProfileList","ProfileListid",Cint(strBandid),"subname")
		strCsubname="<a href="&"Profilebottom.asp?ProfileListid="&strBandid&">"&strCsubname&"</a>"&" > "
	end if

%>
  <table width="100%" border="0" cellpadding="0" cellspacing="0" height="100%">
    <tr> 
      <td align=left height=30 class="title" width=100% colspan="2">
	  	<table width="100%" border="0" cellspacing="0" cellpadding="0">
		  <tr><td align=center colspan="2" height="22"><div align="right">
                <input type=hidden name=mod value=save>
                <input type=hidden name=profilelistid value=<%=request("profilelistid")%>>
                <input type=checkbox name=displayfile value=0 onclick="form2.submit();" <%if strdisplayfile=1 then response.Write "checked"%>>
                不弹出信息 </div></td></tr>
		  <tr><td align=left height="22" colspan="2"><%=strCsubname%><%=strBsubname%><%=strAsubname%></td></tr>
		  <tr><td align=center height="1" bgcolor=#decfa8 colspan="2"></td></tr>
		  <tr><td align=center height="4" bgcolor=#FFFFFF colspan="2"></td></tr>
        </table>
	  </td>
    </tr>
<%
do while not rsq.eof
set strProFileListId=rsq("ProFileListId")
set strsubname=rsq("subname")
set strfiletext=rsq("filetext")
%>
    <tr> 
      <td width=100% align="left" height="20" colspan="2">&nbsp;
	  <%if strfiletext<>"" then%>
	  <img src="ProFileListImg/book.gif">
	  <%else%>
	  <img src="ProFileListImg/dir.gif">
	  <%end if%>
	  <font size=2>&nbsp;<a href="ProFileBottom.asp?ProFileListId=<%=strProFileListId%>"><%=strsubname%></a></font></td>
    </tr>
<%
rsq.movenext
Loop
%>
	<tr><td valign="bottom" height="100%" colspan="2"></td></tr>
  </table>
<%
end if
  'rs.Close
  set rs=nothing
  conn.Close 
  set conn=nothing
%>
</form>
</body>
</html>

⌨️ 快捷键说明

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