DECLARE @name varchar(18)
DECLARE @pw varchar(12)
DECLARE @uid int
SET @name = 'trecasim2' -- Maximal 18 Zeichen
SET @pw = 'hastdubrot' -- Maximal 12 Zeichen
SELECT @uid = Max(UserUID) FROM PS_UserData.dbo.Users_Master WHERE UserUID = UserUID
SET @uid = @uid + 1
INSERT INTO PS_Userdata.dbo.Users_Master VALUES(@uid, @name, @pw, getdate(), 0, 1, 0, 0, 0, '01.01.2022 00:00:00', 1, NULL, NULL, NULL, 1, NULL, NULL)
INSERT INTO OMG_GameWeb.dbo.GameAccountTBL VALUES(@uid, @name, @pw, '01.01.2032 00:00:00', 'ff', getdate())
UPDATE [PS_UserData].[dbo].[Users_Master]
SET UserType= 'A'
WHERE UserType= '1'