mkolb

        if (has_capability('moodle/course:viewparticipants', $this->page->context)) {
            $participants = $coursenode->add(get_string('participants'), new moodle_url('/user/index.php?id='.$course->id), self::TYPE_CONTAINER, get_string('participants'), 'participants');
            $currentgroup = groups_get_course_group($course, true);
            if ($course->id == SITEID) {
                $blogparams = array('courseid' => '');
            } else if ($course->id && !$currentgroup) {
                $blogparams = array('courseid' => clean_param($course->id, PARAM_INT));
            } else {
                $blogparams = array('group' => clean_param($currentgroup, PARAM_INT));
            }

mkolb

do-release-upgrade -d -f DistUpgradeViewNonInteractive

mkolb

# percent posts and total for instructors in a course

select ROUND(100.0 * (SUM(CASE WHEN r.shortname IN ('teacher', 'editingteacher') THEN 1 ELSE 0 END) / (1.0 * COUNT(p.id))), 1) as percent_total, count (p.id) as total
from mdl_user u
left join mdl_role_assignments a on a.userid=u.id
left join mdl_role r on r.id=a.roleid
left join mdl_context x on x.id=a.contextid AND x.contextlevel=50
left join mdl_course c on c.id=x.instanceid
left join mdl_forum_discussions d on d.course=c.id
left join mdl_forum_posts p on p.discussion=d.id

mkolb

field: acc_crsh_id [desc: Crash Identifier]
field: acc_date_val [desc: Date]
field: acc_day_of_week [desc: Day of the Week]
field: acc_milt_time [desc: Military Time]
field: acc_fatl_crsh_ind [desc: Fatal Crash ]
field: acc_injy_crsh_ind [desc: Injury Crash]
field: acc_prop_damg_crsh_ind [desc: Property Damage Crash]
field: acc_num_fatl [desc: Number of Fatalities in UNit]
field: acc_num_injy [desc: Number of Injuries in Unit]
field: acc_num_injy_a [desc: description unavailable]

mkolb

Unstaged changes:                                                                                                   
        Modified   mod/quiz/edit.php                                                                                
diff --git a/mod/quiz/edit.php b/mod/quiz/edit.php                                                                  
index 884fa23..ce331bf 100644                                                                                       
--- a/mod/quiz/edit.php                                                                                             
+++ b/mod/quiz/edit.php                                                                                             
@@ -84,15 +84,7 @@ function module_specific_controls($totalnumber, $recurse, $category, $cmid, $cmo                 
                 question_bank::get_qtype('random')->get_available_questions_from_category(                         
                         $category->id, $recurse);                                      

mkolb

SELECT course.fullname AS course, COUNT(course.id) AS students FROM mdl_role_assignments AS asg
JOIN mdl_context AS context ON asg.contextid = context.id AND context.contextlevel = 50 JOIN mdl_user AS u ON u.id = asg.userid JOIN mdl_course AS course ON context.instanceid = course.id WHERE asg.roleid = 5 GROUP BY course.id ORDER BY COUNT(course.id) DESC;

mkolb

<ul>
  <li><a href="https://engagesupport.s3.amazonaws.com/current/faculty.assignments.creating_and_using_rubrics_for_assignments.html">Rubrics</a></li>
  <li><a href="https://engagesupport.s3.amazonaws.com/current/faculty.grades.how_course_grades_are_calculated.html">How grades are calculated</a></li>
  <li><a href="https://engagesupport.s3.amazonaws.com/current/faculty.grades.aggregation_natural.html">Natural aggregation method</a></li>
  <li><a href="https://engagesupport.s3.amazonaws.com/current/faculty.grades.grade_submission_tracker.html">Grade submission tracker</a></li>
  <li><a href="https://engagesupport.s3.amazonaws.com/current/faculty.forums.grading_forums.html">Forum grade book</a></li>
  <li><a href="https://engagesupport.s3.amazonaws.com/current/faculty.forums.rubrics_for_forums.html">Rubrics for forums</a></li>
  <li><a href="https://engagesupport.s3.amazonaws.com/current/studentfaculty.assignments.vericite_plagiarism_prevention.html">VeriCite</a></li>
</ul>