| Server IP : 165.22.154.248 / Your IP : 216.73.217.0 [ Web Server : Apache/2.4.29 (Ubuntu) System : Linux droplet-integra 4.15.0-197-generic #208-Ubuntu SMP Tue Nov 1 17:23:37 UTC 2022 x86_64 User : www-data ( 33) PHP Version : 7.2.24-0ubuntu0.18.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals, Domains : 1 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/avanza-lms.old.bak9874115/scripts/ |
Upload File : |
<?php
//@sucerman
//Funcion Principal
//ini_set('display_errors', 1);
//error_reporting(E_ALL);
require_once(dirname(__FILE__) . '/../config.php');
session_start();
//Funcion que devuelve la imagen del perfil de un usuario
function getImagenPerfil($userid,$size='f1'){
global $DB,$CFG;
$imagen=$CFG->wwwroot."/theme/image.php?theme=boost&component=core&image=u%2F".$size;
$sql = "
SELECT c.id as contextid,u.picture
FROM mdl_user u
JOIN mdl_context c ON (c.instanceid=u.id and c.contextlevel=30)
WHERE u.id = ".$userid."
";
$result= $DB->get_records_sql($sql);
if(!empty($result)){
foreach($result as $res){
if( $res->picture <> 0){
$imagen=$CFG->wwwroot."/pluginfile.php/".$res->contextid."/user/icon/".$size;
}
}
}
return $imagen;
}
//PARAMETROS DE BUSQUEDA
$usuario=$_SESSION['USER']->username;
if(isloggedin()){//si esta logeado
$html="";
$etiqueta_enlace="Mis compañeros";
#-----------------------------------------------------------------------------
# Arma la instruccion para consultar las categorias
# exceptuando la categoria 5 herramientas de comunicación general
#-----------------------------------------------------------------------------
$random="rand()";
if($CFG->dbtype=="pgsql"){
$random="RANDOM()";
}
$sql=" SELECT u.id as userid,u.firstname,u.lastname,u.picture,ct.id as contextid, t.id as context_id_curso
FROM mdl_user u
JOIN mdl_role_assignments a ON (a.userid=u.id)
JOIN mdl_context t ON (t.id = a.contextid)
JOIN mdl_course c ON (c.id =t.instanceid)
JOIN mdl_context ct ON (ct.instanceid=u.id and ct.contextlevel=30)
WHERE t.contextlevel= 50
AND c.id = ".$_REQUEST['id_curso']."
AND u.picture <> 0
ORDER BY ".$random."
LIMIT 20";
//Ejecuta la consulta en la BD
$result= $DB->get_records_sql($sql);
if(!empty($result)){
foreach($result as $res){
$userid=$res->userid;
#-------------------------------------------------
# Consulta la foto de perfil
#-------------------------------------------------
$url_foto = getImagenPerfil($res->userid,'f1');
$url_perfil =$CFG->wwwroot."/user/view.php?id=".$res->userid."&course=".$_REQUEST['id_curso'];
//etiqueta enlace compañeros del grupo
$html.='
<li class="participante">
<a class="foto text-center" href="'.$url_perfil.'" target="_blank">
<img src="'.$url_foto.'" width="45" alt="'.$res->firstname.' '.$res->lastname.'" title="'.$res->firstname.' '.$res->lastname.'" />
</a>
</li>';
}//Fin Foreach
}
$html.='
<div class="mdl-right m-t-1 footer">
<a href="'.$CFG->wwwroot.'/user/index.php?id='.$_REQUEST['id_curso'].'">'.$etiqueta_enlace.'</a>
<img title="Participantes" alt="Participantes" src="'.$CFG->wwwroot.'/pix/t/groupv.png" border="0" />
</div>';
echo $html;
}
?>