ilForum Class Reference

Class Forum core functions for forum. More...

Collaboration diagram for ilForum:

Public Member Functions
	__construct ()
	Constructor public. More...
	setLanguage ($lng)
	setForumId ($a_obj_id)
	set object id which refers to ILIAS obj_id More...
	setForumRefId ($a_ref_id)
	set reference id which refers to ILIAS obj_id More...
	getForumId ()
	get forum id public More...
	getForumRefId ()
	get forum ref_id public More...
	getOrderField ()
	get name of orderField More...
	setDbTable ($dbTable)
	set database table More...
	getDbTable ()
	get name of database table More...
	setMDB2WhereCondition ($query_string, $data_type, $data_value)
	set content for additional condition More...
	getMDB2Query ()
	get content of additional condition More...
	getMDB2DataValue ()
	get content of additional condition More...
	getMDB2DataType ()
	get content of additional condition More...
	setPageHits ($pageHits)
	getPageHits ()
	get number of max. More...
	getOneTopic ()
	get one topic-dataset by WhereCondition More...
	getOneThread ()
	get one thread-dataset by WhereCondition More...
	getOnePost ($post)
	get one post-dataset More...
	generatePost ($forum_id, $thread_id, $author_id, $display_user_id, $message, $parent_pos, $notify, $subject='', $alias='', $date='', $status=1, $send_activation_mail=0)
	generate new dataset in frm_posts More...
	generateThread (ilForumTopic $thread, $message, $notify, $notify_posts, $status=1)
	moveThreads ($thread_ids=array(), $src_ref_id=0, $dest_top_frm_fk=0)
	Moves all chosen threads and their posts to a new forum. More...
	postCensorship ($message, $pos_pk, $cens=0)
	update dataset in frm_posts with censorship info More...
	deletePost ($post)
	delete post and sub-posts More...
	getAllThreads ($a_topic_id, array $params=array(), $limit=0, $offset=0)
	getUserStatistic ($is_moderator=false)
	getFirstPostByThread ($a_thread_id)
	Get first post of thread. More...
	getModerators ()
	get all users assigned to local role il_frm_moderator_<frm_ref_id> More...
	countUserArticles ($a_user_id)
	get number of articles from given user-ID More...
	countActiveUserArticles ($a_user_id)
	convertDate ($date)
	converts the date format More...
	addPostTree ($a_tree_id, $a_node_id=-1, $a_date='')
	create a new post-tree More...
	insertPostNode ($a_node_id, $a_parent_id, $tree_id, $a_date='')
	insert node under parent node public More...
	getPostDepth ($a_node_id, $tree_id)
	Return depth of an object private. More...
	getFirstPostNode ($tree_id)
	get data of the first node from frm_posts_tree and frm_posts public More...
	getPostNode ($post_id)
	get data of given node from frm_posts_tree and frm_posts public More...
	fetchPostNodeData ($a_row)
	get data of parent node from frm_posts_tree and frm_posts private More...
	deletePostTree ($a_node)
	delete node and the whole subtree under this node public More...
	updateVisits ($ID)
	update page hits of given forum- or thread-ID public More...
	prepareText ($text, $edit=0, $quote_user='', $type='')
	prepares given string public More...
	__deletePostFiles ($a_ids)
	getImportName ()
	setImportName ($a_import_name)
	enableForumNotification ($user_id)
	Enable a user's notification about new posts in this forum. More...
	disableForumNotification ($user_id)
	Disable a user's notification about new posts in this forum. More...
	isForumNotificationEnabled ($user_id)
	Check whether a user's notification about new posts in this forum is enabled (result > 0) or not (result == 0) More...
	enableThreadNotification ($user_id, $thread_id)
	no usage? ..delete . More...
	isThreadNotificationEnabled ($user_id, $thread_id)
	Check whether a user's notification about new posts in a thread is enabled (result > 0) or not (result == 0) More...

Static Public Member Functions
static	_getLanguageInstanceByUsrId ($usr_id)
	Get the ilLanguage instance for the passed user id. More...
static	_lookupPostMessage ($a_id)
static	_getModerators ($a_ref_id)
	get all users assigned to local role il_frm_moderator_<frm_ref_id> (static) More...
static	_isModerator ($a_ref_id, $a_usr_id)
	checks whether a user is moderator of a given forum object More...
static	_getThreads ($a_obj_id, $a_sort_mode=self::SORT_DATE)
	Get thread infos of object. More...
static	_lookupObjIdForForumId ($a_for_id)
static	updateLastPostByObjId ($a_obj_id)
static	mergeThreads ($obj_id, $source_id, $target_id)

Data Fields
const	SORT_TITLE = 1
const	SORT_DATE = 2
const	DEFAULT_PAGE_HITS = 30
	$lng
	$error
	$db
	$user
	$settings

Static Protected Attributes
static	$moderators_by_ref_id_map = array()

Private Member Functions
	setOrderField ($orderField)
	set database field for sorting results More...

Private Attributes
	$dbTable
	$className ="ilForum"
	$orderField
	$mdb2Query
	$mdb2DataValue
	$mdb2DataType
	$txtQuote1 = "[quote]"
	$txtQuote2 = "[/quote]"
	$replQuote1 = '<blockquote class="ilForumQuote">'
	$replQuote2 = '</blockquote>'
	$pageHits = self::DEFAULT_PAGE_HITS
	$id

Detailed Description

Class Forum core functions for forum.

Author

Wolfgang Merkens wmerk.nosp@m.ens@.nosp@m.datab.nosp@m.ay.d.nosp@m.e

Version

$Id$

Definition at line 18 of file class.ilForum.php.

Constructor & Destructor Documentation

__construct()

ilForum::__construct

(

)

Constructor public.

Definition at line 78 of file class.ilForum.php.

References $DIC, settings(), and user().

    {
        global $DIC;

        $this->error = $DIC['ilErr'];
        $this->lng = $DIC->language();
        $this->db = $DIC->database();
        $this->user = $DIC->user();
        $this->settings = $DIC->settings();
    }

Here is the call graph for this function:

Member Function Documentation

__deletePostFiles()

ilForum::__deletePostFiles

(

$a_ids

)

Definition at line 1883 of file class.ilForum.php.

References $file, $files, and getForumId().

Referenced by deletePost().

    {
        if (!is_array($a_ids)) {
            return false;
        }
        include_once "./Modules/Forum/classes/class.ilFileDataForum.php";
        
        $tmp_file_obj = new ilFileDataForum($this->getForumId());
        foreach ($a_ids as $pos_id) {
            $tmp_file_obj->setPosId($pos_id);
            $files = $tmp_file_obj->getFilesOfPost();
            foreach ($files as $file) {
                $tmp_file_obj->unlinkFile($file["name"]);
            }
        }
        unset($tmp_file_obj);
        return true;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_getLanguageInstanceByUsrId()

static ilForum::_getLanguageInstanceByUsrId (   $usr_id )

static

Get the ilLanguage instance for the passed user id.

Parameters

integer

$usr_id

a user id

Returns

ilLanguage public

Definition at line 105 of file class.ilForum.php.

References ilObjUser\_lookupLanguage(), and array.

    {
        static $lngCache = array();
        
        $languageShorthandle = ilObjUser::_lookupLanguage($usr_id);
        
        // lookup in cache array
        if (!isset($lngCache[$languageShorthandle])) {
            $lngCache[$languageShorthandle] = new ilLanguage($languageShorthandle);
            $lngCache[$languageShorthandle]->loadLanguageModule('forum');
        }
        
        return $lngCache[$languageShorthandle];
    }

Here is the call graph for this function:

_getModerators()

static ilForum::_getModerators (   $a_ref_id )

static

get all users assigned to local role il_frm_moderator_<frm_ref_id> (static)

Parameters

int

$a_ref_id

reference id

Returns

array user_ids public

Definition at line 1380 of file class.ilForum.php.

References $DIC, ilObject\_lookupTitle(), and array.

Referenced by ilForumNotification\checkParentNodeTree(), ilObjForumNotificationDataProvider\getPostActivationRecipients(), ilForumSettingsGUI\showMembers(), and ilForumSettingsGUI\updateUserNotifications().

    {
        global $DIC;
        $rbacreview = $DIC->rbac()->review();

        $role_arr = $rbacreview->getRolesOfRoleFolder($a_ref_id);
        foreach ($role_arr as $role_id) {
            if (ilObject::_lookupTitle($role_id) == 'il_frm_moderator_' . $a_ref_id) {
                return $rbacreview->assignedUsers($role_id);
            }
        }

        return array();
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_getThreads()

static ilForum::_getThreads (   $a_obj_id,   $a_sort_mode = self::SORT_DATE  )

static

Get thread infos of object.

Parameters

int	$a_obj_id
int	$a_sort_mode	SORT_TITLE or SORT_DATE

Returns

array

Definition at line 2085 of file class.ilForum.php.

References $DIC, $ilDB, $res, $row, and array.

Referenced by ilObjForumGUI\cloneWizardPageObject(), and ilObjForumSearchResultTableGUI\parse().

    {
        global $DIC;
        $ilDB = $DIC->database();
        
        switch ($a_sort_mode) {
            case self::SORT_DATE:
                $sort = 'thr_date';
                break;
            
            case self::SORT_TITLE:
            default:
                $sort = 'thr_subject';
                break;
        }
        
        $res = $ilDB->queryf(
            '
                        SELECT * FROM frm_threads 
                        JOIN frm_data ON top_pk = thr_top_fk 
                        WHERE top_frm_fk = %s
                        ORDER BY %s',
            array('integer', 'text'),
            array($a_obj_id, $sort)
        );
        
        while ($row = $ilDB->fetchObject($res)) {
            $threads[$row->thr_pk] = $row->thr_subject;
        }
        return $threads ? $threads : array();
    }

Here is the caller graph for this function:

_isModerator()

static ilForum::_isModerator (   $a_ref_id,   $a_usr_id  )

static

checks whether a user is moderator of a given forum object

Parameters

int	$a_ref_id	reference id
int	$a_usr_id	user id

Returns

bool public

Definition at line 1403 of file class.ilForum.php.

Referenced by ilObjForumGUI\renderDraftContent(), ilObjForumGUI\renderPostContent(), and ilForumExportGUI\renderPostHtml().

    {
        if (!self::$moderators_by_ref_id_map[$a_ref_id]) {
            self::$moderators_by_ref_id_map[$a_ref_id] = self::_getModerators($a_ref_id);
        }
        return in_array($a_usr_id, self::$moderators_by_ref_id_map[$a_ref_id]);
    }

Here is the caller graph for this function:

_lookupObjIdForForumId()

static ilForum::_lookupObjIdForForumId (   $a_for_id )

static

Definition at line 2117 of file class.ilForum.php.

References $DIC, $ilDB, $res, and array.

Referenced by ilForumPostingDraftsBlockGUI\fillDataSection(), ilObjMediaObject\getParentObjectIdForUsage(), ilObjForumGUI\mergeThreadsObject(), and ilForumTopic\movePosts().

    {
        global $DIC;
        $ilDB = $DIC->database();
        
        $res = $ilDB->queryf(
            '
                        SELECT top_frm_fk FROM frm_data
                        WHERE top_pk = %s',
            array('integer'),
            array($a_for_id)
        );
        
        if ($fdata = $ilDB->fetchAssoc($res)) {
            return $fdata["top_frm_fk"];
        }
        return false;
    }

Here is the caller graph for this function:

_lookupPostMessage()

static ilForum::_lookupPostMessage (   $a_id )

static

Definition at line 392 of file class.ilForum.php.

References $DIC, $ilDB, $res, $row, and array.

Referenced by ilObjForum\update().

    {
        global $DIC;
        $ilDB = $DIC->database();
        
        $res = $ilDB->queryf(
            '
                        SELECT * FROM frm_posts WHERE pos_pk = %s',
            array('integer'),
            array($a_id)
        );
        
        while ($row = $ilDB->fetchObject($res)) {
            return $row->pos_message;
        }
        return '';
    }

Here is the caller graph for this function:

addPostTree()

ilForum::addPostTree	(		$a_tree_id,
			$a_node_id = -1,
			$a_date = ''
	)

create a new post-tree

Parameters

integer	a_tree_id: id where tree belongs to
integer	a_node_id: root node of tree (optional; default is tree_id itself)

Returns

boolean true on success public

Definition at line 1471 of file class.ilForum.php.

References array, and date.

Referenced by generatePost().

    {
        $a_date = $a_date ? $a_date : date("Y-m-d H:i:s");
        
        if ($a_node_id <= 0) {
            $a_node_id = $a_tree_id;
        }
        
        $nextId = $this->db->nextId('frm_posts_tree');
        
        $this->db->manipulateF(
            '
                        INSERT INTO frm_posts_tree
                        (       fpt_pk,
                                thr_fk,
                                pos_fk,
                                parent_pos,
                                lft,
                                rgt,
                                depth,
                                fpt_date
                        )
                        VALUES(%s, %s, %s, %s,  %s,  %s, %s, %s )',
            array('integer','integer', 'integer', 'integer', 'integer', 'integer', 'integer', 'timestamp'),
            array($nextId, $a_tree_id, $a_node_id, '0', '1', '2', '1', $a_date)
        );
        
        return true;
    }

Here is the caller graph for this function:

convertDate()

ilForum::convertDate

(

$date

)

converts the date format

Parameters

string

$date

Returns

string formatted datetime public

Definition at line 1459 of file class.ilForum.php.

References ilDatePresentation\formatDate(), and IL_CAL_DATETIME.

Referenced by getOnePost().

    {
        return ilDatePresentation::formatDate(new ilDateTime($date, IL_CAL_DATETIME));
    }

Here is the call graph for this function:

Here is the caller graph for this function:

countActiveUserArticles()

ilForum::countActiveUserArticles

(

$a_user_id

)

Definition at line 1433 of file class.ilForum.php.

References $res, array, getForumId(), and user().

    {
        $res = $this->db->queryf(
            '
                        SELECT * FROM frm_data
                        INNER JOIN frm_posts ON pos_top_fk = top_pk
                        WHERE top_frm_fk = %s
                        AND (pos_status = %s
                                OR (pos_status = %s 
                                        AND pos_author_id = %s
                                        )
                                )          
                        AND pos_author_id = %s',
            array('integer', 'integer', 'integer', 'integer', 'integer'),
            array($this->getForumId(),'1', '0', $this->user->getId(), $a_user_id)
        );
        
        return $res->numRows();
    }

Here is the call graph for this function:

countUserArticles()

ilForum::countUserArticles

(

$a_user_id

)

get number of articles from given user-ID

Parameters

integer

$user,

user-ID

Returns

integer public

Definition at line 1418 of file class.ilForum.php.

References $res, array, and getForumId().

    {
        $res = $this->db->queryf(
            '
                        SELECT * FROM frm_data
                        INNER JOIN frm_posts ON pos_top_fk = top_pk 
                        WHERE top_frm_fk = %s
                        AND pos_author_id = %s',
            array('integer', 'integer'),
            array($this->getForumId(), $a_user_id)
        );
        
        return $res->numRows();
    }

Here is the call graph for this function:

deletePost()

ilForum::deletePost

(

$post

)

delete post and sub-posts

Parameters

integer

$post,

ID public

Returns

integer 0 or thread-ID

Definition at line 782 of file class.ilForum.php.

References $GLOBALS, $i, $mobs, $post, __deletePostFiles(), ilObjForum\_deleteAccessEntries(), ilObjForum\_deleteReadEntries(), ilObjMediaObject\_exists(), ilObjMediaObject\_getMobsOfObject(), ilObjMediaObject\_removeUsage(), array, deletePostTree(), ilNewsItem\getFirstNewsIdForContext(), getForumRefId(), and getPostNode().

    {
        include_once "./Modules/Forum/classes/class.ilObjForum.php";

        $p_node = $this->getPostNode($post);

        $GLOBALS['ilAppEventHandler']->raise(
            'Modules/Forum',
            'deletedPost',
            array(
                'ref_id' => $this->getForumRefId(),
                'post'           => new ilForumPost($post),
                'thread_deleted' => ($p_node["parent"] == 0)? true : false
            )
        );

        // delete tree and get id's of all posts to delete
        $del_id = $this->deletePostTree($p_node);

        // delete drafts_history
        $obj_history = new ilForumDraftsHistory();
        $obj_history->deleteHistoryByPostIds($del_id);
        // delete all drafts
        $obj_draft = new ilForumPostDraft();
        $obj_draft->deleteDraftsByPostIds($del_id);

        // Delete User read entries
        foreach ($del_id as $post_id) {
            ilObjForum::_deleteReadEntries($post_id);
        }

        // DELETE ATTACHMENTS ASSIGNED TO POST
        $this->__deletePostFiles($del_id);
        
        $dead_pos = count($del_id);
        $dead_thr = 0;

        // if deletePost is thread opener ...
        if ($p_node["parent"] == 0) {
            // delete thread access data
            include_once './Modules/Forum/classes/class.ilObjForum.php';

            ilObjForum::_deleteAccessEntries($p_node['tree']);

            // delete thread
            $dead_thr = $p_node["tree"];

            $this->db->manipulateF(
                '
                                DELETE FROM frm_threads
                                WHERE thr_pk = %s',
                array('integer'),
                array($p_node['tree'])
            );

            // update num_threads
            $this->db->manipulateF(
                '
                                UPDATE frm_data 
                                SET top_num_threads = top_num_threads - 1 
                                WHERE top_frm_fk = %s',
                array('integer'),
                array($this->id)
            );
            
            // delete all related news
            $posset = $this->db->queryf(
                '
                                SELECT * FROM frm_posts
                                WHERE pos_thr_fk = %s',
                array('integer'),
                array($p_node['tree'])
            );
            
            while ($posrec = $this->db->fetchAssoc($posset)) {
                include_once("./Services/News/classes/class.ilNewsItem.php");
                $news_id = ilNewsItem::getFirstNewsIdForContext(
                    $this->id,
                    "frm",
                    $posrec["pos_pk"],
                    "pos"
                );
                if ($news_id > 0) {
                    $news_item = new ilNewsItem($news_id);
                    $news_item->delete();
                }
                
                try {
                    include_once 'Services/MediaObjects/classes/class.ilObjMediaObject.php';
                    $mobs = ilObjMediaObject::_getMobsOfObject('frm:html', $posrec['pos_pk']);
                    foreach ($mobs as $mob) {
                        if (ilObjMediaObject::_exists($mob)) {
                            ilObjMediaObject::_removeUsage($mob, 'frm:html', $posrec['pos_pk']);
                            $mob_obj = new ilObjMediaObject($mob);
                            $mob_obj->delete();
                        }
                    }
                } catch (Exception $e) {
                }
            }
            
            // delete all posts of this thread
            $this->db->manipulateF(
                '
                                DELETE FROM frm_posts
                                WHERE pos_thr_fk = %s',
                array('integer'),
                array($p_node['tree'])
            );
        } else {
            // delete this post and its sub-posts
            for ($i = 0; $i < $dead_pos; $i++) {
                $this->db->manipulateF(
                     '
                                        DELETE FROM frm_posts
                                        WHERE pos_pk = %s',
                     array('integer'),
                     array($del_id[$i])
                 );
                
                // delete related news item
                include_once("./Services/News/classes/class.ilNewsItem.php");
                $news_id = ilNewsItem::getFirstNewsIdForContext(
                    $this->id,
                    "frm",
                    $del_id[$i],
                    "pos"
                );
                if ($news_id > 0) {
                    $news_item = new ilNewsItem($news_id);
                    $news_item->delete();
                }
                
                try {
                    include_once 'Services/MediaObjects/classes/class.ilObjMediaObject.php';
                    $mobs = ilObjMediaObject::_getMobsOfObject('frm:html', $del_id[$i]);
                    foreach ($mobs as $mob) {
                        if (ilObjMediaObject::_exists($mob)) {
                            ilObjMediaObject::_removeUsage($mob, 'frm:html', $del_id[$i]);
                            $mob_obj = new ilObjMediaObject($mob);
                            $mob_obj->delete();
                        }
                    }
                } catch (Exception $e) {
                }
            }
            
            // update num_posts in frm_threads
            $this->db->manipulateF(
                '
                                UPDATE frm_threads
                                SET thr_num_posts = thr_num_posts - %s
                                WHERE thr_pk = %s',
                array('integer', 'integer'),
                array($dead_pos, $p_node['tree'])
            );
            
            // get latest post of thread and update last_post
            $res1 = $this->db->queryf(
                '
                                SELECT * FROM frm_posts 
                                WHERE pos_thr_fk = %s
                                ORDER BY pos_date DESC',
                array('integer'),
                array($p_node['tree'])
            );
            
            if ($res1->numRows() == 0) {
                $lastPost_thr = "";
            } else {
                $z = 0;

                while ($selData = $this->db->fetchAssoc($res1)) {
                    if ($z > 0) {
                        break;
                    }

                    $lastPost_thr = $selData["pos_top_fk"] . "#" . $selData["pos_thr_fk"] . "#" . $selData["pos_pk"];
                    $z++;
                }
            }
            
            $this->db->manipulateF(
                '
                                UPDATE frm_threads
                                SET thr_last_post = %s
                                WHERE thr_pk = %s',
                array('text', 'integer'),
                array($lastPost_thr, $p_node['tree'])
            );
        }
        
        // update num_posts in frm_data
        $this->db->manipulateF(
             '
                        UPDATE frm_data
                        SET top_num_posts = top_num_posts - %s
                        WHERE top_frm_fk = %s',
             array('integer', 'integer'),
             array($dead_pos, $this->id)
         );
        
        // get latest post of forum and update last_post
        $res2 = $this->db->queryf(
            '
                        SELECT * FROM frm_posts, frm_data 
                        WHERE pos_top_fk = top_pk 
                        AND top_frm_fk = %s
                        ORDER BY pos_date DESC',
            array('integer'),
            array($this->id)
        );
        
        if ($res2->numRows() == 0) {
            $lastPost_top = "";
        } else {
            $z = 0;

            while ($selData = $this->db->fetchAssoc($res2)) {
                if ($z > 0) {
                    break;
                }

                $lastPost_top = $selData["pos_top_fk"] . "#" . $selData["pos_thr_fk"] . "#" . $selData["pos_pk"];
                $z++;
            }
        }
        
        $this->db->manipulateF(
            '
                        UPDATE frm_data
                        SET top_last_post = %s
                        WHERE top_frm_fk = %s',
            array('text', 'integer'),
            array($lastPost_top, $this->id)
        );
        
        return $dead_thr;
    }

Here is the call graph for this function:

deletePostTree()

ilForum::deletePostTree

(

$a_node

)

delete node and the whole subtree under this node public

Parameters

array

node_data of a node

Returns

array ID's of deleted posts

Definition at line 1704 of file class.ilForum.php.

References $res, $result, $row, and array.

Referenced by deletePost().

    {
        // GET LEFT AND RIGHT VALUES
        $res = $this->db->queryf(
            '
                        SELECT * FROM frm_posts_tree
                        WHERE thr_fk = %s 
                        AND pos_fk = %s
                        AND parent_pos = %s',
            array('integer', 'integer', 'integer'),
            array($a_node['tree'], $a_node['pos_pk'], $a_node['parent'])
        );
        
        while ($row = $this->db->fetchObject($res)) {
            $a_node["lft"] = $row->lft;
            $a_node["rgt"] = $row->rgt;
        }

        $diff = $a_node["rgt"] - $a_node["lft"] + 1;
        
        // get data of posts
        $result = $this->db->queryf(
            '
                        SELECT * FROM frm_posts_tree 
                        WHERE lft BETWEEN %s AND %s
                        AND thr_fk = %s',
            array('integer', 'integer', 'integer'),
            array($a_node['lft'], $a_node['rgt'], $a_node['tree'])
        );
        
        $del_id = array();
        
        while ($treeData = $this->db->fetchAssoc($result)) {
            $del_id[] = $treeData["pos_fk"];
        }
        
        // delete subtree
        $this->db->manipulateF(
            '
                        DELETE FROM frm_posts_tree
                        WHERE lft BETWEEN %s AND %s
                        AND thr_fk = %s',
            array('integer', 'integer', 'integer'),
            array($a_node['lft'], $a_node['rgt'], $a_node['tree'])
        );
        
        // close gaps
        $this->db->manipulateF(
            '
                        UPDATE frm_posts_tree 
                        SET lft = CASE 
                                                WHEN lft > %s
                                                THEN lft - %s
                                                ELSE lft 
                                                END, 
                                rgt = CASE 
                                                WHEN rgt > %s
                                                THEN rgt - %s
                                                ELSE rgt 
                                                END 
                        WHERE thr_fk = %s',
            array('integer', 'integer', 'integer', 'integer', 'integer'),
            array($a_node['lft'], $diff, $a_node['lft'], $diff, $a_node['tree'])
        );
        
        return $del_id;
    }

Here is the caller graph for this function:

disableForumNotification()

ilForum::disableForumNotification

(

$user_id

)

Disable a user's notification about new posts in this forum.

Parameters

integer

user_id A user's ID

Returns

bool true private

Definition at line 1990 of file class.ilForum.php.

References array.

    {
        $this->db->manipulateF(
            '
                        DELETE FROM frm_notification 
                        WHERE user_id = %s
                        AND frm_id = %s',
            array('integer', 'integer'),
            array($user_id, $this->id)
        );
        
        return true;
    }

enableForumNotification()

ilForum::enableForumNotification

(

$user_id

)

Enable a user's notification about new posts in this forum.

Parameters

integer

user_id A user's ID

Returns

bool true private

Definition at line 1917 of file class.ilForum.php.

References $counter, $query, $res, $row, array, and isForumNotificationEnabled().

    {
        if (!$this->isForumNotificationEnabled($user_id)) {
            /* Remove all notifications of threads that belong to the forum */
                
            $res = $this->db->queryf(
                '
                                SELECT frm_notification.thread_id FROM frm_data, frm_notification, frm_threads 
                                WHERE frm_notification.user_id = %s
                                AND frm_notification.thread_id = frm_threads.thr_pk 
                                AND frm_threads.thr_top_fk = frm_data.top_pk 
                                AND frm_data.top_frm_fk = %s
                                GROUP BY frm_notification.thread_id',
                array('integer', 'integer'),
                array($user_id, $this->id)
            );
            
            if (is_object($res) && $res->numRows() > 0) {
                $thread_data = array();
                $thread_data_types = array();

                $query = ' DELETE FROM frm_notification 
                                                        WHERE user_id = %s 
                                                        AND thread_id IN (';
                
                array_push($thread_data, $user_id);
                array_push($thread_data_types, 'integer');
                
                $counter = 1;

                while ($row = $this->db->fetchAssoc($res)) {
                    if ($counter < $res->numRows()) {
                        $query .= '%s, ';
                        array_push($thread_data, $row['thread_id']);
                        array_push($thread_data_types, 'integer');
                    }
            
                    if ($counter == $res->numRows()) {
                        $query .= '%s)';
                        array_push($thread_data, $row['thread_id']);
                        array_push($thread_data_types, 'integer');
                    }
                    $counter++;
                }

                $this->db->manipulateF($query, $thread_data_types, $thread_data);
            }

            /* Insert forum notification */

            $nextId = $this->db->nextId('frm_notification');
            
            $this->db->manipulateF(
                '
                                INSERT INTO frm_notification
                                (       notification_id,
                                        user_id, 
                                        frm_id
                                )
                                VALUES(%s, %s, %s)',
                array('integer','integer', 'integer'),
                array($nextId, $user_id, $this->id)
            );
        }
        return true;
    }

Here is the call graph for this function:

enableThreadNotification()

ilForum::enableThreadNotification	(		$user_id,
			$thread_id
	)

no usage? ..delete .

Enable a user's notification about new posts in a thread

Parameters

integer	user_id A user's ID
integer	thread_id ID of the thread

Returns

bool true private

Definition at line 2034 of file class.ilForum.php.

References array, and isThreadNotificationEnabled().

    {
        if (!$this->isThreadNotificationEnabled($user_id, $thread_id)) {
            $nextId = $this->db->nextId('frm_notification');
            $this->db->manipulateF(
                '
                                INSERT INTO frm_notification
                                (       notification_id,
                                        user_id,
                                        thread_id
                                )
                                VALUES (%s, %s, %s)',
                array('integer', 'integer', 'integer'),
                array($nextId, $user_id, $thread_id)
            );
        }

        return true;
    }

Here is the call graph for this function:

fetchPostNodeData()

ilForum::fetchPostNodeData

(

$a_row

)

get data of parent node from frm_posts_tree and frm_posts private

Parameters

object

db db result object containing node_data

Returns

array 2-dim (int/str) node_data

Definition at line 1655 of file class.ilForum.php.

References $data, ilObject\_exists(), and array.

Referenced by getFirstPostNode(), and getPostNode().

    {
        require_once('./Services/User/classes/class.ilObjUser.php');
        
        if (ilObject::_exists($a_row->pos_display_user_id)) {
            $tmp_user = new ilObjUser($a_row->pos_display_user_id);
            $fullname = $tmp_user->getFullname();
            $loginname = $tmp_user->getLogin();
        }
    
        $fullname = $fullname ? $fullname : ($a_row->import_name ? $a_row->import_name : $this->lng->txt("unknown"));

        $data = array(
                    "pos_pk"            => $a_row->pos_pk,
                    "child"         => $a_row->pos_pk,
                    "author"            => $a_row->pos_display_user_id,
                    "alias"                     => $a_row->pos_usr_alias,
                    "title"         => $fullname,
                    "loginname"         => $loginname,
                    "type"          => "post",
                    "message"           => $a_row->pos_message,
                    "subject"           => $a_row->pos_subject,
                    "pos_cens_com"      => $a_row->pos_cens_com,
                    "pos_cens"          => $a_row->pos_cens,
                //      "date"                  => $a_row->date,
                    "date"                      => $a_row->fpt_date,
                    "create_date"       => $a_row->pos_date,
                    "update"            => $a_row->pos_update,
                    "update_user"       => $a_row->update_user,
                    "tree"                      => $a_row->thr_fk,
                    "parent"            => $a_row->parent_pos,
                    "lft"                       => $a_row->lft,
                    "rgt"                       => $a_row->rgt,
                    "depth"                     => $a_row->depth,
                    "id"                        => $a_row->fpt_pk,
                    "notify"            => $a_row->notify,
                    "import_name"   => $a_row->import_name,
                    "pos_status"   => $a_row->pos_status
                    );
        
        return $data ? $data : array();
    }

Here is the call graph for this function:

Here is the caller graph for this function:

generatePost()

ilForum::generatePost	(		$forum_id,
			$thread_id,
			$author_id,
			$display_user_id,
			$message,
			$parent_pos,
			$notify,
			$subject = '',
			$alias = '',
			$date = '',
			$status = 1,
			$send_activation_mail = 0
	)

generate new dataset in frm_posts

Parameters

int	$forum_id
int	$thread_id
int	$author_id
int	$display_user_id
string	$message
int	$parent_pos
int	$notify
string	$subject
string	$alias
string	$date	datetime|timestamp
int	$status
int	$send_activation_mail

Returns

int new post_id

Definition at line 426 of file class.ilForum.php.

References $message, ilRTE\_replaceMediaObjectImageSrc(), addPostTree(), array, date, getForumId(), getForumRefId(), getImportName(), ilForumProperties\getInstance(), ilObjectFactory\getInstanceByRefId(), insertPostNode(), NEWS_NOTICE, NEWS_USERS, and prepareText().

Referenced by generateThread().

    {
        $objNewPost = new ilForumPost();
        $objNewPost->setForumId($forum_id);
        $objNewPost->setThreadId($thread_id);
        $objNewPost->setSubject($subject);
        $objNewPost->setMessage($message);
        $objNewPost->setDisplayUserId($display_user_id);
        $objNewPost->setUserAlias($alias);
        $objNewPost->setPosAuthorId($author_id);
        
        $frm_settings = ilForumProperties::getInstance($this->getForumId());
        
        if ($frm_settings->getMarkModeratorPosts() == 1) {
            self::_isModerator($this->getForumRefId(), $author_id) ? $is_moderator = true : $is_moderator = false;
        } else {
            $is_moderator = false;
        }
        $objNewPost->setIsAuthorModerator($is_moderator);
        
        if ($date == "") {
            $objNewPost->setCreateDate(date("Y-m-d H:i:s"));
        } else {
            if (strpos($date, "-") >  0) {              // in mysql format
                $objNewPost->setCreateDate($date);
            } else {                                                            // a timestamp
                $objNewPost->setCreateDate(date("Y-m-d H:i:s", $date));
            }
        }
        if ($status == 1) {
            $objNewPost->setPostActivationDate($objNewPost->getCreateDate());
        }

        $objNewPost->setImportName($this->getImportName());
        $objNewPost->setNotification($notify);
        $objNewPost->setStatus($status);
        $objNewPost->insert();
        
        // entry in tree-table
        if ($parent_pos == 0) {
            $this->addPostTree($objNewPost->getThreadId(), $objNewPost->getId(), $objNewPost->getCreateDate());
        } else {
            $this->insertPostNode($objNewPost->getId(), $parent_pos, $objNewPost->getThreadId(), $objNewPost->getCreateDate());
        }
        
        // string last post
        $lastPost = $objNewPost->getForumId() . "#" . $objNewPost->getThreadId() . "#" . $objNewPost->getId();
            
        // update thread
        $this->db->manipulateF(
            '
                        UPDATE frm_threads 
                        SET thr_num_posts = thr_num_posts + 1,
                                thr_last_post = %s
                        WHERE thr_pk = %s',
            array('text', 'integer'),
            array($lastPost, $objNewPost->getThreadId())
        );
        
        // update forum
        $this->db->manipulateF(
            '
                        UPDATE frm_data 
                        SET top_num_posts = top_num_posts + 1,
                                top_last_post = %s
                        WHERE top_pk = %s',
            array('text', 'integer'),
            array($lastPost, $objNewPost->getForumId())
        );
        
        // MARK READ
        $forum_obj = ilObjectFactory::getInstanceByRefId($this->getForumRefId());
        $forum_obj->markPostRead($objNewPost->getPosAuthorId(), $objNewPost->getThreadId(), $objNewPost->getId());

        // Add Notification to news
        if ($status) {
            require_once 'Services/RTE/classes/class.ilRTE.php';
            include_once("./Services/News/classes/class.ilNewsItem.php");
            $news_item = new ilNewsItem();
            $news_item->setContext($forum_obj->getId(), 'frm', $objNewPost->getId(), 'pos');
            $news_item->setPriority(NEWS_NOTICE);
            $news_item->setTitle($objNewPost->getSubject());
            $news_item->setContent(ilRTE::_replaceMediaObjectImageSrc($this->prepareText($objNewPost->getMessage(), 0), 1));
            if ($objNewPost->getMessage() != strip_tags($objNewPost->getMessage())) {
                $news_item->setContentHtml(true);
            }
            
            $news_item->setUserId($display_user_id);
            $news_item->setVisibility(NEWS_USERS);
            $news_item->create();
        }

        return $objNewPost->getId();
    }

Here is the call graph for this function:

Here is the caller graph for this function:

generateThread()

ilForum::generateThread	(	ilForumTopic	$thread,
			$message,
			$notify,
			$notify_posts,
			$status = 1
	)

Parameters

ilForumTopic	$thread
string	$message
int	$notify
int	$notify_posts
int	$status

Returns

int The id of the new posting, created implicitly when creating new threads

Definition at line 529 of file class.ilForum.php.

References $message, array, date, ilForumTopic\enableNotification(), generatePost(), ilForumTopic\getCreateDate(), ilForumTopic\getDisplayUserId(), ilForumTopic\getForumId(), ilForumTopic\getId(), getImportName(), ilForumTopic\getSubject(), ilForumTopic\getThrAuthorId(), ilForumTopic\getUserAlias(), ilForumTopic\insert(), ilForumTopic\setCreateDate(), and ilForumTopic\setImportName().

    {
        if (!$thread->getCreateDate()) {
            $thread->setCreateDate(date('Y-m-d H:i:s'));
        }

        $thread->setImportName($this->getImportName());
        $thread->insert();

        if ($notify_posts == 1) {
            $thread->enableNotification($thread->getThrAuthorId());
        }

        $this->db->manipulateF(
            '
                        UPDATE frm_data 
                        SET top_num_threads = top_num_threads + 1
                        WHERE top_pk = %s',
            array('integer'),
            array($thread->getForumId())
        );
        
        return $this->generatePost(
            $thread->getForumId(),
            $thread->getId(),
            $thread->getThrAuthorId(),
            $thread->getDisplayUserId(),
            $message,
            0,
            $notify,
            $thread->getSubject(),
            $thread->getUserAlias(),
            $thread->getCreateDate(),
            $status,
            0
        );
    }

Here is the call graph for this function:

getAllThreads()

ilForum::getAllThreads	(		$a_topic_id,
		array	$params = array(),
			$limit = 0,
			$offset = 0
	)

Parameters

	$a_topic_id
array	$params
int	$limit
int	$offset

Returns

array

Definition at line 1029 of file class.ilForum.php.

References $data, $params, $query, $res, $row, array, date, ilForumProperties\FORUM_OVERVIEW_WITH_NEW_POSTS, getForumId(), ilForumProperties\getInstance(), settings(), and user().

    {
        $frm_overview_setting       = (int) $this->settings->get('forum_overview');
        $frm_props                  = ilForumProperties::getInstance($this->getForumId());
        $is_post_activation_enabled = $frm_props->isPostActivationEnabled();
        
        $user_id = $this->user->getId();
        
        $excluded_ids_condition = '';
        if (isset($params['excluded_ids']) && is_array($params['excluded_ids']) && $params['excluded_ids']) {
            $excluded_ids_condition = ' AND ' . $this->db->in('thr_pk', $params['excluded_ids'], true, 'integer') . ' ';
        }
        
        if (!in_array(strtolower($params['order_column']), array('lp_date', 'rating', 'thr_subject', 'num_posts', 'num_visit'))) {
            $params['order_column'] = 'post_date';
        }
        if (!in_array(strtolower($params['order_direction']), array('asc', 'desc'))) {
            $params['order_direction'] = 'desc';
        }

        $cnt_active_pos_query = '';
        $cnt_join_type        = 'LEFT';
        if ($is_post_activation_enabled && !$params['is_moderator']) {
            $cnt_active_pos_query = " AND (pos_status = {$this->db->quote(1, 'integer')} OR pos_author_id = {$this->db->quote($user_id, 'integer')}) ";
            $cnt_join_type        = "INNER";
        }
        $query =
            "SELECT COUNT(DISTINCT(thr_pk)) cnt
                         FROM frm_threads
                         {$cnt_join_type} JOIN frm_posts
                                ON pos_thr_fk = thr_pk {$cnt_active_pos_query}
                         WHERE thr_top_fk = %s {$excluded_ids_condition}
                ";
        $res      = $this->db->queryF($query, array('integer'), array($a_topic_id));
        $cntData  = $this->db->fetchAssoc($res);
        $cnt      = (int) $cntData['cnt'];

        $active_query               = '';
        $active_inner_query         = '';
        $having                     = '';
        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) ';
            $having = ' HAVING num_posts > 0';
        }

        $threads    = array();
        $data       = array();
        $data_types = array();

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

        if ($params['order_column'] == 'thr_subject') {
            $dynamic_columns = array(', thr_subject ' . $params['order_direction']);
        } elseif ($params['order_column'] == 'num_posts') {
            $dynamic_columns = array(', thr_num_posts ' . $params['order_direction']);
        } elseif ($params['order_column'] == 'num_visit') {
            $dynamic_columns = array(', visits ' . $params['order_direction']);
        } else {
            $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 (!$this->user->isAnonymous()) {
            $query = "SELECT
                                          (CASE WHEN COUNT(DISTINCT(notification_id)) > 0 THEN 1 ELSE 0 END) usr_notification_is_enabled,
                                          MAX(pos_date) post_date,
                                          COUNT(DISTINCT(pos_pk)) num_posts, 
                                          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 .= "
                                          (SELECT COUNT(DISTINCT(ipos.pos_pk))
                                                FROM frm_posts ipos
                                                LEFT JOIN frm_user_read iread ON iread.post_id = ipos.pos_pk AND iread.usr_id = %s
                                                LEFT JOIN frm_thread_access iacc ON (iacc.thread_id = ipos.pos_thr_fk AND iacc.usr_id = %s)
                                                WHERE ipos.pos_thr_fk = thr_pk
                                                 
                                                AND (ipos.pos_update > iacc.access_old_ts
                                                        OR
                                                        (iacc.access_old IS NULL AND (ipos.pos_update > " . $this->db->quote(date('Y-m-d H:i:s', NEW_DEADLINE), 'timestamp') . "))
                                                        )
                                                 
                                                AND ipos.pos_author_id != %s
                                                AND iread.usr_id IS NULL $active_inner_query
                                          ) 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
                                          {$optional_fields}
                                          FROM frm_threads
                                          
                                          LEFT JOIN frm_notification
                                                ON frm_notification.thread_id = thr_pk
                                                AND frm_notification.user_id = %s
                                          
                                          LEFT JOIN frm_posts
                                                ON pos_thr_fk = thr_pk $active_query
                                          
                                          LEFT JOIN frm_user_read postread
                                                ON postread.post_id = pos_pk
                                                AND postread.usr_id = %s";

            $query .= " WHERE thr_top_fk = %s
                                                {$excluded_ids_condition}
                                                GROUP 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
                                                {$optional_fields}
                                                {$having}
                                                ORDER 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[] = $user_id;
                $data[] = $user_id;
                $data[] = $user_id;
                if ($is_post_activation_enabled && !$params['is_moderator']) {
                    array_push($data, '1', $user_id);
                }
            }
            $data[] = $user_id;
            if ($is_post_activation_enabled && !$params['is_moderator']) {
                array_push($data, '1', $user_id);
            }
            $data[] = $user_id;
            $data[] = $a_topic_id;
        } else {
            $query = "SELECT
                                          0 usr_notification_is_enabled,
                                          MAX(pos_date) post_date,
                                          COUNT(DISTINCT(pos_pk)) num_posts,
                                          COUNT(DISTINCT(pos_pk)) num_unread_posts,
                                          COUNT(DISTINCT(pos_pk)) num_new_posts,
                                          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
                                          {$optional_fields}
                                          FROM frm_threads
                                          
                                          LEFT JOIN frm_posts
                                                ON pos_thr_fk = thr_pk $active_query";

            $query .= " WHERE thr_top_fk = %s
                                                {$excluded_ids_condition}
                                                GROUP 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
                                                {$optional_fields}
                                                {$having}
                                                ORDER 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', $user_id);
            }
            $data[] = $a_topic_id;
        }

        if ($limit || $offset) {
            $this->db->setLimit($limit, $offset);
        }
        $res = $this->db->queryF($query, $data_types, $data);

        $threadIds = [];
        while ($row = $this->db->fetchAssoc($res)) {
            $thread = new ilForumTopic($row['thr_pk'], $params['is_moderator'], true);
            $thread->assignData($row);
            $threads[$row['thr_pk']] = $thread;
            
            $threadIds[] = $row['thr_pk'];
        }

        $inner_last_active_post_condition = '';
        if ($params['is_moderator'] == false) {
            $inner_last_active_post_condition = " 
                                AND ( iposts.pos_status = " . $this->db->quote(1, 'integer') . "
                                OR ( iposts.pos_status = " . $this->db->quote(0, 'integer') . "
                                                AND iposts.pos_author_id = " . $this->db->quote($this->user->getId(), 'integer') . "))";
        }

        $post_res = $this->db->query(
            '
                        SELECT frm_posts.*
                        FROM frm_posts
                        INNER JOIN (
                                SELECT pos_thr_fk, MAX(iposts.pos_date) i_pos_date
                                FROM frm_posts iposts
                                WHERE ' . $this->db->in('iposts.pos_thr_fk', $threadIds, false, 'integer') . ' 
                                ' . $inner_last_active_post_condition . '
                                GROUP BY pos_thr_fk
                        ) opost ON frm_posts.pos_thr_fk = opost.pos_thr_fk AND frm_posts.pos_date = opost.i_pos_date'
        );

        while ($post_row = $this->db->fetchAssoc($post_res)) {
            $tmp_obj = new ilForumPost($post_row['pos_pk'], $params['is_moderator'], true);

            $tmp_obj->setPosAuthorId($post_row['pos_author_id']);
            $tmp_obj->setDisplayUserId($post_row['pos_display_user_id']);
            $tmp_obj->setUserAlias($post_row['pos_usr_alias']);
            $tmp_obj->setImportName($post_row['import_name']);
            $tmp_obj->setId($post_row['pos_pk']);
            $tmp_obj->setCreateDate($post_row['pos_date']);

            $threads[$post_row['pos_thr_fk']]->setLastPostForThreadOverview($tmp_obj);
        }

        return array('items' => $threads,'cnt' => $cnt);
    }

Here is the call graph for this function:

getDbTable()

ilForum::getDbTable

(

)

get name of database table

Returns

string name of database table

See also

$dbTable User interface

Definition at line 217 of file class.ilForum.php.

References $dbTable.

    {
        return $this->dbTable;
    }

getFirstPostByThread()

ilForum::getFirstPostByThread

(

$a_thread_id

)

Get first post of thread.

public

Parameters

int

thread id

Returns

Definition at line 1346 of file class.ilForum.php.

References $res, $row, and array.

    {
        $res = $this->db->queryf(
            '
                        SELECT * FROM frm_posts_tree 
                        WHERE thr_fk = %s
                        AND parent_pos = %s',
            array('integer', 'integer'),
            array($a_thread_id, '0')
        );

        $row = $this->db->fetchObject($res);
        
        return $row->pos_fk ? $row->pos_fk : 0;
    }

getFirstPostNode()

ilForum::getFirstPostNode

(

$tree_id

)

get data of the first node from frm_posts_tree and frm_posts public

Parameters

integer

tree id

Returns

object db result object

Definition at line 1610 of file class.ilForum.php.

References $res, $row, array, and fetchPostNodeData().

    {
        $res = $this->db->queryf(
            '
                        SELECT * FROM frm_posts, frm_posts_tree 
                        WHERE pos_pk = pos_fk 
                        AND parent_pos = %s
                        AND thr_fk = %s',
            array('integer', 'integer'),
            array('0', $tree_id)
        );
        
        $row = $this->db->fetchObject($res);
        
        return $this->fetchPostNodeData($row);
    }

Here is the call graph for this function:

getForumId()

ilForum::getForumId

(

)

get forum id public

Returns

integer object id of forum

Definition at line 155 of file class.ilForum.php.

References $id.

Referenced by __deletePostFiles(), countActiveUserArticles(), countUserArticles(), generatePost(), getAllThreads(), and getUserStatistic().

    {
        return $this->id;
    }

Here is the caller graph for this function:

getForumRefId()

ilForum::getForumRefId

(

)

get forum ref_id public

Returns

integer reference id of forum

Definition at line 165 of file class.ilForum.php.

Referenced by deletePost(), generatePost(), getModerators(), and postCensorship().

    {
        return $this->ref_id;
    }

Here is the caller graph for this function:

getImportName()

ilForum::getImportName

(

)

Definition at line 1902 of file class.ilForum.php.

Referenced by generatePost(), and generateThread().

    {
        return $this->import_name;
    }

Here is the caller graph for this function:

getMDB2DataType()

ilForum::getMDB2DataType

(

)

get content of additional condition

Returns

array

Definition at line 265 of file class.ilForum.php.

References $mdb2DataType.

Referenced by getOneThread(), getOneTopic(), and updateVisits().

    {
        if ($this->mdb2DataType != '') {
            return $this->mdb2DataType;
        }
    }

Here is the caller graph for this function:

getMDB2DataValue()

ilForum::getMDB2DataValue

(

)

get content of additional condition

Returns

array

Definition at line 254 of file class.ilForum.php.

References $mdb2DataValue.

Referenced by getOneThread(), getOneTopic(), and updateVisits().

    {
        if ($this->mdb2DataValue != '') {
            return $this->mdb2DataValue;
        }
    }

Here is the caller graph for this function:

getMDB2Query()

ilForum::getMDB2Query

(

)

get content of additional condition

Returns

string

Definition at line 243 of file class.ilForum.php.

References $mdb2Query.

Referenced by getOneThread(), getOneTopic(), and updateVisits().

    {
        if ($this->mdb2Query != '') {
            return $this->mdb2Query;
        }
    }

Here is the caller graph for this function:

getModerators()

ilForum::getModerators

(

)

get all users assigned to local role il_frm_moderator_<frm_ref_id>

Returns

array user_ids public

Definition at line 1368 of file class.ilForum.php.

References getForumRefId().

    {
        return self::_getModerators($this->getForumRefId());
    }

Here is the call graph for this function:

getOnePost()

ilForum::getOnePost

(

$post

)

get one post-dataset

Parameters

integer

post id

Returns

array result dataset of the post public

Definition at line 373 of file class.ilForum.php.

References $post, $res, $row, array, and convertDate().

    {
        $res = $this->db->queryf(
            '
                        SELECT frm_posts.*, usr_data.lastname FROM frm_posts, usr_data 
                        WHERE pos_pk = %s
                        AND pos_display_user_id = usr_id',
            array('integer'),
            array($post)
        );

        $row = $this->db->fetchAssoc($res);
        
        $row["pos_date"] = $this->convertDate($row["pos_date"]);
        $row["pos_message"] = nl2br($row["pos_message"]);
                    
        return $row;
    }

Here is the call graph for this function:

getOneThread()

ilForum::getOneThread

(

)

get one thread-dataset by WhereCondition

Returns

array $result dataset of the thread public

Definition at line 347 of file class.ilForum.php.

References $query, $result, array, getMDB2DataType(), getMDB2DataValue(), and getMDB2Query().

    {
        $data_type = array();
        $data_value = array();
        
        $query = 'SELECT * FROM frm_threads WHERE ';
        
        if ($this->getMDB2Query() != '' && $this->getMDB2DataType() != '' && $this->getMDB2DataValue() != '') {
            $query .= $this->getMDB2Query();
            $data_type = $data_type + $this->getMDB2DataType();
            $data_value = $data_value + $this->getMDB2DataValue();
            
            $sql_res = $this->db->queryf($query, $data_type, $data_value);
            $result = $this->db->fetchAssoc($sql_res);
            $result["thr_subject"] = trim($result["thr_subject"]);
        }

        return $result;
    }

Here is the call graph for this function:

getOneTopic()

ilForum::getOneTopic

(

)

get one topic-dataset by WhereCondition

Returns

array $result dataset of the topic public

Definition at line 302 of file class.ilForum.php.

References $query, $res, $row, array, getMDB2DataType(), getMDB2DataValue(), and getMDB2Query().

Referenced by moveThreads().

    {
        $data_type = array();
        $data_value = array();
        
        $query = 'SELECT * FROM frm_data WHERE ';
        
        if ($this->getMDB2Query() != '' && $this->getMDB2DataType() != '' && $this->getMDB2DataValue() != '') {
            $query .= '' . $this->getMDB2Query() . '';
            $data_type = $data_type + $this->getMDB2DataType();
            $data_value = $data_value + $this->getMDB2DataValue();

            $res = $this->db->queryf($query, $data_type, $data_value);
            $row = $this->db->fetchAssoc($res);
            
            if (is_null($row)) {
                return null;
            }
            
            $row["top_name"] = trim($row["top_name"]);
            $row["top_description"] = nl2br($row["top_description"]);

            return $row;
        } else {
            $query .= '1 = 1';
        
            $res = $this->db->query($query);
            $row = $this->db->fetchAssoc($res);
            
            if (!is_array($row) || !count($row)) {
                return null;
            }
            
            $row['top_name'] = trim($row['top_name']);
            $row['top_description'] = nl2br($row['top_description']);
    
            return $row;
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getOrderField()

ilForum::getOrderField

(

)

get name of orderField

Returns

string name of orderField

See also

$orderField User interface

Definition at line 191 of file class.ilForum.php.

References $orderField.

    {
        return $this->orderField;
    }

getPageHits()

ilForum::getPageHits

(

)

get number of max.

visible datasets

Returns

integer $pageHits

See also

$pageHits User interface

Definition at line 292 of file class.ilForum.php.

References $pageHits.

    {
        return $this->pageHits;
    }

getPostDepth()

ilForum::getPostDepth	(		$a_node_id,
			$tree_id
	)

Return depth of an object private.

Parameters

integer	node_id of parent's node_id
integer	node_id of parent's node parent_id

Returns

integer depth of node

Definition at line 1584 of file class.ilForum.php.

References $res, and array.

Referenced by insertPostNode().

    {
        if ($tree_id) {
            $sql_res = $this->db->queryf(
                '
                                SELECT depth FROM frm_posts_tree
                                WHERE pos_fk = %s
                                AND thr_fk = %s',
                array('integer', 'integer'),
                array($a_node_id, $tree_id)
            );
            
            $res = $this->db->fetchObject($sql_res);
            
            return $res->depth;
        } else {
            return 0;
        }
    }

Here is the caller graph for this function:

getPostNode()

ilForum::getPostNode

(

$post_id

)

get data of given node from frm_posts_tree and frm_posts public

Parameters

integer

post_id

Returns

object db result object

Definition at line 1633 of file class.ilForum.php.

References $res, $row, array, and fetchPostNodeData().

Referenced by deletePost().

    {
        $res = $this->db->queryf(
            '
                        SELECT * FROM frm_posts, frm_posts_tree 
                        WHERE pos_pk = pos_fk 
                        AND pos_pk = %s',
            array('integer'),
            array($post_id)
        );
        
        $row = $this->db->fetchObject($res);

        return $this->fetchPostNodeData($row);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getUserStatistic()

ilForum::getUserStatistic

(

$is_moderator = false

)

Parameters

bool

$is_moderator

Returns

array

Definition at line 1276 of file class.ilForum.php.

References $counter, $data, $query, $res, $row, array, getForumId(), and user().

    {
        $statistic = array();
        
        $data_types = array();
        $data = array();
        
        $query = "SELECT COUNT(f.pos_display_user_id) ranking, u.login, p.value, u.lastname, u.firstname
                                        FROM frm_posts f
                                                INNER JOIN frm_posts_tree t
                                                        ON f.pos_pk = t.pos_fk
                                                INNER JOIN frm_threads th
                                                        ON t.thr_fk = th.thr_pk
                                                INNER JOIN usr_data u
                                                        ON u.usr_id = f.pos_display_user_id
                                                INNER JOIN frm_data d
                                                        ON d.top_pk = f.pos_top_fk
                                                LEFT JOIN usr_pref p
                                                        ON p.usr_id = u.usr_id AND p.keyword = %s
                                        WHERE 1 = 1";
    
        array_push($data_types, 'text');
        array_push($data, 'public_profile');

        if (!$is_moderator) {
            $query .= ' AND (pos_status = %s
                                                OR (pos_status = %s
                                                AND pos_author_id = %s ))';
            
            array_push($data_types, 'integer', 'integer', 'integer');
            array_push($data, '1', '0', $this->user->getId());
        }
        
        $query .= ' AND d.top_frm_fk = %s
                                        GROUP BY pos_display_user_id, u.login, p.value,u.lastname, u.firstname';

        array_push($data_types, 'integer');
        array_push($data, $this->getForumId());
        
        $res = $this->db->queryf($query, $data_types, $data);
        
        $counter = 0;
        while ($row = $this->db->fetchAssoc($res)) {
            $statistic[$counter][] = $row['ranking'];
            $statistic[$counter][] = $row['login'];

            $lastname ='';
            $firstname = '';
            if (!$this->user->isAnonymous() && in_array($row['value'], array('y', 'g')) ||
                $this->user->isAnonymous() && 'g' == $row['value']) {
                $lastname = $row['lastname'];
                $firstname = $row['firstname'];
            }

            $statistic[$counter][] = $lastname;
            $statistic[$counter][] = $firstname;
            
            ++$counter;
        }
              
        return is_array($statistic) ? $statistic : array();
    }

Here is the call graph for this function:

insertPostNode()

ilForum::insertPostNode	(		$a_node_id,
			$a_parent_id,
			$tree_id,
			$a_date = ''
	)

insert node under parent node public

Parameters

integer	node_id
integer	tree_id
integer	parent_id (optional)

Definition at line 1508 of file class.ilForum.php.

References $res, array, date, and getPostDepth().

Referenced by generatePost().

    {
        $a_date = $a_date ? $a_date : date("Y-m-d H:i:s");
        
        // get left value
        $sql_res = $this->db->queryf(
            '
                        SELECT * FROM frm_posts_tree
                        WHERE pos_fk = %s
                        AND thr_fk = %s',
            array('integer', 'integer'),
            array($a_parent_id, $tree_id)
        );
        
        $res = $this->db->fetchObject($sql_res);
        
        $left = $res->lft;

        $lft = $left + 1;
        $rgt = $left + 2;

        // spread tree
        $this->db->manipulateF(
            '
                        UPDATE frm_posts_tree 
                        SET  lft = CASE 
                                 WHEN lft > %s
                                 THEN lft + 2 
                                 ELSE lft 
                                 END, 
                                 rgt = CASE 
                                 WHEN rgt > %s
                                 THEN rgt + 2 
                                 ELSE rgt 
                                 END 
                                 WHERE thr_fk = %s',
            array('integer', 'integer', 'integer'),
            array($left, $left, $tree_id)
        );
        
        $depth = $this->getPostDepth($a_parent_id, $tree_id) + 1;
    
        // insert node
        $nextId = $this->db->nextId('frm_posts_tree');
        $this->db->manipulateF(
             '
                        INSERT INTO frm_posts_tree
                        (       fpt_pk,
                                thr_fk,
                                pos_fk,
                                parent_pos,
                                lft,
                                rgt,
                                depth,
                                fpt_date
                        )
                        VALUES(%s,%s,%s, %s, %s, %s,%s, %s)',
             array('integer','integer', 'integer', 'integer', 'integer', 'integer', 'integer', 'timestamp'),
             array(     $nextId,
                    $tree_id,
                    $a_node_id,
                    $a_parent_id,
                    $lft,
                    $rgt,
                    $depth,
                    $a_date)
         );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

isForumNotificationEnabled()

ilForum::isForumNotificationEnabled

(

$user_id

)

Check whether a user's notification about new posts in this forum is enabled (result > 0) or not (result == 0)

Parameters

integer

user_id A user's ID

Returns

integer Result

Definition at line 2009 of file class.ilForum.php.

References $result, and array.

Referenced by enableForumNotification().

    {
        $result = $this->db->queryf(
            'SELECT COUNT(*) cnt FROM frm_notification WHERE user_id = %s AND frm_id = %s',
            array('integer', 'integer'),
            array($user_id, $this->id)
        );
         
        while ($record = $this->db->fetchAssoc($result)) {
            return (bool) $record['cnt'];
        }
        
        return false;
    }

Here is the caller graph for this function:

isThreadNotificationEnabled()

ilForum::isThreadNotificationEnabled	(		$user_id,
			$thread_id
	)

Check whether a user's notification about new posts in a thread is enabled (result > 0) or not (result == 0)

Parameters

integer	user_id A user's ID
integer	thread_id ID of the thread

Returns

integer Result

Definition at line 2060 of file class.ilForum.php.

References $result, and array.

Referenced by enableThreadNotification().

    {
        $result = $this->db->queryf(
            '
                        SELECT COUNT(*) cnt FROM frm_notification 
                        WHERE user_id = %s 
                        AND thread_id = %s',
            array('integer', 'integer'),
            array($user_id, $thread_id)
        );

                
        while ($record = $this->db->fetchAssoc($result)) {
            return (bool) $record['cnt'];
        }
        
        return false;
    }

Here is the caller graph for this function:

mergeThreads()

static ilForum::mergeThreads (   $obj_id,   $source_id,   $target_id  )

static

Parameters

$obj_id
$source_id
$target_id

Exceptions

ilException

Definition at line 2180 of file class.ilForum.php.

References $GLOBALS, $post, $target_id, ilObjForum\_deleteAccessEntries(), array, ilForumTopic\deleteByThreadId(), ilObjForum\mergeForumUserRead(), ilForumPost\mergePosts(), ilForumNotification\mergeThreadNotificiations(), updateLastPostByObjId(), and ilForumPostsTree\updateTargetRootRgt().

Referenced by ilObjForumGUI\performMergeThreadsObject().

    {
        // selected source & target objects
        $source_thread_obj = new ilForumTopic((int) $source_id);
        $target_thread_obj = new ilForumTopic((int) $target_id);

        if ($source_thread_obj->getForumId() != $target_thread_obj->getForumId()) {
            throw new ilException('not_allowed_to_merge_into_another_forum');
        }
        // use the "older" thread as target
        if ($source_thread_obj->getCreateDate() > $target_thread_obj->getCreateDate()) {
            $merge_thread_source = $source_thread_obj;
            $merge_thread_target = $target_thread_obj;
        } else {
            $merge_thread_source = $target_thread_obj;
            $merge_thread_target = $source_thread_obj;
        }

        $thread_subject = $target_thread_obj->getSubject();

        // remember if the threads are open or closed and then close both threads !
        $targed_was_closed = $merge_thread_target->isClosed();

        $merge_thread_source->close();

        if ($targed_was_closed == false) {
            $merge_thread_target->close();
        }

        $source_all_posts = $merge_thread_source->getAllPosts();
        $source_root_node = $merge_thread_source->getFirstPostNode();
        $target_root_node = $merge_thread_target->getFirstPostNode();

        $add_difference = $target_root_node->getRgt();

        // update target root node rgt
        include_once 'Modules/Forum/classes/class.ilForumPostsTree.php';
        //              $new_target_rgt = ($target_root_node->getRgt() + $source_root_node->getRgt() + 1);
        $new_target_rgt = ($target_root_node->getRgt() + $source_root_node->getRgt());
        ilForumPostsTree::updateTargetRootRgt($target_root_node->getId(), $new_target_rgt);

        $new_target_root = $target_root_node->getId();

        // get source post tree and update posts tree
        foreach ($source_all_posts as $post) {
            $post_obj = new ilForumPost($post->pos_pk);

            $posts_tree_obj = new ilForumPostsTree();
            $posts_tree_obj->setPosFk($post->pos_pk);

            if ($post_obj->getParentId() == 0) {
                $posts_tree_obj->setParentPos($new_target_root);

                //$posts_tree_obj->setRgt(($post_obj->getRgt() + $add_difference));
                $posts_tree_obj->setRgt(($post_obj->getRgt() + $add_difference) - 1);
                $posts_tree_obj->setLft($target_root_node->getRgt());
                
                $posts_tree_obj->setDepth(($post_obj->getDepth() + 1));
                $posts_tree_obj->setSourceThreadId($merge_thread_source->getId());

                $posts_tree_obj->setTargetThreadId($merge_thread_target->getId());

                $posts_tree_obj->mergeParentPos();
            } else {
                $posts_tree_obj->setRgt(($post_obj->getRgt() + $add_difference) - 1);
                $posts_tree_obj->setLft(($post_obj->getLft() + $add_difference) - 1);

                $posts_tree_obj->setDepth(($post_obj->getDepth() + 1));
                $posts_tree_obj->setSourceThreadId($merge_thread_source->getId());

                $posts_tree_obj->setParentPos($post_obj->getParentId());
                $posts_tree_obj->setTargetThreadId($merge_thread_target->getId());

                $posts_tree_obj->merge();
            }
        }

        // update frm_posts pos_thr_fk = target_thr_id
        include_once 'Modules/Forum/classes/class.ilForumPost.php';
        ilForumPost::mergePosts($merge_thread_source->getId(), $merge_thread_target->getId());

        // check notifications
        include_once 'Modules/Forum/classes/class.ilForumNotification.php';
        ilForumNotification::mergeThreadNotificiations($merge_thread_source->getId(), $merge_thread_target->getId());

        // delete frm_thread_access entries
        include_once './Modules/Forum/classes/class.ilObjForum.php';
        ilObjForum::_deleteAccessEntries($merge_thread_source->getId());

        // update frm_user_read
        ilObjForum::mergeForumUserRead($merge_thread_source->getId(), $merge_thread_target->getId());

        // update visits, thr_num_posts, last_post, subject
        $post_date_source = $merge_thread_source->getLastPost()->getCreateDate();
        $post_date_target = $merge_thread_target->getLastPost()->getCreateDate();

        $target_last_post = $merge_thread_target->getLastPostString();
        $exp              = explode('#', $target_last_post);

        if ($post_date_source > $post_date_target) {
            $exp[2] = $merge_thread_source->getLastPost()->getId();
        } else {
            $exp[2] = $merge_thread_target->getLastPost()->getId();
        }
        $new_thr_last_post = implode('#', $exp);

        $num_posts_source  = (int) $merge_thread_source->getNumPosts();
        $num_visits_source = (int) $merge_thread_source->getVisits();
        $num_posts_target  = (int) $merge_thread_target->getNumPosts();
        $num_visits_target = (int) $merge_thread_source->getVisits();

        $frm_topic_obj = new ilForumTopic(0, false, true);
        $frm_topic_obj->setNumPosts(($num_posts_source + $num_posts_target));
        $frm_topic_obj->setVisits(($num_visits_source + $num_visits_target));
        $frm_topic_obj->setLastPostString($new_thr_last_post);
        $frm_topic_obj->setSubject($thread_subject);
        $frm_topic_obj->setId($merge_thread_target->getId());

        $frm_topic_obj->updateMergedThread();

        // update frm_data:  top_last_post , top_num_threads
        ilForum::updateLastPostByObjId($obj_id);

        // reopen target if was not "closed" before merging
        if (!$targed_was_closed) {
            $merge_thread_target->reopen();
        }
        // raise event for updating existing drafts
        $GLOBALS['ilAppEventHandler']->raise(
            'Modules/Forum',
            'mergedThreads',
            array(  'source_thread_id'  => $merge_thread_source->getId(),
                    'target_thread_id'  => $merge_thread_target->getId())
        );

        // delete source thread
        ilForumTopic::deleteByThreadId($merge_thread_source->getId());
    }

Here is the call graph for this function:

Here is the caller graph for this function:

moveThreads()

ilForum::moveThreads	(		$thread_ids = array(),
			$src_ref_id = 0,
			$dest_top_frm_fk = 0
	)

Moves all chosen threads and their posts to a new forum.

Parameters

array	chosen thread pks
integer	object id of src forum
integer	object id of dest forum public

Returns

array

Definition at line 576 of file class.ilForum.php.

References $id, $res, $row, ilObject\_lookupObjectId(), array, getOneTopic(), and setMDB2WhereCondition().

    {
        $src_top_frm_fk = ilObject::_lookupObjectId($src_ref_id);

        $errorMessages = array();

        if (is_numeric($src_top_frm_fk) && $src_top_frm_fk > 0 && is_numeric($dest_top_frm_fk) && $dest_top_frm_fk > 0) {
            $this->setMDB2WhereCondition('top_frm_fk = %s ', array('integer'), array($src_top_frm_fk));
            
            $oldFrmData = $this->getOneTopic();

            $this->setMDB2WhereCondition('top_frm_fk = %s ', array('integer'), array($dest_top_frm_fk));
                    
            $newFrmData = $this->getOneTopic();

            if ($oldFrmData['top_pk'] && $newFrmData['top_pk']) {
                $moved_posts = 0;
                $moved_threads = 0;
                $visits = 0;

                foreach ($thread_ids as $id) {
                    $objTmpThread = new ilForumTopic($id);

                    try {
                        $numPosts = $objTmpThread->movePosts(
                            $src_top_frm_fk,
                            $oldFrmData['top_pk'],
                            $dest_top_frm_fk,
                            $newFrmData['top_pk']
                        );

                        if (($last_post_string = $objTmpThread->getLastPostString()) != '') {
                            $last_post_string = explode('#', $last_post_string);
                            $last_post_string[0] = $newFrmData['top_pk'];
                            $last_post_string = implode('#', $last_post_string);
                            $objTmpThread->setLastPostString($last_post_string);
                        }

                        $visits += $objTmpThread->getVisits();

                        $moved_posts += $numPosts;
                        ++$moved_threads;

                        $objTmpThread->setForumId($newFrmData['top_pk']);
                        $objTmpThread->update();

                        unset($objTmpThread);
                    } catch (\ilFileUtilsException $exception) {
                        $errorMessages[] = sprintf($this->lng->txt('frm_move_invalid_file_type'), $objTmpThread->getSubject());
                        continue;
                    }
                }

                if ($moved_threads > 0 || $moved_posts > 0 || $visits > 0) {
                    // update frm_data source forum
                    $this->db->setLimit(1);
                    $res = $this->db->queryf(
                        '
                                        SELECT pos_thr_fk, pos_pk 
                                        FROM frm_posts                                            
                                        WHERE pos_top_fk = %s
                                        ORDER BY pos_date DESC',
                        array('integer'),
                        array($oldFrmData['top_pk'])
                    );

                    $row = $this->db->fetchObject($res);
                    $last_post_src = $oldFrmData['top_pk'] . '#' . $row->pos_thr_fk . '#' . $row->pos_pk;

                    $this->db->manipulateF(
                        '
                                        UPDATE frm_data
                                        SET top_num_posts = top_num_posts - %s,
                                                top_num_threads = top_num_threads - %s,
                                                visits = visits - %s,
                                                top_last_post = %s
                                        WHERE top_pk = %s',
                        array('integer', 'integer', 'integer', 'text', 'integer'),
                        array(  $moved_posts,
                            $moved_threads,
                            $visits,
                            $last_post_src,
                            $oldFrmData['top_pk'])
                    );

                    // update frm_data destination forum
                    $this->db->setLimit(1);
                    $res = $this->db->queryf(
                        '
                                        SELECT pos_thr_fk, pos_pk 
                                        FROM frm_posts                                            
                                        WHERE pos_top_fk = %s
                                        ORDER BY pos_date DESC',
                        array('integer'),
                        array($newFrmData['top_kp'])
                    );

                    $row = $this->db->fetchObject($res);
                    $last_post_dest = $newFrmData['top_pk'] . '#' . $row->pos_thr_fk . '#' . $row->pos_pk;

                    $this->db->manipulateF(
                        '
                                        UPDATE frm_data
                                        SET top_num_posts = top_num_posts + %s,
                                                top_num_threads = top_num_threads + %s,
                                                visits = visits + %s,
                                                top_last_post = %s
                                                WHERE top_pk = %s',
                        array('integer', 'integer', 'integer', 'text', 'integer'),
                        array($moved_posts, $moved_threads, $visits, $last_post_dest, $newFrmData['top_pk'])
                    );
                }
            }

            return $errorMessages;
        }
    }

Here is the call graph for this function:

postCensorship()

ilForum::postCensorship	(		$message,
			$pos_pk,
			$cens = 0
	)

update dataset in frm_posts with censorship info

Parameters

string	message
integer	pos_pk

Returns

boolean public

Definition at line 702 of file class.ilForum.php.

References $GLOBALS, $message, $res, array, date, ilNewsItem\getFirstNewsIdForContext(), getForumRefId(), and prepareText().

    {
        $cens_date = date("Y-m-d H:i:s");

        $this->db->manipulateF(
            '
                        UPDATE frm_posts
                        SET pos_cens_com = %s,
                                pos_cens_date = %s,
                                pos_cens = %s,
                                update_user = %s
                        WHERE pos_pk = %s',
            array('text', 'timestamp', 'integer', 'integer', 'integer'),
            array($message, $cens_date, $cens, $GLOBALS['DIC']['ilUser']->getId(), $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) {            // censor
                $news_item = new ilNewsItem($news_id);
                //$news_item->setTitle($subject);
                $news_item->setContent(nl2br($this->prepareText($message, 0)));
                if ($message != strip_tags($message)) {
                    $news_item->setContentHtml(true);
                } else {
                    $news_item->setContentHtml(false);
                }
                
                $news_item->update();
            } else {                            // revoke censorship
                // get original message
                $res = $this->db->queryf(
                    '
                                        SELECT * FROM frm_posts
                                        WHERE pos_pk = %s',
                    array('integer'),
                    array($pos_pk)
                );
                    
                $rec = $this->db->fetchAssoc($res);

                $news_item = new ilNewsItem($news_id);
                //$news_item->setTitle($subject);
                $news_item->setContent(nl2br($this->prepareText($rec["pos_message"], 0)));
                if ($rec["pos_message"] != strip_tags($rec["pos_message"])) {
                    $news_item->setContentHtml(true);
                } else {
                    $news_item->setContentHtml(false);
                }
                
                $news_item->update();
            }
        }

        require_once 'Modules/Forum/classes/class.ilForumPost.php';
        $GLOBALS['ilAppEventHandler']->raise(
            'Modules/Forum',
            'censoredPost',
            array(
                'ref_id' => $this->getForumRefId(),
                'post'   => new ilForumPost($pos_pk)
            )
        );

        return true;
    }

Here is the call graph for this function:

prepareText()

ilForum::prepareText	(		$text,
			$edit = 0,
			$quote_user = '',
			$type = ''
	)

prepares given string public

Parameters

string
integer

Returns

string

Definition at line 1805 of file class.ilForum.php.

References $i, $text, $txtQuote2, $type, and ilMathJax\getInstance().

Referenced by generatePost(), and postCensorship().

    {
        if ($type == 'export') {
            $this->replQuote1 = "<blockquote class=\"quote\"><hr size=\"1\" color=\"#000000\">";
            $this->replQuote2 = "<hr size=\"1\" color=\"#000000\"/></blockquote>";
        }

        if ($edit == 1) {
            // add login name of quoted users
            $lname = ($quote_user != "")
                ? '="' . $quote_user . '"'
                : "";

            $text = "[quote$lname]" . $text . "[/quote]";
        } else {
            // check for quotation
            $startZ = substr_count($text, "[quote");    // also count [quote="..."]
            $endZ = substr_count($text, "[/quote]");

            if ($startZ > 0 || $endZ > 0) {
                // add missing opening and closing tags
                if ($startZ > $endZ) {
                    $diff = $startZ - $endZ;

                    for ($i = 0; $i < $diff; $i++) {
                        if ($type == 'export') {
                            $text .= $this->txtQuote2;
                        } else {
                            $text .= "[/quote]";
                        }
                    }
                } elseif ($startZ < $endZ) {
                    $diff = $endZ - $startZ;

                    for ($i = 0; $i < $diff; $i++) {
                        if ($type == 'export') {
                            $text = $this->txtQuote1 . $text;
                        } else {
                            $text = "[quote]" . $text;
                        }
                    }
                }

                if ($edit == 0) {
                    $text = preg_replace(
                        '@\[(quote\s*?=\s*?"([^"]*?)"\s*?)\]@i',
                        $this->replQuote1 . '<div class="ilForumQuoteHead">' . $this->lng->txt('quote') . ' ($2)</div>',
                        $text
                    );

                    $text = str_replace(
                        "[quote]",
                        $this->replQuote1 . '<div class="ilForumQuoteHead">' . $this->lng->txt("quote") . '</div>',
                        $text
                    );
                    
                    $text = str_replace("[/quote]", $this->replQuote2, $text);
                }
            }
        }
        
        if ($type != 'export') {
            if ($edit == 0) {
                include_once './Services/MathJax/classes/class.ilMathJax.php';
                $text = ilMathJax::getInstance()->insertLatexImages($text, "<span class\=\"latex\">", "<\/span>");
                $text = ilMathJax::getInstance()->insertLatexImages($text, "\[tex\]", "\[\/tex\]");
            }
            
            // workaround for preventing template engine
            // from hiding text that is enclosed
            // in curly brackets (e.g. "{a}")
            $text = str_replace("{", "&#123;", $text);
            $text = str_replace("}", "&#125;", $text);
        }

        return $text;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

setDbTable()

ilForum::setDbTable

(

$dbTable

)

set database table

Parameters

string

$dbTable

database table

See also

$dbTable User interface

Definition at line 202 of file class.ilForum.php.

References $dbTable.

    {
        if ($dbTable == "") {
            die($this->className . "::setDbTable(): No database table given.");
        } else {
            $this->dbTable = $dbTable;
        }
    }

setForumId()

ilForum::setForumId

(

$a_obj_id

)

set object id which refers to ILIAS obj_id

Parameters

integer

object id public

Definition at line 125 of file class.ilForum.php.

References $message.

    {
        if (!isset($a_obj_id)) {
            $message = get_class($this) . "::setForumId(): No obj_id given!";
            $this->error->raiseError($message, $this->error->WARNING);
        }
        
        $this->id = $a_obj_id;
    }

setForumRefId()

ilForum::setForumRefId

(

$a_ref_id

)

set reference id which refers to ILIAS obj_id

Parameters

integer

object id public

Definition at line 140 of file class.ilForum.php.

References $message.

    {
        if (!isset($a_ref_id)) {
            $message = get_class($this) . "::setForumRefId(): No ref_id given!";
            $this->error->raiseError($message, $this->error->WARNING);
        }
        
        $this->ref_id = $a_ref_id;
    }

setImportName()

ilForum::setImportName

(

$a_import_name

)

Definition at line 1906 of file class.ilForum.php.

    {
        $this->import_name = $a_import_name;
    }

setLanguage()

ilForum::setLanguage

(

$lng

)

Definition at line 90 of file class.ilForum.php.

References $lng.

    {
        $this->lng = $lng;
    }

setMDB2WhereCondition()

ilForum::setMDB2WhereCondition	(		$query_string,
			$data_type,
			$data_value
	)

set content for additional condition

Parameters

string	$query_string
array	$data_type
array	$data_value

Returns

bool

Definition at line 230 of file class.ilForum.php.

Referenced by moveThreads().

    {
        $this->mdb2Query = $query_string;
        $this->mdb2DataValue = $data_value;
        $this->mdb2DataType = $data_type;
        
        return true;
    }

Here is the caller graph for this function:

setOrderField()

ilForum::setOrderField (   $orderField )

private

set database field for sorting results

Parameters

string

$orderField

database field for sorting

See also

$orderField private

Definition at line 176 of file class.ilForum.php.

References $orderField.

    {
        if ($orderField == "") {
            die($this->className . "::setOrderField(): No orderField given.");
        } else {
            $this->orderField = $orderField;
        }
    }

setPageHits()

ilForum::setPageHits

(

$pageHits

)

Parameters

int

$pageHits

Returns

bool

Definition at line 276 of file class.ilForum.php.

References $pageHits.

    {
        if ($pageHits < 1 || !is_numeric($pageHits)) {
            $pageHits = 1;
        }

        $this->pageHits = (int) $pageHits;
        return true;
    }

updateLastPostByObjId()

static ilForum::updateLastPostByObjId (   $a_obj_id )

static

Definition at line 2136 of file class.ilForum.php.

References $DIC, $ilDB, and array.

Referenced by mergeThreads().

    {
        global $DIC;
        $ilDB = $DIC->database();
        // get latest post of forum and update last_post
        $ilDB->setLimit(1);
        $res2 = $ilDB->queryf(
            '
                        SELECT pos_top_fk, pos_thr_fk, pos_pk FROM frm_posts, frm_data 
                        WHERE pos_top_fk = top_pk 
                        AND top_frm_fk = %s
                        ORDER BY pos_date DESC',
            array('integer'),
            array($a_obj_id)
        );

        if ($res2->numRows() == 0) {
            $lastPost_top = "";
        } else {
            $z = 0;

            while ($selData = $ilDB->fetchAssoc($res2)) {
                if ($z > 0) {
                    break;
                }

                $lastPost_top = $selData["pos_top_fk"] . "#" . $selData["pos_thr_fk"] . "#" . $selData["pos_pk"];
                $z++;
            }
        }

        $ilDB->update(
            'frm_data',
            array('top_last_post' => array('text', $lastPost_top)),
            array('top_frm_fk' => array('integer',  $a_obj_id))
        );
    }

Here is the caller graph for this function:

updateVisits()

ilForum::updateVisits

(

$ID

)

update page hits of given forum- or thread-ID public

Parameters

integer

Definition at line 1777 of file class.ilForum.php.

References $_SESSION, $query, $res, array, getMDB2DataType(), getMDB2DataValue(), getMDB2Query(), and time.

    {
        $checkTime = time() - (60*60);
            
        if ($_SESSION["frm_visit_" . $this->dbTable . "_" . $ID] < $checkTime) {
            $_SESSION["frm_visit_" . $this->dbTable . "_" . $ID] = time();
            $query = 'UPDATE ' . $this->dbTable . ' SET visits = visits + 1 WHERE ';
            
            $data_type = array();
            $data_value = array();
        
            if ($this->getMDB2Query() != '' && $this->getMDB2DataType() != '' && $this->getMDB2DataValue() != '') {
                $query .= $this->getMDB2Query();
                $data_type = $data_type + $this->getMDB2DataType();
                $data_value = $data_value + $this->getMDB2DataValue();

                $res = $this->db->queryf($query, $data_type, $data_value);
            }
        }
    }

Here is the call graph for this function:

Field Documentation

$className

ilForum::$className ="ilForum"

private

Definition at line 49 of file class.ilForum.php.

$db

ilForum::$db

Definition at line 32 of file class.ilForum.php.

$dbTable

ilForum::$dbTable

private

Definition at line 42 of file class.ilForum.php.

Referenced by getDbTable(), and setDbTable().

$error

ilForum::$error

Definition at line 31 of file class.ilForum.php.

$id

ilForum::$id

private

Definition at line 72 of file class.ilForum.php.

Referenced by getForumId(), and moveThreads().

$lng

ilForum::$lng

Definition at line 30 of file class.ilForum.php.

Referenced by setLanguage().

$mdb2DataType

ilForum::$mdb2DataType

private

Definition at line 61 of file class.ilForum.php.

Referenced by getMDB2DataType().

$mdb2DataValue

ilForum::$mdb2DataValue

private

Definition at line 60 of file class.ilForum.php.

Referenced by getMDB2DataValue().

$mdb2Query

ilForum::$mdb2Query

private

Definition at line 59 of file class.ilForum.php.

Referenced by getMDB2Query().

$moderators_by_ref_id_map

ilForum::$moderators_by_ref_id_map = array()

staticprotected

Definition at line 28 of file class.ilForum.php.

$orderField

ilForum::$orderField

private

Definition at line 57 of file class.ilForum.php.

Referenced by getOrderField(), and setOrderField().

$pageHits

ilForum::$pageHits = self::DEFAULT_PAGE_HITS

private

Definition at line 69 of file class.ilForum.php.

Referenced by getPageHits(), and setPageHits().

$replQuote1

ilForum::$replQuote1 = '<blockquote class="ilForumQuote">'

private

Definition at line 65 of file class.ilForum.php.

$replQuote2

ilForum::$replQuote2 = '</blockquote>'

private

Definition at line 66 of file class.ilForum.php.

$settings

ilForum::$settings

Definition at line 34 of file class.ilForum.php.

$txtQuote1

ilForum::$txtQuote1 = "[quote]"

private

Definition at line 63 of file class.ilForum.php.

$txtQuote2

ilForum::$txtQuote2 = "[/quote]"

private

Definition at line 64 of file class.ilForum.php.

Referenced by prepareText().

$user

ilForum::$user

Definition at line 33 of file class.ilForum.php.

DEFAULT_PAGE_HITS

const ilForum::DEFAULT_PAGE_HITS = 30

Definition at line 23 of file class.ilForum.php.

SORT_DATE

const ilForum::SORT_DATE = 2

Definition at line 21 of file class.ilForum.php.

SORT_TITLE

const ilForum::SORT_TITLE = 1

Definition at line 20 of file class.ilForum.php.

Referenced by ilObjForumGUI\cloneWizardPageObject().

---

The documentation for this class was generated from the following file:

• Modules/Forum/classes/class.ilForum.php