Advanced Quake Statistics

about

What's that ?

Advanced Quake Statistics is one of these nifty litte tools that every enthusiastic quake3arena player needs. It's capable to get data from a quake3arena logfile and store it to a database. A GUI frontent (see screenshots) may display summaries, charts and statistics if you don't want to use your own frontent solution.

Why ?

I startet to build this little tool to get familiar with Perl::DBI , Trolltech's Qt database interface and PostgreSQL.

How does it work ?

AQS is devided into four parts.

Firstly there is a quake3arena mod that adds some events like shots and hits to the logfile output stuff of q3a and fix some little bugs that Mr. Carmack left for me.

Second part is a perl script that takes the logfile. It Parses it and puts events to a PostgreSQL database witch it has found.

This database is the third part. It takes the events, does some magic about them and store them. You may have a look at them if you like to use a data viewer like PostgreSQL's psql or pgaccess. There are a lot views waiting for you.

The fourth part is a little Qt application for a easy look at the data.

Where does it work ?

Every platform that runs PostgreSQL and Perl should run the backend part. I have tested it on SuSE Linux 7.3. Maybe cygwin will working too. The Qt frontend uses only Qt functionality and should run on all platforms where you be able to compile the Qt and that have a PostgreSQL driver for.