↓PokerTracker Query Definitions ↓DLL

typedef struct t_QueryDefinition {    
    CString name;    
    CString description_for_editor;    
    CString first_part_of_query;    
    // The queries will be created on the fly,    
    // for both ring-games and tournaments.    
    // There will be an "infix" added, depending on game-type    
    CString last_part_of_query;    
    int stat_group;    
    bool needs_infix_and_second_part; 
};

• "name" should be self-explanatory. It is something like "icon" or "vpip".
• "description_for_editor" is the explanation that will be shown in OpenHoldems formula-editor.
• “query” is is the database-query, usually containing one or more 3 place-holders %GAMETYPE% , %SITEID% and %SCREENNAME%. OpenHoldem will build the complete query on the fly and automatically replace these place-holders by the correct values. A nice side-effect of this new concept: all stats will automatically work for both ring-games and tournaments; therefore OpenHoldem does no longer distinguish between "pt_" and "ptt_" stats, simply “pt_” will always work.
• "stat_group": this is one of pt_group_basic / pt_group_advanced / pt_group_positional. Diffferent groups of stats need different sample-sizes to become meaningful or change significantly. Therefore OpenHoldem will evaluate these symbols with different update delays depending on the number of hands a user has played to achieve a good compromise between meaningful stats and a low database-usage.

const int k_number_of_pokertracker_stats = 29;

t_QueryDefinition query_definitions[k_number_of_pokertracker_stats] = 
{    
    /* PT4 query to get icon */    
    {       
        // name       
        "icon",          
        // description_for_editor 		
        "Poker Tracker auto-rate icon code", 		
        // query 		
        "SELECT val_icon as result \ 		 
        FROM   player \ 		 
        WHERE  id_site = %SITEID% AND \ 		        
        player_name LIKE ’%SCREENNAME%’", 		
        // stat_group 		
        pt_group_basic 	
    }, 
    /* PT4 query to get number of hands in the database */ 	
    { 		
        // name 		
        "hands",
        ...

• it is update-safe. If a new version of OpenHoldem gets released your DLL will work as before without you having to compile a modified version of OpenHoldem or missing important bug-fixes.
• you can add stats without having to wait for new releases.
• you can easily contribute to make OpenHoldem better for everyone.