public function isUserAllowedToDeactivateNotification()
{
if ($this->objProperties->getNotificationType() == 'default') {
return true;
}
if ($this->objProperties->isUserToggleNoti() == 0) {
return true;
}
if ($this->isParentObjectCrsOrGrp()) {
}
global $ilUser;
include_once 'Modules/Forum/classes/class.ilForumNotification.php';
$frm_noti = new ilForumNotification((int) $_GET['ref_id']);
$frm_noti->setUserId($ilUser->getId());
$user_toggle = (int) $frm_noti->isUserToggleNotification();
if ($user_toggle == 0) {
return true;
}
return false;
}
public static function checkForumsExistsInsert($ref_id, $user_id = 0)
{
global $ilUser;
include_once 'Modules/Forum/classes/class.ilForumProperties.php';
$node_data = self::getCachedNodeData($ref_id);
foreach ($node_data as $data) {
//check frm_properties if frm_noti is enabled
$frm_noti = new ilForumNotification($data['ref_id']);
if ($user_id != 0) {
$frm_noti->setUserId($user_id);
} else {
$frm_noti->setUserId($ilUser->getId());
}
$admin_force = ilForumProperties::_isAdminForceNoti($data['obj_id']);
$frm_noti->setAdminForce($admin_force);
$user_toggle = ilForumProperties::_isUserToggleNoti($data['obj_id']);
if ($user_toggle) {
$frm_noti->setAdminForce(1);
}
if ($admin_force == 1 || $user_toggle == 1) {
$frm_noti->setUserToggle($user_toggle);
$frm_noti->setForumId($data['obj_id']);
if ($frm_noti->existsNotification() == false) {
$frm_noti->insertAdminForce();
}
}
}
}
public function getNestedSetPostChildren($pos_id = null, $expandedNodes = array())
{
global $ilUser;
$data = null;
$objProperties = ilForumProperties::getInstance($this->getFrmObjId());
$is_post_activation_enabled = $objProperties->isPostActivationEnabled();
if ($pos_id !== null) {
$res = $this->db->queryF("\n\t\t\t\tSELECT\t\tlft, rgt\n\t\t\t\tFROM\t\tfrm_posts_tree\n\t\t\t\tWHERE\t\tpos_fk = %s\n\t\t\t\tAND\t\t\tthr_fk = %s", array('integer', 'integer'), array($pos_id, $this->id));
$data = $this->db->fetchAssoc($res);
}
$query = '
SELECT fpt.depth,
fpt.rgt,
fpt.parent_pos,
fp.pos_pk,
fp.pos_subject,
fp.pos_usr_alias,
fp.pos_date,
fp.pos_update,
fp.pos_status,
fp.pos_display_user_id,
fp.pos_usr_alias,
fp.import_name,
fp.pos_author_id,
fp.is_author_moderator,
fur.post_id,
(CASE
WHEN fur.post_id IS NULL ' . ($ilUser->getId() == ANONYMOUS_USER_ID ? ' AND 1 = 2 ' : '') . '
THEN 0
ELSE 1
END) post_read,
COUNT(fpt2.pos_fk) children
FROM frm_posts_tree fpt
INNER JOIN frm_posts fp
ON fp.pos_pk = fpt.pos_fk
LEFT JOIN frm_posts_tree fpt2
ON fpt2.lft BETWEEN fpt.lft AND fpt.rgt
AND fpt.thr_fk = fpt2.thr_fk
AND fpt.pos_fk != fpt2.pos_fk ';
$query .= '
LEFT JOIN frm_user_read fur
ON fur.thread_id = fp.pos_thr_fk
AND fur.post_id = fp.pos_pk
AND fur.usr_id = ' . $this->db->quote($ilUser->getId(), 'integer') . '
LEFT JOIN usr_data ud
ON ud.usr_id = fp.pos_display_user_id
WHERE fpt.thr_fk = ' . $this->db->quote($this->id, 'integer');
if ($data) {
$query .= ' AND fpt.lft > ' . $this->db->quote($data['lft'], 'integer') . ' AND fpt.lft < ' . $this->db->quote($data['rgt'], 'integer') . ' ';
}
if ($is_post_activation_enabled && !$this->is_moderator) {
$query .= ' AND (fp.pos_status = 1 OR fp.pos_status = 0 AND fp.pos_display_user_id = ' . $this->db->quote($ilUser->getId(), 'integer') . ') ';
}
if ($expandedNodes) {
$query .= ' AND ' . $this->db->in('fpt.parent_pos', $expandedNodes, false, 'integer') . ' ';
}
$query .= ' GROUP BY fpt.depth,
fpt.rgt,
fpt.parent_pos,
fp.pos_pk,
fp.pos_subject,
fp.pos_usr_alias,
fp.pos_date,
fp.pos_update,
fp.pos_status,
fp.pos_display_user_id,
fp.pos_usr_alias,
fp.import_name,
fp.pos_author_id,
fp.is_author_moderator,
fur.post_id
ORDER BY fpt.rgt DESC
';
$queryCounter = '
SELECT pos_fk
FROM frm_posts_tree fpt
INNER JOIN frm_posts fp
ON fp.pos_pk = fpt.pos_fk
WHERE fpt.thr_fk = ' . $this->db->quote($this->id, 'integer');
if ($is_post_activation_enabled && !$this->is_moderator) {
$queryCounter .= ' AND (fp.pos_status = 1 OR fp.pos_status = 0 AND fp.pos_display_user_id = ' . $this->db->quote($ilUser->getId(), 'integer') . ') ';
}
$queryCounter .= ' ORDER BY fpt.rgt DESC';
$resCounter = $this->db->query($queryCounter);
$counter = array();
$i = 0;
while ($row = $this->db->fetchAssoc($resCounter)) {
$counter[$row['pos_fk']] = $i++;
}
$res = $this->db->query($query);
$children = array();
$usr_ids = array();
while ($row = $this->db->fetchAssoc($res)) {
if ((int) $row['pos_display_user_id']) {
$usr_ids[] = (int) $row['pos_display_user_id'];
}
$row['counter'] = $counter[$row['pos_pk']];
$children[] = $row;
}
require_once 'Modules/Forum/classes/class.ilForumAuthorInformationCache.php';
ilForumAuthorInformationCache::preloadUserObjects(array_unique($usr_ids));
return $children;
}
/**
* @return array
*/
public function getProperties()
{
/**
* @var $lng ilLanguage
* @var $ilUser ilObjUser
* @var $ilAccess ilAccessHandler
*/
global $lng, $ilUser, $ilAccess;
if (!$ilAccess->checkAccess('read', '', $this->ref_id)) {
return array();
}
$lng->loadLanguageModule('forum');
$props = array();
include_once 'Modules/Forum/classes/class.ilObjForumAccess.php';
$properties = ilObjForumAccess::getStatisticsByRefId($this->ref_id);
$num_posts_total = $properties['num_posts'];
$num_unread_total = $properties['num_unread_posts'];
$num_new_total = $properties['num_new_posts'];
$last_post = ilObjForumAccess::getLastPostByRefId($this->ref_id);
if (!$ilUser->isAnonymous()) {
if ($this->getDetailsLevel() == ilObjectListGUI::DETAILS_ALL) {
$alert = $num_unread_total > 0 ? true : false;
$props[] = array('alert' => $alert, 'property' => $lng->txt('forums_articles') . ' (' . $lng->txt('unread') . ')', 'value' => $num_posts_total . ' (' . $num_unread_total . ')');
// New
$alert = $num_new_total > 0 ? true : false;
$props[] = array('alert' => $alert, 'property' => $lng->txt('forums_new_articles'), 'value' => $num_new_total);
}
} else {
$props[] = array('alert' => false, 'property' => $lng->txt('forums_articles'), 'value' => $num_posts_total);
}
include_once 'Modules/Forum/classes/class.ilForumProperties.php';
if ($this->getDetailsLevel() == ilObjectListGUI::DETAILS_ALL) {
if (ilForumProperties::getInstance($this->obj_id)->isAnonymized()) {
$props[] = array('alert' => false, 'newline' => false, 'property' => $lng->txt('forums_anonymized'), 'value' => $lng->txt('yes'));
}
}
// Last Post
if ((int) $last_post['pos_pk']) {
$lpCont = "<a class=\"il_ItemProperty\" target=\"" . ilFrameTargetInfo::_getFrame('MainContent') . "\" href=\"ilias.php?baseClass=ilRepositoryGUI&cmd=viewThread&cmdClass=ilobjforumgui&target=true&pos_pk=" . $last_post['pos_pk'] . "&thr_pk=" . $last_post['pos_thr_fk'] . "&ref_id=" . $this->ref_id . "#" . $last_post["pos_pk"] . "\">" . ilObjForumAccess::prepareMessageForLists($last_post['pos_message']) . "</a> " . strtolower($lng->txt('from')) . " ";
require_once 'Modules/Forum/classes/class.ilForumAuthorInformation.php';
$authorinfo = new ilForumAuthorInformation($last_post['pos_usr_id'], $last_post['pos_usr_alias'], $last_post['import_name'], array('class' => 'il_ItemProperty', 'href' => 'ilias.php?baseClass=ilRepositoryGUI&cmd=showUser&cmdClass=ilobjforumgui&ref_id=' . $this->ref_id . '&user='******'pos_usr_id'] . '&offset=0&backurl=' . urlencode('ilias.php?baseClass=ilRepositoryGUI&ref_id=' . $_GET['ref_id'])));
$lpCont .= $authorinfo->getLinkedAuthorName();
$lpCont .= ', ' . ilDatePresentation::formatDate(new ilDateTime($last_post['pos_date'], IL_CAL_DATETIME));
$props[] = array('alert' => false, 'newline' => true, 'property' => $lng->txt('forums_last_post'), 'value' => $lpCont);
}
return $props;
}
/**
* Clone Object
* @param int $a_target_id
* @param int $a_copy_id
* @return object
*/
public function cloneObject($a_target_id, $a_copy_id = 0)
{
/**
* @var $ilDB ilDB
*/
global $ilDB;
$new_obj = parent::cloneObject($a_target_id, $a_copy_id);
$this->cloneAutoGeneratedRoles($new_obj);
ilForumProperties::getInstance($this->getId())->copy($new_obj->getId());
$this->Forum->setMDB2WhereCondition('top_frm_fk = %s ', array('integer'), array($this->getId()));
$topData = $this->Forum->getOneTopic();
$nextId = $ilDB->nextId('frm_data');
$statement = $ilDB->insert('frm_data', array('top_pk' => array('integer', $nextId), 'top_frm_fk' => array('integer', $new_obj->getId()), 'top_name' => array('text', $topData['top_name']), 'top_description' => array('text', $topData['top_description']), 'top_num_posts' => array('integer', $topData['top_num_posts']), 'top_num_threads' => array('integer', $topData['top_num_threads']), 'top_last_post' => array('text', $topData['top_last_post']), 'top_mods' => array('integer', !is_numeric($topData['top_mods']) ? 0 : $topData['top_mods']), 'top_date' => array('timestamp', $topData['top_date']), 'visits' => array('integer', $topData['visits']), 'top_update' => array('timestamp', $topData['top_update']), 'update_user' => array('integer', $topData['update_user']), 'top_usr_id' => array('integer', $topData['top_usr_id'])));
// read options
include_once 'Services/CopyWizard/classes/class.ilCopyWizardOptions.php';
$cwo = ilCopyWizardOptions::_getInstance($a_copy_id);
$options = $cwo->getOptions($this->getRefId());
$options['threads'] = $this->Forum->_getThreads($this->getId());
// Generate starting threads
include_once 'Modules/Forum/classes/class.ilFileDataForum.php';
$new_frm = $new_obj->Forum;
$new_frm->setMDB2WhereCondition('top_frm_fk = %s ', array('integer'), array($new_obj->getId()));
$new_frm->setForumId($new_obj->getId());
$new_frm->setForumRefId($new_obj->getRefId());
$new_topic = $new_frm->getOneTopic();
foreach ($options['threads'] as $thread_id => $thread_subject) {
$this->Forum->setMDB2WhereCondition('thr_pk = %s ', array('integer'), array($thread_id));
$old_thread = $this->Forum->getOneThread();
$old_post_id = $this->Forum->getFirstPostByThread($old_thread['thr_pk']);
$old_post = $this->Forum->getOnePost($old_post_id);
// Now create new thread and first post
$new_post = $new_frm->generateThread($new_topic['top_pk'], $old_thread['thr_usr_id'], $old_thread['thr_subject'], ilForum::_lookupPostMessage($old_post_id), $old_post['notify'], 0, $old_thread['thr_usr_alias'], $old_thread['thr_date']);
// Copy attachments
$old_forum_files = new ilFileDataForum($this->getId(), $old_post_id);
$old_forum_files->ilClone($new_obj->getId(), $new_post);
}
return $new_obj;
}
/**
* Standard Version of Fill Row. Most likely to
* be overwritten by derived class.
*/
protected function fillRow($a_set)
{
global $lng, $ilCtrl;
$news_set = new ilSetting("news");
$enable_internal_rss = $news_set->get("enable_rss_for_internal");
// context
$obj_id = ilObject::_lookupObjId($a_set["ref_id"]);
$obj_type = ilObject::_lookupType($obj_id);
$obj_title = ilObject::_lookupTitle($obj_id);
// user
if ($a_set["user_id"] > 0) {
$this->tpl->setCurrentBlock("user_info");
if ($obj_type == "frm") {
include_once "./Modules/Forum/classes/class.ilForumProperties.php";
if (ilForumProperties::_isAnonymized($a_set["context_obj_id"])) {
if ($a_set["context_sub_obj_type"] == "pos" && $a_set["context_sub_obj_id"] > 0) {
include_once "./Modules/Forum/classes/class.ilForumPost.php";
$post = new ilForumPost($a_set["context_sub_obj_id"]);
if ($post->getUserAlias() != "") {
$this->tpl->setVariable("VAL_AUTHOR", ilUtil::stripSlashes($post->getUserAlias()));
} else {
$this->tpl->setVariable("VAL_AUTHOR", $lng->txt("forums_anonymous"));
}
} else {
$this->tpl->setVariable("VAL_AUTHOR", $lng->txt("forums_anonymous"));
}
} else {
if (ilObject::_exists($a_set["user_id"])) {
$user_obj = new ilObjUser($a_set["user_id"]);
$this->tpl->setVariable("VAL_AUTHOR", $user_obj->getLogin());
}
}
} else {
if (ilObject::_exists($a_set["user_id"])) {
$user_obj = new ilObjUser($a_set["user_id"]);
$this->tpl->setVariable("VAL_AUTHOR", $user_obj->getLogin());
}
}
$this->tpl->setVariable("TXT_AUTHOR", $lng->txt("author"));
$this->tpl->parseCurrentBlock();
}
// media player
if ($a_set["content_type"] == NEWS_AUDIO && $a_set["mob_id"] > 0 && ilObject::_exists($a_set["mob_id"])) {
include_once "./Services/MediaObjects/classes/class.ilObjMediaObject.php";
include_once "./Services/MediaObjects/classes/class.ilMediaPlayerGUI.php";
$mob = new ilObjMediaObject($a_set["mob_id"]);
$med = $mob->getMediaItem("Standard");
$mpl = new ilMediaPlayerGUI();
$mpl->setFile(ilObjMediaObject::_getDirectory($a_set["mob_id"]) . "/" . $med->getLocation());
$this->tpl->setCurrentBlock("player");
$this->tpl->setVariable("PLAYER", $mpl->getMp3PlayerHtml());
$this->tpl->parseCurrentBlock();
}
// access
if ($enable_internal_rss) {
$this->tpl->setCurrentBlock("access");
include_once "./Services/Block/classes/class.ilBlockSetting.php";
$this->tpl->setVariable("TXT_ACCESS", $lng->txt("news_news_item_visibility"));
if ($a_set["visibility"] == NEWS_PUBLIC || $a_set["priority"] == 0 && ilBlockSetting::_lookup("news", "public_notifications", 0, $obj_id)) {
$this->tpl->setVariable("VAL_ACCESS", $lng->txt("news_visibility_public"));
} else {
$this->tpl->setVariable("VAL_ACCESS", $lng->txt("news_visibility_users"));
}
$this->tpl->parseCurrentBlock();
}
// content
if ($a_set["content"] != "") {
$this->tpl->setCurrentBlock("content");
$this->tpl->setVariable("VAL_CONTENT", ilUtil::makeClickable($a_set["content"], true));
$this->tpl->parseCurrentBlock();
}
if ($a_set["content_long"] != "") {
$this->tpl->setCurrentBlock("long");
$this->tpl->setVariable("VAL_LONG_CONTENT", ilUtil::makeClickable($a_set["content_long"], true));
$this->tpl->parseCurrentBlock();
}
if ($a_set["update_date"] != $a_set["creation_date"]) {
$this->tpl->setCurrentBlock("ni_update");
$this->tpl->setVariable("TXT_LAST_UPDATE", $lng->txt("last_update"));
$this->tpl->setVariable("VAL_LAST_UPDATE", ilDatePresentation::formatDate(new ilDateTime($a_set["update_date"], IL_CAL_DATETIME)));
$this->tpl->parseCurrentBlock();
}
// forum hack, not nice
$add = "";
if ($obj_type == "frm" && $a_set["context_sub_obj_type"] == "pos" && $a_set["context_sub_obj_id"] > 0) {
include_once "./Modules/Forum/classes/class.ilObjForumAccess.php";
$pos = $a_set["context_sub_obj_id"];
$thread = ilObjForumAccess::_getThreadForPosting($pos);
if ($thread > 0) {
$add = "_" . $thread . "_" . $pos;
}
}
$url_target = "./goto.php?client_id=" . rawurlencode(CLIENT_ID) . "&target=" . $obj_type . "_" . $a_set["ref_id"] . $add;
$this->tpl->setCurrentBlock("context");
$cont_loc = new ilLocatorGUI();
$cont_loc->addContextItems($a_set["ref_id"], true);
$this->tpl->setVariable("CONTEXT_LOCATOR", $cont_loc->getHTML());
$this->tpl->setVariable("HREF_CONTEXT_TITLE", $url_target);
$this->tpl->setVariable("CONTEXT_TITLE", $obj_title);
$this->tpl->setVariable("ALT_CONTEXT_TITLE", $lng->txt("icon") . " " . $lng->txt("obj_" . $obj_type));
$this->tpl->setVariable("IMG_CONTEXT_TITLE", ilUtil::getImagePath("icon_" . $obj_type . "_b.png"));
$this->tpl->parseCurrentBlock();
$this->tpl->setVariable("HREF_TITLE", $url_target);
// title
if ($a_set["content_is_lang_var"]) {
$this->tpl->setVariable("VAL_TITLE", $lng->txt($a_set["title"]));
} else {
$this->tpl->setVariable("VAL_TITLE", ilUtil::stripSlashes($a_set["title"]));
// title
}
// creation date
$this->tpl->setVariable("VAL_CREATION_DATE", ilDatePresentation::formatDate(new ilDateTime($a_set["creation_date"], IL_CAL_DATETIME)));
$this->tpl->setVariable("TXT_CREATED", $lng->txt("created"));
$this->tpl->parseCurrentBlock();
}
/**
* handler for end of element
*
* @param resource $a_xml_parser xml parser
* @param string $a_name element name
*/
public function handlerEndTag($a_xml_parser, $a_name)
{
global $ilDB, $ilUser;
$this->cdata = trim($this->cdata);
$arrayname = strtolower($this->entity) . 'Array';
$x =& $this->{$arrayname};
switch ($a_name) {
case 'Forum':
$query_num_posts = "SELECT COUNT(pos_pk) cnt\n\t\t\t\t\t\t\t\t\t\tFROM frm_posts\n\t\t\t\t\t\t\t\t\tWHERE pos_top_fk = " . $ilDB->quote($this->lastHandledForumId, 'integer');
$res_pos = $ilDB->query($query_num_posts);
$data_pos = $ilDB->fetchAssoc($res_pos);
$num_posts = $data_pos['cnt'];
$query_num_threads = "SELECT COUNT(thr_pk) cnt\n\t\t\t\t\t\t\t\t\t\tFROM frm_threads\n\t\t\t\t\t\t\t\t\t WHERE thr_top_fk = " . $ilDB->quote($this->lastHandledForumId, 'integer');
$res_thr = $ilDB->query($query_num_threads);
$data_thr = $ilDB->fetchAssoc($res_thr);
$num_threads = $data_thr['cnt'];
$update_str = "{$this->lastHandledForumId}#{$this->lastHandledThreadId}#{$this->lastHandledPostId}";
$ilDB->manipulateF("UPDATE frm_data \n\t\t\t\t\t\tSET top_last_post = %s,\n\t\t\t\t\t\t\ttop_num_posts = %s,\n\t\t\t\t\t\t\ttop_num_threads = %s\n\t\t\t\t\tWHERE top_frm_fk = %s", array('text', 'integer', 'integer', 'integer'), array($update_str, $num_posts, $num_threads, $this->forum_obj_id));
break;
case 'Id':
$x['Id'] = $this->cdata;
break;
case 'ObjId':
$x['ObjId'] = $this->cdata;
break;
case 'Title':
$x['Title'] = $this->cdata;
break;
case 'Description':
$x['Description'] = $this->cdata;
break;
case 'DefaultView':
$x['DefaultView'] = $this->cdata;
break;
case 'Pseudonyms':
$x['Pseudonyms'] = $this->cdata;
break;
case 'Statistics':
$x['Statistics'] = $this->cdata;
break;
case 'PostingActivation':
$x['PostingActivation'] = $this->cdata;
break;
case 'PresetSubject':
$x['PresetSubject'] = $this->cdata;
break;
case 'PresetRe':
$x['PresetRe'] = $this->cdata;
break;
case 'NotificationType':
$x['NotificationType'] = $this->cdata;
break;
case 'ForceNotification':
$x['ForceNotification'] = $this->cdata;
break;
case 'ToggleNotification':
$x['ToggleNotification'] = $this->cdata;
break;
case 'LastPost':
$x['LastPost'] = $this->cdata;
break;
case 'Moderator':
$x['Moderator'] = $this->cdata;
break;
case 'CreateDate':
$x['CreateDate'] = $this->cdata;
break;
case 'UpdateDate':
$x['UpdateDate'] = $this->cdata;
break;
case 'UpdateUserId':
$x['UpdateUserId'] = $this->cdata;
break;
case 'UserId':
$x['UserId'] = $this->cdata;
if ($this->entity == 'forum' && $this->forumArray) {
//// @todo: Maybe problems if the forum xml is imported as content of a course
// createSettings accesses superglobal $_GET array, which can cause problems
// with public_notifications of block settings
$this->forum->createSettings();
$forum_array = $this->getUserIdAndAlias($this->forumArray['UserId'], '');
// Store old user id
$oldUsrId = $ilUser->getId();
// Manipulate user object
$ilUser->setId($forum_array['usr_id']);
// create frm_data
$this->forum->saveData(array());
// Restore old user id
$ilUser->setId($oldUsrId);
$update_forum_array = $this->getUserIdAndAlias($this->forumArray['UpdateUserId'], '');
// Store old user id
$oldUsrId = $_SESSION["AccountId"];
// Manipulate user object
$_SESSION["AccountId"] = $update_forum_array['usr_id'];
$this->forum->setTitle($this->forumArray["Title"]);
$this->forum->setDescription($this->forumArray["Description"]);
$this->forum->update();
// Restore old user id
$_SESSION["AccountId"] = $oldUsrId;
// create frm_settings
$newObjProp = ilForumProperties::getInstance($this->forum->getId());
$newObjProp->setDefaultView((int) $this->forumArray['DefaultView']);
$newObjProp->setAnonymisation((int) $this->forumArray['Pseudonyms']);
$newObjProp->setStatisticsStatus((int) $this->forumArray['Statistics']);
$newObjProp->setPostActivation((int) $this->forumArray['PostingActivation']);
$newObjProp->setPresetSubject((int) $this->forumArray['PresetSubject']);
$newObjProp->setAddReSubject((int) $this->forumArray['PresetRe']);
$newObjProp->setNotificationType($this->forumArray['NotificationType'] ? $this->forumArray['NotificationType'] : 'all_users');
$newObjProp->setAdminForceNoti((int) $this->forumArray['ForceNotification']);
$newObjProp->setUserToggleNoti((int) $this->forumArray['ToggleNotification']);
$newObjProp->insert();
$id = $this->getNewForumPk();
$this->forum_obj_id = $newObjProp->getObjId();
$this->mapping['frm'][$this->forumArray['Id']] = $id;
$this->lastHandledForumId = $id;
unset($this->forumArray);
}
break;
case 'Thread':
$update_str = "{$this->lastHandledForumId}#{$this->lastHandledThreadId}#{$this->lastHandledPostId}";
$ilDB->manipulateF("UPDATE frm_threads\n\t\t\t\t\t\tSET thr_last_post = %s\n\t\t\t\t\tWHERE thr_pk = %s", array('text', 'integer'), array($update_str, $this->lastHandledThreadId));
break;
case 'Subject':
$x['Subject'] = $this->cdata;
break;
case 'Alias':
$x['Alias'] = $this->cdata;
break;
case 'Sticky':
$x['Sticky'] = $this->cdata;
break;
case 'Closed':
$x['Closed'] = $this->cdata;
if ($this->entity == 'thread' && $this->threadArray) {
require_once 'Modules/Forum/classes/class.ilForumTopic.php';
$this->forumThread = new ilForumTopic();
$this->forumThread->setId($this->threadArray['Id']);
$this->forumThread->setForumId($this->lastHandledForumId);
$this->forumThread->setSubject($this->threadArray['Subject']);
$this->forumThread->setSticky($this->threadArray['Sticky']);
$this->forumThread->setClosed($this->threadArray['Closed']);
$this->forumThread->setCreateDate($this->threadArray['CreateDate']);
$this->forumThread->setChangeDate($this->threadArray['UpdateDate']);
$this->forumThread->setImportName($this->threadArray['ImportName']);
$usr_data = $this->getUserIdAndAlias($this->threadArray['UserId'], $this->threadArray['Alias']);
$this->forumThread->setUserId($usr_data['usr_id']);
$this->forumThread->setUserAlias($usr_data['usr_alias']);
$this->forumThread->insert();
$this->mapping['thr'][$this->threadArray['Id']] = $this->forumThread->getId();
$this->lastHandledThreadId = $this->forumThread->getId();
unset($this->threadArray);
}
break;
case 'Post':
break;
case 'Censorship':
$x['Censorship'] = $this->cdata;
break;
case 'CensorshipMessage':
$x['CensorshipMessage'] = $this->cdata;
break;
case 'Notification':
$x['Notification'] = $this->cdata;
break;
case 'ImportName':
$x['ImportName'] = $this->cdata;
break;
case 'Status':
$x['Status'] = $this->cdata;
break;
case 'Message':
$x['Message'] = $this->cdata;
break;
case 'Lft':
$x['Lft'] = $this->cdata;
break;
case 'Rgt':
$x['Rgt'] = $this->cdata;
break;
case 'Depth':
$x['Depth'] = $this->cdata;
break;
case 'ParentId':
$x['ParentId'] = $this->cdata;
if ($this->entity == 'post' && $this->postArray) {
require_once 'Modules/Forum/classes/class.ilForumPost.php';
$this->forumPost = new ilForumPost();
$this->forumPost->setId($this->postArray['Id']);
$this->forumPost->setCensorship($this->postArray['Censorship']);
$this->forumPost->setCensorshipComment($this->postArray['CensorshipMessage']);
$this->forumPost->setNotification($this->postArray['Notification']);
$this->forumPost->setImportName($this->postArray['ImportName']);
$this->forumPost->setStatus($this->postArray['Status']);
$this->forumPost->setMessage($this->postArray['Message']);
$this->forumPost->setSubject($this->postArray['Subject']);
$this->forumPost->setLft($this->postArray['Lft']);
$this->forumPost->setRgt($this->postArray['Rgt']);
$this->forumPost->setDepth($this->postArray['Depth']);
$this->forumPost->setParentId($this->postArray['ParentId']);
$this->forumPost->setThread($this->forumThread);
$this->forumPost->setThreadId($this->lastHandledThreadId);
$this->forumPost->setForumId($this->lastHandledForumId);
$this->forumPost->setCreateDate($this->postArray['CreateDate']);
$this->forumPost->setChangeDate($this->postArray['UpdateDate']);
$usr_data = $this->getUserIdAndAlias($this->postArray['UserId'], $this->postArray['Alias']);
$update_usr_data = $this->getUserIdAndAlias($this->postArray['UpdateUserId']);
$this->forumPost->setUserId($usr_data['usr_id']);
$this->forumPost->setUserAlias($usr_data['usr_alias']);
$this->forumPost->setUpdateUserId($update_usr_data['usr_id']);
$this->forumPost->insert();
if ($this->mapping['pos'][$this->postArray['ParentId']]) {
$parentId = $this->mapping['pos'][$this->postArray['ParentId']];
} else {
$parentId = 0;
}
$postTreeNodeId = $ilDB->nextId('frm_posts_tree');
$ilDB->insert('frm_posts_tree', array('fpt_pk' => array('integer', $postTreeNodeId), 'thr_fk' => array('integer', $this->lastHandledThreadId), 'pos_fk' => array('integer', $this->forumPost->getId()), 'parent_pos' => array('integer', $parentId), 'lft' => array('integer', $this->postArray['Lft']), 'rgt' => array('integer', $this->postArray['Rgt']), 'depth' => array('integer', $this->postArray['Depth']), 'fpt_date' => array('timestamp', date('Y-m-d H:i:s'))));
$this->mapping['pos'][$this->postArray['Id']] = $this->forumPost->getId();
$this->lastHandledPostId = $this->forumPost->getId();
$media_objects_found = false;
foreach ($this->mediaObjects as $mob_attr) {
$importfile = $this->getImportDirectory() . '/' . $mob_attr['uri'];
if (file_exists($importfile)) {
$mob = ilObjMediaObject::_saveTempFileAsMediaObject(basename($importfile), $importfile, false);
ilObjMediaObject::_saveUsage($mob->getId(), "frm:html", $this->forumPost->getId());
$this->forumPost->setMessage(str_replace(array("src=\"" . $mob_attr["label"] . "\"", "src=\"" . preg_replace("/(il)_[\\d]+_(mob)_([\\d]+)/", "\$1_0_\$2_\$3", $mob_attr["label"]) . "\""), "src=\"" . "il_" . IL_INST_ID . "_mob_" . $mob->getId() . "\"", $this->forumPost->getMessage()));
$media_objects_found = true;
}
}
if ($media_objects_found) {
$this->forumPost->update();
}
unset($this->postArray);
}
break;
case 'Content':
$x['content'] = $this->cdata;
break;
case 'Attachment':
$filedata = new ilFileDataForum($this->forum->getId(), $this->lastHandledPostId);
$importPath = $this->contentArray['content'];
if (strlen($importPath)) {
$importPath = $this->getImportDirectory() . '/' . $importPath;
$newFilename = preg_replace("/^\\d+_\\d+(_.*)/ims", $this->forum->getId() . "_" . $this->lastHandledPostId . "\$1", basename($importPath));
$path = $filedata->getForumPath();
$newPath = $path . '/' . $newFilename;
@copy($importPath, $newPath);
}
break;
}
$this->cdata = '';
return;
}
public function showMembersObject()
{
/**
* @var $tree ilTree
* @var $tpl ilTemplate
* @var $ilTabs ilTabsGUI
* @var $ilAccess ilAccessHandler
* @var $ilErr ilErr
*/
global $tree, $tpl, $ilTabs, $ilAccess, $ilErr;
if (!$ilAccess->checkAccess('write', '', $this->ref_id)) {
$ilErr->raiseError($this->lng->txt('msg_no_perm_read'), $ilErr->MESSAGE);
}
$tpl->addBlockFile('ADM_CONTENT', 'adm_content', 'tpl.forums_members_list.html', 'Modules/Forum');
$ilTabs->setTabActive('settings');
$this->settingsTabs();
// instantiate the property form
if (!$this->initNotificationSettingsForm()) {
// if the form was just created set the values fetched from database
$this->notificationSettingsForm->setValuesByArray(array('notification_type' => $this->objProperties->getNotificationType(), 'adm_force' => (bool) $this->objProperties->isAdminForceNoti(), 'usr_toggle' => (bool) $this->objProperties->isUserToggleNoti()));
}
// set form html into template
$tpl->setVariable('NOTIFICATIONS_SETTINGS_FORM', $this->notificationSettingsForm->getHTML());
include_once 'Modules/Forum/classes/class.ilForumNotification.php';
include_once 'Modules/Forum/classes/class.ilObjForum.php';
$frm_noti = new ilForumNotification($this->object->getRefId());
// check if there a parent-node is a grp or crs
$grp_ref_id = $tree->checkForParentType($this->object->getRefId(), 'grp');
$crs_ref_id = $tree->checkForParentType($this->object->getRefId(), 'crs');
if ($grp_ref_id == 0 && $crs_ref_id == 0) {
$ilErr->raiseError($this->lng->txt('msg_no_perm_read'), $ilErr->MESSAGE);
}
/**
* @var $oParticipants ilParticipants
*/
$oParticipants = null;
if ($grp_ref_id > 0) {
$parent_obj = ilObjectFactory::getInstanceByRefId($grp_ref_id);
include_once 'Modules/Group/classes/class.ilGroupParticipants.php';
$oParticipants = ilGroupParticipants::_getInstanceByObjId($parent_obj->getId());
} else {
if ($crs_ref_id > 0) {
$parent_obj = ilObjectFactory::getInstanceByRefId($crs_ref_id);
include_once 'Modules/Course/classes/class.ilCourseParticipants.php';
$oParticipants = ilCourseParticipants::_getInstanceByObjId($parent_obj->getId());
}
}
$moderator_ids = $frm_noti->_getModerators($this->object->getRefId());
$admin_ids = $oParticipants->getAdmins();
$member_ids = $oParticipants->getMembers();
$tutor_ids = $oParticipants->getTutors();
$moderators = array();
$admins = array();
$members = array();
$tutors = array();
$all_forum_users = array_merge($moderator_ids, $admin_ids, $member_ids, $tutor_ids);
$all_forum_users = array_unique($all_forum_users);
if ($this->objProperties->getNotificationType() == 'default') {
// update forum_notification table
include_once 'Modules/Forum/classes/class.ilForumNotification.php';
$forum_noti = new ilForumNotification($this->object->getRefId());
$forum_noti->setAdminForce($this->objProperties->isAdminForceNoti());
$forum_noti->setUserToggle($this->objProperties->isUserToggleNoti());
$forum_noti->setForumId($this->objProperties->getObjId());
if (isset($_POST['notification_type']) && $_POST['notification_type'] == 'default') {
// delete all notifications set by admin
$forum_noti->deleteNotificationAllUsers();
}
} else {
if ($this->objProperties->getNotificationType() == 'per_user') {
$counter = 0;
foreach ($moderator_ids as $user_id) {
$frm_noti->setUserId($user_id);
#$admin_force_noti = $frm_noti->isAdminForceNotification();
$user_toggle_noti = $frm_noti->isUserToggleNotification();
$icon_ok = $this->getIcon(!$user_toggle_noti);
$moderators[$counter]['user_id'] = ilUtil::formCheckbox(0, 'user_id[]', $user_id);
$moderators[$counter]['login'] = ilObjUser::_lookupLogin($user_id);
$name = ilObjUser::_lookupName($user_id);
$moderators[$counter]['firstname'] = $name['firstname'];
$moderators[$counter]['lastname'] = $name['lastname'];
$moderators[$counter]['user_toggle_noti'] = $icon_ok;
$counter++;
}
$counter = 0;
foreach ($admin_ids as $user_id) {
$frm_noti->setUserId($user_id);
#$admin_force_noti = $frm_noti->isAdminForceNotification();
$user_toggle_noti = $frm_noti->isUserToggleNotification();
$icon_ok = $this->getIcon(!$user_toggle_noti);
$admins[$counter]['user_id'] = ilUtil::formCheckbox(0, 'user_id[]', $user_id);
$admins[$counter]['login'] = ilObjUser::_lookupLogin($user_id);
$name = ilObjUser::_lookupName($user_id);
$admins[$counter]['firstname'] = $name['firstname'];
$admins[$counter]['lastname'] = $name['lastname'];
$admins[$counter]['user_toggle_noti'] = $icon_ok;
$counter++;
}
$counter = 0;
foreach ($member_ids as $user_id) {
$frm_noti->setUserId($user_id);
#$admin_force_noti = $frm_noti->isAdminForceNotification();
$user_toggle_noti = $frm_noti->isUserToggleNotification();
$icon_ok = $this->getIcon(!$user_toggle_noti);
$members[$counter]['user_id'] = ilUtil::formCheckbox(0, 'user_id[]', $user_id);
$members[$counter]['login'] = ilObjUser::_lookupLogin($user_id);
$name = ilObjUser::_lookupName($user_id);
$members[$counter]['firstname'] = $name['firstname'];
$members[$counter]['lastname'] = $name['lastname'];
$members[$counter]['user_toggle_noti'] = $icon_ok;
$counter++;
}
$counter = 0;
foreach ($tutor_ids as $user_id) {
$frm_noti->setUserId($user_id);
#$admin_force_noti = $frm_noti->isAdminForceNotification();
$user_toggle_noti = $frm_noti->isUserToggleNotification();
$icon_ok = $this->getIcon(!$user_toggle_noti);
$tutors[$counter]['user_id'] = ilUtil::formCheckbox(0, 'user_id[]', $user_id);
$tutors[$counter]['login'] = ilObjUser::_lookupLogin($user_id);
$name = ilObjUser::_lookupName($user_id);
$tutors[$counter]['firstname'] = $name['firstname'];
$tutors[$counter]['lastname'] = $name['lastname'];
$tutors[$counter]['user_toggle_noti'] = $icon_ok;
$counter++;
}
$this->__showMembersTable($moderators, $admins, $members, $tutors);
} else {
$frm_noti = new ilForumNotification($this->object->getRefId());
$all_notis = $frm_noti->read();
foreach ($all_forum_users as $user_id) {
$frm_noti->setUserId($user_id);
$frm_noti->setAdminForce(1);
$frm_noti->setUserToggle($this->objProperties->isUserToggleNoti());
if (array_key_exists($user_id, $all_notis)) {
$frm_noti->update();
} else {
if ($frm_noti->existsNotification() == false && !in_array($user_id, $moderator_ids)) {
$frm_noti->insertAdminForce();
}
}
}
}
}
}
/**
* @static
* @param int $ref_id
* @return array
*/
public static function lookupStatisticsByRefId($ref_id)
{
/**
* @var $ilAccess ilAccessHandler
* @var $ilUser ilObjUser
* @var $ilDB ilDB
* @var $ilSetting ilSetting
*/
global $ilAccess, $ilUser, $ilDB, $ilSetting;
if (isset(self::$forum_statistics_cache[$ref_id])) {
return self::$forum_statistics_cache[$ref_id];
}
$statistics = array('num_posts' => 0, 'num_unread_posts' => 0, 'num_new_posts' => 0);
$forumId = self::lookupForumIdByRefId($ref_id);
if (!$forumId) {
self::$forum_statistics_cache[$ref_id] = $statistics;
return self::$forum_statistics_cache[$ref_id];
}
$objProperties = ilForumProperties::getInstance(ilObject::_lookupObjectId($ref_id));
$is_post_activation_enabled = $objProperties->isPostActivationEnabled();
$act_clause = '';
if ($is_post_activation_enabled && !$ilAccess->checkAccess('moderate_frm', '', $ref_id)) {
$act_clause .= " AND (frm_posts.pos_status = " . $ilDB->quote(1, "integer") . " OR frm_posts.pos_author_id = " . $ilDB->quote($ilUser->getId(), "integer") . ") ";
}
$new_deadline = date('Y-m-d H:i:s', time() - 60 * 60 * 24 * 7 * ($ilSetting->get('frm_store_new') ? $ilSetting->get('frm_store_new') : 8));
if (!$ilUser->isAnonymous()) {
$query = "\n\t\t\t\t(SELECT COUNT(frm_posts.pos_pk) cnt\n\t\t\t\tFROM frm_posts\n\t\t\t\tINNER JOIN frm_threads ON frm_posts.pos_thr_fk = frm_threads.thr_pk \n\t\t\t\tWHERE frm_threads.thr_top_fk = %s {$act_clause})\n\t\t\t\t\n\t\t\t\tUNION ALL\n\t\t\t\t \n\t\t\t\t(SELECT COUNT(DISTINCT(frm_user_read.post_id)) cnt\n\t\t\t\tFROM frm_user_read\n\t\t\t\tINNER JOIN frm_posts ON frm_user_read.post_id = frm_posts.pos_pk\n\t\t\t\tINNER JOIN frm_threads ON frm_threads.thr_pk = frm_posts.pos_thr_fk \n\t\t\t\tWHERE frm_user_read.usr_id = %s AND frm_posts.pos_top_fk = %s {$act_clause})\n\t\t\t";
$types = array('integer', 'integer', 'integer');
$values = array($forumId, $ilUser->getId(), $forumId);
$forum_overview_setting = (int) $ilSetting::_lookupValue('frma', 'forum_overview');
if ($forum_overview_setting == ilForumProperties::FORUM_OVERVIEW_WITH_NEW_POSTS) {
$news_types = array('integer', 'integer', 'integer', 'timestamp', 'integer');
$news_values = array($ilUser->getId(), $ilUser->getId(), $forumId, $new_deadline, $ilUser->getId());
$query .= " \n\t\t\t\tUNION ALL\n\t\t\t\t\n\t\t\t\t(SELECT COUNT(frm_posts.pos_pk) cnt\n\t\t\t\tFROM frm_posts\n\t\t\t\tLEFT JOIN frm_user_read ON (post_id = frm_posts.pos_pk AND frm_user_read.usr_id = %s)\n\t\t\t\tLEFT JOIN frm_thread_access ON (frm_thread_access.thread_id = frm_posts.pos_thr_fk AND frm_thread_access.usr_id = %s)\n\t\t\t\tWHERE frm_posts.pos_top_fk = %s\n\t\t\t\tAND ( (frm_posts.pos_update > frm_thread_access.access_old_ts)\n\t\t\t\t\t\tOR (frm_thread_access.access_old IS NULL AND frm_posts.pos_update > %s)\n\t\t\t\t\t)\n\t\t\t\tAND frm_posts.pos_author_id != %s \n\t\t\t\tAND frm_user_read.usr_id IS NULL {$act_clause})";
$types = array_merge($types, $news_types);
$values = array_merge($values, $news_values);
}
$mapping = array_keys($statistics);
$res = $ilDB->queryF($query, $types, $values);
for ($i = 0; $i <= 2; $i++) {
$row = $ilDB->fetchAssoc($res);
$statistics[$mapping[$i]] = (int) $row['cnt'];
if ($i == 1) {
// unread = all - read
$statistics[$mapping[$i]] = $statistics[$mapping[$i - 1]] - $statistics[$mapping[$i]];
}
}
} else {
$query = "\n\t\t\t\tSELECT COUNT(frm_posts.pos_pk) cnt\n\t\t\t\tFROM frm_posts\n\t\t\t\tINNER JOIN frm_threads ON frm_posts.pos_thr_fk = frm_threads.thr_pk \n\t\t\t\tWHERE frm_threads.thr_top_fk = %s {$act_clause}\n\t\t\t";
$types = array('integer');
$values = array($forumId);
$res = $ilDB->queryF($query, $types, $values);
$row = $ilDB->fetchAssoc($res);
$statistics = array('num_posts' => $row['cnt'], 'num_unread_posts' => $row['cnt'], 'num_new_posts' => $row['cnt']);
}
self::$forum_statistics_cache[$ref_id] = $statistics;
return self::$forum_statistics_cache[$ref_id];
}
/**
*
*/
public function detachModeratorRole()
{
if (!isset($_POST['usr_id']) || !is_array($_POST['usr_id'])) {
ilUtil::sendFailure($this->lng->txt('frm_moderators_select_at_least_one'));
return $this->showModerators();
}
$entries = $this->oForumModerators->getCurrentModerators();
if (count($_POST['usr_id']) == count($entries)) {
ilUtil::sendFailure($this->lng->txt('frm_at_least_one_moderator'));
return $this->showModerators();
}
include_once "Modules/Forum/classes/class.ilForumNotification.php";
$isCrsGrp = ilForumNotification::_isParentNodeGrpCrs($this->ref_id);
if ($isCrsGrp) {
global $tree;
$parent_ref_id = $tree->getParentId($this->ref_id);
include_once "Services/Membership/classes/class.ilParticipants.php";
}
include_once "Modules/Forum/classes/class.ilForumProperties.php";
$objFrmProps = ilForumProperties::getInstance(ilObject::_lookupObjId($this->ref_id));
$frm_noti_type = $objFrmProps->getNotificationType();
foreach ($_POST['usr_id'] as $usr_id) {
$this->oForumModerators->detachModeratorRole((int) $usr_id);
if ($isCrsGrp && $frm_noti_type != 'default') {
if (!ilParticipants::_isParticipant($this->ref_id, $usr_id)) {
$tmp_frm_noti = new ilForumNotification($this->ref_id);
$tmp_frm_noti->setUserId((int) $usr_id);
$tmp_frm_noti->setForumId(ilObject::_lookupObjId($this->ref_id));
$tmp_frm_noti->deleteAdminForce();
}
}
}
ilUtil::sendSuccess($this->lng->txt('frm_moderators_detached_role_successfully'), true);
$this->ctrl->redirect($this, 'showModerators');
}
/**
* @param $a_topic_id
* @param array $params
* @param int $limit
* @param int $offset
* @return array
*/
public function getAllThreads($a_topic_id, array $params = array(), $limit = 0, $offset = 0)
{
/**
* @var $ilDB ilDB
* @var $ilUser ilObjUser
* @var $ilSetting ilSetting
*/
global $ilDB, $ilUser, $ilSetting;
$frm_overview_setting = (int) $ilSetting::_lookupValue('frma', 'forum_overview');
$frm_props = ilForumProperties::getInstance($this->getForumId());
$excluded_ids_condition = '';
if (isset($params['excluded_ids']) && is_array($params['excluded_ids']) && $params['excluded_ids']) {
$excluded_ids_condition = ' AND ' . $ilDB->in('thr_pk', $params['excluded_ids'], true, 'integer') . ' ';
}
if (!in_array(strtolower($params['order_column']), array('lp_date', 'rating'))) {
$params['order_column'] = 'post_date';
}
if (!in_array(strtolower($params['order_direction']), array('asc', 'desc'))) {
$params['order_direction'] = 'desc';
}
// Count all threads for the passed forum
$query = "SELECT COUNT(thr_pk) cnt\n\t\t\t\t FROM frm_threads\n\t\t\t\t WHERE thr_top_fk = %s {$excluded_ids_condition}";
$res = $ilDB->queryF($query, array('integer'), array($a_topic_id));
$data = $ilDB->fetchAssoc($res);
$cnt = (int) $data['cnt'];
$threads = array();
$data = array();
$data_types = array();
$active_query = '';
$active_inner_query = '';
$is_post_activation_enabled = $frm_props->isPostActivationEnabled();
if ($is_post_activation_enabled && !$params['is_moderator']) {
$active_query = ' AND (pos_status = %s OR pos_author_id = %s) ';
$active_inner_query = ' AND (ipos.pos_status = %s OR ipos.pos_author_id = %s) ';
}
$optional_fields = '';
if ($frm_props->isIsThreadRatingEnabled()) {
$optional_fields = ',avg_rating';
}
if ($frm_props->getThreadSorting() == 1) {
$optional_fields = ',thread_sorting';
}
$additional_sort = '';
if ($frm_props->getThreadSorting()) {
$additional_sort .= ' ,thread_sorting ASC ';
}
$dynamic_columns = array(' ,post_date ' . $params['order_direction']);
if ($frm_props->isIsThreadRatingEnabled()) {
$dynamic_columns[] = ' ,avg_rating ' . $params['order_direction'];
}
if ('rating' == strtolower($params['order_column'])) {
$dynamic_columns = array_reverse($dynamic_columns);
}
$additional_sort .= implode(' ', $dynamic_columns);
if (!$ilUser->isAnonymous()) {
$query = "SELECT\n\t\t\t\t\t (CASE WHEN COUNT(DISTINCT(notification_id)) > 0 THEN 1 ELSE 0 END) usr_notification_is_enabled,\n\t\t\t\t\t MAX(pos_date) post_date,\n\t\t\t\t\t COUNT(DISTINCT(pos_pk)) num_posts, \n\t\t\t\t\t COUNT(DISTINCT(pos_pk)) - COUNT(DISTINCT(postread.post_id)) num_unread_posts, ";
// new posts query
if ($frm_overview_setting == ilForumProperties::FORUM_OVERVIEW_WITH_NEW_POSTS) {
$query .= "\n\t\t\t\t\t (SELECT COUNT(DISTINCT(ipos.pos_pk))\n\t\t\t\t\t\tFROM frm_posts ipos\n\t\t\t\t\t\tLEFT JOIN frm_user_read iread ON iread.post_id = ipos.pos_pk AND iread.usr_id = %s\n\t\t\t\t\t\tLEFT JOIN frm_thread_access iacc ON (iacc.thread_id = ipos.pos_thr_fk AND iacc.usr_id = %s)\n\t\t\t\t\t\tWHERE ipos.pos_thr_fk = thr_pk\n\t\t\t\t\t\t \n\t\t\t\t\t\tAND (ipos.pos_update > iacc.access_old_ts\n\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t(iacc.access_old IS NULL AND (ipos.pos_update > " . $ilDB->quote(date('Y-m-d H:i:s', NEW_DEADLINE), 'timestamp') . "))\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t \n\t\t\t\t\t\tAND ipos.pos_author_id != %s\n\t\t\t\t\t\tAND iread.usr_id IS NULL {$active_inner_query}\n\t\t\t\t\t ) num_new_posts, ";
}
$query .= " thr_pk, thr_top_fk, thr_subject, thr_author_id, thr_display_user_id, thr_usr_alias, thr_num_posts, thr_last_post, thr_date, thr_update, visits, frm_threads.import_name, is_sticky, is_closed\n\t\t\t\t\t {$optional_fields}\n\t\t\t\t\t FROM frm_threads\n\t\t\t\t\t \n\t\t\t\t\t LEFT JOIN frm_notification\n\t\t\t\t\t\tON frm_notification.thread_id = thr_pk\n\t\t\t\t\t\tAND frm_notification.user_id = %s\n\t\t\t\t\t \n\t\t\t\t\t LEFT JOIN frm_posts\n\t\t\t\t\t\tON pos_thr_fk = thr_pk {$active_query}\n\t\t\t\t\t \n\t\t\t\t\t LEFT JOIN frm_user_read postread\n\t\t\t\t\t\tON postread.post_id = pos_pk\n\t\t\t\t\t\tAND postread.usr_id = %s";
$query .= " WHERE thr_top_fk = %s\n\t\t\t\t\t\t{$excluded_ids_condition}\n\t\t\t\t\t\tGROUP BY thr_pk, thr_top_fk, thr_subject, thr_author_id, thr_display_user_id, thr_usr_alias, thr_num_posts, thr_last_post, thr_date, thr_update, visits, frm_threads.import_name, is_sticky, is_closed\n\t\t\t\t\t\t{$optional_fields}\n\t\t\t\t\t\tORDER BY is_sticky DESC {$additional_sort}, thr_date DESC";
// data_types for new posts query and $active_inner_query
if ($frm_overview_setting == ilForumProperties::FORUM_OVERVIEW_WITH_NEW_POSTS) {
$data_types[] = 'integer';
$data_types[] = 'integer';
$data_types[] = 'integer';
if ($is_post_activation_enabled && !$params['is_moderator']) {
array_push($data_types, 'integer', 'integer');
}
}
$data_types[] = 'integer';
if ($is_post_activation_enabled && !$params['is_moderator']) {
array_push($data_types, 'integer', 'integer');
}
$data_types[] = 'integer';
$data_types[] = 'integer';
// data_values for new posts query and $active_inner_query
if ($frm_overview_setting == ilForumProperties::FORUM_OVERVIEW_WITH_NEW_POSTS) {
$data[] = $ilUser->getId();
$data[] = $ilUser->getId();
$data[] = $ilUser->getId();
if ($is_post_activation_enabled && !$params['is_moderator']) {
array_push($data, '1', $ilUser->getId());
}
}
$data[] = $ilUser->getId();
if ($is_post_activation_enabled && !$params['is_moderator']) {
array_push($data, '1', $ilUser->getId());
}
$data[] = $ilUser->getId();
$data[] = $a_topic_id;
} else {
$query = "SELECT\n\t\t\t\t\t 0 usr_notification_is_enabled,\n\t\t\t\t\t MAX(pos_date) post_date,\n\t\t\t\t\t COUNT(DISTINCT(pos_pk)) num_posts,\n\t\t\t\t\t COUNT(DISTINCT(pos_pk)) num_unread_posts,\n\t\t\t\t\t COUNT(DISTINCT(pos_pk)) num_new_posts,\n\t\t\t\t\t thr_pk, thr_top_fk, thr_subject, thr_author_id, thr_display_user_id, thr_usr_alias, thr_num_posts, thr_last_post, thr_date, thr_update, visits, frm_threads.import_name, is_sticky, is_closed\n\t\t\t\t\t {$optional_fields}\n\t\t\t\t\t FROM frm_threads\n\t\t\t\t\t \n\t\t\t\t\t LEFT JOIN frm_posts\n\t\t\t\t\t\tON pos_thr_fk = thr_pk {$active_query}";
$query .= " WHERE thr_top_fk = %s\n\t\t\t\t\t\t{$excluded_ids_condition}\n\t\t\t\t\t\tGROUP BY thr_pk, thr_top_fk, thr_subject, thr_author_id, thr_display_user_id, thr_usr_alias, thr_num_posts, thr_last_post, thr_date, thr_update, visits, frm_threads.import_name, is_sticky, is_closed\n\t\t\t\t\t\t{$optional_fields}\n\t\t\t\t\t\tORDER BY is_sticky DESC {$additional_sort}, thr_date DESC";
if ($is_post_activation_enabled && !$params['is_moderator']) {
array_push($data_types, 'integer', 'integer');
}
$data_types[] = 'integer';
if ($is_post_activation_enabled && !$params['is_moderator']) {
array_push($data, '1', $ilUser->getId());
}
$data[] = $a_topic_id;
}
if ($limit || $offset) {
$ilDB->setLimit($limit, $offset);
}
$res = $ilDB->queryF($query, $data_types, $data);
while ($row = $ilDB->fetchAssoc($res)) {
$thread = new ilForumTopic($row['thr_pk'], $params['is_moderator'], true);
$thread->assignData($row);
$threads[] = $thread;
}
return array('items' => $threads, 'cnt' => $cnt);
}
/**
* @param ilTemplate $tpl
* @param ilForumPost $post
* @param int $counter
* @param int $mode
*/
protected function renderPostHtml(ilTemplate $tpl, ilForumPost $post, $counter, $mode)
{
/**
* @var $lng ilLanguage
* @var $rbacreview ilRbacReview
* @var $ilUser ilObjUser
* @var $ilObjDataCache ilObjectDataCache
*/
global $lng, $rbacreview, $ilUser, $ilObjDataCache;
$tpl->setCurrentBlock('posts_row');
if (ilForumProperties::getInstance($ilObjDataCache->lookupObjId($_GET['ref_id']))->getMarkModeratorPosts() == 1) {
if ($post->getIsAuthorModerator() === null && ($is_moderator = ilForum::_isModerator($_GET['ref_id'], $post->getPosAuthorId()))) {
$rowCol = 'ilModeratorPosting';
} else {
if ($post->getIsAuthorModerator()) {
$rowCol = 'ilModeratorPosting';
} else {
$rowCol = ilUtil::switchColor($counter, 'tblrow1', 'tblrow2');
}
}
} else {
$rowCol = ilUtil::switchColor($counter, 'tblrow1', 'tblrow2');
}
$tpl->setVariable('ROWCOL', ' ' . $rowCol);
// post is censored
if ($post->isCensored()) {
// display censorship advice
$tpl->setVariable('TXT_CENSORSHIP_ADVICE', $lng->txt('post_censored_comment_by_moderator'));
// highlight censored posts
$rowCol = 'tblrowmarked';
}
// set row color
$tpl->setVariable('ROWCOL', ' ' . $rowCol);
// if post is not activated display message for the owner
if (!$post->isActivated() && $post->isOwner($ilUser->getId())) {
$tpl->setVariable('POST_NOT_ACTIVATED_YET', $lng->txt('frm_post_not_activated_yet'));
}
$authorinfo = new ilForumAuthorInformation($post->getPosAuthorId(), $post->getDisplayUserId(), $post->getUserAlias(), $post->getImportName());
if ($authorinfo->hasSuffix()) {
$tpl->setVariable('AUTHOR', $authorinfo->getSuffix());
$tpl->setVariable('USR_NAME', $post->getUserAlias());
} else {
$tpl->setVariable('AUTHOR', $authorinfo->getAuthorShortName());
if ($authorinfo->getAuthorName(true)) {
$tpl->setVariable('USR_NAME', $authorinfo->getAuthorName(true));
}
}
if (self::MODE_EXPORT_CLIENT == $mode) {
if ($authorinfo->getAuthor()->getPref('public_profile') != 'n') {
$tpl->setVariable('TXT_REGISTERED', $lng->txt('registered_since'));
$tpl->setVariable('REGISTERED_SINCE', $this->frm->convertDate($authorinfo->getAuthor()->getCreateDate()));
}
if ($post->getDisplayUserId()) {
if ($this->is_moderator) {
$num_posts = $this->frm->countUserArticles($post->getDisplayUserId());
} else {
$num_posts = $this->frm->countActiveUserArticles($post->getDisplayUserId());
}
$tpl->setVariable('TXT_NUM_POSTS', $lng->txt('forums_posts'));
$tpl->setVariable('NUM_POSTS', $num_posts);
}
}
$tpl->setVariable('USR_IMAGE', $authorinfo->getProfilePicture());
if ($authorinfo->getAuthor()->getId() && ilForum::_isModerator((int) $_GET['ref_id'], $post->getPosAuthorId())) {
if ($authorinfo->getAuthor()->getGender() == 'f') {
$tpl->setVariable('ROLE', $lng->txt('frm_moderator_f'));
} else {
if ($authorinfo->getAuthor()->getGender() == 'm') {
$tpl->setVariable('ROLE', $lng->txt('frm_moderator_m'));
}
}
}
// get create- and update-dates
if ($post->getUpdateUserId() > 0) {
$spanClass = '';
// last update from moderator?
$posMod = $this->frm->getModeratorFromPost($post->getId());
if (is_array($posMod) && $posMod['top_mods'] > 0) {
$MODS = $rbacreview->assignedUsers($posMod['top_mods']);
if (is_array($MODS)) {
if (in_array($post->getUpdateUserId(), $MODS)) {
$spanClass = 'moderator_small';
}
}
}
$post->setChangeDate($post->getChangeDate());
if ($spanClass == '') {
$spanClass = 'small';
}
require_once 'Modules/Forum/classes/class.ilForumAuthorInformation.php';
$authorinfo = new ilForumAuthorInformation($post->getPosAuthorId(), $post->getUpdateUserId(), '', '');
$tpl->setVariable('POST_UPDATE_TXT', $lng->txt('edited_on') . ': ' . $this->frm->convertDate($post->getChangeDate()) . ' - ' . strtolower($lng->txt('by')));
$tpl->setVariable('UPDATE_AUTHOR', $authorinfo->getLinkedAuthorShortName());
if ($authorinfo->getAuthorName(true)) {
$tpl->setVariable('UPDATE_USR_NAME', $authorinfo->getAuthorName(true));
}
}
// prepare post
$post->setMessage($this->frm->prepareText($post->getMessage()));
$tpl->setVariable('POST_DATE', $this->frm->convertDate($post->getCreateDate()));
$tpl->setVariable('SUBJECT', $post->getSubject());
if (!$post->isCensored()) {
// post from moderator?
$modAuthor = $this->frm->getModeratorFromPost($post->getId());
$spanClass = "";
if (is_array($modAuthor) && $modAuthor['top_mods'] > 0) {
$MODS = $rbacreview->assignedUsers($modAuthor['top_mods']);
if (is_array($MODS) && in_array($post->getDisplayUserId(), $MODS)) {
$spanClass = 'moderator';
}
}
// possible bugfix for mantis #8223
if ($post->getMessage() == strip_tags($post->getMessage())) {
// We can be sure, that there are not html tags
$post->setMessage(nl2br($post->getMessage()));
}
if ($spanClass != "") {
$tpl->setVariable('POST', "<span class=\"" . $spanClass . "\">" . ilRTE::_replaceMediaObjectImageSrc($post->getMessage(), 1) . "</span>");
} else {
$tpl->setVariable('POST', ilRTE::_replaceMediaObjectImageSrc($post->getMessage(), 1));
}
} else {
$tpl->setVariable('POST', "<span class=\"moderator\">" . nl2br($post->getCensorshipComment()) . "</span>");
}
$tpl->parseCurrentBlock('posts_row');
}
