| @@ 129-157 (lines=29) @@ | ||
| 126 | } |
|
| 127 | } |
|
| 128 | ||
| 129 | class BoltCourse { |
|
| 130 | static function insert($clause) { |
|
| 131 | $db = BoltDb::get(); |
|
| 132 | $ret = $db->insert('bolt_course', $clause); |
|
| 133 | if (!$ret) return $ret; |
|
| 134 | return $db->insert_id(); |
|
| 135 | } |
|
| 136 | static function lookup_id($id) { |
|
| 137 | $db = BoltDb::get(); |
|
| 138 | return $db->lookup_id($id, 'bolt_course', 'BoltCourse'); |
|
| 139 | } |
|
| 140 | static function lookup_name($name) { |
|
| 141 | $db = BoltDb::get(); |
|
| 142 | $name = BoincDb::escape_string($name); |
|
| 143 | return $db->lookup('bolt_course', 'BoltCourse', "short_name='$name'"); |
|
| 144 | } |
|
| 145 | static function enum() { |
|
| 146 | $db = BoltDb::get(); |
|
| 147 | return $db->enum('bolt_course', 'BoltCourse'); |
|
| 148 | } |
|
| 149 | function update($clause) { |
|
| 150 | $db = BoltDb::get(); |
|
| 151 | return $db->update($this, 'bolt_course', $clause); |
|
| 152 | } |
|
| 153 | function doc_file() { |
|
| 154 | $sn = $this->short_name; |
|
| 155 | return "../inc/$sn.inc"; |
|
| 156 | } |
|
| 157 | } |
|
| 158 | ||
| 159 | class BoltEnrollment { |
|
| 160 | static function insert($clause) { |
|
| @@ 36-63 (lines=28) @@ | ||
| 33 | } |
|
| 34 | } |
|
| 35 | ||
| 36 | class BoincForum { |
|
| 37 | static function insert($clause) { |
|
| 38 | $db = BoincDb::get(); |
|
| 39 | $ret = $db->insert('forum', $clause); |
|
| 40 | if (!$ret) return null; |
|
| 41 | return $db->insert_id(); |
|
| 42 | } |
|
| 43 | static function lookup_id($id) { |
|
| 44 | $db = BoincDb::get(); |
|
| 45 | return $db->lookup_id($id, 'forum', 'BoincForum'); |
|
| 46 | } |
|
| 47 | static function lookup($clause) { |
|
| 48 | $db = BoincDb::get(); |
|
| 49 | return $db->lookup('forum', 'BoincForum', $clause); |
|
| 50 | } |
|
| 51 | static function enum($clause) { |
|
| 52 | $db = BoincDb::get(); |
|
| 53 | return $db->enum('forum', 'BoincForum', $clause); |
|
| 54 | } |
|
| 55 | function update($clause) { |
|
| 56 | $db = BoincDb::get(); |
|
| 57 | return $db->update($this, 'forum', $clause); |
|
| 58 | } |
|
| 59 | function delete() { |
|
| 60 | $db = BoincDb::get(); |
|
| 61 | return $db->delete($this, 'forum'); |
|
| 62 | } |
|
| 63 | } |
|
| 64 | ||
| 65 | class BoincThread { |
|
| 66 | static function insert($clause) { |
|
| @@ 658-685 (lines=28) @@ | ||
| 655 | return $r; |
|
| 656 | } |
|
| 657 | ||
| 658 | class BoincBadge { |
|
| 659 | static function enum($where_clause) { |
|
| 660 | $db = BoincDb::get(); |
|
| 661 | return $db->enum('badge', 'BoincBadge', $where_clause); |
|
| 662 | } |
|
| 663 | static function insert($clause) { |
|
| 664 | $db = BoincDb::get(); |
|
| 665 | $ret = $db->insert('badge', $clause); |
|
| 666 | if (!$ret) return 0; |
|
| 667 | return $db->insert_id(); |
|
| 668 | } |
|
| 669 | function update($clause) { |
|
| 670 | $db = BoincDb::get(); |
|
| 671 | return $db->update($this, 'badge', $clause); |
|
| 672 | } |
|
| 673 | static function lookup_id($id) { |
|
| 674 | $db = BoincDb::get(); |
|
| 675 | return $db->lookup_id($id, 'badge', 'BoincBadge'); |
|
| 676 | } |
|
| 677 | static function lookup($clause) { |
|
| 678 | $db = BoincDb::get(); |
|
| 679 | return $db->lookup('badge', 'BoincBadge', $clause); |
|
| 680 | } |
|
| 681 | function delete() { |
|
| 682 | $db = BoincDb::get(); |
|
| 683 | return $db->delete($this, 'badge'); |
|
| 684 | } |
|
| 685 | } |
|
| 686 | ||
| 687 | class BoincBadgeUser { |
|
| 688 | static function enum($where_clause) { |
|