PHP this_week Examples

Example #1

File: show_corp.php Project: Covert-Inferno/fortissimo

<?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);

Example #2

File: index.php Project: Covert-Inferno/fortissimo

<?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));