Moodle 3.10 XRef and Diffs

Search moodle.org's
Developer Documentation

See Release Notes

Bug fixes for general core bugs in 3.10.x will end 8 November 2021 (12 months).
Bug fixes for security issues in 3.10.x will end 9 May 2022 (18 months).
PHP version: minimum PHP 7.2.0 Note: minimum PHP version has increased since Moodle 3.8. PHP 7.3.x and 7.4.x are supported too.

Moodle 3.10 Database Schema (by Marcus Green)

get_recordset_sql

[Top level directory]

Function and Method Cross Reference

at:

/lib/dml/pgsql_native_moodle_database.php -> line 776
/lib/dml/tests/fixtures/test_moodle_database.php -> line 198
/lib/dml/tests/dml_test.php -> line 5893
/lib/dml/pdo_moodle_database.php -> line 252
/lib/dml/sqlsrv_native_moodle_database.php -> line 848
/lib/dml/mysqli_native_moodle_database.php -> line 1178
/lib/dml/tests/fixtures/read_slave_moodle_database_special.php -> line 53
/lib/dml/oci_native_moodle_database.php -> line 1089
/lib/dml/tests/fixtures/read_slave_moodle_database.php -> line 136

Referenced 432 times:

/mod/survey/classes/search/activity.php -> line 63
/report/completion/user.php -> line 109
/enrol/cohort/locallib.php -> line 197
/enrol/cohort/locallib.php -> line 220
/enrol/cohort/locallib.php -> line 261
/enrol/cohort/locallib.php -> line 283
/mod/forum/classes/privacy/provider.php -> line 603
/mod/forum/classes/privacy/provider.php -> line 679
/lib/classes/task/completion_daily_task.php -> line 87
/message/output/airnotifier/externallib.php -> line 115
/admin/tool/policy/classes/privacy/provider.php -> line 242
/admin/tool/policy/classes/privacy/provider.php -> line 322
/completion/criteria/completion_criteria_activity.php -> line 247
/comment/lib.php -> line 576
/mod/forum/db/upgrade.php -> line 232
/mod/choice/classes/privacy/provider.php -> line 168
/portfolio/classes/privacy/provider.php -> line 163
/admin/cli/fix_deleted_users.php -> line 71
/lib/gradelib.php -> line 219
/lib/gradelib.php -> line 1523
/cohort/classes/privacy/provider.php -> line 146
/enrol/mnet/enrol.php -> line 82
/enrol/mnet/enrol.php -> line 348
/analytics/classes/model.php -> line 1429
/analytics/classes/model.php -> line 1922
/mod/workshop/form/comments/lib.php -> line 325
/enrol/classes/privacy/provider.php -> line 163
/course/classes/search/customfield.php -> line 81
/mod/lesson/locallib.php -> line 729
/tag/classes/tag.php -> line 319
/customfield/classes/api.php -> line 89
/customfield/classes/api.php -> line 364
/backup/moodle2/restore_stepslib.php -> line 419
/backup/moodle2/restore_stepslib.php -> line 5044
/admin/tool/multilangupgrade/index.php -> line 84
/mod/quiz/cronlib.php -> line 110
/lib/db/upgrade.php -> line 918
/lib/db/upgrade.php -> line 950
/lib/db/upgrade.php -> line 1332
/lib/db/upgrade.php -> line 1376
/lib/db/upgrade.php -> line 2804
/blocks/html/classes/privacy/provider.php -> line 152
/competency/classes/course_module_competency.php -> line 221
/competency/classes/course_module_competency.php -> line 291
/competency/classes/course_module_competency.php -> line 320
/lib/dml/tests/fixtures/test_moodle_database.php -> line 208
/mod/glossary/classes/privacy/provider.php -> line 234
/analytics/classes/privacy/provider.php -> line 219
/analytics/classes/privacy/provider.php -> line 247
/analytics/classes/privacy/provider.php -> line 273
/message/output/email/classes/task/send_email_task.php -> line 122
/message/output/email/classes/task/send_email_task.php -> line 151
/message/output/email/classes/task/send_email_task.php -> line 175
/enrol/externallib.php -> line 176
/enrol/externallib.php -> line 848
/completion/criteria/completion_criteria_duration.php -> line 251
/blocks/html/backup/moodle2/restore_html_block_task.class.php -> line 81
/grade/classes/privacy/provider.php -> line 434
/grade/classes/privacy/provider.php -> line 490
/grade/classes/privacy/provider.php -> line 529
/grade/classes/privacy/provider.php -> line 563
/grade/classes/privacy/provider.php -> line 587
/grade/classes/privacy/provider.php -> line 618
/grade/classes/privacy/provider.php -> line 659
/grade/classes/privacy/provider.php -> line 892
/grade/classes/privacy/provider.php -> line 917
/grade/classes/privacy/provider.php -> line 986
/grade/classes/privacy/provider.php -> line 1011
/grade/classes/privacy/provider.php -> line 1272
/lib/dml/moodle_database.php -> line 1394
/lib/dml/moodle_database.php -> line 1413
/lib/dml/moodle_database.php -> line 2002
/blocks/recentlyaccessedcourses/db/install.php -> line 63
/mod/scorm/lib.php -> line 1443
/mod/survey/classes/privacy/provider.php -> line 221
/mod/survey/classes/privacy/provider.php -> line 268
/grade/grading/classes/privacy/provider.php -> line 185
/grade/grading/classes/privacy/provider.php -> line 291
/lib/classes/task/delete_incomplete_users_task.php -> line 52
/lib/dml/tests/dml_test.php -> line 1397
/lib/dml/tests/dml_test.php -> line 1407
/lib/dml/tests/dml_test.php -> line 3610
/lib/dml/tests/dml_test.php -> line 5475
/lib/dml/tests/dml_test.php -> line 5619
/lib/dml/tests/dml_test.php -> line 5623
/grade/report/user/lib.php -> line 994
/backup/moodle2/backup_stepslib.php -> line 2251
/mod/forum/rsslib.php -> line 317
/grade/grading/pick.php -> line 196
/message/classes/search/base_message.php -> line 197
/lib/db/upgradelib.php -> line 47
/lib/db/upgradelib.php -> line 381
/lib/db/upgradelib.php -> line 409
/lib/db/upgradelib.php -> line 520
/lib/db/upgradelib.php -> line 1083
/lib/db/upgradelib.php -> line 1133
/lib/db/upgradelib.php -> line 1174
/lib/db/upgradelib.php -> line 1222
/admin/tool/policy/classes/api.php -> line 136
/admin/tool/policy/classes/api.php -> line 356
/admin/tool/policy/classes/api.php -> line 624
/admin/tool/policy/classes/api.php -> line 692
/mod/feedback/classes/privacy/provider.php -> line 176
/lib/datalib.php -> line 765
/admin/roles/classes/privacy/provider.php -> line 244
/admin/roles/classes/privacy/provider.php -> line 291
/admin/roles/classes/privacy/provider.php -> line 333
/enrol/manual/lib.php -> line 273
/enrol/manual/lib.php -> line 296
/comment/classes/privacy/provider.php -> line 93
/admin/tool/dataprivacy/classes/expired_contexts_manager.php -> line 121
/admin/tool/dataprivacy/classes/expired_contexts_manager.php -> line 141
/admin/tool/dataprivacy/classes/expired_contexts_manager.php -> line 268
/admin/tool/dataprivacy/classes/expired_contexts_manager.php -> line 505
/lib/dml/pdo_moodle_database.php -> line 296
/lib/dml/pdo_moodle_database.php -> line 326
/mod/book/classes/search/chapter.php -> line 63
/lib/accesslib.php -> line 354
/lib/accesslib.php -> line 935
/lib/accesslib.php -> line 4183
/lib/accesslib.php -> line 5996
/lib/accesslib.php -> line 6589
/lib/accesslib.php -> line 6804
/lib/accesslib.php -> line 7040
/lib/accesslib.php -> line 7336
/lib/accesslib.php -> line 7557
/badges/classes/privacy/provider.php -> line 311
/badges/classes/privacy/provider.php -> line 353
/badges/classes/privacy/provider.php -> line 447
/user/action_redir.php -> line 130
/blog/classes/privacy/provider.php -> line 296
/blog/classes/privacy/provider.php -> line 384
/mod/workshop/form/numerrors/lib.php -> line 362
/backup/util/dbops/restore_dbops.class.php -> line 745
/backup/util/dbops/restore_dbops.class.php -> line 773
/backup/util/dbops/restore_dbops.class.php -> line 872
/backup/util/dbops/restore_dbops.class.php -> line 978
/grade/lib.php -> line 214
/grade/lib.php -> line 243
/enrol/lti/classes/privacy/provider.php -> line 136
/mod/data/locallib.php -> line 534
/calendar/classes/privacy/provider.php -> line 638
/calendar/classes/privacy/provider.php -> line 683
/enrol/fee/classes/privacy/provider.php -> line 138
/mod/data/classes/privacy/provider.php -> line 319
/mod/data/classes/privacy/provider.php -> line 420
/mod/data/classes/privacy/provider.php -> line 456
/mod/data/classes/privacy/provider.php -> line 502
/competency/classes/user_evidence_competency.php -> line 101
/competency/classes/user_evidence_competency.php -> line 129
/mod/forum/classes/task/send_user_digests.php -> line 289
/analytics/classes/manager.php -> line 975
/analytics/classes/manager.php -> line 998
/lib/grade/grade_item.php -> line 1450
/lib/grade/grade_item.php -> line 2198
/completion/criteria/completion_criteria_date.php -> line 181
/backup/util/ui/restore_ui_components.php -> line 201
/cohort/lib.php -> line 549
/mod/forum/locallib.php -> line 531
/lib/classes/session/manager.php -> line 992
/mod/glossary/lib.php -> line 2976
/mod/glossary/lib.php -> line 3687
/lib/classes/task/tag_cron_task.php -> line 95
/lib/classes/task/tag_cron_task.php -> line 187
/competency/classes/related_competency.php -> line 156
/enrol/self/lib.php -> line 453
/enrol/self/lib.php -> line 471
/lib/classes/check/access/riskbackup_result.php -> line 169
/lib/classes/task/grade_cron_task.php -> line 60
/lib/classes/task/grade_cron_task.php -> line 82
/admin/tool/log/store/database/backup/moodle2/backup_logstore_database_nested_element.php -> line 71
/mod/data/classes/search/entry.php -> line 67
/lib/completionlib.php -> line 1260
/lib/dml/sqlsrv_native_moodle_database.php -> line 976
/lib/dml/sqlsrv_native_moodle_database.php -> line 1004
/blocks/classes/privacy/provider.php -> line 173
/admin/cli/mysql_collation.php -> line 136
/admin/cli/mysql_collation.php -> line 167
/admin/cli/mysql_collation.php -> line 223
/admin/cli/mysql_collation.php -> line 278
/admin/cli/mysql_collation.php -> line 299
/admin/tool/spamcleaner/index.php -> line 225
/admin/tool/spamcleaner/index.php -> line 226
/admin/tool/spamcleaner/index.php -> line 227
/admin/tool/spamcleaner/index.php -> line 228
/admin/tool/spamcleaner/index.php -> line 229
/admin/tool/spamcleaner/index.php -> line 230
/admin/tool/spamcleaner/index.php -> line 231
/mod/lesson/classes/privacy/provider.php -> line 341
/mod/forum/classes/task/send_user_notifications.php -> line 201
/lib/dml/tests/fixtures/read_slave_moodle_database_special.php -> line 62
/search/classes/base_mod.php -> line 234
/lib/filterlib.php -> line 799
/lib/filterlib.php -> line 1026
/lib/enrollib.php -> line 2759
/lib/enrollib.php -> line 2881
/lib/enrollib.php -> line 2913
/lib/enrollib.php -> line 3032
/tag/classes/area.php -> line 450
/mod/glossary/classes/local/concept_cache.php -> line 123
/course/classes/search/section.php -> line 64
/mod/workshop/locallib.php -> line 2353
/mod/workshop/locallib.php -> line 2436
/webservice/classes/token_table.php -> line 258
/search/classes/base_block.php -> line 124
/search/classes/base_block.php -> line 386
/backup/util/helper/backup_cron_helper.class.php -> line 101
/backup/util/helper/backup_cron_helper.class.php -> line 555
/auth/mnet/classes/privacy/provider.php -> line 192
/mod/glossary/classes/search/entry.php -> line 65
/lib/classes/analytics/analyser/users.php -> line 57
/competency/classes/api.php -> line 1428
/competency/classes/api.php -> line 2471
/competency/classes/api.php -> line 5323
/mod/quiz/classes/privacy/provider.php -> line 275
/mod/quiz/classes/privacy/provider.php -> line 507
/mod/scorm/classes/privacy/provider.php -> line 187
/mod/scorm/classes/privacy/provider.php -> line 233
/mod/assign/externallib.php -> line 154
/mod/assign/externallib.php -> line 1119
/mod/assign/externallib.php -> line 1272
/lib/blocklib.php -> line 761
/lib/editor/atto/classes/privacy/provider.php -> line 130
/lib/editor/atto/classes/privacy/provider.php -> line 145
/mod/assign/feedback/editpdf/db/upgrade.php -> line 56
/mod/imscp/locallib.php -> line 374
/repository/recent/lib.php -> line 115
/enrol/manual/locallib.php -> line 402
/calendar/lib.php -> line 3820
/calendar/lib.php -> line 3846
/calendar/lib.php -> line 3876
/calendar/lib.php -> line 3897
/contentbank/classes/privacy/provider.php -> line 187
/enrol/meta/lib.php -> line 248
/completion/criteria/completion_criteria_course.php -> line 194
/enrol/category/classes/observer.php -> line 73
/enrol/category/classes/observer.php -> line 87
/enrol/category/classes/observer.php -> line 130
/question/engine/datalib.php -> line 327
/question/engine/datalib.php -> line 373
/question/engine/datalib.php -> line 435
/question/engine/datalib.php -> line 497
/question/engine/datalib.php -> line 635
/question/engine/datalib.php -> line 894
/question/engine/datalib.php -> line 1286
/message/output/popup/classes/api.php -> line 82
/report/stats/locallib.php -> line 98
/mod/book/locallib.php -> line 657
/backup/util/ui/classes/privacy/provider.php -> line 207
/customfield/classes/privacy/provider.php -> line 179
/customfield/classes/privacy/provider.php -> line 378
/customfield/classes/privacy/provider.php -> line 413
/course/classes/search/course.php -> line 60
/mod/glossary/classes/entry_query_builder.php -> line 312
/question/type/multianswer/backup/moodle2/restore_qtype_multianswer_plugin.class.php -> line 97
/admin/cli/mysql_engine.php -> line 73
/admin/cli/mysql_engine.php -> line 111
/admin/cli/mysql_engine.php -> line 152
/admin/cli/mysql_engine.php -> line 173
/course/classes/category.php -> line 381
/course/classes/category.php -> line 801
/course/classes/category.php -> line 1046
/course/classes/category.php -> line 1139
/course/classes/category.php -> line 1466
/course/classes/category.php -> line 2637
/webservice/classes/privacy/provider.php -> line 175
/webservice/classes/privacy/provider.php -> line 192
/webservice/classes/privacy/provider.php -> line 224
/auth/db/auth.php -> line 318
/lib/moodlelib.php -> line 5692
/enrol/flatfile/classes/privacy/provider.php -> line 134
/user/classes/table/participants_search.php -> line 117
/competency/classes/privacy/provider.php -> line 927
/competency/classes/privacy/provider.php -> line 990
/competency/classes/privacy/provider.php -> line 1047
/competency/classes/privacy/provider.php -> line 1087
/competency/classes/privacy/provider.php -> line 1144
/competency/classes/privacy/provider.php -> line 1193
/competency/classes/privacy/provider.php -> line 1271
/competency/classes/privacy/provider.php -> line 1379
/competency/classes/privacy/provider.php -> line 1414
/competency/classes/privacy/provider.php -> line 1464
/competency/classes/privacy/provider.php -> line 1535
/competency/classes/privacy/provider.php -> line 1588
/competency/classes/privacy/provider.php -> line 1653
/competency/classes/privacy/provider.php -> line 1688
/competency/classes/privacy/provider.php -> line 1727
/competency/classes/privacy/provider.php -> line 1798
/competency/classes/privacy/provider.php -> line 1848
/competency/classes/privacy/provider.php -> line 1873
/competency/classes/privacy/provider.php -> line 1933
/competency/classes/privacy/provider.php -> line 1963
/competency/classes/privacy/provider.php -> line 1993
/user/selector/lib.php -> line 848
/user/selector/lib.php -> line 932
/lib/dml/oci_native_moodle_database.php -> line 1077
/mod/survey/lib.php -> line 247
/lib/deprecatedlib.php -> line 2800
/lib/deprecatedlib.php -> line 3345
/backup/util/dbops/backup_structure_dbops.class.php -> line 56
/backup/util/dbops/backup_structure_dbops.class.php -> line 139
/mod/data/field/latlong/field.class.php -> line 97
/enrol/meta/locallib.php -> line 317
/enrol/meta/locallib.php -> line 370
/enrol/meta/locallib.php -> line 447
/enrol/meta/locallib.php -> line 518
/enrol/meta/locallib.php -> line 552
/enrol/meta/locallib.php -> line 576
/enrol/meta/locallib.php -> line 602
/analytics/classes/local/analyser/by_course.php -> line 52
/mod/lesson/backup/moodle2/restore_lesson_stepslib.php -> line 305
/mod/glossary/locallib.php -> line 589
/grade/grading/form/rubric/lib.php -> line 319
/backup/util/helper/restore_decode_content.class.php -> line 103
/search/tests/fixtures/mock_search_area.php -> line 59
/mod/data/lib.php -> line 2929
/mod/data/lib.php -> line 3999
/mod/data/lib.php -> line 4098
/mod/workshop/form/rubric/lib.php -> line 373
/mod/workshop/form/rubric/lib.php -> line 441
/lib/testing/classes/util.php -> line 365
/lib/testing/classes/util.php -> line 390
/lib/testing/classes/util.php -> line 410
/lib/testing/classes/util.php -> line 506
/lib/testing/classes/util.php -> line 549
/lib/testing/classes/util.php -> line 667
/enrol/category/locallib.php -> line 98
/enrol/category/locallib.php -> line 109
/enrol/category/locallib.php -> line 192
/enrol/category/locallib.php -> line 209
/enrol/category/locallib.php -> line 227
/enrol/category/locallib.php -> line 248
/lib/classes/task/delete_unconfirmed_users_task.php -> line 52
/lib/classes/task/completion_regular_task.php -> line 86
/admin/tool/lpmigrate/classes/framework_processor.php -> line 173
/admin/tool/lpmigrate/classes/framework_processor.php -> line 223
/mod/assign/locallib.php -> line 6902
/mod/assign/locallib.php -> line 8909
/mod/forum/classes/subscriptions.php -> line 233
/mod/forum/classes/subscriptions.php -> line 369
/admin/cli/fix_orphaned_question_categories.php -> line 77
/lib/classes/task/send_failed_login_notifications_task.php -> line 91
/lib/classes/task/send_failed_login_notifications_task.php -> line 108
/lib/classes/task/send_failed_login_notifications_task.php -> line 142
/mod/workshop/classes/privacy/provider.php -> line 205
/mod/workshop/classes/privacy/provider.php -> line 398
/mod/workshop/classes/privacy/provider.php -> line 509
/h5p/classes/editor_framework.php -> line 198
/completion/criteria/completion_criteria_grade.php -> line 231
/admin/tool/dataprivacy/classes/output/expired_contexts_table.php -> line 403
/lib/dml/tests/pgsql_native_recordset_test.php -> line 111
/lib/dml/tests/pgsql_native_recordset_test.php -> line 137
/lib/dml/tests/pgsql_native_recordset_test.php -> line 341
/lib/dml/tests/pgsql_native_recordset_test.php -> line 371
/mod/forum/lib.php -> line 857
/search/engine/simpledb/classes/privacy/provider.php -> line 139
/mod/quiz/report/overview/report.php -> line 448
/mod/wiki/classes/privacy/provider.php -> line 282
/mod/wiki/classes/privacy/provider.php -> line 366
/mod/workshop/form/accumulative/lib.php -> line 327
/availability/condition/grade/classes/condition.php -> line 241
/enrol/database/lib.php -> line 249
/enrol/database/lib.php -> line 402
/enrol/database/lib.php -> line 423
/enrol/database/lib.php -> line 483
/competency/classes/course_competency.php -> line 295
/competency/classes/course_competency.php -> line 388
/admin/tool/lp/classes/external.php -> line 896
/webservice/lib.php -> line 1391
/webservice/lib.php -> line 1499
/privacy/classes/local/request/contextlist.php -> line 71
/blocks/timeline/db/install.php -> line 65
/admin/tool/monitor/classes/task/check_subscriptions.php -> line 100
/comment/locallib.php -> line 70
/mod/assign/backup/moodle2/restore_assign_stepslib.php -> line 295
/notes/classes/privacy/provider.php -> line 200
/group/overview.php -> line 124
/user/externallib.php -> line 1004
/user/externallib.php -> line 1020
/mod/feedback/classes/responses_table.php -> line 377
/mod/feedback/classes/responses_table.php -> line 379
/question/classes/bank/view.php -> line 482
/question/classes/bank/view.php -> line 486
/lib/grade/grade_category.php -> line 522
/lib/grade/grade_category.php -> line 841
/mod/lesson/classes/file_info.php -> line 146
/search/classes/base_activity.php -> line 71
/lib/filebrowser/file_info_stored.php -> line 411
/enrol/paypal/classes/privacy/provider.php -> line 194
/h5p/classes/editor_ajax.php -> line 203
/group/lib.php -> line 668
/group/lib.php -> line 1008
/group/lib.php -> line 1148
/group/lib.php -> line 1164
/competency/classes/user_competency_plan.php -> line 196
/lib/filestorage/file_storage.php -> line 2017
/lib/filestorage/file_storage.php -> line 2060
/lib/filestorage/file_storage.php -> line 2171
/lib/filestorage/file_storage.php -> line 2254
/lib/filestorage/file_storage.php -> line 2275
/lib/filestorage/file_storage.php -> line 2297
/message/classes/privacy/provider.php -> line 923
/admin/tool/innodb/index.php -> line 45
/mod/workshop/lib.php -> line 545
/mod/workshop/lib.php -> line 791
/mod/workshop/lib.php -> line 1499
/lib/navigationlib.php -> line 1644
/lib/navigationlib.php -> line 1671
/lib/navigationlib.php -> line 1707
/lib/navigationlib.php -> line 1743
/lib/navigationlib.php -> line 1855
/lib/navigationlib.php -> line 3349
/mod/h5pactivity/classes/privacy/provider.php -> line 193
/lib/classes/task/send_new_user_passwords_task.php -> line 51
/lib/filebrowser/file_info_context_course.php -> line 552
/lib/filebrowser/file_info_context_course.php -> line 832
/lib/filebrowser/file_info_context_course.php -> line 978
/tag/classes/privacy/provider.php -> line 254
/mod/workshop/fileinfolib.php -> line 130
/mod/workshop/fileinfolib.php -> line 291
/mod/forum/classes/search/post.php -> line 77
/report/backups/index.php -> line 134
/lib/grouplib.php -> line 362
/message/classes/api.php -> line 491
/message/classes/api.php -> line 1394
/message/classes/api.php -> line 1443
/message/classes/api.php -> line 1477
/course/classes/privacy/provider.php -> line 119
/enrol/locallib.php -> line 1316
/mod/wiki/classes/search/collaborative_page.php -> line 68
/mod/workshop/form/rubric/classes/privacy/provider.php -> line 88
/admin/tool/unsuproles/index.php -> line 85