Some personal thoughts or improvements about recent bans

Recently, I have heard about some bans in shoutbox about the bans. Some are due to vpn and some are real world trades. But in the gm’s response, it seems like they often require more details and I do not know it’s a strategy of inquiry or just need supplemental evidence. So here is some of my advice.

## build a relation table in database in order to find out the characters are belonging to THE same guy
Because I saw gm asked about the another characters of the ban appealers, so I assume that may be it’s a lack of some evidence of proving same characters belongs to the same guy? So why not just add a relationship table to the database. The condition to judge whether chars or accounts belong to same guy is base on the [hwid], two people can’t play royals at the same time on same computer. The only question is what if I played my accounts on my friends computer? Well, it’s hard to solve, but according to my experience, some time I log in in different locations, I have to enter my first password of account( sorry I forgot what’s the name), so can we develop a chain confirmation option?

If one char or account being accused of rwt, it’s ez to find out the others. Save the time of gm to find-out efforts .

This chain mechanism also solve the problems of multi votes. So we can specify the group ID other than account ID(suppose database have) to vote once within 24 hours.

 

Thanks for answering VPN part and some of my question xD

But one small question is what I mean relation table I mean like permanent table in relation database(eg.mysql). I guess what you mean it’s cached or nosql? May be is quick or some other reasons or advantages? so may I ask why is 200 players online is the prerequisite to build this table? Is it any reference I can get access to? I’ll really appreciate it if you can explain

 

i am not a coder but i'm guessing this stuff would be easy to do with a non-spaghetti coded nexon game, but we are probably dealing with a spaghetti-coded nexon game so band-aid database solutions are likely the only feasible option

 

Thanks for sharing your opinion with me

Due to the ban appeals part conversations on forum, I think our admin has same similar function deployed.

But now my focus is why 200 player matters

 

I understand now. But some feasible solutions like heap sort or bucket sort(I guess) can automatically filter the the most common hardware players login in so do not have to check in person? What’s your opinion on the feasibility?

 

So in this scenario, we’re dealing with many to many model right?( like many player can link to you and you can link to many players), I’m not sure about the nosql, but in sql, I think one relation table can solve that