Quick Navigation
×
Moodle 4.0 XRef and Diffs
Home
Quick Navigation
Moodle 4.0
Classes
Functions
Variables
Constants
Namespaces
Statistics
Moodle 4.0 Database Schema
Versions
Moodle 4.3
Moodle 4.2
Moodle 4.1
Moodle 4.0
Moodle 3.11
Moodle 3.10
Moodle 3.9
Classes
Functions
Variables
Constants
Tables
Namespaces
Search
Search moodle.org's
Developer Documentation
Search
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_records_select
[
Top level directory
]
Function and Method Cross Reference
at:
/lib/classes/persistent.php
->
line 866
/lib/dml/moodle_database.php
->
line 1476
Referenced 335 times:
/comment/locallib.php
->
line 240
/admin/tool/uploadcourse/classes/helper.php
->
line 574
/reportbuilder/classes/reportbuilder/audience/systemrole.php
->
line 124
/lib/dml/tests/dml_test.php
->
line 693
/payment/classes/helper.php
->
line 409
/course/tests/externallib_test.php
->
line 343
/contentbank/classes/contentbank.php
->
line 216
/grade/import/xml/grade_import_form.php
->
line 64
/enrol/lti/classes/data_connector.php
->
line 224
/enrol/lti/classes/data_connector.php
->
line 239
/enrol/lti/classes/data_connector.php
->
line 435
/enrol/locallib.php
->
line 995
/mod/workshop/classes/task/cron_task.php
->
line 57
/blocks/rss_client/managefeeds.php
->
line 77
/mod/wiki/locallib.php
->
line 546
/mod/wiki/locallib.php
->
line 557
/mod/wiki/locallib.php
->
line 568
/mod/wiki/locallib.php
->
line 1243
/mod/data/tests/privacy/provider_test.php
->
line 228
/mod/lesson/locallib.php
->
line 86
/mod/lesson/locallib.php
->
line 239
/mod/lesson/locallib.php
->
line 296
/mod/lesson/locallib.php
->
line 314
/mod/lesson/locallib.php
->
line 315
/mod/lesson/locallib.php
->
line 1124
/mod/lesson/locallib.php
->
line 1212
/report/participation/locallib.php
->
line 203
/lib/questionlib.php
->
line 1196
/lib/classes/task/legacy_plugin_cron_task.php
->
line 88
/lib/classes/task/legacy_plugin_cron_task.php
->
line 118
/mod/lesson/lesson.php
->
line 65
/competency/classes/competency.php
->
line 406
/competency/classes/competency.php
->
line 428
/competency/classes/competency.php
->
line 877
/mod/bigbluebuttonbn/classes/logger.php
->
line 103
/mod/bigbluebuttonbn/classes/logger.php
->
line 234
/enrol/meta/lib.php
->
line 338
/mod/bigbluebuttonbn/classes/recording.php
->
line 700
/mod/bigbluebuttonbn/classes/recording.php
->
line 797
/lib/classes/analytics/analyser/courses.php
->
line 112
/question/classes/privacy/provider.php
->
line 458
/analytics/classes/prediction.php
->
line 205
/lib/classes/persistent.php
->
line 880
/lib/upgradelib.php
->
line 1405
/mod/lti/lib.php
->
line 718
/mod/lti/lib.php
->
line 740
/competency/classes/user_competency.php
->
line 512
/mod/assign/classes/privacy/assign_plugin_request_data.php
->
line 203
/mod/assign/classes/privacy/assign_plugin_request_data.php
->
line 204
/user/profile/field/social/upgradelib.php
->
line 59
/mod/assign/classes/privacy/provider.php
->
line 462
/mod/choice/tests/privacy/provider_test.php
->
line 310
/admin/tool/usertours/db/upgrade.php
->
line 61
/lib/classes/task/backup_cleanup_task.php
->
line 64
/mod/survey/graph.php
->
line 193
/mod/survey/graph.php
->
line 332
/mod/survey/graph.php
->
line 475
/mod/survey/graph.php
->
line 624
/admin/mnet/index.php
->
line 96
/notes/externallib.php
->
line 100
/message/classes/helper.php
->
line 504
/mod/bigbluebuttonbn/classes/local/proxy/bigbluebutton_proxy.php
->
line 149
/admin/tool/monitor/classes/rule_manager.php
->
line 235
/grade/import/keymanager.php
->
line 57
/repository/contentbank/classes/browser/contentbank_browser.php
->
line 106
/admin/presets/classes/manager.php
->
line 149
/mod/h5pactivity/lib.php
->
line 346
/mod/h5pactivity/lib.php
->
line 368
/completion/data_object.php
->
line 236
/question/classes/statistics/responses/analyser.php
->
line 171
/admin/reports.php
->
line 66
/grade/export/grade_export_form.php
->
line 169
/mod/scorm/datamodels/scormlib.php
->
line 738
/mod/scorm/datamodels/scormlib.php
->
line 748
/reportbuilder/classes/task/send_schedules.php
->
line 49
/competency/classes/api.php
->
line 857
/competency/classes/api.php
->
line 2020
/competency/classes/api.php
->
line 2394
/competency/classes/api.php
->
line 4222
/competency/classes/api.php
->
line 4714
/calendar/externallib.php
->
line 217
/lib/form/cohort.php
->
line 136
/mod/forum/lib.php
->
line 2078
/backup/util/helper/async_helper.class.php
->
line 336
/backup/util/helper/async_helper.class.php
->
line 385
/lib/classes/task/blog_cron_task.php
->
line 52
/rating/lib.php
->
line 1205
/reportbuilder/classes/local/helpers/schedule.php
->
line 116
/admin/presets/tests/generator_test.php
->
line 110
/grade/report/outcomes/index.php
->
line 63
/lib/badgeslib.php
->
line 1247
/contentbank/classes/privacy/provider.php
->
line 294
/lib/classes/plugininfo/filter.php
->
line 52
/admin/tool/profiling/index.php
->
line 80
/admin/tool/profiling/index.php
->
line 131
/lib/filterlib.php
->
line 1170
/lib/filterlib.php
->
line 1174
/mod/wiki/lib.php
->
line 770
/calendar/lib.php
->
line 1645
/lib/classes/analytics/analyser/site_courses.php
->
line 112
/message/classes/privacy/provider.php
->
line 567
/message/classes/privacy/provider.php
->
line 838
/message/classes/privacy/provider.php
->
line 859
/lib/classes/plugininfo/format.php
->
line 51
/grade/edit/outcome/import.php
->
line 181
/grade/edit/outcome/import.php
->
line 193
/mod/resource/backup/moodle2/backup_resource_activity_task.class.php
->
line 88
/mod/resource/backup/moodle2/backup_resource_activity_task.class.php
->
line 112
/lib/classes/task/portfolio_cron_task.php
->
line 50
/competency/classes/user_competency_course.php
->
line 231
/mod/lesson/essay.php
->
line 218
/mod/lesson/essay.php
->
line 224
/calendar/tests/externallib_test.php
->
line 146
/calendar/tests/externallib_test.php
->
line 153
/message/tests/externallib_test.php
->
line 1919
/message/tests/externallib_test.php
->
line 1920
/message/tests/externallib_test.php
->
line 1926
/message/tests/externallib_test.php
->
line 1927
/course/classes/privacy/provider.php
->
line 189
/mod/book/lib.php
->
line 719
/badges/classes/assertion.php
->
line 308
/lib/datalib.php
->
line 464
/mod/forum/classes/task/cron_task.php
->
line 190
/mod/forum/classes/task/cron_task.php
->
line 208
/mod/forum/classes/task/cron_task.php
->
line 236
/mod/choice/lib.php
->
line 1091
/analytics/tests/fixtures/test_site_users_analyser.php
->
line 104
/lib/classes/session/manager.php
->
line 910
/favourites/classes/local/repository/favourite_repository.php
->
line 153
/favourites/classes/local/repository/favourite_repository.php
->
line 208
/search/engine/simpledb/tests/engine_test.php
->
line 382
/lib/db/upgrade.php
->
line 2273
/competency/classes/related_competency.php
->
line 181
/mod/chat/gui_header_js/jsupdated.php
->
line 157
/mod/survey/lib.php
->
line 1056
/mod/survey/lib.php
->
line 1078
/lib/moodlelib.php
->
line 1764
/lib/moodlelib.php
->
line 4317
/enrol/flatfile/lib.php
->
line 352
/mod/chat/gui_header_js/jsupdate.php
->
line 77
/message/externallib.php
->
line 181
/availability/condition/profile/classes/condition.php
->
line 495
/availability/condition/profile/classes/condition.php
->
line 506
/blocks/rss_client/block_rss_client.php
->
line 135
/course/lib.php
->
line 1361
/course/lib.php
->
line 1968
/course/lib.php
->
line 3536
/mod/scorm/backup/moodle2/restore_scorm_stepslib.php
->
line 215
/reportbuilder/classes/local/helpers/report.php
->
line 173
/reportbuilder/classes/local/helpers/report.php
->
line 197
/reportbuilder/classes/local/helpers/report.php
->
line 301
/reportbuilder/classes/local/helpers/report.php
->
line 381
/admin/tool/lp/classes/external/user_competency_summary_exporter.php
->
line 144
/mod/chat/lib.php
->
line 642
/mod/chat/lib.php
->
line 699
/mod/chat/lib.php
->
line 1339
/mod/chat/lib.php
->
line 1384
/mod/chat/lib.php
->
line 1571
/mod/bigbluebuttonbn/tests/task/upgrade_recordings_task_test.php
->
line 84
/mod/bigbluebuttonbn/tests/task/upgrade_recordings_task_test.php
->
line 93
/mod/bigbluebuttonbn/tests/task/upgrade_recordings_task_test.php
->
line 157
/lib/classes/analytics/analyser/users.php
->
line 148
/mod/scorm/locallib.php
->
line 1045
/mod/scorm/locallib.php
->
line 2108
/mod/scorm/locallib.php
->
line 2201
/mod/scorm/locallib.php
->
line 2214
/calendar/classes/local/event/entities/repeat_event_collection.php
->
line 135
/mod/assign/classes/plugininfo/assignsubmission.php
->
line 49
/mod/glossary/locallib.php
->
line 67
/course/externallib.php
->
line 1837
/course/externallib.php
->
line 1858
/question/type/calculated/questiontype.php
->
line 294
/question/type/calculated/questiontype.php
->
line 692
/question/type/calculated/questiontype.php
->
line 1308
/question/type/calculated/questiontype.php
->
line 1411
/mod/lti/backup/moodle1/lib.php
->
line 89
/mod/workshop/lib.php
->
line 2092
/mod/workshop/lib.php
->
line 2112
/mod/workshop/lib.php
->
line 2142
/mod/workshop/lib.php
->
line 2173
/search/engine/simpledb/classes/engine.php
->
line 184
/mod/forum/classes/task/send_user_notifications.php
->
line 243
/mod/forum/classes/task/send_user_notifications.php
->
line 253
/mod/forum/classes/task/send_user_notifications.php
->
line 263
/question/bank/managecategories/classes/question_category_object.php
->
line 262
/mod/forum/classes/task/send_user_digests.php
->
line 319
/mod/forum/classes/task/send_user_digests.php
->
line 322
/mod/forum/classes/task/send_user_digests.php
->
line 325
/mod/forum/classes/task/send_user_digests.php
->
line 328
/mod/lesson/classes/privacy/provider.php
->
line 663
/mod/lesson/classes/privacy/provider.php
->
line 671
/grade/grading/form/lib.php
->
line 448
/grade/export/keymanager.php
->
line 57
/lib/dml/moodle_database.php
->
line 1451
/lib/dml/moodle_database.php
->
line 1473
/lib/dml/moodle_database.php
->
line 1569
/mod/bigbluebuttonbn/bbb_view.php
->
line 112
/admin/tool/dataprivacy/classes/api.php
->
line 379
/admin/tool/dataprivacy/classes/api.php
->
line 385
/admin/tool/dataprivacy/classes/api.php
->
line 533
/user/externallib.php
->
line 949
/mod/assign/classes/plugininfo/assignfeedback.php
->
line 49
/admin/tool/dataprivacy/classes/external.php
->
line 102
/admin/tool/dataprivacy/classes/external.php
->
line 718
/mod/forum/tests/privacy/provider_test.php
->
line 1194
/mod/forum/tests/privacy/provider_test.php
->
line 1424
/mod/forum/tests/privacy/provider_test.php
->
line 1438
/mod/forum/tests/privacy/provider_test.php
->
line 1442
/mod/forum/tests/privacy/provider_test.php
->
line 1448
/mod/forum/tests/privacy/provider_test.php
->
line 1456
/mod/forum/tests/privacy/provider_test.php
->
line 1459
/mod/forum/tests/privacy/provider_test.php
->
line 1465
/mod/forum/tests/privacy/provider_test.php
->
line 1468
/mod/forum/tests/privacy/provider_test.php
->
line 1475
/mod/forum/tests/privacy/provider_test.php
->
line 1479
/mod/forum/tests/privacy/provider_test.php
->
line 1635
/mod/forum/tests/privacy/provider_test.php
->
line 1649
/mod/forum/tests/privacy/provider_test.php
->
line 1653
/mod/forum/tests/privacy/provider_test.php
->
line 1659
/mod/forum/tests/privacy/provider_test.php
->
line 1667
/mod/forum/tests/privacy/provider_test.php
->
line 1670
/mod/forum/tests/privacy/provider_test.php
->
line 1676
/mod/forum/tests/privacy/provider_test.php
->
line 1679
/mod/forum/tests/privacy/provider_test.php
->
line 1686
/mod/forum/tests/privacy/provider_test.php
->
line 1691
/lib/classes/oauth2/api.php
->
line 122
/mod/quiz/report/overview/overview_table.php
->
line 380
/blocks/recent_activity/block_recent_activity.php
->
line 253
/mod/scorm/datamodels/aicclib.php
->
line 385
/analytics/classes/analysis.php
->
line 160
/reportbuilder/classes/privacy/provider.php
->
line 237
/reportbuilder/classes/privacy/provider.php
->
line 246
/reportbuilder/classes/privacy/provider.php
->
line 251
/webservice/lib.php
->
line 582
/mod/forum/classes/privacy/provider.php
->
line 1351
/lib/tests/task/completion_daily_task_test.php
->
line 102
/admin/tool/lp/classes/form/framework_autocomplete.php
->
line 107
/admin/tool/generator/classes/site_backend.php
->
line 192
/search/classes/manager.php
->
line 1669
/search/classes/manager.php
->
line 1898
/h5p/classes/api.php
->
line 154
/customfield/tests/privacy/provider_test.php
->
line 213
/customfield/tests/privacy/provider_test.php
->
line 222
/customfield/tests/privacy/provider_test.php
->
line 223
/customfield/tests/privacy/provider_test.php
->
line 228
/customfield/tests/privacy/provider_test.php
->
line 229
/customfield/tests/privacy/provider_test.php
->
line 250
/customfield/tests/privacy/provider_test.php
->
line 259
/customfield/tests/privacy/provider_test.php
->
line 260
/customfield/tests/privacy/provider_test.php
->
line 265
/customfield/tests/privacy/provider_test.php
->
line 266
/customfield/tests/privacy/provider_test.php
->
line 287
/customfield/tests/privacy/provider_test.php
->
line 288
/competency/classes/user_competency_plan.php
->
line 263
/admin/tool/log/store/database/classes/log/store.php
->
line 177
/mod/survey/report.php
->
line 220
/mod/lesson/lib.php
->
line 265
/mod/lesson/lib.php
->
line 484
/mod/lesson/lib.php
->
line 485
/mod/lesson/lib.php
->
line 1309
/mod/lesson/lib.php
->
line 1314
/mod/lesson/lib.php
->
line 1329
/mod/lesson/lib.php
->
line 1334
/mod/lesson/lib.php
->
line 1341
/mod/lesson/lib.php
->
line 1349
/mod/lesson/lib.php
->
line 1377
/mod/lesson/lib.php
->
line 1382
/mod/lesson/lib.php
->
line 1392
/mod/lesson/lib.php
->
line 1404
/mod/quiz/lib.php
->
line 615
/mod/quiz/lib.php
->
line 1364
/mod/quiz/lib.php
->
line 1922
/mod/quiz/lib.php
->
line 1935
/mod/quiz/lib.php
->
line 1940
/mod/quiz/lib.php
->
line 1962
/mod/quiz/lib.php
->
line 1969
/lib/accesslib.php
->
line 6182
/lib/accesslib.php
->
line 6609
/lib/accesslib.php
->
line 7553
/customfield/tests/api_test.php
->
line 234
/customfield/tests/api_test.php
->
line 235
/customfield/tests/api_test.php
->
line 238
/customfield/tests/api_test.php
->
line 239
/customfield/tests/api_test.php
->
line 246
/customfield/tests/api_test.php
->
line 247
/customfield/tests/api_test.php
->
line 251
/customfield/tests/api_test.php
->
line 252
/lib/classes/plugininfo/qtype.php
->
line 51
/tag/classes/tag.php
->
line 227
/tag/classes/tag.php
->
line 284
/tag/classes/tag.php
->
line 1522
/tag/classes/tag.php
->
line 1523
/tag/classes/tag.php
->
line 1603
/tag/classes/tag.php
->
line 1636
/lib/grade/grade_grade.php
->
line 216
/mod/feedback/lib.php
->
line 1431
/mod/feedback/lib.php
->
line 2183
/mod/feedback/lib.php
->
line 2187
/mod/feedback/lib.php
->
line 2951
/mod/feedback/lib.php
->
line 2956
/mod/feedback/lib.php
->
line 2978
/mod/feedback/lib.php
->
line 2985
/lib/licenselib.php
->
line 233
/comment/classes/external.php
->
line 311
/mod/chat/gui_basic/index.php
->
line 188
/group/classes/privacy/provider.php
->
line 160
/group/classes/privacy/provider.php
->
line 210
/group/classes/privacy/provider.php
->
line 288
/admin/tools.php
->
line 64
/notes/lib.php
->
line 80
/mod/chat/locallib.php
->
line 65
/mod/assign/lib.php
->
line 1476
/mod/assign/lib.php
->
line 1483
/mod/assign/lib.php
->
line 1505
/mod/assign/lib.php
->
line 1512
/mod/glossary/lib.php
->
line 4189
/grade/report/history/classes/output/tablelog.php
->
line 166
/mod/quiz/report/statistics/report.php
->
line 557
/lib/classes/task/badges_message_task.php
->
line 52
/lib/adminlib.php
->
line 4567
/lib/adminlib.php
->
line 4574
/lib/adminlib.php
->
line 9950
/lib/adminlib.php
->
line 9995
/enrol/meta/locallib.php
->
line 127
/course/classes/category.php
->
line 2418
/course/classes/category.php
->
line 2477
/course/classes/category.php
->
line 3058
/competency/classes/competency_rule_points.php
->
line 82
/lib/classes/task/manager.php
->
line 626
/lib/classes/task/manager.php
->
line 706
/mod/scorm/lib.php
->
line 416
/mod/scorm/lib.php
->
line 598
/mod/scorm/lib.php
->
line 612
/mod/scorm/lib.php
->
line 1416
/mod/scorm/lib.php
->
line 1438