set ANSI_NULLS OFF
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
-- ePoint por ser VIP OURO (Desativado, quem manjar, manipule como desejar)
set dateformat dmy;
set language brazilian;
--IF EXISTS(SELECT memb___id FROM MEMB_VIP WITH (READUNCOMMITTED) WHERE convert(datetime,vip_vencimento) >= getdate() AND vip_on='1' AND vip_plano='1' AND memb___id = @uid )
--Begin
DECLARE @ept int;
select @ept = DATEPART(hh, getdate()-ConnectTM)*2 FROM MEMB_STAT WHERE memb___id = @uid;
UPDATE MEMB_INFO SET CSPoints=CSPoints+@ept WHERE memb___id = @uid;
--print N'HORAS: '+convert(nvarchar(10),@ept); esta dando 5
--End
--Else
--Begin
-- print N'SEM VIP';
--End
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