<?php include 'lib/fortissimo.php'; # figure out what they want to filter on $corpid = $_GET['corpid']; if (!$corpid) { return $ft->errorpage('Sorry, you got to this page in an invalid way.'); } # load the pilot $corp = get_corp_name($corpid); if (!$corp) { return $ft->errorpage('Sorry, that corporation does not seem to exist.'); } # now get some interesting stats $stats = array(); $get = array('week' => this_week(), 'month' => this_month(), 'year' => this_year(), 'ever' => 0); foreach ($get as $when => $val) { $st = $ft->dbh->_select_row_as_assoc('SELECT * FROM tbl:stats WHERE type = "corp" AND var1 = ? AND dtype = ? AND var2 = ?', array($corpid, $when, $val)); $stats[$when] = $st; } # get various top 10s $ft->assign('t10weapons', get_top10('corp', $corpid, 'weapon')); $ft->assign('t10shipslost', get_top10('corp', $corpid, 'ship_lost')); $ft->assign('t10shipsdestroyed', get_top10('corp', $corpid, 'ship_killed')); $ft->assign('t10systems', get_top10('corp', $corpid, 'system')); $ft->assign('t10targets', get_top10('corp', $corpid, 'pilot')); $ft->assign('t10shipsflown', get_top10('corp', $corpid, 'ship_flown')); # get the last 50 final blows # $fbids = $ft->dbh->_select_column('SELECT killid FROM tbl:summary WHERE k_pilotid = ? AND type = "kill" ' . # 'ORDER BY killtime DESC LIMIT 10', array($pilotid)); # $fbs = load_kills_by_id($fbids);
<?php include 'lib/fortissimo.php'; # show the last 50 somethings $which = $_GET['show']; if (!$which) { $which = 'kill'; } if ($which == 'kill') { $ft->message('Last 50 Kills'); $ft->title('Last 50 Kills'); # also show the finalblows/lossrecv by group $groups = $ft->dbh->_select_rows_as_objects('SELECT var1, killrecv, lossrecv FROM tbl:stats ' . 'WHERE type = "group" AND dtype = "week" AND var2 = ?', array(this_week())); $gout = array(); if ($groups) { foreach ($groups as $grow) { $name = get_group_name($grow->var1); if ($name) { $gout[$name] = array($grow->killrecv, $grow->lossrecv, $grow->var1); } } } } elseif ($which == 'loss') { $ft->message('Last 50 Losses'); $ft->title('Last 50 Losses'); } else { $which = 'murder'; $ft->message('Last 50 Murders'); $ft->title('Last 50 Murders'); } $ids = $ft->dbh->_select_column('SELECT killid FROM tbl:summary WHERE type = ? ORDER BY killtime DESC LIMIT 50', array($which));