function getMarriagePlaces(&$locations, $person = null) { global $tblprefix, $strEvent, $currentRequest; $pquery = "select relation.event_id," . PersonDetail::getFields("groom", "ng", "bg", "dg") . "," . PersonDetail::getFields("bride", "nb", "bb", "db") . "," . Event::getFields("e") . ", relation.dissolve_date, relation.dissolve_reason," . " DATE_FORMAT(relation.dissolve_date, " . $currentRequest->datefmt . ") AS DOD " . "," . Location::getFields("l") . " FROM " . $tblprefix . "event e" . " JOIN " . $tblprefix . "spouses relation ON relation.event_id=e.event_id" . " JOIN " . $tblprefix . "locations l ON e.location_id=l.location_id " . " LEFT JOIN " . $tblprefix . "people bride ON relation.bride_id = bride.person_id " . " LEFT JOIN " . $tblprefix . "people groom ON relation.groom_id = groom.person_id " . PersonDetail::getJoins("LEFT", "groom", "ng", "bg", "dg") . PersonDetail::getJoins("LEFT", "bride", "nb", "bb", "db") . " WHERE (e.etype = " . BANNS_EVENT . " OR e.etype=" . MARRIAGE_EVENT . ") AND e.location_id is not null"; $pquery .= $this->addPersonRestriction(" AND ", "bg", "dg"); $pquery .= $this->addPersonRestriction(" AND ", "bb", "db"); if ($locations->location_id > 0) { $pquery .= " AND l.location_id = " . $locations->location_id; } $presult = $this->runQuery($pquery, ""); while ($row = $this->getNextRow($presult)) { $rel = new Relationship(); $rel->person->loadFields($row, L_HEADER, "groom_"); $rel->person->name->loadFields($row, "ng_"); $rel->person->setPermissions(); $rel->relation->loadFields($row, L_HEADER, "bride_"); $rel->relation->name->loadFields($row, "nb_"); $rel->relation->setPermissions(); $rel->loadFields($row); $rel->event = new Event(); $rel->event->loadFields($row, "e_"); $rel->event->location->loadFields($row, "l_"); $rel->event->location->setPermissions(); $text = $rel->person->getLink() . ' ' . $strEvent[$row["e_etype"]] . ' ' . $rel->relation->getLink() . ' ' . $rel->event->getDate1(); if ($rel->isViewable()) { $p = $this->createPlace($locations, $rel->event->location, $text); if ($p != null) { $p->marriage = true; } } } $this->freeResultSet($presult); }