chamilo / chamilo-lms

 * @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

     * @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