 |
|
 |
<%if session("which")="" then%>
<%else%>
<%=session("who1")%>,欢迎您
编辑资料 退出登陆
找歌服务
<%if session("ban_msg")<>Empty then%>
<%=trim(session("ban_msg"))%>
<%end if%>
<% if session("blnStatus")="2" then %>
<%response.write " 你是流量用户" %> <%response.write " (VIP B型)" %>
<%response.write " 已下载:"&trim(session("DownloadCurrent")) & "MB"%>
<% response.write " 可下载:"&trim(session("DownLoadMax")) & "MB"%>
<%else%>
<% if session("blnStatus")="1" then %>
<%response.write " 你是包月用户" %><%response.write " (VIP A型)" %>
<%response.write " 开始时间:"&trim(session("start")) %>
<% response.write " 结束时间:"&trim(session("end")) %>
<% else %>
你是普通用户
请升级成VIP
<% end if %>
<% end if %>
<%end if%>
 |
 |
<%
set rs=server.createobject("adodb.recordset")
sql="select top 1 * from music_research order by datetime desc"
rs.open sql,conn,3
if not rs.eof then
%>
<%
end if
rs.close
set rs=nothing
%> |
|
 |
|
 |
<%
set rs=server.createobject("adodb.recordset")
sql="select top 2 * from music_pv where filename!='' order by ID desc"
rs.open sql,conn,3
do while not rs.eof
%>
.gif" width="110"> |
|
<%=left(rs("name"),14)%> |
|
<%
rs.movenext
loop
%>
|
|
|
 |
 |
|
 |
|
<%
set rs=server.createobject("adodb.recordset")
sql="select top 10 * from music_news order by newsid desc"
rs.open sql,conn,3
do while not rs.eof
%> "><%=left(rs("name"),30)%> <%=day(rs("datetime"))&"/"&month(rs("datetime"))%>
<%
rs.movenext
loop%>
|
|
|
|
 |
|
 |
|
 |
<%
sort="cn"
set rs=server.createobject("adodb.recordset")
sql="select top 1 * from note where sort='"&sort&"' order by id desc"
rs.open sql,conn,1,1
%>
|
|
 |
 |
<%
set rs=server.createobject("adodb.recordset")
sql="select top 10 * from music_disk where type=1 order by weekhits desc,hots desc"
rs.open sql,conn,3
i=0
do while not rs.eof
i=i+1
%>
|
|
 |
<%
set rs=server.createobject("adodb.recordset")
sql="select top 10 * from music_disk where type=0 order by weekhits desc,hots desc"
rs.open sql,conn,3
i=0
do while not rs.eof
i=i+1
%>
|
|
|
|
|

<%set rs=server.createobject("adodb.recordset")
sql="select * from music_disk where type=1 order by diskid desc"
rs.open sql,conn,3
i=1
do while (not rs.eof)and(i<=6)%>
|
曲名:<%=left(trim(rs("name")),8)%>
歌手:<%=left(trim(rs("singer")),12)%>
上传:<%=Year(rs("datetime"))&"-"&Month(rs("datetime"))&"-"&Day(rs("datetime"))%>
发行:<%=trim(rs("issue_date"))%> |
| <%
rs.movenext
if (i mod 2)=0 then
response.write " "
end if
i=i+1
loop%>
|
|
|

<%set rs=server.createobject("adodb.recordset")
sql="select * from music_disk where type=0 order by diskid desc"
rs.open sql,conn,3
i=1
do while (not rs.eof)and(i<=6)%>
|
曲名:<%=left(trim(rs("name")),8)%>
歌手:<%=left(trim(rs("singer")),12)%>
上传:<%=Year(rs("datetime"))&"-"&Month(rs("datetime"))&"-"&Day(rs("datetime"))%>
发行:<%=trim(rs("issue_date"))%> |
| <%
rs.movenext
if (i mod 2)=0 then
response.write " "
end if
i=i+1
loop%>
|
|
|
|
|
|
|
 |
<%
set rs2=server.CreateObject("adodb.recordset")
rs2.Open "select * from top5song",conn,3
do until(rs2.eof)
%>
" WIDTH="80" HEIGHT="80"> |
|
<%
rs2.MoveNext
loop
%>
<%
rs2.MoveFirst
do until (rs2.EOF)
%>
<%=rs2("songname")%>
<%=rs2("singer")%>
<%=rs2("updatetime")%>
">
Download |
<%
rs2.MoveNext
loop
set rs2=nothing
%>
|
|
|
|
 |
 |
<%clear_all%> |