it's most all in holdem_hand_player_statistics, occasionally holdem_hand_player_detail has interesting stuff too. join to table player on id_player to get their names.
you kinda do need to work them out, but it's easy. sometimes lot of the time they're bools, so you need to case and sum them. then divide by opportunities. for example:
Code:
SELECT
SUM (CASE WHEN (hhps.flg_vpip) THEN 1.0 ELSE 0.0 END) / COUNT(hhps.id_player) AS vpip
FROM
holdem_hand_player_statistics hhps, player
WHERE
player.id_player = hhps.id_player AND player.player_name = 'screenname_here';
would get you the VPIP for screenname_here
note 1.0 and 0.0 in the case, important to cast as a float since it'll give a result like 0.223422, and round to zero if using ints.
Two Plus Two
Linear Mode
