if ($pesquisa != "") {
$sql = "select * from ejbsm_usuario where permissao = 'usuario' and login like '%{$pesquisa}%' or nome like '{$pesquisa}%'";
} elseif (isset($_GET["inicio_consulta"])) {
$inicio_consulta = $_GET["inicio_consulta"];
$sql = "select * from ejbsm_usuario where permissao = 'usuario' order by login limit 10 offset {$inicio_consulta}";
} else {
$sql = "select * from ejbsm_usuario where permissao = 'usuario' order by login limit 10;";
}
$qr = $link->query($sql) or die(mysqli_error($link));
$j = 0;
while ($r = mysqli_fetch_object($qr)) {
?>
<tr>
<td>
<?php
Imagem($r->login, 80);
?>
</td>
<td><?php
echo "{$r->nome}";
?>
</td>
<td><?php
echo "{$r->login}";
?>
</td>
<td><?php
echo "{$r->celular}";
?>
</td>
<td><?php
</span></b></font>
</span>
</a>
<ul>
<li class='has-sub'>
<a>
<?php
$sql_respostas = "select * from ejbsm_batepapo_resposta where id_mensagem = '{$r->id}' order by id asc limit 10;";
$qr_respostas = $link->query($sql_respostas);
while ($resposta = mysqli_fetch_object($qr_respostas)) {
?>
<table class="table">
<tr>
<td rowspan='2' style="width: 40px">
<?php
Imagem($resposta->login, 50);
?>
</td>
<td> dia <font
color="green"><b><?php
echo "{$resposta->data}";
?>
</b></font>
</td>
<td> as <font
color="green"><b><?php
echo "{$resposta->hora}";
?>
</b></font>
</td>
<?php
<br>Caso sua imagem não se altere, recarregue a página.
<!-- Modal -->
<div class="modal fade" id="myModal" tabindex="-1" role="dialog"
aria-labelledby="myModalLabel"
aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal"
aria-label="Close"><span
aria-hidden="true">×</span></button>
<h4 class="modal-title" id="myModalLabel">Alterar imagem (max 2mb)</h4>
</div>
<div class="modal-body" style="margin-left: 20px">
<?php
Imagem($user_login, 200);
?>
<input type="file" class="form-control" name="arquivo" required>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Cancelar
</button>
<button type="submit" class="btn btn-success" value="Alterar imagem"
name="opcao">
<span class="glyphicon glyphicon-camera"></span>
Alterar imagem
</button>
</div>
</div>
</div>
</div>
}
$sql = "select * from ejbsm_usuario, ejbsm_integrante where permissao = 'bolsista' and status='Inativo' AND ejbsm_integrante.login=ejbsm_usuario.login ORDER by status;";
$qr = $link->query($sql);
while ($bolsista = mysqli_fetch_object($qr)) {
?>
<br><br>
<div id='cssmenu' style='box-shadow: 1px 1px 5px 1px #c9302c;'>
<ul>
<li class='active has-sub'>
<a>
<span>
<table>
<tr>
<td rowspan="3" style="width: 15%;" colspan="2">
<?php
Imagem($bolsista->login, 80);
?>
</td>
<td style="width: 35%;"><b>Nome: </b><?php
echo "{$bolsista->nome}";
?>
</td>
<td style="width: 25%;"><b>Login: </b><?php
echo "{$bolsista->login}";
?>
</td>
<td style="width: 35%;"><b>E-mail: </b><?php
echo "{$bolsista->email}";
?>
</td>
</tr>
<?php
}
$result = $link->query($consulta);
while ($topico = mysqli_fetch_object($result)) {
$sql = "select nome from ejbsm_forum_area where id = {$topico->id_area}";
$pega_nome = mysqli_fetch_object($link->query($sql));
$nome_area = $pega_nome->nome;
$sql = "select nome from ejbsm_forum_subarea where id = {$topico->id_subarea}";
$pega_nome = mysqli_fetch_object($link->query($sql));
$nome_subarea = $pega_nome->nome;
?>
<div class="alert alert-info">
<div class="media-left">
<a href="#">
<?php
Imagem($topico->login, 40);
?>
</a>
</div>
<div class="media-body">
<h4 class="media-heading"><?php
echo $topico->assunto;
?>
</h4>
<font color="green" style="margin-left: 10px;"><b>
ID </b></font><?php
echo $topico->id;
?>
.
<font color="green"><b>Por </b></font>
<a href="forum_info.php?info=login&login=<?php
echo $login;
?>
</h3>
<div class="alert <?php
if ($row->status == "Ativo") {
} else {
echo "alert-danger";
}
?>
" role="alert">
<table>
<tr>
<td rowspan="7" style="width: 210px">
<?php
Imagem($row->login, 100);
?>
</td>
<td>
Nome: <?php
echo $row->nome;
?>
<br>
</td>
</tr>
<tr>
<td>
Permissões: <?php
echo $row->permissao;
?>
<br>
