For a game server, I want to record details when a player makes a kill, store this, and then at intervals update to a sql database.
The part i'm interested in right now is the best method of storing the kill information.
What i'd like to pass to the sql server on update would be {PlayerName, Kills, Deaths}, where the kills and deaths are a sum for the period between updates.
So i'm assuming i'd build a list along the lines of
{bob, 1, 0}
{frank, 0, 1}
{tom, 1, 0}
{frank, 0, 1}
then on update, consolidate the list to {frank, 14, 3}etc
Can someone offer some advice please?