EMZ Results Database "beta"

simulation · Post by **simulation** » Tue Apr 01, 2008 3:47 pm

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

Post by **eXg. Pun1sher** » Tue Apr 01, 2008 5:23 pm

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

simulation · Post by **simulation** » Tue Apr 01, 2008 6:00 pm

I added a simple search page too.

simulation · Post by **simulation** » Sun Apr 06, 2008 5:52 pm

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

eXg. sabooya · Post by **eXg. sabooya** » Sun Apr 06, 2008 6:38 pm

so these are results for (generally speaking) all tourny matches as of the date on exg and emz servers?

simulation · Post by **simulation** » Mon Apr 07, 2008 3:59 am

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.

simulation · Post by **simulation** » Fri Apr 11, 2008 3:07 am

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

eXg. sabooya · Post by **eXg. sabooya** » Fri Apr 11, 2008 5:35 am

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

simulation · Post by **simulation** » Fri Apr 11, 2008 6:11 am

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

eXg. Frag///aster · Post by **eXg. Frag///aster** » Fri Apr 11, 2008 8:34 am

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.

???

simulation · Post by **simulation** » Fri Apr 11, 2008 9:26 am

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.

simulation · Post by **simulation** » Fri Apr 11, 2008 9:27 am

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

hadriel · Post by **hadriel** » Fri Apr 11, 2008 10:34 am

Poop.. going to have to play more again, I guess.

Stopped playing long before those dates lol

eXg. sabooya · Post by **eXg. sabooya** » Fri Apr 11, 2008 2:43 pm

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)

hadriel · Post by **hadriel** » Fri Apr 11, 2008 6:45 pm

Awesome job Sim!
Just wondering, does this get updated automatically, or do you need to do it manually?