Welcome to duststar theory

MapleSEA Ranking Database – 2

Author duststar | 23.01.2010 | Category MapleSEA

A quick update on progress.

The database design for the ranking database is finally done and tested. Right now, I am working on summarising data. To improve SELECT query performance, all data needs to “summarised” before I insert them into the database e.g. aggregate by day, week, month etc

Let’s look at BOOTES dataset for the past 10 hours! (From 0000 hours to 1000 hours, GMT +8)

1. Congrats to all those who level up (A total of 81 players). Below are the top 10 climbers based on level descending sequence.

2. Top 10 climbers based on levels gained descending sequence.

Hope you like them and watch out for more coming soon as the project gets nearer to completion!

.duststar

MapleSEA Ranking Database – 1

Author duststar | 22.01.2010 | Category MapleSEA

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

MapleSEA Registry of Marriages Database is UP!

Author duststar | 18.01.2010 | Category MapleSEA

Following from this post. Belated update.

The user interface (UI) has been completed. Please let me know if there are bugs.

This project was started to maintain an archive of MapleSEA’s wedding gallery, and at the same time allowing users to perform searches of individual player’s records based on player’s IGN (in-game nick) or a specified date.

Why do we need this?

1. For fun!
2. Before you get married in game don’t you wish to know if your partner was married before (and how many times)?
3. Now you can find back your favourite wedding photo shoot easily! Just search for your in-game nick (IGN).

Check out: http://www.duststar.net/projects/maplesea-registry-of-marriages-database/
Hope you all like it.

.duststar

MapleSEA Registry of Marriages (Project ROM)

Author duststar | 16.01.2010 | Category MapleSEA

You see. In real life, we can find out if someone is married or not by checking with the Registry of Marriages. In maplestory (MapleSEA), we have to crawl through every page in the gallery to find out what we want. Therefore, I am working on an automated archival and search project that will automatically collects MapleSEA’s wedding data periodically and allow user to search through these data.

Why do we need this?

1. For fun!
2. Before you get married in game don’t you wish to know if your partner was married before (and how many times)?
3. Now you can find back your favourite wedding photo shoot easily! Just search for your in-game nick (IGN).

While we are waiting for the user interface (UI) for searching to be up, here is some fun statistic.

1. x3ZhuZhux married 5 times ever since MapleSEA keep tracks of in-game wedding.

2009-10-13 ArcanaXII x3ZhuZhux http://www.duststar.net/rom/335d7d90b93fe88ce88a126c05cc08cb.jpg
2008-12-23 MrSp0ngeBob x3ZhuZhux http://www.duststar.net/rom/3dc2c70b578322511785e42035c2ceba.jpg
2008-11-21 xXiaoZaiKia x3ZhuZhux http://www.duststar.net/rom/3676b942b9412a8244c1eb774033acc4.jpg
2008-11-07 x3PeAcHTeA x3ZhuZhux http://www.duststar.net/rom/5d472a37cac68fbb1acd4a5bec8544e3.jpg
2008-10-03 XCrEaTmAgEX x3ZhuZhux http://www.duststar.net/rom/5862c37ebec4ba780bffa806b0eae096.jpg

2. On 14th Feb 2009, we saw the highest number (68) of couples getting married in MapleSEA!

“xXZwordXx”;”MRSCOOKIEx3″
“XxXxShadowxX”;”StarliteDust”
“xSociometry”;”pICkzp0ck3tX”
“XIiaoOnubboi”;”joey890″
“xiiaodidis”;”xPureL0ve”
“XAncientGodX”;”Darlingzx”
“Wizordy”;”xSHI”
“Shaolin”;”BIurrSiiN”
“renry”;”renerine”
“Punchkid”;”b2rusty”
“Nelsonworld”;”Stella279″
“MrZsparrow”;”xDrEDreLx”
“Mickyboyz”;”MinniegirIz”
“meetboyonli”;”ghostlyhq”
“mabaouncle”;”ChubbyKaty”
“Lord0FheaveN”;”YuenakBoos”
“littleboy11″;”x3Tobix3″
“LetMe0ut”;”xbabyMINTxDD”
“IxRuiQuanxI”;”IxXiaoXuanxI”
“HolyRomeo”;”HolyJuliet”
“HIJAYSONL33″;”bonia”
“Godfrey”;”CherAndrea”
“EarthRay”;”xiia0ppEy”
“Chameleos”;”Purpl3YinG”
“BenDanPiggy”;”x3ZacEfron”
“alalulu”;”oOkuenOo”
“nanooo”;”aaMiryonGaa”
“Soospirit”;”o0DeviLry0o”
“SeanPirate”;”BabyLeit”
“JVlyvidanus”;”CutieJoc”
“GodlyAkira”;”MiyuSama”
“Chanceux”;”llEsti”
“3vOlutiOnx”;”xPokeEu”
“zzfreez0nzzz”;”natsuki92″
“xXxDazzyxXx”;”MelodicAngel”
“XiaoMilkx33″;”XiaoAngeIx3″
“xHer3tiC”;”XiAoaNgeLgAI”
“xBakaJey”;”Xqu3lin3X”
“UpInTheSky”;”XiaoLoA”
“SacredLoveY”;”SacredLoveX”
“RangerWANpq”;”CIericWANpq”
“LuVmEgAnLyN”;”lCleriCsiaI”
“l0v3DlT”;”4Everlov33″
“KissChEnDoLx”;”snow1510″
“K4Lieb0yz”;”xXeMoTeddYXx”
“IYoShiRoI”;”xTomat0m3lx”
“IndianPriest”;”ChineseSlN”
“IIDKI”;”baobelx33″
“HoLyAsaSiNe”;”oHoLyoAnGeLo”
“feRmiZa”;”xXClericQiXx”
“ExotherMit”;”Metallicx3″
“BossKen”;”zBabyCrystaL”
“xxxKenSanxxx”;”BubbieDuddie”
“XiaoMoS3s”;”OoKuioO”
“xH0IyI3I5h0p”;”berry951″
“WNU2613″;”H0LySeEeNz0″
“UnKnOwnDeViI”;”tebby”
“QTcolumBOY”;”AlohaGal”
“proaddicted”;”LoVeLoLiPox3″
“mrharry3″;”xaishax”
“gonzafite2″;”BOttleWinter”
“EverDear”;”Ndas”
“Esplarade”;”TeddyJojo”
“Espadadrigo”;”Kittylingz”
“dEverIove”;”LuLuLaLa8080″
“dessertRazor”;”JefenneyRa”
“CafeGalilee”;”PuR3P1r4T3″
“Boy70″;”Preggie”

Watch out for more updates coming soon!

.duststar

Maplestory (MapleSEA) Network Status Monitoring – Update 1

Author duststar | 11.01.2010 | Category Cyber Security, MapleSEA

Continuing from this post.

Today evening managed to meddle with jpGraph‘s powerful graphing ability.  Added new RRD-style graphs to show past 24 hours network latency and uptime for all monitored services!

So let us go through how to interpret the graphs. (If you cannot wait to see them, just go here!)

The 1st graph sample shows us “www.maplesea.com – past 24hr network uptime status”. We have the timestamp and network latency in milliseconds on the x and y axis scale respectively. Currently we are looking at data from yesterday night 23:01 hrs to current time 22:38 hrs. Average network latency was around 300 ms (From US to SG/MY takes about such timing). At about today 00:30 hrs, high network latency spikes were observed.

For 2nd graph sample, the results are pretty much the same as the 1st graph sample. From this we could conclude that there might be a small network maintenance carried out during the period of high network latency spikes.

Next we have the 3rd graph sample of forums.asiasoftsea.net. The graph shows a near constant (good) network performance for forums.asiasoftsea.net. However, there were 2 network disruptions (network unreachable) after midnight 00:15 hrs and today evening 17:10 hrs. This might be due to the forums performing automated self maintenance. The timing at 00:15 hrs coincides with what seems to be the maintenance timing for www.maplesea.com and maple.playpark.net as well.

This 4th graph sample  showed us a stable network connectivity for Singapore gateway (the MapleSEA’s in-game login server) constant around 280 ms.

The last graph sample showed us network connectivity for Malaysia gateway which has 2 high network latency spikes occurring around last night 23:30 hrs and after midnight 00:25 hrs.

Hope you like what has been going on at duststar.net. There will be more surprises coming soon!

.duststar