unforum

[Sasuntsi Davit]

Polygon Marathon uid effort [one triplicate found]

[SteveC]

My opinion is that you won't find any duplicate UIDs - they're unique in the DB and represent that individual's entry in that year, and their unique completion time.

No problem with trying to de-hash the ids though - that could result in a name/year/some data if we're lucky... That or this is just a set up for the story - OR the note number is relevant... somehow...

[Sasuntsi Davit]

Right, I have this kind of working now, (havn't tested it thoroughly, so there may be some bugs I havn't noticed).

Please download and run the app only if you have broadband and a fairly high bandwidth allowance as the app will download about 60 megs worth of html pages, and thats just for the year 268 for the main runners. (Thats all this app will do for the moment as I need to export the rest of the data from my database).

Once the zip file is downloaded, unzip it to any directory. Open up a command prompt and run the jar file from it (don't double click it, this is because it does not have a gui and therefore you won't be able to shut it down unless you ctrl+del it).
Thats all there is to it.
It will show a progress bar so that you can see if it has crashed or not (it won't, hopefully), and give some info about what happening. Once it has finished the process, zip up the userinfo.dat in the data directory of the unzip folder and send it to me at pxcsas(a big !%#$ u to spambots)hotmail.com.

Now I need to get the other data out of my db, oh joy.

[Sasuntsi Davit]

Hmm, looks like on some people's computers the command line output isn't showing up properly. I'm not sure why that is, but it may be something to do with the way the jar file was launched.

Hopefully this will help.
Type this command in

[fabs_uk]

you have mail

The unserinfo.dat only came out to 1MB though, which seemed slightly odd. 1.00MB infact.

Oh well, you're more in a position to work it out than I am!

[Sasuntsi Davit]

I have so far found one duplicate entry.

Arianna Saldana in 265

Arianna Saldana in 266

EDIT: might be db error

[Joe]

just random.. because it may not matter, but on both pages for the duplicate it shows her a being 31 years old which wouldn't be possible unless the race was held at different times of the year.. (or maybe that's her current age..)

[Sasuntsi Davit]

[PiratePete]

Arianna also finished in exactly the same time in 264 in position 1516th

in 265 in 1505th
in 266 in 1479th

strange how they are all the same time and the user id does not change.

[Sasuntsi Davit]

[Sasuntsi Davit]

Since we seem to have come to a dead end of sorts with this, for the moment, here are some random facts taken from my db about the year 268 competitors in the main run.
Thanks Hawk for processing the year 268 main runners file.

• out of all the participants, only 38 people were not taking any forms of legal drugs (observed due to bug in my processing code).
  
• oldest participant is Kristina Medina at 56 years old
  
• youngest participant is Celine Hays at 20 years old
  

more to come as I think of more 'interesting' facts to find...

[Sasuntsi Davit]

Heres the file for the main runners in 267 if anyone feels like processing it.

[justdig]

I'm pretty sure these "duplicates" are just errors. They're the same entry linked from two different pages. Go to anybody's page and change any of the values, like year or type of race, except the uid, and it'll stay on the same page.

EDIT: Uh, whoops, guess I was wrong about that.

[Sasuntsi Davit]

[Sasuntsi Davit]

Here are two more files to process.