Collaboration diagram for ilForumTopic:

Public Member Functions
	__construct ($a_id=0, $a_is_moderator=false, $preventImplicitRead=false)
	Constructor. More...

	assignData ($data)

	insert ()
	Inserts the object data into database. More...

	update ()
	Updates an existing topic. More...

	reload ()
	Calls the private method read() to load the topic data from database into the object. More...

	getFirstPostId ()
	Fetches the primary key of the first post node of the current topic from database and returns it. More...

	updateVisits ()
	Updates the visit counter of the current topic. More...

	countPosts ()
	Fetches and returns the number of posts for the given user id. More...

	countActivePosts ()
	Fetches and returns the number of active posts for the given user id. More...

	getFirstPostNode ()
	Fetches and returns an object of the first post in the current topic. More...

	getLastPost ()
	Fetches and returns an object of the last post in the current topic. More...

	getLastActivePost ()
	Fetches and returns an object of the last active post in the current topic. More...

	getAllPosts ()

	getPostTree (ilForumPost $a_post_node)
	Fetches and returns an array of posts from the post tree, starting with the node object passed by the first paramter. More...

	movePosts ($old_obj_id, $old_pk, $new_obj_id, $new_pk)
	Moves all posts within the current thread to a new forum. More...

	getNestedSetPostChildren ($pos_id=null, $levels=null)

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

	enableNotification ($a_user_id)
	Enable a user's notification about new posts in a thread. More...

	disableNotification ($a_user_id)
	Disable a user's notification about new posts in a thread. More...

	makeSticky ()
	Sets the current topic sticky. More...

	unmakeSticky ()
	Sets the current topic non-sticky. More...

	close ()
	Closes the current topic. More...

	reopen ()
	Reopens the current topic. More...

	getAverageRating ()

	setAverageRating ($average_rating)

	setId ($a_id)

	getId ()

	setForumId ($a_forum_id)

	getForumId ()

	setDisplayUserId ($a_user_id)

	getDisplayUserId ()

	setUserAlias ($a_user_alias)

	getUserAlias ()

	setSubject ($a_subject)

	getSubject ()

	setCreateDate ($a_createdate)

	getCreateDate ()

	setChangeDate ($a_changedate)

	getChangeDate ()

	setImportName ($a_import_name)

	getImportName ()

	setLastPostString ($a_last_post)

	getLastPostString ()

	setVisits ($a_visits)

	getVisits ()

	setSticky ($a_sticky)

	isSticky ()

	setClosed ($a_closed)

	isClosed ()

	setOrderField ($a_order_field)

	getOrderField ()

	setModeratorRight ($bool)

	getModeratorRight ()

	getFrmObjId ()

	setThrAuthorId ($thr_author_id)

	getThrAuthorId ()

	updateThreadTitle ()

	setNumPosts ($a_num_posts)

	getNumPosts ()

	setNumNewPosts ($num_new_posts)

	getNumNewPosts ()

	setNumUnreadPosts ($num_unread_posts)

	getNumUnreadPosts ()

	setUserNotificationEnabled ($user_notification_enabled)

	getUserNotificationEnabled ()

	setOrderDirection ($direction)

	getOrderDirection ()

	getLastPostForThreadOverview ()

	setLastPostForThreadOverview (ilForumPost $post)

	getSorting ()

	updateMergedThread ()

Static Public Member Functions
static	_lookupTitle ($a_topic_id)
	Looks up the title/subject of a topic/thread. More...

static	lookupForumIdByTopicId ($a_topic_id)

static	deleteByThreadId ($thr_id)

static	_lookupDate ($thread_id)

Static Protected Attributes
static	$possibleOrderDirections = array('ASC', 'DESC')

Private Member Functions
	read ()
	Reads the data of the current object id from database and loads it into the object. More...

Private Attributes
	$id = 0

	$forum_id = 0

	$frm_obj_id = 0

	$display_user_id = 0

	$user_alias = ''

	$subject = ''

	$createdate = null

	$changedate = null

	$num_posts = 0

	$last_post_string = ''

	$visits = 0

	$import_name = ''

	$is_sticky = 0

	$is_closed = 0

	$orderField = ''

	$last_post = null

	$db = null

	$is_moderator = false

	$thr_author_id = 0

	$average_rating = 0

	$orderDirection = 'DESC'

Detailed Description

Author: Michael Jansen mjans.nosp@m.en@d.nosp@m.ataba.nosp@m.y.de

Version: $Id:$

Definition at line 12 of file class.ilForumTopic.php.

Constructor & Destructor Documentation

◆ __construct()

ilForumTopic::__construct	(	$a_id = `0`,
		$a_is_moderator = `false`,
		$preventImplicitRead = `false`
	)

Constructor.

Returns an object of a forum topic. The constructor calls the private method read() to load the topic data from database into the object.

Parameters

integer	$a_id	primary key of a forum topic (optional)
bool	$a_is_moderator	moderator-status of the current user (optional)
bool	$preventImplicitRead	Prevents the implicit database query if an id was passed

public

Definition at line 73 of file class.ilForumTopic.php.

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

     {
         global $DIC;
 
         $this->is_moderator = $a_is_moderator;
         $this->db = $DIC->database();
         $this->user = $DIC->user();
         $this->id = $a_id;
         
         if (!$preventImplicitRead) {
             $this->read();
         }
     }

Here is the call graph for this function:

Member Function Documentation

◆ _lookupDate()

static ilForumTopic::_lookupDate ( $thread_id )

static

Parameters

integer $thread_id

Returns: string datetime

Definition at line 1332 of file class.ilForumTopic.php.

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

Referenced by ilObjForumGUI\confirmMergeThreadsObject().

     {
         global $DIC;
         $ilDB = $DIC->database();
         
         $res = $ilDB->queryF(
             'SELECT thr_date FROM frm_threads WHERE thr_pk = %s',
             array('integer'),
             array((int) $thread_id)
         );
         
         $row = $ilDB->fetchAssoc($res);
         
         return $row['thr_date'] ? $row['thr_date'] : '0000-00-00 00:00:00';
     }

Here is the caller graph for this function:

◆ _lookupTitle()

static ilForumTopic::_lookupTitle ( $a_topic_id )

static

Looks up the title/subject of a topic/thread.

Parameters

integer id of the topic/thread

Returns: string title/subject of the topic/thread public

Definition at line 1155 of file class.ilForumTopic.php.

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

Referenced by ilObjForumGUI\confirmMergeThreadsObject().

     {
         global $DIC;
         $ilDB = $DIC->database();
         
         $res = $ilDB->queryf(
             '
                         SELECT thr_subject
                         FROM frm_threads
                         WHERE thr_pk = %s',
             array('integer'),
             array($a_topic_id)
         );
         $row = $ilDB->fetchObject($res);
 
         if (is_object($row)) {
             return $row->thr_subject;
         }
         
         return '';
     }

Here is the caller graph for this function:

◆ assignData()

ilForumTopic::assignData ( $data )

Parameters

$data

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

References $data, setAverageRating(), setChangeDate(), setClosed(), setCreateDate(), setDisplayUserId(), setForumId(), setId(), setImportName(), setLastPostString(), setNumNewPosts(), setNumPosts(), setNumUnreadPosts(), setSticky(), setSubject(), setThrAuthorId(), setUserAlias(), setUserNotificationEnabled(), and setVisits().

     {
         $this->setId((int) $data['thr_pk']);
         $this->setForumId((int) $data['thr_top_fk']);
         $this->setSubject($data['thr_subject']);
         $this->setDisplayUserId((int) $data['thr_display_user_id']);
         $this->setUserAlias($data['thr_usr_alias']);
         $this->setLastPostString($data['last_post_string']);
         $this->setCreateDate($data['thr_date']);
         $this->setChangeDate($data['thr_update']);
         $this->setVisits((int) $data['visits']);
         $this->setImportName($data['import_name']);
         $this->setSticky((int) $data['is_sticky']);
         $this->setClosed((int) $data['is_closed']);
         $this->setAverageRating($data['avg_rating']);
         $this->setThrAuthorId($data['thr_author_id']);
 
         // Aggregated values
         $this->setNumPosts((int) $data['num_posts']);
         $this->setNumUnreadPosts((int) $data['num_unread_posts']);
         $this->setNumNewPosts((int) $data['num_new_posts']);
         $this->setUserNotificationEnabled((bool) $data['usr_notification_is_enabled']);
     }

Here is the call graph for this function:

◆ close()

ilForumTopic::close ( )

Closes the current topic.

Returns: bool true in case of success, false in case of failure public

Definition at line 944 of file class.ilForumTopic.php.

References array.

     {
         if ($this->id && !$this->is_closed) {
             $this->db->manipulateF(
                 '
                                 UPDATE frm_threads 
                                 SET is_closed = %s
                                 WHERE thr_pk = %s',
                 array('integer', 'integer'),
                 array('1', $this->id)
             );
                 
             $this->is_closed = 1;
             
             return true;
         }
         
         return false;
     }

◆ countActivePosts()

ilForumTopic::countActivePosts ( )

Fetches and returns the number of active posts for the given user id.

Parameters

integer $a_user_id user id

Returns: integer number of active posts public

Definition at line 327 of file class.ilForumTopic.php.

References $id, $res, array, ilDBConstants\FETCHMODE_ASSOC, and user().

     {
         $res = $this->db->queryf(
             '
                         SELECT COUNT(*) cnt
                         FROM frm_posts
                         WHERE (pos_status = %s
                                  OR (pos_status = %s AND pos_display_user_id = %s))
                         AND pos_thr_fk = %s',
             array('integer', 'integer', 'integer', 'integer'),
             array('1', '0', $this->user->getId(), $this->id)
         );
             
         $rec = $res->fetchRow(ilDBConstants::FETCHMODE_ASSOC);
             
         return $rec['cnt'];
     }

Here is the call graph for this function:

◆ countPosts()

ilForumTopic::countPosts ( )

Fetches and returns the number of posts for the given user id.

Parameters

integer $a_user_id user id

Returns: integer number of posts public

Definition at line 304 of file class.ilForumTopic.php.

References $res, array, and ilDBConstants\FETCHMODE_ASSOC.

     {
         $res = $this->db->queryf(
             '
                         SELECT COUNT(*) cnt
                         FROM frm_posts
                         WHERE pos_thr_fk = %s',
             array('integer'),
             array($this->id)
         );
         
         $rec = $res->fetchRow(ilDBConstants::FETCHMODE_ASSOC);
             
         return $rec['cnt'];
     }

◆ deleteByThreadId()

static ilForumTopic::deleteByThreadId ( $thr_id )

static

Definition at line 1317 of file class.ilForumTopic.php.

References $DIC, and array.

Referenced by ilForum\mergeThreads().

     {
         global $DIC;
         $DIC->database()->manipulateF(
             'DELETE FROM frm_threads WHERE thr_pk = %s',
             array('integer'),
             array($thr_id)
         );
     }

Here is the caller graph for this function:

◆ disableNotification()

ilForumTopic::disableNotification ( $a_user_id )

Disable a user's notification about new posts in a thread.

Parameters

integer $a_user_id id of an user

Returns: bool true in case of success, false in case of failure public

Definition at line 868 of file class.ilForumTopic.php.

References array.

     {
         if ($this->id && $a_user_id) {
             $this->db->manipulateF(
                 '
                                 DELETE FROM frm_notification
                                 WHERE user_id = %s
                                 AND thread_id = %s',
                 array('integer', 'integer'),
                 array($a_user_id, $this->id)
             );
                 
             return false;
         }
         
         return false;
     }

◆ enableNotification()

ilForumTopic::enableNotification ( $a_user_id )

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

Parameters

integer $a_user_id id of an user

Returns: bool true in case of success, false in case of failure public

Definition at line 837 of file class.ilForumTopic.php.

References array, and isNotificationEnabled().

Referenced by ilForum\generateThread().

     {
         if ($this->id && $a_user_id) {
             if (!$this->isNotificationEnabled($a_user_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, $a_user_id, $this->id)
                 );
 
                 return true;
             }
             return false;
         }
         
         return false;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getAllPosts()

ilForumTopic::getAllPosts ( )

Definition at line 427 of file class.ilForumTopic.php.

References $res, $row, array, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by movePosts().

     {
         $posts = array();
         
         if ($this->id) {
             $res = $this->db->queryf(
                 '
                                 SELECT pos_pk
                                 FROM frm_posts 
                                 WHERE pos_thr_fk = %s',
                 array('integer'),
                 array($this->id)
             );
             
             while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
                 $posts[$row->pos_pk] = $row;
             }
         }
         
         return is_array($posts) ? $posts : array();
     }

Here is the caller graph for this function:

◆ getAverageRating()

ilForumTopic::getAverageRating ( )

Returns: int

Definition at line 993 of file class.ilForumTopic.php.

References $average_rating.

     {
         return $this->average_rating;
     }

◆ getChangeDate()

ilForumTopic::getChangeDate ( )

Definition at line 1062 of file class.ilForumTopic.php.

References $changedate.

     {
         return $this->changedate;
     }

◆ getCreateDate()

ilForumTopic::getCreateDate ( )

Definition at line 1050 of file class.ilForumTopic.php.

References $createdate.

Referenced by ilForum\generateThread().

     {
         return $this->createdate;
     }

Here is the caller graph for this function:

◆ getDisplayUserId()

ilForumTopic::getDisplayUserId ( )

Definition at line 1026 of file class.ilForumTopic.php.

References $display_user_id.

Referenced by ilForum\generateThread().

     {
         return $this->display_user_id;
     }

Here is the caller graph for this function:

◆ getFirstPostId()

ilForumTopic::getFirstPostId ( )

Fetches the primary key of the first post node of the current topic from database and returns it.

Returns: integer primary key of the first post node public

Definition at line 256 of file class.ilForumTopic.php.

References $res, $row, array, and ilDBConstants\FETCHMODE_OBJECT.

     {
         $res = $this->db->queryf(
             '
                         SELECT * FROM frm_posts_tree 
                         WHERE thr_fk = %s
                         AND parent_pos = %s',
             array('integer', 'integer'),
             array($this->id, '1')
         );
         
         $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
         
         return $row->pos_fk ? $row->pos_fk : 0;
     }

◆ getFirstPostNode()

ilForumTopic::getFirstPostNode ( )

Fetches and returns an object of the first post in the current topic.

Returns: ilForumPost object of a post public

Definition at line 351 of file class.ilForumTopic.php.

References $res, $row, array, and ilDBConstants\FETCHMODE_OBJECT.

     {
         $res = $this->db->queryf(
             '
                         SELECT pos_pk
                         FROM frm_posts 
                         INNER JOIN frm_posts_tree ON pos_fk = pos_pk
                         WHERE parent_pos = %s
                         AND thr_fk = %s',
             array('integer', 'integer'),
             array('0', $this->id)
         );
             
         $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
         
         return new ilForumPost($row->pos_pk);
     }

◆ getForumId()

ilForumTopic::getForumId ( )

Definition at line 1018 of file class.ilForumTopic.php.

References $forum_id.

Referenced by ilForumExportGUI\ensureThreadBelongsToForum(), ilObjForumGUI\ensureThreadBelongsToForum(), and ilForum\generateThread().

     {
         return $this->forum_id;
     }

Here is the caller graph for this function:

◆ getFrmObjId()

ilForumTopic::getFrmObjId ( )

Definition at line 1126 of file class.ilForumTopic.php.

References $frm_obj_id.

Referenced by getNestedSetPostChildren().

     {
         return $this->frm_obj_id;
     }

Here is the caller graph for this function:

◆ getId()

ilForumTopic::getId ( )

Definition at line 1010 of file class.ilForumTopic.php.

References $id.

Referenced by ilForum\generateThread(), updateMergedThread(), and updateThreadTitle().

     {
         return $this->id;
     }

Here is the caller graph for this function:

◆ getImportName()

ilForumTopic::getImportName ( )

Definition at line 1070 of file class.ilForumTopic.php.

References $import_name.

     {
         return $this->import_name;
     }

◆ getLastActivePost()

ilForumTopic::getLastActivePost ( )

Fetches and returns an object of the last active post in the current topic.

Returns: ilForumPost object of the last active post public

Definition at line 403 of file class.ilForumTopic.php.

References $res, $row, array, ilDBConstants\FETCHMODE_OBJECT, and user().

     {
         if ($this->id) {
             $this->db->setLimit(1);
             $res = $this->db->queryf(
                 '
                                 SELECT pos_pk
                                 FROM frm_posts 
                                 WHERE pos_thr_fk = %s           
                                 AND (pos_status = %s OR 
                                         (pos_status = %s AND pos_display_user_id = %s))                                                  
                                 ORDER BY pos_date DESC',
                 array('integer', 'integer', 'integer', 'integer'),
                 array($this->id, '1', '0', $this->user->getId())
             );
             
             $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
             
             return new ilForumPost($row->pos_pk);
         }
         
         return false;
     }

Here is the call graph for this function:

◆ getLastPost()

ilForumTopic::getLastPost ( )

Fetches and returns an object of the last post in the current topic.

Returns: ilForumPost object of the last post public

Definition at line 375 of file class.ilForumTopic.php.

References $res, $row, array, and ilDBConstants\FETCHMODE_OBJECT.

     {
         if ($this->id) {
             $this->db->setLimit(1);
             $res = $this->db->queryf(
                 '
                                 SELECT pos_pk
                                 FROM frm_posts 
                                 WHERE pos_thr_fk = %s                            
                                 ORDER BY pos_date DESC',
                 array('integer'),
                 array($this->id)
             );
             
             $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
 
             return new ilForumPost($row->pos_pk);
         }
         
         return false;
     }

◆ getLastPostForThreadOverview()

ilForumTopic::getLastPostForThreadOverview ( )

Definition at line 1273 of file class.ilForumTopic.php.

References $last_post.

     {
         return $this->last_post;
     }

◆ getLastPostString()

ilForumTopic::getLastPostString ( )

Definition at line 1082 of file class.ilForumTopic.php.

References $last_post_string.

Referenced by updateMergedThread().

     {
         return $this->last_post_string;
     }

Here is the caller graph for this function:

◆ getModeratorRight()

ilForumTopic::getModeratorRight ( )

Definition at line 1122 of file class.ilForumTopic.php.

References $is_moderator.

     {
         return $this->is_moderator;
     }

◆ getNestedSetPostChildren()

ilForumTopic::getNestedSetPostChildren	(	$pos_id = `null`,
		$levels = `null`
	)

Definition at line 671 of file class.ilForumTopic.php.

References $counter, $data, $i, $query, $res, $row, array, getFrmObjId(), ilForumProperties\getInstance(), ilForumAuthorInformationCache\preloadUserObjects(), and user().

     {
         $data = null;
         $objProperties = ilForumProperties::getInstance($this->getFrmObjId());
         $is_post_activation_enabled = $objProperties->isPostActivationEnabled();
 
         if ($pos_id !== null) {
             $res = $this->db->queryF(
                 "
                                 SELECT          lft, rgt, depth
                                 FROM            frm_posts_tree
                                 WHERE           pos_fk = %s
                                 AND                     thr_fk = %s",
                 array('integer', 'integer'),
                 array($pos_id, $this->id)
             );
 
             $data = $this->db->fetchAssoc($res);
         }
 
         $query = '
                         SELECT                  fpt.depth,
                                                         fpt.rgt,
                                                         fpt.parent_pos,
                                                         fp.pos_pk,
                                                         fp.pos_subject,
                                                         fp.pos_usr_alias,
                                                         fp.pos_date,
                                                         fp.pos_update,
                                                         fp.pos_status,
                                                         fp.pos_display_user_id,
                                                         fp.pos_usr_alias,
                                                         fp.import_name,
                                                         fp.pos_author_id,
                                                         fp.is_author_moderator,
                                                         fur.post_id,
                                                         (CASE
                                                         WHEN fur.post_id IS NULL ' .
                                 ($this->user->getId() == ANONYMOUS_USER_ID ? ' AND 1 = 2 ' : '') . '
                                                         THEN 0
                                                         ELSE 1
                                                         END) post_read,
                                                         COUNT(fpt2.pos_fk) children
 
                         FROM                    frm_posts_tree fpt
 
                         INNER JOIN              frm_posts fp
                                 ON                      fp.pos_pk = fpt.pos_fk
                                 
                         LEFT JOIN               frm_posts_tree fpt2
                                  ON         fpt2.lft BETWEEN fpt.lft AND fpt.rgt
                                  AND            fpt.thr_fk = fpt2.thr_fk
                                  AND            fpt.pos_fk != fpt2.pos_fk ';
                                 
     
         $query .= '
                         LEFT JOIN               frm_user_read fur
                                 ON                      fur.thread_id = fp.pos_thr_fk
                                 AND                     fur.post_id = fp.pos_pk
                                 AND                     fur.usr_id = ' . $this->db->quote($this->user->getId(), 'integer') . '
 
                         LEFT JOIN               usr_data ud
                                 ON                      ud.usr_id = fp.pos_display_user_id
                 
                         WHERE                   fpt.thr_fk = ' . $this->db->quote($this->id, 'integer');
 
         if ($data) {
             $query .= '         AND fpt.lft > ' . $this->db->quote($data['lft'], 'integer') .
                     '           AND fpt.lft < ' . $this->db->quote($data['rgt'], 'integer') . ' ';
         }
         if ($is_post_activation_enabled && !$this->is_moderator) {
             $query .= ' AND (fp.pos_status = 1 OR fp.pos_status = 0 AND fp.pos_display_user_id = ' . $this->db->quote($this->user->getId(), 'integer') . ') ';
         }
 
         if ($data && is_numeric($levels)) {
             $query .= ' AND fpt.depth <= ' . $this->db->quote($data['depth'] + $levels, 'integer') . ' ';
         }
 
         $query .= ' GROUP BY fpt.depth,
                                                         fpt.rgt,
                                                         fpt.parent_pos,
                                                         fp.pos_pk,
                                                         fp.pos_subject,
                                                         fp.pos_usr_alias,
                                                         fp.pos_date,
                                                         fp.pos_update,
                                                         fp.pos_status,
                                                         fp.pos_display_user_id,
                                                         fp.pos_usr_alias,
                                                         fp.import_name,
                                                         fp.pos_author_id,
                                                         fp.is_author_moderator,
                                                         fur.post_id
                                         ORDER BY fpt.rgt DESC
                 ';
         
         $queryCounter = '
                         SELECT                  pos_fk
                         FROM                    frm_posts_tree fpt
                         INNER JOIN              frm_posts fp
                                 ON                      fp.pos_pk = fpt.pos_fk
                         WHERE                   fpt.thr_fk = ' . $this->db->quote($this->id, 'integer');
 
         if ($is_post_activation_enabled && !$this->is_moderator) {
             $queryCounter .= ' AND (fp.pos_status = 1 OR fp.pos_status = 0 AND fp.pos_display_user_id = ' . $this->db->quote($this->user->getId(), 'integer') . ') ';
         }
         $queryCounter .= ' ORDER BY fpt.rgt DESC';
 
         $resCounter = $this->db->query($queryCounter);
         $counter = array();
         $i = 0;
         while ($row = $this->db->fetchAssoc($resCounter)) {
             $counter[$row['pos_fk']] = $i++;
         }
 
         $res = $this->db->query($query);
         $children = array();
         $usr_ids = array();
         while ($row = $this->db->fetchAssoc($res)) {
             if ((int) $row['pos_display_user_id']) {
                 $usr_ids[] = (int) $row['pos_display_user_id'];
             }
             
             $row['counter'] = $counter[$row['pos_pk']];
             $children[] = $row;
         }
 
         require_once 'Modules/Forum/classes/class.ilForumAuthorInformationCache.php';
         ilForumAuthorInformationCache::preloadUserObjects(array_unique($usr_ids));
 
         return $children;
     }

Here is the call graph for this function:

◆ getNumNewPosts()

ilForumTopic::getNumNewPosts ( )

Returns: int

Definition at line 1217 of file class.ilForumTopic.php.

     {
         return $this->num_new_posts;
     }

◆ getNumPosts()

ilForumTopic::getNumPosts ( )

Returns: int

Definition at line 1199 of file class.ilForumTopic.php.

References $num_posts.

Referenced by updateMergedThread().

     {
         return $this->num_posts;
     }

Here is the caller graph for this function:

◆ getNumUnreadPosts()

ilForumTopic::getNumUnreadPosts ( )

Returns: int

Definition at line 1235 of file class.ilForumTopic.php.

     {
         return $this->num_unread_posts;
     }

◆ getOrderDirection()

ilForumTopic::getOrderDirection ( )

Definition at line 1268 of file class.ilForumTopic.php.

References $orderDirection.

Referenced by getPostTree().

     {
         return $this->orderDirection;
     }

Here is the caller graph for this function:

◆ getOrderField()

ilForumTopic::getOrderField ( )

Definition at line 1114 of file class.ilForumTopic.php.

References $orderField.

     {
         return $this->orderField;
     }

◆ getPostTree()

ilForumTopic::getPostTree ( ilForumPost $a_post_node )

Fetches and returns an array of posts from the post tree, starting with the node object passed by the first paramter.

Parameters

ilForumPost $a_post_node node-object of a post

Returns: array array of post objects public

Definition at line 457 of file class.ilForumTopic.php.

References $data, $query, $res, $row, array, ilForumPost\getLft(), getOrderDirection(), ilForumPost\getRgt(), ilForumPost\getThreadId(), ilForumAuthorInformationCache\preloadUserObjects(), and user().

     {
         $posts = array();
         
         $data = array();
         $data_types = array();
 
         $query = '
                         SELECT                  is_author_moderator, pos_author_id, pos_pk, fpt_date, rgt, pos_top_fk, pos_thr_fk, 
                                                         pos_display_user_id, pos_usr_alias, pos_subject,
                                                         pos_status, pos_message, pos_date, pos_update,
                                                         update_user, pos_cens, pos_cens_com, notify,
                                                         import_name, fpt_pk, parent_pos, lft, depth,
                                                         (CASE
                                                         WHEN fur.post_id IS NULL ' .
                                 ($this->user->getId() == ANONYMOUS_USER_ID ? ' AND 1 = 2 ' : '') . '
                                                         THEN 0
                                                         ELSE 1
                                                         END) post_read,
                                                         firstname, lastname, title, login
                                                          
                         FROM                    frm_posts_tree
                          
                         INNER JOIN              frm_posts 
                                 ON                      pos_fk = pos_pk
                                 
                         LEFT JOIN               usr_data
                                 ON                      pos_display_user_id  = usr_id
                                 
                         LEFT JOIN               frm_user_read fur
                                 ON                      fur.thread_id = pos_thr_fk
                                 AND                     fur.post_id = pos_pk
                                 AND                     fur.usr_id = %s
                                  
                         WHERE                   lft BETWEEN %s AND %s 
                                 AND             thr_fk = %s';
         
         array_push($data_types, 'integer', 'integer', 'integer', 'integer');
         array_push($data, $this->user->getId(), $a_post_node->getLft(), $a_post_node->getRgt(), $a_post_node->getThreadId());
 
         if ($this->orderField != "") {
             $query .= " ORDER BY " . $this->orderField . " " . $this->getOrderDirection();
         }
 
         $res = $this->db->queryf($query, $data_types, $data);
         
         $usr_ids = array();
 
         $deactivated = array();
         while ($row = $this->db->fetchAssoc($res)) {
             $tmp_object = new ilForumPost($row['pos_pk'], false, true);
             $tmp_object->assignData($row);
 
             if (!$this->is_moderator) {
                 if (!$tmp_object->isActivated() && $tmp_object->getDisplayUserId() != $this->user->getId()) {
                     $deactivated[] = $tmp_object;
                     unset($tmp_object);
                     continue;
                 }
              
                 foreach ($deactivated as $deactivated_node) {
                     if ($deactivated_node->getLft() < $tmp_object->getLft() && $deactivated_node->getRgt() > $tmp_object->getLft()) {
                         $deactivated[] = $tmp_object;
                         unset($tmp_object);
                         continue 2;
                     }
                 }
             }
 
             if ((int) $row['pos_display_user_id']) {
                 $usr_ids[] = (int) $row['pos_display_user_id'];
             }
             if ((int) $row['update_user']) {
                 $usr_ids[] = (int) $row['update_user'];
             }
              
             $posts[] = $tmp_object;
              
             unset($tmp_object);
         }
 
         require_once 'Modules/Forum/classes/class.ilForumAuthorInformationCache.php';
         ilForumAuthorInformationCache::preloadUserObjects(array_unique($usr_ids));
 
         return $posts;
     }

Here is the call graph for this function:

◆ getSorting()

ilForumTopic::getSorting ( )

Definition at line 1299 of file class.ilForumTopic.php.

     {
         return $this->thread_sorting;
     }

◆ getSubject()

ilForumTopic::getSubject ( )

Definition at line 1042 of file class.ilForumTopic.php.

References $subject.

Referenced by ilForum\generateThread(), updateMergedThread(), and updateThreadTitle().

     {
         return $this->subject;
     }

Here is the caller graph for this function:

◆ getThrAuthorId()

ilForumTopic::getThrAuthorId ( )

Returns: int

Definition at line 1142 of file class.ilForumTopic.php.

References $thr_author_id.

Referenced by ilForum\generateThread().

     {
         return $this->thr_author_id;
     }

Here is the caller graph for this function:

◆ getUserAlias()

ilForumTopic::getUserAlias ( )

Definition at line 1034 of file class.ilForumTopic.php.

References $user_alias.

Referenced by ilForum\generateThread().

     {
         return $this->user_alias;
     }

Here is the caller graph for this function:

◆ getUserNotificationEnabled()

ilForumTopic::getUserNotificationEnabled ( )

Returns: boolean

Definition at line 1253 of file class.ilForumTopic.php.

     {
         return $this->user_notification_enabled;
     }

◆ getVisits()

ilForumTopic::getVisits ( )

Definition at line 1090 of file class.ilForumTopic.php.

References $visits.

Referenced by updateMergedThread().

     {
         return $this->visits;
     }

Here is the caller graph for this function:

◆ insert()

ilForumTopic::insert ( )

Inserts the object data into database.

Returns: bool true in case of success, false in case of failure public

Definition at line 120 of file class.ilForumTopic.php.

References array.

Referenced by ilForum\generateThread().

     {
         if ($this->forum_id) {
             $nextId = $this->db->nextId('frm_threads');
                         
             $this->db->insert(
                 'frm_threads',
                 array(
                 'thr_pk'        => array('integer', $nextId),
                 'thr_top_fk'    => array('integer', $this->forum_id),
                 'thr_subject'   => array('text', $this->subject),
                 'thr_display_user_id'    => array('integer', $this->display_user_id),
                 'thr_usr_alias' => array('text', $this->user_alias),
                 'thr_num_posts' => array('integer', $this->num_posts),
                 'thr_last_post' => array('text', $this->last_post_string),
                 'thr_date'      => array('timestamp', $this->createdate),
                 'thr_update'    => array('timestamp', null),
                 'import_name'   => array('text', $this->import_name),
                 'is_sticky'     => array('integer', $this->is_sticky),
                 'is_closed'     => array('integer', $this->is_closed),
                 'avg_rating'    => array('float', $this->average_rating),
                 'thr_author_id' => array('integer', $this->thr_author_id)
             )
             );
 
             $this->id = $nextId;
                             
             return true;
         }
         
         return false;
     }

Here is the caller graph for this function:

◆ isClosed()

ilForumTopic::isClosed ( )

Definition at line 1106 of file class.ilForumTopic.php.

     {
         return $this->is_closed == 1 ? true : false;
     }

◆ isNotificationEnabled()

ilForumTopic::isNotificationEnabled ( $a_user_id )

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

Parameters

integer $a_user_id id of an user

Returns: bool true in case of success, false in case of failure public

Definition at line 810 of file class.ilForumTopic.php.

References $result, and array.

Referenced by enableNotification().

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

Here is the caller graph for this function:

◆ isSticky()

ilForumTopic::isSticky ( )

Definition at line 1098 of file class.ilForumTopic.php.

     {
         return $this->is_sticky == 1 ? true : false;
     }

◆ lookupForumIdByTopicId()

static ilForumTopic::lookupForumIdByTopicId ( $a_topic_id )

static

Definition at line 1283 of file class.ilForumTopic.php.

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

Referenced by ilObjForumGUI\confirmMergeThreadsObject().

     {
         global $DIC;
         $ilDB = $DIC->database();
 
         $res = $ilDB->queryF(
             'SELECT thr_top_fk FROM frm_threads WHERE thr_pk = %s',
             array('integer'),
             array($a_topic_id)
         );
 
         $row = $ilDB->fetchAssoc($res);
 
         return $row['thr_top_fk'];
     }

Here is the caller graph for this function:

◆ makeSticky()

ilForumTopic::makeSticky ( )

Sets the current topic sticky.

Returns: bool true in case of success, false in case of failure public

Definition at line 892 of file class.ilForumTopic.php.

References array.

     {
         if ($this->id && !$this->is_sticky) {
             $this->db->manipulateF(
                 '
                                 UPDATE frm_threads 
                                 SET is_sticky = %s
                                 WHERE thr_pk = %s',
                 array('integer', 'integer'),
                 array('1', $this->id)
             );
             
             $this->is_sticky = 1;
             
             return true;
         }
         
         return false;
     }

◆ movePosts()

ilForumTopic::movePosts	(	$old_obj_id,
		$old_pk,
		$new_obj_id,
		$new_pk
	)

Moves all posts within the current thread to a new forum.

Parameters

integer	$old_obj_id	object id of the current forum
integer	$old_pk	primary key of old forum
integer	$new_obj_id	object id of the new forum
integer	$new_pk	primary key of new forum

Returns: integer number of afffected rows by updating posts public

Definition at line 554 of file class.ilForumTopic.php.

References $id, $ilDB, $post, ilForum\_lookupObjIdForForumId(), array, ilDBConstants\FETCHMODE_ASSOC, getAllPosts(), ilNewsItem\getFirstNewsIdForContext(), and ilDBInterface\manipulateF().

     {
         if ($this->id) {
             $nodes = $this->getAllPosts();
             if (is_array($nodes)) {
                 $postsMoved = array();
                 // Move attachments
                 try {
                     foreach ($nodes as $node) {
                         $file_obj = new ilFileDataForum((int) $old_obj_id, (int) $node->pos_pk);
                         $moved = $file_obj->moveFilesOfPost((int) $new_obj_id);
 
                         if (true === $moved) {
                             $postsMoved[] = array(
                                 'from' => $old_obj_id,
                                 'to' => $new_obj_id,
                                 'position_id' => (int) $node->pos_pk
                             );
                         }
 
                         unset($file_obj);
                     }
                 } catch (\ilFileUtilsException $exception) {
                     foreach ($postsMoved as $postedInformation) {
                         $file_obj = new ilFileDataForum($postedInformation['to'], $postedInformation['position_id']);
                         $file_obj->moveFilesOfPost($postedInformation['from']);
                     }
 
                     throw $exception;
                 }
             }
 
             $current_id = $this->id;
 
             $ilAtomQuery = $this->db->buildAtomQuery();
             $ilAtomQuery->addTableLock('frm_user_read');
             $ilAtomQuery->addTableLock('frm_thread_access');
 
             $ilAtomQuery->addQueryCallable(function (ilDBInterface $ilDB) use ($new_obj_id, $current_id) {
                 $ilDB->manipulateF(
                     '
                                 DELETE FROM frm_user_read
                                 WHERE obj_id = %s AND thread_id =%s',
                     array('integer', 'integer'),
                     array($new_obj_id, $current_id)
                 );
 
                 $ilDB->manipulateF(
                     '
                                 UPDATE frm_user_read
                                 SET obj_id = %s
                                 WHERE thread_id = %s',
                     array('integer', 'integer'),
                     array($new_obj_id, $current_id)
                 );
 
                 $ilDB->manipulateF(
                     '
                                 DELETE FROM frm_thread_access
                                 WHERE obj_id = %s AND thread_id =%s',
                     array('integer', 'integer'),
                     array($new_obj_id, $current_id)
                 );
 
                 $ilDB->manipulateF(
                     '
                                 UPDATE frm_thread_access
                                 SET obj_id = %s
                                 WHERE thread_id =%s',
                     array('integer', 'integer'),
                     array($new_obj_id, $current_id)
                 );
             });
 
             $ilAtomQuery->run();
 
             $this->db->manipulateF(
                 '
                                 UPDATE frm_posts
                                 SET pos_top_fk = %s
                                 WHERE pos_thr_fk = %s',
                 array('integer', 'integer'),
                 array($new_pk, $this->id)
             );
             
             // update all related news
             $posts = $this->db->queryf(
                 '
                                 SELECT * FROM frm_posts WHERE pos_thr_fk = %s',
                 array('integer'),
                 array($this->id)
             );
             
             $old_obj_id = ilForum::_lookupObjIdForForumId($old_pk);
 
             $new_obj_id = ilForum::_lookupObjIdForForumId($new_pk);
 
             while ($post = $posts->fetchRow(ilDBConstants::FETCHMODE_ASSOC)) {
                 include_once("./Services/News/classes/class.ilNewsItem.php");
                 $news_id = ilNewsItem::getFirstNewsIdForContext(
                     $old_obj_id,
                     "frm",
                     $post["pos_pk"],
                     "pos"
                 );
                 $news_item = new ilNewsItem($news_id);
                 $news_item->setContextObjId($new_obj_id);
                 $news_item->update();
                 //echo "<br>-".$post["pos_pk"]."-".$old_obj_id."-".$new_obj_id."-";
             }
             
             return count($nodes);
         }
         
         return 0;
     }

Here is the call graph for this function:

◆ read()

ilForumTopic::read ( )

private

Reads the data of the current object id from database and loads it into the object.

Returns: bool true in case of success, false in case of failure

private

Definition at line 197 of file class.ilForumTopic.php.

References $res, $row, array, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by __construct(), and reload().

     {
         if ($this->id) {
             $res = $this->db->queryf(
                 '
                                 SELECT frm_threads.*, top_frm_fk frm_obj_id
                                 FROM frm_threads
                                 INNER JOIN frm_data ON top_pk = thr_top_fk
                                 WHERE thr_pk = %s',
                 array('integer'),
                 array($this->id)
             );
 
             $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
 
             if (is_object($row)) {
                 $this->thr_pk           = $row->pos_pk;   // thr_pk = pos_pk ??!??!
                 $this->forum_id         = $row->thr_top_fk;
                 $this->display_user_id  = $row->thr_display_user_id;
                 $this->user_alias       = $row->thr_usr_alias;
                 $this->subject          = html_entity_decode($row->thr_subject);
                 $this->createdate       = $row->thr_date;
                 $this->changedate       = $row->thr_update;
                 $this->import_name      = $row->import_name;
                 $this->num_posts        = $row->thr_num_posts;
                 $this->last_post_string = $row->thr_last_post;
                 $this->visits           = $row->visits;
                 $this->is_sticky        = $row->is_sticky;
                 $this->is_closed        = $row->is_closed;
                 $this->frm_obj_id       = $row->frm_obj_id;
                 $this->average_rating   = $row->avg_rating;
                 $this->thr_author_id    = $row->thr_author_id;
                 
                 return true;
             }
             $this->id = 0;
             return false;
         }
         
         return false;
     }

Here is the caller graph for this function:

◆ reload()

ilForumTopic::reload ( )

Calls the private method read() to load the topic data from database into the object.

Returns: bool true in case of success, false in case of failure public

Definition at line 245 of file class.ilForumTopic.php.

References read().

     {
         return $this->read();
     }

Here is the call graph for this function:

◆ reopen()

ilForumTopic::reopen ( )

Reopens the current topic.

Returns: bool true in case of success, false in case of failure public

Definition at line 970 of file class.ilForumTopic.php.

References array.

     {
         if ($this->id && $this->is_closed) {
             $this->db->manipulateF(
                 '
                                 UPDATE frm_threads 
                                 SET is_closed = %s
                                 WHERE thr_pk = %s',
                 array('integer', 'integer'),
                 array('0', $this->id)
             );
                                 
             $this->is_closed = 0;
             
             return true;
         }
         
         return false;
     }

◆ setAverageRating()

ilForumTopic::setAverageRating ( $average_rating )

Parameters

int $average_rating

Definition at line 1001 of file class.ilForumTopic.php.

References $average_rating.

Referenced by assignData().

     {
         $this->average_rating = $average_rating;
     }

Here is the caller graph for this function:

◆ setChangeDate()

ilForumTopic::setChangeDate ( $a_changedate )

Definition at line 1054 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         if ($a_changedate == '0000-00-00 00:00:00') {
             $this->changedate = null;
         } else {
             $this->changedate = $a_changedate;
         }
     }

Here is the caller graph for this function:

◆ setClosed()

ilForumTopic::setClosed ( $a_closed )

Definition at line 1102 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         $this->is_closed = $a_closed;
     }

Here is the caller graph for this function:

◆ setCreateDate()

ilForumTopic::setCreateDate ( $a_createdate )

Definition at line 1046 of file class.ilForumTopic.php.

Referenced by assignData(), and ilForum\generateThread().

     {
         $this->createdate = $a_createdate;
     }

Here is the caller graph for this function:

◆ setDisplayUserId()

ilForumTopic::setDisplayUserId ( $a_user_id )

Definition at line 1022 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         $this->display_user_id = $a_user_id;
     }

Here is the caller graph for this function:

◆ setForumId()

ilForumTopic::setForumId ( $a_forum_id )

Definition at line 1014 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         $this->forum_id = $a_forum_id;
     }

Here is the caller graph for this function:

◆ setId()

ilForumTopic::setId ( $a_id )

Definition at line 1006 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         $this->id = $a_id;
     }

Here is the caller graph for this function:

◆ setImportName()

ilForumTopic::setImportName ( $a_import_name )

Definition at line 1066 of file class.ilForumTopic.php.

Referenced by assignData(), and ilForum\generateThread().

     {
         $this->import_name = $a_import_name;
     }

Here is the caller graph for this function:

◆ setLastPostForThreadOverview()

ilForumTopic::setLastPostForThreadOverview ( ilForumPost $post )

Definition at line 1278 of file class.ilForumTopic.php.

References $post.

     {
         $this->last_post = $post;
     }

◆ setLastPostString()

ilForumTopic::setLastPostString ( $a_last_post )

Definition at line 1074 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         if ($a_last_post == '') {
             $a_last_post = null;
         }
         
         $this->last_post_string = $a_last_post;
     }

Here is the caller graph for this function:

◆ setModeratorRight()

ilForumTopic::setModeratorRight ( $bool )

Definition at line 1118 of file class.ilForumTopic.php.

     {
         $this->is_moderator = $bool;
     }

◆ setNumNewPosts()

ilForumTopic::setNumNewPosts ( $num_new_posts )

Parameters

int $num_new_posts

Returns: ilForumTopic

Definition at line 1208 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         $this->num_new_posts = $num_new_posts;
         return $this;
     }

Here is the caller graph for this function:

◆ setNumPosts()

ilForumTopic::setNumPosts ( $a_num_posts )

Parameters

$a_num_posts

Returns: ilForumTopic

Definition at line 1190 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         $this->num_posts = $a_num_posts;
         return $this;
     }

Here is the caller graph for this function:

◆ setNumUnreadPosts()

ilForumTopic::setNumUnreadPosts ( $num_unread_posts )

Parameters

int $num_unread_posts

Returns: ilForumTopic

Definition at line 1226 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         $this->num_unread_posts = $num_unread_posts;
         return $this;
     }

Here is the caller graph for this function:

◆ setOrderDirection()

ilForumTopic::setOrderDirection ( $direction )

Definition at line 1258 of file class.ilForumTopic.php.

     {
         if (!in_array(strtoupper($direction), self::$possibleOrderDirections)) {
             $direction = current(self::$possibleOrderDirections);
         }
         
         $this->orderDirection = $direction;
         return $this;
     }

◆ setOrderField()

ilForumTopic::setOrderField ( $a_order_field )

Definition at line 1110 of file class.ilForumTopic.php.

     {
         $this->orderField = $a_order_field;
     }

◆ setSticky()

ilForumTopic::setSticky ( $a_sticky )

Definition at line 1094 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         $this->is_sticky = $a_sticky;
     }

Here is the caller graph for this function:

◆ setSubject()

ilForumTopic::setSubject ( $a_subject )

Definition at line 1038 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         $this->subject = $a_subject;
     }

Here is the caller graph for this function:

◆ setThrAuthorId()

ilForumTopic::setThrAuthorId ( $thr_author_id )

Parameters

int $thr_author_id

Definition at line 1134 of file class.ilForumTopic.php.

References $thr_author_id.

Referenced by assignData().

     {
         $this->thr_author_id = $thr_author_id;
     }

Here is the caller graph for this function:

◆ setUserAlias()

ilForumTopic::setUserAlias ( $a_user_alias )

Definition at line 1030 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         $this->user_alias = $a_user_alias;
     }

Here is the caller graph for this function:

◆ setUserNotificationEnabled()

ilForumTopic::setUserNotificationEnabled ( $user_notification_enabled )

Parameters

boolean $user_notification_enabled

Returns: ilForumTopic

Definition at line 1244 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         $this->user_notification_enabled = $user_notification_enabled;
         return $this;
     }

Here is the caller graph for this function:

◆ setVisits()

ilForumTopic::setVisits ( $a_visits )

Definition at line 1086 of file class.ilForumTopic.php.

Referenced by assignData().

     {
         $this->visits = $a_visits;
     }

Here is the caller graph for this function:

◆ unmakeSticky()

ilForumTopic::unmakeSticky ( )

Sets the current topic non-sticky.

Returns: bool true in case of success, false in case of failure public

Definition at line 918 of file class.ilForumTopic.php.

References array.

     {
         if ($this->id && $this->is_sticky) {
             $this->db->manipulateF(
                 '
                                 UPDATE frm_threads 
                                 SET is_sticky = %s
                                 WHERE thr_pk = %s',
                 array('integer', 'integer'),
                 array('0', $this->id)
             );
             
             $this->is_sticky = 0;
             
             return true;
         }
         
         return false;
     }

◆ update()

ilForumTopic::update ( )

Updates an existing topic.

Returns: bool true in case of success, false in case of failure public

Definition at line 159 of file class.ilForumTopic.php.

References array, and date.

     {
         if ($this->id) {
             $this->db->manipulateF(
                 '
                                 UPDATE frm_threads
                                 SET thr_top_fk = %s,
                                         thr_subject = %s,
                                         thr_update = %s,
                                         thr_num_posts = %s,
                                         thr_last_post = %s,
                                         avg_rating = %s
                                 WHERE thr_pk = %s',
                 array('integer', 'text','timestamp', 'integer', 'text', 'float', 'integer'),
                 array(  $this->forum_id,
                         $this->subject,
             /*                  $this->changedate, */
                         date('Y-m-d H:i:s'),
                         $this->num_posts,
                         $this->last_post_string,
                         $this->average_rating,
                         $this->id
             )
             );
             
             return true;
         }
         
         return false;
     }

◆ updateMergedThread()

ilForumTopic::updateMergedThread ( )

Definition at line 1303 of file class.ilForumTopic.php.

References array, getId(), getLastPostString(), getNumPosts(), getSubject(), and getVisits().

     {
         $this->db->update(
             'frm_threads',
             array(
                 'thr_num_posts' => array('integer', $this->getNumPosts()),
                 'visits'                => array('integer', $this->getVisits()),
                 'thr_last_post' => array('text', $this->getLastPostString()),
                 'thr_subject'           => array('text', $this->getSubject())
             ),
             array('thr_pk' => array('integer', $this->getId()))
         );
     }

Here is the call graph for this function:

◆ updateThreadTitle()

ilForumTopic::updateThreadTitle ( )

Definition at line 1177 of file class.ilForumTopic.php.

References array, getId(), and getSubject().

     {
         $this->db->update(
             'frm_threads',
             array('thr_subject' => array('text',$this->getSubject())),
             array('thr_pk'=> array('integer', $this->getId()))
         );
     }

Here is the call graph for this function:

◆ updateVisits()

ilForumTopic::updateVisits ( )

Updates the visit counter of the current topic.

public

Definition at line 277 of file class.ilForumTopic.php.

References $_SESSION, $id, array, and time.

     {
         $checkTime = time() - (60 * 60);
         
         if ($_SESSION['frm_visit_frm_threads_' . $this->id] < $checkTime) {
             $_SESSION['frm_visit_frm_threads_' . $this->id] = time();
         
             $this->db->manipulateF(
                 '
                                 UPDATE frm_threads
                                 SET     visits = visits + 1
                                 WHERE thr_pk = %s',
                 array('integer'),
                 array($this->id)
             );
         }
         
         return true;
     }

Field Documentation

◆ $average_rating

ilForumTopic::$average_rating = 0

private

Definition at line 55 of file class.ilForumTopic.php.

Referenced by getAverageRating(), and setAverageRating().

◆ $changedate

ilForumTopic::$changedate = null

private

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

Referenced by getChangeDate().

◆ $createdate

ilForumTopic::$createdate = null

private

Definition at line 26 of file class.ilForumTopic.php.

Referenced by getCreateDate().

◆ $db

ilForumTopic::$db = null

private

Definition at line 46 of file class.ilForumTopic.php.

◆ $display_user_id

ilForumTopic::$display_user_id = 0

private

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

Referenced by getDisplayUserId().

◆ $forum_id

ilForumTopic::$forum_id = 0

private

Definition at line 16 of file class.ilForumTopic.php.

Referenced by getForumId().

◆ $frm_obj_id

ilForumTopic::$frm_obj_id = 0

private

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

Referenced by getFrmObjId().

◆ $id

ilForumTopic::$id = 0

private

Definition at line 14 of file class.ilForumTopic.php.

Referenced by countActivePosts(), getId(), movePosts(), and updateVisits().

◆ $import_name

ilForumTopic::$import_name = ''

private

Definition at line 36 of file class.ilForumTopic.php.

Referenced by getImportName().

◆ $is_closed

ilForumTopic::$is_closed = 0

private

Definition at line 40 of file class.ilForumTopic.php.

◆ $is_moderator

ilForumTopic::$is_moderator = false

private

Definition at line 48 of file class.ilForumTopic.php.

Referenced by getModeratorRight().

◆ $is_sticky

ilForumTopic::$is_sticky = 0

private

Definition at line 38 of file class.ilForumTopic.php.

◆ $last_post

ilForumTopic::$last_post = null

private

Definition at line 44 of file class.ilForumTopic.php.

Referenced by getLastPostForThreadOverview().

◆ $last_post_string

ilForumTopic::$last_post_string = ''

private

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

Referenced by getLastPostString().

◆ $num_posts

ilForumTopic::$num_posts = 0

private

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

Referenced by getNumPosts().

◆ $orderDirection

ilForumTopic::$orderDirection = 'DESC'

private

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

Referenced by getOrderDirection().

◆ $orderField

ilForumTopic::$orderField = ''

private

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

Referenced by getOrderField().

◆ $possibleOrderDirections

ilForumTopic::$possibleOrderDirections = array('ASC', 'DESC')

staticprotected

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

◆ $subject

ilForumTopic::$subject = ''

private

Definition at line 24 of file class.ilForumTopic.php.

Referenced by getSubject().

◆ $thr_author_id

ilForumTopic::$thr_author_id = 0

private

Definition at line 50 of file class.ilForumTopic.php.

Referenced by getThrAuthorId(), and setThrAuthorId().

◆ $user_alias

ilForumTopic::$user_alias = ''

private

Definition at line 22 of file class.ilForumTopic.php.

Referenced by getUserAlias().

◆ $visits

ilForumTopic::$visits = 0

private

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

Referenced by getVisits().

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

Modules/Forum/classes/class.ilForumTopic.php

Public Member Functions

Static Public Member Functions

Static Protected Attributes

Private Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ _lookupDate()

◆ _lookupTitle()

◆ assignData()

◆ close()

◆ countActivePosts()

◆ countPosts()

◆ deleteByThreadId()

◆ disableNotification()

◆ enableNotification()

◆ getAllPosts()

◆ getAverageRating()

◆ getChangeDate()

◆ getCreateDate()

◆ getDisplayUserId()

◆ getFirstPostId()

◆ getFirstPostNode()

◆ getForumId()

◆ getFrmObjId()

◆ getId()

◆ getImportName()

◆ getLastActivePost()

◆ getLastPost()

◆ getLastPostForThreadOverview()

◆ getLastPostString()

◆ getModeratorRight()

◆ getNestedSetPostChildren()

◆ getNumNewPosts()

◆ getNumPosts()

◆ getNumUnreadPosts()

◆ getOrderDirection()

◆ getOrderField()

◆ getPostTree()

◆ getSorting()

◆ getSubject()

◆ getThrAuthorId()

◆ getUserAlias()

◆ getUserNotificationEnabled()

◆ getVisits()

◆ insert()

◆ isClosed()

◆ isNotificationEnabled()

◆ isSticky()

◆ lookupForumIdByTopicId()

◆ makeSticky()

◆ movePosts()

◆ read()

◆ reload()

◆ reopen()

◆ setAverageRating()

◆ setChangeDate()

◆ setClosed()

◆ setCreateDate()

◆ setDisplayUserId()

◆ setForumId()

◆ setId()

◆ setImportName()

◆ setLastPostForThreadOverview()

◆ setLastPostString()

◆ setModeratorRight()

◆ setNumNewPosts()

◆ setNumPosts()

◆ setNumUnreadPosts()

◆ setOrderDirection()

◆ setOrderField()

◆ setSticky()

◆ setSubject()

◆ setThrAuthorId()

◆ setUserAlias()

◆ setUserNotificationEnabled()

◆ setVisits()

◆ unmakeSticky()