The TalkingPoker.com Forum  

Go Back   The TalkingPoker.com Forum > All Things Poker > General Poker Discussion
Register Blogs Arcade HH Converter Calendar

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 07-26-07, 08:00 PM
melioris melioris is offline
squeezed the charmin
 
Join Date: Nov 2005
Location: Milwaukee
Posts: 3,015
melioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Points
Default

Is this the type of thing that is easy to do in Holdem Manager?
  #2  
Old 07-26-07, 09:51 PM
lightfungus's Avatar
lightfungus lightfungus is offline
Back in business!
 

Join Date: Nov 2004
Posts: 2,259
lightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Points
Default

And shouldn't the donk bet situation be specified as the lead out bet OOP is less than a percentage of the pot? Like say 50%...or 40%? If someone leads out for >50% isn't this a completely different story than someone who leads out with less than 50%? Or did we take that into account already?
__________________
I need 'em for my footsies.
  #3  
Old 07-26-07, 09:55 PM
Talking Poker's Avatar
Talking Poker Talking Poker is offline
Adminimus Maximus
 
Join Date: Oct 2004
Location: Florida Coast
Posts: 27,480
Talking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep Points
Default

If a guy leads into the PFRer (obviously OOP), that's a donk bet. Whether he leads out for a min bet or the entire pot will obviously effect if the PFRer chooses to raise or not, but once he does, it's being lumped in to these results.

Narrowing down the results based on the size of the donk bet as a percentage of the pot would definitely be interesting, but again, I don't know how to do that.
__________________

Got RakeBack?
27% at Full Tilt | 33% at Cake Poker | 30% at Carbon Poker
  #4  
Old 07-26-07, 10:44 PM
de-coder's Avatar
de-coder de-coder is offline
Talking Poker League Champion
 
Join Date: May 2006
Location: Toronto, On
Posts: 1,248
de-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Points
Default

I've figured out the alias issue and it's pretty simple actually.

change x.player_id to x.real_player_id and you're good to go.
  #5  
Old 07-26-07, 11:24 PM
Wes Wes is offline
Forum Addict
 

Join Date: Apr 2007
Posts: 1,879
Blog Entries: 23
Wes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep Points
Default

Really easy, although you wouldn't have the l33tness because you don't know have to know how to do sql queries.
  #6  
Old 07-27-07, 12:00 AM
de-coder's Avatar
de-coder de-coder is offline
Talking Poker League Champion
 
Join Date: May 2006
Location: Toronto, On
Posts: 1,248
de-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Points
Default

to find the level you want try this

select * from game_level

that will give you all the levels you have in the DB and their game_level_id

then use

select x.game_id from game_players x join game_players y on x.game_id = y.game_id and y.fbet = 1 and y.praise != 1 and y.ffold = 1 join game z on x.game_id = z.game_id and z.game_level_id = game_level_id here where x.raised_first_pf = 1 and x.fraise = 1 and x.fcheck != 1 and x.real_player_id = player_id here

to those who actually appreciate my work - you're very welcome. This is such a fascinating topic. There's a lot of good stuff in there.

Here's a question:

how often is a limp - re-raise AA?

To be fair I'm not talking about pure limps, but people that call the current bet, get raised at some point behind them, and then re-reraise pre-flop.

Any guesses?
  #7  
Old 07-27-07, 01:19 AM
Talking Poker's Avatar
Talking Poker Talking Poker is offline
Adminimus Maximus
 
Join Date: Oct 2004
Location: Florida Coast
Posts: 27,480
Talking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep Points
Default

Stats are fun.

This is a tricky one though, especially with the broad definition (maybe this should be a new thread - but I guess there's not too much to discuss with this one). I think the number is pretty high... how about 42%?
__________________

Got RakeBack?
27% at Full Tilt | 33% at Cake Poker | 30% at Carbon Poker
  #8  
Old 07-27-07, 06:57 AM
lightfungus's Avatar
lightfungus lightfungus is offline
Back in business!
 

Join Date: Nov 2004
Posts: 2,259
lightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Points
Default

I'm doing a decent amount of SQL at work right now and would love to help out with this but I don't have the time right now. So I appreciate it de-coder. And work also blocks this site
__________________
I need 'em for my footsies.
  #9  
Old 07-27-07, 01:31 PM
de-coder's Avatar
de-coder de-coder is offline
Talking Poker League Champion
 
Join Date: May 2006
Location: Toronto, On
Posts: 1,248
de-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Points
Default

Keep in mind I'm not actually a sql guy - I'm just kindof flying by the seat of my pants and reading a lot of sql docs (I also asked a guy at work to point me in the right direction). If you have any suggestions as to how to do things better, or if you see any problems with it let me know.

There's more stuff in there too if we have any ideas for things we'd like to see (see above for 1 fun stat...).
  #10  
Old 07-27-07, 03:17 PM
Wes Wes is offline
Forum Addict
 

Join Date: Apr 2007
Posts: 1,879
Blog Entries: 23
Wes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep Points
Default



Use it.
  #11  
Old 08-02-07, 12:44 PM
de-coder's Avatar
de-coder de-coder is offline
Talking Poker League Champion
 
Join Date: May 2006
Location: Toronto, On
Posts: 1,248
de-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Points
Default

No other guesses on this?

TP guessed 42% - anyone else?
  #12  
Old 08-02-07, 03:19 PM
Reel Deal's Avatar
Reel Deal Reel Deal is offline
I'm on a boat
 

Join Date: May 2005
Location: NE Fla
Posts: 6,651
Blog Entries: 3
Reel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep Points
Default

62%
__________________
GO GREEN!!! GO WHITE!!!
  #13  
Old 08-02-07, 03:45 PM
meanness meanness is offline
Shark
 

Join Date: Apr 2006
Posts: 937
meanness has between 750 and 999 Rep Pointsmeanness has between 750 and 999 Rep Pointsmeanness has between 750 and 999 Rep Pointsmeanness has between 750 and 999 Rep Pointsmeanness has between 750 and 999 Rep Pointsmeanness has between 750 and 999 Rep Pointsmeanness has between 750 and 999 Rep Points
Default

Good thread, thanks for the work.

I don't have any data, but I'm sure my 5% guess was strongly influenced by the way I was running at the time, and not truly representative of the general trend. Thanks to this thread, I've been experimenting a lot more with raising the donk bettor.

On a drawy board, I'm starting to find more success - not with the initial fold, at $100NL anyway - but if the turn blanks and I fire again, I'm winning the pot consistently.
  #14  
Old 08-02-07, 04:14 PM
Talking Poker's Avatar
Talking Poker Talking Poker is offline
Adminimus Maximus
 
Join Date: Oct 2004
Location: Florida Coast
Posts: 27,480
Talking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep Points
Default

Exactly.

Nice to know that not everyone finds this thread useless.
__________________

Got RakeBack?
27% at Full Tilt | 33% at Cake Poker | 30% at Carbon Poker
Closed Thread


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:13 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
©2004-2008 TalkingPoker.com