prepare("SELECT * FROM `mensagens` WHERE (`id_de` = ? AND `id_para` = ?) OR (`id_de` = ? AND `id_para` = ?) ORDER BY `id` DESC LIMIT 10");
$pegaConversas->execute(array($online, $id_conversa, $id_conversa, $online));
while($row = $pegaConversas->fetch()){
$fotoUser = '';
if($online == $row['id_de']){
$janela_de = $row['id_para'];
}elseif($online == $row['id_para']){
$janela_de = $row['id_de'];
$pegaFoto = BD::conn()->prepare("SELECT `foto` FROM `usuarios` WHERE `id` = '".$row['id_de']."'");
$pegaFoto->execute();
while ($usr = $pegaFoto->fetch()){
$fotoUser = ($usr['foto'] == '') ? 'default.jpg' : $usr['foto'];
}
}
$emotions = array(':P', ':$', ':|', ':O', '<3', ';*', ':%', ':@', ':D', ';D', ':A', ':"(', ':(', ':Z');
$imgs = array(
'
',
'
',
'
',
'
',
'
',
'
',
'
',
'
',
'
',
'
',
'
',
'
',
'
',
'
'
);
$msg = str_replace($emotions, $imgs, $row['mensagem']);
$mensagens[] = array(
'id' => $row['id'],
'mensagem' => utf8_encode($msg),
'fotoUser' => $fotoUser,
'id_de' => $row['id_de'],
'id_para' => $row['id_para'],
'janela_de' => $janela_de
);
}
die(json_encode($mensagens));
}
?>