Skip to content
Sudonix

sudonix

MongoDB Tweaks : query to delete unverified-users and more 🙂

Configure
  • undefined

    Hello Mark

    I would like to have examples of Mongodb queries for nodebb

    – Among other things, I would like to delete all unverified users without verified emails)
    I can do it manually via the ACP but it takes time and a lot of resources on the forum (error 503) during processing
    Do you have a trick like a mongo DB query or a routine?

    – I would also like a request for :

    • list all users

    • list all users whose last login dates back to 1 year or other duration

    • list all unverified users

    • list all unverified users whose last login dates back to 1 year or other duration

    • list all verified users whose last login dates back to 1 year or other duration

    😉

    PW and WS Spirit alive

    1
  • undefined DownPW

    Hello Mark

    I would like to have examples of Mongodb queries for nodebb

    – Among other things, I would like to delete all unverified users without verified emails)
    I can do it manually via the ACP but it takes time and a lot of resources on the forum (error 503) during processing
    Do you have a trick like a mongo DB query or a routine?

    – I would also like a request for :

    • list all users

    • list all users whose last login dates back to 1 year or other duration

    • list all unverified users

    • list all unverified users whose last login dates back to 1 year or other duration

    • list all verified users whose last login dates back to 1 year or other duration

    😉

    undefined

    @DownPW This isn’t something I have readily available, and because I’m not entirely familiar with the database structure of NodeBB, it’s something that would require research and development in terms of script.

    I think it’d be quicker to ask this in the NodeBB forums.

    Author of OGProxy, Swatch, Threaded, Card, and most of Sudonix's bugs…

    2
  • undefined phenomlab marked this topic as a regular topic on 16 Jan 2023, 00:17
Log in to reply

2/2

9 Jan 2023, 11:05

Related Topics
  • undefined

    Mongodb or Redis

    General
    2 9 Aug 2024, 02:15
    9 Aug 2024, 02:15
    11 Votes
    29 Posts
    689 Views
    undefined
    @Madchatthew still a great catch.
  • undefined

    Is my Mongodb installation correct?

    Solved General
    2 23 Mar 2024, 13:21
    23 Mar 2024, 13:21
    4
    13 Votes
    27 Posts
    3k Views
    undefined
    [image: 1711303116154-yuuuuu.png]
  • undefined

    mongodb backup problem

    Moved Configure
    2 2 Feb 2024, 09:52
    2 Feb 2024, 09:52
    1
    1 Votes
    3 Posts
    279 Views
    undefined
    You might want to also review this post https://sudonix.org/topic/389/mongodb-backup-script
  • undefined

    mongodb replica set

    Configure
    2 22 Nov 2023, 08:25
    22 Nov 2023, 08:25
    2 Votes
    11 Posts
    578 Views
    undefined
    @veronikya said in mongodb replica set: The host’s local dns resolution is not configured. The problem of the host’s hosts being unable to be resolved in docker has been solved. Surprisingly Solution: Edit the /etc/resovel.conf file Add 127.0.0.53 One immediate issue I can think of here is that editing resolv.conf directly is no longer supported and not recommended (because the changes do not survive a reboot) - unless you install the resolvconf package?
  • cagatayundefined

    Category For User

    Solved Configure
    2 13 Nov 2023, 05:14
    13 Nov 2023, 05:14
    12 Votes
    11 Posts
    595 Views
    undefined
    3.5.1 has now been released. I’ve just deployed it, so safe to do so!
  • undefined

    Nodebb: failed to restore a mongo dump

    Solved Configure
    2 7 Jan 2023, 22:40
    7 Jan 2023, 22:40
    1 Votes
    2 Posts
    241 Views
    undefined
    @phenomlab In fact I specified the sub rep and not the rep DON’T DO THIS: nodebb@nodebbpwclonedb:~/nodebb$ sudo mongorestore --username admin --password XXXXXXXXXXXXXX --nsInclude nodebb.objects --drop /home/nodebb/nodebb_DB_20230107/nodebb/ BUT THIS : nodebb@nodebbpwclonedb:~/nodebb$ sudo mongorestore --username admin --password XXXXXXXXXXXXXX --nsInclude nodebb.objects --drop /home/nodebb/nodebb_DB_20230107/
  • undefined

    NodeBB Global Tchat : Forum with many users performance issues

    Solved Configure
    2 6 Jan 2023, 14:23
    6 Jan 2023, 14:23
    1
    5 Votes
    13 Posts
    731 Views
    undefined
    'use strict'; const winston = require('winston'); const user = require('../user'); const notifications = require('../notifications'); const sockets = require('../socket.io'); const plugins = require('../plugins'); const meta = require('../meta'); module.exports = function (Messaging) { Messaging.notifyQueue = {}; // Only used to notify a user of a new chat message, see Messaging.notifyUser Messaging.notifyUsersInRoom = async (fromUid, roomId, messageObj) => { let uids = await Messaging.getUidsInRoom(roomId, 0, -1); uids = await user.blocks.filterUids(fromUid, uids); let data = { roomId: roomId, fromUid: fromUid, message: messageObj, uids: uids, }; data = await plugins.hooks.fire('filter:messaging.notify', data); if (!data || !data.uids || !data.uids.length) { return; } uids = data.uids; uids.forEach((uid) => { data.self = parseInt(uid, 10) === parseInt(fromUid, 10) ? 1 : 0; Messaging.pushUnreadCount(uid); sockets.in(`uid_${uid}`).emit('event:chats.receive', data); }); if (messageObj.system) { return; } // Delayed notifications let queueObj = Messaging.notifyQueue[`${fromUid}:${roomId}`]; if (queueObj) { queueObj.message.content += `\n${messageObj.content}`; clearTimeout(queueObj.timeout); } else { queueObj = { message: messageObj, }; Messaging.notifyQueue[`${fromUid}:${roomId}`] = queueObj; } queueObj.timeout = setTimeout(async () => { try { await sendNotifications(fromUid, uids, roomId, queueObj.message); } catch (err) { winston.error(`[messaging/notifications] Unabled to send notification\n${err.stack}`); } }, meta.config.notificationSendDelay * 1000); }; async function sendNotifications(fromuid, uids, roomId, messageObj) { const isOnline = await user.isOnline(uids); uids = uids.filter((uid, index) => !isOnline[index] && parseInt(fromuid, 10) !== parseInt(uid, 10)); if (!uids.length) { return; } if (roomId != 11) { // 5 Is the ID of the ID of the global chat room. Messaging.getUidsInRoom(roomId, 0, -1); // Proceed as normal. } else { user.getUidsFromSet('users:online', 0, -1); // Only notify online users. } const { displayname } = messageObj.fromUser; const isGroupChat = await Messaging.isGroupChat(roomId); const notification = await notifications.create({ type: isGroupChat ? 'new-group-chat' : 'new-chat', subject: `[[email:notif.chat.subject, ${displayname}]]`, bodyShort: `[[notifications:new_message_from, ${displayname}]]`, bodyLong: messageObj.content, nid: `chat_${fromuid}_${roomId}`, from: fromuid, path: `/chats/${messageObj.roomId}`, }); delete Messaging.notifyQueue[`${fromuid}:${roomId}`]; notifications.push(notification, uids); } };
  • undefined

    mongorestore "E11000 duplicate key error collection"

    Solved Configure
    2 21 Mar 2022, 16:18
    21 Mar 2022, 16:18
    1 Votes
    1 Posts
    864 Views
    No one has replied