No friends yet, start making new friends.
";
}
$profile = $db->query("SELECT id,username,photo FROM profile WHERE id = '".$db->intcast($uid)."'");
?>
prepare("SELECT * FROM messenger where toid = ? and uid = ?");
$stmt->bind_param("ii", $uid, $toid);
$stmt->execute();
$query = $stmt->get_result();
while($row = $query->fetch_array(MYSQLI_ASSOC)) {
$flaggedlist = $db->query("SELECT * FROM flagged where flaggedby = '".$db->intcast($uid)."' and chatid = '".$row['id']."'");
if(count($flaggedlist) == 0) {
$messages[] = $row;
}
}
$stmt->close();
$stmt = $mysqli->prepare("SELECT * FROM messenger where uid = ? AND toid = ?");
$stmt->bind_param("ii", $uid,$toid);
$stmt->execute();
$query = $stmt->get_result();
while($row = $query->fetch_array(MYSQLI_ASSOC)) {
$flaggedlist = $db->query("SELECT * FROM flagged where flaggedby = '".$db->intcast($uid)."' and chatid = '".$row['id']."'");
if(count($flaggedlist) == 0) {
$messages[] = $row;
}
}
$stmt->close();
array_multisort(
array_column($messages, 'id'),
$messages
);
for($i=0; $i < count($messages); $i++) {
if($messages[$i]['uid'] != $uid) {
$friend_uid = $db->intcast($messages[$i]['uid']);
$friend_toid = $db->intcast($messages[$i]['toid']);
$friend_photo = '/'.$db->clean($profile_friend[0]["photo"],'encode');
$photo = $db->clean($profile_friend[0]["photo"],'encode');
} else {
$photo = $db->clean($profile[0]["photo"],'encode');
}
?>
- hide this chat
- flag this chat
- block this user
prepare("UPDATE messenger SET readit = ? WHERE id = ?");
$read = 1;
$readid = $messages[$i]['id'];
$stmt->bind_param("ii", $read, $readid);
$stmt->execute();
$stmt->close();
}
}
?>