CREATE PROCEDURE [dbo].[up_SetMonitorUser]
@log_type		int
,@world_id		int
,@gate			int
,@lobby			int
,@dungeon		int
,@pvp			int
,@total			int
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(1500)

-- Battle_Room_Log ??? ??
exec Local_CreateMonitorUserTable @createtime

 SET @updatesql ='insert into MonitorUser_Log_'+ @year+'_'
	     +@month+'( log_type, world_ID, CU_gate, CU_lobby, CU_PVP, CU_dungeon, CU_total, date ) 
	      values (' 
			+ '''' +convert(nvarchar, @log_type) + '''' + ',' 
			+ '''' +convert(nvarchar, @world_id) + '''' + ',' 
			+ '''' +convert(nvarchar, @gate) + '''' + ',' 
			+ '''' +convert(nvarchar, @lobby) + '''' + ',' 
			+ '''' +convert(nvarchar, @dungeon) + '''' + ',' 
			+ '''' +convert(nvarchar, @pvp) + '''' + ',' 
			+ '''' +convert(nvarchar, @total) + '''' + ',' 
			+ '''' +convert(nvarchar, @createtime, 109)+ '''' + ')'   
EXEC(@updatesql)

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

commit