smtech / canvas-ics-sync

sync.php

<?php

define('IGNORE_LTI', true);
	
require_once('common.inc.php');

// FIXME: should filter so that the syncs for the server we're running against (INDEX_WEB_PATH) are called (or is that already happening?)
$schedulesResponse = $sql->query("
	SELECT *
		FROM `schedules`
		WHERE
			`schedule` = '" . $sql->real_escape_string($argv[1]) . "'
		ORDER BY
			`synced` ASC
");

while($schedule = $schedulesResponse->fetch_assoc()) {
	$calendarResponse = $sql->query("
		SELECT *
			FROM `calendars`
			WHERE
				`id` = '{$schedule['calendar']}'
	");
	if ($calendar = $calendarResponse->fetch_assoc()) {
		echo shell_exec('php ' . __DIR__ . '/import.php ' . $calendar['ics_url'] . ' ' . $calendar['canvas_url'] . ' ' . $schedule['id']);
	}
}

?>

It is not recommended to use PHP's closing tag ?> in files other than templates.