Kokotewa

Updates

2024

09/14 Bugfix - Skills

Corrected many skill and typographical errors, including:

I'd like to thank zyn, mrj, Daegaladh, Playtester for their assistance in identifying these skill errors.

08/18 Database 7.7 - Monster Density

Introduced the density of monsters, i.e. monster number / walkable cells, to the mon_info page.

07/14 Database 7.5 - Brasilis

Brasilis, although introduced in two official regions (bRO and jRO) prior to renewal, is difficult to document correctly. Notably, Brasilis was incomplete on release which led to each region customizing the content for their localization. In some cases, we opt to document what we believe is correct rather than what was initially accurate as the content updated post release. For transparency, we document these occurrences and the rationale behind them here.

On release, many monsters had inflated health points (HP) and/or experience rewards (EXP) relative to their attack (ATK). It is expected that this discrepancy originated from renewal development, which introduced significant changes to game mechanics and monster attributes. This resulted in content that was either overly fruitful or underwhelming. By means of an illustrative example, consider the following monsters from the initial bRO release.

monster_id ATK HP bEXP jEXP CURUPIRA 140 ~ 175 8,669 1,209 850 TOUCAN 166 ~ 201 10,555 1,002 1,552 JAGUAR 192 ~ 234 12,590 1,820 1,012 HEADLESS_MULE 210 ~ 267 20,065 6,666 4,111 PIRANHA 182 ~ 223 15,882 2,445 2,023 IARA 284 ~ 352 18,952 4,689 1,500

In subsequent updates, each region modified monster attributes with reference to their playerbase. jRO opted to increase monster ATK (3~5x) to be appropriate for their HP and EXP rewards. bRO opted to decrease monster HP and EXP to be appropriate for their ATK. While there are merits to either approach, we present the bRO implementation within our interactive database as it more closely aligns with the original implementation and observed intent.

With reference to bRO's implementation, a significant portion of the original dungeon monster composition consists of weak monsters. While "atmospheric" monsters are not unheard of, e.g. Magmarings and Ghouls in Thor Volcano Nameless Island respectively, Brasilis' composition is beyond "atmospheric". Unlike the prior examples, these inclusions span multiple monster IDs, comprise 20 ~ 33% monster spawns, and are present on the final floor. Collectively, this is strong evidence that the dungeon was catered for lower level characters.

# bra_dun01 putmob "bra_dun01" 0 0 0 0 80 PIRANHA 5000 0 0 putmob "bra_dun01" 0 0 0 0 30 IARA 5000 0 0 putmob "bra_dun01" 0 0 0 0 20 MARINA 5000 0 0 putmob "bra_dun01" 0 0 0 0 15 HYDRA 5000 0 0 putmob "bra_dun01" 0 0 0 0 10 KUKRE 5000 0 0 putmob "bra_dun01" 0 0 0 0 10 PLANKTON 5000 0 0 putmob "bra_dun01" 0 0 0 0 5 BLACK_MUSHROOM 5000 0 0 # bra_dun02 putmob "bra_dun02" 0 0 0 0 60 PIRANHA 5000 0 0 putmob "bra_dun02" 0 0 0 0 110 IARA 5000 0 0 putmob "bra_dun02" 0 0 0 0 10 MARINA 5000 0 0 putmob "bra_dun02" 0 0 0 0 15 HYDRA 5000 0 0 putmob "bra_dun02" 0 0 0 0 10 KUKRE 5000 0 0 putmob "bra_dun02" 0 0 0 0 10 PLANKTON 5000 0 0 putmob "bra_dun02" 0 0 0 0 5 BLACK_MUSHROOM 5000 0 0 putmob "bra_dun02" 0 0 0 0 2 SHINING_PLANT 5000 0 0

With reference to jRO's implementation, other localized dungeons (e.g. Amatsu, Ayothaya, Luoyang, Moscovia) introduce monsters in excess of 10 ~ 20k HP on the lower levels. Headless Mule, the monster with the highest HP and EXP rewards of the new monsters, was relocated from Brasilis Field to Brasilis Dungeon to mirror its difficulty. To supplement this shift, and remain consistent with the previously discussed atmospheric context, jRO removed weak monsters (e.g. Marina, Kukre, Plankton) from the dungeon completely.

While jRO official and unofficial sources document monster drop tables and behavior, they do not preserve the item order or AI type(s). Consequently, although the monster drop tables may be assumed accurate, item order and AI type are inferred with reference to renewal data. Should the renewal monster drop table significantly differ to the extent that direct comparison is impossible, item order was inferred from a similar monster instead, e.g. Obeaune for Iara.

07/06 Misc. Updates

Updated the following components/packages to the latest versions:

06/30 Bugfix - Skills

Corrected many skill and typographical errors, including:

I'd like to thank zyn, mrj, and Playtester for their assistance in identifying these skill errors.

06/29 Database 7.4 - Adv. Monster Search (Constraints)

Improved the Advanced Monster Search by introducing additional filters, sort options, and constraints.

06/08 Database 7.3 - Item Recovery Traceback

Introduced traceback links to related items for recovery bonuses to the itm_info page.

06/05 Database 7.2 - CSS and DB Schemas

Restructured MSSQL tables, stored procedures, schemas and CSS to improve performance.

06/02 Database 7.1 - Adv. Map Search

Introduced Advanced Map Search.

05/29 Database 7.0 - Connection Pooling

Refactored page structure to support connection pooling and other performance improvements.

05/27 Database 6.7 - Monster Heatmaps

Introduced a monster heatmap toggle to the map_info page.

On zone start, each monster is assigned a position within their spawn area. While the spawn area from this position is rectangular, the distribution exhibits decreasing probability relative to the radial distance from the centerpoint. This behavior continues until the zone server is reset and a new position for each monster is chosen.

I'd like to thank mrj, Playtester, and Doddler for their assistance in researching the implementation of monster spawns, and with additional accolades to Doddler for generating the heatmap images.

05/05 Database 6.6 - Map Background Music

Introduced a background music toggle to the map_info page.

04/05 Bugfix - Skills

Corrected many skill and typographical errors, including:

I'd like to thank mrj & Playtester and Nikua & ckx for identifying the skill and typographical errors respectively.

03/24 Database 6.5 - Mercenaries

Added mercenaries to mon_info monster listing and tracebacks to mon_info, itm_info, and skl_info pages.

03/15 Bugfix - Luk Status Resists

Introduced status duration reduction from enemy luck within status formulae alongside other minor bugfixes, e.g.

01/09 Database 6.4 - Status Effects

Introduced the eft_info lookup page and skill effect icons.

2023

08/21 Database 6.3 - Page Cache

Introduced a cache for page queries.

06/03 Database 6.2 - Jobs

Introduced the job_info lookup page.

05/03 Database 6.1 - Item Skill Traceback

Introduced traceback links to related skills due to item effects or catalysts to the itm_info lookup page.

04/22 Database 6.0 - Skills

Introduced the skl_info lookup page. I'd like to thank mrj for his assistance with skill mechanic research. This update is coupled with minor schema, query, javascript, and architecture rewrites to improve performance.

2022

08/20 Database 5.1 - Adv. Item Search (Combil)

Added item combination scripts to Advanced Item Search (Script).

07/27 Database 5.0 - Map Links

Introduced Map Links on Map Info pages to facilitate navigation between adjacent maps. I'd like to thank RDW for his guidance on this feature's CSS and JS inclusions.

06/25 Database 4.7 - Adv. Item Search (Script)

Introduced Advanced Item Search (Script).

06/23 Database 4.6 - Adv. Item Search (Ammo)

Introduced Advanced Item Search (Ammo).

06/22 Database 4.5 - Adv. Item Search (Weapon)

Introduced Advanced Item Search (Weapon).

06/20 Database 4.4 - Adv. Item Search (Armor)

Introduced Advanced Item Search (Armor).

06/17 Database 4.3 - Adv. Item Search (Heal)

Introduced Advanced Item Search (Heal).

05/30 Public Release and Fansite Submission

Webservice made public and submitted fansite request to Warp Portal (iRO) for approval.

05/28 Database 4.2 - Map Images

Introduced improved map images and graymap toggle on mouseover. I'd like to thank Doddler for providing the improved map images.

05/21 Database 4.1 - Shop Detail

Introduced Shop Detail to map_info lookup page.

05/06 Bugfix - Skill Descriptions

Corrected inaccurate monster skill tooltips:

I'd like to thank Playtester for identifying these inaccuracies.

05/01 Database 4.0 - Skill Tooltips

Introduced skill tooltip summaries on mouseover. The monster info page tooltips source the monster attributes, providing detailed information within the context of the current monster (e.g. offensive skills will include a damage range with reference to the monster's stats). This feature was significantly improved with the help of many individuals;

03/24 Bugfix - Monster Drop Rates

Corrected a drop rate calculation that used a divisor of 10,000 instead of 10,001. This resulted in item drop rates above 50% showing 0.01% higher than intended. I'd like to thank Playtester for identifying this inaccuracy.

This change has been reverted, the drop calculation uses a random number 0-9,999 inclusive (10,000 was correct). I'd like to thank mrj for identifying this inaccuracy.

03/20 Database 3.2 - Adv. Monster Search

Introduced Advanced Monster Search.

02/11 Database 3.1 - Location Tooltips

Introduced tooltips to highlight NPCs location and monster spawns on mouseover.

2021

12/22 Database 3.0 - Cute Pets

Introduced cutepet info (e.g. hunger, intimacy, related links), mon_from_mon, and mon_from_itm links (e.g. DBs and monster summons).

12/18 Database 2.6 - Item & NPC Crafts

Introduced item_making_item info (e.g. OCAs, OPBs, etc.), item_summon_monster info (e.g. DBs, BBs, etc.), item_proc_items (e.g. Mimic Card, Myst Case Card), craft success rates on navigation pages, and misc Javascript and UX improvements. I'd like to thank mrj for his assistance with cooking and potion creation success rate disambiguation.

12/03 Database 2.4 - Quick Search

Introduced quick search navigation. I'd like to thank RDW for his Javascript guidance and mrj, Nikua, and Riku for their UX feedback.

11/22 Database 2.2 - Player Crafts

Introduced crafted item info (e.g. Arrow Crafting, Alchemists, NPC quests, etc.). I'd like to thank mrj for his persistent, and difficult to implement, UX recommendations.

10/23 Database 2.0 - Items

Introduced the itm_info lookup page and episode filter. I'd like to thank mrj, RDW, phaicm, and Nikua for their feedback for this feature.

08/28 Database 1.0 - Monsters & Maps

Introduced the mon_info and map_info lookup pages. I'd like to thank mrj, RDW, and Nikua for their assistance and/or guidance with this feature.

2020

11/14 World Map 1.0 - Resources

Introduced world map navigation. I would like to thank Nikua for assistance with small_map file generation.

10/13 Database Prework

Introduced the database framework for preliminary development.

2019

08/18 SummonList Tables

Introduced ItemSummonList and MonsterSummonList tables.

Ragnarok Online © Gravity Corp. & Lee Myoungjin
Kokotewa ©