USE [talesrunner]
GO
/****** Object: StoredProcedure [dbo].[usp_startRoomServer] Script Date: 03/03/2012 21:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*****************************************************************************
Name:
Desc:
Return-values:
Parameters:
Input
----------------------------
Output
----------------------------
Auth:
Date:
Version:
******************************************************************************
Change History
******************************************************************************
Date: 2011.11.23
----------------------------
Author: Kim SangUk
----------------------------
Description: 룸 서버가 켜질때 유저의 팜 리스트 정보의 룸 서버 번호와, 룸 핸들 값을 초기화 한다
----------------------------
******************************************************************************
Date: 2012.01.31
----------------------------
Author: Kim SangUk
----------------------------
Description: 각 서버별 팜 캐시 최대치 추가
----------------------------
******************************************************************************/
ALTER PROCEDURE [dbo].[usp_startRoomServer]
@ip varchar(20),
@port int
AS
SET NOCOUNT ON
EXEC dbo.usp_LogTranCount @@procid
declare @roomservernum int;
declare @farmCacheMax int;
declare @limitRoomCount int;
select @roomservernum = fdNum, @farmCacheMax = fdFarmCacheMax, @limitRoomCount = fdLimitRoomCount
from tblServerListRoomSvr with (nolock)
where fdServerIP = @ip and
fdServerPort = @port;
update tblServerListRoomSvr
set fdStartServerDateTime = getdate()
where fdServerIP = @ip and
fdServerPort = @port;
update tblUserFarmList set fdRoomServerNum = 0, fdRoomHandle = 0, fdCacheRoomServerNum = 0
where fdRoomServerNum = @roomservernum
if @roomservernum is null
begin
raiserror('cannot find proper server', 16, 1);
return;
end
else
select servernum = @roomservernum,
farmCacheMax = @farmCacheMax,
limitRoomCount = @limitRoomCount,
dbtime = getdate();