void LoadDataPlayer_Statistics(GameObject player)
{
PlayerStatisticComponent manager = player.GetComponent <PlayerStatisticComponent>();
foreach (TablePlayerStatistics row in Query <TablePlayerStatistics>("SELECT * FROM " + nameof(TablePlayerStatistics) + " WHERE owner=?", player.name))
{
manager.AddEntry(row.name, row.category, row.value);
}
}
void SaveDataPlayer_Statistics(GameObject player, bool isOnline)
{
// you should delete all data of this player first, to prevent duplicates
DeleteDataPlayer_Statistics(player.name);
PlayerStatisticComponent manager = player.GetComponent <PlayerStatisticComponent>();
foreach (StatisticSyncStruct entry in manager.GetEntries(false))
{
InsertOrReplace(new TablePlayerStatistics {
owner = player.name,
name = entry.name,
category = entry.category,
value = entry.value
});
}
}
