public static long GetBalance(Guid allianceId)
{
try
{
using (var db = new LiteDatabase(connectionString))
{
var collection = db.GetCollection <BankData>("BankData");
var bank = collection.FindById(allianceId);
if (bank == null)
{
bank = new BankData
{
Id = allianceId,
balance = 0
};
collection.Insert(bank);
return(0);
}
else
{
return(bank.balance);
}
}
}
catch (Exception ex)
{
AlliancePlugin.Log.Error("Error with getting balance");
AlliancePlugin.Log.Error(ex);
return(0);
}
return(0);
}
public static Boolean RemoveFromBalance(Alliance alliance, long amount)
{
try
{
using (var db = new LiteDatabase(connectionString))
{
var collection = db.GetCollection <BankData>("BankData");
var bank = collection.FindById(alliance.AllianceId);
if (bank == null)
{
bank = new BankData
{
Id = alliance.AllianceId,
balance = 0
};
collection.Insert(bank);
}
else
{
bank.balance -= amount;
collection.Update(bank);
}
}
}
catch (Exception ex)
{
AlliancePlugin.Log.Error("Error with removing money from bank");
AlliancePlugin.Log.Error(ex);
return(false);
}
return(true);
}
public static Boolean PayShipyardFee(Alliance alliance, long fee, ulong id)
{
try
{
using (var db = new LiteDatabase(connectionString))
{
alliance.PayShipyardFee(fee, id);
var collection = db.GetCollection <BankData>("BankData");
var bank = collection.FindById(alliance.AllianceId);
if (bank == null)
{
bank = new BankData
{
Id = alliance.AllianceId,
balance = fee
};
collection.Insert(bank);
}
else
{
bank.balance += fee;
collection.Update(bank);
}
}
}
catch (Exception ex)
{
AlliancePlugin.Log.Error("Error with adding shipyard fee to bank");
AlliancePlugin.Log.Error(ex);
return(false);
}
return(true);
//MySqlConnection conn = new MySqlConnection(connStr);
//try
//{
// //Update the players table to add a new player and contract, if the player exists in table, update the contract id field
// //currently a player can only ever have one active contract, but that would be fairly easy to change
// //throw the player id into the contracts table then load all of those where completed is false
// conn.Open();
// String sql = "UPDATE AllianceBank.BankBalances SET balance = balance + " + fee + " where allianceId =" + alliance.AllianceId.ToString();
// MySqlCommand cmd = new MySqlCommand(sql, conn);
// cmd.ExecuteNonQuery();
//}
//catch (Exception ex)
//{
// conn.Close();
// AlliancePlugin.Log.Error("Error on paying shipyard fee", ex.ToString());
// return false;
//}
//conn.Close();
//AlliancePlugin.Log.Info("Paid shipyard fee " + id);
//return true;
}
public static Boolean Taxes(Dictionary <Guid, Dictionary <long, float> > taxes)
{
try
{
using (var db = new LiteDatabase(connectionString))
{
var collection = db.GetCollection <BankData>("BankData");
foreach (KeyValuePair <Guid, Dictionary <long, float> > key in taxes)
{
Alliance alliance = AlliancePlugin.GetAlliance(key.Key);
long amount = 0;
foreach (float f in key.Value.Values)
{
amount += (long)f;
}
var bank = collection.FindById(key.Key);
if (bank == null)
{
bank = new BankData
{
Id = key.Key,
balance = amount
};
collection.Insert(bank);
}
else
{
bank.balance += amount;
collection.Update(bank);
}
foreach (KeyValuePair <long, float> tax in key.Value)
{
if (EconUtils.getBalance(tax.Key) >= tax.Value)
{
alliance.DepositTax((long)tax.Value, MySession.Static.Players.TryGetSteamId(tax.Key));
EconUtils.takeMoney(tax.Key, (long)tax.Value);
}
}
AlliancePlugin.SaveAllianceData(alliance);
}
}
}
catch (Exception ex)
{
AlliancePlugin.Log.Error("Error with taxes");
AlliancePlugin.Log.Error(ex);
return(false);
}
return(true);
}
public static Boolean CreateAllianceBank(Alliance alliance)
{
// if (!File.Exists(AlliancePlugin.path + "//bank.db"))
// {
// File.Create(AlliancePlugin.path + "//bank.db");
// }
try
{
using (var db = new LiteDatabase(connectionString))
{
var collection = db.GetCollection <BankData>("BankData");
var bank = new BankData
{
Id = alliance.AllianceId,
balance = 1
};
collection.Insert(bank);
}
}
catch (Exception ex)
{
AlliancePlugin.Log.Error("Error creating new alliance in db");
AlliancePlugin.Log.Error(ex);
return(false);
}
return(true);
//MySqlConnection conn = new MySqlConnection(connStr);
//try
//{
// AlliancePlugin.Log.Info("Connecting to MySQL...");
// conn.Open();
// string sql = "INSERT INTO AllianceBank.BankBalances(allianceId, balance) VALUES ROW ('" + alliance.AllianceId.ToString() + "',0)";
// MySqlCommand cmd = new MySqlCommand(sql, conn);
// cmd.ExecuteNonQuery();
// AlliancePlugin.Log.Info("Inserted a new alliance into the bank");
//}
//catch (Exception ex)
//{
// conn.Close();
// AlliancePlugin.Log.Error("Error adding new alliance to bank.");
// AlliancePlugin.Log.Error(ex);
//}
//conn.Close();
//AlliancePlugin.Log.Info("Successfully created bank data in database!");
//return true;
}
//public static void testConnection()
//{
// MySqlConnection conn = new MySqlConnection(connStr);
// try
// {
// AlliancePlugin.Log.Info("Connecting to MySQL...");
// conn.Open();
// string sql = "CREATE DATABASE IF NOT EXISTS AllianceBank";
// MySqlCommand cmd = new MySqlCommand(sql, conn);
// cmd.ExecuteNonQuery();
// sql = "CREATE TABLE IF NOT EXISTS AllianceBank.BankBalances(allianceId CHAR(36) PRIMARY KEY, balance BIGINT)";
// cmd = new MySqlCommand(sql, conn);
// cmd.ExecuteNonQuery();
// AlliancePlugin.Log.Info("Created the tables if it needed to");
// }
// catch (Exception ex)
// {
// ReadyToSave = false;
// conn.Close();
// AlliancePlugin.Log.Error("Error connecting to database, disabling bank features.");
// AlliancePlugin.Log.Error(ex);
// }
// conn.Close();
// AlliancePlugin.Log.Info("Successfully connected to database!");
//}
public static void DoUpkeepForOne(Alliance alliance)
{
try
{
using (var db = new LiteDatabase(connectionString))
{
var collection = db.GetCollection <BankData>("BankData");
FileUtils jsonStuff = new FileUtils();
jsonStuff.WriteToJsonFile <Alliance>(AlliancePlugin.path + "//UpkeepBackups//" + alliance.AllianceId + ".json", alliance);
var bank = collection.FindById(alliance.AllianceId);
if (bank == null)
{
bank = new BankData
{
Id = alliance.AllianceId,
balance = 1
};
collection.Insert(bank);
alliance.failedUpkeep++;
if (alliance.failedUpkeep >= AlliancePlugin.config.UpkeepFailBeforeDelete)
{
AllianceChat.SendChatMessage(alliance.AllianceId, "Upkeep", "Upkeep failed, met the threshold for delete. Deleting Alliance.", true, 0);
AlliancePlugin.AllAlliances.Remove(alliance.name);
File.Delete(AlliancePlugin.path + "//AllianceData//" + alliance.AllianceId + ".json");
foreach (long id in alliance.AllianceMembers)
{
AlliancePlugin.FactionsInAlliances.Remove(id);
}
}
else
{
AllianceChat.SendChatMessage(alliance.AllianceId, "Upkeep", "Upkeep failed, Upgrades disabled.", true, 0);
}
}
else
{
if (bank.balance >= alliance.GetUpkeep())
{
bank.balance -= alliance.GetUpkeep();
collection.Update(bank);
AllianceChat.SendChatMessage(alliance.AllianceId, "Upkeep", "Paying upkeep of " + String.Format("{0:n0}", alliance.GetUpkeep()) + " SC.", true, 0);
alliance.Upkeep(alliance.GetUpkeep(), 1);
alliance.bankBalance -= alliance.GetUpkeep();
alliance.failedUpkeep = 0;
AlliancePlugin.SaveAllianceData(alliance);
}
else
{
alliance.failedUpkeep++;
if (alliance.failedUpkeep >= AlliancePlugin.config.UpkeepFailBeforeDelete)
{
AllianceChat.SendChatMessage(alliance.AllianceId, "Upkeep", "Upkeep failed, met the threshold for delete. Deleting Alliance.", true, 0);
AlliancePlugin.AllAlliances.Remove(alliance.name);
File.Delete(AlliancePlugin.path + "//AllianceData//" + alliance.AllianceId + ".json");
foreach (long id in alliance.AllianceMembers)
{
AlliancePlugin.FactionsInAlliances.Remove(id);
}
}
else
{
AllianceChat.SendChatMessage(alliance.AllianceId, "Upkeep", "Upkeep failed, Upgrades disabled.", true, 0);
}
}
}
}
}
catch (Exception ex)
{
AlliancePlugin.Log.Error("Error for all upkeep");
AlliancePlugin.Log.Error(ex);
return;
}
}