Skyeam

Naaah! Don't think so. (F2P myself) What would be handy: Prayer potions! Or at least somewhere to recharge your prayer in pvp... (altars are way too far) a little more bank space :D

Currently I'm just working offline on the access. The prices will be automatically integrated from the runescape website. Maybe Later I will synchronize it with an online mySQL server, but first things first.

Hello, I'm planning to make a database with ms access 2007. It'll be about Runescape prices in the GE. I want to display the price from an item at a certain date. Of course I will be having multiple items. However, I can't find out how I should create my database. I started with 3 tables. The First one was just Item info, containing the columns: Item_ID (=jagex item id) ; Item_name ; Item_P2P (=F2P or P2P) ; Item_HighAlchVal ; ... The second was just about the date: Date_ID The third talked about the price: Price_ID ; Date ; Item_ID ; Price The first table was linked to the third by Item_ID to Item_Id. The second to the third by Date_ID to DAte_ID. However, I get a huge table then with not much structure: different dates and times mixed. But I can't find a way to structure it without having to create a new table for every Item... Which Is way too much work...

I found this code and it worked pretty well. However, I decided I would better go with an access database. In that way I can store prices in a better way. After that I can insert them into an excel file anyway. Thus currently I'm looking for a way to store those prices from the GE in a database, and I think there are better ways than this code. However, I still appreciate your help, and that excel is exactly what I'm planning. Also things like high alchemy loss can be calculated really fast that way. <?php function getprice($id) { $url = "http://itemdb-rs.runescape.com/viewitem.ws?obj=".$id; $startat = "Market price: "; $stopat = ""; $ch = curl_init(); $timeout = 5; curl_setopt ($ch, CURLOPT_URL, $url); curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt ($ch, CURLOPT_CONNECTTIMEOUT, $timeout); $start = curl_exec($ch); curl_close($ch); $exploded = explode($startat,$start); $exploded = explode($stopat,$exploded[1]); $result = str_replace(' ','',nl2br($exploded[0])); return $result; } echo "prijs van grain: ".getprice(IDVANGRAINHIER); ?>

That would be really helpful! Any idea when you could have the code? On your problem: You could use a free spreadsheet maybe like openoffice or staroffice. Secondly, aren't there any free webhost you can use? Even if they shut you website down after a month, there are still so many others which provide php support for free.

I searched, but I could only find price checkers, just like the GE database website actually is. I don't need those things, I need to be able to make calculations with those data. I will be making automatic future predictions and so on, to help merchandising. But I need the prices to be automatically updated in my worksheet.

Hello, The introducing of the GE-database makes the life of us players a lot easier. However, I still find myself clicking daily trough too many pages, with too long load times. I would like to add certain GE items, with their prices, date, graph, and so on to a centralized place. For this I took excel, because it's pretty good at doing basic handling of information. However, when I use web queries in excel to get runescape pages, I just get a bunch of mess. I would like to only take the prices, name, price change and so on (anything relevant) and not all that random stuff like "Go To Homepage" in my excel. However, I have no idea how I could do that. I've looked how I can get updates from the GE, (like they do in the tip-it price guide), but it's php and so on (which I don't know anything about) and thus not competent for doing what I want in excel. Thus, I'm looking for some help for making a decent centralized place for some Runescape prices: First of all: Should I stick with MS excel for this, of should I change to MS access or something else? Should I use another kind of excel like Openoffice Calc? Then: How could I realise this in the chosen program? Finally: Is this the right subforum? Or should this be in Tech and Computers? Thank you for at least reading this! Btw: Using MS office 2007 and OpenOffice 3.0, In possession of MS office 2003 and OpenOffice 2.0