Collaboration diagram for ilWikiContributor:

Public Member Functions
	_lookupStatus ($a_obj_id, $a_user_id)
	Lookup current success status (STATUS_NOT_GRADED\|STATUS_PASSED\|STATUS_FAILED) More...

	_lookupStatusTime ($a_obj_id, $a_user_id)
	Lookup last change in mark or success status. More...

	_writeStatus ($a_obj_id, $a_user_id, $a_status)
	Write success status. More...

Data Fields
const	STATUS_NOT_GRADED = 0

const	STATUS_PASSED = 1

const	STATUS_FAILED = 2

Detailed Description

Class ilWikiContributor.

Author: Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Version: $Id$

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

Member Function Documentation

◆ _lookupStatus()

ilWikiContributor::_lookupStatus	(	$a_obj_id,
		$a_user_id
	)

Lookup current success status (STATUS_NOT_GRADED|STATUS_PASSED|STATUS_FAILED)

Parameters

int	$a_obj_id	exercise id
int	$a_user_id	member id

Returns: mixed false (if user is no member) or notgraded|passed|failed

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

        {
                global $ilDB;
 
                $set = $ilDB->queryF("SELECT status FROM il_wiki_contributor ".
                        "WHERE wiki_id = %s and user_id = %s",
                        array("integer", "integer"),
                        array($a_obj_id, $a_user_id));
                if($row = $ilDB->fetchAssoc($set))
                {
                        return $row["status"];
                }
                return false;
        }

References $ilDB, and $row.

Referenced by ilWikiContributorsTableGUI\fillRow(), ilObjWikiGUI\infoScreen(), and ilObjWikiGUI\saveGradingObject().

Here is the caller graph for this function:

◆ _lookupStatusTime()

ilWikiContributor::_lookupStatusTime	(	$a_obj_id,
		$a_user_id
	)

Lookup last change in mark or success status.

Parameters

int	$a_obj_id	exercise id
int	$a_user_id	member id

Returns: mixed false (if user is no member) or notgraded|passed|failed

Definition at line 68 of file class.ilWikiContributor.php.

        {
                global $ilDB;
 
                $set = $ilDB->queryF("SELECT status_time FROM il_wiki_contributor ".
                        "WHERE wiki_id = %s and user_id = %s",
                        array("integer", "integer"),
                        array($a_obj_id, $a_user_id));
                if($row = $ilDB->fetchAssoc($set))
                {
                        return $row["status_time"];
                }
                return false;
        }

References $ilDB, and $row.

Referenced by ilWikiContributorsTableGUI\fillRow().

Here is the caller graph for this function:

◆ _writeStatus()

ilWikiContributor::_writeStatus	(	$a_obj_id,
		$a_user_id,
		$a_status
	)

Write success status.

Parameters

int	$a_obj_id	exercise id
int	$a_user_id	member id
int	$status	status: STATUS_NOT_GRADED\|STATUS_PASSED\|STATUS_FAILED

Returns: int number of affected rows

Definition at line 92 of file class.ilWikiContributor.php.

        {
                global $ilDB;
 
                $ilDB->manipulate("DELETE FROM il_wiki_contributor WHERE ".
                        " wiki_id = ".$ilDB->quote($a_obj_id, "integer").
                        " AND user_id = ".$ilDB->quote($a_user_id, "integer"));
 
                $ilDB->manipulateF("INSERT INTO il_wiki_contributor (status, wiki_id, user_id, status_time) ".
                        "VALUES (%s,%s,%s,%s)",
                        array("integer", "integer", "integer", "timestamp"),
                        array($a_status, $a_obj_id, $a_user_id, ilUtil::now()));
        }