[Release] Database Total Online Time Mod

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

try this

Code:

---

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

---

bad for Season 8 (offtrade) user:D:

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

Code:

---

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?

Any fix? (Time acumuleted when reconnect)

Quote:

---

Originally Posted by crlfrancis

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

---

this is working ?