Mystery

Midgard-Community

76 posts in this topic

mgLogo.thumb.png.807ff142f0c7c861a342496

 

 
 
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

Edited by Mysterious
Updated first post!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Q0ExxwD.png?1

 
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!

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

The map system is very very nice. Did it support multiple languages?

Share this post


Link to post
Share on other sites

The map system is very very nice. Did it support multiple languages?

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.

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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.

Edited by Zephyr

Share this post


Link to post
Share on other sites

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 :D

Edited by GmOcean

Share this post


Link to post
Share on other sites

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.

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.

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

Thanks for your response as well! I would say it's roughly at 90% completed. I'm assuming you mean the main page, right?

Share this post


Link to post
Share on other sites

 

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.

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

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. :lol:

Edited by Zephyr

Share this post


Link to post
Share on other sites

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 :D

Ah, then yes. It should be done next week ;D

Xgear, on 23 Oct 2014 - 00:42, said:

The API suggestion is indeed pretty good suggestion, Thumbs up for that one.

Indeed it is! And as requested, I've recently been diligently working on this suggestion! (With some help of course) :D

Share this post


Link to post
Share on other sites

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

 

Updated first post:

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

Share this post


Link to post
Share on other sites

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 :)!

Share this post


Link to post
Share on other sites

Hey everyone! I think it's time to add some more 'liveness' to our main page by bringing in more servers to register with us! For this, I'm offering free ad spots for a whole free month!
 
If you visit our ad page, you'll notice I have two advertisement spots labeled. One being Kafra's Bulletin and Kafra's Cover. For new servers that are going to be listed, I'll be giving them a spot (server owner chooses) in Kafra's Bulletin for a full 30 days for free*

 
* Terms & Guidelines
Before getting your ad listed with us, there are a few guidelines a server owner must adhere to:

    [*]Ad Dimension: 700 x 90 [*]Your server must be newly listed with us [*]You must have a 24/7 up server [*]Must follow our Server Owner Rules [*]You must have a link on your server's homepage that redirects users to review your site on Midgard-Community [*]You must email us at administrator@midgard-community.com with the following criteria (taken from our ad spot):
      [*]Your username registered here at Midgard-Community [*]You must show your server’s banner (As an attachment or as a link) [*]Name of Advertisement section(s) (names are listed below) [*]Target URL (i.e. landing page) [*]and, the spot you are going to choose for that specific advertisement section (i.e. from review listing, review listing: low rate, etc).


I will only be accepting the first 25 newly listed servers! This will be a first come first served basis. Please check the availability down below for available spots.
 
Availability
To keep track of available spots, here is the current list:

Share this post


Link to post
Share on other sites

Update:

 

Free advertisement is still available! It'll be available for the first 25 new servers listed! There is no timeframe for you to get the free advertisement, there is however, a first come first served basis. First 25 new servers to email me with the proper guidelines (listed above) will get their free spot! 

 

Moving along now! I've been playing around with app making and I created a very basic app for Midgard Community! It currently only runs on iOS and no other platform. 

uC5Wy0l.png

As I've mentioned, it's a very basic app. and what I mean by that is, the app is used for gathering quick information regarding Migard Community. You get quick access to email function, news, events, Twitter feed, and links to our pre-re and renewal databases! 

 

You may check out more information on our landing page: http://midgard-community.com/landing/

 

It is currently not available at the moment. I'll be releasing it in the near future!

Share this post


Link to post
Share on other sites

Update:

I would like to thank everyone! Midgard Community officially launched on November 25th 2014 and I've noticed a potential growth already of users both on the boards and main page! To end off 2014, we've reached 104 users on the main page with 7 published servers and 90 user registrations in December alone!
4dSE947.png
 
Heres to 2015! Happy New Years everyone !

Share this post


Link to post
Share on other sites

Update:
 
It's taken a little long, but it has finally arrived! Server owners now have access to a "Review us at MC!" button for their servers! Head over to your account and you can see the preview of the button! The output is in HTML and if you don't like the button, you can always remove it!
 
Image Preview:
ReviewMC.png
 
Code Example:

<a href="http://www.midgard-community.com/server/test/"><img src="http://www.midgard-community.com/wp-content/themes/midgard-community/images/ReviewMC.png" alt=""></a>

Share this post


Link to post
Share on other sites

Little information everyone should know!

 

During the migration of our boards, we lost a bit of topics / posts / and files. Sadly, the SQL file got corrupted that held these. However, all accounts / customizations, etc. have been saved.

 

To begin with, the boards didn't have too many topics / posts / files to begin with, so it wasn't a huge loss! I've taken extra precaution to make daily backups of our boards (and of course our homepage and database).

 

MC just needs support now from our fellow members to help repopulate our boards :) Head on over: http://www.board.midgard-community.com

Share this post


Link to post
Share on other sites

Little information everyone should know!During the migration of our boards, we lost a bit of topics / posts / and files. Sadly, the SQL file got corrupted that held these. However, all accounts / customizations, etc. have been saved.To begin with, the boards didn't have too many topics / posts / files to begin with, so it wasn't a huge loss! I've taken extra precaution to make daily backups of our boards (and of course our homepage and database).MC just needs support now from our fellow members to help repopulate our boards :) Head on over: http://www.board.midgard-community.com

Error on visiting board

 

 

Fatal error: Call to a member function primary_navigation() on a non-object

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now