Advertisement
Guest User

Untitled

a guest
Jan 15th, 2018
648
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.63 KB | None | 0 0
  1. /// <summary>
  2. /// Holt alle Spieler aus der DB
  3. /// </summary>
  4. /// <returns></returns>
  5. public List<Player> GetAllPlayer()
  6. {
  7. List<Player> Players = new List<Player>();
  8.  
  9. using (MySqlConnection connection = new MySqlConnection(connectionString))
  10. {
  11. connection.Open();
  12.  
  13. MySqlCommand command = connection.CreateCommand();
  14. 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;";
  15.  
  16. using (MySqlDataReader reader = command.ExecuteReader())
  17. {
  18. while (reader.Read())
  19. {
  20. Players.Add(new Player
  21. {
  22. ID = (int)reader["ID"],
  23. Username = (string)reader["Username"],
  24. Password = (string)reader["Password"],
  25. Position = new Vector3((double)reader["x_coordinate"], (double)reader["y_coordinate"], (double)reader["z_coordinate"]),
  26. Rotation = new Vector3(0, 0, (double)reader["rotation"]),
  27. Details = new PlayerDetails
  28. {
  29. Health = (int)reader["Health"],
  30. Armor = (int)reader["Armor"],
  31. isDead = reader.GetBoolean("isDead"),
  32. Model = (int)reader["Model"],
  33. Team = (int)reader["Team"],
  34. WalletMoney = (int)reader["WalletMoney"],
  35. Balance = (int)reader["Balance"],
  36. Job = (int)reader["Job"],
  37. Skin = (int)reader["skin"],
  38. Compontens = new CharacterCompontens
  39. {
  40. Face = (int)reader["Face"],
  41. Eyes = (int)reader["Eyes"],
  42. FacialHair = (int)reader["FacialHair"],
  43. Mask = (int)reader["Mask"],
  44. Hair = (int)reader["Hair"],
  45. HairColor = (int)reader["HairColor"],
  46. Torso = (int)reader["Torso"],
  47. Legs = (int)reader["Legs"],
  48. Backpack = (int)reader["Backpack"],
  49. Feet = (int)reader["Feet"],
  50. Undershirt = (int)reader["Undershirt"],
  51. BodyArmor = (int)reader["BodyArmor"],
  52. Top = (int)reader["Top"]
  53. },
  54. Acccessories = new CharacterAcccessories
  55. {
  56. Hat = (int)reader["Hat"],
  57. Glasses = (int)reader["Glasses"],
  58. Ears = (int)reader["Ears"],
  59. Watch = (int)reader["Watch"],
  60. Bracelets = (int)reader["Bracelets"]
  61. }
  62. }
  63. });
  64. }
  65. }
  66. }
  67.  
  68. return Players;
  69. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement