[Release] Database Total Online Time Mod

Page 3 of 3 FirstFirst 123
Results 31 to 37 of 37
  1. #31
    The truth seeker -_- Dode is offline
    True MemberRank
    Feb 2013 Join Date
    384Posts

    re: [Release] Database Total Online Time Mod

    [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.
    -.-

  2. #32
    High'nLows 19871986 is offline
    True MemberRank
    Sep 2010 Join Date
    istanbulLocation
    809Posts

    re: [Release] Database Total Online Time Mod

    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

  3. #33
    CCCP Mu Owner 15351535 is offline
    True MemberRank
    Sep 2007 Join Date
    Russia/GermanyLocation
    855Posts

    re: [Release] Database Total Online Time Mod

    bad for Season 8 (offtrade) user

  4. #34
    Member KlubZone is offline
    MemberRank
    Jun 2010 Join Date
    Craiova, RomaniLocation
    71Posts

    re: [Release] Database Total Online Time Mod

    Works fine on 97d:D -KlubZone MuOnline 97D
    Last edited by KlubZone; 20-10-15 at 09:59 AM.

  5. #35
    Member davideguadagno is offline
    MemberRank
    Dec 2014 Join Date
    Starcross, UnitLocation
    32Posts

    re: [Release] Database Total Online Time Mod

    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?

  6. #36
    Member diemorko is offline
    MemberRank
    Nov 2015 Join Date
    70Posts

    re: [Release] Database Total Online Time Mod

    Any fix? (Time acumuleted when reconnect)

  7. #37
    Account Upgraded | Title Enabled! cover is offline
    True MemberRank
    Jun 2016 Join Date
    275Posts

    Re: [Release] Database Total Online Time Mod

    Quote Originally Posted by crlfrancis View Post
    there you go
    i just changed OnlineHours to TotalOnline to show in mins
    this is working ?



Page 3 of 3 FirstFirst 123

Advertisement