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

1/2

8 Jan 2023, 19:58

Related Topics
  • Sampo2910undefined

    Mongo Completely Broken.

    General mongodb
    2 30 Dec 2024, 16:46
    30 Dec 2024, 16:46
    3 Votes
    20 Posts
    581 Views
    undefined
    @Sampo2910 said in Mongo Completely Broken.: I can see you cringing Yes, that does make me slightly uncomfortable but OK.
  • Madchatthewundefined

    Mongodb or Redis

    General database mongodb redis
    2 9 Aug 2024, 02:15
    9 Aug 2024, 02:15
    11 Votes
    29 Posts
    1k Views
    undefined
    @Madchatthew still a great catch.
  • ahmedundefined

    Is my Mongodb installation correct?

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

    mongodb backup problem

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

    mongodb replica set

    Configure mongodb docker ansible
    2 22 Nov 2023, 08:25
    22 Nov 2023, 08:25
    2 Votes
    11 Posts
    687 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 category
    2 13 Nov 2023, 05:14
    13 Nov 2023, 05:14
    12 Votes
    11 Posts
    676 Views
    undefined
    3.5.1 has now been released. I’ve just deployed it, so safe to do so!
  • undefined

    NodeBB Global Tchat : Forum with many users performance issues

    Solved Configure perf global chat
    2 6 Jan 2023, 14:23
    6 Jan 2023, 14:23
    1
    5 Votes
    13 Posts
    796 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); } };
  • Sampo2910undefined

    Mongodb Authorisation.

    Solved General mongodb
    2 2 Dec 2022, 16:44
    2 Dec 2022, 16:44
    2 Votes
    17 Posts
    997 Views
    undefined
    @Sampo2910 I just saw this on the NodeBB community site and it seems very much in line with the issue you are experiencing. Worth a look I think https://community.nodebb.org/topic/16826/does-nodebb-work-with-mongodb-6-0