Inheritance diagram for ilObjForum:

Collaboration diagram for ilObjForum:

Public Member Functions
	__construct ($a_id=0, $a_call_by_reference=true)
	Constructor public. More...

	create ()

	setPermissions ($a_ref_id)

	updateModeratorRole ($role_id)

	getDiskUsage ()
	Gets the disk usage of the object in bytes. More...

	getCountUnread ($a_usr_id, $a_thread_id=0, $ignoreRoot=false)

	markThreadRead ($a_usr_id, $a_thread_id)

	markAllThreadsRead ($a_usr_id)

	markPostRead ($a_usr_id, $a_thread_id, $a_post_id)

	markPostUnread ($a_user_id, $a_post_id)

	isRead ($a_usr_id, $a_post_id)

	updateLastAccess ($a_usr_id, $a_thread_id)

	update ($a_update_user_id=0)
	update forum data public More...

	cloneAutoGeneratedRoles ($new_obj)
	Clone forum moderator role public. More...

	delete ()
	Delete forum and all related data public. More...

	initDefaultRoles ()
	init default roles settings public More...

	createSettings ()

	saveData ($a_roles=array())

	setThreadSorting ($a_thr_pk, $a_sorting_value)

	getNumStickyThreads ()

Public Member Functions inherited from ilObject
	__construct ($a_id=0, $a_reference=true)
	Constructor public. More...

	withReferences ()
	determines wehter objects are referenced or not (got ref ids or not) More...

	read ()
	read object data from db into object More...

	getId ()
	get object id public More...

	setId ($a_id)
	set object id public More...

	setRefId ($a_id)
	set reference id public More...

	getRefId ()
	get reference id public More...

	getType ()
	get object type public More...

	setType ($a_type)
	set object type public More...

	getPresentationTitle ()
	get presentation title Normally same as title Overwritten for sessions More...

	getTitle ()
	get object title public More...

	getUntranslatedTitle ()
	get untranslated object title public More...

	setTitle ($a_title)
	set object title More...

	getDescription ()
	get object description More...

	setDescription ($a_desc)
	set object description More...

	getLongDescription ()
	get object long description (stored in object_description) More...

	getImportId ()
	get import id More...

	setImportId ($a_import_id)
	set import id More...

	setOfflineStatus ($a_status)
	Set offline status. More...

	getOfflineStatus ()
	Get offline status. More...

	supportsOfflineHandling ()
	Check whether object supports offline handling. More...

	getOwner ()
	get object owner More...

	getOwnerName ()

	setOwner ($a_owner)
	set object owner More...

	getCreateDate ()
	get create date public More...

	getLastUpdateDate ()
	get last update date public More...

	getDiskUsage ()
	Gets the disk usage of the object in bytes. More...

	create ()
	create More...

	update ()
	update object in db More...

	MDUpdateListener ($a_element)
	Meta data update listener. More...

	createMetaData ()
	create meta data entry More...

	updateMetaData ()
	update meta data entry More...

	deleteMetaData ()
	delete meta data entry More...

	updateOwner ()
	update owner of object in db More...

	putInTree ($a_parent_ref)
	maybe this method should be in tree object!? More...

	setPermissions ($a_parent_ref)
	set permissions of object More...

	setParentRolePermissions ($a_parent_ref)
	Initialize the permissions of parent roles (local roles of categories, global roles...) This method is overwritten in e.g courses, groups for building permission intersections with non_member templates. More...

	createReference ()
	creates reference for object More...

	countReferences ()
	count references of object More...

	delete ()
	delete object or referenced object (in the case of a referenced object, object data is only deleted if last reference is deleted) This function removes an object entirely from system!! More...

	initDefaultRoles ()
	init default roles settings Purpose of this function is to create a local role folder and local roles, that are needed depending on the object type If you want to setup default local roles you MUST overwrite this method in derived object classes (see ilObjForum for an example) public More...

	applyDidacticTemplate ($a_tpl_id)
	Apply template. More...

	setRegisterMode ($a_bool)

	isUserRegistered ($a_user_id=0)

	requireRegistration ()

	getXMLZip ()

	getHTMLDirectory ()

	appendCopyInfo ($a_target_id, $a_copy_id)
	Prepend Copy info if object with same name exists in that container. More...

	cloneDependencies ($a_target_id, $a_copy_id)
	Clone object dependencies. More...

	cloneMetaData ($target_obj)
	Copy meta data. More...

	getPossibleSubObjects ($a_filter=true)
	get all possible subobjects of this type the object can decide which types of subobjects are possible jut in time overwrite if the decision distinguish from standard model More...

Static Public Member Functions
static	_lookupThreadSubject ($a_thread_id)

static	_updateOldAccess ($a_usr_id)

static	_deleteUser ($a_usr_id)

static	_deleteReadEntries ($a_post_id)

static	_deleteAccessEntries ($a_thread_id)

static	_lookupModeratorRole ($a_ref_id)
	Lookup moderator role public. More...

static	lookupForumIdByObjId ($obj_id)

static	lookupForumIdByRefId ($ref_id)

static	preloadForumIdsByObjIds (array $obj_ids)

static	preloadForumIdsByRefIds (array $ref_ids)

static	lookupStatisticsByRefId ($ref_id)

static	lookupLastPostByRefId ($ref_id)

static	getUserIdsOfLastPostsByRefIdAndThreadIds ($ref_id, array $thread_ids)

static	mergeForumUserRead ($merge_source_thread_id, $merge_target_thread_id)

Static Public Member Functions inherited from ilObject
static	_lookupObjIdByImportId ($a_import_id)

static	_lookupImportId ($a_obj_id)

static	_lookupOwnerName ($a_owner_id)
	lookup owner name for owner id More...

static	_getIdForImportId ($a_import_id)
	get current object id for import id (static) More...

static	_getAllReferences ($a_id)
	get all reference ids of object More...

static	_lookupTitle ($a_id)
	lookup object title More...

static	lookupOfflineStatus ($a_obj_id)
	Lookup offline status using objectDataCache. More...

static	_lookupOwner ($a_id)
	lookup object owner More...

static	_getIdsForTitle ($title, $type='', $partialmatch=false)

static	_lookupDescription ($a_id)
	lookup object description More...

static	_lookupLastUpdate ($a_id, $a_as_string=false)
	lookup last update More...

static	_getLastUpdateOfObjects ($a_objs)
	Get last update for a set of media objects. More...

static	_lookupObjId ($a_id)

static	_setDeletedDate ($a_ref_id, $a_deleted_by)

static	setDeletedDates ($a_ref_ids, $a_user_id)
	Set deleted date. More...

static	_resetDeletedDate ($a_ref_id)
	only called in ilObjectGUI::insertSavedNodes More...

static	_lookupDeletedDate ($a_ref_id)
	only called in ilObjectGUI::insertSavedNodes More...

static	_writeTitle ($a_obj_id, $a_title)
	write title to db (static) More...

static	_writeDescription ($a_obj_id, $a_desc)
	write description to db (static) More...

static	_writeImportId ($a_obj_id, $a_import_id)
	write import id to db (static) More...

static	_lookupType ($a_id, $a_reference=false)
	lookup object type More...

static	_isInTrash ($a_ref_id)
	checks wether object is in trash More...

static	_hasUntrashedReference ($a_obj_id)
	checks wether an object has at least one reference that is not in trash More...

static	_lookupObjectId ($a_ref_id)
	lookup object id More...

static	_getObjectsDataForType ($a_type, $a_omit_trash=false)
	get all objects of a certain type More...

static	_exists ($a_id, $a_reference=false, $a_type=null)
	checks if an object exists in object_data More...

static	_getObjectsByType ($a_obj_type="", $a_owner="")
	Get objects by type. More...

static	_prepareCloneSelection ($a_ref_ids, $new_type, $show_path=true)
	Prepare copy wizard object selection. More...

static	_getIcon ( $a_obj_id="", $a_size="big", $a_type="", $a_offline=false)
	Get icon for repository item. More...

static	collectDeletionDependencies (&$deps, $a_ref_id, $a_obj_id, $a_type, $a_depth=0)
	Collect deletion dependencies. More...

static	getDeletionDependencies ($a_obj_id)
	Get deletion dependencies. More...

static	getLongDescriptions (array $a_obj_ids)
	Get long description data. More...

static	getAllOwnedRepositoryObjects ($a_user_id)
	Get all ids of objects user owns. More...

static	fixMissingTitles ($a_type, array &$a_obj_title_map)
	Try to fix missing object titles. More...

static	_lookupCreationDate ($a_id)
	Lookup creation date. More...

static	hasAutoRating ($a_type, $a_ref_id)
	Check if auto rating is active for parent group/course. More...

Data Fields
	$Forum

Data Fields inherited from ilObject
const	TITLE_LENGTH = 255
	max length of object title More...

const	DESC_LENGTH = 128

	$lng

	$id

	$ref_id

	$type

	$title

	$untranslatedTitle

	$desc

	$long_desc

	$owner

	$create_date

	$last_update

	$import_id

	$register = false

	$referenced

	$objectList

	$max_title

	$max_desc

	$add_dots

Static Protected Attributes
static	$obj_id_to_forum_id_cache = array()

static	$ref_id_to_forum_id_cache = array()

static	$forum_statistics_cache = array()

static	$forum_last_post_cache = array()

Private Member Functions
	deleteDraftsByForumId ($forum_id)

Private Attributes
	$settings

	$rbac

	$ilBench

	$user

	$logger

Additional Inherited Members
Protected Attributes inherited from ilObject
	$objDefinition

	$db

	$log

	$error

	$tree

	$app_event_handler

	$rbacadmin

	$rbacreview

Detailed Description

Class ilObjForum.

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

Version: $Id$

Definition at line 13 of file class.ilObjForum.php.

Constructor & Destructor Documentation

◆ __construct()

ilObjForum::__construct	(	$a_id = `0`,
		$a_call_by_reference = `true`
	)

Constructor public.

Parameters

integer	$a_id	reference_id or object_id
boolean	$a_call_by_reference	treat the id as reference_id (true) or object_id (false)

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

References $DIC, ILIAS\GlobalScreen\Provider\__construct(), settings(), and user().

     {
         global $DIC;
         $this->settings = $DIC->settings();
         $this->rbac = $DIC->rbac();
         $this->db = $DIC->database();
         $this->ilBench = $DIC['ilBench'];
         $this->user = $DIC->user();
         $this->logger = $DIC->logger()->root();
         
         $this->type = 'frm';
         parent::__construct($a_id, $a_call_by_reference);
 
         /*
          * this constant is used for the information if a single post is marked as new
          * All threads/posts created before this date are never marked as new
          * Default is 8 weeks
          *
          */
         $new_deadline = time() - 60 * 60 * 24 * 7 * ($this->settings->get('frm_store_new') ?
             $this->settings->get('frm_store_new') :
             8);
         define('NEW_DEADLINE', $new_deadline);
 
         // TODO: needs to rewrite scripts that are using Forum outside this class
         $this->Forum = new ilForum();
     }

Here is the call graph for this function:

Member Function Documentation

◆ _deleteAccessEntries()

static ilObjForum::_deleteAccessEntries ( $a_thread_id )

static

Definition at line 463 of file class.ilObjForum.php.

References $DIC, and $ilDB.

Referenced by ilForum\deletePost(), and ilForum\mergeThreads().

     {
         global $DIC;
         $ilDB = $DIC->database();
         $ilDB->manipulateF(
             '
                         DELETE FROM frm_thread_access WHERE thread_id = %s',
             array('integer'),
             array($a_thread_id)
         );
 
         return true;
     }

Here is the caller graph for this function:

◆ _deleteReadEntries()

static ilObjForum::_deleteReadEntries ( $a_post_id )

static

Definition at line 448 of file class.ilObjForum.php.

References $DIC, and $ilDB.

Referenced by ilForum\deletePost().

     {
         global $DIC;
         $ilDB = $DIC->database();
 
         $ilDB->manipulateF(
             '
                         DELETE FROM frm_user_read WHERE post_id = %s',
             array('integer'),
             array($a_post_id)
         );
 
         return true;
     }

Here is the caller graph for this function:

◆ _deleteUser()

static ilObjForum::_deleteUser ( $a_usr_id )

static

Definition at line 415 of file class.ilObjForum.php.

References $data, $DIC, and $ilDB.

Referenced by ilObjUser\delete().

     {
         global $DIC;
         $ilDB = $DIC->database();
 
         $data = array($a_usr_id);
 
         $ilDB->manipulateF(
             '
                         DELETE FROM frm_user_read WHERE usr_id = %s',
             array('integer'),
             $data
         );
 
         $ilDB->manipulateF(
             '
                         DELETE FROM frm_thread_access WHERE usr_id = %s',
             array('integer'),
             $data
         );
 
         // delete notifications of deleted user
         $ilDB->manipulateF(
             '
                         DELETE FROM frm_notification WHERE user_id = %s',
             array('integer'),
             $data
         );
 
         return true;
     }

Here is the caller graph for this function:

◆ _lookupModeratorRole()

static ilObjForum::_lookupModeratorRole ( $a_ref_id )

static

Lookup moderator role public.

Parameters

int $a_ref_id ref_id of forum

Definition at line 766 of file class.ilObjForum.php.

References $DIC, $ilDB, and $res.

Referenced by cloneAutoGeneratedRoles(), and setPermissions().

     {
         global $DIC;
         $ilDB = $DIC->database();
 
         $mod_title = 'il_frm_moderator_' . $a_ref_id;
 
         $res = $ilDB->queryf(
             '
                         SELECT * FROM object_data WHERE title = %s',
             array('text'),
             array($mod_title)
         );
 
         while ($row = $ilDB->fetchObject($res)) {
             return $row->obj_id;
         }
         return 0;
     }

Here is the caller graph for this function:

◆ _lookupThreadSubject()

static ilObjForum::_lookupThreadSubject ( $a_thread_id )

static

Definition at line 141 of file class.ilObjForum.php.

References $DIC, $ilDB, and $res.

Referenced by ilObjForumSubItemListGUI\getHTML().

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

Here is the caller graph for this function:

◆ _updateOldAccess()

static ilObjForum::_updateOldAccess ( $a_usr_id )

static

Parameters

int

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

References $DIC, and $ilDB.

Referenced by ilAuthFrontend\handleAuthenticationSuccess().

     {
         global $DIC;
         $ilDB = $DIC->database();
 
         $ilDB->manipulateF(
             '
                         UPDATE frm_thread_access 
                         SET access_old = access_last
                         WHERE usr_id = %s',
             array('integer'),
             array($a_usr_id)
         );
 
         $set = $ilDB->query(
             "SELECT * FROM frm_thread_access " .
                 " WHERE usr_id = " . $ilDB->quote($a_usr_id, "integer")
         );
         while ($rec = $ilDB->fetchAssoc($set)) {
             $ilDB->manipulate(
                 "UPDATE frm_thread_access SET " .
                     " access_old_ts = " . $ilDB->quote(date('Y-m-d H:i:s', $rec["access_old"]), "timestamp") .
                     " WHERE usr_id = " . $ilDB->quote($rec["usr_id"], "integer") .
                     " AND obj_id = " . $ilDB->quote($rec["obj_id"], "integer") .
                     " AND thread_id = " . $ilDB->quote($rec["thread_id"], "integer")
             );
         }
 
         $new_deadline = time() - 60 * 60 * 24 * 7 * ($DIC->settings()->get('frm_store_new') ?
             $DIC->settings()->get('frm_store_new') :
             8);
 
         $ilDB->manipulateF(
             '
                         DELETE FROM frm_thread_access WHERE access_last < %s',
             array('integer'),
             array($new_deadline)
         );
     }

Here is the caller graph for this function:

◆ cloneAutoGeneratedRoles()

ilObjForum::cloneAutoGeneratedRoles ( $new_obj )

Clone forum moderator role public.

Parameters

object $new_obj forum object

Definition at line 616 of file class.ilObjForum.php.

References _lookupModeratorRole(), ilObject\getOwner(), and ilObject\getRefId().

Referenced by update().

     {
         $moderator = ilObjForum::_lookupModeratorRole($this->getRefId());
         $new_moderator = ilObjForum::_lookupModeratorRole($new_obj->getRefId());
 
         if (!$moderator || !$new_moderator || !$this->getRefId() || !$new_obj->getRefId()) {
             $this->logger->write(__METHOD__ . ' : Error cloning auto generated role: il_frm_moderator');
         }
         $this->rbac->admin()->copyRolePermissions($moderator, $this->getRefId(), $new_obj->getRefId(), $new_moderator, true);
         $this->logger->write(__METHOD__ . ' : Finished copying of role il_frm_moderator.');
 
         $obj_mods = new ilForumModerators($this->getRefId());
 
         $old_mods = $obj_mods->getCurrentModerators();
         foreach ($old_mods as $user_id) {
             // The object owner is already member of the moderator role when this method is called
             // Since the new static caches are introduced with ILIAS 5.0, a database error occurs if we try to assign the user here.
             if ($this->getOwner() != $user_id) {
                 $this->rbac->admin()->assignUser($new_moderator, $user_id);
             }
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ create()

ilObjForum::create ( )

Returns: int

Definition at line 91 of file class.ilObjForum.php.

References ilObject\$id, createSettings(), ilObject\getId(), ilForumProperties\getInstance(), saveData(), and ilForumProperties\VIEW_DATE_ASC.

     {
         $id = parent::create();
 
         $properties = ilForumProperties::getInstance($this->getId());
         $properties->setDefaultView(ilForumProperties::VIEW_DATE_ASC);
         $properties->setAnonymisation(0);
         $properties->setStatisticsStatus(0);
         $properties->setPostActivation(0);
         $properties->setThreadSorting(0);
         $properties->insert();
 
         $this->createSettings();
 
         $this->saveData();
 
         return $id;
     }

Here is the call graph for this function:

◆ createSettings()

ilObjForum::createSettings ( )

Definition at line 787 of file class.ilObjForum.php.

References $_GET, ilNewsItem\_getDefaultVisibilityForRefId(), ilBlockSetting\_write(), and ilObject\getId().

Referenced by create().

     {
         // news settings (public notifications yes/no)
         $default_visibility = ilNewsItem::_getDefaultVisibilityForRefId($_GET["ref_id"]);
         if ($default_visibility == "public") {
             ilBlockSetting::_write("news", "public_notifications", 1, 0, $this->getId());
         }
 
         return true;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ delete()

ilObjForum::delete ( )

Delete forum and all related data public.

Returns: boolean true if all object data were removed; false if only a references were removed

Definition at line 644 of file class.ilObjForum.php.

References deleteDraftsByForumId(), and ilObject\getId().

     {
         // always call parent delete function first!!
         if (!parent::delete()) {
             return false;
         }
 
         // delete attachments
         $tmp_file_obj = new ilFileDataForum($this->getId());
         $tmp_file_obj->delete();
         unset($tmp_file_obj);
 
         $this->Forum->setMDB2WhereCondition('top_frm_fk = %s ', array('integer'), array($this->getId()));
 
         $topData = $this->Forum->getOneTopic();
 
         $threads = $this->Forum->getAllThreads($topData['top_pk']);
         foreach ($threads['items'] as $thread) {
             $thread_ids_to_delete[$thread->getId()] = $thread->getId();
         }
         
         // delete tree
         $this->db->manipulate('DELETE FROM frm_posts_tree WHERE ' . $this->db->in('thr_fk', $thread_ids_to_delete, false, 'integer'));
         
         // delete posts
         $this->db->manipulate('DELETE FROM frm_posts WHERE ' . $this->db->in('pos_thr_fk', $thread_ids_to_delete, false, 'integer'));
     
         // delete threads
         $this->db->manipulate('DELETE FROM frm_threads WHERE ' . $this->db->in('thr_pk', $thread_ids_to_delete, false, 'integer'));
         
         $obj_id = array($this->getId());
         // delete forum
         $this->db->manipulateF(
             'DELETE FROM frm_data WHERE top_frm_fk = %s',
             array('integer'),
             $obj_id
         );
 
         // delete settings
         $this->db->manipulateF(
             'DELETE FROM frm_settings WHERE obj_id = %s',
             array('integer'),
             $obj_id
         );
 
         // delete read infos
         $this->db->manipulateF(
             'DELETE FROM frm_user_read WHERE obj_id = %s',
             array('integer'),
             $obj_id
         );
 
         // delete thread access entries
         $this->db->manipulateF(
             'DELETE FROM frm_thread_access WHERE obj_id = %s',
             array('integer'),
             $obj_id
         );
 
         //delete thread notifications
         $this->db->manipulate('DELETE FROM frm_notification WHERE ' . $this->db->in('thread_id', $thread_ids_to_delete, false, 'integer'));
         
         //delete forum notifications
         $this->db->manipulateF('DELETE FROM frm_notification WHERE  frm_id = %s', array('integer'), $obj_id);
         
         // delete posts_deleted entries
         $this->db->manipulateF('DELETE FROM frm_posts_deleted WHERE obj_id = %s', array('integer'), $obj_id);
         
         //delete drafts
         $this->deleteDraftsByForumId((int) $topData['top_pk']);
             
         return true;
     }

Here is the call graph for this function:

◆ deleteDraftsByForumId()

ilObjForum::deleteDraftsByForumId ( $forum_id )

private

Parameters

int $forum_id

Definition at line 721 of file class.ilObjForum.php.

References $res.

Referenced by delete().

     {
         $res = $this->db->queryF(
             'SELECT draft_id FROM frm_posts_drafts WHERE forum_id = %s',
             array('integer'),
             array((int) $forum_id)
         );
         
         $draft_ids = array();
         while ($row = $this->db->fetchAssoc($res)) {
             $draft_ids[] = $row['draft_id'];
         }
 
         if (count($draft_ids) > 0) {
             $historyObj = new ilForumDraftsHistory();
             $historyObj->deleteHistoryByDraftIds($draft_ids);
             
             $draftObj = new ilForumPostDraft();
             $draftObj->deleteDraftsByDraftIds($draft_ids);
         }
     }

Here is the caller graph for this function:

◆ getCountUnread()

ilObjForum::getCountUnread	(	$a_usr_id,
		$a_thread_id = `0`,
		$ignoreRoot = `false`
	)

Definition at line 160 of file class.ilObjForum.php.

References $res, and ilObject\getId().

     {
         $a_frm_id = $this->getId();
 
         $this->ilBench->start("Forum", 'getCountRead');
         if (!$a_thread_id) {
             // Get topic_id
             $res = $this->db->queryf(
                 '
                                 SELECT top_pk FROM frm_data WHERE top_frm_fk = %s',
                 array('integer'),
                 array($a_frm_id)
             );
 
 
             while ($row = $this->db->fetchObject($res)) {
                 $topic_id = $row->top_pk;
             }
 
             // Get number of posts
             $res = $this->db->queryf(
                 '
                                 SELECT COUNT(pos_pk) num_posts
                                 FROM frm_posts 
                                 LEFT JOIN frm_posts_tree ON frm_posts_tree.pos_fk = pos_pk
                                 WHERE pos_top_fk = %s' . ($ignoreRoot ? ' AND parent_pos != 0 ' : ''),
                 array('integer'),
                 array($topic_id)
             );
 
             while ($row = $this->db->fetchObject($res)) {
                 $num_posts = $row->num_posts;
             }
 
             $res = $this->db->queryf(
                 '
                                 SELECT COUNT(post_id) count_read FROM frm_user_read
                                 WHERE obj_id = %s
                                 AND usr_id = %s',
                 array('integer', 'integer'),
                 array($a_frm_id, $a_usr_id)
             );
 
             while ($row = $this->db->fetchObject($res)) {
                 $count_read = $row->count_read;
             }
             $unread = $num_posts - $count_read;
 
             $this->ilBench->stop("Forum", 'getCountRead');
             return $unread > 0 ? $unread : 0;
         } else {
             $res = $this->db->queryf(
                 '
                                 SELECT COUNT(pos_pk) num_posts FROM frm_posts
                                 LEFT JOIN frm_posts_tree ON frm_posts_tree.pos_fk = pos_pk
                                 WHERE pos_thr_fk = %s' . ($ignoreRoot ? ' AND parent_pos != 0 ' : ''),
                 array('integer'),
                 array($a_thread_id)
             );
 
             $row = $this->db->fetchObject($res);
             $num_posts = $row->num_posts;
 
             $res = $this->db->queryf(
                 '
                                 SELECT COUNT(post_id) count_read FROM frm_user_read 
                                 WHERE obj_id = %s
                                 AND usr_id = %s
                                 AND thread_id = %s',
                 array('integer', 'integer', 'integer'),
                 array($a_frm_id, $a_frm_id, $a_thread_id)
             );
 
             $row = $this->db->fetchObject($res);
             $count_read = $row->count_read;
 
             $unread = $num_posts - $count_read;
 
             $this->ilBench->stop("Forum", 'getCountRead');
             return $unread > 0 ? $unread : 0;
         }
         $this->ilBench->stop("Forum", 'getCountRead');
         return false;
     }

Here is the call graph for this function:

◆ getDiskUsage()

ilObjForum::getDiskUsage ( )

Gets the disk usage of the object in bytes.

public

Returns: integer the disk usage in bytes

Definition at line 136 of file class.ilObjForum.php.

References ilObjForumAccess\_lookupDiskUsage().

     {
         return ilObjForumAccess::_lookupDiskUsage($this->id);
     }

Here is the call graph for this function:

◆ getNumStickyThreads()

ilObjForum::getNumStickyThreads ( )

Definition at line 1207 of file class.ilObjForum.php.

References $res.

                                           : int
     {
         $res = $this->db->query(
             'SELECT COUNT(is_sticky) num_sticky FROM frm_threads
             INNER JOIN frm_data ON top_pk = thr_top_fk
             WHERE frm_data.top_frm_fk = ' . $this->db->quote($this->getId(), 'integer') . '
             AND is_sticky = ' . $this->db->quote(1, 'integer')
         );
         if ($row = $this->db->fetchAssoc($res)) {
             return (int) $row['num_sticky'];
         }
         return 0;
     }

◆ getUserIdsOfLastPostsByRefIdAndThreadIds()

static ilObjForum::getUserIdsOfLastPostsByRefIdAndThreadIds	(		$ref_id,
		array	$thread_ids
	)

static

Parameters

int	$ref_id
array	$thread_ids

Returns: array

Definition at line 1148 of file class.ilObjForum.php.

References $DIC, $ilDB, $ilUser, $in, $query, ilObject\$ref_id, and $res.

Referenced by ilForumTopicTableGUI\numericOrdering().

     {
         global $DIC;
         $ilAccess = $DIC->access();
         $ilUser = $DIC->user();
         $ilDB = $DIC->database();
 
         $act_clause = '';
         $act_inner_clause = '';
         if (!$ilAccess->checkAccess('moderate_frm', '', $ref_id)) {
             $act_clause .= " AND (t1.pos_status = " . $ilDB->quote(1, "integer") . " OR t1.pos_author_id = " . $ilDB->quote($ilUser->getId(), "integer") . ") ";
             $act_inner_clause .= " AND (t3.pos_status = " . $ilDB->quote(1, "integer") . " OR t3.pos_author_id = " . $ilDB->quote($ilUser->getId(), "integer") . ") ";
         }
 
         $in = $ilDB->in("t1.pos_thr_fk", $thread_ids, false, 'integer');
         $inner_in = $ilDB->in("t3.pos_thr_fk", $thread_ids, false, 'integer');
  
         $query = "
                         SELECT t1.pos_display_user_id, t1.update_user
                         FROM frm_posts t1
                         INNER JOIN frm_posts_tree tree1 ON tree1.pos_fk = t1.pos_pk AND tree1.parent_pos != 0 
                         INNER JOIN (
                                 SELECT t3.pos_thr_fk, MAX(t3.pos_date) pos_date
                                 FROM frm_posts t3
                                 INNER JOIN frm_posts_tree tree2 ON tree2.pos_fk = t3.pos_pk AND tree2.parent_pos != 0 
                                 WHERE $inner_in $act_inner_clause
                                 GROUP BY t3.pos_thr_fk
                         ) t2 ON t2.pos_thr_fk = t1.pos_thr_fk AND t2.pos_date = t1.pos_date
                         WHERE $in $act_clause
                         GROUP BY t1.pos_thr_fk, t1.pos_display_user_id, t1.update_user
                 ";
         $usr_ids = array();
 
         $res = $ilDB->query($query);
         while ($row = $ilDB->fetchAssoc($res)) {
             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'];
             }
         }
 
         return array_unique($usr_ids);
     }

Here is the caller graph for this function:

◆ initDefaultRoles()

ilObjForum::initDefaultRoles ( )

init default roles settings public

Returns: array object IDs of created local roles.

Definition at line 748 of file class.ilObjForum.php.

References ilObjRole\createDefaultRole(), ilObject\getId(), and ilObject\getRefId().

     {
         $role = ilObjRole::createDefaultRole(
             'il_frm_moderator_' . $this->getRefId(),
             "Moderator of forum obj_no." . $this->getId(),
             'il_frm_moderator',
             $this->getRefId()
         );
         return array();
     }

Here is the call graph for this function:

◆ isRead()

ilObjForum::isRead	(	$a_usr_id,
		$a_post_id
	)

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

References $res.

     {
         $res = $this->db->queryf(
             '
                         SELECT * FROM frm_user_read
                         WHERE usr_id = %s
                         AND post_id = %s',
             array('integer', 'integer'),
             array($a_usr_id, $a_post_id)
         );
 
         return $this->db->numRows($res) ? true : false;
     }

◆ lookupForumIdByObjId()

static ilObjForum::lookupForumIdByObjId ( $obj_id )

static

Parameters

int $obj_id

Returns: int

Definition at line 861 of file class.ilObjForum.php.

Referenced by ilForumExportGUI\ensureThreadBelongsToForum(), ilObjForumGUI\ensureThreadBelongsToForum(), and ilObjForumGUI\getContent().

     {
         if (array_key_exists($obj_id, self::$obj_id_to_forum_id_cache)) {
             return (int) self::$obj_id_to_forum_id_cache[$obj_id];
         }
 
         self::preloadForumIdsByObjIds(array($obj_id));
 
         return (int) self::$obj_id_to_forum_id_cache[$obj_id];
     }

Here is the caller graph for this function:

◆ lookupForumIdByRefId()

static ilObjForum::lookupForumIdByRefId ( $ref_id )

static

Parameters

int $ref_id

Returns: int

Definition at line 877 of file class.ilObjForum.php.

References ilObject\$ref_id.

Referenced by ilObjForumGUI\autosaveDraftAsyncObject(), ilObjForumGUI\autosaveThreadDraftAsyncObject(), ilForumPostDraft\getDraftsStatisticsByRefId(), and ilForumPostDraft\moveDraftsByMovedThread().

     {
         if (array_key_exists($ref_id, self::$ref_id_to_forum_id_cache)) {
             return (int) self::$ref_id_to_forum_id_cache[$ref_id];
         }
 
         self::preloadForumIdsByRefIds(array($ref_id));
 
         return (int) self::$ref_id_to_forum_id_cache[$ref_id];
     }

Here is the caller graph for this function:

◆ lookupLastPostByRefId()

static ilObjForum::lookupLastPostByRefId ( $ref_id )

static

Parameters

int $ref_id

Returns: array

Definition at line 1097 of file class.ilObjForum.php.

References $data, $DIC, $ilDB, $ilUser, $query, ilObject\$ref_id, and $res.

Referenced by ilObjForumAccess\getLastPostByRefId().

     {
         global $DIC;
         $ilAccess = $DIC->access();
         $ilUser = $DIC->user();
         $ilDB = $DIC->database();
         
         if (isset(self::$forum_last_post_cache[$ref_id])) {
             return self::$forum_last_post_cache[$ref_id];
         }
 
         $forumId = self::lookupForumIdByRefId($ref_id);
         if (!$forumId) {
             self::$forum_last_post_cache[$ref_id] = array();
             return self::$forum_last_post_cache[$ref_id];
         }
 
         $act_clause = '';
         if (!$ilAccess->checkAccess('moderate_frm', '', $ref_id)) {
             $act_clause .= " AND (frm_posts.pos_status = " . $ilDB->quote(1, "integer") . " OR frm_posts.pos_author_id = " . $ilDB->quote($ilUser->getId(), "integer") . ") ";
         }
 
         $ilDB->setLimit(1, 0);
         $query = "
                         SELECT *
                         FROM frm_posts 
                         INNER JOIN frm_posts_tree tree1
                                         ON tree1.pos_fk = frm_posts.pos_pk
                                         AND tree1.parent_pos != 0
                         WHERE pos_top_fk = %s $act_clause
                         ORDER BY pos_date DESC
                 ";
         $res = $ilDB->queryF(
             $query,
             array('integer'),
             array($forumId)
         );
 
         $data = $ilDB->fetchAssoc($res);
 
         self::$forum_last_post_cache[$ref_id] = is_array($data) ? $data : array();
 
         return self::$forum_last_post_cache[$ref_id];
     }

Here is the caller graph for this function:

◆ lookupStatisticsByRefId()

static ilObjForum::lookupStatisticsByRefId ( $ref_id )

static

Parameters

int $ref_id

Returns: array

Definition at line 959 of file class.ilObjForum.php.

References $DIC, $i, $ilDB, $ilSetting, $ilUser, $query, ilObject\$ref_id, $res, ilObject\_lookupObjectId(), ilForumProperties\FORUM_OVERVIEW_WITH_NEW_POSTS, and ilForumProperties\getInstance().

Referenced by ilObjForumAccess\getStatisticsByRefId().

     {
         global $DIC;
         $ilAccess = $DIC->access();
         $ilUser = $DIC->user();
         $ilDB = $DIC->database();
         $ilSetting = $DIC->settings();
 
         if (isset(self::$forum_statistics_cache[$ref_id])) {
             return self::$forum_statistics_cache[$ref_id];
         }
 
         $statistics = array(
             'num_posts' => 0,
             'num_unread_posts' => 0,
             'num_new_posts' => 0
         );
 
         $forumId = self::lookupForumIdByRefId($ref_id);
         if (!$forumId) {
             self::$forum_statistics_cache[$ref_id] = $statistics;
             return self::$forum_statistics_cache[$ref_id];
         }
         
         $objProperties = ilForumProperties::getInstance(ilObject::_lookupObjectId($ref_id));
         $is_post_activation_enabled = $objProperties->isPostActivationEnabled();
 
         $act_clause = '';
 
         if ($is_post_activation_enabled && !$ilAccess->checkAccess('moderate_frm', '', $ref_id)) {
             $act_clause .= " AND (frm_posts.pos_status = " . $ilDB->quote(1, "integer") . " OR frm_posts.pos_author_id = " . $ilDB->quote($ilUser->getId(), "integer") . ") ";
         }
 
         $new_deadline = date('Y-m-d H:i:s', time() - 60 * 60 * 24 * 7 * ($ilSetting->get('frm_store_new') ? $ilSetting->get('frm_store_new') : 8));
 
         if (!$ilUser->isAnonymous()) {
             $query = "
                                 (SELECT COUNT(frm_posts.pos_pk) cnt
                                 FROM frm_posts
                                 INNER JOIN frm_posts_tree tree1
                                         ON tree1.pos_fk = frm_posts.pos_pk
                                         AND tree1.parent_pos != 0
                                 INNER JOIN frm_threads ON frm_posts.pos_thr_fk = frm_threads.thr_pk 
                                 WHERE frm_threads.thr_top_fk = %s $act_clause)
                                 
                                 UNION ALL
                                  
                                 (SELECT COUNT(DISTINCT(frm_user_read.post_id)) cnt
                                 FROM frm_user_read
                                 INNER JOIN frm_posts ON frm_user_read.post_id = frm_posts.pos_pk
                                 INNER JOIN frm_posts_tree tree1
                                         ON tree1.pos_fk = frm_posts.pos_pk
                                         AND tree1.parent_pos != 0
                                 INNER JOIN frm_threads ON frm_threads.thr_pk = frm_posts.pos_thr_fk 
                                 WHERE frm_user_read.usr_id = %s AND frm_posts.pos_top_fk = %s $act_clause)
                         ";
 
             $types = array('integer', 'integer', 'integer');
             $values = array($forumId, $ilUser->getId(), $forumId);
 
             $forum_overview_setting = (int) $ilSetting::_lookupValue('frma', 'forum_overview');
             if ($forum_overview_setting == ilForumProperties::FORUM_OVERVIEW_WITH_NEW_POSTS) {
                 $news_types = array('integer', 'integer', 'integer', 'timestamp', 'integer');
                 $news_values = array($ilUser->getId(), $ilUser->getId(), $forumId,  $new_deadline, $ilUser->getId());
 
                 $query .= " 
                                 UNION ALL
                                 
                                 (SELECT COUNT(frm_posts.pos_pk) cnt
                                 FROM frm_posts
                                 INNER JOIN frm_posts_tree tree1
                                         ON tree1.pos_fk = frm_posts.pos_pk
                                         AND tree1.parent_pos != 0
                                 LEFT JOIN frm_user_read ON (post_id = frm_posts.pos_pk AND frm_user_read.usr_id = %s)
                                 LEFT JOIN frm_thread_access ON (frm_thread_access.thread_id = frm_posts.pos_thr_fk AND frm_thread_access.usr_id = %s)
                                 WHERE frm_posts.pos_top_fk = %s
                                 AND ( (frm_posts.pos_update > frm_thread_access.access_old_ts)
                                                 OR (frm_thread_access.access_old IS NULL AND frm_posts.pos_update > %s)
                                         )
                                 AND frm_posts.pos_author_id != %s 
                                 AND frm_user_read.usr_id IS NULL $act_clause)";
                 
                 $types = array_merge($types, $news_types);
                 $values = array_merge($values, $news_values);
             }
             
             $mapping = array_keys($statistics);
             $res = $ilDB->queryF(
                 $query,
                 $types,
                 $values
             );
             for ($i = 0; $i <= 2; $i++) {
                 $row = $ilDB->fetchAssoc($res);
 
                 $statistics[$mapping[$i]] = (int) ((is_array($row) ? $row['cnt'] : 0));
 
                 if ($i == 1) {
                     // unread = all - read
                     $statistics[$mapping[$i]] = $statistics[$mapping[$i - 1]] - $statistics[$mapping[$i]];
                 }
             }
         } else {
             $query = "
                                 SELECT COUNT(frm_posts.pos_pk) cnt
                                 FROM frm_posts
                                 INNER JOIN frm_posts_tree tree1
                                         ON tree1.pos_fk = frm_posts.pos_pk
                                         AND tree1.parent_pos != 0
                                 INNER JOIN frm_threads ON frm_posts.pos_thr_fk = frm_threads.thr_pk 
                                 WHERE frm_threads.thr_top_fk = %s $act_clause
                         ";
             $types = array('integer');
             $values = array($forumId);
             $res = $ilDB->queryF(
                 $query,
                 $types,
                 $values
             );
             $row = $ilDB->fetchAssoc($res);
 
             $statistics = array(
                 'num_posts' => $row['cnt'],
                 'num_unread_posts' => $row['cnt'],
                 'num_new_posts' => $row['cnt']
             );
         }
 
         self::$forum_statistics_cache[$ref_id] = $statistics;
 
         return self::$forum_statistics_cache[$ref_id];
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ markAllThreadsRead()

ilObjForum::markAllThreadsRead ( $a_usr_id )

Definition at line 262 of file class.ilObjForum.php.

References $res, ilObject\getId(), and markThreadRead().

     {
         $res = $this->db->queryf(
             '
                         SELECT * FROM frm_data, frm_threads 
                         WHERE top_frm_fk = %s
                         AND top_pk = thr_top_fk',
             array('integer'),
             array($this->getId())
         );
 
         while ($row = $this->db->fetchObject($res)) {
             $this->markThreadRead($a_usr_id, $row->thr_pk);
         }
 
         return true;
     }

Here is the call graph for this function:

◆ markPostRead()

ilObjForum::markPostRead	(	$a_usr_id,
		$a_thread_id,
		$a_post_id
	)

Definition at line 281 of file class.ilObjForum.php.

References $res, and ilObject\getId().

Referenced by markThreadRead().

     {
         // CHECK IF ENTRY EXISTS
         $res = $this->db->queryf(
             '
                         SELECT * FROM frm_user_read 
                         WHERE usr_id = %s
                         AND obj_id = %s
                         AND thread_id = %s
                         AND post_id = %s',
             array('integer', 'integer', 'integer', 'integer'),
             array($a_usr_id, $this->getId(), $a_thread_id, $a_post_id)
         );
 
         if ($this->db->numRows($res)) {
             return true;
         }
 
         $this->db->manipulateF(
             '
                         INSERT INTO frm_user_read
                         (       usr_id,
                                 obj_id,
                                 thread_id,
                                 post_id
                         )
                         VALUES (%s,%s,%s,%s)',
             array('integer', 'integer', 'integer', 'integer'),
             array($a_usr_id, $this->getId(), $a_thread_id, $a_post_id)
         );
 
         return true;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ markPostUnread()

ilObjForum::markPostUnread	(	$a_user_id,
		$a_post_id
	)

Definition at line 315 of file class.ilObjForum.php.

     {
         $this->db->manipulateF(
             '
                         DELETE FROM frm_user_read
                         WHERE usr_id = %s
                         AND post_id = %s',
             array('integer', 'integer'),
             array($a_user_id, $a_post_id)
         );
     }

◆ markThreadRead()

ilObjForum::markThreadRead	(	$a_usr_id,
		$a_thread_id
	)

Definition at line 246 of file class.ilObjForum.php.

References $res, and markPostRead().

Referenced by markAllThreadsRead().

     {
         // Get all post ids
         $res = $this->db->queryf(
             '
                         SELECT * FROM frm_posts WHERE pos_thr_fk = %s',
             array('integer'),
             array($a_thread_id)
         );
 
         while ($row = $this->db->fetchObject($res)) {
             $this->markPostRead($a_usr_id, $a_thread_id, $row->pos_pk);
         }
         return true;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ mergeForumUserRead()

static ilObjForum::mergeForumUserRead	(	$merge_source_thread_id,
		$merge_target_thread_id
	)

static

Definition at line 1195 of file class.ilObjForum.php.

References $DIC, and $ilDB.

Referenced by ilForum\mergeThreads().

     {
         global $DIC;
         $ilDB = $DIC->database();
         
         $ilDB->update(
             'frm_user_read',
             array('thread_id' => array('integer', $merge_target_thread_id)),
             array('thread_id' => array('integer',$merge_source_thread_id))
         );
     }

Here is the caller graph for this function:

◆ preloadForumIdsByObjIds()

static ilObjForum::preloadForumIdsByObjIds ( array $obj_ids )

static

Parameters

array $obj_ids

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

References $DIC, $ilDB, $in, $query, and $res.

     {
         global $DIC;
         $ilDB = $DIC->database();
 
         if (count($obj_ids) == 1) {
             $in = " objr.obj_id = " . $ilDB->quote(current($obj_ids), 'integer') . " ";
         } else {
             $in = $ilDB->in('objr.obj_id', $obj_ids, false, 'integer');
         }
         $query = "
                         SELECT frmd.top_pk, objr.ref_id, objr.obj_id
                         FROM object_reference objr
                         INNER JOIN frm_data frmd ON frmd.top_frm_fk = objr.obj_id
                         WHERE $in 
                 ";
         $res = $ilDB->query($query);
 
         // Prepare  cache array
         foreach ($obj_ids as $obj_id) {
             self::$obj_id_to_forum_id_cache[$obj_id] = null;
         }
 
         while ($row = $ilDB->fetchAssoc($res)) {
             self::$obj_id_to_forum_id_cache[$row['obj_id']] = $row['top_pk'];
             self::$ref_id_to_forum_id_cache[$row['ref_id']] = $row['top_pk'];
         }
     }

◆ preloadForumIdsByRefIds()

static ilObjForum::preloadForumIdsByRefIds ( array $ref_ids )

static

Parameters

array $ref_ids

Definition at line 925 of file class.ilObjForum.php.

References $DIC, $ilDB, $in, $query, ilObject\$ref_id, and $res.

Referenced by ilObjForumAccess\_preloadData().

     {
         global $DIC;
         $ilDB = $DIC->database();
         
         if (count($ref_ids) == 1) {
             $in = " objr.ref_id = " . $ilDB->quote(current($ref_ids), 'integer') . " ";
         } else {
             $in = $ilDB->in('objr.ref_id', $ref_ids, false, 'integer');
         }
         $query = "
                         SELECT frmd.top_pk, objr.ref_id, objr.obj_id
                         FROM object_reference objr
                         INNER JOIN frm_data frmd ON frmd.top_frm_fk = objr.obj_id
                         WHERE $in 
                 ";
         $res = $ilDB->query($query);
 
         // Prepare  cache array
         foreach ($ref_ids as $ref_id) {
             self::$ref_id_to_forum_id_cache[$ref_id] = null;
         }
 
         while ($row = $ilDB->fetchAssoc($res)) {
             self::$obj_id_to_forum_id_cache[$row['obj_id']] = $row['top_pk'];
             self::$ref_id_to_forum_id_cache[$row['ref_id']] = $row['top_pk'];
         }
     }

Here is the caller graph for this function:

◆ saveData()

ilObjForum::saveData ( $a_roles = array() )

Definition at line 798 of file class.ilObjForum.php.

References ilObject\getDescription(), ilObject\getId(), ilObject\getTitle(), ilUtil\now(), and user().

Referenced by create().

     {
         $nextId = $this->db->nextId('frm_data');
 
         $top_data = array(
             'top_frm_fk' => $this->getId(),
             'top_name' => $this->getTitle(),
             'top_description' => $this->getDescription(),
             'top_num_posts' => 0,
             'top_num_threads' => 0,
             'top_last_post' => null,
             'top_mods' => !is_numeric($a_roles[0]) ? 0 : $a_roles[0],
             'top_usr_id' => $this->user->getId(),
             'top_date' => ilUtil::now()
         );
 
         $this->db->manipulateF(
             '
                 INSERT INTO frm_data 
                 ( 
                         top_pk,
                         top_frm_fk, 
                         top_name,
                         top_description,
                         top_num_posts,
                         top_num_threads,
                         top_last_post,
                         top_mods,
                         top_date,
                         top_usr_id
                 )
                 VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)',
             array('integer', 'integer', 'text', 'text', 'integer', 'integer', 'text', 'integer', 'timestamp', 'integer'),
             array(
                 $nextId,
                 $top_data['top_frm_fk'],
                 $top_data['top_name'],
                 $top_data['top_description'],
                 $top_data['top_num_posts'],
                 $top_data['top_num_threads'],
                 $top_data['top_last_post'],
                 $top_data['top_mods'],
                 $top_data['top_date'],
                 $top_data['top_usr_id']
             )
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setPermissions()

ilObjForum::setPermissions ( $a_ref_id )

Returns: int

Definition at line 113 of file class.ilObjForum.php.

References _lookupModeratorRole(), ilObject\getOwner(), ilObject\getRefId(), and updateModeratorRole().

     {
         parent::setPermissions($a_ref_id);
 
         // ...finally assign moderator role to creator of forum object
         $roles = array(ilObjForum::_lookupModeratorRole($this->getRefId()));
         $this->rbac->admin()->assignUser($roles[0], $this->getOwner(), 'n');
         $this->updateModeratorRole($roles[0]);
     }

Here is the call graph for this function:

◆ setThreadSorting()

ilObjForum::setThreadSorting	(	$a_thr_pk,
		$a_sorting_value
	)

Definition at line 846 of file class.ilObjForum.php.

     {
         $this->db->update(
             'frm_threads',
             array('thread_sorting' => array('integer',$a_sorting_value)),
             array('thr_pk' => array('integer', $a_thr_pk))
         );
     }

◆ update()

ilObjForum::update ( $a_update_user_id = 0 )

update forum data public

Definition at line 481 of file class.ilObjForum.php.

References ilCopyWizardOptions\_getInstance(), cloneAutoGeneratedRoles(), ilObject\getDescription(), ilObject\getId(), ilForumProperties\getInstance(), ilObject\getRefId(), ilObject\getTitle(), and user().

     {
         if (!$a_update_user_id) {
             $a_update_user_id = $this->user->getId();
         }
         
         if (parent::update()) {
             $this->db->manipulateF(
                 '
                                 UPDATE frm_data 
                                 SET top_name = %s,
                                         top_description = %s,
                                         top_update = %s,
                                         update_user = %s
                                 WHERE top_frm_fk =%s',
                 array('text', 'text', 'timestamp', 'integer', 'integer'),
                 array(
                     $this->getTitle(),
                     $this->getDescription(),
                     date("Y-m-d H:i:s"),
                     (int) $a_update_user_id,
                     (int) $this->getId()
                 )
             );
 
             return true;
         }
 
         return false;
     }

Here is the call graph for this function:

◆ updateLastAccess()

ilObjForum::updateLastAccess	(	$a_usr_id,
		$a_thread_id
	)

Definition at line 341 of file class.ilObjForum.php.

References $data, $res, and ilObject\getId().

     {
         $res = $this->db->queryf(
             '
                         SELECT * FROM frm_thread_access 
                         WHERE usr_id = %s
                         AND obj_id = %s
                         AND thread_id = %s',
             array('integer', 'integer', 'integer'),
             array($a_usr_id, $this->getId(), $a_thread_id)
         );
         $data = $this->db->fetchAssoc($res);
 
         $this->db->replace(
             'frm_thread_access',
             array(
                 'usr_id' => array('integer', $a_usr_id),
                 'obj_id' => array('integer', $this->getId()),
                 'thread_id' => array('integer', $a_thread_id)
             ),
             array(
                 'access_last' => array('integer', time()),
                 'access_old' => array('integer', isset($data['access_old']) ? $data['access_old'] : 0),
                 'access_old_ts' => array('timestamp', $data['access_old_ts'])
             )
         );
 
         return true;
     }

Here is the call graph for this function:

◆ updateModeratorRole()

ilObjForum::updateModeratorRole ( $role_id )

Parameters

int $role_id

Definition at line 126 of file class.ilObjForum.php.

References ilObject\getId().

Referenced by setPermissions().

     {
         $this->db->manipulate('UPDATE frm_data SET top_mods = ' . $this->db->quote($role_id, 'integer') . ' WHERE top_frm_fk = ' . $this->db->quote($this->getId(), 'integer'));
     }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $Forum

ilObjForum::$Forum

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

◆ $forum_last_post_cache

ilObjForum::$forum_last_post_cache = array()

staticprotected

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

◆ $forum_statistics_cache

ilObjForum::$forum_statistics_cache = array()

staticprotected

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

◆ $ilBench

ilObjForum::$ilBench

private

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

◆ $logger

ilObjForum::$logger

private

Definition at line 52 of file class.ilObjForum.php.

◆ $obj_id_to_forum_id_cache

ilObjForum::$obj_id_to_forum_id_cache = array()

staticprotected

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

◆ $rbac

ilObjForum::$rbac

private

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

◆ $ref_id_to_forum_id_cache

ilObjForum::$ref_id_to_forum_id_cache = array()

staticprotected

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

◆ $settings

ilObjForum::$settings

private

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

◆ $user

ilObjForum::$user

private

Definition at line 51 of file class.ilObjForum.php.

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

Modules/Forum/classes/class.ilObjForum.php

Public Member Functions

Static Public Member Functions

Data Fields

Static Protected Attributes

Private Member Functions

Private Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ _deleteAccessEntries()

◆ _deleteReadEntries()

◆ _deleteUser()

◆ _lookupModeratorRole()

◆ _lookupThreadSubject()

◆ _updateOldAccess()

◆ cloneAutoGeneratedRoles()

◆ create()

◆ createSettings()

◆ delete()

◆ deleteDraftsByForumId()

◆ getCountUnread()

◆ getDiskUsage()

◆ getNumStickyThreads()

◆ getUserIdsOfLastPostsByRefIdAndThreadIds()

◆ initDefaultRoles()

◆ isRead()

◆ lookupForumIdByObjId()

◆ lookupForumIdByRefId()

◆ lookupLastPostByRefId()

◆ lookupStatisticsByRefId()

◆ markAllThreadsRead()

◆ markPostRead()

◆ markPostUnread()

◆ markThreadRead()

◆ mergeForumUserRead()

◆ preloadForumIdsByObjIds()

◆ preloadForumIdsByRefIds()

◆ saveData()

◆ setPermissions()

◆ setThreadSorting()

◆ update()

◆ updateLastAccess()

◆ updateModeratorRole()

Field Documentation

◆ $Forum

◆ $forum_last_post_cache

◆ $forum_statistics_cache

◆ $ilBench

◆ $logger

◆ $obj_id_to_forum_id_cache

◆ $rbac

◆ $ref_id_to_forum_id_cache

◆ $settings

◆ $user