Daninms

May 22 2006, 07:33 PM | Post #1

Unregistered



Hiya,

Is there a way to download the Runescape Highscore data?

I'd like to keep track of multiple players, in an Excel spreadsheet format. Names at the top of the columns and levels beneath.

I've been trying to figure out how to link into the database, so Excel would update itself. No luck there. So a download (although the database is huge) is the next best thing. A simple search-sort will throw out names that I'm not interested in.

Any ideas?

Thanks,

Daninms

|

Makoto

May 22 2006, 09:21 PM | Post #2

Unregistered



There is a way, yeah. But Excel could never do that. Not as far as I know.

It involves PHP and MySQL, and I haven't figured it out yet myself.

|

Arguous

May 22 2006, 11:33 PM | Post #3

Unregistered



*hi-lights web page*

*right-clicks - selects "copy"*

*switches to Excel*

*right-clicks - selects "paste special" selects "text"*

*Menu item: "Data" "text to columns"*

*wizard opens* *selects "delimited", hits next*

*another dialog box* *checks the box for "space"*

Hmmmm, that looks close. A bit crude, needs some formatting.

Not exactly pretty, but it works.

Otherwise you could get into vba, create a button on the sheet and use some http get statements, but that's much, much, much more work.

This post has been edited by Arguous: May 22 2006, 11:34 PM

|

Daninms

May 23 2006, 04:10 AM | Post #4

Unregistered



Thanks Arguous,

Exactly how I'm doing it right now.

Bring up high-score page, select it all, and paste into excel. It actually copies very nicely, and all the data is copies into exactly the same cells.

Then a master excel document that links to all of the individual files that contain each persons highscore data (from the copy-paste).

Very crude.. but it does work. I was hoping that the highscores could be direct linked via html programming something like:

htp://www.runescape.com/hiscore.html?user=Daninms?skill=Attack?attrib=Level
htp://www.runescape.com/hiscore.html?user=Daninms?skill=Attack?attrib=Experience

or some such direct access, anyway you get the picture of what I was hoping for.

It is possible, heck, RuneWeb programmers do it. Look at our signatures.

|

Twilight Ray

May 23 2006, 12:04 PM | Post #5

Unregistered

QUOTE(Daninms @ May 22 2006, 11:10 PM)

It is possible, heck, RuneWeb programmers do it. Look at our signatures.

It's a bit different to put it into an excel document. Bug Vulcan.

|

Vulcan

May 23 2006, 10:22 PM | Post #6

Unregistered



Java is your friend. you can write a quick java app to write to excel. much more simple then copy and pasting everything

|

Daninms

May 24 2006, 06:56 AM | Post #7

Unregistered



I was afraid someone would mention Java

Last programming I did was Fortran77 and Pascal, I know, I'm old.

Does anyone else remember the VAX and punch cards?

This post has been edited by Daninms: May 24 2006, 06:57 AM

|

MaxTheDragon

May 24 2006, 10:59 AM | Post #8

Unregistered



I know how to download hiscores to PHP and Flash apps.

Downloading the actual database is no good, since it won't give you access. Most dynamic sigs read the hiscore page with the stats, instead of querying the db.

Perhaps you could set up a dynamic XLS file using PHP? Send a header in the PHP script that states that the document is XLS (Excel).

Then download the data as you would in PHP. Make sure that the format corresponds with actual XLS files.

Perhaps that works.

This post has been edited by MaxTheDragon: May 24 2006, 11:03 AM

|

Baakalor

May 24 2006, 02:08 PM | Post #9

Unregistered

QUOTE(Daninms @ May 23 2006, 11:56 PM)

Does anyone else remember the VAX and punch cards?

Just us old folks. I cut my teeth on punch cards. After dropping the box the first time, every time after that I numbered the dang things.

This post has been edited by Baakalor: May 24 2006, 02:09 PM

|

Daninms

May 26 2006, 08:32 PM | Post #10

Unregistered



lol, dropping them. Oh yeah, that was a bit of a pain. I also remembering taking home the old ones. The children loved them for crafts. I think I still have gold painted cards forming Christmas wreaths.

EDIT: I stumbled on a very simple way to put the highscored into an Excel Document. Not nearly as effective for tracking multiple members, but progress.

Excel allows web based html files to be opened, in excel.

Simply open a new file, and in the filename block, enter: http://hiscore.runescape.com/lang/en/aff/r...s?user1=daninms

And in it goes. A bit of file manipulation, and viola!


[I new I should have payed more attention in Excel class.]

[LOL Don't double post, just hit the edit button DATA WAS HERE]

This post has been edited by Loggy: May 28 2006, 04:45 PM

|

Mouthgate

May 26 2006, 09:30 PM | Post #11

Unregistered



Why dont you just go on the runeweb downloads page, there is a small database program, where you can look up certain players and find out there levels that are on the highscores and it also shows the exp .

This post has been edited by Mouthgate: May 26 2006, 09:44 PM

|

Daninms

May 28 2006, 04:25 AM | Post #12

Unregistered



The goal of this is to put everyone on my friends list, into one file. The perfect situation, is one that every time I refresh the file, it pulls new data on each person.

Excel is preferred (for me) for the simplicity of putting together lists of people who, say, have 72 herblore. or a list of folks having 83 agility. etc etc.

Everything I have seen so far, is look up one person at a time, or the two person compare on runescape highscore lookups.

But thanks for pointing me to the download page. I'll try most programs to see if they can be made to work.

|

Vulcan

May 28 2006, 01:02 PM | Post #13

Unregistered



heh someone decided to be funny and either hid my last reply to this or deleted it because i said this thread was pointless...

|

Splatman

May 28 2006, 09:45 PM | Post #14

Administrator
Member No.:4


Why is it pointless?.. He's trying to solve a problem for himself..

--------------------

Posts: 353 |

Baakalor

Jun 3 2006, 09:24 AM | Post #15

Unregistered

QUOTE(Vulcan @ May 28 2006, 06:02 AM)

heh someone decided to be funny and either hid my last reply to this or deleted it because i said this thread was pointless...

I just checked. It wasn't deleted.
The only reply of yours I saw that mentioned "pointless" was in the combat error thread.

QUOTE(Vulcan @ May 27 2006, 06:46 PM)

the only point to this post now is to help me update the combat formulas in my irc bot me0w...

i no longer have anything to do with the runeweb sigs or anything else rw related...so bugging me to fix something is a waste of time and quite pointless.

Later

|

« Next Oldest | RuneScape Chat | Next Newest »