[Development] Mu Market Data - better understanding of server economy

[marecznyjo]

Usually in MMORPGs, developers tend to keep track of their market and model it accordingly. I built up an app that does just that - track the market of Mu Online server to better understand the server economy.

It can show you how the amount of jewels, ancient, exc items change over time on the server. This is useful to see which jewels drop too much and which are too scarce.

Also, it can help admins respond to dupe much faster before it breaks down the whole server economy. If there is an unnatural spike of jewels between hours then it means that something’s going on and the admin needs to investigate.

I made an example webpage of how it looks like and how it works:
https://mumarketdata.com/example



It is also deployed for two upcoming MU servers (they are in preparation so data is a bit stale, one example is: https://mumarketdata.com/9threalm)

Technical stuff
Mu Market Data connects to the MU server sql and reads the data every 15 minutes. I didn’t do any stress tests but it seems to be working fine from a low to medium size database. Probably big databases too - I just didn't test it yet.

For now I track the following items:

• All jewels (no customs)
• Excellent items
• Ancient items
• Talisman of Chaos Assembly
• Zen
• Ruud

What do I plan in the future?
As per request, I plan to extend the app to track how much WCoin and Goblin Points players own. There was also a request to provide an option for custom jewels but that requires some changes to how I store the data.

If there will be a big interest I’d like to slowly build up Mu Market Data as an analytics tool for Mu Online servers with various important data to MU Admins.

I invite you all to a discussion about Mu Market Data. Feedback is highly appreciated. If you have any ideas on what I could change or add let me know.

[MentaL]

[nevS]

Nice idea!
In "normal" server files that means that you have to scan these large binary columns for each inventory and vault periodically, right?