Example #1
0
<?php

require_once '../../../protected/config.php';
require_once config::servroot() . "/protected/smarty/template.php";
$template = new template();
require_once config::servroot() . "/protected/db/dbview.php";
$dbh = new dbview();
// Find the tournament specified by the URL
$sres = $dbh->get('select count(*) as many
from tournaments
where id = :id
and year = :year
and aka = :aka', array(':id' => $_GET['id'], ':aka' => $_GET['aka'], ':year' => $_GET['year']));
if (0 == $sres[0]['many']) {
    error_log("Can't find series: aka: {$_GET['aka']}, id: {$_GET['id']}, year: {$_GET['year']}");
    // Find all tournaments with a given aka
    $akaAll = 'select 
tournaments.name as name, 
tournaments.year, 
tournaments.id, 
start,
host,
schools.name as sname
from tournaments
left join schools
on host = schools.id
and tournaments.year = schools.year
where tournaments.aka = :aka
order by start desc, tournaments.name';
    // All tournaments witht eh aka given by the URL
    $akaGrp = $dbh->get($akaAll, array(':aka' => $_GET['aka']));
Example #2
0
<?php

require_once '../../protected/config.php';
//require_once('../../protected/error-init.php');
require_once config::servroot() . "/protected/smarty/template.php";
$template = new template();
require_once config::servroot() . "/protected/db/dbview.php";
$dbh = new dbview();
// avg simply ignored nulls
$torder = $dbh->get('select aka,
avg(if(datediff(start,makedate(year(start),210)) < 0, 
datediff(start,makedate(year(start),210)) + 365.24, 
datediff(start,makedate(year(start),210)))) as days
from tournaments 
group by aka 
order by days');
$tyStmt = $dbh->prepare('
set @year = :year;
select year, id, name
from tournaments
where ((datediff(start, makedate(@year - 1,210)) > 0
and datediff(start, makedate(@year - 1,210)) < 364)
or (start is null
and year = @year))
and aka = :aka
order by name');
foreach ($torder as $key => $trn) {
    $list = null;
    $recentYear = null;
    $recentID = null;
    for ($year = config::lastyear(); $year >= config::firstyear(); --$year) {