public static EcoStats RetrieveStats(string name) { EcoStats stats = default(EcoStats); stats.Player = name; using (DataTable eco = Database.Backend.GetRows("Economy", "*", "WHERE player=@0", name)) { if (eco.Rows.Count > 0) { stats.TotalSpent = int.Parse(eco.Rows[0]["total"].ToString()); stats.Purchase = eco.Rows[0]["purchase"].ToString(); stats.Payment = eco.Rows[0]["payment"].ToString(); stats.Salary = eco.Rows[0]["salary"].ToString(); stats.Fine = eco.Rows[0]["fine"].ToString(); } else { stats.Purchase = "%cNone"; stats.Payment = "%cNone"; stats.Salary = "%cNone"; stats.Fine = "%cNone"; } } return(stats); }
static object ListOld(IDataRecord record, object arg) { EcoStats stats = ParseStats(record); stats.__unused = record.GetInt("money"); ((List <EcoStats>)arg).Add(stats); return(arg); }
public static EcoStats RetrieveStats(string name) { EcoStats stats = default(EcoStats); stats.Player = name; return((EcoStats)Database.ReadRows("Economy", "*", stats, ReadStats, "WHERE player=@0", name)); }
public static EcoStats RetrieveEcoStats(string playername) { EcoStats es = new EcoStats(); es.playerName = playername; EconomyDB.Load(es); return(es); }
public static void UpdateEcoStats(EcoStats es) { Database.AddParams("@Name", es.playerName); Database.AddParams("@Money", es.money); Database.AddParams("@Total", es.totalSpent); Database.AddParams("@Purchase", es.purchase); Database.AddParams("@Payment", es.payment); Database.AddParams("@Salary", es.salary); Database.AddParams("@Fine", es.fine); Database.executeQuery(string.Format("{0} Economy (player, money, total, purchase, payment, salary, fine) VALUES (@Name, @Money, @Total, @Purchase, @Payment, @Salary, @Fine)", (Server.useMySQL ? "REPLACE INTO" : "INSERT OR REPLACE INTO"))); }
public static void UpdateEcoStats(EcoStats es) { EconomyDB.Save(es); }
public static EcoStats RetrieveEcoStats(string playername) { EcoStats es = new EcoStats(); es.playerName = playername; EconomyDB.Load (es); return es; }
public static void UpdateStats(EcoStats stats) { Database.AddOrReplaceRow("Economy", "player, money, total, purchase, payment, salary, fine", stats.Player, 0, stats.TotalSpent, stats.Purchase, stats.Payment, stats.Salary, stats.Fine); }
public static void UpdateEcoStats(EcoStats es) { string query1 = String.Format("REPLACE INTO Economy (player, money, total, purchase, payment, salary, fine) VALUES ('{0}', {1}, {2}, '{3}', '{4}', '{5}', '{6}')", es.playerName, es.money, es.totalSpent, es.purchase, es.payment, es.salary, es.fine); string query2 = String.Format("INSERT OR REPLACE INTO Economy (player, money, total, purchase, payment, salary, fine) VALUES ('{0}', {1}, {2}, '{3}', '{4}', '{5}', '{6}')", es.playerName, es.money, es.totalSpent, es.purchase, es.payment, es.salary, es.fine); if (Server.useMySQL) MySQL.executeQuery(query1); else SQLite.executeQuery(query2); }