修改在线计时长

Published: Nov 11, 2025   Comment: No Comments

游戏数据库 如果觉得对你有帮助，并想支持我，可以适当打赏以作勉励，点击打赏

默认计时长为1小时一记录，更改为一分钟一记录

-- 1. 先将历史数据从小时转换为分钟
UPDATE MEMB_STAT 
SET OnlineHours = OnlineHours * 60

-- 2. 修改存储过程使用分钟计算
ALTER PROCEDURE [WZ_DISCONNECT_MEMB]
    @inAccountID VARCHAR(10)
AS
BEGIN
    SET NOCOUNT ON

    BEGIN TRANSACTION

    IF EXISTS (SELECT 1 FROM MEMB_STAT WHERE memb___id = @inAccountID)
    BEGIN
        UPDATE MEMB_STAT
        SET ConnectStat = 0, 
            DisConnectTM = GETDATE(), 
            OnlineHours = OnlineHours + DATEDIFF(MINUTE, ConnectTM, GETDATE())
        WHERE memb___id = @inAccountID
    END

    IF @@ERROR = 0
        COMMIT TRANSACTION
    ELSE
        ROLLBACK TRANSACTION

    SET NOCOUNT OFF
END
GO

执行完代码后，时间就自动将已记录的时长转换为了分钟