function b1n_checkHour($hour, $min, $mandatory = false) { if (!$mandatory && (empty($hour) && empty($min))) { return true; } $ret = b1n_checkNumeric($hour, $mandatory) && b1n_checkNumeric($min, $mandatory); $ret = $ret && ($hour >= 0 && $hour <= 23) && ($min >= 0 && $min <= 59); return $ret; }
function b1n_checkSearch(&$search, $ret, $session_hash_name, $select_first_if_none = true) { if (!isset($search["pg_actual"]) || !b1n_checkNumeric($search["pg_actual"]) || $search["pg_actual"] <= 0) { $pg_actual = 1; } else { $pg_actual = $search["pg_actual"]; } if (!isset($search["search_quantity"]) || !in_array($search["search_quantity"], $ret["possible_quantities"])) { if (isset($_SESSION["search"][$session_hash_name]["search_quantity"])) { $search["search_quantity"] = $_SESSION["search"][$session_hash_name]["search_quantity"]; } else { $search["search_quantity"] = b1n_DEFAULT_QUANTITY; } } if (!$search["search_order_type"] == 'ASC' && !$search["search_order_type"] == 'DESC') { if (isset($_SESSION["search"][$session_hash_name]["search_order_type"])) { $search["search_order_type"] = $_SESSION["search"][$session_hash_name]["search_order_type"]; } else { $search["search_order_type"] = 'ASC'; } } if (in_array($search["search_field"], $ret["possible_fields"]) && in_array($search["search_order"], $ret["select_fields"])) { return true; } else { if (isset($_SESSION["search"][$session_hash_name]["search_field"])) { $search["search_field"] = $_SESSION["search"][$session_hash_name]["search_field"]; } else { if ($select_first_if_none) { $search["search_field"] = array_shift($ret["possible_fields"]); } else { $search["search_field"] = ""; } } if (isset($_SESSION["search"][$session_hash_name]["search_order"])) { $search["search_order"] = $_SESSION["search"][$session_hash_name]["search_order"]; } else { $search["search_order"] = $search["search_field"]; } if (isset($_SESSION["search"][$session_hash_name]["search_text"])) { $search["search_text"] = $_SESSION["search"][$session_hash_name]["search_text"]; } $search["pg_actual"] = $pg_actual; } return true; }
} else { 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'];
function b1n_mapWithdraw($money) { global $sql; if (!empty($money) && b1n_checkNumeric($money) && $money > 0) { $money = (int) $money; if ($money > $_SESSION['player']['pla_bank_money']) { $money = $_SESSION['player']['pla_bank_money']; } if ($money > 0) { $query = "\n UPDATE player\n SET\n pla_money = pla_money + " . b1n_inBd($money) . ",\n pla_bank_money = pla_bank_money - " . b1n_inBd($money) . "\n WHERE\n pla_id = '" . $_SESSION['player']['pla_id'] . "'"; $rs = $sql->sqlQuery($query); if ($rs) { $aux = array('money' => $money); b1n_logAction('withdraw', $aux); $_SESSION['player']['pla_money'] += $money; $_SESSION['player']['pla_bank_money'] -= $money; } } } }
<?php // $Id: index.php,v 1.11 2003/02/19 22:51:13 binary Exp $ $ret_msgs = array(); b1n_getVar("action2", $action2); b1n_getVar("ids", $ids); if (!is_array($ids)) { $ids = explode(':', $ids); } $leg_id = $ids[sizeof($ids) - 1]; if (!b1n_checkNumeric($leg_id, true)) { b1n_regGoBackExit('Could not get ID of last leg Checked.\\nAborting PDF Generation.' . $leg_id); } switch ($action1) { case 'config': // Config PDF Generation switch ($action0) { case 'handler': case 'permit': case 'gedec': $page1_title = ''; // This require defines the $reg_config hash // And the beginning of the $page1_title require $page0 . '/' . $page1 . '/' . $action0 . '.php'; $page1_title .= ' PDF Configuration'; if ($action2 == 'generate') { $func_check = 'b1n_regPdfCheck' . ucfirst($action0); $reg_data = b1n_regExtract($reg_config); if ($func_check($sql, $ret_msgs, $reg_data, $reg_config)) { // Everything is fine, Generate PDF $action2 = 'GO';
function b1n_regDefaultLegSearchSimilar($sql, $apt_id_depart, $apt_id_arrive) { if (b1n_checkNumeric($apt_id_depart) && b1n_checkNumeric($apt_id_arrive)) { $query = "SELECT func_similar_leg('" . b1n_inBd($apt_id_depart) . "', '" . b1n_inBd($apt_id_arrive) . "') AS similar_leg"; $rs = $sql->singleQuery($query); return $rs['similar_leg']; } }
} // 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'] = ''; } $reg_data['leg_ete_i'] = b1n_formatHourFromDb($reg_data['leg_ete_i']); } } ?> <script language="JavaScript"> function b1n_verifyAirports(f) { var d = f.apt_id_depart.options[f.apt_id_depart.selectedIndex];
function b1n_regCheckChange($sql, &$ret_msgs, $reg_data, $reg_config) { $ret = true; foreach ($reg_config as $t => $r) { $msg = ""; switch ($r['check']) { case "none": if ($r['mand'] && empty($reg_data[$r['reg_data']]) && $r['type'] != 'password') { $msg = "Please, fill the <b>" . $t . "</b> field."; } break; case "numeric": if (!b1n_checkNumeric($reg_data[$r["reg_data"]], $r['mand'])) { $msg = "Invalid <b>" . $t . "</b> (Only numbers are allowed)."; } break; case "date": if (!b1n_checkDate($reg_data[$r["reg_data"]]["month"], $reg_data[$r["reg_data"]]["day"], $reg_data[$r["reg_data"]]["year"], $r['mand'])) { $msg = "Invalid date in <b>" . $t . "</b>."; } break; case "date_hour": if (!b1n_checkDate($reg_data[$r["reg_data"]]["month"], $reg_data[$r["reg_data"]]["day"], $reg_data[$r["reg_data"]]["year"], $reg_data[$r["reg_data"]]["hour"], $reg_data[$r["reg_data"]]["min"], $r['mand'])) { $msg = "Invalid date/hour in <b>" . $t . "</b>."; } break; case "email": if (!b1n_checkEmail($reg_data[$r["reg_data"]])) { $msg = "Invalid <b>" . $t . "</b> (Example: user@domain.org)."; } break; case "length": if (strlen($reg_data[$r["reg_data"]]) > $r["extra"]["maxlen"]) { $msg = "No more than '" . $r["extra"]["maxlen"] . "' characters are allowed in <b>" . $t . "</b>"; } break; case "radio": if (!b1n_checkFilled($reg_data[$r["reg_data"]])) { $msg = "Please, choose something on <b>" . $t . "</b>."; } break; case "boolean": if (!b1n_checkBoolean($reg_data[$r["reg_data"]], $r['mand'])) { $msg = "Please, choose something on <b>" . $t . "</b>."; } break; case "unique": if ($r['mand'] && empty($reg_data[$r['reg_data']])) { $msg = "Please, fill the <b>" . $t . "</b> field."; break; } $query = "SELECT " . $reg_config['ID']['db'] . " AS id FROM \"" . $r['extra']['table'] . "\" WHERE " . $r['db'] . " = '" . b1n_inBd($reg_data[$r["reg_data"]]) . "' AND " . $reg_config['ID']['db'] . " != '" . b1n_inBd($reg_data["id"]) . "'"; $rs = $sql->singleQuery($query); if (is_array($rs)) { global $page1_title; $msg = "There is already one " . $page1_title . " with this <b>" . $t . "</b>."; unset($page1_title); } break; case "fk": if (is_array($reg_data[$r['reg_data']]) && $r['mand'] && !sizeof($reg_data[$r['reg_data']])) { $msg = "Please, select something in <b>" . $t . "</b>."; } else { if (!b1n_checkNumeric($reg_data[$r["reg_data"]], $r['mand'])) { $msg = "Please, select something in <b>" . $t . "</b>."; } } break; case "hour": if (isset($reg_data[$r["reg_data"]]["hour"])) { if (!b1n_checkHour($reg_data[$r["reg_data"]]["hour"], $reg_data[$r["reg_data"]]["min"], $r["mand"])) { $msg = "Invalid Hour/Minute in <b>" . $t . "</b>."; } } break; } if (!empty($msg)) { b1n_retMsg($ret_msgs, b1n_FIZZLES, $msg); $ret = false; } } 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);