MarketDB API

MuhRO Web API

The MuhRO Web API serves pre-generated JSON snapshot files from the control panel. There are two parts:

• MarketDB API: vending, buying and sales trend data. Snapshots are refreshed about every 5 minutes.
• Game DB API: item and monster data as shown on the item and monster pages, including drops, drop chances, NPC shops, spawns and item groups. Snapshots are rebuilt when the game database is updated, which is about once a week.

Both parts are snapshot-based:

• API requests do not execute live database queries.
• Responses are served from JSON files and carry cache headers, so clients should honour ETag and Cache-Control.

Base URL

https://flux.muhro.eu/?module=<module>&action=<action>[&parameters]

All endpoints use the query form. The key parameter is accepted everywhere but currently not required.

MarketDB API

Endpoint

https://flux.muhro.eu/?module=marketdb&action=api&name=<dataset>

Query Parameters

Parameter	Required	Description
name	Yes	Dataset to fetch.
key	No	Currently not used.

Available Datasets

Dataset	Description	Notes
vendings	Current vendor shop list.	Shop-level snapshot.
v_vending	Items currently for sale.	Full rows from the vending cache view.
v_buying	Items currently being bought.	Full rows from the buying cache view.
buyingstores	Current buying shop list.	Shop-level snapshot.
vending_trend_daily	Full daily sales trend dataset.	Includes all available day buckets and items.
vending_trend_hourly	Full hourly sales trend dataset.	Includes all available hour buckets and items.
vending_last_sales	Latest sales log snapshot.	Currently limited to 1000 rows.
vending_trend_daily_latest	Rolling summary for the last 24 hours.	Ordered by sales_count descending.
vending_trend_hourly_latest	Rolling summary for the last 60 minutes.	Ordered by sales_count descending.
vending_last_sales_latest	Latest sales feed.	Currently the same 1000-row payload as vending_last_sales.
meta	Snapshot metadata.	Includes generated_at and server.

Example Requests

https://flux.muhro.eu/?module=marketdb&action=api&name=vendings
https://flux.muhro.eu/?module=marketdb&action=api&name=v_vending
https://flux.muhro.eu/?module=marketdb&action=api&name=v_buying
https://flux.muhro.eu/?module=marketdb&action=api&name=buyingstores
https://flux.muhro.eu/?module=marketdb&action=api&name=vending_trend_daily_latest
https://flux.muhro.eu/?module=marketdb&action=api&name=vending_trend_hourly_latest
https://flux.muhro.eu/?module=marketdb&action=api&name=vending_last_sales_latest

Game DB API

The Game DB API exposes the same item and monster data as the control panel item and monster pages. Drop chances and exp values are already adjusted with the server rates, so the numbers match what the web pages show.

Endpoints

Endpoint	Description
?module=api&action=itemdata	Full item list. Returns {generated_at, count, items: [...]} with compact rows.
?module=api&action=itemdata&id=<item id>	One item with all details (see below).
?module=api&action=monsterdata	Full monster list. Returns {generated_at, count, monsters: [...]} with compact rows.
?module=api&action=monsterdata&id=<monster id>	One monster with all details (see below).
?module=api&action=itemgroups	All item groups (boxes): {groups: {<group name>: {containers: [...], contents: [...]}}}.
?module=api&action=gamedbmeta	Snapshot metadata: generated_at, server, item and monster counts, exp_rates, drop_rates. Poll this to detect a new snapshot.

Item list row

id, aegis_name, name, type, subtype, price_buy, price_sell, weight, attack, magic_attack, defense, range, slots, refineable, view, equip_locations[], custom

Item detail

Field	Description
Base fields	Everything from the list row plus alias_name, gender, weapon_level, armor_level, equip_level_min, equip_level_max, gradable, jobs[], classes[], trade_restrictions[], flags[], nouse[], delay, stack, script, equip_script, unequip_script.
description, description_info	Item description as shown in the client and the extra info block from the control panel.
item_group, group_contents[]	For boxes: the group name and its contents (item_id, name, amount, rate, subgroup, algorithm).
contained_in[]	Boxes that can give this item (item_id, name, aegis_name, group).
npc_shops[]	NPC shops that sell the item: npc_id, npc_name, shop_type, map, x, y, price, currency, quantity (market shops) and cost_items[] (barter shops).
barter_ingredient_for[]	Barter shops that take the item as payment, with reward_item_id and reward_item_name.
itemshop_cost	Control panel item shop price, if any.
drops[]	Monsters that drop the item, sorted by chance. See drop entries below.
images	icon and collection image URLs.

Monster list row

id, sprite, name, name_japanese, level, hp, size, race, element, element_level, base_exp, job_exp, mvp_exp, mvp, custom

Monster detail

Field	Description
Base fields	Everything from the list row plus sp, attack, attack2, defense, magic_defense, resistance, magic_resistance, str, agi, vit, int, dex, luk, attack_range, skill_range, chase_range, race_groups[], walk_speed, attack_delay, attack_motion, damage_motion, damage_taken, ai, class, boss, modes[].
base_exp_rated, job_exp_rated, mvp_exp_rated	Exp with the server exp rates applied. The unsuffixed fields are the raw database values.
drops[]	The normal drop slots: slot, item_id, aegis_name, name, item_type, rate_raw, rate, steal, option, index.
mvp_drops[]	The MVP reward slots, same fields. rate already accounts for the earlier slots being rolled first.
extra_drops[]	Additional drops from the server drop table (item_id, name, rate_raw, rate).
map_drops[]	Map specific drops (map, item_id, name, rate_raw, rate).
skills[]	Monster skills with cast conditions, if the server publishes them.
spawns[]	Spawn points: map, x, y, respawn_min, respawn_max, quantity.
image	Sprite image URL.

Drop entries on items

Each entry in an item's drops[] has monster_id, monster_name, monster_level, monster_race, monster_element, monster_element_level, boss, type, rate_raw, rate, steal and, for map drops, map.

type	Meaning
normal	One of the ten regular drop slots.
mvp	MVP reward slot.
extra	Additional server drop.
map	Map specific drop on the map named in map.

Drop chances

• rate is the chance in percent with the server drop rates applied, the same number the item and monster pages show. Cards are fixed at 0.20% (0.04% from bosses).
• rate_raw is the untouched database value: 1/100 percent for normal, MVP and extra drops and 1/1000 percent for map drops.
• The rates used are published in gamedbmeta as drop_rates and exp_rates.
• Drops whose item is not in the item database have item_id set to null.

Example Requests

https://flux.muhro.eu/?module=api&action=itemdata&id=501
https://flux.muhro.eu/?module=api&action=monsterdata&id=1002
https://flux.muhro.eu/?module=api&action=itemdata
https://flux.muhro.eu/?module=api&action=monsterdata
https://flux.muhro.eu/?module=api&action=itemgroups
https://flux.muhro.eu/?module=api&action=gamedbmeta

Example drop entry from a monster:

{"slot":1,"item_id":909,"aegis_name":"Jellopy","name":"Jellopy","item_type":"Etc",
 "rate_raw":7000,"rate":93.37,"steal":true,"option":null,"index":0}

Response Headers

Header	Description
Content-Type	application/json; charset=utf-8
Cache-Control	Public cache header with max-age: 300 seconds for MarketDB, 3600 seconds for Game DB.
ETag	Entity tag based on the snapshot file and modification time. Send it back as If-None-Match.
Last-Modified	Snapshot file modification timestamp in GMT. Game DB endpoints also answer If-Modified-Since.
Content-Encoding	Set to gzip when the client sends Accept-Encoding: gzip. The full item list is about 11 MB raw and under 1 MB gzipped, so always request gzip for the list endpoints.
Access-Control-Allow-Origin	* on Game DB endpoints, so they can be called from browser scripts on other sites.

Rate Limits

API	Limit
MarketDB	120 requests per minute per IP.
Game DB	240 requests per minute per IP.

Fetch the list endpoints once and cache them; the game data only changes about weekly and gamedbmeta tells you when.

Status Codes

Status	Meaning
200	Snapshot returned successfully.
304	The client cache is still valid for the current ETag.
400	Invalid id parameter (Game DB).
403	Invalid or missing API key when key protection is enabled.
404	Unknown dataset name, unknown item or monster id or snapshot file missing.
429	Rate limit exceeded.
500	MarketDB cache configuration is missing.
503	Game DB API disabled.

Game DB errors are returned as JSON: {"error": "..."}.