What is Ragial?Ragial
is an iRO market site that contains live vending information and market history.What is this thread for?
Ragial now supports all iRO servers and non-iRO servers
- Bug reports
If you would like your official server included on the ragial site send me a pm or post here. I might even be able to have the item database/site layout be in the server's native language. FAQ
--[Q] How does the site get its information?
[A] A bot goes through town and submits information to the site. The site then parses the information and takes appropriate action. [Q] Has the bot ever been banned?
[A] The bot only walks through prontera for a brief period of time. It never kills any monsters, loots items, or interacts with the player base in any noticeable way. [Q] How come my vend isn't listed?
[A] The bot does not browse all of Prontera. It only browses around the fountain, down the main path, and by the park benches. Occasionally the site misses a vend or two. There is also a delay of up to twenty minutes between when you put up a vend and when the site sees it.[Q] How come the new site took so long?
[A] Ragial is quite a bit more complicated than most people realize. Ragial currently has ~12 tables per server, ~6 tables for other things, and over 1.4gb of data tracking ~3 years of valkyrie's market and Ymir since its creation. The size of the new site's back-end code is 108kb when compressed, and that doesn't count the plugins for the bot or other scripts I have written by hand.
Rewriting everything from scratch was a daunting task. There are scripts to extract information from the client, scripts to convert images from the client to proper format, and scripts to handle a lot of the database maintenance. The update script on the server alone is ~600 lines of code. On top of all this, the SQL queries required to perform all of this efficiently take considerable planning as well as testing. A single poorly indexed (or non-indexed) query on the item tables for a given server, with over 1.4million entries in some of the tables used, will murder the site's performance.
I did go months at a time without working on it, but even if I treated the site as a full time job it would have taken over a month of development effort. I'm also lazy
--Old ThreadKNOWN BUGS
-None at this time