Vs hero stats on pokerstars
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Jan 2012
    Posts
    49

    Default Vs hero stats on pokerstars

    Hi,

    Some time ago vs hero stats stopped working on stars for me and are not updating for any opponent. They work fine on other rooms. Just wondering – have they been permanently banned by stars in any of the rule changes or is this something I can fix? They still show up for opponents that I used to play against before the stats stopped working but they're just not updating.

    Thanks!

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    They were not banned as part of the new Third Party Tool Rules changes that I recall.

    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. 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. 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 - Hold'Em Manager 2 FAQs - Poker Software :: How to create a new database and import previously played hands

    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.

    For the opponents it should show their lifetime history as long as HM2 doesn't think they are a hero. For you, and anyone else that HM2 thinks is a hero because you imported all of their original hand histories instead of just the hands you previously played against them, it will only show their session stats or no stats at all.

    You can try to fix this manually as explained below but this is for advanced users only, incorrect edits can corrupt your database permanently!

    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)

    Code:
    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)

    Code:
    update players set optimizationstatus = 0 where player_id = {player_id of player}
    Click the 'Play' button to 'Execute Query'

    so for example,

    Code:
    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.

Similar Threads

  1. Hero HUD showing lifetime stats + no vs hero stats
    By conoval in forum General Support
    Replies: 1
    Last Post: 06-11-2015, 02:28 PM
  2. Hero stats appearing (dissable hero in hud activated)
    By sebalpda in forum Manager General
    Replies: 7
    Last Post: 08-09-2012, 11:13 PM
  3. no Hero Stats Pokerstars
    By Pirni in forum General Support
    Replies: 1
    Last Post: 01-12-2012, 11:59 PM
  4. Can't see Hero stats on PokerStars
    By pulainmata in forum Manager General
    Replies: 4
    Last Post: 04-06-2010, 04:14 PM
  5. Replies: 3
    Last Post: 08-14-2009, 10:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •