flagflag  
1: 2012-04-14 (Sat) 08:51:51 iseki source 2: 2012-04-14 (Sat) 09:49:00 iseki source
Line 1: Line 1:
-** Moodle1.9 Programing [#l2cb4679] +** Moodle2.x Programing [#l2cb4679] 
-- http://docs.moodle.org/dev/Blocks/Blocks_for_1.5_to_1.9+- Block: http://docs.moodle.org/en/Development:Blocks 
 + 
 +- [[1.9→2.x>../1.9→2.x]] 
 +#br 
 + 
 +*** Data Base [#xc80db23] 
 +- DB は全面的に XMLDB に移行 
 +- $DB 変数必須 
 +**** XMLDB [#yaa09041] 
 +- http://dev.moodle.org/mod/resource/view.​php?id=48 
 +- block にディレクトリを作成し,その中に dbディレクトリを作る. 
 +- 「サイト管理」→「開発」→「XMLDBエディタ」 でデータベース定義用の db/install.xml を作成する.
#br #br
*** global 変数 [#s52b390d] *** global 変数 [#s52b390d]
 +**** $DB [#c208b528]
 +- データベースにアクセスする場合は必ず必要
**** $CFG [#v460c415] **** $CFG [#v460c415]
Line 36: Line 49:
*** 権限 [#kca35ac9] *** 権限 [#kca35ac9]
-- isadmin() +- require_login($course->id) 
-- isguest() +
-- require_login($course->id); +
-- isteacher($course->id)+
#br #br
 +**** 2.x で廃止になった関数 [#c3786957]
 +- %%isadmin()%%
 +- %%isguest()%%
 +- %%isteacher($course->id)%%
- +**** 代替関数 [#iafed563] 
 +- see jbxl_moodle_tools.php 
 +#br
*** メッセージ [#pb1c2054] *** メッセージ [#pb1c2054]
 +- メッセージテーブルはローカルに持つ
 +- ja_utf-8 → ja, en_utf-8 → en
- get_string( , ) - get_string( , )
#br #br
*** DataBase [#v4abf387] *** DataBase [#v4abf387]
-- lib/dmllib.php+- lib/dml/moodle_database.php 
 +- $strictness: MUST_EXIST, IGNORE_MISSING
#br #br
-**** count_records [#rc2a2d4a] +**** $DB->count_records [#rc2a2d4a] 
- $count = count_records('autoattend_sessions', 'courseid', $course->id, 'sessdate', $sdate, 'starttime', $starttime);+ $count = $DB->count_records('autoattend_sessions', array('courseid'=>$course->id, 'sessdate'=>$sdate, 'starttime'=>$starttime));
-**** get_record(s) [#z3e3f469] +**** $DB->get_record(s) [#z3e3f469] 
-- get_record($table, $field1, $value1, $field2="", $value2="", $field3="", $value3="", $fields='*') +- $DB-> get_record($table, array $conditions, $fields='*', $strictness=IGNORE_MISSING
- if ($user = get_record("user", "id", $USER->id)) {+ if ($user = $DB->get_record('user', array('id'=>$USER->id))) {
   $firstname = $user->firstname;    $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+- $DB->get_records($table, array $conditions=null, $sort='', $fields='*', $limitfrom=0, $limitnum=0
 + if (!$vars = $DB->get_records('autoattend_settings', array('courseid'=>$courseid), 'id ASC')) { 
 +   $vars = $DB->get_records('autoattend_settings', array('courseid'=>0));      // use default
 }  }
-**** get_records_sql [#r096c770]+**** $DB->get_records_sql [#r096c770] 
 +- $DB->get_record_sql($sql, array $params=null, $strictness=IGNORE_MISSING)
 $qey = "SELECT * FROM .......";  $qey = "SELECT * FROM .......";
- if ($users = get_records_sql($qry)) {+ if ($users = $DB->get_records_sql($qry)) {
   foreach($users as $key => $user) {    foreach($users as $key => $user) {
       $return['id']      = $user->id;        $return['id']      = $user->id;
Line 76: Line 98:
 }  }
-**** update_record, insert_record [#bfdf5685]+**** $DB->update_record, $DB->insert_record [#bfdf5685]
 $update = false;  $update = false;
- if ($rec = get_record('autoattend_settings', 'courseid', $course->id, 'status', $status[$i])) {+ if ($rec = $DB->get_record('autoattend_settings', array('courseid'=>$course->id, 'status'=>$status[$i]))) {
   $update = true;    $update = true;
 }  }
Line 84: Line 106:
 ............................  ............................
 if ($update) {  if ($update) {
-     $result = update_record('autoattend_settings', $rec);+     $result = $DB->update_record('autoattend_settings', $rec);
 }  }
 else {  else {
-     $result = insert_record('autoattend_settings', $rec);+     $result = $DB->insert_record('autoattend_settings', $rec);
 }  }
 unset($rec);  unset($rec);
-**** delete_records [#u570f164] +**** $DB->delete_records [#u570f164] 
- delete_records('autoattend_settings​', 'courseid', $course->id); + ;$DB->;delete_records('autoattend_settings', array('courseid'=>$course->id));
- +
-**** XMLDB [#yaa09041] +
-- http://dev.moodle.org/mod/resource/view.​php?id=48 +
-- block にディレクトリを作成し,その中に dbディレクトリを作る. +
-- 「サイト管理」→「その他」→「XMLDBエディタ」 でデータベース定義用の db/install.xml を作成する. +
-#br+
*** ログ [#q8c98d5f] *** ログ [#q8c98d5f]


Front page   New List of Pages Search Recent changes   Help   RSS of recent changes (RSS 1.0) RSS of recent changes (RSS 2.0) RSS of recent changes (RSS Atom)

Site Search

Login

Username:

Password:


Lost Password?
Register now!!

Sub Menu

mini Calendar

Last MonthMay 2024Next Month
Su Mo Tu We Th Fr Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
Today

Who's Online

38 user(s) are online (1 user(s) are browsing xpwiki)

Members: 0
Guests: 38

more...

Access Counter

Today : 2929
Yesterday : 5790579057905790
Total : 2365282523652825236528252365282523652825236528252365282523652825
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com