Example #1
0
 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());
 }
Example #2
0
 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);
 }