The prompt should be played=#
if it's played-# that means you forgot a semicolon; put in a semicolon and hit enter.

Then type this exactly:
SELECT history from holdem_hand_histories;

and hit enter. It should spit everything out properly and all output should be redirected to the file you specified.

ok this is what it gave me for different values

^
played=# SELECT history from holdem_hand_histories;
ERROR: could not read block 177908 of relation 1663/16438/16694: Invalid argume
nt
played=# SELECT history from holdem_hand_histories WHERE id_hand > 10;
ERROR: could not read block 177908 of relation 1663/16438/16694: Invalid argume
nt
played=# SELECT history from holdem_hand_histories WHERE id_hand > 50;
ERROR: could not read block 177908 of relation 1663/16438/16694: Invalid argume
nt
played=#

Try for some larger values? See if you can get it from id_hand > 1000 or > 10000.

How big is your database, roughly?

my database is prob like 1.5mil

ill try bigger values later

just checked its only 1 mil

will try bigger values later.

if u dont come up with another way and it doesnt work, i might just have to reimport some hands i saved somewhere and hope that is all (which it wont be)

should i reinstall postgresql in that case or will creating a new database be fine?

i could also just remove and not delete my database and start a new one right, since all my hands "seem" to be in there for emergency cases

sry, just double checked, coz i had filters on

its actually 5.5 million, alot of obvserved ones tho, im only intersted in played hands if that helps anything

In order to try exporting just played hands, run this query:

SELECT history from holdem_hand_histories, holdem_hand_player_detail, player where holdem_hand_histories.id_hand = holdem_hand_player_detail.id_hand and holdem_hand_player_detail.id_player = player.id_player and player.player_name = "Your Screenname";

It may also not work, I'm not sure how deep the corruption goes. Again, you can also add "Where holdem_hand_histories.id_hand > X" for some numbers x and try to just get some. I'm starting to doubt this will actually work but it's worth one more try (maybe the parts of the database that are corrupted are from the other players, after all).

Good luck

In the cash hud configuration menu, which one of the options stands for btn and co 3bet pf?

Positional stats aren't included by default yet, so you will need to use Custom Stats.
There are a few of these available for download from the Repository although I don't remember seeing 3 bet positional stats yet.
It would be pretty straightforward to build your own, though.
Have a look at how one of the positional stats is made, as well as the 3-bet stats, and have a go.
Custom Statistics and Reports FAQ.
If you get stuck, please ask. (I'd suggest starting a thread in the PokerTracker 3 Forum)

Thanks

A few basic PT3 Qs:

On Stars, when I click "sit here" to rotate the view of the seat that I am in, the HUD stats do not move with me and are on the wrong player. Is there a way around this?

My HUD stats are based only upon the session I am playing, but I want it to be based upon my entire history with that player, how can I change that?

Is there a way to auto-import STT and MTT? I have been maually entering the results so far.

Thanks.

The Hand History doesn't say where you move to when you use "Sit Here" so PT3 cannot recognize your new seat location. You need to use the Preferred Seating on PokerStars in order for PT3 to recognize it. Once you set up Preferred Seating PT3 should automatically detect where you are and rotate the stats accordingly.

Your HUD stats will always be session only and this is by design; your session stats show you how the other players around the table perceive you and this information is very useful since there's no way to know for sure how much data your opponents have for you.

Imports by e-mail for tournament summaries will be available in the next Beta, which should be out by the end of the day tomorrow.

Thanks. Very good info.

Any update on this?

There are currently quite a few filters, and you can do most of what you want right now.

You want position is exactly 0 on the general tab for times you're on the button.

You can then go to the Actions tab and add Chance to Steal, Raised for times when it's folded to you and you raise.

Then you can add Face 3 bet on the Facing tab. Then you'll see hands where you faced a 3bet when opening from the button.

Or you can add "Call 3bet" on the Facing tab's flop section and then you can look at all hands where you stole from the button got 3 bet and flat called.

From there you can add whatever you'd like to reports and see what you'd like to see.

And more filters should be available in the next Beta release, due out sometime tomorrow.

It sounds like I would have to go through all the hands in that situation and look for the villain I want and count right? There isn't the ability to select a player, select filters, then have a number come up?

If you're looking for a number on a specific villian, you should create a custom stat for it.

You didn't give a very specific situation, so here's how you'd create "Fold to cbet in 3 bet pot when having stolen the blinds"

Create two columns in Holdem Cash Player Statistics:

(1) Call the first one something like "cnt_f_cbet_def_fold_when_stealing_and_3bet":

sum(if[ flg_steal_att and enum_p_3bet_action = 'C' and enum_f_cbet_action = 'F'])

(2) Call the second one something like "cnt_f_cbet_def_when_stealing_and_3bet":

sum(if[ flg_steal_att and enum_p_3bet_action = 'C' and flg_f_cbet_def_opp ])

Then go to the statistics tab, create a new stat, call it how you please ("Fold to cbet percentage in 3bet blind stealing pot"? This name is going to get long).

Define it as:
100 * cnt_f_cbet_def_fold_when_stealing_and_3bet / cnt_f_cbet_def_when_stealing_and_3bet

Make sure on the format tab you give it a width (40 or 50 should be fine) and a title (FCB3BWS?).

You can then add that stat to any report that can access the Holdem Cash Player Statistics information and use that data on your HUD.

Now, it won't be based on times they've done that to you but rather times they've done that with all opponents.

Still, that should get you what you're looking for. And, similarly, you can create other stats in the same vein.

Sorry in advance for what probably are newb questions. I just purchased PT3 for use with FullTiltPoker. I read the documentation but didn't see anything that addressed this.

1. Should I download the Beta20 release (11/4/08) or the Build 3 release (9/29/08)? I would think the Build 3 release since it would not be as buggy, but what do I know?

2. Do I need to make an adjustment in the FTP software on how many days I keep my hand history? Does the PT software keep all my history since the first day, regardless how long I save my hand history in FTP?

This is what I was asking about.

When importing older hands into PT3, does PT3 recognize duplicate hands as duplicates or unique? i.e., are hands double counted, and therefore I need to manually remove the duplicates?

There are enough fixes and improvements in Build 20 to make that the preferred version.
You can check out the version history post and make your own decision if you like: http://www.pokertracker.com/forums/v...hp?f=15&t=6548

No, as long as the files are written that's fine. PT3 will read them as they are updated, and when you stop auto import it will move the files to another folder as a backup (and so it doesn't have to read them again next time).
If you leave the "Store Hand History Text" option enabled then the hand history text will also be stored in the database.

If the hand is already in your database then it will be identified as a duplicate and NOT imported again (so you don't need to do anything).

Beta 21 Released

Added:

• New Site: Boss Media
• Tourney: Enter Results window allows you to select and edit/auto multiple tournaments at once
• Tourney: Report: Tournaments - By Time
• Import from Email
• New Filters
• Option to use images to represent cards in reports
• OnGame tournament support

Fixed:

• Report: Tournaments/Winnings tab using the "Amount Won" value instead of the "Net Won" value for the row coloring
• Auto Rate: "Rules" tab shows icons properly (broke in previous release)
• Import: OnGame import problem with steal attempts
• Import: After preflop raise, flag for cbet opportunity being set

PT3 now supports a new site: Boss Media. This is full support: Cash, Tournament and Hud on both. It has not been thoroughly tested yet, so there may be some statistical bugs, so please compare your PT3 results with what PT2 shows (if you use PT2).

Tournament support has been improved. There is now a "Tournament - By Time" report, which allows you to see your true hourly win rate. Also, tournament result entry has been improved. You can highlight multiple tournaments and edit them all at once. You can also use the Auto Fill to automatically fill the results for multiple tournaments at one time. To further improve tournament result entry, PT3 can import summaries from your POP3 email account. Simply configure PT3 using the link on the Manual Import tab and then click the Import from Email button. It will bring up a window that lets you select which emails you would like PT3 to import from.

New filters have been added to PT3. You can now filter for all-ins, as well as board texture, cards on the board, various pot sizes, and more. These filters were a late addition and thus have not been tested much. Please report any inconsistencies you notice.

OnGame tournament support has been added. This was also a late addition and has had very little testing. Please let us know of any problems you experience.

We hope to add more site support by the end of the year. Thanks to those of you who have submitted hands to us, but we still need more. We need hands from the following sites:

• Absolute
• B2B
• Betfair
• Bodog
• Cryptologic
• Microgaming Network
• Pacific Poker
• Tain Network
• Tribeca
• Ultimate Bet
• World Poker Exchange

We need hand histories in all formats and both cash and tournament hands. For sites that use database files or single xml files or whatever, we need those as well as any datamining formats and PT2 exported formats. The more hand histories we get, the easier and faster it will be for us to get support added for the site. The sites above are not listed in the order we will be adding them. We have been going by http://pokerscout.com and adding the sites by size. We may continue to do this or we may skip around now that the unsupported sites are pretty similar in size. To submit your hand histories, please follow this link.

Unfortunately I don't think it's possible to make any "Against Me Only" stats in PT3 at this time.

pls say something about this

another question:

if i do this


SELECT history from holdem_hand_histories, holdem_hand_player_detail, player where holdem_hand_histories.id_hand = holdem_hand_player_detail.id_hand and holdem_hand_player_detail.id_player = player.id_player and player.player_name = "Your Screenname";


will my usual screenname that has aliasses attached to it in pt3 be enough or can i do "screenname1, screenname2"?

So long as you don't initialize a new database cluster on top of the old database location, your data will not be harmed; reinstalling PostgreSQL will only nuke your database if you initialize a new database cluster on top of the old one.

I believe the alias function actually adds your data together at a low enough level that using just your master screenname would get all hands from all aliased screen names as well.