How will character names be handled?

[Softcore PK]

I'd like for us to be able to keep the characters we make on beta, just have them reset as brand new at release.

[Bazooka]

If you want a name go reserve it on p99,

if you already did then you're good to go.

[bakkily]

so someones using tells from me as a signature, i dont feel offended

[Forestdweller]

That's funny. I didn't even read his sig till you said something.

[bakkily]

the thing that happend, so main char im playing is a ogre shaman, but decided to help my lvl quicker by boxing a monk, but my monk dies and is back at freeport, so i see this other monk killing stuff, i was lvl 5 on my toon, this other was 3, so i go attack him, and not doing any form of eq pvp prior to playing here, i totally sucked, and so bazooka is chilling there killing/camping this lvl 5 mage for hours, and he starts to go after me, at first when he attacked me, i went to run to inspect him, but he he must've been thinking i was going to attack him, nothing twords him there, so he roots, and blinds, roots and blinds having fun, hours after that, every time he sees my char, he keeps pking me, im thinking shit, man, you're 10 lvls higher then me, so how can i be on par with you pvp wise, but yea bad on my part sending angry tells, but what ever, lets pvp

[lindz]

I was definitely able to create a name on Red99 that is not saved on my account on P99 (and is in use by someone on P99) so I don't think this is in yet.

Will this be true at some point in the future? Just disabled for beta or something?

[vinx]

Im pretty sure R99 will be a seperate NEW server.. all names open
So saving names on P99 and beta for R99 is futile

just be quick when server launches

[Xatava]

decided to help my lvl quicker by boxing a monk,

ban plox

[XiakenjaTZ]

you can box during beta on red99

[lindz]

Im pretty sure R99 will be a seperate NEW server.. all names open
So saving names on P99 and beta for R99 is futile

just be quick when server launches

Rogean already stated that the names saved on P99 accounts will be saved for those accounts on Red99. This just isn't the case right now. Not sure why that is though.

[Rushmore]

If you want a name go reserve it on p99,

if you already did then you're good to go.

I saved your life the other day.

[Bazooka]

I saved your life the other day.

http://t3.gstatic.com/images?q=tbn:ANd9GcRDAuyj5Xfsi4S9VSGzIMefyu5zFlO_s NfiHqpb8JKdSQ9eCkrLwg

[Rogean]

System has been in place since the start of beta and will be in place for the live launch. You are missing the details of this system though, such as the last time online check.

[Softcore PK]

Thanks :)

[lindz]

What if I was able to get a name on Red but it is already taken on Blue?

The account that owns the name on blue hasn't logged in since the last time online check so the name is open to use I would assume from Rogean's post.

[L1ch]

Phew. Let's hope so then.

[Rogean]

if (RuleB(Server, CharnameFederation)) {
MYSQL_RES *result;
MYSQL_ROW row;
if (!RunQuery(query, MakeAnyLenString(&query, "SELECT a.id, a.account_id, a.timelaston, UNIX_TIMESTAMP(), b.status, b.banned, b.suspended FROM character_fed a left outer join account b on b.id = a.account_id WHERE a.name = '%s'", name), errbuf, &result)) {
cerr << "Error in Char Federation query '" << query << "' " << errbuf << endl;
} else {
if ((row = mysql_fetch_row(result))) {
if (atoi(row[0]) > 0 && atoi(row[1]) != account_id && (atoi(row[3]) - atoi(row[2]) < 7257600 || atoi(row[4]) || atoi(row[5]) || atoi(row[6]) > atoi(row[3]))) return false;
}
mysql_free_result(result);
}
safe_delete_array(query);
}

[L1ch]

I don't speak SQL :confused:

[Atmas]

84 days?

[Softcore PK]

the 84 days seemed to be part of an equation though..
(i know nothing about sql)

[Knuckle]

System has been in place since the start of beta and will be in place for the live launch. You are missing the details of this system though, such as the last time online check.

thanks rogean, so if 'knuckle' hasn't been online in YEARS ill be able to get my name? awesome.

[Atmas]

the 84 days seemed to be part of an equation though..
(i know nothing about sql)

The code is looking for an existing account row with certain properties.

There is a comparison on these values "a.timelaston, UNIX_TIMESTAMP(),". I can assume by name a.timelaston is last login time and the UNIX_TIMESTAMP() is a current time stamp (what ever the time is when caled). I don't use MySQL. The function is subtracting the last login from the current time to see if the value is bigger than 84 days. Time is often stored in DBs as an incrememt of units from some starting point.

The "7257600" value I just made a guess was seconds cause other formats like milliseconds were impractical.

/60 = 120,960 minutes
/60 = 2016 hours
/24 = 84 days

I could be wrong, I'm making a couple of assumptions.

Edit for more clarifciation: The function is basically doing other checks on the status of the account (if it exists) to return a value as to whether or not you can create a character with this name. They include if an account is banned if and if it's the same account using that name.

[Atmas]

thanks rogean, so if 'knuckle' hasn't been online in YEARS ill be able to get my name? awesome.

Funny enough I created a Knuckle on Beta to mess with you but I havent played on the toon. I won't be creating it when server goes live and can delete the one I made if you want it.

[Rogean]

I like pasting code and letting people try to interpret it. I should do it more often.

[Atmas]

I like pasting code and letting people try to interpret it. I should do it more often.

R I am right?

[Softcore PK]

lol

[L1ch]

AMEN