class.ilWikiContributor.php

Go to the documentation of this file.

<?php
/*
    +-----------------------------------------------------------------------------+
    | ILIAS open source                                                           |
    +-----------------------------------------------------------------------------+
    | Copyright (c) 1998-2009 ILIAS open source, University of Cologne            |
    |                                                                             |
    | This program is free software; you can redistribute it and/or               |
    | modify it under the terms of the GNU General Public License                 |
    | as published by the Free Software Foundation; either version 2              |
    | of the License, or (at your option) any later version.                      |
    |                                                                             |
    | This program is distributed in the hope that it will be useful,             |
    | but WITHOUT ANY WARRANTY; without even the implied warranty of              |
    | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the               |
    | GNU General Public License for more details.                                |
    |                                                                             |
    | You should have received a copy of the GNU General Public License           |
    | along with this program; if not, write to the Free Software                 |
    | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA. |
    +-----------------------------------------------------------------------------+
*/


class ilWikiContributor
{
    const STATUS_NOT_GRADED = 0;
    const STATUS_PASSED = 1;
    const STATUS_FAILED = 2;
    
    public static function _lookupStatus($a_obj_id, $a_user_id)
    {
        global $DIC;

        $ilDB = $DIC->database();

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

    public static function _lookupStatusTime($a_obj_id, $a_user_id)
    {
        global $DIC;

        $ilDB = $DIC->database();

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

    public static function _writeStatus($a_obj_id, $a_user_id, $a_status)
    {
        global $DIC;

        $ilDB = $DIC->database();

        $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())
        );
    }
}