specific HH out of PT3

General discussion of PokerTracker 3.

Moderator: Moderators

specific HH out of PT3

Postby matze_widi » Thu Dec 16, 2010 9:16 am

hey guys,is there a easy way to get like all hh for specific hand out of PT3.
like say i wanna get all hh for my AA w/o going though all AA in particular.
can someone plz help me out with this..


Cheers matze_widi
matze_widi
 
Posts: 50
Joined: Sun Aug 30, 2009 2:42 pm

Re: specific HH out of PT3

Postby kraada » Thu Dec 16, 2010 10:02 am

Follow the directions in this post, except instead of the query there use:

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 Username Here' and holdem_hand_player_detail.holecard_1 % 13 = 0 and holdem_hand_player_detail.holecard_2 % 13 = 0;

(The data on holecards is explained in this post)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: specific HH out of PT3

Postby matze_widi » Thu Dec 16, 2010 11:28 am

kraada wrote:Follow the directions in this post, except instead of the query there use:

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 Username Here' and holdem_hand_player_detail.holecard_1 % 13 = 0 and holdem_hand_player_detail.holecard_2 % 13 = 0;

(The data on holecards is explained in this post)



so when im connected to my DB i just have to c/p this in and fill in my user name here

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 Username Here' and holdem_hand_player_detail.holecard_1 % 13 = 0 and holdem_hand_player_detail.holecard_2 % 13 = 0;

doesnt seem to work tho somehow..
nad am i right thta i should find the files in the "bin" folder??
sry but i need some help here
matze_widi
 
Posts: 50
Joined: Sun Aug 30, 2009 2:42 pm

Re: specific HH out of PT3

Postby kraada » Thu Dec 16, 2010 11:31 am

Make sure not to miss this step:

Type \o exportedhands.txt and hit enter.

The file you'll be looking for will be called "exportedhands.txt"
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: specific HH out of PT3

Postby matze_widi » Thu Dec 16, 2010 11:40 am

it then says EROOR: column"matze_widi" does not exist
LIne1: ...layer=player.id_ülayer and player.player_name= matze_widi...

am i right with typing that in??

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 = matze_widi and holdem_hand_player_detail.holecard_1 % 13 = 0 and holdem_hand_player_detail.holecard_2 % 13 = 0;
matze_widi
 
Posts: 50
Joined: Sun Aug 30, 2009 2:42 pm

Re: specific HH out of PT3

Postby kraada » Thu Dec 16, 2010 12:18 pm

You need the single quotes around your name.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: specific HH out of PT3

Postby matze_widi » Thu Dec 16, 2010 12:28 pm

idk why this isnt working...
i dont find any given file
after i type in this there is just nothing going on...
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 = 'matze_widi' and holdem_hand_player_detail.holecard_1 % 13 = 0 and holdem_hand_player_detail.holecard_2 % 13 = 0;
matze_widi
 
Posts: 50
Joined: Sun Aug 30, 2009 2:42 pm

Re: specific HH out of PT3

Postby kraada » Thu Dec 16, 2010 12:57 pm

This is going to take some time it needs to read every row of your database to find the hands to pull out. It would not surprise me if it took 5-10 minutes to complete or more depending on the speed of your computer.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to General [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests