Couple of newbie questions

[mythrilfox]

Hi, I'm just recently switching back to PT4 and had a couple of questions I couldn't find the answers to.

-I have a recent hands HUD on the table to keep track of big pots. Live Win/Live Winner. Is there any way to make it so clicking on those recent pots opens up the HH viewer?
-On Ignition, is there any way to shorten the names of the auto-generated players in the HH viewer? It can be very hard to track the action with the names being so long.
-Is there a way to adjust the session timeout length?

Also been trying to create a stat from scratch for bet-check-bet, but I'm getting an invalid sql error. This is what I'm trying for cnt_r_bxb:

sum(if[lookup_actions_f.action='B' AND
lookup_actions_t.action='X' AND
lookup_actions_r.action LIKE 'B%', 1, 0])

What've I got wrong?

Thanks for the help!

[Flag_Hippo]

-I have a recent hands HUD on the table to keep track of big pots. Live Win/Live Winner. Is there any way to make it so clicking on those recent pots opens up the HH viewer?
-On Ignition, is there any way to shorten the names of the auto-generated players in the HH viewer? It can be very hard to track the action with the names being so long.
-Is there a way to adjust the session timeout length?

None of that is possible I'm afraid.

Also been trying to create a stat from scratch for bet-check-bet, but I'm getting an invalid sql error. This is what I'm trying for cnt_r_bxb:

sum(if[lookup_actions_f.action='B' AND
lookup_actions_t.action='X' AND
lookup_actions_r.action LIKE 'B%', 1, 0])

What've I got wrong?

Just the formatting. Needs to be either this:

sum(if[lookup_actions_f.action='B'
AND lookup_actions_t.action='X'
AND lookup_actions_r.action LIKE 'B%', 1, 0])

or this:

sum(if[lookup_actions_f.action='B' AND lookup_actions_t.action='X' AND lookup_actions_r.action LIKE 'B%', 1, 0])