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.

You must be registered to see links

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 [USER=25895]Custom[/USER]erID
    END

this not work

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

 

[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 @[I][B][URL="https://forum.ragezone.com/members/25895.html"]Custom[/URL][/B][/I]erID, 20174, 2000 --Give Character to account    
exec WZ_CharCreate @[I][B][URL="https://forum.ragezone.com/members/25895.html"]Custom[/URL][/B][/I]erID, 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 @[I][B][URL="https://forum.ragezone.com/members/25895.html"]Custom[/URL][/B][/I]erID, 20174, 2000 --Give Character to account    
exec WZ_CharCreate @[I][B][URL="https://forum.ragezone.com/members/25895.html"]Custom[/URL][/B][/I]erID, 0, @MyCharName, 20174, 0, 2, 2 --Create first character to account

Be happy!

this is wonderful! I love you brother!

 

[SEEK3R]

I'm learning SQL. Can you please walk me through on how I process this?

 

[ES3N1N]

I'm learning SQL. Can you please walk me through on how I process this?

this is a function for automatic character creation. If you are using 1 character in your game with no option to delete then this feature is for you.