public static void CheckPlayer(string Name)
{
try
{
checkPlayer = new Dictionary <string, Player>();
using (var reader = MySqlHelper.ExecuteReader(Connector.ConnectionString, "SELECT * FROM `players` WHERE Name='" + Name + "';"))
{
while (reader.Read())
{
Player player2 = new Player()
{
PlayerID = reader.GetUInt64("PlayerID"),
AccountID = reader.GetUInt64("AccountID"),
PlayerName = reader.GetString("Name"),
Rank = reader.GetInt32("Rank"),
PC_Cafe = reader.GetInt32("PC_Cafe"),
Emblem = reader.GetInt32("Emblem"),
Exp = reader.GetInt32("Exp"),
GP = reader.GetInt32("GP"),
Money = reader.GetInt32("Money"),
Clan = ClansManager.Load().getClanById(reader.GetUInt64("ClanID")),
};
checkPlayer.Add(player2.PlayerName, player2);
}
}
}
catch (Exception ex)
{
Logger.Error("[Error] {0}", ex);
}
}
public override void WriteImpl()
{
Clan clan = player.Clan;
WriteH(0x5A2);
if (clan == null)
{
WriteD(0); //есть ли клан
WriteD(0); //привилегии в клане
}
else
{
WriteD(clan != null ? 1 : 0);
WriteD(clan != null ? clan.OwnerId == player.PlayerID ? 1 : 2 : 0); // Привилегии в клане
}
WriteD(ClansManager.Load().getClans().Count); // количество кланов
WriteB(HexToByte.Convert("AA 01 00 80 6C 44 37")); //unk
}
public static void updatePlayerInfo(ulong PlayerID)
{
try
{
using (var reader = MySqlHelper.ExecuteReader(Connector.ConnectionString, "SELECT * FROM `players` WHERE PlayerID='" + PlayerID + "'';"))
{
while (reader.Read())
{
Player player = new Player()
{
PlayerID = reader.GetUInt64("PlayerID"),
AccountID = reader.GetUInt64("AccountID"),
PlayerName = reader.GetString("Name"),
Rank = reader.GetInt32("Rank"),
PC_Cafe = reader.GetInt32("PC_Cafe"),
Emblem = reader.GetInt32("Emblem"),
Exp = reader.GetInt32("Exp"),
GP = reader.GetInt32("GP"),
Money = reader.GetInt32("Money"),
Clan = ClansManager.Load().getClanById(reader.GetUInt64("ClanID")),
Effect1 = reader.GetInt32("Effect1"),
Effect2 = reader.GetInt32("Effect2"),
Effect3 = reader.GetInt32("Effect3"),
Effect4 = reader.GetInt32("Effect4"),
Effect5 = reader.GetInt32("Effect5"),
};
players.Remove(PlayerID); // удаляем значение из коллекции
players.Add(player.AccountID, player); // добавляем обновленное значение в коллекцию
}
}
Logger.Info("[PlayersTable] Player successfully update");
}
catch (Exception ex)
{
Logger.Error("[Error] {0}", ex);
}
}
public static void LoadTable()
{
try
{
players = new Dictionary <ulong, Player>();
using (var reader = MySqlHelper.ExecuteReader(Connector.ConnectionString, "SELECT * FROM `players`"))
{
while (reader.Read())
{
Player player = new Player()
{
PlayerID = reader.GetUInt64("PlayerID"),
AccountID = reader.GetUInt64("AccountID"),
PlayerName = reader.GetString("Name"),
Rank = reader.GetInt32("Rank"),
PC_Cafe = reader.GetInt32("PC_Cafe"),
Emblem = reader.GetInt32("Emblem"),
Exp = reader.GetInt32("Exp"),
GP = reader.GetInt32("GP"),
Money = reader.GetInt32("Money"),
Clan = ClansManager.Load().getClanById(reader.GetUInt64("ClanID")),
Effect1 = reader.GetInt32("Effect1"),
Effect2 = reader.GetInt32("Effect2"),
Effect3 = reader.GetInt32("Effect3"),
Effect4 = reader.GetInt32("Effect4"),
Effect5 = reader.GetInt32("Effect5"),
};
players.Add(player.AccountID, player);
}
}
Logger.Info("[PlayersTable] Loaded {0} players", players.Count);
}
catch (Exception ex)
{
Logger.Error("[Error] {0}", ex);
}
}
