CREATE                    PROCEDURE WZ_DISCONNECT_MEMB 
@uid varchar(10)
AS
Begin

BEGIN TRANSACTION

SET NOCOUNT ON 

IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED) WHERE memb___id = @uid )
Begin 
	UPDATE MEMB_STAT SET DisConnectTM = (getdate()), connectstat = 0 WHERE memb___id = @uid

	ＭＯＮＥＹ
	IF EXISTS ( SELECT UserID FROM UserLogin WITH (READUNCOMMITTED) WHERE UserID = @uid)
	Begin 
  declare @ntm datetime
  declare @otm int
  declare @mny int
  set @ntm=getdate()
  select @otm=datediff(minute,LoginTM,@ntm) from UserLogin where UserID = @uid

  Money
  declare @money int
  SELECT @money=OnlineMoney FROM SetServerList WHERE (ServerName IN (SELECT Server FROM UserLogin WHERE UserID = @uid))

  set @mny=@otm*@money
  
  update warehouse set [money]=(case when 2000000000-@mny>[money] then [money]+@mny else 2000000000 end ) where accountid=@uid

  
  UPDATE UserLogin SET LogoutTM = @ntm,OnlineSec=@otm,GiveMoney=@mny WHERE UserID = @uid 

	End
End
DELETE FROM Uselog WHERE (Id =@uid )

update character set ctlcode=(ctlcode & 0xffffff7e) where accountid=@uid and (ctlcode & 0x81)=0x81

declare @ckpw int
select @ckpw=lastpw from warehouse where accountid=@uid
if @ckpw is not null and @ckpw <>0 begin
	update warehouse set pw=@ckpw where accountid=@uid
	update extwarehouse set pw=@ckpw where accountid=@uid
end
UPDATE [Character] SET MapNumber = 0, MapPosX = 130, MapPosY = 130 WHERE (MapNumber = 30) AND (AccountID = @uid) OR (MapNumber = 31) AND (AccountID = @uid)
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE 
COMMIT TRANSACTION

SET NOCOUNT OFF 
End
GO

update warehouse set [money]=(case when 2000000000-@mny>[money] then [money]+@mny else 2000000000 end ) where accountid=@uid