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

05-20-2008 , 09:20 PM
Quote:
Originally Posted by mittman84
Please make it so we can edit the pop up stats on the HUD!!! Thank you!
What do you mean? You can edit the pop up stats. It may not be the most user friendly thing to do at the moment, and they are aware of that and will improve it, but you can still do it by selecting the "Default Popup" in the "Groups" tab and then go to the "Stats" tab to customize it.

Quote:
Originally Posted by Sickboy
say i have a 6 million hand databse and like 1/3 of that is NL100 and the rest is 200NL.
is there anyway to purge the 200NL hands from the database so its not so damn huge anymore...cuz i moved down


also is there anyway to purge hands that are older than say 6 months etc?
Selective purge is unfortunately not added yet, but it's coming.
05-20-2008 , 09:40 PM
Quote:
Originally Posted by Dazarath
When you export hands from PT2, you can filter hands by date/stakes/site/etc.

Do I export them and then re-import them into a new PT2 database or can I export them and just import into PT3?
05-20-2008 , 09:54 PM
Quote:
Originally Posted by xxrod17xx
Do I export them and then re-import them into a new PT2 database or can I export them and just import into PT3?
Umm, this depends on what your goal is. By your previous post, I assumed you wanted to build a PT3 database using only some of the hands from your PT2 database. But once you've exported the raw HHs, you can do whatever with them. You can build a PT3 DB, a PT2 DB, or a DB with any other tracking software.
05-20-2008 , 10:19 PM
This one's weird: I just had to add my pokerstars name to my aliases although it was already in there. It's now in there twice. I have no idea what triggered this.

And... I've got some full tilt sessions (by table) with... 0 hands? The times are the same as the actual sessions I played on those tables, which are also shown.

And... some of my hands aren't showing up anywhere, of 770 hands today (PT2), PT3 only acknowledges that I played 647. One session (table) should be 70 hands, but it's 27 in PT3 although if I try to reimport the file in question, it says 71 duplicates (don't ask me where that 1 hand went, maybe I was sitting out).

Last edited by notreallymyname; 05-20-2008 at 10:36 PM.
05-21-2008 , 12:02 AM
Quote:
Originally Posted by Dazarath
Umm, this depends on what your goal is. By your previous post, I assumed you wanted to build a PT3 database using only some of the hands from your PT2 database. But once you've exported the raw HHs, you can do whatever with them. You can build a PT3 DB, a PT2 DB, or a DB with any other tracking software.
great thanks.

Edit: How do I export a large group of hands without having to put them in 300 hand files?

Last edited by xxrod17xx; 05-21-2008 at 12:19 AM.
05-21-2008 , 05:11 AM
Quote:
Originally Posted by xxrod17xx
great thanks.

Edit: How do I export a large group of hands without having to put them in 300 hand files?
What would you prefer to put them in?
05-21-2008 , 01:19 PM
Quote:
Originally Posted by 437 Nr. 3
So will we lose all our settings when the next update comes out?

More importantly

HOW THE HELL CAN I MAKE MY STATS NOT HAVE ANY BACKGROUND? If i use transluency to zero I dont see anything at all and theres no "transparent colour"
Your settings won't be affected by upgrades. Transparent backgrounds are not yet supported.


Quote:
Originally Posted by ghengis_socrates
Thanks for your response re: reports. I had PT3 completely lockup while in the process of playing back a hand. Is this a reported problem or would you like me to open a ticket?
I believe I've fixed all the replayer problems for the next release.

Quote:
Originally Posted by ghengis_socrates
Sorry, forgot one item: are there plans to add ev calculations to the playback, similar to PT2?
Yes.


Quote:
Originally Posted by YoureToast
Then perhaps the misinterpretation I'm having is in the lookup_positions table. It won't register a flagged position if the position > cnt_players. Perhaps the lookup_position table isn't intended to be linked to the hhps or hhs tables? Let me know your thoughts.

Much appreciated.
The lookup table was added to the schema before we made the change for bb/sb positions. It will need updated to reflect the change.

Quote:
Originally Posted by MasterLJ
Sorry for my vague description of the problem...

Every statistic I create shows 0's. I've even tried debugging to see if something as simple as "count: player is in SB AND player flat calls" will output anything on the screen (of course the syntax is correct as it validates correctly), and I get 0's still. I even imported someone's random stat (I believe it's call turn cbet in 3bet pot) and I get the same. I would imagine if you mess with columns that it takes a while to populate and that it's obviously not retroactive, since that column didn't exist... but I've let it work for several hours and every stat I have shows 0's. I'm 90% my formatting of the output is correct.

Here are some of the stats/columns I created... please keep in mind that I play HU exclusively. Is it technically a limp in HU if they just complete the SB?

COLUMNS:

cnt_p_limp_call_opp
Description: Number of times player has opportunity to limp call

Expression:
sum(if[holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_face_raise, 1, 0])

cnt_p_limp_call
Description: Number of times player limps and calls a raise

Expression:

sum(if[holdem_hand_player_statistics.flg_p_open AND holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_f_saw, 1, 0])


Statistic:
LC%

Description: Percentage of the time a player elects to limp call

Value Expression:
(cnt_p_limp_call / cnt_p_limp_call_opp) * 100

Format:

Title: LC%

Format Expression: /%.2f




I've looked that code over a hojillion times and it seems to be fine unless I'm mistaken about some of the "axioms" like exactly what cold calling preflop means and what limping preflop means in a HU match. But I have to assume something is wrong with PT3 or my set up of PT3 if I can't even get an imported stat to display anything but 0's.
Export some of your custom stats and attach them to a support ticket on our site. I'll take a look at closer them.


Quote:
Originally Posted by MatthewRyan
can anyone here help me get my betpot and PT3 working correctly? Ill pay $50

(i have vista)
Right-click one of the handles of the PT icon on the table and drag it off the pot amount.


Quote:
Originally Posted by Rendle
After downloading the new version I'm having trouble importing. The imports are coming in every 2 seconds in red with the error message stating the connection is refused and I can't connect to the server. Please help.
PostgreSQL might not be running. Go Start -> Programs -> PostgreSQL -> Start service. If that doesn't work, try rebooting. If that doesn't work, contact us via our support system.

Quote:
Originally Posted by Stosh
When will it be possible for us to import HUD layouts from PAHUD? Also when will you be implementing templates similar to PAHUD's "Layout Manager" so we can work on HUD layouts without having active tables open?
I can't give an ETA, but this is planned.

Quote:
Originally Posted by dawade
Could be a dumb question but how do I combine my Stars and FTP aliases?

It seemed to work fine in beta but has messed up with the commercial version.
How has it messed up?

Quote:
Originally Posted by jontsef
I'm sure this has been discussed somewhere but I tried searching and couldn't find the answer.
You know how for cash games they have MT Ratio, Minutes, , $/hour, etc,
well, is that going to be available for tournaments as it was in PT2?
Yes, we will be adding many more stats, both for tournaments and for cash.

Quote:
Originally Posted by SoundMan
flg_p_open means open raise. Since you can't open raise AND limp your query will return 0.
Actually, flg_p_open just means they opened the action (raise or limp).

Quote:
Originally Posted by ncboiler
There is nothing to count. I tired grouping by hole cards and counting hole cards and filtering for rake >=0.40 and <3.00 or rake >=3.00 and only get an error. When I try to run the report using only "Hands" it lists the hole cards filtered by my above rake filter. It doesn't count anything however.
I misunderstood. I don't have a lot of time at the moment, but if you submit a support ticket, I will figure it out and build the report for you.

Quote:
Originally Posted by M_Mind_
Hi there, I'm experiencing a problem with PT3Hud. First time I ran it looked like it was working properly but now it's showing stats of players that are not even sat at my table. How can I solve that?
Set auto-import to move processed files.

Quote:
Originally Posted by chicken10der
just started messing around with PT3, tried to set an alias and got this message:

"Unable to execute query: UPDATE tourney_holdem_results SET id_player = 1054 WHERE id_player_real = 8176; Reason: Fatal Error ()"

the original name has one sng in the database, and the alias doesn't have any tourney info, if that helps. also, both names are on ftp - using a combination of the original from ftp and an alias from pokerstars does work, though.
Please enable logging, reproduce this problem, then attach the PokerTracker.log file to a support ticket on our site. Be sure to include a description of your problem.

Quote:
Originally Posted by Klaudioz
have an ridiculous problem with reports. I have a huge DB and a simple report take 30 minutes. When it is ready i wanna take a note over a x player, i did double click over player and report reload taking 30 minutes extra :S
My other problem is that HUD dont work Ipoker but in b10, and previous versions worked OK.
How large is your database, and what report/reports is taking 30 minutes?

Does the PT icon appear on your iPoker tables?

Quote:
Originally Posted by BetYourLife
Please update. PT3 is decreasing my edge Crashed every 5 minutes ... and so on. beta 11 was better than final release lol
I'm working hard to get the next release out. It's taking longer than I thought, but early results seem to indicate all lag problems will be completely gone!
05-21-2008 , 01:41 PM
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.
05-21-2008 , 01:42 PM
Quote:
Originally Posted by PokerAce
Actually, flg_p_open just means they opened the action (raise or limp).
Oh, really?
So, the documentation cannot be trusted then?
http://www.pokertracker.com/products...ase_Schema.pdf
05-21-2008 , 02:14 PM
sometimes the mucked cards will not disappear although they should after 5 secons. Pls fix that

sometimes, all the stats dont update although auto import is running. pls fix it
05-21-2008 , 02:31 PM
Quote:
Originally Posted by notreallymyname
This one's weird: I just had to add my pokerstars name to my aliases although it was already in there. It's now in there twice. I have no idea what triggered this.
...and again. Had to add my full tilt alias again, that's now in there twice too. No missing hands or phantom sessions today though. Yet.

The SQL error on the notes button on the replayer wasn't fixed in build 2 BTW.
05-21-2008 , 03:05 PM
FTP's deep HU tables are being imported as regular tables (i.e. suggesting they are FR).
05-21-2008 , 03:06 PM
I started a cluster about 20 hours ago.. and its still running. There are like 10 postgres processes running.. there are only 600kish hands in the db wtf is taking so long?
05-21-2008 , 03:09 PM
Quote:
Originally Posted by carnivalhobo
I started a cluster about 20 hours ago.. and its still running. There are like 10 postgres processes running.. there are only 600kish hands in the db wtf is taking so long?
There's definitely something wrong. I imported about 3M hands and it only took 2-3 hours to cluster.

You can probably get a faster response here: http://www.pokertracker.com/forums/viewforum.php?f=17
05-21-2008 , 04:19 PM
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

Last edited by dorado29; 05-21-2008 at 04:20 PM. Reason: .
05-21-2008 , 04:43 PM
every time i use my mouse wheel to tick up a bet on FTP and i accidnetally am over a player's HUD the stats pop up as if i clicked it and i can't get focus back to the table to tick up the bets
05-21-2008 , 04:45 PM
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
05-21-2008 , 05:15 PM
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
05-21-2008 , 05:24 PM
hud still doesnt work on ipoker, please fix it, it works on other sites like full tilt.
05-21-2008 , 08:42 PM
And again it's not recognising my alias (pokerstars again), but this time only on the tournament tab and it (understandably) reports an error if I try to add the same alias for the third time.

Also, it seems to think that 0:44-01:27 is 103 minutes, and all the other sngs in the set are an hour too long as well.
05-21-2008 , 09:13 PM
Quote:
Originally Posted by MasterLJ
You can filter by date. On the main page of the Texas Holdem tab, go to the Filters Button (upper right corner)... then in the upper left corner there's a pulldown menu under "Session Dates". Select the option you want (since a date, between date... etc etc) and the appropriate input boxes should appear.

As for being good with the postgres stuff lol, I can't get any of my own custom stats to work, not sure how good I am =).
LJ - have you still no luck?
05-21-2008 , 09:33 PM
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
What you probably actually want to do is run the database server on one computer, and connect via PT3 remotely. If you setup PostgreSQL in one place all of the database will be on that computer, if you connect remotely you'll still be playing on your machine. See: How To: Network PostgreSQL
05-21-2008 , 11:59 PM
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
05-22-2008 , 12:50 AM
Quote:
Originally Posted by Kraada
What you probably actually want to do is run the database server on one computer, and connect via PT3 remotely. If you setup PostgreSQL in one place all of the database will be on that computer, if you connect remotely you'll still be playing on your machine. See: How To: Network PostgreSQL
thanks kraada but im stuck on the last part
05-22-2008 , 02:16 AM
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

      
m