/** * main call to build profile of title * * @return array */ public function profile() { $this->getIMDBMetadata(); $sqlQuery = "SELECT catalogue.*, member.ID as MID, member.Email, member.FirstName, member.Surname \r\n FROM catalogue \r\n LEFT JOIN member ON catalogue.Owner = member.ID \r\n WHERE catalogue.ID = '{$this->id}'"; $records = DB::query($sqlQuery); if ($records) { $set = new ArrayList(); foreach ($records as $record) { $record['lastupdatedreadable'] = parent::humanTiming($record['LastEdited']); $record['seasonLinks'] = $this->seasonLinks($record['Seasons']); $record['displayComments'] = parent::displayComments($record['Comments']); $set->push(new ArrayData($record)); } return $set; } }