if ($statement === false) { return $query . "\n\n" . get_odbc_error(); } $items = array(); $items[] = (int) $rownum; $result = odbc_execute($statement, $items); if ($result === false) { return $query . "\n\n" . get_odbc_error(); } return $statement; } $result = get_report($client, totally_escape($_POST["target"]), $_POST["show"], $_POST["rownum"]); if (is_string($result)) { echo "<div class=\"error_message\">" . $result . "</div>"; } else { make_results_table($result, false, null); } } else { //show form ?> <div id="form_message" style="display: none;"></div> <form action="" method="post" class="report_form" id="report_form"> <p>Compose report of <input type='number' name='rownum' value='50' min='1'/> rows from table <select id="report_target" name="target" onchange="show_fields();"> <option value=""><select table></option> <?php $query = "SELECT table_name FROM user_tables;"; $result = odbc_exec($client->get_connection(), $query); if ($result === false) {
} // This search functionality is for OPERATORS only if (!$user->isAllowed(CS_ACTION::ADMINISTER_MEMBERS, CS_CONTEXT_TYPE::MEMBER, null)) { exit; } $sa_url = get_first_service_of_type(SR_SERVICE_TYPE::SLICE_AUTHORITY); $ma_url = get_first_service_of_type(SR_SERVICE_TYPE::MEMBER_AUTHORITY); // Handle the request, determine if a search can be performed and which to be performed if (array_key_exists('term', $_REQUEST)) { $term = $_REQUEST['term']; if (array_key_exists('search_type', $_REQUEST)) { $search_type = $_REQUEST['search_type']; } else { $search_type = "urn"; } make_results_table(search_for_slices($term, $search_type, $user, $ma_url, $sa_url), $user, $ma_url, $sa_url); } else { print "Couldn't complete empty search."; } function is_valid_urn($urn) { $pattern = '/urn:publicid:IDN\\+([^\\+]+)\\+([^\\+]+)\\+([^\\+]+)$/'; $match_count = preg_match($pattern, $urn, $matches); return $match_count == 1; } // Returns an array of slice detail objects from the SA for slices which match // the $term for the $search_type function search_for_slices($term, $search_type, $signer, $ma_url, $sa_url) { if ($search_type == "urn") { if (is_valid_urn($term)) {
></a> <a class="button edit" href=<?php echo "\"?tables&action=edit&target=" . $target . "\""; ?> ></a> <a class="button add" href=<?php echo "\"?tables&action=add_entry&target=" . $target . "\""; ?> ><div class="plus-sign"></div></a> </div> <div id="save_message" style="display: none;"></div> <?php $query = "select ROWID, a.* from " . $target . " a where rownum<50;"; $result = odbc_exec($client->get_connection(), $query); make_results_table($result, false, $target); ?> <script> var button_active = true; function delete_entry(rowid) { if(!button_active) return; button_active = false; message('save_message', "gray_message", "Deleting..."); AJAX_POST( "ajax/delete_entry.php", {"target": <?php echo "\"" . $target . "\""; ?> , "rowid": rowid},