public void loadPlayerMoney(int id)
{
Player player = new PlayerList()[id];
var licenseIdentifier = player.Identifiers["steam"];
MYSQL.FetchAll($"SELECT * FROM playermoney WHERE steamid = '{licenseIdentifier}'", null, (List <dynamic> list) =>
{
Debug.WriteLine("3");
int money_ = 1000;
int bank_ = 5000;
int dirtyMoney_ = 0;
int count = (list == null) ? 0 : list.Count;
if (count == 0)
{
MYSQL.execute($"INSERT INTO playermoney (steamid,money,bank,dirty_money) VALUES ('{licenseIdentifier}','{money_}','{bank_}','{dirtyMoney_}');");
Debug.WriteLine($"Vytvarim hrace: {player.Name} [MONEYSYSTEM]");
}
else
{
money_ = list[0].money;
bank_ = list[0].bank;
dirtyMoney_ = list[0].dirty_money;
Debug.WriteLine($"Nacitam hrace: {player.Name} [MONEYSYSTEM]");
}
PlayerMoney money = new PlayerMoney();
money.setPlayer(player);
money.setMoney(money_);
money.setBankMoney(bank_);
money.setDirtyMoney(dirtyMoney_);
PlayerMoneyHolder.saveMoneyPlayerToList(id, money);
});
}
public static void loadPlayerJob(int source)
{
Player player = new PlayerList()[source];
string job = "unemployed";
string grade = "unemployed";
var licenseIdentifier = player.Identifiers["steam"];
MYSQL.FetchAll($"SELECT * FROM playerjob WHERE steamid = '{licenseIdentifier}'", null, (List <dynamic> list) =>
{
int count = (list == null) ? 0 : list.Count;
if (count == 0)
{
MYSQL.execute($"INSERT INTO playerjob (name,grade,steamid) VALUES ('{job}','{grade}','{licenseIdentifier}');");
Debug.WriteLine("Zapisuju nového hráče do tabulky 'PlayerJob'");
}
else
{
job = list[0].name;
grade = list[0].grade;
}
player.TriggerEvent("xCore:client:LoadJob", job, grade);
PlayerJob pJob = new PlayerJob();
pJob.setPlayer(player);
pJob.setPlayerJob(job, grade);
PlayerJobHolder.savePlayerToList(source, pJob);
});
}
public static void playerDisconnectFromGame([FromSource] Player player, string reason)
{
var licenseIdentifier = player.Identifiers["steam"];
//=====================
PlayerJob job = PlayerJobHolder.getPlayerJob(player);
if (job != null)
{
MYSQL.execute($"UPDATE playerjob " +
$"SET name = '{job.getJobName()}'," +
$"grade = '{job.getJobGrade()}' " +
$"WHERE steamid = '{licenseIdentifier}'; ");
PlayerJobHolder.removePlayerFromJobList(player);
}
//=====================
PlayerMoney money = PlayerMoneyHolder.getPlayerMoney(player);
if (money != null)
{
MYSQL.execute($"UPDATE playermoney " +
$"SET money = '{money.getMoney()}'," +
$"bank = '{money.getBankMoney()}'," +
$"dirty_money='{money.getDirtyMoney()}'" +
$"WHERE steamid = '{licenseIdentifier}'; ");
PlayerMoneyHolder.removePlayerFromMoneyList(player);
}
//=====================
PlayerGroup group = PlayerGroupHolder.getPlayerGroup(player);
if (group != null)
{
List <string> gp = group.playerGroups();
StringBuilder sb = new StringBuilder();
if (gp.Count != 0)
{
for (int i = 0; i < gp.Count; i++)
{
sb.Append($"('{licenseIdentifier}', '{gp[i]}'),");
}
MYSQL.execute($"DELETE FROM `groupusers` WHERE steamid = '{licenseIdentifier}';" +
$"INSERT INTO `groupusers` (`steamid`, `group`) VALUES {sb.ToString().Remove(sb.Length - 1)}");
}
PlayerGroupHolder.removePlayerFromGroupList(player);
}
//=====================
//=====================
//=====================
Debug.WriteLine($"Player {player.Name} has disconnected! ================================== :(");
}