All times are UTC - 6 hours




Post new topic Reply to topic   Page 1 of 1
 [ 8 posts ] 
Author Message

 Post subject: Item Database Suggestion
PostPosted: May 17th, 2008, 1:10 pm 
Village Legend
Village Legend
User avatar

Joined: September 16th, 2005, 5:29 am
Posts: 6,194
Location: attemping to get Tears of Guthix experience in a 99 skill
Status: Offline
I don't know how practical this is; however, with the current structure of the Runescape website, you can simply go into the Grand Exchange link and look up the price of an item. Is there any possibility of making it so that when a person looks up a specific item in the RV item database that it would simply pull the value off of this GE database from the website, always giving them an up-to-date value on the price without any need to create a database?

__________________
"I would drill through a polar bear's head to get cheaper oil." -Glenn Beck

Currently playing World of Warcraft.

For those looking for the old version of the Charm program, you can find it here: http://users.telenet.be/glodenox/Charms ... ttern.html
Note that an updated version will be released with the summoning guide.


Top
 Profile
 

 Post subject: Re: Item Database Suggestion
PostPosted: May 17th, 2008, 1:29 pm 
5000/? Earth Warriors
Priest of Saradomin
Priest of Saradomin

Joined: May 11th, 2005, 11:32 am
Posts: 1,293
Location: England
Status: Offline
Yes it is possible. Runescript currently does this.


Top
 Profile
 

 Post subject: Re: Item Database Suggestion
PostPosted: May 17th, 2008, 2:46 pm 
♫ Hakuna Matata ♫
Village Elder
Village Elder
User avatar

Joined: March 10th, 2006, 2:55 pm
Posts: 5,936
Status: Offline

Donor: Guardian (2009)
We actually also thought about that, but the only person who would be able to do this is Glodenox :cheese: , so you've got to ask him. ;)


Top
 Profile
 

 Post subject: Re: Item Database Suggestion
PostPosted: May 17th, 2008, 3:26 pm 
Village Elder
Village Elder
User avatar

Joined: September 2nd, 2005, 11:27 am
Posts: 4,588
Location: Sitting in an igloo eating beaver, drinking beer, and watching hockey, eh?
Status: Offline

Donor: Guardian (2008)
There's actually a lot of stuff we can probably do. Unless Jagex blocks this in some way, I don't see why it wouldn't be possible.

The problem is... as far as I know, we only have one admin with the knowledge to do such things, and Glodenox is often beyond busy. :|

__________________
Image | Image | Image
Image
Image | Image | Image | Image | Image
Temporarily Gone


Top
 Profile
 

 Post subject: Re: Item Database Suggestion
PostPosted: May 18th, 2008, 8:58 am 
Village Legend
Village Legend
User avatar

Joined: September 16th, 2005, 5:29 am
Posts: 6,194
Location: attemping to get Tears of Guthix experience in a 99 skill
Status: Offline
I will say that, if this were to be programmed in Java, for example, I know that this would be an extremely simple thing to do and could probably be thrown together in a few hours (with the exception of some grind work that would need to be done but that could be done by anyone, even with zero programming experience). I don't know if PHP is capable of doing it as easily, however.

__________________
"I would drill through a polar bear's head to get cheaper oil." -Glenn Beck

Currently playing World of Warcraft.

For those looking for the old version of the Charm program, you can find it here: http://users.telenet.be/glodenox/Charms ... ttern.html
Note that an updated version will be released with the summoning guide.


Top
 Profile
 

 Post subject: Re: Item Database Suggestion
PostPosted: May 18th, 2008, 12:12 pm 
Tweaking all the time
Staff Elder
Staff Elder
User avatar

Joined: July 5th, 2003, 7:13 am
Posts: 8,699
Location: Flanders (northern Belgium)
Gender: Male
Status: Offline

Donor: Knight (2012)
Friend of Hiker
By matching the item ID of the Grand Exchange with the item ID our own item database, we can request the specific page. It is a lot easier in PHP than it is in Java to get the contents of a website :P It's just filtering out the specific data we need that is somewhat harder if you don't know regular expressions (which sadly enough is the case for me).

- Greetz Glodenox :cheese:

__________________
XML, SOAP, XSLT, JavaScript, SQL, Java, CSS, PHP, Scheme, JSP, C#, ASP.NET, VB.NET, PL/SQL, Visual Basic 6.0, C/AL and C (sorted well to less known).


Top
 Profile WWW 
 

 Post subject: Re: Item Database Suggestion
PostPosted: May 18th, 2008, 2:44 pm 
Village Legend
Village Legend
User avatar

Joined: September 16th, 2005, 5:29 am
Posts: 6,194
Location: attemping to get Tears of Guthix experience in a 99 skill
Status: Offline
Glodenox wrote:
By matching the item ID of the Grand Exchange with the item ID our own item database, we can request the specific page. It is a lot easier in PHP than it is in Java to get the contents of a website :P It's just filtering out the specific data we need that is somewhat harder if you don't know regular expressions (which sadly enough is the case for me).

- Greetz Glodenox :cheese:


Getting the contents of a webpage is pretty easy in Java as well (which I'm sure you're aware of); it's the filtering aspect that I'm not so sure of with PHP. With Java, it's pretty easy to set up some loop and such that can filter the data; don't know how hard that is to do with PHP.

__________________
"I would drill through a polar bear's head to get cheaper oil." -Glenn Beck

Currently playing World of Warcraft.

For those looking for the old version of the Charm program, you can find it here: http://users.telenet.be/glodenox/Charms ... ttern.html
Note that an updated version will be released with the summoning guide.


Top
 Profile
 

 Post subject: Re: Item Database Suggestion
PostPosted: May 18th, 2008, 3:31 pm 
♫ Hakuna Matata ♫
Village Elder
Village Elder
User avatar

Joined: March 10th, 2006, 2:55 pm
Posts: 5,936
Status: Offline

Donor: Guardian (2009)
Glodenox wrote:
By matching the item ID of the Grand Exchange with the item ID our own item database, we can request the specific page. It is a lot easier in PHP than it is in Java to get the contents of a website :P It's just filtering out the specific data we need that is somewhat harder if you don't know regular expressions (which sadly enough is the case for me).

- Greetz Glodenox :cheese:

Do you know the Mozilla Firefox Add-On "Firebug"?
It views the page source in categories, which might help you find the specific section you desire.
I really like it, because you can view the HTML, CSS and Script content separately.
If interested you can get it from here. (though I have a feeling you have it already lol)


Top
 Profile
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
 [ 8 posts ] 

All times are UTC - 6 hours


Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Jump to:  

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
The Village and this web site are © 2002-2012

ThePub 2.0 - Designed by Goten & Jackstick. Coded by Glodenox & Henner.
With many thanks to the Website Team!