RS3 Market Watch data
Import the pages from here:
https://secure.runescape.com/m=itemdb_rs/
Would need an item database
then each item would need price details
how to store the price details, all in one table or seperate per item.
- Item Database
- Price Database linked to item database, keeping price history.
Links
Price Rises : https://secure.runescape.com/m=itemdb_rs/top100?list=2
Price Falls : https://secure.runescape.com/m=itemdb_rs/top100?list=3&scale=0
Valuable Trades : https://secure.runescape.com/m=itemdb_rs/top100?list=1&scale=0
Most Traded : https://secure.runescape.com/m=itemdb_rs/top100?list=0k&scale=0
Class
rs3_items
Import Stage 1
loop through this list: https://secure.runescape.com/m=itemdb_rs/top100?list=2
add item to rs3_items if title md5 does not exist, needs a flag for processed and url for full details.
Structure elements
HTML
<tr>
<td>
<a href="https://secure.runescape.com/m=itemdb_rs/Bottled+dinosaur+roar/viewitem?obj=48926" class="table-item-link">
<img class="table-item-image" src="https://secure.runescape.com/m=itemdb_rs/1653310924541_obj_sprite.gif?id=48926" alt="Bottled dinosaur roar" title="Bottled dinosaur roar"><span>Bottled dinosaur roar</span>
</a>
</td>
<td class="memberItem"><img src="https://www.runescape.com/img/rs3/grand_exchange/tick.png" title="Members Only" alt="Yes"></td>
<td><a href="https://secure.runescape.com/m=itemdb_rs/Bottled+dinosaur+roar/viewitem?obj=48926">8,816</a></td>
<td><a href="https://secure.runescape.com/m=itemdb_rs/Bottled+dinosaur+roar/viewitem?obj=48926">9,692</a></td>
<td><a href="https://secure.runescape.com/m=itemdb_rs/Bottled+dinosaur+roar/viewitem?obj=48926">876</a></td>
<td class="change positive"><a href="https://secure.runescape.com/m=itemdb_rs/Bottled+dinosaur+roar/viewitem?obj=48926">+9%</a></td>
</tr>Price Data Changes
Seperate table linked to main item id uid or md5
Single Item
https://secure.runescape.com/m=itemdb_rs/Crystal+skillchompa/viewitem?obj=40995
rs3_items class extend
PHP
public $load_array = [
"id",
"uid",
"insdate",
"title",
"additional",
"category",
"md5",
"members_item",
"image_url_small",
"image_url_large",
"item_id",
"item_url",
"processed",
];Added new price rise import
RS3 Prices Class Extend
PHP
public $load_array = [
"id",
"uid",
"insdate",
"title",
"additional",
"category",
"md5",
"item_id",
"price_start",
"price_end",
"price_rise",
"price_change_percent",
];1st Level import for this is now running every hour.
https://api.kruxor.com/list-table/rs3_items/
https://api.kruxor.com/list-table/rs3_prices/
Price Changes
I noticed that the prices listed are not accurate, they seem to have some rounding in them.
price_start
9,960
price_end
11.0k
price_rise
1,044
So to get the correct rise, just ad the start price and the price rise, rather than relying on the price_end
RS3 Item Search JSON Examples
Example item:
title: cooked meat
item_id: 2142
item list:
latest items: https://api.kruxor.com/json/rs3_items/latest/start/50/
item search:
https://api.kruxor.com/json/rs3_items/search_list/title/?search_value=cooked%20meat
price search link:
https://api.kruxor.com/json/rs3_prices/search_list/item_id/?search_value=2142
How to get this working in kruxor front end.
tool and frontend done
need to get this into re-usable functions for other data.