½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
happycgi
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > ASP > ASP ¼Ò½ºÃ¢°í > °Ô½ÃÆÇ > ½ÉÇÃÇÑ ¹«·á ASP °Ô½ÃÆÇ »ó¼¼Á¤º¸
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
javascript
PHP
html
ASP
css
MYSQL
Mobile
image
jquery
slide
2023
2022
�޴�
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
½ÉÇÃÇÑ ¹«·á ASP °Ô½ÃÆÇ
¼Ò½ºÅë°èÁ¤º¸ ¿À·ù½Å°í ¹× ¹®ÀÇ
ÇØÇÇÆÀ
³×ƼÁð
Æ®À§ÅÍ·Î º¸³»±â ÆäÀ̽ººÏÀ¸·Î º¸³»±â
¼Ò½ººÐ·ù °Ô½ÃÆÇ
´Ù¿î·Îµå Ƚ¼ö 5351 ȸ
°£´Ü¼³¸í ASP·Î Á¦ÀÛµÈ ½ÉÇÃÇÏ°í ±ò²ûÇÑ ¹«·á°Ô½ÃÆÇÀÔ´Ï´Ù. °Ô½ÃÆÇ, ¸ÞÀϸµ, Æ˾÷, Á¢¼Ó·Î±×¸¦ Á¦°øÇÕ´Ï´Ù.
Æò°¡Çϱâ ÈǸ¢ÇÔ ¸Å¿ìÁÁÀ½ ÁÁÀ½ ±¦ÂúÀ½ º¸Åë º°·Î
¼Ò½º´Ù¿î·Îµå µ¥¸ð ¹Ì¸®º¸±â°¡ ¾ø½À´Ï´Ù ½ºÅ©·¦Çϱâ

ÀÌ °Ô½ÃÆÇÀº ASP + MSSQL ·Î Á¦ÀÛµÈ ¹«·á°Ô½ÃÆÇ ÀÔ´Ï´Ù.
¶óÀ̼¾½º°¡ ¾ø±â ¶§¹®¿¡ ÀÚÀ¯·Ó°Ô »ç¿ëÀÌ °¡´ÉÇÕ´Ï´Ù.^^ ( Á¦ÀÛÀÚ : ¿ÁâÀ± )

¾Æ·¡´Â °Ô½ÃÆÇ ¼³Ä¡ÈÄ ÂïÀº ½ºÅ©¸°¼¦µé ÀÔ´Ï´Ù.

°ü¸®ÀÚ¸ðµå ¸ÞÀÎÆäÀÌÁö ÀÔ´Ï´Ù.


°Ô½ÃÆÇ »ý¼º È­¸éÀÔ´Ï´Ù.


ȸ¿ø ¸ÞÀϸµ È­¸é ÀÔ´Ï´Ù.


Æ˾÷â µî·Ï È­¸é ÀÔ´Ï´Ù.


Á¢¼ÓÅë°è È­¸é ÀÔ´Ï´Ù.



¾Æ·¡´Â Á¦ÀÛÇϽźÐÀÌ ³Ö¾îµÎ½Å setup.txt ÆÄÀÏ¿¡ ÀÛ¼ºµÈ ¼³Ä¡¹æ¹ý ÀÔ´Ï´Ù. (¾ÐÃàÆÄÀϾȿ¡µµ ÀÖ½À´Ï´Ù.)
ÂüÁ¶Çϼż­ ¼³Ä¡¸¦ ÁøÇàÇÏ½Ã¸é µË´Ï´Ù.

 
 ¼³Ä¡¼ø¼­
 1. lib Æú´õ¾È¿¡ config.asp ÆÄÀÏÀ» ¿­°í ȯ°æ¼³Á¤À»ÇÑ´Ù
   Db_Odbc_Name = "test" --> µðºñ¸í
  Db_Odbc_User = "test"  --> µðºñ¾ÆÀ̵ð
  Db_Odbc_Pass = "test"  --> µðºñÆнº¿öµå
  sql_ip = "localhost" --> µðºñ¼­¹ö ÁÖ¼Ò
 
  ''/// ·ÎÄðæ·Î
  PathDir  = "D:\inote\aspboard\"   -> ¸¶Áö¸·¿¡ \ ¿¡ ÁÖÀÇÇϼ¼¿ä
  ''/// »ó´ë°æ·Î
  PathHttp  = "http://www.inote.pe.kr/aspboard/"  --> http://Àڱ⵵¸ÞÀÎ/°Ô½ÃÆÇÆú´õ/  ¸¶Áö¸·¿¡ / ¿¡ ÁÖÀÇÇϼ¼¿ä
 
 2. ¾Æ·¡ Å×ÀÌºí »ý¼º
 
 3. upload_file  --> ¿äÆú´õ¿¡ ¾²±â ±ÇÇѼ³Á¤
 
 4. post2000.xls ¿ìÆí¹øÈ£»ý¼º(ȸ¿ø°¡ÀÔÀ» »ç¿ëÇÏÁö¾Ê´Â´Ù¸é ÇÊ¿ä¾ø½À´Ï´Ù.)
 
 5. ¼³Ä¡ÈÄ °ü¸®ÀÚ ¸ðµå Á¢¼Ó http://¼³Ä¡µÈ µµ¸ÞÀÎ/¼³Ä¡Æú´õ/admin/ ¿¹) http://www.inote.pe.kr/aspboard/admin
 

 
 
// Å×ÀÌºí »ý¼º ¹× ÇÁ·Î½ÃÁ® »ý¼º

-- ¿©±âºÎÅÍ º¹»ç --
CREATE TABLE [dbo].[BOARD_ADMIN] (
 [ADMIN_ID] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [ADMIN_PWD] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [ADMIN_NAME] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [ADMIN_EMAIL] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [ADMIN_LOGIN_COUNT] [int] NULL ,
 [ADMIN_LAST_LOGIN] [datetime] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[BOARD_CATEGORY] (
 [B_CODE] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [CATEGORY_NO] [int] NOT NULL ,
 [CATEGORY_NAME] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[BOARD_COMMENT] (
 [C_IDX] [int] IDENTITY (1, 1) NOT NULL ,
 [C_ID] [varchar] (20) COLLATE Korean_Wansung_CI_AS NULL ,
 [B_CODE] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [IDX] [int] NOT NULL ,
 [C_NAME] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [C_PWD] [varchar] (20) COLLATE Korean_Wansung_CI_AS NULL ,
 [C_WRITEDAY] [datetime] NOT NULL ,
 [C_MEMO] [text] COLLATE Korean_Wansung_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[BOARD_CONFIG] (
 [IDX] [int] IDENTITY (1, 1) NOT NULL ,
 [B_CODE] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [B_BOARDNAME] [varchar] (30) COLLATE Korean_Wansung_CI_AS NULL ,
 [B_SKIN] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [B_H_FILE] [varchar] (150) COLLATE Korean_Wansung_CI_AS NULL ,
 [B_H_HTML] [text] COLLATE Korean_Wansung_CI_AS NULL ,
 [B_F_FILE] [varchar] (150) COLLATE Korean_Wansung_CI_AS NULL ,
 [B_F_HTML] [text] COLLATE Korean_Wansung_CI_AS NULL ,
 [B_SUBJECT_CUT] [int] NULL ,
 [B_LIST_SIZE] [int] NOT NULL ,
 [B_WIDTH] [int] NOT NULL ,
 [B_COMMENT_U] [char] (1) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [B_PDS_U] [char] (1) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [B_PDS_CNT] [int] NOT NULL ,
 [B_MAX_UPLOAD_SIZE] [int] NOT NULL ,
 [B_SECURITY_CONFIG_U] [char] (1) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [B_CATEGORY_U] [char] (1) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [B_VIEW_LIST_U] [char] (1) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [B_ACCESS_WRITE] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [B_ACCESS_LIST] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [B_ACCESS_DOWN] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [B_ACCESS_VIEW] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [B_ACCESS_REPLE] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [B_WRITEDAY] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [dbo].[LOG_TABLE] (
 [vNum] [int] IDENTITY (1, 1) NOT NULL ,
 [vIP] [varchar] (15) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [vYY] [smallint] NOT NULL ,
 [vMM] [tinyint] NOT NULL ,
 [vDD] [tinyint] NOT NULL ,
 [vHH] [tinyint] NOT NULL ,
 [vMT] [tinyint] NOT NULL ,
 [vSeason] [tinyint] NOT NULL ,
 [vDW] [tinyint] NOT NULL ,
 [vBrowser] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [vOS] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [vReferer] [varchar] (200) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [vTarget] [varchar] (200) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [writeday] [smalldatetime] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MEMBER_TABLE] (
 [IDX] [int] IDENTITY (1, 1) NOT NULL ,
 [M_ID] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [M_PWD] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [M_NAME] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
 [M_EMAIL] [varchar] (100) COLLATE Korean_Wansung_CI_AS NULL ,
 [M_SSH] [varchar] (14) COLLATE Korean_Wansung_CI_AS NULL ,
 [M_TEL] [varchar] (20) COLLATE Korean_Wansung_CI_AS NULL ,
 [M_HP] [varchar] (20) COLLATE Korean_Wansung_CI_AS NULL ,
 [M_ZIP] [varchar] (7) COLLATE Korean_Wansung_CI_AS NULL ,
 [M_ADDRESS1] [varchar] (100) COLLATE Korean_Wansung_CI_AS NULL ,
 [M_ADDRESS2] [varchar] (100) COLLATE Korean_Wansung_CI_AS NULL ,
 [M_LOGIN_COUNT] [int] NOT NULL ,
 [M_WRITEDAY] [datetime] NOT NULL ,
 [M_LAST_LOGIN] [datetime] NOT NULL ,
 [M_LEVEL] [tinyint] NOT NULL ,
 [M_MAILING_U] [char] (1) COLLATE Korean_Wansung_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[POPUP_TABLE] (
 [IDX] [int] IDENTITY (1, 1) NOT NULL ,
 [P_SUBJECT] [varchar] (255) COLLATE Korean_Wansung_CI_AS NULL ,
 [P_CONTENT] [text] COLLATE Korean_Wansung_CI_AS NULL ,
 [P_POPUP_U] [char] (1) COLLATE Korean_Wansung_CI_AS NULL ,
 [P_WRITEDAY] [smalldatetime] NULL ,
 [P_STARTDAY] [varchar] (10) COLLATE Korean_Wansung_CI_AS NULL ,
 [P_ENDDAY] [varchar] (10) COLLATE Korean_Wansung_CI_AS NULL ,
 [P_WIN_WIDTH] [int] NULL ,
 [P_WIN_HEIGHT] [int] NULL ,
 [P_WIN_LEFT] [int] NULL ,
 [P_WIN_TOP] [int] NULL ,
 [P_MOVEURL] [varchar] (200) COLLATE Korean_Wansung_CI_AS NULL ,
 [P_FILE] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
 [P_STYLE] [char] (1) COLLATE Korean_Wansung_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

 


ALTER TABLE [dbo].[BOARD_COMMENT] WITH NOCHECK ADD
 CONSTRAINT [PK_BOARD_COMMENT] PRIMARY KEY  CLUSTERED
 (
  [C_IDX]
 ) WITH  FILLFACTOR = 90  ON [PRIMARY]
GO

ALTER TABLE [dbo].[BOARD_CONFIG] WITH NOCHECK ADD
 CONSTRAINT [PK_BOARD_CONFIG] PRIMARY KEY  CLUSTERED
 (
  [B_CODE]
 ) WITH  FILLFACTOR = 90  ON [PRIMARY]
GO

ALTER TABLE [dbo].[MEMBER_TABLE] WITH NOCHECK ADD
 CONSTRAINT [PK_MEMBER_TABLE] PRIMARY KEY  CLUSTERED
 (
  [M_ID]
 )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[POPUP_TABLE] WITH NOCHECK ADD
 CONSTRAINT [PK_POPUP_TABLE] PRIMARY KEY  CLUSTERED
 (
  [IDX]
 ) WITH  FILLFACTOR = 90  ON [PRIMARY]
GO

ALTER TABLE [dbo].[LOG_TABLE] ADD
 CONSTRAINT [DF_LOG_TABLE_writeday] DEFAULT (getdate()) FOR [writeday]
GO

ALTER TABLE [dbo].[POPUP_TABLE] ADD
 CONSTRAINT [DF_POPUP_TABLE_PopupYN] DEFAULT (0) FOR [P_POPUP_U]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE [dbo].[BOARD_LIST]
@B_LIST_SIZE  varchar(30),
@B_CODE   varchar(30),
@gotopage   varchar(30),
@where_qry    varchar(100)
as
declare
@sqlquery  varchar(1000)
 
set @sqlquery  = 'set transaction isolation level read uncommitted select top ' + @B_LIST_SIZE + ' * from '+ @B_CODE +'  where B_NOTICE_U= ''N''  '+@where_qry+' and  IDX not in (select top '+ str(((@gotopage - 1) * @B_LIST_SIZE)) +' IDX from '+@B_CODE+'  where B_NOTICE_U = ''N''  '+@where_qry+'  order by B_REF desc,B_STEP asc) order by B_REF desc,B_STEP asc '
exec(@sqlquery)
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE [dbo].[BOARD_LIST_COUNT]
@B_CODE   varchar(30),
@where_qry   varchar(100)
as
declare
@sqlquery  varchar(1000)
 
set @sqlquery  = 'set transaction isolation level read uncommitted Select count(IDX) from '+@B_CODE+' where  B_NOTICE_U = ''N''   ' +@where_qry+''
exec(@sqlquery)
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE [dbo].[BOARD_NOTICE]
@B_CODE   varchar(30)
as
declare
@sqlquery  varchar(1000)
 
set @sqlquery  = ' set transaction isolation level read uncommitted Select * From '+@B_CODE+' where 1=1 and B_NOTICE_U = ''Y'' order by IDX desc'
exec(@sqlquery)
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

INSERT INTO BOARD_ADMIN VALUES('admin','admin','°ü¸®ÀÚ','test@test.com',0,getdate())
INSERT INTO LOG_TABLE VALUES('111.111.111.111','2006','5','22','11','6','1','2','MSIE 6.0','Windows NT 5.1','http://www.inote.pe.kr/Zmall/Zadmin/log/log_list.asp','/Zmall/Zmall_default.asp?',GETDATE())


-- ¿©±â±îÁö º¹»ç Çؼ­ Äõ¸®ºÐ¼®±â·Î »ý¼ºÇϼ¼¿ä--


³×ƼÁð ÀÇ°ß   ÀÌ¿ëÇϽŠÀÚ·áÀÇ Èı⸦ ÀÚÀ¯·Ó°Ô ÀÛ¼ºÇϼ¼¿ä. (»ó¾÷ÀûÀÎ ±¤°í ¹× µµ¹è¼º ±Û µîÀº »çÀüÅ뺸¾øÀÌ »èÁ¦µÉ ¼ö ÀÖ½À´Ï´Ù.)
³»¿ë ¾ÆÀ̵ð ÀÇ°ß³²±â±â
ÁÁÀº Á¤º¸ °¨»çÇÕ´Ï´Ù ^^
2008-11-27 08:41:26
hacking
Âù¼º 101
¹Ý´ë 100
ÆÄÀÏÀ» ´Ù½Ã ¾÷·Îµå ÇÏ¿´½À´Ï´Ù.^^
ÁÁÀºÇÏ·ç º¸³»¼¼¿ä~
2008-11-12 11:12:15
kwak17
Âù¼º 103
¹Ý´ë 102
1
À̸§
³»¿ë
:³×¸Â¾Æ¿ä: :È­³ª´Â±º¿ä: :Àá¿Í: :¿ì¿ïÇØ: :À̰ǾƳÄ: :¿ÕÇÏÇÏ: ¿Õ¿ôÀ½~ ³î·¥~
Æò°¡Çϱâ ÈǸ¢ÇÔ ¸Å¿ìÁÁÀ½ ÁÁÀ½ ±¦ÂúÀ½ º¸Åë º°·Î
µµ¹è¹æÁöÅ°
 54734796 º¸ÀÌ´Â µµ¹è¹æÁöÅ°¸¦ ÀÔ·ÂÇϼ¼¿ä.