Help mee pleas MuOnline Problem

[ImperiusMu]

GameServer Off and i have 3 player online why not 0 ?? ReedLanFiles

 

[whyjustwhy]

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

 

[ImperiusMu]

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

 

[FlipZero]

What file are you using

 

[ImperiusMu]

Reedlan season 3 episode 1

 

[KarLi]

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

 

[ImperiusMu]

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

 

[KarLi]

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

 

[ImperiusMu]

Thanks

 

[LTPTeam]

Maybe some problems in WZ_DISCONNECT_MEMB procedure.

 

[KarLi]

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

CREATE PROCEDURE WZ_CONNECT_MEMB

@uid varchar(20), [USER=412249]Server[/USER] 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 = [USER=412249]Server[/USER] , ConnectTM = (getdate())
WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,ip,connectstat,servername) valueS (
@uid,
@uip,
1, [USER=412249]Server[/USER]
)
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

@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

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