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 }); } }