Deleted Characters Being Reviewed

You are severely over-estimating their design. It's been leaked more than once, go look at it, or at the queries that were dumped from the client.

I'll take your word for it and wouldn't be surprised. rofl. Someone also mentioned date_of_first_completed_quest; this would work too (if there is such a column).

I'll take your word for it and wouldn't be surprised. rofl. Someone also mentioned date_of_first_completed_quest; this would work too (if there is such a column).

It's not a column, it'd be a join, and only works if they've actually done quests, which aren't required to get out of newbieness depending on the class you've picked and whether the character was created using the NX create-a-character item or the other create a character method they had.

that's just as bad.

Not nearly.
First of all, by changing the timeframe from seven months to 3 weeks, you're already saving at least 90% of the innocents from any harm at all.
Second, by setting up the automated checks, unbans should happen fairly quickly. (I'd have put these checks in the initial ban script, but Nexon is known for a "Kill them all, God will know His own" attitude. Also I've heard horrible things about their database efficiency. Checking those things for every single skill-getter in the time-frame, when the vast majority of them are, in fact, hack-UAs, would lengthen the maintenance unnecessarily.) The people who would need to submit screen-prints and have a human examine their case are only those who created a UA and deleted its KoC within the past few weeks. I seriously doubt there are more than a handful of them.

And of course, the most important bit, is banning instead of deleting. Whoever thought up the brilliant notion of deleting, especially coupled with the seven-month timeframe, is... *facepalm*

did these hacked UA's get the special successor medal?

And of course, the most important bit, is banning instead of deleting. Whoever thought up the brilliant notion of deleting, especially coupled with the seven-month timeframe, is... *facepalm*

Giving them a very minor benefit of the doubt here, I want to believe they did it to prove they will take a harder stand on abuse and nothing is harder than deleting... I just think they picked a very bad point to try to make it.

did these hacked UA's get the special successor medal?

Yes, except it says "Cygnus' successor" instead of a specific character name.
Also, read some comments about some of them escaping deletion by throwing that medal away. No idea whether that is true.

It's not a column, it'd be a join

How would date_of_first_completed_quest be a join? Create_date, update_date - These are all columns in a database as would date_of_first_completed_quest be whether or not it exists, rationally. They are not referred to as joins by DBAs/coders. Where are you getting your information from?

It is already understood that with Nexon's flawed database design, there wouldn't be as thorough a SQL solution as with a competent database. So this solution which we came up with so far (which, you know, should've been implemented in the first place instead of a full-on Delete) does it's job for the most part - it ends the characters with the illegal hair/face/job and bans their account.

Yes, except it says "Cygnus' successor" instead of a specific character name.
Also, read some comments about some of them escaping deletion by throwing that medal away. No idea whether that is true.

Wrong. They get one and it says the character name that the UA was created on. It could be created on a Lvl 1 and it would have that name until the Lvl 1 is deleted.

Giving them a very minor benefit of the doubt here, I want to believe they did it to prove they will take a harder stand on abuse and nothing is harder than deleting... I just think they picked a very bad point to try to make it.

Very, very bad point.

Banning an entire account is a much more severe punishment than deleting a two-week-old level 50 mule created for shyts, giggles, and the gfa60 quest.
The only reason deletion hit people so hard is that the characters deleted were not two-week-old mules, they were mains of many years, with much effort and money invested in them.
So using the deletion weapon in this case was actually making extra sure the only ones to suffer would be those wrongfully punished.
Yes, makes perfect sense... in Nexonland.

How would date_of_first_completed_quest be a join? Create_date, update_date - These are all columns in a database as would date_of_first_completed_quest be whether or not it exists, rationally. They are not referred to as joins by DBAs/coders. Where are you getting your information from?

Because there is no magic date_of_first_completed_quest column, that was a reference to a concept, not an entity.
It would be found by joining the Character table to earliest entry from the QuestComplete or QuestPerform table. Nexon doesn't even store the character level in the Character table, it's in it's own table, so why would you assume something as random and unnecessary as first_completed_quest would exist as a dedicated field in a table? Each active quest has it's own date/time field per character indicating when it was started and finished, to find the earliest you would specifically query the min() date of the appropriate table and join that result to the character table. Thank you ever so much for explaining to me the nomenclature of the job I've had for over a decade, truly.

[COLOR="#000000"]So what has happened to the deleted accounts? (Don't know what is happening since I can't log in my account.)
From my understanding Hime posted this on the Nexon forums

Despite numerous attempts in doing so, individual account restore points are simply not possible. I'm very sorry to hear your account was hacked.

So if characters are deleted they have to rollback everything.[/COLOR]

[COLOR="#000000"]So what has happened to the deleted accounts? (Don't know what is happening since I can't log in my account.)
From my understanding Hime posted this on the Nexon forums


So if characters are deleted they have to rollback everything.[/COLOR]

Hime usually has no clue what she is talking about. But, on the offchance that it's true, that's some fucking pathetic game coding.

Because there is no magic date_of_first_completed_quest column, that was a reference to a concept, not an entity.
It would be found by joining the Character table to earliest entry from the QuestComplete or QuestPerform table. Nexon doesn't even store the character level in the Character table, it's in it's own table, so why would you assume something as random and unnecessary as first_completed_quest would exist as a dedicated field in a table? Each active quest has it's own date/time field per character indicating when it was started and finished, to find the earliest you would specifically query the min() date of the appropriate table and join that result to the character table. Thank you ever so much for explaining to me the nomenclature of the job I've had for over a decade, truly.

It can always be created within its own temporary table as a column and thus as an entity. Sometimes when you try to explain things the simplest possible way people divert from trying to understand the explanation and put their own meaning to it. When I mentioned "column" it was implied that it would be the min date from a separate table (also, never did I assume such a date column exists). I think you got the idea from the start though. This argument is pointless.

And nice job showing off how smart you are. Fyi, I also work with SQL as a developer (not to rub it in of course).

It can always be created within its own temporary table as a column and thus as an entity. Sometimes when you try to explain things the simplest possible way people divert from trying to understand the explanation and put their own meaning to it. When I mentioned "column" it was implied that it would be the min date from a separate table (also, never did I assume such a date column exists). I think you got the idea from the start though. This argument is pointless.

And nice job showing off how smart you are. Fyi, I also work with SQL as a developer (not to rub it in of course).

"created within its own temporary table as a column" would be done how?
Right! Via join.
The time/space tradeoff you (or your database's built-in optimizer) decide to use is irrelevant.

Right! Via join.

I think he was thinking more along the lines of

Code:

insert into #t select min(date) first_quest_completed, characterid group by charecterid

But yeah, he'd still have to join to #t to get that which would be redundant, and annoying for a delete when the initial join would already be just the subset of people you cared about anyway.

INCOMING


HOLD UP A SECOND
THEY ACTUALLY DID pomegranate

dont know it its been said already but

inb4 chars are at lvl 1, and get the compensation package that they cant equip

[i should update my SW profile]

"created within its own temporary table as a column" would be done how?
Right! Via join.
The time/space tradeoff you (or your database's built-in optimizer) decide to use is irrelevant.

What I wrote: "Someone also mentioned date_of_first_completed_quest; this would work too (if there is such a column)."

What I meant: "Someone also mentioned date_of_first_completed_quest; this would work too (if there is a date column to be used within the join)."

[COLOR="#000000"]So what has happened to the deleted accounts? (Don't know what is happening since I can't log in my account.)
From my understanding Hime posted this on the Nexon forums


So if characters are deleted they have to rollback everything.[/COLOR]

First of all, Hime said it.
Second of all, they don't need individual account restore points to restore an account back to where it was before.
It'd be a hell of a lot more complicated, but it would still be doable.
That is to say, if they back up everything, the data for individual characters is backed up as well.
If it's there, it can be accessed and duplicated.

Of course, my knowledge is far more abstract than those above me talking about tables and whatnot.

Use the earliest completed date in the quest table. Dunno if UAs have a quest auto-completed on creation though. Wouldn't it be when they get their clothes?

My thoughts exactly.
And, based on what Eos said, they log both when a quest starts and when it ends.
I'm fairly sure that most of the UA quests start automatically upon character creation.

dont know it its been said already but

inb4 chars are at lvl 1, and get the compensation package that they cant equip

[i should update my SW profile]

more like
>inb4 they have to give the deleted people who already had their names taken a random new name
Then they will give them a discounted price on Name Change Coupons! Not a free one, obviously. And they will never get their old names back. Enjoy!

Name changes are unavailable at the moment, discounted or otherwise.