If you are coaching or importing hands from a friend to review for any reason you should never import them to your own database. You should create a separate database for those hands.Originally Posted by grulko
This problem can be caused if you are sharing hands which is against the rules at almost all of the sites we support. We generally will not provide tech support for problems caused by sharing hands or importing purchased hands as we can't be seen to condone this behavior that the sites we support do not allow. I would suggest that you start a new database and only import your own original hand histories without any of the hands they shared with you. If your poker site finds out you are using hands in your database you did not play in you run the risk of having your poker account closed and funds confiscated.
Because you imported their hands, which have their hole cards for every single one of their hands in your database, HM2 thinks they are a hero and as such treats them as a hero when you encounter them at a table. This means it is going to show their session stats in the HUD instead of their lifetime HUD.
First you need to access your database in pgadmin and open a SQL window
start > programs > postgresql > pgadmin > connect to the sql server > then connect to the database
tools > query tools > clear the text in the SQL Editor window
1)
select * from players where optimizationstatus != 0
Click the 'Play' button to 'Execute Query'
This will show all the players marked as hero's. They should note the ID of the player that they want to un-make as a hero then
2)
update players set optimizationstatus = 0 where player_id = {player_id of player}
Click the 'Play' button to 'Execute Query'
so for example, "update players set optimizationstatus = 0 where player_id = 1232"
Once that is done launch HM2 and that player won't be a hero and other players moved against that player will not count towards vs hero stats. No need to reimport DB or anything after that. If you keep on sharing hands like this then you will need to update this again before playing.
Reply With Quote
