TL;DR: Need code developers to query database that displays live buy and sell price of items in a table inside Excel or website.
Hi Everyone,
I'm trying to work on this new project regarding the RS3 Grand Exchange. Basically I'd like to create an environment where I can display live buy and sell prices of individual items. A working example can be found here: http://merchz.com/live/ - it's extremely accurate.
unescape has created a Grand Exchange database where you can find all the items that that have been implemented into the game. Apparently you can access fundamentals of this exchange through their API. Queries in the API return JSON.
They have a dedicated page here - http://services.runescape.com/m=rswi..._Exchange_APIs and a further support page here - http://runescape.wikia.com/wiki/Appl...e_Database_API
Ideally I'd like to create something identical to this page http://merchz.com/live/ which will give me live prices of all the items in the Grand Exchange. To see that page, you'll need to activate a free trial (no information needed), and become a temporary VIP. I took a look at his source code, and there appears to be some Ajax in there too, along with functions - the source code can be found here http://pastebin.com/n54kKhu9 - one of their functions is to load a table displaying live prices...here is the code:
function load_table(type, tblname){
$.ajax({
type: "POST",
url:"/ajax/get-last-live.php",
data: {type:type},
cache: false,
success: function(response){
if(type != 0 && type != 15){
$('#' + tblname + '_content').html(response);
}else{
var item_split = response.split("::::/::::");
for(var i = 0; i < item_split.length; i++){
var split_data = item_split[i].split(":|:");
var listen_geid = parseInt(split_data[0]);
var tbl_data = split_data[1];
if(response){
$('#' + type + '-' + listen_geid).fadeIn(function() {
$(this).html(tbl_data);
}).fadeIn();
Basically, it is a table of in-game items, with their live buy / sell price (instead of having to manually buy and sell an individual item in the game to determine this yourself). The Grand Exchange does display an item price on the website and in the game itself, but this is just an average, and not the live price that is being negotiated by buyers and sellers (think market efficiency).
I'm thinking there is some line of code that will make this incredibly easy for me to navigate. Basically drawing a query that asks for the buy and sell price of an item (each item has a unique ID which is usually a number, for example, a steel bar has the ID of 2353).
If you can help create this project with me - I will gladly appreciate it. What I'm fundamentally after, is the ability to create tables with items from the game, that displays their live buy and sell prices, either inside Excel, or on a website.
I can talk to you via here, or Skype / Discord if it's easier.
TL;DR: Need code developers to query database that displays live buy and sell price of items in a table inside Excel or website.
Thank-you for your time in reading and applying to this project. I look forward to working with you.