chat_whoisonline.php 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109
  1. <?php // $Id: chat_whoisonline.php,v 1.12.2.1 2005/09/02 08:18:31 pcool Exp $
  2. /*
  3. ==============================================================================
  4. Dokeos - elearning and course management software
  5. Copyright (c) 2004 Dokeos S.A.
  6. Copyright (c) 2003 Ghent University (UGent)
  7. Copyright (c) 2001 Universite catholique de Louvain (UCL)
  8. Copyright (c) Olivier Brouckaert
  9. For a full list of contributors, see "credits.txt".
  10. The full license can be read in "license.txt".
  11. This program is free software; you can redistribute it and/or
  12. modify it under the terms of the GNU General Public License
  13. as published by the Free Software Foundation; either version 2
  14. of the License, or (at your option) any later version.
  15. See the GNU General Public License for more details.
  16. Contact: Dokeos, 181 rue Royale, B-1000 Brussels, Belgium, info@dokeos.com
  17. ==============================================================================
  18. */
  19. /**
  20. ==============================================================================
  21. * Shows the list of connected users
  22. *
  23. * @author Olivier Brouckaert
  24. * @package dokeos.chat
  25. ==============================================================================
  26. */
  27. define('FRAME','online');
  28. $language_file = array ('chat');
  29. include('../inc/global.inc.php');
  30. include('../inc/lib/course.lib.php');
  31. $showPic=intval($_GET['showPic']);
  32. $tbl_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER);
  33. $tbl_session_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  34. $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
  35. $tbl_chat_connected = Database::get_course_chat_connected_table();
  36. $query="SELECT username FROM $tbl_user WHERE user_id='".$_user['user_id']."'";
  37. $result=api_sql_query($query,__FILE__,__LINE__);
  38. list($pseudoUser)=mysql_fetch_row($result);
  39. $isAllowed=(empty($pseudoUser) || !$_cid)?false:true;
  40. $isMaster=$is_courseAdmin?true:false;
  41. $pictureURL=api_get_path(WEB_CODE_PATH).'upload/users/';
  42. if(!isset($_SESSION['id_session'])){
  43. $query="SELECT t1.user_id,username,firstname,lastname,picture_uri,t3.status FROM $tbl_user t1,$tbl_chat_connected t2,$tbl_course_user t3 WHERE t1.user_id=t2.user_id AND t3.user_id=t2.user_id AND t3.course_code = '".$_course['sysCode']."' AND t2.last_connection>'".date('Y-m-d H:i:s',time()-60*5)."' ORDER BY username";
  44. }
  45. else{
  46. $query="SELECT t1.user_id,username,firstname,lastname,picture_uri FROM $tbl_user t1,$tbl_chat_connected t2,$tbl_session_course_user t3 WHERE t1.user_id=t2.user_id AND t3.id_user=t2.user_id AND t3.course_code = '".$_course['sysCode']."' AND t2.last_connection>'".date('Y-m-d H:i:s',time()-60*5)."' ORDER BY username";
  47. }
  48. $result=api_sql_query($query,__FILE__,__LINE__);
  49. $Users=api_store_result($result);
  50. include('header_frame.inc.php');
  51. ?>
  52. <table border="0" cellpadding="0" cellspacing="0" width="100%" class="data_table">
  53. <tr><th colspan="2"><?php echo get_lang("Connected"); ?></th></tr>
  54. <?php
  55. foreach($Users as $enreg)
  56. {
  57. if(!isset($_SESSION['id_session'])){
  58. $status=$enreg['status'];
  59. }
  60. else{
  61. if(CourseManager::is_course_teacher($enreg['user_id'],$_SESSION['_course']['id'])) $status=1; else $status=5;
  62. }
  63. ?>
  64. <tr>
  65. <td width="1%" valign="top"><?php if($status == 1) echo '<img src="../img/teachers.gif" align="absbottom" border="0" alt="" style="margin: 1px;">'; else echo '<img src="../img/students.gif" align="absbottom" border="0" alt="" style="margin: 1px;">';?></td>
  66. <td width="99%"><a <?php if($status == 1) echo 'class="master"'; ?> name="user_<?php echo $enreg['user_id']; ?>" href="<?php echo api_get_self(); ?>?showPic=<?php if($showPic == $enreg['user_id']) echo '0'; else echo $enreg['user_id']; ?>#user_<?php echo $enreg['user_id']; ?>"><?php echo ucfirst($enreg['firstname']).' '.ucfirst($enreg['lastname']); ?></a></td>
  67. </tr>
  68. <?php if($showPic == $enreg['user_id']): ?>
  69. <tr>
  70. <td colspan="2" align="center"><img src="<?php if(empty($enreg['picture_uri'])) echo '../img/unknown.jpg'; else echo $pictureURL.$enreg['picture_uri']; ?>" border="0" width="100" alt="" style="margin-top: 5px;"></td>
  71. </tr>
  72. <?php endif; ?>
  73. <?php
  74. }
  75. unset($Users);
  76. ?>
  77. </table>
  78. <?php
  79. include('footer_frame.inc.php');
  80. ?>