www.gusucode.com > 盐城分类信息网asp源码程序 > comno.asp
<%
'***********************************
'本站由吉林信息网团队制作
'***********************************
'--------版权说明------------------
'吉林信息网官方网站：http://www.jl-e.com
'QQ:304133183
'***********************************
%><!--#include file="inc/conn.asp"-->
<!--#include file="inc/inc.asp"-->
<%
dim k
m=CheckStr(trim(request("m")))
set rs = Server.CreateObject("ADODB.RecordSet")
sql="select * from [com] where username='"&m&"'"
rs.open sql,conn,1,3
if rs.eof or rs.bof then
response.write "<script language=JavaScript>" & chr(13) & "alert('相关用户资料没有通过管理员的审核或者已经被删除！')</script>"
response.redirect "../"
end if
if rs("yz")<>1 then
response.write "<script language=JavaScript>" & chr(13) & "alert('我们将在２４小时内审核通过您的申请！若超过４８小时没有通过，请检查您的注册信息或联系本站')</script>"
response.redirect "../"
end if
if rs("vip")="1" then
response.redirect "com.asp?m="&m&""
end if
rs("tong")=rs("tong")+1
rs.update
%>
<%dim n,rs0
set rs0=server.createobject("adodb.recordset")
set rs0=conn.execute("select count(id) from [xinxi] where username='"&m&"'")
n=rs0(0)
rs0.close
%>
<html>
<HEAD>
<title><%=rs("com")%>-首页-<%=title%></title>
<LINK href="images/at_news.css" type=text/css rel=stylesheet>
<LINK href="images/at_news.css" type=text/css rel=stylesheet>
</HEAD>
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0">
<%call t()%>
<DIV id=content>
<DIV id=right>
<DIV class=navigation>
<table border="0" width="100%" id="table1" style="border-collapse: collapse">
<tr>
<td width="70%" colspan="0" class="td1" background="Images/menu_r.gif">
<font color="red"><b><%=rs("com")%></b></font>简介 <font color="#666666"> 已有</font>[<%=rs("tong")%>]<font color="#666666">人访问</font></td>
<td class="td1" background="Images/menu_r.gif"><marquee onMouseOver="this.stop()" onMouseOut="this.start()" scrollamount="3" scrolldelay="121" behavior="scroll" height="14" style="font-size: 10pt; color: #835E07" width="306">最新公告：<%=rs("comgg")%></marquee></td>
</tr></table></DIV>
<DIV class=rightbody>
<DIV class=tags_calss>
<!--商家简介开始-->
<div align="center">
<TABLE cellSpacing=0 cellPadding=0 border=0 width="96%">
<TBODY>
<TR>
<TD width="400" valign="top"> <u><b><font color="#808080"><%=rs("com")%>简介</font></b></u><font color="#808080"><br> <%=HTMLDecode(rs("comabout"))%></font>
</TD>
<TD align=middle>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#999999 cellSpacing=0 cellPadding=0
align=right border=1 width="250" height="250">
<TBODY>
<TR>
<TD align=middle><p align="center"><%if rs("logo")<>"" then %><img src="<%=rs("logo")%>" onload="if(this.width>screen.width-460)this.width=screen.width-460;" onerror=src='err.gif' border=1 onload="javascript:DrawImage(this);" style="border: 0px solid #C0C0C0; " alt="店标" width="250" height="250">
<%else%>
<img src="err.gif" border=1 alt="店标" width="250" height="250">
<%end if%>
<a href="javascript:window.external.AddFavorite('<%=web%>/com.asp?com=<%=rs("username")%>', '<%=rs("com")%>-<%=title%>')"><img border="0" src="image/bookmark.gif"<font color="#835E07">收藏此店铺</font></a><br></TD></TR></TBODY></TABLE></TD>
</TR>
<TR>
</TBODY></TABLE>
</center>
</div>
</DIV>
</DIV>
<DIV class=rightbody>
<DIV class=tags_calss>
<!--产品发布开始-->
<div align="center">
<TABLE border=0 width="99%">
<tr>
<%
dim j
set rstj_a=server.createobject("adodb.recordset")
sqltj_a="select top 12 * from xinxi where yz=1 and username='"&m&"' order by fbsj desc,ID desc"
rstj_a.open sqltj_a,conn,1,1
while not rstj_a.eof
%>
<%for j=0 to 3
if rstj_a.eof then
exit for
end if
%>
<td align="center" class=tmpstr valign="top" style="; border:1px solid #CCCCCC; background-color:#F7F7F7" width="25%">
<a title="<%=rstj_a("biaoti")%>" target="_blank" href="x.asp?cnmai=<%=rstj_a("id")%>"><%if rstj_a("tupian")<>"0" and rstj_a("tupian")<>"" then%><IMG src="<%=rstj_a("tupian")%>" width="120" height="100" border=1 style="border: 1px solid #FFFFFF; ; padding-left:2px; padding-right:2px" hspace="0" ><br><u><b><%=left(rstj_a("biaoti"),7)%></b></u><br><%=left(rstj_a("memo"),20)%><font size="1">></font></a><%else%><u><b><%=left(rstj_a("biaoti"),12)%></b></u><br><%=left(rstj_a("memo"),40)%><font size="1">></font><%end if%></td>
<%
rstj_a.movenext
next
%> </tr>
<%
wend
rstj_a.close
%>
</TABLE>
</center>
</div>
</DIV>
</DIV>
</td>
</tr>
</table>
</div>
<!--左边-->
<DIV id=rights>
<DIV class=leftborder>
<DIV class=ltitle><SPAN class=font> >><%=left(rs("com"),10)%></SPAN></DIV>
<DIV class=lcontent> <SPAN class=tableleft>
<TABLE cellSpacing=0 cellPadding=0 width="99%" border=0>
<TBODY>
<table border="0" width="99%" cellspacing="0" cellpadding="0" id="table2">
<tr>
<td height="91"> <font color="#808080">商家模式：</font>普通商家<br> <font color="#808080">店主：</font><%=rs("name")%>(<%=rs("username")%>)<br> <font color="#808080">积分：</font><%=rs("jf")%><br> <font color="#808080"> 物品数：</font><%=n%><br> <font color="#808080">创店时间：</font><%=formatdatetime(rs("zcdata"),1)%><br> <font color="#808080">商家地址：</font><%=left(rs("dizhi"),10)%><br> <a target="_blank" href="com_mail.asp?com=<%=rs("username")%>">给店家发信息</a><%if rs("qq")<>"" then %> <a target=blank href=http://wpa.qq.com/msgrd?V=1&Uin=<%=rs("qq")%>&Menu=yes><img border="0" SRC=http://wpa.qq.com/pa?p=1:<%=rs("qq")%>:7 alt="用QQ给他发信息"></a><%end if%><br>
<font color="#666666"> 已有</font>[<%=rs("tong")%>]<font color="#666666">人访问您的店铺</font></td>
</tr>
<tr>
<td height="64" valign="top"><%if request.cookies("cnmai")("username")<>"" then%>
<font color="#808080">地址：<%=rs("dizhi")%><br> 电话：<%=rs("dianhua")%><br> 传真：<%=rs("fax")%><br> E-mail：<%=rs("email")%></font><%else%><font color="#808080">非<a target="_blank" href="ab_help.asp">[特约商家]</a>需要登陆</font><a href="login.asp"><font color="#808080">[<%=title%>]</font></a><font color="#808080">才能看到联系方式→</font><a href="login.asp"><font color="#CC9900">[我要登陆]</font></a><%end if%>
</td>
</tr>
</table>
</TBODY></TABLE></SPAN></DIV></DIV>
<DIV class=leftborder>
<DIV class=ltitle><SPAN class=font> >> vip特约商家</SPAN></DIV>
<DIV class=lcontent> <SPAN class=tableleft>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<%
sql= "select top 10 username,com,zcdata,lastdl from com where yz=1 and vip=1 order by lastdl desc,id desc"
call ncom()
%>
</TBODY></TABLE></SPAN></DIV></DIV>
<center>
<!--#include file="foot.asp"-->
</center>
<!--左边结束-->
</body>
</html><%
'***********************************
'本站由吉林信息网团队制作
'***********************************
'--------版权说明------------------
'吉林信息网官方网站：http://www.jl-e.com
'QQ:304133183
'***********************************
%>