class.ilNewsSubscription.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */


class ilNewsSubscription
{
    public static function _subscribe($a_ref_id, $a_user_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $ilDB->manipulate("DELETE FROM il_news_subscription WHERE " .
            " ref_id = " . $ilDB->quote($a_ref_id, "integer") . " " .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer"));
        $ilDB->manipulate("INSERT INTO il_news_subscription (ref_id, user_id) VALUES (" .
            $ilDB->quote($a_ref_id, "integer") . ", " .
            $ilDB->quote($a_user_id, "integer") . ")");
    }

    public static function _unsubscribe($a_ref_id, $a_user_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $ilDB->manipulate("DELETE FROM il_news_subscription WHERE ref_id  = " .
            $ilDB->quote($a_ref_id, "integer") . " AND user_id = " .
            $ilDB->quote($a_user_id, "integer"));
    }

    public static function _hasSubscribed($a_ref_id, $a_user_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $query = "SELECT * FROM il_news_subscription WHERE ref_id = " .
            $ilDB->quote($a_ref_id, "integer") . " AND user_id = " .
            $ilDB->quote($a_user_id, "integer");
        $set = $ilDB->query($query);
        if ($rec = $ilDB->fetchAssoc($set)) {
            return true;
        } else {
            return false;
        }
    }

    public static function _getSubscriptionsOfUser($a_user_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $query = "SELECT * FROM il_news_subscription WHERE user_id = " .
            $ilDB->quote($a_user_id, "integer");
        $set = $ilDB->query($query);
        $ref_ids = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $ref_ids[] = $rec["ref_id"];
        }

        return $ref_ids;
    }
}