chamilo / chamilo-lms

 *

 * @return array

 */

function get_work_data_by_path($path, $courseId = null)

{

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

    if (empty($courseId)) {

        $courseId = api_get_course_int_id();

    } else {

        $courseId = intval($courseId);

    }

    $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);

    $sql = "SELECT *  FROM  ".$work_table."

            WHERE url = '$path' AND c_id = $courseId ";

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

    $return = array();

    if (Database::num_rows($result)) {

        $return = Database::fetch_array($result, 'ASSOC');

    }

    return $return;

}

/**

 * @param int $id

 *

 * @return array

 */

function get_work_assignment_by_id($id, $courseId = null)

{

    if (empty($courseId)) {

        $courseId = api_get_course_int_id();

    } else {

        $courseId = intval($courseId);

    }

    $id = intval($id);

    $table = Database :: get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT);

    $sql = "SELECT * FROM $table

            WHERE c_id = $courseId AND publication_id = $id";

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

    $return = array();

    if (Database::num_rows($result)) {

        $return = Database::fetch_array($result, 'ASSOC');

    }

    return $return;

}

/**

 * @param int $id