chamilo / chamilo-lms

 * @author Isaac Flores <[email protected]>, U.N.A.S University

 * @version December 2008, dokeos  1.8.6

 */

function current_qualify_of_thread($threadId, $sessionId, $userId)

{

    $table_threads_qualify = Database::get_course_table(TABLE_FORUM_THREAD_QUALIFY);

    $course_id = api_get_course_int_id();

    $currentUserId = api_get_user_id();

    $sessionId = intval($sessionId);

    $threadId = intval($threadId);

    $sql = "SELECT qualify FROM $table_threads_qualify

            WHERE

                c_id = $course_id AND

                thread_id = $threadId AND

                session_id = $sessionId AND

                qualify_user_id = $currentUserId AND

                user_id = $userId

            ";

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

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

    return $row['qualify'];

}

/**

 * This function stores a reply in the forum_post table.

     * @param integer $thematic_advance_id

     * @return	int		Affected rows

     */

    public function thematic_advance_destroy($thematic_advance_id)

    {

        $_course = api_get_course_info();

        $course_id = api_get_course_int_id();

        // definition database table

        $tbl_thematic_advance = Database::get_course_table(TABLE_THEMATIC_ADVANCE);

        // protect data

        $thematic_advance_id = intval($thematic_advance_id);

        $user_id = api_get_user_id();

        $sql = "DELETE FROM $tbl_thematic_advance

                WHERE c_id = $course_id AND id = $thematic_advance_id ";

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

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

        if ($affected_rows) {

            api_item_property_update(

                $_course,

                'thematic_advance',

                $thematic_advance_id,

                'ThematicAdvanceDeleted',

                $user_id

            );

        }

        return $affected_rows;

    }

    /**

     * get thematic plan data

     * @param integer $item_id

     * @return array

     */

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

    {

        $tbl_blogs_rating = Database::get_course_table(TABLE_BLOGS_RATING);

        $course_id = api_get_course_int_id();

        $blog_id = intval($blog_id);

        $item_id = intval($item_id);

        $type = Database::escape_string($type);

        // Calculate rating

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

                WHERE

                    c_id = $course_id AND

                    blog_id = $blog_id AND

                    item_id = $item_id AND

                    rating_type = '$type'";

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

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

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

    }

    /**

     * Displays the form to create a new post