MuCore top online module / not working

[badboy_style]

Dear Ragezoner's,

so, i ve installed module TOP ONLINE, themselfe module is working but importent thing is that id does not show online hours played by gamer.

your kind help will be appraciated.

To view the content, you need to sign in or register

screenshots here:

 

[badboy_style]

any idea?

 

[jacubb]

What database you use? Maybe you don't have column for counting online hours.

 

[badboy_style]

What database you use? Maybe you don't have column for counting online hours.

thank for your reply,

i am using http://forum.ragezone.com/f197/server-files-season-6-100-a-792584/ this pack.

 

[AncestraL]

that module never worked for me

 

[barry952]

The module dose work..You just have to make sure you have OnlineHours in your memb_stat and trigger set

 

[badboy_style]

The module dose work..You just have to make sure you have OnlineHours in your memb_stat and trigger set

a little guide will be great for me, thks in advance.

 

[jacubb]

Try this. Just put all in SQL Query and run (not all at once).

ALTER TABLE dbo.MEMB_STAT ADD MinutesOnline int NOT NULL CONSTRAINT DF_MEMB_STAT_MinutesOnline DEFAULT 0

Use MuOnline

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[WZ_CONNECT_MEMB]
@uid varchar(10),
@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,ConnectTM) valueS (@uid,@uip,1,@server,(getdate()))
End

IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

SET NOCOUNT OFF
End

Use MuOnline

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON

GO
ALTER PROCEDURE [dbo].[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 , MinutesOnline = MinutesOnline+(DATEDIFF(mi,ConnectTM,getdate())) WHERE memb___id = @uid
UPDATE Character SET cLevel = 400 , MapNumber = 40, MapPosX = 225, MapPosY = 25, MapDir = 1, PkTime= 0 Where CtlCode = 32 And AccountID = @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