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;
}
