Number of Hands played in the last 10 mintues

[devolveNZ]

What I'd like to do is create a stat that will tell me the number of hands a player has played in the last time minutes.
I would then use this stat to run a report (where current hands played > 0) detailing information about payers I'm currently playing.

I'm not sure how to create the cnt_hands_last10mins column.

I'm guessing you use holdem_hand_player_statistics.date_played < "current time'- 10 mins'

However is this a date stamp only, or does it include the time played as well?
What is the correct syntax?

Thanks for your help.

[WhiteRider]

You can check like this:

holdem_hand_player_statistics.date_played > (now() - interval '10 minutes')

Bear in mind if you build are stat to use this in the Holdem Cash Player Statistics then the value will be cached so it won't work correctly.

I assume that you want to see the total stats for all players who have played a hand in the last 10 minutes?
I thought that I had a custom report which would do this, but I can't find it – I think Kraada will have one when he comes on later.

[kraada]

Report attached.

[WhiteRider]

That's only going to show stats from hands played in the last 10 minutes, though?
I think devolveNZ wants to see total stats for all players who have played a hand in the last 10 minutes, so we'll need one of your clever filters... :)

[kraada]

Oh, I thought he was looking for a way to find the mass multitablers he's against :)

Changing the filter to:

player.id_player in (SELECT p.id_player from player p, holdem_hand_player_statistics hhps where hhps.id_player = p.id_player and hhps.date_played > (now() - interval '10 minutes'))

should do that.

[devolveNZ]

What I'm doing is making a 'pseudo HUD'
Basicly I've made a script that converts a Hand History from a poker site PT3 doesn't support, into one that it does.
And then importing the hands as per normal.
I then want to run a report showing different stats that would be used in a HUD, but only showing the players I've played
against in the last 10 minutes. I can then look at this report, and use it as I would use a HUD.

I used the filter you suggested, and unchecked 'filter on active player'

player.id_player in (SELECT p.id_player from player p, holdem_hand_player_statistics hhps where hhps.id_player = p.id_player and hhps.date_played > (now() - interval '10 minutes'))

However I always get 0 players in the report. I tested the report while playing on stars but I still got 0 players, just in case that was the problem.

I also tried Kraada's last10min report, but that returned 0 results as well.

Did you get any results in your report?

Thanks for your help. Greg

[WhiteRider]

Kraada's new filter is working for me.
Are sessions/hands shown as the correct time in PT3?
It's possible that you have a time zone (or daylight savings) issue, in which case you may need to extend the time. Try a larger number of minutes, like 600 (10 hours) and see if that works. If it does, experiment with the period – you may find that you need to use 70 minutes, for instance.

[devolveNZ]

It was a time zone issue, thanks for your time, everything is working as it should.

[WhiteRider]

Cool - thanks for letting us know.