chamilo / chamilo-lms

     * @param int $task_id

     * @return void

     */

    public static function deleteTask($blog_id, $task_id)

    {

        $tbl_blogs_tasks = Database::get_course_table(TABLE_BLOGS_TASKS);

        $course_id = api_get_course_int_id();

        $blog_id = intval($blog_id);

        $task_id = intval($task_id);

        // Delete posts

        $sql = "DELETE FROM $tbl_blogs_tasks

                WHERE c_id = $course_id AND blog_id = $blog_id AND task_id = $task_id";

        Database::query($sql);

    }

    /**

     * Deletes an assigned task from a blog

     * @param int $editIcon

     * @return array

     */

    public static function getTool($editIcon)

    {

        $course_tool_table = Database::get_course_table(TABLE_TOOL_LIST);

        $editIcon = intval($editIcon);

        $sql = "SELECT * FROM $course_tool_table

                WHERE iid = $editIcon";

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

        $tool = Database::fetch_assoc($result, 'ASSOC');

        return $tool;

    }

    /**

     * @return string

 * @param $workId

 * @return mixed

 */

function checkExistingWorkFileName($filename, $workId)

{

    $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);

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

    $sql = "SELECT title FROM $work_table

            WHERE parent_id = $workId AND title = '$filename' AND active = 1";

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

    return Database::fetch_assoc($result);

}

/**

 * @param array $workInfo