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