Change character name 5165

[.Kob]

Where he says that in his first post -_-

[DePredaTe]

It didn't work?

[alexhaes]

Yes thanks for all the help
First change it in /accounts and then in the database itsself
You could combined those 2 in your reply but after reading them both i did understand

Thank you people so much

[BlueFlame11]

Originally Posted by kinshi88

If they're using Flat file, first of they fail hardcore.
Second off, make a program to read the files =D

Pleas explain why they fail? Cause i use flat file.
Make your statement and i might make mine

[DePredaTe]

Alright, what he meant by "database" I THINK he meant the Character folder.

So:
1st. Start up your server
2nd. In the console type /accounts
3rd. Find the account in the drop box or search the account by name
4th. Change the name to whatever you want it in the Character field
5th. Click save
6th. Go to your character folder in OldCODB
7th. Change the file name from the old character name to the new character name
8th. Log on to the account

[kinshi88]

Originally Posted by BlueFlame11

Pleas explain why they fail? Cause i use flat file.
Make your statement and i might make mine

Alright, lets give an example.
Say you have 2000 flat files, each containing info for various monsters.
Then lets say that you wanted to make monsters now have a "LoveRating" (Lulz), you would have to make an entirely new program to change each of them!
Scalability is easy with a MySql Database, click click done; synchronized!

Convenience, simplicity of design, portability and easy management of content data.

But yes, flat files are great for in a lot of cases, but imho, a MySql database is the optimal option for a private server.

[BlueFlame11]

Originally Posted by kinshi88

Alright, lets give an example.
Say you have 2000 flat files, each containing info for various monsters.
Then lets say that you wanted to make monsters now have a "LoveRating" (Lulz), you would have to make an entirely new program to change each of them!
Scalability is easy with a MySql Database, click click done; synchronized!

Convenience, simplicity of design, portability and easy management of content data.

But yes, flat files are great for in a lot of cases, but imho, a MySql database is the optimal option for a private server.

O.O Okay but i still like flat file + you can make a server tool to do all that for you ;O

[kinshi88]

Originally Posted by BlueFlame11

O.O Okay but i still like flat file + you can make a server tool to do all that for you ;O

Oh I'm not saying you can't. MySql is just better for this sort of thing.

[Arcо]

Originally Posted by cakobu

It's like talking to a 5 years old child. Well, how old are you?

Originally Posted by alexhaes

Yes thanks for all the help
First change it in /accounts and then in the database itsself
You could combined those 2 in your reply but after reading them both i did understand

Thank you people so much

Looks like I was right.

[pro4never]

Originally Posted by BlueFlame11

O.O Okay but i still like flat file + you can make a server tool to do all that for you ;O

Personally I feel flat files should only apply to things that won't be changing often.

The obvious would include things like portals, items, composition info, base monsters, maybe monster spawns, guilds (depending on how you structure your guild system/database). Things that you won't care to add new fields to often and won't need large numbers of entries.

Personally I would find it a complete pain to have to write a program to re-write every single created entry/file simply to add a new field.

Anything like accounts, characters, character items and things along those lines are just infinitely easier to do using sql...

If you get a problem with certain data, run a sql query. If you want to add something new (character tables are prime examples.. I've added so many new fields for different things!) it's a simple matter of a few clicks. Same with the in source side. Sql queries (while I admit, it's what I'm used to) is so much simpler. You run your command and your data is then there which you can organize however you want in your server structures.



Anyways, back on topic I suppose seeing as everyone has their own preference. Flatfiles are perfectly fine depending on if you know what you are doing and are comfortable working with them... personally I'm just not.

@ Thread:

Sounds like it's been answered. Depending on how easy you want name change to be on your server, you may want to write a new script to load up the character flatfile and change everything properly in that... the problem I see there though is searching through all the other character files to ensure the name isn't already taken.. (another reason why I like sql lol, all the data is right there without all sorts of fuss).

You should be able to run a check for other chars with that name, modify it in both the account files and the character ones (as account is linked to character. changing character name and not the account file will make it not know what character to point to... aka not being able to log). Then either disconnect the client or (I THINK) you can change it while logged in by removing and re-spawning the client (Not sure on that though, never done it)


Best of luck. Hopefully you get everything working.

[DePredaTe]

Yeah, with SQL database you can make a character name change as an NPC option.
I'm not sure if you can with the flat files because it requires for a file name to be changed. I would have no idea how to do that.

if it was just a one time thing then, its not worth the switch.