public function getRevisions() { $res = array(); foreach ($this->dbQuery('SELECT slide_revision.id, timestamp, content, comment, user_id, username FROM slide_revision INNER JOIN users ON(user_id=users.id) WHERE slide=' . $this->slide_id . ' ORDER BY timestamp DESC') as $row) { $slide = new Slide(); $slide->createFromID($row['id']); $slide->content = $slide->getThumbnailContent(); $res[] = $slide; } return $res; }
public function getFourSlides() { $slides = array(); $res = array(); $slides = $this->dbQuery('SELECT * FROM deck_content WHERE deck_revision_id=:id AND item_type="slide" ORDER BY position LIMIT 4', array('id' => $this->id)); foreach ($slides as $slide) { $slide_obj = new Slide(); $slide_obj->createFromID($slide['item_id']); $slide_obj->thumbnailContent = $slide_obj->getThumbnailContent(); $slide_obj->deck = new Deck(); $slide_obj->deck->id = $this->id; $slide_obj->deck->title = $slide_obj->deck->getTitle(); $slide_obj->deck->slug_title = $slide_obj->sluggify($slide_obj->deck->title); $res[] = $slide_obj; } return $res; }