Custom DataBase / Hud don't show

[Eric Poker]

OK

I have tried several thing so far and everything seem to work perfecly. But I can make the hud showing the result I can show in the Players/Statistics

I'm going to make it simple for the beginning. If I create str_player_name2 (columns) and Player2 (statistics) in the tournament player statistics, a total clone of str_player_name and Player. I can show the "new" stats in the "player stats" in the general tabs but I can't use it in the hud.
Yes I know this is worthless to show it in the hud.

Here the main problem ( yes i made backup and i'm trying this with new database)
I add a new column in the "player" table (IN THE DATABASE using pgAdmin) named scroi (sharkscope ROI)
I can see it with the "insert" tool of configure statistics/columns.
I made a columns using the expression player.scroi. Everything is working fine at this point
I made a statistics in the "Tournament Player Statistics" named Sharkscope.

In the General tabs / Player Statisctic I can use this new statistic, the numbers are properly showed
I can make a report (number is not actual roi of player )
[ img ]

The question is... why the hell can I display this stat in the Hud ( i cant see the option) ?
Any idea ?

[Eric Poker]

I tried to add a column to tourney_holdem_hand_summary
Using max(expr)
But I can't import new hands :(
I have no way to set postgre SQL ignoring when I tried to create a row without the value for the last column in the setting ?

Code: Select all

2008/10/17 02:43:52: Full Tilt: Unable to import hand (#8526045239). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR:  missing data for column "sharkscope" CONTEXT:  COPY tourney_holdem_hand_summary, line 1: "4   300   1   3   1   8526045239   2008/10/17 06:41:53   2008/10/17 02:43:51   9   2   2   2   925.00   1330.00   1330.00   1330.0..." )


[WhiteRider]

For stats to be available in the HUD you will need to restart the HUD after you save the stats.
I'm not sure of the consequences of changes to the database, so I'll try to get someone from the dev team to take a look.

[APerfect10]

You should never modify the PostgreSQL tables directly as it will more than likely not work properly. Even if a query doesn't fail new stats would not be inserted properly anyways...

That is why we've created custom stats. You should be able to do almost everything that you would want via custom stats/reports and if you cannot, let us know and we'll gladly add it. :)

Best regards,

Derek