little register bot solution

[[DEV]Elessar]

hey
I found this solution after a problem,

Users_master adding this table

 Spoiler

/* 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

We make loginstatus 1 to see that the account has entered the game

 Spoiler

IF @Type = 107
BEGIN
Update PS_UserData.dbo.Users_Master Set LoginStatus=1 Where UserUID=@UserUID
END

and we delete accounts with loginstatus 0

 Spoiler

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

here you can add it as windowsa operation to do this automatically.write for better solutions

[sominus]

You mean people who create accounts but never use them?
Isn't LeaveDate = Null or UserIP = Null useful to find that?

[[DEV]Elessar]

it is not possible because everything is random 1 IP per account and 100 accounts per second

[[DEV]Elessar]

v2 can be passed v3 i don't know