Create account and Auto-create char

[ES3N1N]

Hello World!

I want to make a function so that when creating an Account, a character is auto created.
I created a function, and a "Nickname" column in Accounts.
https://pastebin.com/NHxXAtGJ

this not work

DECLARE @in_Gamertag nvarchar
    IF(@in_NickName = @in_Gamertag) 
BEGIN
        SET @in_NickName = @in_Gamertag
        UPDATE UsersChars SET Gamertag=@in_Gamertag WHERE CustomerID [MENTION=25895]Custom[/MENTION]erID
    END 

this not work

-- get new Char
    declare @in_Gamertag varchar
    SELECT @in_NickName, [MENTION=25895]Custom[/MENTION]erID from UsersChars as Gamertag
    exec UsersChars set @in_NickName=@in_Gamertag as CustomerID [MENTION=25895]Custom[/MENTION]erID 

[MentaL]

[LukasCCB]

Open function

WZ_ACCOUNT_CREATE

Before return, add this

--Create first char
DECLARE @MyCharName VARCHAR(128) = LEFT(@in_Email, 8); --Get 8 frist caracters of email to put on Char Name    
exec FN_AddItemToUser @CustomerID, 20174, 2000 --Give Character to account    
exec WZ_CharCreate @CustomerID, 0, @MyCharName, 20174, 0, 2, 2 --Create first character to account

Be happy!

[ES3N1N]

Open function

WZ_ACCOUNT_CREATE

Before return, add this

--Create first char
DECLARE @MyCharName VARCHAR(128) = LEFT(@in_Email, 8); --Get 8 frist caracters of email to put on Char Name    
exec FN_AddItemToUser @CustomerID, 20174, 2000 --Give Character to account    
exec WZ_CharCreate @CustomerID, 0, @MyCharName, 20174, 0, 2, 2 --Create first character to account

Be happy!

this is wonderful! I love you brother!