CREATE PROCEDURE [dbo].[up_save_logout] @auth_id uniqueidentifier, @CharID [uniqueidentifier], @server int, @channelID int, @name nvarchar(16), @real_ip varchar(16), @inven_gold int, @storage_gold int, @character_level int, @character_exp bigint, @log_type smallint as begin set nocount on declare @last_time datetime declare @bcust_id nvarchar(30) set @bcust_id = '' select @bcust_id=WindyCode, @last_time = BTime from AuthTable with (READUNCOMMITTED) where AuthID = @auth_id update AuthTable set world_id=0, [online] = '0', [BTime] = GETDATE(), [LTime] = @last_time from AuthTable where AuthID = @auth_id ------------------------------------------------------- -- ?? ?? ?? DB? ??? declare @srvname nvarchar(128) declare @srvid smallint set @srvid = -1 SELECT @srvid = srvid FROM master.dbo.sysservers where srvname = 'RustyHearts_LogDB' if(@srvid <> -1) begin exec RustyHearts_LogDB.RustyHearts_Log.dbo.up_LogOut @log_type, @server, @auth_id, @bcust_id, @CharID, @name, @channelID, @real_ip, @inven_gold, @storage_gold, @character_level, @character_exp end ------------------------------------------------------- end return @@error