chamilo / chamilo-lms

	 * @param int $language_id

	 * @return int The current type of terms and conditions

	 */

	public static function get_type_of_terms_and_conditions($legal_id, $language_id)

    {

		$legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL);

		$legal_id = intval($legal_id);

		$language_id = intval($language_id);

		$sql = 'SELECT type FROM '.$legal_conditions_table.'

		        WHERE id =  "'.$legal_id.'" AND language_id="'.$language_id.'"';

		$rs = Database::query($sql);

		return Database::result($rs,0,'type');

	}

    /**

     * @param int $userId

     * @param int user id

     * @return array

     */

    public static function get_list_invitation_of_friends_by_user_id($user_id)

    {

        $tbl_message = Database::get_main_table(TABLE_MESSAGE);

        $sql = 'SELECT user_sender_id, send_date, title, content

                FROM '.$tbl_message.'

                WHERE

                    user_receiver_id = '.intval($user_id).' AND

                    msg_status = '.MESSAGE_STATUS_INVITATION_PENDING;

        $res = Database::query($sql);

        $list_friend_invitation = array();

        while ($row = Database::fetch_array($res, 'ASSOC')) {

            $list_friend_invitation[] = $row;

        }

        return $list_friend_invitation;

    }

    /**

     * Get invitation list sent by user

     * @param int user id

     * @return array()

     */

    public static function get_list_invitation_sent_by_user_id($user_id)

    {

        $list_friend_invitation = array();

        $tbl_message = Database::get_main_table(TABLE_MESSAGE);

        $sql = 'SELECT user_receiver_id, send_date,title,content

                FROM '.$tbl_message.'

                WHERE

                    user_sender_id = '.intval($user_id).' AND

                    msg_status = '.MESSAGE_STATUS_INVITATION_PENDING;

        $res = Database::query($sql);

        while ($row = Database::fetch_array($res, 'ASSOC')) {

            $list_friend_invitation[$row['user_receiver_id']] = $row;

        }

        return $list_friend_invitation;

    }

    /**

     * Accepts invitation

     * @param Integer The sub language id

     * @return array All information about sub-language

     */

    public static function get_all_information_of_sub_language($parent_id, $sub_language_id)

    {

        $table = Database :: get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = 'SELECT * FROM ' . $table . '

                WHERE

                    parent_id= ' . intval($parent_id).' AND

                    id= ' . intval($sub_language_id) . '';

        $rs = Database::query($sql);

        $all_information = array();

        while ($row = Database::fetch_array($rs, 'ASSOC')) {

            $all_information = $row;

        }

        return $all_information;

    }

    /**

     * Get all information of language

     * @param Integer The parent id(Language father id)

     * @return array All information about language

     */

    public static function get_all_information_of_language($parent_id)

    {

        $table = Database :: get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = 'SELECT * FROM ' . $table . ' WHERE id = "' . intval($parent_id) . '"';

        $rs = Database::query($sql);

        $all_information = array();

        while ($row = Database::fetch_array($rs, 'ASSOC')) {

            $all_information = $row;

        }

        return $all_information;

    }

    /**

     * Get all information of chamilo file