I've been lurking around these forums for awhile and have been seeing a lot of different things going on. For starters, KP, for one guy running this server you are doing one hell of a job. Yes, the disconnections get frustrating sometimes, but that's the way private servers go. Now for the thought that crossed my mind... I think that you should make a character creation limit for every registered member on your server. Maybe 3 per person. It may cut down on data storage for you. But hey, I'm no expert on running a private server so don't blast me.

P.S. Keep the good work up KP, it's so hard to find a good private server.

you mean theres only 1 guy doing this server!!! wow i can barley run a simple game on the internet take all the time you need

Yeah, 1 guy from what I've been reading, so everyone needs to be nice and respectful to KP.

KP is doing a great job and he deserves respect sure the Getting Disconnected is frusturating but being by himself.... he is doing a hell of a job keep it up

Yeah he IS doing a great job. But no one has said anything about my suggestion... oh well. I guess I'll post it later or something on a new thread.

dude he could work for blizzard they got like 20 people per realm he would be like every1 boss

lol thanx, its a good idea but no way to implement it yet, I will see if any way can be figured out.

Shew, take away the mobs ability
to path
(they don't really deserve to path, do they?)

.. bump the server limit a bit..

(and, as always, my plug to temporarily disable account creation until stability is achieved)

Having never seen what the tables for character look like in the database, I can't say for certain what the data structure is like and how much of a data hit each character makes.

But I'd be kind of iffy on this.

As far as I can tell just from playing and limited experience with db's, the only time a player's full character list is hit, is when the account holder log's in, or when mail is sent to a character not currently logged in.

Although, now that I think about it, if each person had a full 10 characters on their account, and there's (for simple math's sake) 1,000 registered accounts, there'd be 10,000 entries for the database to look through if (and I doubt this) they go through entry by entry.

However, the easier way to do this, would simply be to construct the SQL statement to look for a specific String (typically a word or phrase, through it can also be a number), in this case a character name, then simply assign that character entry the value for having mail.

Now, all of this is without having seen any of the the EMU code for the server, so I'm really no expert and KP could probably give a better information on this subject.

Ultimately, it'd cut down on the data stored. I'm not sure though, how much bandwidth it'd free up though.

not about bandwidth, mysql db space is a lot more important, with a 20/2.5 connection bandwidth issues are on the back burner for me, mysqlhowever eats ram like fat kid eats cake (50 cent (dont like rap? tough, i live in brooklyn I dont have a choice)) so cutting back on mysql DB space is a lot more important. for example I cannot name the MMORPG due to NDA reasons but recently a major MMO stop golding players items for them in temp storage on death just to reduce one table from their DB's! (now the itme sstay on the player so he has them soon as he spawns, whereas before he would have to goto a closeby drop on respawn and pick up the items again.)