About Character name.

[Samlove143]

Hello Everyone,
I am using A3 Elements Client with Raman's 219 server files & A3 Client hexed to default IP [127.0.0.1]..
I am going to start game on Hamachi..
And when I Create new character, its name can entered like Upper case & Lower case letters anywhere [eg. GhostRider , DarkKnight]

I want to make is like only 1st letter Upper case & others all lower case [eg.Ghostrider , Darkknight]

If anyone know about it Please Reply me !

Thanks.

 

[chrissdegrece]

Make a BEFORE INSERT trigger in DB. Validate the account name as you wish and return OK or ERROR

 

[holy003]

I didnt Understand
Can u Expain plz ?

 

[Samlove143]

Yea, I also didnt get you...
please Explain us..

 

[suruchi_sogano1]

He is talking about making a Database Before Insert Trigger in SQL server.
That will surely, stop users from making new chars with wrong indentation.

But if you wana experiment and do it right, use account server source code and put a check there

 

[lamba6]

Lol from last night me praying for chrissdegrece because there is war in grece but mow i m sure that our friend and helper who always helping us is fine and safe ....:8::8::8:
Cheers for chrissdegrece:::

 

[holy003]

I Love Wars

 

[chrissdegrece]

Thanks guys.

[OffTopic]
Actually it's not war, it's protests & demonstrations cos of IMF loan that Greece got, IMF & his "friends" demanded very very very strict social policies to be applied and this has side effects of unemployment, salaries reductions, benefits retracted etc. So as it's expected people protest for their rights.
[/OffTopic]

 

[cvrdheeraj]

Make a BEFORE INSERT trigger in DB. Validate the account name as you wish and return OK or ERROR

It should be a Constraint. Not a trigger. Trigger can be used to capitalize, but the Account FDB(acl) files would contain the other character name as it was input by the user. That would give a conflict.

Constraint violation will return an error, but a3 server is not designed to process the error. Hence the player get stuck on the character select screen.

The only alternative to this is to modify your Accountserver so that it autocapitalizes and returns errors for invalid Character Names directly without having anything to do with the database.