Help - Using PT4 to analyse population tendencies - Page 3 - Heads Up SNG and Spin and Gos -- Two Plus Two Poker Forums

there is an option to in player>view all rows that gives us the option to copy or delete the row.

If we want a reg DB, cant we just mark the players we want and paste them into a new db, and if we want just the fish, cant we just order it by hands we played and then delete all the players we´ve played more then lets say 150 hands?

Quote

01-11-2013 , 06:51 AM

#52

Benjamin the Donk

old hand

Join Date: Mar 2012 Posts: 1,254

probably but I haven't messed around with deleting players from my db - I'm sure it can be done though.

Quote

01-11-2013 , 07:30 AM

#53

Wisher

grinder

Join Date: Jan 2012 Posts: 602

To not screw up the system I guess that deleting the player would mean also deleting all his hands and games played with him.
So just deleting a row from the players table in the DB would not work.

Quote

01-11-2013 , 02:34 PM

#54

Emus

adept

Join Date: Oct 2008 Posts: 839

An idea that came up yesterday was this.
The moment you have an all player report you can export it to excel.
It is not that hard imo to copy a certain amount of cells once the report is open in excel.
When pasted in a txt file it should be possible to create a .bat file with some loop to automatically delete all files with opponent x in it from a folder.

This way you have to spend maybe 10min max to have created a dbase w/o certain opponents with the export/create new dbase as I suggested above. Your PC will be running in background but that is not really a problem to do while grinding.

Problem is that I have currently no idea how to create such a .bat file ...

Instead of an .bat file; there are probably people who can do this equivalently with an AHK script maybe.

Quote

01-11-2013 , 05:48 PM

#55

mrbambocha

adept

Join Date: Sep 2009 Posts: 1,106

Quote:

Originally Posted by Wisher

To not screw up the system I guess that deleting the player would mean also deleting all his hands and games played with him.
So just deleting a row from the players table in the DB would not work.

Thats what i wanna do, i want to just have a DB with a few players, so why cant i delete the others that i dont want?

Quote

01-11-2013 , 09:28 PM

#56

Benjamin the Donk

old hand

Join Date: Mar 2012 Posts: 1,254

Maybe try posting your questions in the PT4 forums? The mods there are usually pretty helpful but it's also a little bit beyond what I'd call 'support'.

Quote

01-12-2013 , 04:22 PM

#57

Wisher

grinder

Join Date: Jan 2012 Posts: 602

Quote:

Originally Posted by mrbambocha

Thats what i wanna do, i want to just have a DB with a few players, so why cant i delete the others that i dont want?

Not saying you couldn't do it. Just that if you only delete the row from the players table will probably not do the trick as thr hands and stats associated with that player will remain in the other tables of the database creating a situation which is not common for the software (as you are not supposed to be manually interveining with the DB) and results cannot be predicted.

What I would do in this situation is turn on SQL logging on the DB, delete a player from the software and then check what was the SQL used to so this. Afterwards - use this SQL (or optimize it to fit multiple players) to delete all the ones whic I don't want in the database.

Quote

02-19-2013 , 06:28 AM

#58

olistr

journeyman

Join Date: Mar 2010 Posts: 227

oki, finaly I get no errors and have succesfully all rows affected in postgre
but when I open PT4 and make active right db I can choose only me in edit player list , and there is nobody else to pick so I still see only games I played
any help?

Quote

02-20-2013 , 05:08 AM

#59

Emus

adept

Join Date: Oct 2008 Posts: 839

Quote:

Originally Posted by olistr

Make master dbase active.
Look through hand histories.
Record 1 random opponent name.
Make pop dbase active.
Type in random name.
Read off in pop-up which name comes up.
Type in name of pop-up.

Other possibility; record name with highest ID while creating pop dbase.
Should be the same name as in pop-up.

Quote

02-20-2013 , 05:44 AM

#60

Nidel

centurion

Join Date: Jan 2013 Posts: 108

I'll try that after work, TY guys.

Quote

02-22-2013 , 04:06 PM

#61

Nidel

centurion

Join Date: Jan 2013 Posts: 108

I´ve executed the query and I have my alias for all the population

But i don´t feel to much confident with the results, i dont know about de stastitc but the graph is bad for sure... Is this happening to you guys?

Quote

02-22-2013 , 04:17 PM

#62

shortchange

journeyman

Join Date: May 2012 Posts: 379

my graph slopes the other way

Quote

02-22-2013 , 05:51 PM

#63

JArul3

journeyman

Join Date: May 2010 Posts: 229

@nidel

dont u know, that it is not from your perspective?

I mean, this graph shows, how they run vs you and not how u run vs them.

Quote

02-22-2013 , 09:00 PM

#64

Nidel

centurion

Join Date: Jan 2013 Posts: 108

Yes I Know that but my EvRoi is 3%. I wish be winning 7%EvRoi :P

Quote

02-22-2013 , 09:47 PM

#65

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

rake

Quote

02-22-2013 , 10:24 PM

#66

Nidel

centurion

Join Date: Jan 2013 Posts: 108

Even counting the rake, rake is about 2%.... should be something wrong with the tournament sumaries, but the thing is: Can I dismis the graph and trust the statstics?

Quote

02-23-2013 , 01:47 AM

#67

Benjamin the Donk

old hand

Join Date: Mar 2012 Posts: 1,254

Yeah my villain graph shows ~-$1100 in winnings when I'm + only a few hundred. Sharkscope has me only having paid about $600 in rake so that's still a bit of a difference.
I think you can trust that stats though, maybe this is worth a post on the PT4 forums?

Quote

02-23-2013 , 07:20 AM

#68

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

Quote:

Originally Posted by Nidel

Yes I Know that but my EvRoi is 3%. I wish be winning 7%EvRoi :P

Quote:

Originally Posted by Nidel

Even counting the rake, rake is about 2%.... should be something wrong with the tournament sumaries, but the thing is: Can I dismis the graph and trust the statstics?

Rake is about 2% each. Your ROI 3%, your rake 2% + villain rake 2% = 7%. As shown in the graph from population villains perspective.

Last edited by _dave_; 02-23-2013 at 07:25 AM.

Quote

02-23-2013 , 08:04 AM

#69

Benjamin the Donk

old hand

Join Date: Mar 2012 Posts: 1,254

Nice 1 dave, thanks

Quote

02-23-2013 , 09:04 AM

#70

Nidel

centurion

Join Date: Jan 2013 Posts: 108

Thank you very much Dave, now makes sense for me :P

Quote

03-12-2013 , 03:02 AM

#71

CJSaunders

adept

Join Date: Apr 2008 Posts: 948

I tried all of this then also kept having this error when running the SQL query:

Code:

ERROR: duplicate key value violates unique constraint "tourney_hand_player_statistics_primary_key"

Which did not make sense because I definitely did NOT have any observed hands, no other hands than heads up hands, or more than one hero name. Then I found out why.

The id_player corresponding to your screenname is not necessary 1.

In my case it was 2, I am guessing that when PT4 imports the very first HH in your new database, your opponent might get id_player number 1, therefore you get number 2. Talk about a coinflip

So while you're looking at the "players" table to find out who has the last id_player, find out if you have number 1 or 2 (or else maybe). Then in the SQL query, replace all statements with "!=1" by "!=your_own_id_player". For example, if it happens to be 2:

Code:

UPDATE tourney_hand_summary SET id_winner = 1446 WHERE id_winner != 2 AND id_winner != 0 AND id_winner != -1;
UPDATE tourney_hand_player_statistics SET id_player = 1446 WHERE id_player != 2 AND id_player != 0 AND id_player != -1;
UPDATE tourney_hand_player_combinations SET id_player = 1446 WHERE id_player != 2 AND id_player != 0 AND id_player != -1;
UPDATE tourney_summary SET id_winner = 1446 WHERE id_winner != 2 AND id_winner != 0 AND id_winner != -1;
UPDATE tourney_results SET id_player = 1446 WHERE id_player_real != 2 AND id_player_real != 0 AND id_player_real != -1;
UPDATE player SET id_player_alias = 1446 WHERE id_player != 2 AND id_player != 0 AND id_player != -1;

Where 1446 is still to be replaced with the last id_player in the "players" table.

Secondly, I also recommend backing up the "new" database before running the SQL query. You don't want to spend what could be another couple of hours doing the import all over again because something with the query goes wrong, see the next point.

Finally, before you run the SQL query in your new database, launch PT4 and go to view stats -> results, and from the drop down "player" menu, select the name of the player who was last in your "player" SQL table. Then only after that go run the SQL query. If I don't do this before running the query, I cannot select any other player than myself afterwards in PT4, which sort of defeats the whole point. Might have to do with the merging of all player ids, and PT4 getting confused.

Hopefully this helps, and of course, big thanks to Ben, Dave and anyone involved, there is probably a goldmine of info to analyze now

Last edited by CJSaunders; 03-12-2013 at 03:09 AM.

Quote

03-29-2013 , 12:16 AM

#72

hakunamatata998

grinder

Join Date: Nov 2011 Posts: 526

Thank you very much for helping out guys!

I think I've followed the steps correctly and used the fix given by CJSaunders but now i'm getting another error:

ERROR: relation "player" already exists
SQL state: 42P07

any idea why?

Quote

03-29-2013 , 04:04 AM

#73

Wisher

grinder

Join Date: Jan 2012 Posts: 602

Quote:

Originally Posted by Torg0th

If you could give us the SQL you are executing when you receive this, we might be able to help more.

Also, just re-do it from scratch and see what happens. Sometimes it can get pretty messy if you have done something, tried to fix it, done it again, etc.

Quote

03-29-2013 , 04:54 PM

#74

hakunamatata998

grinder

Join Date: Nov 2011 Posts: 526

Haha it was a simple fix: my sql query editor came up with code already there for some reason and I just assumed it was needed for it to work properly. Tried after removing it and worked perfectly so if that can help anyone who is as oblivious as me :P

Thx anyway!

Quote

05-03-2013 , 06:35 PM

#75

Nidel

centurion

Join Date: Jan 2013 Posts: 108

Hi guys!

Anyone knows how to show a HUD for an Alias?

I´m doing reports to study population tendencies but is not too clear, so I would like to see the coffeHud with the population tendencies values

Quote

Page 3 of 5

First

1 2 3 4 5

Last

Post Reply Subscribe

...

Page 3 of 5

First

1 2 3 4 5

Last