コード例 #1
0
 public function build($runData)
 {
     $site = $runData->getTemp("site");
     $pl = $runData->getParameterList();
     $limit = $pl->getParameterValue("limit", "MODULE");
     if ($limit == null || !is_numeric($limit) || $limit < 1 || $limit > 300) {
         $limit = 5;
     }
     $categoryId = $pl->getParameterValue("categoryId", "MODULE", "AMODULE");
     if ($categoryId !== null) {
         $category = DB_ForumCategoryPeer::instance()->selectByPrimaryKey($categoryId);
         if ($category == null || $category->getSiteId() != $site->getSiteId()) {
             throw new ProcessException(_("The category can not be found."));
         }
     }
     // get recent forum posts
     $c = new Criteria();
     $c->add("forum_post.site_id", $site->getSiteId());
     if ($category) {
         $c->add("forum_post.category_id", $category->getCategoryId());
     }
     $c->addJoin("thread_id", "forum_thread.thread_id");
     $c->addOrderDescending("post_id");
     $c->setLimit($limit);
     $posts = DB_ForumPostPeer::instance()->select($c);
     $runData->contextAdd("posts", $posts);
 }
コード例 #2
0
ファイル: NumberForumPosts.php プロジェクト: jbzdak/wikidot
 public function calculate($user)
 {
     $c = new Criteria();
     $c->add('user_id', $user->getUserId());
     $count = DB_ForumPostPeer::instance()->selectCount($c);
     return $count;
 }
コード例 #3
0
 public function build($runData)
 {
     $pl = $runData->getParameterList();
     $postId = $pl->getParameterValue("postId", "AMODULE");
     $user = $runData->getUser();
     $site = $runData->getTemp("site");
     if ($postId == null || !is_numeric($postId)) {
         throw new ProcessException(_("No post specified."), "no_post");
     }
     $post = DB_ForumPostPeer::instance()->selectByPrimaryKey($postId);
     if ($post == null || $post->getSiteId() != $site->getSiteId()) {
         throw new ProcessException(_("No post specified."), "no_post");
     }
     $category = $post->getForumThread()->getCategory();
     try {
         WDPermissionManager::instance()->hasForumPermission('moderate_forum', $runData->getUser(), $category);
     } catch (Exception $e) {
         throw new WDPermissionException(_("Sorry, you are not allowed to delete posts. Only site administrators and moderators are the ones who can."));
     }
     // OK for now...
     //check if there any child posts
     $c = new Criteria();
     $c->add("parent_id", $postId);
     $chpc = DB_ForumPostPeer::instance()->selectCount($c);
     if ($chpc > 0) {
         $runData->contextAdd("hasChildren", true);
     }
     $runData->contextAdd("post", $post);
     $runData->ajaxResponseAdd("postId", $postId);
 }
コード例 #4
0
ファイル: DB_ForumCategory.php プロジェクト: jbzdak/wikidot
 public function getLastPost()
 {
     if ($this->getLastPostId() == null) {
         return;
     }
     $c = new Criteria();
     $c->add("post_id", $this->getLastPostId());
     $c->addJoin("user_id", "ozone_user.user_id");
     $post = DB_ForumPostPeer::instance()->selectOne($c);
     return $post;
 }
コード例 #5
0
 public function build($runData)
 {
     $site = $runData->getTemp("site");
     $pl = $runData->getParameterList();
     $userId = $pl->getParameterValue("userId");
     if ($runData->getUser() && $userId == $runData->getUser()->getUserId()) {
         $own = true;
     }
     $categoryId = $pl->getParameterValue("categoryId");
     $limit = $pl->getParameterValue("limit");
     if ($limit == null || !is_numeric($limit)) {
         $limit = 20;
     }
     $pageNumber = $pl->getParameterValue("page");
     $op = $pl->getParameterValue("options");
     if ($pageNumber === null) {
         $pageNumber = 1;
     }
     $perPage = $limit;
     $offset = ($pageNumber - 1) * $perPage;
     $count = $perPage * 2 + 1;
     $c = new Criteria();
     if ($categoryId !== null && is_numeric($categoryId)) {
         $c->add("forum_thread.category_id", $categoryId);
     }
     $c->add("forum_post.user_id", $userId);
     if (!$own) {
         $c->add("site.private", false);
     }
     $c->addJoin("thread_id", "forum_thread.thread_id");
     $c->addJoin("user_id", "ozone_user.user_id");
     $c->addJoin("forum_post.site_id", "site.site_id");
     $c->add("site.deleted", false);
     $c->addOrderDescending("post_id");
     $c->setLimit($count, $offset);
     $posts = DB_ForumPostPeer::instance()->select($c);
     $counted = count($posts);
     $pagerData = array();
     $pagerData['currentPage'] = $pageNumber;
     if ($counted > $perPage * 2) {
         $knownPages = $pageNumber + 2;
         $pagerData['knownPages'] = $knownPages;
     } elseif ($counted > $perPage) {
         $knownPages = $pageNumber + 1;
         $pagerData['totalPages'] = $knownPages;
     } else {
         $totalPages = $pageNumber;
         $pagerData['totalPages'] = $totalPages;
     }
     $posts = array_slice($posts, 0, $perPage);
     $runData->contextAdd("pagerData", $pagerData);
     $runData->contextAdd("posts", $posts);
 }
コード例 #6
0
ファイル: AWForumListModule.php プロジェクト: jbzdak/wikidot
 public function build($runData)
 {
     $user = $runData->getUser();
     $pl = $runData->getParameterList();
     $pageNumber = $pl->getParameterValue("page");
     if ($pageNumber === null) {
         $pageNumber = 1;
     }
     $limit = $pl->getParameterValue("limit");
     if ($limit == null || !is_numeric($limit)) {
         $limit = 20;
     }
     $perPage = $limit;
     $offset = ($pageNumber - 1) * $perPage;
     $count = $perPage * 2 + 1;
     // join the tables: watched_forum_thread, forum_thread, forum_post, site, user???. OK???
     $c = new Criteria();
     $c->addJoin("thread_id", "forum_thread.thread_id");
     $c->addJoin("thread_id", "watched_forum_thread.thread_id");
     $c->addJoin("user_id", "ozone_user.user_id");
     $c->add("watched_forum_thread.user_id", $user->getUserId());
     $c->addOrderDescending("post_id");
     $c->setLimit($count, $offset);
     $posts = DB_ForumPostPeer::instance()->select($c);
     $counted = count($posts);
     $pagerData = array();
     $pagerData['currentPage'] = $pageNumber;
     if ($counted > $perPage * 2) {
         $knownPages = $pageNumber + 2;
         $pagerData['knownPages'] = $knownPages;
     } elseif ($counted > $perPage) {
         $knownPages = $pageNumber + 1;
         $pagerData['totalPages'] = $knownPages;
     } else {
         $totalPages = $pageNumber;
         $pagerData['totalPages'] = $totalPages;
     }
     $posts = array_slice($posts, 0, $perPage);
     $runData->contextAdd("pagerData", $pagerData);
     $runData->contextAdd("posts", $posts);
 }
コード例 #7
0
 public function build($runData)
 {
     $pl = $runData->getParameterList();
     $postId = $pl->getParameterValue("postId", "AMODULE");
     $user = $runData->getUser();
     $site = $runData->getTemp("site");
     if ($postId == null || !is_numeric($postId)) {
         throw new ProcessException(_("No post specified."), "no_post");
     }
     $post = DB_ForumPostPeer::instance()->selectByPrimaryKey($postId);
     if ($post == null || $post->getSiteId() != $site->getSiteId()) {
         throw new ProcessException(_("No post specified."), "no_post");
     }
     $category = $post->getForumThread()->getCategory();
     WDPermissionManager::instance()->hasForumPermission('edit_post', $runData->getUser(), $category, null, $post);
     // check if thread blocked
     $thread = $post->getForumThread();
     if ($thread->getBlocked()) {
         // check if moderator or admin
         $c = new Criteria();
         $c->add("site_id", $site->getSiteId());
         $c->add("user_id", $user->getUserId());
         $rel = DB_ModeratorPeer::instance()->selectOne($c);
         if (!$rel || strpos($rel->getPermissions(), 'f') == false) {
             $rel = DB_AdminPeer::instance()->selectOne($c);
             if (!$rel) {
                 throw new WDPermissionException(_("Sorry, this thread is blocked. Nobody can add new posts nor edit existing ones."));
             }
         }
     }
     // OK for now...
     // keep the session - i.e. put an object into session storage not to delete it!!!
     $runData->sessionAdd("keep", true);
     $runData->contextAdd("post", $post);
     $runData->ajaxResponseAdd("postId", $postId);
     $userId = $runData->getUserId();
     if ($userId == null) {
         $userString = $runData->createIpString();
         $runData->contextAdd("anonymousString", $userString);
     }
 }
コード例 #8
0
 public function build($runData)
 {
     $pl = $runData->getParameterList();
     $postId = $pl->getParameterValue("postId");
     $site = $runData->getTemp("site");
     if ($postId == null || !is_numeric($postId)) {
         throw new ProcessException(_("No post specified."), "no_post");
     }
     $post = DB_ForumPostPeer::instance()->selectByPrimaryKey($postId);
     if ($post == null || $post->getSiteId() != $site->getSiteId()) {
         throw new ProcessException(_("No post specified."), "no_post");
     }
     // get all revisions
     $c = new Criteria();
     $c->add("post_id", $postId);
     $c->addOrderDescending("revision_id");
     $revs = DB_ForumPostRevisionPeer::instance()->select($c);
     $runData->contextAdd("revisions", $revs);
     $runData->contextAdd("post", $post);
     $runData->ajaxResponseAdd("postId", $postId);
 }
コード例 #9
0
ファイル: DB_ForumThread.php プロジェクト: jbzdak/wikidot
 public function getFirstPost()
 {
     $c = new Criteria();
     $c->add("thread_id", $this->getThreadId());
     $c->addOrderAscending("post_id");
     $post = DB_ForumPostPeer::instance()->selectOne($c);
     return $post;
 }
コード例 #10
0
 public function build($runData)
 {
     $site = $runData->getTemp("site");
     $page = $runData->getTemp("page");
     $pl = $runData->getParameterList();
     if ($page == null) {
         $pageId = $pl->getParameterValue("pageId");
         if ($pageId !== null && is_numeric($pageId)) {
             $page = DB_PagePeer::instance()->selectByPrimaryKey($pageId);
         } else {
             $pageName = $runData->getTemp("pageUnixName");
             $site = $runData->getTemp("site");
             $page = DB_PagePeer::instance()->selectByName($site->getSiteId(), $pageName);
         }
         if ($page == null || $page->getSiteId() !== $site->getSiteId()) {
             throw new ProcessException(_("Can not find related page."), "no_page");
         }
     }
     // check for a discussion thread. if not exists - create it!
     $c = new Criteria();
     $c->add("page_id", $page->getPageId());
     $c->add("site_id", $site->getSiteId());
     $thread = DB_ForumThreadPeer::instance()->selectOne($c);
     if ($thread == null) {
         // create thread!!!
         $c = new Criteria();
         $c->add("site_id", $site->getSiteId());
         $c->add("per_page_discussion", true);
         $category = DB_ForumCategoryPeer::instance()->selectOne($c);
         if ($category == null) {
             // create this category!
             $category = new DB_ForumCategory();
             $category->setName(_("Per page discussions"));
             $category->setDescription(_("This category groups discussions related to particular pages within this site."));
             $category->setPerPageDiscussion(true);
             $category->setSiteId($site->getSiteId());
             // choose group. create one?
             $c = new Criteria();
             $c->add("site_id", $site->getSiteId());
             $c->add("name", "Hidden");
             $group = DB_ForumGroupPeer::instance()->selectOne($c);
             if ($group == null) {
                 $group = new DB_ForumGroup();
                 $group->setName(_("Hidden"));
                 $group->setDescription(_("Hidden group used for storing some discussion threads."));
                 $group->setSiteId($site->getSiteId());
                 $group->setVisible(false);
                 $group->save();
             }
             $category->setGroupId($group->getGroupId());
             $category->save();
         }
         // now create thread...
         $thread = new DB_ForumThread();
         $thread->setCategoryId($category->getCategoryId());
         $thread->setSiteId($site->getSiteId());
         $thread->setPageId($page->getPageId());
         $thread->setUserId(-1);
         $thread->setDateStarted(new ODate());
         $thread->setNumberPosts(0);
         $thread->save();
         $page->setThreadId($thread->getThreadId());
         $page->save();
         $category->setNumberThreads($category->getNumberThreads() + 1);
         $category->save();
     } else {
         $category = $thread->getForumCategory();
     }
     $this->threadId = $thread->getThreadId();
     $c = new Criteria();
     $c->add("thread_id", $thread->getThreadId());
     $c->add("site_id", $site->getSiteId());
     $c->addJoin("user_id", "ozone_user.user_id");
     $c->addOrderAscending("post_id");
     $posts = DB_ForumPostPeer::instance()->select($c);
     // make a mapping first.
     $map = array();
     $levels = array();
     foreach ($posts as $post) {
         $parentId = $post->getParentId();
         $postId = $post->getPostId();
         if ($parentId === null) {
             // if no parrent - simply add at the end of $map
             $map[] = $postId;
             $levels[$postId] = 0;
         } else {
             // find a parent
             $cpos = array_search($parentId, $map);
             $clevel = $levels[$parentId];
             // find a place for the post, i.e. the place where level_next == level or the end of array
             $cpos++;
             while (isset($map[$cpos]) && $levels[$map[$cpos]] > $clevel) {
                 $cpos++;
             }
             // insert at this position!!!
             array_splice($map, $cpos, 0, $postId);
             $levels[$postId] = $clevel + 1;
         }
     }
     // create container control list
     $cc = array();
     foreach ($map as $pos => $m) {
         // open if previous post has LOWER level
         $clevel = $levels[$m];
         if (isset($map[$pos + 1])) {
             $nlevel = $levels[$map[$pos + 1]];
             if ($nlevel > $clevel) {
                 $cc[$pos] = 'k';
             }
             if ($nlevel < $clevel) {
                 $cc[$pos] = str_repeat('c', $clevel - $nlevel);
             }
         } else {
             $cc[$pos] = str_repeat('c', $clevel);
         }
     }
     $runData->contextAdd("postmap", $map);
     $runData->contextAdd("levels", $levels);
     $runData->contextAdd("containerControl", $cc);
     $runData->contextAdd("thread", $thread);
     $runData->contextAdd("category", $category);
     $runData->contextAdd("posts", $posts);
     $runData->ajaxResponseAdd("threadId", $thread->getThreadId());
 }
コード例 #11
0
 public function build($runData)
 {
     $site = $runData->getTemp("site");
     $pl = $runData->getParameterList();
     $categoryId = $pl->getParameterValue("c");
     $category = DB_ForumCategoryPeer::instance()->selectByPrimaryKey($categoryId);
     if ($category == null) {
         throw new ProcessException("No such category.", "no_category");
     }
     $channel = array();
     $channel['title'] = $category->getName() . " (" . _('new posts') . ")";
     $channel['link'] = "http://" . $site->getDomain() . "/forum/c-" . $categoryId . "/" . $category->getUnixifiedName();
     $channel['description'] = _("Posts in the forum category") . " \"" . $category->getName() . "\"";
     if ($category->getDescription()) {
         $channel['description'] .= " - " . $category->getDescription();
     }
     $items = array();
     $c = new Criteria();
     $c->add("category_id", $categoryId);
     $c->add("forum_post.site_id", $site->getSiteId());
     $c->addJoin("thread_id", "forum_thread.thread_id");
     $c->addJoin("user_id", "ozone_user.user_id");
     $c->addOrderDescending("post_id");
     $c->setLimit(20);
     $posts = DB_ForumPostPeer::instance()->select($c);
     foreach ($posts as $post) {
         $item = array();
         $thread = $post->getForumThread();
         $item['title'] = $thread->getTitle() . ': ' . $post->getTitle();
         $item['link'] = "http://" . $site->getDomain() . "/forum/t-" . $thread->getThreadId() . '/' . $thread->getUnixifiedTitle() . '#post-' . $post->getPostId();
         $item['guid'] = "http://" . $site->getDomain() . "/forum/t-" . $thread->getThreadId() . '#post-' . $post->getPostId();
         $item['date'] = date('r', $post->getDatePosted()->getTimestamp());
         // TODO: replace relative links with absolute links!
         $content = $post->getText();
         $content = preg_replace(';(<.*?)(src|href)="/([^"]+)"([^>]*>);si', '\\1\\2="http://' . $site->getDomain() . '/\\3"\\4', $content);
         $content = preg_replace(';<script\\s+[^>]+>.*?</script>;is', '', $content);
         $content = preg_replace(';(<[^>]*\\s+)on[a-z]+="[^"]+"([^>]*>);si', '\\1 \\2', $content);
         $item['content'] = $content;
         if ($post->getUserId() > 0) {
             $item['authorUserId'] = $post->getUserId();
             $user = $post->getUser();
             $item['author'] = $user->getNickName();
         } else {
             $item['author'] = $post->getUserString();
         }
         $items[] = $item;
     }
     $runData->contextAdd("channel", $channel);
     $runData->contextAdd("items", $items);
 }
コード例 #12
0
ファイル: Indexer.php プロジェクト: jbzdak/wikidot
 public function indexThread($thread)
 {
     // look for an existing fts_entry
     $ie = DB_FtsEntryPeer::instance()->selectByThreadId($thread->getThreadId());
     if (!$ie) {
         $ie = new DB_FtsEntry();
         $ie->setThreadId($thread->getThreadId());
         $ie->setSiteId($thread->getSiteId());
     }
     $ie->setTitle(htmlspecialchars($thread->getTitle()));
     $ie->setUnixName($thread->getUnixifiedTitle());
     // to create thread text select all posts and extract body
     $c = new Criteria();
     $c->add("thread_id", $thread->getThreadId());
     $c->addOrderAscending("post_id");
     $posts = DB_ForumPostPeer::instance()->select($c);
     $text = '';
     foreach ($posts as $post) {
         $text .= $post->getTitle() . "\n";
         $text .= strip_tags($post->getText()) . "\n\n";
     }
     $ie->setText(htmlspecialchars($thread->getDescription()) . "\n\n" . $text);
     $title = db_escape_string(htmlspecialchars($thread->getTitle()));
     $description = db_escape_string(htmlspecialchars($thread->getDescription()));
     $db = Database::connection();
     $v = pg_version($db->getLink());
     if (!preg_match(';^8\\.3;', $v['server'])) {
         $db->query("SELECT set_curcfg('default')");
     }
     $ie->setVector("setweight( to_tsvector('{$title}'), 'C') || setweight( to_tsvector('{$description}'), 'C') || to_tsvector('" . db_escape_string($text) . "')", true);
     $ie->save();
 }
コード例 #13
0
 public function build($runData)
 {
     $pl = $runData->getParameterList();
     $postId = $pl->getParameterValue("postId");
     $threadId = $pl->getParameterValue("threadId");
     $user = $runData->getUser();
     $site = $runData->getTemp("site");
     $title = '';
     $db = Database::connection();
     $db->begin();
     $thread = DB_ForumThreadPeer::instance()->selectByPrimaryKey($threadId);
     if ($thread == null || $thread->getSiteId() !== $site->getSiteId()) {
         throw new ProcessException(_("No thread found... Is it deleted?"), "no_thread");
     }
     // check if thread blocked
     if ($thread->getBlocked()) {
         // check if moderator or admin
         if ($runData->getUser()) {
             $c = new Criteria();
             $c->add("site_id", $site->getSiteId());
             $c->add("user_id", $user->getUserId());
             $rel = DB_ModeratorPeer::instance()->selectOne($c);
         }
         if (!$rel || strpos($rel->getPermissions(), 'f') == false) {
             $rel = DB_AdminPeer::instance()->selectOne($c);
             if (!$rel) {
                 throw new WDPermissionException(_("Sorry, this thread is blocked. Nobody can add new posts nor edit existing ones."));
             }
         }
     }
     // now check if user is allowed
     $category = $thread->getCategory();
     WDPermissionManager::instance()->hasForumPermission('new_post', $runData->getUser(), $category);
     if ($postId !== null && is_numeric($postId)) {
         $post = DB_ForumPostPeer::instance()->selectByPrimaryKey($postId);
         if ($post == null || $post->getThreadId() !== $thread->getThreadId()) {
             throw new ProcessException(_("Original post does not exist! Please reload the page to make it up-to-date."), "no_post");
         }
         // try to  determine true parent id based on the nesting level.
         // TODO!
         $maxNest = $thread->getForumCategory()->getEffectiveMaxNestLevel();
         // now check the nest level of the post... woooo...
         $parentId6 = $post->getParentId();
         $nestLevel6 = 0;
         $parents = array();
         while ($parentId6 != null) {
             $parent6 = DB_ForumPostPeer::instance()->selectByPrimaryKey($parentId6);
             $parents[] = $parent6;
             $parentId6 = $parent6->getParentId();
             $nestLevel6++;
         }
         if ($nestLevel6 >= $maxNest) {
             // change parent id to the maxNest-1 in the chain
             $parent = $parents[$nestLevel6 - ($maxNest - 1) - 1];
             if ($parent) {
                 $parentId = $parent->getPostId();
                 $parentChanged = true;
             }
         } else {
             $parentId = $post->getPostId();
         }
         $title = preg_replace('/^Re:\\s?/', '', $post->getTitle());
         $title = 'Re: ' . $title;
     } else {
         // only if NOT a page discussion
         if ($thread->getPageId() == null) {
             $title = 'Re: ' . $thread->getTitle();
         }
     }
     $runData->contextAdd("thread", $thread);
     if ($parentId) {
         $runData->ajaxResponseAdd("parentId", $parentId);
         $runData->contextAdd("parentId", $parentId);
         if ($parentChanged) {
             $runData->ajaxResponseAdd("parentChanged", true);
         }
     }
     $runData->contextAdd("title", $title);
     // keep the session - i.e. put an object into session storage not to delete it!!!
     $runData->sessionAdd("keep", true);
     $userId = $runData->getUserId();
     if ($userId == null) {
         $userString = $runData->createIpString();
         $runData->contextAdd("anonymousString", $userString);
     }
     $db->commit();
 }
コード例 #14
0
ファイル: ForumPostsFeed.php プロジェクト: jbzdak/wikidot
 public function build($runData)
 {
     $site = $runData->getTemp("site");
     $pl = $runData->getParameterList();
     $categoryId = $pl->getParameterValue("c");
     $channel = array();
     $channel['title'] = $site->getName() . " - " . _("new forum posts");
     $channel['link'] = "http://" . $site->getDomain() . "/forum/start";
     $channel['description'] = _("Posts in forums of the site") . " \"" . $site->getName() . "\"";
     if ($site->getSubtitle()) {
         $channel['description'] .= " - " . $site->getSubtitle();
     }
     $items = array();
     $c = new Criteria();
     $c->add("forum_post.site_id", $site->getSiteId());
     $c->add("forum_group.visible", true);
     $c->addJoin("thread_id", "forum_thread.thread_id");
     $c->addJoin("user_id", "ozone_user.user_id");
     $c->addJoin("forum_thread.category_id", "forum_category.category_id");
     $c->addJoin("forum_category.group_id", "forum_group.group_id");
     $c->addOrderDescending("post_id");
     $c->setLimit(20);
     $posts = DB_ForumPostPeer::instance()->select($c);
     foreach ($posts as $post) {
         $item = array();
         $thread = $post->getForumThread();
         $item['title'] = $post->getTitle();
         $item['link'] = "http://" . $site->getDomain() . "/forum/t-" . $thread->getThreadId() . '/' . $thread->getUnixifiedTitle() . '#post-' . $post->getPostId();
         $item['guid'] = "http://" . $site->getDomain() . "/forum/t-" . $thread->getThreadId() . '#post-' . $post->getPostId();
         $item['date'] = date('r', $post->getDatePosted()->getTimestamp());
         // TODO: replace relative links with absolute links!
         $content = $post->getText();
         $content = preg_replace(';(<.*?)(src|href)="/([^"]+)"([^>]*>);si', '\\1\\2="http://' . $site->getDomain() . '/\\3"\\4', $content);
         $content = preg_replace(';<script\\s+[^>]+>.*?</script>;is', '', $content);
         $content = preg_replace(';(<[^>]*\\s+)on[a-z]+="[^"]+"([^>]*>);si', '\\1 \\2', $content);
         // add extra info.
         $content .= '<br/>';
         $fcategory = $thread->getForumCategory();
         $content .= _('Forum category') . ': <a href="http://' . $site->getDomain() . '/forum/c-' . $thread->getCategoryId() . '">' . htmlspecialchars($fcategory->getForumGroup()->getName() . ' / ' . $fcategory->getName()) . '</a><br/>';
         $content .= _('Forum thread') . ': <a href="http://' . $site->getDomain() . '/forum/t-' . $thread->getThreadId() . '/' . $thread->getUnixifiedTitle() . '">' . htmlspecialchars($thread->getTitle()) . '</a>';
         $item['content'] = $content;
         if ($post->getUserId() > 0) {
             $item['authorUserId'] = $post->getUserId();
             $user = $post->getUser();
             $item['author'] = $user->getNickName();
         } else {
             $item['author'] = $post->getUserString();
         }
         $items[] = $item;
     }
     $runData->contextAdd("channel", $channel);
     $runData->contextAdd("items", $items);
 }
コード例 #15
0
 public function build($runData)
 {
     $site = $runData->getTemp("site");
     $pl = $runData->getParameterList();
     $threadId = $pl->getParameterValue("t");
     if ($threadId == null || !is_numeric($threadId)) {
         throw new ProcessException(_("Invalid thread."), "invalid_thread");
     }
     $c = new Criteria();
     $c->add("thread_id", $threadId);
     $c->add("site_id", $site->getSiteId());
     $thread = DB_ForumThreadPeer::instance()->selectOne($c);
     if ($thread == null) {
         throw new ProcessException(_("No thread."), "no_thread");
     }
     $this->threadTitle = $thread->getTitle();
     $this->threadId = $thread->getThreadId();
     $category = $thread->getForumCategory();
     $this->categoryName = $category->getName();
     // check if connected to a page
     $this->tpage = $thread->getPage();
     // get posts
     $c = new Criteria();
     $c->add("thread_id", $threadId);
     $c->add("site_id", $site->getSiteId());
     $c->addJoin("user_id", "ozone_user.user_id");
     $c->addOrderAscending("post_id");
     $posts = DB_ForumPostPeer::instance()->select($c);
     // make a mapping first.
     $map = array();
     $levels = array();
     foreach ($posts as $post) {
         $parentId = $post->getParentId();
         $postId = $post->getPostId();
         if ($parentId === null) {
             // if no parrent - simply add at the end of $map
             $map[] = $postId;
             $levels[$postId] = 0;
         } else {
             // find a parent
             $cpos = array_search($parentId, $map);
             $clevel = $levels[$parentId];
             // find a place for the post, i.e. the place where level_next == level or the end of array
             $cpos++;
             while (isset($map[$cpos]) && $levels[$map[$cpos]] > $clevel) {
                 $cpos++;
             }
             // insert at this position!!!
             array_splice($map, $cpos, 0, $postId);
             $levels[$postId] = $clevel + 1;
         }
     }
     // create container control list
     $cc = array();
     foreach ($map as $pos => $m) {
         // open if previous post has LOWER level
         $clevel = $levels[$m];
         if (isset($map[$pos + 1])) {
             $nlevel = $levels[$map[$pos + 1]];
             if ($nlevel > $clevel) {
                 $cc[$pos] = 'k';
             }
             if ($nlevel < $clevel) {
                 $cc[$pos] = str_repeat('c', $clevel - $nlevel);
             }
         } else {
             $cc[$pos] = str_repeat('c', $clevel);
         }
     }
     $runData->contextAdd("postmap", $map);
     $runData->contextAdd("levels", $levels);
     $runData->contextAdd("containerControl", $cc);
     $runData->contextAdd("thread", $thread);
     $runData->contextAdd("category", $category);
     $runData->contextAdd("posts", $posts);
     $page = $GLOBALS['page'];
 }
コード例 #16
0
ファイル: PageCommentsFeed.php プロジェクト: jbzdak/wikidot
 public function build($runData)
 {
     $site = $runData->getTemp("site");
     $pl = $runData->getParameterList();
     $pageId = $pl->getParameterValue("p");
     $page = DB_PagePeer::instance()->selectByPrimaryKey($pageId);
     $threadId = $page->getThreadId();
     $thread = DB_ForumThreadPeer::instance()->selectByPrimaryKey($threadId);
     if ($thread == null) {
         throw new ProcessException("No such thread.", "no_thread");
     }
     $this->threadId = $thread->getThreadId();
     $channel = array();
     $channel['title'] = _('Comments for page') . ' "' . $page->getTitleOrUnixName() . '"';
     $channel['link'] = "http://" . $site->getDomain() . "/" . $page->getUnixName() . "/comments/show";
     $items = array();
     $c = new Criteria();
     $c->add("thread_id", $threadId);
     $c->add("forum_post.site_id", $site->getSiteId());
     $c->addJoin("user_id", "ozone_user.user_id");
     $c->addOrderDescending("post_id");
     $c->setLimit(20);
     $posts = DB_ForumPostPeer::instance()->select($c);
     foreach ($posts as $post) {
         $item = array();
         if ($post->getTitle() != '') {
             $item['title'] = $post->getTitle();
         } else {
             $item['title'] = "(no title)";
         }
         $item['link'] = $channel['link'] . '#post-' . $post->getPostId();
         $item['guid'] = $item['link'];
         $item['date'] = date('r', $post->getDatePosted()->getTimestamp());
         // TODO: replace relative links with absolute links!
         $content = $post->getText();
         $content = preg_replace(';(<.*?)(src|href)="/([^"]+)"([^>]*>);si', '\\1\\2="http://' . $site->getDomain() . '/\\3"\\4', $content);
         $content = preg_replace(';<script\\s+[^>]+>.*?</script>;is', '', $content);
         $content = preg_replace(';(<[^>]*\\s+)on[a-z]+="[^"]+"([^>]*>);si', '\\1 \\2', $content);
         $item['content'] = $content;
         if ($post->getUserId() > 0) {
             $item['authorUserId'] = $post->getUserId();
             $user = $post->getUser();
             $item['author'] = $user->getNickName();
         } else {
             $item['author'] = $post->getUserString();
         }
         $items[] = $item;
     }
     $runData->contextAdd("channel", $channel);
     $runData->contextAdd("items", $items);
 }
コード例 #17
0
 public function build($runData)
 {
     $user = $runData->getTemp("user");
     $userId = $user->getUserId();
     // set language for the user
     $lang = $user->getLanguage();
     $runData->setLanguage($lang);
     $GLOBALS['lang'] = $lang;
     // and for gettext too:
     switch ($lang) {
         case 'pl':
             $glang = "pl_PL";
             break;
         case 'en':
             $glang = "en_US";
             break;
     }
     putenv("LANG={$glang}");
     putenv("LANGUAGE={$glang}");
     setlocale(LC_ALL, $glang . '.UTF-8');
     // now just get watched page changes for the user...
     $c = new Criteria();
     $c->addJoin("thread_id", "forum_thread.thread_id");
     $c->addJoin("thread_id", "watched_forum_thread.thread_id");
     $c->addJoin("user_id", "ozone_user.user_id");
     $c->add("watched_forum_thread.user_id", $user->getUserId());
     $c->addOrderDescending("post_id");
     $c->setLimit(30);
     $posts = DB_ForumPostPeer::instance()->select($c);
     $channel['title'] = _('Wikidot.com watched forum discussions for user') . ' "' . $user->getNickName() . '"';
     $channel['link'] = "http://" . GlobalProperties::$URL_HOST . "/account:you/start/watched-forum";
     $items = array();
     foreach ($posts as $post) {
         $thread = $post->getForumThread();
         $site = $post->getSite();
         $item = array();
         $item['title'] = $post->getTitle() . ' (' . _('on site') . ' "' . htmlspecialchars($site->getName()) . '")';
         $item['link'] = "http://" . $site->getDomain() . "/forum/t-" . $thread->getThreadId() . '/' . $thread->getUnixifiedTitle() . '#post-' . $post->getPostId();
         $item['guid'] = "http://" . $site->getDomain() . "/forum/t-" . $thread->getThreadId() . '#post-' . $post->getPostId();
         $item['date'] = date('r', $post->getDatePosted()->getTimestamp());
         $content = $post->getText();
         $content = preg_replace(';(<.*?)(src|href)="/([^"]+)"([^>]*>);si', '\\1\\2="http://' . $site->getDomain() . '/\\3"\\4', $content);
         $content = preg_replace(';<script\\s+[^>]+>.*?</script>;is', '', $content);
         $content = preg_replace(';(<[^>]*\\s+)on[a-z]+="[^"]+"([^>]*>);si', '\\1 \\2', $content);
         // add extra info.
         $content .= '<br/><hr/>';
         $content .= _('Site') . ': <a href="http://' . $site->getDomain() . '">' . htmlspecialchars($site->getName()) . '</a><br/>';
         $content .= _('Forum category') . ': <a href="http://' . $site->getDomain() . '/forum/c-' . $thread->getCategoryId() . '">' . htmlspecialchars($thread->getForumCategory()->getName()) . '</a><br/>';
         $content .= _('Forum thread') . ': <a href="http://' . $site->getDomain() . '/forum/t-' . $thread->getThreadId() . '/' . $thread->getUnixifiedTitle() . '">' . htmlspecialchars($thread->getTitle()) . '</a><br/>';
         $content .= _('Author of the post') . ': ' . WDRenderUtils::renderUser($post->getUserOrString()) . '<br/>';
         $item['content'] = $content;
         if ($post->getUserId() > 0) {
             $item['authorUserId'] = $post->getUserId();
             $user = $post->getUser();
             $item['author'] = $user->getNickName();
         } else {
             $item['author'] = $post->getUserString();
         }
         $items[] = $item;
     }
     $runData->contextAdd("channel", $channel);
     $runData->contextAdd("items", $items);
 }
コード例 #18
0
ファイル: ForumAction.php プロジェクト: jbzdak/wikidot
 public function deletePostEvent($runData)
 {
     $pl = $runData->getParameterList();
     $site = $runData->getTemp("site");
     $postId = $pl->getParameterValue("postId");
     if ($postId == null || !is_numeric($postId)) {
         throw new ProcessException(_("No such post."), "no_post");
     }
     $db = Database::connection();
     $db->begin();
     $post = DB_ForumPostPeer::instance()->selectByPrimaryKey($postId);
     if ($post == null || $post->getSiteId() != $site->getSiteId()) {
         throw new ProcessException(_("No such post."), "no_post");
     }
     $thread = $post->getForumThread();
     $category = $thread->getForumCategory();
     try {
         WDPermissionManager::instance()->hasForumPermission('moderate_forum', $runData->getUser(), $category);
     } catch (Exception $e) {
         throw new WDPermissionException(_("Sorry, you are not allowed to delete posts. Only site administrators and moderators are the ones who can."));
     }
     $c = new Criteria();
     $c->add("parent_id", $postId);
     $toDelete = array();
     $chposts = DB_ForumPostPeer::instance()->select($c);
     while ($chposts && count($chposts) > 0) {
         $toDelete = array_merge($toDelete, $chposts);
         $c = new Criteria();
         foreach ($chposts as $f) {
             $c->addOr("parent_id", $f->getPostId());
         }
         $chposts = DB_ForumPostPeer::instance()->select($c);
     }
     DB_ForumPostPeer::instance()->deleteByPrimaryKey($post->getPostId());
     foreach ($toDelete as $f) {
         DB_ForumPostPeer::instance()->deleteByPrimaryKey($f->getPostId());
     }
     // now recalculate a few things...
     $thread->calculateNumberPosts();
     $thread->findLastPost();
     $thread->save();
     $category->calculateNumberPosts();
     $category->findLastPost();
     $category->save();
     // outdate
     $o = new Outdater();
     $o->forumEvent("thread_save", $thread);
     // index thread
     Indexer::instance()->indexThread($thread);
     EventLogger::instance()->logPostDelete($thread, $post->getTitle());
     $db->commit();
     if (GlobalProperties::$UI_SLEEP) {
         sleep(1);
     }
 }