literate-perfunctory
Poker Software
Results 1 to 6 of 6
  1. #1
    Member
    Join Date
    Jan 2012
    Posts
    39

    Default How to get notes from postgress database

    Hello
    I'd like to take notes directly from database.
    I use pgadmin III and when put
    "select * from notecaddy_data where player_id = 4; I get result :

    "52-2,20,37,-23,63,-59,-86,286,294,-1444,-1521,-1591,-1999,-2569,2600,-2616,-2639,-2874,-2965,-2974,-2988,-5851,9452,-9464,9490,-9514,9554,-9581,9582,-9590,-9611,-9608,9621,-9638,9631,9665,-9677,-9682,9694,9706,9717,9732,-9751,9772,9813,9830,9852,-9848,-99 (...)"
    What is it?


    How to get notes which notecaddy created ?

    Best Regards

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

    Default

    This is described in more detail here NoteCaddy note creation information - Assaultware Wiki
    NoteCaddy Manual | Coaching Packs | Blog
    NoteCaddy experts: a.k.aAlso, Catalyst_Kh, Derders, karstenkloss, scoobediah (NoteCaddy Edge)

  3. #3
    Member
    Join Date
    Jan 2012
    Posts
    39

    Default

    I checked that one.
    "One row is created for each player and the full data is stored as a single piece of text"
    Where exactly is stored (which column?), because i checked table notecaddy_data and don't see any text

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

    Default

    "52-2,20,37,-23,63,-59,-86,286,294,-1444,-1521,-1591,-1999,-2569,2600,-2616,-2639,-2874,-2965,-2974,-2988,-5851,9452,-9464,9490,-9514,9554,-9581,9582,-9590,-9611,-9608,9621,-9638,9631,9665,-9677,-9682,9694,9706,9717,9732,-9751,9772,9813,9830,9852,-9848,-99 (...)"
    This is text. Maybe not human readable but it is technically text
    NoteCaddy Manual | Coaching Packs | Blog
    NoteCaddy experts: a.k.aAlso, Catalyst_Kh, Derders, karstenkloss, scoobediah (NoteCaddy Edge)

  5. #5
    Member
    Join Date
    Jan 2012
    Posts
    39

    Default

    Yes, technically.
    Any chance to transform it to the same form I can see in hm2? Any help on that?
    for example "misses cb out of position"

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

    Default

    You'd have to write a program to do that. A big part of the source code to make such a program is listed in that wiki page. If you're not clear about anything there I can try to help but I can't think of how better to help than to publish the source code of how to do it
    NoteCaddy Manual | Coaching Packs | Blog
    NoteCaddy experts: a.k.aAlso, Catalyst_Kh, Derders, karstenkloss, scoobediah (NoteCaddy Edge)

Similar Threads

  1. Connecting to remote postgress database
    By GaryPoker in forum General Support
    Replies: 1
    Last Post: 04-27-2017, 09:56 PM
  2. HEM postgress error while postgress works fine
    By yoshiwa in forum Bug Reports
    Replies: 1
    Last Post: 09-02-2012, 06:58 PM
  3. Replies: 3
    Last Post: 11-10-2011, 01:28 AM
  4. HEM suddenly can't connect to postgress database
    By CKP in forum Manager General
    Replies: 16
    Last Post: 08-28-2009, 02:28 PM
  5. How to delete database postgress if you cant find it?
    By blackopc in forum Manager General
    Replies: 4
    Last Post: 03-06-2009, 02:47 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
  •