Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /// <summary>
- /// Holt alle Spieler aus der DB
- /// </summary>
- /// <returns></returns>
- public List<Player> GetAllPlayer()
- {
- List<Player> Players = new List<Player>();
- using (MySqlConnection connection = new MySqlConnection(connectionString))
- {
- connection.Open();
- MySqlCommand command = connection.CreateCommand();
- command.CommandText = "select * from Player p, PlayerPosition pp, PlayerDetails details, PlayerComponents pc where p.ID = pp.PlayerID AND p.ID = details.PlayerID AND p.ID = pc.PlayerID;";
- using (MySqlDataReader reader = command.ExecuteReader())
- {
- while (reader.Read())
- {
- Players.Add(new Player
- {
- ID = (int)reader["ID"],
- Username = (string)reader["Username"],
- Password = (string)reader["Password"],
- Position = new Vector3((double)reader["x_coordinate"], (double)reader["y_coordinate"], (double)reader["z_coordinate"]),
- Rotation = new Vector3(0, 0, (double)reader["rotation"]),
- Details = new PlayerDetails
- {
- Health = (int)reader["Health"],
- Armor = (int)reader["Armor"],
- isDead = reader.GetBoolean("isDead"),
- Model = (int)reader["Model"],
- Team = (int)reader["Team"],
- WalletMoney = (int)reader["WalletMoney"],
- Balance = (int)reader["Balance"],
- Job = (int)reader["Job"],
- Skin = (int)reader["skin"],
- Compontens = new CharacterCompontens
- {
- Face = (int)reader["Face"],
- Eyes = (int)reader["Eyes"],
- FacialHair = (int)reader["FacialHair"],
- Mask = (int)reader["Mask"],
- Hair = (int)reader["Hair"],
- HairColor = (int)reader["HairColor"],
- Torso = (int)reader["Torso"],
- Legs = (int)reader["Legs"],
- Backpack = (int)reader["Backpack"],
- Feet = (int)reader["Feet"],
- Undershirt = (int)reader["Undershirt"],
- BodyArmor = (int)reader["BodyArmor"],
- Top = (int)reader["Top"]
- },
- Acccessories = new CharacterAcccessories
- {
- Hat = (int)reader["Hat"],
- Glasses = (int)reader["Glasses"],
- Ears = (int)reader["Ears"],
- Watch = (int)reader["Watch"],
- Bracelets = (int)reader["Bracelets"]
- }
- }
- });
- }
- }
- }
- return Players;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement