# searches so that we don't have to run it for each page.
if (!isset($total)) {
$total = sql_query1("SELECT count(*) FROM {$tbl_entry} E WHERE {$sql_pred}");
}
if ($total <= 0) {
echo "<B>" . get_vocab("nothing_found") . "</B>\n";
include "trailer.inc";
exit;
}
if (!isset($search_pos) || $search_pos <= 0) {
$search_pos = 0;
} elseif ($search_pos >= $total) {
$search_pos = $total - $total % $search["count"];
}
# Now we set up the "real" query using LIMIT to just get the stuff we want.
$sql = "SELECT E.id, E.create_by, E.name, E.description, E.start_time, R.area_id\n FROM {$tbl_entry} E, {$tbl_room} R\n WHERE {$sql_pred}\n AND E.room_id = R.id\n ORDER BY E.start_time asc " . sql_syntax_limit($search["count"], $search_pos);
# this is a flag to tell us not to display a "Next" link
$result = sql_query($sql);
if (!$result) {
fatal_error(0, sql_error());
}
$num_records = sql_count($result);
$has_prev = $search_pos > 0;
$has_next = $search_pos < $total - $search["count"];
if ($has_prev || $has_next) {
echo "<B>" . get_vocab("records") . ($search_pos + 1) . get_vocab("through") . ($search_pos + $num_records) . get_vocab("of") . $total . "</B><br>";
# display a "Previous" button if necessary
if ($has_prev) {
echo "<A HREF=\"search.php?search_str={$search_url}&search_pos=";
echo max(0, $search_pos - $search["count"]);
echo "&total={$total}&year={$year}&month={$month}&day={$day}\">";
fatal_error(FALSE, get_vocab("fatal_db_error"));
}
if ($total <= 0) {
echo "<p id=\"nothing_found\">" . get_vocab("nothing_found") . "</p>\n";
require_once "trailer.inc";
exit;
}
if (!isset($search_pos) || $search_pos <= 0) {
$search_pos = 0;
} else {
if ($search_pos >= $total) {
$search_pos = $total - $total % $search["count"];
}
}
// Now we set up the "real" query using LIMIT to just get the stuff we want.
$sql = "SELECT E.id AS entry_id, E.create_by, E.name, E.description, E.start_time,\n R.area_id, A.enable_periods\n FROM {$tbl_entry} E, {$tbl_room} R, {$tbl_area} A\n WHERE {$sql_pred}\n ORDER BY E.start_time asc " . sql_syntax_limit($search["count"], $search_pos);
// this is a flag to tell us not to display a "Next" link
$result = sql_query($sql);
if (!$result) {
trigger_error(sql_error(), E_USER_WARNING);
fatal_error(FALSE, get_vocab("fatal_db_error"));
}
$num_records = sql_count($result);
$has_prev = $search_pos > 0;
$has_next = $search_pos < $total - $search["count"];
if ($has_prev || $has_next) {
echo "<div id=\"record_numbers\">\n";
echo get_vocab("records") . ($search_pos + 1) . get_vocab("through") . ($search_pos + $num_records) . get_vocab("of") . $total;
echo "</div>\n";
echo "<div id=\"record_nav\">\n";
$query_string = formatURLSearch($year, $month, $day, $search_str, $total, NULL);
$search_pos = 0;
} else {
if ($search_pos >= $total) {
$search_pos = $total - $total % $search["count"];
}
}
// If we're Ajax capable and this is not an Ajax request then don't ouput
// the table body, because that's going to be sent later in response to
// an Ajax request - so we don't need to do the query
if (!$ajax_capable || $ajax) {
// Now we set up the "real" query
$sql = "SELECT E.id AS entry_id, E.create_by, E.name, E.description, E.start_time,\n R.area_id, A.enable_periods\n FROM {$tbl_entry} E, {$tbl_room} R, {$tbl_area} A\n WHERE {$sql_pred}\n ORDER BY E.start_time asc";
// If it's an Ajax query we want everything. Otherwise we use LIMIT to just get
// the stuff we want.
if (!$ajax) {
$sql .= " " . sql_syntax_limit($search["count"], $search_pos);
}
// this is a flag to tell us not to display a "Next" link
$result = sql_query($sql);
if (!$result) {
trigger_error(sql_error(), E_USER_WARNING);
fatal_error(FALSE, get_vocab("fatal_db_error"));
}
$num_records = sql_count($result);
}
if (!$ajax_capable) {
echo generate_search_nav_html($search_pos, $total, $num_records, $search_str);
}
if (!$ajax) {
echo "<div id=\"search_output\" class=\"datatable_container\">\n";
echo "<table id=\"search_results\" class=\"admin_table display\">\n";
# searches so that we don't have to run it for each page.
if (!isset($total)) {
$total = sql_query1("SELECT count(*) FROM mrbs_entry WHERE {$sql_pred}");
}
if ($total <= 0) {
echo "<B>" . $lang["nothing_found"] . "</B>\n";
include "trailer.inc";
exit;
}
if (!isset($search_pos) || $search_pos <= 0) {
$search_pos = 0;
} elseif ($search_pos >= $total) {
$search_pos = $total - $total % $search["count"];
}
# Now we set up the "real" query using LIMIT to just get the stuff we want.
$sql = "SELECT id, create_by, name, description, start_time\n FROM mrbs_entry\n WHERE {$sql_pred}\n ORDER BY start_time asc " . sql_syntax_limit($search["count"], $search_pos);
# this is a flag to tell us not to display a "Next" link
$result = sql_query($sql);
if (!$result) {
fatal_error(0, sql_error());
}
$num_records = sql_count($result);
$has_prev = $search_pos > 0;
$has_next = $search_pos < $total - $search["count"];
if ($has_prev || $has_next) {
echo "<B>" . $lang["records"] . ($search_pos + 1) . $lang["through"] . ($search_pos + $num_records) . $lang["of"] . $total . "</B><BR>";
# display a "Previous" button if necessary
if ($has_prev) {
echo "<A HREF=\"search.php?search_str={$search_url}&search_pos=";
echo max(0, $search_pos - $search["count"]);
echo "&total={$total}&year={$year}&month={$month}&day={$day}\">";
