Advanced Hud Config for Tourney's

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Re: Advanced Hud Config for Tourney's

Postby kraada » Thu Mar 05, 2009 10:51 am

Just to keep people updated: all of the stats got built yesterday, so all I need to finish off today is, once the cache rebuild completes, putting them into a Popup window, then creating a few screenshots and writing the new post for the How To, then exporting the actual layout and zipping it up so you can all download it :D
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Advanced Hud Config for Tourney's

Postby preparac » Thu Mar 05, 2009 1:15 pm

Kraada,
will you make available your opus magnum also stat by stat ... ? I'm afraid to overwrite some of my own (different but perhaps identicaly named) custom stats and columns when I import your work as a whole ...
thanks
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am

Re: Advanced Hud Config for Tourney's

Postby kraada » Thu Mar 05, 2009 2:01 pm

If you have different but identically named stats the new stats shouldn't overwrite the stats already in the database.

Are there any stats in particular that you're worried I'd be duplicating?

Oh and because I can do this to make you guys drool, here's what the by M popup looks like:

byMpopup.png
byMpopup.png (6.22 KiB) Viewed 904 times


(I'm writing up the post and exporting the layout as soon as I finish this post and the actual layout should be available very shortly :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Advanced Hud Config for Tourney's

Postby kraada » Thu Mar 05, 2009 4:24 pm

The Tourney HUD is posted, see the How To: Advanced HUD Configuration for the download. Please note it does require Beta 25.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Advanced Hud Config for Tourney's

Postby preparac » Thu Mar 05, 2009 5:03 pm

Amazing! You put a lot of work and thought in it... Thank you again!

And: In particular I'm worried about the positional stats, because I use a slightly different defnition of EP/MP/LP in the colums and I'm also worried about the coloring of the stats, because there I'm using everywhere my own completely different coloring system ... so I think I will export all my custom stats first to be sure I could reimport them just in case ...
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am

Re: Advanced Hud Config for Tourney's

Postby kraada » Thu Mar 05, 2009 5:21 pm

That's probably going to be easiest. My naming conventions for those stats was basically: Statname - EP

So it's:
VP$IP - EP
VP$IP - MP
VP$IP - LP
VP$IP - Blinds

etc.

If you don't use the dash and spaces or use "Early Position" or anything other than that exact name you shouldn't have a conflict, though backing up your data wouldn't be a bad thing either.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Advanced Hud Config for Tourney's

Postby sookmctourie » Thu Mar 05, 2009 7:50 pm

Looks very impressive Kraada! :D :D I'll be importing and updating cache tonight. Can't wait to test drive tomorrow. Thanks again.

Art
sookmctourie
 
Posts: 202
Joined: Thu Mar 06, 2008 7:52 pm

Re: Advanced Hud Config for Tourney's

Postby Hextall » Thu Mar 05, 2009 10:34 pm

Thanks kraada... these look great.

one problem... I imported, then forgot to update my cache. tried to open the advanced hud, and of course the popup was blank. So I tried to update the cache, and I get a message there were errors while updating cache...

Any suggestions?
Hextall
 
Posts: 17
Joined: Wed Jan 07, 2009 5:16 pm

Re: Advanced Hud Config for Tourney's

Postby preparac » Fri Mar 06, 2009 5:07 am

There is a typo in some of the new Kraada-Stats f.ex.
tourney_tourney_holdem_hand_player_statistics.position
instead of
tourney_holdem_hand_player_statistics.position
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am

Re: Advanced Hud Config for Tourney's

Postby preparac » Fri Mar 06, 2009 5:14 am

Actually this Typo is in ALL of the new stats ... so no valid SQL statement
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am

PreviousNext

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 1 guest

cron
highfalutin