Help mee pleas MuOnline Problem

Results 1 to 11 of 11
  1. #1
    Member ImperiusMu is offline
    MemberRank
    Jan 2014 Join Date
    50Posts

    Help mee pleas MuOnline Problem

    Help mee pleas MuOnline Problem
    GameServer Off and i have 3 player online why not 0 ?? ReedLanFiles


  2. #2
    Newbie whyjustwhy is offline
    MemberRank
    Nov 2020 Join Date
    2Posts

    Re: Help mee pleas MuOnline Problem

    If you closed the game server while there were players connected, it will show that number of players connected even if they are not.

  3. #3
    Member ImperiusMu is offline
    MemberRank
    Jan 2014 Join Date
    50Posts

    Re: Help mee pleas MuOnline Problem

    yes. i started the server and 3 player on but dont have player on .... sry for english

  4. #4
    Member FlipZero is offline
    MemberRank
    Jul 2015 Join Date
    57Posts

    Re: Help mee pleas MuOnline Problem

    What file are you using

  5. #5
    Member ImperiusMu is offline
    MemberRank
    Jan 2014 Join Date
    50Posts

    Re: Help mee pleas MuOnline Problem

    Reedlan season 3 episode 1

  6. #6

    Re: Help mee pleas MuOnline Problem

    we dont understand your issue .... if u want to be sure all players are off then close all MU applications, why not?

  7. #7
    Member ImperiusMu is offline
    MemberRank
    Jan 2014 Join Date
    50Posts

    Re: Help mee pleas MuOnline Problem

    the game is closed, but the players stayed in it. if I start, just show that they stayed inside.

    Demo.
    Server off but i have online players...

  8. #8

    Re: Help mee pleas MuOnline Problem

    check database > muonline tables> memb_stat and change all to 0 if thats what u mean

  9. #9
    Member ImperiusMu is offline
    MemberRank
    Jan 2014 Join Date
    50Posts

    Re: Help mee pleas MuOnline Problem

    Thanks

  10. #10
    LTP-Team.com LTPTeam is offline
    True MemberRank
    Feb 2013 Join Date
    UkraineLocation
    535Posts

    Re: Help mee pleas MuOnline Problem

    Maybe some problems in WZ_DISCONNECT_MEMB procedure.

  11. #11

    Re: Help mee pleas MuOnline Problem

    u can modify both stored procedures in ur database/muonline/programmibility/stored procedures/ find

    or delete the procedure simply and re-run this this script (backup database better before)

    WZ_CONNECT_MEMB
    Code:
    CREATE PROCEDURE WZ_CONNECT_MEMB
    
    @uid varchar(20), @Server varchar(20),
    @uip varchar(20)
    AS
    
    Begin
    
    BEGIN TRANSACTION
    
    SET NOCOUNT ON
    
    IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED)
    WHERE memb___id = @uid )
    Begin
    UPDATE MEMB_STAT
    SET ip = @uip , connectstat = 1 , servername = @Server , ConnectTM = (getdate())
    WHERE memb___id = @uid
    End
    ELSE
    Begin
    INSERT INTO MEMB_STAT ( memb___id,ip,connectstat,servername) valueS (
    @uid,
    @uip,
    1, @Server
    )
    End
    
    
    IF(@@Error <> 0 )
    ROLLBACK TRANSACTION
    ELSE
    COMMIT TRANSACTION
    
    SET NOCOUNT OFF
    End
    GO
    SET QUOTED_IDENTIFIER OFF
    GO
    SET ANSI_NULLS ON
    GO
    
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_NULLS OFF
    GO
    WZ_DISCONNECT_MEMB
    Code:
    @uid varchar(20)
    AS
    Begin
    
    BEGIN TRANSACTION
    
    SET NOCOUNT ON
    
    IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED)
    WHERE memb___id = @uid )
    Begin
    UPDATE MEMB_STAT
    SET DisConnectTM = (getdate()), connectstat = 0 WHERE memb___id = @uid
    End
    ELSE
    Begin
    INSERT INTO MEMB_STAT ( memb___id,DisConnectTM,connectstat) valueS (
    @uid,
    (getdate()),
    0
    )
    End
    
    
    IF(@@Error <> 0 )
    ROLLBACK TRANSACTION
    ELSE
    COMMIT TRANSACTION
    
    SET NOCOUNT OFF
    End
    GO
    SET QUOTED_IDENTIFIER OFF
    GO
    SET ANSI_NULLS ON
    GO

    also fix memb_stat by deleteing the table completely
    database>muonline>tables>memb_stat right click delete and re-run this query
    Code:
    CREATE TABLE [dbo].[MEMB_STAT] (
    [memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [ConnectStat] [tinyint] NULL ,
    [ServerName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [IP] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
    [ConnectTM] [smalldatetime] NULL ,
    [DisConnectTM] [smalldatetime] NULL
    ) ON [PRIMARY]
    GO
    i hope it helps



Advertisement