|
1: 2021-07-29 (木) 13:35:08 iseki  |
| | + | *** DataBase [#v4abf387] |
| | + | - lib/dmllib.php |
| | + | #br |
| | | | |
| | + | **** count_records [#rc2a2d4a] |
| | + | $count = count_records('autoattend_sessions', 'courseid', $course->id, 'sessdate', $sdate, 'starttime', $starttime); |
| | + | |
| | + | **** get_record(s) [#z3e3f469] |
| | + | - get_record($table, $field1, $value1, $field2="", $value2="", $field3="", $value3="", $fields='*') |
| | + | if ($user = get_record('user', 'id', $USER->id)) { |
| | + | $firstname = $user->firstname; |
| | + | } |
| | + | - get_records($table, $field="", $value="", $sort="", $fields='*', $limitfrom="", $limitnum="") |
| | + | if (!$vars = get_records('autoattend_settings', 'courseid', $courseid, 'id')) { |
| | + | $vars = get_records('autoattend_settings', 'courseid', 0); // use default |
| | + | } |
| | + | |
| | + | **** get_records_sql [#r096c770] |
| | + | $qey = "SELECT * FROM ......."; |
| | + | if ($users = get_records_sql($qry)) { |
| | + | foreach($users as $key => $user) { |
| | + | $return['id'] = $user->id; |
| | + | $return['attsid'] = $user->attsid; |
| | + | ............................. |
| | + | } |
| | + | } |
| | + | |
| | + | **** update_record, insert_record [#bfdf5685] |
| | + | $update = false; |
| | + | if ($rec = get_record('autoattend_settings', 'courseid', $course->id, 'status', $status[$i])) { |
| | + | $update = true; |
| | + | } |
| | + | $rec->courseid = $course->id; |
| | + | ............................ |
| | + | if ($update) { |
| | + | $result = update_record('autoattend_settings', $rec); |
| | + | } |
| | + | else { |
| | + | $result = insert_record('autoattend_settings', $rec); |
| | + | } |
| | + | unset($rec); |
| | + | |
| | + | **** delete_records [#u570f164] |
| | + | delete_records('autoattend_settings', 'courseid', $course->id); |
| | + | |
| | + | **** XMLDB [#yaa09041] |
| | + | - http://dev.moodle.org/mod/resource/view.php?id=48 |
| | + | - block にディレクトリを作成し，その中に dbディレクトリを作る． |
| | + | - 「サイト管理」→「その他」→「XMLDBエディタ」 でデータベース定義用の db/install.xml を作成する． |
| | + | #br |
