Return to DbDatabase.class.php CVS log

Up to [Local Repository] / db / prgsrc / drupal / modules / chgk_db / classes

Initial edition of drupal version

    1: <?php
    2: 
    3: class DbDatabase  {
    4:   const QUESTION_TABLE='Questions';
    5:   const TOURNAMENT_TABLE='Tournaments';
    6: 
    7:   public function getTournament($id) {
    8:     if (!preg_match('/\./', $id)) {
    9:       $id .= '.txt';
   10:     }
   11: 
   12:     $sql = sprintf ("SELECT * FROM {%s} t 
   13:       WHERE t.FileName = '%s'", self::TOURNAMENT_TABLE, $id);
   14:     $res = db_query($sql);    
   15:     return db_fetch_object($res);
   16:   }
   17:   
   18:   public function getQuestionsRes($id) {
   19:     $sql = sprintf("SELECT * FROM {%s} WHERE ParentId=%d", self::QUESTION_TABLE, $id);
   20:     return db_query($sql);
   21:   }
   22:   
   23:   public function fetch_row($res) {
   24:     return db_fetch_object($res);
   25:   }
   26: }
   27: