Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Top online module?

Status
Not open for further replies.
Experienced Elementalist
Joined
Apr 23, 2015
Messages
237
Reaction score
20
any top online module here I can use?
I saw modules but links are dead and it's not also working.
please.
 
Experienced Elementalist
Joined
Apr 23, 2015
Messages
237
Reaction score
20
which error u get on 2009x2014 module
I finally make it work using the query
but in the module it seems it's not recording the online hours.
it is still 0.
i was afk at lorencia for 1 hour and it didn't count.

so this is my WZ_DISCONNECT_MEMB
Code:
USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_DISCONNECT_MEMB]    Script Date: 02/11/2016 09:55:15 ******/
SET ANSI_NULLS ON
GO
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, TH = 
TH+(DATEDIFF(hh,ConnectTM,getdate())) WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,DisConnectTM,connectstat,TH) valueS (
@uid,
(getdate()),
0,
0
)
End




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


SET NOCOUNT OFF
End
 
Upvote 0
Experienced Elementalist
Joined
Apr 23, 2015
Messages
237
Reaction score
20
Upvote 0
Joined
May 26, 2009
Messages
17,279
Reaction score
3,203
nope he aint here.

try to drop memb_stat (delete that table)
and re-create with this query
Code:
USE [MuOnline]
GO

/****** Object:  Table [dbo].[MEMB_STAT]    Script Date: 02/11/2016 22:28:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[MEMB_STAT](
	[memb___id] [nvarchar](10) NOT NULL,
	[ConnectStat] [tinyint] NULL,
	[ServerName] [nvarchar](20) NULL,
	[IP] [nvarchar](15) NULL,
	[ConnectTM] [smalldatetime] NULL,
	[DisConnectTM] [smalldatetime] NULL,
 CONSTRAINT [PK_MEMB_STAT] PRIMARY KEY CLUSTERED 
(
	[memb___id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[MEMB_STAT] ADD  CONSTRAINT [DF_MEMB_STAT_ConnectTM]  DEFAULT (getdate()) FOR [ConnectTM]
GO

ALTER TABLE [dbo].[MEMB_STAT] ADD  CONSTRAINT [DF_MEMB_STAT_DisConnectTM]  DEFAULT (getdate()) FOR [DisConnectTM]
GO

might work cus works here.
 
Upvote 0
Experienced Elementalist
Joined
Apr 23, 2015
Messages
237
Reaction score
20
nope he aint here.

try to drop memb_stat (delete that table)
and re-create with this query
Code:
USE [MuOnline]
GO

/****** Object:  Table [dbo].[MEMB_STAT]    Script Date: 02/11/2016 22:28:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[MEMB_STAT](
    [memb___id] [nvarchar](10) NOT NULL,
    [ConnectStat] [tinyint] NULL,
    [ServerName] [nvarchar](20) NULL,
    [IP] [nvarchar](15) NULL,
    [ConnectTM] [smalldatetime] NULL,
    [DisConnectTM] [smalldatetime] NULL,
 CONSTRAINT [PK_MEMB_STAT] PRIMARY KEY CLUSTERED 
(
    [memb___id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[MEMB_STAT] ADD  CONSTRAINT [DF_MEMB_STAT_ConnectTM]  DEFAULT (getdate()) FOR [ConnectTM]
GO

ALTER TABLE [dbo].[MEMB_STAT] ADD  CONSTRAINT [DF_MEMB_STAT_DisConnectTM]  DEFAULT (getdate()) FOR [DisConnectTM]
GO

might work cus works here.

what PHP did you use for this?
 
Upvote 0
Joined
May 26, 2009
Messages
17,279
Reaction score
3,203
i use on my template .php this :

Code:
<li><spa style="color: Red; text-shadow: 0 0 5px #FF0000;">»</spa> Server: <span><? if ($check=@fsockopen($onlineoffline,$srvport,$ERROR_NO,$ERROR_STR,(float)0.5)) <li>
so it reads from another .php which is :
Code:
$Sdaaq = mssql_query("SELECT count(*) FROM MEMB_STAT WHERE ConnectStat = '1'");	 
$online= mssql_result($Sdaaq, 0, 0);
 
Upvote 0
Experienced Elementalist
Joined
Apr 23, 2015
Messages
237
Reaction score
20
i use on my template .php this :

Code:
<li><spa style="color: Red; text-shadow: 0 0 5px #FF0000;">»</spa> Server: <span><? if ($check=@fsockopen($onlineoffline,$srvport,$ERROR_NO,$ERROR_STR,(float)0.5)) <li>
so it reads from another .php which is :
Code:
$Sdaaq = mssql_query("SELECT count(*) FROM MEMB_STAT WHERE ConnectStat = '1'");     
$online= mssql_result($Sdaaq, 0, 0);

It's working now KarLi #15 post gave me a hint.
Thanks a lot!
 
Upvote 0
Status
Not open for further replies.
Back
Top