Welcome to duststar theory

MapleSEA Ranking Database – 1

Autor duststar

I have announced the development of this project for MapleSEA few days ago at Asiasoft Forums. The MapleSEA’s ranking website we know of currently only allow us to search for players statistics based on their in-game nickname. Though it allow us to see rankings for various criteria e.g. All, Job, World and Fame, I felt that more could be done.

From data analysis point-of-view, perhaps we could make use of this provided data set to answer some of the following questions:
1. How many level 200 are there in each world? Of which, what are the distribution of level 200 among all jobs?
2. Who are the players that are going to reach level 200 soon?
3. How can we know if a particular player is leveling at a very fast speed?
4. How many 4th jobbers does each world have? And, what are the distribution of 4th jobbers among all jobs? So, which job is the most popular (in terms of 4th jobbers) and which job is the least popular?

Thus this is what the whole project is about.

Yesterday wrote and tested a script to fetch ranking information from MapleSEA’s ranking website. Now looking at database design which is very important because if I need to store the delta difference of all players’ statistics at each poll by the script, the database will be very huge! (A quick check on Bootes tells us that we have about 11,500 players with between level 120 to 200. That would means at every 2 hour poll I would probably have inserted 11,500 entries into my database. 24 hours = over 130,000 entries. 1 month = 3.9 million entries. 1 year = 46.8 million entries. And this is only Bootes! What about other worlds?)

Some fun facts:

1.  As of point of writing, Bootes has 1,690 level 120 players. The job distribution are as follows:

2. That would means for Knight of Cynus. We have (from most popular to least popular):
Flame Wizard, Soul Master, Night Walker, Wind Breaker, Striker.

3. For Adventurer Class, We have (from most popular to least popular):
Magician, Thief, Warrior, Bowman, Pirate

4. That probably explained why Magician and Thief jobs’ items and scrolls are still so expensive. Zzz.

5. The only Beginner at level 120 is … Sattva

Please look out for more cool stuffs coming soon!

.duststar