/**
* Moves all posts within the current thread to a new forum
*
* @param integer $old_obj_id object id of the current forum
* @param integer $old_pk primary key of old forum
* @param integer $new_obj_id object id of the new forum
* @param integer $new_pk primary key of new forum
* @return integer number of afffected rows by updating posts
* @access public
*/
public function movePosts($old_obj_id, $old_pk, $new_obj_id, $new_pk)
{
global $ilDB;
if ($this->id) {
$nodes = $this->getAllPosts();
if (is_array($nodes)) {
// Move attachments
foreach ($nodes as $node) {
$file_obj = new ilFileDataForum((int) $old_obj_id, (int) $node->pos_pk);
$file_obj->moveFilesOfPost((int) $new_obj_id);
unset($file_obj);
}
}
$this->db->lockTables(array(0 => array('name' => 'frm_user_read', 'type' => ilDB::LOCK_WRITE), 1 => array('name' => 'frm_thread_access', 'type' => ilDB::LOCK_WRITE)));
$this->db->manipulateF('
DELETE FROM frm_user_read
WHERE obj_id = %s AND thread_id =%s', array('integer', 'integer'), array($new_obj_id, $this->id));
$this->db->manipulateF('
UPDATE frm_user_read
SET obj_id = %s
WHERE thread_id = %s', array('integer', 'integer'), array($new_obj_id, $this->id));
$this->db->manipulateF('
DELETE FROM frm_thread_access
WHERE obj_id = %s AND thread_id =%s', array('integer', 'integer'), array($new_obj_id, $this->id));
$this->db->manipulateF('
UPDATE frm_thread_access
SET obj_id = %s
WHERE thread_id =%s', array('integer', 'integer'), array($new_obj_id, $this->id));
$this->db->unlockTables();
$this->db->manipulateF('
UPDATE frm_posts
SET pos_top_fk = %s
WHERE pos_thr_fk = %s', array('integer', 'integer'), array($new_pk, $this->id));
// update all related news
$posts = $ilDB->queryf('
SELECT * FROM frm_posts WHERE pos_thr_fk = %s', array('integer'), array($this->id));
$old_obj_id = ilForum::_lookupObjIdForForumId($old_pk);
$new_obj_id = ilForum::_lookupObjIdForForumId($new_pk);
while ($post = $posts->fetchRow(DB_FETCHMODE_ASSOC)) {
include_once "./Services/News/classes/class.ilNewsItem.php";
$news_id = ilNewsItem::getFirstNewsIdForContext($old_obj_id, "frm", $post["pos_pk"], "pos");
$news_item = new ilNewsItem($news_id);
$news_item->setContextObjId($new_obj_id);
$news_item->update();
//echo "<br>-".$post["pos_pk"]."-".$old_obj_id."-".$new_obj_id."-";
}
return count($nodes);
}
return 0;
}
/**
* Delete news items.
*/
function determinePlaytimeObject()
{
global $ilCtrl, $lng;
$mc_item = new ilNewsItem($_GET["item_id"]);
$mob = $mc_item->getMobId();
include_once "./Services/MediaObjects/classes/class.ilObjMediaObject.php";
$mob = new ilObjMediaObject($mob);
$mob_dir = ilObjMediaObject::_getDirectory($mob->getId());
$m_item = $mob->getMediaItem("Standard");
$file = $mob_dir . "/" . $m_item->getLocation();
$duration = $this->getDuration($file);
if ($duration != "00:00:00") {
$mc_item->setPlaytime($duration);
$mc_item->update();
ilUtil::sendSuccess($lng->txt("mcst_set_playtime"), true);
} else {
ilUtil::sendFailure($lng->txt("mcst_unable_to_determin_playtime"), true);
}
$ilCtrl->redirect($this, "listItems");
}
public function savePostObject()
{
/**
* @var $ilUser ilObjUser
* @var $ilAccess ilAccessHandler
* @var $lng ilLanguage
*/
global $ilUser, $ilAccess, $lng;
if (!isset($_POST['del_file']) || !is_array($_POST['del_file'])) {
$_POST['del_file'] = array();
}
if ($this->objCurrentTopic->isClosed()) {
$_GET['action'] = '';
return $this->viewThreadObject();
}
$oReplyEditForm = $this->getReplyEditForm();
if ($oReplyEditForm->checkInput()) {
require_once 'Services/Captcha/classes/class.ilCaptchaUtil.php';
if ($ilUser->isAnonymous() && !$ilUser->isCaptchaVerified() && ilCaptchaUtil::isActiveForForum()) {
$ilUser->setCaptchaVerified(true);
}
// init objects
$oForumObjects = $this->getForumObjects();
/**
* @var $forumObj ilObjForum
*/
$forumObj = $oForumObjects['forumObj'];
/**
* @var $frm ilForum
*/
$frm = $oForumObjects['frm'];
$frm->setMDB2WhereCondition(' top_frm_fk = %s ', array('integer'), array($frm->getForumId()));
$topicData = $frm->getOneTopic();
// Generating new posting
if ($_GET['action'] == 'ready_showreply') {
if (!$ilAccess->checkAccess('add_reply', '', (int) $_GET['ref_id'])) {
$this->ilias->raiseError($lng->txt('permission_denied'), $this->ilias->error_obj->MESSAGE);
}
// reply: new post
$status = 1;
$send_activation_mail = 0;
if ($this->objProperties->isPostActivationEnabled()) {
if (!$this->is_moderator) {
$status = 0;
$send_activation_mail = 1;
} else {
if ($this->objCurrentPost->isAnyParentDeactivated()) {
$status = 0;
}
}
}
if ($this->objProperties->isAnonymized()) {
if (!strlen($oReplyEditForm->getInput('alias'))) {
$user_alias = $this->lng->txt('forums_anonymous');
} else {
$user_alias = $oReplyEditForm->getInput('alias');
}
} else {
$user_alias = $ilUser->getLogin();
}
$newPost = $frm->generatePost($topicData['top_pk'], $this->objCurrentTopic->getId(), $ilUser->getId(), $this->objProperties->isAnonymized() ? 0 : $ilUser->getId(), ilRTE::_replaceMediaObjectImageSrc($oReplyEditForm->getInput('message'), 0), $this->objCurrentPost->getId(), (int) $oReplyEditForm->getInput('notify'), $this->handleFormInput($oReplyEditForm->getInput('subject'), false), $user_alias, '', $status, $send_activation_mail);
// mantis #8115: Mark parent as read
$this->object->markPostRead($ilUser->getId(), (int) $this->objCurrentTopic->getId(), (int) $this->objCurrentPost->getId());
// copy temporary media objects (frm~)
include_once 'Services/MediaObjects/classes/class.ilObjMediaObject.php';
$mediaObjects = ilRTE::_getMediaObjects($oReplyEditForm->getInput('message'), 0);
$myMediaObjects = ilObjMediaObject::_getMobsOfObject('frm~:html', $ilUser->getId());
foreach ($mediaObjects as $mob) {
foreach ($myMediaObjects as $myMob) {
if ($mob == $myMob) {
// change usage
ilObjMediaObject::_removeUsage($mob, 'frm~:html', $ilUser->getId());
break;
}
}
ilObjMediaObject::_saveUsage($mob, 'frm:html', $newPost);
}
$oFDForum = new ilFileDataForum($forumObj->getId(), $newPost);
$file = $_FILES['userfile'];
if (is_array($file) && !empty($file)) {
$oFDForum->storeUploadedFile($file);
}
// FINALLY SEND MESSAGE
if ($this->ilias->getSetting("forum_notification") == 1 && (int) $status) {
$objPost = new ilForumPost((int) $newPost, $this->is_moderator);
$post_data = array();
$post_data = $objPost->getDataAsArray();
$titles = $this->getTitlesByRefId(array($this->object->getRefId()));
$post_data["top_name"] = $titles[0];
$post_data["ref_id"] = $this->object->getRefId();
$frm->__sendMessage($objPost->getParentId(), $post_data);
$frm->sendForumNotifications($post_data);
$frm->sendThreadNotifications($post_data);
}
$message = '';
if (!$this->is_moderator && !$status) {
$message .= $lng->txt('forums_post_needs_to_be_activated');
} else {
$message .= $lng->txt('forums_post_new_entry');
}
$_SESSION['frm'][(int) $_GET['thr_pk']]['openTreeNodes'][] = (int) $this->objCurrentPost->getId();
ilUtil::sendSuccess($message, true);
$this->ctrl->setParameter($this, 'pos_pk', $newPost);
$this->ctrl->setParameter($this, 'thr_pk', $this->objCurrentPost->getThreadId());
$this->ctrl->redirect($this, 'viewThread');
} else {
if (!$this->is_moderator && !$this->objCurrentPost->isOwner($ilUser->getId()) || $this->objCurrentPost->isCensored() || $ilUser->getId() == ANONYMOUS_USER_ID) {
$this->ilias->raiseError($lng->txt('permission_denied'), $this->ilias->error_obj->MESSAGE);
}
// remove usage of deleted media objects
include_once 'Services/MediaObjects/classes/class.ilObjMediaObject.php';
$oldMediaObjects = ilObjMediaObject::_getMobsOfObject('frm:html', $this->objCurrentPost->getId());
$curMediaObjects = ilRTE::_getMediaObjects($oReplyEditForm->getInput('message'), 0);
foreach ($oldMediaObjects as $oldMob) {
$found = false;
foreach ($curMediaObjects as $curMob) {
if ($oldMob == $curMob) {
$found = true;
break;
}
}
if (!$found) {
if (ilObjMediaObject::_exists($oldMob)) {
ilObjMediaObject::_removeUsage($oldMob, 'frm:html', $this->objCurrentPost->getId());
$mob_obj = new ilObjMediaObject($oldMob);
$mob_obj->delete();
}
}
}
// if post has been edited posting mus be activated again by moderator
$status = 1;
$send_activation_mail = 0;
if ($this->objProperties->isPostActivationEnabled()) {
if (!$this->is_moderator) {
$status = 0;
$send_activation_mail = 1;
} else {
if ($this->objCurrentPost->isAnyParentDeactivated()) {
$status = 0;
}
}
}
$this->objCurrentPost->setStatus($status);
$this->objCurrentPost->setSubject($this->handleFormInput($oReplyEditForm->getInput('subject'), false));
$this->objCurrentPost->setMessage(ilRTE::_replaceMediaObjectImageSrc($oReplyEditForm->getInput('message'), 0));
$this->objCurrentPost->setNotification((int) $oReplyEditForm->getInput('notify'));
$this->objCurrentPost->setChangeDate(date('Y-m-d H:i:s'));
$this->objCurrentPost->setUpdateUserId($ilUser->getId());
// edit: update post
if ($this->objCurrentPost->update()) {
$this->objCurrentPost->reload();
// Change news item accordingly
include_once 'Services/News/classes/class.ilNewsItem.php';
// note: $this->objCurrentPost->getForumId() does not give us the forum ID here (why?)
$news_id = ilNewsItem::getFirstNewsIdForContext($forumObj->getId(), 'frm', $this->objCurrentPost->getId(), 'pos');
if ($news_id > 0) {
$news_item = new ilNewsItem($news_id);
$news_item->setTitle($this->objCurrentPost->getSubject());
$news_item->setContent(ilRTE::_replaceMediaObjectImageSrc($frm->prepareText($this->objCurrentPost->getMessage(), 0), 1));
$news_item->update();
}
// attachments
$oFDForum = $oForumObjects['file_obj'];
$file = $_FILES['userfile'];
if (is_array($file) && !empty($file)) {
$oFDForum->storeUploadedFile($file);
}
$file2delete = $oReplyEditForm->getInput('del_file');
if (is_array($file2delete) && count($file2delete)) {
$oFDForum->unlinkFilesByMD5Filenames($file2delete);
}
}
if (!$status && $send_activation_mail) {
$pos_data = $this->objCurrentPost->getDataAsArray();
$pos_data["top_name"] = $this->object->getTitle();
$frm->sendPostActivationNotification($pos_data);
}
ilUtil::sendSuccess($lng->txt('forums_post_modified'), true);
$this->ctrl->setParameter($this, 'pos_pk', $this->objCurrentPost->getId());
$this->ctrl->setParameter($this, 'thr_pk', $this->objCurrentPost->getThreadId());
$this->ctrl->setParameter($this, 'viewmode', $_SESSION['viewmode']);
$this->ctrl->redirect($this, 'viewThread');
}
} else {
$_GET['action'] = substr($_GET['action'], 6);
}
return $this->viewThreadObject();
}
/**
* Create
*/
function updateNews($a_update = false)
{
global $ilUser;
$news_set = new ilSetting("news");
$default_visibility = $news_set->get("default_visibility") != "" ? $news_set->get("default_visibility") : "users";
include_once "./Services/News/classes/class.ilNewsItem.php";
if (!$a_update) {
$news_item = new ilNewsItem();
$news_item->setContext($this->getWikiId(), "wiki", $this->getId(), "wpg");
$news_item->setPriority(NEWS_NOTICE);
$news_item->setTitle($this->getTitle());
$news_item->setContentTextIsLangVar(true);
$news_item->setContent("wiki_news_page_created");
$news_item->setUserId($ilUser->getId());
$news_item->setVisibility($default_visibility);
$news_item->create();
} else {
// get last news item of the day (if existing)
$news_id = ilNewsItem::getLastNewsIdForContext($this->getWikiId(), "wiki", $this->getId(), "wpg", true);
if ($news_id > 0) {
$news_item = new ilNewsItem($news_id);
$news_item->setContent("wiki_news_page_changed");
$news_item->setUserId($ilUser->getId());
$news_item->setTitle($this->getTitle());
$news_item->setContentTextIsLangVar(true);
$news_item->update(true);
} else {
$news_item = new ilNewsItem();
$news_item->setContext($this->getWikiId(), "wiki", $this->getId(), "wpg");
$news_item->setPriority(NEWS_NOTICE);
$news_item->setTitle($this->getTitle());
$news_item->setContentTextIsLangVar(true);
$news_item->setContent("wiki_news_page_changed");
$news_item->setUserId($ilUser->getId());
$news_item->setVisibility($default_visibility);
$news_item->create();
}
}
}
/**
* update dataset in frm_posts with censorship info
* @param string message
* @param integer pos_pk
* @return boolean
* @access public
*/
public function postCensorship($message, $pos_pk, $cens = 0)
{
global $ilDB;
$statement = $ilDB->manipulateF('
UPDATE frm_posts
SET pos_cens_com = %s,
pos_update = %s,
pos_cens = %s,
update_user = %s
WHERE pos_pk = %s', array('text', 'timestamp', 'integer', 'integer', 'integer'), array($message, date("Y-m-d H:i:s"), $cens, $_SESSION['AccountId'], $pos_pk));
// Change news item accordingly
include_once "./Services/News/classes/class.ilNewsItem.php";
$news_id = ilNewsItem::getFirstNewsIdForContext($this->id, "frm", $pos_pk, "pos");
if ($news_id > 0) {
if ($cens > 0) {
$news_item = new ilNewsItem($news_id);
//$news_item->setTitle($subject);
$news_item->setContent(nl2br($this->prepareText($message, 0)));
$news_item->update();
} else {
// get original message
$res = $ilDB->queryf('
SELECT * FROM frm_posts
WHERE pos_pk = %s', array('integer'), array($pos_pk));
$rec = $ilDB->fetchAssoc($res);
$news_item = new ilNewsItem($news_id);
//$news_item->setTitle($subject);
$news_item->setContent(nl2br($this->prepareText($rec["pos_message"], 0)));
$news_item->update();
}
}
return true;
}
