Moodle 4.0 XRef and Diffs

Search moodle.org's
Developer Documentation

See Release Notes

Bug fixes for general core bugs in 4.0.x will end 8 May 2023 (12 months).
Bug fixes for security issues in 4.0.x will end 13 November 2023 (18 months).
PHP version: minimum PHP 7.3.0 Note: the minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is also supported.

Moodle 4.0 Database Schema (by Marcus Green)

get_record_sql

[Top level directory]

Function and Method Cross Reference

at:

/lib/dml/oci_native_moodle_database.php -> line 1074
/lib/dml/moodle_database.php -> line 1650

Referenced 252 times:

/lib/dml/tests/dml_test.php -> line 1940
/lib/dml/tests/dml_test.php -> line 1950
/lib/dml/tests/dml_test.php -> line 1951
/lib/dml/tests/dml_test.php -> line 1955
/lib/dml/tests/dml_test.php -> line 1961
/lib/dml/tests/dml_test.php -> line 1964
/lib/dml/tests/dml_test.php -> line 1969
/lib/dml/tests/dml_test.php -> line 1973
/lib/dml/tests/dml_test.php -> line 4603
/lib/dml/tests/dml_test.php -> line 4607
/lib/dml/tests/dml_test.php -> line 4626
/lib/dml/tests/dml_test.php -> line 4630
/lib/dml/tests/dml_test.php -> line 4634
/lib/dml/tests/dml_test.php -> line 4638
/lib/dml/tests/dml_test.php -> line 4643
/login/lib.php -> line 123
/login/lib.php -> line 233
/enrol/tests/privacy/provider_test.php -> line 97
/enrol/lti/classes/data_connector.php -> line 488
/mod/wiki/locallib.php -> line 124
/mod/wiki/locallib.php -> line 211
/admin/tool/brickfield/classes/local/areas/core_question/base.php -> line 225
/lib/classes/lock/postgres_lock_factory.php -> line 175
/lib/classes/lock/postgres_lock_factory.php -> line 198
/mod/lesson/locallib.php -> line 403
/lib/questionlib.php -> line 361
/lib/questionlib.php -> line 1472
/lib/questionlib.php -> line 1918
/lib/questionlib.php -> line 2034
/lib/questionlib.php -> line 2092
/blog/lib.php -> line 728
/competency/classes/competency.php -> line 711
/mod/data/lib.php -> line 1217
/mod/data/lib.php -> line 1677
/mod/data/lib.php -> line 1783
/mod/wiki/classes/search/collaborative_page.php -> line 145
/repository/repository_callback.php -> line 49
/lib/classes/lock/mysql_lock_factory.php -> line 141
/lib/classes/lock/mysql_lock_factory.php -> line 161
/admin/tool/monitor/classes/subscription_manager.php -> line 267
/mod/assign/feedback/editpdf/classes/task/bump_submission_for_stale_conversions.php -> line 47
/competency/classes/user_competency.php -> line 477
/admin/cli/mysql_collation.php -> line 112
/admin/cli/mysql_collation.php -> line 116
/admin/cli/mysql_collation.php -> line 313
/grade/import/csv/classes/load_data.php -> line 592
/lib/filelib.php -> line 684
/user/profile/field/social/upgradelib.php -> line 115
/user/profile/field/social/upgradelib.php -> line 135
/question/type/essay/tests/restore_test.php -> line 60
/search/classes/base_block.php -> line 247
/message/classes/search/message_received.php -> line 81
/lib/filestorage/file_storage.php -> line 487
/lib/filestorage/file_storage.php -> line 508
/lib/filestorage/file_storage.php -> line 1112
/mnet/xmlrpc/serverlib.php -> line 410
/mnet/xmlrpc/serverlib.php -> line 571
/lib/tablelib.php -> line 2136
/completion/classes/api.php -> line 173
/competency/classes/template_competency.php -> line 183
/lib/dml/oci_native_moodle_database.php -> line 1101
/h5p/classes/editor_framework.php -> line 77
/mod/scorm/report/basic/classes/report.php -> line 327
/mod/scorm/report/basic/classes/report.php -> line 332
/backup/moodle2/restore_stepslib.php -> line 1205
/backup/moodle2/restore_stepslib.php -> line 1256
/backup/moodle2/restore_stepslib.php -> line 1400
/backup/moodle2/restore_stepslib.php -> line 1460
/mod/assign/locallib.php -> line 1027
/enrol/ldap/lib.php -> line 224
/enrol/ldap/lib.php -> line 584
/enrol/ldap/lib.php -> line 602
/enrol/ldap/lib.php -> line 613
/admin/tool/mobile/lib.php -> line 106
/question/editlib.php -> line 38
/question/bank/tagquestion/classes/external/submit_tags.php -> line 80
/enrol/lti/tests/local/ltiadvantage/repository/user_repository_test.php -> line 136
/enrol/lti/tests/local/ltiadvantage/repository/user_repository_test.php -> line 158
/enrol/lti/classes/local/ltiadvantage/repository/user_repository.php -> line 241
/enrol/lti/classes/local/ltiadvantage/repository/user_repository.php -> line 270
/mod/assignment/classes/privacy/provider.php -> line 358
/mod/assignment/classes/privacy/provider.php -> line 393
/lib/tests/h5p_clean_orphaned_records_task_test.php -> line 79
/lib/tests/h5p_clean_orphaned_records_task_test.php -> line 82
/lib/behat/classes/behat_core_generator.php -> line 539
/lib/behat/classes/behat_generator_base.php -> line 604
/blog/locallib.php -> line 183
/badges/action.php -> line 95
/badges/criteria/award_criteria_activity.php -> line 49
/badges/criteria/award_criteria_activity.php -> line 68
/admin/tool/task/classes/check/adhocqueue.php -> line 48
/mod/forum/lib.php -> line 917
/mod/forum/lib.php -> line 1356
/mod/forum/lib.php -> line 1381
/mod/forum/lib.php -> line 1395
/mod/forum/lib.php -> line 1420
/mod/forum/lib.php -> line 1882
/mod/forum/lib.php -> line 1883
/mod/data/locallib.php -> line 1037
/mod/quiz/tests/behat/behat_mod_quiz.php -> line 242
/repository/lib.php -> line 553
/repository/lib.php -> line 603
/question/engine/bank.php -> line 624
/question/bank/managecategories/tests/helper_test.php -> line 103
/admin/cli/mysql_compressed_rows.php -> line 73
/admin/cli/mysql_compressed_rows.php -> line 75
/rating/lib.php -> line 818
/mod/glossary/classes/search/entry.php -> line 198
/grade/querylib.php -> line 255
/mod/quiz/accessmanager.php -> line 231
/mod/quiz/accessmanager.php -> line 258
/badges/criteria/award_criteria_course.php -> line 51
/mod/wiki/tests/privacy/provider_test.php -> line 497
/lib/badgeslib.php -> line 894
/lib/badgeslib.php -> line 916
/lib/badgeslib.php -> line 931
/mod/forum/report/summary/classes/summary_table.php -> line 676
/lib/ddl/postgres_sql_generator.php -> line 433
/user/classes/search/course_teacher.php -> line 197
/admin/tool/profiling/index.php -> line 66
/mod/quiz/report/statistics/classes/calculator.php -> line 223
/mod/quiz/report/statistics/classes/calculator.php -> line 287
/mod/quiz/report/attemptsreport.php -> line 356
/question/engine/upgrade/upgradelib.php -> line 291
/badges/classes/output/issued_badge.php -> line 82
/badges/classes/output/issued_badge.php -> line 90
/mod/data/rsslib.php -> line 79
/question/bank/previewquestion/classes/helper.php -> line 293
/question/classes/external.php -> line 164
/competency/classes/course_competency.php -> line 326
/competency/classes/course_competency.php -> line 366
/message/tests/externallib_test.php -> line 152
/message/tests/externallib_test.php -> line 308
/badges/classes/assertion.php -> line 63
/lib/datalib.php -> line 1266
/lib/datalib.php -> line 1317
/enrol/database/lib.php -> line 352
/h5p/classes/framework.php -> line 1184
/tag/classes/index_builder.php -> line 311
/reportbuilder/tests/local/entities/user_test.php -> line 62
/course/tests/category_test.php -> line 336
/question/bank/history/classes/question_history_view.php -> line 189
/mod/feedback/item/info/lib.php -> line 223
/search/engine/simpledb/tests/engine_test.php -> line 419
/lib/ddl/mssql_sql_generator.php -> line 570
/lib/db/upgrade.php -> line 3565
/lib/db/upgrade.php -> line 4179
/lib/db/upgrade.php -> line 4193
/lib/db/upgrade.php -> line 4373
/lib/db/upgrade.php -> line 4396
/mod/survey/lib.php -> line 295
/mod/survey/lib.php -> line 342
/mod/survey/lib.php -> line 403
/question/bank/comment/tests/backup_test.php -> line 206
/question/bank/comment/tests/backup_test.php -> line 211
/enrol/lti/classes/local/ltiadvantage/repository/deployment_repository.php -> line 183
/badges/classes/output/external_badge.php -> line 65
/mod/quiz/tests/structure_test.php -> line 710
/analytics/tests/privacy/provider_test.php -> line 410
/course/format/topics/lib.php -> line 474
/message/externallib.php -> line 2518
/mod/lti/backup/moodle2/restore_lti_stepslib.php -> line 190
/lib/dml/mysqli_native_moodle_database.php -> line 413
/lib/dml/mysqli_native_moodle_database.php -> line 432
/question/type/edit_question_form.php -> line 888
/mod/quiz/backup/moodle2/restore_quiz_stepslib.php -> line 333
/message/classes/search/message_sent.php -> line 80
/question/bank/customfields/tests/customfield_test.php -> line 297
/question/bank/customfields/tests/customfield_test.php -> line 305
/completion/criteria/completion_criteria_activity.php -> line 128
/mod/chat/lib.php -> line 326
/mod/chat/lib.php -> line 559
/mod/scorm/report/interactions/classes/report.php -> line 373
/mod/scorm/report/interactions/classes/report.php -> line 378
/lib/tests/questionlib_test.php -> line 265
/lib/behat/classes/behat_session_trait.php -> line 1586
/lib/behat/classes/behat_session_trait.php -> line 1628
/question/type/calculated/questiontype.php -> line 1497
/grade/edit/tree/outcomeitem.php -> line 170
/mod/quiz/locallib.php -> line 2304
/mod/quiz/locallib.php -> line 2432
/lib/myprofilelib.php -> line 137
/mnet/peer.php -> line 271
/lib/dml/moodle_database.php -> line 1643
/lib/dml/moodle_database.php -> line 1744
/course/classes/search/customfield.php -> line 142
/competency/classes/plan_competency.php -> line 106
/backup/util/dbops/restore_dbops.class.php -> line 1451
/backup/util/dbops/restore_dbops.class.php -> line 1476
/backup/util/dbops/restore_dbops.class.php -> line 1498
/backup/util/dbops/restore_dbops.class.php -> line 1529
/backup/util/dbops/restore_dbops.class.php -> line 1551
/backup/util/dbops/restore_dbops.class.php -> line 1570
/backup/util/dbops/restore_dbops.class.php -> line 1582
/mod/quiz/report/overview/overview_table.php -> line 108
/lib/enrollib.php -> line 1747
/lib/ddl/oracle_sql_generator.php -> line 439
/lib/ddl/oracle_sql_generator.php -> line 635
/lib/ddl/oracle_sql_generator.php -> line 662
/lib/modinfolib.php -> line 2638
/lib/modinfolib.php -> line 2717
/webservice/lib.php -> line 327
/webservice/lib.php -> line 437
/webservice/lib.php -> line 460
/mod/data/classes/search/entry.php -> line 147
/mod/data/classes/search/entry.php -> line 304
/mod/workshop/locallib.php -> line 979
/mod/workshop/locallib.php -> line 1003
/mod/workshop/locallib.php -> line 1351
/mod/workshop/locallib.php -> line 1377
/mod/data/tests/search/search_test.php -> line 1119
/competency/classes/user_competency_plan.php -> line 221
/lib/navigationlib.php -> line 2470
/lib/navigationlib.php -> line 3415
/lib/navigationlib.php -> line 3428
/lib/navigationlib.php -> line 4990
/lib/navigationlib.php -> line 5011
/cohort/upload_form.php -> line 554
/mod/workshop/classes/privacy/provider.php -> line 319
/mod/lesson/lib.php -> line 455
/lib/accesslib.php -> line 1234
/lib/accesslib.php -> line 7223
/question/format/xml/tests/qformat_xml_import_export_test.php -> line 140
/tag/classes/tag.php -> line 897
/tag/classes/tag.php -> line 946
/course/format/weeks/lib.php -> line 588
/course/format/weeks/lib.php -> line 647
/question/tests/version_test.php -> line 88
/question/tests/version_test.php -> line 134
/question/tests/version_test.php -> line 149
/question/tests/version_test.php -> line 220
/question/type/calculated/question.php -> line 257
/mod/data/view.php -> line 297
/mod/data/view.php -> line 335
/enrol/lti/classes/local/ltiadvantage/repository/application_registration_repository.php -> line 242
/competency/classes/course_module_competency.php -> line 249
/mod/scorm/report/objectives/classes/report.php -> line 363
/mod/scorm/report/objectives/classes/report.php -> line 368
/webservice/externallib.php -> line 113
/question/lib.php -> line 66
/mod/bigbluebuttonbn/classes/instance.php -> line 126
/mod/bigbluebuttonbn/classes/instance.php -> line 171
/admin/tool/moodlenet/db/upgrade.php -> line 54
/enrol/lti/classes/helper.php -> line 296
/question/bank/tagquestion/lib.php -> line 62
/mod/glossary/lib.php -> line 631
/mod/glossary/lib.php -> line 735
/blocks/glossary_random/block_glossary_random.php -> line 196
/reportbuilder/tests/local/helpers/database_test.php -> line 63
/reportbuilder/tests/local/helpers/database_test.php -> line 96
/message/classes/api.php -> line 2537
/message/classes/api.php -> line 3033