Hello, I am opening a new topic for this since I think my questions in a Previous topic about this have been looked over since I originally marked it as resolved, but it isn’t. case: I migrated to discourse, and members of the old forum all have TL1, which they find not fair, so I wanted to bump t…

Maybe: users = User.where('admin = false') users.update_all(trust_level: 2)

[immagine] Canapin: users = User.where(‘admin = false’) users.update_all(trust_level: 2) This query will change all moderators to trust level 2 as well. I’m not sure @Queth really wants to do that.

There is an Howto to bulk move all the users from a lower TL to an higher level (and viceversa) [immagine] Modify trust level for all users Self-Hosting Here’s an example of a bulk operation to set the trust level to 2 for all users currently at trust level 0 o…

Thank you so much for your fast replies! @Canapin , @neounix I don’t mind changing mods to tl2 temporarily, I can set their TL manually afterwards I think. I don’t think it would impact mod abilities? Would it? @dax Thank you! We are talking about 20k users, 10k are tl1 after migration, and the o…

[immagine] Queth: Would there be a way to include some kind of registration date criteria? Eg all TL1 who registered before March 17 2020? Yes @Queth Would you like me to post a copy of the structure of the users table so you can see all the different entries there? Update: Here is it @Qu…

Thank you @neounix ! Would it be possible to help me with the correct query? Because I don’t know how to do that… probably include somewhere Where user created at < [march 17 2020 but then formatted correctly]

[immagine] Queth: Where user created at < [march 17 2020 but then formatted correctly] I would love to; but some things are easier (and better) done by you doing a bit of your own homework. You have all the pieces of the puzzle, so my advise is to spend a bit of time and learn to write an SQL…

Thanks :slight_smile: Well I do have basic basic knowledge but writing queries from scratch is still something I rather copy paste from a trusted source instead of trying to devise my own. But thank you indeed for the building blocks!

[immagine] Queth: Thanks :slight_smile: Well I do have basic basic knowledge but writing queries from scratch is still something I rather copy paste from a trusted source instead of trying to devise my own. But thank you indeed for the building blocks! It’s always a good idea to SELECT firs…

Comando Rails per promuovere in massa gli utenti a TL2?

Sviluppatore

dax (Daniela) 25 Aprile 2020, 9:43am 4

C’è una guida su come spostare in blocco tutti gli utenti da un livello di fiducia inferiore a uno superiore (e viceversa)

Argomento		Risposte	Visualizzazioni
Promoting users to TL2 when joining a group - retrospectively? Support	11	717	Febbraio 26, 2023
How do I promote all users to trust level 1? Support trust-levels	6	1677	Marzo 19, 2020
Mass promotion to TL2 via manual command? Support	3	724	Aprile 20, 2020
User isn't promoted to TL2 Support	13	1307	Dicembre 15, 2020
Self Hosted Reassess trust levels Support	1	82	Settembre 18, 2024

Comando Rails per promuovere in massa gli utenti a TL2?

Argomenti correlati