}
} else {
$_GET["type"] = "";
$show_types = FALSE;
$clean_type = "";
}
// Add a quick search
$description_search = 0;
// init to negative
if (isset($_POST["searchterm"])) {
$_GET["letter"] = "%" . $_POST["searchterm"];
$page_title = _("Database List: Search Results");
$description_search = 1;
// if you want to search descriptions, too, set to 1; otherwise to 0
}
$alphabet = getLetters("databases", $_GET["letter"], 1, TRUE);
// Get our newest databases
$connection = $db->getConnection();
$statement = $connection->prepare("SELECT DISTINCT title, location, access_restrictions\n FROM title as t\n INNER JOIN location_title as lt\n ON t.title_id = lt.title_id\n INNER JOIN location as l\n ON lt.location_id = l.location_id\n INNER JOIN restrictions as r\n ON l.access_restrictions = r.restrictions_id\n INNER JOIN rank as rk\n ON rk.title_id = t.title_id\n INNER JOIN source as s\n ON rk.source_id = s.source_id\nWHERE l.ctags LIKE '%New_Databases%'\n AND eres_display = 'Y'\nORDER BY t.title\nASC limit 0,5");
$statement->execute();
$newlist = "";
if ($rnew = $statement->fetchAll()) {
$newlist = "<ul>\n";
foreach ($rnew as $myrow) {
$db_url = "";
// add proxy string if necessary
if ($myrow[2] != 1) {
$db_url = $proxyURL;
}
$newlist .= "<li><a href=\"{$db_url}{$myrow['1']}\">{$myrow['0']}</a></li>\n";
}
{
$sql = 'select content from game_redbag_letters where type_code = ' . $type_code . ' order by item';
$result = $conn->query($sql);
return $result;
}
//查询初始头像
$def_ava = getAvatar($conn);
$avatar_path_rect = '';
$avatar_path_circle = '';
$avatar_name;
if ($def_ava->num_rows == 2) {
while ($row = $def_ava->fetch_assoc()) {
if ($avatar_path_rect != '') {
$avatar_path_circle = $row['path'];
} else {
$avatar_path_rect = $row['path'];
}
$avatar_name = iconv('gbk', 'utf-8', $row['name']);
}
}
//查询文案
$def_let_result = getLetters('01', $conn);
$def_let = array();
if ($def_let_result->num_rows > 0) {
while ($row = $def_let_result->fetch_assoc()) {
array_push($def_let, iconv('gbk', 'utf-8', $row['content']));
}
}
$conn->close;
$resp = array('avatar_name' => $avatar_name, 'avatar_path_rect' => $avatar_path_rect, 'avatar_path_circle' => $avatar_path_circle, 'def_let' => $def_let, 'userKey' => $userKey);
echo json_encode($resp);
exit;
}
$page_title = "Library Staff";
$description = "Library contact list.";
$keywords = "staff list, librarians, contacts";
$use_jquery = array("ui", "ui_styles");
//////////
// Generate List
//////////
$intro = "<br />";
$our_cats = array("A-Z", "By Department", "Subject Librarians A-Z", "Librarians by Subject Specialty");
if (!isset($_GET["letter"]) || $_GET["letter"] == "") {
$_GET["letter"] = "A-Z";
}
$selected_letter = scrubData($_GET["letter"]);
$alphabet = getLetters($our_cats, $selected_letter);
if ($selected_letter == "A-Z") {
$intro = "<p><img src=\"{$IconPath}/information.png\" alt=\"icon\" /> Click on a name for more information.</p>\n<br />";
}
$staff_data = new StaffDisplay();
$out = $staff_data->writeTable($selected_letter);
// Assemble the content for our main pluslet
$display = $alphabet . $intro . $out;
////////////////////////////
// Now we are finally read to display the page
////////////////////////////
include "includes/header.php";
?>
<div class="pure-g">
<div class="pure-u-1 pure-u-lg-2-3 pure-u-xl-4-5">
<div class="pluslet">
<?php echo getPoints(); ?> </select> Rewards <select id="Rewards_15" name="selectRewards"> <?php echo getRewards(); ?> </select> </td> <td> Letter <select id="Letter_16" name="selectLetter"> <?php echo $letters = getLetters(); ?> </select> Points <select id="Points_16" name="selectPoints"> <?php echo getPoints(); ?> </select> Rewards <select id="Rewards_16" name="selectRewards"> <?php echo getRewards(); ?> </select> </td> </tr>
