Esempio n. 1
0
 /**
  * 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;
     }
 }