little register bot solution

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.Users_Master ADD
LoginStatus int NULL
GO
ALTER TABLE dbo.Users_Master ADD CONSTRAINT
DF_Users_Master_LoginStatus DEFAULT ((0)) FOR LoginStatus
GO
ALTER TABLE dbo.Users_Master SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

IF @[Only registered and activated users can see links. Click Here To Register...]Type = 107
BEGIN
Update PS_UserData.dbo.Users_Master Set LoginStatus=1 Where UserUID=@UserUID
END

SELECT UserUID
into #UserUIDs
FROM [PS_UserData].[dbo].[Users_Master]
where LoginStatus = 0

delete
from PS_UserData.dbo.Users_Master
where LoginStatus=0

drop table #UserUIDs