Quote:
Originally Posted by Wisher
Yes. In HEM, unlike in PT4, there is a column in the players table which notes the number of tourney and number of cash game hands the opponent has played.
So you can just extend the WHERE clause of the query to have "AND tourney_hands > 30".
Note: Above is sample extension, not sure if I recall the column name exactly.
tl;dl; Yes. It is possible.
Where exactly do we enter this extra data?
I'm using HM2 so this is what it would look normally...
INSERT INTO aliases
SELECT 12345, p1.player_id
FROM players p1
WHERE p1.player_id NOT IN
(
SELECT a1.player_id
FROM aliases a1
WHERE a1.aliasplayer_id = 12345
-- to exclude players yet inserted
)
AND p1.player_id NOT IN
(
SELECT a2.player_id
FROM players p2 JOIN aliases a2 ON p2.player_id = a2.aliasplayer_id
WHERE p2.pokersite_id = -1 and p2.playername = 'Hero'
-- to exclude hero nicknames from the insert
)
AND p1.pokersite_id <> -1
-- to exclude other aliases
;
Which part would we add the hands requirement? I have 216k player DB and need to cut this down significantly so that my HM2 doesnt crash.
Thanks!