function writeTable($qualifier, $subject_id = '')
{
global $IconPath;
global $proxyURL;
// sanitize submission
$selected = scrubData($qualifier);
$subject_id = scrubData($subject_id);
// determine submission type
$selected = getTableOptions($selected, $subject_id);
if (isset($subject_id) && $subject_id != "") {
$q = "select distinct left(title,1) as initial, title, description, location, access_restrictions, title.title_id as this_record,\neres_display, display_note, pre, citation_guide, ctags\n FROM title, restrictions, location, location_title, source, rank\n {$selected}\n AND title.title_id = location_title.title_id\n AND location.location_id = location_title.location_id\n AND restrictions_id = access_restrictions\n \n AND rank.title_id = title.title_id AND source.source_id = rank.source_id\n ORDER BY title ";
} else {
$q = "select distinct left(title,1) as initial, title, description, location, access_restrictions, title.title_id as this_record,\neres_display, display_note, pre, citation_guide, ctags\n\t\tFROM title, restrictions, location, location_title, source\n\t\t{$selected}\n\t\tAND title.title_id = location_title.title_id\n\t\tAND location.location_id = location_title.location_id\n\t\tAND restrictions_id = access_restrictions\n\n\t\tORDER BY title";
}
//print $q;
$db = new Querier();
$r = $db->query($q);
// check row count for 0 returns
$num_rows = count($r);
if ($num_rows == 0) {
return "<div class=\"no_results\">" . _("Sorry, there are no results at this time.") . "</div>";
}
// prepare header
$items = "<table width=\"98%\" class=\"item_listing\">";
$row_count = 0;
$colour1 = "oddrow";
$colour2 = "evenrow";
foreach ($r as $myrow) {
$row_colour = $row_count % 2 ? $colour1 : $colour2;
$patterns = "/'|\"/";
$replacements = "";
$item_title = $myrow["title"];
$safe_title = trim(preg_replace($patterns, $replacements, $item_title));
$blurb = $myrow["description"];
$bib_id = $myrow["5"];
/// CHECK RESTRICTIONS ///
if ($myrow['4'] == 2 or $myrow['4'] == 3) {
$url = $proxyURL . $myrow[3];
$rest_icons = "restricted";
} else {
$url = $myrow[3];
$rest_icons = "";
// if you want the unlocked icon to show, enter "unrestricted" here
}
$current_ctags = explode("|", $myrow["ctags"]);
// add our $rest_icons info to this array at the beginning
array_unshift($current_ctags, $rest_icons);
$icons = showIcons($current_ctags);
//Check if there is a display note
if ($myrow["display_note"] == NULL) {
$display_note_text = "";
} else {
$display_note_text = "<strong>" . _("Note:") . " </strong>{$myrow['display_note']}";
}
$bonus = "{$blurb}";
if ($blurb != "") {
$information = "<img src=\"{$IconPath}/information.png\" border=\"0\" alt=\"" . _("more information") . "\" title=\"" . _("more information") . "\" id=\"bib-{$bib_id}\" />";
} else {
$information = "";
}
$items .= "\n\t<tr class=\"zebra {$row_colour}\" valign=\"top\">\n\t\t\n\t\t<td><a href=\"{$url}\" target=\"_blank\"><strong>{$item_title}</strong></a> {$icons}<br/>{$bonus} {$display_note_text}\n \n\t</tr>";
$row_count++;
}
$items .= "</table>";
return $items;
}
padding:10px;
width: 200px;
}
#d_clip_button.hover { background-color:#eee; }
#d_clip_button.active { background-color:#aaa; }
</style>
<script type="text/javascript" src="http://ben.soundenterprises.net/constructor/zeroclipboard/ZeroClipboard.js"></script>
<h1>Class Constructor</h1>
<form id="tableselector" action="constructor.jay.php">
Class to create:
<select name="table" onchange="document.getElementById('tableselector').submit()">
<option value="">Select a Table</option>
<?php
getTableOptions();
?>
</select>
</form>
<?php
writeTable();
if (isset($_REQUEST['pageaction'])) {
switch ($_REQUEST['pageaction']) {
case 'c':
writeClass();
break;
case 'alist':
writeAdminList();
break;
case 'elist':
writeAdminEdit();
