Page 1 of 1

PT2 DB: any way to know if player

PostPosted: Mon Mar 31, 2008 1:16 pm
by MrFlibble
I want to make a table summarising player stats. I'm not sure how to keep it current. Regenerating the whole table every often seems a bit crazy. Is there any way to know when a player's stats related data has been changed/added?
I'm thinking using the player_winnings date_played column - am I missing a better way?

Re: PT2 DB: any way to know if player

PostPosted: Mon Mar 31, 2008 4:22 pm
by ptrack pat
I would suggest the session_start date in the SESSIONS table.

Re: PT2 DB: any way to know if player

PostPosted: Mon Mar 31, 2008 7:11 pm
by MrFlibble
Thanks pat.