Deprecated: Function ereg_replace() is deprecated in /home/rel20/public_html/database/index.php on line 141

Deprecated: Function ereg_replace() is deprecated in /home/rel20/public_html/database/index.php on line 143

Deprecated: Function ereg_replace() is deprecated in /home/rel20/public_html/database/index.php on line 145

Deprecated: Function ereg_replace() is deprecated in /home/rel20/public_html/database/index.php on line 147

Deprecated: Function ereg_replace() is deprecated in /home/rel20/public_html/database/index.php on line 149
:: RO Empire - Database - Home ::
UK Web Hosting

Ragnarok Online Database System

Welcome to the RO Empire - Ragnarok Online Database System.
Here you'll find a ton of monster, item, map, and quest related information.
If you see anything wrong, or incomplete, and have the correct data for it,
please don't hesitate to PM me in the forums, or reply in this dedicated database suggestion/complaint/etc thread in the forums.
Whatever it is you want to say, please do so in that thread, or PM me, now, enjoy. :)

To Do/Idea List:

  • Add dungeon entrance locations. Thanks saxie1
  • Add guild castle information (maps, treasure chests, etc). Thanks Dark~Mike, saxie1
  • Allow monster search results to carry over (search comparison). Thanks Zannah
  • Add more quests and skills.
  • Add more NPC's and shops.
  • Add more search options onto the Item Search. Thanks AzureFlash
  • Add steal calculator.
  • Add skill simulators.

Change Log:

  • 17th of November 2006 - Relena:
    • Added Misc > Weapon Size Damage Percentage Table
    • Added Misc > Weapon Size Damage Percentage Table > Monster; Weapon damage script. Thanks Astarael
  • 16th of November 2006 - Solar:
    • Added new NPCs.
    • Added new NPC Shops.
    • Added NPC's Butcher [Morroc], Miya, Towner, Jeweler 1 [Morroc], Jeweler 2 [Morroc], Tool Dealer [Morroc], Smile Assistance [Morroc], Item Collector [Morroc], Cool Event Voting Staff [Morroc], Kafra Voting Staff [Morroc], Hans, Educated Traveler, Zaka, Assassin Boy, Ant Man.
    • Added NPC Shops Morroc Jeweler 1, Morroc Jeweler 2, Morroc Tool Shop.
  • 16th of November 2006 - ~Ogami Itto~:
    • Added Amatsu & Lighthalzen NPCs.
    • Added Amatsu & Lighthalzen NPC Shops.
    • Added NPCs: Armor Dealer [Amatsu], Weapon Dealer [Amatsu], Collins, Old Man, Ordinary Man, Joyce, Dan Song, Lucius, Relaxed-Looking Lady, Wallace, Ruth, Oyoung, Kariya, Vendor from Milk Ranch [Lighthalzen], Sigmund, Klaubis, Pet Groomer [Lighthalzen]
    • Added NPC Shops: Amatsu Armor Shop, Amatsu Weapon Shop, Lighthalzen Milk Shop, Lighthalzen Pet Shop
  • 15th of November 2006 - ~Ogami Itto~:
    • Added Lighthalzen NPCs.
    • Added Lighthalzen NPC Shop.
    • Added NPCs: Elmer Keays, Gopal, Jeweler [Lighthalzen], Kosit, Laqumet, Maivi, Margaret Merry, Margie Keays, Sefith, Sopheap, Vergil, Villagomez.
    • Added NPC Shop: Lighthalzen Jeweler
  • 14th of November 2006 - ~Ogami Itto~:
    • Added Lighthalzen NPCs, Lighthalzen NPC Shops
    • Added NPCs: Cool Event Voting Staff [Lighthalzen], Flower Girl [Lighthalzen], Fruit Gardener [Lighthalzen], Jade, Janice, Kafra Voting Staff [Lighthalzen], Kemp, Kimmy, Mauro, Sameer, Sergei, Strange Guy, Sung
    • Added NPC Shops: Lighthalzen Flower Shop, Lighthalzen Fruit Shop
  • 10th of November 2006 - ~Ogami Itto~:
    • Added new NPCs.
    • Added new NPC shops.
    • Added NPC Shops: Einbroch Weapon Shop 1 2 & 3, Einbroch Tool Shop, Einbroch Chef Assistant, Einbroch Flu Mask Shop.
    • Added NPCs: Airship Engineer, Chef Assistant [Einbroch], Flu Mask Dealer [Einbroch], One Hand Weapon Dealer [Einbroch], Two Hand Weapon Dealer [Einbroch], Paddler, Weapon Dealer [Einbroch]
  • 7th of November 2006 - Relena:
    • Updated Monster Database; Skills.
    • Removed some useless doubled monsters.
    • Added some missing map images.
    • Fixed a bug causing the map mouse over box (World and Dungeon Maps) to flicker. Thanks Larpus
    • Fixed a bug causing unused/hidden maps to be shown.
    • Renamed similarly named monsters to help distinguish between them.
    • Added Quest > NPC interlinking.
  • 29th of October 2006 - Relena:
    • Updated Map Database.
    • Updated Monster Database; Spawns.
    • Updated Arrow Crafting.
    • Added a monsters alternate name in Monsters > View (shown as "name1 / name2").
    • Fixed race listing in Monsters > List. Thanks peter
  • 23rd of October 2006 - Solar:
    • Added new NPCs.
    • Added new NPC Shops.
    • Added NPC's Hypnotist, Butcher, Vendor from Milk Ranch, Milk Vendor, Cool Event Voting Staff [Prontera], Kafra Voting Staff [Prontera], Busy Boy, Archeoligist, Weapon Dealer [Prontera], Armor Dealer [Prontera].
    • Added NPC Shops Prontera Armor Shop, Prontera Weapon Shop 1, Prontera Milk Shop, Prontera Gift Shop, Prontera Butcher Shop.
  • 22nd of October 2006 - Relena:
    • Updated Monster Database; Drops and Stats.
    • Added new section; Shops to the NPC Database.
    • Added new section; Search to the NPC Database.
    • Added the shops part to an NPC's details this time.
    • Added linking from Items > NPC Shops this time.
    • Fixed the Merchant Set, had Myst Card instead of the correct Myst Case Card. Thanks <Illuvitar>
    • Fixed a lot of items not displaying a Sell Price.
    • Added "Is Aggressive/Is Not Aggressive" Monster Filter. Thanks tino227
  • 20th of October 2006 - Solar:
    • Added new NPC entries.
    • Added NPC Shop Prontera Flower Shop, Prontera Doll Shop.
    • Added NPC's Flower Girl, Doll Supplier, Gift Merchant, Tialfi.
  • 16th of October 2006 - Relena:
    • Added new DB; NPC's.
    • Added new section; Item Sets to the Item Database. Thanks Matt
    • Added new feature; NPC Shops.
    • Added NPC Shop Prontera Tool Dealer.
    • Added linking from Items > NPC Shops.
    • Added NPC's Alchemist, Alcouskou, Bag Seller, Boy, Charlron, Chivalry Member, Cleric, Fuzzy Fuzz,
       Gershaun, Granny, Hat Merchant, Java Dullihan, Marianne, Marx Hansen, Morrison, Muscle Man,
       Mystic Lady, Nami, Necko, Nursing Instructor, Pretty Lindsay, Teacher, Tool Dealer [Prontera],
       Trader, Vending Machine Man, William, Young Man to the NPC Database.
    • Fixed a bug causing quests to show up in the wrong items in "Used In Quests". Thanks wanglover
    • Fixed the missing drop card image in monster data.
    • Small Note: I have constructed a front end for database management.
       Anyone wanting to help maintain/update/modify the database, please reply in the DB thread or PM me.
       No knowledge of PHP or MySQL is required.
  • 4th of October 2006 - Relena:
    • Updated the Item Database.
  • 22nd of May 2006 - Relena:
    • Added Merchant skill set to the database.
    • Added linking to the quest database for the quest skills.
    • Fixed a bug causing table data rolling over into other skills in Jobs > List by Job. Thanks I B r E a K I
  • 10th of May 2006 - Relena:
    • Added new sections; View and List By Job to the Skills Database.
    • Added entire Novice, Acolyte and Thief skill sets.
    • Added items used and gained in skills linking to the Items Database.
    • Added linking to skills in monsters to the Skills Database.
    • Added Heal Table to the Misc Database.
    • Added Pet Levels to the Monsters > Pet Table. Thanks RagnarokX5000
    • Added HP to the Monsters > Search > Order By list. Thanks AllPainful
    • Fixed map images not showing up in Maps > World/Dungeons when using database.roempire.com URL. Thanks Tag
  • 2nd of May 2006 - Relena:
    • Added new filters in Items > Search: Slot count, Applicable Job field, and a Description search (for things like INT, AGI, etc). Thanks Sorensen, oopszqoo
    • Added new filters in Monsters > Search: HP and JEXP range, and hide mini-bosses. Thanks AllPainful
    • Added a Weapons and Armors Refineable status. Thanks gailking
    • Fixed a bug causing Head Gear positioning to appear when listing Head Gear Cards.
    • Fixed a bug causing certain items to display the incorrect description (that of another items).
    • Removed a lot of the target="_blank" tags to the links (they were pissing me off).
  • 26th of April 2006 - Relena:
    • Added Sub-Filtering in Items > List By Class; Armor > Head Gear. Now has All, Upper, Middle and Lower.
  • 25th of April 2006 - Relena:
    • Fixed a ton of missing data on the Item Database.
    • Updated the Monster Database.
  • 28th of March 2006 - Relena:
    • Updated the Item Database.
  • 26th of September 2005 - Relena:
    • Fixed a bug caused monster images not to change on Maps > View.
    • Fixed a bug causing alot of missing items.
  • 23rd of September 2005 - Relena:
    • Updated the Item Database.
    • Fixed a bug causing an empty selection in Items > List By Class.
    • Fixed a ton of missing item images; every item should have one now.
    • Added quest Oxygen Mask.
    • Added quest Binoculars.
    • Added quests Dyestuffs.
    • Added quests Hat Merchant.
    • Added quests Vending Machine.
    • Added quest See-Otter Hat.
    • Added quest Alarm Mask.
    • Added quests Trader.
    • Added monster Arclouse to anthell02[1]. Thanks Talkeman
    • Fixed monster Jing Guai drops, swapped Club[4] for Club[3], and lowered rate to 0.1%. Thanks Awasai
    • Fixed monster Christmas Chookie, changed name to Chookie (Christmas). Thanks sup-dude
    • Fixed monster Cookie (Christmas) drops, added Gift Box at 0.1%. Thanks Baku-chan, sup-dude
    • Fixed monster Emperium stats, changed BEXP and JEXP to 0, 0. Thanks bastien
    • Fixed monster Knight of Abyss, changed name to Abysmal Knight. Thanks bastien
    • Removed monster Penomena from beach_dun3 spawn list. Thanks Chloegurl
    • Removed monster Wanderer from pay_fild09 spawn list. Thanks Chloegurl
    • Fixed monsters Maya Purple, Mobster, Zealotus, Apocalypse, Dark Illusion,
       Panzer Goblin, Strouf, Deviace, Alice, Mysteltainn, Executioner,
       Ogretooth grouping, changed to mini-boss. Thanks Wang Fenrir
  • 9th of September 2005 - Relena:
    • Added Quests Database.
    • Added "Used In Quests" and "Gained From Quests" onto items.
    • Fixed monster Zombie Prisoner drops, increased Shackles from 0.03% to 0.3%. Thanks Vidar
    • Fixed monster Elder Willow drops, added Dead Branch at 0.1%. Thanks Chibi-Pez
    • Fixed monster Kobold Leader sprite. Thanks Orokirn
    • Fixed monster Rybio drops, added Empty Potion Bottle at 0.01%. Thanks Simonlein
    • Fixed monster Beetle King mode, changed from Passive to Assist. Thanks Mike
    • Fixed mosnter Kraben drops, added Old Blue Box at 0.01%. Thanks Prince Of Darkness
    • Fixed mosnter Ogretooth drops, increased Muscovite from 1% to 15%. Thanks Awasai
    • Fixed monster Kaho drops, swapped Stone Heart for Burning Heart. Thanks acathla
    • Fixed monster Dark Lord drops, added MVP Coif[1] at 10%. Thanks Phoenix Guardian
    • Fixed monster PecoPeco mode, changed from Unknown to Assist. Thanks Vidar
    • Fixed monster Goat mode, changed from Cast Detector to Assist. Thanks Vidar
    • Fixed monster Goblin Leader drops, swapped Goblin Mask for Goblin Leader Mask. Thanks Vidar
    • Fixed monster Hatii Baby, changed name to Baby Hatii. Thanks Awasai
    • Fixed monster Garm, changed name to Hatii. Thanks Hyper Sonic lv 2, Slothrop
    • Fixed monster Hylozoist, changed name to Heirozoist. Thanks xpsypiex
    • Fixed monster Leaf Cat, decreased spawn count on ayo_fild01 to 10.
    • Added monster Elder to c_tower2[2]. Thanks Vidar, Slothrop
    • Replaced monster Mime Monkey with Leaf Cat on ayo_dun01 spawn list. Thanks Vidar
    • Removed monster Joker from gl_knt2 spawn list. Thanks kc00l, Slothrop
    • Removed the formula 1 Mole Whiskers for 30 Stone Arrow from Arrow Crafting. Thanks Mike
  • 7th of August 2005 - Relena:
    • Added "Merchant > Alchemist > Biochemist" Skill Tree.
    • Added yggdrasil01 monster spawns.
    • Added custom generated map for yggdrasil01.
    • Added the Einbroch and Lighthalzen maps to Maps > World.
    • Added an option to not show maps not currently in iRO onto Maps > World.
    • Fixed the Thief > Assassin > Assassin Cross skill tree to counter for new required skills.
    • Replaced monsters Stainer with Horn on um_fild04 spawn list.
    • Replaced monsters Wootan Shooter with Stone Shooter on um_fild02 spawn list. Thanks Mincemaker
    • Added monster Coco [10] to um_fild02 spawn list.
    • Added monster Choco [1] to um_fild02 spawn list.
    • Replace monsters Pest with Stainer on um_fild03 spawn list.
    • Re-arranged the monster profiles in Monsters > View a bit. Thanks Parsec
    • Changed the Enchanted Peach Tree so that it is no longer classed as immobile. Thanks Kaldemious_Loreman
    • Changed the Beetle King mode to Passive from Agressive. Thanks Dark Phoenix
    • Updated the best viewed in info to Mozilla Firefox v1.0.6 Thanks elscire
    • Fixed item Katar of Raging Blaze images. Thanks Zannah
    • Fixed monster Emperium stats. Thanks Digara, bastien
    • Fixed monster Kaho stats. Thanks acathla
    • Added monster Kaho [20] to the mag_dun01 spawn list. Thanks Vidar, Chloegurl
    • Added monster Am Mut [1/15] to the pay_dun04 spawn list. Thanks Vidar
    • Added monster Cat'o'Nine Tails [1/15] to the pay_dun04 spawn list. Thanks Vidar
    • Added monster Skeleton General [1/15] to the pay_dun04 spawn list. Thanks Vidar
    • Fixed monster Nine-Tail spawn rate in pay_dun04 from 1 to 30. Thanks Vidar
    • Fixed monster Loli Ruri drop rate, swapped Black Cat Doll with Bat Cage. Thanks Vidar
    • Fixed monster Gibbet drop rate, increased Cursed Ruby from 0.1% to 1%. Thanks Vidar
    • Fixed monster Rotar Zairo mode, added Ranged Attack(10). Thanks kasuha
    • Fixed monster Frilldora mode, changed it to Aggressive. Thanks kasuha
    • Fixed monster Quve drops, added Poisonous Powder by 1%. Thanks ~Ogami Itto~
    • Fixed monster Ogretooth drops, increased Muscovite drop rate from 0.1% to 1%. Thanks Awasai
  • 3rd of August 2005 - Relena:
    • Uploaded new map images.
    • Added custom generated maps for ama_dun01 and ayo_dun01.
    • Removed all maps that don't have monster spawns on them in Maps > View.
    • Fixed a bug causing some items not correctly showing what monsters drop it.
    • Fixed a bug causing some monsters not correctly showing what items they drop.
    • Monsters in Maps > View now link down instead of loading a new page.
    • Changed some of the monster names to the iRO version: Thanks bastien, Katana, Vidar
       -Dancing Dragon -> Zhu Po Long
       -Hyegun -> Yao Jun
       -Civil Servant -> Mao Guai
       -Li Me Mang Ryang -> Jing Guai
       -Tyrfing -> Ogretooth
       -Increase Soil -> Mi Gao
       -Zherlthsh -> Zealotus
    • Replaced Diabolic for Blazer in mag_dun01 spawn list. Thanks Vidar
    • Fixed monster Ghoul not showing up in Maps > View at ayo_dun01.
    • Fixed a few spelling mistakes on Items index page. Thanks Ultima_Pi
    • Fixed monster Drake Water Ball level from 10 to 5. Thanks Katana
    • Fixed Zealotus' and Alice's pet eggs in Monsters > Pet Table
    • Removed Cramp from gl_sew03 spawn list. Thanks Fullangr
    • Fixed a bug causing the search fields in Items > Search to not save after searching.
    • Fixed a bug causing the monster search to spit out an SQL error when entering strange chars as a search string.
    • Added VIT and DEF into the Order By options in the Monsters > Search Display Options. Thanks Pyraxis
    • Added Hit and Flee into the Order By options in the Monsters > Search Display Options. Thanks jammymacster
    • Added ATK range filter in Monsters > Search Filter Options. Thanks Verowyn
    • Added EXP range filter in Monsters > Search Filter Options. Thanks Adramelech
    • Changed it so that the monster details displayed in Maps > View is now in alphabetical order.
    • Fixed a bug causing item search highlighting to not work in Monsters > Search
  • 30th of July 2005 - Relena:
    • Updated the Monster and Item databases/images.
  • 29th of March 2005 - Relena:
    • Added Skills Database.
    • Added "Thief > Assassin > Assassin Cross" Skill Tree.
    • Added a "Mini-Boss" Filter. Thanks Vidar
    • Added monster details to the end of a "Maps > View" page.
    • Added what monsters a monster summons when they use "Summon Slave". Thanks Phineas
    • Changed the way monster counts work on maps.
       If it's a normal monster spawn, you'll see MAP[COUNT] (which is bascily the same as before).
       But if it has a timed spawn, you'll see it as MAP[COUNT/RATE], where RATE is in min.
       So for most MVPs you'll see MAP[1/120], meaning 1 spawn every 120 minutes (2 hours) from last kill. Thanks Lord Razark
    • Renamed "Increase Soil" to "Mi Gao" (iRO Name). Thanks Rikimaru.
    • Fixed "Lance" forging materials (it was missing 1 "Evil Horn"). Thanks Gryz
    • Fixed "Turn off Monster Animations", it wasn't working before, but now is. Thanks Denzi
    • Items in "Items > Arrow Crafting Table" now have slot counts if applicable.
    • Fixed a ton of incorrect arrow crafting formulas. Thanks Aucix
    • Modified a ton of HTML code. Alot more complient with the W3C standard than it was before.
  • 23rd of March 2005 - Relena:
    • Added an extra table to "Items > Arrow Crafting Table" which now displays them in their groups, as well as quick links to them.
    • When clicking a map on the maps ("Maps > World and Maps > Dungeons") they now link to their map info.
    • Fixed a bug in "Items > Dropped By" causing None/Unknown to appear with OBB only drops.
    • Fixed a bug causing "Go" in "Items > List By Class" to not work.
    • Fixed multiple/miss-spelt Subclasses's appearing in "Items > List By Class > Card". Thanks fakeplasticbarry.
    • Fixed ALOT of monster map locations, monster drops, monster skills errors, and other small errors. Thanks Mimscriptably, Savaela, Senshin, !Wilder!
  • 20th of March 2005 - Relena:
    • Added "Monsters > Pet Table".
    • Added "Items > Arrow Crafting Table".
    • Added MVP Mob Spawns. Thanks Lolita
    • Added MVP Search Filter. Thanks Zannah
  • 18th of March 2005 - Relena:
    • Massive Monster Locations and Drops update (stupid me was accidently using my older database). Thanks seamonkey79
    • Added "Items > Old Blue Box".
    • Added "Items > Old Purple Box".
    • Added "Items > Old Card Album Box".
    • Added "Items > Gift Box".
    • Added if an item was dropped from OBB, OPB, OCA, or GB in an items "Dropped By".
    • Fixed a bug causing items to be carried on from monsters in "Monsters > Search". Thanks Davi
  • 15th of March 2005 - Relena:
    • Added "Items > Forge List".
    • Added "Items > List By Class".
    • Added "Monsters > Hit and Flee Charts".
    • Added "Misc > EXP Tables".
    • Monsters in "Maps > View" now link to it's data. Thanks Lolita
    • Fixed a bug in "NPC buys for". Thanks Lolita
    • Fixed a display bug with Applicable Jobs/Applicable Pets in Items. Thanks Lolita
  • 14th of March 2005 - Relena:
    • New database up:
    • Items > Search
    • Items > View
    • Monsters > Search
    • Monsters > View
    • Maps > World
    • Maps > Dungeons
    • Maps > View