chamilo / chamilo-lms

     * @param int $locked 1 or unlocked 0

     *

     * */

    public function lock($locked)

    {

        $table = Database::get_main_table(TABLE_MAIN_GRADEBOOK_LINK);

        $sql = "UPDATE $table SET locked = '".intval($locked)."'

                WHERE id='".$this->id."'";

        Database::query($sql);

    }

    /**

     * Get current user ranking

    /**

     * Not delete this category from the database,when visible=3 is category eliminated

     */

    public function update_category_delete($course_id)

    {

        $tbl_grade_categories = Database :: get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY);

        $sql = 'UPDATE '.$tbl_grade_categories.' SET visible=3

                WHERE course_code ="'.Database::escape_string($course_id).'"';

        Database::query($sql);

    }

    /**

     * Show message resource delete

     * @return boolean|null

     * */

    public function lock($locked)

    {

        $table = Database::get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY);

        $sql = "UPDATE $table SET locked = '".intval($locked)."'

                WHERE id='".intval($this->id)."'";

        Database::query($sql);

    }

    /**

     * @param $locked

	/**

	 * Delete all results for this evaluation

	 */

	public function delete_results()

	{

		$tbl_grade_results = Database :: get_main_table(TABLE_MAIN_GRADEBOOK_RESULT);

		$sql = 'DELETE FROM '.$tbl_grade_results.'

				WHERE evaluation_id = '.intval($this->id);

		Database::query($sql);

	}

	/**

	 * Delete this evaluation and all underlying results.

     * @param string $course_code

     * @return integer if exists, false else

     */

    public static function course_exists($course_code)

    {

        $sql = 'SELECT 1 FROM ' . Database::get_main_table(TABLE_MAIN_COURSE) . '

                WHERE code="' . Database::escape_string($course_code) . '"';

        return Database::num_rows(Database::query($sql));

    }

    /**

     * Send an email to tutor after the auth-suscription of a student in your course