Need Help Add TotalHours in Stored Procedures
I'm using MMT Season 2 Database and would like to add the TotalHours (TH) table and stored procedure but I don't know which part should I add the query from 4Funer.
Code:
, TH = TH+(DATEDIFF(mi,ConnectTM,getdate()))
Here is my WZ_DISCONNECT_MEMB from MMT Season 2 released DBase
Code:
CREATE 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
GO
Re: Need Help Add TotalHours in Stored Procedures
Why dont make with a simple PHP query and cron?