CREATE PROCEDURE [dbo].[up_SetDungeon]
	
	 @log_type			int	
	,@intance_id		[uniqueidentifier]
	,@world_id			int	
	,@dungeonid			int	
	,@difficulty		tinyint	
	,@membercountstart	tinyint	
	,@death				tinyint	
	,@rebirth			tinyint	

as 
set nocount on

declare @createtime datetime
set @createtime = getdate()

declare @year varchar(50)
declare @month varchar(50)

set @year	= convert(varchar, datepart(yy,@createtime))
set @month	= convert(varchar, datepart(mm,@createtime))

set xact_abort on
begin tran

declare @updatesql nvarchar(2500)

declare @char_instance_id		nvarchar(50)


-- Login_Log ??? ??
exec Local_CreateDungeonTable @createtime

set @char_instance_id = @intance_id

	SET	 @updatesql  = 'INSERT INTO Dungeon_log_' + @year + '_' + @month + '(    log_type			
																				,instance_id		
																				,world_id			
																				,dungeon_id			
																				,difficulty		
																				,membercountstart	
																				,death				
																				,rebirth)
																				VALUES('
																				+ '''' +convert(nvarchar, @log_type)         + '''' + ',' 
																				+ '''' +@char_instance_id  + '''' + ','  
																				+ '''' +convert(nvarchar, @world_id)        + '''' + ','
																				+ '''' +convert(nvarchar, @dungeonid)        + '''' + ',' 
																				+ '''' +convert(nvarchar, @difficulty)       + '''' + ',' 
																				+ '''' +convert(nvarchar, @membercountstart) + '''' + ',' 
																				+ '''' +convert(nvarchar, @death)            + '''' + ',' 
																				+ '''' +convert(nvarchar, @rebirth)          + '''' + ')'   

EXEC(@updatesql)			

if(@@error <> 0)
begin
	rollback
	return
end

commit