function getEventSources(&$event)
{
global $tblprefix, $restrictdate, $strEvent, $datefmt;
$event->numResults = 0;
$pquery = "SELECT s.source_id as s_source_id, " . Source::getFields("s") . " FROM " . $tblprefix . "source s" . " JOIN " . $tblprefix . "source_event se ON s.source_id=se.source_id";
if ($event->event_id > 0) {
$pquery .= " AND se.event_id = " . $event->event_id;
} else {
return;
}
$presult = $this->runQuery($pquery, "");
while ($row = $this->getNextRow($presult)) {
$s = new Source();
$s->source_id = $row["s_source_id"];
$s->loadFields($row, "s_");
$event->results[] = $s;
$event->numResults++;
}
$this->freeResultSet($presult);
}
