public function translate($language) { $source_arr = $this->getLanguage(); if (is_array($source_arr) && isset($source_arr['id'])) { $source = $source_arr['id']; } $target_arr = explode('-', $language); $target = $target_arr[0]; $translations = array(); $translations = $this->getAllTranslations(); $translator = new LanguageTranslator('AIzaSyBlwXdmxJZ__ZNScwe4zq5r3qh3ebXb26k'); if (count($translations)) { foreach ($translations as $node) { if ($node['language']['id'] == $target) { $slide = new Slide(); $slide->slide_id = $node['id']; $slide->createFromIDLite($slide->getLastRevisionID()); return $slide->id; } } } $old_slide_id = $this->slide_id; //for questions $this->symbolsToLatex(); $replace_array = array(); $replace_array = $this->filterTags(); $q = $this->content; $content = ''; $translation = $translator->translate($q, $target, $source); if ($translation != -1) { $tags_back = $this->addTagsBack($translation, $replace_array); $content = '<div lang="' . $target . '-x-mtfrom-' . $source . '">' . $tags_back . '</div>'; $this->language = $language; $this->translated_from = $this->slide_id; $translated_from_revision = $this->id; $this->content = $content; $this->description = $this->getDescription(); $this->latexToSymbols(); $based_on = NULL; $this->slide_id = $this->dbInsert('slide', array('user_id' => $this->user->id, 'description' => $this->description, 'language' => $this->language, 'translated_from' => $this->translated_from, 'translated_from_revision' => $translated_from_revision)); $new_slide_id = $this->slide_id; //for questions $this->translateQuestions($old_slide_id, $new_slide_id, $source_arr, $language); $this->based_on = NULL; $this->id = $this->dbInsert('slide_revision', array('slide' => $this->slide_id, 'content' => $this->content, 'user_id' => $this->user->id, 'comment' => $this->comment, 'based_on' => $based_on, 'note' => $this->note, 'translation_status' => 'google', 'translated_from_revision' => $translated_from_revision)); return $this->id; } else { return -1; } }
function reportSlideChanges() { $this->_template->disableHeader(); $this->_template->disableFooter(); $id = @$_GET['slide']; $compareTo = @$_GET['compareTo']; if (!isset($id)) { die("Error in receiving Slide id!"); } $slide1 = new Slide(); $slide2 = new Slide(); $slide1->createFromIDLite($id); if (!isset($compareTo)) { $slide2->id = $slide1->getPreviousRevisionID(); } else { $slide2->id = $compareTo; } $slide2->createFromIDLite($slide2->id); //$slide2->content=$this->tidyhtml($slide2->content); //$slide1->content=$this->tidyhtml($slide1->content); $this->set('new_content', htmlspecialchars($slide1->content)); $this->set('old_content', htmlspecialchars($slide2->content)); $this->set('slide_id', $id); //echo $this->htmlDiff($slide2->content, $slide1->content); }
public function fetchDeckContentLite() { $this->initConnection(); $deck = null; $slide = null; $res = array(); // get content $deckContent = $this->dbQuery('SELECT * FROM deck_content WHERE deck_revision_id=:id ORDER BY position', array('id' => $this->id)); /*if (! $deckContent) die ( "error querying db for deck content: " . mysql_error () );*/ // parse content foreach ($deckContent as $item) { // if it's deck if ($item['item_type'] == 'deck') { $deck = new Deck(); $deck->createFromIDLite($item['item_id']); $deck->content = $deck->fetchDeckContentLite(); $deck->position = $item['position']; $res[] = $deck; } else { $slide = new Slide(); $slide->createFromIDLite($item['item_id']); $slide->position = $item['position']; $slide->deck = new Deck(); $slide->deck->id = $item['deck_revision_id']; $slide->deck->title = $slide->deck->getTitle(); $slide->deck->slug_title = $slide->sluggify($slide->deck->title); $res[] = $slide; } } return $res; }
public function getFollowedSlides() { $this->initConnection(); $res = array(); $res_array = $this->dbQuery('SELECT * FROM subscription WHERE item_type="slide" AND user_id=:id', array('id' => $this->id)); foreach ($res_array as $row) { $slide = new Slide(); $slide->slide_id = $row['item_id']; $slide->createFromIDLite($slide->getLastRevisionID()); $title = $slide->getTitle(); $slide->title = $slide->shortenTitle($title); $res[] = $slide; } return $res; }
public function getCreateQuestionRevision($user_id = false, $start, $end, $keywords = '') { if ($user_id) { $user = new User(); $user->id = $user_id; $user->getUsername(); $this->initConnection(); $activities = array(); $result = array(); if (strlen($keywords)) { $result = $this->dbQuery('SELECT * FROM questions WHERE user_id=:user_id AND based_on IS NOT NULL AND MATCH (question) AGAINST (\'' . $keywords . '*\' IN BOOLEAN MODE)', array('user_id' => $user_id)); } else { $result = $this->dbQuery('SELECT * FROM questions WHERE user_id=:user_id AND based_on IS NOT NULL AND timestamp >= "' . $start . '" AND timestamp < "' . $end . '"', array('user_id' => $user_id)); } if (count($result)) { foreach ($result as $row) { $question = new Question(); $question->question = $row['question']; $text = new Slide(); $text->slide_id = $row['item_id']; $text->createFromIDLite($text->getLastRevisionID()); $text->title = $text->getTitle(); if ($text->title == "") { $text->title = "Untitled"; } $activity = new Activity($row['timestamp'], $user, 'created_question', $question, $text); $activities[] = $activity; } } if (count($activities)) { foreach ($activities as $activity) { $this->activities[] = $activity; } } } }