Creating Custom Character with Money at First Only

08/09/2019 21:18 erasmojosepzo#1
Need help...
I have a code where he creates the first character by adding money, when creating the second he will not have money.
The problem is that by deleting all characters, he adds money back to the first character.
I want only the first character of the account to be added money.
Follows the code:
[usp_Create_Char_R]
ELSE IF @Grow = 3 -- Ultimate mode
BEGIN
SET @Grow = 3
SET @Level = 1
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 0
SET @[Only registered and activated users can see links. Click Here To Register...] = 5

-- Status
IF @Job = 0
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 14
END
ELSE IF @Job = 1
BEGIN
SET @rec = 12
END
ELSE IF @Job = 2
BEGIN
SET @dex = 19
END
ELSE IF @Job = 3
BEGIN
SET @luc = 13
END
ELSE IF @job = 4
BEGIN
SET @int = 15
END
ELSE IF @job = 5
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 14
END

END

SET @CharName = LTRIM(RTRIM(@CharName))
SET @[Only registered and activated users can see links. Click Here To Register...] = 0

SET @Money = 1000000

/* First we declare our variable selecting all of our characters from our specified useruid - making sure the character is alive aswell */
DECLARE @charselect int = (Select COUNT(*) FROM PS_GameData.dbo.Chars WHERE UserUID=@UserUID AND Del=0)
/* Then we say if it has more than one character we will return an error not allowing it to be created. */
IF @charselect > 0
BEGIN
SET @Money = 0
END
08/09/2019 22:39 SnickQ#2
You have to remove Del=0