<?php
class DbDatabase {
const QUESTION_TABLE='Questions';
const TOURNAMENT_TABLE='Tournaments';
public function getTournament($id) {
if (is_numeric($id)) {
return $this->getTournamentByDatabaseId($id);
} else {
return $this->getTournamentByTextId($id);
}
}
public function getTournamentByDatabaseId($id){
$sql = sprintf ("SELECT * FROM %s t
WHERE t.Id = '%d'", self::TOURNAMENT_TABLE, $id);
$res = db_query($sql);
return db_fetch_object($res);
}
public function getTournamentByTextId($id){
if (!preg_match('/\./', $id)) {
$id .= '.txt';
}
$sql = sprintf ("SELECT * FROM %s t
WHERE t.FileName = '%s'", self::TOURNAMENT_TABLE, $id);
$res = db_query($sql);
return db_fetch_object($res);
}
public function getQuestionsRes($id) {
$sql = sprintf("SELECT * FROM {%s} WHERE ParentId=%d", self::QUESTION_TABLE, $id);
return db_query($sql);
}
public function getToursRes($id) {
$sql = sprintf("SELECT * FROM {%s} WHERE ParentId=%d", self::TOURNAMENT_TABLE, $id);
return db_query($sql);
}
public function fetch_row($res) {
return db_fetch_object($res);
}
}
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>