5) { $tbl_chat_connected = Database::get_course_chat_connected_table(); $sql='DELETE FROM '.$tbl_chat_connected.' WHERE user_id='.$list_info_user['user_id']; Database::query($sql,__FILE__,__LINE__); } } } } /** * @param void * @return array user list in chat */ function users_list_in_chat () { $list_users_in_chat=array(); $tbl_chat_connected = Database::get_course_chat_connected_table(); $group_id = intval($_SESSION['id_group']); $session_id = intval($_SESSION['id_session']); $extra_condition = ''; if (!empty($group_id)) $extra_condition = " WHERE to_group_id = '$group_id'"; else $extra_condition = api_get_session_condition($session_id,false); $sql='SELECT user_id,last_connection FROM '.$tbl_chat_connected.$extra_condition; $result=Database::query($sql,__FILE__,__LINE__); while ($row = Database::fetch_array($result,'ASSOC')) { $list_users_in_chat[]=$row; } return $list_users_in_chat; } ?>