function getSQL() { return "SELECT fg_id, fg_status, fg_status_date, ft_user, fg_gedcom_filename, fg_file_size, fg_status_reason, fg_reviewer FROM familytree, familytree_gedcom" . ' WHERE fg_tree_id = ft_tree_id' . ($this->status ? " AND fg_status={$this->status}" : ' AND ' . GedcomsPage::getInProcessCondition()); }
function inprocessGedcom() { global $wgUser; $dbr =& wfGetDB(DB_SLAVE); $res = $dbr->select(array('familytree', 'familytree_gedcom'), array('fg_id', 'fg_status'), array('fg_tree_id=ft_tree_id', 'ft_user' => $wgUser->getName(), GedcomsPage::getInProcessCondition())); $gedcomId = 0; $gedcomStatus = 0; // should be at most 1 while ($row = $dbr->fetchObject($res)) { $gedcomId = $row->fg_id; $gedcomStatus = $row->fg_status; } $dbr->freeResult($res); return array($gedcomId, $gedcomStatus); }