ALTER PROCEDURE User_UpDate
(
@IP nvarchar(15)
)
As
Declare @User bit
Select @User = Count(*) From AuthUsers Where IPAddress = @IP
If @User = 1 Begin
UpDate AuthUsers Set LastDate = GetDate() Where IPAddress = @IP
End Else Begin
Insert Into AuthUsers(IPAddress, LastDate) Values(@IP, GetDate())
End
Insert Into StayUserTime
Select * From AuthUsers Where LastDate < DateAdd(Minute, -10, GetDate())
Delete From AuthUsers Where LastDate < DateAdd(Minute, -10, GetDate())