private function loadTours() { $res = $this->db->editorToursRes($this->id); $this->tours = array(); while ($tourRow = db_fetch_object($res)) { $this->tours[] = DbPackage::newFromRow($tourRow); } }
private function getPublishedPackage() { if (NULL === $this->publishedPackage) { $db = new DbDatabase(); $t = $db->getTournamentByTextId($this->getPublishedTextId()); if ($t) { $this->publishedPackage = DbPackage::newFromRow($t); } else { $this->publishedPackage = FALSE; } } return $this->publishedPackage; }
function getDayNumbers() { if (!isset($this->dayNumbers)) { $instance = new DbDatabase(); $res = $instance->getLastTournamentsRes(50000); for ($date = $this->getFirstDate(); $date <= $this->getLastDate(); $date = date('Y-m-d', strtotime($date . ' +1 days'))) { $this->dayNumbers[$date] = 0; } while ($row = $instance->fetch_row($res)) { $package = DbPackage::newFromRow($row); $this->dayNumbers[$package->getCreatedAt()] += $package->getQuestionsNumber(); } } return $this->dayNumbers; }
public function loadChildren() { $this->children = array(); $res = $this->db->getChildrenRes($this->getDbId()); while ($row = $this->db->fetch_row($res)) { $this->children[] = DbPackage::newFromRow($row, $this); } }
public function getTour() { if (!$this->tour) { $row = $this->db->getTournament($this->question->ParentId); $this->tour = DbPackage::newFromRow($row); } return $this->tour; }
protected function makeTournamentsResults() { $factory = new DbQuestionFactory(); $this->results = array(); $words = $this->words; # $s = "~([^a-zA-Zа-яА-Я_0-9])(".implode('|', $words).")~iu"; while ($row = db_fetch_object($this->mysqlRes)) { $t = DbPackage::newFromRow($row); # $title = preg_replace($s, '$1<strong class="highlight">$2</strong>', $t->getTitle()); $title = $t->getTitle(); $date = $t->getPlayedAtDate(); $snippet = ''; $snippetArray = array(); if ($date) { $snippetArray[] = '<strong>Дата:</strong> ' . $date; } $editor = $t->getEditorHtml(); if ($editor) { $snippetArray[] = "<p>{$editor}</p>"; } $snippet = implode('<br/>', $snippetArray); $this->results[] = array('link' => url($t->getLink()), 'title' => $title, 'snippet' => "<br/>{$snippet}"); } }