read_art_display.asp

都市星空BBS系统 v1.1(SQL)

	sqltext="select db_bbs.bbsid,db_bbs.boardid,db_bbs.title,db_bbs.content,db_bbs.pic,db_bbs.author,db_bbs.putdate,db_bbs.replynum,db_bbs.clicknum,db_bbs.replydate,db_user.id,db_user.username,db_user.name,db_user.Face,db_user.Underwrite,db_user.TopicCount from db_bbs,db_user where db_bbs.author=db_user.username and db_bbs.rootid="&bbsid&" order by db_bbs.bbsid asc"
	'response.write sqltext
	rs.open sqltext,conn,1,1
	do while not rs.eof
%>
<table width="100%"  border="0" cellpadding="0" cellspacing="1" bgcolor="#E7E7E7">
                      <tr>
                        <td height="25" bgcolor="#738AD6" STYLE='PADDING-LEFT: 10px'><span class="7"><font color="#FFFFFF">回复</font>：<%=rs("title")%></span></td>
        </tr>
                      <tr>
                        <td bgcolor="#F7F3F7"><table width="98%"  border="0" align="center" cellpadding="2" cellspacing="1">
                            <tr>
                              <td height="25"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                  <td width="50"><img src="/Face/face<%=rs("Face")%>.jpg">&nbsp;</td>
                                  <td><a href="user_info.asp?username=<%=rs("username")%>"><span class="6"><%=rs("name")%></span></a>&nbsp;&nbsp;发表于：<%=rs("putdate")%>&nbsp;&nbsp;  发帖： <%=rs("TopicCount")%></td>
                                  <td width="200"><div align="right">
                                      <% if adminboardok=1 or session("username")=rs("author") then %>
        ［<a href="delete.asp?boardid=<%=rs("boardid")%>&bbsid=<%=rs("bbsid")%>">删除</a>］［<a href="edit_art.asp?boardid=<%=rs("boardid")%>&bbsid=<%=rs("bbsid")%>">修改</a>］
        <% end if %>
                                  </div></td>
                                </tr>
                              </table></td>
                            </tr>
                            <tr>
                              <td height="1" background="images/ehouse_54.gif"></td>
                            </tr>
                            <tr>
                              <td><font color="#FFFFFF"><img src="ubb/<%=rs("pic")%>"></font><%=UBBCODE(trim(rs("content")))%></td>
                            </tr>
                            <tr>
                              <td><%=UBBCODE(trim(rs("underwrite")))%></td>
                            </tr>
                        </table></td>
                      </tr>
                    </table><%
rs.movenext
loop	 
rs.close
set rs=nothing
%>
</td>
                  </tr>
                  <tr>
                    <td height="30"><div align="right"><a href="top_art_cancel.asp?boardid=<%=request("boardid")%>&bbsid=<%=request("bbsid")%>">[取消置顶]</a>　<a href="top_art_submit.asp?boardid=<%=request("boardid")%>&bbsid=<%=request("bbsid")%>">[置顶]</a>　<a href="distillate_art_cancel.asp?boardid=<%=request("boardid")%>&bbsid=<%=request("bbsid")%>">[取消精华]</a>　 <a href="distillate_art_submit.asp?boardid=<%=request("boardid")%>&bbsid=<%=request("bbsid")%>">[精华]</a>　
                    <a href="delete.asp?boardid=<%=request("boardid")%>&bbsid=<%=request("bbsid")%>">[删除]</a> 　<a href="edit_art.asp?boardid=<%=request("boardid")%>&bbsid=<%=request("bbsid")%>">[修改]</a> 　<a href="devolve_art_submit.asp?boardid=<%=request("boardid")%>&bbsid=<%=request("bbsid")%>">[转帖]</a> </div></td>
                  </tr>
                  <tr>
                    <td><table width="100%"  border="0" cellpadding="0" cellspacing="1" bgcolor="#E7E7E7">
                      <tr>
                        <td height="25" bgcolor="#738AD6" STYLE='PADDING-LEFT: 10px'><a name="reply"></a><span class="7">回复这条主题</span></td>
                      </tr>
                      <tr>
                        <td bgcolor="#FFFFFF"><%
if session("id")="" or isempty(session("id")) then
%>
                            <br>
                            <table width="600"  border="0" align="center" cellpadding="0" cellspacing="0">
                              <tr>
                                <td><img src="images/bbs_0.gif" width="600" height="11"></td>
                              </tr>
                              <tr>
                                <td height="25" background="images/bbs_2.gif"><table  border="0" align="center" cellpadding="1" cellspacing="3">
                                  <tr>
                                      <td>&nbsp;您还没有登录或登录超时，请重新登录！</td>
                                      <td><a href="reg.asp"><img src="images/ehouse_21.gif" width="74" height="19" border="0"></a></td>
                                      <td><a href="login.asp"><img src="images/login.gif" width="64" height="19" border="0"></a></td>
                                  </tr>
                                  </table></td>
                              </tr>
                              <tr>
                                <td valign="top"><img src="images/bbs_3.gif" width="600" height="12"></td>
                              </tr>
                            </table>
                            <br>
                            <%else%>
  <form name="form" method="post" action="reply_art_submit.asp?boardid=<%=request("boardid")%>&bbsid=<%=request("bbsid")%>"><table width="100%"  border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#E7E7E7">
                              <tr bgcolor="#FFFFFF">
                                <td width="100" height="25">表情： </td>
                                <td><table border="0" cellspacing="1" cellpadding="3">
                                  <tr>
                                    <td width="24" align="center">
                                      <input name="pic" type="radio" value="n1.gif" checked>
                                    </td>
                                    <td width="30"><img border="0" src="ubb/n1.gif"></td>
                                    <td width="24" align="center">
                                      <input type="radio" value="n2.gif" name="pic">
                                    </td>
                                    <td width="30"><img border="0" src="ubb/n2.gif"></td>
                                    <td width="28" align="center">
                                      <input type="radio" value="n3.gif" name="pic">
                                    </td>
                                    <td width="30"><img border="0" src="ubb/n3.gif"></td>
                                    <td width="25" align="center">
                                      <input type="radio" value="n4.gif" name="pic">
                                    </td>
                                    <td width="30"><img border="0" src="ubb/n4.gif"></td>
                                    <td width="24">
                                      <input type="radio" value="n5.gif" name="pic">
                                    </td>
                                    <td width="30"><img border="0" src="ubb/n5.gif"></td>
                                    <td width="24">
                                      <input type="radio" value="n6.gif" name="pic">
                                    </td>
                                    <td width="30"><img border="0" src="ubb/n6.gif"></td>
                                  </tr>
                                  <tr>
                                    <td width="24" align="center">
                                      <input type="radio" value="n7.gif" name="pic">
                                    </td>
                                    <td width="30"><img border="0" src="ubb/n7.gif"></td>
                                    <td width="24" align="center">
                                      <input type="radio" value="n8.gif" name="pic">
                                    </td>
                                    <td width="30"><img border="0" src="ubb/n8.gif"></td>
                                    <td width="28" align="center">
                                      <input type="radio" value="n9.gif" name="pic">
                                    </td>
                                    <td width="18"><img border="0" src="ubb/n9.gif"></td>
                                    <td width="25" align="center">
                                      <input type="radio" value="n10.gif" name="pic">
                                    </td>
                                    <td width="19"><img border="0" src="ubb/n10.gif"></td>
                                    <td width="24">
                                      <input type="radio" value="n11.gif" name="pic">
                                    </td>
                                    <td width="19"><img border="0" src="ubb/n11.gif"></td>
                                    <td width="24">
                                      <input type="radio" value="n12.gif" name="pic">
                                    </td>
                                    <td width="19"><img border="0" src="ubb/n12.gif"></td>
                                  </tr>
                                </table></td>
                            </tr>
                              <tr>
                                <td bgcolor="#F7F3F7">标题：</td>
                                <td bgcolor="#F7F3F7"><input type="text" name="title" value="回复：<%=oldtitle%>" size="50" maxlength="60"></td>
                            </tr>
                              <tr bgcolor="#FFFFFF">
                                <td bgcolor="#FFFFFF">上传图片：</td>
                                <td><iframe height=25 marginwidth=0 width=100% marginheight=0 frameborder=0 hspace=0 vspace=0 scrolling=no bordercolor="#000000" src="upload.asp"></iframe></td>
                </tr>
                              <tr>
                                <td bgcolor="#FFFFFF">内容：</td>
                                <td bgcolor="#FFFFFF"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                                  <tr>
                                    <td><!--#include file=include/getUbb.asp-->&nbsp;</td>
                                  </tr>
                                  <tr>
                                    <td><textarea name="content" rows="8" cols="80"></textarea></td>
                                  </tr>
                                </table>                                  </td>
                              </tr>
                              <tr bgcolor="#FFFFFF">
                                <td>&nbsp;</td>
                                <td>
                                  <li>社区用户请确认您发表的言论符合 <a href="http://club.sohu.com/rules1.htm">《互联网电子公告服务管理规定》 </a>、 <a href="http://club.sohu.com/rules2.htm">《全国人大常委会关于维护互联网安全的规定》 </a>、 <a href="http://club.sohu.com/tiaoli.htm">《用户条款》 </a>规定，并符合本论坛的主旨。 <br>
                                  <li>本社区用户不得在本社区发表包含破坏宪法和法律、破坏民族团结、捏造或者歪曲事实、宣扬封建迷信、淫秽、色情，及其他违反宪法和法律行政法规的言论。 <br>
                                  <li>本社区用户因为违反本社区规定而触犯中华人民共和国法律的，责任自负，我网站不承担任何责任。
                                </td>
                              </tr>
                        </table>
  <div align="center">
      <input type="submit" name="Submit" value="回复该文章">
    </div><%end if%></form></td>
                      </tr>
                    </table></td>
                  </tr>
                </table>