private void CharacterSave_UCE_Statistics(Player player)
{
#if _MYSQL && _SERVER
ExecuteNonQueryMySql("DELETE FROM character_statistics WHERE `character`=@character", new MySqlParameter("@character", player.name));
foreach (UCE_Statistic statistic in player.GetComponent <UCE_PlayerStatistics>().UCE_statistics)
{
ExecuteNonQueryMySql("INSERT INTO character_statistics VALUES (@character, @statistic, @amount, @total)",
new MySqlParameter("@character", player.name),
new MySqlParameter("@currency", statistic.name),
new MySqlParameter("@amount", statistic.amount),
new MySqlParameter("@total", statistic.total)
);
}
#elif _SQLITE && _SERVER
UCE_connection.Execute("DELETE FROM character_statistics WHERE character=?", player.name);
foreach (UCE_Statistic statistic in player.GetComponent <UCE_PlayerStatistics>().UCE_statistics)
{
UCE_connection.InsertOrReplace(new character_statistics
{
character = player.name,
statistic = statistic.name,
amount = statistic.amount,
total = statistic.total
});
}
#endif
}
private void Connect_UCE_Statistics()
{
#if _MYSQL && _SERVER
ExecuteNonQueryMySql(@"CREATE TABLE IF NOT EXISTS character_statistics (
`character` VARCHAR(32) NOT NULL,
statistic VARCHAR(32) NOT NULL,
amount INTEGER(16) NOT NULL,
total INTEGER(16) NOT NULL
)CHARACTER SET=utf8mb4" );
#elif _SQLITE && _SERVER
UCE_connection.CreateTable <character_statistics>();
#endif
}
private void CharacterLoad_UCE_Statistics(Player player)
{
#if _MYSQL && _SERVER
var table = ExecuteReaderMySql("SELECT statistic, amount, total FROM character_statistics WHERE `character`=@name", new MySqlParameter("@name", player.name));
foreach (var row in table)
{
player.GetComponent <UCE_PlayerStatistics>().AddStatistic((string)row[0], (int)row[1], (int)row[2]);
}
#elif _SQLITE && _SERVER
var table = UCE_connection.Query <character_statistics>("SELECT statistic, amount, total FROM character_statistics WHERE character=?", player.name);
foreach (var row in table)
{
player.GetComponent <UCE_PlayerStatistics>().AddStatistic(row.statistic, row.amount, row.total);
}
#endif
}
