Midgard-Community

[Mystery 594]

 

 
 
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

• Homepage: http://www.midgard-community.com
• Forums: http://www.board.midgard-community.com
• Download System: http://www.board.midgard-community.com/files/
• Pre-Renewal Database: http://www.database.midgard-community.com
• Renewal Database: http://www.database.midgard-community.com/renewal

Edited March 21, 2016 by Mysterious
Updated first post!

[Mystery 594]

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.

[Mystery 594]

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.

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.

[Mystery 594]

 
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!

[Mystery 594]

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!

[kisuka 178]

Just a random suggestion, update the css to be responsive so the design resizes based on screen size.

 

http://getbootstrap.com/

 

http://960.gs/

[安赫尔 9]

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

[Mystery 594]

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.

[Zezicla 2]

sounds cool its like others but fresh'ed up good luck with this

[Mystery 594]

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,

 

Glimpse of a server's page.

 

 

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!

[Zephyr 2]

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:

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 October 23, 2014 by Zephyr

[GmOcean 92]

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

Edited October 24, 2014 by GmOcean

[Mystery 594]

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?

[Zephyr 2]

 

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.

Edited October 23, 2014 by Zephyr

[Xgear 44]

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

[Mystery 594]

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

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)

[Mystery 594]

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

 

Updated first post:

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

[Mystery 594]

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 !

[GmOcean 92]

D: If I had a server, I'd list it!! Fck my slow devloping skills xD

[Mystery 594]

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 [email protected] 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:

[*]Review Listing (Lists all servers) – (5 / 5) Slots Available [*]Review Listing: Low Rate – (5 / 5) Slots Available [*]Review Listing: Mid Rate – (5 / 5) Slots Available [*]Review Listing: High Rate – (5 / 5) Slots Available [*]Review Listing: Super High Rate – (5 / 5) Slots Available

[Mystery 594]

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. 

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!

[Mystery 594]

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!

 
Heres to 2015! Happy New Years everyone !

[Mystery 594]

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:

 
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>

[Mystery 594]

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

[Dastgir 1246]

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