Merge Support - moving "party" hands to merge
Page 1 of 3 123 LastLast
Results 1 to 10 of 21
  1. #1
    Junior Member
    Join Date
    Aug 2009
    Posts
    5

    Default Merge Support - moving "party" hands to merge

    Good afternoon,

    Thank you very much for adding support for the Merge Network.
    I had previously purchased the Merge Converter that converts hands to Party Poker format. I downloaded the latest HEM beta (1.10 Beta 6) and the imports seem to work well now, so I don't need the Merge Converter I purchased.

    My problem is that I have a couple months of history in Party Poker format and I don't have the originals from the merge site (Carbon). I tried emailing their support and they will not send my old histories (the software only allows for saving of up to 30 days).

    Is there any way I can convert my Party history to the Merge network?

    Thank you!
    cmc

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

    Default

    I have forwarded this thread to the developer.

  3. #3
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    Does this help?

    "Hi, you first need to open pgadmin from Start Menu - Postgresql and then double click on the server name in the list and it will ask you for your password. Most likely it is postgrespass unless you used a different one.

    Open the Query window by clicking on the icon that looks like a pencil and a piece of paper. In the window that opens replace anything in there with:

    update players set site_id = 18 where site_id = 0;
    update pokerhands set site_id = 18 where site_id = 0;
    update pokerhands_hero set site_id = 18 where site_id = 0;
    update tourneydata set site_id = 18 where site_id = 0;
    update tourneyplayerdata set site_id = 18 where site_id = 0;


    Then press F5 to run it. Launch HM and all your Boss players and hands that were converted to Party should be back to Boss. The problem with doing this if you already imported real Boss hands is you'll have duplicate players in the players table which will probably cause other problems.

    Roy"

  4. #4
    Junior Member
    Join Date
    Aug 2009
    Posts
    5

    Default

    Yes, thank you!
    Note that for Merge, the site_id = 19.

    To avoid having duplicate players, I did the following and it seemed to work well:

    1. Purge all Merge hands from the database
    2. Export Hands
    3. Create new Database
    4. Import hands
    5. Run the SQL command provided (using the correct site_id).

    Thanks again.

  5. #5
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    Thanks for the feedback

  6. #6
    Junior Member
    Join Date
    Nov 2009
    Posts
    17

    Default

    Hi there i followed your link here from the PKR thread. im trying to get the hands i converted from pkr into pokerstars format back to pkr format, ive read all the above and have followed the instructions upto where i have to enter ....

    update players set site_id = 18 where site_id = 0;
    update pokerhands set site_id = 18 where site_id = 0;
    update pokerhands_hero set site_id = 18 where site_id = 0;
    update tourneydata set site_id = 18 where site_id = 0;
    update tourneyplayerdata set site_id = 18 where site_id = 0;

    what codes should i use to do this correctly

    Thanks in advance antz

  7. #7
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    You find the values in the table "pokersites".

    Stars is 2
    Merge is 19

    0;"Party";"PP"
    1;"Full Tilt";"FT"
    2;"Stars";"PS"
    3;"Prima";"PRM"
    4;"IPoker";"IPK"
    5;"Absolute";"ABS"
    6;"Crypto";"CRY"
    7;"Bodog";"BDG"
    8;"Ultimate Bet";"UB"
    9;"On Game";"ONG"
    10;"Everest";"EVT"
    12;"Pacific";"PAC"
    14;"Betfair";"BTF"
    15;"Dracula";"DRC"
    16;"Entraction";"ENT"
    17;"Cake Poker";"CAK"
    18;"Boss";"BOS"
    19;"Merge";"MER"
    20;"PKR";"PKR"

  8. #8
    Junior Member
    Join Date
    Nov 2009
    Posts
    17

    Default

    ok thanks for the above
    one quick question, will this action affect my pokerstars hh's for games ive playd on pokerstars under a different alias than on pkr. im guessing it should not !

    Thanks for yurr time antz

  9. #9
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    Yes it will because the statements don't differ between different players.

    If you have hands from both sited this will not work. I think the easiest it to create a new database and reimport all your hands.

  10. #10
    Junior Member
    Join Date
    Nov 2009
    Posts
    17

    Default

    ok thank you, il create a new database and giv it a go, see how i get on and il let yu know how i get on. Cheers man

Similar Threads

  1. Importing hands from merge on 1.10 beta
    By WtfFml in forum Manager General
    Replies: 1
    Last Post: 12-13-2009, 03:56 PM
  2. Boss and Merge hands needed
    By Rvg72 in forum Manager General
    Replies: 5
    Last Post: 10-28-2009, 04:36 PM
  3. Merge/Carbon Support
    By PokerPilot in forum Manager General
    Replies: 3
    Last Post: 08-28-2009, 12:29 AM
  4. database "merge" question
    By Colin252 in forum Manager General
    Replies: 4
    Last Post: 07-02-2009, 10:25 AM
  5. Merge support.
    By blackjock in forum Manager General
    Replies: 8
    Last Post: 06-20-2009, 02:53 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
  •