Db memb_stat

[Haarhus]

I need some help , my MEMB_STAT stopped filling when somebody goes online or offline , the data is not recorded so anything connected to online accounts is not working :/ any ideas how to fix that without reisntalling the DB files ?

[MentaL]

[fallenfate]

Are the column names still the same? The one to log online/offline is ConnectStat.

[Haarhus]

Yes , they are the same , nothing has been changed
memb__id varchar 10
ConnectStat tinyint 1
ServerName varchar 50 tick
IP varchar 15 tick
ConnectTM smalldatetime 4 tick
DisConnectTM smalldatetime 4 tick
TotalTime int 4 tick ( custom added for webcounter)

[fallenfate]

Have you been editing any configs or anything lately, or has it just randomly stopped? All I can think of to help is checking the server logs for a message. Are there any that look out of place?

[Haarhus]

only WZ_DISCONNECT_MEMB procedure thats the only thing

[7GNJumper]

go delete old WZ_DISCONNECT_MEMB create new one with same name copy paste this code.

USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_DISCONNECT_MEMB] Script Date: 03.06.2015 11:00:24 ******/
SET ANSI_NULLS OFF
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 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

[Haarhus]

It still doesnt work :/

- - - Updated - - -

i might eventually reinstall it all

- - - Updated - - -

Another problem , after some time the DB stops recording data and when i stop the database server and start it again there is a rollback and the website lags untill the reset happens

[fallenfate]

No idea why any of that is happening besides the server files being buggy, but I've not run into that issue before, so I don't know if that will fix it or if its truly a DB issue. I recommend trying some new files if possible.

[Haarhus]

I will see, anyway , thank you !

[fallenfate]

No worries, I like helping the community, I just wish I knew what the problem you encountered was. Sounds really weird.