Search found 740 matches

Return to advanced search

Re: Filtering names with special characters

    I guess you can use dollar quoting.

    Code: Select all
    player.player_name not in ($$playerÁ$$, $$le'bouc$$)
    by BillGatesIII
    Sat Jun 20, 2020 3:10 pm
     
    Forum: PokerTracker 4
    Topic: Filtering names with special characters
    Replies: 2
    Views: 275

    Re: Error updating DB after most recent update

    javegam wrote:Im having the same problem attached the error message, due this right now PT4 is useless and i cannot play. Please Help

    I guess you'll have to ask the person or company where you bought the vs hero stats from to help you.
    by BillGatesIII
    Fri Jun 19, 2020 5:59 am
     
    Forum: PokerTracker 4
    Topic: Error updating DB after most recent update
    Replies: 17
    Views: 2556

    Re: Error updating DB after most recent update

    VCardKiller wrote:Getting exact same issue!! At least I am not alone. Mods should be able to help. Ty for replying :)

    https://gyazo.com/a6abbb5e3ea4e1b6baae919beef96533

    You are using hero stats from ProPokerHuds so maybe they can help you.
    by BillGatesIII
    Fri Jun 19, 2020 5:57 am
     
    Forum: PokerTracker 4
    Topic: Error updating DB after most recent update
    Replies: 17
    Views: 2556

    Re: How to use the MIN function?

    The min(a, b) and max(a, b) functions can only be used in statistics, not in columns.
    minmax.png
    min(a, b) and max(a, b)
    by BillGatesIII
    Thu Jun 18, 2020 7:35 am
     
    Forum: Custom Stats, Reports and HUD Profiles
    Topic: How to use the MIN function?
    Replies: 1
    Views: 181

    Re: Filter for facing 3bet w exactly 1 cold call

    I am not sure if I understand you correctly but for a report with all hands with a preflop 3bet and one cold caller this piece of code should work. id_hand in (select id_hand from tourney_hand_summary where length(str_aggressors_p) = 3 and right(str_actors_p, 1) <> right(str_aggressors_p, 1) and len...
    by BillGatesIII
    Mon Jun 15, 2020 3:11 pm
     
    Forum: Custom Stats, Reports and HUD Profiles
    Topic: Filter for facing 3bet w exactly 1 cold call
    Replies: 7
    Views: 517

    Re: Custom reports

    Cant edit I tried this on the All players report This filters to hands where someone was dealt in with less than 300 hands in the database: tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps where thps.id_player in (SELECT tc.id_player from tourn...
    by BillGatesIII
    Tue Oct 02, 2018 11:46 am
     
    Forum: Custom Stats, Reports and HUD Profiles
    Topic: Custom reports
    Replies: 17
    Views: 1865

    Re: Effective Stack Filter Problem

      A non-cached stat can be done with subqueries, like Flag_Hippo says. I think making a cacheable one is beyond the scope of this forum.
      by BillGatesIII
      Mon Aug 27, 2018 9:19 am
       
      Forum: PokerTracker 4
      Topic: Effective Stack Filter Problem
      Replies: 9
      Views: 1015

      Re: Effective Stack Filter Problem

        Is in the stat you want to create the button player the first to act? So all other players acting before the button have folded?
        by BillGatesIII
        Fri Aug 24, 2018 8:50 am
         
        Forum: PokerTracker 4
        Topic: Effective Stack Filter Problem
        Replies: 9
        Views: 1015
        Next

        Return to advanced search

        cron