chamilo / chamilo-lms

main/chat/chat_whoisonline.php

Indentation +27 added lines, -27 removed lines

@@ -37,15 +37,15 @@ 
 
     list($pseudo_user) = Database::fetch_array($result);
 
-	$isAllowed = !(empty($pseudo_user) || !$_cid);
-	$isMaster = api_is_course_admin();
+    $isAllowed = !(empty($pseudo_user) || !$_cid);
+    $isMaster = api_is_course_admin();
     $date_inter = api_get_utc_datetime(time() - 120);
 
     $users = array();
     $course_id = api_get_course_int_id();
 
     if (empty($session_id)) {
-		$sql = "SELECT DISTINCT
+        $sql = "SELECT DISTINCT
 		            t1.user_id,
 		            username,
 		            firstname,
@@ -65,10 +65,10 @@ 
 
         $result = Database::query($sql);
         $users = Database::store_result($result);
-	} else {
+    } else {
         $session_condition = api_get_session_condition($session_id, true, false, 't3.session_id');
-		// select learners
-		$query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri,email
+        // select learners
+        $query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri,email
                   FROM $tbl_user t1, $tbl_chat_connected t2, $tbl_session_course_user t3
 		          WHERE
 		          t2.c_id = $course_id AND
@@ -77,13 +77,13 @@ 
 		          t3.c_id = '".$courseInfo['real_id']."' AND
 		          t2.last_connection>'".$date_inter."' $session_condition
 		          ORDER BY username";
-		$result = Database::query($query);
-		while ($learner = Database::fetch_array($result)) {
+        $result = Database::query($query);
+        while ($learner = Database::fetch_array($result)) {
             $users[$learner['user_id']] = $learner;
-		}
+        }
 
-		// select session coach
-		$query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri,email
+        // select session coach
+        $query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri,email
 		          FROM $tbl_user t1,$tbl_chat_connected t2,$tbl_session t3
 		          WHERE
 					t2.c_id = $course_id AND
@@ -93,13 +93,13 @@ 
 					t2.last_connection > '".$date_inter."'
 					$extra_condition
 				  ORDER BY username";
-		$result = Database::query($query);
-		if ($coach = Database::fetch_array($result)) {
-			$users[$coach['user_id']] = $coach;
-		}
+        $result = Database::query($query);
+        if ($coach = Database::fetch_array($result)) {
+            $users[$coach['user_id']] = $coach;
+        }
 
-		// select session course coach
-		$query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri,email
+        // select session course coach
+        $query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri,email
 				FROM $tbl_user t1,$tbl_chat_connected t2,$tbl_session_course_user t3
 				WHERE
 					t2.c_id = $course_id AND
@@ -110,15 +110,15 @@ 
 					AND t2.last_connection>'".$date_inter."' $extra_condition
 				ORDER BY username";
 
-		$result = Database::query($query);
-		$course_coaches = array();
-		while ($coaches = Database::fetch_array($result)) {
-			$users[$coaches['user_id']] = $coaches;
-		}
-	}
-	require 'header_frame.inc.php';
+        $result = Database::query($query);
+        $course_coaches = array();
+        while ($coaches = Database::fetch_array($result)) {
+            $users[$coaches['user_id']] = $coaches;
+        }
+    }
+    require 'header_frame.inc.php';
 
-	?>
+    ?>
 	<div class="user-connected">
 	<div id="user-online-scroll" class="user-online">
 		<div class="title"><?php echo get_lang('Users'); ?> <?php echo get_lang('Connected'); ?></div>
@@ -134,7 +134,7 @@ 
                 }
                 $fileUrl = UserManager::getUserPicture($user['user_id'], USER_IMAGE_SIZE_MEDIUM);
                 $url_user_profile=api_get_path(WEB_CODE_PATH).'social/profile.php?u='.$user['user_id'].'&';
-			?>
+            ?>
 			<li class="list-group-item">
 				<img src="<?php echo $fileUrl;?>" border="0" width="50" alt="" class="user-image-chat" />
 				<div class="user-name">
@@ -147,7 +147,7 @@ 
                         } else {
                             echo Display::return_icon('students.gif', get_lang('Student'), array('height' => '18'));
                         }
-					?>
+                    ?>
 				</div>
 				<div class="user-email"><?php echo $user['username']; ?></div>
 			</li>

main/chat/chat_functions.lib.php

Indentation +26 added lines, -26 removed lines

@@ -15,27 +15,27 @@ 
  */
 function user_connected_in_chat($user_id)
 {
- 	$tbl_chat_connected = Database::get_course_table(TABLE_CHAT_CONNECTED);
+        $tbl_chat_connected = Database::get_course_table(TABLE_CHAT_CONNECTED);
     $user_id 	= intval($user_id);
- 	$session_id = api_get_session_id();
+        $session_id = api_get_session_id();
     $group_id   = api_get_group_id();
     $course_id  = api_get_course_int_id();
 
-	if (!empty($group_id)) {
-		$extra_condition = " AND to_group_id = '$group_id'";
-	} else {
-		$extra_condition = api_get_session_condition($session_id);
-	}
+    if (!empty($group_id)) {
+        $extra_condition = " AND to_group_id = '$group_id'";
+    } else {
+        $extra_condition = api_get_session_condition($session_id);
+    }
 
- 	$sql = 'SELECT COUNT(*) AS count
+        $sql = 'SELECT COUNT(*) AS count
  	        FROM '.$tbl_chat_connected .' c
  	        WHERE
  	            c_id = '.$course_id.' AND
  	            user_id='.$user_id.$extra_condition;
- 	$result = Database::query($sql);
- 	$count  = Database::fetch_array($result,'ASSOC');
+        $result = Database::query($sql);
+        $count  = Database::fetch_array($result,'ASSOC');
 
- 	return $count['count'] == 1;
+        return $count['count'] == 1;
 }
 
 /**
@@ -71,7 +71,7 @@ 
     $cdate_h = date('H', $now);
     $cdate_m = date('i', $now);
     $cdate_s = date('s', $now);
-	$cd_count_time_seconds = $cdate_h*3600 + $cdate_m*60 + $cdate_s;
+    $cd_count_time_seconds = $cdate_h*3600 + $cdate_m*60 + $cdate_s;
 
     if (is_array($list_info_user_in_chat) && count($list_info_user_in_chat) > 0) {
         foreach ($list_info_user_in_chat as $list_info_user) {
@@ -101,26 +101,26 @@ 
  */
 function users_list_in_chat()
 {
-	$list_users_in_chat = array();
- 	$tbl_chat_connected = Database::get_course_table(TABLE_CHAT_CONNECTED);
+    $list_users_in_chat = array();
+        $tbl_chat_connected = Database::get_course_table(TABLE_CHAT_CONNECTED);
     $course_id = api_get_course_int_id();
 
- 	$session_id = api_get_session_id();
+        $session_id = api_get_session_id();
     $group_id   = api_get_group_id();
 
-	if (!empty($group_id)) {
-		$extra_condition = " WHERE to_group_id = '$group_id'";
-	} else{
-		$extra_condition = api_get_session_condition($session_id, false);
-	}
+    if (!empty($group_id)) {
+        $extra_condition = " WHERE to_group_id = '$group_id'";
+    } else{
+        $extra_condition = api_get_session_condition($session_id, false);
+    }
     $extra_condition.= " AND c_id = $course_id ";
- 	$sql = 'SELECT user_id, last_connection FROM '.$tbl_chat_connected.$extra_condition;
- 	$result = Database::query($sql);
- 	while ($row = Database::fetch_array($result, 'ASSOC')) {
- 		$list_users_in_chat[] = $row;
- 	}
+        $sql = 'SELECT user_id, last_connection FROM '.$tbl_chat_connected.$extra_condition;
+        $result = Database::query($sql);
+        while ($row = Database::fetch_array($result, 'ASSOC')) {
+            $list_users_in_chat[] = $row;
+        }
 
- 	return $list_users_in_chat;
+        return $list_users_in_chat;
 }
 
 /**

main/exercice/hotpotatoes_exercise_report.php

Indentation +4 added lines, -4 removed lines

@@ -45,7 +45,7 @@ 
 }
 
 if (!$is_allowedToEdit) {
-   // api_not_allowed();
+    // api_not_allowed();
 }
 
 if (!empty($_REQUEST['path'])) {
@@ -190,9 +190,9 @@ 
         get_lang('Actions')
     );
 
-  // Column config
-  // @todo fix search firstname/lastname that doesn't work. rmove search for the moment
-	$column_model   = array(
+    // Column config
+    // @todo fix search firstname/lastname that doesn't work. rmove search for the moment
+    $column_model   = array(
         array('name'=>'firstname',      'index'=>'firstname',		'width'=>'50',   'align'=>'left', 'search' => 'false'),
         array('name'=>'lastname',		    'index'=>'lastname',		'width'=>'50',   'align'=>'left', 'formatter'=>'action_formatter', 'search' => 'false'),
         array('name'=>'login',          'hidden'=>'true',       'index'=>'username',        'width'=>'40',   'align'=>'left', 'search' => 'false'),

main/exercice/question_list_admin.inc.php

Indentation -1 removed lines

@@ -16,7 +16,6 @@
  * @author Patrick Cool
  * @author René Haentjens, added CSV file import (October 2004)
  * @package chamilo.link
-
  */
 
 // Including libraries

main/dashboard/index.php

Indentation +2 added lines, -2 removed lines

@@ -26,7 +26,7 @@ 
 $actions = array('listing', 'store_user_block', 'disable_block');
 $action = 'listing';
 if (isset($_GET['action']) && in_array($_GET['action'],$actions)) {
-	$action = $_GET['action'];
+    $action = $_GET['action'];
 }
 
 // load styles from dashboard plugins
@@ -37,7 +37,7 @@ 
 $dashboard_controller = new DashboardController();
 
 if (isset($_GET['path'])) {
-	$path = $_GET['path'];
+    $path = $_GET['path'];
 }
 
 // distpacher actions to controller

main/auth/ldap/newUser.php

Indentation +7 added lines, -7 removed lines

@@ -21,17 +21,17 @@
 
 if ($ldap_login_success)
 {
-	//error_log('Found user '.$login.' on LDAP server',0);
-	/*
+    //error_log('Found user '.$login.' on LDAP server',0);
+    /*
 		In here, we know that
 		- the user does not exist in dokeos
 		- the users login and password are correct
 	*/
-	$info_array = ldap_find_user_info($login);
-	ldap_put_user_info_locally($login, $info_array);
+    $info_array = ldap_find_user_info($login);
+    ldap_put_user_info_locally($login, $info_array);
 } else {
     //error_log('Could not find '.$login.' on LDAP server',0);
-	$loginFailed = true;
-	unset($_user['user_id']);
-	$uidReset = false;
+    $loginFailed = true;
+    unset($_user['user_id']);
+    $uidReset = false;
 }

main/cron/user_import/get_data_from_mail.php

Indentation +8 added lines, -8 removed lines

@@ -20,16 +20,16 @@
 $users = Database::get_main_table(TABLE_MAIN_USER);
 $string='';
 foreach ($list as $mail) {
-  $mail = trim($mail);
-  $sql = "SELECT user_id, official_code, firstname, lastname, email FROM $users WHERE email = '$mail'\n";
-  $res = Database::query($sql);
-  if ($res === false) { die(mysql_error());}
-  if (Database::num_rows($res) == 0) {
+    $mail = trim($mail);
+    $sql = "SELECT user_id, official_code, firstname, lastname, email FROM $users WHERE email = '$mail'\n";
+    $res = Database::query($sql);
+    if ($res === false) { die(mysql_error());}
+    if (Database::num_rows($res) == 0) {
     $string .= 'No encontrado;'.$row['email'];
-  } else {
+    } else {
     $row = Database::fetch_assoc($res);
-   $string .= $row['user_id'].';'.$row['email'].';'.$row['firstname'].';'.$row['lastname'].';'.$row['official_code']."\r\n";
-  }
+    $string .= $row['user_id'].';'.$row['email'].';'.$row['firstname'].';'.$row['lastname'].';'.$row['official_code']."\r\n";
+    }
 }
 echo $string;
 file_put_contents('/tmp/list.txt',$string);

main/exercice/export/aiken/aiken_classes.php

Indentation +6 added lines, -6 removed lines

@@ -10,9 +10,9 @@ 
 if ( count( get_included_files() ) == 1 ) die( '---' );
 
 if (!function_exists('mime_content_type')) {
-	function mime_content_type($filename) {
-		return DocumentManager::file_get_mime_type((string)$filename);
-	}
+    function mime_content_type($filename) {
+        return DocumentManager::file_get_mime_type((string)$filename);
+    }
 }
 
 /**
@@ -29,7 +29,7 @@ 
         {
             case MCUA :
                 $answer = new AikenAnswerMultipleChoice($this->id);
-            	return $answer;
+                return $answer;
             default :
                 $answer = null;
                 break;
@@ -38,11 +38,11 @@ 
     }
     function createAnswersForm($form)
     {
-    	return true;
+        return true;
     }
     function processAnswersCreation($form)
     {
-    	return true;
+        return true;
     }
 }
 

main/admin/user_export.php

Indentation +93 added lines, -93 removed lines

@@ -29,20 +29,20 @@ 
 global $_configuration;
 
 if (api_is_multiple_url_enabled()) {
-	$tbl_course_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
-	$access_url_id = api_get_current_access_url_id();
-	if ($access_url_id != -1){
-	$sql = "SELECT code,visual_code,title
+    $tbl_course_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
+    $access_url_id = api_get_current_access_url_id();
+    if ($access_url_id != -1){
+    $sql = "SELECT code,visual_code,title
 		FROM $course_table as c
 		INNER JOIN $tbl_course_rel_access_url as course_rel_url
 		ON (c.id = course_rel_url.c_id)
 		WHERE access_url_id = $access_url_id
 		ORDER BY visual_code";
-	}
+    }
 }
 $result = Database::query($sql);
 while ($course = Database::fetch_object($result)) {
-	$courses[$course->code] = $course->visual_code.' - '.$course->title;
+    $courses[$course->code] = $course->visual_code.' - '.$course->title;
 }
 $form = new FormValidator('export_users');
 $form->addElement('header', $tool_name);
@@ -56,13 +56,13 @@ 
 $form->setDefaults(array('file_type' => 'csv'));
 
 if ($form->validate()) {
-	$export = $form->exportValues();
-	$file_type = $export['file_type'];
-	$course_code = Database::escape_string($export['course_code']);
-	$courseInfo = api_get_course_info($course_code);
-	$courseId = $courseInfo['real_id'];
+    $export = $form->exportValues();
+    $file_type = $export['file_type'];
+    $course_code = Database::escape_string($export['course_code']);
+    $courseInfo = api_get_course_info($course_code);
+    $courseId = $courseInfo['real_id'];
 
-	$sql = "SELECT
+    $sql = "SELECT
 				u.user_id 	AS UserId,
 				u.lastname 	AS LastName,
 				u.firstname 	AS FirstName,
@@ -73,96 +73,96 @@ 
 				u.status		AS Status,
 				u.official_code	AS OfficialCode,
 				u.phone		AS Phone";
-	if (strlen($course_code) > 0) {
-		$sql .= " FROM $user_table u, $course_user_table cu
+    if (strlen($course_code) > 0) {
+        $sql .= " FROM $user_table u, $course_user_table cu
 					WHERE
 						u.user_id = cu.user_id AND
 						cu.c_id = $courseId AND
 						cu.relation_type<>".COURSE_RELATION_TYPE_RRHH."
 					ORDER BY lastname,firstname";
-		$filename = 'export_users_'.$course_code.'_'.api_get_local_time();
-	} else {
-		if (api_is_multiple_url_enabled()) {
-			$tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
-			$access_url_id = api_get_current_access_url_id();
-			if ($access_url_id != -1) {
-			$sql.= " FROM $user_table u
+        $filename = 'export_users_'.$course_code.'_'.api_get_local_time();
+    } else {
+        if (api_is_multiple_url_enabled()) {
+            $tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
+            $access_url_id = api_get_current_access_url_id();
+            if ($access_url_id != -1) {
+            $sql.= " FROM $user_table u
 					INNER JOIN $tbl_user_rel_access_url as user_rel_url
 				ON (u.user_id= user_rel_url.user_id)
 				WHERE access_url_id = $access_url_id
 				ORDER BY lastname,firstname";
-			}
-		} else {
-			$sql .= " FROM $user_table u ORDER BY lastname,firstname";
-		}
-		$filename = 'export_users_'.api_get_local_time();
-	}
-	$data = array();
-	$extra_fields = UserManager::get_extra_fields(0, 0, 5, 'ASC',false);
-	if ($export['addcsvheader']=='1' AND $export['file_type']=='csv') {
-		if ($_configuration['password_encryption'] != 'none') {
-			$data[] = array(
-				'UserId',
-				'LastName',
-				'FirstName',
-				'Email',
-				'UserName',
-				'AuthSource',
-				'Status',
-				'OfficialCode',
-				'PhoneNumber',
-			);
-		} else {
-			$data[] = array(
-				'UserId',
-				'LastName',
-				'FirstName',
-				'Email',
-				'UserName',
-				'Password',
-				'AuthSource',
-				'Status',
-				'OfficialCode',
-				'PhoneNumber',
-			);
-		}
-
-		foreach($extra_fields as $extra) {
-			$data[0][]=$extra[1];
-		}
-	}
-
-	$res = Database::query($sql);
-	while($user = Database::fetch_array($res,'ASSOC')) {
-		$student_data = UserManager:: get_extra_user_data(
-			$user['UserId'],
-			true,
-			false
-		);
-		foreach($student_data as $key=>$value) {
-			$key = substr($key, 6);
-			if (is_array($value)) {
-				$user[$key] = $value[$key];
-			} else {
-				$user[$key] = $value;
-			}
-		}
-		$data[] = $user	;
-	}
-
-	switch ($file_type) {
-		case 'xml':
-			Export::arrayToXml($data, $filename, 'Contact', 'Contacts');
-			exit;
-			break;
-		case 'csv':
-			Export::arrayToCsv($data, $filename);
-			exit;
-		case 'xls':
-			Export::arrayToXls($data, $filename);
-			exit;
-			break;
-	}
+            }
+        } else {
+            $sql .= " FROM $user_table u ORDER BY lastname,firstname";
+        }
+        $filename = 'export_users_'.api_get_local_time();
+    }
+    $data = array();
+    $extra_fields = UserManager::get_extra_fields(0, 0, 5, 'ASC',false);
+    if ($export['addcsvheader']=='1' AND $export['file_type']=='csv') {
+        if ($_configuration['password_encryption'] != 'none') {
+            $data[] = array(
+                'UserId',
+                'LastName',
+                'FirstName',
+                'Email',
+                'UserName',
+                'AuthSource',
+                'Status',
+                'OfficialCode',
+                'PhoneNumber',
+            );
+        } else {
+            $data[] = array(
+                'UserId',
+                'LastName',
+                'FirstName',
+                'Email',
+                'UserName',
+                'Password',
+                'AuthSource',
+                'Status',
+                'OfficialCode',
+                'PhoneNumber',
+            );
+        }
+
+        foreach($extra_fields as $extra) {
+            $data[0][]=$extra[1];
+        }
+    }
+
+    $res = Database::query($sql);
+    while($user = Database::fetch_array($res,'ASSOC')) {
+        $student_data = UserManager:: get_extra_user_data(
+            $user['UserId'],
+            true,
+            false
+        );
+        foreach($student_data as $key=>$value) {
+            $key = substr($key, 6);
+            if (is_array($value)) {
+                $user[$key] = $value[$key];
+            } else {
+                $user[$key] = $value;
+            }
+        }
+        $data[] = $user	;
+    }
+
+    switch ($file_type) {
+        case 'xml':
+            Export::arrayToXml($data, $filename, 'Contact', 'Contacts');
+            exit;
+            break;
+        case 'csv':
+            Export::arrayToCsv($data, $filename);
+            exit;
+        case 'xls':
+            Export::arrayToXls($data, $filename);
+            exit;
+            break;
+    }
 }
 
 Display :: display_header($tool_name);