Page 1 of 2

EMZ Results Database "beta"

Posted: Tue Apr 01, 2008 3:47 pm
by simulation
Hi All.

I finally got round to doing something about the growing pile of match result files piling up on my server.

Check out the blog for more info or go straight here for a preview.

Sim

Posted: Tue Apr 01, 2008 5:23 pm
by eXg. Pun1sher
Very impressive. I'm going to hit you up in a bit, hehe, to see how you have the database setup, and what queries can be sent out to it.

PuN

Posted: Tue Apr 01, 2008 6:00 pm
by simulation
I added a simple search page too.

Posted: Sun Apr 06, 2008 5:52 pm
by simulation
The results database now has 16,462 Tourney results for 792 playes.

emz server: 2007-02-10 to 2008-04-05
exg server: 2008-01-29 to 2008-03-26

Clicking on the date of the match now gives a little more detail. I'll work on more stats and a REAL ranking system based on who beat who later.

This is still "beta" at the moment, so don't try and bookmark your own pages just yet ;)

If anyone has more results*.emz files on their server I can add them to the database.

Sim

Posted: Sun Apr 06, 2008 6:38 pm
by eXg. sabooya
so these are results for (generally speaking) all tourny matches as of the date on exg and emz servers?

Posted: Mon Apr 07, 2008 3:59 am
by simulation
eXg. sabooya wrote:so these are results for (generally speaking) all tourny matches as of the date on exg and emz servers?
On my server since 1.31 went live. On the exg server since Jan this year.

Posted: Fri Apr 11, 2008 3:07 am
by simulation
Bump!

A couple of new features on the stats database, including Elo ratings for all players.

http://www.the-emz.com/blog/ for an update.

Sim

Posted: Fri Apr 11, 2008 5:35 am
by eXg. sabooya
12 1877.00 Perfect1on
14 1860.90 eXg. ShooteR
Wow nice job perf at 12th place, and shooter at 14. Sim did you post this update on the TN or .50 cal site? Being they are in the top, i bet they would like to see it.

My favorite stats are teh Most quitters. The people you know not to play with haha!
http://www.the-emz.com/results/?mode=search&type=quits

Posted: Fri Apr 11, 2008 6:11 am
by simulation
eXg. sabooya wrote:
12 1877.00 Perfect1on
14 1860.90 eXg. ShooteR
Wow nice job perf at 12th place, and shooter at 14. Sim did you post this update on the TN or .50 cal site? Being they are in the top, i bet they would like to see it.

My favorite stats are teh Most quitters. The people you know not to play with haha!
http://www.the-emz.com/results/?mode=search&type=quits
Ah no, I must track down the .50 cal site and post there. Thx for the reminder.

As for the quitters, I found this series of "wins" quite interesting.

http://www.the-emz.com/results/?mode=re ... 52&quits=1

Sim

Posted: Fri Apr 11, 2008 8:34 am
by eXg. Frag///aster
hmm now I thought I had played in those dates but I guess not. hmm.

Have to figure out where my games went. hehe. guess I will have to play more...

Now is this something that will be on going and ever changing. :) ???

Posted: Fri Apr 11, 2008 9:26 am
by simulation
eXg. Frag///aster wrote:Now is this something that will be on going and ever changing. :) ???

I'll be uploading the files from my server periodically, and any other files that admins send me.

Posted: Fri Apr 11, 2008 9:27 am
by simulation
eXg. Frag///aster wrote:hmm now I thought I had played in those dates but I guess not. hmm.
Isn't this you ? http://www.the-emz.com/results/?mode=player&id=718

Posted: Fri Apr 11, 2008 10:34 am
by hadriel
Poop.. going to have to play more again, I guess. :P Stopped playing long before those dates lol

Posted: Fri Apr 11, 2008 2:43 pm
by eXg. sabooya
wow you can set it to remember you as your name and then see all the matches you played very nice sim!!!
It also might be a cool idea to post this on a larger site. Anyone know a large forum community for doom?

Sim is there a way the exg site could have all matches listed from our server and have everyones scores as well?(That would be both servers combined)

Posted: Fri Apr 11, 2008 6:45 pm
by hadriel
Awesome job Sim!
Just wondering, does this get updated automatically, or do you need to do it manually?