Midgard-Community

Mystery

Mystery

Community Contributors
Messages
2,635
Points
0
Age
33
Location
Prontera ;3
Github
Mystery
​
 ​
 
 
What is Midgard Community?

- Midgard Community is a Ragnarok Online community that provides various information regarding the world of Ragnarok. We have a Ragnarok Server Listing service that provides space for server owners to list their Ragnarok Online Private Server with us. We provide a download system to the Ragnarok Community which houses multiple files that range from NPC sprites, Class Sprites, Palettes, Maps, Items, Monsters, Cutins/Illustrations, Models, etc. !

 
Does Midgard Community have a Database?

- Midgard Community provides both a Renewal and Pre-Renewal database for our community. Unfortunately, the database is not integrated with the main site. In both databases, you'll find information regarding various Ragnarok items, monsters, and maps. We also have various calculators and informational tables.

 
What is Midgard Community's Download system?

- The download system found in Midgard Community's forum houses tons of files that range from NPC sprites, Class Sprites, Palettes, Maps, Items, Monsters, Cutins/Illustrations, Models, etc. In order to get any files from the system, you must be an active member in the forum. The plan for the download system is to be the #1 stop to get files for a server owner's Ragnarok Server.

 
API (Application Programming Interface)

- As suggested by a member of the community, I've worked diligently with a fellow friend on implementing an API for Midgard's database. When you send a request for either an item or monster, you'll get different structured outputs returned back to you depending on what you've searched for.

 Item

[
    {
        "id": "",
        "name_english": "",
        "name_japanese": "",
        "type": "",
        "price_buy": "",
        "price_sell": 
        "weight": ""
        "attack": 
        "defence": 
        "range": 
        "slots": 
        "equip_jobs": "",
        "equip_upper": "",
        "equip_genders": "",
        "equip_locations":
        "weapon_level": 
        "equip_level": 
        "refineable": 
        "view": 
        "script": "",
        "equip_script": 
        "unequip_script": 
        "Description": "",
        "Description_IRO": 
        "Episode_Info": 
        "Droppers": ""
    }
]
 
Monster

[
    {
        "ID": "",
        "Sprite": "",
        "kName": "",
        "iName": "",
        "LV": "",
        "HP": "",
        "SP": "",
        "EXP": "",
        "JEXP": "",
        "Range1": "",
        "ATK1": "",
        "ATK2": "",
        "DEF": "",
        "MDEF": "",
        "STR": "",
        "AGI": "",
        "VIT": "",
        "INT": "",
        "DEX": "",
        "LUK": "",
        "Range2": "",
        "Range3": "",
        "Scale": "",
        "Race": "",
        "Element": "",
        "Mode": "",
        "Speed": "",
        "aDelay": "",
        "aMotion": "",
        "dMotion": "",
        "MEXP": "",
        "MVP1id": "",
        "MVP1per": "",
        "MVP2id": "",
        "MVP2per": "",
        "MVP3id": "",
        "MVP3per": "",
        "Drop1id": "",
        "Drop1per": "",
        "Drop2id": "",
        "Drop2per": "",
        "Drop3id": "",
        "Drop3per": "",
        "Drop4id": "",
        "Drop4per": "",
        "Drop5id": "",
        "Drop5per": "",
        "Drop6id": "",
        "Drop6per": "",
        "Drop7id": "",
        "Drop7per": "",
        "Drop8id": "",
        "Drop8per": "",
        "Drop9id": "",
        "Drop9per": "",
        "DropCardid": "",
        "DropCardper": "",
        "ItemDrops": ""
    }
]
However, not anyone can fetch what they want. When you create an account through the main site, if setup, there will be a token assigned to your username. You will need this token in order to fetch data from the database.
 
Required Fields:

  • api_key
  • id (Item / Monster ID)

​Optional Field:

  • type - If no type is given, you'll directly get an item. To get monster, set Type's value to 1.
 
Site Links & Information

 
Last edited by a moderator:
I've launched my Community Boards over a week ago for testing purposes and I've given my link to certain people but I feel it should be spread a little bit more now xD. You can find my Community Boards here.

On a side note, I've overhauled the Boards. Find out here.

 
Hey everyone!

I decided to create a quick simple Search Box for our Database located right inside out Boards. Why? Well, whatever you search in that search box will give you a list of results in our actual database provided through Google. But why Google? With using Google as the search engine allows Google's Crawl Bot to consistently crawl our Boards while providing hits to our site.

Screen Shot 2013-03-16 at 8.32.24 PM.png

However, keep in mind that whatever you're searching in our Search Box will only redirect you to findings within our database. For example, if you search 'Poring', you will only be redirected to several pages in our database the contains the word 'Poring'. In other words, the search results will only be from our database and not from the entire web.

 
Q0ExxwD.png
 
Our database has gotten a nice clean and sleek uplifted design. What do you guys think about it? Something a lot different than what it was before (if you remember what it looked like before)! Also, with this new design I've been working on (with the help of Strudel <3) I've also created a Character Skill Simulator and also a simple Potion Creation Calculator!
 
Last edited by a moderator:
Hey everyone,

it's never too late to update the database... and well, it's that time again! I've been working on our databases: Pre-Renewal and... Renewal! Yup! I now added a Renewal database (it's about time). Keep in mind the Renewal Database still needs to go through some colours just like our Pre-Renewal one did. Anyways! Lets move onto what I did!

Pre-Renewal / Renewal

  • Pre-Renewal database got a new colour scheme: http://database.midgard-community.com/
  • URL to Renewal database: http://database.midgard-community.com/renewal/
  • Added now a link to Renewal Database VIA the sidebar under 'Main Page' link (Pre-Renewal Database)
  • Added now a link to Pre-Renewal Database VIA the sidebar under 'Main Page' link (Renewal Database)
  • Added now a link to Calculators - a section that I will display different calculators (i.e. Potions, EDP Creating, etc.)
  • Both databases Experience and Drop rates have been adjusted to kRO's official Experience and Drop rate
  • Both databases got new structure/code tweaks
And to top everything all off.. I finally added the long awaited "Script", "Equip Script", and "Unequip Script". Yup, you read right! Now, every time you search for an item, you will see their scripts. Check it out here: http://database.midgard-community.com/?act=itemsearch&ctype=on&type=5&cmax_page=on&max_page=40&cdisplayorder=on&displayorder=100#main

As I mentioned above, the Renewal database is still new so I'm not done adjusting its tables. But, I'm a step closer!

 
rosfus said:
The map system is very very nice. Did it support multiple languages?
Click to expand...
I currently have a Google translate hooked on the site (bottom left corner). Changing the language there changes the language throughout the page and it works from what I've tested.

 
Update:

Midgard-Community (MC) is in its final stage of development! The main site has been coming along nicely and I'm very proud of it!

To give everyone a preview of how the main site will look,

Screen Shot 2014-10-20 at 4.36.24 PM.png

Glimpse of a server's page.

Screen Shot 2014-10-20 at 4.40.07 PM.png

These are the only screenshots I will provide to show a preview! Everything else will be kept a secret :> ! I've had a couple of people try out my site and walk through it and experience it as a server owner as well as from a player's standpoint; needless to say, their experience has been great!

So for that, I'm glad to see that the site is headed in the right direction!

 
Suggestion:

When we do a search, make it to show the fields we put again, example: if I search for the item ID 1723, it takes me to this page:

30b8fef0f1.png


Above that little "search result" window, you could implemente another small window with the fields we filled before, so we can search another item on that screen without clicking the "back" button to search it again. If I filled the ID field, the ID field will be shown there, if I filled another fields, it'll appears too (but only the fields we filled before). It'll allow fast searches through the database.

If you implement AJAX request, it'll be amazing too. When we click the "search button" or press enter, instead of the page reload, it'll show a "loading" gif and then the page shows the info. It'll increase the speed, and it'll be the faster database ever created, and your database will be unique, doing what no other database does, focusing on speed and an easy interface that allows the users to search over and over again with just a few clicks.

Now, other amazing suggestion for you: make an API that returns JSON data with the infos, this way, web developers (like me) can make a request to your database like:

http://database.midgard-community.com/?api=database&search=item&id=1723
And it will return something like:

data = { item: { id: 1723, name: "Luna Bow", desc: { "A bow crafted out of moonstone with an attached blade that allows its user to block and counter enemy attacks. ", "The drawback is that this bow is quite heavy.", "[Refine Rate 0~6]", "DEF + 2", "[Refine Rate 7~8]", "DEF + 3", "[Refine Rate 9~10]", "DEF + 5", "[Lunatic Brooch & Luna Bow Equip Set]", "Class : Bow", "Attack : 100", "Weight : 200", "Property : Neutral", "Weapon Level : 3", "Required Level : 30", "Applicable Job : Hunter" }, droppedby: { monsterid: 1650, monstername: "Sniper Shecil", rate: "10%" } }}
If the item doesn't exists:

data = { error: 1, errorException: "This item doesn't exists."}

And then your database can be implemented at any other site easily, allowing users can search for your database from any site that implements it, of couse, at the result, including the link for your site, or even a link with something like "See full info clicking here" and then going to the original link.

OR, if you are planning to receive donations or selling features, you can sell it to the servers, making some very simple window with the API implemented, so the admin can just iframe it into their sites to search anything, and you can control the requests for any server like that:

http://database.midgard-community.com/?api=database&user=zephyr&search=item&id=1723
If the zephyr user has no permission (didn't buy the api feature), it simply return an errorException like I said before.

I liked the website, I'll save it. I'd like to see the implementations.

 
Last edited by a moderator:
This looks amazing. How far along would you say it is towards completion? 20%? 50%? 99% (I hope)? lol.

Edit: @Mysterious ( below ) - Yeah, I meant the main page lol. And glad to hear it's so far along
default_biggrin.png


 
Last edited by a moderator:
Zephyr said:
Above that little "search result" window, you could implement another small window with the fields we filled before, so we can search another item on that screen without clicking the "back" button to search it again. If I filled the ID field, the ID field will be shown there, if I filled another fields, it'll appears too (but only the fields we filled before). It'll allow fast searches through the database.
Click to expand...
Thanks for your response! This I can probably do. As for your second suggestion, I don't think I can necessarily do it just 'cause I'm not skilled enough when it comes to coding lol.
GmOcean said:
This looks amazing. How far along would you say it is towards completion? 20%? 50%? 99% (I hope)? lol.
Click to expand...
Thanks for your response as well! I would say it's roughly at 90% completed. I'm assuming you mean the main page, right?
 
Mysterious said:
Zephyr said:
Above that little "search result" window, you could implement another small window with the fields we filled before, so we can search another item on that screen without clicking the "back" button to search it again. If I filled the ID field, the ID field will be shown there, if I filled another fields, it'll appears too (but only the fields we filled before). It'll allow fast searches through the database.
Click to expand...
Thanks for your response! This I can probably do. As for your second suggestion, I don't think I can necessarily do it just 'cause I'm not skilled enough when it comes to coding lol
Click to expand...
It's easy, when you have time, send me a message and we can talk about it. I can teach you how to send and receive JSON data and you'll see how it's easy.
default_laugh.png


 
Last edited by a moderator:
The API suggestion is indeed pretty good suggestion, Thumbs up for that one. 

 
GmOcean said:
GmOcean, on 22 Oct 2014 - 19:56, said:

Edit: @Mysterious ( below ) - Yeah, I meant the main page lol. And glad to hear it's so far along
default_biggrin.png
Click to expand...
Ah, then yes. It should be done next week ;D
Xgear said:
Xgear, on 23 Oct 2014 - 00:42, said:

The API suggestion is indeed pretty good suggestion, Thumbs up for that one.
Click to expand...
Indeed it is! And as requested, I've recently been diligently working on this suggestion! (With some help of course)
default_biggrin.png

 
Last edited by a moderator:
I would like to thank everyone for the suggestions! I've implemented the API suggestion (with the help of a friend
default_biggrin.png
) as well now. Refer to first post!

Updated first post:

  • Changed up a few words / sentences
  • Changed images
  • Talked about the addition of API.

 
Last edited by a moderator:
I would like to thank everyone for taking their time and writing feedback towards my project! For that, I would like to welcome Midgard-Community to the public!

The public may now access Midgard-Community at http://www.midgard-community.com !

I hope server owners / server players enjoy new and different features that are offered through the site! I can't wait to start seeing servers being listed
default_smile.png
!

 
Last edited by a moderator:
You must log in or register to reply here.
Back
Top