literate-perfunctory
Poker Software
Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Member
    Join Date
    Feb 2009
    Posts
    33

    Default HM2 database tables (pokersite_id / name)

    Where does HM2 store the name of the pokersite which is used in the database? A number of tables have pokersite_id but there's no 'pokersites' or similiar table that connects the int value to a pokersite? Also, some tables have just a site_id - is this different from pokersite_id?

    And generally - are there (will there be) any general resources on the database structure to help make custom queries, 3d party programs and such? Most of it can be figured out by poking about in pgadmin, but that also leaves some guesswork.

    Thanks

  2. #2
    NoteCaddy sreticentv's Avatar
    Join Date
    Dec 2009
    Location
    No direction but to trust the final destination
    Posts
    6,455

    Default

    there is no table to resolve the poker sites but it's the same as hm1

  3. #3
    Member
    Join Date
    Feb 2009
    Posts
    33

    Default

    Thanks - so this means the values are hardcoded into HM2? And for instance pokersite_id=0 will always be Party for all HM2 users regardless of whether they've ever played there?

    So all third party programs that use pokersites, will have to figure out the number/name combo and change their programs too, whenever support for a new site is added to HM2?

  4. #4
    NoteCaddy sreticentv's Avatar
    Join Date
    Dec 2009
    Location
    No direction but to trust the final destination
    Posts
    6,455

    Default

    it's no different than it is now really other than the lack of a lookup table in the database. Values were already hard coded in hm1. Also, yes 0 will always be whatever 0 is - I guarantee it

    If you're making a third party program then you'll just import a hand into hm2 then look at the hand table and figure it out from there

  5. #5
    Member
    Join Date
    Feb 2009
    Posts
    33

    Default

    Well, yes, I realize the value is consistent throughout the db, but one of the things a user has to do in my program is to pick their sn/alias.

    If someone has the same username on 10 different sites, or a username on one site that someone else uses on another site they play on, it's a bit difficult for them to know if they should pick the username with a 4 behind it or the username with a 7, 2 or 8 behind it
    Last edited by MinusEV; 10-14-2011 at 09:57 AM.

  6. #6
    Member
    Join Date
    Feb 2009
    Posts
    33

    Default

    And also: How is it possible to match the player_id to the hands they've played?

    Say I want to list all hands that a player_id has played - for HM this could be done through the playerhandscashkeycolumns table which held both pokerhand_id and player_id but I can not figure out how to do this in the HM2 db?

  7. #7
    Holdem Manager
    Join Date
    Sep 2010
    Posts
    105

    Default

    Some things are going to be a little bit tricky for 3rd party developers until we release the API since a lot of information is stored outside of Postgresql. Once that is released you'll be amazed at the level of detail and analytical possibilities of HM2. It's fairly high on my priority list and something we're anxious to get out.

    PokerSite_id is an enumerated value:

    public enum PokerSiteType
    {
    [DisplayString("Party")]
    PartyPoker = 0,
    [DisplayString("Full Tilt")]
    FullTiltPoker = 1,
    [DisplayString("PokerStars")]
    [AlternateDisplayString("Poker Stars")]
    PokerStars = 2,
    [DisplayString("Prima")]
    Prima = 3,
    [DisplayString("IPoker")]
    IPoker = 4,
    [DisplayString("Absolute")]
    Absolute = 5,
    [DisplayString("Cryptologic")]
    Cryptologic = 6,
    [DisplayString("Bodog")]
    Bodog = 7,
    [DisplayString("Ultimate Bet")]
    UltimateBet = 8,
    [DisplayString("Ongame")]
    Ongame = 9,
    [DisplayString("Everest")]
    Everest = 10,
    [DisplayString("Pacific")]
    Pacific = 12,
    [DisplayString("Betfair")]
    Betfair = 14,
    [DisplayString("Dracula")]
    Dracula = 15,
    [DisplayString("Entraction")]
    Entraction = 16,
    [DisplayString("Cake")]
    CakePoker = 17,
    [DisplayString("Boss Network")]
    BossNetwork = 18,
    [DisplayString("Merge")]
    Merge = 19,
    [DisplayString("PokerRoom")]
    PokerRoom = 20,
    [DisplayString("EverLeaf")]
    EverLeaf = 21,
    [DisplayString("PlayerAlias")]
    PlayerAlias = -1,
    [DisplayString("Winamax")]
    Winamax = 22,
    [DisplayString("Replayer")]
    Replayer = 23,
    [DisplayString("MAX_SITES")]
    MAX_SITES = 24,
    [DisplayString("None")]
    NONE = -99,
    [DisplayString("All")]
    ALL = -100
    };

    Roy

  8. #8
    Member
    Join Date
    Feb 2009
    Posts
    33

    Default

    Thanks, that's great to hear - I'll wait for the API then. I was getting a bit worried as I could not make much sense of what I could piece together from pgadmin

  9. #9
    Holdem Manager
    Join Date
    Sep 2010
    Posts
    105

    Default

    Quote Originally Posted by MinusEV View Post
    Thanks, that's great to hear - I'll wait for the API then. I was getting a bit worried as I could not make much sense of what I could piece together from pgadmin
    Yeah, it is something that I'll be working on sooner rather than later - we're currently focused on getting HM2 release ready but once that happens I'll be jumping on the API piece and I can guarantee that you'll be impressed with what you have access to.

    Roy

  10. #10
    Junior Member
    Join Date
    Oct 2011
    Posts
    10

    Default

    Quote Originally Posted by roy.goncalves View Post
    Yeah, it is something that I'll be working on sooner rather than later - we're currently focused on getting HM2 release ready but once that happens I'll be jumping on the API piece and I can guarantee that you'll be impressed with what you have access to.

    Roy
    Hi! Are you going to release the API?

Similar Threads

  1. Importing hands from old database to new database?
    By Gaylord in forum Manager General
    Replies: 3
    Last Post: 12-14-2010, 11:05 AM
  2. Restoring to new database kills off old database
    By JtX in forum Manager General
    Replies: 12
    Last Post: 10-05-2010, 08:27 PM
  3. Filter for pure HU-tables (no 6max-tables w/ just 2 players)?
    By Tackleberry in forum Manager General
    Replies: 2
    Last Post: 07-31-2010, 04:43 AM
  4. Restoring a Database Using backup and restore Made a different database disappear!
    By onlymymissiscallsmedonkey in forum Manager General
    Replies: 3
    Last Post: 07-12-2010, 08:56 PM
  5. Replies: 5
    Last Post: 06-24-2010, 09:36 AM

Posting Permissions

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