Advanced Hud Config for Tourney's

[preparac]

Kraada, I have dificultys to translate your expression
cnt_f_bigpot
in spoken language. Can you give me please a help to express your definition of big pot please ...?

[foldyhawn]

Same problem with toutney_tourney overhere...must be a find and replace gone bad

[kraada]

I exported the stats directly from my database and the stats imported when the HUD imports comes from the profile. I thought we'd tested this previously but I'll make sure with our head of QA and we'll figure out what's going on.

As to what's a big pot:

A pot is big if the shortest player left has less than a pot sized bet, and nobody was all in preflop. For this specific stat I was basically looking to target people who get in a lot of their stack preflop then fold to a flop shove. I wasn't sure the best way to define "a lot" but if they bet X and you call X and they have less than the pot left (blinds + 2X) that means they got in roughly half their stack preflop, which seemed like a good definition of "a lot".

It does get a little bit odd in multiway pots though, as if you raise to X, player B calls X and player C calls X (assume B and C are in the blinds for simplicity), if anybody has < 3X in their stack, it's a big pot now, but they only put in 1/3 of the pot so they called less preflop to get into the big pot.

But I still think it intuitively makes sense as a Big Pot, so I'm okay with that.

If you want a really short snippet as to what this stat was for, in my mind, it was to find people who you can stop-n-go against.

[preparac]

Makes definitly sense to me. Good idea. Thanks

[sookmctourie]

Kraada wrote:
Apparently there was an issue with the Layout that exported from Beta 25 for the Tournament HUD. Specifically the column definitions exported as tourney_tourney_X instead of tourney_X for all tournament columns. As such, they won't work. I'm in the process of exporting the statistics individually so they can be imported properly, but it seemed prudent to remove the layout file until such time as this issue was resolved.

I'm wondering if the profile import did more than just alter "tourney_"? Being a little? obssesive compulsive, I took the time to maually correct all colum fields by replacing "tourney_tourney" with "tourney_". I ran housekeeping and I'm still getting lots of errors, and the Adv Trny Hud is still not working.

[kraada]

What do the errors say?

[sookmctourie]

I would have to run housekeeping again to get a screen capture. My housekeeping normally takes 3.5 hours. With the introduction of Adv Trny Hud Profile, the process is interrupted at 1.5 hours and an extensive list of errors are listed, "cannot ..." It appears to me that its a query issue.

[kraada]

If it's a PostgreSQL error you should be able to find it in the C:\Program Files\PostgreSQL\8.3\data\pg_log directory. I haven't been getting this error myself but I'll re-run housekeeping again on a semi-large database just to make sure.

Edited to add: I can't recreate this myself, are you sure you didn't miss a stat when going through fixing the tourney_tourney columns?

[sookmctourie]

I rechecked all the column fields and stats, making sure they were all valid. The only thing I found was a column field cnt_p_limp would not validate because it was a cash stat. I edited it, and ran housekeeping again. This is the first part of the error before it lists the actual errors.

2009-03-07 11:53:04 EST LOG: database system was shut down at 2009-03-07 11:25:58 EST
2009-03-07 11:53:04 EST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-07 11:53:04 EST FATAL: the database system is starting up
2009-03-07 11:53:04 EST LOG: database system is ready to accept connections
2009-03-07 11:53:04 EST LOG: autovacuum launcher started
2009-03-07 11:53:05 EST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-07 11:57:35 EST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-07 11:57:49 EST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-07 11:57:50 EST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-07 11:57:50 EST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-07 11:57:50 EST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-07 11:58:00 EST ERROR: relation "tourney_holdem_cache" does not exist
2009-03-07 11:58:00 EST STATEMENT: select sum(cnt) from (select count(*) as cnt from holdem_cache union select count(*) as cnt from tourney_holdem_cache) as CacheCount;
2009-03-07 14:08:08 EST NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "holdem_cache_primary_key" for table "holdem_cache"
2009-03-07 14:08:08 EST ERROR: duplicate key value violates unique constraint "settings_primary_key"
2009-03-07 14:08:08 EST STATEMENT: INSERT INTO settings VALUES('cache_update:holdem', '59567');
2009-03-07 14:08:14 EST ERROR: table "tourney_holdem_cache" does not exist
2009-03-07 14:08:14 EST STATEMENT: DROP TABLE tourney_holdem_cache;

[sookmctourie]

Do you have an estimated date for re-releasing Trny Hud?