Life is Feudal Official Forum

[Nopsi]

Hiya,

i would like to know if its possible to setup a server somehow that you can only have one character and not multiple alts?

Thanks alot

[Capndudeguy]

It depends on the skill cap set by the server. The higher the skill cap is set to the more skills you can learn

[Capndudeguy]

On a single character that is

[Uno]

From what I read he asked how to set up the SERVER in order to limit one pc per account.

[Maegfaer]

It is possible, give the Account column in the Character table the Unique constraint.

Did it on my modded server as well:

post29315/#p29315

[Capndudeguy]

Sorry I misread

[Chessmaster42]

I wonder then if it's possible put a different foreign key constraint on the characters table so that we could limit it to an arbitrary number of characters instead of either 1 or unlimited as it is now.

For the most part I am in favor of 1 character per account but currently my server has a low pop so we've been allowing 2 per account and tonight I'm planning on doing some SQL work and am curious if anyone has found any other way than forcing the account id foreign key column to be unique (which works by the way so kudos for that )

[Nopsi]

It is possible, give the Account column in the Character table the Unique constraint.

Did it on my modded server as well:

post29315/#p29315

thank you! Could you maybe explain that a little bit more? at your post you dont realy explain what or how you did that.

[Maegfaer]

From PM:

How or where can i find this?

I am searching at the directorys but cant find anything[/url]

These changes need to be done in the SQL database. It should be possible to do this with HeidiSQL I think, somehow. I use dbForge Studio myself.

You could try adding this to the patch.sql file in the sql folder in your dedicated server directory:

ALTER TABLE `character`
ADD UNIQUE(AccountID);

No guarantees that it works though, haven't tested it. Else try it through the SQL shell.

[HydroxTV]

Made a video for that:

[youtube]XsvQiYCNDgg[/youtube]

[Mighty7788]

Is there a chance to only allow 1 character and for some trusted peeps a second or third?

Even if you are GM you might need some more NPCs


Using dedicated standalone + MAriaDB

[Vamyan]

Yes. There are instructions in this post: character-count-limiter-t4718/

Of course, you may need to add some conditions, but the basics are there.

[Mighty7788]

doesnt work for me .. maybe because im a SQL roockie /