%
'-------------------------------------------------------------------------------
'Template
'-------------------------------------------------------------------------------
%>
<%
'-------------------------------------------------------------------------------
'Config
'-------------------------------------------------------------------------------
Public Sub Config()
Page.S = fn.dic("s")
Page.Cate = "1030000"
End Sub
'-------------------------------------------------------------------------------
'Local Function
'-------------------------------------------------------------------------------
'-------------------------------------------------------------------------------
'Content
'-------------------------------------------------------------------------------
Public Sub RenderContent()
%>
<%
dim seq,fg,lastQidx,isWrite
seq = fn.dic("seq")
fg = 0
lastQidx = 0
isWrite = 0
set db = new dbclass
db.sql = "SELECT fg FROM popup_info WHERE popno=2;"
'db.view
set rs = db.execrs() : db.clear()
if not rs.eof then fg = rs(0) ' fg:1À̸é how to say ±Û¾²±â ¹öư showó¸®
rs.close : set rs = nothing
' ±Û¾²±â¿©ºÎ °¡Á®¿À±â
db.sql = "SELECT isWrite FROM popup_info WHERE popNo=2"
set rs = db.execrs() : db.clear()
if not rs.eof then isWrite = rs(0)
rs.close : set rs = nothing
if fg=1 then
db.sql = "SELECT top 1 qidx FROM Board where QUnique ='40000000' and QDelFg = 0 order by Qidx desc"
set rs = db.execrs() : db.clear()
if not rs.eof then lastQidx = rs(0) ' ÇöÀç ÁøÇàÁßÀÎ how to say ¹øÈ£ °¡Á®¿À±â
rs.close : set rs = nothing
end if
db.sql = "SELECT * FROM Board WHERE QUnique=40000000 and QIdx=" & seq & " ;"
db.sql = "UPDATE Board SET QRead=QRead+1 WHERE QUnique=40000000 and QIdx=" & seq & " ;"
'db.view
set rs = db.execrs()
set db = nothing
%>
Á¦¸ñ
<%=rs("QTitle")%>
ÀÛ¼ºÀÚ
°ü¸®ÀÚ
ÀÛ¼ºÀÏ
<%=left(rs("QDate"),10)%>
<%=replace(rs("QContent"),"http://file.themavens.co.kr","")%>
<%
if rs("qidx")=lastQidx and isWrite=1 then
response.write "How To Say ¾²±â "
end if%>
">
<%
set db = new dbclass
db.sql = "SELECT * FROM BoardComment WHERE qunique=" & seq & " AND CDelFg=0 AND cdetc2=0 order by cdate desc;"
'db.view
set rs = db.execrs()
set db = nothing
' Set Listing = new ListClass
' Listing.SetLow = 11
' Listing.Columm = " * "
' Listing.Short = " cidx DESC "
' Listing.Table = " BoardComment "
' Listing.CountSql = "select count(*) from BoardComment where QUnique=" & seq & " AND CDelFg=0 and cdetc2=0 ;"
' Listing.Condition = " QUnique=" & seq & " AND CDelFg=0 and cdetc2=0 "
'Listing.Dbview = true
' Set rs = Listing.execrs()
%>
<%if not (rs.eof or rs.bof) then%>
<%do until rs.eof%>
¡æ
<%=rs("MID")%>
<%=Replace(rs("CContent"), chr(13), " ")%>
<%=left(rs("CDate"),10)%>
<%rs.movenext:loop%>
<%'=Listing.Paging2("")%>
<%end if%>
<%
End Sub
%>