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	int		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