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