[Release] Database Total Online Time Mod

[Dode]

Server: Msg 446, Level 16, State 9, Procedure WZ_DISCONNECT_MEMB, Line 10
Cannot resolve collation conflict for equal to operation.
-.-

[19871986]

try this

CREATE PROCEDURE WZ_DISCONNECT_MEMB
@memb___id varchar(10)
 AS
Begin    
set nocount on
    Declare   @Find_id varchar(10)    
    Declare  @Connectstat tinyint
    Set  @Connectstat = 0     
    Set  @Find_id = 'NOT'
    select  @Find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id COLLATE DATABASE_DEFAULT = I.memb___id COLLATE DATABASE_DEFAULT
           where I.memb___id = @memb___id
    if(  @Find_id <> 'NOT' )    
    begin        
        update MEMB_STAT set ConnectStat =  @Connectstat, DisConnectTM = getdate(), TotalTime = TotalTime+(DATEDIFF(mi,ConnectTM,getdate()))
         where memb___id = @memb___id
            -- TIMEONLINE MOD by john_d
    end
end

GO

[15351535]

bad for Season 8 (offtrade) user

[KlubZone]

Works fine on 97d:D -KlubZone MuOnline 97D

[davideguadagno]

Msg 2714, Level 16, State 3, Procedure WZ_DISCONNECT_MEMB, Line 14There is already an object named 'WZ_DISCONNECT_MEMB' in the database.

i'm getting this error, any solution?

[diemorko]

Any fix? (Time acumuleted when reconnect)

[cover]

there you go
i just changed OnlineHours to TotalOnline to show in mins

this is working ?