Ranking Spreadsheet

Navigate to

Up to:

IdeasSuggest a new feature for the game!

Previous: Can someone explain what the R...

Next: Expansion sequels?

mike flips

Using what has already been programmed to display the rankings of people in each level, make a program that puts your own rankings into some sort of spreadsheet downloadable to the palm so that you can look up your ranking on any level on the go. it doesnt have to include all the names of everyone, just the level name and your rank number.

32 comments on 2 pages: 1 2 >>>>

Kristopher

How would this be any better than what we already have? You would still have to download it, but you can already download your user profile page and save view it on the Palm. Do you just want the scores for all of the levelpacks on a single page, or do you also want all of the players on a single page?

mike flips

I mean like something we can download that has a list of every level and our current ranking on it. so for example if i go away, before i leave i download the list and then i can find out which levels are my lowest rankings and improve them while im away

Kristopher

Okay, I could make one of those. But until I do, you can just go to your profile and save the page for each of the Time Trial levelpacks.

mike flips

Too much work

lol

Kristopher

Oh course it will be even harder for me, since I will need to download about 20,000 web pages and then process them all!

Do you want a text file, or a web page?

mike flips

Text would be better as not everyone has access to the web on their palms

Kristopher

I'm using this to download one player every six seconds.

'\ITECH\MISC\BIKERC\GETRC
'Bike or Die Player Pages Downloader! Version 1.0
'(C) 2006 i-TECH and Kristopher Windsor

CONST playercount = 3000: CHDIR "C:\ITECH\MISC\BIKERC"
ON ERROR GOTO resumenext: MKDIR "PAGES": OPEN "propgress.txt" FOR INPUT AS #1: INPUT #1, progress: CLOSE #1: ON ERROR GOTO 0
ON KEY(31) GOSUB quickexit: KEY(31) ON

SCREEN 0: WIDTH 80, 25: CLS
FOR a = progress + 1 TO playercount
LOCATE 3, 5: PRINT "Getting data for player" + STR$(a) + "..."
OPEN "TEMP.BAT" FOR OUTPUT AS #1
PRINT #1, "CMD /C START wget -O PAGES\" + LTRIM$(STR$(a)) + "a.htm -o tmp.tmp http://bike.toyspring.com/player.php?p=" + LTRIM$(STR$(a)) + "^& op=1"
PRINT #1, "CMD /C START wget -O PAGES\" + LTRIM$(STR$(a)) + "b.htm -o tmp.tmp http://bike.toyspring.com/player.php?p=" + LTRIM$(STR$(a)) + "^& op=2"
PRINT #1, "CMD /C START wget -O PAGES\" + LTRIM$(STR$(a)) + "c.htm -o tmp.tmp http://bike.toyspring.com/player.php?p=" + LTRIM$(STR$(a)) + "^& op=3"
PRINT #1, "CMD /C START wget -O PAGES\" + LTRIM$(STR$(a)) + "d.htm -o tmp.tmp http://bike.toyspring.com/player.php?p=" + LTRIM$(STR$(a)) + "^& op=4"
PRINT #1, "CMD /C START wget -O PAGES\" + LTRIM$(STR$(a)) + "e.htm -o tmp.tmp http://bike.toyspring.com/player.php?p=" + LTRIM$(STR$(a)) + "^& op=5"
PRINT #1, "CMD /C START wget -O PAGES\" + LTRIM$(STR$(a)) + "f.htm -o tmp.tmp http://bike.toyspring.com/player.php?p=" + LTRIM$(STR$(a)) + "^& op=49"
PRINT #1, "CMD /C START wget -O PAGES\" + LTRIM$(STR$(a)) + "g.htm -o tmp.tmp http://bike.toyspring.com/player.php?p=" + LTRIM$(STR$(a)) + "^& op=71"
CLOSE #1
SHELL "TEMP.BAT": SLEEP 6
OPEN "progress.txt" FOR OUTPUT AS #1: PRINT #1, a: CLOSE #1
NEXT a

quickexit:
SYSTEM

resumenext:
RESUME NEXT

mike flips

Looks good

Kristopher

I fixed the typo in propgress.txt", and I found out it can actually download a player every two or three seconds, but it will still take a few hours on Dial-Up.

mike flips

did it work?

Kristopher

I've been a bit busy, and I need to modify it because the players' profiles look diifferent now, but it will be done in a few days. Right now I am getting some programs ready for the county fair.

Kristopher

It's looking good so far, but I have only downloaded the ranking for the first 10% of the players. Here is what Rachman!'s looks like:

############################################################
# rachman! #
############################################################
Bottle.................................. 1
Skyway.................................. 2
Finding Mice............................ 2
Me vs. The Gravity...................... 3
Malysz.................................. 5
Zip-Zap................................. 5
Shark!.................................. 5
Pipe Universe........................... 7
Bike Impossible......................... 7
Home Sweet Home......................... 7
Hellraider.............................. 8
Big Cheese.............................. 8
Spike Cave.............................. 9
Mount Kinabalu.......................... 9
pumb.org................................ 10
Bird.................................... 10
Jurassic Parking........................ 11
Square.................................. 11
Sleeps With The Fishes.................. 11
Fruits.................................. 11
Double Sprint........................... 12
Floors.................................. 12
Golden Gate............................. 12
Cave.................................... 12
Fly!.................................... 12
Teapot.................................. 12
Midnight Mess........................... 13
Bike O'Clock............................ 13
OrR's Cave.............................. 13
Riding School........................... 14
palmstamp.com........................... 14
Nose.................................... 14
Riding School Part 2.................... 15
The Right Way........................... 15
Cloudwalk............................... 15
SinkInToDrinks.......................... 15
Tricky.................................. 15
Sqare................................... 15
KL City Centre.......................... 15
Oil Drop................................ 15
U Jump.................................. 16
Up! Up! Up!............................. 16
Vertical Avenue......................... 17
Watch your head......................... 17
Konecnik................................ 17
Underground............................. 18
Clay Serpent............................ 18
Jump Over............................... 18
Purple Palace........................... 18
Cave 2.................................. 18
Cablecar................................ 19
Up stairs............................... 20
Cemetery................................ 20
Omaha Beach............................. 20
Loop 3.................................. 20
Wheel Insider........................... 21
Human Insides........................... 21
Touch Bricks............................ 22
Street.................................. 23
Moon Madness............................ 23
Sinus Mountains......................... 24
Hill.................................... 26
Vanilla Sky............................. 27
You Qi.................................. 28
Konecnik Down........................... 29
The Well................................ 31
Loop 1.................................. 31
Tatra................................... 31
Loop 2.................................. 32
Sawtooth................................ 33
Downhill Madness........................ 52
Incomplete:
Red Murder
Smiley
Grand Canyon
Hank Chill
Blizzard
Catapult
Cave Dweller
Catapult Back
WOW
Obstacalis Muchus
Fear Of The Dark
Castle
Jump or Die
Triangles
Equisplateral
Congratulations!
Shelf
Jumping Trial
?lip that ?lipper...
Way Up There
Cactus
Hellevator
Hillz
Double-back Jumps
Snowstorm
Spiral
Foothill Half Circle
Sharper Than Glass
?urn I?, ?wis? I?, E?c.
Spike Mountain
Parachute
Die or Die!

Kristopher

But it looks better in a different font, and the indentation is not preserved here.

mike flips

sweet thats exactly what i was thinking of, when completed, all players could download their rankings and then take them with wherever they go so they can see which levels need the most work, also its useful for setting goals such as "i want all levels under rank 20" or something like that, and for finding incomplete levels... good job kristopher

mike flips

depending on how easy this is to do (i have no clue as i cant program) other useful inclusions for this thing could be the next fastest persons time, and the overall fastest persons time to make the thing more elaborate

surprise! look at player's profile below the ranking

now you can easily download your complete ranking and save it for offline viewing (and even paste it into your palm's memo pad) and the csv options means less work for kristopher's applications

Kristopher

Really awesome!

Now I can download everything within half an hour (instead of three to five hours).

Mike flips: I can process these essentially every way possible. Until now, the problem was downloading the data. Now, I should be able to do a lot with it.

mike flips

sweetness

mike flips

this = extremely useful

Kristopher

The "(Second Behind)"... part is entirely accurate yet, but it will be soon. It tells you how many seconds you are away from the gold medal. I think that is better than finding the "next fastest person[']s time"

Any more ideas, I can add. I'll find a way to get each players ranking chart into a seperate file soon...

############################################################
# mike flips #
############################################################
Cablecar................................ 1 (Leader)
Sawtooth................................ 2 (.08 Seconds behind)
Loop 3.................................. 2 (.14 Seconds behind)
Cactus.................................. 2 (.64 Seconds behind)
Zip-Zap................................. 3 (.86 Seconds behind)
Loop 1.................................. 3 (.92 Seconds behind)
Bird.................................... 3 (1.04 Seconds behind)
pumb.org................................ 4 (1.92 Seconds behind)
Cave Dweller............................ 4 (21.28 Seconds behind)
Watch your head......................... 5 (3.66 Seconds behind)
OrR's Cave.............................. 5 (1.1 Seconds behind)
Cave 2.................................. 5 (.36 Seconds behind)
Snowstorm............................... 5 (.1 Seconds behind)
Double Sprint........................... 6 (20.84 Seconds behind)
Vertical Avenue......................... 6 (1.82 Seconds behind)
Malysz.................................. 6 (1.58 Seconds behind)
Midnight Mess........................... 6 (.68 Seconds behind)
Teapot.................................. 6 (1.86 Seconds behind)
Downhill Madness........................ 7 (.06 Seconds behind)
Touch Bricks............................ 7 (3.42 Seconds behind)
Floors.................................. 8 (2.28 Seconds behind)
Pipe Universe........................... 8 (2.28 Seconds behind)
Sqare................................... 8 (1.92 Seconds behind)
WOW..................................... 8 (4.5 Seconds behind)
Spiral.................................. 8 (1.02 Seconds behind)
?urn I?, ?wis? I?, E?c.................. 8 (1.1 Seconds behind)
Sinus Mountains......................... 9 (31.92 Seconds behind)
Up! Up! Up!............................. 9 (2.02 Seconds behind)
Human Insides........................... 9 (3.7 Seconds behind)
Konecnik................................ 9 (1.64 Seconds behind)
KL City Centre.......................... 9 (1.88 Seconds behind)
Smiley.................................. 9 (2 Seconds behind)
Way Up There............................ 9 (5.18 Seconds behind)
Me vs. The Gravity...................... 10 (1.98 Seconds behind)
palmstamp.com........................... 10 (.9 Seconds behind)
Tricky.................................. 10 (1.24 Seconds behind)
Fruits.................................. 10 (2.38 Seconds behind)
You Qi.................................. 10 (1.28 Seconds behind)
Street.................................. 11 (4.08 Seconds behind)
Loop 2.................................. 11 (.68 Seconds behind)
Blizzard................................ 11 (2.4 Seconds behind)
Catapult Back........................... 11 (1.28 Seconds behind)
Hellevator.............................. 11 (5.5 Seconds behind)
Double-back Jumps....................... 11 (1.4 Seconds behind)
Spike Mountain.......................... 11 (7.28 Seconds behind)
Jurassic Parking........................ 12 (1.42 Seconds behind)
Spike Cave.............................. 12 (1.5 Seconds behind)
Jump or Die............................. 12 (3.06 Seconds behind)
Triangles............................... 12 (5.74 Seconds behind)
Die or Die!............................. 12 (26.4 Seconds behind)
U Jump.................................. 13 (.7 Seconds behind)
The Well................................ 13 (.54 Seconds behind)
Bike Impossible......................... 13 (1.16 Seconds behind)
Nose.................................... 13 (2.92 Seconds behind)
Fly!.................................... 13 (2.04 Seconds behind)
Mount Kinabalu.......................... 13 (2.78 Seconds behind)
Skyway.................................. 13 (2.82 Seconds behind)
Grand Canyon............................ 13 (4.42 Seconds behind)
Sharper Than Glass...................... 13 (4.22 Seconds behind)
Parachute............................... 13 (7.58 Seconds behind)
Underground............................. 14 (17.66 Seconds behind)
Jump Over............................... 14 (1.22 Seconds behind)
Up stairs............................... 14 (3.18 Seconds behind)
Tatra................................... 14 (7.58 Seconds behind)
Catapult................................ 14 (1.58 Seconds behind)
Fear Of The Dark........................ 14 (6.22 Seconds behind)
Jumping Trial........................... 14 (.88 Seconds behind)
Riding School........................... 15 (28.52 Seconds behind)
Hellraider.............................. 15 (2.26 Seconds behind)
Hill.................................... 15 (5.56 Seconds behind)
Square.................................. 15 (.9 Seconds behind)
Cemetery................................ 15 (1.1 Seconds behind)
Omaha Beach............................. 15 (3.26 Seconds behind)
Shark!.................................. 15 (6.38 Seconds behind)
Red Murder.............................. 15 (16.76 Seconds behind)
Hank Chill.............................. 15 (1.6 Seconds behind)
Obstacalis Muchus....................... 15 (1.94 Seconds behind)
Foothill Half Circle.................... 15 (.52 Seconds behind)
Clay Serpent............................ 16 (.82 Seconds behind)
Purple Palace........................... 16 (3.24 Seconds behind)
Moon Madness............................ 16 (.86 Seconds behind)
Finding Mice............................ 16 (15.12 Seconds behind)
Equisplateral........................... 16 (.22 Seconds behind)
Hillz................................... 16 (1.28 Seconds behind)
Vanilla Sky............................. 17 (1.42 Seconds behind)
Cave.................................... 17 (9.18 Seconds behind)
SinkInToDrinks.......................... 17 (2 Seconds behind)
Oil Drop................................ 17 (1.06 Seconds behind)
?lip that ?lipper....................... 17 (.18 Seconds behind)
Wheel Insider........................... 18 (12.54 Seconds behind)
Golden Gate............................. 18 (2 Seconds behind)
Bike O'Clock............................ 18 (.76 Seconds behind)
Konecnik Down........................... 18 (2.28 Seconds behind)
Home Sweet Home......................... 18 (9.66 Seconds behind)
Congratulations!........................ 18 (4.96 Seconds behind)
Big Cheese.............................. 19 (5.8 Seconds behind)
Cloudwalk............................... 19 (1.58 Seconds behind)
Sleeps With The Fishes.................. 19 (.72 Seconds behind)
Castle.................................. 21 (11.62 Seconds behind)
The Right Way........................... 23 (20.58 Seconds behind)
Riding School Part 2.................... 29 (.52 Seconds behind)
Shelf................................... 39 (4.06 Seconds behind)
Bottle.................................. 58 (.12 Seconds behind)