amt_f_bet_made vs amt_bet_f

[preparac]

we have
amt_bet_f (numeric) = Total amount bet on the flop.

and we have
amt_f_bet_made (numeric) = Amount of bet on the flop.

whats exactly the difference of the two.

If I want to make sure that a player didn't bet, raise, 3bet or 4 bet on F, T and R, how I do this best?

NOT (amt_f_raise_made > 0 OR amt_f_raise_made > 0 OR amt_t_raise_made > 0 OR amt_t_raise_made > 0 OR amt_r_raise_made > 0 OR amt_r_raise_made > 0)

or

NOT (cnt_f_bet > 1 OR flg_f_raise OR flg_f_3bet OR flg f_4bet OR cnt_t_bet > 1 OR flg_t_raise OR flg_t_3bet OR flg t_4bet OR cnt_fr_bet > 1 OR flg_r_raise OR flg_r_3bet OR flg r_4bet)

or is there a cool substring way to do it, something like f_LIKE (X|XF) ... but then how I can combine substirings over several streets ?

Thanx

[preparac]

or is

NOT (amt_f_raise_made > 0 OR amt_f_raise_made > 0 OR amt_f_raise_made_2 > 0 OR amt_t_raise_made > 0 OR amt_t_raise_made > 0 OR amt_t_raise_made_2 > 0 OR amt_r_raise_made > 0 OR amt_r_raise_made > 0 OR OR amt_r_raise_made_2 > 0 )

the way to go?? What exactly counts "amt_f_raise_made_2 > 0" ? All 3/4bets or only 3/4bets after a player already bet/raised ?

[WhiteRider]

amt_bet_f is the total amount bet on the flop - it is not the amount of just the "bet".
amt_f_bet_made is the amount of the actual "bet" and does not include raises.

I assume you want to check for a player not betting or raising, but ignoring calls?
I would suggest that the best way would be like this - NOT( flg_f_bet OR cnt_f_raise > 0 OR same-for-turn OR river ).

[preparac]

Yep, I If I want to make sure that a player didn't bet, raise, 3bet or 4 bet on F, T and R (no aggressive action)

so ... cnt_f_raise > 0 excludes also 3bets/4bets?

(and what exactly returns amt_f_raise_made_2 > 0 ??)

[WhiteRider]

Yep, I If I want to make sure that a player didn't bet, raise, 3bet or 4 bet on F, T and R (no aggressive action)

so ... cnt_f_raise > 0 excludes also 3bets/4bets?

cnt_f_raise counts how many raises the player made on the flop - it includes all raises (but not a "bet").

(and what exactly returns amt_f_raise_made_2 > 0 ??)

ant_f_raise_made is the first raise made by the player, amt_f_raise_made_2 is the last raise made by the player (on the flop).

[preparac]

ok thanx

by the way

"tourney_holdem_hand_player_detail.amt_f_bet_made > 0" gives the same results "as flg_f_bet"

[WhiteRider]

Yes, that's correct.