SRL Archive - Outdated / Broken

Grand Prices
By Drunkenoldma, Nielsie95 and c0de

Okay, as some of you might know I had an idea to combine a SCAR script with PHP, and make something usefull out of it. The idea was to make a SCAR script that scans Grand Exchange prices, and get the itemprice out of it, put the price on a server, and tadaa, you got a searchable-item-database.
I made a thread on the Members news, asking for people that could help me, and if people would really like something like this, I got replies fast enough, and people were very willing to help, though, nielsie95 came with the first scar script, and he IM'd me on MSN too, we discussed the topic, and we worked together on what we have now, the SCAR script is downloadable here, and the website link with all the items is: http://www.ex-convicts.be.

SCAR will take items that need to be updated from an online list, and will store them back there too, so you need to give permission to scar to do that.

On the website, you will be able to register too, when you register, you can put your username and password in the SCAR script, which saves how many items you have scanned (nothing to show it yet, but will come later tonight, tomorrow, the day after, I don't know :p)

Oh, before I forget, this 'beta phase' of the project only scans for free players items, so members need to wait a bit, but it's certainly coming.

Oh, I want to thank everyone who gave his idea's, and offered some of his work, you've been great help, I wanna thank Nielsie95 so much, cuz he did all the SCAR-side, I wanna thank c0de too for his great artwork, and his help on the php-side :)

And umm, please donate, or click the ads, this will help us get money for the host, and a domain that fits the site, and to get member accounts to scan the GE for members items.

Thanks
Drunkenoldma

Awsome stuff =D thanks. I will work on the banner now :D

Do you guys need someone to run a scar script on it 24/7? I can do that

From: hugolord
Do you guys need someone to run a scar script on it 24/7? I can do that

No, as GE only refreshes every day, 24/7 is too much, with the script, I think you can scan whole GE in 2 hours :)

From: Drunkenoldma
No, as GE only refreshes every day, 24/7 is too much, with the script, I think you can scan whole GE in 2 hours :)

ow good ^^

nice script btw

You could run 24/7 though, it rests a bit when it doesn't need to search for items ;)

Someone needs some grammar lessons

There are 573 items in the database,
100 gave an error (didn't found the item, and will be fixed later on),
and thus 473 items didn't gave an error =).

Anyways, good work, I'm sure the people on the rs forums would also appreciate this ;), put some ads on their and make some money :)

This is so awsome :D ill certainly use it :D

I see some of what we discussed in msn here. Good job. I would have made it last night for you if I didn't get so drunk.

Very nice, does it also work with member items?
EG: I could not find 'abyssal whip'.

Nice. I didn't think it would be completed so quickly at all. If I actually played RS legitly I would use this, its much faster than all of the other sites with lots of formatting.

@Sp0rky - I want booze!

Damn nice guys, that was done really fast lol. Glad I didn't end up doing it… I mean I wish I had time to do it. ;)

From: Wizzup?
Very nice, does it also work with member items?
EG: I could not find 'abyssal whip'.

Oh, before I forget, this 'beta phase' of the project only scans for free players items, so members need to wait a bit, but it's certainly coming.

I'll do member scanning if you want. Well when you update the list I guess.

From: Narcle
Damn nice guys, that was done really fast lol. Glad I didn't end up doing it… I mean I wish I had time to do it. ;)



I'll do member scanning if you want. Well when you update the list I guess.

Lol, ok thanks!
I didn't read the entire post.

First we need to get all free items working. That means change names and delete/add items.

From: Wizzup?
Lol, ok thanks!
I didn't read the entire post.

Figures… you just try it and go YOU FAIL! or YES! ;)

wow this looks nice!!!. but for what can we use this?

edit: nvm. its not a scripting tool. but more a tool for those who still play rs.

Proggie:

15 Minutes and 49 Seconds
29 Minutes and 52 Seconds
43 Minutes and 52 Seconds
57 Minutes and 57 Seconds
1 Hours, 11 Minutes and 58 Seconds
1 Hours, 26 Minutes and 3 Seconds
3 Hours, 9 Minutes and 13 Seconds
3 Hours, 22 Minutes and 28 Seconds
3 Hours, 35 Minutes and 39 Seconds

It did the list in 1 hour and 26 mins, waited for 1,5 hours and continued. It's done again now :)

Nice nielsie, code looks clean :)

Great :) Would be good to have a "Last updated" field in the database so we know when to update it next? So if it hasnt been updated for say, 2 days, then put that as high priority for the script to update it

here's my suggestion: don't only keep the current prices, also keep track of past prices. this will be of a huge economic value and we can predict what is worth selling / buying and when, which can help us decide on what to macro :) it can also help us decide what to merchant and predict future prices ;)

(yes i love economics :P)

~RM

From: Rasta Magician
here's my suggestion: don't only keep the current prices, also keep track of past prices. this will be of a huge economic value and we can predict what is worth selling / buying and when, which can help us decide on what to macro :) it can also help us decide what to merchant and predict future prices ;)

(yes i love economics :P)

~RM

Even create charts and such

That would take up a lot of space. Especially for 700+ items.

From: nielsie95
That would take up a lot of space. Especially for 700+ items.

Nah. The entire SRL forum is like… 100mb?
1 Week would be 7*700 items. Thats nothing. ;)

Thats exactly what databases are for. In fact, you are looking at one now :)

Wow this is really awesome… Maybe the guys at Zybez would be interested in this ;D

Why would you check the price yourself when you can rely on SCAR? :D

Ok, I edited the PHP side of the script now, it saves all historical info to the database now too, and it gives a history graph (perfecting this now =/ (kinda hard lol))

I think you should link it to the site in your sig, not just this thread, unless you want it to only be SRL membe

its srl members only :)

gotta say i love this, but does anyone else notice if you leave the site up, and have a runescape client open, the client lags real bad? idk why it would do that, but it always does for me.

History graph looks good :) just throwing the ideas out here now, but it would be cool to have a page which shows the biggest rises %wise over the last week, or last day or whatever. and noticed a bug…some of the more expensive items, like party hats arent showing up as their correct prices - for example, blue party hat at 5 560 000 Gp when they are a lot more than that. might be going over the integer limit at a guess? could be fixed by making the field in the db a longint maybe

From: The Claw
some of the more expensive items, like party hats arent showing up as their correct prices - for example, blue party hat at 5 560 000 Gp when they are a lot more than that. might be going over the integer limit at a guess? could be fixed by making the field in the db a longint maybe

You're right.. That's a bug in the script

Change a similar looking line in function GetMarketPrice to this:

Result := StrToIntDef(GetNumbers(GetTextAtEx(x - 3, y -1, 10, StatChars, False, False, 0, 2, 39321, 20, False, tr_Digits)), 0);

Thank you =]

Updated the graphs, cuz with items with very high prices (10m+) he didnt show full itemprice (was cut off), fixed now

Btw, 100th post :D

I just found out.. The database doesn't contain any Sets of Armour :(

I love you c0de.

You could do an aweful lot with that information. Its very useful. You might have well struck a goldmine here guys. The current presentation is perfect. I say let this grow for a couple of weeks and then start selling subscriptions (did I say that?) People will be very interested in this graphed out information. You've build a stock exchange. Buying/Selling in large quantities will be the next big thing in the economy. Its only natural. Its very simple now to see which items buys best and which item sells best. If I where you, I'd set up a character with lots of money on it and see how rich you can make it. I will gradly donate 1 mill :)


BTW: Do you also register min and max prices? If not, do so :)

Updated the php side, so it will search more accurate items

From: WT-Fakawi
BTW: Do you also register min and max prices? If not, do so :)

We didn't cuz it's a different font and stuff, but i'm kinda sure it will come later on :)

Wow, this is truly amazing. I rarely post around here anymore (But i do look around every now and then, i just rarely feel like posting anything) But this made me want to post xD

The only suggestion i could think of is for the graphs, having the number written over each point on the graph. (If possible, might not work when there's a ton more points on the graphs though)

And like Fakawi said, the min and max prices. If it had all that it would be simply amazing. Well, it's already amazing, but still xD

I will definitely be keeping around to see how this develops, and probably be using it as well. Can't wait to see the rest of the items added, then it'll be even more useful.

Ooo very nice job! Working great :D.

Hmm, one problem that could affect something is that the graph continues even if you haven't looked up the price for that day, so you could be flat lining for a while just because you didn't search the price that day. You should make it only add a date in the graph if it gets an uploaded price.

Owah ive been watching this from the start. All i can say is code you are a graphics master :P haha. Love all the colors and everything. And the graphs are awesome. You could spend forever looking on there tracking ups and downs.

From: Bobarkinator
Hmm, one problem that could affect something is that the graph continues even if you haven't looked up the price for that day, so you could be flat lining for a while just because you didn't search the price that day. You should make it only add a date in the graph if it gets an uploaded price.

The graph is good, I tested it and stuff, its just the price that didn't change ^^

From: mastaraymond
I just found out.. The database doesn't contain any Sets of Armour :(

Why is everybody ignoring my post :'(..

From: mastaraymond
Why is everybody ignoring my post :'(..

From: c0de
Soon, drunken already said it's in beta phase :-) Not all items are supported at this moment.

Because you suck!! or you didn't look good enough :)

From: Dumpin
Because you suck!! or you didn't look good enough :)

Omygosh. I guess im drunken without drinking.. Sucks :(

There are 552 items in the database,
0 gave an error (didn't find the item, and will be fixed later on),
so 552 items didn't give an error =).

:) Now we can add items, f2p first. Which items did we forget?

Sets of armour.. anything else?

You still messed up your grammar on that.

From: nielsie95
:) Now we can add items, f2p first. Which items did we forget?

Sets of armour.. anything else?

Rares. (Halloween masks)
Rares should be a priority.

Check h'ween ;)

My bad, no grammar errors :)

Hm, one thing i'm noticing is that it bases the up/down arrow on the highest/lowest price and the current price. I think instead of how it is now, it should say the amount the item is worth (but without any arrow next to it) and then in another column have the symbol, showing how much it went up or down from the last time the price was updated. In other words, instead of

Item Name - Symbol Based On Entire History/Current Price - Last Updated

something like

Item Name - Current Price - Symbol Based on previous update and most recent update/Amount of gp up or down from between last two checks - Last Updated

Each "-" representing a seperate column, and the "/" representing that they're in the same column, but i put it to make it clear that they're separate things.

Because from what i can tell, if the item's first price was to be, say 100 gp, and then the next day dropped to 50, the arrow would be red. (Which makes sense) but then the next day, say it raised to 70. The arrow would remain red, even though it went up, because it's comparing it to it's highest ever price (I think?) What i'm getting at is i think it'd be better if the arrow represented it's most recent change.

Looking extremely forward to members items being added.. :) Also, could i ask what the premium button is for? And i'm still trying to decide whether or not i like the way the graph pops up now xD

By the way, you guys do know that Jagex is adding the same thing you guys worked so hard to create to their homepage? With a little search bar too.

awh thats bullshit f*cking jagex…

From: Swift
By the way, you guys do know that Jagex is adding the same thing you guys worked so hard to create to their homepage? With a little search bar too.

They state they are making a website to keep track of the items. Not that they will make an actual search bar, right?

Post it on the RS forums! Beat Jagex to it.

@NewToAutoing: I like the format you have laid out. However I think it does go off the most recent update. I like it better that way, I couldn't tell if you liked it better from the highest price ever or from the recent update.

From: Runescape.com
while a new web page is already in the works which will allow you to track item prices over a long period of time.

Interpret it as you want…

Missing Adamant and Rune ores + bars. This really is a fun tool.

From: Bobarkinator
Post it on the RS forums! Beat Jagex to it.

@NewToAutoing: I like the format you have laid out. However I think it does go off the most recent update. I like it better that way, I couldn't tell if you liked it better from the highest price ever or from the recent update.

No, i've seen it go off the highest price. I like it better from the recent update though (Like you said you do) :p Lemme go and make sure it still goes off the highest price though..

Edit: Search coal. First price was 164 gp, from there it went to 162. Most recent update it went up to 163. Has a red, down arrow. So yeah, i think it still goes by highest price ever.

From: NewToAutoing
No, i've seen it go off the highest price. I like it better from the recent update though (Like you said you do) :p Lemme go and make sure it still goes off the highest price though..

Edit: Search coal. First price was 164 gp, from there it went to 162. Most recent update it went up to 163. Has a red, down arrow. So yeah, i think it still goes by highest price ever.

confirmed, how about having a long run arrow (that'll tells us how much it's gone up/down in the past 7 days?) and another arrow that'll compare it to the day before?

and how about giving me premium for suggesting the graphs back on the first page? :p

~RM

It would be nice for a updated GP script, for the new server and all…

That would be nice, yes :rolleyes:

It's just that I don't know where the new file is located.

…

I remember when Drunkenoldma wanted to do something like this, i gave my agreement…

I forgot that, that he wants to build something like that…

Yesterday I got a perfect idea…almost same as he…

I got pwnd.

Anyways…Nice…Nice…one more thingy… Nice!

From: Timer
It would be nice for a updated GP script, for the new server and all…

The new site is just an iframe of the old site look at the source of the page.