About Character Creation

[[GameAdvisor]Finn]

Hi epvp, may i know if it is possible to disable multiple create character?
i mean if it is possible to make 1 character only per account..
thanks and advance if someone answering my question.

[JuuF]

Yeah, it is actually very easy. Edit create_char_r procedure and make it return an error when there is an alive character.

[[GameAdvisor]Finn]

Originally Posted by JuuF

Yeah, it is actually very easy. Edit create_char_r procedure and make it return an error when there is an alive character.

Thank you sir JuuF
but can you tell me what i need to do exactly? thanks

[Velocity.]

Originally Posted by [GameAdvisor]Finn

Thank you sir JuuF
but can you tell me what i need to do exactly? thanks

He told you exactly what you need to do, Writing SQL is very very easy.

Just try to do something like this and I Hope that you learn from it for next time.

 Spoiler

/* First we declare our variable selecting all of our characters from our specified useruid - making sure the character is alive aswell */
DECLARE @elect 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 @elect > 0)
BEGIN
RETURN -2
END