...and also
/blocks/ilp/reports.php
line 115
'report3' => 'Report 3 Total'
should read
'report3' => 'Report 3 Total',
'report4' => 'Report 4 Total'
line 185
$report['report3'] = count_records_sql('SELECT COUNT
FROM '.$CFG->prefix.'ilpconcern_posts WHERE setforuserid = '.$user->id.' AND status = "2"' );
should read
$report['report3'] = count_records_sql('SELECT COUNT
FROM '.$CFG->prefix.'ilpconcern_posts WHERE setforuserid = '.$user->id.' AND status = "2"' );
$report['report4'] = count_records_sql('SELECT COUNT
FROM '.$CFG->prefix.'ilpconcern_posts WHERE setforuserid = '.$user->id.' AND status = "3"' );
line 210
'report3' => 'Report 3 Total'
should read
'report3' => 'Report 3 Total',
'report4' => 'Report 4 Total'
line 262
$report['report3'] = count_records_sql('SELECT COUNT
FROM '.$CFG->prefix.'ilpconcern_posts WHERE course = '.$course->id.' AND status = "2"' );
should read
$report['report3'] = count_records_sql('SELECT COUNT
FROM '.$CFG->prefix.'ilpconcern_posts WHERE course = '.$course->id.' AND status = "2"' );
$report['report4'] = count_records_sql('SELECT COUNT
FROM '.$CFG->prefix.'ilpconcern_posts WHERE course = '.$course->id.' AND status = "3"' );
Here are a few tweaks to allow the for the new 4th report type from latest version (created from CVS) downloaded on 4 October 2009
/mod/ilpconcern/view_students.php
Starting at line 467
if($CFG->ilpconcern_report4 == 1){ $report3total = count_records_sql('SELECT COUNT(*) FROM '.$CFG->prefix.'ilpconcern_posts WHERE setforuserid = '.$auser->id.' AND status = 3' ); $report3text = '<a href="concerns_view.php'.$link_values.'&userid='.$auser->id.'&status=3">'.$report3total.' '.get_string('report4plural', 'ilpconcern').'</a>'; $row[] .= $report4text; }
should read
if($CFG->ilpconcern_report4 == 1){ $report4total = count_records_sql('SELECT COUNT(*) FROM '.$CFG->prefix.'ilpconcern_posts WHERE setforuserid = '.$auser->id.' AND status = 3' ); $report4text = '<a href="concerns_view.php'.$link_values.'&userid='.$auser->id.'&status=3">'.$report4total.' '.get_string('report4plural', 'ilpconcern').'</a>'; $row[] .= $report4text; }