About Character name.

Printable View

24-02-11
Samlove143

About Character name.

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.
24-02-11
chrissdegrece

Re: About Character name.

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

Re: About Character name.

I didnt Understand :(
Can u Expain plz ?
24-02-11
Samlove143

Re: About Character name.

Yea, I also didnt get you...
please Explain us..
24-02-11
suruchi_sogano1

Re: About Character name.

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 :D
24-02-11
lamba6

Re: About Character name.

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:D::D::D:
25-02-11
holy003

Re: About Character name.

I Love Wars :)
25-02-11
chrissdegrece

Re: About Character name.

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]
03-03-11
cvrdheeraj

Re: About Character name.

Quote:

Originally Posted by chrissdegrece

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.