consulta($sql);
if(mysql_num_rows($result)!=0){
$person=$db->fetch_array($result);
$sql='select * from programa where idPrograma="'.$event.'" AND IDAno="'.$ano.'"';
$result=$db->consulta($sql);
$evento=$db->fetch_array($result);
$sql='select * from programvsuser where IDPersona="'.$person['idPersona'].'" AND IDProgram="'.$evento['idPrograma'].'"';
$result_persona=$db->consulta($sql);
if(mysql_num_rows($result_persona)!=0){
while($user=$db->fetch_array($result_persona)){
if($user['idTipo_Certi']==$tpCerti){
$sql='select * from tipo_certi where idTipo_Certi="'.$tpCerti.'"';
$result=$db->consulta($sql);
$Tp_certi=$db->fetch_array($result);
$sql='select * from ano where idAno="'.$ano.'"';
$result=$db->consulta($sql);
$Tp_ano=$db->fetch_array($result);
if($user['Descarga']==null){
$descragas =1;
}else{
$descragas = $user['Descarga']+1;
}
$query = 'UPDATE programvsuser SET Descarga='.$descragas.' WHERE idProgramvsUser='.$user['idProgramvsUser'];
$db->consulta($query);
$ruta = "archivos/".$Tp_ano['ano']."/".$evento['Nombre']."/".$Tp_certi['Nombre'].".png-".$person['Nombre'];
return $ruta;
}
}
return "";
}else{
return "";
}
}else{
return "";
// echo ;
}
}else{
return "";
// echo ;
}
}
?>