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 }