} while ($row = $qry->getRow()) { $list->addCombinedAlliance($row['all_id']); } } if (isset($_GET['corp'])) { $arr = explode(',', $_GET['corp']); foreach ($arr as &$val) { $val = intval($val); } $qry->execute("SELECT crp_id FROM kb3_corps WHERE crp_external_id IN (" . implode(',', $arr) . ")"); if (!$qry->recordCount()) { show($sxe); } while ($row = $qry->getRow()) { $list->addCombinedCorp($row['crp_id']); } } 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); }