DECLARE @strNexonID NVARCHAR(64) = 'ashlay'; -- Replace with actual value
DECLARE @strPassword NVARCHAR(128) = 'test';
DECLARE @strEmail NVARCHAR(200) = '[email protected]';
-- Ensure required values are not NULL
IF @strNexonID IS NULL OR @strPassword IS NULL OR @strEmail IS NULL
BEGIN
PRINT 'Error: strNexonID, strPassword, and strEmail cannot be NULL.';
RETURN;
END
INSERT INTO CBT_UserAuth (
strNexonID,
strLNexonID,
strPassword,
strEmail,
bIsMailActive,
BlockStartDate,
BlockEndDate,
RegDate,
strLastMacAddress,
strLastLoginIP,
strLastHWID
)
VALUES (
@strNexonID, -- Original Nexon ID
LOWER(@strNexonID), -- Lowercase Nexon ID for consistent lookups
--HASHBYTES('SHA1', @strPassword), -- Hashed password
@strPassword, -- If the password SHA1 is disabled
@strEmail, -- Email address
1, -- Email not active initially
NULL, -- No block start date
NULL, -- No block end date
GETDATE(), -- Registration date
NULL, -- Last MAC address (not set yet)
NULL, -- Last login IP (not set yet)
NULL -- Last HWID (not set yet)
);