chamilo / chamilo-lms

main/badge/criteria.php

Spacing +1 added lines, -1 removed lines

@@ -15,7 +15,7 @@
         Display::return_message(get_lang('SkillNotFound'), 'error')
     );
 
-    header('Location: ' . api_get_path(WEB_PATH));
+    header('Location: '.api_get_path(WEB_PATH));
     exit;
 }
 

main/badge/issued.php

Spacing +10 added lines, -10 removed lines

@@ -12,7 +12,7 @@ 
 $skillId = isset($_GET['skill']) ? intval($_GET['skill']) : 0;
 
 if (!isset($_GET['user'], $_GET['skill'])) {
-    header('Location: ' . api_get_path(WEB_PATH));
+    header('Location: '.api_get_path(WEB_PATH));
     exit;
 }
 
@@ -25,7 +25,7 @@ 
         Display::return_message(get_lang('NoResults'), 'error')
     );
 
-    header('Location: ' . api_get_path(WEB_PATH));
+    header('Location: '.api_get_path(WEB_PATH));
     exit;
 }
 
@@ -40,7 +40,7 @@ 
         Display::return_message(get_lang('TheUserXNotYetAchievedTheSkillX'), 'error')
     );
 
-    header('Location: ' . api_get_path(WEB_PATH));
+    header('Location: '.api_get_path(WEB_PATH));
     exit;
 }
 
@@ -78,7 +78,7 @@ 
         'date_issued' => api_format_date($userSkillDate, DATE_TIME_FORMAT_LONG)
     ];
 
-    $assertionUrl = api_get_path(WEB_CODE_PATH) . "badge/assertion.php?";
+    $assertionUrl = api_get_path(WEB_CODE_PATH)."badge/assertion.php?";
     $assertionUrl .= http_build_query(array(
         'user' => $user->getId(),
         'skill' => $skill->getId(),
@@ -100,11 +100,11 @@ 
         $backpack = $configBackpack;
     }
 
-    $htmlHeadXtra[] = '<script src="' . $backpack . 'issuer.js"></script>';
+    $htmlHeadXtra[] = '<script src="'.$backpack.'issuer.js"></script>';
 }
 $objSkill = new Skill();
 $skills = $objSkill->get($skillId);
-$unbakedBadge = api_get_path(SYS_UPLOAD_PATH) . "badges/".$skills['icon'];
+$unbakedBadge = api_get_path(SYS_UPLOAD_PATH)."badges/".$skills['icon'];
 
 $unbakedBadge = file_get_contents($unbakedBadge);
 $badgeInfoError = false;
@@ -119,12 +119,12 @@ 
         mkdir($bakedBadge, api_get_permissions_for_new_directories(), true);
     }
     $skillRelUserId = $userSkills[0]->getId();
-    if (!file_exists($bakedBadge . "/badge_" . $skillRelUserId)) {
-        file_put_contents($bakedBadge . "/badge_" . $skillRelUserId . ".png", $bakedInfo);
+    if (!file_exists($bakedBadge."/badge_".$skillRelUserId)) {
+        file_put_contents($bakedBadge."/badge_".$skillRelUserId.".png", $bakedInfo);
     }
     
     //Process to validate a baked badge
-    $badgeContent = file_get_contents($bakedBadge . "/badge_" . $skillRelUserId . ".png");
+    $badgeContent = file_get_contents($bakedBadge."/badge_".$skillRelUserId.".png");
     $verifyBakedBadge = $png->extractBadgeInfo($badgeContent);
     if (!is_array($verifyBakedBadge)) {
         $badgeInfoError = true;
@@ -132,7 +132,7 @@ 
 
     if (!$badgeInfoError) {
         $personalBadge = UserManager::getUserPathById($userId, "web");
-        $personalBadge = $personalBadge."badges/badge_" . $skillRelUserId . ".png";  
+        $personalBadge = $personalBadge."badges/badge_".$skillRelUserId.".png";  
     }
 }
 

main/help/allowed_html_tags.php

Indentation +4 added lines, -4 removed lines

@@ -53,10 +53,10 @@
 $table_header[] = array('tag', true);
 $table_header[] = array('attributes', false);
 foreach ($tags as $tag => & $attributes) {
-	$row = array();
-	$row[] = '<kbd>'.$tag.'</kbd>';
-	$row[] = '<kbd>&nbsp;'.implode(', ', array_keys($attributes)).'</kbd>';
-	$table_data[] = $row;
+    $row = array();
+    $row[] = '<kbd>'.$tag.'</kbd>';
+    $row[] = '<kbd>&nbsp;'.implode(', ', array_keys($attributes)).'</kbd>';
+    $table_data[] = $row;
 }
 Display::display_sortable_table($table_header, $table_data, array(), array(), array('fullpage' => intval($_GET['fullpage'])));
 ?>

main/help/faq.php

Indentation +3 added lines, -3 removed lines

@@ -41,9 +41,9 @@
         $form->display();
     }
 } else {
-	$faq_content = @(string)file_get_contents(api_get_path(SYS_APP_PATH).'home/'.$faq_file);
-	$faq_content = api_to_system_encoding($faq_content, api_detect_encoding(strip_tags($faq_content)));
-	echo $faq_content;
+    $faq_content = @(string)file_get_contents(api_get_path(SYS_APP_PATH).'home/'.$faq_file);
+    $faq_content = api_to_system_encoding($faq_content, api_detect_encoding(strip_tags($faq_content)));
+    echo $faq_content;
 }
 
 Display::display_footer();

Spacing +2 added lines, -2 removed lines

@@ -23,7 +23,7 @@ 
     $form = new FormValidator('set_faq', 'post', 'faq.php?edit=true');
     $form->addHtmlEditor('faq_content', null, false, false, array('ToolbarSet' => 'FAQ', 'Width' => '100%', 'Height' => '300'));
     $form->addButtonSave(get_lang('Ok'), 'faq_submit');
-    $faq_content = @(string)file_get_contents(api_get_path(SYS_APP_PATH).'home/faq.html');
+    $faq_content = @(string) file_get_contents(api_get_path(SYS_APP_PATH).'home/faq.html');
     $faq_content = api_to_system_encoding($faq_content, api_detect_encoding(strip_tags($faq_content)));
     $form->setDefaults(array('faq_content' => $faq_content));
     if ($form->validate()) {
@@ -41,7 +41,7 @@ 
         $form->display();
     }
 } else {
-	$faq_content = @(string)file_get_contents(api_get_path(SYS_APP_PATH).'home/'.$faq_file);
+	$faq_content = @(string) file_get_contents(api_get_path(SYS_APP_PATH).'home/'.$faq_file);
 	$faq_content = api_to_system_encoding($faq_content, api_detect_encoding(strip_tags($faq_content)));
 	echo $faq_content;
 }

main/reports/reports.lib.php

Indentation +10 added lines, -10 removed lines

@@ -14,9 +14,9 @@ 
 
 // load templates 
 function reports_loadTemplates() {
-	global $reports_enabled_templates, $reports_template;
-	foreach ($reports_enabled_templates as $t)
-		require_once 'templates/'.$t.'.reports.php';
+    global $reports_enabled_templates, $reports_template;
+    foreach ($reports_enabled_templates as $t)
+        require_once 'templates/'.$t.'.reports.php';
 }
 
 
@@ -149,18 +149,18 @@ 
  */
 // return tools ID (parametre is a constant from main_api
 function reports_getToolId($tool) {
-	$tools = array_flip(api_get_tools_lists());
-	if (array_key_exists($tool, $tools)) 
-		return $tools[$tool];
-	else
-		return null;
+    $tools = array_flip(api_get_tools_lists());
+    if (array_key_exists($tool, $tools)) 
+        return $tools[$tool];
+    else
+        return null;
 }
 
 // return a sql clause returning triplet of (course, $session, $uid) the
 // current user is authorized to reed
 function reports_getVisibilitySQL () {
-	return "select cru.user_id from ".Database::get_main_table(TABLE_MAIN_COURSE_USER).' cru';
-	// fixme sessions
+    return "select cru.user_id from ".Database::get_main_table(TABLE_MAIN_COURSE_USER).' cru';
+    // fixme sessions
 }
 
 // this function execute keys_query (SQL statement)

Spacing +3 added lines, -3 removed lines

@@ -3,11 +3,11 @@ 
 require_once '../inc/global.inc.php';
 
 
-define ('REPORTS_PROGRESS_COMPLETED', 1);
+define('REPORTS_PROGRESS_COMPLETED', 1);
 
 $reports_modules = array();
 
-$reports_enabled_modules = array('quiz','course','scorm');
+$reports_enabled_modules = array('quiz', 'course', 'scorm');
 
 $reports_enabled_templates = array('exercicesMultiCourses', 'courseTime', 'courseArticulate');
 
@@ -158,7 +158,7 @@ 
 
 // return a sql clause returning triplet of (course, $session, $uid) the
 // current user is authorized to reed
-function reports_getVisibilitySQL () {
+function reports_getVisibilitySQL() {
 	return "select cru.user_id from ".Database::get_main_table(TABLE_MAIN_COURSE_USER).' cru';
 	// fixme sessions
 }

Braces +10 added lines, -8 removed lines

@@ -15,9 +15,10 @@ 
 // load templates 
 function reports_loadTemplates() {
 	global $reports_enabled_templates, $reports_template;
-	foreach ($reports_enabled_templates as $t)
-		require_once 'templates/'.$t.'.reports.php';
-}
+	foreach ($reports_enabled_templates as $t) {
+			require_once 'templates/'.$t.'.reports.php';
+	}
+	}
 
 
 // clear all reporting data
@@ -150,11 +151,12 @@ 
 // return tools ID (parametre is a constant from main_api
 function reports_getToolId($tool) {
 	$tools = array_flip(api_get_tools_lists());
-	if (array_key_exists($tool, $tools)) 
-		return $tools[$tool];
-	else
-		return null;
-}
+	if (array_key_exists($tool, $tools)) {
+			return $tools[$tool];
+	} else {
+			return null;
+	}
+	}
 
 // return a sql clause returning triplet of (course, $session, $uid) the
 // current user is authorized to reed

main/reports/index.php

Indentation +2 added lines, -2 removed lines

@@ -134,14 +134,14 @@
                         <select class="input_field_12em link required" name="type" id="type">
 <?php
 foreach ($reports_template as $key => $value) {
-	echo '<option value="'.$key.'">'.$value['description'].'</option>';
+    echo '<option value="'.$key.'">'.$value['description'].'</option>';
 }
 ?>
                         </select><br />
                     </span>
 <?php
 foreach ($reports_template as $key => $value) {
-	echo $value['wizard'];
+    echo $value['wizard'];
 }
 ?>
                     <span id="format" class="step submit_step">

Spacing +1 added lines, -1 removed lines

@@ -22,7 +22,7 @@
 $this_section = SECTION_REPORTS;
 
 // setting the name of the tool
-$tool_name=get_lang('Reports');
+$tool_name = get_lang('Reports');
 
 // Displaying the header
 foreach (array('jquery.ba-bbq.min.js', 'jquery.validate.js', 'jquery.form.js', 'jquery.form.wizard.js', 'jquery.dataTables.min.js') as $js)

Braces +2 added lines, -1 removed lines

@@ -25,8 +25,9 @@
 $tool_name=get_lang('Reports');
 
 // Displaying the header
-foreach (array('jquery.ba-bbq.min.js', 'jquery.validate.js', 'jquery.form.js', 'jquery.form.wizard.js', 'jquery.dataTables.min.js') as $js)
+foreach (array('jquery.ba-bbq.min.js', 'jquery.validate.js', 'jquery.form.js', 'jquery.form.wizard.js', 'jquery.dataTables.min.js') as $js) {
     $htmlHeadXtra[] = '<script src="'.api_get_path(WEB_LIBRARY_PATH).'javascript/'.$js.'" type="text/javascript" language="javascript"></script>'."\n";
+}
 
 // FIXME
 $htmlHeadXtra[] = '    <style type="text/css">

main/reports/multiquery.lib.php

Indentation +46 added lines, -46 removed lines

@@ -2,62 +2,62 @@
 
 // get fields informations
 function multiquery_query($array) {
-	$result = array();
-	$field = 0;
-	for ($i = 0; $i <sizeof($array); $i++) {
-		// mysql handler
-		$result[$i]['mysql'] = mysql_query($array[$i]);
-
-		if (! $result[$i]['mysql'])
-			die("error in query $i : ".$array[$i]);
-
-		// fields
-		$result[$i]['num_fields'] = mysql_num_fields($result[$i]['mysql']);
-		for ($j = 0; $j < $result[$i]['num_fields']; $j++) {
-			$name = mysql_field_name($result[$i]['mysql'], $j);
-			$result['field'][$field]['query']=$i;
-			$result['field'][$field]['name']=$name;
-			$result['field'][$field]['id']=$j;
-			$result['field_assoc'][$name][$field];
-			$field++;
-		}
-	}
-	$result['num_queries'] = sizeof($array);
-	// rows
-	$numberOfResult = mysql_num_rows($result[0]['mysql']);
-	for ($i = 1; $i <$result['num_queries']; $i++) 
-		if ($numberOfResult != mysql_num_rows($result[$i]['mysql']))
-			die("wrong number of row: $numberOfResult vs ".
-				mysql_num_rows($result[$i]['mysql'])." on query $i");
-
-	$result['num_rows'] = $numberOfResult;
-	$result['num_fields'] = $field;
-
-	return $result;
+    $result = array();
+    $field = 0;
+    for ($i = 0; $i <sizeof($array); $i++) {
+        // mysql handler
+        $result[$i]['mysql'] = mysql_query($array[$i]);
+
+        if (! $result[$i]['mysql'])
+            die("error in query $i : ".$array[$i]);
+
+        // fields
+        $result[$i]['num_fields'] = mysql_num_fields($result[$i]['mysql']);
+        for ($j = 0; $j < $result[$i]['num_fields']; $j++) {
+            $name = mysql_field_name($result[$i]['mysql'], $j);
+            $result['field'][$field]['query']=$i;
+            $result['field'][$field]['name']=$name;
+            $result['field'][$field]['id']=$j;
+            $result['field_assoc'][$name][$field];
+            $field++;
+        }
+    }
+    $result['num_queries'] = sizeof($array);
+    // rows
+    $numberOfResult = mysql_num_rows($result[0]['mysql']);
+    for ($i = 1; $i <$result['num_queries']; $i++) 
+        if ($numberOfResult != mysql_num_rows($result[$i]['mysql']))
+            die("wrong number of row: $numberOfResult vs ".
+                mysql_num_rows($result[$i]['mysql'])." on query $i");
+
+    $result['num_rows'] = $numberOfResult;
+    $result['num_fields'] = $field;
+
+    return $result;
 }
 
 function multiquery_num_rows(&$mq_h) {
-	return $mq_h['num_rows'];
+    return $mq_h['num_rows'];
 }
 
 function multiquery_num_fields(&$mq_h) {
-	return $mq_h['num_fields'];
+    return $mq_h['num_fields'];
 }
 
 function multiquery_field_name(&$mq_h, $id) {
-	return $mq_h['field'][$id]['name'];
+    return $mq_h['field'][$id]['name'];
 }
 
 function multiquery_fetch_row(&$mq_h) {
-	$result = array();
-	$pos = 0;
-	for ($i = 0; $i < $mq_h['num_queries']; $i++) {
-		$row = mysql_fetch_row($mq_h[$i]['mysql']);
-		if (!$row) return false; // last line
-		for ($j = 0; $j < sizeof($row); $j++) {
-			$result[$pos] = $row[$j];
-			$pos++;
-		}
-	}
-	return $result;
+    $result = array();
+    $pos = 0;
+    for ($i = 0; $i < $mq_h['num_queries']; $i++) {
+        $row = mysql_fetch_row($mq_h[$i]['mysql']);
+        if (!$row) return false; // last line
+        for ($j = 0; $j < sizeof($row); $j++) {
+            $result[$pos] = $row[$j];
+            $pos++;
+        }
+    }
+    return $result;
 }

Spacing +6 added lines, -6 removed lines

@@ -4,20 +4,20 @@ 
 function multiquery_query($array) {
 	$result = array();
 	$field = 0;
-	for ($i = 0; $i <sizeof($array); $i++) {
+	for ($i = 0; $i < sizeof($array); $i++) {
 		// mysql handler
 		$result[$i]['mysql'] = mysql_query($array[$i]);
 
-		if (! $result[$i]['mysql'])
+		if (!$result[$i]['mysql'])
 			die("error in query $i : ".$array[$i]);
 
 		// fields
 		$result[$i]['num_fields'] = mysql_num_fields($result[$i]['mysql']);
 		for ($j = 0; $j < $result[$i]['num_fields']; $j++) {
 			$name = mysql_field_name($result[$i]['mysql'], $j);
-			$result['field'][$field]['query']=$i;
-			$result['field'][$field]['name']=$name;
-			$result['field'][$field]['id']=$j;
+			$result['field'][$field]['query'] = $i;
+			$result['field'][$field]['name'] = $name;
+			$result['field'][$field]['id'] = $j;
 			$result['field_assoc'][$name][$field];
 			$field++;
 		}
@@ -25,7 +25,7 @@ 
 	$result['num_queries'] = sizeof($array);
 	// rows
 	$numberOfResult = mysql_num_rows($result[0]['mysql']);
-	for ($i = 1; $i <$result['num_queries']; $i++) 
+	for ($i = 1; $i < $result['num_queries']; $i++) 
 		if ($numberOfResult != mysql_num_rows($result[$i]['mysql']))
 			die("wrong number of row: $numberOfResult vs ".
 				mysql_num_rows($result[$i]['mysql'])." on query $i");

Braces +10 added lines, -5 removed lines

@@ -8,8 +8,9 @@ 
 		// mysql handler
 		$result[$i]['mysql'] = mysql_query($array[$i]);
 
-		if (! $result[$i]['mysql'])
-			die("error in query $i : ".$array[$i]);
+		if (! $result[$i]['mysql']) {
+					die("error in query $i : ".$array[$i]);
+		}
 
 		// fields
 		$result[$i]['num_fields'] = mysql_num_fields($result[$i]['mysql']);
@@ -25,10 +26,11 @@ 
 	$result['num_queries'] = sizeof($array);
 	// rows
 	$numberOfResult = mysql_num_rows($result[0]['mysql']);
-	for ($i = 1; $i <$result['num_queries']; $i++) 
-		if ($numberOfResult != mysql_num_rows($result[$i]['mysql']))
+	for ($i = 1; $i <$result['num_queries']; $i++) {
+			if ($numberOfResult != mysql_num_rows($result[$i]['mysql']))
 			die("wrong number of row: $numberOfResult vs ".
 				mysql_num_rows($result[$i]['mysql'])." on query $i");
+	}
 
 	$result['num_rows'] = $numberOfResult;
 	$result['num_fields'] = $field;
@@ -53,7 +55,10 @@ 
 	$pos = 0;
 	for ($i = 0; $i < $mq_h['num_queries']; $i++) {
 		$row = mysql_fetch_row($mq_h[$i]['mysql']);
-		if (!$row) return false; // last line
+		if (!$row) {
+		    return false;
+		}
+		// last line
 		for ($j = 0; $j < sizeof($row); $j++) {
 			$result[$pos] = $row[$j];
 			$pos++;

main/reports/modules/quiz.php

Indentation +18 added lines, -18 removed lines

@@ -7,27 +7,27 @@
 }
 
 function reports_modules_quiz_init_forEachCourses($course_code, $course_id, $course_db) {
-	global $reports_modules;
+    global $reports_modules;
 	
-	$reports_modules_quiz_toolid = reports_getToolId(TOOL_QUIZ);
+    $reports_modules_quiz_toolid = reports_getToolId(TOOL_QUIZ);
 
-	array_push($reports_modules['quiz'], 
-	  array('keys_query' =>  
-		'select '.$course_id.' as course_id, '.
-		$reports_modules_quiz_toolid.' as tool_id, '.
-		'q.id as child_id, q.title as child_name, '.
-		"'".$course_code."'".' as course_code from '.Database::get_course_table(TABLE_QUIZ_TEST).' q ',
-		'values_query_function' => 'reports_modules_quiz_quizVal'));		
+    array_push($reports_modules['quiz'], 
+        array('keys_query' =>  
+        'select '.$course_id.' as course_id, '.
+        $reports_modules_quiz_toolid.' as tool_id, '.
+        'q.id as child_id, q.title as child_name, '.
+        "'".$course_code."'".' as course_code from '.Database::get_course_table(TABLE_QUIZ_TEST).' q ',
+        'values_query_function' => 'reports_modules_quiz_quizVal'));		
 }
 
 function reports_modules_quiz_quizVal($quiz, $key_id) {
-	$courseId = api_get_course_int_id($quiz['course_code']);
-	return array('type'=> 'sql', 'sql' => 
-			'select '.$key_id.', exe_user_id as uid, '.
-			'session_id, -1 as attempt, exe_result as score, '.
-			REPORTS_PROGRESS_COMPLETED.' as progress, '.
-			'exe_duration as time, exe_date as ts from '.
-			Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES).
-			' where c_id = ' . $courseId .
-			' and exe_exo_id='.$quiz['child_id']);
+    $courseId = api_get_course_int_id($quiz['course_code']);
+    return array('type'=> 'sql', 'sql' => 
+            'select '.$key_id.', exe_user_id as uid, '.
+            'session_id, -1 as attempt, exe_result as score, '.
+            REPORTS_PROGRESS_COMPLETED.' as progress, '.
+            'exe_duration as time, exe_date as ts from '.
+            Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES).
+            ' where c_id = ' . $courseId .
+            ' and exe_exo_id='.$quiz['child_id']);
 }

Spacing +2 added lines, -2 removed lines

@@ -1,6 +1,6 @@ 
 <?php 
 
-$reports_modules['quiz'] = array ();
+$reports_modules['quiz'] = array();
 
 
 function reports_modules_quiz_init() {
@@ -28,6 +28,6 @@ 
 			REPORTS_PROGRESS_COMPLETED.' as progress, '.
 			'exe_duration as time, exe_date as ts from '.
 			Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES).
-			' where c_id = ' . $courseId .
+			' where c_id = '.$courseId.
 			' and exe_exo_id='.$quiz['child_id']);
 }

main/reports/modules/scorm.php

Indentation +100 added lines, -100 removed lines

@@ -7,117 +7,117 @@
 }
 
 function reports_modules_scorm_init_forEachCourses($course_code, $course_id, $course_db) {
-	global $reports_modules;
+    global $reports_modules;
 	
-	$reports_modules_scorm_toolid = reports_getToolId(TOOL_LEARNPATH);
+    $reports_modules_scorm_toolid = reports_getToolId(TOOL_LEARNPATH);
 
-	// package level
-	array_push($reports_modules['scorm'], 
-	  array('keys_query' =>  
-		'select '.$course_id.' as course_id, '.
-		$reports_modules_scorm_toolid.' as tool_id, '.
-		'lp.id as child_id, lp.name as child_name, '.
-		"'".$course_db."'".' as course_db from '.
-		Database::get_course_table(TABLE_LP_MAIN).' lp',
-		'values_query_function' => 'reports_modules_scorm_packageVal'));		
+    // package level
+    array_push($reports_modules['scorm'], 
+        array('keys_query' =>  
+        'select '.$course_id.' as course_id, '.
+        $reports_modules_scorm_toolid.' as tool_id, '.
+        'lp.id as child_id, lp.name as child_name, '.
+        "'".$course_db."'".' as course_db from '.
+        Database::get_course_table(TABLE_LP_MAIN).' lp',
+        'values_query_function' => 'reports_modules_scorm_packageVal'));		
 
-	// sco level
-	array_push($reports_modules['scorm'], 
-	  array('keys_query' =>  
-		'select '.$course_id.' as course_id, '.
-		$reports_modules_scorm_toolid.' as tool_id, '.
-		'lp.id as child_id, lp.name as child_name, '.
-		'lpi.id as subchild_id, lpi.title as subchild_name, '.
-		"'".$course_db."'".' as course_db from '.
-		Database::get_course_table(TABLE_LP_MAIN, $course_db).
-		' lp,'.
-		Database::get_course_table(TABLE_LP_ITEM, $course_db).
-		' lpi where lp.id = lpi.lp_id',
-		'values_query_function' => 'reports_modules_scorm_scoVal'));		
+    // sco level
+    array_push($reports_modules['scorm'], 
+        array('keys_query' =>  
+        'select '.$course_id.' as course_id, '.
+        $reports_modules_scorm_toolid.' as tool_id, '.
+        'lp.id as child_id, lp.name as child_name, '.
+        'lpi.id as subchild_id, lpi.title as subchild_name, '.
+        "'".$course_db."'".' as course_db from '.
+        Database::get_course_table(TABLE_LP_MAIN, $course_db).
+        ' lp,'.
+        Database::get_course_table(TABLE_LP_ITEM, $course_db).
+        ' lpi where lp.id = lpi.lp_id',
+        'values_query_function' => 'reports_modules_scorm_scoVal'));		
 
-	// objectives level
-	array_push($reports_modules['scorm'], 
-	  array('keys_query' =>  
-		'select distinct '.$course_id.' as course_id, '.
-		$reports_modules_scorm_toolid.' as tool_id, '.
-		'lp.id as child_id, lp.name as child_name, '.
-		'lpi.id as subchild_id, '.
-		'lpi.title as subchild_name, '.
-		'null as subsubchild_id, '.
-		'lpivo.objective_id as subsubchild_name, '.
-		"'".$course_db."'".' as course_db from '.
-		Database::get_course_table(TABLE_LP_MAIN, $course_db).
-		' lp,'.
-		Database::get_course_table(TABLE_LP_ITEM, $course_db).
-		' lpi, '.
-		Database::get_course_table(TABLE_LP_ITEM_VIEW, $course_db).
-		' lpiv, '.
-		Database::get_course_table(TABLE_LP_IV_OBJECTIVE, $course_db).
-		' lpivo '.
-		'where lp.id = lpi.lp_id '.
-		'and lpi.id = lpiv.lp_item_id '.
-		'and lpiv.id = lpivo.lp_iv_id ',
-		'values_query_function' => 'reports_modules_scorm_objVal'));		
+    // objectives level
+    array_push($reports_modules['scorm'], 
+        array('keys_query' =>  
+        'select distinct '.$course_id.' as course_id, '.
+        $reports_modules_scorm_toolid.' as tool_id, '.
+        'lp.id as child_id, lp.name as child_name, '.
+        'lpi.id as subchild_id, '.
+        'lpi.title as subchild_name, '.
+        'null as subsubchild_id, '.
+        'lpivo.objective_id as subsubchild_name, '.
+        "'".$course_db."'".' as course_db from '.
+        Database::get_course_table(TABLE_LP_MAIN, $course_db).
+        ' lp,'.
+        Database::get_course_table(TABLE_LP_ITEM, $course_db).
+        ' lpi, '.
+        Database::get_course_table(TABLE_LP_ITEM_VIEW, $course_db).
+        ' lpiv, '.
+        Database::get_course_table(TABLE_LP_IV_OBJECTIVE, $course_db).
+        ' lpivo '.
+        'where lp.id = lpi.lp_id '.
+        'and lpi.id = lpiv.lp_item_id '.
+        'and lpiv.id = lpivo.lp_iv_id ',
+        'values_query_function' => 'reports_modules_scorm_objVal'));		
 }
 
 function reports_modules_scorm_packageVal($scorm, $key_id) {
-	return array('type'=> 'sql', 'sql' => 
-			'select '.$key_id.', user_id as uid, '.
-			'session_id, view_count as attempt, null as score, '.
-			'progress as progress, '.
-			'null as time, null as ts from '.
-			Database::get_course_table(TABLE_LP_VIEW, $scorm['course_db']).
-			' where lp_id = '.$scorm['child_id']);
+    return array('type'=> 'sql', 'sql' => 
+            'select '.$key_id.', user_id as uid, '.
+            'session_id, view_count as attempt, null as score, '.
+            'progress as progress, '.
+            'null as time, null as ts from '.
+            Database::get_course_table(TABLE_LP_VIEW, $scorm['course_db']).
+            ' where lp_id = '.$scorm['child_id']);
 }
 
 function reports_modules_scorm_scoVal($scorm, $key_id) {
-	return array('type'=> 'sql', 'sql' => 
-			'select '.$key_id.', lpv.user_id as uid, '.
-			'lpv.session_id, lpiv.view_count as attempt, '.
-			'lpiv.score as score, '.
-			'(case lpiv.status '.
-				'when "incomplete" then 0 '.
-				'when "completed" then 1 '.
-				'when "passed" then 2 '.
-				'when "failed" then 3 '.
-				'when "browsed" then 4 '.
-				'when "not attempted" then 5 '.
-				'else 6 '.
-			'end) as progress, '.
-			'lpiv.total_time as time, null as ts from '.
-			Database::get_course_table(TABLE_LP_VIEW, $scorm['course_db']).
-			' lpv, '.
-			Database::get_course_table(TABLE_LP_ITEM_VIEW, $scorm['course_db']).
-			' lpiv '.
-			' where lpv.lp_id = '.$scorm['child_id'].
-			' and lpiv.lp_item_id = '.$scorm['subchild_id'].
-			' and lpiv.lp_view_id = lpv.id');
+    return array('type'=> 'sql', 'sql' => 
+            'select '.$key_id.', lpv.user_id as uid, '.
+            'lpv.session_id, lpiv.view_count as attempt, '.
+            'lpiv.score as score, '.
+            '(case lpiv.status '.
+                'when "incomplete" then 0 '.
+                'when "completed" then 1 '.
+                'when "passed" then 2 '.
+                'when "failed" then 3 '.
+                'when "browsed" then 4 '.
+                'when "not attempted" then 5 '.
+                'else 6 '.
+            'end) as progress, '.
+            'lpiv.total_time as time, null as ts from '.
+            Database::get_course_table(TABLE_LP_VIEW, $scorm['course_db']).
+            ' lpv, '.
+            Database::get_course_table(TABLE_LP_ITEM_VIEW, $scorm['course_db']).
+            ' lpiv '.
+            ' where lpv.lp_id = '.$scorm['child_id'].
+            ' and lpiv.lp_item_id = '.$scorm['subchild_id'].
+            ' and lpiv.lp_view_id = lpv.id');
 }
 
 function reports_modules_scorm_objVal($scorm, $key_id) {
-	return array('type'=> 'sql', 'sql' => 
-			'select '.$key_id.', lpv.user_id as uid, '.
-			'lpv.session_id, lpiv.view_count as attempt, '.
-			'lpivo.score_raw as score, '.
-			'(case lpivo.status '.
-				'when "incomplete" then 0 '.
-				'when "completed" then 1 '.
-				'when "passed" then 2 '.
-				'when "failed" then 3 '.
-				'when "browsed" then 4 '.
-				'when "not attempted" then 5 '.
-				'else 6 '.
-			'end) as progress, '.
-			'null as time, null as ts from '.
-			Database::get_course_table(TABLE_LP_VIEW, $scorm['course_db']).
-			' lpv, '.
-			Database::get_course_table(TABLE_LP_ITEM_VIEW, $scorm['course_db']).
-			' lpiv, '.
-			Database::get_course_table(TABLE_LP_IV_OBJECTIVE, $scorm['course_db']).
-			' lpivo '.
-			' where lpv.lp_id = '.$scorm['child_id'].
-			' and lpiv.lp_item_id = '.$scorm['subchild_id'].
-			' and lpivo.objective_id = "'.$scorm['subsubchild_name'].'" '.
-			' and lpiv.lp_view_id = lpv.id'.
-			' and lpivo.lp_iv_id=lpiv.id');
+    return array('type'=> 'sql', 'sql' => 
+            'select '.$key_id.', lpv.user_id as uid, '.
+            'lpv.session_id, lpiv.view_count as attempt, '.
+            'lpivo.score_raw as score, '.
+            '(case lpivo.status '.
+                'when "incomplete" then 0 '.
+                'when "completed" then 1 '.
+                'when "passed" then 2 '.
+                'when "failed" then 3 '.
+                'when "browsed" then 4 '.
+                'when "not attempted" then 5 '.
+                'else 6 '.
+            'end) as progress, '.
+            'null as time, null as ts from '.
+            Database::get_course_table(TABLE_LP_VIEW, $scorm['course_db']).
+            ' lpv, '.
+            Database::get_course_table(TABLE_LP_ITEM_VIEW, $scorm['course_db']).
+            ' lpiv, '.
+            Database::get_course_table(TABLE_LP_IV_OBJECTIVE, $scorm['course_db']).
+            ' lpivo '.
+            ' where lpv.lp_id = '.$scorm['child_id'].
+            ' and lpiv.lp_item_id = '.$scorm['subchild_id'].
+            ' and lpivo.objective_id = "'.$scorm['subsubchild_name'].'" '.
+            ' and lpiv.lp_view_id = lpv.id'.
+            ' and lpivo.lp_iv_id=lpiv.id');
 }

Spacing +1 added lines, -1 removed lines

@@ -1,6 +1,6 @@
 <?php 
 
-$reports_modules['scorm'] = array ();
+$reports_modules['scorm'] = array();
 
 
 function reports_modules_scorm_init() {