1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
<?php
// $Id: event.php,v 1.2 2007-05-11 16:32:24 dpage Exp $
// Event details
class Page_Event extends PgPage {
private $id;
function __construct($id) {
$this->id = intval($id);
$this->navsection = 'about';
$this->content_template = 'about/event.html';
}
function Render() {
$rs = $this->pg_query_params("SELECT posted, posted_by, start_date, end_date, COALESCE(training,false) AS training, COALESCE(et1.event, et2.event) AS event, COALESCE(et1.summary,et2.summary) AS summary, COALESCE(et1.details, et2.details) AS details, city, state, c.name AS country FROM events e INNER JOIN events_location el ON e.id=el.eventid INNER JOIN countries c ON el.country=c.id INNER JOIN events_text et2 ON e.id=et2.eventid LEFT JOIN (SELECT eventid,event,summary,details FROM events_text WHERE language=$1) et1 ON et1.eventid=e.id WHERE e.approved AND e.id=$2 AND et2.language='en'", array($this->language, $this->id));
if (pg_num_rows($rs) != 1) {
throw new NotFoundException('Event item not found');
}
$r = pg_fetch_assoc($rs, 0);
if (isset($r['end_date']) && $r['end_date'] != $r['start_date']) {
// both start and end date
$this->tpl->setVariable(array(
'date_start' => $r['start_date'],
'date_end' => $r['end_date']
));
}
else {
$this->tpl->setVariable('date', $r['start_date']);
}
$r['details'] = nl2br(empty($r['details'])?$r['summary']:$r['details']);
$this->tpl->setVariable($r);
$this->tpl->setVariable('location', $this->format_location($r));
$this->tpl->setVariable('title_location', $this->format_location($r));
$this->tpl->setVariable('title_event', $r['event']);
if ($r['training'] == 't') {
$this->tpl->touchBlock('event_is_training');
}
}
}
?>
|
