Open Side Menu Go to the Top
Register
PokerTracker 3 PokerTracker 3

05-22-2008 , 09:36 AM
Quote:
Originally Posted by stevi3p
My W$SD has increased massively from PT2 to PT3 over the same sample size. In PT2 it was 52.4% (over 31,000 hands). In PT3 it is 59.6% (over 31,000 hands). The latter figure just seems way too high. Is it treating split pots differently or something?
Quote:
Originally Posted by PokerAce
It does treat split pots differently. In PT3, if you win and split the pot, but lose slightly due to the rake, it's still considered a win. In PT2, these are losses. While technically, you lost money due to the rake, you actual won the hand.
I'm 99% sure there is a bug here. I ran a SQL query in pgadmin looking at cases where amt_won<0 in cases where somebody "won" the hand and went to showdown. It returned many cases which didn't make sense. Here's one:

***** Hand History for Game 7056841957 *****
$100 USD NL Texas Hold'em - Wednesday, May 14, 17:30:42 ET 2008
Table Table 126292 (No DP) (Real Money)
Seat 1 is the button
Total number of players : 6
Seat 1: Jacky0902 ( $45.49 USD )
Seat 2: unexplicable ( $157.81 USD )
Seat 5: Atohn1 ( $135.96 USD )
Seat 6: Fish_Donker ( $162.93 USD )
Seat 3: LooseTomte ( $95.40 USD )
Seat 4: SnakeGumm ( $50 USD )
unexplicable posts small blind [$0.50 USD].
LooseTomte posts big blind [$1 USD].
** Dealing down cards **
Fish_Donker raises [$4 USD]
Jacky0902 calls [$4 USD]
unexplicable folds
LooseTomte folds
** Dealing Flop ** [ 3c, 3s, 6h ]
Fish_Donker bets [$9 USD]
Jacky0902 raises [$18 USD]
Fish_Donker is all-In [$149.93 USD]
Jacky0902 is all-In [$23.49 USD]
** Dealing Turn ** [ 3d ]
** Dealing River ** [ Tc ]
Jacky0902 shows [ 4c, 3h ]four of a kind, Threes.
Fish_Donker shows [ 9c, 9s ]a full house, Threes full of Nines.
Fish_Donker wins $117.44 USD from the side pot 1 with a full house, Threes full of Nines.
Jacky0902 wins $90.48 USD from the main pot with four of a kind, Threes.
Game #7056843714 starts.

It seems to include cases where somebody goes all in, has them covered, they call and they win. PT3 seems to think that the all-iner wins a side-pot, when all that's happened is money has been returned. I play on Party and Ongame and noticed the problem occurring on both sites.
05-22-2008 , 09:50 AM
Quote:
Originally Posted by r0eKY
Therefore, to log into this database from my other computers in the house the server: port: pass is - 192.168.1.16:5432:dbpass.

this is the part i dont understand
When you start up PokerTracker 3 having never installed PostgreSQL on the computer, and if you're starting up the "WITHOUT" download, it prompts you to log in to some database. The boxes are: server, port, user password.

Server is the IP address of the computer that has the database installed. So if the computer that has PostgreSQL installed on it is 192.168.1.102, that goes in the 'server' box. Port will almost always be '5432' (you can manually change that, but the directions don't have you doing so). User is most likely 'postgres', and the default password is 'dbpass'.

So when you start up PokerTracker 3 on Computer # 2 having never installed PostgreSQL it will prompt you to connect to somewhere or get PostgreSQL. Use whatever your information is for IP Address, then the rest of the default values and you should be able to connect. Once you've connected, you're all set and everything else should function identically.
05-22-2008 , 09:51 AM
Quote:
Originally Posted by stakman1011
I appreciate all your hard work and I really am trying to be patient. But I sent my Pokerstars transfer like 4 or 5 days ago and I notified you through the support feature of your site.

Is it really taking this long to get to sending out registration codes? I'm sympathetic to the workload you must be under but I was hoping to have it by now.

I'd be glad to resend or something if my message has been lost in translation somehow.

Thanks again for a wonderful program..

STak
STak,

I greatly apologize for your situation, if you will PM me the ticket number of your ticket I will make sure it gets attention shortly.
05-22-2008 , 02:05 PM
I just bought PT3 and when importing I get alot of
Quote:
2008/05/22 19:04:10: Import file: F:StuffpokerhhsPartyFR#2008#080420080403Jackpot #1304210_1304210.txt
2008/05/22 19:04:10: Invalid pot size/winnings for hand #6939519010 (Line #3280)
2008/05/22 19:04:10: Invalid pot size/winnings for hand #6939557551 (Line #4076)
2008/05/22 19:04:11: Invalid pot size/winnings for hand #6939681027 (Line #6338)
2008/05/22 19:04:11: + Complete (193 hands, 3 errors, 0 duplicates)
errors, like 3 errors/file or so. Those hands have been imported fine and with no errors when using the beta. I've opened a ticket on the website with errors and handhistories, I'm just wondering if this is a known issue? ETA on fix?
05-22-2008 , 02:22 PM
Quote:
Originally Posted by Kraada
When you start up PokerTracker 3 having never installed PostgreSQL on the computer, and if you're starting up the "WITHOUT" download, it prompts you to log in to some database. The boxes are: server, port, user password.

Server is the IP address of the computer that has the database installed. So if the computer that has PostgreSQL installed on it is 192.168.1.102, that goes in the 'server' box. Port will almost always be '5432' (you can manually change that, but the directions don't have you doing so). User is most likely 'postgres', and the default password is 'dbpass'.

So when you start up PokerTracker 3 on Computer # 2 having never installed PostgreSQL it will prompt you to connect to somewhere or get PostgreSQL. Use whatever your information is for IP Address, then the rest of the default values and you should be able to connect. Once you've connected, you're all set and everything else should function identically.
when i goto "ipconfig" in the command prompt on my main pc it says it's not a recognized command but on my 2nd pc it works and gives me the ip so are the 2 the same or is there another way of finding the ip for my sql client machine? thanks
05-22-2008 , 04:07 PM
When I try to set up a custom stat and add it using the spanner button, it won't show up in any of the tabs within PT3 (I'm not referring to the HUD but the "main" application. I can set it up to pick up any pre-defined stat, but not a new custom one.

Grateful if this could be fixed.

Thanks
05-22-2008 , 04:13 PM
Quote:
Originally Posted by r0eKY
when i goto "ipconfig" in the command prompt on my main pc it says it's not a recognized command but on my 2nd pc it works and gives me the ip so are the 2 the same or is there another way of finding the ip for my sql client machine? thanks
I can't check it right now (no windows on my working computer), but IIRC you need to have admin rights to execute ipconfig.
05-22-2008 , 05:01 PM
Quote:
Originally Posted by Maunzekater
I can't check it right now (no windows on my working computer), but IIRC you need to have admin rights to execute ipconfig.
im on xp not vista
05-22-2008 , 05:26 PM
what was the standart password for the sql database again?ty
05-22-2008 , 06:04 PM
dbpass
05-22-2008 , 06:21 PM
Quote:
Originally Posted by stakman1011
I appreciate all your hard work and I really am trying to be patient. But I sent my Pokerstars transfer like 4 or 5 days ago and I notified you through the support feature of your site.

Is it really taking this long to get to sending out registration codes? I'm sympathetic to the workload you must be under but I was hoping to have it by now.

I'd be glad to resend or something if my message has been lost in translation somehow.

Thanks again for a wonderful program..

STak
credit cards work instantly...
05-22-2008 , 07:48 PM
Did you ever get any feedback on if this worked correctly?


Quote:
Originally Posted by Greg29
Ok I tried something for the Fold to 3bet stat, can someone confirm that it's correct:

F3b = (cnt_f_3bet_after_raise / cnt_f_3bet_after_raise_opp) * 100

where cnt_f_3bet_after_raise = sum(if[(holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.enum_p_3bet_action = 'F'),1,0])

and

cnt_f_3bet_after_raise_opp = sum(if[(holdem_hand_player_statistics.flg_p_first_raise) AND (holdem_hand_player_statistics.flg_p_3bet_def_opp) ,1,0])


Thank you
05-23-2008 , 01:14 AM
please bring build 3 out my pokertracker keeps randomly freezing and closing!
05-23-2008 , 02:47 AM
Kind of a repeat question but I haven't seen a straight answer yet. Is PT3 going to have the Poker Stars memory scanner just like PT2? I have a few million hands for the levels I play. Will PT3 be able to use that DB and grab/display the stats, before I sit at the table?
05-23-2008 , 03:34 AM
I was using pt3 on ftp and everything worked fine. all of my sngos auto imported fine, stats were accurate. everything was fine.

I just played all night on ps and while the auto import for the cash games i played is fine, stats are fine. the auto import for the sngos that i played are not accurate. they all dont have the position i finished and my winnings/losses are not accurate.

why does it work on ftp and not pokerstars. what can i do ??? i sure hope i dont have to manually enter anything..

help please
05-23-2008 , 04:24 AM
Quote:
Originally Posted by Ashy Knuckles
I was using pt3 on ftp and everything worked fine. all of my sngos auto imported fine, stats were accurate. everything was fine.

I just played all night on ps and while the auto import for the cash games i played is fine, stats are fine. the auto import for the sngos that i played are not accurate. they all dont have the position i finished and my winnings/losses are not accurate.

why does it work on ftp and not pokerstars. what can i do ??? i sure hope i dont have to manually enter anything..

help please
Must manually enter on Stars.
05-23-2008 , 04:39 AM
screw that... any idea when it will work properly ??
05-23-2008 , 10:13 AM
Quote:
Originally Posted by oracle3001
PokerAce, given what you said in your last post when would you expect to get the next release out(ish)? As I understood it the plan was for a new build around today, but I take it that it will now be a bit longer.
Some of the Hud fixes are taking longer than I hoped. I'm not going to rush another release. I'm going to try to make sure the next release fixes all the major known bugs and that it will work without lag for most people. It's possible I could have something out by the end of the weekend, but more realistically, it will be next week sometime.

Quote:
Originally Posted by SoundMan
Oh, really?
So, the documentation cannot be trusted then?
http://www.pokertracker.com/products...ase_Schema.pdf
It's not as if it's a conspiracy to get you to believe the wrong thing. The documentation just hasn't been updated in a long time.

Quote:
Originally Posted by DMoogle
FTP's deep HU tables are being imported as regular tables (i.e. suggesting they are FR).
If the hand histories don't specify that the hands are heads up, PT3 doesn't automatically make them 2 max. You can click the "Adjust Qualifying Tables Limits" option in the auto-import preferences and it will mark these as 2 max.

Quote:
Originally Posted by dorado29
so i had to make a new database when i d/l'ed the official PT3 when it came out. it said my old database (1 million hh's) was outdated. not that big of deal so i make a new database and try to export/re-import the hands into that one. however, i get this message when i try to export

"unable to execute query: select hhh.id_hand from holdem_hand_histories hhh, holdem_hand_histories hhh, holdem_hand_summary hhs Where hhs.id_hand=hhh id_hand and hhs.id_site=300;; Reason: Fatal Error (ERROR: could not read block 9543 of relation 1663/25306/33823: Invalid argument"

any way to fix this? i did get some very recent HH's from a different site (stars) exported into the designated folder but theres still a ~1 million from FT

edit: damnn Poker Ace you must be bogged down with all these support questions
It sounds like you have a corrupt database. Make a post in our PostgreSQL forum on our site. You'll get better help there.

Quote:
Originally Posted by meleader2
is there a way to save HUD position layouts for stars and one for FT because the panes don't line up on FTP as the do for PS
Yes, just position them and PT Icon -> Save Layout.

Quote:
Originally Posted by r0eKY
i have 2 pc's on a home network and i want pt3 on 1 pc and hud on the other one, is there anyway to set this up. I see a proxy option but im not sure what this is. thanks
No, this is not possible. At least not at this time.

Quote:
Originally Posted by stakman1011
I appreciate all your hard work and I really am trying to be patient. But I sent my Pokerstars transfer like 4 or 5 days ago and I notified you through the support feature of your site.

Is it really taking this long to get to sending out registration codes? I'm sympathetic to the workload you must be under but I was hoping to have it by now.

I'd be glad to resend or something if my message has been lost in translation somehow.

Thanks again for a wonderful program..

STak
You definitely should've received your code much sooner than this. If you still don't have your code, reply to your support ticket and send Derek (APerfect10) a PM on our site. I apologize for your wait time.

Quote:
Originally Posted by stevi3p
When I try to set up a custom stat and add it using the spanner button, it won't show up in any of the tabs within PT3 (I'm not referring to the HUD but the "main" application. I can set it up to pick up any pre-defined stat, but not a new custom one.

Grateful if this could be fixed.

Thanks
Under what section did you create your stat? Is it not appearing on the list of stats available in the report config window, or is it not showing in the report once you've added it?

Quote:
Originally Posted by MyironThumb
please bring build 3 out my pokertracker keeps randomly freezing and closing!
I understand it's frustrating. That's why I'm waiting until I'm confident the next build will work correctly for most people.

Quote:
Originally Posted by l0gician
Kind of a repeat question but I haven't seen a straight answer yet. Is PT3 going to have the Poker Stars memory scanner just like PT2? I have a few million hands for the levels I play. Will PT3 be able to use that DB and grab/display the stats, before I sit at the table?
Yes, but with the restrictions PokerStars has put into place for this (only 30 hands per observed table).

Quote:
Originally Posted by Ashy Knuckles
screw that... any idea when it will work properly ??
PokerStars does not record your winning information in it's hand histories written to disk. You need to request your tournament summaries and copy/paste the email they send you to a file on disk and manually import that file into PT3. That, or you need to manually enter the results. We plan on adding the email-reading functionality so you can skip the copy/paste step, so that will make it a bit easier.
05-23-2008 , 10:38 AM
Quote:
Originally Posted by PokerAce
Under what section did you create your stat? Is it not appearing on the list of stats available in the report config window, or is it not showing in the report once you've added it?
Under configure, in the Statistics tab. It didn't appear in the report (in both Table Tracker and the 'positions' tabs). It gave me the choice in the config window, and it appeared to work within that window, but ignored my choice to add it after clicking apply and close. Closing PT3 it and starting it again didn't work. Returning to the config window, the window still showed the stat as being added, but it wouldn't report - the column didn't appear at all.

Grateful for a response on my earlier post re: what seems to be a bug re: W$WSD. PT3 seems to think we've W$WSD even if we lost a heads-up pot when we (a) have the opponent covered and (b) bet more than he has. It seems to not recognise the difference between money being returned and a true sidepot. This is a significant issue IMO.

Thanks
05-23-2008 , 12:01 PM
Quote:
Originally Posted by l0gician
Kind of a repeat question but I haven't seen a straight answer yet. Is PT3 going to have the Poker Stars memory scanner just like PT2? I have a few million hands for the levels I play. Will PT3 be able to use that DB and grab/display the stats, before I sit at the table?



Quote:
Originally Posted by PokerAce
Yes, but with the restrictions PokerStars has put into place for this (only 30 hands per observed table).
So PT3 will be able to use only 30 hands from my database to display stats before I sit, even if I have 30k hands on someone? Count me out! I hope you are planning on keeping PT2 & Ace hud working in the future.
05-23-2008 , 12:47 PM
Quote:
Originally Posted by l0gician
So PT3 will be able to use only 30 hands from my database to display stats before I sit, even if I have 30k hands on someone? Count me out! I hope you are planning on keeping PT2 & Ace hud working in the future.
LOL - Reading Compreshension, FTW. Pretty sure what he meant was:

It will only be able to 'Read the first 30 observed hands' (i.e. - Datamine 5 orbits). The HUD stats will obviously pull from your entire DB, + the new 30 observed hands, so you can table select. I believe it will be similar to PT2/PAHUD, only better cuz u get +30 more recent observed hands into the HUD stats, to help you table select.
05-23-2008 , 12:50 PM
Quote:
Originally Posted by fozzy71
LOL - Reading Compreshension, FTW. Pretty sure what he meant was:

It will only be able to 'Read the first 30 observed hands' (i.e. - Datamine 5 orbits). The HUD stats will obviously pull from your entire DB, + the new 30 observed hands, so you can table select. I believe it will be similar to PT2/PAHUD, only better cuz u get +30 more recent observed hands into the HUD stats, to help you table select.
Well I made it rather clear I didn't care about the 30 hands and wanted to know about my DB hands. In the PT3 forums and in here I got the same 30 hand response, no mention of, yes of course your DB hands will be included.
05-23-2008 , 01:36 PM
Quote:
Originally Posted by PokerAce
PokerStars does not record your winning information in it's hand histories written to disk. You need to request your tournament summaries and copy/paste the email they send you to a file on disk and manually import that file into PT3. That, or you need to manually enter the results. We plan on adding the email-reading functionality so you can skip the copy/paste step, so that will make it a bit easier.

tried this last night..

1) i had ps send the hh of the 6 sngos i played last night to my email. (seperately, because i dont know how to do them all at once)

2) i copied and pasted each hh to note book and placed them in a new folder.

3) i went to manual import in pt3 and chose import from files.

4) i opened the folder that the hhs were and highlighted them all and imported them all into pt3

5)pt3 said that 6 0f 6 files were imported but nothing changed in my tournament stats..


when you all fix this problem will the user have to manually import anything ?? when do you expect to have this done ??

i read the thread for over an hour trying to learn how to do this properly.. i understand copy/paste, could you walk me through it please. perhaps i missed a step.


thanks..
05-23-2008 , 02:16 PM
Pleaase release build 3 asap...it's very frustrating to buy a program and have to use the older version (PT2...) because the new one doesn't work properly.
05-23-2008 , 02:32 PM
Quote:
Originally Posted by Kayooo
Pleaase release build 3 asap...it's very frustrating to buy a program and have to use the older version (PT2...) because the new one doesn't work properly.
well give them time to fix up the bug
make no sense to release build 3 if known bug is not kill yet
you'll still have the same problem

      
m