return $ft->errorpage('Invalid ranking criteria.');
}
# now do the select
$results = array();
$maxct = 0;
$v = array('week' => this_week(), 'month' => this_month(), 'year' => this_year(), 'ever' => 0);
foreach (array_keys($v) as $when) {
$data = $ft->dbh->_select_rows_as_objects("SELECT var1, {$by} AS 'val' FROM tbl:stats WHERE type = ? AND dtype = ? AND var2 = ? " . "AND {$by} > 0 ORDER BY {$by} DESC LIMIT 25", array($which, $when, $v[$when]));
if ($data) {
# 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));
# get parameters
$which = $_GET['which'];
$type = $_GET['type'];
$pilotid = $_GET['pilotid'];
if ($which != 'k' && $which != 'v') {
return $ft->errorpage("Sorry, bad input.");
}
if ($type != 'kill' && $type != 'loss') {
return $ft->errorpage("Sorry, bad input.");
}
if (!is_numeric($pilotid) || $pilotid <= 0) {
return $ft->errorpage("Sorry, bad input.");
}
# sql to get everything
$col = $which . '_pilotid';
$killids = $ft->dbh->_select_column("SELECT killid FROM tbl:summary WHERE {$col} = ? AND type = ? ORDER BY killtime DESC", array($pilotid, $type));
$kills = load_kills_by_id($killids);
# now prepare the page
$ft->assign('pilot', get_pilot_link($pilotid));
$ft->assign('kills', $kills);
if ($which == 'k') {
$whicharry = array('kill' => 'Kills', 'loss' => 'Losses');
$ft->assign('which', $whicharry[$type]);
} else {
$whicharry = array('kill' => 'Losses', 'loss' => 'Kills');
$ft->assign('which', $whicharry[$type]);
}
$ft->assign('killids', $killids);
# dump the page
$ft->title('Pilot History');
$ft->makepage('all_kills');
