chamilo / chamilo-lms

     * @param    int

     * @return   String

     */

    public static function get_course_id_by_link_id($id_link)

    {

        $course_table = Database::get_main_table(TABLE_MAIN_COURSE);

        $tbl_grade_links = Database::get_main_table(TABLE_MAIN_GRADEBOOK_LINK);

        $sql = 'SELECT c.id FROM ' . $course_table . ' c

                INNER JOIN ' . $tbl_grade_links . ' l

                ON c.code = l.course_code

                WHERE l.id=' . intval($id_link) . ' OR l.category_id=' . intval($id_link);

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

        $array = Database::fetch_array($res, 'ASSOC');

        return $array['id'];

    }

    /**

     * @param $type

	 *

	 * @return array()

	 */

	public static function display_rating($type, $blog_id, $item_id)

	{

		$tbl_blogs_rating = Database::get_course_table(TABLE_BLOGS_RATING);

		$course_id = api_get_course_int_id();

		// Calculate rating

		$sql = "SELECT AVG(rating) as rating FROM $tbl_blogs_rating

				WHERE

				    c_id = $course_id AND

				    blog_id = '".(int)$blog_id."' AND

				    item_id = '".(int)$item_id."' AND

				    rating_type = '".Database::escape_string($type)."' ";

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

		$result = Database::fetch_array($result);

		return round($result['rating'], 2);

	}

	/**

	 * Shows the rating form if not already rated by that user