http://wiki.mipt.ru/index.php?action=history&feed=atom&title=Admin%2Ftool%2Fnavdb%2Findex 2026-05-06T23:54:54Z История изменений этой страницы в вики MediaWiki 1.42.1 http://wiki.mipt.ru/index.php?title=Admin/tool/navdb/index&diff=7789&oldid=prev 2024-10-18T06:51:33Z

<p>1 версия импортирована</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="ru"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Предыдущая версия</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Версия от 06:51, 18 октября 2024</td> </tr><tr><td colspan="2" class="diff-notice" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

Олег Давидович http://wiki.mipt.ru/index.php?title=Admin/tool/navdb/index&diff=7788&oldid=prev 2021-12-09T16:54:45Z

<p><span dir="auto"><span class="autocomment">top: </span>clean up, typos fixed: Futhermore → Furthermore</span></p> <p><b>Новая страница</b></p><div>{{stub}}<br /> [https://moodle.org/plugins/tool_navdb Database Navigation (tool_navdb)] is a database browsing plugin for Moodle. This plugin is designed especially for Moodle&#039;s DB structure and adds some practical tools.<br /> <br /> One of the main limitations of Moodle DB structure is that there are no [https://en.wikipedia.org/wiki/Foreign_key foreign keys]. With tool_navdb the first things you&#039;ll notice is that, when a DB table content is shown, some fields have hyperlinks to navigate between tables like a standard [https://en.wikipedia.org/wiki/Foreign_key foreign key]. Some examples of this kind of auto-links are:<br /> <br /> * userid goes to a specific entry in mdl_course table<br /> * courseid goes to mdl_user<br /> * contextid goes to mdl_context<br /> * instance ids in tables like mdl_course_modules and mdl_context goes directly to related table<br /> * etc.<br /> <br /> The same happens with the visualisation of fields that Moodle uses in a non standard ways. The plugin add some extra information when you move a mouse over some elements. For example:<br /> <br /> * timestamps stored as integer instead of a proper date format show a human date<br /> * contextlevel shows a human readable format<br /> * roleid show a role shortname<br /> <br /> Furthermore, some tables like mdl_user, mdl_course, mdl_course_modules... has a dropdown menu on every record entry with useful options for that specific row. Some examples of these are:<br /> * mdl_user entry: login as, view profile, delete user, go to user&#039;s mdl_role_assignments DB records...<br /> * mdl_course: view course, settings, delete course, go to mdl_role_assignments for this course DB records...<br /> <br /> ==Dynamic table list==<br /> <br /> [[File:ToolNavDB_Selection_003.png]]<br /> <br /> ==Assisted SQL filter generator==<br /> <br /> [[File:ToolNavDB_Selection_004.png]]<br /> <br /> ==Smart Record Visualization==<br /> <br /> [[File:ToolNavDB_Selection_006.png]]<br /> <br /> [[es:admin/tool/navdb/index]]</div>

1>Tim@horizoneducationnetwork.org