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:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>