Point-based stat distribution is too powerful

[ChodTheWacko]

I have three huge stats databases <snip>
What we need is a SQL wizard to query them and plot this explosion visually for us, showing the levels where different things become available (damage, speed, ESP, etc. etc.). Without any coding changes we could then adjust rarities and depths and alloc_probs to smooth out these curves so that stuff wasn't available quite so quickly in the 2000'-3000' range, and more was only found in the 3000s and 4000s.

I'll take it.
I'm not sure what form it is in, but I hope it's some sort of CSV format so it can be imported into another database.

Tell me what you want and it shouldn't be hard to do, but you have to be specific.

Certain things are straightforward:
speed could be a horizontal histogram, # of objects with speed +X at dLvl Y.
Egos, like ESP, could also be a horizontal histogram as well.

But what do you mean by 'damage'? Damage is a factor of max blows, base damage, bonus to dam.
I'm having a hard time thinking about what a useful 'chart' of that would be.

A big report type of dump where lines are:
object - min level, max level, avg level, total
would be useful, expecially in a forms based tool where you can specifiy min/max ranges.


- Frank

[Derakon]

Currently the database is hosted on Magnate's server. It's conceptually easy to just make a dump of it and distribute that (so others could mirror the database and run their own queries without hammering his hardware), but apparently his upload capacity is limited.

[myshkin]

I'll take it.
I'm not sure what form it is in, but I hope it's some sort of CSV format so it can be imported into another database.

The stats code dumps data into a sqlite3 database. My 60k runs database is about 314MB. It may be simpler for you just to generate your own database; on reasonably recent hardware, each run takes about 1s. The database schema is partly documented in comments to main-stats.c on the staging branch. To generate a database in ANGBAND_DIR_USER/stats/, run

.../angband -mstats -- [-q] [-nNNNN] [-s]

The options are for enabling quiet mode, making NNNN runs through the dungeon, and enabling no-selling. I don't recommend running with randarts at this point. We are still tracking down some memory leaks that seem to prevent running more than about 69k runs in a session.

[Netbrian]

To generate a database in ANGBAND_DIR_USER/stats/, run

.../angband -mstats -- [-q] [-nNNNN] [-s]

The options are for enabling quiet mode, making NNNN runs through the dungeon, and enabling no-selling. I don't recommend running with randarts at this point. We are still tracking down some memory leaks that seem to prevent running more than about 69k runs in a session.

I'm trying this on the latest nightly, and I get the error message "cannot find required file -mstats."

Am I missing something? I'm running Windows 7.

[myshkin]

I'm trying this on the latest nightly, and I get the error message "cannot find required file -mstats."

Am I missing something? I'm running Windows 7.

Sorry...the Windows and OS X ports do not support display modules, and the stats module is a pseudo-display module. If you can compile the game with the autoconf/buildsys toolchain (configure with --enable-stats), or with Makefile.std, then you should be able to run with -mstats.

[d_m]

I've run -mstats on Ubuntu and OSX (like you say, using ./autogen.sh, ./configure, make and make install).

[Netbrian]

Sorry...the Windows and OS X ports do not support display modules, and the stats module is a pseudo-display module. If you can compile the game with the autoconf/buildsys toolchain (configure with --enable-stats), or with Makefile.std, then you should be able to run with -mstats.

Okay, thank you. I'd like to play with the stats, but am not set up to recompile the game. If anyone has a Windows binary with this enabled, please let me know!

[jens]

Okay, thank you. I'd like to play with the stats, but am not set up to recompile the game. If anyone has a Windows binary with this enabled, please let me know!

+1
plus some extra text so the forum accepts my comment...