Jump to content

Platinum level Jagex recognized fansite

Toggle shoutbox ColorWars ShoutBox

Tri_Killer2 : (Oct 01,2014 19:38) your choice
Hope : (Oct 01,2014 18:52) I think it is fixing itself now but I can send you screenie
Tri_Killer2 : (Oct 01,2014 18:49) Which ones? @ hope
Hope : (Oct 01,2014 18:45) Is it just me or is some of the coding broken on the threads?
Sola Wind : (Oct 01,2014 17:50) grats kushie :bunny:
Kunio : (Oct 01,2014 17:36) Congrats! :D
Sliver : (Oct 01,2014 17:35) Kushie has been awarded the events regular award! :D
Katalex : (Oct 01,2014 15:41) All set with the invite :)
Flashharriet : (Oct 01,2014 15:37) I was going to invite, but he is offline
Rednar : (Oct 01,2014 15:33) I would invite, but I'm off for tonight.
Rednar : (Oct 01,2014 15:33) Pm a general (gold star) or an admin (bronze cross)
Ol Reb : (Oct 01,2014 14:19) still waiting for invite or are ya'll full
Sliver : (Oct 01,2014 13:18) Today's RuneHQ event is birthday month starting parade! Event is in 3 hours 42m, World: 60 FC: Sliver
Ol Reb : (Oct 01,2014 11:11) I'll just wait for invite now
Ol Reb : (Oct 01,2014 11:11) okay thanks
Bob : (Oct 01,2014 10:29) Also, the probationary wait time before being allowed to skill in the citadel is only one week (not two), but you can collect Anagogic Orts instantly upon joining. Please bear in mind you will lose all your orts upon leaving the previous clan.
Bob : (Oct 01,2014 10:27) You can pop in the clan chat as a guest and ask for an invite.

http://www.runehq.co...he-runehq-clan/ - the CoC is found here; your recruiter will tell you to read it (mandatory), but here's the link to save you time
Ol Reb : (Oct 01,2014 10:20) so i'll leave and wait for invite
Ol Reb : (Oct 01,2014 10:14) I use to play about 3 yrs ago started playing again and have forgot some and a lot has changed as well so really want to learn more
Ol Reb : (Oct 01,2014 10:12) so would have to go through the 2 week wait again

Grand Exchange Crawler (.NET Source)


This topic has been archived. This means that you cannot reply to this topic.
4 replies to this topic

#1 Guest_Pinch d_*

Guest_Pinch d_*
  • Guests
Click to view battle stats

Posted 30 September 2012 - 04:12 AM

I've started a project to create a Grand Exchange Analysis program, whereby you could manage your stock (logs/ores/rares/etc) and the financial gains (or loss) day by day, for any number of items and quantities. While the Grand Exchange itself provides all of the information, it doesn't allow you to make any calls without calculating the profit margin yourself.

Projected Features:
Given an input of the item you currently have, and quanitity, upon startup the program will grab the latest GE prices, and calculate your profit from time of purchase (if known, and within 180days)
Calculate graph curve, and attempt rough prediction of item value fluctuation
Update grand exchange list (remotely hosted itemdb, or locally built, which at this moment in time is data usage heavy)
Slide away interface
Item search combining wikia listing & current GE Price data in result
Open source, implement via webserver or as a local program


At this stage, the grand exchange item crawling feature is 100% working (needs revising, but scans reasonably well), and you'll find that at the end of the thread!

For some of you out there who may enjoy programming, the projects current code would be great for indexing the GE, as apparently the item numbers change from time to time, and being able to reliably check a range of indexes for change could be very useful.

To compile yourself:
-Listview Control (3 columns, itemindex itemname itemurl)
- 2 x TextBox (1 & 2) - textbox1 is starting index, textbox2 is final index
Reference to mshtml.dll (7.5)


Imports System
Imports System.IO
Imports System.Net
Imports System.Text
Imports mshtml

Public Class itemdbcrawler


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim itemindex As Integer = CInt(TextBox2.Text)
        Dim itemcount As Integer = CInt(TextBox1.Text)
        Dim baseurl As String = "http://services.runescape.com/m=itemdb_rs/viewitem.ws?obj="
        Dim countedurl As String

        While itemcount < itemindex
            countedurl = baseurl & itemcount.ToString
            Dim request As WebRequest = _
              WebRequest.Create(countedurl)
            request.Credentials = CredentialCache.DefaultCredentials
            Dim response As WebResponse = request.GetResponse()
            Console.WriteLine(CType(response, HttpWebResponse).StatusDescription)
            Dim dataStream As Stream = response.GetResponseStream()
            Dim reader As New StreamReader(dataStream)
            Dim responseFromServer As String = reader.ReadToEnd()
            Dim doc As IHTMLDocument2 = New HTMLDocumentClass()
            doc.write(New Object() {responseFromServer})
            doc.close()
            reader.Close()
            response.Close()
            Dim ContentStr As String = metacapture(doc)
            If Not ContentStr.Contains("role-playing") Then
                Dim fields() As String
                fields = Split(ContentStr, ",")
                Dim Index As String = itemcount.ToString
                Dim Name As String = fields(1)
                Dim Url As String = countedurl.ToString
                ListViewAddItem(Index, Name, Url)
            End If
            itemcount += 1
        End While
        MessageBox.Show("Crawl Complete")
    End Sub

    Private Function metacapture(ByVal htmldoc As IHTMLDocument) As String

        If (htmldoc IsNot Nothing) Then
            Dim Elems As IHTMLElementCollection
            Dim Errors As IHTMLElementCollection
            Dim WebOC As IHTMLDocument = htmldoc
            Errors = WebOC.getElementsByTagName("div")
            For Each elem As IHTMLElement In Errors
                Dim NameStr As String = elem.getAttribute("id")
                If ((NameStr IsNot Nothing) And (NameStr.Length <> 0)) Then
                    If NameStr.ToLower().Equals("errorcontent") Then
                        Return "0"
                    Else
                        Elems = WebOC.getElementsByTagName("meta")
                        For Each elem2 As IHTMLElement In Elems
                            Dim NameStr2 As String = elem2.getAttribute("name")
                            If ((NameStr2 IsNot Nothing) And (NameStr2.Length <> 0)) Then
                                If NameStr2.ToLower().Equals("keywords") Then
                                    Dim ContentStr As String = elem2.getAttribute("content")
                                    Dim returnstring As String
                                    Dim fields() As String
                                    fields = Split(ContentStr, ",")
                                    returnstring = (WebOC.url.ToString() & "," & fields(3))
                                    Return returnstring
                                End If
                            End If
                        Next
                    End If
                End If
            Next
        End If
    End Function

    Private Delegate Sub ListViewAddItem_delegate(ByVal i_index As String, ByVal i_name As String, ByVal i_url As String)

    Private Sub ListViewAddItem(ByVal i_index As String, ByVal i_name As String, ByVal i_url As String)
        Dim myArgs(2) As Object
        myArgs(0) = i_index
        myArgs(1) = i_name
        myArgs(2) = i_url
        If Me.ListView1.InvokeRequired Then
            Dim d As New ListViewAddItem_delegate(AddressOf ListViewAddItem)
            Me.ListView1.BeginInvoke(d, myArgs)
        Else
            Dim lvi As New ListViewItem(i_index)
            lvi.SubItems.Add(i_name)
            lvi.SubItems.Add(i_url)
            ListView1.Items.AddRange(New ListViewItem() {lvi})
            ListView1.Update()
        End If
    End Sub
End Class


#2 Claudia

Claudia

  • Established Members
  • PipPipPipPipPip
  • 556 posts
Click to view battle stats

Posted 30 September 2012 - 06:56 AM

That sounds pretty neat-o. A little too smart for me, but neat-o nonetheless.

Best of luck with this awesome project.

Sweetheart.png


#3 Symbolic

Symbolic

    Influential Iron Dragon

  • Advanced Members
  • 561 posts
Click to view battle stats

Posted 30 September 2012 - 08:53 AM

Looks pretty cool. Good luck with your project and keep us updated!
Posted Image

#4 Guest_Pinch d_*

Guest_Pinch d_*
  • Guests
Click to view battle stats

Posted 30 September 2012 - 09:05 PM

Moving along, across the next week, ill be building the database using the above code, with slight modifications to the 2nd node 'for each', to collect description, Item Icon URL (saving upwards of 50k icons would be killer, better to load OTF from a personal view) & price. Im contemplating making the initial database dump (raw container) a tab delimited txt file, then use my local SQL server to build a proper database.

The next step after that, is to rework the existing code into a deployable database creation tool, and depending on how complex the database needs to be, attempt to add support for various other database formats.

Heres how the GEC is looking so far!

Attached File  currentprog.jpg   184.24KB   19 downloads

#5 Guest_Pinch d_*

Guest_Pinch d_*
  • Guests
Click to view battle stats

Posted 03 October 2012 - 05:36 PM

so far 00000-10000 have been indexed, and progress is going smooth.

Currently working on a Farming buddy, an event driven alarm, press a hotkey of your choice, a dialog box appears, giving you a selection of farming locations & plots, and what youre planting, and a selection of per-stage reminders or expected fully grown time. Because honestly, micromanaging farming patches can be a pain, now it'll be a whole lot easier (:

if you have any suggestions to what you'd find handy helpful, im more than happy to work a solution, and provide code and in the next 2 days a code project link to compiled .exe's (.net 3 or above required)