public static List <HasCarPart> getCarPartsForUser(int playerId) { List <HasCarPart> parts = new List <HasCarPart>(); SqliteCommand command = new SqliteCommand(@"select * from has_car_part hc, player_car pc where pc.player_id = hc.playerId AND pc.player_id = @id AND(pc.chassis_id IS NULL OR hc.id <> pc.chassis_id) AND(pc.attack1_id IS NULL OR hc.id <> pc.attack1_id) AND(pc.attack2_id IS NULL OR hc.id <> pc.attack2_id) AND(pc.forklift_id IS NULL OR hc.id <> pc.forklift_id) AND(pc.frontwheel_id IS NULL OR hc.id <> pc.frontwheel_id) AND(pc.backwheel_id IS NULL OR hc.id <> pc.backwheel_id)", DatabaseConnection.connection); command.Parameters.Add(new SqliteParameter("@id", playerId)); IDataReader reader = command.ExecuteReader(); while (reader.Read()) { HasCarPart hasCarPart = new HasCarPart(); hasCarPart.id = reader.GetInt32(0); hasCarPart.playerId = playerId; hasCarPart.carPart = getCarPart(reader.GetInt32(2)); hasCarPart.stars = reader.GetInt32(3); parts.Add(hasCarPart); } reader.Close(); return(parts); }
public void UnselectItem() { if (selected == null) { return; } switch (selected.carPart.type) { case 1: chassisPlace.SetActive(false); break; case 2: frontWheelPlace.SetActive(false); backWheelPlace.SetActive(false); break; case 3: forkliftPlace.SetActive(false); break; case 4: attack1Place.SetActive(false); if (selected.carPart.id == 9) { attack2Place.SetActive(false); } break; } selected = null; }
public void SelectItem(HasCarPart hasCarPart) { selected = hasCarPart; switch (selected.carPart.type) { case 1: chassisPlace.SetActive(true); break; case 2: frontWheelPlace.SetActive(true); backWheelPlace.SetActive(true); break; case 3: forkliftPlace.SetActive(true); break; case 4: attack1Place.SetActive(true); if (selected.carPart.id == 9 && playerCar.chassis.id == 3) { attack2Place.SetActive(true); } break; } }
public void AddPlayerButton() { string nick = nickname.text; string first = firstName.text; string last = lastName.text; int a = int.Parse(age.text); Player p = DatabaseDataAcces.getPlayerWithNickname(nick); if (p == null) { p = new Player(); p.nickname = nick; p.firstName = first; p.lastName = last; p.age = a; DatabaseDataAcces.insertPlayer(p); } p = DatabaseDataAcces.getPlayerWithNickname(nick); int chassisId = DatabaseDataAcces.InsertHasCarPart(p.id, 1, 1); int attackId = DatabaseDataAcces.InsertHasCarPart(p.id, 7, 1); int wheelId = DatabaseDataAcces.InsertHasCarPart(p.id, 5, 1); int wheel2Id = DatabaseDataAcces.InsertHasCarPart(p.id, 5, 1); HasCarPart chassis = DatabaseDataAcces.getHasCarPart(chassisId); HasCarPart attack = DatabaseDataAcces.getHasCarPart(attackId); HasCarPart wheel = DatabaseDataAcces.getHasCarPart(wheelId); HasCarPart wheel2 = DatabaseDataAcces.getHasCarPart(wheel2Id); DatabaseDataAcces.InsertPlayerCar(p.id); DatabaseDataAcces.changePart(chassis, 1); DatabaseDataAcces.changePart(attack, 1); DatabaseDataAcces.changePart(wheel, 1); DatabaseDataAcces.changePart(wheel2, 2); DatabaseDataAcces.insertBox(p.id, 0); DatabaseDataAcces.insertBox(p.id, 0); SceneManager.LoadScene("StartupScene"); }
public static void changePart(HasCarPart hasCarPart, int subtype) { SqliteCommand command = null; switch (hasCarPart.carPart.type) { case 1: command = new SqliteCommand("UPDATE player_car SET chassis_id = @partId WHERE player_id = @playerId", DatabaseConnection.connection); break; case 2: if (subtype == 1) { command = new SqliteCommand("UPDATE player_car SET frontwheel_id = @partId WHERE player_id = @playerId", DatabaseConnection.connection); } else { command = new SqliteCommand("UPDATE player_car SET backwheel_id = @partId WHERE player_id = @playerId", DatabaseConnection.connection); } break; case 3: command = new SqliteCommand("UPDATE player_car SET forklift_id = @partId WHERE player_id = @playerId", DatabaseConnection.connection); break; case 4: if (subtype == 1) { command = new SqliteCommand("UPDATE player_car SET attack1_id = @partId WHERE player_id = @playerId", DatabaseConnection.connection); } else { command = new SqliteCommand("UPDATE player_car SET attack2_id = @partId WHERE player_id = @playerId", DatabaseConnection.connection); } break; } command.Parameters.Add(new SqliteParameter("@playerId", hasCarPart.playerId)); command.Parameters.Add(new SqliteParameter("@partId", hasCarPart.id)); command.ExecuteNonQuery(); }
public static HasCarPart getHasCarPart(int id) { HasCarPart hasCarPart = null; SqliteCommand command = new SqliteCommand("select * from has_car_part where id = @id", DatabaseConnection.connection); command.Parameters.Add(new SqliteParameter("@id", id)); IDataReader reader = command.ExecuteReader(); if (reader.Read()) { hasCarPart = new HasCarPart(); hasCarPart.id = reader.GetInt32(0); hasCarPart.playerId = reader.GetInt32(1); hasCarPart.carPart = DatabaseDataAcces.getCarPart(reader.GetInt32(2)); hasCarPart.stars = reader.GetInt32(3); } reader.Close(); return(hasCarPart); }
public static Car getPlayersCar(int playerId) { Car car = null; SqliteCommand command = new SqliteCommand("select * from player_car where player_id = @id", DatabaseConnection.connection); command.Parameters.Add(new SqliteParameter("@id", playerId)); IDataReader reader = command.ExecuteReader(); if (reader.Read()) { car = new Car(); // chasiss if (!reader.IsDBNull(1)) { int id = reader.GetInt32(1); HasCarPart hasCarPart = getHasCarPart(id); car.chassis = hasCarPart.carPart; car.chassisStars = hasCarPart.stars; } else { car.chassis = null; } // attack1 if (!reader.IsDBNull(2)) { int id = reader.GetInt32(2); HasCarPart hasCarPart = getHasCarPart(id); car.attack1 = hasCarPart.carPart; car.attack1Stars = hasCarPart.stars; } else { car.attack1 = null; } if (!reader.IsDBNull(3)) { int id = reader.GetInt32(3); HasCarPart hasCarPart = getHasCarPart(id); car.frontWheel = hasCarPart.carPart; car.frontWheelStars = hasCarPart.stars; } else { car.frontWheel = null; } if (!reader.IsDBNull(4)) { int id = reader.GetInt32(4); HasCarPart hasCarPart = getHasCarPart(id); car.backWheel = hasCarPart.carPart; car.backWheelStars = hasCarPart.stars; } else { car.backWheel = null; } if (!reader.IsDBNull(5)) { int id = reader.GetInt32(5); HasCarPart hasCarPart = getHasCarPart(id); car.forklift = hasCarPart.carPart; car.forkliftStars = hasCarPart.stars; } else { car.forklift = null; } if (!reader.IsDBNull(6)) { int id = reader.GetInt32(6); HasCarPart hasCarPart = getHasCarPart(id); car.attack2 = hasCarPart.carPart; car.attack2Stars = hasCarPart.stars; } else { car.attack2 = null; } } reader.Close(); return(car); }