/** * @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(); }