Author |
Message |
Extra Ball Newbie
Joined: Mar 24 2005 Posts: 2 Location: Rennes, France Offline
|
Posted: Thu Mar 24, 2005 5:16 pm Post maybe stupid Post subject: Access to Edome database/data? |
 |
|
|
|
Hello all
I'm not sure this forum is the right place to post my crappy request but let's see if someone can help me here
I've been doing general statistics for the Extreme Games Zone players for a couple months now (based on what I can find at Edome site) and try to provide them with added value information (summary of their recycles, sum/average/best values of kills, points and so on, overall rank of each pilot compared to others...). Go to http://frederic.mevel.club.fr/EG/Projects/index.php if you want to have an overview of what I'm trying to put in place
My problem:
At the moment, I'm working with the data I gathered from Edome site by hand via the results obtained with the cgi script (copy/paste of the 138 EG resets for 2 categories, 500 first results of each reset only, ouch it took me ages to do that ah ah). You'll easily understand that the retrieving of the data is my main concern as it would take too long to get the complete results stored in the Edome db in order to produce new or more accurate stats
Question:
Any contact you could redirect me to in order to get an extract of the Edome data for the Extreme Games zone or have more information about my concern (automatically collect the results from Edome site)?
Ty in advance
PS: my last post at EG forum about this subject http://www.extreme-games.net/forum/sutra141762.html#141762 |
|
Back to top |
|
 |
Dr Brain Flip-flopping like a wind surfer

Age:39 Gender: Joined: Dec 01 2002 Posts: 3502 Location: Hyperspace Offline
|
Posted: Thu Mar 24, 2005 5:33 pm Post maybe stupid Post subject: |
 |
|
|
|
What you're asking for you will never get. The administration surrounding the biller is worthless and 100% opposed to change. Change includes letting someone do something worthwhile.
Don't let this put you off though. The rumor is that EG will be moving to ASSS someday very soon. When that happens, all of the EG stats will be collected by the server itself (rather than by the biller) and you can request stats directly from the zone ops.
Good luck in your endeavors. _________________ Hyperspace Owner
Smong> so long as 99% deaths feel lame it will always be hyperspace to me |
|
Back to top |
|
 |
CypherJF I gargle nitroglycerin

Gender: Joined: Aug 14 2003 Posts: 2582 Location: USA Offline
|
Posted: Thu Mar 24, 2005 7:33 pm Post maybe stupid Post subject: |
 |
|
|
|
I was looking for something very similiar for Omega Fire - stats on its own website but eDome isn't very friendly for script parsing :X... _________________ Performance is often the art of cheating carefully. - James Gosling |
|
Back to top |
|
 |
Pests Novice
Joined: Feb 24 2003 Posts: 84 Offline
|
Posted: Fri Mar 25, 2005 11:55 am Post maybe stupid Post subject: |
 |
|
|
|
Its actually quite easy to grab the data. Each row of data in most results is unique so you can easily place that into a regular expression. Download the page you need (parameters are easy to figure out), plug it in, and get a nice representation of data in return. Takes under 10 lines of PHP.
Last edited by Pests on Wed Apr 20, 2005 11:01 pm, edited 1 time in total |
|
Back to top |
|
 |
Extra Ball Newbie
Joined: Mar 24 2005 Posts: 2 Location: Rennes, France Offline
|
Posted: Fri Mar 25, 2005 3:47 pm Post maybe stupid Post subject: |
 |
|
|
|
hmm Pest, maybe you didn't understand my problem or maybe I didn't get your answer: my concern isn't to parse and get the data from one page displayed after you have chosen the parameters (zone+reset date+category), it is to cycle through all possible results for a given zone just like:
EG zone chosen -> all resets (138)
For a given reset -> all categories (total wins, total points, reccers..)
For a specific category -> all existing pages (for like 7 or 8K pilots)
The idea is to get the [(138 resets) x (3 or 4 categories) x number of results pages] different pages I could use to feed my database
Hmm atm I feel like Edome looks like Fort Knox ah ah and this is weird since the data is available via the cgi. But I never give up |
|
Back to top |
|
 |
D1st0rt Miss Directed Wannabe

Age:37 Gender: Joined: Aug 31 2003 Posts: 2247 Location: Blacksburg, VA Offline
|
Posted: Sat Mar 26, 2005 12:34 pm Post maybe stupid Post subject: |
 |
|
|
|
I remember it being very easy to extract when I was doing stuff for Hyperspace. Once you have the data requested from a particular zone, its just reading in a table. There was even some formatting things I noticed that made it a lot easier like the case of the html tags inside the table were lowercase and outside were uppercase or something like that. I don't know if I still have the code, but I can look for it (it's in C# - no comments, that's the type of hosting I had) _________________
 |
|
Back to top |
|
 |
Pests Novice
Joined: Feb 24 2003 Posts: 84 Offline
|
Posted: Wed Apr 20, 2005 11:04 pm Post maybe stupid Post subject: |
 |
|
|
|
You don't even need to really do that. The line for the stats has its own format so this can be plugged into a regular expression pulling out everything between the TDs. |
|
Back to top |
|
 |
|