Author Topic: AH Database Question (Read 315 times)

dtango · « **on:** August 20, 2004, 09:03:18 AM »

I've seen people post stats for various things that must have come from database queries not available through just the scores webpages.

Can someone point out instructions on how this can be done?

Thanks!

Tango, XO
412th FS Braunco Mustangs

flyingaround · « **Reply #1 on:** August 20, 2004, 09:29:07 AM »

http://www.innomi.com/ahkillstats/personalstats.php?

dtango · « **Reply #2 on:** August 20, 2004, 09:35:36 AM »

Lute:

Thanks. I'm aware of innominate's and blkknit's stats pages. Looking for other data than what's provided there.

Tango, XO
412th FS Braunco Mustangs

Innominate · « **Reply #3 on:** August 20, 2004, 11:38:28 AM »

What data is that?

dtango · « **Reply #4 on:** August 20, 2004, 02:29:35 PM »

inom:

I was curious about the following:
- total hours online by country->by squad->by player
- total kills per squad->player->per hours online
- total kills per player->per hours online
- sorties per aircraft->per squad->per player (not kills or deaths)

I was also curious about what types of info could be derived from the queries so wanted to explore a little bit. The 1st 3 were just musings. The last one was for some specific things that might help some internal squadron merits.

I'd be happy to take this offline to discuss. I'm familiar with sql / mysql queries etc. and if possible would like to know what's available to analyze.

Tango, XO
412th FS Braunco Mustangs

Innominate · « **Reply #5 on:** August 20, 2004, 02:41:34 PM »

All of the data we have to work with comes from:
http://www.hitechcreations.com/cgi-bin/105score/105stats.pl