}
if (isset($_GET['pilot'])) {
$arr = explode(',', $_GET['pilot']);
$arr_pilots = array();
foreach ($arr as $val) {
// Remove 0 external ids since that matches all pilots with no id.
if ((int) $val) {
$arr_pilots[] = (int) $val;
}
}
$qry->execute("SELECT plt_id FROM kb3_pilots WHERE plt_externalid IN (" . implode(',', $arr_pilots) . ")");
if (!$qry->recordCount()) {
show($sxe);
}
while ($row = $qry->getRow()) {
$list->addCombinedPilot($row['plt_id']);
}
}
if (isset($_GET['alliancename'])) {
$_GET['alliancename'] = '"' . str_replace(',', '","', $qry->escape(urldecode($_GET['alliancename']))) . '"';
$qry->execute("SELECT all_id FROM kb3_alliances WHERE all_name IN (" . $_GET['alliancename'] . ")");
if (!$qry->recordCount()) {
show($sxe);
}
while ($row = $qry->getRow()) {
$list->addCombinedAlliance($row['all_id']);
}
}
if (isset($_GET['corpname'])) {
$_GET['corpname'] = '"' . str_replace(',', '","', $qry->escape(urldecode($_GET['corpname']))) . '"';
$qry->execute("SELECT crp_id FROM kb3_corps WHERE crp_name IN (" . $_GET['corpname'] . ")");
