chamilo / chamilo-lms

     *

     * @return array

     */

    public function getRepeatedInfoByEvent($eventId, $courseId)

    {

        $repeatTable = Database::get_course_table(TABLE_AGENDA_REPEAT);

        $eventId = intval($eventId);

        $courseId = intval($courseId);

        $sql = "SELECT * FROM $repeatTable

                WHERE c_id = $courseId AND cal_id = $eventId";

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

        $repeatInfo = array();

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

            $repeatInfo = Database::fetch_array($res, 'ASSOC');

        }

        return $repeatInfo;

    }

    /**

     * @param int $eventId

 * @param int       Session ID

 * @return array    information of the session

 */

function api_get_session_info($session_id)

{

    $data = array();

    if (!empty($session_id)) {

        $session_id = intval($session_id);

        $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);

        $sql = "SELECT * FROM $tbl_session WHERE id = $session_id";

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

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

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

        }

    }

    return $data;

}

/**

 * Gets the session visibility by session id