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 @
Point = 0SET @
= 5-- Status
IF @Job = 0
BEGIN
SET @
= 14END
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 @
= 14END
END
SET @CharName = LTRIM(RTRIM(@CharName))
SET @
= 0SET @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







