Return to DbDatabase.class.php CVS log

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

Annotation of db/prgsrc/drupal/modules/chgk_db/classes/DbDatabase.class.php, revision 1.1

1.1     ! roma7       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: