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); } }