<?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);
  }
}