echo "</tr>";
}
?>
</table>
<?php
} else {
echo "(none found)";
}
break;
//display expression type list for admin screen - needs its own display because of note type
//display expression type list for admin screen - needs its own display because of note type
case 'getCalendarSettingsList':
$instanceArray = array();
$calendarSettings = new CalendarSettings();
$tempArray = array();
foreach ($calendarSettings->allAsArray() as $tempArray) {
array_push($instanceArray, $tempArray);
}
if (count($instanceArray) > 0) {
?>
<table class='dataTable' style='width:400px'>
<tr>
<th>Setting</th>
<th>Value</th>
<th> </th>
<?php
foreach ($instanceArray as $instance) {
echo "<tr>";
echo "<td>" . $instance['shortName'] . "</td>";
echo "<td>";
//below includes search options in left pane only - the results are refreshed through ajax and placed in div searchResults
//print header
$pageTitle = _('Calendar');
$config = new Configuration();
$host = $config->database->host;
$username = $config->database->username;
$password = $config->database->password;
$license_databaseName = $config->database->name;
$resource_databaseName = $config->settings->resourcesDatabaseName;
$link = mysqli_connect($host, $username, $password) or die(_("Could not connect to host."));
mysqli_select_db($link, $license_databaseName) or die(_("Could not find License database."));
mysqli_select_db($link, $resource_databaseName) or die(_("Could not find Resource database."));
$display = array();
$calendarSettings = new CalendarSettings();
try {
$calendarSettingsArray = $calendarSettings->allAsArray();
} catch (Exception $e) {
echo "<span style='color:red'>" . _("There was an error with the CalendarSettings Table please verify the table has been created.") . "</span>";
exit;
}
// Check for earlier version of Resource Module. With update of 1.3 the table definition changed.
$query = "Select subscriptionStartDate from `{$resource_databaseName}`.`Resource`";
$result = mysqli_query($link, $query);
if ($result) {
// Previous tabel definition before Resources version 1.3
$startDateName = "subscriptionStartDate";
$endDateName = "subscriptionEndDate";
} else {
$startDateName = "currentStartDate";
$endDateName = "currentEndDate";
}
