[MTT PKO] Show Bounty Factor in HUD

[fruethr]

Hello,
I'm working on this project with the help of gpt 4 because i don't have enough knwoledge on the SQL/coding side.
Unfortunately the code that GPT suggests is not working due to different reasons.
First of all some colums names in PT4 are different.
Eg: player_id is id_player in PT4.
Apart this i suspect there are also differences in the sintax of the espression.

The goal here is to get the bounty factor displayed on HUD for each player.
BOUNTY FACTOR: Ratio between Starting Bounty units and starting stack units. This is very inportant to determine the weight of the bounty and the ability to widen our calling range to capture it.

First of all i need to be able to extract from the very first hand of the tourney the stack of hero (this will properly extract the data even if late registrating).
This allows to have the data of the starting stack.
The same needs to be done for the starting bounty.

With this data i can then make a stat that will do a ratio between units of starting bounties and units of starting stack.

Yesterday i was trying to extract the starting stack of hero but even if i corrected the gpt code with the right column names in PT4 the expression was not valid.
I will provide what GPT suggested me if anyine likes to examine it.

Is anyone able to determine if this is something we can do and help me on the coding side?

Thanks

[fruethr]

This is what gpt suggests to extract the stack of hero in the first hand.
Of course, even on my level of basic knowledge of the SQL database, i can recognize a lot of reasons for this to not work, because as stated on the OP the colums names are different and need to be replaced.

Anyway i need to know if gpt 4 is able to suggest reasonable code sintax for this.

SELECT
h.tourney_id,
h.player_id,
h.stack AS initial_stack
FROM
cash_hand_player_statistics h
INNER JOIN
tourney_results t ON h.tourney_id = t.tourney_id
WHERE
h.hand_number = ( -- First hand of the tournament
SELECT MIN(h2.hand_number)
FROM cash_hand_player_statistics h2
WHERE h2.tourney_id = h.tourney_id
AND h2.player_id = h.player_id
)
AND h.player_id = ( -- Hero Player ID
SELECT player_id
FROM players
WHERE screen_name = 'Hero' -- replace with your Hero's screen name
)

[Flag_Hippo]

Unfortunately that's beyond my own SQL knowledge and I'm not aware of a method to create a statistic for that.

[fruethr]

Hi and thanks for your reply.
Are you a developer of PT4?
Can you describe what is the most difficult task here?

[fruethr]

Unfortunately that's beyond my own SQL knowledge and I'm not aware of a method to create a statistic for that.

Hello Hippo,

I've extended my research on this topic and with the immense help of gpt-o1 i jumped to some interesting conclusions.
Exploring the database with pgAdmin there is a table called tourney_summary in which we can find some useful columns: amt_bounty and amt_starting_stack.

amt_bounty: this field is automatically populated by PT4 analyzing the hh and it successfully stores data of all the bounty fees related to any tournament.
it also appears in the columns list in PT4.

infact, if we run this SQL Query on pgAdmin:

SELECT id_tourney, amt_bounty
FROM tourney_summary
WHERE amt_bounty IS NOT NULL AND amt_bounty > 0;

We get this list of outputs in the attachment 1.



amt_starting_stack: this is only present in pgAdmin columns list and not in PT4.

infact, if we run this SQL Query on pgAdmin:

SELECT id_tourney, amt_starting_stack
FROM tourney_summary
WHERE amt_starting_stack IS NOT NULL AND amt_starting_stack > 0;

We get an empty list of data.



Now my issue seems to be that i can't see viable options to get the starting stack of the toruney and this seems a little strange to me.
Can we look into some kind of solution to get this piece of info implemented in PT4?
Seems to be easy to complete the other part of the puzzle if i can get a column with the starting stack of each tournament, but maybe this is really the hard part.

Looking forward for some kind of feedback.

Thanks
Alessandro

[Flag_Hippo]

Are you a developer of PT4?

No.

Can you describe what is the most difficult task here?

Statistics which combine hand data and overall tournament data will not work in the HUD. With regards to starting stack information that isn't currently stored in the database - this is why there was no data when you queried that column. If you want to be notified when support has been added you can let us know via a Support Ticket.