public function save(PlayerStage $stage)
{
$query = "UPDATE player_stages SET\n level_id = ? WHERE level_id = ? AND stage_id = ? AND player_id = ? AND university_id = ?";
$params = [$stage->getLevel()->getLevelId(), $stage->getLevel()->getLevelId() - 1, $stage->getStage()->getId(), $stage->getPlayer()->getId(), $stage->getUniversity()->getId()];
$this->db->query($query, $params);
return $this->db->rows() > 0;
}
public function save(University $university)
{
$query = "\n INSERT INTO universities\n (name, player_id, money, lectures)\n VALUES (?, ?, ?, ?)\n ";
$params = [$university->getName(), $university->getPlayer()->getId(), $university->getMoney(), $university->getLecturues()];
if ($university->getId()) {
$query = "UPDATE universities SET\n name = ?, player_id = ?, money = ?, lectures = ?\n WHERE id = ?\n ";
$params[] = $university->getId();
}
$this->db->query($query, $params);
return $this->db->rows() > 0;
}
public function save(Player $player)
{
$query = "\n INSERT INTO players (username, password)\n VALUES (?, ?)\n ";
$params = [$player->getUsername(), $player->getPassword()];
if ($player->getId()) {
$query = "UPDATE players SET username = ?, password = ? WHERE id = ?";
$params[] = $player->getId();
}
$this->db->query($query, $params);
return $this->db->rows() > 0;
}
