View Single Post
  #2  
Old 11-09-2007, 06:04 AM
Phil153 Phil153 is offline
Senior Member
 
Join Date: Oct 2005
Posts: 4,905
Default Re: How to calculate Total money bet using PT?

If you've converted your databases to postgresql, you can put the following query in the SQL window

select sum(total_bet) as TOTAL_BET, sum(total_won) as TOTAL_WON, sum(total_won-total_bet) as NET_WON from game_players inner join players on players.player_id = game_players.player_id where players.screen_name = 'Pokerpun'

Replace Pokerpun with your screen name, leave the ''. If you don't have postgresql, it's a bit more complicated. It's probably easier to install postgresql and convert the database than anything else.
Reply With Quote