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