public static function removeUserMsgs($userId)
{
$connection = new DbConnect();
$pdo = $connection->connect();
$ownerQuery = "SELECT id, sender, receiver, isDeleted_sender, isDeleted_receiver FROM direct_message\n WHERE sender = :userId OR receiver = :userId";
$stmt = $pdo->prepare($ownerQuery);
$stmt->bindParam(':userId', $userId);
$stmt->setFetchMode(PDO::FETCH_OBJ);
$stmt->execute();
$ownerCheck = $stmt->fetchAll();
foreach ($ownerCheck as $eachMsg) {
if ($eachMsg->sender == $userId) {
DirectMessages::removeSender($eachMsg->id);
}
if ($eachMsg->receiver == $userId) {
DirectMessages::removeReceiver($eachMsg->id);
}
DirectMessages::removeMsgCheck($eachMsg->id, $eachMsg->isDeleted_sender, $eachMsg->isDeleted_receiver);
}
return $stmt->errorInfo();
}
