# now convert the data to something useful
$out = array();
$ct = 0;
foreach ($data as $row) {
$ct++;
if ($which == 'pilot') {
array_push($out, array(get_pilot_link($row->var1), $row->val));
} elseif ($which == 'system') {
$sys = new EVESystem($row->var1);
array_push($out, array($sys->getLink() . ' (<span style="color: ' . security_color($sys->getSecurity()) . ';">' . security($sys->getSecurity()) . '</span>)', $row->val));
} elseif ($which == 'corp') {
array_push($out, array(get_corp_link($row->var1), $row->val));
} elseif ($which == 'alliance') {
array_push($out, array(get_alliance_link($row->var1), $row->val));
} elseif ($which == 'region') {
array_push($out, array(EVERegion::getLink($row->var1), $row->val));
} elseif ($which == 'group') {
array_push($out, array(get_group_link($row->var1), $row->val));
} elseif ($which == 'ship') {
array_push($out, array(get_ship_link($row->var1), $row->val));
} elseif ($which == 'weapon') {
array_push($out, array(get_item_link($row->var1), $row->val));
}
}
if ($maxct < $ct) {
$maxct = $ct;
}
$results[$when] = $out;
} else {
$results[$when] = array();
}
array_push($criteria, 'systemid = ?');
array_push($bind, $systemid);
array_push($args, "systemid={$systemid}");
array_push($message, "in <strong>" . EVESystem::getName($systemid) . "</strong>");
}
if (is_numeric($weaponid) && $weaponid > 0) {
array_push($criteria, 'weaponid = ?');
array_push($bind, $weaponid);
array_push($args, "weaponid={$weaponid}");
array_push($message, "with a <strong>" . get_item_name($weaponid) . "</strong>");
}
if (is_numeric($regionid) && $regionid > 0) {
array_push($criteria, 'regionid = ?');
array_push($bind, $regionid);
array_push($args, "regionid={$regionid}");
array_push($message, "in <strong>" . EVERegion::getName($regionid) . "</strong>");
}
if (is_numeric($groupid) && $groupid > 0) {
array_push($criteria, '(v_groupid = ? OR k_groupid = ?)');
array_push($bind, $groupid, $groupid);
array_push($args, "groupid={$groupid}");
array_push($message, "by group <strong>" . get_group_name($groupid) . "</strong>");
}
if (is_numeric($corpid) && $corpid > 0) {
array_push($criteria, '(v_corpid = ? OR k_corpid = ?)');
array_push($bind, $corpid, $corpid);
array_push($args, "corpid={$corpid}");
array_push($message, "by corp <strong>" . get_corp_name($corpid) . " [" . get_corp_ticker($corpid) . "]</strong>");
}
if (is_numeric($allianceid) && $allianceid > 0) {
array_push($criteria, '(v_allianceid = ? OR k_allianceid = ?)');
function getRegionName()
{
return EVERegion::getName($this->RegionId);
}
