´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net)
ID¿Í Password¸¦ ÀÔ·ÂÇϼ¼¿ä.
ÀÔ±¹Çϱâ
|
¿µÁÖ±Ç ½Åû
¸öºÎ¸² °ñ¶ó°ñ¶ó
¼Ò±Ù¼Ò±Ù
µµ¶õµµ¶õ
³«¼¸¶´ç
Âø°¢ÇѾÆÀÌ
¼ýÀÚ¸ÂÃß±â
¼Ò¿øºô±â
ÈçÀû³²±â±â
²Þ¼Ó¿©Çà
Ä£±¸Áý ³î·¯°¡±â
¸ðµÎµå¸²´ÔÀÇ È¨
î¤éÞ´ÔÀÇ È¨
Çö¿ì´ÔÀÇ È¨
º°¾ÆÇØ´ÔÀÇ È¨
ÇÞ»ì´ÔÀÇ È¨
À̳ª´Ï´ÔÀÇ È¨
À¯¸®¾Ë´ÔÀÇ È¨
³È³ÈÀÌ´ÔÀÇ È¨
²ÀÁö´ÔÀÇ È¨
´ë¼º´ÔÀÇ È¨
¼öÁ¤ÇϽǶ§´Â ÇʼöÇ׸ñÀ» ¸ðµÎ ÀÔ·ÂÇÏ¼Å¾ß ÇÕ´Ï´Ù.
À̸§
*
°øÁö»çÇ×
ºñ°ø°³
HTML »ç¿ë
Á¦¸ñ
*
¼±ÅÃ
ÀÚÀÛ
»ç¶û
À¯¸Ó
ÀÚÀ¯
̵̧
¾Ë¸²
Áú¹®
±âŸ
³»¿ë
*
»õÇØ ÜØ ¸¹ÀÌ ¹ÞÀ¸¼¼¿ä. ´Ù¸§ÀÌ ¾Æ´Ï¶ó À̹ÌÁö ÆÄÀÏ ¾÷·Îµå Çϱ¸ À̹ÌÁö ºñÀ²¿¡ °üÇÑ Áú¹®À» µå¸±±î ÇÕ´Ï´Ù. À̹ÌÁö¸¦ Ãâ·ÂÇϴµ¥
ÀÌ·¸°Ô width¿Í height¸¦ ÁöÁ¤ÇÏ¿© Ãâ·ÂÇϴµ¥¿ä. À̹ÌÁö ÆÄÀÏ ¾÷·Îµå½Ã ºñÀ²ÀÌ ¾È ¸Â´Ù°í ¸ÂÃß¾î ´Þ¶ó°í Çϳ׿ä. Á¶±Ý Å« »çÁøÀÌ width°ª°ú height°ª¿¡ ÀâÇô¼ Àüü À̹ÌÁö°¡ ¾È º¸Àδٸ鼿ä. ¾î¶»°Ô Çϸé ÀßÇß´Ù°í ¼Ò¹®ÀÌ ³¯·±Áö.. [Àüü¼Ò½º] <% sCode = Request("sCode") Set Conn = Server.CreateObject("ADODB.Connection") 'DB¿¡ ¿¬°á Conn.Open "***********" Set Rs = Server.CreateObject("ADODB.RecordSet") SQL = "SELECT b.LocalName, a.SiteName, a.StDate, a.EnDate, a.InDate, a.Picture, a.Name, a.Prologue, a.Summary, a.Address, a.Telephone, a.PosPic FROM SiteInFo a, Local b WHERE (a.SiteCode = '" & sCode & "')" Rs.Open SQL, Conn, 1 If Rs.Eof then %> <% Response.end End If %>
º®»ê °Ç¼³ °øÁö »çÇ×
<%=Rs("SiteName")%>
ÇöÀå ¼ÒÀå
<%=Rs("Name")%>
<% If isNull(Rs("picture")) = TRUE then Response.Write "»çÁø ¾ø½¿" Else %>
" width="102"> <% End If %>
<%=Replace(Rs("Prologue"),chr(10),"
")%>
ÁÖ ¼Ò
<%=Rs("LocalName")%> <%=Rs("Address")%>
ÀüÈ ¹øÈ£
<%=Rs("Telephone")%>
°ø»ç ±â°£
<%=Rs("StDate")%> - <%=Rs("EnDate")%>
°ø»ç °³¿ä
<%=Replace(Rs("Summary"),chr(10),"
")%>
ÀÔÁÖ ¿¹Á¤ÀÏ
<%=Rs("InDate")%>
¡¡
<% Set PRs = Server.CreateObject("ADODB.RecordSet") SQL = "SELECT NewDate, ForePic FROM SitePic WHERE (SiteCode = '" & sCode & "') AND (ForePic IS NOT NULL) ORDER BY NewDate" PRs.Open SQL, Conn, 3 If PRs.EOF Then %>
ÇöÀå¿ùº°
<% Else forePic="sitepic\" & PRs("forepic") %>
ÇöÀå¿ùº°
<% For nFor = 1 To PRs.RecordCount %>
"><%=trim(Mid(PRs("NewDate"), 8, 5))%>
<% PRs.MoveNext Next End If %>
<% Set SRs = Server.CreateObject("ADODB.RecordSet") SQL = "SELECT Descript, RoomPic FROM SitePic WHERE (SiteCode = '" & sCode & "') AND (Descript IS NOT NULL)" SRs.Open SQL, Conn, 3 If SRs.EOF Then %>
ÇöÀå ¼¼ºÎ »çÁø
<% Else Unit = "sitepic\" & SRs("RoomPic") %>
ÇöÀå ¼¼ºÎ »çÁø
<% For nFor = 1 To SRs.RecordCount %>
"><%=SRs("Descript")%>
<% SRs.MoveNext Next End If %>
<% If forepic<>"" Then %>
ÀÌ ºÎºÐÀÌ À̹ÌÁö¸¦ Ãâ·ÂÇÕ´Ï´Ù width°ª°ú height°ªÀ» Á¦°ÅÇÏ¸é ´ç¿¬È÷ À¯µ¿ÀûÀ¸·Î À̹ÌÁö°¡ Ãâ·ÂµÇ±¸¿ä... <% End If %>
<% If Unit <> "" Then %>
<% End If %>
<% SRs.Close PRs.Close %>
','','width=370,height=250');">
<% Set Crs = Server.CreateObject("ADODB.Recordset") SQL = "SELECT b_board_idx, b_name, b_subject, convert(char(8), b_writeday) as b_writeday, b_re_level, b_ref FROM MBoard where b_sitecode='" & sCode & "' ORDER BY b_ref DESC, b_re_step asc" Crs.PageSize = 5 Crs.Open SQL, Conn, 1 %>
¹øÈ£
Á¦ ¸ñ
ÀÛ¼ºÀÚ
ÀÛ¼ºÀÏ
<% If Not Crs.Eof Then i = 1 Do until Crs.EOF Or i > Crs.PageSize if Crs("b_re_level") > 0 then wid = 5 * Crs("b_re_level") %>
<%=i%>
&sitecode=<%=sCode%>"><%=Crs("b_subject")%>
<%=Crs("b_name")%>
<%=Crs("b_writeday")%>
<% else %>
<%=i%>
&sitecode=<%=sCode%>"><%=Crs("b_subject")%>
<%=Crs("b_name")%>
<%=Crs("b_writeday")%>
<% end if Crs.MoveNext i = i + 1 loop %>
<% j=1 Do Until j > 10 or blockPage > int(Crs.pagecount) If int(blockPage)=int(c_page) Then %>
[<%=blockPage%>]
<% else %>
[<%=blockPage%>]
<% End If blockPage = blockPage + 1 j = j + 1 Loop Crs.close %>
<% Else %>
[
1
]
<% End If %>
<% rs.Close conn.Close Set rs = Nothing Set conn = Nothing %>
Ãß°¡ÇÒ À̹ÌÁö¸¦ ÀÔ·ÂÇϼ¼¿ä.
À̹ÌÁö 1
À̹ÌÁö¼³¸í 1
Ãß°¡ÇÒ ÀڷḦ ÀÔ·ÂÇϼ¼¿ä.
ÀÚ·á 1
ÀÚ·á¼³¸í 1
Ãß°¡ÇÒ ½ÎÀÌÆ®¸¦ ÀÔ·ÂÇϼ¼¿ä.
°ü·Ã½ÎÀÌÆ® 1
½ÎÀÌÆ®¼³¸í 1
Password
*