[Release] Database Total Online Time Mod

[feature21]

Msg 468, Level 16, State 9, Procedure WZ_DISCONNECT_MEMB, Line 10
Cannot resolve the collation conflict between "Chinese_PRC_CS_AS" and "Chinese_PRC_CI_AS" in the equal to operation.
Please help with this error

 

[john_d]

Msg 468, Level 16, State 9, Procedure WZ_DISCONNECT_MEMB, Line 10
Cannot resolve the collation conflict between "Chinese_PRC_CS_AS" and "Chinese_PRC_CI_AS" in the equal to operation.
Please help with this error

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 = 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

 

[Diabolik]

thx jhon !

 

[kinder32]

this works on 97d?

 

[john_d]

it will since since Mu dev began the database structure has been almost the same.

 

[dannythe]

dont work on 97d ...

 

[xute]

dont work on 97d ...

try deleting all lines from WZ_DISCONNECT procedure and paste:

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 = 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

 

[hydramu]

john can you give me the script referal systen
because in first post you write you use this script to referal system can you give me it? please

 

[kinder32]

doesn't work with 97d db :S its totally diferent from the wz_disconnect_memb of the 97d... :S

 

[DraGoN-GR]

Good Release 10/10

 

[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   [USER=1333416677]Find[/USER]_id varchar(10)    
    Declare  [USER=1333459481]Connects[/USER]tat tinyint
    Set  [USER=1333459481]Connects[/USER]tat = 0     
    Set  [USER=1333416677]Find[/USER]_id = 'NOT'
    select  [USER=1333416677]Find[/USER]_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(  [USER=1333416677]Find[/USER]_id <> 'NOT' )    
    begin        
        update MEMB_STAT set ConnectStat =  [USER=1333459481]Connects[/USER]tat, 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 -

You must be registered to see links

 

[davideguadagno]

[COLOR=#4B4F56]Msg 2714, Level 16, State 3, Procedure WZ_DISCONNECT_MEMB, Line 14There is already an object named 'WZ_DISCONNECT_MEMB' in the database.


[/COLOR]

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 ?