chamilo / chamilo-lms

 * @param string $course_code

 * @return array All fields from c_item_property (all rows found) or empty array

 */

function api_get_item_property_by_tool($tool, $course_code, $session_id = null)

{

    $course_info = api_get_course_info($course_code);

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

    // Definition of tables.

    $item_property_table = Database::get_course_table(TABLE_ITEM_PROPERTY);

    $session_id = intval($session_id);

    $session_condition = ' AND session_id = '.$session_id;

    if (empty($session_id)) {

        $session_condition = " AND (session_id = 0 OR session_id IS NULL) ";

    }

    $course_id = $course_info['real_id'];

    $sql = "SELECT * FROM $item_property_table

            WHERE

                c_id = $course_id AND

                tool = '$tool'

                $session_condition ";

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

    $list = array();

    if (Database::num_rows($rs) > 0) {

        while ($row = Database::fetch_array($rs, 'ASSOC')) {

            $list[] = $row;

        }

    }

    return $list;

}

/**

 * Gets item property by tool and user

 * @param int $session_id

 * @return array

 */

function api_get_item_property_list_by_tool_by_user(

    $userId,

    $tool,

    $courseId,

    $session_id = 0

) {

    $userId = intval($userId);

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

    $session_id = intval($session_id);

    $courseId = intval($courseId);

    // Definition of tables.

    $item_property_table = Database::get_course_table(TABLE_ITEM_PROPERTY);

    $session_condition = ' AND session_id = '.$session_id;

    if (empty($session_id)) {

        $session_condition = " AND (session_id = 0 OR session_id IS NULL) ";

    }

    $sql = "SELECT * FROM $item_property_table

            WHERE

                insert_user_id = $userId AND

                c_id = $courseId AND

                tool = '$tool'

                $session_condition ";

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

    $list = array();

    if (Database::num_rows($rs) > 0) {

        while ($row = Database::fetch_array($rs, 'ASSOC')) {

            $list[] = $row;

        }

    }

    return $list;

}

/**

 * Gets item property id from tool of a course