chamilo / chamilo-lms

main/session/resume_session.php

Upper-Lower-Casing +1 added lines, -1 removed lines

@@ -95,7 +95,7 @@
             $result = Database::query("DELETE FROM $tbl_session_rel_class
                              WHERE session_id='$sessionId' AND class_id=".intval($_GET['class']));
             $nbr_affected_rows = Database::affected_rows($result);
-            Database::query("UPDATE $tbl_session SET nbr_classes=nbr_classes-$nbr_affected_rows WHERE id='$sessionId'");
+            Database::query("update $tbl_session SET nbr_classes=nbr_classes-$nbr_affected_rows WHERE id='$sessionId'");
         }
 
         if (!empty($_GET['user'])) {

Spacing +1 added lines, -1 removed lines

@@ -171,7 +171,7 @@
         $namesOfCoaches = [];
         $coachSubscriptions = $session
             ->getUserCourseSubscriptionsByStatus($course, Session::COACH)
-            ->forAll(function ($index, SessionRelCourseRelUser $subscription) use (&$namesOfCoaches) {
+            ->forAll(function($index, SessionRelCourseRelUser $subscription) use (&$namesOfCoaches) {
                 $namesOfCoaches[] = $subscription->getUser()->getCompleteNameWithUserName();
 
                 return true;

main/session/session_course_user_list.php

Upper-Lower-Casing +1 added lines, -1 removed lines

@@ -65,7 +65,7 @@
                     WHERE session_id='$id_session' AND c_id='".$courseId."' AND user_id IN($idChecked)";
             $result = Database::query($sql);
             $nbr_affected_rows = Database::affected_rows($result);
-            $sql = "UPDATE $tbl_session_rel_course SET nbr_users=nbr_users-$nbr_affected_rows
+            $sql = "update $tbl_session_rel_course SET nbr_users=nbr_users-$nbr_affected_rows
                     WHERE session_id='$id_session' AND c_id='".$courseId."'";
             Database::query($sql);
         }

Switch Indentation +22 added lines, -22 removed lines

@@ -62,30 +62,30 @@
 }
 
 switch ($action) {
-    case 'delete':
-        if (is_array($idChecked) && count($idChecked) > 0) {
-            array_map('intval', $idChecked);
-            $idChecked = implode(',', $idChecked);
-        }
-        if (!empty($idChecked)) {
-            $sql = "DELETE FROM $tbl_session_rel_course_rel_user
+        case 'delete':
+            if (is_array($idChecked) && count($idChecked) > 0) {
+                array_map('intval', $idChecked);
+                $idChecked = implode(',', $idChecked);
+            }
+            if (!empty($idChecked)) {
+                $sql = "DELETE FROM $tbl_session_rel_course_rel_user
                     WHERE session_id='$id_session' AND c_id='".$courseId."' AND user_id IN($idChecked)";
-            $result = Database::query($sql);
-            $nbr_affected_rows = Database::affected_rows($result);
-            $sql = "UPDATE $tbl_session_rel_course SET nbr_users=nbr_users-$nbr_affected_rows
+                $result = Database::query($sql);
+                $nbr_affected_rows = Database::affected_rows($result);
+                $sql = "UPDATE $tbl_session_rel_course SET nbr_users=nbr_users-$nbr_affected_rows
                     WHERE session_id='$id_session' AND c_id='".$courseId."'";
-            Database::query($sql);
-        }
-        header('Location: '.api_get_self()
-            .'?id_session='.$id_session.'&course_code='.urlencode($course_code).'&sort='.$sort);
-        exit();
-        break;
-    case 'add':
-        SessionManager::subscribe_users_to_session_course($idChecked, $id_session, $course_code);
-        header('Location: '.api_get_self()
-            .'?id_session='.$id_session.'&course_code='.urlencode($course_code).'&sort='.$sort);
-        exit;
-        break;
+                Database::query($sql);
+            }
+            header('Location: '.api_get_self()
+                .'?id_session='.$id_session.'&course_code='.urlencode($course_code).'&sort='.$sort);
+            exit();
+            break;
+        case 'add':
+            SessionManager::subscribe_users_to_session_course($idChecked, $id_session, $course_code);
+            header('Location: '.api_get_self()
+                .'?id_session='.$id_session.'&course_code='.urlencode($course_code).'&sort='.$sort);
+            exit;
+            break;
 }
 
 

main/session/session_import.php

Upper-Lower-Casing +3 added lines, -3 removed lines

@@ -284,7 +284,7 @@ 
                                 $session_counter++;
                             } else {
                                 // if the session already exists - update it.
-                                $sql_session = "UPDATE $tbl_session SET
+                                $sql_session = "update $tbl_session SET
                                         id_coach = '$coach_id',
                                         access_start_date = '$date_start',
                                         access_end_date = '$date_end',
@@ -385,12 +385,12 @@ 
                                         $error_message .= get_lang('UserDoesNotExist').' : '.$username.'<br />';
                                     }
                                 }
-                                $sql = "UPDATE $tbl_session_course SET nbr_users='$users_in_course_counter' WHERE c_id='$courseId'";
+                                $sql = "update $tbl_session_course SET nbr_users='$users_in_course_counter' WHERE c_id='$courseId'";
                                 Database::query($sql);
                                 $inserted_in_course[$course_code] = $course_info['title'];
                             }
                         }
-                        Database::query("UPDATE $tbl_session SET nbr_users='$user_counter', nbr_courses='$course_counter' WHERE id='$session_id'");
+                        Database::query("update $tbl_session SET nbr_users='$user_counter', nbr_courses='$course_counter' WHERE id='$session_id'");
                     }
                 }
                 if (empty($root->Users->User) && empty($root->Courses->Course) && empty($root->Session)) {

main/announcements/announcements.php

Upper-Lower-Casing +2 added lines, -2 removed lines

@@ -130,10 +130,10 @@
                 if ($thisAnnouncementOrderFound) {
                     $nextAnnouncementId = $announcementId;
                     $nextAnnouncementOrder = $announcementOrder;
-                    $sql = "UPDATE $tbl_announcement SET display_order = '$nextAnnouncementOrder'
+                    $sql = "update $tbl_announcement SET display_order = '$nextAnnouncementOrder'
                             WHERE c_id = $course_id AND id = $thisAnnouncementId";
                     Database::query($sql);
-                    $sql = "UPDATE $tbl_announcement  SET display_order = '$thisAnnouncementOrder'
+                    $sql = "update $tbl_announcement  SET display_order = '$thisAnnouncementOrder'
                             WHERE c_id = $course_id AND id =  $nextAnnouncementId";
 
                     Database::query($sql);

main/mySpace/coaches.php

Indentation +15 added lines, -15 removed lines

@@ -19,7 +19,7 @@ 
 $interbreadcrumb[] = array("url" => "index.php", "name" => get_lang('MySpace'));
 
 if (isset($_GET["id_student"])) {
-	$interbreadcrumb[] = array("url" => "student.php", "name" => get_lang('Students'));
+    $interbreadcrumb[] = array("url" => "student.php", "name" => get_lang('Students'));
 }
 
 Display :: display_header($nameTools);
@@ -197,25 +197,25 @@ 
                         '.Display::return_icon('2rightarrow.png', get_lang('Details')).'</a>
                     </td>
                     </tr>';
-		}
-
-		if (api_is_western_name_order(PERSON_NAME_DATA_EXPORT)) {
-			$data[$id_coach]["firstname"] = $firstname;
-			$data[$id_coach]["lastname"] = $lastname;
-		} else {
-			$data[$id_coach]["lastname"] = $lastname;
-			$data[$id_coach]["firstname"] = $firstname;
-		}
-		$data[$id_coach]["connection_time"] = $s_connection_time;
-	}
+        }
+
+        if (api_is_western_name_order(PERSON_NAME_DATA_EXPORT)) {
+            $data[$id_coach]["firstname"] = $firstname;
+            $data[$id_coach]["lastname"] = $lastname;
+        } else {
+            $data[$id_coach]["lastname"] = $lastname;
+            $data[$id_coach]["firstname"] = $firstname;
+        }
+        $data[$id_coach]["connection_time"] = $s_connection_time;
+    }
 } else {
-	// No results
-	echo '<tr><td colspan="5">'.get_lang("NoResult").'</td></tr>';
+    // No results
+    echo '<tr><td colspan="5">'.get_lang("NoResult").'</td></tr>';
 }
 echo '</table>';
 
 if (isset($_POST['export'])) {
-	export_csv($header, $data, 'coaches.csv');
+    export_csv($header, $data, 'coaches.csv');
 }
 
 echo "<br /><br />";

main/course_home/vertical_activity.php

Braces +2 added lines, -1 removed lines

@@ -19,7 +19,8 @@
 
 if (api_is_allowed_to_edit(null, true)) {
     // HIDE
-    if (!empty($_GET['hide'])) { // visibility 1 -> 0
+    if (!empty($_GET['hide'])) {
+// visibility 1 -> 0
         $sql = "UPDATE $tool_table SET visibility=0 WHERE c_id = $course_id AND id='".$id."'";
         Database::query($sql);
         $show_message = Display::return_message(get_lang('ToolIsNowHidden'), 'confirmation');

Upper-Lower-Casing +2 added lines, -2 removed lines

@@ -20,13 +20,13 @@
 if (api_is_allowed_to_edit(null, true)) {
     // HIDE
     if (!empty($_GET['hide'])) { // visibility 1 -> 0
-        $sql = "UPDATE $tool_table SET visibility=0 WHERE c_id = $course_id AND id='".$id."'";
+        $sql = "update $tool_table SET visibility=0 WHERE c_id = $course_id AND id='".$id."'";
         Database::query($sql);
         $show_message = Display::return_message(get_lang('ToolIsNowHidden'), 'confirmation');
     } elseif (!empty($_GET['restore'])) {
         // visibility 0,2 -> 1
         // REACTIVATE
-        $sql = "UPDATE $tool_table SET visibility=1  WHERE c_id = $course_id AND id='".$id."'";
+        $sql = "update $tool_table SET visibility=1  WHERE c_id = $course_id AND id='".$id."'";
         Database::query($sql);
         $show_message = Display::return_message(get_lang('ToolIsNowVisible'), 'confirmation');
     }

Indentation +1 added lines, -1 removed lines

@@ -97,7 +97,7 @@
         $content .= '<div class="courseadminview-activity-3col"><span class="viewcaption">'.get_lang('SessionData').'</span>
             <table width="100%">';
                 $content .= CourseHome::show_session_data($session_id);
-             $content .= '</table></div>';
+                $content .= '</table></div>';
     }
 
     $my_list = CourseHome::get_tools_category(TOOL_STUDENT_VIEW);

main/course_home/course_home.php

Braces +2 added lines, -1 removed lines

@@ -176,7 +176,8 @@
 $auto_launch = api_get_course_setting('enable_lp_auto_launch');
 $session_id = api_get_session_id();
 if (!empty($auto_launch)) {
-    if ($auto_launch == 2) { //LP list
+    if ($auto_launch == 2) {
+//LP list
         if (api_is_platform_admin() || api_is_allowed_to_edit()) {
             $show_autolaunch_lp_warning = true;
         } else {

Indentation +1 added lines, -1 removed lines

@@ -240,7 +240,7 @@
         //if (!isset($_SESSION[$forumKey])) {
             //redirecting to the LP
             $url = api_get_path(WEB_CODE_PATH).'forum/index.php?'.api_get_cidreq().'&id_session='.$session_id;
-          //  $_SESSION[$forumKey] = true;
+            //  $_SESSION[$forumKey] = true;
             header("Location: $url");
             exit;
         //}

main/course_home/2column.php

Upper-Lower-Casing +3 added lines, -3 removed lines

@@ -35,16 +35,16 @@
          * Process hiding a tools from available tools.
          * visibility=2 are only view  by Dokeos Administrator (visibility 0,1->2)
          */
-        Database::query("UPDATE $tool_table SET visibility='2' WHERE c_id = $course_id AND id='".$id."'");
+        Database::query("update $tool_table SET visibility='2' WHERE c_id = $course_id AND id='".$id."'");
     } elseif (isset($_GET['hide']) && $_GET['hide']) {
         /*	HIDE */
         // visibility 1 -> 0
-        Database::query("UPDATE $tool_table SET visibility=0 WHERE c_id = $course_id AND id='".$id."'");
+        Database::query("update $tool_table SET visibility=0 WHERE c_id = $course_id AND id='".$id."'");
         $show_message .= Display::return_message(get_lang('ToolIsNowHidden'), 'confirmation');
     } elseif (isset($_GET['restore']) && $_GET["restore"]) {
         // visibility 0,2 -> 1
         /*	REACTIVATE */
-        Database::query("UPDATE $tool_table SET visibility=1  WHERE c_id = $course_id AND id='".$id."'");
+        Database::query("update $tool_table SET visibility=1  WHERE c_id = $course_id AND id='".$id."'");
         $show_message .= Display::return_message(get_lang('ToolIsNowVisible'), 'confirmation');
     }
 }

main/group/group_creation.php

Upper-Lower-Casing +1 added lines, -1 removed lines

@@ -145,7 +145,7 @@
 		</td>
 	</tr>
 
-EOT;
+eot;
         $renderer->setCustomElementTemplate($element_template);
         $form->addElement('header', $nameTools);
         $form->addElement('hidden', 'action');

Indentation +16 added lines, -16 removed lines

@@ -79,11 +79,11 @@ 
 if (isset($_POST['number_of_groups'])) {
     if (!is_numeric($_POST['number_of_groups']) || intval($_POST['number_of_groups']) < 1) {
         echo Display::return_message(
-			get_lang('PleaseEnterValidNumber').'<br /><br />
+            get_lang('PleaseEnterValidNumber').'<br /><br />
 			<a href="group_creation.php?'.api_get_cidreq().'">&laquo; '.get_lang('Back').'</a>',
             'error',
-			false
-		);
+            false
+        );
     } else {
         $number_of_groups = intval($_POST['number_of_groups']);
         if ($number_of_groups > 1) {
@@ -121,20 +121,20 @@ 
     }
     </script>
     <?php
-		}
-		$group_categories = GroupManager::get_categories();
-		$group_id = GroupManager :: get_number_of_groups() + 1;
-		$cat_options = [];
-		foreach ($group_categories as $index => $category) {
-			$cat_options[$category['id']] = $category['title'];
-		}
+        }
+        $group_categories = GroupManager::get_categories();
+        $group_id = GroupManager :: get_number_of_groups() + 1;
+        $cat_options = [];
+        foreach ($group_categories as $index => $category) {
+            $cat_options[$category['id']] = $category['title'];
+        }
         $form = new FormValidator('create_groups_step2', 'POST', api_get_self().'?'.api_get_cidreq());
 
-		// Modify the default templates
-		$renderer = $form->defaultRenderer();
-		$form_template = "<form {attributes}>\n<div class='create-groups'>\n<table>\n{content}\n</table>\n</div>\n</form>";
-		$renderer->setFormTemplate($form_template);
-		$element_template = <<<EOT
+        // Modify the default templates
+        $renderer = $form->defaultRenderer();
+        $form_template = "<form {attributes}>\n<div class='create-groups'>\n<table>\n{content}\n</table>\n</div>\n</form>";
+        $renderer->setFormTemplate($form_template);
+        $element_template = <<<EOT
         <tr class="separate">
 		<td>
 			<!-- BEGIN required -->
@@ -226,7 +226,7 @@ 
         $form->setDefaults($defaults);
         $form->addButtonCreate(get_lang('CreateGroup'), 'submit');
         $form->display();
-	}
+    }
 } else {
     /*
      * Show form to generate new groups