function indexAction() { $db = $this->get('db'); $session = $this->get('session'); $aid = $session->get('aid'); $player = new Agent($aid); $player->setDb($db); $player->load(); $cid = $player->getCity(); $city = new City($cid); $city->setDb($db); $city->load(); $persona = new Persona($player->getPersona()); $persona->setDb($db); $persona->load(); $player->setDb(null); $player->setIsplayer(null); $player->setPtype(null); return $this->render('GameBundle:Game:characterview.html.twig', array('myCity' => $city, 'myCharacter' => $player, 'myReputation' => $persona)); }
/** * @param $userid * @param $named * @param $culture * @param $city * @param $allegiance * @return int */ private function newPlayerAgent($userid, $named, $culture, $city, $allegiance) { // Create an undefined object to be assembled and pass it the DB $agent = new Agent(null); $agent->setDb($this->db); // Plunk, plonk, plonk $agent->setIsplayer(true); $agent->setUserid($userid); $agent->setNamed($named); $agent->setCulture($culture); // Get the player's chosen city out of the DB $query = 'SELECT * FROM game.city WHERE named="' . $city . '";'; $this->db->setQuery($query); $this->db->query(); $dbObject = $this->db->loadObject(); // Plunk, plonk, city data $agent->setX($dbObject->x); $agent->setY($dbObject->y); $agent->setCity($dbObject->id); $agent->setActivity('idle'); // Create a new buildinglist and point the value of $this->holdings to its primary key $query = 'INSERT INTO game.estate(id) VALUES(null);'; $this->db->setQuery($query); $this->db->query(); $agent->setHoldings($this->db->getLastInsertId()); // Ditto for a blank persona $query = 'INSERT INTO game.persona(id) VALUES(null);'; $this->db->setQuery($query); $this->db->query(); $agent->setPersona($this->db->getLastInsertId()); // Plunk $agent->setAllegiance($allegiance); // Insert the new Agent into SQL and return the primary key $agent->update(); return $this->db->getLastInsertId(); }