chamilo / chamilo-lms

main/exercise/question.class.php

Braces +2 added lines, -1 removed lines

@@ -1046,7 +1046,8 @@
                 $di->addChunk($ic_slide);
 
                 //index and return search engine document id
-                if (!empty($question_exercises)) { // if empty there is nothing to index
+                if (!empty($question_exercises)) {
+// if empty there is nothing to index
                     $did = $di->index();
                     unset($di);
                 }

Doc Comments +1 added lines, -1 removed lines

@@ -493,7 +493,7 @@
      * in this version, a question can only have 1 category
      * if category is 0, then question has no category then delete the category entry
      * @param int $categoryId
-     * @return bool
+     * @return null|boolean
      *
      * @author Hubert Borderiou 12-10-2011
      */

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

@@ -532,7 +532,7 @@ 
             $res = Database::query($sql);
             $row = Database::fetch_array($res);
             if ($row['nb'] > 0) {
-                $sql = "UPDATE $table
+                $sql = "update $table
                         SET category_id = $categoryId
                         WHERE
                             question_id = $question_id AND
@@ -850,7 +850,7 @@ 
             return false;
         }
 
-        $sql = "UPDATE $TBL_QUESTIONS SET
+        $sql = "update $TBL_QUESTIONS SET
                 picture = '".Database::escape_string($picture)."'
                 WHERE c_id = $course_id AND id='".intval($questionId)."'";
         Database::query($sql);
@@ -1014,7 +1014,7 @@ 
             $this->id = Database::insert($TBL_QUESTIONS, $params);
 
             if ($this->id) {
-                $sql = "UPDATE $TBL_QUESTIONS SET id = iid WHERE iid = {$this->id}";
+                $sql = "update $TBL_QUESTIONS SET id = iid WHERE iid = {$this->id}";
                 Database::query($sql);
 
                 api_item_property_update(
@@ -1303,7 +1303,7 @@ 
             if (Database::num_rows($res) > 0) {
                 $row = Database::fetch_array($res);
                 if (!empty($row['question_order'])) {
-                    $sql = "UPDATE $TBL_EXERCISE_QUESTION
+                    $sql = "update $TBL_EXERCISE_QUESTION
                         SET question_order = question_order-1
                         WHERE
                             c_id = $course_id
@@ -1354,7 +1354,7 @@ 
             if (Database::num_rows($res) > 0) {
                 while ($row = Database::fetch_array($res)) {
                     if (!empty($row['question_order'])) {
-                        $sql = "UPDATE $TBL_EXERCISE_QUESTION
+                        $sql = "update $TBL_EXERCISE_QUESTION
                                 SET question_order = question_order-1
                                 WHERE
                                     c_id = $course_id AND 
@@ -1469,7 +1469,7 @@ 
         $newQuestionId = Database::insert($TBL_QUESTIONS, $params);
 
         if ($newQuestionId) {
-            $sql = "UPDATE $TBL_QUESTIONS 
+            $sql = "update $TBL_QUESTIONS 
                     SET id = iid
                     WHERE iid = $newQuestionId";
             Database::query($sql);
@@ -1483,7 +1483,7 @@ 
                     unset($item['iid']);
                     $id = Database::insert($TBL_QUESTION_OPTIONS, $item);
                     if ($id) {
-                        $sql = "UPDATE $TBL_QUESTION_OPTIONS 
+                        $sql = "update $TBL_QUESTION_OPTIONS 
                                 SET id = iid
                                 WHERE iid = $id";
                         Database::query($sql);
@@ -1874,7 +1874,7 @@ 
         $result = self::readQuestionOption($question_id, $course_id);
         $last_id = Database::insert($table, $params);
         if ($last_id) {
-            $sql = "UPDATE $table SET id = iid WHERE iid = $last_id";
+            $sql = "update $table SET id = iid WHERE iid = $last_id";
             Database::query($sql);
         }
 
@@ -2080,7 +2080,7 @@ 
         $question_id = Database::insert($tbl_quiz_question, $params);
 
         if ($question_id) {
-            $sql = "UPDATE $tbl_quiz_question  
+            $sql = "update $tbl_quiz_question  
                     SET id = iid WHERE iid = $question_id";
             Database::query($sql);
 

main/exercise/savescores.php

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

@@ -93,7 +93,7 @@
     $htmlHeadXtra[] = $jscript2run;
     Display::display_reduced_header();
     if (!empty($course_id) && !empty($learnpath_item_id) && !empty($lpViewId)) {
-        $sql = "UPDATE $TABLE_LP_ITEM_VIEW SET
+        $sql = "update $TABLE_LP_ITEM_VIEW SET
                     status = 'completed'
                 WHERE
                     c_id = $course_id AND

main/exercise/hotspot_updatescore.inc.php

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

@@ -45,7 +45,7 @@
 
 // update db
 $update_id = $_SESSION['exerciseResult'][$questionId]['ids'][$answerId];
-$sql = "UPDATE $TBL_TRACK_E_HOTSPOT 
+$sql = "update $TBL_TRACK_E_HOTSPOT 
         SET coordinate = '".Database::escape_string($coordinates)."'
         WHERE id = ".intval($update_id)." 
         LIMIT 1";

Braces +4 added lines, -2 removed lines

@@ -18,13 +18,15 @@
 $objExercise = Session::read('objExercise');
 $hotspotId = $_GET['hotspotId'];
 $exerciseId = $objExercise->selectId();
-if ($_GET['answerId'] == "0") { // click is NOT on a hotspot
+if ($_GET['answerId'] == "0") {
+// click is NOT on a hotspot
     $hit = 0;
     $answerId = $hotspotId;
 
     // remove from session
     unset($_SESSION['exerciseResult'][$questionId][$answerId]);
-} else { // user clicked ON a hotspot
+} else {
+// user clicked ON a hotspot
     $hit = 1;
     $answerId = $hotspotId;
 

main/exercise/hotpotatoes.php

Braces +2 added lines, -1 removed lines

@@ -169,7 +169,8 @@
                         my_delete($document_sys_path.$uploadPath.'/'.$fld.'/'.$filename);
                         DocumentManager::updateDbInfo('delete', $uploadPath.'/'.$fld.'/'.$filename);
                     }
-                    if ($imgcount == 0) { // all image uploaded
+                    if ($imgcount == 0) {
+// all image uploaded
                         $finish = 1;
                     }
                 } else {

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

@@ -196,7 +196,7 @@
                     ENT_COMPAT,
                     api_get_system_encoding()
                 );
-                $query = "UPDATE $dbTable
+                $query = "update $dbTable
                           SET comment='".Database::escape_string($title)."'
                           WHERE c_id = $course_id AND path=\"".$uploadPath."/".$fld."/".$filename."\"";
                 Database::query($query);

main/reports/templates/courseArticulate.reports.php

Braces +10 added lines, -6 removed lines

@@ -11,7 +11,8 @@ 
 </span>
 ');
 
-function reports_template_CourseArticulate_getSQL() {
+function reports_template_CourseArticulate_getSQL()
+{
     // settings
 
 
@@ -23,7 +24,8 @@ 
     $queries[0] = $query;
     $extraFieldType = \Chamilo\CoreBundle\Entity\ExtraField::USER_FIELD_TYPE;
     // Custom Field
-    foreach (array("tags" => "tags") as $k => $v) { // FIXME
+    foreach (array("tags" => "tags") as $k => $v) {
+// FIXME
         $query = 'select ufv.value  as "'.$v.'" ';
         $query .= 'from '.Database::get_main_table(TABLE_MAIN_USER).' u ';
         $query .= 'left join'.Database::get_main_table(TABLE_EXTRA_FIELD).' uf ';
@@ -39,8 +41,9 @@ 
     // Stored Value
     $sv = array();
     foreach ($sv as $k => $v) {
-        if (!isset($v['sql']))
-                $v['sql'] = 'FIELD';
+        if (!isset($v['sql'])) {
+                        $v['sql'] = 'FIELD';
+        }
         $sqlField = str_replace('FIELD', 'sv.sv_value', $v['sql']);
         $query = 'select '.$sqlField.' as "'.$v['title'].'" ';
 //		$query = 'select sec_to_time(sv.sv_value) as "'.$v.'" ';
@@ -110,8 +113,9 @@ 
         $query .= ' on u.user_id = lv.user_id and lv.lp_id = '.$v['lid'];
         $query .= ' left outer join '.Database::get_course_table(TABLE_LP_ITEM_VIEW).' liv ';
         $query .= ' on lv.id = liv.lp_view_id ';
-        if ($v['target_view_count'])
-            $query .= ' and liv.view_count = '.$v['target_view_count'];
+        if ($v['target_view_count']) {
+                    $query .= ' and liv.view_count = '.$v['target_view_count'];
+        }
         $query .= ' and liv.lp_item_id = '.$v['liid'].' ';
         $query .= ' where u.user_id in ('.reports_getVisibilitySQL().') ';
         $query .= ' group by u.user_id ';

main/inc/global_error_message.inc.php

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

@@ -248,7 +248,7 @@ 
         </div>
 		</body>
 </html>
-EOM;
+eom;
     } else {
         $global_error_message_page =
 <<<EOM
@@ -311,7 +311,7 @@ 
         </div>
         </body>
 </html>
-EOM;
+eom;
     }
     foreach ($global_error_message as $key => $value) {
         $global_error_message_page = str_replace('{'.strtoupper($key).'}', $value, $global_error_message_page);

main/inc/ajax/work.ajax.php

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

@@ -120,7 +120,7 @@
                 $url = Database::escape_string($resultUpload['url']);
                 $title = Database::escape_string($title);
 
-                $sql = "UPDATE $work_table SET
+                $sql = "update $work_table SET
                             url_correction = '".$url."',
                             title_correction = '".$title."'
                         WHERE iid = $itemId";

main/inc/ajax/events.ajax.php

Braces +1 added lines, -1 removed lines

@@ -8,7 +8,7 @@
 

 api_protect_admin_script();

 

-switch ($action) {

+switch ($action) {
     case 'getEventTypes':

         $events = Event::get_all_event_types();

         print json_encode($events);

main/inc/lib/array.lib.php

Braces +2 added lines, -1 removed lines

@@ -76,7 +76,8 @@
     &$array,
     $function,
     $apply_to_keys_also = false
-) {
+)
+{
     static $recursive_counter = 0;
     if (++$recursive_counter > 1000) {
         die('possible deep recursion attack');

Indentation +16 added lines, -16 removed lines

@@ -108,24 +108,24 @@
  */
 function utf8_sort($array)
 {
-	$old_locale = setlocale(LC_ALL, null);
-	$code = api_get_language_isocode();
-	$locale_list = array($code.'.utf8', 'en.utf8', 'en_US.utf8', 'en_GB.utf8');
-	$try_sort = false;
+    $old_locale = setlocale(LC_ALL, null);
+    $code = api_get_language_isocode();
+    $locale_list = array($code.'.utf8', 'en.utf8', 'en_US.utf8', 'en_GB.utf8');
+    $try_sort = false;
 
-	foreach ($locale_list as $locale) {
-		$my_local = setlocale(LC_COLLATE, $locale);
-		if ($my_local) {
-			$try_sort = true;
-			break;
-		}
-	}
+    foreach ($locale_list as $locale) {
+        $my_local = setlocale(LC_COLLATE, $locale);
+        if ($my_local) {
+            $try_sort = true;
+            break;
+        }
+    }
 
-	if ($try_sort) {
-		uasort($array, 'strcoll');
-	}
-	setlocale(LC_COLLATE, $old_locale);
-	return $array;
+    if ($try_sort) {
+        uasort($array, 'strcoll');
+    }
+    setlocale(LC_COLLATE, $old_locale);
+    return $array;
 }
 
 /**