any top online module here I can use?
I saw modules but links are dead and it's not also working.
please.
any top online module here I can use?
I saw modules but links are dead and it's not also working.
please.
show me links of dead modules.. ill find u working links.
For website?
For what website? Mucor? Enemy Mu Web? DMN?
HERE
You've got the download link and all the necessary information.
So where is the problem? What it does or does not do?
Describe your problem
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
some threads that had similar issues that can help you.
http://forum.ragezone.com/f197/mucor...module-928874/
http://forum.ragezone.com/f82/mucore...6/#post7037916
http://forum.ragezone.com/f82/onlinehours-901634/
http://forum.ragezone.com/f82/fix-me...3/#post8200623
nope he aint here.
try to drop memb_stat (delete that table)
and re-create with this query
might work cus works here.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
i use on my template .php this :
so it reads from another .php which is :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>
Code:$Sdaaq = mssql_query("SELECT count(*) FROM MEMB_STAT WHERE ConnectStat = '1'"); $online= mssql_result($Sdaaq, 0, 0);
awesome m8!
Sent from my iPhone.