Fansite/DB Information distribution and request station - New Player Zone and General Guides - WarpPortal Community Forums

Jump to content


Photo
- - - - -

Fansite/DB Information distribution and request station


  • Please log in to reply
141 replies to this topic

#1 Oda

Oda

    Overseas

  • Community Managers
  • 10261 posts
  • Twitter:@Oda_CM
  • LocationAmatsu
  • Playing:Ragnarok Online

Posted 09 January 2015 - 01:47 PM

Hello there! I am setting up a thread to post things from our database that fansites need to keep up to date! 

 

We have to do some conversions and tweaking to clean the files up to distribute to the community so watch this space as we add more. I'll note when the file was updated so you know if the information is kept current.

 

While we're preparing the larger files for distribution, if you have specific requests for db data you can ask it here for less waiting. 

 

For the monster spawn data, we are including the DB names, Client names and monster ID numbers to make it easier for you guys to enter them into your respective wikis. 

 

Classic (updated 8/12):

 

1/9 Monster spawn data

 

3/18 Monster drop data

 

6/5 Monster drop data with percentages

 

8/12 Classic Hazy Dungeon Monster drop data

 

Renewal (updated 5/24): 

 

1/9 Monster spawn data

 

Hero's Trail Part I Monster Drops and Data 

 

1/16 Drops and data

 

1/26 HP/SP tables for Renewal characters, includes level 150+

 

8/28 New Fansite Kit

 

9/28 Episode 14.3 Monster Data and Drops info 

 

10/27 Nightmare Toy Factory Monster Drops and Data

 

Doram Update 2017

 

3/29 Doram Drops Table


  • 3

#2 DrAzzy

DrAzzy

    Really Azzy? Already?

  • VMod Retired
  • 15606 posts
  • LocationNew England
  • Playing:Ragnarok Online
  • Server:Chaos-Clandestine Society

Posted 09 January 2015 - 01:51 PM

Data got munged, at least for renewal. It looks like someone hit alphabetize on the first column, but didn't select the other columns, so now the map column doesn't match the other columns. 


  • 0

#3 DamiaN468

DamiaN468

    Amateur Blogger

  • Members
  • 356 posts
  • Playing:Ragnarok Online
  • Server:Chaos Renewal

Posted 09 January 2015 - 03:08 PM

*Breathing intensifies*...

For this and the upcoming data: Very thank you!!

Pd: check your PM, please :3
  • 0

#4 ZeroTigress

ZeroTigress

    My Offline Life is Nonexistent.

  • RO1 Member
  • 15204 posts
  • Playing:Ragnarok Online
  • Server:Sakray->Iris->Ymir->Chaos

Posted 09 January 2015 - 03:17 PM

HD official concept art for the current Rune Knights and Rebel classes? Haven't been able to find those anywhere, not even on kRO.
  • 0

#5 Nirvanna21

Nirvanna21

    They pay me to post.

  • Members
  • 9553 posts
  • LocationNew Zealand
  • Playing:Ragnarok Online
  • Server:Chaos

Posted 09 January 2015 - 03:26 PM

Hey Oda

Can I grab DB card names for the following affixes...

 

4454,Sorry
4455,Love
4480,Of Halfreload
4481,Half Jack Frost
4482,Of Half regeneration
4483,Half Spiritual
4484,Of Half Gemstone
4485,Half Abyss
4505,of Mad Witch
4506,of Archer
4507,Scaraba
4508,of Mad Berserker
4509,Insectproof
4510,Black-out
4511,Silentium
4512,of Acolyte
4513,of Thief
4514,Exorcism
4515,Flora
4516,of Stone wall
4517,of Magician
4518,Burning
4519,Seraphim
4520,Screaming
4521,Mortal Blow
4522,Cold
4523,Aquarius
4524,of Swordman
4525,Sweeping
4526,of MDEF
4527,of DEF
4528,Spirit
4529,Physical
4530,of Merchant
4531,Under Curse
4532,Sprinting
4533,Blinding
4534,Water Bomb
4998,of Valor
4999,of Aegis

 

Thanks a bunch!


  • 0

#6 Oda

Oda

    Overseas

  • Community Managers
  • 10261 posts
  • Twitter:@Oda_CM
  • LocationAmatsu
  • Playing:Ragnarok Online

Posted 09 January 2015 - 04:03 PM

Data got munged, at least for renewal. It looks like someone hit alphabetize on the first column, but didn't select the other columns, so now the map column doesn't match the other columns. 

Let me get that corrected and updated.


  • 0

#7 Oda

Oda

    Overseas

  • Community Managers
  • 10261 posts
  • Twitter:@Oda_CM
  • LocationAmatsu
  • Playing:Ragnarok Online

Posted 09 January 2015 - 05:19 PM

Ok, the Renewal DB should have the correct map names. I'll get the Classic monster n/a entries replaced with proper ones. Just results of my poor excel technique. 


  • 0

#8 AlmrOfAtlas

AlmrOfAtlas

    They pay me to post.

  • Members
  • 6533 posts
  • Playing:Nothing

Posted 09 January 2015 - 05:26 PM

Would you be able to add Monster IDs to those? DBs all have entries based on ID.


  • 0

#9 Kaymaru

Kaymaru

    I made it Off Topic

  • Members
  • 23 posts
  • Playing:Nothing

Posted 09 January 2015 - 06:52 PM

We need the monster IDs to differentiate between the different types of mobs

(plasma for example all have the same name but are very different properties)

 

- Whilst it would also be awesome for the plasma to be renamed since they can be kind of hard to tell the difference between, the mob ID numbers are still important for Homunculi and Mercenary AI scripting.


Edited by Kaymaru, 09 January 2015 - 06:59 PM.

  • 0

#10 AlmrOfAtlas

AlmrOfAtlas

    They pay me to post.

  • Members
  • 6533 posts
  • Playing:Nothing

Posted 09 January 2015 - 06:55 PM

After actually having looked through these spreadsheets, I'm having this weird feeling we just got...

 


  • 0

#11 Kaymaru

Kaymaru

    I made it Off Topic

  • Members
  • 23 posts
  • Playing:Nothing

Posted 09 January 2015 - 07:05 PM

Also Venatu and Dimik. 

Skeggiolds

picky

whisper

 

it goes on like this 


Edited by Kaymaru, 09 January 2015 - 08:09 PM.

  • 0

#12 DamiaN468

DamiaN468

    Amateur Blogger

  • Members
  • 356 posts
  • Playing:Ragnarok Online
  • Server:Chaos Renewal

Posted 10 January 2015 - 09:35 PM

Hope we get that fixed quickly.
  • 0

#13 Themes

Themes

    Too Legit To Quit

  • Members
  • 1412 posts
  • Playing:Nothing

Posted 12 January 2015 - 03:13 PM

The Classic DB on iROWiki should now be up to date.


  • 0

#14 Xellie

Xellie

    Valkyrie

  • RO Fungineering
  • 18610 posts
  • Twitter:@nekoxellie
  • LocationValhalla
  • Playing:Ragnarok Online
  • Server:Europe ban!

Posted 12 January 2015 - 03:22 PM

The Classic DB on iROWiki should now be up to date.

 

How can you have done that without mob IDs? lmao
 


  • 0

#15 VicViper7a3

VicViper7a3

    I made it Off Topic

  • Members
  • 13 posts
  • Playing:Nothing

Posted 12 January 2015 - 05:06 PM

Any chance you could share mob info/drops for some of the newer additions (Nightmare GH, faceworm, ect.)?


  • 0

#16 Oda

Oda

    Overseas

  • Community Managers
  • 10261 posts
  • Twitter:@Oda_CM
  • LocationAmatsu
  • Playing:Ragnarok Online

Posted 13 January 2015 - 10:11 AM

Hey Oda

Can I grab DB card names for the following affixes...

 

4454,Sorry
4455,Love
4480,Of Halfreload
4481,Half Jack Frost
4482,Of Half regeneration
4483,Half Spiritual
4484,Of Half Gemstone
4485,Half Abyss
4505,of Mad Witch
4506,of Archer
4507,Scaraba
4508,of Mad Berserker
4509,Insectproof
4510,Black-out
4511,Silentium
4512,of Acolyte
4513,of Thief
4514,Exorcism
4515,Flora
4516,of Stone wall
4517,of Magician
4518,Burning
4519,Seraphim
4520,Screaming
4521,Mortal Blow
4522,Cold
4523,Aquarius
4524,of Swordman
4525,Sweeping
4526,of MDEF
4527,of DEF
4528,Spirit
4529,Physical
4530,of Merchant
4531,Under Curse
4532,Sprinting
4533,Blinding
4534,Water Bomb
4998,of Valor
4999,of Aegis

 

Thanks a bunch!

Here you go. There are a number of these that we don't have ingame yet, but we are not planning on implementing the sealed card system on iRO. 


  • 0

#17 Nirvanna21

Nirvanna21

    They pay me to post.

  • Members
  • 9553 posts
  • LocationNew Zealand
  • Playing:Ragnarok Online
  • Server:Chaos

Posted 13 January 2015 - 10:22 AM

Here you go. There are a number of these that we don't have ingame yet, but we are not planning on implementing the sealed card system on iRO. 

 

Thanks a lot!


  • 0

#18 Oda

Oda

    Overseas

  • Community Managers
  • 10261 posts
  • Twitter:@Oda_CM
  • LocationAmatsu
  • Playing:Ragnarok Online

Posted 13 January 2015 - 12:08 PM

Updated links to new excel files prepared by the Producers for the monster spawns on Classic and Renewal, these will be up to date as of today. The Respawn Range number 1 is in milliseconds, just divide by 1000 to get the number of seconds for respawning. The Respawn Range 2 is the +/- variable time. 


  • 0

#19 Themes

Themes

    Too Legit To Quit

  • Members
  • 1412 posts
  • Playing:Nothing

Posted 13 January 2015 - 12:17 PM

Cool thanks Oda, I'll sort through and see if there's anything I missed.


  • 0

#20 Necrohealiac

Necrohealiac

    10,000 posts and not even a Tiki-Shirt.

  • Members
  • 13389 posts
  • Playing:Ragnarok Online
  • Server:Chaos

Posted 13 January 2015 - 12:29 PM

is there any reason why ungoliant has what is basically a one day spawn timer with another one day variable timer tacked on? i mean, is its card really that amazing that one is limited to essentially killing it every other day?
  • 0

#21 Kadelia

Kadelia

    Rainbow Sparkle, Go!

  • Members
  • 14312 posts
  • LocationVirginia, USA
  • Playing:Ragnarok Online
  • Server:Chaos/Renewal

Posted 13 January 2015 - 03:49 PM

@oda can I have ful hp/sp table of all jobs up to 175? For my calc.
  • 0

#22 Oda

Oda

    Overseas

  • Community Managers
  • 10261 posts
  • Twitter:@Oda_CM
  • LocationAmatsu
  • Playing:Ragnarok Online

Posted 13 January 2015 - 05:36 PM

Sure, I'll ask the producers to generate that table when they have a chance. 


  • 0

#23 AlmrOfAtlas

AlmrOfAtlas

    They pay me to post.

  • Members
  • 6533 posts
  • Playing:Nothing

Posted 13 January 2015 - 05:39 PM

Revised data sheets are fantastic. Thank you for that!


  • 0

#24 Kadelia

Kadelia

    Rainbow Sparkle, Go!

  • Members
  • 14312 posts
  • LocationVirginia, USA
  • Playing:Ragnarok Online
  • Server:Chaos/Renewal

Posted 13 January 2015 - 05:40 PM

Thanks <3


  • 0

#25 Oda

Oda

    Overseas

  • Community Managers
  • 10261 posts
  • Twitter:@Oda_CM
  • LocationAmatsu
  • Playing:Ragnarok Online

Posted 14 January 2015 - 04:18 PM

Any chance you could share mob info/drops for some of the newer additions (Nightmare GH, faceworm, ect.)?

Sure, it's usually easier to distribute info for newer monsters since kRO usually sends us DB excel files with the new monster stat info. 


  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users