} } 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>