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)
{
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)
{
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);
}
public static void UpdateEcoStats(EcoStats es)
{
EconomyDB.Save(es);
}
