function b1n_doLogin($sql, &$ret_msgs, &$logging)
{
$ret_msgs = array();
session_unset();
if (!b1n_getVar("page0", $page0) || !b1n_getVar("action0", $action0) || !b1n_getVar("login", $login) || !b1n_getVar("passwd", $passwd) || $page0 != "login" || $action0 != "login") {
return false;
}
$query = "\n SELECT\n usr_id,\n usr_name,\n usr_start_page,\n usr_email\n FROM\n view_active_usr\n WHERE\n usr_login = '******'\n AND usr_passwd = '" . b1n_inBd(b1n_crypt($passwd)) . "'";
$rs = $sql->singleQuery($query);
if (!is_array($rs)) {
b1n_retMsg($ret_msgs, b1n_FIZZLES, "Login incorrect");
return false;
}
$user = array("usr_id" => $rs["usr_id"], "usr_name" => ucfirst(strtok($rs["usr_name"], " ")), "usr_email" => $rs["usr_email"]);
if (!empty($rs['usr_start_page'])) {
$aux = explode(': ', $rs['usr_start_page']);
if (sizeof($aux)) {
$user += array("usr_toc" => $aux[0]);
if (isset($aux[1])) {
}
$user += array("usr_content" => $aux[1]);
}
}
$user["permission"] = b1n_getPermissions($sql, $user["usr_id"]);
$user["bookmark"] = b1n_getBookmarks($sql, $user["usr_id"]);
$_SESSION["user"] = $user;
$logging = 1;
return true;
}
function b1n_sessionDestroy($ses_id)
{
global $ses_sql;
$query = 'DELETE FROM session WHERE ses_id = ' . b1n_inBd($ses_id);
$ses_sql->sqlQuery($query);
return true;
}
function b1n_regLoadLink($sql, &$ret_msgs, &$reg_data, $reg_config)
{
// Testing if the link really belongs to the current user
$rs = $sql->singleQuery("SELECT COUNT(lnk_id) AS c FROM \"link\" WHERE usr_id = '" . b1n_inBd($_SESSION['user']['usr_id']) . "' AND lnk_id = '" . b1n_inBd($reg_data['id']) . "'");
if ($rs['c'] == '1') {
return b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "link");
} else {
b1n_retMsg($ret_msgs, b1n_FIZZLES, "This Link does not belongs to you, What are you Trying to Do?");
return false;
}
}
function b1n_regChangeCatererPlus($sql, &$ret_msgs, $reg_data, $reg_config)
{
// Deleting Contacts
if ($sql->query("DELETE FROM \"cat_ctc\" WHERE cat_id = '" . b1n_inBd($reg_data["id"]) . "'")) {
// Adding New
$ret = b1n_regAddCatererPlus($sql, $ret_msgs, $reg_data, $reg_config);
} else {
b1n_retMsg($ret_msgs, b1n_FIZZLES, "Could not delete entries in cat_ctc.");
$ret = false;
}
return $ret;
}
function b1n_regAddFilePlus($sql, &$ret_msgs, $reg_data, $reg_config)
{
if (move_uploaded_file($_FILES['file']['tmp_name'], b1n_UPLOAD_DIR . "/fil_" . $reg_data['id'])) {
$query = "\n UPDATE\n \"file\"\n SET\n fil_fake_name = '" . b1n_inBd($reg_data['fil_fake_name']) . "'\n WHERE\n fil_id = '" . b1n_inBd($reg_data['id']) . "'";
$rs = $sql->query($query);
if ($rs) {
return true;
}
}
b1n_retMsg($ret_msgs, b1n_FIZZLES, "Unexpected Error! Could not update 'file' table...");
return false;
}
function b1n_search($sql, $search_config, $search, $select_first_if_none = true, $where_plus = '')
{
$ret["select_fields"] = $search_config["select_fields"];
$ret["possible_fields"] = $search_config["possible_fields"];
$ret["possible_quantities"] = $search_config["possible_quantities"];
// ---------------------- Checking and Session storing ----------------
if (!b1n_checkSearch($search, $ret, $search_config["session_hash_name"], $select_first_if_none)) {
$ret["search"] = $search;
return $ret;
}
$ret["search"] = $search;
$_SESSION["search"][$search_config["session_hash_name"]] = $search;
if (empty($search["search_text"])) {
$isnull = " OR " . $search["search_field"] . " IS NULL";
} else {
$isnull = "";
}
// ---------------------- WHERE ---------------------------
if (!empty($search["search_field"])) {
$where = " WHERE " . $search["search_field"] . " ILIKE '%" . b1n_inBd($search["search_text"]) . "%'" . $where_plus . $isnull;
} else {
$where = $where_plus;
}
// ---------------------- ORDER BY ---------------------------
if (!empty($search['search_order'])) {
$orderby = " ORDER BY LOWER(" . $search['search_order'] . ") ";
if (!empty($search['search_order_type'])) {
$orderby .= " " . $search['search_order_type'];
}
} else {
$orderby = '';
}
// ---------------------- LIMIT & OFFSET ----------------
if ($search["search_quantity"] == 'all') {
$limit = '';
$ret['pg_actual'] = 1;
$ret['pg_pages'] = 1;
} else {
$query = "\n SELECT DISTINCT\n COUNT(" . $search_config["id_field"] . ")\n FROM\n \"" . $search_config["table"] . "\"" . $where;
$rs_count = $sql->singleQuery($query);
$ret["pg_pages"] = max(1, ceil($rs_count["count"] / $search["search_quantity"]));
if ($search["pg_actual"] > $ret["pg_pages"]) {
$search["pg_actual"] = $ret["pg_pages"];
}
$ret["pg_actual"] = $search["pg_actual"];
$limit = " LIMIT " . $search['search_quantity'] . ' OFFSET ' . ($search['pg_actual'] - 1) * $search['search_quantity'];
}
// ---------------------- DB Search ---------------------------
$select_fields = $search_config['id_field'] . " AS id, " . implode(", ", $search_config['select_fields']);
$query = "\n SELECT\n " . $select_fields . "\n FROM\n \"" . $search_config['table'] . "\" " . $where . $orderby . $limit;
$ret["result"] = $sql->query($query);
return $ret;
}
function b1n_regChangeFoodtypePlus($sql, &$ret_msgs, $reg_data, $reg_config)
{
$ret = false;
// Deleting Functions
if ($sql->query("DELETE FROM \"fdt_fod\" WHERE fdt_id = '" . b1n_inBd($reg_data["id"]) . "'")) {
// Adding New
$ret = b1n_regAddFoodtypePlus($sql, $ret_msgs, $reg_data, $reg_config);
} else {
b1n_retMsg($ret_msgs, b1n_FIZZLES, "Could not delete entries in fdt_fod.");
$ret = false;
}
return $ret;
}
function b1n_regCheckChangePax_vst($sql, &$ret_msgs, $reg_data, $reg_config)
{
$ret = b1n_regCheckChange($sql, $ret_msgs, $reg_data, $reg_config);
if ($ret) {
$query = "SELECT pvs_id FROM \"pax_vst\" WHERE pax_id = '" . b1n_inBd($reg_data['pax_id']) . "' AND vst_id = '" . b1n_inBd($reg_data['vst_id']) . "' AND pvs_id != '" . $reg_data['id'] . "'";
$rs = $sql->singleQuery($query);
if (is_array($rs)) {
b1n_retMsg($ret_msgs, b1n_FIZZLES, "This combination of <b>Pax</b> and <b>Visa Type</b> already exists.");
$ret = false;
}
}
return $ret;
}
function b1n_playerGetSiblings()
{
global $sql;
$siblings = array();
if (!empty($_SESSION['player']['pla_parent_id'])) {
$query = "\n SELECT\n pla_login || ' (' || pla_exp || ') ' AS player\n FROM\n player\n WHERE\n pla_id != " . $_SESSION['player']['pla_id'] . " AND\n pla_parent_id = " . b1n_inBd($_SESSION['player']['pla_parent_id']) . " AND\n pla_active = true AND\n pla_last_login >\n (CURRENT_TIMESTAMP::timestamp - '" . b1n_MAX_INACTIVE_TIME . "'::interval)";
$aux = $sql->sqlQuery($query);
foreach ($aux as $s) {
$siblings[] = $s['player'];
}
}
return $siblings;
}
function b1n_regChangeGroupPlus($sql, &$ret_msgs, $reg_data, $reg_config)
{
// Deleting Functions
if ($sql->query("DELETE FROM \"grp_fnc\" WHERE grp_id = '" . b1n_inBd($reg_data["id"]) . "'")) {
// Deleting Users
if ($sql->query("DELETE FROM \"grp_usr\" WHERE grp_id = '" . b1n_inBd($reg_data["id"]) . "'")) {
// Adding New
$ret = b1n_regAddGroupPlus($sql, $ret_msgs, $reg_data, $reg_config);
} else {
b1n_retMsg($ret_msgs, b1n_FIZZLES, "Could not delete entries in grp_usr.");
$ret = false;
}
} else {
b1n_retMsg($ret_msgs, b1n_FIZZLES, "Could not delete entries in grp_fnc.");
$ret = false;
}
return $ret;
}
function b1n_regLoadFood($sql, &$ret_msgs, &$reg_data, $reg_config)
{
$ret = b1n_regLoad($sql, $ret_msgs, $reg_data, $reg_config, "group");
$reg_data["functions"] = array();
$reg_data["users"] = array();
/* Functions */
$query = "SELECT DISTINCT fnc_id FROM \"grp_fnc\" WHERE grp_id = '" . b1n_inBd($reg_data['id']) . "'";
$rs = $sql->query($query);
if ($rs) {
if (is_array($rs)) {
foreach ($rs as $i) {
array_push($reg_data['functions'], $i['fnc_id']);
}
}
} else {
$ret = false;
}
return $ret;
}
function b1n_logAction($action, $vars = array(), $pla_id = '', $dec_action_points = 1, $arbitrary_date = 'CURRENT_TIMESTAMP')
{
global $sql;
if (empty($pla_id)) {
if (isset($_SESSION['player'])) {
$pla_id = $_SESSION['player']['pla_id'];
} else {
exit('Couldnt get pla_id, aborting');
}
}
$aux = array();
foreach ($vars as $key => $value) {
$aux[] = $key . ':' . $value;
}
$aux = implode(';', $aux);
$query = "\n INSERT INTO log (\n pla_id,\n log_action,\n log_add_dt,\n log_vars\n )\n VALUES (\n " . b1n_inBd($pla_id) . ",\n " . b1n_inBd($action) . ",\n " . $arbitrary_date . ",\n " . b1n_inBd($aux) . "\n )";
$sql->sqlQuery($query);
if ($dec_action_points > 0 && $_SESSION['player']['pla_action_points'] >= $dec_action_points) {
$query = "\n UPDATE player\n SET\n pla_action_points = pla_action_points - {$dec_action_points}\n WHERE\n pla_id = " . b1n_inBd($pla_id);
$_SESSION['player']['pla_action_points'] -= $dec_action_points;
}
}
<?php
// $Id: handler.php,v 1.7 2003/02/15 18:04:03 binary Exp $
$page1_title = 'Handling';
// Getting handler ID of the airport of the Last checked Leg
$query = "\n SELECT\n hdl_id\n FROM\n \"leg\"\n JOIN \"airport\" ON (leg.apt_id_arrive = airport.apt_id)\n WHERE\n leg_id = '" . b1n_inBd($leg_id) . "'";
$rs = $sql->singleQuery($query);
if ($rs && is_array($rs)) {
$hdl_id = $rs['hdl_id'];
} else {
b1n_regGoBackExit('Could not get ID of the Handler of the last checked Leg.\\nAborting PDF Generation.');
}
// Configuration Hash
$reg_config = array("Contacts" => array("reg_data" => "contacts", "db" => "none", "check" => "fk", "type" => "select", "extra" => array("seltype" => "fk", "table" => "view_hdl_ctc", "text" => "ctc_name", "value" => "ctc_id", "name" => "contacts[]", "params" => array("multiple" => ""), "where" => "hdl_id = '" . b1n_inBd($hdl_id) . "'"), "mand" => true), "Request" => array("reg_data" => "services", "db" => "none", "check" => "fk", "type" => "select", "extra" => array("seltype" => "fk", "table" => "service", "text" => "srv_name", "value" => "srv_id", "name" => "services[]", "params" => array("multiple" => ""), "where" => "srv_provider = 'H'"), "mand" => true), "Remarks" => array("reg_data" => "remarks", "db" => "Remarks", "check" => "none", "type" => "text", "extra" => array("size" => b1n_DEFAULT_SIZE, "maxlen" => b1n_DEFAULT_MAXLEN), "mand" => false));
// 4d - Extra2
// 5 - Services Requested
// 6 - Pax Manifest
// 7 - Itinerary Piece
$pdf_data = array();
// Getting Data to Build the Document
// -----------------------------------------------------------------
// Getting 1, 2, 3 and 4 From the DataBase
$data = $sql->singleQuery("SELECT * FROM \"view_permit_request\" WHERE leg_id = '" . $leg_id . "'");
if (!is_array($data)) {
b1n_regGoBackExit('Could not get data from view_permit_request.\\nAborting PDF Generation');
}
// Contacts
$query = "\n SELECT\n ctc_name\n FROM\n \"view_pmt_ctc\"\n WHERE\n pmt_id = '" . $pmt_id . "' AND (ctc_id IS NULL";
foreach ($reg_data['contacts'] as $c) {
$query .= " OR ctc_id = '" . b1n_inBd($c) . "'";
}
$query .= ") LIMIT " . b1n_PDF_PMT_MAX_CTC;
$rs = $sql->query($query);
if ($rs && is_array($rs)) {
$pdf_data['contacts'] = $rs[0]['ctc_name'];
array_shift($rs);
foreach ($rs as $r) {
$pdf_data['contacts'] .= ' / ' . $r['ctc_name'];
}
} else {
b1n_regGoBackExit('Could not get contacts for this Permit.\\nAborting PDF Generation.');
}
// Service
$query = "\n SELECT\n srv_name\n FROM\n \"service\"\n WHERE\n srv_provider = 'P' AND\n srv_id = '" . $reg_data['service'] . "'";
$rs = $sql->singleQuery($query);
$query .= ") LIMIT " . b1n_PDF_HDL_MAX_CTC;
$rs = $sql->query($query);
if ($rs && is_array($rs)) {
$pdf_data['contacts'] = $rs[0]['ctc_name'];
array_shift($rs);
foreach ($rs as $r) {
$pdf_data['contacts'] .= ' / ' . $r['ctc_name'];
}
} else {
b1n_regGoBackExit('Could not get contacts for this Handler.\\nAborting PDF Generation.');
}
// Services
$pdf_data['services'] = implode(', ', $reg_data['services']);
$query = "\n SELECT\n srv_name\n FROM\n \"service\"\n WHERE\n srv_provider = 'H' AND (srv_id IS NULL";
foreach ($reg_data['services'] as $s) {
$query .= " OR srv_id = '" . b1n_inBd($s) . "'";
}
$query .= ") LIMIT " . b1n_PDF_HDL_MAX_SRV;
$rs = $sql->query($query);
if ($rs && is_array($rs)) {
$pdf_data['services'] = $rs[0]['srv_name'];
array_shift($rs);
foreach ($rs as $r) {
$pdf_data['services'] .= ', ' . $r['srv_name'];
}
} else {
b1n_regGoBackExit('Could not get services for this Handler.\\nAborting PDF Generation.');
}
// Remarks
$pdf_data['remarks'] = $reg_data['remarks'];
// Itinerary
function b1n_permNewPlayer($login, $passwd, $email, $seccode, $master)
{
global $sql, $lang;
$seccode = b1n_crypt($seccode);
if (!b1n_cmp($seccode, $_SESSION['seccode'])) {
$msg = b1n_decrypt($seccode);
$msg .= ' != ';
$msg .= b1n_decrypt($_SESSION['seccode']);
b1n_retMsg($lang['login_err_wrong_code'], array('{code}' => $msg));
return false;
}
if (b1n_permCheckNewPlayer($login, $passwd, $email, $master)) {
$query = '
SELECT
func_newPlayer(
' . b1n_inBd($login) . ',
' . b1n_inBd(b1n_crypt($passwd)) . ',
' . b1n_inBd($email) . ',
' . b1n_inBd($master) . ') AS ret';
$rs = $sql->sqlSingleQuery($query);
$rs['ret'] = b1n_checkTrue($rs['ret']);
if ($rs['ret']) {
b1n_retMsg($lang['unexpected']);
}
return $rs['ret'];
}
return false;
}
<?php
// $Id: gedec.php,v 1.1 2003/06/20 19:44:13 mmr Exp $
$page1_title = 'General Declaration';
// Configuration Hash
$reg_config = array("Illness" => array("reg_data" => "illness", "db" => "none", "check" => "fk", "type" => "select", "extra" => array("seltype" => "fk", "table" => "view_leg_pax", "text" => "pax_cts_name", "value" => "pax_id", "name" => "illness[]", "params" => array("multiple" => ""), "where" => "leg_id = '" . b1n_inBd($leg_id) . "'"), "mand" => false), "Conditions" => array("reg_data" => "condition", "db" => "Condition", "check" => "none", "type" => "text", "extra" => array("size" => b1n_DEFAULT_SIZE, "maxlen" => b1n_DEFAULT_MAXLEN), "mand" => false), "Disinsecting" => array("reg_data" => "disinsecting", "db" => "Disinsecting", "check" => "none", "type" => "text", "extra" => array("size" => b1n_DEFAULT_SIZE, "maxlen" => b1n_DEFAULT_MAXLEN), "mand" => false), "Remarks" => array("reg_data" => "remarks", "db" => "Remarks", "check" => "none", "type" => "text", "extra" => array("size" => b1n_DEFAULT_SIZE, "maxlen" => b1n_DEFAULT_MAXLEN), "mand" => false));
echo $page1_title . " - " . ucfirst($action1);
?>
</td>
</tr>
<tr>
<td class="retfizzles" colspan="3" align='center'>
<i>Items with the '<b>*</b>' are mandatory</i><br />
<i>At least, one item must have its quantity greater than 0.</i>
</td>
</tr>
<tr>
<td class='formitem' width='1'>*</td>
<td class='formitem'>Contacts</td>
<td class='forminput'>
<?php
echo b1n_buildSelectCommon($sql, 'contacts[]', 'ctc_id', 'ctc_name', 'view_cat_ctc', $reg_data['contacts'], array('multiple' => ''), 'cat_id = \'' . b1n_inBd($cat_id) . '\'');
?>
</td>
</tr>
<tr>
<td class='formitem' colspan='3'> </td>
</tr>
<tr>
<td class='formitem' colspan='2' align='center' style='font-weight: bold'>Item</td>
<td class='formitem' align='center' style='font-weight: bold'>Quantity</td>
</tr>
<?php
$last_fdt = '';
foreach ($fdt_fod as $f) {
$input_name = 'qtd_' . $f['fdt_id'] . '_' . $f['fod_id'];
if ($last_fdt != $f['fdt_id']) {
function b1n_regSearchLeg($sql, $search_config, $search)
{
$ret["select_fields"] = $search_config["select_fields"];
$ret["possible_fields"] = $search_config["possible_fields"];
$ret["possible_quantities"] = $search_config["possible_quantities"];
// ---------------------- Checking and Session storing ----------------
if (!b1n_checkSearch($search, $ret, $search_config["session_hash_name"], true)) {
$ret["search"] = $search;
return $ret;
}
$ret["search"] = $search;
$_SESSION["search"][$search_config["session_hash_name"]] = $search;
// ---------------------- WHERE ---------------------------
switch ($search["search_field"]) {
case "apt_name_depart":
$field = "\n CASE WHEN (apt_depart.apt_icao IS NOT NULL) THEN\n apt_depart.apt_name || ' (' || apt_depart.apt_icao || ')'\n ELSE\n apt_depart.apt_name\n END";
break;
case "apt_name_arrive":
$field = "\n CASE WHEN (apt_arrive.apt_icao IS NOT NULL) THEN\n apt_arrive.apt_name || ' (' || apt_arrive.apt_icao || ')'\n ELSE \n apt_arrive.apt_name\n END";
break;
default:
$field = $search["search_field"];
break;
}
// ---------------------- LIMIT & OFFSET ----------------
if ($search["search_quantity"] == 'all') {
$ret['pg_actual'] = 1;
$ret['pg_pages'] = 1;
$limit_quantity = 0;
$limit_offset = 0;
} else {
$query = "\n SELECT DISTINCT\n COUNT(leg_id)\n FROM\n \"leg\"\n LEFT OUTER JOIN \"airport\" apt_depart ON (apt_id_depart = apt_depart.apt_id)\n LEFT OUTER JOIN \"airport\" apt_arrive ON (apt_id_arrive = apt_arrive.apt_id)\n WHERE " . $field . " ILIKE '%" . b1n_inBd($search['search_text']) . "%'";
$rs_count = $sql->singleQuery($query);
$ret["pg_pages"] = max(1, ceil($rs_count["count"] / $search["search_quantity"]));
if ($search["pg_actual"] > $ret["pg_pages"]) {
$search["pg_actual"] = $ret["pg_pages"];
}
$ret["pg_actual"] = $search["pg_actual"];
$limit_quantity = $search['search_quantity'];
$limit_offset = ($search['pg_actual'] - 1) * $search['search_quantity'];
}
// ---------------------- DB Search ---------------------------
$query = "\n SELECT\n *\n FROM\n func_list_leg (\n '" . b1n_inBd($field) . "', \n '" . b1n_inBd($search["search_text"]) . "', \n '" . $search["search_order"] . "', \n '" . $search["search_order_type"] . "', \n '" . $limit_quantity . "',\n '" . $limit_offset . "'\n )\n AS \n (\n apt_name_depart text,\n apt_name_arrive text,\n apt_timezone_depart text,\n apt_timezone_arrive text,\n\n leg_etd_dt text,\n leg_etd_localtime_dt text,\n \n leg_ete_i interval,\n\n leg_eta_dt text,\n leg_eta_localtime_dt text,\n leg_groundtime_i interval,\n\n id integer,\n leg_trip integer,\n leg_distance integer,\n leg_wind integer,\n leg_fuel integer,\n leg_remarks text\n )";
$ret["result"] = $sql->query($query);
return $ret;
}
<?php
/* $Id: index.php,v 1.3 2002/12/23 13:57:53 binary Exp $ */
b1n_getVar("id", $id);
if (!b1n_checkNumeric($id)) {
?>
<script language='JavaScript'>
history.go(-1);
window.alert('ID is missing.\nDownload aborted.');
</script>
<?php
exit;
}
$query = "SELECT fil_fake_name FROM \"file\" WHERE fil_id = '" . b1n_inBd($id) . "'";
$rs = $sql->singleQuery($query);
if (!$rs) {
?>
<script language='JavaScript'>
history.go(-1);
window.alert('ID Not Registered.\nDownload Aborted.');
</script>
<?php
exit;
}
$fil_fake = $rs['fil_fake_name'];
$fil_real = b1n_UPLOAD_DIR . "/fil_" . $id;
if (is_readable($fil_real)) {
header("Content-Type: octet/stream");
//header("Content-Length: ...");
header("Content-Disposition: attachment; filename=" . $fil_fake);
readfile($fil_real);
function b1n_regCheckRelationship($sql, &$ret_msgs, $ids, $rel, $table, $col_id, $col_name, $msg)
{
if (!is_array($rel)) {
b1n_retMsg($ret_msgs, b1n_FIZZLES, 'Rel is not an Array.');
return false;
}
$ret = true;
foreach ($ids as $id) {
foreach ($rel as $d) {
$query = '
SELECT
' . $d['col_name'] . '
FROM
"' . $d['table'] . '"
WHERE
' . $d['col_ref_id'] . ' = \'' . b1n_inBd($id) . '\'';
$rs = $sql->singleQuery($query);
if (is_array($rs) && sizeof($rs)) {
$rs2 = $sql->singleQuery('
SELECT
' . $col_name . '
FROM
"' . $table . '"
WHERE
' . $col_id . ' = \'' . b1n_inBd($id) . '\'');
$msg = 'You cannot delete the <b><i>' . $rs2[$col_name] . '</i> ' . $msg . '</b> because it is still refered by the <b><i>' . $rs[$d['col_name']] . '</i> ' . $d['title'] . '</b>';
if (!empty($d['as'])) {
$msg .= ' as <b>' . $d['as'] . '</b>';
}
$msg .= '.<br />Process Aborted';
b1n_retMsg($ret_msgs, b1n_FIZZLES, $msg);
$ret = false;
break 2;
}
}
}
return $ret;
}
function b1n_mapMoveCityPlayer($cit_id, $x, $y)
{
global $sql, $lang;
if ($ret = b1n_mapCheckMoveCityPlayer($cit_id, $x, $y)) {
// Updating User data
$query = "\n UPDATE player SET\n cit_id = " . b1n_inBd($cit_id) . "\n WHERE\n pla_id = " . b1n_inBd($_SESSION['player']['pla_id']);
if ($sql->sqlQuery($query)) {
// Updating session data
$_SESSION['player']['cit_id'] = $cit_id;
$_SESSION['player']['cit_code'] = $ret['cit_code'];
$_SESSION['player']['cit_pos_x0'] = $ret['cit_pos_x0'];
$_SESSION['player']['cit_pos_x1'] = $ret['cit_pos_x1'];
$_SESSION['player']['cit_pos_y0'] = $ret['cit_pos_y0'];
$_SESSION['player']['cit_pos_y1'] = $ret['cit_pos_y1'];
$_SESSION['player']['cit_cols'] = ($ret['cit_pos_x1'] - $ret['cit_pos_x0'] - 2) / 2;
$_SESSION['player']['cit_rows'] = ($ret['cit_pos_y1'] - $ret['cit_pos_y0'] - 2) / 2;
$_SESSION['player']['pla_pos_x'] = $x;
$_SESSION['player']['pla_pos_y'] = $y;
} else {
$ret = false;
b1n_retMsg($lang['unexpected']);
}
} else {
b1n_retMsg($lang['map_move_illegal']);
}
return $ret;
}
<?php
/* $Id: list.php,v 1.3 2002/12/21 18:16:32 binary Exp $ */
$search_config = array('possible_fields' => array('Name' => 'lnk_name', 'URL' => 'lnk_url', 'Desc' => 'lnk_desc'), 'select_fields' => array('Name' => 'lnk_name', 'URL' => 'lnk_url', 'Desc' => 'lnk_desc'), 'possible_quantities' => array('10' => '10', '20' => '20', '30' => '30', '50' => '50', '100' => '100'), 'session_hash_name' => 'link', 'table' => 'link', 'id_field' => 'lnk_id');
b1n_getVar('search_text', $search['search_text']);
b1n_getVar('search_field', $search['search_field']);
b1n_getVar('search_order', $search['search_order']);
b1n_getVar('search_order_type', $search['search_order_type']);
b1n_getVar('search_quantity', $search['search_quantity']);
b1n_getVar('pg_actual', $search['pg_actual']);
$where_plus = " AND usr_id = '" . b1n_inBd($_SESSION['user']['usr_id']) . "' ";
$search = b1n_search($sql, $search_config, $search, true, $where_plus);
?>
<center>
<br />
<br />
<table cellspacing="0" cellpadding="0" class="maintable">
<tr>
<td>
<table cellspacing="1" cellpadding="5" class="inttable">
<tr>
<td class="box" colspan="2"><?php
echo $page1_title;
?>
- Search</td>
</tr>
<tr>
<td class='formitem'>Search Field
<form method="post" name="form_search" action="<?php
echo b1n_URL;
?>
b1n_getVar("last_leg_id", $reg_data['last_leg_id']);
if (!b1n_checkNumeric($reg_data['last_leg_id'], true)) {
$query = "SELECT leg_id FROM \"leg\" ORDER BY leg_keeptrack_dt DESC";
$rs = $sql->singleQuery($query);
if ($rs && is_array($rs)) {
$reg_data['last_leg_id'] = $rs['leg_id'];
} else {
// Prolly very first leg, so, ETD is mandatory
$reg_config['ETD']['mand'] = true;
}
}
}
$colspan = 3;
$disable_etd_dt = false;
if (!empty($reg_data['last_leg_id']) && b1n_checkNumeric($reg_data['last_leg_id'])) {
$query = "\n SELECT\n acf_id,\n apt_id_depart,\n apt_id_arrive,\n\n leg_groundtime_i IS NOT NULL AS leg_groundtime_i,\n leg_keeptrack_dt::timestamp\n +\n CASE WHEN (leg_ete_i IS NULL) THEN\n '00:00'::interval\n ELSE\n leg_ete_i::interval\n END\n +\n CASE WHEN (leg_groundtime_i IS NULL) THEN\n '00:00'::interval\n ELSE\n leg_groundtime_i::interval\n END AS leg_keeptrack_dt,\n\n cmb_id_pic,\n cmb_id_sic,\n cmb_id_extra1,\n cmb_id_extra2\n FROM\n \"leg\" \n WHERE\n leg_id = '" . b1n_inBd($reg_data['last_leg_id']) . "'";
$rs = $sql->singleQuery($query);
switch ($action0) {
case 'getdefaults':
// Pax List from Last Leg
$reg_data['paxs'] = b1n_regDefaultLegPaxList($sql, $reg_data['last_leg_id']);
if ($rs && is_array($rs)) {
// Default depart airport is the Last Arrive Airport
$reg_data['apt_id_depart'] = $rs['apt_id_arrive'];
// Default arrive airport is the Last Depart Airport
$reg_data['apt_id_arrive'] = $rs['apt_id_depart'];
// Default Depart date is keeptrack
// $reg_data['leg_etd_dt'] = b1n_formatDateHourFromDb($rs['leg_keeptrack_dt']);
// PIC/SIC/Extra1/Extra2 from Last Leg
$reg_data['cmb_id_pic'] = $rs['cmb_id_pic'];
$reg_data['cmb_id_sic'] = $rs['cmb_id_sic'];
<?php
/* $Id: change.php,v 1.13 2004/09/28 22:35:22 mmr Exp $ */
$disable_etd_dt = false;
$colspan = 3;
// Checking if that is the first time
if (empty($reg_data['leg_etd_dt']) || empty($reg_data['leg_etd_dt']['year'])) {
$reg_data['leg_etd_dt'] = b1n_formatDateHourFromDb($reg_data['leg_keeptrack_dt']);
}
// Checking if last leg has groundtime
$query = "\n SELECT\n leg_id as last_leg_id,\n leg_groundtime_i IS NOT NULL AS have_groundtime\n FROM\n \"leg\"\n WHERE\n leg_keeptrack_dt < '" . b1n_inBd(b1n_formatDateHour($reg_data['leg_etd_dt'])) . "'\n ORDER BY\n leg_keeptrack_dt DESC";
$rs = $sql->singleQuery($query);
if ($rs && is_array($rs)) {
$reg_data['last_leg_id'] = $rs['last_leg_id'];
if ($rs['have_groundtime'] == 't') {
// Yes, it has, disable etd_dt select box
$disable_etd_dt = true;
}
} else {
// Prolly very first leg, so, ETD is mandatory
$reg_config['ETD']['mand'] = true;
}
// Seeing if we have to check for leg similarity
if ($action0 == 'similarleg' && b1n_checkNumeric($reg_data['apt_id_depart'], true) && b1n_checkNumeric($reg_data['apt_id_arrive'], true)) {
$aux = b1n_regDefaultLegSearchSimilar($sql, $reg_data['apt_id_depart'], $reg_data['apt_id_arrive']);
if ($aux) {
list($reg_data['leg_ete_i'], $reg_data['leg_distance'], $reg_data['leg_fuel']) = explode('|', $aux);
unset($aux);
if ($reg_data['leg_fuel'] === 0) {
$reg_data['leg_fuel'] = '';
}
