HowTo: Working Tournament M Values + Get M Specific Stats

[MixMastaPJ]

Ok, got it running with about 80% accuracy. This may be a result of the fact that I was only testing it at $1 heads up tables in order to check it out before unleashing it at my regular games (full ring)

about 20% of the time, I would get a reading of M equalling zero. Any ideas why?

[WhiteRider]

I haven't looked into this mechanism myself but hopefully the OP will have an idea.

[MixMastaPJ]

ok, played it 9 handed and had some similar results. But I think I know where the problem is lying. I'm thinking the HUD looks to update more than once during a hand, but sometimes reaches and finds no data and reports a zero back for M. This happens since it is not a collective statistic where the previous hands add to a sum of data as with VPIP etc.

[WhiteRider]

Yes, I suspect it's something like that, but I don't know how the updates are triggered here.

[AAA Donnie]

I was able to execute the query after deleting the create language statement.... Step#1 done, I think?

but, When I try to create a new column (step#2) it says "The statement is not valid SQL.

That's as far as I've got on my own. Anyone, help please

[kraada]

Are you sure you pasted the entire row including all of the trailing )s? (I've missed one before and driven myself crazy figuring that out )

[AAA Donnie]

Yeah, I used copy/all and tried it like 7 times. I even typed it in by hand to make sure once.
Also, is this supposed to be done in the Tourney player_player stats section? It doesn't say which section to create the column in. Very vague tutorial imho.
Mike was gonna walk me thru this, but I guess he's been busy. Can't seem to connect w/ him on AIM.

[kraada]

Unfortunately I haven't had a chance to do more in depth work on these functions so I'm still not entirely sure what could be going wrong for you.

[AAA Donnie]

Thanks for the reply anyway. I'll get it somehow...

TC/GL

[AAA Donnie]

I submitted a ticket w/ the errors and .log file attached. After I attempt to create a column, I get the
"The statement is not valid SQL" I can't even create the column to move on, to create the stat...

TY