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